时间: 2024-11-28 09:21:45,027
线程ID: 144
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2024-11-01
0
<__data__>
billdateend
2024-11-27
0
<__data__>
chkisquery
0
0
<__customer__>
userno
LT031
0
<__customer__>
customer_id
渠道编号
4
<__customer___x0024_customer_id_x0024_>
JN001
济南集合
<__customer___x0024_customer_id_x0024_>
QD001BUR
青岛BUR
<__customer___x0024_customer_id_x0024_>
YC01BUR
银川BUR
<__customer___x0024_customer_id_x0024_>
Z029XA1
临潼BUR店
<__customer___x0024_customer_id_x0024_>
Z029XA2
咸阳机场店
<__customer___x0024_customer_id_x0024_>
Z029XA3
咸阳ARM店
<__customer___x0024_customer_id_x0024_>
Z029XA5
临潼阿玛尼
<__businessman__>
userno
LT031
0
<__goods__>
userno
LT031
0
9
1
Name
营业员姓名
BM.Name
true
1
14
1
Quantity
数量
SUM(A.Quantity)
false
2
16
1
DiscountAmount
生意额
SUM(DiscountAmount)
false
3
3
1
Abbrev
渠道简称
CT.Abbrev
true
4
时间: 2024-11-28 09:21:45,039
线程ID: 144
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##7800df8a77604afe97c35c3fd6cf3c3a]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-11-28 13:21:15,719
线程ID: 169
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2024-11-01
0
<__data__>
billdateend
2024-11-28
0
<__data__>
chkisquery
0
0
<__customer__>
userno
NB002
0
<__customer__>
customer_id
渠道编号
JM001
2
<__businessman__>
userno
NB002
0
<__businessman__>
BusinessManCustomer
渠道
5
<__businessman__>
buisnessmanid
营业员编号
4
<__businessmancustomer__>
userno
NB002
0
<__businessman___x0024_buisnessmanid_x0024_>
LTB0167
陈静
<__businessman___x0024_buisnessmanid_x0024_>
LTB0202
高雅琴
<__businessman___x0024_buisnessmanid_x0024_>
LTB0212
陶海英
<__businessman___x0024_buisnessmanid_x0024_>
LTB0408
李晓洁
<__businessman___x0024_buisnessmanid_x0024_>
LTB0409
尤英杰
<__businessman___x0024_buisnessmanid_x0024_>
LTB0432
朱燕
<__businessman___x0024_buisnessmanid_x0024_>
LTB0445
张锐
<__goods__>
userno
NB002
0
4
1
CheckID
核销单号
A.CheckID
true
1
6
1
Manual_ID
手工单号
a.Manual_ID
true
2
7
1
CheckDate
日期
A.CheckDate
true
3
9
1
Name
营业员姓名
BM.Name
true
4
12
1
Quantity
数量
SUM(A.Quantity)
false
5
14
1
DiscountAmount
生意额
SUM(DiscountAmount)
false
6
时间: 2024-11-28 13:21:15,739
线程ID: 169
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##67bda227983c455a847a5276df9f1429]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
AND A.BuisnessManID IN ('LTB0167', 'LTB0202', 'LTB0212', 'LTB0408', 'LTB0409', 'LTB0432', 'LTB0445')
AND EXISTS (SELECT 1 FROM [##1e7e8e58ad2848de9178491991377467] WHERE Customer_ID = A.CustomerID)
) A
ORDER BY BuisnessManID
时间: 2024-11-28 13:21:25,133
线程ID: 135
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2024-11-01
0
<__data__>
billdateend
2024-11-28
0
<__data__>
chkisquery
0
0
<__customer__>
userno
NB002
0
<__customer__>
customer_id
渠道编号
JM001
2
<__businessman__>
userno
NB002
0
<__businessman__>
BusinessManCustomer
渠道
5
<__businessman__>
buisnessmanid
营业员编号
4
<__businessmancustomer__>
userno
NB002
0
<__businessman___x0024_buisnessmanid_x0024_>
LTB0167
陈静
<__businessman___x0024_buisnessmanid_x0024_>
LTB0202
高雅琴
<__businessman___x0024_buisnessmanid_x0024_>
LTB0212
陶海英
<__businessman___x0024_buisnessmanid_x0024_>
LTB0408
李晓洁
<__businessman___x0024_buisnessmanid_x0024_>
LTB0409
尤英杰
<__businessman___x0024_buisnessmanid_x0024_>
LTB0432
朱燕
<__businessman___x0024_buisnessmanid_x0024_>
LTB0445
张锐
<__goods__>
userno
NB002
0
4
1
CheckID
核销单号
A.CheckID
true
1
7
1
CheckDate
日期
A.CheckDate
true
3
9
1
Name
营业员姓名
BM.Name
true
4
12
1
Quantity
数量
SUM(A.Quantity)
false
5
14
1
DiscountAmount
生意额
SUM(DiscountAmount)
false
6
时间: 2024-11-28 13:21:25,152
线程ID: 135
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##1164b4ed384b4f19b10a4f86fac550cc]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
AND A.BuisnessManID IN ('LTB0167', 'LTB0202', 'LTB0212', 'LTB0408', 'LTB0409', 'LTB0432', 'LTB0445')
AND EXISTS (SELECT 1 FROM [##a173ce2ead3748afb97c1dc34922c268] WHERE Customer_ID = A.CustomerID)
) A
ORDER BY BuisnessManID
时间: 2024-11-28 13:24:42,362
线程ID: 135
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2024-11-01
0
<__data__>
billdateend
2024-11-28
0
<__data__>
chkisquery
0
0
<__customer__>
userno
NB002
0
<__customer__>
customer_id
渠道编号
JM001
2
<__businessman__>
userno
NB002
0
<__goods__>
userno
NB002
0
7
1
CheckDate
日期
A.CheckDate
true
1
4
1
CheckID
核销单号
A.CheckID
true
2
12
1
Quantity
数量
SUM(A.Quantity)
false
3
14
1
DiscountAmount
生意额
SUM(DiscountAmount)
false
4
9
1
Name
营业员姓名
BM.Name
true
5
时间: 2024-11-28 13:24:42,371
线程ID: 135
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##66c69ee94829466c895834b2d648a835]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-11-28 13:27:30,936
线程ID: 47
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2024-11-01
0
<__data__>
billdateend
2024-11-28
0
<__data__>
chkisquery
0
0
<__customer__>
userno
NB002
0
<__customer__>
customer_id
渠道编号
JM001
2
<__businessman__>
userno
NB002
0
<__goods__>
userno
NB002
0
<__goods__>
brand
品牌
4
<__goods___x0024_brand_x0024_>
ALEXANDER MCQUEEN
<__goods___x0024_brand_x0024_>
BALENCIAGA
<__goods___x0024_brand_x0024_>
BALLY
<__goods___x0024_brand_x0024_>
HERON PRESTON
<__goods___x0024_brand_x0024_>
KENZO
<__goods___x0024_brand_x0024_>
MARCELO BURLON
<__goods___x0024_brand_x0024_>
OFF WHITE
<__goods___x0024_brand_x0024_>
OFF-WHITE
<__goods___x0024_brand_x0024_>
PALM ANGELS
7
1
CheckDate
日期
A.CheckDate
true
1
4
1
CheckID
核销单号
A.CheckID
true
2
12
1
Quantity
数量
SUM(A.Quantity)
false
3
14
1
DiscountAmount
生意额
SUM(DiscountAmount)
false
4
9
1
Name
营业员姓名
BM.Name
true
5
时间: 2024-11-28 13:27:30,943
线程ID: 47
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##684b64551b3744468084e3c6f4395bbe]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-11-28 13:29:53,014
线程ID: 95
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2024-11-01
0
<__data__>
billdateend
2024-11-28
0
<__data__>
chkisquery
0
0
<__customer__>
userno
NB002
0
<__customer__>
customer_id
渠道编号
JM001
2
<__businessman__>
userno
NB002
0
<__goods__>
userno
NB002
0
<__goods__>
brand
品牌
GUCCI
1
7
1
CheckDate
日期
A.CheckDate
true
1
4
1
CheckID
核销单号
A.CheckID
true
2
12
1
Quantity
数量
SUM(A.Quantity)
false
3
14
1
DiscountAmount
生意额
SUM(DiscountAmount)
false
4
9
1
Name
营业员姓名
BM.Name
true
5
时间: 2024-11-28 13:29:53,021
线程ID: 95
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##1a5db7b846754bf19d2692acce32a946]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-11-28 15:24:21,444
线程ID: 109
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
[渠道编号:JM003]
5
<__businessman__>
userno
NB001
0
<__customer__>
userno
NB001
0
<__customer__>
customer_id
渠道编号
JM003
1
时间: 2024-11-28 15:24:21,470
线程ID: 109
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##ddd6d3e9c197443a8165fdb6ec1b2a3f]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-11-28 15:24:41,449
线程ID: 49
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
[渠道编号:JM003]
5
<__businessman__>
userno
NB001
0
<__customer__>
userno
NB001
0
<__customer__>
customer_id
渠道编号
JM003
1
时间: 2024-11-28 15:24:41,456
线程ID: 49
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##2939b7ad21384988a4792a44f8177766]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-11-28 15:24:55,441
线程ID: 91
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
[渠道编号:JM003]
5
<__businessman__>
userno
NB001
0
<__customer__>
userno
NB001
0
<__customer__>
customer_id
渠道编号
JM003
1
时间: 2024-11-28 15:24:55,448
线程ID: 91
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##e7e2364936e049af8c1088a28b790627]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-11-28 15:25:08,129
线程ID: 91
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
[渠道编号:JM003]
5
<__businessman__>
userno
NB001
0
<__customer__>
userno
NB001
0
<__customer__>
customer_id
渠道编号
JM003
1
时间: 2024-11-28 15:25:08,135
线程ID: 91
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##98d8381226fd4f7ebdfef489f3572a95]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-11-28 16:37:44,071
线程ID: 110
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__businessman__>
userno
LT017
0
<__customer__>
userno
LT017
0
时间: 2024-11-28 16:37:44,079
线程ID: 110
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##2406c9f525a04793b8a27f6ab8eccbb1]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID