时间: 2021-12-27 08:50:14,158
  线程ID: 69
日志级别: 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 [##7a111699caae4ad6b1fa13933b108c8c]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-12-27 08:50:14,641
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##140f6558dc5a489e97559557232eab41] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-12-27 08:50:14,644
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##7a111699caae4ad6b1fa13933b108c8c] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##140f6558dc5a489e97559557232eab41]


    时间: 2021-12-27 08:50:14,705
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##7789d5c351e743d3a2069841d8363043 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-12-27 08:50:14,707
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##7789d5c351e743d3a2069841d8363043 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-12-27 08:50:14,710
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##7789d5c351e743d3a2069841d8363043 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-12-27 08:50:14,744
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##7789d5c351e743d3a2069841d8363043 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-12-27 08:50:14,745
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##7789d5c351e743d3a2069841d8363043 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-12-27 08:50:14,749
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##7a111699caae4ad6b1fa13933b108c8c] (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 [##8eca66d33e71486681a5e00b4b2b050e]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-12-27 08:50:14,756
  线程ID: 69
日志级别: 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 ##9c66e1bb27a2417d84b84fb5e8ebe18c
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 [##610285d51db04537bd905cf80e4c6ae0] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##046cd23ddc7940d7bb982399798cb3d5] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >='2021/11/21'
 AND CheckDate <='2021-12-21'
 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-12-27 08:50:14,785
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##9c66e1bb27a2417d84b84fb5e8ebe18c a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-12-27 08:50:14,788
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##9c66e1bb27a2417d84b84fb5e8ebe18c SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-12-27 08:50:14,791
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##9c66e1bb27a2417d84b84fb5e8ebe18c 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-12-27 08:50:14,824
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##9c66e1bb27a2417d84b84fb5e8ebe18c SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-12-27 08:50:14,825
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##9c66e1bb27a2417d84b84fb5e8ebe18c SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-12-27 08:50:14,828
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##7a111699caae4ad6b1fa13933b108c8c(Customer_ID, Goods_No, ColorID, Long, [7DayCheckQuantity], [7DayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##96c8001574544bca81763ea7bac1324e
 WHERE CheckDate BETWEEN '2021/12/15'
AND '2021-12-21 23:59:59'  
GROUP BY Customer_ID, Goods_No, ColorID, Long
 INSERT INTO ##7a111699caae4ad6b1fa13933b108c8c(Customer_ID, Goods_No, ColorID, Long, [15DayCheckQuantity], [15DayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##96c8001574544bca81763ea7bac1324e
 WHERE CheckDate BETWEEN '2021/12/7'
AND '2021-12-21 23:59:59'  
GROUP BY Customer_ID, Goods_No, ColorID, Long
 INSERT INTO ##7a111699caae4ad6b1fa13933b108c8c(Customer_ID, Goods_No, ColorID, Long, [30DayCheckQuantity], [30DayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##96c8001574544bca81763ea7bac1324e
 WHERE CheckDate BETWEEN '2021/11/22'
AND '2021-12-21 23:59:59'  
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-12-27 08:50:14,837
  线程ID: 69
日志级别: 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 ##983f3e9c74644cef8f5b9662f3d6ee1e
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 [##610285d51db04537bd905cf80e4c6ae0] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##046cd23ddc7940d7bb982399798cb3d5] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2021-12-27 08:50:14,909
  线程ID: 69
日志级别: 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 ##760dbb8c33ff491cb72a619df3530a19
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 [##610285d51db04537bd905cf80e4c6ae0] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##046cd23ddc7940d7bb982399798cb3d5] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2021-12-21'
 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-12-27 08:50:14,946
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##760dbb8c33ff491cb72a619df3530a19 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-12-27 08:50:14,949
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##760dbb8c33ff491cb72a619df3530a19 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-12-27 08:50:14,952
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##760dbb8c33ff491cb72a619df3530a19 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-12-27 08:50:14,985
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##760dbb8c33ff491cb72a619df3530a19 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-12-27 08:50:14,987
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##760dbb8c33ff491cb72a619df3530a19 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-12-27 08:50:14,989
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##7a111699caae4ad6b1fa13933b108c8c(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##82b70bffccb44430bdb59eb987eed5c1
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-12-27 08:50:14,996
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long 
     , MAX(a.Tin_Date) AS MaxLoadInDate
INTO ##2e31db52bb4c4d7584651e098e758aba
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 Type = 2
     AND EXISTS (SELECT 1 FROM [##610285d51db04537bd905cf80e4c6ae0] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##046cd23ddc7940d7bb982399798cb3d5] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2021-12-27 08:50:15,070
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.Customer_ID, B.Goods_No, C.ColorID, C.Long 
     , MAX(a.CheckDate) AS MaxCheckDate
INTO ##a92ee23bb9c64284821598f85c751c68
FROM [vn_Check] A
     INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID
     INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID
WHERE A.Posted=1 
     AND EXISTS (SELECT 1 FROM [##610285d51db04537bd905cf80e4c6ae0] WHERE Customer_ID = A.Customer_ID)
     AND EXISTS (SELECT 1 FROM [##046cd23ddc7940d7bb982399798cb3d5] WHERE Goods_No = B.Goods_No)
GROUP BY  a.Customer_ID, b.Goods_No, C.ColorID, C.Long


    时间: 2021-12-27 08:50:15,166
  线程ID: 69
日志级别: 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 [货品名称], MAX(T7.MaxLoadInDate) AS [最后调入日期], MAX(T8.MaxCheckDate) AS [最后销售日期], SUM(A.[30DayCheckQuantity]) AS [月销售数量], SUM(A.[30DayCheckAmount]) AS [月销售生意额], SUM(A.[AllDayCheckQuantity]) AS [累销数量], SUM(A.[AllDayCheckAmount]) AS [累销售生意额], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END  AS [存销比],  DATEDIFF ( day,  MIN(T9.MinShopTinDate),getdate()) as 在店天数, GS.UnitPrice AS [吊牌价]
INTO tempdb.dbo.[b41e9446-41a6-4d78-91e4-a39c991b0c2a]
FROM ##7a111699caae4ad6b1fa13933b108c8c 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 ##983f3e9c74644cef8f5b9662f3d6ee1e 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
         LEFT JOIN ##2e31db52bb4c4d7584651e098e758aba T7 ON A.Goods_No = T7.Goods_No AND A.Customer_ID = T7.Customer_ID AND T7.ColorID=A.ColorID AND T7.Long=A.Long AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN ##a92ee23bb9c64284821598f85c751c68 T8 ON A.Goods_No = T8.Goods_No AND A.Customer_ID = T8.Customer_ID AND T8.ColorID=A.ColorID AND T8.Long=A.Long AND ISNULL(A.ItemType,0) = 0

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, GS.UnitPrice

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, GS.UnitPrice


    时间: 2021-12-27 08:50:58,435
  线程ID: 71
日志级别: 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 [##7efd38cba9364114a441da30dfbb3d73]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-12-27 08:50:58,789
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##41605c61178649a385fad451b24d05c1] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-12-27 08:50:58,790
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##7efd38cba9364114a441da30dfbb3d73] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##41605c61178649a385fad451b24d05c1]


    时间: 2021-12-27 08:50:58,857
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##45157c3bf13546fe8b15ca2a1764eeac a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-12-27 08:50:58,859
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##45157c3bf13546fe8b15ca2a1764eeac SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-12-27 08:50:58,862
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##45157c3bf13546fe8b15ca2a1764eeac 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-12-27 08:50:58,893
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##45157c3bf13546fe8b15ca2a1764eeac SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-12-27 08:50:58,894
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##45157c3bf13546fe8b15ca2a1764eeac SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-12-27 08:50:58,898
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##7efd38cba9364114a441da30dfbb3d73] (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 [##93681737e24e4860bd797ed7d4074859]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-12-27 08:50:58,903
  线程ID: 71
日志级别: 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 ##8f5eea21ad454c3789df2b3aff7f90f7
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 [##a6ccade9dab94697a00506b45b0516e4] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##140b6deaae884288b39de51e2e6fda58] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >='2021/11/21'
 AND CheckDate <='2021-12-21'
 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-12-27 08:50:58,931
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##8f5eea21ad454c3789df2b3aff7f90f7 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-12-27 08:50:58,934
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##8f5eea21ad454c3789df2b3aff7f90f7 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-12-27 08:50:58,937
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##8f5eea21ad454c3789df2b3aff7f90f7 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-12-27 08:50:58,968
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##8f5eea21ad454c3789df2b3aff7f90f7 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-12-27 08:50:58,970
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##8f5eea21ad454c3789df2b3aff7f90f7 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-12-27 08:50:58,972
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##7efd38cba9364114a441da30dfbb3d73(Customer_ID, Goods_No, ColorID, Long, [7DayCheckQuantity], [7DayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##7f9cd2dc04074290b15290efca708cd6
 WHERE CheckDate BETWEEN '2021/12/15'
AND '2021-12-21 23:59:59'  
GROUP BY Customer_ID, Goods_No, ColorID, Long
 INSERT INTO ##7efd38cba9364114a441da30dfbb3d73(Customer_ID, Goods_No, ColorID, Long, [15DayCheckQuantity], [15DayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##7f9cd2dc04074290b15290efca708cd6
 WHERE CheckDate BETWEEN '2021/12/7'
AND '2021-12-21 23:59:59'  
GROUP BY Customer_ID, Goods_No, ColorID, Long
 INSERT INTO ##7efd38cba9364114a441da30dfbb3d73(Customer_ID, Goods_No, ColorID, Long, [30DayCheckQuantity], [30DayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##7f9cd2dc04074290b15290efca708cd6
 WHERE CheckDate BETWEEN '2021/11/22'
AND '2021-12-21 23:59:59'  
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-12-27 08:50:58,982
  线程ID: 71
日志级别: 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 ##47f76cc61f854057a8e93fe6fff08f20
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 [##a6ccade9dab94697a00506b45b0516e4] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##140b6deaae884288b39de51e2e6fda58] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2021-12-27 08:50:59,051
  线程ID: 71
日志级别: 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 ##15b1d12d5b57422ca63f62e457f666bc
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 [##a6ccade9dab94697a00506b45b0516e4] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##140b6deaae884288b39de51e2e6fda58] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2021-12-21'
 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-12-27 08:50:59,086
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##15b1d12d5b57422ca63f62e457f666bc a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-12-27 08:50:59,088
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##15b1d12d5b57422ca63f62e457f666bc SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-12-27 08:50:59,091
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##15b1d12d5b57422ca63f62e457f666bc 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-12-27 08:50:59,124
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##15b1d12d5b57422ca63f62e457f666bc SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-12-27 08:50:59,126
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##15b1d12d5b57422ca63f62e457f666bc SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-12-27 08:50:59,128
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##7efd38cba9364114a441da30dfbb3d73(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##46f7b90be2414f72a7e62db2db4a2d34
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-12-27 08:50:59,132
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long 
     , MAX(a.Tin_Date) AS MaxLoadInDate
INTO ##c61f8654f2ea49138f293e07c4b841e1
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 Type = 2
     AND EXISTS (SELECT 1 FROM [##a6ccade9dab94697a00506b45b0516e4] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##140b6deaae884288b39de51e2e6fda58] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2021-12-27 08:50:59,210
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.Customer_ID, B.Goods_No, C.ColorID, C.Long 
     , MAX(a.CheckDate) AS MaxCheckDate
INTO ##95b8881f1469461e9b4fe1b3a4034a12
FROM [vn_Check] A
     INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID
     INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID
WHERE A.Posted=1 
     AND EXISTS (SELECT 1 FROM [##a6ccade9dab94697a00506b45b0516e4] WHERE Customer_ID = A.Customer_ID)
     AND EXISTS (SELECT 1 FROM [##140b6deaae884288b39de51e2e6fda58] WHERE Goods_No = B.Goods_No)
GROUP BY  a.Customer_ID, b.Goods_No, C.ColorID, C.Long


    时间: 2021-12-27 08:50:59,297
  线程ID: 71
日志级别: 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 [货品名称], MAX(T7.MaxLoadInDate) AS [最后调入日期], MAX(T8.MaxCheckDate) AS [最后销售日期], SUM(A.[30DayCheckQuantity]) AS [月销售数量], SUM(A.[30DayCheckAmount]) AS [月销售生意额], SUM(A.[AllDayCheckQuantity]) AS [累销数量], SUM(A.[AllDayCheckAmount]) AS [累销售生意额], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END  AS [存销比],  DATEDIFF ( day,  MIN(T9.MinShopTinDate),getdate()) as 在店天数, GS.UnitPrice AS [吊牌价]
INTO tempdb.dbo.[b41e9446-41a6-4d78-91e4-a39c991b0c2a]
FROM ##7efd38cba9364114a441da30dfbb3d73 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 ##47f76cc61f854057a8e93fe6fff08f20 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
         LEFT JOIN ##c61f8654f2ea49138f293e07c4b841e1 T7 ON A.Goods_No = T7.Goods_No AND A.Customer_ID = T7.Customer_ID AND T7.ColorID=A.ColorID AND T7.Long=A.Long AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN ##95b8881f1469461e9b4fe1b3a4034a12 T8 ON A.Goods_No = T8.Goods_No AND A.Customer_ID = T8.Customer_ID AND T8.ColorID=A.ColorID AND T8.Long=A.Long AND ISNULL(A.ItemType,0) = 0

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, GS.UnitPrice

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, GS.UnitPrice


    时间: 2021-12-27 10:49:58,965
  线程ID: 32
日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##5e5afa006da84a0e917b7e76ebe2a381]
ORDER BY Goods_no


    时间: 2021-12-27 10:50:01,237
  线程ID: 29
日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##af539fa5dbf24b5e91336a89888569be]
ORDER BY Goods_no


    时间: 2021-12-27 13:01:27,767
  线程ID: 46
日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##287795bde9604b48959d84fc2c75a29d]
ORDER BY Goods_no


    时间: 2021-12-27 13:03:04,320
  线程ID: 50
日志级别: 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 [##ac263039abd5402bb805c5ed8aff4a65]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-12-27 13:03:04,648
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##3a33d050f55b4c6595ecd0a7f022b6f9] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-12-27 13:03:04,650
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##ac263039abd5402bb805c5ed8aff4a65] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##3a33d050f55b4c6595ecd0a7f022b6f9]


    时间: 2021-12-27 13:03:04,651
  线程ID: 50
日志级别: 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 ##1c2851b721054cf99857cdf37c081c70
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 [##83754dfdf0a44499a8fdeb88b1d0d8f1] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##acd80f66a970424fab9a8b42f301690b] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2021-12-27 13:03:04,714
  线程ID: 50
日志级别: 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 ##5c46b7d99c2c42fca727c43b9001b608
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 [##83754dfdf0a44499a8fdeb88b1d0d8f1] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##acd80f66a970424fab9a8b42f301690b] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2021-12-26'
 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-12-27 13:03:04,749
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##5c46b7d99c2c42fca727c43b9001b608 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-12-27 13:03:04,752
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##5c46b7d99c2c42fca727c43b9001b608 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-12-27 13:03:04,755
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##5c46b7d99c2c42fca727c43b9001b608 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-12-27 13:03:04,787
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##5c46b7d99c2c42fca727c43b9001b608 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-12-27 13:03:04,789
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##5c46b7d99c2c42fca727c43b9001b608 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-12-27 13:03:04,793
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##ac263039abd5402bb805c5ed8aff4a65(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##ba87fc999fb94dfcbe008aae82b0c555
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-12-27 13:03:04,798
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END  AS [存销比], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[1f5bece3-4c8a-4780-96f3-a6bbc983b9dd]
FROM ##ac263039abd5402bb805c5ed8aff4a65 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 ##1c2851b721054cf99857cdf37c081c70 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  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No

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


    时间: 2021-12-27 13:27:48,423
  线程ID: 82
日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##f397c0d44be24601954aaa6311388bac]
ORDER BY Goods_no


    时间: 2021-12-27 14:54:54,229
  线程ID: 44
日志级别: 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 [##a52d6d5d7b654d15b12d9b9a144504cf]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-12-27 14:54:54,588
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##9ceec97aacb84e00a8ae7379b7db6743] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-12-27 14:54:54,590
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##a52d6d5d7b654d15b12d9b9a144504cf] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##9ceec97aacb84e00a8ae7379b7db6743]


    时间: 2021-12-27 14:54:54,591
  线程ID: 44
日志级别: 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 ##37c0304a29454853ae93067e0e1ff2a2
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 [##1fa94efa2d184d8f9cd3ecb244c0245e] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##9d5bc32b69274a80afdd01503bb16f64] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2021-12-27 14:54:54,656
  线程ID: 44
日志级别: 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 ##6e4ecd8912c441838517dfeb5e244c85
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 [##1fa94efa2d184d8f9cd3ecb244c0245e] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##9d5bc32b69274a80afdd01503bb16f64] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2021-12-26'
 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-12-27 14:54:54,692
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##6e4ecd8912c441838517dfeb5e244c85 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-12-27 14:54:54,695
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6e4ecd8912c441838517dfeb5e244c85 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-12-27 14:54:54,698
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##6e4ecd8912c441838517dfeb5e244c85 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-12-27 14:54:54,741
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6e4ecd8912c441838517dfeb5e244c85 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-12-27 14:54:54,742
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6e4ecd8912c441838517dfeb5e244c85 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-12-27 14:54:54,746
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##a52d6d5d7b654d15b12d9b9a144504cf(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##09f12ec8df6549d596d762181c22a94c
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-12-27 14:54:54,752
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END  AS [存销比], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[1f5bece3-4c8a-4780-96f3-a6bbc983b9dd]
FROM ##a52d6d5d7b654d15b12d9b9a144504cf 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 ##37c0304a29454853ae93067e0e1ff2a2 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  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No

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


    时间: 2021-12-27 14:58:29,904
  线程ID: 38
日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##2a86853027c548e2bc292d02768aa15e]
ORDER BY Goods_no


    时间: 2021-12-27 16:46:01,703
  线程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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##e6675bb99cb843baa047686ec9d649ac]
ORDER BY Goods_no


    时间: 2021-12-27 16:46:16,337
  线程ID: 78
日志级别: 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 [##b795b6cc619b45578300c3d937082d67]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-12-27 16:46:16,712
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##781d22744abf454ba968cb8cc4713ad2] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-12-27 16:46:16,713
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b795b6cc619b45578300c3d937082d67] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##781d22744abf454ba968cb8cc4713ad2]


    时间: 2021-12-27 16:46:16,715
  线程ID: 78
日志级别: 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 ##2ac343318c6845b08a3b2fd08dc14c72
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 [##2cd5523c26a748ea9bb2b894ee9dd012] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##1ab611a897bc45fd85a0129ef8579a6b] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2021-12-27 16:46:16,780
  线程ID: 78
日志级别: 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 ##3e15d120ca43450d85208bf641044e27
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 [##2cd5523c26a748ea9bb2b894ee9dd012] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##1ab611a897bc45fd85a0129ef8579a6b] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2021-12-26'
 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-12-27 16:46:16,817
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##3e15d120ca43450d85208bf641044e27 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-12-27 16:46:16,820
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##3e15d120ca43450d85208bf641044e27 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-12-27 16:46:16,823
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##3e15d120ca43450d85208bf641044e27 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-12-27 16:46:16,855
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##3e15d120ca43450d85208bf641044e27 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-12-27 16:46:16,856
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##3e15d120ca43450d85208bf641044e27 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-12-27 16:46:16,859
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##b795b6cc619b45578300c3d937082d67(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##ddb519601308418183b11bad1af9d6b9
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-12-27 16:46:16,865
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END  AS [存销比], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[1f5bece3-4c8a-4780-96f3-a6bbc983b9dd]
FROM ##b795b6cc619b45578300c3d937082d67 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 ##2ac343318c6845b08a3b2fd08dc14c72 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  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No

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


    时间: 2021-12-27 17:42:08,356
  线程ID: 42
日志级别: 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 [##5b689294f9d546b19e3cdb5bfd63d76b]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-12-27 17:42:08,706
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##18ab4d4d019c436e870a9aee96d31324] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-12-27 17:42:08,708
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##5b689294f9d546b19e3cdb5bfd63d76b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##18ab4d4d019c436e870a9aee96d31324]


    时间: 2021-12-27 17:42:08,709
  线程ID: 42
日志级别: 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 ##4c85d84e1d1f4a1caa2b551dd6ddc47d
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 [##d8dd03defac0460c8926acef4cbba099] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##e46876c61f4e41ce929ce1872924134e] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2021-12-27 17:42:08,774
  线程ID: 42
日志级别: 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 ##2d7767c7d4044d9186f7c58f761d36b7
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 [##d8dd03defac0460c8926acef4cbba099] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##e46876c61f4e41ce929ce1872924134e] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2021-12-26'
 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-12-27 17:42:08,808
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##2d7767c7d4044d9186f7c58f761d36b7 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-12-27 17:42:08,810
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##2d7767c7d4044d9186f7c58f761d36b7 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-12-27 17:42:08,813
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##2d7767c7d4044d9186f7c58f761d36b7 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-12-27 17:42:08,842
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##2d7767c7d4044d9186f7c58f761d36b7 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-12-27 17:42:08,843
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##2d7767c7d4044d9186f7c58f761d36b7 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-12-27 17:42:08,847
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##5b689294f9d546b19e3cdb5bfd63d76b(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##31da13b11c7d4dbb841d6df5b234cdf4
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-12-27 17:42:08,852
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END  AS [存销比], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[1f5bece3-4c8a-4780-96f3-a6bbc983b9dd]
FROM ##5b689294f9d546b19e3cdb5bfd63d76b 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 ##4c85d84e1d1f4a1caa2b551dd6ddc47d 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  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No

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


    时间: 2021-12-27 18:45:08,274
  线程ID: 112
日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##f19232aa7fa04f37bdce1325b09ea2f9]
ORDER BY Goods_no


    时间: 2021-12-27 23:39:31,459
  线程ID: 15
日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##ce5370dd817a4b72887769f028007cf5]
ORDER BY Goods_no


    时间: 2021-12-27 23:39:37,353
  线程ID: 30
日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##cfe57f21bb2a408d974b78e343bbaaf9]
ORDER BY Goods_no


    时间: 2021-12-27 23:39:39,815
  线程ID: 109
日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##1a5da8738e7c4d16a061edf8d4150c87]
ORDER BY Goods_no


    时间: 2021-12-27 23:41:20,935
  线程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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##5da6aec9f9084143921c938761bef85b]
ORDER BY Goods_no


    时间: 2021-12-27 23:52:43,233
  线程ID: 89
日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##19a8f0547d4d4d1182d673f46c51d259]
ORDER BY Goods_no


    时间: 2021-12-27 23:53:22,100
  线程ID: 109
日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##01f2a996626440738edf59d239186489]
ORDER BY Goods_no


    时间: 2021-12-27 23:54:13,982
  线程ID: 94
日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##2226bf8eb52b4d7d89012d959c7b5c14]
ORDER BY Goods_no


    时间: 2021-12-27 23:55:00,137
  线程ID: 109
日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##d2b9cd7b2f094694b98b7db73216bbf3]
ORDER BY Goods_no


    时间: 2021-12-27 23:55:15,169
  线程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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##99a63e6528a247d3864e36e19805abcd]
ORDER BY Goods_no


    时间: 2021-12-27 23:57:05,187
  线程ID: 99
日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##2017c41f2bf94a049f8483042fd2bc75]
ORDER BY Goods_no


    时间: 2021-12-27 23:57:55,243
  线程ID: 32
日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##832b122012c743e39155ab62f5c0fbb9]
ORDER BY Goods_no


    时间: 2021-12-27 23:57:56,641
  线程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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##d4bfa7cd6a534a5f84e9cc0defb42b04]
ORDER BY Goods_no


    时间: 2021-12-27 23:59:11,837
  线程ID: 32
日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3]
FROM [##4b4806dac6bd4eb19e30a6ea26a56981]
ORDER BY Goods_no