时间: 2023-07-31 09:43:44,798
  线程ID: 57
日志级别: 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 [##3f487bbef3ab4bc396318a7e562a6d11]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-07-31 09:43:45,249
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##a89e456a4b6c45cbb4bbac28a0eef54f] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-07-31 09:43:45,252
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##3f487bbef3ab4bc396318a7e562a6d11] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##a89e456a4b6c45cbb4bbac28a0eef54f]


    时间: 2023-07-31 09:43:45,321
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##9dd4174dc1da4cb99eeb4e8f4b7ef71a a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-07-31 09:43:45,323
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##9dd4174dc1da4cb99eeb4e8f4b7ef71a SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-07-31 09:43:45,326
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##9dd4174dc1da4cb99eeb4e8f4b7ef71a 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 = '退货' 


    时间: 2023-07-31 09:43:45,354
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##9dd4174dc1da4cb99eeb4e8f4b7ef71a SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-07-31 09:43:45,356
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##9dd4174dc1da4cb99eeb4e8f4b7ef71a SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-07-31 09:43:45,359
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##3f487bbef3ab4bc396318a7e562a6d11] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##b706c1f1265f46afa640b69e111ff965]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-07-31 09:43:45,377
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存]
INTO tempdb.dbo.[51566312-1a6a-4842-83f0-6bb53acce769]
FROM ##3f487bbef3ab4bc396318a7e562a6d11 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2023-07-31 09:43:48,788
  线程ID: 86
