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