时间: 2023-07-23 12:56:37,285
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH WarehouseData AS ( 
SELECT Warehouse_No FROM rightWare RS 
WHERE RS.Warehouse_No <> '全部'
AND RS.UserNo = '202'
UNION  
SELECT S.Warehouse_No FROM Warehouse S , rightWare RS
WHERE RS.UserNo = '202'
AND RS.Warehouse_No = '全部'
 )
SELECT * INTO ##71fc242d93dc4990bcb96d46f0536788 FROM WarehouseData 

    时间: 2023-07-23 12:56:37,337
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Warehouse_No AS [仓库编号], Warehouse_Na AS [仓库名称], Region AS [区域]
,ChannelID AS [上级渠道], PreAbbrev AS [上级渠道简称]
,AccountCustomer_ID AS [应收归集户口], AccountCustomerAbbrev AS [应收归集户口简称], KeyMan AS [联系人]
,Tele AS [电话], AllowMinusStock AS [仓库库存准许负数]
,ShutOut AS [停用], Tag AS [虚拟仓]
INTO tempdb.dbo.[c793a006-4c01-468e-9cae-505cadd0b4d9]
 FROM [##b613a386e01443f78417081dda8051c9]
 ORDER BY Warehouse_No


    时间: 2023-07-23 12:56:38,847
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH WarehouseData AS ( 
SELECT Warehouse_No FROM rightWare RS 
WHERE RS.Warehouse_No <> '全部'
AND RS.UserNo = '202'
UNION  
SELECT S.Warehouse_No FROM Warehouse S , rightWare RS
WHERE RS.UserNo = '202'
AND RS.Warehouse_No = '全部'
 )
SELECT * INTO ##5f6964383b6540d88d53d40c94a2f67e FROM WarehouseData 

    时间: 2023-07-23 12:56:38,872
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Warehouse_No AS [仓库编号], Warehouse_Na AS [仓库名称], Region AS [区域]
,ChannelID AS [上级渠道], PreAbbrev AS [上级渠道简称]
,AccountCustomer_ID AS [应收归集户口], AccountCustomerAbbrev AS [应收归集户口简称], KeyMan AS [联系人]
,Tele AS [电话], AllowMinusStock AS [仓库库存准许负数]
,ShutOut AS [停用], Tag AS [虚拟仓]
INTO tempdb.dbo.[c793a006-4c01-468e-9cae-505cadd0b4d9]
 FROM [##f13c58199f46429aac5710fc9dea93a9]
 ORDER BY Warehouse_No


    时间: 2023-07-23 12:56:39,122
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH WarehouseData AS ( 
SELECT Warehouse_No FROM rightWare RS 
WHERE RS.Warehouse_No <> '全部'
AND RS.UserNo = '202'
UNION  
SELECT S.Warehouse_No FROM Warehouse S , rightWare RS
WHERE RS.UserNo = '202'
AND RS.Warehouse_No = '全部'
 )
SELECT * INTO ##9c6d0958f16e41078a2c050b9cc34a3a FROM WarehouseData 

    时间: 2023-07-23 12:56:39,148
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Warehouse_No AS [仓库编号], Warehouse_Na AS [仓库名称], Region AS [区域]
,ChannelID AS [上级渠道], PreAbbrev AS [上级渠道简称]
,AccountCustomer_ID AS [应收归集户口], AccountCustomerAbbrev AS [应收归集户口简称], KeyMan AS [联系人]
,Tele AS [电话], AllowMinusStock AS [仓库库存准许负数]
,ShutOut AS [停用], Tag AS [虚拟仓]
INTO tempdb.dbo.[c793a006-4c01-468e-9cae-505cadd0b4d9]
 FROM [##27b851eb6d614f7d8193331ff4223ee5]
 ORDER BY Warehouse_No


    时间: 2023-07-23 12:56:44,605
  线程ID: 59
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH WarehouseData AS ( 
SELECT Warehouse_No FROM rightWare RS 
WHERE RS.Warehouse_No <> '全部'
AND RS.UserNo = '202'
UNION  
SELECT S.Warehouse_No FROM Warehouse S , rightWare RS
WHERE RS.UserNo = '202'
AND RS.Warehouse_No = '全部'
 )
SELECT * INTO ##6f2de4273fe94b558d5830dce3c159c6 FROM WarehouseData 

    时间: 2023-07-23 12:56:44,631
  线程ID: 59
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Warehouse_No AS [仓库编号], Warehouse_Na AS [仓库名称], Region AS [区域]
,ChannelID AS [上级渠道], PreAbbrev AS [上级渠道简称]
,AccountCustomer_ID AS [应收归集户口], AccountCustomerAbbrev AS [应收归集户口简称], KeyMan AS [联系人]
,Tele AS [电话], AllowMinusStock AS [仓库库存准许负数]
,ShutOut AS [停用], Tag AS [虚拟仓]
INTO tempdb.dbo.[c793a006-4c01-468e-9cae-505cadd0b4d9]
 FROM [##16839675c42f48f3b5cb327fb3c32338]
 ORDER BY Warehouse_No


    时间: 2023-07-23 12:56:47,281
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH WarehouseData AS ( 
SELECT Warehouse_No FROM rightWare RS 
WHERE RS.Warehouse_No <> '全部'
AND RS.UserNo = '202'
UNION  
SELECT S.Warehouse_No FROM Warehouse S , rightWare RS
WHERE RS.UserNo = '202'
AND RS.Warehouse_No = '全部'
 )
SELECT * INTO ##4e3bba6ad12841188faeb2e5e8a74b46 FROM WarehouseData 

    时间: 2023-07-23 12:56:47,304
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Warehouse_No AS [仓库编号], Warehouse_Na AS [仓库名称], Region AS [区域]
,ChannelID AS [上级渠道], PreAbbrev AS [上级渠道简称]
,AccountCustomer_ID AS [应收归集户口], AccountCustomerAbbrev AS [应收归集户口简称], KeyMan AS [联系人]
,Tele AS [电话], AllowMinusStock AS [仓库库存准许负数]
,ShutOut AS [停用], Tag AS [虚拟仓]
INTO tempdb.dbo.[c793a006-4c01-468e-9cae-505cadd0b4d9]
 FROM [##45a0ec05d3a340538faed01e3bb31f1f]
 ORDER BY Warehouse_No


    时间: 2023-07-23 12:56:48,093
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH WarehouseData AS ( 
SELECT Warehouse_No FROM rightWare RS 
WHERE RS.Warehouse_No <> '全部'
AND RS.UserNo = '202'
UNION  
SELECT S.Warehouse_No FROM Warehouse S , rightWare RS
WHERE RS.UserNo = '202'
AND RS.Warehouse_No = '全部'
 )
SELECT * INTO ##241efe2dca2a47beaa93d1d160fa0368 FROM WarehouseData 

    时间: 2023-07-23 12:56:48,117
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Warehouse_No AS [仓库编号], Warehouse_Na AS [仓库名称], Region AS [区域]
,ChannelID AS [上级渠道], PreAbbrev AS [上级渠道简称]
,AccountCustomer_ID AS [应收归集户口], AccountCustomerAbbrev AS [应收归集户口简称], KeyMan AS [联系人]
,Tele AS [电话], AllowMinusStock AS [仓库库存准许负数]
,ShutOut AS [停用], Tag AS [虚拟仓]
INTO tempdb.dbo.[c793a006-4c01-468e-9cae-505cadd0b4d9]
 FROM [##5cdd8d9a8290453e83a6a06afa17ba77]
 ORDER BY Warehouse_No


    时间: 2023-07-23 12:56:48,423
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH WarehouseData AS ( 
SELECT Warehouse_No FROM rightWare RS 
WHERE RS.Warehouse_No <> '全部'
AND RS.UserNo = '202'
UNION  
SELECT S.Warehouse_No FROM Warehouse S , rightWare RS
WHERE RS.UserNo = '202'
AND RS.Warehouse_No = '全部'
 )
SELECT * INTO ##54aa23e256b24c2c86c1c5eb9d98a717 FROM WarehouseData 

    时间: 2023-07-23 12:56:48,446
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Warehouse_No AS [仓库编号], Warehouse_Na AS [仓库名称], Region AS [区域]
,ChannelID AS [上级渠道], PreAbbrev AS [上级渠道简称]
,AccountCustomer_ID AS [应收归集户口], AccountCustomerAbbrev AS [应收归集户口简称], KeyMan AS [联系人]
,Tele AS [电话], AllowMinusStock AS [仓库库存准许负数]
,ShutOut AS [停用], Tag AS [虚拟仓]
INTO tempdb.dbo.[c793a006-4c01-468e-9cae-505cadd0b4d9]
 FROM [##dc9837bbfc0246cfb0349b923b65cb38]
 ORDER BY Warehouse_No


    时间: 2023-07-23 12:56:48,742
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH WarehouseData AS ( 
SELECT Warehouse_No FROM rightWare RS 
WHERE RS.Warehouse_No <> '全部'
AND RS.UserNo = '202'
UNION  
SELECT S.Warehouse_No FROM Warehouse S , rightWare RS
WHERE RS.UserNo = '202'
AND RS.Warehouse_No = '全部'
 )
SELECT * INTO ##58ed7c6d3d3249a397661cdd5d20c3ff FROM WarehouseData 

    时间: 2023-07-23 12:56:48,765
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Warehouse_No AS [仓库编号], Warehouse_Na AS [仓库名称], Region AS [区域]
,ChannelID AS [上级渠道], PreAbbrev AS [上级渠道简称]
,AccountCustomer_ID AS [应收归集户口], AccountCustomerAbbrev AS [应收归集户口简称], KeyMan AS [联系人]
,Tele AS [电话], AllowMinusStock AS [仓库库存准许负数]
,ShutOut AS [停用], Tag AS [虚拟仓]
INTO tempdb.dbo.[c793a006-4c01-468e-9cae-505cadd0b4d9]
 FROM [##242904fb43d64333b1e4e5a12b27e1b1]
 ORDER BY Warehouse_No


    时间: 2023-07-23 12:56:53,246
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH WarehouseData AS ( 
SELECT Warehouse_No FROM rightWare RS 
WHERE RS.Warehouse_No <> '全部'
AND RS.UserNo = '202'
UNION  
SELECT S.Warehouse_No FROM Warehouse S , rightWare RS
WHERE RS.UserNo = '202'
AND RS.Warehouse_No = '全部'
 )
SELECT * INTO ##66cced9bd8034e4a9328ce87d2e075dc FROM WarehouseData 

    时间: 2023-07-23 12:56:53,284
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Warehouse_No AS [仓库编号], Warehouse_Na AS [仓库名称], Region AS [区域]
,ChannelID AS [上级渠道], PreAbbrev AS [上级渠道简称]
,AccountCustomer_ID AS [应收归集户口], AccountCustomerAbbrev AS [应收归集户口简称], KeyMan AS [联系人]
,Tele AS [电话], AllowMinusStock AS [仓库库存准许负数]
,ShutOut AS [停用], Tag AS [虚拟仓]
INTO tempdb.dbo.[c793a006-4c01-468e-9cae-505cadd0b4d9]
 FROM [##5346e84d153c488b89677ad544301e29]
 ORDER BY Warehouse_No


    时间: 2023-07-23 12:57:00,949
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH WarehouseData AS ( 
SELECT Warehouse_No FROM rightWare RS 
WHERE RS.Warehouse_No <> '全部'
AND RS.UserNo = '202'
UNION  
SELECT S.Warehouse_No FROM Warehouse S , rightWare RS
WHERE RS.UserNo = '202'
AND RS.Warehouse_No = '全部'
 )
SELECT * INTO ##8a9db81a7e7e489489b9041f1dd70642 FROM WarehouseData 

    时间: 2023-07-23 12:57:00,988
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Warehouse_No AS [仓库编号], Warehouse_Na AS [仓库名称], Region AS [区域]
,ChannelID AS [上级渠道], PreAbbrev AS [上级渠道简称]
,AccountCustomer_ID AS [应收归集户口], AccountCustomerAbbrev AS [应收归集户口简称], KeyMan AS [联系人]
,Tele AS [电话], AllowMinusStock AS [仓库库存准许负数]
,ShutOut AS [停用], Tag AS [虚拟仓]
INTO tempdb.dbo.[c793a006-4c01-468e-9cae-505cadd0b4d9]
 FROM [##fbd44dbccc6144659508533e8f99ba8f]
 ORDER BY Warehouse_No


    时间: 2023-07-23 12:57:01,946
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH WarehouseData AS ( 
SELECT Warehouse_No FROM rightWare RS 
WHERE RS.Warehouse_No <> '全部'
AND RS.UserNo = '202'
UNION  
SELECT S.Warehouse_No FROM Warehouse S , rightWare RS
WHERE RS.UserNo = '202'
AND RS.Warehouse_No = '全部'
 )
SELECT * INTO ##f70b08e72457487aa134c283d1199472 FROM WarehouseData 

    时间: 2023-07-23 12:57:01,988
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Warehouse_No AS [仓库编号], Warehouse_Na AS [仓库名称], Region AS [区域]
,ChannelID AS [上级渠道], PreAbbrev AS [上级渠道简称]
,AccountCustomer_ID AS [应收归集户口], AccountCustomerAbbrev AS [应收归集户口简称], KeyMan AS [联系人]
,Tele AS [电话], AllowMinusStock AS [仓库库存准许负数]
,ShutOut AS [停用], Tag AS [虚拟仓]
INTO tempdb.dbo.[c793a006-4c01-468e-9cae-505cadd0b4d9]
 FROM [##c381c914012349b3974500f0aa10e505]
 ORDER BY Warehouse_No


    时间: 2023-07-23 12:57:02,410
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH WarehouseData AS ( 
SELECT Warehouse_No FROM rightWare RS 
WHERE RS.Warehouse_No <> '全部'
AND RS.UserNo = '202'
UNION  
SELECT S.Warehouse_No FROM Warehouse S , rightWare RS
WHERE RS.UserNo = '202'
AND RS.Warehouse_No = '全部'
 )
SELECT * INTO ##64b2e0cdf37a45fa8ada089e95a8b269 FROM WarehouseData 

    时间: 2023-07-23 12:57:02,445
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Warehouse_No AS [仓库编号], Warehouse_Na AS [仓库名称], Region AS [区域]
,ChannelID AS [上级渠道], PreAbbrev AS [上级渠道简称]
,AccountCustomer_ID AS [应收归集户口], AccountCustomerAbbrev AS [应收归集户口简称], KeyMan AS [联系人]
,Tele AS [电话], AllowMinusStock AS [仓库库存准许负数]
,ShutOut AS [停用], Tag AS [虚拟仓]
INTO tempdb.dbo.[c793a006-4c01-468e-9cae-505cadd0b4d9]
 FROM [##cdb5e208ad624da1aedc642fd03ed9fa]
 ORDER BY Warehouse_No


    时间: 2023-07-23 12:57:02,696
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH WarehouseData AS ( 
SELECT Warehouse_No FROM rightWare RS 
WHERE RS.Warehouse_No <> '全部'
AND RS.UserNo = '202'
UNION  
SELECT S.Warehouse_No FROM Warehouse S , rightWare RS
WHERE RS.UserNo = '202'
AND RS.Warehouse_No = '全部'
 )
SELECT * INTO ##212f540f5daf47008e41de083f5d99c0 FROM WarehouseData 

    时间: 2023-07-23 12:57:02,740
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Warehouse_No AS [仓库编号], Warehouse_Na AS [仓库名称], Region AS [区域]
,ChannelID AS [上级渠道], PreAbbrev AS [上级渠道简称]
,AccountCustomer_ID AS [应收归集户口], AccountCustomerAbbrev AS [应收归集户口简称], KeyMan AS [联系人]
,Tele AS [电话], AllowMinusStock AS [仓库库存准许负数]
,ShutOut AS [停用], Tag AS [虚拟仓]
INTO tempdb.dbo.[c793a006-4c01-468e-9cae-505cadd0b4d9]
 FROM [##f7194a698e54465ebaa3b7c953f6e7d1]
 ORDER BY Warehouse_No


    时间: 2023-07-23 12:57:58,036
  线程ID: 51
日志级别: 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 [##d30c0ca01286497888e521e5f2aa5a75]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-07-23 12:57:58,354
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##c4d24519997d48cda865c59ac8a6775c] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-07-23 12:57:58,357
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##d30c0ca01286497888e521e5f2aa5a75] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##c4d24519997d48cda865c59ac8a6775c]


    时间: 2023-07-23 12:57:58,409
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##aa274278287f4044ad3ec2f34ff65df5 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-07-23 12:57:58,412
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##aa274278287f4044ad3ec2f34ff65df5 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-07-23 12:57:58,414
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##aa274278287f4044ad3ec2f34ff65df5 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-23 12:57:58,441
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##aa274278287f4044ad3ec2f34ff65df5 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-07-23 12:57:58,443
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##aa274278287f4044ad3ec2f34ff65df5 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-07-23 12:57:58,447
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##d30c0ca01286497888e521e5f2aa5a75] (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 [##d1bef5f460284c5989772df4be07d4d7]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-07-23 12:57:58,463
  线程ID: 51
日志级别: 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.[5785fe73-b688-435c-a1a8-4f901241c6de]
FROM ##d30c0ca01286497888e521e5f2aa5a75 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-23 15:58:46,401
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1]
    , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1]
    , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1]
    , CAST(NULL AS INT) AS [批发在途#数量]
    , CAST(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS 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 [##5889086d31954fde9b60d8df725b429f]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-07-23 15:58:46,777
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##9c6fc8fd698a4101b5df494c3b95c463] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-07-23 15:58:46,779
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##5889086d31954fde9b60d8df725b429f] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##9c6fc8fd698a4101b5df494c3b95c463]


    时间: 2023-07-23 15:58:46,840
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##db65e16b73014845a7c8807cbd0950c3 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-07-23 15:58:46,843
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##db65e16b73014845a7c8807cbd0950c3 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-07-23 15:58:46,846
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##db65e16b73014845a7c8807cbd0950c3 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-23 15:58:46,879
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##db65e16b73014845a7c8807cbd0950c3 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-07-23 15:58:46,881
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##db65e16b73014845a7c8807cbd0950c3 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-07-23 15:58:46,884
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##5889086d31954fde9b60d8df725b429f] (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 [##5dce13d0d12947cbabb921aa8701fb6b]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-07-23 15:58:46,889
  线程ID: 27
日志级别: 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.[5785fe73-b688-435c-a1a8-4f901241c6de]
FROM ##5889086d31954fde9b60d8df725b429f 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-23 16:47:42,379
  线程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 [##e613d2cf0ec44880ba20097fe7ec0c61]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-07-23 16:47:42,771
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##b93ef4dc3b1f404cbb40296ec5ffe5be] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-07-23 16:47:42,773
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##e613d2cf0ec44880ba20097fe7ec0c61] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##b93ef4dc3b1f404cbb40296ec5ffe5be]


    时间: 2023-07-23 16:47:42,833
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##38ed6c0b9e3a4ebd9b5a5db8d3fe60f2 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


    时间: 2023-07-23 16:47:42,839
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##38ed6c0b9e3a4ebd9b5a5db8d3fe60f2 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-23 16:47:42,871
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##38ed6c0b9e3a4ebd9b5a5db8d3fe60f2 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-07-23 16:47:42,872
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##38ed6c0b9e3a4ebd9b5a5db8d3fe60f2 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-07-23 16:47:42,877
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##e613d2cf0ec44880ba20097fe7ec0c61] (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 [##2b7d5aa553a8401a88408205f7608aa7]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-07-23 16:47:42,883
  线程ID: 22
日志级别: 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.[5785fe73-b688-435c-a1a8-4f901241c6de]
FROM ##e613d2cf0ec44880ba20097fe7ec0c61 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-23 17:36:22,544
  线程ID: 21
日志级别: 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 [##aa7cd7264608400697b60f05acfcf7e8]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-07-23 17:36:22,967
  线程ID: 21
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##0ee1e2985b754feebb3df5b6ae1834ab] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-07-23 17:36:22,967
  线程ID: 21
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##aa7cd7264608400697b60f05acfcf7e8] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##0ee1e2985b754feebb3df5b6ae1834ab]


    时间: 2023-07-23 17:36:23,038
  线程ID: 21
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##f7a1594bece74903a4898b932533705e a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


    时间: 2023-07-23 17:36:23,038
  线程ID: 21
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##f7a1594bece74903a4898b932533705e 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-23 17:36:23,091
  线程ID: 21
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f7a1594bece74903a4898b932533705e SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-07-23 17:36:23,094
  线程ID: 21
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f7a1594bece74903a4898b932533705e SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-07-23 17:36:23,097
  线程ID: 21
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##aa7cd7264608400697b60f05acfcf7e8] (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 [##073fd6a30435428aa0968e8d412c170e]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-07-23 17:36:23,105
  线程ID: 21
日志级别: 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.[5785fe73-b688-435c-a1a8-4f901241c6de]
FROM ##aa7cd7264608400697b60f05acfcf7e8 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-23 18:12:44,560
  线程ID: 26
日志级别: 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 [##8f78fd121b574490a2563b8b8a261179]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-07-23 18:12:44,991
  线程ID: 26
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##cc13eee75b254619a6678ca4394f72d8] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-07-23 18:12:44,992
  线程ID: 26
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##8f78fd121b574490a2563b8b8a261179] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##cc13eee75b254619a6678ca4394f72d8]


    时间: 2023-07-23 18:12:45,053
  线程ID: 26
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##626ec2b8da8e4aec9c737be028b72bbb a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


    时间: 2023-07-23 18:12:45,060
  线程ID: 26
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##626ec2b8da8e4aec9c737be028b72bbb 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-23 18:12:45,095
  线程ID: 26
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##626ec2b8da8e4aec9c737be028b72bbb SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-07-23 18:12:45,096
  线程ID: 26
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##626ec2b8da8e4aec9c737be028b72bbb SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-07-23 18:12:45,099
  线程ID: 26
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##8f78fd121b574490a2563b8b8a261179] (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 [##931563e77af84ff5914d87869e5a66fd]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-07-23 18:12:45,104
  线程ID: 26
日志级别: 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.[5785fe73-b688-435c-a1a8-4f901241c6de]
FROM ##8f78fd121b574490a2563b8b8a261179 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-23 19:03:03,532
  线程ID: 11
日志级别: 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 [##450bc8a44f24458c89de09ae17013da1]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-07-23 19:03:03,921
  线程ID: 11
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##27e16ba9ce154acda7473ad582058a32] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-07-23 19:03:03,923
  线程ID: 11
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##450bc8a44f24458c89de09ae17013da1] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##27e16ba9ce154acda7473ad582058a32]


    时间: 2023-07-23 19:03:03,979
  线程ID: 11
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##e34dbd1f22f94c3d89bd2ebf939a8c2e a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


    时间: 2023-07-23 19:03:03,985
  线程ID: 11
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##e34dbd1f22f94c3d89bd2ebf939a8c2e 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-23 19:03:04,018
  线程ID: 11
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##e34dbd1f22f94c3d89bd2ebf939a8c2e SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-07-23 19:03:04,020
  线程ID: 11
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##e34dbd1f22f94c3d89bd2ebf939a8c2e SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-07-23 19:03:04,022
  线程ID: 11
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##450bc8a44f24458c89de09ae17013da1] (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 [##8caa123cdda245dbb87255db53a573dc]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-07-23 19:03:04,030
  线程ID: 11
日志级别: 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.[5785fe73-b688-435c-a1a8-4f901241c6de]
FROM ##450bc8a44f24458c89de09ae17013da1 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-23 21:17:20,902
  线程ID: 5
日志级别: 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 [##699aa03f4efb46fa8b619b890e884ceb]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-07-23 21:17:21,286
  线程ID: 5
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##629184a6d8ec45028c571de67abdf8d8] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-07-23 21:17:21,287
  线程ID: 5
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##699aa03f4efb46fa8b619b890e884ceb] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##629184a6d8ec45028c571de67abdf8d8]


    时间: 2023-07-23 21:17:21,347
  线程ID: 5
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##53fc1052602646b5b2c01fc757c5821d a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


    时间: 2023-07-23 21:17:21,353
  线程ID: 5
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##53fc1052602646b5b2c01fc757c5821d 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-23 21:17:21,383
  线程ID: 5
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##53fc1052602646b5b2c01fc757c5821d SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-07-23 21:17:21,384
  线程ID: 5
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##53fc1052602646b5b2c01fc757c5821d SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-07-23 21:17:21,387
  线程ID: 5
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##699aa03f4efb46fa8b619b890e884ceb] (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 [##a300d555894f4298aa996dc429b65982]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-07-23 21:17:21,391
  线程ID: 5
日志级别: 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.[5785fe73-b688-435c-a1a8-4f901241c6de]
FROM ##699aa03f4efb46fa8b619b890e884ceb 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