时间: 2025-03-02 11:28:22,808
线程ID: 83
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2025-02-01
0
<__data__>
billdateend
2025-02-28
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
时间: 2025-03-02 11:28:22,836
线程ID: 83
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##957840e03e644b9f9fefdc70951dd04a]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-03-02 11:30:00,005
线程ID: 78
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2025-01-01
0
<__data__>
billdateend
2025-01-31
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
时间: 2025-03-02 11:30:00,014
线程ID: 78
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##996cdd0716b04ad18286347d4d4ab207]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-03-02 11:30:19,231
线程ID: 139
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2025-01-01
0
<__data__>
billdateend
2025-02-28
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
时间: 2025-03-02 11:30:19,242
线程ID: 139
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##02571f966d6e47459e18217ef4c336be]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-03-02 11:30:55,192
线程ID: 83
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2025-01-01
0
<__data__>
billdateend
2025-02-28
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
时间: 2025-03-02 11:30:55,202
线程ID: 83
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##9a408b0724954841b684225484bedb75]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-03-02 12:23:46,333
线程ID: 14
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2025-02-01
0
<__data__>
billdateend
2025-02-28
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
时间: 2025-03-02 12:23:46,342
线程ID: 14
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##59c54588c05643b0aa8f8a287a7bcc4f]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-03-02 12:27:20,513
线程ID: 135
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2025-02-01
0
<__data__>
billdateend
2025-02-28
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
6
1
Manual_ID
手工单号
a.Manual_ID
true
6
时间: 2025-03-02 12:27:20,525
线程ID: 135
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##438b12c81edb404da2a2680dc7569783]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-03-02 12:31:40,606
线程ID: 178
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2025-02-01
0
<__data__>
billdateend
2025-02-28
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
6
1
Manual_ID
手工单号
a.Manual_ID
true
6
4
1
CheckID
核销单号
A.CheckID
true
7
时间: 2025-03-02 12:31:40,615
线程ID: 178
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##c9996595688245a29cd7bf7cf0b09d74]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-03-02 22:44:21,925
线程ID: 213
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2025-02-04
0
<__data__>
billdateend
2025-03-02
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
时间: 2025-03-02 22:44:21,935
线程ID: 213
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##07e4f9c9915b40dc906eb0b2df692bf1]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID