时间: 2024-12-12 09:36:01,556
线程ID: 64
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2024-12-01
0
<__data__>
billdateend
2024-12-11
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-12-12 09:36:01,580
线程ID: 64
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##4b88e43936574f839764661c8fcb3eef]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-12-12 11:27:14,276
线程ID: 84
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__businessman__>
userno
LT062
0
<__customer__>
userno
LT062
0
时间: 2024-12-12 11:27:14,284
线程ID: 84
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##c4a5a6e52069423291a3de6620577041]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-12-12 14:21:02,085
线程ID: 159
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
name
熊冰冰
2
<__data__>
CustomerID
5
<__businessman__>
userno
LT062
0
<__customer__>
userno
LT062
0
时间: 2024-12-12 14:21:02,092
线程ID: 159
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##102964ee83f34f3eb6c22cd7e3de7bbf]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-12-12 14:21:17,719
线程ID: 147
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
name
李莹莹
2
<__data__>
CustomerID
5
<__businessman__>
userno
LT062
0
<__customer__>
userno
LT062
0
时间: 2024-12-12 14:21:17,725
线程ID: 147
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##b6ac673da3224aee821999b22ea61624]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-12-12 14:22:00,474
线程ID: 66
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
name
邢金澄
2
<__data__>
CustomerID
5
<__businessman__>
userno
LT062
0
<__customer__>
userno
LT062
0
时间: 2024-12-12 14:22:00,481
线程ID: 66
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##dfdbf4d1a7e84fea9fbb09c78c105c90]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-12-12 14:24:29,251
线程ID: 212
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
name
测试
2
<__data__>
CustomerID
5
<__businessman__>
userno
LT062
0
<__customer__>
userno
LT062
0
时间: 2024-12-12 14:24:29,258
线程ID: 212
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##c7c5e5cf0cea41f88dcf1f9d3bc783a2]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-12-12 14:26:44,822
线程ID: 198
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__data__>
abbrev
青岛
2
<__businessman__>
userno
LT062
0
<__customer__>
userno
LT062
0
时间: 2024-12-12 14:26:44,830
线程ID: 198
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##c7da5e50e070485dbcdeddc88cedbfc0]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-12-12 14:26:51,677
线程ID: 197
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__data__>
abbrev
青岛BUR
2
<__businessman__>
userno
LT062
0
<__customer__>
userno
LT062
0
时间: 2024-12-12 14:26:51,683
线程ID: 197
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##d17cc7869d034195a9a672254fe03b2d]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-12-12 14:26:52,077
线程ID: 184
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__data__>
abbrev
青岛BUR
2
<__businessman__>
userno
LT062
0
<__customer__>
userno
LT062
0
时间: 2024-12-12 14:26:52,084
线程ID: 184
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##1b8ae88ffc8a41f5aa61a1390f6d7fc9]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-12-12 14:46:23,254
线程ID: 126
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
name
尹慧敏
2
<__data__>
CustomerID
5
<__businessman__>
userno
LT062
0
<__customer__>
userno
LT062
0
时间: 2024-12-12 14:46:23,262
线程ID: 126
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##08562678029b48eebf27e8d594d1dd3e]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-12-12 15:03:46,548
线程ID: 121
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__businessman__>
userno
LT062
0
<__customer__>
userno
LT062
0
时间: 2024-12-12 15:03:46,554
线程ID: 121
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##9253da985daf4b5997e2204f14b682cc]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-12-12 15:05:03,322
线程ID: 121
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
name
杨燕
2
<__data__>
CustomerID
5
<__businessman__>
userno
LT062
0
<__customer__>
userno
LT062
0
时间: 2024-12-12 15:05:03,329
线程ID: 121
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##728890cbc0d14167bd37732be89654ab]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-12-12 15:05:07,613
线程ID: 207
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
name
杨燕青
2
<__data__>
CustomerID
5
<__businessman__>
userno
LT062
0
<__customer__>
userno
LT062
0
时间: 2024-12-12 15:05:07,620
线程ID: 207
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##6501529863544bd59f597dd5748f8b5c]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2024-12-12 17:27:06,508
线程ID: 164
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2024-12-01
0
<__data__>
billdateend
2024-12-12
0
<__data__>
chkisquery
0
0
<__customer__>
userno
LT091
0
<__businessman__>
userno
LT091
0
<__goods__>
userno
LT091
0
8
1
BusiManID
营业员编号
A.BusiManID
true
1
9
1
Name
营业员姓名
BM.Name
true
2
14
1
Quantity
数量
SUM(A.Quantity)
false
3
16
1
DiscountAmount
生意额
SUM(DiscountAmount)
false
4
17
1
Discount
折扣
CASE WHEN ISNULL(SUM(A.CustDpAmount), 0) <> 0 THEN CAST(SUM(DiscountAmount) / SUM(A.CustDpAmount) AS NUMERIC(18,2)) ELSE 0 END
false
5
时间: 2024-12-12 17:27:06,515
线程ID: 164
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##23845c01ca314be5a9e876944bd885f6]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID