时间: 2025-03-28 13:33:06,257 线程ID: 106 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 朱金鑫 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2025-03-28 13:33:06,288 线程ID: 106 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##4311e33322064b4e8332689a2d50ad61] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-03-28 13:37:00,889 线程ID: 111 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2025-03-01 0 <__data__> billdateend 2025-03-28 0 <__data__> chkisquery 0 0 <__customer__> userno NB002 0 <__customer__> customer_id 渠道编号 JM001 2 <__businessman__> userno NB002 0 <__goods__> userno NB002 0 <__goods__> brand 品牌 GUCCI 1 7 1 CheckDate 日期 A.CheckDate true 1 6 1 Manual_ID 手工单号 a.Manual_ID true 2 4 1 CheckID 核销单号 A.CheckID true 3 12 1 Quantity 数量 SUM(A.Quantity) false 4 14 1 DiscountAmount 生意额 SUM(DiscountAmount) false 5 9 1 Name 营业员姓名 BM.Name true 6 时间: 2025-03-28 13:37:00,903 线程ID: 111 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##d2d2dfd7e9ad44dfb076099349a6b2cf] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-03-28 13:37:10,648 线程ID: 88 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2025-03-01 0 <__data__> billdateend 2025-03-28 0 <__data__> chkisquery 0 0 <__customer__> userno NB002 0 <__customer__> customer_id 渠道编号 JM001 2 <__businessman__> userno NB002 0 <__goods__> userno NB002 0 <__goods__> brand 品牌 GUCCI 1 7 1 CheckDate 日期 A.CheckDate true 1 4 1 CheckID 核销单号 A.CheckID true 3 12 1 Quantity 数量 SUM(A.Quantity) false 4 14 1 DiscountAmount 生意额 SUM(DiscountAmount) false 5 9 1 Name 营业员姓名 BM.Name true 6 时间: 2025-03-28 13:37:10,658 线程ID: 88 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##a66df48b8914440a800abd5d10a5eaee] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-03-28 13:39:54,185 线程ID: 172 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2025-03-01 0 <__data__> billdateend 2025-03-28 0 <__data__> chkisquery 0 0 <__customer__> userno NB002 0 <__customer__> customer_id 渠道编号 JM001 2 <__businessman__> userno NB002 0 <__goods__> userno NB002 0 <__goods__> brand 品牌 4 <__goods___x0024_brand_x0024_> ALEXANDER MCQUEEN <__goods___x0024_brand_x0024_> BALENCIAGA <__goods___x0024_brand_x0024_> BALLY <__goods___x0024_brand_x0024_> FERRAGAMO <__goods___x0024_brand_x0024_> HERON PRESTON <__goods___x0024_brand_x0024_> KENZO <__goods___x0024_brand_x0024_> LOEWE <__goods___x0024_brand_x0024_> MARCELO BURLON <__goods___x0024_brand_x0024_> McQ <__goods___x0024_brand_x0024_> OFF WHITE <__goods___x0024_brand_x0024_> OFF-WHITE <__goods___x0024_brand_x0024_> PALM ANGELS 7 1 CheckDate 日期 A.CheckDate true 1 4 1 CheckID 核销单号 A.CheckID true 3 12 1 Quantity 数量 SUM(A.Quantity) false 4 14 1 DiscountAmount 生意额 SUM(DiscountAmount) false 5 9 1 Name 营业员姓名 BM.Name true 6 时间: 2025-03-28 13:39:54,195 线程ID: 172 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##1c2fa88e94e14480a6c99a01ee2b1ca6] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-03-28 15:03:50,720 线程ID: 71 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2025-03-01 0 <__data__> billdateend 2025-03-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-28 15:03:50,735 线程ID: 71 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##d3f6eacf1b414621a165776c69ef90ff] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-03-28 20:18:26,681 线程ID: 75 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2025-03-01 0 <__data__> billdateend 2025-03-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-28 20:18:26,694 线程ID: 75 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##3cdae58551984825b7e1eb5d1d403307] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID