时间: 2022-03-21 09:49:54,037
  线程ID: 64
日志级别: 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.[04cd6a37-9ea1-4fab-8f09-677a83040d54]
FROM [##f38ab31aef0243ac9d9480bdf900636c]
ORDER BY Goods_no


    时间: 2022-03-21 09:49:55,096
  线程ID: 105
日志级别: 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.[04cd6a37-9ea1-4fab-8f09-677a83040d54]
FROM [##37780e1ee24b47a39bbb681c9a877817]
ORDER BY Goods_no


    时间: 2022-03-21 09:50:06,601
  线程ID: 64
日志级别: 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 [##b6a51f41585241848c72e3e681997ff4]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-03-21 09:50:07,057
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##a319b10012fa440fa7f4caa6aa5acde6] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-03-21 09:50:07,059
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b6a51f41585241848c72e3e681997ff4] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##a319b10012fa440fa7f4caa6aa5acde6]


    时间: 2022-03-21 09:50:07,142
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##aa8242e7c07f4d0f9c2c42f55ec27577 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-03-21 09:50:07,145
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##aa8242e7c07f4d0f9c2c42f55ec27577 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-03-21 09:50:07,148
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##aa8242e7c07f4d0f9c2c42f55ec27577 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2022-03-21 09:50:07,186
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##aa8242e7c07f4d0f9c2c42f55ec27577 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-03-21 09:50:07,188
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##aa8242e7c07f4d0f9c2c42f55ec27577 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-03-21 09:50:07,192
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b6a51f41585241848c72e3e681997ff4] (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 [##03a916cf323b4122bd0e12eed7b30240]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-03-21 09:50:07,702
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##c3a7e87d329d4a4e925da2e62f4b0241] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-03-21 09:50:07,704
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b6a51f41585241848c72e3e681997ff4] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##c3a7e87d329d4a4e925da2e62f4b0241]


    时间: 2022-03-21 09:50:07,721
  线程ID: 64
日志级别: 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 [货品名称], CAST(NULL AS IMAGE) AS [图片], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], SUM([渠道在途#数量]) AS [渠道在途]
INTO tempdb.dbo.[53826217-2cd4-4b7e-9195-f888b8764c72]
FROM ##b6a51f41585241848c72e3e681997ff4 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


    时间: 2022-03-21 10:00:36,915
  线程ID: 111
日志级别: 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.[04cd6a37-9ea1-4fab-8f09-677a83040d54]
FROM [##9ea5fdafab3e49458c994d75258ddbcc]
ORDER BY Goods_no


    时间: 2022-03-21 10:00:46,366
  线程ID: 66
日志级别: 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 [##192cb8e76f1841bdb59bac4384623d86]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-03-21 10:00:46,707
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##588381faa1a64a5e93344cbaa2bab21c] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-03-21 10:00:46,709
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##192cb8e76f1841bdb59bac4384623d86] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##588381faa1a64a5e93344cbaa2bab21c]


    时间: 2022-03-21 10:00:46,780
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##239cd2881b2b4c39a60f011b6155359b a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-03-21 10:00:46,782
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##239cd2881b2b4c39a60f011b6155359b SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-03-21 10:00:46,785
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##239cd2881b2b4c39a60f011b6155359b a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2022-03-21 10:00:46,824
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##239cd2881b2b4c39a60f011b6155359b SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-03-21 10:00:46,825
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##239cd2881b2b4c39a60f011b6155359b SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-03-21 10:00:46,829
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##192cb8e76f1841bdb59bac4384623d86] (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 [##51cdbbdea913455cbbe532d633bffb81]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-03-21 10:00:47,301
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##74459c0f6a5443aa9e20ad7ddcd26fda] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-03-21 10:00:47,302
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##192cb8e76f1841bdb59bac4384623d86] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##74459c0f6a5443aa9e20ad7ddcd26fda]


    时间: 2022-03-21 10:00:47,304
  线程ID: 66
日志级别: 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 [货品名称], CAST(NULL AS IMAGE) AS [图片], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], SUM([渠道在途#数量]) AS [渠道在途]
INTO tempdb.dbo.[53826217-2cd4-4b7e-9195-f888b8764c72]
FROM ##192cb8e76f1841bdb59bac4384623d86 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


    时间: 2022-03-21 11:17:12,242
  线程ID: 107
日志级别: 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.[04cd6a37-9ea1-4fab-8f09-677a83040d54]
FROM [##1a4f7f4c14694d4bbc5866ec12c6679b]
ORDER BY Goods_no


    时间: 2022-03-21 11:17:24,866
  线程ID: 109
日志级别: 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 [##d33ab3c7d82a4cf4bb459037540d4490]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-03-21 11:17:25,212
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##686049f5ee6f4439acca69099db1fbb0] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-03-21 11:17:25,214
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##d33ab3c7d82a4cf4bb459037540d4490] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##686049f5ee6f4439acca69099db1fbb0]


    时间: 2022-03-21 11:17:25,283
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##a616a0b67b044cbaa90e56836da72d2b a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-03-21 11:17:25,286
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##a616a0b67b044cbaa90e56836da72d2b SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-03-21 11:17:25,289
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##a616a0b67b044cbaa90e56836da72d2b a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2022-03-21 11:17:25,313
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##a616a0b67b044cbaa90e56836da72d2b SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-03-21 11:17:25,315
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##a616a0b67b044cbaa90e56836da72d2b SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-03-21 11:17:25,318
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##d33ab3c7d82a4cf4bb459037540d4490] (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 [##3d2dcfd076b246778cf21b9623e9f913]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-03-21 11:17:25,767
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##0b5475e7648e48b5aa152ff2b73cdb3a] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-03-21 11:17:25,769
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##d33ab3c7d82a4cf4bb459037540d4490] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##0b5475e7648e48b5aa152ff2b73cdb3a]


    时间: 2022-03-21 11:17:25,771
  线程ID: 109
日志级别: 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 [货品名称], CAST(NULL AS IMAGE) AS [图片], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], SUM([渠道在途#数量]) AS [渠道在途]
INTO tempdb.dbo.[53826217-2cd4-4b7e-9195-f888b8764c72]
FROM ##d33ab3c7d82a4cf4bb459037540d4490 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


    时间: 2022-03-21 11:18:20,897
  线程ID: 66
日志级别: 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.[04cd6a37-9ea1-4fab-8f09-677a83040d54]
FROM [##8ab10fb9d4a549d492a6dc33e95529ad]
ORDER BY Goods_no


    时间: 2022-03-21 11:18:23,996
  线程ID: 111
日志级别: 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.[04cd6a37-9ea1-4fab-8f09-677a83040d54]
FROM [##310a90eda943452bb4d2094de364fe38]
ORDER BY Goods_no


    时间: 2022-03-21 11:18:33,081
  线程ID: 109
日志级别: 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 [##e4bdf418b1cc45ef9d5330c1ac4933e0]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-03-21 11:18:33,424
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##ad702bff05e7478fb440894738ac2c46] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-03-21 11:18:33,426
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##e4bdf418b1cc45ef9d5330c1ac4933e0] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##ad702bff05e7478fb440894738ac2c46]


    时间: 2022-03-21 11:18:33,496
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##7497f353b4b344679df82d6f622505fa a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-03-21 11:18:33,499
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##7497f353b4b344679df82d6f622505fa SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-03-21 11:18:33,501
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##7497f353b4b344679df82d6f622505fa a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2022-03-21 11:18:33,533
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##7497f353b4b344679df82d6f622505fa SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-03-21 11:18:33,534
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##7497f353b4b344679df82d6f622505fa SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-03-21 11:18:33,537
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##e4bdf418b1cc45ef9d5330c1ac4933e0] (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 [##c7b2b32a1ee64dfa9a75c11463614990]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-03-21 11:18:34,032
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##db38b6f8c56d46b989e7d9c361d04b79] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-03-21 11:18:34,034
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##e4bdf418b1cc45ef9d5330c1ac4933e0] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##db38b6f8c56d46b989e7d9c361d04b79]


    时间: 2022-03-21 11:18:34,035
  线程ID: 109
日志级别: 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 [货品名称], CAST(NULL AS IMAGE) AS [图片], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], SUM([渠道在途#数量]) AS [渠道在途]
INTO tempdb.dbo.[53826217-2cd4-4b7e-9195-f888b8764c72]
FROM ##e4bdf418b1cc45ef9d5330c1ac4933e0 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


    时间: 2022-03-21 13:19:49,991
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  SELECT A.VIP_Card, A.Customer_ID, A.CheckDate, A.CheckID, B.Goods_No
         , ISNULL(B.Quantity, 0) Quantity, ISNULL(B.Quantity,0) * ISNULL(B.DiscountPrice,0) DiscountAmount, b.Discount, ISNULL(b.Integral,0) Integral
 INTO ##f596b10b0c214d2992cce28d863bf0ac
 FROM [Check] A 
     INNER JOIN CheckGoods B ON A.CheckID = B.CheckID
     INNER JOIN Goods G ON B.Goods_No = G.Goods_no 
     INNER JOIN CustomerVIP V ON A.VIP_Card=V.VIP 
     INNER JOIN Customer C ON A.Customer_ID = C.Customer_id 
     LEFT JOIN CUSTOMER CV ON v.CUSTOMER_ID = CV.CUSTOMER_ID
     LEFT JOIN CUSTOMER CV2 ON v.OriginalCustomer = CV2.CUSTOMER_ID
 WHERE LEN(ISNULL(A.VIP_Card, '')) > 0 AND A.Posted = 1 
 AND A.CheckDate >= '2021/1/1 0:00:00'  
 AND A.CheckDate <= '2022/3/21 0:00:00'  
 AND EXISTS (SELECT 1 FROM ##4d67c40dee884cd4b7e4be2c21eba05f WHERE Customer_ID = a.Customer_ID) 
  AND EXISTS (SELECT 1 FROM ##8ac44f3e708d4ec2a496460a841df784 WHERE VIP = A.VIP_Card) 
 

    时间: 2022-03-21 13:19:50,388
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##f596b10b0c214d2992cce28d863bf0ac
 SELECT A.VIP_Card, A.Customer_ID, A.CheckDate, A.CheckID, B.Goods_No
         , ISNULL(B.Quantity, 0) Quantity, ISNULL(B.Quantity,0) * ISNULL(B.DiscountPrice,0) DiscountAmount, b.Discount, ISNULL(b.Integral,0) Integral
 FROM [CheckL] A 
     INNER JOIN CheckLGoods B ON A.CheckID = B.CheckID
     INNER JOIN Goods G ON B.Goods_No = G.Goods_no 
     INNER JOIN CustomerVIP V ON A.VIP_Card = V.VIP 
     INNER JOIN Customer C ON A.Customer_ID = C.Customer_id 
     LEFT JOIN CUSTOMER CV ON v.CUSTOMER_ID = CV.CUSTOMER_ID
     LEFT JOIN CUSTOMER CV2 ON v.OriginalCustomer = CV2.CUSTOMER_ID
 WHERE LEN(ISNULL(A.VIP_Card, '')) > 0 AND A.Posted = 1 
 AND A.CheckDate >= '2021/1/1 0:00:00'  
 AND A.CheckDate <= '2022/3/21 0:00:00'  
 AND EXISTS (SELECT 1 FROM ##4d67c40dee884cd4b7e4be2c21eba05f WHERE Customer_ID = A.Customer_ID) 
  AND EXISTS (SELECT 1 FROM ##8ac44f3e708d4ec2a496460a841df784 WHERE VIP = A.VIP_Card) 
 

    时间: 2022-03-21 13:19:50,483
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber , A.CheckID AS [核销单], CONVERT(VARCHAR(20), A.CheckDate, 23) AS [日期], a.VIP_Card AS [Vip卡号], V.Name AS [Vip姓名], A.Customer_ID AS [渠道编号], CV.Abbrev AS [渠道简称], A.Goods_No AS [货号], SUM(A.Quantity) AS [数量], SUM(DiscountAmount) AS [金额], A.Discount AS [折扣], SUM(A.Integral) AS [积分], CAST(NULL AS IMAGE) AS [图片] 
   INTO tempdb.dbo.[dae2aa79-c38a-4314-a349-7486268050d5] 
FROM ##f596b10b0c214d2992cce28d863bf0ac A 
   INNER JOIN CustomerVIP V ON A.VIP_Card = V.VIP 
   LEFT JOIN Customer CV ON A.CUSTOMER_ID = CV.CUSTOMER_ID 
GROUP BY  A.CheckID, CONVERT(VARCHAR(20), A.CheckDate, 23), a.VIP_Card, V.Name, A.Customer_ID, CV.Abbrev, A.Goods_No, A.Discount
ORDER BY  A.CheckID, CONVERT(VARCHAR(20), A.CheckDate, 23), a.VIP_Card, V.Name, A.Customer_ID, CV.Abbrev, A.Goods_No, A.Discount


    时间: 2022-03-21 16:04:29,116
  线程ID: 107
日志级别: 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.[04cd6a37-9ea1-4fab-8f09-677a83040d54]
FROM [##9265fe0b70e84a628b587968f8f9f3c1]
ORDER BY Goods_no


    时间: 2022-03-21 16:04:39,092
  线程ID: 109
日志级别: 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 [##edf2f08056094f4cb0a7094960562ab4]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-03-21 16:04:39,444
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##edd13ab3c82f4edb8e75a40148ca11c1] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-03-21 16:04:39,445
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##edf2f08056094f4cb0a7094960562ab4] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##edd13ab3c82f4edb8e75a40148ca11c1]


    时间: 2022-03-21 16:04:39,519
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##ac9ac06c47884f19900688a3d907e635 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-03-21 16:04:39,522
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##ac9ac06c47884f19900688a3d907e635 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-03-21 16:04:39,525
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##ac9ac06c47884f19900688a3d907e635 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2022-03-21 16:04:39,555
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##ac9ac06c47884f19900688a3d907e635 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-03-21 16:04:39,556
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##ac9ac06c47884f19900688a3d907e635 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-03-21 16:04:39,559
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##edf2f08056094f4cb0a7094960562ab4] (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 [##448664c3b03844dcb016860fa2290b69]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-03-21 16:04:40,006
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##0344cdd1ffe04e4285b5a39802f2d710] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-03-21 16:04:40,007
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##edf2f08056094f4cb0a7094960562ab4] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##0344cdd1ffe04e4285b5a39802f2d710]


    时间: 2022-03-21 16:04:40,009
  线程ID: 109
日志级别: 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 [货品名称], CAST(NULL AS IMAGE) AS [图片], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], SUM([渠道在途#数量]) AS [渠道在途]
INTO tempdb.dbo.[53826217-2cd4-4b7e-9195-f888b8764c72]
FROM ##edf2f08056094f4cb0a7094960562ab4 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


    时间: 2022-03-21 16:39:42,102
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##fd5efd2af7ba42e1ae9de1cce7d6fd92] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-03-21 16:39:42,110
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##fd5efd2af7ba42e1ae9de1cce7d6fd92] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##fd5efd2af7ba42e1ae9de1cce7d6fd92] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##824e7a8809ef4e9faac7fc5cba854698] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-03-21 16:39:42,222
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##fd5efd2af7ba42e1ae9de1cce7d6fd92] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##fd5efd2af7ba42e1ae9de1cce7d6fd92] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##824e7a8809ef4e9faac7fc5cba854698] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-03-21 16:39:42,329
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##fd5efd2af7ba42e1ae9de1cce7d6fd92] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [ShopTinSSGoods] A 
             INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##fd5efd2af7ba42e1ae9de1cce7d6fd92 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##824e7a8809ef4e9faac7fc5cba854698] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-03-21 16:39:42,469
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##fd5efd2af7ba42e1ae9de1cce7d6fd92] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-03-21 16:39:42,471
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期]
, DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号]
, TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [零售额]
     , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[1050cd08-536d-40ac-86d0-1669ad573045]
 FROM [##fd5efd2af7ba42e1ae9de1cce7d6fd92]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-03-21 16:39:46,236
  线程ID: 110
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##37dc238098024472bf001c65123817cc] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-03-21 16:39:46,242
  线程ID: 110
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##37dc238098024472bf001c65123817cc] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##37dc238098024472bf001c65123817cc] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##dd9ba6f7349349e49c498af7df31e080] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-03-21 16:39:46,355
  线程ID: 110
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##37dc238098024472bf001c65123817cc] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##37dc238098024472bf001c65123817cc] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##dd9ba6f7349349e49c498af7df31e080] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-03-21 16:39:46,468
  线程ID: 110
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##37dc238098024472bf001c65123817cc] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [ShopTinSSGoods] A 
             INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##37dc238098024472bf001c65123817cc WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##dd9ba6f7349349e49c498af7df31e080] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-03-21 16:39:46,613
  线程ID: 110
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##37dc238098024472bf001c65123817cc] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-03-21 16:39:46,615
  线程ID: 110
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期]
, DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号]
, TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [零售额]
     , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[1050cd08-536d-40ac-86d0-1669ad573045]
 FROM [##37dc238098024472bf001c65123817cc]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-03-21 16:40:17,179
  线程ID: 110
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##1155ab27122d4ebd826c75cb46a26d77] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo )


    时间: 2022-03-21 16:40:17,186
  线程ID: 110
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##1155ab27122d4ebd826c75cb46a26d77] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT DealereturnID FROM Pureceipt 
      WHERE Type = 3 AND [##1155ab27122d4ebd826c75cb46a26d77].DealereturnID = DealereturnID)


    时间: 2022-03-21 16:40:17,200
  线程ID: 110
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##1155ab27122d4ebd826c75cb46a26d77] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END  
                              , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END  
 FROM [##1155ab27122d4ebd826c75cb46a26d77] A INNER JOIN  Pureceipt B ON A.DealereturnID = B.DealereturnID
 WHERE B.Type = 3 


    时间: 2022-03-21 16:40:17,215
  线程ID: 110
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0), BalanceAmount = ISNULL(B.BalanceAmount,0)
 FROM [##1155ab27122d4ebd826c75cb46a26d77] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
               , SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0)) BalanceAmount
        FROM [DealeReturnGoods] A 
             INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##1155ab27122d4ebd826c75cb46a26d77 WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##82f6b87b05d64a1ca6863ebecc5d326d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2022-03-21 16:40:17,386
  线程ID: 110
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##1155ab27122d4ebd826c75cb46a26d77] SET ReceiveQuantity = B.Quantity 
 FROM [##1155ab27122d4ebd826c75cb46a26d77] A INNER JOIN 
     ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity 
       FROM Pureceipt A 
            INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID 
        WHERE EXISTS( SELECT 1 FROM ##1155ab27122d4ebd826c75cb46a26d77 WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##82f6b87b05d64a1ca6863ebecc5d326d] WHERE Goods_No = C.Goods_No)
       GROUP BY A.DealereturnID 
      ) B ON A.DealereturnID = B.DealereturnID 


    时间: 2022-03-21 16:40:17,756
  线程ID: 110
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##1155ab27122d4ebd826c75cb46a26d77] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 

    时间: 2022-03-21 16:40:17,761
  线程ID: 110
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期]
, rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号]
, Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [零售额]
     , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数]
     , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[21011b2c-5ef6-4549-8d04-f32ac9403c19]
 FROM [##1155ab27122d4ebd826c75cb46a26d77]
 ORDER BY Return_Date DESC, DealereturnID ASC


    时间: 2022-03-21 16:40:49,133
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##acd9afd6a5ca4941be8979361d41b057] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CMoveOut' AND A.ShopToutID = BillNo )


    时间: 2022-03-21 16:40:49,141
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##acd9afd6a5ca4941be8979361d41b057] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT ShopToutID FROM ShopTin 
      WHERE 1 = 1 AND [##acd9afd6a5ca4941be8979361d41b057].ShopToutID = ShopToutID)


    时间: 2022-03-21 16:40:49,150
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##acd9afd6a5ca4941be8979361d41b057] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##acd9afd6a5ca4941be8979361d41b057] A INNER JOIN  ShopTin B ON A.ShopToutID = B.ShopToutID
 WHERE 1 = 1 


    时间: 2022-03-21 16:40:49,157
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##acd9afd6a5ca4941be8979361d41b057] A
    INNER JOIN (
        SELECT A.ShopToutID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [ShopToutGoods] A 
             INNER JOIN ShopTout B ON A.ShopToutID = B.ShopToutID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.ToutShop = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##acd9afd6a5ca4941be8979361d41b057 WHERE A.ShopToutID = ShopToutID )
     AND EXISTS (SELECT 1 FROM [##4199d30a6c804f3dacd8263c252b13c0] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopToutID
    ) B ON A.ShopToutID = B.ShopToutID


    时间: 2022-03-21 16:40:49,278
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ShopTinQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) 
 FROM [##acd9afd6a5ca4941be8979361d41b057] A
    INNER JOIN (
        SELECT A.ShopToutID, SUM(B.Quantity) AS Quantity 
        FROM ShopTin A 
        INNER JOIN [ShopTinSSGoods] B ON A.ShopTinID = B.ShopTinID
        WHERE EXISTS( SELECT 1 FROM [##acd9afd6a5ca4941be8979361d41b057] WHERE A.ShopToutID = ShopToutID )
     AND EXISTS (SELECT 1 FROM [##4199d30a6c804f3dacd8263c252b13c0] WHERE Goods_No = B.Goods_No)
        GROUP BY A.ShopToutID
    ) B ON A.ShopToutID = B.ShopToutID


    时间: 2022-03-21 16:40:49,556
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##acd9afd6a5ca4941be8979361d41b057] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ShopTinQuantity,0) 

    时间: 2022-03-21 16:40:49,560
  线程ID: 111
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopToutID AS [单号], Manual_ID AS [手工单号], Tout_Date AS [日期]
, ShopApplyOutID AS [调出通知单], rtrim(ToutShop) AS [调出渠道编号], ToutShopAbbrev AS [调出渠道简称], rtrim(TinShop) AS [调入渠道编号]
, TinShopAbbrev AS [调入渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , ShopTinQuantity AS [业务状态#调入数], ChangeQuantity AS [业务状态#差异数]
     , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[5829bbd8-4173-4800-931a-02287fe3c433]
 FROM [##acd9afd6a5ca4941be8979361d41b057]
 ORDER BY Tout_Date DESC, ShopToutID ASC


    时间: 2022-03-21 18:29:46,898
  线程ID: 94
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[04cd6a37-9ea1-4fab-8f09-677a83040d54]
FROM [##748d6086c3a649e2b3b77d385cdbd4f1]
ORDER BY Goods_no


    时间: 2022-03-21 18:29:56,607
  线程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 [##6a9a04fd241f4c0e877601172aaac236]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-03-21 18:29:56,986
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##a7f0d46e40a74abdae76634d45a9c8e6] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-03-21 18:29:56,988
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##6a9a04fd241f4c0e877601172aaac236] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##a7f0d46e40a74abdae76634d45a9c8e6]


    时间: 2022-03-21 18:29:57,062
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##1194a15a7bdd4ae0b5f0a429346338aa a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-03-21 18:29:57,065
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##1194a15a7bdd4ae0b5f0a429346338aa SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-03-21 18:29:57,068
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##1194a15a7bdd4ae0b5f0a429346338aa a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2022-03-21 18:29:57,097
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##1194a15a7bdd4ae0b5f0a429346338aa SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-03-21 18:29:57,099
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##1194a15a7bdd4ae0b5f0a429346338aa SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-03-21 18:29:57,101
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##6a9a04fd241f4c0e877601172aaac236] (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 [##0c6280b2ee7f44f981c45550172bc994]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-03-21 18:29:57,588
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##6477a8fa47244149954c7dd4b4cafbab] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-03-21 18:29:57,589
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##6a9a04fd241f4c0e877601172aaac236] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##6477a8fa47244149954c7dd4b4cafbab]


    时间: 2022-03-21 18:29:57,591
  线程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 [货品名称], CAST(NULL AS IMAGE) AS [图片], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], SUM([渠道在途#数量]) AS [渠道在途]
INTO tempdb.dbo.[53826217-2cd4-4b7e-9195-f888b8764c72]
FROM ##6a9a04fd241f4c0e877601172aaac236 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


    时间: 2022-03-21 22:12:33,178
  线程ID: 97
日志级别: 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.[04cd6a37-9ea1-4fab-8f09-677a83040d54]
FROM [##0a122c126aee4ae289cd6b4270389fd7]
ORDER BY Goods_no


    时间: 2022-03-21 22:12:34,129
  线程ID: 54
日志级别: 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.[04cd6a37-9ea1-4fab-8f09-677a83040d54]
FROM [##788d151f532e46829f7822c7de995db3]
ORDER BY Goods_no


    时间: 2022-03-21 22:12:50,250
  线程ID: 115
日志级别: 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.[04cd6a37-9ea1-4fab-8f09-677a83040d54]
FROM [##f3b46e89ac3744f5bcad7ef3e7d296f6]
ORDER BY Goods_no


    时间: 2022-03-21 22:14:27,401
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##b3bf16ee16c94951b6783e5fc61b146b] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##b3bf16ee16c94951b6783e5fc61b146b] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##064f13d840e8441db1562de2bd0656f6] 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 [##b3bf16ee16c94951b6783e5fc61b146b] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##b3bf16ee16c94951b6783e5fc61b146b] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##064f13d840e8441db1562de2bd0656f6] 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 [##b3bf16ee16c94951b6783e5fc61b146b] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##b3bf16ee16c94951b6783e5fc61b146b] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##064f13d840e8441db1562de2bd0656f6] 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 [##b3bf16ee16c94951b6783e5fc61b146b] 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 [##064f13d840e8441db1562de2bd0656f6] 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 [##b3bf16ee16c94951b6783e5fc61b146b] 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 [##b3bf16ee16c94951b6783e5fc61b146b] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##064f13d840e8441db1562de2bd0656f6] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-03-21 22:14:28,602
  线程ID: 54
日志级别: 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.[24cd80ed-650e-416a-841c-b4957986e804]
 FROM [##b3bf16ee16c94951b6783e5fc61b146b] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2022-03-21 22:14:30,094
  线程ID: 90
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##cb70d602441d471e92b3fefd9021f91e] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##cb70d602441d471e92b3fefd9021f91e] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##9eb6666648564fb884ba5fe017b71f96] 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 [##cb70d602441d471e92b3fefd9021f91e] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##cb70d602441d471e92b3fefd9021f91e] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##9eb6666648564fb884ba5fe017b71f96] 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 [##cb70d602441d471e92b3fefd9021f91e] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##cb70d602441d471e92b3fefd9021f91e] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##9eb6666648564fb884ba5fe017b71f96] 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 [##cb70d602441d471e92b3fefd9021f91e] 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 [##9eb6666648564fb884ba5fe017b71f96] 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 [##cb70d602441d471e92b3fefd9021f91e] 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 [##cb70d602441d471e92b3fefd9021f91e] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##9eb6666648564fb884ba5fe017b71f96] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-03-21 22:14:31,270
  线程ID: 90
日志级别: 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.[24cd80ed-650e-416a-841c-b4957986e804]
 FROM [##cb70d602441d471e92b3fefd9021f91e] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2022-03-21 22:31:17,183
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##1c97de6c4a024992901ee18e06c00c40] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##1c97de6c4a024992901ee18e06c00c40] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##deefb7bca391465fbff91135e9f3033e] 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 [##1c97de6c4a024992901ee18e06c00c40] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##1c97de6c4a024992901ee18e06c00c40] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##deefb7bca391465fbff91135e9f3033e] 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 [##1c97de6c4a024992901ee18e06c00c40] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##1c97de6c4a024992901ee18e06c00c40] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##deefb7bca391465fbff91135e9f3033e] 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 [##1c97de6c4a024992901ee18e06c00c40] 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 [##deefb7bca391465fbff91135e9f3033e] 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 [##1c97de6c4a024992901ee18e06c00c40] 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 [##1c97de6c4a024992901ee18e06c00c40] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##deefb7bca391465fbff91135e9f3033e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-03-21 22:31:18,353
  线程ID: 9
日志级别: 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.[24cd80ed-650e-416a-841c-b4957986e804]
 FROM [##1c97de6c4a024992901ee18e06c00c40] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2022-03-21 22:38:57,617
  线程ID: 95
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称]
,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式]
,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额]
,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣]
,[Group] [组], Company_ID [公司编号], SaleMan [业务员]
,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别]
INTO tempdb.dbo.[5f1d9b6c-b788-451c-8c61-b4af09d6d74b]
 FROM Customer A
 INNER JOIN [##105c901730ec4dbaa664cc85e7b371ed] B ON A.Customer_ID = B.Customer_ID
 ORDER BY A.Customer_ID