日志级别: 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 [##89f45d205c564d43b81cfedd73c79a1c]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-07-31 09:43:49,156
  线程ID: 86
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##8bd33b67dfb9481aad9b0eb6b124a8d0] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-07-31 09:43:49,159
  线程ID: 86
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##89f45d205c564d43b81cfedd73c79a1c] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##8bd33b67dfb9481aad9b0eb6b124a8d0]


    时间: 2023-07-31 09:43:49,217
  线程ID: 86
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##87910bb3fb0349a5a925f255a6dda51b a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-07-31 09:43:49,219
  线程ID: 86
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##87910bb3fb0349a5a925f255a6dda51b SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-07-31 09:43:49,222
  线程ID: 86
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##87910bb3fb0349a5a925f255a6dda51b 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 = '退货' 


    时间: 2023-07-31 09:43:49,249
  线程ID: 86
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##87910bb3fb0349a5a925f255a6dda51b SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-07-31 09:43:49,251
  线程ID: 86
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##87910bb3fb0349a5a925f255a6dda51b SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-07-31 09:43:49,254
  线程ID: 86
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##89f45d205c564d43b81cfedd73c79a1c] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##84aa925b0e9e445198054bda596b426f]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-07-31 09:43:49,258
  线程ID: 86
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存]
INTO tempdb.dbo.[51566312-1a6a-4842-83f0-6bb53acce769]
FROM ##89f45d205c564d43b81cfedd73c79a1c A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2023-07-31 10:29:09,152
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1]
    , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1]
    , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1]
    , CAST(NULL AS INT) AS [批发在途#数量]
    , CAST(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS 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 [##aacf8bdff0b04b2babce4aa0ac454612]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-07-31 10:29:09,939
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##0cbd413ad31e430e97059ca96c6e3d98] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-07-31 10:29:09,947
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##aacf8bdff0b04b2babce4aa0ac454612] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##0cbd413ad31e430e97059ca96c6e3d98]


    时间: 2023-07-31 10:29:10,091
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##1a170f07dccf4efcb11878e64a63c116 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-07-31 10:29:10,114
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##1a170f07dccf4efcb11878e64a63c116 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-07-31 10:29:10,126
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##1a170f07dccf4efcb11878e64a63c116 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 = '退货' 


    时间: 2023-07-31 10:29:10,165
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##1a170f07dccf4efcb11878e64a63c116 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-07-31 10:29:10,168
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##1a170f07dccf4efcb11878e64a63c116 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-07-31 10:29:10,192
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##aacf8bdff0b04b2babce4aa0ac454612] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##7fa65e812def472ea102e8fc1841c0c9]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-07-31 10:29:10,214
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称]
INTO tempdb.dbo.[3685a084-66e0-4bbe-8715-47052166152d]
FROM ##aacf8bdff0b04b2babce4aa0ac454612 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2023-07-31 10:49:00,485
  线程ID: 24
日志级别: 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 [##086ab7039ae24f5e842d929e04021d91]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-07-31 10:49:01,242
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##e58f277487714bb2887a3053da5158ed] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-07-31 10:49:01,249
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##086ab7039ae24f5e842d929e04021d91] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##e58f277487714bb2887a3053da5158ed]


    时间: 2023-07-31 10:49:01,396
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##8d55a3aa6fae46ea8922398258b639e8 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-07-31 10:49:01,418
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##8d55a3aa6fae46ea8922398258b639e8 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-07-31 10:49:01,429
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##8d55a3aa6fae46ea8922398258b639e8 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 = '退货' 


    时间: 2023-07-31 10:49:01,463
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##8d55a3aa6fae46ea8922398258b639e8 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-07-31 10:49:01,466
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##8d55a3aa6fae46ea8922398258b639e8 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-07-31 10:49:01,490
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##086ab7039ae24f5e842d929e04021d91] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##7872292fa30d47238f8d19b52e77ce0f]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-07-31 10:49:01,511
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量]
INTO tempdb.dbo.[3685a084-66e0-4bbe-8715-47052166152d]
FROM ##086ab7039ae24f5e842d929e04021d91 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2023-07-31 11:46:19,869
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 A.Vip AS [卡号]
, CAST(NULL AS DECIMAL(30,2)) AS [期初积分]
, CAST(NULL AS DECIMAL(30,2)) AS [本期积分]
, CAST(NULL AS DECIMAL(30,2)) AS [消费积分]
, CAST(NULL AS DECIMAL(30,2)) AS [抵减积分]
, CAST(NULL AS DECIMAL(30,2)) AS [金额充值赠送]
, CAST(NULL AS DECIMAL(30,2)) AS [增提积分]
, CAST(NULL AS DECIMAL(30,2)) AS [积分换购]
, CAST(NULL AS DECIMAL(30,2)) AS [积分转入]
, CAST(NULL AS DECIMAL(30,2)) AS [积分转出]
, CAST(NULL AS DECIMAL(30,2)) AS [零售订单积分]
, CAST(NULL AS DECIMAL(30,2)) AS [可用积分]
, CAST(NULL AS DECIMAL(30,2)) AS [累计积分]
, CAST(NULL AS DECIMAL(30,2)) AS [当前积分]
INTO [##b77507f5259c4c4caeaeb02a58ecc812]
FROM CustomerVip A


    时间: 2023-07-31 11:46:19,876
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: EXEC p_VipGetIntegral 
@VipTable = '##7cbc55e7f3ca40acbbdf11b0499dd60e', 
@EndDate = '2022/12/31', 
@DataTable = '##7c02a7577c48430ca05e751421f39cf5' 


    时间: 2023-07-31 11:46:20,168
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##b77507f5259c4c4caeaeb02a58ecc812 ([卡号], [期初积分])
SELECT A.VIP, SUM(A.IntegralAmount)
FROM ##7c02a7577c48430ca05e751421f39cf5 A
GROUP BY A.VIP


    时间: 2023-07-31 11:46:20,180
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##b77507f5259c4c4caeaeb02a58ecc812 ([卡号], [金额充值赠送])
SELECT A.Vip, SUM(A.Integral)
FROM VIPAddValue A
WHERE A.Posted = 1
AND  A.VipAddValue_Date>='2023/1/1' AND A.VipAddValue_Date<='2023/7/31 23:59:59'
AND EXISTS(SELECT 1 FROM ##7cbc55e7f3ca40acbbdf11b0499dd60e WHERE VIP=A.VIP) 
GROUP BY A.VIP


    时间: 2023-07-31 11:46:20,189
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT Vip INTO ##2273f94d44634e998b6d896b77027047 FROM ##7cbc55e7f3ca40acbbdf11b0499dd60e

    时间: 2023-07-31 11:46:20,192
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: EXEC p_VipGetIntegral 
@VipTable = '##2273f94d44634e998b6d896b77027047', 
@DataTable = '##998c9055858b4ecdbcbada4e92fd2a9a', 
@IsUsabeIntegral = 1 


    时间: 2023-07-31 11:46:20,572
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##b77507f5259c4c4caeaeb02a58ecc812 ([卡号], [可用积分], [当前积分])
SELECT A.VIP, SUM(A.IntegralAmount), SUM(A.Integral)
FROM ##998c9055858b4ecdbcbada4e92fd2a9a A
GROUP BY A.VIP


    时间: 2023-07-31 11:46:20,586
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##b77507f5259c4c4caeaeb02a58ecc812 ([卡号], [消费积分])
SELECT A.Vip_Card, SUM(A.IntegralAmount) 
FROM [vn_Check] A
WHERE A.Posted = 1
AND  A.CheckDate>='2023/1/1' AND A.CheckDate<='2023/7/31 23:59:59'
AND EXISTS(SELECT 1 FROM ##7cbc55e7f3ca40acbbdf11b0499dd60e WHERE VIP=A.Vip_Card) 
GROUP BY A.Vip_Card


    时间: 2023-07-31 11:46:20,638
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##b77507f5259c4c4caeaeb02a58ecc812 ([卡号], [增提积分])
SELECT A.VIP, SUM(A.Integral)
FROM [VIPAddIntegral] A
WHERE A.Posted = 1
AND  A.VipAddIntegral_Date>='2023/1/1' AND A.VipAddIntegral_Date<='2023/7/31 23:59:59'
AND EXISTS(SELECT 1 FROM ##7cbc55e7f3ca40acbbdf11b0499dd60e WHERE VIP=A.VIP) 
GROUP BY A.VIP, A.VipAddIntegralID, A.VipAddIntegral_Date


    时间: 2023-07-31 11:46:20,653
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##b77507f5259c4c4caeaeb02a58ecc812 ([卡号], [积分换购])
SELECT A.VIP, SUM(A.Amount)
FROM [VipIntegralExchange] A
WHERE A.Posted = 1
AND  A.ExchangeDate>='2023/1/1' AND A.ExchangeDate<='2023/7/31 23:59:59'
AND EXISTS(SELECT 1 FROM ##7cbc55e7f3ca40acbbdf11b0499dd60e WHERE VIP=A.VIP) 
GROUP BY A.VIP


    时间: 2023-07-31 11:46:20,662
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##b77507f5259c4c4caeaeb02a58ecc812 ([卡号], [抵减积分])
SELECT A.Vip_Card, SUM(B.Integral)
FROM [vn_Check] A
INNER JOIN CheckCounteractIntegral B ON A.CheckId=B.CheckId
WHERE A.Posted = 1
AND A.CheckDate>='2023/1/1' AND A.CheckDate<='2023/7/31 23:59:59'
AND EXISTS(SELECT 1 FROM ##7cbc55e7f3ca40acbbdf11b0499dd60e WHERE VIP=A.Vip_Card) 
GROUP BY A.Vip_Card


    时间: 2023-07-31 11:46:20,735
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##b77507f5259c4c4caeaeb02a58ecc812 ([卡号], [积分转入])
SELECT A.TurnInCard, SUM(A.TurnInIntegral)
FROM [IntegralTurnCard] A
WHERE A.Posted = 1
AND  A.IntegralTurnCard_Date>='2023/1/1' AND A.IntegralTurnCard_Date<='2023/7/31 23:59:59'
AND EXISTS(SELECT 1 FROM ##7cbc55e7f3ca40acbbdf11b0499dd60e WHERE VIP=A.TurnInCard) 
GROUP BY A.TurnInCard


    时间: 2023-07-31 11:46:20,743
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##b77507f5259c4c4caeaeb02a58ecc812 ([卡号], [积分转出])
SELECT A.TurnOutCard, SUM(A.TurnInIntegral)
FROM [IntegralTurnCard] A
WHERE A.Posted = 1
AND  A.IntegralTurnCard_Date>='2023/1/1' AND A.IntegralTurnCard_Date<='2023/7/31 23:59:59'
AND EXISTS(SELECT 1 FROM ##7cbc55e7f3ca40acbbdf11b0499dd60e WHERE VIP=A.TurnOutCard) 
GROUP BY A.TurnOutCard


    时间: 2023-07-31 11:46:20,752
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##b77507f5259c4c4caeaeb02a58ecc812 ([卡号], [零售订单积分])
SELECT A.VIP, SUM(A.Integral)
FROM [KS2_RetailOrderIntegral] A
WHERE 1 = 1
AND  A.InputTime>='2023/1/1' AND A.InputTime<='2023/7/31 23:59:59'
AND EXISTS(SELECT 1 FROM ##7cbc55e7f3ca40acbbdf11b0499dd60e WHERE VIP=A.VIP) 
GROUP BY A.VIP


    时间: 2023-07-31 11:46:20,765
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b77507f5259c4c4caeaeb02a58ecc812 SET [本期积分] = ISNULL([消费积分],0) - ISNULL([抵减积分],0) - ISNULL([积分换购],0) + ISNULL([金额充值赠送],0) + ISNULL([增提积分],0)


    时间: 2023-07-31 11:46:20,774
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b77507f5259c4c4caeaeb02a58ecc812 SET [累计积分] = ISNULL([期初积分],0) + ISNULL([消费积分],0) - ISNULL([抵减积分],0) - ISNULL([积分换购],0) + ISNULL([金额充值赠送],0) + ISNULL([增提积分],0) + ISNULL([积分转入],0) - ISNULL([积分转出],0) + ISNULL([零售订单积分],0)


    时间: 2023-07-31 11:46:20,784
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 A.Vip
, CAST(NULL AS VARCHAR(10)) AS [首次消费日期]
, CAST(NULL AS VARCHAR(10)) AS [最后消费日期]
, CAST(NULL AS VARCHAR(50)) AS [最后消费渠道]
, CAST(NULL AS DECIMAL(30,2)) AS [消费金额]
, CAST(NULL AS DECIMAL(30,2)) AS [累计消费金额]
, CAST(NULL AS NVARCHAR(50)) AS [活跃度]
, CAST(NULL AS INT) AS [活跃度2]
INTO [##03436d312d1742acba16c7db594c624c]
FROM CustomerVip A


    时间: 2023-07-31 11:46:20,786
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##03436d312d1742acba16c7db594c624c(Vip,活跃度)
SELECT A.Vip,'深度休眠' FROM ##7cbc55e7f3ca40acbbdf11b0499dd60e A 
INNER JOIN CustomerVip B ON A.Vip = B.Vip 
WHERE EXISTS(SELECT 1 FROM ##1c74f21e23f44374a085ae512ef5d510 C WHERE B.Customer_ID = C.Customer_ID)


    时间: 2023-07-31 11:46:20,812
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH cteData 
AS (
    SELECT a.VIP_Card VIP, MIN(a.CheckDate) AS MinDate, MAX(a.CheckDate) AS MaxDate 
    FROM vn_check a 
       WHERE ISNULL(A.Posted,0) = 1 
           AND EXISTS(SELECT 1 FROM ##7cbc55e7f3ca40acbbdf11b0499dd60e B WHERE a.VIP_Card = B.Vip) 
    GROUP BY a.VIP_Card
)
UPDATE A SET A.首次消费日期 = CONVERT(VARCHAR(10),B.MinDate,120)
      ,A.最后消费日期 = CONVERT(VARCHAR(10),B.MaxDate,120)
FROM ##03436d312d1742acba16c7db594c624c A 
INNER JOIN cteData B ON A.Vip = B.VIP


    时间: 2023-07-31 11:46:20,952
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH cteSaleData 
AS (
   SELECT a.VIP_Card Vip, SUM(ISNULL(b.DiscountPrice, 0) * (ISNULL([S1], 0))) Amount 
         FROM vn_check a 
             INNER JOIN VN_CheckGoods b ON a.CheckID = b.CheckID
             INNER JOIN VN_CheckDetail c ON b.CheckGoodsID = c.CheckGoodsID
         WHERE a.Posted = 1 
           AND EXISTS(SELECT 1 FROM ##7cbc55e7f3ca40acbbdf11b0499dd60e WHERE Vip = a.VIP_Card ) 
           AND a.CheckDate>'2022/12/31' and a.CheckDate<'2023/8/1' 
         GROUP BY a.VIP_Card
)
UPDATE A SET A.消费金额 = B.Amount
FROM ##03436d312d1742acba16c7db594c624c A 
INNER JOIN cteSaleData B ON A.Vip = B.Vip


    时间: 2023-07-31 11:46:21,028
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH cteSaleData 
AS (
   SELECT a.VIP_Card Vip, SUM(ISNULL(b.DiscountPrice, 0) * (ISNULL([S1], 0))) Amount 
         FROM vn_check a 
             INNER JOIN VN_CheckGoods b ON a.CheckID = b.CheckID
             INNER JOIN VN_CheckDetail c ON b.CheckGoodsID = c.CheckGoodsID
         WHERE a.Posted = 1 
           AND EXISTS(SELECT 1 FROM ##7cbc55e7f3ca40acbbdf11b0499dd60e WHERE Vip = a.VIP_Card ) 
         GROUP BY a.VIP_Card
)
UPDATE A SET A.累计消费金额 = B.Amount
FROM ##03436d312d1742acba16c7db594c624c A 
INNER JOIN cteSaleData B ON A.Vip = B.Vip


    时间: 2023-07-31 11:46:21,152
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH cteLastSale
AS (
    SELECT a.Customer_ID, a.VIP_Card VIP, MAX(A.CheckDate) AS CheckDate
    FROM vn_Check a 
    WHERE ISNULL(a.Posted,0) = 1
       AND EXISTS(SELECT 1 FROM ##7cbc55e7f3ca40acbbdf11b0499dd60e B WHERE a.VIP_Card = B.Vip) 
    GROUP BY a.Customer_ID, a.VIP_Card
)
,cteMax 
AS (
    SELECT Vip, MAX(CheckDate) AS CheckDate
    FROM cteLastSale 
    GROUP BY Vip
)
,cteSet
AS (
    SELECT A.* 
    FROM cteLastSale A 
    WHERE EXISTS(SELECT 1 FROM cteMax B WHERE A.Vip = B.Vip AND A.CheckDate = B.CheckDate)
)
UPDATE A SET A.最后消费渠道 = C.Abbrev 
FROM ##03436d312d1742acba16c7db594c624c A 
INNER JOIN cteSet B ON A.Vip = B.Vip 
INNER JOIN Customer C ON B.Customer_ID = C.Customer_ID 


    时间: 2023-07-31 11:46:21,560
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.Vip = A.Vip
      ,A.活跃度2 = DATEDIFF(DAY,CAST(A.最后消费日期 AS DATETIME),GETDATE())
FROM ##03436d312d1742acba16c7db594c624c A 
WHERE ISNULL(A.最后消费日期,'') != ''


    时间: 2023-07-31 11:46:21,576
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.活跃度 = '活跃'
FROM ##03436d312d1742acba16c7db594c624c A 
WHERE ISNULL(A.最后消费日期,'') != ''
AND CAST(A.活跃度2 AS INT) <= 90 


    时间: 2023-07-31 11:46:21,583
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.活跃度 = '较活跃'
FROM ##03436d312d1742acba16c7db594c624c A 
WHERE ISNULL(A.最后消费日期,'') != ''
AND CAST(A.活跃度2 AS INT) >= 90 
AND CAST(A.活跃度2 AS INT) < 180 


    时间: 2023-07-31 11:46:21,587
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.活跃度 = '警戒'
FROM ##03436d312d1742acba16c7db594c624c A 
WHERE ISNULL(A.最后消费日期,'') != ''
AND CAST(A.活跃度2 AS INT) >= 180 
AND CAST(A.活跃度2 AS INT) < 365 


    时间: 2023-07-31 11:46:21,593
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.活跃度 = '休眠'
FROM ##03436d312d1742acba16c7db594c624c A 
WHERE ISNULL(A.最后消费日期,'') != ''
AND CAST(A.活跃度2 AS INT) >= 365 
AND CAST(A.活跃度2 AS INT) < 730 


    时间: 2023-07-31 11:46:21,603
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.活跃度 = '深度休眠'
FROM ##03436d312d1742acba16c7db594c624c A 
WHERE ISNULL(A.最后消费日期,'') != ''
AND CAST(A.活跃度2 AS INT) >= 730 


    时间: 2023-07-31 11:46:21,607
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,Vip.VIP AS [VIP卡号], CV.Name AS [VIP姓名], B.首次消费日期 AS [首次消费日期], B.最后消费日期 AS [最后消费日期], B.最后消费渠道 AS [最后消费渠道], B.消费金额 AS [消费金额], B.累计消费金额 AS [累计消费金额], B.活跃度 AS [活跃度], SUM(期初积分) AS [期初积分], SUM(消费积分) AS [销售积分#消费积分], SUM(增提积分) AS [销售积分#增提积分], SUM(抵减积分) AS [销售积分#抵减积分], SUM(积分换购) AS [销售积分#积分换购], SUM(金额充值赠送) AS [销售积分#金额充值赠送], SUM(本期积分) AS [销售积分#本期积分], SUM(积分转入) AS [积分转入], SUM(积分转出) AS [积分转出], SUM(零售订单积分) AS [零售订单积分], SUM(可用积分) AS [可用积分], SUM(累计积分) AS [累计积分], CASE WHEN ISNULL(SUM([累计积分]),0) = 0 THEN 0 ELSE CAST(SUM([本期积分]) / SUM([累计积分]) AS NUMERIC(18,2)) END AS [占比], SUM(当前积分) AS [当前积分] 
   INTO tempdb.dbo.[71b5b508-6170-461d-886d-246a4f86c555] 
 FROM [##7cbc55e7f3ca40acbbdf11b0499dd60e] Vip
 LEFT JOIN [##b77507f5259c4c4caeaeb02a58ecc812] A ON Vip.VIP=A.[卡号]
 LEFT JOIN [##03436d312d1742acba16c7db594c624c] B ON Vip.VIP=B.Vip
 LEFT JOIN CustomerVIP CV ON Vip.VIP=CV.VIP
 LEFT JOIN Customer CV1 ON CV.Customer_ID=CV1.Customer_ID
GROUP BY  Vip.VIP, CV.Name, B.首次消费日期, B.最后消费日期, B.最后消费渠道, B.消费金额, B.累计消费金额, B.活跃度
HAVING 1=1
ORDER BY  Vip.VIP, CV.Name, B.首次消费日期, B.最后消费日期, B.最后消费渠道, B.消费金额, B.累计消费金额, B.活跃度


    时间: 2023-07-31 14:19:38,073
  线程ID: 58
日志级别: 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 [##177503785fe04e098c6230174b21de7c]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-07-31 14:19:38,428
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##1cb46a951fe549e3bc62b42190caea57] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-07-31 14:19:38,430
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##177503785fe04e098c6230174b21de7c] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##1cb46a951fe549e3bc62b42190caea57]


    时间: 2023-07-31 14:19:38,491
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##6cc28fbc32174e8398f0b974d3915f02 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-07-31 14:19:38,494
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6cc28fbc32174e8398f0b974d3915f02 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-07-31 14:19:38,497
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##6cc28fbc32174e8398f0b974d3915f02 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 = '退货' 


    时间: 2023-07-31 14:19:38,528
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6cc28fbc32174e8398f0b974d3915f02 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-07-31 14:19:38,529
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6cc28fbc32174e8398f0b974d3915f02 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-07-31 14:19:38,533
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##177503785fe04e098c6230174b21de7c] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##4a0ed15d10e940cc9b24e2c060c14930]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-07-31 14:19:38,538
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称]
INTO tempdb.dbo.[79c88adf-f1d3-4056-9679-c829a35748b5]
FROM ##177503785fe04e098c6230174b21de7c A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2023-07-31 16:09:01,364
  线程ID: 25
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称]
,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式]
,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额]
,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣]
,[Group] [组], Company_ID [公司编号], SaleMan [业务员]
,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别]
INTO tempdb.dbo.[8c95d418-2e93-4503-b945-1d5a39bddb87]
 FROM Customer A
 INNER JOIN [##ae92e262db4542afbed4ef27d3d1e2dc] B ON A.Customer_ID = B.Customer_ID
 ORDER BY A.Customer_ID


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


    时间: 2023-07-31 18:21:55,469
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##e4ecefc3a53c49e9954a946483089bb2] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-07-31 18:21:55,471
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##5ab3069834184873a0a983034ccbba98] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##e4ecefc3a53c49e9954a946483089bb2]


    时间: 2023-07-31 18:21:55,532
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##31fd4be2f6544e68a30c6dffffcf5938 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-07-31 18:21:55,535
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##31fd4be2f6544e68a30c6dffffcf5938 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-07-31 18:21:55,538
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##31fd4be2f6544e68a30c6dffffcf5938 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 = '退货' 


    时间: 2023-07-31 18:21:55,570
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##31fd4be2f6544e68a30c6dffffcf5938 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-07-31 18:21:55,572
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##31fd4be2f6544e68a30c6dffffcf5938 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-07-31 18:21:55,576
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##5ab3069834184873a0a983034ccbba98] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##679c698caca04e9998d2f7a18aa9d8ce]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-07-31 18:21:55,594
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称]
INTO tempdb.dbo.[79c88adf-f1d3-4056-9679-c829a35748b5]
FROM ##5ab3069834184873a0a983034ccbba98 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


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


    时间: 2023-07-31 18:22:13,158
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##382c33710b724548b4b122fbcd3c633e] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-07-31 18:22:13,160
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##fe9e25f4845b42ccaca253e1691bd6d2] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##382c33710b724548b4b122fbcd3c633e]


    时间: 2023-07-31 18:22:13,222
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##51086b7a7c7445d6b41f12fe58c69950 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-07-31 18:22:13,224
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##51086b7a7c7445d6b41f12fe58c69950 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-07-31 18:22:13,228
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##51086b7a7c7445d6b41f12fe58c69950 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 = '退货' 


    时间: 2023-07-31 18:22:13,263
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##51086b7a7c7445d6b41f12fe58c69950 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-07-31 18:22:13,265
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##51086b7a7c7445d6b41f12fe58c69950 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-07-31 18:22:13,269
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##fe9e25f4845b42ccaca253e1691bd6d2] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##b069b7b30ac347e3b20d81ad91d2dc73]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-07-31 18:22:13,276
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称]
INTO tempdb.dbo.[79c88adf-f1d3-4056-9679-c829a35748b5]
FROM ##fe9e25f4845b42ccaca253e1691bd6d2 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2023-07-31 18:22:25,877
  线程ID: 41
日志级别: 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 [##77cd1b842b1540e680198710e8d29e7d]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-07-31 18:22:26,241
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##759ce7171343427ebf3e62a51a0af58a] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-07-31 18:22:26,243
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##77cd1b842b1540e680198710e8d29e7d] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##759ce7171343427ebf3e62a51a0af58a]


    时间: 2023-07-31 18:22:26,304
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##65c7960c9e614b63b8533b8df02c6d14 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-07-31 18:22:26,307
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##65c7960c9e614b63b8533b8df02c6d14 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-07-31 18:22:26,310
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##65c7960c9e614b63b8533b8df02c6d14 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 = '退货' 


    时间: 2023-07-31 18:22:26,340
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##65c7960c9e614b63b8533b8df02c6d14 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-07-31 18:22:26,342
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##65c7960c9e614b63b8533b8df02c6d14 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-07-31 18:22:26,346
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##77cd1b842b1540e680198710e8d29e7d] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##b23d6f1ed387497c80dc69ad7baee4e2]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-07-31 18:22:26,351
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称]
INTO tempdb.dbo.[79c88adf-f1d3-4056-9679-c829a35748b5]
FROM ##77cd1b842b1540e680198710e8d29e7d A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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