时间: 2021-09-01 13:56:38,771
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##0dcd214c98924681879698a64f75dc97]
ORDER BY Goods_no


    时间: 2021-09-01 13:56:43,642
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##a1271ab4d637493e84086b52d769723b]
ORDER BY Goods_no


    时间: 2021-09-01 13:56:56,453
  线程ID: 19
日志级别: 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 INT) AS [15DayCheckQuantity]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , 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 [##a56ad93baa7a4c3fa17df678798098aa]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-09-01 13:56:56,823
  线程ID: 19
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##fc2f1260319844a39806b50eca7f3c19] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-09-01 13:56:56,825
  线程ID: 19
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##a56ad93baa7a4c3fa17df678798098aa] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##fc2f1260319844a39806b50eca7f3c19]


    时间: 2021-09-01 13:56:56,907
  线程ID: 19
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##820c89494239430785acc8758cf81634 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-09-01 13:56:56,910
  线程ID: 19
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##820c89494239430785acc8758cf81634 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-09-01 13:56:56,913
  线程ID: 19
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##820c89494239430785acc8758cf81634 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 = '退货' 


    时间: 2021-09-01 13:56:56,937
  线程ID: 19
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##820c89494239430785acc8758cf81634 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-09-01 13:56:56,939
  线程ID: 19
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##820c89494239430785acc8758cf81634 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-09-01 13:56:56,943
  线程ID: 19
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##a56ad93baa7a4c3fa17df678798098aa] (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 [##dc435aea054f4805b7294e25b327e400]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-09-01 13:56:56,969
  线程ID: 19
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称]
INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e]
FROM ##a56ad93baa7a4c3fa17df678798098aa 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  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END

ORDER BY  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END


    时间: 2021-09-01 14:01:38,302
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long
    , 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 占用数#数量
INTO [##691a0c51251943d78007c7afd59ae3f9]
FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W


    时间: 2021-09-01 14:01:38,525
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##691a0c51251943d78007c7afd59ae3f9] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##1090009fc9fd43e89804ea68dc854cb7] A
INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No


    时间: 2021-09-01 14:06:46,626
  线程ID: 84
日志级别: 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 INT) AS [15DayCheckQuantity]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , 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 [##376f0d8a6fcb431baf049b09af9037a0]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-09-01 14:06:46,980
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##cb83a8e998fe490897bb965602e42980] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-09-01 14:06:46,982
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##376f0d8a6fcb431baf049b09af9037a0] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##cb83a8e998fe490897bb965602e42980]


    时间: 2021-09-01 14:06:47,056
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##eb78e6422cf64e2697cb025b74a4ddd5 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-09-01 14:06:47,058
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##eb78e6422cf64e2697cb025b74a4ddd5 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-09-01 14:06:47,061
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##eb78e6422cf64e2697cb025b74a4ddd5 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 = '退货' 


    时间: 2021-09-01 14:06:47,087
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##eb78e6422cf64e2697cb025b74a4ddd5 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-09-01 14:06:47,089
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##eb78e6422cf64e2697cb025b74a4ddd5 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-09-01 14:06:47,092
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##376f0d8a6fcb431baf049b09af9037a0] (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 [##c8137fca2bef4d3aafe9c31301cd9196]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-09-01 14:06:47,100
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long
, A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType 
, SUM(C.[S1]) AS [S1]
, SUM(ISNULL(C.[S1], 0)) AS Quantity
, SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount
INTO ##ff534915ffce423f9e8b73d826fa07dd
FROM [vn_Check] A 
INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID
INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID
INNER JOIN [##856bb9ae9ed94689bb826942abebf72c] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##b2afa201830e4fa1acfa84f0265054ab] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >='2021/8/1'
 AND CheckDate <='2021-08-31'
 GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long
, A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 


    时间: 2021-09-01 14:06:47,129
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##ff534915ffce423f9e8b73d826fa07dd a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-09-01 14:06:47,134
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##ff534915ffce423f9e8b73d826fa07dd SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-09-01 14:06:47,136
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##ff534915ffce423f9e8b73d826fa07dd 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 = '退货' 


    时间: 2021-09-01 14:06:47,168
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##ff534915ffce423f9e8b73d826fa07dd SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-09-01 14:06:47,170
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##ff534915ffce423f9e8b73d826fa07dd SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-09-01 14:06:47,172
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##376f0d8a6fcb431baf049b09af9037a0(Customer_ID, Goods_No, ColorID, Long, [7DayCheckQuantity]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity) FROM ##d4fa4f0bf35345179b69cf1adcb9c8f4
 WHERE CheckDate BETWEEN '2021/8/25'
AND '2021-08-31 23:59:59'  
GROUP BY Customer_ID, Goods_No, ColorID, Long
 INSERT INTO ##376f0d8a6fcb431baf049b09af9037a0(Customer_ID, Goods_No, ColorID, Long, [15DayCheckQuantity]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity) FROM ##d4fa4f0bf35345179b69cf1adcb9c8f4
 WHERE CheckDate BETWEEN '2021/8/17'
AND '2021-08-31 23:59:59'  
GROUP BY Customer_ID, Goods_No, ColorID, Long
 INSERT INTO ##376f0d8a6fcb431baf049b09af9037a0(Customer_ID, Goods_No, ColorID, Long, [30DayCheckQuantity]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity) FROM ##d4fa4f0bf35345179b69cf1adcb9c8f4
 WHERE CheckDate BETWEEN '2021/8/2'
AND '2021-08-31 23:59:59'  
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-09-01 14:06:47,180
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long 
     , MIN(a.Tin_Date) AS MinShopTinDate 
     , MAX(a.Tin_Date) AS MaxShopTinDate
INTO ##b8534aaa5d6547fab806b05ad282c86d
FROM ShopTin A 
     INNER JOIN ShopTinGoods b on A.ShopTinID = B.ShopTinID 
     INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID 
WHERE A.Posted=1 
     AND EXISTS (SELECT 1 FROM [##856bb9ae9ed94689bb826942abebf72c] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##b2afa201830e4fa1acfa84f0265054ab] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2021-09-01 14:06:47,244
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long
, A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType 
, SUM(C.[S1]) AS [S1]
, SUM(ISNULL(C.[S1], 0)) AS Quantity
, SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount
INTO ##9035a37a15db40b0b5cf4e158ff26c88
FROM [vn_Check] A 
INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID
INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID
LEFT JOIN (SELECT T9.Customer_ID, T9.Goods_No, T9.ColorID, T9.Long, MIN(T9.MinShopTinDate) MinShopTinDate FROM ##b8534aaa5d6547fab806b05ad282c86d T9 GROUP BY T9.Customer_ID, T9.Goods_No, T9.ColorID, T9.Long) T ON B.Goods_No = T.Goods_No AND A.Customer_ID = T.Customer_ID AND T.ColorID=C.ColorID AND T.Long=C.Long
INNER JOIN [##856bb9ae9ed94689bb826942abebf72c] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##b2afa201830e4fa1acfa84f0265054ab] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= ISNULL(T.MinShopTinDate, '1990-01-01')
 AND CheckDate <='2021-08-31'
 GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long
, A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 


    时间: 2021-09-01 14:06:47,285
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##9035a37a15db40b0b5cf4e158ff26c88 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-09-01 14:06:47,288
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##9035a37a15db40b0b5cf4e158ff26c88 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-09-01 14:06:47,291
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##9035a37a15db40b0b5cf4e158ff26c88 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 = '退货' 


    时间: 2021-09-01 14:06:47,320
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##9035a37a15db40b0b5cf4e158ff26c88 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-09-01 14:06:47,323
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##9035a37a15db40b0b5cf4e158ff26c88 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-09-01 14:06:47,326
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##376f0d8a6fcb431baf049b09af9037a0(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity) FROM ##dc6e75063cb14bfab036ad04bdf90ff2
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-09-01 14:06:47,330
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.UnitPrice AS [吊牌价], SUM(A.[30DayCheckQuantity]) AS [月销售数量], SUM(A.[AllDayCheckQuantity]) AS [累销数量], SUM([渠道库存#数量]) AS [渠道库存], GS.Range AS [系列], SUM([销售#数量]) AS [销售]
INTO tempdb.dbo.[c9a9a89c-06e5-4639-96ef-8a3ca821cc28]
FROM ##376f0d8a6fcb431baf049b09af9037a0 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
         LEFT JOIN ##b8534aaa5d6547fab806b05ad282c86d T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0

GROUP BY  A.Goods_No, GS.Goods_Name, GS.UnitPrice, GS.Range

ORDER BY  A.Goods_No, GS.Goods_Name, GS.UnitPrice, GS.Range


    时间: 2021-09-01 14:07:39,310
  线程ID: 22
日志级别: 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 INT) AS [15DayCheckQuantity]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , 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 [##59b29033653444018b79d8cdfb9530c3]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-09-01 14:07:39,665
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##57a15cb0dc814dc69e618b79eb364100] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-09-01 14:07:39,666
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##59b29033653444018b79d8cdfb9530c3] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##57a15cb0dc814dc69e618b79eb364100]


    时间: 2021-09-01 14:07:39,739
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##30b196fcabd2473bbc25e51eb35cdeec a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-09-01 14:07:39,742
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##30b196fcabd2473bbc25e51eb35cdeec SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-09-01 14:07:39,745
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##30b196fcabd2473bbc25e51eb35cdeec 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 = '退货' 


    时间: 2021-09-01 14:07:39,770
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##30b196fcabd2473bbc25e51eb35cdeec SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-09-01 14:07:39,771
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##30b196fcabd2473bbc25e51eb35cdeec SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-09-01 14:07:39,775
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##59b29033653444018b79d8cdfb9530c3] (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 [##a6b232a738714d6cb0bccdce95e431ec]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-09-01 14:07:39,780
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long
, A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType 
, SUM(C.[S1]) AS [S1]
, SUM(ISNULL(C.[S1], 0)) AS Quantity
, SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount
INTO ##a9627d093a8b4892b9918e64367ffaac
FROM [vn_Check] A 
INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID
INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID
INNER JOIN [##32a1a59ceb394a1ba77113b458519441] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##ebc86b5f6bae475d86f8a18c06610afd] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >='2021/8/1'
 AND CheckDate <='2021-08-31'
 GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long
, A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 


    时间: 2021-09-01 14:07:39,809
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##a9627d093a8b4892b9918e64367ffaac a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-09-01 14:07:39,811
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##a9627d093a8b4892b9918e64367ffaac SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-09-01 14:07:39,814
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##a9627d093a8b4892b9918e64367ffaac 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 = '退货' 


    时间: 2021-09-01 14:07:39,846
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##a9627d093a8b4892b9918e64367ffaac SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-09-01 14:07:39,847
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##a9627d093a8b4892b9918e64367ffaac SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-09-01 14:07:39,850
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##59b29033653444018b79d8cdfb9530c3(Customer_ID, Goods_No, ColorID, Long, [7DayCheckQuantity]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity) FROM ##127ef4465dcf4a7dac839d09da378820
 WHERE CheckDate BETWEEN '2021/8/25'
AND '2021-08-31 23:59:59'  
GROUP BY Customer_ID, Goods_No, ColorID, Long
 INSERT INTO ##59b29033653444018b79d8cdfb9530c3(Customer_ID, Goods_No, ColorID, Long, [15DayCheckQuantity]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity) FROM ##127ef4465dcf4a7dac839d09da378820
 WHERE CheckDate BETWEEN '2021/8/17'
AND '2021-08-31 23:59:59'  
GROUP BY Customer_ID, Goods_No, ColorID, Long
 INSERT INTO ##59b29033653444018b79d8cdfb9530c3(Customer_ID, Goods_No, ColorID, Long, [30DayCheckQuantity]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity) FROM ##127ef4465dcf4a7dac839d09da378820
 WHERE CheckDate BETWEEN '2021/8/2'
AND '2021-08-31 23:59:59'  
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-09-01 14:07:39,858
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long 
     , MIN(a.Tin_Date) AS MinShopTinDate 
     , MAX(a.Tin_Date) AS MaxShopTinDate
INTO ##14c364b523df4a5091fda477459862c5
FROM ShopTin A 
     INNER JOIN ShopTinGoods b on A.ShopTinID = B.ShopTinID 
     INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID 
WHERE A.Posted=1 
     AND EXISTS (SELECT 1 FROM [##32a1a59ceb394a1ba77113b458519441] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##ebc86b5f6bae475d86f8a18c06610afd] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2021-09-01 14:07:39,920
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long
, A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType 
, SUM(C.[S1]) AS [S1]
, SUM(ISNULL(C.[S1], 0)) AS Quantity
, SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount
INTO ##5d6b070f0cec4c90acec01e4d36a0143
FROM [vn_Check] A 
INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID
INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID
LEFT JOIN (SELECT T9.Customer_ID, T9.Goods_No, T9.ColorID, T9.Long, MIN(T9.MinShopTinDate) MinShopTinDate FROM ##14c364b523df4a5091fda477459862c5 T9 GROUP BY T9.Customer_ID, T9.Goods_No, T9.ColorID, T9.Long) T ON B.Goods_No = T.Goods_No AND A.Customer_ID = T.Customer_ID AND T.ColorID=C.ColorID AND T.Long=C.Long
INNER JOIN [##32a1a59ceb394a1ba77113b458519441] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##ebc86b5f6bae475d86f8a18c06610afd] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= ISNULL(T.MinShopTinDate, '1990-01-01')
 AND CheckDate <='2021-08-31'
 GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long
, A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 


    时间: 2021-09-01 14:07:39,971
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##5d6b070f0cec4c90acec01e4d36a0143 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-09-01 14:07:39,974
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##5d6b070f0cec4c90acec01e4d36a0143 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-09-01 14:07:39,978
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##5d6b070f0cec4c90acec01e4d36a0143 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 = '退货' 


    时间: 2021-09-01 14:07:40,008
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##5d6b070f0cec4c90acec01e4d36a0143 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-09-01 14:07:40,009
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##5d6b070f0cec4c90acec01e4d36a0143 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-09-01 14:07:40,012
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##59b29033653444018b79d8cdfb9530c3(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity) FROM ##00b130721d494d43b57f6a65e1baed35
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-09-01 14:07:40,017
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.UnitPrice AS [吊牌价], SUM(A.[30DayCheckQuantity]) AS [月销售数量], SUM(A.[AllDayCheckQuantity]) AS [累销数量], SUM([渠道库存#数量]) AS [渠道库存], GS.Range AS [系列], SUM([销售#数量]) AS [销售]
INTO tempdb.dbo.[c9a9a89c-06e5-4639-96ef-8a3ca821cc28]
FROM ##59b29033653444018b79d8cdfb9530c3 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
         LEFT JOIN ##14c364b523df4a5091fda477459862c5 T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0

GROUP BY  A.Goods_No, GS.Goods_Name, GS.UnitPrice, GS.Range

ORDER BY  A.Goods_No, GS.Goods_Name, GS.UnitPrice, GS.Range


    时间: 2021-09-01 14:07:41,821
  线程ID: 36
日志级别: 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 INT) AS [15DayCheckQuantity]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , 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 [##86cc4f1c0ad04405b74fd34cd74e972a]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-09-01 14:07:42,183
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##dcb25f30b15648e3b9ab980a638eaa6d] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-09-01 14:07:42,185
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##86cc4f1c0ad04405b74fd34cd74e972a] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##dcb25f30b15648e3b9ab980a638eaa6d]


    时间: 2021-09-01 14:07:42,274
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##51b9a3d0acf849ccb2d1e400c7d78918 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-09-01 14:07:42,277
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##51b9a3d0acf849ccb2d1e400c7d78918 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-09-01 14:07:42,280
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##51b9a3d0acf849ccb2d1e400c7d78918 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 = '退货' 


    时间: 2021-09-01 14:07:42,311
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##51b9a3d0acf849ccb2d1e400c7d78918 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-09-01 14:07:42,314
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##51b9a3d0acf849ccb2d1e400c7d78918 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-09-01 14:07:42,317
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##86cc4f1c0ad04405b74fd34cd74e972a] (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 [##978207290bd44fab925bdba38ed242b6]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-09-01 14:07:42,322
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long
, A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType 
, SUM(C.[S1]) AS [S1]
, SUM(ISNULL(C.[S1], 0)) AS Quantity
, SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount
INTO ##c66d334c2eb8489d80184a1c6724c92f
FROM [vn_Check] A 
INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID
INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID
INNER JOIN [##2d9418e14b514aa19a5f2bd5e399d7ee] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##56f7a67f0b74416f990d71a108036a57] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >='2021/8/1'
 AND CheckDate <='2021-08-31'
 GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long
, A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 


    时间: 2021-09-01 14:07:42,352
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##c66d334c2eb8489d80184a1c6724c92f a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-09-01 14:07:42,354
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c66d334c2eb8489d80184a1c6724c92f SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-09-01 14:07:42,358
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##c66d334c2eb8489d80184a1c6724c92f 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 = '退货' 


    时间: 2021-09-01 14:07:42,389
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c66d334c2eb8489d80184a1c6724c92f SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-09-01 14:07:42,390
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c66d334c2eb8489d80184a1c6724c92f SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-09-01 14:07:42,393
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##86cc4f1c0ad04405b74fd34cd74e972a(Customer_ID, Goods_No, ColorID, Long, [7DayCheckQuantity]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity) FROM ##7c8e79b6e4764c40b649664d5661e3dd
 WHERE CheckDate BETWEEN '2021/8/25'
AND '2021-08-31 23:59:59'  
GROUP BY Customer_ID, Goods_No, ColorID, Long
 INSERT INTO ##86cc4f1c0ad04405b74fd34cd74e972a(Customer_ID, Goods_No, ColorID, Long, [15DayCheckQuantity]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity) FROM ##7c8e79b6e4764c40b649664d5661e3dd
 WHERE CheckDate BETWEEN '2021/8/17'
AND '2021-08-31 23:59:59'  
GROUP BY Customer_ID, Goods_No, ColorID, Long
 INSERT INTO ##86cc4f1c0ad04405b74fd34cd74e972a(Customer_ID, Goods_No, ColorID, Long, [30DayCheckQuantity]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity) FROM ##7c8e79b6e4764c40b649664d5661e3dd
 WHERE CheckDate BETWEEN '2021/8/2'
AND '2021-08-31 23:59:59'  
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-09-01 14:07:42,401
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long 
     , MIN(a.Tin_Date) AS MinShopTinDate 
     , MAX(a.Tin_Date) AS MaxShopTinDate
INTO ##7509b60009a844b38274304930619680
FROM ShopTin A 
     INNER JOIN ShopTinGoods b on A.ShopTinID = B.ShopTinID 
     INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID 
WHERE A.Posted=1 
     AND EXISTS (SELECT 1 FROM [##2d9418e14b514aa19a5f2bd5e399d7ee] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##56f7a67f0b74416f990d71a108036a57] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2021-09-01 14:07:42,462
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long
, A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType 
, SUM(C.[S1]) AS [S1]
, SUM(ISNULL(C.[S1], 0)) AS Quantity
, SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount
INTO ##23570e80805d45ea9c4b199a8abceefd
FROM [vn_Check] A 
INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID
INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID
LEFT JOIN (SELECT T9.Customer_ID, T9.Goods_No, T9.ColorID, T9.Long, MIN(T9.MinShopTinDate) MinShopTinDate FROM ##7509b60009a844b38274304930619680 T9 GROUP BY T9.Customer_ID, T9.Goods_No, T9.ColorID, T9.Long) T ON B.Goods_No = T.Goods_No AND A.Customer_ID = T.Customer_ID AND T.ColorID=C.ColorID AND T.Long=C.Long
INNER JOIN [##2d9418e14b514aa19a5f2bd5e399d7ee] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##56f7a67f0b74416f990d71a108036a57] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= ISNULL(T.MinShopTinDate, '1990-01-01')
 AND CheckDate <='2021-08-31'
 GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long
, A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 


    时间: 2021-09-01 14:07:42,505
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##23570e80805d45ea9c4b199a8abceefd a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-09-01 14:07:42,507
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##23570e80805d45ea9c4b199a8abceefd SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-09-01 14:07:42,511
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##23570e80805d45ea9c4b199a8abceefd 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 = '退货' 


    时间: 2021-09-01 14:07:42,542
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##23570e80805d45ea9c4b199a8abceefd SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-09-01 14:07:42,543
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##23570e80805d45ea9c4b199a8abceefd SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-09-01 14:07:42,547
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##86cc4f1c0ad04405b74fd34cd74e972a(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity) FROM ##0e10db5900924b049e69f439a130b0e8
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-09-01 14:07:42,552
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.UnitPrice AS [吊牌价], SUM(A.[30DayCheckQuantity]) AS [月销售数量], SUM(A.[AllDayCheckQuantity]) AS [累销数量], SUM([渠道库存#数量]) AS [渠道库存], GS.Range AS [系列], SUM([销售#数量]) AS [销售]
INTO tempdb.dbo.[c9a9a89c-06e5-4639-96ef-8a3ca821cc28]
FROM ##86cc4f1c0ad04405b74fd34cd74e972a 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
         LEFT JOIN ##7509b60009a844b38274304930619680 T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0

GROUP BY  A.Goods_No, GS.Goods_Name, GS.UnitPrice, GS.Range

ORDER BY  A.Goods_No, GS.Goods_Name, GS.UnitPrice, GS.Range


    时间: 2021-09-01 14:14:35,363
  线程ID: 19
日志级别: 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 INT) AS [15DayCheckQuantity]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , 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 [##d6a1f13c959141c598f72c696dac5a9e]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-09-01 14:14:35,987
  线程ID: 19
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##99e9d8d7648344be808de02d727e7846] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-09-01 14:14:35,992
  线程ID: 19
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##d6a1f13c959141c598f72c696dac5a9e] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##99e9d8d7648344be808de02d727e7846]


    时间: 2021-09-01 14:14:36,124
  线程ID: 19
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##7d7c47558d81480d85a32a044c751bb9 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-09-01 14:14:36,202
  线程ID: 19
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##7d7c47558d81480d85a32a044c751bb9 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-09-01 14:14:36,217
  线程ID: 19
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##7d7c47558d81480d85a32a044c751bb9 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 = '退货' 


    时间: 2021-09-01 14:14:36,260
  线程ID: 19
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##7d7c47558d81480d85a32a044c751bb9 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-09-01 14:14:36,263
  线程ID: 19
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##7d7c47558d81480d85a32a044c751bb9 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-09-01 14:14:36,296
  线程ID: 19
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##d6a1f13c959141c598f72c696dac5a9e] (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 [##5a28bef401ab4e22b48a8da339fd3d39]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-09-01 14:14:36,327
  线程ID: 19
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称]
INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e]
FROM ##d6a1f13c959141c598f72c696dac5a9e 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  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END

ORDER BY  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END


    时间: 2021-09-01 14:32:16,746
  线程ID: 84
日志级别: 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 INT) AS [15DayCheckQuantity]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , 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 [##f14c0094001c455eafe8bd09d672504a]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-09-01 14:32:17,081
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##bcdb9723d3b9439eab453b7ed7475e79] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-09-01 14:32:17,083
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##f14c0094001c455eafe8bd09d672504a] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##bcdb9723d3b9439eab453b7ed7475e79]


    时间: 2021-09-01 14:32:17,154
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##c89a4ba2b6cb4eba8d8669b6532d5b89 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-09-01 14:32:17,156
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c89a4ba2b6cb4eba8d8669b6532d5b89 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-09-01 14:32:17,160
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##c89a4ba2b6cb4eba8d8669b6532d5b89 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 = '退货' 


    时间: 2021-09-01 14:32:17,188
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c89a4ba2b6cb4eba8d8669b6532d5b89 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-09-01 14:32:17,190
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c89a4ba2b6cb4eba8d8669b6532d5b89 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-09-01 14:32:17,194
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##f14c0094001c455eafe8bd09d672504a] (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 [##8378f33b5d3e47fdacd70ae7209aecf1]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-09-01 14:32:17,199
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称]
INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e]
FROM ##f14c0094001c455eafe8bd09d672504a 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  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END

ORDER BY  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END


    时间: 2021-09-01 14:33:09,051
  线程ID: 88
日志级别: 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 INT) AS [15DayCheckQuantity]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , 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 [##722476126b704d2a86f57a1b7f350c00]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-09-01 14:33:09,401
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##b4e5ed89fb1b46a4b386f3d484d46299] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-09-01 14:33:09,403
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##722476126b704d2a86f57a1b7f350c00] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##b4e5ed89fb1b46a4b386f3d484d46299]


    时间: 2021-09-01 14:33:09,483
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##7de09fd0a616443a8dd59a29047178e7 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-09-01 14:33:09,485
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##7de09fd0a616443a8dd59a29047178e7 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-09-01 14:33:09,488
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##7de09fd0a616443a8dd59a29047178e7 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 = '退货' 


    时间: 2021-09-01 14:33:09,517
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##7de09fd0a616443a8dd59a29047178e7 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-09-01 14:33:09,519
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##7de09fd0a616443a8dd59a29047178e7 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-09-01 14:33:09,521
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##722476126b704d2a86f57a1b7f350c00] (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 [##bb41d32d0eb444479ca220ced53de0eb]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-09-01 14:33:09,526
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称]
INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e]
FROM ##722476126b704d2a86f57a1b7f350c00 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  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END

ORDER BY  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END


    时间: 2021-09-01 14:33:40,483
  线程ID: 84
日志级别: 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 INT) AS [15DayCheckQuantity]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , 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 [##ae9832bf88e84ac7b2ab5662f29a0650]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-09-01 14:33:40,859
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##fe1495b065964735b10480746da7fa94] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-09-01 14:33:40,862
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##ae9832bf88e84ac7b2ab5662f29a0650] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##fe1495b065964735b10480746da7fa94]


    时间: 2021-09-01 14:33:40,939
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##e1fdfd5dbc9546a4af40871415d08dde a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-09-01 14:33:40,941
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##e1fdfd5dbc9546a4af40871415d08dde SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-09-01 14:33:40,944
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##e1fdfd5dbc9546a4af40871415d08dde 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 = '退货' 


    时间: 2021-09-01 14:33:40,976
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##e1fdfd5dbc9546a4af40871415d08dde SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-09-01 14:33:40,978
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##e1fdfd5dbc9546a4af40871415d08dde SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-09-01 14:33:40,981
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##ae9832bf88e84ac7b2ab5662f29a0650] (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 [##6baf56c5f6e1423f98485e89e1d48a2e]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-09-01 14:33:40,987
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称]
INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e]
FROM ##ae9832bf88e84ac7b2ab5662f29a0650 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  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END

ORDER BY  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END


    时间: 2021-09-01 14:33:58,771
  线程ID: 73
日志级别: 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 INT) AS [15DayCheckQuantity]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , 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 [##91ab04a3578947f7aa546b3c08a68a22]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-09-01 14:33:59,122
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##f2e3c05ae3a844079b71c7649b495a3e] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-09-01 14:33:59,124
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##91ab04a3578947f7aa546b3c08a68a22] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##f2e3c05ae3a844079b71c7649b495a3e]


    时间: 2021-09-01 14:33:59,198
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##510f1731d5da4401bc6b51abca6b1ae7 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-09-01 14:33:59,201
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##510f1731d5da4401bc6b51abca6b1ae7 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-09-01 14:33:59,205
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##510f1731d5da4401bc6b51abca6b1ae7 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 = '退货' 


    时间: 2021-09-01 14:33:59,237
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##510f1731d5da4401bc6b51abca6b1ae7 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-09-01 14:33:59,239
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##510f1731d5da4401bc6b51abca6b1ae7 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-09-01 14:33:59,242
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##91ab04a3578947f7aa546b3c08a68a22] (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 [##be5f86009a1d473b818894cb29b01a27]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-09-01 14:33:59,247
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称]
INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e]
FROM ##91ab04a3578947f7aa546b3c08a68a22 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  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END

ORDER BY  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END


    时间: 2021-09-01 14:34:46,118
  线程ID: 27
日志级别: 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 INT) AS [15DayCheckQuantity]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , 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 [##4b24ce60c40c4e2e988ccb79c6f59039]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-09-01 14:34:46,458
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##93b8cac593184e12b90e3b057a9e1775] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-09-01 14:34:46,460
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##4b24ce60c40c4e2e988ccb79c6f59039] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##93b8cac593184e12b90e3b057a9e1775]


    时间: 2021-09-01 14:34:46,530
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##16675385da8642e68aad2e5c00616423 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-09-01 14:34:46,532
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##16675385da8642e68aad2e5c00616423 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-09-01 14:34:46,537
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##16675385da8642e68aad2e5c00616423 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 = '退货' 


    时间: 2021-09-01 14:34:46,568
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##16675385da8642e68aad2e5c00616423 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-09-01 14:34:46,568
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##16675385da8642e68aad2e5c00616423 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-09-01 14:34:46,573
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##4b24ce60c40c4e2e988ccb79c6f59039] (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 [##f45fc728ea4740239ec1b553e0b712a1]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-09-01 14:34:46,579
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称]
INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e]
FROM ##4b24ce60c40c4e2e988ccb79c6f59039 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  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END

ORDER BY  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END


    时间: 2021-09-01 14:38:33,860
  线程ID: 73
日志级别: 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 INT) AS [15DayCheckQuantity]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , 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 [##bb52fb42d3e34334b954df7f1b3bede9]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-09-01 14:38:34,185
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##ceefe304d2ad42248fc595fea2301e5b] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-09-01 14:38:34,187
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##bb52fb42d3e34334b954df7f1b3bede9] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##ceefe304d2ad42248fc595fea2301e5b]


    时间: 2021-09-01 14:38:34,261
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##462d00f2bf374cb28bfe30d56d0b13af a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-09-01 14:38:34,264
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##462d00f2bf374cb28bfe30d56d0b13af SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-09-01 14:38:34,268
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##462d00f2bf374cb28bfe30d56d0b13af 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 = '退货' 


    时间: 2021-09-01 14:38:34,302
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##462d00f2bf374cb28bfe30d56d0b13af SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-09-01 14:38:34,304
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##462d00f2bf374cb28bfe30d56d0b13af SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-09-01 14:38:34,308
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##bb52fb42d3e34334b954df7f1b3bede9] (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 [##ee982f022bf5427b9a12fcaa00c87a27]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-09-01 14:38:34,317
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称]
INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e]
FROM ##bb52fb42d3e34334b954df7f1b3bede9 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  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END

ORDER BY  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END