时间: 2025-02-07 09:10:50,411
线程ID: 8
日志级别: 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-06
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-02-07 09:10:50,439
线程ID: 8
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##5b0407f70fe64b61bc73f043df096965]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-02-07 09:12:29,832
线程ID: 98
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
buisnessmanid
LTB0593
1
时间: 2025-02-07 09:36:22,027
线程ID: 16
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__businessman__>
userno
LT017
0
<__customer__>
userno
LT017
0
时间: 2025-02-07 09:36:22,039
线程ID: 16
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##a21f31dc0d534fda8c645ddfa8aa7e49]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-02-07 11:48:50,641
线程ID: 207
日志级别: 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-02-07 11:48:50,652
线程ID: 207
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##23c3e83d066d4b7e8bf48fc47d42077a]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-02-07 11:48:58,845
线程ID: 208
日志级别: 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
7
1
CheckDate
日期
A.CheckDate
true
6
时间: 2025-02-07 11:48:58,853
线程ID: 208
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##9b07dc53e48c4e259df91e0fa08d7c27]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-02-07 14:11:02,283
线程ID: 186
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
name
张晶晶
2
<__data__>
CustomerID
5
<__businessman__>
userno
LT062
0
<__customer__>
userno
LT062
0
时间: 2025-02-07 14:11:02,295
线程ID: 186
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##2e9520ab07634391ba1da9feba886410]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-02-07 14:54:42,364
线程ID: 168
日志级别: 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
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-02-07 14:54:42,377
线程ID: 168
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##b9b8b4b731ca45bea517b8c39172c7da]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-02-07 15:52:03,106
线程ID: 187
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
CustomerID
5
<__businessman__>
userno
LT062
0
<__businessman__>
buisnessmanid
营业员编号
张晶晶
2
<__customer__>
userno
LT062
0
时间: 2025-02-07 15:52:03,114
线程ID: 187
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##2841dd43698c4e5dac0c1c330f055c4f]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
AND A.BuisnessManID = @buisnessmanid
) A
ORDER BY BuisnessManID
时间: 2025-02-07 15:52:05,690
线程ID: 144
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
name
张晶晶
2
<__data__>
CustomerID
5
<__businessman__>
userno
LT062
0
<__customer__>
userno
LT062
0
时间: 2025-02-07 15:52:05,702
线程ID: 144
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##59473790831d493bbe551cd0c38459ef]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-02-07 15:52:16,567
线程ID: 203
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
name
张晶晶
2
<__data__>
CustomerID
5
<__businessman__>
userno
LT062
0
<__customer__>
userno
LT062
0
时间: 2025-02-07 15:52:16,581
线程ID: 203
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##80c5b5b738cf4a0eb14cf2d125742514]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-02-07 15:52:27,547
线程ID: 66
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
name
芮琼芳
2
<__data__>
CustomerID
5
<__businessman__>
userno
LT062
0
<__customer__>
userno
LT062
0
时间: 2025-02-07 15:52:27,558
线程ID: 66
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##c799e51a886d49289ba374eedff4a4bf]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-02-07 15:52:35,772
线程ID: 200
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
name
芮琼芳
2
<__data__>
CustomerID
5
<__businessman__>
userno
LT062
0
<__customer__>
userno
LT062
0
时间: 2025-02-07 15:52:35,785
线程ID: 200
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##8655b65456184362b66e302a0a2f60c9]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID
时间: 2025-02-07 15:53:09,713
线程ID: 188
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息:
<__data__>
BuisnessManID
5
<__data__>
name
芮琼芳
2
<__data__>
CustomerID
5
<__businessman__>
userno
LT062
0
<__customer__>
userno
LT062
0
时间: 2025-02-07 15:53:09,723
线程ID: 188
日志级别: INFO
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##37fdf218b92342deaf1b89bc4be2aa56]
FROM (
SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
) A
ORDER BY BuisnessManID