时间: 2025-07-02 11:44:15,344
线程ID: 15
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2025-06-01
0
<__data__>
billdateend
2025-06-30
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-07-02 11:44:15,376
线程ID: 15
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##28dbecc098a34c4f8a37b504b3e5ad78]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-07-02 11:44:23,806
线程ID: 28
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2025-06-01
0
<__data__>
billdateend
2025-06-30
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
7
1
CheckDate
日期
A.CheckDate
true
6
时间: 2025-07-02 11:44:23,817
线程ID: 28
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##e8f8b5064fed469da4dc734e453166fc]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-07-02 11:50:59,207
线程ID: 28
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2025-06-01
0
<__data__>
billdateend
2025-06-30
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-07-02 11:50:59,220
线程ID: 28
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##c410d5235fb041ee9fd039293603ad06]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-07-02 12:47:30,117
线程ID: 195
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2025-06-01
0
<__data__>
billdateend
2025-06-30
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
9
1
Name
营业员姓名
BM.Name
true
2
12
1
Quantity
数量
SUM(A.Quantity)
false
3
14
1
DiscountAmount
生意额
SUM(DiscountAmount)
false
4
11
1
PreAmount
原折让额
SUM(PreAmount)
false
5
时间: 2025-07-02 12:47:30,126
线程ID: 195
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##8d83fd6eb3634521b5e6fd73c9a9fe60]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-07-02 13:51:54,997
线程ID: 31
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2025-06-02
0
<__data__>
billdateend
2025-07-02
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
7
1
CheckDate
日期
A.CheckDate
true
6
时间: 2025-07-02 13:51:55,013
线程ID: 31
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##e0cd0037f5eb422dbc21010a030bfd92]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-07-02 13:54:49,400
线程ID: 210
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2025-06-01
0
<__data__>
billdateend
2025-06-30
0
<__data__>
chkisquery
0
0
<__customer__>
userno
LT069
0
<__businessman__>
userno
LT069
0
<__goods__>
userno
LT069
0
8
1
BusiManID
营业员编号
A.BusiManID
true
1
9
1
Name
营业员姓名
BM.Name
true
2
15
1
Scale
分配比例
CONVERT(NUMERIC(10,2), A.Scale)
true
3
16
1
DiscountAmount
生意额
SUM(DiscountAmount)
false
4
14
1
Quantity
数量
SUM(A.Quantity)
false
5
时间: 2025-07-02 13:54:49,413
线程ID: 210
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##9e14bbd83cd2494ebccf9f69a79799d6]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-07-02 13:55:11,599
线程ID: 195
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2025-06-01
0
<__data__>
billdateend
2025-06-30
0
<__data__>
chkisquery
0
0
<__customer__>
userno
LT069
0
<__businessman__>
userno
LT069
0
<__goods__>
userno
LT069
0
8
1
BusiManID
营业员编号
A.BusiManID
true
1
9
1
Name
营业员姓名
BM.Name
true
2
15
1
Scale
分配比例
CONVERT(NUMERIC(10,2), A.Scale)
true
3
16
1
DiscountAmount
生意额
SUM(DiscountAmount)
false
4
14
1
Quantity
数量
SUM(A.Quantity)
false
5
7
1
CheckDate
日期
A.CheckDate
true
6
时间: 2025-07-02 13:55:11,608
线程ID: 195
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##14c0eb29930d48c28d68a818f460e0e8]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-07-02 13:57:52,729
线程ID: 98
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2025-06-01
0
<__data__>
billdateend
2025-06-30
0
<__data__>
chkisquery
0
0
<__customer__>
userno
LT069
0
<__businessman__>
userno
LT069
0
<__goods__>
userno
LT069
0
8
1
BusiManID
营业员编号
A.BusiManID
true
1
9
1
Name
营业员姓名
BM.Name
true
2
16
1
DiscountAmount
生意额
SUM(DiscountAmount)
false
4
14
1
Quantity
数量
SUM(A.Quantity)
false
5
7
1
CheckDate
日期
A.CheckDate
true
6
时间: 2025-07-02 13:57:52,741
线程ID: 98
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##3cd6a947ebaf4f94bfa6b88a50a40f0d]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID