时间: 2024-11-17 00:47:24,325
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1]
    , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1]
    , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1]
    , CAST(NULL AS INT) AS [批发在途#数量]
    , CAST(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount]
    , CAST(NULL AS INT) AS [15DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount]
    , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1]
    , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1]
    , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1]
    , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1]
    , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1]
    , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1]
INTO [##41e09f69ba4a4ee3a968a82f04824da7]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2024-11-17 00:47:24,806
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##0215bdb3fcca4740a84525b904ef645b] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2024-11-17 00:47:24,808
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##41e09f69ba4a4ee3a968a82f04824da7] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##0215bdb3fcca4740a84525b904ef645b]


    时间: 2024-11-17 00:47:24,875
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##f179e14294c24be5bdc522be3c1a229b a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2024-11-17 00:47:24,878
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f179e14294c24be5bdc522be3c1a229b SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2024-11-17 00:47:24,880
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##f179e14294c24be5bdc522be3c1a229b a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2024-11-17 00:47:24,911
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f179e14294c24be5bdc522be3c1a229b SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2024-11-17 00:47:24,912
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f179e14294c24be5bdc522be3c1a229b SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2024-11-17 00:47:24,916
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##41e09f69ba4a4ee3a968a82f04824da7] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##c5d0cd9005bf4f3d9ee9ce9d8cd608da]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2024-11-17 00:47:24,921
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量]
INTO tempdb.dbo.[adc02d40-d2c6-4419-9e36-cd9d78a2e05a]
FROM ##41e09f69ba4a4ee3a968a82f04824da7 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name


    时间: 2024-11-17 16:20:27,627
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1]
    , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1]
    , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1]
    , CAST(NULL AS INT) AS [批发在途#数量]
    , CAST(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount]
    , CAST(NULL AS INT) AS [15DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount]
    , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1]
    , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1]
    , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1]
    , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1]
    , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1]
    , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1]
INTO [##d68ad65800b043e9ab01e08ef17a7aa4]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2024-11-17 16:20:28,043
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##23ed8e42458d474fba33be2b7a26fea5] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2024-11-17 16:20:28,046
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##d68ad65800b043e9ab01e08ef17a7aa4] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##23ed8e42458d474fba33be2b7a26fea5]


    时间: 2024-11-17 16:20:28,111
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##80c93e3409404b4b845475fd8d66c5d9 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2024-11-17 16:20:28,113
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##80c93e3409404b4b845475fd8d66c5d9 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2024-11-17 16:20:28,117
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##80c93e3409404b4b845475fd8d66c5d9 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2024-11-17 16:20:28,155
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##80c93e3409404b4b845475fd8d66c5d9 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2024-11-17 16:20:28,158
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##80c93e3409404b4b845475fd8d66c5d9 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2024-11-17 16:20:28,163
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##d68ad65800b043e9ab01e08ef17a7aa4] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##786ec06b25274933b3fa0bcfca88b3d9]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2024-11-17 16:20:28,177
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量]
INTO tempdb.dbo.[6d7c3166-f91d-4b71-8987-9e88065adb4d]
FROM ##d68ad65800b043e9ab01e08ef17a7aa4 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name


    时间: 2024-11-17 16:40:38,738
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1]
    , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1]
    , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1]
    , CAST(NULL AS INT) AS [批发在途#数量]
    , CAST(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount]
    , CAST(NULL AS INT) AS [15DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount]
    , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1]
    , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1]
    , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1]
    , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1]
    , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1]
    , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1]
INTO [##f591ee45cb7142429071f80a08478966]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2024-11-17 16:40:39,191
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##ddcf905dd3384f18baaaa4446fede721] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2024-11-17 16:40:39,193
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##f591ee45cb7142429071f80a08478966] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##ddcf905dd3384f18baaaa4446fede721]


    时间: 2024-11-17 16:40:39,261
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##378758b3d53049e5ae2310b816842b00 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2024-11-17 16:40:39,264
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##378758b3d53049e5ae2310b816842b00 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2024-11-17 16:40:39,267
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##378758b3d53049e5ae2310b816842b00 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2024-11-17 16:40:39,299
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##378758b3d53049e5ae2310b816842b00 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2024-11-17 16:40:39,300
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##378758b3d53049e5ae2310b816842b00 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2024-11-17 16:40:39,305
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##f591ee45cb7142429071f80a08478966] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##724dfcb5f5e2470b85be701f4fcac007]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2024-11-17 16:40:39,310
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量]
INTO tempdb.dbo.[6d7c3166-f91d-4b71-8987-9e88065adb4d]
FROM ##f591ee45cb7142429071f80a08478966 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name


    时间: 2024-11-17 16:41:23,345
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1]
    , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1]
    , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1]
    , CAST(NULL AS INT) AS [批发在途#数量]
    , CAST(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount]
    , CAST(NULL AS INT) AS [15DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount]
    , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1]
    , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1]
    , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1]
    , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1]
    , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1]
    , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1]
INTO [##07d5c8b6a1ca4c7f85eeaf3505312f14]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2024-11-17 16:41:23,894
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##34119fce674d414bb2df018f31a90aff] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2024-11-17 16:41:23,896
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##07d5c8b6a1ca4c7f85eeaf3505312f14] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##34119fce674d414bb2df018f31a90aff]


    时间: 2024-11-17 16:41:23,959
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##aa801e78c033464798fa3c0eb4b593de a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2024-11-17 16:41:23,962
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##aa801e78c033464798fa3c0eb4b593de SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2024-11-17 16:41:23,966
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##aa801e78c033464798fa3c0eb4b593de a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2024-11-17 16:41:24,003
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##aa801e78c033464798fa3c0eb4b593de SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2024-11-17 16:41:24,005
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##aa801e78c033464798fa3c0eb4b593de SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2024-11-17 16:41:24,008
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##07d5c8b6a1ca4c7f85eeaf3505312f14] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##555c3d6763a74d939cb70c97f9db8d19]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2024-11-17 16:41:24,013
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量]
INTO tempdb.dbo.[6d7c3166-f91d-4b71-8987-9e88065adb4d]
FROM ##07d5c8b6a1ca4c7f85eeaf3505312f14 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name


    时间: 2024-11-17 16:49:27,332
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1]
    , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1]
    , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1]
    , CAST(NULL AS INT) AS [批发在途#数量]
    , CAST(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount]
    , CAST(NULL AS INT) AS [15DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount]
    , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1]
    , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1]
    , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1]
    , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1]
    , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1]
    , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1]
INTO [##1ecc08c2ff524a3cab2cbc748fb0f352]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2024-11-17 16:49:27,771
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##722a90ce28204b3b9424901f54daebe0] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2024-11-17 16:49:27,773
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##1ecc08c2ff524a3cab2cbc748fb0f352] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##722a90ce28204b3b9424901f54daebe0]


    时间: 2024-11-17 16:49:27,840
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##ab69098d71aa4a0ba3d99d22ad9c7e20 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2024-11-17 16:49:27,843
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##ab69098d71aa4a0ba3d99d22ad9c7e20 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2024-11-17 16:49:27,846
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##ab69098d71aa4a0ba3d99d22ad9c7e20 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2024-11-17 16:49:27,882
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##ab69098d71aa4a0ba3d99d22ad9c7e20 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2024-11-17 16:49:27,884
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##ab69098d71aa4a0ba3d99d22ad9c7e20 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2024-11-17 16:49:27,887
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##1ecc08c2ff524a3cab2cbc748fb0f352] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##dae8290cfd514760845f15bc1d1604e7]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2024-11-17 16:49:27,893
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量]
INTO tempdb.dbo.[6d7c3166-f91d-4b71-8987-9e88065adb4d]
FROM ##1ecc08c2ff524a3cab2cbc748fb0f352 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name


    时间: 2024-11-17 16:53:22,487
  线程ID: 21
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1]
    , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1]
    , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1]
    , CAST(NULL AS INT) AS [批发在途#数量]
    , CAST(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount]
    , CAST(NULL AS INT) AS [15DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount]
    , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1]
    , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1]
    , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1]
    , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1]
    , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1]
    , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1]
INTO [##0a4d3d357353403d8108bbf166e85cb9]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2024-11-17 16:53:22,910
  线程ID: 21
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##31530c591a0a4e5a857972ff8e0cbdcc] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2024-11-17 16:53:22,912
  线程ID: 21
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0a4d3d357353403d8108bbf166e85cb9] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##31530c591a0a4e5a857972ff8e0cbdcc]


    时间: 2024-11-17 16:53:22,979
  线程ID: 21
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##5c047da7d24f4ab298a5ffa5fc5c6c4f a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2024-11-17 16:53:22,982
  线程ID: 21
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##5c047da7d24f4ab298a5ffa5fc5c6c4f SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2024-11-17 16:53:22,985
  线程ID: 21
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##5c047da7d24f4ab298a5ffa5fc5c6c4f a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2024-11-17 16:53:23,012
  线程ID: 21
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##5c047da7d24f4ab298a5ffa5fc5c6c4f SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2024-11-17 16:53:23,014
  线程ID: 21
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##5c047da7d24f4ab298a5ffa5fc5c6c4f SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2024-11-17 16:53:23,017
  线程ID: 21
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0a4d3d357353403d8108bbf166e85cb9] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##512c3018bd6142a79b582bec564bc469]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2024-11-17 16:53:23,021
  线程ID: 21
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量]
INTO tempdb.dbo.[6d7c3166-f91d-4b71-8987-9e88065adb4d]
FROM ##0a4d3d357353403d8108bbf166e85cb9 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name


    时间: 2024-11-17 17:55:49,830
  线程ID: 30
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1]
    , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1]
    , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1]
    , CAST(NULL AS INT) AS [批发在途#数量]
    , CAST(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount]
    , CAST(NULL AS INT) AS [15DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount]
    , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1]
    , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1]
    , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1]
    , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1]
    , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1]
    , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1]
INTO [##2954b589cb6d4f9ba71e44b1c7a0c9bd]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2024-11-17 17:55:50,259
  线程ID: 30
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##6ae08370e49a4fd99b8a1d7c1b3c9c8e] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2024-11-17 17:55:50,261
  线程ID: 30
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##2954b589cb6d4f9ba71e44b1c7a0c9bd] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##6ae08370e49a4fd99b8a1d7c1b3c9c8e]


    时间: 2024-11-17 17:55:50,323
  线程ID: 30
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##4c4c755203c947cfb26eebc130de5863 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2024-11-17 17:55:50,326
  线程ID: 30
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4c4c755203c947cfb26eebc130de5863 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2024-11-17 17:55:50,330
  线程ID: 30
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##4c4c755203c947cfb26eebc130de5863 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2024-11-17 17:55:50,360
  线程ID: 30
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4c4c755203c947cfb26eebc130de5863 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2024-11-17 17:55:50,363
  线程ID: 30
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4c4c755203c947cfb26eebc130de5863 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2024-11-17 17:55:50,366
  线程ID: 30
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##2954b589cb6d4f9ba71e44b1c7a0c9bd] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##6573c45d1b74447f98772a1cd6384bd4]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2024-11-17 17:55:50,372
  线程ID: 30
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量]
INTO tempdb.dbo.[6d7c3166-f91d-4b71-8987-9e88065adb4d]
FROM ##2954b589cb6d4f9ba71e44b1c7a0c9bd A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name


    时间: 2024-11-17 18:02:53,527
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1]
    , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1]
    , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1]
    , CAST(NULL AS INT) AS [批发在途#数量]
    , CAST(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount]
    , CAST(NULL AS INT) AS [15DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount]
    , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1]
    , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1]
    , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1]
    , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1]
    , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1]
    , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1]
INTO [##c17a890430f3430b85fe78b8fd5ecad3]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2024-11-17 18:02:53,959
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##3ec28818582d4cb29d6fb53325c2f769] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2024-11-17 18:02:53,961
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##c17a890430f3430b85fe78b8fd5ecad3] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##3ec28818582d4cb29d6fb53325c2f769]


    时间: 2024-11-17 18:02:54,032
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##72c1fe76367c4e23ba75893323c5ddf1 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2024-11-17 18:02:54,036
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##72c1fe76367c4e23ba75893323c5ddf1 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2024-11-17 18:02:54,039
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##72c1fe76367c4e23ba75893323c5ddf1 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2024-11-17 18:02:54,075
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##72c1fe76367c4e23ba75893323c5ddf1 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2024-11-17 18:02:54,076
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##72c1fe76367c4e23ba75893323c5ddf1 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2024-11-17 18:02:54,079
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##c17a890430f3430b85fe78b8fd5ecad3] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##b8a899b198da4b9f9b2b4d01e94c61e9]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2024-11-17 18:02:54,085
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量]
INTO tempdb.dbo.[6d7c3166-f91d-4b71-8987-9e88065adb4d]
FROM ##c17a890430f3430b85fe78b8fd5ecad3 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name


    时间: 2024-11-17 18:37:29,373
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1]
    , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1]
    , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1]
    , CAST(NULL AS INT) AS [批发在途#数量]
    , CAST(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount]
    , CAST(NULL AS INT) AS [15DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount]
    , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1]
    , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1]
    , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1]
    , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1]
    , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1]
    , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1]
