时间: 2025-02-07 09:10:50,411 线程ID: 8 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2025-02-01 0 <__data__> billdateend 2025-02-06 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 时间: 2025-02-07 09:10:50,439 线程ID: 8 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##5b0407f70fe64b61bc73f043df096965] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-02-07 09:12:29,832 线程ID: 98 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> buisnessmanid LTB0593 1 时间: 2025-02-07 09:36:22,027 线程ID: 16 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> CustomerID 5 <__businessman__> userno LT017 0 <__customer__> userno LT017 0 时间: 2025-02-07 09:36:22,039 线程ID: 16 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##a21f31dc0d534fda8c645ddfa8aa7e49] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-02-07 11:48:50,641 线程ID: 207 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2025-01-01 0 <__data__> billdateend 2025-01-31 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-02-07 11:48:50,652 线程ID: 207 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##23c3e83d066d4b7e8bf48fc47d42077a] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-02-07 11:48:58,845 线程ID: 208 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2025-01-01 0 <__data__> billdateend 2025-01-31 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-02-07 11:48:58,853 线程ID: 208 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##9b07dc53e48c4e259df91e0fa08d7c27] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-02-07 14:11:02,283 线程ID: 186 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 张晶晶 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2025-02-07 14:11:02,295 线程ID: 186 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##2e9520ab07634391ba1da9feba886410] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-02-07 14:54:42,364 线程ID: 168 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2025-01-01 0 <__data__> billdateend 2025-01-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 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 时间: 2025-02-07 14:54:42,377 线程ID: 168 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##b9b8b4b731ca45bea517b8c39172c7da] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-02-07 15:52:03,106 线程ID: 187 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__businessman__> buisnessmanid 营业员编号 张晶晶 2 <__customer__> userno LT062 0 时间: 2025-02-07 15:52:03,114 线程ID: 187 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##2841dd43698c4e5dac0c1c330f055c4f] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 AND A.BuisnessManID = @buisnessmanid ) A ORDER BY BuisnessManID 时间: 2025-02-07 15:52:05,690 线程ID: 144 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 张晶晶 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2025-02-07 15:52:05,702 线程ID: 144 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##59473790831d493bbe551cd0c38459ef] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-02-07 15:52:16,567 线程ID: 203 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 张晶晶 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2025-02-07 15:52:16,581 线程ID: 203 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##80c5b5b738cf4a0eb14cf2d125742514] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-02-07 15:52:27,547 线程ID: 66 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 芮琼芳 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2025-02-07 15:52:27,558 线程ID: 66 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##c799e51a886d49289ba374eedff4a4bf] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-02-07 15:52:35,772 线程ID: 200 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 芮琼芳 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2025-02-07 15:52:35,785 线程ID: 200 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##8655b65456184362b66e302a0a2f60c9] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2025-02-07 15:53:09,713 线程ID: 188 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> name 芮琼芳 2 <__data__> CustomerID 5 <__businessman__> userno LT062 0 <__customer__> userno LT062 0 时间: 2025-02-07 15:53:09,723 线程ID: 188 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##37fdf218b92342deaf1b89bc4be2aa56] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID