时间: 2023-06-12 14:10:31,066
  线程ID: 111
日志级别: 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 [##a33ec2ad7dec4cb7b75b12907e6f2379]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-06-12 14:10:31,468
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##51432690ab684b60ac4521e29a909e16] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-12 14:10:31,471
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##a33ec2ad7dec4cb7b75b12907e6f2379] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##51432690ab684b60ac4521e29a909e16]


    时间: 2023-06-12 14:10:31,533
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##f50d9ba9ef604f52aad5350a0694136a a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


    时间: 2023-06-12 14:10:31,540
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##f50d9ba9ef604f52aad5350a0694136a 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-06-12 14:10:31,572
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f50d9ba9ef604f52aad5350a0694136a SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-06-12 14:10:31,574
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f50d9ba9ef604f52aad5350a0694136a SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-06-12 14:10:31,578
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##a33ec2ad7dec4cb7b75b12907e6f2379] (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 [##0bd9e82ea8fc40b6a3458fbf4d8adc1b]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-12 14:10:31,591
  线程ID: 111
日志级别: 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.[a2e8361c-92fe-4f46-b472-ede705dd94ed]
FROM ##a33ec2ad7dec4cb7b75b12907e6f2379 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-06-12 14:10:43,048
  线程ID: 80
日志级别: 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 [##5b357bf62d8146b49f05f4f4a6337d9b]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-06-12 14:10:43,391
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##3ebf707804dd4ab0abf62121292969da] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-12 14:10:43,393
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##5b357bf62d8146b49f05f4f4a6337d9b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##3ebf707804dd4ab0abf62121292969da]


    时间: 2023-06-12 14:10:43,473
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##de4758bd654f41c785dbd80573b1ee6d a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-06-12 14:10:43,475
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##de4758bd654f41c785dbd80573b1ee6d SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-06-12 14:10:43,478
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##de4758bd654f41c785dbd80573b1ee6d 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-06-12 14:10:43,508
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##de4758bd654f41c785dbd80573b1ee6d SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-06-12 14:10:43,510
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##de4758bd654f41c785dbd80573b1ee6d SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-06-12 14:10:43,513
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##5b357bf62d8146b49f05f4f4a6337d9b] (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 [##d3d422b0d4b34c1c8b2f61248e7e49b8]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-12 14:10:43,518
  线程ID: 80
日志级别: 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.[a2e8361c-92fe-4f46-b472-ede705dd94ed]
FROM ##5b357bf62d8146b49f05f4f4a6337d9b 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-06-12 14:35:13,802
  线程ID: 117
日志级别: 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 [##21d670b1bc134ca58a16beaf8eefefd3]
FROM CustomerVip A


    时间: 2023-06-12 14:35:13,809
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: EXEC p_VipGetIntegral 
@VipTable = '##e113325fc3fb4b9ba275432a59df56a8', 
@EndDate = '2019/12/31', 
@DataTable = '##99d0ae8c194249aaba3ffde1e58ac63a' 


    时间: 2023-06-12 14:35:14,054
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##21d670b1bc134ca58a16beaf8eefefd3 ([卡号], [期初积分])
SELECT A.VIP, SUM(A.IntegralAmount)
FROM ##99d0ae8c194249aaba3ffde1e58ac63a A
GROUP BY A.VIP


    时间: 2023-06-12 14:35:14,057
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##21d670b1bc134ca58a16beaf8eefefd3 ([卡号], [金额充值赠送])
SELECT A.Vip, SUM(A.Integral)
FROM VIPAddValue A
WHERE A.Posted = 1
AND  A.VipAddValue_Date>='2020/1/1' AND A.VipAddValue_Date<='2023/6/12 23:59:59'
AND EXISTS(SELECT 1 FROM ##e113325fc3fb4b9ba275432a59df56a8 WHERE VIP=A.VIP) 
GROUP BY A.VIP


    时间: 2023-06-12 14:35:14,070
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT Vip INTO ##aac649c05b69458d8d1bb9a9388412d2 FROM ##e113325fc3fb4b9ba275432a59df56a8

    时间: 2023-06-12 14:35:14,074
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: EXEC p_VipGetIntegral 
@VipTable = '##aac649c05b69458d8d1bb9a9388412d2', 
@DataTable = '##6c38f60286f942eaa0c2fc262b9f6178', 
@IsUsabeIntegral = 1 


    时间: 2023-06-12 14:35:14,444
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##21d670b1bc134ca58a16beaf8eefefd3 ([卡号], [可用积分], [当前积分])
SELECT A.VIP, SUM(A.IntegralAmount), SUM(A.Integral)
FROM ##6c38f60286f942eaa0c2fc262b9f6178 A
GROUP BY A.VIP


    时间: 2023-06-12 14:35:14,459
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##21d670b1bc134ca58a16beaf8eefefd3 ([卡号], [消费积分])
SELECT A.Vip_Card, SUM(A.IntegralAmount) 
FROM [vn_Check] A
WHERE A.Posted = 1
AND  A.CheckDate>='2020/1/1' AND A.CheckDate<='2023/6/12 23:59:59'
AND EXISTS(SELECT 1 FROM ##e113325fc3fb4b9ba275432a59df56a8 WHERE VIP=A.Vip_Card) 
GROUP BY A.Vip_Card


    时间: 2023-06-12 14:35:14,577
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##21d670b1bc134ca58a16beaf8eefefd3 ([卡号], [增提积分])
SELECT A.VIP, SUM(A.Integral)
FROM [VIPAddIntegral] A
WHERE A.Posted = 1
AND  A.VipAddIntegral_Date>='2020/1/1' AND A.VipAddIntegral_Date<='2023/6/12 23:59:59'
AND EXISTS(SELECT 1 FROM ##e113325fc3fb4b9ba275432a59df56a8 WHERE VIP=A.VIP) 
GROUP BY A.VIP, A.VipAddIntegralID, A.VipAddIntegral_Date


    时间: 2023-06-12 14:35:14,591
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##21d670b1bc134ca58a16beaf8eefefd3 ([卡号], [积分换购])
SELECT A.VIP, SUM(A.Amount)
FROM [VipIntegralExchange] A
WHERE A.Posted = 1
AND  A.ExchangeDate>='2020/1/1' AND A.ExchangeDate<='2023/6/12 23:59:59'
AND EXISTS(SELECT 1 FROM ##e113325fc3fb4b9ba275432a59df56a8 WHERE VIP=A.VIP) 
GROUP BY A.VIP


    时间: 2023-06-12 14:35:14,600
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##21d670b1bc134ca58a16beaf8eefefd3 ([卡号], [抵减积分])
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>='2020/1/1' AND A.CheckDate<='2023/6/12 23:59:59'
AND EXISTS(SELECT 1 FROM ##e113325fc3fb4b9ba275432a59df56a8 WHERE VIP=A.Vip_Card) 
GROUP BY A.Vip_Card


    时间: 2023-06-12 14:35:14,684
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##21d670b1bc134ca58a16beaf8eefefd3 ([卡号], [积分转入])
SELECT A.TurnInCard, SUM(A.TurnInIntegral)
FROM [IntegralTurnCard] A
WHERE A.Posted = 1
AND  A.IntegralTurnCard_Date>='2020/1/1' AND A.IntegralTurnCard_Date<='2023/6/12 23:59:59'
AND EXISTS(SELECT 1 FROM ##e113325fc3fb4b9ba275432a59df56a8 WHERE VIP=A.TurnInCard) 
GROUP BY A.TurnInCard


    时间: 2023-06-12 14:35:14,692
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##21d670b1bc134ca58a16beaf8eefefd3 ([卡号], [积分转出])
SELECT A.TurnOutCard, SUM(A.TurnInIntegral)
FROM [IntegralTurnCard] A
WHERE A.Posted = 1
AND  A.IntegralTurnCard_Date>='2020/1/1' AND A.IntegralTurnCard_Date<='2023/6/12 23:59:59'
AND EXISTS(SELECT 1 FROM ##e113325fc3fb4b9ba275432a59df56a8 WHERE VIP=A.TurnOutCard) 
GROUP BY A.TurnOutCard


    时间: 2023-06-12 14:35:14,700
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##21d670b1bc134ca58a16beaf8eefefd3 ([卡号], [零售订单积分])
SELECT A.VIP, SUM(A.Integral)
FROM [KS2_RetailOrderIntegral] A
WHERE 1 = 1
AND  A.InputTime>='2020/1/1' AND A.InputTime<='2023/6/12 23:59:59'
AND EXISTS(SELECT 1 FROM ##e113325fc3fb4b9ba275432a59df56a8 WHERE VIP=A.VIP) 
GROUP BY A.VIP


    时间: 2023-06-12 14:35:14,713
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##21d670b1bc134ca58a16beaf8eefefd3 SET [本期积分] = ISNULL([消费积分],0) - ISNULL([抵减积分],0) - ISNULL([积分换购],0) + ISNULL([金额充值赠送],0) + ISNULL([增提积分],0)


    时间: 2023-06-12 14:35:14,722
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##21d670b1bc134ca58a16beaf8eefefd3 SET [累计积分] = ISNULL([期初积分],0) + ISNULL([消费积分],0) - ISNULL([抵减积分],0) - ISNULL([积分换购],0) + ISNULL([金额充值赠送],0) + ISNULL([增提积分],0) + ISNULL([积分转入],0) - ISNULL([积分转出],0) + ISNULL([零售订单积分],0)


    时间: 2023-06-12 14:35:14,733
  线程ID: 117
日志级别: 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 [##cdb0ec4b30ac4fe1829d466d46c7ba15]
FROM CustomerVip A


    时间: 2023-06-12 14:35:14,735
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##cdb0ec4b30ac4fe1829d466d46c7ba15(Vip,活跃度)
SELECT A.Vip,'深度休眠' FROM ##e113325fc3fb4b9ba275432a59df56a8 A 
INNER JOIN CustomerVip B ON A.Vip = B.Vip 
WHERE EXISTS(SELECT 1 FROM ##e77262cbb85f4ea8ac4c832bf955a8ed C WHERE B.Customer_ID = C.Customer_ID)


    时间: 2023-06-12 14:35:14,758
  线程ID: 117
日志级别: 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 ##e113325fc3fb4b9ba275432a59df56a8 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 ##cdb0ec4b30ac4fe1829d466d46c7ba15 A 
INNER JOIN cteData B ON A.Vip = B.VIP


    时间: 2023-06-12 14:35:14,900
  线程ID: 117
日志级别: 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 ##e113325fc3fb4b9ba275432a59df56a8 WHERE Vip = a.VIP_Card ) 
           AND a.CheckDate>'2019/12/31' and a.CheckDate<'2023/6/13' 
         GROUP BY a.VIP_Card
)
UPDATE A SET A.消费金额 = B.Amount
FROM ##cdb0ec4b30ac4fe1829d466d46c7ba15 A 
INNER JOIN cteSaleData B ON A.Vip = B.Vip


    时间: 2023-06-12 14:35:15,023
  线程ID: 117
日志级别: 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 ##e113325fc3fb4b9ba275432a59df56a8 WHERE Vip = a.VIP_Card ) 
         GROUP BY a.VIP_Card
)
UPDATE A SET A.累计消费金额 = B.Amount
FROM ##cdb0ec4b30ac4fe1829d466d46c7ba15 A 
INNER JOIN cteSaleData B ON A.Vip = B.Vip


    时间: 2023-06-12 14:35:15,141
  线程ID: 117
日志级别: 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 ##e113325fc3fb4b9ba275432a59df56a8 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 ##cdb0ec4b30ac4fe1829d466d46c7ba15 A 
INNER JOIN cteSet B ON A.Vip = B.Vip 
INNER JOIN Customer C ON B.Customer_ID = C.Customer_ID 


    时间: 2023-06-12 14:35:15,560
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.Vip = A.Vip
      ,A.活跃度2 = DATEDIFF(DAY,CAST(A.最后消费日期 AS DATETIME),GETDATE())
FROM ##cdb0ec4b30ac4fe1829d466d46c7ba15 A 
WHERE ISNULL(A.最后消费日期,'') != ''


    时间: 2023-06-12 14:35:15,574
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.活跃度 = '活跃'
FROM ##cdb0ec4b30ac4fe1829d466d46c7ba15 A 
WHERE ISNULL(A.最后消费日期,'') != ''
AND CAST(A.活跃度2 AS INT) <= 90 


    时间: 2023-06-12 14:35:15,581
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.活跃度 = '较活跃'
FROM ##cdb0ec4b30ac4fe1829d466d46c7ba15 A 
WHERE ISNULL(A.最后消费日期,'') != ''
AND CAST(A.活跃度2 AS INT) >= 90 
AND CAST(A.活跃度2 AS INT) < 180 


    时间: 2023-06-12 14:35:15,586
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.活跃度 = '警戒'
FROM ##cdb0ec4b30ac4fe1829d466d46c7ba15 A 
WHERE ISNULL(A.最后消费日期,'') != ''
AND CAST(A.活跃度2 AS INT) >= 180 
AND CAST(A.活跃度2 AS INT) < 365 


    时间: 2023-06-12 14:35:15,591
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.活跃度 = '休眠'
FROM ##cdb0ec4b30ac4fe1829d466d46c7ba15 A 
WHERE ISNULL(A.最后消费日期,'') != ''
AND CAST(A.活跃度2 AS INT) >= 365 
AND CAST(A.活跃度2 AS INT) < 730 


    时间: 2023-06-12 14:35:15,600
  线程ID: 117
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.活跃度 = '深度休眠'
FROM ##cdb0ec4b30ac4fe1829d466d46c7ba15 A 
WHERE ISNULL(A.最后消费日期,'') != ''
AND CAST(A.活跃度2 AS INT) >= 730 


    时间: 2023-06-12 14:35:15,604
  线程ID: 117
日志级别: 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.[77de3c0a-6fa1-41dc-b065-541f906a0784] 
 FROM [##e113325fc3fb4b9ba275432a59df56a8] Vip
 LEFT JOIN [##21d670b1bc134ca58a16beaf8eefefd3] A ON Vip.VIP=A.[卡号]
 LEFT JOIN [##cdb0ec4b30ac4fe1829d466d46c7ba15] 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-06-12 15:02:54,083
  线程ID: 14
日志级别: 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.[3345729d-90ec-4ce2-ac49-be818248a224]
FROM [##8c4ff41288414a51a1f2f2cec1e3055a]
ORDER BY Goods_no


    时间: 2023-06-12 15:04:01,402
  线程ID: 12
日志级别: 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 [##0cbe78863834422fb1d0168422fc7eee]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-06-12 15:04:01,810
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##1a8aa50582c242cebc00802936c121d3] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-12 15:04:01,812
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0cbe78863834422fb1d0168422fc7eee] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##1a8aa50582c242cebc00802936c121d3]


    时间: 2023-06-12 15:04:01,898
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##b2f92123241f46e6a1ec9ab34d6621a4 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


    时间: 2023-06-12 15:04:01,904
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##b2f92123241f46e6a1ec9ab34d6621a4 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-06-12 15:04:01,945
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b2f92123241f46e6a1ec9ab34d6621a4 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-06-12 15:04:01,946
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b2f92123241f46e6a1ec9ab34d6621a4 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-06-12 15:04:01,950
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0cbe78863834422fb1d0168422fc7eee] (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 [##5eeafc65be5c46948703dfa9f4c2398a]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-12 15:04:01,957
  线程ID: 12
日志级别: 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.[db69dda3-ef0f-4165-af9d-869f88162a3f]
FROM ##0cbe78863834422fb1d0168422fc7eee 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-06-12 15:04:33,907
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##b776d805473a4ca39fb7259a8df6d3f0] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##b776d805473a4ca39fb7259a8df6d3f0] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##1c20e80a0a23432eba17e5b42efda5b2] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID

 UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0)
 FROM [##b776d805473a4ca39fb7259a8df6d3f0] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##b776d805473a4ca39fb7259a8df6d3f0] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##1c20e80a0a23432eba17e5b42efda5b2] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID

 UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0)
 FROM [##b776d805473a4ca39fb7259a8df6d3f0] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##b776d805473a4ca39fb7259a8df6d3f0] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##1c20e80a0a23432eba17e5b42efda5b2] WHERE Goods_No = A.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID

 UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0)
 FROM [##b776d805473a4ca39fb7259a8df6d3f0] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity
        FROM PuReceipt A
        INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID
        INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID
        WHERE 1 = 1 AND A.[Type] = 1
     AND EXISTS (SELECT 1 FROM [##1c20e80a0a23432eba17e5b42efda5b2] WHERE Goods_No = R.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID
 UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0)
 FROM [##b776d805473a4ca39fb7259a8df6d3f0] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount
        FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##b776d805473a4ca39fb7259a8df6d3f0] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##1c20e80a0a23432eba17e5b42efda5b2] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-12 15:04:34,504
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式],
        rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BillAmount AS [采购额],
        PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异],
        DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[38fc05c2-b120-4a03-b98d-5be6d208b7b7]
 FROM [##b776d805473a4ca39fb7259a8df6d3f0] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-12 15:04:41,944
  线程ID: 11
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##5d95130287384325b35111d9467b525b] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##5d95130287384325b35111d9467b525b] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##1d3ec944647d4289ba0688e34b97c028] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID

 UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0)
 FROM [##5d95130287384325b35111d9467b525b] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##5d95130287384325b35111d9467b525b] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##1d3ec944647d4289ba0688e34b97c028] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID

 UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0)
 FROM [##5d95130287384325b35111d9467b525b] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##5d95130287384325b35111d9467b525b] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##1d3ec944647d4289ba0688e34b97c028] WHERE Goods_No = A.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID

 UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0)
 FROM [##5d95130287384325b35111d9467b525b] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity
        FROM PuReceipt A
        INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID
        INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID
        WHERE 1 = 1 AND A.[Type] = 1
     AND EXISTS (SELECT 1 FROM [##1d3ec944647d4289ba0688e34b97c028] WHERE Goods_No = R.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID
 UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0)
 FROM [##5d95130287384325b35111d9467b525b] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount
        FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##5d95130287384325b35111d9467b525b] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##1d3ec944647d4289ba0688e34b97c028] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-12 15:04:42,474
  线程ID: 11
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式],
        rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BillAmount AS [采购额],
        PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异],
        DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[38fc05c2-b120-4a03-b98d-5be6d208b7b7]
 FROM [##5d95130287384325b35111d9467b525b] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-12 15:33:04,701
  线程ID: 113
日志级别: 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.[3345729d-90ec-4ce2-ac49-be818248a224]
FROM [##49d6848772384b94aa97aeeddd96f9bb]
ORDER BY Goods_no


    时间: 2023-06-12 15:34:55,785
  线程ID: 16
日志级别: 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 [##62ede49e07924345a80a708186fe16c9]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-06-12 15:34:56,203
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##31633e53d90146658eb0b728c59b9b68] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-12 15:34:56,205
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##62ede49e07924345a80a708186fe16c9] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##31633e53d90146658eb0b728c59b9b68]


    时间: 2023-06-12 15:34:56,280
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##171b824171b84bebb47a99143f848229 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-06-12 15:34:56,282
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##171b824171b84bebb47a99143f848229 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-06-12 15:34:56,285
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##171b824171b84bebb47a99143f848229 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-06-12 15:34:56,318
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##171b824171b84bebb47a99143f848229 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-06-12 15:34:56,319
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##171b824171b84bebb47a99143f848229 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-06-12 15:34:56,323
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##62ede49e07924345a80a708186fe16c9] (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 [##a2e971e5a4934f2bbd9fe624fc3d8d1c]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-12 15:34:56,326
  线程ID: 16
日志级别: 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.[db69dda3-ef0f-4165-af9d-869f88162a3f]
FROM ##62ede49e07924345a80a708186fe16c9 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-06-12 15:35:09,418
  线程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 [##435dbff7656448f1a107492226aeb686]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-06-12 15:35:09,785
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##e9472446ed704f0b977af93e8b9bd40c] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-12 15:35:09,786
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##435dbff7656448f1a107492226aeb686] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##e9472446ed704f0b977af93e8b9bd40c]


    时间: 2023-06-12 15:35:09,867
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##828f5cf7a92142568327d46e6d3842f8 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-06-12 15:35:09,870
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##828f5cf7a92142568327d46e6d3842f8 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-06-12 15:35:09,874
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##828f5cf7a92142568327d46e6d3842f8 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-06-12 15:35:09,906
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##828f5cf7a92142568327d46e6d3842f8 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-06-12 15:35:09,907
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##828f5cf7a92142568327d46e6d3842f8 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-06-12 15:35:09,910
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##435dbff7656448f1a107492226aeb686] (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 [##e3ed4a0c5e394eb6957ee4fff08c4eb5]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-12 15:35:09,916
  线程ID: 24
日志级别: 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.[db69dda3-ef0f-4165-af9d-869f88162a3f]
FROM ##435dbff7656448f1a107492226aeb686 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-06-12 16:11:22,555
  线程ID: 55
日志级别: 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.[3345729d-90ec-4ce2-ac49-be818248a224]
FROM [##f08b396172794939b7a8dbc7f67e3e05]
ORDER BY Goods_no


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


    时间: 2023-06-12 16:11:38,241
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##c532eb55e8604fbbb59d89b6a06aee91] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-12 16:11:38,243
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##3077a246fd814b118ee251fc4bd41faa] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##c532eb55e8604fbbb59d89b6a06aee91]


    时间: 2023-06-12 16:11:38,332
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##f1386666d52d4e81b609e3765c0303bb a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-06-12 16:11:38,335
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f1386666d52d4e81b609e3765c0303bb SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-06-12 16:11:38,339
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##f1386666d52d4e81b609e3765c0303bb 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-06-12 16:11:38,409
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f1386666d52d4e81b609e3765c0303bb SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-06-12 16:11:38,424
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f1386666d52d4e81b609e3765c0303bb SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-06-12 16:11:38,428
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##3077a246fd814b118ee251fc4bd41faa] (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 [##3983bd88237a4d19a8b56ac05afe088a]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-12 16:11:38,435
  线程ID: 69
日志级别: 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.[db69dda3-ef0f-4165-af9d-869f88162a3f]
FROM ##3077a246fd814b118ee251fc4bd41faa 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-06-12 16:11:54,125
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##84b690ea17f84412b1ddd4adfff2f40e] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##84b690ea17f84412b1ddd4adfff2f40e] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##2ef4d89e3abc4c9ba1271f79439e5d68] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID

 UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0)
 FROM [##84b690ea17f84412b1ddd4adfff2f40e] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##84b690ea17f84412b1ddd4adfff2f40e] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##2ef4d89e3abc4c9ba1271f79439e5d68] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID

 UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0)
 FROM [##84b690ea17f84412b1ddd4adfff2f40e] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##84b690ea17f84412b1ddd4adfff2f40e] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##2ef4d89e3abc4c9ba1271f79439e5d68] WHERE Goods_No = A.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID

 UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0)
 FROM [##84b690ea17f84412b1ddd4adfff2f40e] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity
        FROM PuReceipt A
        INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID
        INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID
        WHERE 1 = 1 AND A.[Type] = 1
     AND EXISTS (SELECT 1 FROM [##2ef4d89e3abc4c9ba1271f79439e5d68] WHERE Goods_No = R.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID
 UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0)
 FROM [##84b690ea17f84412b1ddd4adfff2f40e] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount
        FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##84b690ea17f84412b1ddd4adfff2f40e] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##2ef4d89e3abc4c9ba1271f79439e5d68] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-12 16:11:54,634
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式],
        rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BillAmount AS [采购额],
        PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异],
        DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[38fc05c2-b120-4a03-b98d-5be6d208b7b7]
 FROM [##84b690ea17f84412b1ddd4adfff2f40e] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-12 17:24:01,359
  线程ID: 91
日志级别: 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.[d769fd62-c823-43ab-9dad-a4195610d274]
FROM [##878aa5b9fb35486d8464036a1b77bc07]
ORDER BY Goods_no


    时间: 2023-06-12 17:24:05,163
  线程ID: 110
日志级别: 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.[d769fd62-c823-43ab-9dad-a4195610d274]
FROM [##8bac919ae4524550a0c336daf09b5fac]
ORDER BY Goods_no


    时间: 2023-06-12 17:24:08,941
  线程ID: 44
日志级别: 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.[d769fd62-c823-43ab-9dad-a4195610d274]
FROM [##11375e1e450a4dff8966427d630df9ec]
ORDER BY Goods_no


    时间: 2023-06-12 17:27:13,472
  线程ID: 104
日志级别: 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.[d769fd62-c823-43ab-9dad-a4195610d274]
FROM [##14e110f4cad04ef48c06bc80be9b0a60]
ORDER BY Goods_no


    时间: 2023-06-12 17:57:19,260
  线程ID: 44
日志级别: 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.[0b72f152-d171-4713-ac76-05598e9b4af0]
FROM [##6af64f7f59954543bbeaeae55637249a]
ORDER BY Goods_no


    时间: 2023-06-12 18:00:08,806
  线程ID: 91
日志级别: 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 [##eb37dec6d57d4092abe612c187522262]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-06-12 18:00:09,164
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##9b2e954062eb45ea9d1e6641dd746497] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-12 18:00:09,166
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##eb37dec6d57d4092abe612c187522262] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##9b2e954062eb45ea9d1e6641dd746497]


    时间: 2023-06-12 18:00:09,222
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##d7d82918c56c4244bd41aaad29a84977 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-06-12 18:00:09,224
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##d7d82918c56c4244bd41aaad29a84977 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-06-12 18:00:09,226
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##d7d82918c56c4244bd41aaad29a84977 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-06-12 18:00:09,254
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##d7d82918c56c4244bd41aaad29a84977 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-06-12 18:00:09,255
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##d7d82918c56c4244bd41aaad29a84977 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-06-12 18:00:09,259
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##eb37dec6d57d4092abe612c187522262] (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 [##ec9fe938f3a5461da72199f66e104253]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-12 18:00:09,263
  线程ID: 91
日志级别: 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.[a2e8361c-92fe-4f46-b472-ede705dd94ed]
FROM ##eb37dec6d57d4092abe612c187522262 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-06-12 18:08:38,034
  线程ID: 53
日志级别: 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 [##85a0141ca5f94380aa58a06cb838fdb8]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-06-12 18:08:38,409
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##1c8f1983e9c44da9936a3ad6ca77399b] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-12 18:08:38,412
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##85a0141ca5f94380aa58a06cb838fdb8] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##1c8f1983e9c44da9936a3ad6ca77399b]


    时间: 2023-06-12 18:08:38,468
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##cd93041af00a4cc291be618e92c7be24 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-06-12 18:08:38,471
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##cd93041af00a4cc291be618e92c7be24 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-06-12 18:08:38,473
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##cd93041af00a4cc291be618e92c7be24 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-06-12 18:08:38,501
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##cd93041af00a4cc291be618e92c7be24 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-06-12 18:08:38,502
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##cd93041af00a4cc291be618e92c7be24 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-06-12 18:08:38,505
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##85a0141ca5f94380aa58a06cb838fdb8] (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 [##76fb925aa7ef4583a2b28012a5fed1fa]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-12 18:08:38,509
  线程ID: 53
日志级别: 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.[a2e8361c-92fe-4f46-b472-ede705dd94ed]
FROM ##85a0141ca5f94380aa58a06cb838fdb8 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-06-12 18:08:50,020
  线程ID: 62
日志级别: 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 [##b1eb2fd55fab4a67876c8c6094cb96db]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-06-12 18:08:50,392
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##ceb0c29354304cde96b7d242f8cd12aa] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-12 18:08:50,394
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b1eb2fd55fab4a67876c8c6094cb96db] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##ceb0c29354304cde96b7d242f8cd12aa]


    时间: 2023-06-12 18:08:50,457
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##e99c4b71fe3443fa9e3973dce0464396 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-06-12 18:08:50,460
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##e99c4b71fe3443fa9e3973dce0464396 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-06-12 18:08:50,463
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##e99c4b71fe3443fa9e3973dce0464396 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-06-12 18:08:50,494
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##e99c4b71fe3443fa9e3973dce0464396 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-06-12 18:08:50,496
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##e99c4b71fe3443fa9e3973dce0464396 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-06-12 18:08:50,499
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b1eb2fd55fab4a67876c8c6094cb96db] (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 [##c79aeb7bc0fa4beea4b530de90f7148a]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-12 18:08:50,506
  线程ID: 62
日志级别: 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.[a2e8361c-92fe-4f46-b472-ede705dd94ed]
FROM ##b1eb2fd55fab4a67876c8c6094cb96db 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