INTO [##0935fea839954e7bbe5055b6cc30d8a9]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2024-11-17 18:37:29,797
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##a8a7d64471f940aca2b7fbe08ff0ab82] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2024-11-17 18:37:29,799
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0935fea839954e7bbe5055b6cc30d8a9] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##a8a7d64471f940aca2b7fbe08ff0ab82]


    时间: 2024-11-17 18:37:29,862
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##d3fd4e63417747beb0b0518206a16c37 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2024-11-17 18:37:29,864
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##d3fd4e63417747beb0b0518206a16c37 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2024-11-17 18:37:29,867
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##d3fd4e63417747beb0b0518206a16c37 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2024-11-17 18:37:29,898
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##d3fd4e63417747beb0b0518206a16c37 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2024-11-17 18:37:29,901
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##d3fd4e63417747beb0b0518206a16c37 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2024-11-17 18:37:29,905
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0935fea839954e7bbe5055b6cc30d8a9] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##e5b5331e942f4895b3ac97a306490e25]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2024-11-17 18:37:29,909
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量]
INTO tempdb.dbo.[6d7c3166-f91d-4b71-8987-9e88065adb4d]
FROM ##0935fea839954e7bbe5055b6cc30d8a9 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name


    时间: 2024-11-17 18:37:49,258
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1]
    , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1]
    , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1]
    , CAST(NULL AS INT) AS [批发在途#数量]
    , CAST(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount]
    , CAST(NULL AS INT) AS [15DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount]
    , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1]
    , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1]
    , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1]
    , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1]
    , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1]
    , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1]
INTO [##6b5f4ea7d9de4caaa5eac57260f245fe]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2024-11-17 18:37:49,617
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##a710a581b7ac4ff696ad955ea57b9f7c] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2024-11-17 18:37:49,619
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##6b5f4ea7d9de4caaa5eac57260f245fe] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##a710a581b7ac4ff696ad955ea57b9f7c]


    时间: 2024-11-17 18:37:49,675
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##f1a11240903c4ea6ae8f6a56a6344c91 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2024-11-17 18:37:49,677
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f1a11240903c4ea6ae8f6a56a6344c91 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2024-11-17 18:37:49,678
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##f1a11240903c4ea6ae8f6a56a6344c91 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2024-11-17 18:37:49,710
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f1a11240903c4ea6ae8f6a56a6344c91 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2024-11-17 18:37:49,712
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f1a11240903c4ea6ae8f6a56a6344c91 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2024-11-17 18:37:49,715
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##6b5f4ea7d9de4caaa5eac57260f245fe] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##189cc23a396d49c69c80e62df7a67f09]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2024-11-17 18:37:49,719
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量]
INTO tempdb.dbo.[6d7c3166-f91d-4b71-8987-9e88065adb4d]
FROM ##6b5f4ea7d9de4caaa5eac57260f245fe A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name


    时间: 2024-11-17 18:38:11,595
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1]
    , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1]
    , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1]
    , CAST(NULL AS INT) AS [批发在途#数量]
    , CAST(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount]
    , CAST(NULL AS INT) AS [15DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount]
    , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1]
    , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1]
    , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1]
    , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1]
    , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1]
    , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1]
INTO [##860a0ac64a6047be8100c2d936b7dfc9]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2024-11-17 18:38:12,016
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##a8b85704c324409581df9463dd8e8a52] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2024-11-17 18:38:12,018
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##860a0ac64a6047be8100c2d936b7dfc9] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##a8b85704c324409581df9463dd8e8a52]


    时间: 2024-11-17 18:38:12,079
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##90e5e3e71b39489abe32c42596cd4af0 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2024-11-17 18:38:12,082
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##90e5e3e71b39489abe32c42596cd4af0 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2024-11-17 18:38:12,083
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##90e5e3e71b39489abe32c42596cd4af0 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2024-11-17 18:38:12,111
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##90e5e3e71b39489abe32c42596cd4af0 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2024-11-17 18:38:12,112
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##90e5e3e71b39489abe32c42596cd4af0 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2024-11-17 18:38:12,115
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##860a0ac64a6047be8100c2d936b7dfc9] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##f92b14292e324bc0a6885a6e4b10a006]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2024-11-17 18:38:12,118
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量]
INTO tempdb.dbo.[6d7c3166-f91d-4b71-8987-9e88065adb4d]
FROM ##860a0ac64a6047be8100c2d936b7dfc9 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name