时间: 2025-08-01 08:37:45,514 线程ID: 60 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2025-07-01 0 <__data__> billdateend 2025-07-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 10 1 Name 营业员姓名 BM.Name true 1 15 1 Quantity 数量 SUM(A.Quantity) false 2 17 1 DiscountAmount 生意额 SUM(DiscountAmount) false 3 3 1 Abbrev 渠道简称 CT.Abbrev true 4 时间: 2025-08-01 08:37:45,540 线程ID: 60 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##f419e93a58784a3e9af19f79ad4e0e83] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-08-01 11:06:32,806 线程ID: 73 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2025-07-01 0 <__data__> billdateend 2025-07-31 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-08-01 11:06:32,821 线程ID: 73 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##1bd068ae9a9e4b89a9a88be6354d1d91] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-08-01 11:19:46,762 线程ID: 77 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2025-07-01 0 <__data__> billdateend 2025-07-31 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-08-01 11:19:46,778 线程ID: 77 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##9b75951fbc5341d2a5797ff04f70b394] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-08-01 11:24:39,990 线程ID: 43 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2025-07-01 0 <__data__> billdateend 2025-07-31 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-08-01 11:24:40,001 线程ID: 43 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##026311eac8e741c9ab01416cc625c545] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-08-01 13:26:56,789 线程ID: 244 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2025-07-01 0 <__data__> billdateend 2025-08-31 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 8 1 CheckDate 日期 A.CheckDate true 1 4 1 CheckID 核销单号 A.CheckID true 2 10 1 Name 营业员姓名 BM.Name true 3 13 1 Quantity 数量 SUM(A.Quantity) false 4 15 1 DiscountAmount 生意额 SUM(DiscountAmount) false 5 时间: 2025-08-01 13:26:56,800 线程ID: 244 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##69d814d2ea8d4369ab6f38721b6d527a] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-08-01 13:27:03,863 线程ID: 255 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2025-07-01 0 <__data__> billdateend 2025-07-31 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 8 1 CheckDate 日期 A.CheckDate true 1 4 1 CheckID 核销单号 A.CheckID true 2 10 1 Name 营业员姓名 BM.Name true 3 13 1 Quantity 数量 SUM(A.Quantity) false 4 15 1 DiscountAmount 生意额 SUM(DiscountAmount) false 5 时间: 2025-08-01 13:27:03,875 线程ID: 255 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##ed9c7438a4624713b500f1212038f8dc] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-08-01 13:29:27,528 线程ID: 123 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2025-07-01 0 <__data__> billdateend 2025-07-31 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_> MARCELO BURLON <__goods___x0024_brand_x0024_> OFF WHITE <__goods___x0024_brand_x0024_> OFF-WHITE <__goods___x0024_brand_x0024_> PALM ANGELS 8 1 CheckDate 日期 A.CheckDate true 1 4 1 CheckID 核销单号 A.CheckID true 2 10 1 Name 营业员姓名 BM.Name true 3 13 1 Quantity 数量 SUM(A.Quantity) false 4 15 1 DiscountAmount 生意额 SUM(DiscountAmount) false 5 时间: 2025-08-01 13:29:27,540 线程ID: 123 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##3fd8b781446345588ec433e1cab0dd8f] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-08-01 13:46:14,500 线程ID: 237 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 沈燕红 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2025-08-01 13:46:14,517 线程ID: 237 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##c7380bb12f3948f5aef6dbe8ff77b4f3] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-08-01 13:47:03,603 线程ID: 121 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 沈燕红 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2025-08-01 13:47:03,639 线程ID: 121 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##3188c678b37e43d08f02456197eabe30] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-08-01 13:47:21,557 线程ID: 47 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 潘诗嘉 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2025-08-01 13:47:21,572 线程ID: 47 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##df66bf0b706546e29f906d5f741f4134] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-08-01 13:47:32,001 线程ID: 260 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 潘诗嘉 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2025-08-01 13:47:32,020 线程ID: 260 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##6752fd10f0df4accac2b545b5372451a] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-08-01 13:47:39,679 线程ID: 257 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 朱雯雯 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2025-08-01 13:47:39,696 线程ID: 257 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##baa5c79b134e4cb09efeb7dcaec956f7] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-08-01 13:47:59,636 线程ID: 115 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 朱雯雯 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2025-08-01 13:47:59,644 线程ID: 115 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##99d7ff1132ac4db887748c8cf154cfce] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-08-01 13:48:30,478 线程ID: 122 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 沈燕红 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2025-08-01 13:48:30,489 线程ID: 122 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##b260ab91061f45e98516221d36637f0e] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-08-01 17:01:11,884 线程ID: 66 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2025-07-01 0 <__data__> billdateend 2025-07-31 0 <__data__> chkisquery 0 0 <__customer__> userno LT069 0 <__businessman__> userno LT069 0 <__goods__> userno LT069 0 9 1 BusiManID 营业员编号 A.BusiManID true 1 10 1 Name 营业员姓名 BM.Name true 2 16 1 Scale 分配比例 CONVERT(NUMERIC(10,2), A.Scale) true 3 17 1 DiscountAmount 生意额 SUM(DiscountAmount) false 4 15 1 Quantity 数量 SUM(A.Quantity) false 5 时间: 2025-08-01 17:01:11,896 线程ID: 66 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##b646c044bfb84b4f941976543ef2778f] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-08-01 17:03:34,491 线程ID: 176 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2025-07-01 0 <__data__> billdateend 2025-07-31 0 <__data__> chkisquery 0 0 <__customer__> userno LT069 0 <__businessman__> userno LT069 0 <__goods__> userno LT069 0 9 1 BusiManID 营业员编号 A.BusiManID true 1 10 1 Name 营业员姓名 BM.Name true 2 16 1 Scale 分配比例 CONVERT(NUMERIC(10,2), A.Scale) true 3 17 1 DiscountAmount 生意额 SUM(DiscountAmount) false 4 15 1 Quantity 数量 SUM(A.Quantity) false 5 时间: 2025-08-01 17:03:34,503 线程ID: 176 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##9c26be0047bd44208cf440c50b57c5d4] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-08-01 17:03:50,922 线程ID: 177 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2025-07-01 0 <__data__> billdateend 2025-07-31 0 <__data__> chkisquery 0 0 <__customer__> userno LT069 0 <__businessman__> userno LT069 0 <__goods__> userno LT069 0 9 1 BusiManID 营业员编号 A.BusiManID true 1 10 1 Name 营业员姓名 BM.Name true 2 16 1 Scale 分配比例 CONVERT(NUMERIC(10,2), A.Scale) true 3 17 1 DiscountAmount 生意额 SUM(DiscountAmount) false 4 15 1 Quantity 数量 SUM(A.Quantity) false 5 8 1 CheckDate 日期 A.CheckDate true 6 时间: 2025-08-01 17:03:50,931 线程ID: 177 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##a7221afa0e6b4d60bd279d62a958dc11] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID