时间: 2024-10-25 09:48:56,165 线程ID: 71 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2024-09-01 0 <__data__> billdateend 2024-10-25 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-10-25 09:48:56,193 线程ID: 71 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##74f00548a0ed4cea8c89b4cbc22dac84] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-10-25 13:44:26,841 线程ID: 131 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2024-09-25 0 <__data__> billdateend 2024-10-25 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 9 1 Name 营业员姓名 BM.Name true 2 12 1 Quantity 数量 SUM(A.Quantity) false 3 14 1 DiscountAmount 生意额 SUM(DiscountAmount) false 4 时间: 2024-10-25 13:44:26,851 线程ID: 131 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##7ff44f976bd54e4680daecc6354297fa] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-10-25 13:44:34,125 线程ID: 93 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2024-10-01 0 <__data__> billdateend 2024-10-25 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 9 1 Name 营业员姓名 BM.Name true 2 12 1 Quantity 数量 SUM(A.Quantity) false 3 14 1 DiscountAmount 生意额 SUM(DiscountAmount) false 4 时间: 2024-10-25 13:44:34,133 线程ID: 93 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##34ff296fcd2a488f84be32aac9ef8684] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-10-25 13:44:44,681 线程ID: 162 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2024-10-01 0 <__data__> billdateend 2024-10-25 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 9 1 Name 营业员姓名 BM.Name true 2 12 1 Quantity 数量 SUM(A.Quantity) false 3 14 1 DiscountAmount 生意额 SUM(DiscountAmount) false 4 4 1 CheckID 核销单号 A.CheckID true 5 时间: 2024-10-25 13:44:44,728 线程ID: 162 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##c35cc11b8b994ae2aeb9b4873323efe4] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-10-25 13:45:09,934 线程ID: 123 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2024-10-01 0 <__data__> billdateend 2024-10-25 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 5 12 1 Quantity 数量 SUM(A.Quantity) false 6 14 1 DiscountAmount 生意额 SUM(DiscountAmount) false 7 9 1 Name 营业员姓名 BM.Name true 8 时间: 2024-10-25 13:45:09,943 线程ID: 123 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##c6ff767b099b457db8a00ad07a27fff9] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2024-10-25 13:48:18,885 线程ID: 100 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> Goods_No 5 <__data__> billdatebegin 2024-10-01 0 <__data__> billdateend 2024-10-25 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_> LOEWE <__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 5 12 1 Quantity 数量 SUM(A.Quantity) false 6 14 1 DiscountAmount 生意额 SUM(DiscountAmount) false 7 9 1 Name 营业员姓名 BM.Name true 8 时间: 2024-10-25 13:48:18,911 线程ID: 100 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##c885c566714b4a2c9bfb9e9464f2af85] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID