时间: 2024-12-12 09:36:01,556 线程ID: 64 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2024-12-01 0 <__data__> billdateend 2024-12-11 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 时间: 2024-12-12 09:36:01,580 线程ID: 64 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##4b88e43936574f839764661c8fcb3eef] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-12-12 11:27:14,276 线程ID: 84 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2024-12-12 11:27:14,284 线程ID: 84 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##c4a5a6e52069423291a3de6620577041] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-12-12 14:21:02,085 线程ID: 159 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 熊冰冰 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2024-12-12 14:21:02,092 线程ID: 159 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##102964ee83f34f3eb6c22cd7e3de7bbf] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-12-12 14:21:17,719 线程ID: 147 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 李莹莹 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2024-12-12 14:21:17,725 线程ID: 147 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##b6ac673da3224aee821999b22ea61624] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-12-12 14:22:00,474 线程ID: 66 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 邢金澄 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2024-12-12 14:22:00,481 线程ID: 66 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##dfdbf4d1a7e84fea9fbb09c78c105c90] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-12-12 14:24:29,251 线程ID: 212 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 测试 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2024-12-12 14:24:29,258 线程ID: 212 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##c7c5e5cf0cea41f88dcf1f9d3bc783a2] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-12-12 14:26:44,822 线程ID: 198 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> CustomerID 5 <__data__> abbrev 青岛 2 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2024-12-12 14:26:44,830 线程ID: 198 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##c7da5e50e070485dbcdeddc88cedbfc0] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-12-12 14:26:51,677 线程ID: 197 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> CustomerID 5 <__data__> abbrev 青岛BUR 2 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2024-12-12 14:26:51,683 线程ID: 197 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##d17cc7869d034195a9a672254fe03b2d] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-12-12 14:26:52,077 线程ID: 184 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> CustomerID 5 <__data__> abbrev 青岛BUR 2 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2024-12-12 14:26:52,084 线程ID: 184 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##1b8ae88ffc8a41f5aa61a1390f6d7fc9] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-12-12 14:46:23,254 线程ID: 126 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 尹慧敏 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2024-12-12 14:46:23,262 线程ID: 126 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##08562678029b48eebf27e8d594d1dd3e] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-12-12 15:03:46,548 线程ID: 121 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2024-12-12 15:03:46,554 线程ID: 121 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##9253da985daf4b5997e2204f14b682cc] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-12-12 15:05:03,322 线程ID: 121 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 杨燕 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2024-12-12 15:05:03,329 线程ID: 121 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##728890cbc0d14167bd37732be89654ab] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-12-12 15:05:07,613 线程ID: 207 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 杨燕青 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2024-12-12 15:05:07,620 线程ID: 207 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##6501529863544bd59f597dd5748f8b5c] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-12-12 17:27:06,508 线程ID: 164 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2024-12-01 0 <__data__> billdateend 2024-12-12 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 时间: 2024-12-12 17:27:06,515 线程ID: 164 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##23845c01ca314be5a9e876944bd885f6] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID