时间: 2022-01-13 11:00:14,126
  线程ID: 83
日志级别: 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 [##33634db35cd64bda8cacfc809f56d62c]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-01-13 11:00:14,476
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##5e28edfac2a6468b9c205a950f343baa] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-01-13 11:00:14,478
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##33634db35cd64bda8cacfc809f56d62c] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##5e28edfac2a6468b9c205a950f343baa]


    时间: 2022-01-13 11:00:14,480
  线程ID: 83
日志级别: 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 ##cf7d410ee14244e882d001674c2084a9
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 [##aa448f4bd3ed487bbd027460ce12fe31] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##712c86136db9449b99b914a4a2a1b9c6] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2022-01-13 11:00:14,545
  线程ID: 83
日志级别: 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 ##c0bdba92be7643baafab35e88b9be9bd
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 [##aa448f4bd3ed487bbd027460ce12fe31] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##712c86136db9449b99b914a4a2a1b9c6] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2022-01-12'
 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 


    时间: 2022-01-13 11:00:14,578
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##c0bdba92be7643baafab35e88b9be9bd a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-01-13 11:00:14,581
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c0bdba92be7643baafab35e88b9be9bd SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-01-13 11:00:14,585
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##c0bdba92be7643baafab35e88b9be9bd 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 = '退货' 


    时间: 2022-01-13 11:00:14,615
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c0bdba92be7643baafab35e88b9be9bd SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-01-13 11:00:14,617
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c0bdba92be7643baafab35e88b9be9bd SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-01-13 11:00:14,620
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##33634db35cd64bda8cacfc809f56d62c(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##8fc591632c43445fb6f3347d70a7b777
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2022-01-13 11:00:14,642
  线程ID: 83
日志级别: 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 ##33634db35cd64bda8cacfc809f56d62c 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 ##cf7d410ee14244e882d001674c2084a9 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


    时间: 2022-01-13 11:00:24,902
  线程ID: 38
日志级别: 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 [##4982b3cc3d7e4f36866a1d845b29712d]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-01-13 11:00:25,234
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##08da7a6dfb024fada0c85fc636b657bf] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-01-13 11:00:25,235
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##4982b3cc3d7e4f36866a1d845b29712d] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##08da7a6dfb024fada0c85fc636b657bf]


    时间: 2022-01-13 11:00:25,236
  线程ID: 38
日志级别: 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 ##3f34c7bfb1264a0f936fdf35a3574741
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 [##dbc1cbbe28914e50a63737ba2481a347] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##fbefed1a3fdd4ee996328e9708a37a6d] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2022-01-13 11:00:25,298
  线程ID: 38
日志级别: 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 ##2cd49a13c75c47f98a920c4851e95de4
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 [##dbc1cbbe28914e50a63737ba2481a347] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##fbefed1a3fdd4ee996328e9708a37a6d] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2022-01-13'
 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 


    时间: 2022-01-13 11:00:25,330
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##2cd49a13c75c47f98a920c4851e95de4 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-01-13 11:00:25,332
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##2cd49a13c75c47f98a920c4851e95de4 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-01-13 11:00:25,336
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##2cd49a13c75c47f98a920c4851e95de4 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 = '退货' 


    时间: 2022-01-13 11:00:25,366
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##2cd49a13c75c47f98a920c4851e95de4 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-01-13 11:00:25,367
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##2cd49a13c75c47f98a920c4851e95de4 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-01-13 11:00:25,370
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##4982b3cc3d7e4f36866a1d845b29712d(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##a95e95a533204470bb00c96b3c31eec9
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2022-01-13 11:00:25,375
  线程ID: 38
日志级别: 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 ##4982b3cc3d7e4f36866a1d845b29712d 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 ##3f34c7bfb1264a0f936fdf35a3574741 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


    时间: 2022-01-13 11:00:34,673
  线程ID: 38
日志级别: 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 [##5d52fb4477224d4bb385c3cc9b8b061a]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-01-13 11:00:35,005
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##e52c3f6d3dc74146b15e250e8b68b4ad] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-01-13 11:00:35,006
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##5d52fb4477224d4bb385c3cc9b8b061a] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##e52c3f6d3dc74146b15e250e8b68b4ad]


    时间: 2022-01-13 11:00:35,007
  线程ID: 38
日志级别: 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 ##9ec1e8fbca54485b81c602a4d0ee2024
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 [##e32cca03ba434f868c2248aeed1f9000] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##8f5ffa29fee84972b974ea4e1135269c] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2022-01-13 11:00:35,068
  线程ID: 38
日志级别: 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 ##4515b96042da4fbebee4b85c787de2e2
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 [##e32cca03ba434f868c2248aeed1f9000] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##8f5ffa29fee84972b974ea4e1135269c] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2022-01-13'
 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 


    时间: 2022-01-13 11:00:35,101
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##4515b96042da4fbebee4b85c787de2e2 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-01-13 11:00:35,104
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4515b96042da4fbebee4b85c787de2e2 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-01-13 11:00:35,107
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##4515b96042da4fbebee4b85c787de2e2 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 = '退货' 


    时间: 2022-01-13 11:00:35,137
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4515b96042da4fbebee4b85c787de2e2 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-01-13 11:00:35,139
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4515b96042da4fbebee4b85c787de2e2 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-01-13 11:00:35,142
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##5d52fb4477224d4bb385c3cc9b8b061a(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##47dd3339af724fc1b0d1ced6008f84c0
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2022-01-13 11:00:35,146
  线程ID: 38
日志级别: 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 ##5d52fb4477224d4bb385c3cc9b8b061a 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 ##9ec1e8fbca54485b81c602a4d0ee2024 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


    时间: 2022-01-13 11:00:36,639
  线程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 [##35dc551f8ee34d2da3aea07c45beab8e]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-01-13 11:00:36,971
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##f79524bcf8494e5fa27513894ee17c3a] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-01-13 11:00:36,973
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##35dc551f8ee34d2da3aea07c45beab8e] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##f79524bcf8494e5fa27513894ee17c3a]


    时间: 2022-01-13 11:00:36,974
  线程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 ##5006689f37c04bf99d2f3b306b7f0b59
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 [##3f2cb63372254778a342e9de90c5aebd] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##f174142fe64f454aaca920a5dd1d1e48] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2022-01-13 11:00:37,036
  线程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 ##4d605df9b7c44d45ae4ce5cbd64b643c
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 [##3f2cb63372254778a342e9de90c5aebd] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##f174142fe64f454aaca920a5dd1d1e48] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2022-01-13'
 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 


    时间: 2022-01-13 11:00:37,067
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##4d605df9b7c44d45ae4ce5cbd64b643c a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-01-13 11:00:37,070
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4d605df9b7c44d45ae4ce5cbd64b643c SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-01-13 11:00:37,073
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##4d605df9b7c44d45ae4ce5cbd64b643c 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 = '退货' 


    时间: 2022-01-13 11:00:37,102
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4d605df9b7c44d45ae4ce5cbd64b643c SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-01-13 11:00:37,103
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4d605df9b7c44d45ae4ce5cbd64b643c SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-01-13 11:00:37,106
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##35dc551f8ee34d2da3aea07c45beab8e(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##67d1d0b96c514bdf8f4d0befaeb70c3e
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2022-01-13 11:00:37,112
  线程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 ##35dc551f8ee34d2da3aea07c45beab8e 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 ##5006689f37c04bf99d2f3b306b7f0b59 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


    时间: 2022-01-13 11:00:37,396
  线程ID: 38
日志级别: 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 [##b8487c5dcef44bad8d79e7f5bc25a64b]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-01-13 11:00:37,712
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##38fbe89eab6e4f1d841166c9d5beee25] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-01-13 11:00:37,713
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b8487c5dcef44bad8d79e7f5bc25a64b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##38fbe89eab6e4f1d841166c9d5beee25]


    时间: 2022-01-13 11:00:37,714
  线程ID: 38
日志级别: 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 ##feab5b6082974a328b76f10b70ca6887
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 [##573cb629d16242d880dfb9732dac2d58] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##50cf832f76eb4326a1ef96c139fecd70] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2022-01-13 11:00:37,776
  线程ID: 38
日志级别: 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 ##289358cad7954374aefd9f544fa28955
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 [##573cb629d16242d880dfb9732dac2d58] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##50cf832f76eb4326a1ef96c139fecd70] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2022-01-13'
 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 


    时间: 2022-01-13 11:00:37,807
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##289358cad7954374aefd9f544fa28955 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-01-13 11:00:37,810
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##289358cad7954374aefd9f544fa28955 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-01-13 11:00:37,821
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##289358cad7954374aefd9f544fa28955 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 = '退货' 


    时间: 2022-01-13 11:00:37,850
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##289358cad7954374aefd9f544fa28955 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-01-13 11:00:37,852
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##289358cad7954374aefd9f544fa28955 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-01-13 11:00:37,856
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##b8487c5dcef44bad8d79e7f5bc25a64b(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##1cc740bfde7944baaa4a6a7ba8e11483
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2022-01-13 11:00:37,860
  线程ID: 38
日志级别: 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 ##b8487c5dcef44bad8d79e7f5bc25a64b 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 ##feab5b6082974a328b76f10b70ca6887 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


    时间: 2022-01-13 11:00:38,079
  线程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 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 [##2f914aad53c74684ac5c8337faeb9b44]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-01-13 11:00:38,409
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##be822be5f2554b18bb5ae5b78a61ae15] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-01-13 11:00:38,411
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##2f914aad53c74684ac5c8337faeb9b44] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##be822be5f2554b18bb5ae5b78a61ae15]


    时间: 2022-01-13 11:00:38,412
  线程ID: 73
日志级别: 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 ##4bf38f2d27b1423097eb7e4b90ba9087
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 [##dbd1b4254b8c4bffafb3925085d79378] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##30818c0fede64eba891cca5041e8f3f7] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2022-01-13 11:00:38,473
  线程ID: 73
日志级别: 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 ##e51c0c00b29542d1ba3462d829bec5f5
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 [##dbd1b4254b8c4bffafb3925085d79378] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##30818c0fede64eba891cca5041e8f3f7] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2022-01-13'
 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 


    时间: 2022-01-13 11:00:38,505
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##e51c0c00b29542d1ba3462d829bec5f5 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-01-13 11:00:38,507
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##e51c0c00b29542d1ba3462d829bec5f5 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-01-13 11:00:38,510
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##e51c0c00b29542d1ba3462d829bec5f5 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 = '退货' 


    时间: 2022-01-13 11:00:38,539
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##e51c0c00b29542d1ba3462d829bec5f5 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-01-13 11:00:38,542
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##e51c0c00b29542d1ba3462d829bec5f5 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-01-13 11:00:38,545
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##2f914aad53c74684ac5c8337faeb9b44(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##58eef6d203e4490981af45cc7b39f173
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2022-01-13 11:00:38,550
  线程ID: 73
日志级别: 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 ##2f914aad53c74684ac5c8337faeb9b44 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 ##4bf38f2d27b1423097eb7e4b90ba9087 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


    时间: 2022-01-13 11:00:38,766
  线程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 [##7b393bbfbab54969b4d3bac9748e93a8]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-01-13 11:00:39,080
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##e08c2533c85a497bb349461e9d9f90f6] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-01-13 11:00:39,081
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##7b393bbfbab54969b4d3bac9748e93a8] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##e08c2533c85a497bb349461e9d9f90f6]


    时间: 2022-01-13 11:00:39,082
  线程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 ##b3c3563c18c84e5dbdf4bde610f79217
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 [##488ccfe11c344b0b9a060331fdb012d6] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##054f82e5c9944dafa8ba6b16ddced899] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2022-01-13 11:00:39,143
  线程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 ##b9aecdd7aeba4ae19c7cc80fa275e973
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 [##488ccfe11c344b0b9a060331fdb012d6] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##054f82e5c9944dafa8ba6b16ddced899] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2022-01-13'
 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 


    时间: 2022-01-13 11:00:39,175
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##b9aecdd7aeba4ae19c7cc80fa275e973 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-01-13 11:00:39,181
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b9aecdd7aeba4ae19c7cc80fa275e973 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-01-13 11:00:39,184
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##b9aecdd7aeba4ae19c7cc80fa275e973 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 = '退货' 


    时间: 2022-01-13 11:00:39,212
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b9aecdd7aeba4ae19c7cc80fa275e973 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-01-13 11:00:39,214
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b9aecdd7aeba4ae19c7cc80fa275e973 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-01-13 11:00:39,217
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##7b393bbfbab54969b4d3bac9748e93a8(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##1135caa8ddc044229f5856ac31209980
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2022-01-13 11:00:39,223
  线程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 ##7b393bbfbab54969b4d3bac9748e93a8 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 ##b3c3563c18c84e5dbdf4bde610f79217 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


    时间: 2022-01-13 12:43:27,812
  线程ID: 98
日志级别: 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 [##40c82cf284414c27aea88b2d1a87d5af]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-01-13 12:43:28,125
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##1c0e38df2c604004841ac18cd4b02960] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-01-13 12:43:28,127
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##40c82cf284414c27aea88b2d1a87d5af] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##1c0e38df2c604004841ac18cd4b02960]


    时间: 2022-01-13 12:43:28,128
  线程ID: 98
日志级别: 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 ##4297a0c84d9d4767afeb39566892d53c
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 [##9850f2ddbae042f9a9adc7b6b24e8ac7] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##5f2b263c5da64f8f9d7f07c3f5e65e0d] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2022-01-13 12:43:28,181
  线程ID: 98
日志级别: 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 ##71f9b6bdc8f64a738549055bf209f737
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 [##9850f2ddbae042f9a9adc7b6b24e8ac7] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##5f2b263c5da64f8f9d7f07c3f5e65e0d] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2022-01-13'
 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 


    时间: 2022-01-13 12:43:28,209
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##71f9b6bdc8f64a738549055bf209f737 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-01-13 12:43:28,210
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##71f9b6bdc8f64a738549055bf209f737 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-01-13 12:43:28,211
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##71f9b6bdc8f64a738549055bf209f737 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 = '退货' 


    时间: 2022-01-13 12:43:28,240
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##71f9b6bdc8f64a738549055bf209f737 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-01-13 12:43:28,241
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##71f9b6bdc8f64a738549055bf209f737 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-01-13 12:43:28,244
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##40c82cf284414c27aea88b2d1a87d5af(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##26c7befd2ecc4f50a75d0555463422dc
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2022-01-13 12:43:28,247
  线程ID: 98
日志级别: 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 ##40c82cf284414c27aea88b2d1a87d5af 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 ##4297a0c84d9d4767afeb39566892d53c 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


    时间: 2022-01-13 12:43:59,818
  线程ID: 102
日志级别: 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 [##4ddf20e330a247b7842c476e31abc627]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-01-13 12:44:00,153
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##61f92c258c734616a99315b2647e10d6] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-01-13 12:44:00,154
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##4ddf20e330a247b7842c476e31abc627] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##61f92c258c734616a99315b2647e10d6]


    时间: 2022-01-13 12:44:00,155
  线程ID: 102
日志级别: 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 ##6e1838e69ca74c4ba7aecf0386ce4fac
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 [##cc7172fa7b2b4e8194c2a7a0e1540427] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##e66c484fff9242cdb369b73cd7e7781b] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2022-01-13 12:44:00,217
  线程ID: 102
日志级别: 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 ##f1e9870c2a594f6fbdf4c369a5e722e4
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 [##cc7172fa7b2b4e8194c2a7a0e1540427] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##e66c484fff9242cdb369b73cd7e7781b] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2022-01-13'
 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 


    时间: 2022-01-13 12:44:00,249
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##f1e9870c2a594f6fbdf4c369a5e722e4 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-01-13 12:44:00,251
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f1e9870c2a594f6fbdf4c369a5e722e4 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-01-13 12:44:00,253
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##f1e9870c2a594f6fbdf4c369a5e722e4 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 = '退货' 


    时间: 2022-01-13 12:44:00,282
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f1e9870c2a594f6fbdf4c369a5e722e4 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-01-13 12:44:00,283
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f1e9870c2a594f6fbdf4c369a5e722e4 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-01-13 12:44:00,286
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##4ddf20e330a247b7842c476e31abc627(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##e4556cd24ba74140a160164adb420229
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2022-01-13 12:44:00,290
  线程ID: 102
日志级别: 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 ##4ddf20e330a247b7842c476e31abc627 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 ##6e1838e69ca74c4ba7aecf0386ce4fac 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


    时间: 2022-01-13 12:45:15,414
  线程ID: 104
日志级别: 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 [##8823844c045f4fa896f9b78ed51ea288]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-01-13 12:45:15,843
  线程ID: 104
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##e6fa9264ca6d42afafb6b6765834682e] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-01-13 12:45:15,846
  线程ID: 104
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##8823844c045f4fa896f9b78ed51ea288] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##e6fa9264ca6d42afafb6b6765834682e]


    时间: 2022-01-13 12:45:15,847
  线程ID: 104
日志级别: 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 ##90a7dd81718b4c96a58badcd5517ea2e
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 [##c69573aa61124956978bda5a36e77226] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##6270d95a20ea46ea81f0c19b3be4f509] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2022-01-13 12:45:15,913
  线程ID: 104
日志级别: 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 ##b86f93e81da44447baffa33712165b8d
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 [##c69573aa61124956978bda5a36e77226] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##6270d95a20ea46ea81f0c19b3be4f509] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2022-01-13'
 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 


    时间: 2022-01-13 12:45:15,947
  线程ID: 104
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##b86f93e81da44447baffa33712165b8d a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-01-13 12:45:15,950
  线程ID: 104
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b86f93e81da44447baffa33712165b8d SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-01-13 12:45:15,952
  线程ID: 104
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##b86f93e81da44447baffa33712165b8d 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 = '退货' 


    时间: 2022-01-13 12:45:15,984
  线程ID: 104
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b86f93e81da44447baffa33712165b8d SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-01-13 12:45:15,985
  线程ID: 104
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b86f93e81da44447baffa33712165b8d SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-01-13 12:45:15,988
  线程ID: 104
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##8823844c045f4fa896f9b78ed51ea288(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##f02e065929e8404fb1e92cc3af034716
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2022-01-13 12:45:15,993
  线程ID: 104
日志级别: 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 ##8823844c045f4fa896f9b78ed51ea288 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 ##90a7dd81718b4c96a58badcd5517ea2e 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


    时间: 2022-01-13 13:13:42,492
  线程ID: 103
日志级别: 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.[28ac41ea-b414-475e-95f4-e15ff5a0934c]
FROM [##03d40456e9ec4a3eb7a2e4d015aa4256]
ORDER BY Goods_no


    时间: 2022-01-13 13:13:50,000
  线程ID: 95
日志级别: 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.[28ac41ea-b414-475e-95f4-e15ff5a0934c]
FROM [##0cafa167acfc4eb08432bb3c2046c5ff]
ORDER BY Goods_no


    时间: 2022-01-13 13:14:45,138
  线程ID: 88
日志级别: 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.[28ac41ea-b414-475e-95f4-e15ff5a0934c]
FROM [##96f696050a6d47f38c04262319ffef17]
ORDER BY Goods_no


    时间: 2022-01-13 13:14:46,933
  线程ID: 88
日志级别: 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.[28ac41ea-b414-475e-95f4-e15ff5a0934c]
FROM [##08b2b0a3fc1f45d0ad44eb31455812be]
ORDER BY Goods_no


    时间: 2022-01-13 13:58:57,763
  线程ID: 73
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>Vip</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>Customer_ID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>billdatebegin</ID>
    <Caption />
    <Data>2020-01-13</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2022-01-10</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__vip__>
    <ID>userno</ID>
    <Caption />
    <Data>SYSTEM</Data>
    <ConditionType>0</ConditionType>
  </__vip__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>SYSTEM</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>SYSTEM</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <OutputData>
    <ID>2</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP卡号</FieldName>
    <Expression>A.VIP</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>1</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>3</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP姓名</FieldName>
    <Expression>A.Name</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>2</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>5</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>发卡店铺简称</FieldName>
    <Expression>CT.Abbrev</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>3</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>8</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>注册渠道简称</FieldName>
    <Expression>OT.Abbrev</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>4</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>10</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>发卡日期</FieldName>
    <Expression>CONVERT(VARCHAR(10), A.BegainDate, 120)</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>5</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>11</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>失效日期</FieldName>
    <Expression>CONVERT(VARCHAR(10), A.ExpireDate, 120)</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>6</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>14</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>出生日期</FieldName>
    <Expression>CONVERT(VARCHAR(10), A.BirthDate, 120)</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>7</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>13</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>性别</FieldName>
    <Expression>A.Sex</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>8</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>20</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>电话</FieldName>
    <Expression>A.Tel</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>9</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>46</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP等级</FieldName>
    <Expression>A.Vipgrade</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>10</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>47</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP等级折扣</FieldName>
    <Expression>C.Discount</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>11</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>49</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>营业员编号</FieldName>
    <Expression>A.BusinessManID</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>12</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>50</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>营业员姓名</FieldName>
    <Expression>BM.Name</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>13</OrderIndex>
  </OutputData>
</NewDataSet>

    时间: 2022-01-13 13:58:57,774
  线程ID: 73
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##0ed050e85d6b49d3b2991fc7511d9c97]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2022-01-13 13:59:32,073
  线程ID: 84
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>Vip</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>Customer_ID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>billdatebegin</ID>
    <Caption />
    <Data>2020-01-13</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2022-01-10</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__vip__>
    <ID>userno</ID>
    <Caption />
    <Data>SYSTEM</Data>
    <ConditionType>0</ConditionType>
  </__vip__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>SYSTEM</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>SYSTEM</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <OutputData>
    <ID>2</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP卡号</FieldName>
    <Expression>A.VIP</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>1</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>3</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP姓名</FieldName>
    <Expression>A.Name</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>2</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>5</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>发卡店铺简称</FieldName>
    <Expression>CT.Abbrev</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>3</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>8</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>注册渠道简称</FieldName>
    <Expression>OT.Abbrev</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>4</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>10</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>发卡日期</FieldName>
    <Expression>CONVERT(VARCHAR(10), A.BegainDate, 120)</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>5</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>11</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>失效日期</FieldName>
    <Expression>CONVERT(VARCHAR(10), A.ExpireDate, 120)</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>6</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>14</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>出生日期</FieldName>
    <Expression>CONVERT(VARCHAR(10), A.BirthDate, 120)</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>7</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>13</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>性别</FieldName>
    <Expression>A.Sex</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>8</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>46</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP等级</FieldName>
    <Expression>A.Vipgrade</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>10</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>47</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP等级折扣</FieldName>
    <Expression>C.Discount</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>11</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>45</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>移动电话</FieldName>
    <Expression>A.MobileTel</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>14</OrderIndex>
  </OutputData>
</NewDataSet>

    时间: 2022-01-13 13:59:32,076
  线程ID: 84
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##b7a73b606235492d8e206136aaaa14c9]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2022-01-13 14:46:05,434
  线程ID: 7
日志级别: 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.[28ac41ea-b414-475e-95f4-e15ff5a0934c]
FROM [##7c9c888ed3754cc685b4c4c75f690ec9]
ORDER BY Goods_no


    时间: 2022-01-13 14:47:19,400
  线程ID: 65
日志级别: 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.[28ac41ea-b414-475e-95f4-e15ff5a0934c]
FROM [##9f7028078fb448be9228a47d7497ea42]
ORDER BY Goods_no


    时间: 2022-01-13 14:47:39,493
  线程ID: 72
日志级别: 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 [##ab544856491945d5a9822ae6436d256f]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-01-13 14:47:39,873
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##f7b4d112751045b1b293da6b9cbde9db] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-01-13 14:47:39,875
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##ab544856491945d5a9822ae6436d256f] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##f7b4d112751045b1b293da6b9cbde9db]


    时间: 2022-01-13 14:47:39,876
  线程ID: 72
日志级别: 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 ##4b0c022258904205aa6879aa0cb28297
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 [##a190be2f8cc94252bbd6b3e95b5afd16] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##2f0033fb7d4d4f3a971f4bdc169a25f7] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2022-01-13 14:47:39,943
  线程ID: 72
日志级别: 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 ##806fedd2d03e49ef826e53810cce73a2
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 [##a190be2f8cc94252bbd6b3e95b5afd16] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##2f0033fb7d4d4f3a971f4bdc169a25f7] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2022-01-13'
 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 


    时间: 2022-01-13 14:47:39,977
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##806fedd2d03e49ef826e53810cce73a2 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-01-13 14:47:39,980
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##806fedd2d03e49ef826e53810cce73a2 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-01-13 14:47:39,983
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##806fedd2d03e49ef826e53810cce73a2 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 = '退货' 


    时间: 2022-01-13 14:47:40,016
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##806fedd2d03e49ef826e53810cce73a2 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-01-13 14:47:40,017
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##806fedd2d03e49ef826e53810cce73a2 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-01-13 14:47:40,021
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##ab544856491945d5a9822ae6436d256f(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##ae0f8a097abb48b5a1e12be785c4a57a
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2022-01-13 14:47:40,026
  线程ID: 72
日志级别: 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 ##ab544856491945d5a9822ae6436d256f 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 ##4b0c022258904205aa6879aa0cb28297 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


    时间: 2022-01-13 14:48:42,546
  线程ID: 65
日志级别: 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 [##c1e76b4dd06a496ca7485507c8f47e59]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-01-13 14:48:42,945
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##f68f96326d65470f94fed99ed0ec0954] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-01-13 14:48:42,947
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##c1e76b4dd06a496ca7485507c8f47e59] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##f68f96326d65470f94fed99ed0ec0954]


    时间: 2022-01-13 14:48:42,948
  线程ID: 65
日志级别: 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 ##3b2c4b86fdb84cd79b91ede7e84612f3
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 [##7ad28f8d4e7d4061906e610379a6441d] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##20dd987101c74241867dc3da929c3ebc] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2022-01-13 14:48:43,019
  线程ID: 65
日志级别: 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 ##5f75cd747dcf49eebab03e3f65bdec57
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 [##7ad28f8d4e7d4061906e610379a6441d] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##20dd987101c74241867dc3da929c3ebc] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2022-01-13'
 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 


    时间: 2022-01-13 14:48:43,058
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##5f75cd747dcf49eebab03e3f65bdec57 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-01-13 14:48:43,061
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##5f75cd747dcf49eebab03e3f65bdec57 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-01-13 14:48:43,064
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##5f75cd747dcf49eebab03e3f65bdec57 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 = '退货' 


    时间: 2022-01-13 14:48:43,106
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##5f75cd747dcf49eebab03e3f65bdec57 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-01-13 14:48:43,107
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##5f75cd747dcf49eebab03e3f65bdec57 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-01-13 14:48:43,111
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##c1e76b4dd06a496ca7485507c8f47e59(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##4a1691cfe3254eaca5933d9afece9e82
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2022-01-13 14:48:43,116
  线程ID: 65
日志级别: 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 ##c1e76b4dd06a496ca7485507c8f47e59 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 ##3b2c4b86fdb84cd79b91ede7e84612f3 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


    时间: 2022-01-13 15:06:11,364
  线程ID: 67
日志级别: 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.[28ac41ea-b414-475e-95f4-e15ff5a0934c]
FROM [##dc37bf45cb534bac9004b3558216b0ae]
ORDER BY Goods_no


    时间: 2022-01-13 15:06:29,664
  线程ID: 79
日志级别: 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 [##818f9d8f24304a23a9189b9c3d355028]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-01-13 15:06:30,004
  线程ID: 79
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##f7d1b087c2854ebb9cdf915621c139bc] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-01-13 15:06:30,005
  线程ID: 79
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##818f9d8f24304a23a9189b9c3d355028] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##f7d1b087c2854ebb9cdf915621c139bc]


    时间: 2022-01-13 15:06:30,007
  线程ID: 79
日志级别: 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 ##748d68850b444e34a2b2374b84463468
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 [##eb9fc436e2b345749859fb35fc8ba246] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##96360530c2214d0f8279b183886e9023] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2022-01-13 15:06:30,068
  线程ID: 79
日志级别: 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 ##98c6eada6db142979860594aa8c9d3e4
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 [##eb9fc436e2b345749859fb35fc8ba246] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##96360530c2214d0f8279b183886e9023] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2022-01-13'
 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 


    时间: 2022-01-13 15:06:30,100
  线程ID: 79
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##98c6eada6db142979860594aa8c9d3e4 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-01-13 15:06:30,103
  线程ID: 79
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##98c6eada6db142979860594aa8c9d3e4 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-01-13 15:06:30,106
  线程ID: 79
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##98c6eada6db142979860594aa8c9d3e4 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 = '退货' 


    时间: 2022-01-13 15:06:30,136
  线程ID: 79
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##98c6eada6db142979860594aa8c9d3e4 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-01-13 15:06:30,138
  线程ID: 79
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##98c6eada6db142979860594aa8c9d3e4 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-01-13 15:06:30,141
  线程ID: 79
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##818f9d8f24304a23a9189b9c3d355028(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##2a0d6c1ef5284ec6b9c6fc1cd9011340
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2022-01-13 15:06:30,146
  线程ID: 79
日志级别: 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 ##818f9d8f24304a23a9189b9c3d355028 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 ##748d68850b444e34a2b2374b84463468 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


    时间: 2022-01-13 15:54:05,393
  线程ID: 36
日志级别: 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.[28ac41ea-b414-475e-95f4-e15ff5a0934c]
FROM [##a4c8b06681854089a46bd84974da237a]
ORDER BY Goods_no


    时间: 2022-01-13 15:54:16,392
  线程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 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 [##6d84a75c651d4cc49ca981b17218e2b2]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-01-13 15:54:16,763
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##fc0c6796fd424d7b8c4e88430d4dc282] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-01-13 15:54:16,765
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##6d84a75c651d4cc49ca981b17218e2b2] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##fc0c6796fd424d7b8c4e88430d4dc282]


    时间: 2022-01-13 15:54:16,766
  线程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 ##8301aaacd1be4992834f9f4da86cfad9
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 [##001b3338de004a9fbdcc80d6bc8d3691] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##057dc7d611484a63b61f346d327cbad7] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2022-01-13 15:54:16,827
  线程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 ##893da714060a4850ad09f511ca8e9faf
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 [##001b3338de004a9fbdcc80d6bc8d3691] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##057dc7d611484a63b61f346d327cbad7] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2022-01-13'
 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 


    时间: 2022-01-13 15:54:16,858
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##893da714060a4850ad09f511ca8e9faf a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-01-13 15:54:16,860
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##893da714060a4850ad09f511ca8e9faf SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-01-13 15:54:16,862
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##893da714060a4850ad09f511ca8e9faf 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 = '退货' 


    时间: 2022-01-13 15:54:16,890
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##893da714060a4850ad09f511ca8e9faf SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-01-13 15:54:16,891
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##893da714060a4850ad09f511ca8e9faf SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-01-13 15:54:16,895
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##6d84a75c651d4cc49ca981b17218e2b2(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##e88a4853a45249b1a82869beec5cf43d
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2022-01-13 15:54:16,899
  线程ID: 36
日志级别: 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 ##6d84a75c651d4cc49ca981b17218e2b2 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 ##8301aaacd1be4992834f9f4da86cfad9 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


    时间: 2022-01-13 21:14:33,571
  线程ID: 84
日志级别: 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.[28ac41ea-b414-475e-95f4-e15ff5a0934c]
FROM [##9437d2998d5947ca990adf3a77b13ed2]
ORDER BY Goods_no


    时间: 2022-01-13 21:18:58,451
  线程ID: 84
日志级别: 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.[28ac41ea-b414-475e-95f4-e15ff5a0934c]
FROM [##0feab38e8d7f4c1cbbf9b857d1987225]
ORDER BY Goods_no


    时间: 2022-01-13 21:19:14,766
  线程ID: 70
日志级别: 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 [##7ac84d6c64ee454fa50c4ac19716895b]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-01-13 21:19:15,140
  线程ID: 70
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##c262004c1ca84e51a3dc6fe9549fa342] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-01-13 21:19:15,141
  线程ID: 70
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##7ac84d6c64ee454fa50c4ac19716895b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##c262004c1ca84e51a3dc6fe9549fa342]


    时间: 2022-01-13 21:19:15,143
  线程ID: 70
日志级别: 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 ##4b32945440154d26b1737dca52cce53b
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 [##f5dce1e5b02e478f9fe2c83a0c5339d2] WHERE Customer_ID = A.TinShop)
     AND EXISTS (SELECT 1 FROM [##e6924b0e3bf8458fb2ea9ca1276827d9] WHERE Goods_No = B.Goods_No)
GROUP BY  a.TinShop, b.Goods_No, C.ColorID, C.Long


    时间: 2022-01-13 21:19:15,209
  线程ID: 70
日志级别: 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 ##9e13eac47602443d9b37ccf3b74726d5
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 [##f5dce1e5b02e478f9fe2c83a0c5339d2] CT ON A.Customer_ID = CT.Customer_ID
INNER JOIN [##e6924b0e3bf8458fb2ea9ca1276827d9] GS ON B.Goods_No = GS.Goods_No
WHERE A.Posted=1
 AND CheckDate >= '1990-01-01'
 AND CheckDate <='2022-01-13'
 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 


    时间: 2022-01-13 21:19:15,243
  线程ID: 70
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##9e13eac47602443d9b37ccf3b74726d5 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-01-13 21:19:15,246
  线程ID: 70
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##9e13eac47602443d9b37ccf3b74726d5 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-01-13 21:19:15,248
  线程ID: 70
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##9e13eac47602443d9b37ccf3b74726d5 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 = '退货' 


    时间: 2022-01-13 21:19:15,281
  线程ID: 70
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##9e13eac47602443d9b37ccf3b74726d5 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-01-13 21:19:15,282
  线程ID: 70
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##9e13eac47602443d9b37ccf3b74726d5 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-01-13 21:19:15,286
  线程ID: 70
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##7ac84d6c64ee454fa50c4ac19716895b(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) 
 SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##c7c13c89d9324727a9531fba5cd1ef65
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2022-01-13 21:19:15,292
  线程ID: 70
日志级别: 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 ##7ac84d6c64ee454fa50c4ac19716895b 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 ##4b32945440154d26b1737dca52cce53b 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