时间: 2025-09-24 11:02:23,086
线程ID: 51
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__businessman__>
userno
LT017
0
<__customer__>
userno
LT017
0
时间: 2025-09-24 11:02:23,109
线程ID: 51
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##5f46f3744091455d8cfac483d06e852d]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-09-24 11:10:36,480
线程ID: 9
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__businessman__>
userno
LT017
0
<__customer__>
userno
LT017
0
时间: 2025-09-24 11:10:36,493
线程ID: 9
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##09de1cfd89c045fa837528d474636249]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-09-24 11:11:26,648
线程ID: 9
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__businessman__>
userno
LT017
0
<__customer__>
userno
LT017
0
时间: 2025-09-24 11:11:26,657
线程ID: 9
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##74b5204e0c234fe98ae98d9b8e801316]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-09-24 11:11:56,762
线程ID: 88
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__businessman__>
userno
LT017
0
<__customer__>
userno
LT017
0
时间: 2025-09-24 11:11:56,772
线程ID: 88
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##4284c0f87079490eb8dd52fa59aee129]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-09-24 11:12:31,103
线程ID: 24
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__businessman__>
userno
LT017
0
<__customer__>
userno
LT017
0
时间: 2025-09-24 11:12:31,160
线程ID: 24
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##23b193d398c549688c038a73213afce1]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-09-24 11:12:54,165
线程ID: 86
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__businessman__>
userno
LT017
0
<__customer__>
userno
LT017
0
时间: 2025-09-24 11:12:54,186
线程ID: 86
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##599fec19fd9a4f9a95ec040fd8028f8e]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-09-24 13:01:48,102
线程ID: 14
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2025-08-01
0
<__data__>
billdateend
2025-08-20
0
<__data__>
chkisquery
0
0
<__customer__>
userno
LT091
0
<__businessman__>
userno
LT091
0
<__goods__>
userno
LT091
0
9
1
BusiManID
营业员编号
A.BusiManID
true
1
10
1
Name
营业员姓名
BM.Name
true
2
15
1
Quantity
数量
SUM(A.Quantity)
false
3
17
1
DiscountAmount
生意额
SUM(DiscountAmount)
false
4
18
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-09-24 13:01:48,113
线程ID: 14
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##5f1ef12e259d4158b592c07f1dd4d9a8]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-09-24 13:30:04,949
线程ID: 110
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
[渠道编号:JN001]
5
<__businessman__>
userno
LT017
0
<__customer__>
userno
LT017
0
<__customer__>
customer_id
渠道编号
JN001
1
时间: 2025-09-24 13:30:04,965
线程ID: 110
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##d1352030b13d4552b9c91c11860a5d55]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-09-24 13:30:34,538
线程ID: 168
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
[渠道编号:JN001]
5
<__businessman__>
userno
LT017
0
<__customer__>
userno
LT017
0
<__customer__>
customer_id
渠道编号
JN001
1
时间: 2025-09-24 13:30:34,559
线程ID: 168
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##fe216318c6134f369fbd0e4a2a0ac723]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-09-24 15:12:57,087
线程ID: 130
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
Customer_ID
5
<__data__>
BuisnessManID
5
<__data__>
Goods_No
5
<__data__>
billdatebegin
2025-08-07
0
<__data__>
billdateend
2025-09-24
0
<__data__>
chkisquery
0
0
<__customer__>
userno
LT091
0
<__businessman__>
userno
LT091
0
<__goods__>
userno
LT091
0
9
1
BusiManID
营业员编号
A.BusiManID
true
1
10
1
Name
营业员姓名
BM.Name
true
2
15
1
Quantity
数量
SUM(A.Quantity)
false
3
17
1
DiscountAmount
生意额
SUM(DiscountAmount)
false
4
18
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
8
1
CheckDate
日期
A.CheckDate
true
6
时间: 2025-09-24 15:12:57,098
线程ID: 130
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##00c3b122189d4646afbe9be1fdb30ffc]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-09-24 15:22:50,754
线程ID: 163
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__businessman__>
userno
LT017
0
<__businessman__>
buisnessmanid
营业员编号
LTB0658
2
<__customer__>
userno
LT017
0
时间: 2025-09-24 15:22:50,761
线程ID: 163
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##53c0d347cf3948f0a5dc3f24ff88adec]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
AND A.BuisnessManID = @buisnessmanid
) A
ORDER BY BuisnessManID
时间: 2025-09-24 15:22:52,217
线程ID: 102
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__businessman__>
userno
LT017
0
<__businessman__>
buisnessmanid
营业员编号
LTB0658
2
<__customer__>
userno
LT017
0
时间: 2025-09-24 15:22:52,226
线程ID: 102
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##67f6a690b17f45668e3a88662c035580]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
AND A.BuisnessManID = @buisnessmanid
) A
ORDER BY BuisnessManID
时间: 2025-09-24 15:22:57,112
线程ID: 146
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__businessman__>
userno
LT017
0
<__businessman__>
buisnessmanid
营业员编号
LTB0658
2
<__customer__>
userno
LT017
0
时间: 2025-09-24 15:22:57,132
线程ID: 146
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##e3b57d9a97514e0f96564b494a7332b2]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
AND A.BuisnessManID = @buisnessmanid
) A
ORDER BY BuisnessManID
时间: 2025-09-24 15:23:06,381
线程ID: 173
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__businessman__>
userno
LT017
0
<__businessman__>
buisnessmanid
营业员编号
LTB0658
2
<__customer__>
userno
LT017
0
时间: 2025-09-24 15:23:06,388
线程ID: 173
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##5a2ed961e2394f9b8657e27792a545d9]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
AND A.BuisnessManID = @buisnessmanid
) A
ORDER BY BuisnessManID
时间: 2025-09-24 15:23:15,784
线程ID: 173
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__businessman__>
userno
LT017
0
<__businessman__>
buisnessmanid
营业员编号
LTB0657
2
<__customer__>
userno
LT017
0
时间: 2025-09-24 15:23:15,791
线程ID: 173
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##c3cce711cf0846e8bd99c06ab62099a5]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
AND A.BuisnessManID = @buisnessmanid
) A
ORDER BY BuisnessManID
时间: 2025-09-24 15:23:21,782
线程ID: 173
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__businessman__>
userno
LT017
0
<__businessman__>
buisnessmanid
营业员编号
LTB0658
2
<__customer__>
userno
LT017
0
时间: 2025-09-24 15:23:21,794
线程ID: 173
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##09731e44da7e4d51b7f3d4be61cad698]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
AND A.BuisnessManID = @buisnessmanid
) A
ORDER BY BuisnessManID
时间: 2025-09-24 16:56:52,495
线程ID: 187
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
[渠道编号:JN001]
5
<__businessman__>
userno
LT017
0
<__customer__>
userno
LT017
0
<__customer__>
customer_id
渠道编号
JN001
1
时间: 2025-09-24 16:56:52,507
线程ID: 187
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##4187e15322474336be2a81b4bf5aade9]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID