时间: 2024-11-28 09:21:45,027 线程ID: 144 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2024-11-01 0 <__data__> billdateend 2024-11-27 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-11-28 09:21:45,039 线程ID: 144 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##7800df8a77604afe97c35c3fd6cf3c3a] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-11-28 13:21:15,719 线程ID: 169 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2024-11-01 0 <__data__> billdateend 2024-11-28 0 <__data__> chkisquery 0 0 <__customer__> userno NB002 0 <__customer__> customer_id 渠道编号 JM001 2 <__businessman__> userno NB002 0 <__businessman__> BusinessManCustomer 渠道 5 <__businessman__> buisnessmanid 营业员编号 4 <__businessmancustomer__> userno NB002 0 <__businessman___x0024_buisnessmanid_x0024_> LTB0167 陈静 <__businessman___x0024_buisnessmanid_x0024_> LTB0202 高雅琴 <__businessman___x0024_buisnessmanid_x0024_> LTB0212 陶海英 <__businessman___x0024_buisnessmanid_x0024_> LTB0408 李晓洁 <__businessman___x0024_buisnessmanid_x0024_> LTB0409 尤英杰 <__businessman___x0024_buisnessmanid_x0024_> LTB0432 朱燕 <__businessman___x0024_buisnessmanid_x0024_> LTB0445 张锐 <__goods__> userno NB002 0 4 1 CheckID 核销单号 A.CheckID true 1 6 1 Manual_ID 手工单号 a.Manual_ID true 2 7 1 CheckDate 日期 A.CheckDate true 3 9 1 Name 营业员姓名 BM.Name true 4 12 1 Quantity 数量 SUM(A.Quantity) false 5 14 1 DiscountAmount 生意额 SUM(DiscountAmount) false 6 时间: 2024-11-28 13:21:15,739 线程ID: 169 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##67bda227983c455a847a5276df9f1429] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 AND A.BuisnessManID IN ('LTB0167', 'LTB0202', 'LTB0212', 'LTB0408', 'LTB0409', 'LTB0432', 'LTB0445') AND EXISTS (SELECT 1 FROM [##1e7e8e58ad2848de9178491991377467] WHERE Customer_ID = A.CustomerID) ) A ORDER BY BuisnessManID 时间: 2024-11-28 13:21:25,133 线程ID: 135 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2024-11-01 0 <__data__> billdateend 2024-11-28 0 <__data__> chkisquery 0 0 <__customer__> userno NB002 0 <__customer__> customer_id 渠道编号 JM001 2 <__businessman__> userno NB002 0 <__businessman__> BusinessManCustomer 渠道 5 <__businessman__> buisnessmanid 营业员编号 4 <__businessmancustomer__> userno NB002 0 <__businessman___x0024_buisnessmanid_x0024_> LTB0167 陈静 <__businessman___x0024_buisnessmanid_x0024_> LTB0202 高雅琴 <__businessman___x0024_buisnessmanid_x0024_> LTB0212 陶海英 <__businessman___x0024_buisnessmanid_x0024_> LTB0408 李晓洁 <__businessman___x0024_buisnessmanid_x0024_> LTB0409 尤英杰 <__businessman___x0024_buisnessmanid_x0024_> LTB0432 朱燕 <__businessman___x0024_buisnessmanid_x0024_> LTB0445 张锐 <__goods__> userno NB002 0 4 1 CheckID 核销单号 A.CheckID true 1 7 1 CheckDate 日期 A.CheckDate true 3 9 1 Name 营业员姓名 BM.Name true 4 12 1 Quantity 数量 SUM(A.Quantity) false 5 14 1 DiscountAmount 生意额 SUM(DiscountAmount) false 6 时间: 2024-11-28 13:21:25,152 线程ID: 135 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##1164b4ed384b4f19b10a4f86fac550cc] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 AND A.BuisnessManID IN ('LTB0167', 'LTB0202', 'LTB0212', 'LTB0408', 'LTB0409', 'LTB0432', 'LTB0445') AND EXISTS (SELECT 1 FROM [##a173ce2ead3748afb97c1dc34922c268] WHERE Customer_ID = A.CustomerID) ) A ORDER BY BuisnessManID 时间: 2024-11-28 13:24:42,362 线程ID: 135 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2024-11-01 0 <__data__> billdateend 2024-11-28 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 4 1 CheckID 核销单号 A.CheckID true 2 12 1 Quantity 数量 SUM(A.Quantity) false 3 14 1 DiscountAmount 生意额 SUM(DiscountAmount) false 4 9 1 Name 营业员姓名 BM.Name true 5 时间: 2024-11-28 13:24:42,371 线程ID: 135 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##66c69ee94829466c895834b2d648a835] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-11-28 13:27:30,936 线程ID: 47 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2024-11-01 0 <__data__> billdateend 2024-11-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_> 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 7 1 CheckDate 日期 A.CheckDate true 1 4 1 CheckID 核销单号 A.CheckID true 2 12 1 Quantity 数量 SUM(A.Quantity) false 3 14 1 DiscountAmount 生意额 SUM(DiscountAmount) false 4 9 1 Name 营业员姓名 BM.Name true 5 时间: 2024-11-28 13:27:30,943 线程ID: 47 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##684b64551b3744468084e3c6f4395bbe] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-11-28 13:29:53,014 线程ID: 95 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2024-11-01 0 <__data__> billdateend 2024-11-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 2 12 1 Quantity 数量 SUM(A.Quantity) false 3 14 1 DiscountAmount 生意额 SUM(DiscountAmount) false 4 9 1 Name 营业员姓名 BM.Name true 5 时间: 2024-11-28 13:29:53,021 线程ID: 95 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##1a5db7b846754bf19d2692acce32a946] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-11-28 15:24:21,444 线程ID: 109 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> CustomerID [渠道编号:JM003] 5 <__businessman__> userno NB001 0 <__customer__> userno NB001 0 <__customer__> customer_id 渠道编号 JM003 1 时间: 2024-11-28 15:24:21,470 线程ID: 109 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##ddd6d3e9c197443a8165fdb6ec1b2a3f] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-11-28 15:24:41,449 线程ID: 49 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> CustomerID [渠道编号:JM003] 5 <__businessman__> userno NB001 0 <__customer__> userno NB001 0 <__customer__> customer_id 渠道编号 JM003 1 时间: 2024-11-28 15:24:41,456 线程ID: 49 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##2939b7ad21384988a4792a44f8177766] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-11-28 15:24:55,441 线程ID: 91 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> CustomerID [渠道编号:JM003] 5 <__businessman__> userno NB001 0 <__customer__> userno NB001 0 <__customer__> customer_id 渠道编号 JM003 1 时间: 2024-11-28 15:24:55,448 线程ID: 91 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##e7e2364936e049af8c1088a28b790627] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-11-28 15:25:08,129 线程ID: 91 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> CustomerID [渠道编号:JM003] 5 <__businessman__> userno NB001 0 <__customer__> userno NB001 0 <__customer__> customer_id 渠道编号 JM003 1 时间: 2024-11-28 15:25:08,135 线程ID: 91 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##98d8381226fd4f7ebdfef489f3572a95] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-11-28 16:37:44,071 线程ID: 110 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> CustomerID 5 <__businessman__> userno LT017 0 <__customer__> userno LT017 0 时间: 2024-11-28 16:37:44,079 线程ID: 110 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##2406c9f525a04793b8a27f6ab8eccbb1] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID