时间: 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