时间: 2022-12-25 11:43:27,929
  线程ID: 70
日志级别: 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.[28102562-2f74-4abf-902e-581fd6da6ca0]
FROM [##f30fb83dd7da4c8882938e92b4d17511]
ORDER BY Goods_no


    时间: 2022-12-25 11:43:54,276
  线程ID: 8
日志级别: 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 [##0d82debcfce04adb805de5a244189b1c]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-12-25 11:43:54,656
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##dc719587b872438ea256363e072706d8] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-12-25 11:43:54,659
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0d82debcfce04adb805de5a244189b1c] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##dc719587b872438ea256363e072706d8]


    时间: 2022-12-25 11:43:54,737
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##97b46f6cf6c54707bb5b7c569bba2eff a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-12-25 11:43:54,740
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##97b46f6cf6c54707bb5b7c569bba2eff SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-12-25 11:43:54,744
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##97b46f6cf6c54707bb5b7c569bba2eff 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-12-25 11:43:54,775
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##97b46f6cf6c54707bb5b7c569bba2eff SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-12-25 11:43:54,777
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##97b46f6cf6c54707bb5b7c569bba2eff SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-12-25 11:43:54,781
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0d82debcfce04adb805de5a244189b1c] (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 [##0a7da457fdea4931961cb5e0b1ff55d9]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-12-25 11:43:54,797
  线程ID: 8
日志级别: 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 [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[822454f9-ba56-49be-9522-9d401c30f5f6]
FROM ##0d82debcfce04adb805de5a244189b1c 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

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


    时间: 2022-12-25 13:15:27,030
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long
    , CAST(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 占用数#数量
INTO [##c3d5bea3ad0a42aebaff60f77cbfe005]
FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W


    时间: 2022-12-25 13:15:27,255
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##c3d5bea3ad0a42aebaff60f77cbfe005] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##723e875a51e44b2590148eb99ff9b2b9] A
INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No


    时间: 2022-12-25 13:15:28,157
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##c3d5bea3ad0a42aebaff60f77cbfe005] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量)
SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##7977c3dad8264799b66f245ed6664e66] A
INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No


    时间: 2022-12-25 13:15:28,164
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##c3d5bea3ad0a42aebaff60f77cbfe005] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2022-12-25 13:15:34,926
  线程ID: 35
日志级别: 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 [##f7ff06da3d7f4affa3712a585fed8353]
FROM Customer A, Barcode B, DeliveryDetail C


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

    时间: 2022-12-25 13:15:35,298
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##f7ff06da3d7f4affa3712a585fed8353] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##6c6bceeac2fb41399d1b3c6ba4b19d49]


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


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


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


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


    时间: 2022-12-25 13:15:35,422
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##f7ff06da3d7f4affa3712a585fed8353] (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 [##19b5dcbef4424223a0275dbda077b965]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-12-25 13:15:35,429
  线程ID: 35
日志级别: 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 [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[822454f9-ba56-49be-9522-9d401c30f5f6]
FROM ##f7ff06da3d7f4affa3712a585fed8353 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

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


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


    时间: 2022-12-25 13:56:23,292
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##d67e72c6041948e196a618928cae69cd] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-12-25 13:56:23,294
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##14c5369bc1d6465893ae9f1707eba164] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##d67e72c6041948e196a618928cae69cd]


    时间: 2022-12-25 13:56:23,367
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##5592115c1c7547b9ba9bdec6beb92f1d a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


    时间: 2022-12-25 13:56:23,373
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##5592115c1c7547b9ba9bdec6beb92f1d 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-12-25 13:56:23,406
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##5592115c1c7547b9ba9bdec6beb92f1d SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-12-25 13:56:23,407
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##5592115c1c7547b9ba9bdec6beb92f1d SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-12-25 13:56:23,411
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##14c5369bc1d6465893ae9f1707eba164] (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 [##6acd2156387c4cd1a9865c2ae1a83ade]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-12-25 13:56:23,416
  线程ID: 98
日志级别: 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 [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[822454f9-ba56-49be-9522-9d401c30f5f6]
FROM ##14c5369bc1d6465893ae9f1707eba164 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

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


    时间: 2022-12-25 14:10:43,750
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##2e520dd28c304bec933dca7b6daede68] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2022-12-25 14:10:43,757
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##2e520dd28c304bec933dca7b6daede68] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##2e520dd28c304bec933dca7b6daede68] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2022-12-25 14:10:43,764
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 0 
 FROM [##2e520dd28c304bec933dca7b6daede68] A 
 WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 


    时间: 2022-12-25 14:10:43,769
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 1 
 FROM [##2e520dd28c304bec933dca7b6daede68] A 
 WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 


    时间: 2022-12-25 14:10:43,775
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##2e520dd28c304bec933dca7b6daede68 A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##2e520dd28c304bec933dca7b6daede68 WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##2179fd17e17e45e59d322e73c8d46293] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-12-25 14:10:43,832
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##2e520dd28c304bec933dca7b6daede68 A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##2e520dd28c304bec933dca7b6daede68 WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##2179fd17e17e45e59d322e73c8d46293] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2022-12-25 14:10:43,893
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##2e520dd28c304bec933dca7b6daede68 A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##2e520dd28c304bec933dca7b6daede68 WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##2179fd17e17e45e59d322e73c8d46293] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:10:44,005
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##2e520dd28c304bec933dca7b6daede68 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##2e520dd28c304bec933dca7b6daede68 WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##2179fd17e17e45e59d322e73c8d46293] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:10:44,605
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##2e520dd28c304bec933dca7b6daede68 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##2e520dd28c304bec933dca7b6daede68 C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##2179fd17e17e45e59d322e73c8d46293] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:10:44,955
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##2e520dd28c304bec933dca7b6daede68
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2022-12-25 14:10:44,956
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##2e520dd28c304bec933dca7b6daede68] A
    INNER JOIN (
        SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount
        FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo
        WHERE A.AccBillType = 'WareDelivery' 
          AND EXISTS( SELECT 1 FROM [##2e520dd28c304bec933dca7b6daede68] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:10:44,998
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号]
, Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号]
, CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号]
, Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [结算额]
     , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数]
     , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数]
     , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[ae75e79c-baf2-4564-8563-4d49773a3a60]
 FROM [##2e520dd28c304bec933dca7b6daede68]
 ORDER BY Delivery_Date DESC, DeliveryID ASC


    时间: 2022-12-25 14:10:45,391
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##8258ed5061dc4575a877bb741be9085a] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2022-12-25 14:10:45,397
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##8258ed5061dc4575a877bb741be9085a] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##8258ed5061dc4575a877bb741be9085a] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2022-12-25 14:10:45,404
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 0 
 FROM [##8258ed5061dc4575a877bb741be9085a] A 
 WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 


    时间: 2022-12-25 14:10:45,409
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 1 
 FROM [##8258ed5061dc4575a877bb741be9085a] A 
 WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 


    时间: 2022-12-25 14:10:45,414
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##8258ed5061dc4575a877bb741be9085a A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##8258ed5061dc4575a877bb741be9085a WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##392add71682943e79eb53c1a6647eaf0] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-12-25 14:10:45,477
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##8258ed5061dc4575a877bb741be9085a A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##8258ed5061dc4575a877bb741be9085a WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##392add71682943e79eb53c1a6647eaf0] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2022-12-25 14:10:45,549
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##8258ed5061dc4575a877bb741be9085a A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##8258ed5061dc4575a877bb741be9085a WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##392add71682943e79eb53c1a6647eaf0] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:10:45,660
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##8258ed5061dc4575a877bb741be9085a A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##8258ed5061dc4575a877bb741be9085a WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##392add71682943e79eb53c1a6647eaf0] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:10:46,253
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##8258ed5061dc4575a877bb741be9085a A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##8258ed5061dc4575a877bb741be9085a C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##392add71682943e79eb53c1a6647eaf0] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:10:46,606
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##8258ed5061dc4575a877bb741be9085a
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2022-12-25 14:10:46,607
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##8258ed5061dc4575a877bb741be9085a] A
    INNER JOIN (
        SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount
        FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo
        WHERE A.AccBillType = 'WareDelivery' 
          AND EXISTS( SELECT 1 FROM [##8258ed5061dc4575a877bb741be9085a] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:10:46,642
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号]
, Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号]
, CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号]
, Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [结算额]
     , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数]
     , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数]
     , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[861a5161-cf80-4dd5-ac46-33dd0c0bfdbc]
 FROM [##8258ed5061dc4575a877bb741be9085a]
 ORDER BY Delivery_Date DESC, DeliveryID ASC


    时间: 2022-12-25 14:11:55,049
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##21954d81a8804ed0a1624b545cc0575e] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2022-12-25 14:11:55,054
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##21954d81a8804ed0a1624b545cc0575e] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##21954d81a8804ed0a1624b545cc0575e] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2022-12-25 14:11:55,058
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 0 
 FROM [##21954d81a8804ed0a1624b545cc0575e] A 
 WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 


    时间: 2022-12-25 14:11:55,064
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 1 
 FROM [##21954d81a8804ed0a1624b545cc0575e] A 
 WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 


    时间: 2022-12-25 14:11:55,067
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##21954d81a8804ed0a1624b545cc0575e A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##21954d81a8804ed0a1624b545cc0575e WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##37352c18cea14010821f45642299bcb0] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-12-25 14:11:55,138
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##21954d81a8804ed0a1624b545cc0575e A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##21954d81a8804ed0a1624b545cc0575e WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##37352c18cea14010821f45642299bcb0] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2022-12-25 14:11:55,204
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##21954d81a8804ed0a1624b545cc0575e A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##21954d81a8804ed0a1624b545cc0575e WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##37352c18cea14010821f45642299bcb0] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:11:55,362
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##21954d81a8804ed0a1624b545cc0575e A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##21954d81a8804ed0a1624b545cc0575e WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##37352c18cea14010821f45642299bcb0] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:11:55,913
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##21954d81a8804ed0a1624b545cc0575e A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##21954d81a8804ed0a1624b545cc0575e C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##37352c18cea14010821f45642299bcb0] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:11:56,292
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##21954d81a8804ed0a1624b545cc0575e
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2022-12-25 14:11:56,294
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##21954d81a8804ed0a1624b545cc0575e] A
    INNER JOIN (
        SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount
        FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo
        WHERE A.AccBillType = 'WareDelivery' 
          AND EXISTS( SELECT 1 FROM [##21954d81a8804ed0a1624b545cc0575e] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:11:56,328
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号]
, Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号]
, CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号]
, Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [结算额]
     , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数]
     , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数]
     , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[119a4e9a-9da6-4c82-a6e2-99746bfdafd6]
 FROM [##21954d81a8804ed0a1624b545cc0575e]
 ORDER BY Delivery_Date DESC, DeliveryID ASC


    时间: 2022-12-25 14:11:56,729
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##0cdf11ebfa414edb9b1b6ef81e3ea494] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2022-12-25 14:11:56,735
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##0cdf11ebfa414edb9b1b6ef81e3ea494] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##0cdf11ebfa414edb9b1b6ef81e3ea494] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2022-12-25 14:11:56,741
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 0 
 FROM [##0cdf11ebfa414edb9b1b6ef81e3ea494] A 
 WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 


    时间: 2022-12-25 14:11:56,745
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 1 
 FROM [##0cdf11ebfa414edb9b1b6ef81e3ea494] A 
 WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 


    时间: 2022-12-25 14:11:56,749
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##0cdf11ebfa414edb9b1b6ef81e3ea494 A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##0cdf11ebfa414edb9b1b6ef81e3ea494 WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##74164acc1eb04102bf601d7bf668a0e5] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-12-25 14:11:56,806
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##0cdf11ebfa414edb9b1b6ef81e3ea494 A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##0cdf11ebfa414edb9b1b6ef81e3ea494 WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##74164acc1eb04102bf601d7bf668a0e5] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2022-12-25 14:11:56,862
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##0cdf11ebfa414edb9b1b6ef81e3ea494 A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##0cdf11ebfa414edb9b1b6ef81e3ea494 WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##74164acc1eb04102bf601d7bf668a0e5] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:11:56,986
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##0cdf11ebfa414edb9b1b6ef81e3ea494 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##0cdf11ebfa414edb9b1b6ef81e3ea494 WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##74164acc1eb04102bf601d7bf668a0e5] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:11:57,525
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##0cdf11ebfa414edb9b1b6ef81e3ea494 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##0cdf11ebfa414edb9b1b6ef81e3ea494 C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##74164acc1eb04102bf601d7bf668a0e5] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:11:57,906
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##0cdf11ebfa414edb9b1b6ef81e3ea494
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2022-12-25 14:11:57,908
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##0cdf11ebfa414edb9b1b6ef81e3ea494] A
    INNER JOIN (
        SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount
        FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo
        WHERE A.AccBillType = 'WareDelivery' 
          AND EXISTS( SELECT 1 FROM [##0cdf11ebfa414edb9b1b6ef81e3ea494] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:11:57,944
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号]
, Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号]
, CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号]
, Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [结算额]
     , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数]
     , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数]
     , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[ba35b5c7-d805-4670-9dac-2d36d169ad56]
 FROM [##0cdf11ebfa414edb9b1b6ef81e3ea494]
 ORDER BY Delivery_Date DESC, DeliveryID ASC


    时间: 2022-12-25 14:12:33,878
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##7f1eadba9da247cabfc8ab590e2e909a] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2022-12-25 14:12:33,885
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##7f1eadba9da247cabfc8ab590e2e909a] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##7f1eadba9da247cabfc8ab590e2e909a] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2022-12-25 14:12:33,891
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 0 
 FROM [##7f1eadba9da247cabfc8ab590e2e909a] A 
 WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 


    时间: 2022-12-25 14:12:33,900
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 1 
 FROM [##7f1eadba9da247cabfc8ab590e2e909a] A 
 WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 


    时间: 2022-12-25 14:12:33,907
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##7f1eadba9da247cabfc8ab590e2e909a A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##7f1eadba9da247cabfc8ab590e2e909a WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##661347f62ce6492684ab3131ba3f307c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-12-25 14:12:33,986
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##7f1eadba9da247cabfc8ab590e2e909a A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##7f1eadba9da247cabfc8ab590e2e909a WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##661347f62ce6492684ab3131ba3f307c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2022-12-25 14:12:34,067
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##7f1eadba9da247cabfc8ab590e2e909a A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##7f1eadba9da247cabfc8ab590e2e909a WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##661347f62ce6492684ab3131ba3f307c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:12:34,191
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##7f1eadba9da247cabfc8ab590e2e909a A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##7f1eadba9da247cabfc8ab590e2e909a WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##661347f62ce6492684ab3131ba3f307c] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:12:34,496
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##7f1eadba9da247cabfc8ab590e2e909a A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##7f1eadba9da247cabfc8ab590e2e909a C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##661347f62ce6492684ab3131ba3f307c] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:12:34,803
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##7f1eadba9da247cabfc8ab590e2e909a
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2022-12-25 14:12:34,804
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##7f1eadba9da247cabfc8ab590e2e909a] A
    INNER JOIN (
        SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount
        FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo
        WHERE A.AccBillType = 'WareDelivery' 
          AND EXISTS( SELECT 1 FROM [##7f1eadba9da247cabfc8ab590e2e909a] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:12:34,839
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号]
, Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号]
, CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号]
, Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [结算额]
     , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数]
     , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数]
     , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[0eeb042a-d93e-4893-afae-ecb7817dea51]
 FROM [##7f1eadba9da247cabfc8ab590e2e909a]
 ORDER BY Delivery_Date DESC, DeliveryID ASC


    时间: 2022-12-25 14:13:21,298
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##8e47ae936e994a65bd817b51a3b9581b] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2022-12-25 14:13:21,306
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##8e47ae936e994a65bd817b51a3b9581b] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##8e47ae936e994a65bd817b51a3b9581b] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2022-12-25 14:13:21,312
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 0 
 FROM [##8e47ae936e994a65bd817b51a3b9581b] A 
 WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 


    时间: 2022-12-25 14:13:21,323
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 1 
 FROM [##8e47ae936e994a65bd817b51a3b9581b] A 
 WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 


    时间: 2022-12-25 14:13:21,331
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##8e47ae936e994a65bd817b51a3b9581b A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##8e47ae936e994a65bd817b51a3b9581b WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##80d2221a2a2b431283dab84129968bad] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-12-25 14:13:21,412
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##8e47ae936e994a65bd817b51a3b9581b A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##8e47ae936e994a65bd817b51a3b9581b WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##80d2221a2a2b431283dab84129968bad] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2022-12-25 14:13:21,554
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##8e47ae936e994a65bd817b51a3b9581b A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##8e47ae936e994a65bd817b51a3b9581b WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##80d2221a2a2b431283dab84129968bad] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:13:21,674
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##8e47ae936e994a65bd817b51a3b9581b A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##8e47ae936e994a65bd817b51a3b9581b WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##80d2221a2a2b431283dab84129968bad] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:13:21,993
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##8e47ae936e994a65bd817b51a3b9581b A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##8e47ae936e994a65bd817b51a3b9581b C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##80d2221a2a2b431283dab84129968bad] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:13:22,297
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##8e47ae936e994a65bd817b51a3b9581b
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2022-12-25 14:13:22,299
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##8e47ae936e994a65bd817b51a3b9581b] A
    INNER JOIN (
        SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount
        FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo
        WHERE A.AccBillType = 'WareDelivery' 
          AND EXISTS( SELECT 1 FROM [##8e47ae936e994a65bd817b51a3b9581b] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-12-25 14:13:22,339
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号]
, Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号]
, CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号]
, Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [结算额]
     , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数]
     , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数]
     , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[0eeb042a-d93e-4893-afae-ecb7817dea51]
 FROM [##8e47ae936e994a65bd817b51a3b9581b]
 ORDER BY Delivery_Date DESC, DeliveryID ASC


    时间: 2022-12-25 14:16:30,674
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##ea409154d9564048ab4c43ba85191722] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:16:30,680
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##ea409154d9564048ab4c43ba85191722] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##ea409154d9564048ab4c43ba85191722] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##e727a8b36a6f466bab87e79cdc494116] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:16:30,788
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##ea409154d9564048ab4c43ba85191722] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##ea409154d9564048ab4c43ba85191722] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##e727a8b36a6f466bab87e79cdc494116] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:16:30,901
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##ea409154d9564048ab4c43ba85191722] 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 ##ea409154d9564048ab4c43ba85191722 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##e727a8b36a6f466bab87e79cdc494116] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:16:31,110
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##ea409154d9564048ab4c43ba85191722] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:16:31,112
  线程ID: 41
日志级别: 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.[2be521ab-002d-4afc-82b2-6727632fa191]
 FROM [##ea409154d9564048ab4c43ba85191722]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:16:31,452
  线程ID: 20
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##90973f31623a4865bcd5f082e94fcb6d] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:16:31,456
  线程ID: 20
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##90973f31623a4865bcd5f082e94fcb6d] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##90973f31623a4865bcd5f082e94fcb6d] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##e40618976972469995977498aa1bb1a8] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:16:31,560
  线程ID: 20
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##90973f31623a4865bcd5f082e94fcb6d] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##90973f31623a4865bcd5f082e94fcb6d] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##e40618976972469995977498aa1bb1a8] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:16:31,670
  线程ID: 20
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##90973f31623a4865bcd5f082e94fcb6d] 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 ##90973f31623a4865bcd5f082e94fcb6d WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##e40618976972469995977498aa1bb1a8] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:16:31,863
  线程ID: 20
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##90973f31623a4865bcd5f082e94fcb6d] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:16:31,865
  线程ID: 20
日志级别: 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.[bffbdf16-c434-4abe-86b7-ee616877209b]
 FROM [##90973f31623a4865bcd5f082e94fcb6d]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:17:25,843
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##79d380977f7e4dc28e30648b138f6e95] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:17:25,848
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##79d380977f7e4dc28e30648b138f6e95] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##79d380977f7e4dc28e30648b138f6e95] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##fa7e889bd9934a9a9ffefb84e465462c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:17:25,968
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##79d380977f7e4dc28e30648b138f6e95] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##79d380977f7e4dc28e30648b138f6e95] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##fa7e889bd9934a9a9ffefb84e465462c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:17:26,100
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##79d380977f7e4dc28e30648b138f6e95] 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 ##79d380977f7e4dc28e30648b138f6e95 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##fa7e889bd9934a9a9ffefb84e465462c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:17:26,361
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##79d380977f7e4dc28e30648b138f6e95] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:17:26,364
  线程ID: 60
日志级别: 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.[157c5bc1-7c3c-411c-b301-54f8364a0ead]
 FROM [##79d380977f7e4dc28e30648b138f6e95]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:17:26,774
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##6edb6e578a07434d8c0807f41d9e0500] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:17:26,777
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##6edb6e578a07434d8c0807f41d9e0500] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##6edb6e578a07434d8c0807f41d9e0500] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##eaba14e5865544319ad50a534d0d096f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:17:26,892
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##6edb6e578a07434d8c0807f41d9e0500] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##6edb6e578a07434d8c0807f41d9e0500] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##eaba14e5865544319ad50a534d0d096f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:17:26,996
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##6edb6e578a07434d8c0807f41d9e0500] 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 ##6edb6e578a07434d8c0807f41d9e0500 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##eaba14e5865544319ad50a534d0d096f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:17:27,197
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##6edb6e578a07434d8c0807f41d9e0500] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:17:27,199
  线程ID: 50
日志级别: 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.[a4a2f46c-73f0-48cc-b931-6bdaae82d6fb]
 FROM [##6edb6e578a07434d8c0807f41d9e0500]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:23:13,656
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##96f61c3eeb5949a991c0ffeb714f3f39] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:23:13,662
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##96f61c3eeb5949a991c0ffeb714f3f39] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##96f61c3eeb5949a991c0ffeb714f3f39] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##061854bebee043b186b7df5203eb1468] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:23:13,767
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##96f61c3eeb5949a991c0ffeb714f3f39] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##96f61c3eeb5949a991c0ffeb714f3f39] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##061854bebee043b186b7df5203eb1468] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:23:13,869
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##96f61c3eeb5949a991c0ffeb714f3f39] 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 ##96f61c3eeb5949a991c0ffeb714f3f39 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##061854bebee043b186b7df5203eb1468] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:23:14,065
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##96f61c3eeb5949a991c0ffeb714f3f39] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:23:14,067
  线程ID: 32
日志级别: 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.[77802050-2109-44c3-ab89-49a1d9644089]
 FROM [##96f61c3eeb5949a991c0ffeb714f3f39]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:23:25,223
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##94c837cdeb574f24ae67218b545a13ed] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:23:25,228
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##94c837cdeb574f24ae67218b545a13ed] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##94c837cdeb574f24ae67218b545a13ed] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##884011eb02694a588d5b2ac3cb54768e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:23:25,323
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##94c837cdeb574f24ae67218b545a13ed] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##94c837cdeb574f24ae67218b545a13ed] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##884011eb02694a588d5b2ac3cb54768e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:23:25,415
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##94c837cdeb574f24ae67218b545a13ed] 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 ##94c837cdeb574f24ae67218b545a13ed WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##884011eb02694a588d5b2ac3cb54768e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:23:25,584
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##94c837cdeb574f24ae67218b545a13ed] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:23:25,586
  线程ID: 32
日志级别: 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.[77802050-2109-44c3-ab89-49a1d9644089]
 FROM [##94c837cdeb574f24ae67218b545a13ed]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:23:44,429
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##f67b0e7ec8c2488eb8707f9d31aab10e] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo )


    时间: 2022-12-25 14:23:44,439
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##f67b0e7ec8c2488eb8707f9d31aab10e] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT DealereturnID FROM Pureceipt 
      WHERE Type = 3 AND [##f67b0e7ec8c2488eb8707f9d31aab10e].DealereturnID = DealereturnID)


    时间: 2022-12-25 14:23:44,446
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##f67b0e7ec8c2488eb8707f9d31aab10e] 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 [##f67b0e7ec8c2488eb8707f9d31aab10e] A INNER JOIN  Pureceipt B ON A.DealereturnID = B.DealereturnID
 WHERE B.Type = 3 


    时间: 2022-12-25 14:23:44,458
  线程ID: 41
日志级别: 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 [##f67b0e7ec8c2488eb8707f9d31aab10e] 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 ##f67b0e7ec8c2488eb8707f9d31aab10e WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##50fecce805314d0d9b14b2b01623d079] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2022-12-25 14:23:44,630
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##f67b0e7ec8c2488eb8707f9d31aab10e] SET ReceiveQuantity = B.Quantity 
 FROM [##f67b0e7ec8c2488eb8707f9d31aab10e] 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 ##f67b0e7ec8c2488eb8707f9d31aab10e WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##50fecce805314d0d9b14b2b01623d079] WHERE Goods_No = C.Goods_No)
       GROUP BY A.DealereturnID 
      ) B ON A.DealereturnID = B.DealereturnID 


    时间: 2022-12-25 14:23:45,002
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##f67b0e7ec8c2488eb8707f9d31aab10e] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 

    时间: 2022-12-25 14:23:45,005
  线程ID: 41
日志级别: 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.[0ce80338-dd35-43a3-a438-a10ca68ef7da]
 FROM [##f67b0e7ec8c2488eb8707f9d31aab10e]
 ORDER BY Return_Date DESC, DealereturnID ASC


    时间: 2022-12-25 14:24:13,457
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##351f808f19434f7c974a086ee9f546df] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:24:13,460
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##351f808f19434f7c974a086ee9f546df] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##351f808f19434f7c974a086ee9f546df] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##0773d76dd3c5428c94a576b4c76871ca] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:24:13,564
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##351f808f19434f7c974a086ee9f546df] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##351f808f19434f7c974a086ee9f546df] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##0773d76dd3c5428c94a576b4c76871ca] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:24:13,672
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##351f808f19434f7c974a086ee9f546df] 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 ##351f808f19434f7c974a086ee9f546df WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##0773d76dd3c5428c94a576b4c76871ca] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:24:13,867
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##351f808f19434f7c974a086ee9f546df] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:24:13,869
  线程ID: 60
日志级别: 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.[ec17eec9-bb8b-4642-8a12-0b33afb02d1b]
 FROM [##351f808f19434f7c974a086ee9f546df]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:24:23,526
  线程ID: 20
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##74016ed9af6340debd9cc442eb936ba2] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:24:23,530
  线程ID: 20
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##74016ed9af6340debd9cc442eb936ba2] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##74016ed9af6340debd9cc442eb936ba2] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##485277b1c4d64d8795a616f298d4543d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:24:23,633
  线程ID: 20
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##74016ed9af6340debd9cc442eb936ba2] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##74016ed9af6340debd9cc442eb936ba2] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##485277b1c4d64d8795a616f298d4543d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:24:23,735
  线程ID: 20
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##74016ed9af6340debd9cc442eb936ba2] 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 ##74016ed9af6340debd9cc442eb936ba2 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##485277b1c4d64d8795a616f298d4543d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:24:23,932
  线程ID: 20
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##74016ed9af6340debd9cc442eb936ba2] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:24:23,934
  线程ID: 20
日志级别: 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.[ec17eec9-bb8b-4642-8a12-0b33afb02d1b]
 FROM [##74016ed9af6340debd9cc442eb936ba2]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:24:41,781
  线程ID: 20
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##bafaafc13d5644cf940cba56f870c8fc] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:24:41,785
  线程ID: 20
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##bafaafc13d5644cf940cba56f870c8fc] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##bafaafc13d5644cf940cba56f870c8fc] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##c96c13571b5b4fd492717a1251794400] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:24:41,888
  线程ID: 20
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##bafaafc13d5644cf940cba56f870c8fc] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##bafaafc13d5644cf940cba56f870c8fc] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##c96c13571b5b4fd492717a1251794400] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:24:41,993
  线程ID: 20
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##bafaafc13d5644cf940cba56f870c8fc] 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 ##bafaafc13d5644cf940cba56f870c8fc WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##c96c13571b5b4fd492717a1251794400] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:24:42,184
  线程ID: 20
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##bafaafc13d5644cf940cba56f870c8fc] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:24:42,186
  线程ID: 20
日志级别: 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.[ec17eec9-bb8b-4642-8a12-0b33afb02d1b]
 FROM [##bafaafc13d5644cf940cba56f870c8fc]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:24:53,134
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##083af87134f648369db7a3c33ae1c1a9] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:24:53,139
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##083af87134f648369db7a3c33ae1c1a9] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##083af87134f648369db7a3c33ae1c1a9] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##b5828682d6f246fe85572285cfdfe262] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:24:53,261
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##083af87134f648369db7a3c33ae1c1a9] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##083af87134f648369db7a3c33ae1c1a9] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##b5828682d6f246fe85572285cfdfe262] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:24:53,362
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##083af87134f648369db7a3c33ae1c1a9] 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 ##083af87134f648369db7a3c33ae1c1a9 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##b5828682d6f246fe85572285cfdfe262] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:24:53,554
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##083af87134f648369db7a3c33ae1c1a9] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:24:53,556
  线程ID: 50
日志级别: 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.[ec17eec9-bb8b-4642-8a12-0b33afb02d1b]
 FROM [##083af87134f648369db7a3c33ae1c1a9]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:25:45,944
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##027fdbdd67d1454bb12851a666d3f62d] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CMoveIn' AND A.ShopTInID = BillNo )


    时间: 2022-12-25 14:25:45,950
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##027fdbdd67d1454bb12851a666d3f62d] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##027fdbdd67d1454bb12851a666d3f62d] A INNER JOIN  ShopTin B ON A.ShopTInID = B.ShopTInID
 WHERE 1 = 1 


    时间: 2022-12-25 14:25:45,955
  线程ID: 41
日志级别: 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 [##027fdbdd67d1454bb12851a666d3f62d] A
    INNER JOIN (
        SELECT A.ShopTinID, 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) ) As BalanceAmount
        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.ToutShop = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##027fdbdd67d1454bb12851a666d3f62d WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##f75a47b727cd4bc8b71ea57656404596] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:25:46,121
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) 
 FROM [##027fdbdd67d1454bb12851a666d3f62d] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(B.Quantity) AS Quantity 
        FROM ShopTin A 
        INNER JOIN [ShopTinGoods] B ON A.ShopTinID = B.ShopTinID
        WHERE EXISTS( SELECT 1 FROM [##027fdbdd67d1454bb12851a666d3f62d] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##f75a47b727cd4bc8b71ea57656404596] WHERE Goods_No = B.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:25:46,350
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##027fdbdd67d1454bb12851a666d3f62d] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END

    时间: 2022-12-25 14:25:46,353
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期]
, rtrim(ToutShop) AS [调出渠道编号], ToutShopAbv 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.[1ef7c4de-b8f3-4ba7-a0cf-c933119349e1]
 FROM [##027fdbdd67d1454bb12851a666d3f62d]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:25:54,557
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##7126f22f9a034635ae3824e293f8c440] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CMoveIn' AND A.ShopTInID = BillNo )


    时间: 2022-12-25 14:25:54,562
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##7126f22f9a034635ae3824e293f8c440] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##7126f22f9a034635ae3824e293f8c440] A INNER JOIN  ShopTin B ON A.ShopTInID = B.ShopTInID
 WHERE 1 = 1 


    时间: 2022-12-25 14:25:54,566
  线程ID: 41
日志级别: 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 [##7126f22f9a034635ae3824e293f8c440] A
    INNER JOIN (
        SELECT A.ShopTinID, 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) ) As BalanceAmount
        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.ToutShop = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##7126f22f9a034635ae3824e293f8c440 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##fdf1b4eaf2964e4892b01726a2e47974] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:25:54,729
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) 
 FROM [##7126f22f9a034635ae3824e293f8c440] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(B.Quantity) AS Quantity 
        FROM ShopTin A 
        INNER JOIN [ShopTinGoods] B ON A.ShopTinID = B.ShopTinID
        WHERE EXISTS( SELECT 1 FROM [##7126f22f9a034635ae3824e293f8c440] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##fdf1b4eaf2964e4892b01726a2e47974] WHERE Goods_No = B.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:25:54,957
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##7126f22f9a034635ae3824e293f8c440] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END

    时间: 2022-12-25 14:25:54,961
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期]
, rtrim(ToutShop) AS [调出渠道编号], ToutShopAbv 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.[1ef7c4de-b8f3-4ba7-a0cf-c933119349e1]
 FROM [##7126f22f9a034635ae3824e293f8c440]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:26:11,445
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##017b079858c94549811b3f91f82f1566] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CMoveIn' AND A.ShopTInID = BillNo )


    时间: 2022-12-25 14:26:11,448
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##017b079858c94549811b3f91f82f1566] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##017b079858c94549811b3f91f82f1566] A INNER JOIN  ShopTin B ON A.ShopTInID = B.ShopTInID
 WHERE 1 = 1 


    时间: 2022-12-25 14:26:11,453
  线程ID: 32
日志级别: 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 [##017b079858c94549811b3f91f82f1566] A
    INNER JOIN (
        SELECT A.ShopTinID, 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) ) As BalanceAmount
        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.ToutShop = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##017b079858c94549811b3f91f82f1566 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##a4b9f150b7af48bfb4794488c5e32fb2] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:26:11,610
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) 
 FROM [##017b079858c94549811b3f91f82f1566] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(B.Quantity) AS Quantity 
        FROM ShopTin A 
        INNER JOIN [ShopTinGoods] B ON A.ShopTinID = B.ShopTinID
        WHERE EXISTS( SELECT 1 FROM [##017b079858c94549811b3f91f82f1566] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##a4b9f150b7af48bfb4794488c5e32fb2] WHERE Goods_No = B.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:26:11,820
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##017b079858c94549811b3f91f82f1566] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END

    时间: 2022-12-25 14:26:11,823
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期]
, rtrim(ToutShop) AS [调出渠道编号], ToutShopAbv 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.[1ef7c4de-b8f3-4ba7-a0cf-c933119349e1]
 FROM [##017b079858c94549811b3f91f82f1566]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:27:02,596
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##b21141bce8474e0e8e74e4684fda3fca] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:27:02,600
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##b21141bce8474e0e8e74e4684fda3fca] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##b21141bce8474e0e8e74e4684fda3fca] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##2915cbb0804a46449d9103f8eb8484ea] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:27:02,696
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##b21141bce8474e0e8e74e4684fda3fca] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##b21141bce8474e0e8e74e4684fda3fca] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##2915cbb0804a46449d9103f8eb8484ea] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:27:02,793
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##b21141bce8474e0e8e74e4684fda3fca] 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 ##b21141bce8474e0e8e74e4684fda3fca WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##2915cbb0804a46449d9103f8eb8484ea] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:27:02,976
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##b21141bce8474e0e8e74e4684fda3fca] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:27:02,978
  线程ID: 50
日志级别: 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.[ec17eec9-bb8b-4642-8a12-0b33afb02d1b]
 FROM [##b21141bce8474e0e8e74e4684fda3fca]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:27:12,941
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##339566ceb8684d329aa2c9a62515384e] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:27:12,946
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##339566ceb8684d329aa2c9a62515384e] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##339566ceb8684d329aa2c9a62515384e] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##a2b6dc0ddc0044a0acb0f3568f810108] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:27:13,039
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##339566ceb8684d329aa2c9a62515384e] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##339566ceb8684d329aa2c9a62515384e] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##a2b6dc0ddc0044a0acb0f3568f810108] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:27:13,136
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##339566ceb8684d329aa2c9a62515384e] 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 ##339566ceb8684d329aa2c9a62515384e WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##a2b6dc0ddc0044a0acb0f3568f810108] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:27:13,311
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##339566ceb8684d329aa2c9a62515384e] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:27:13,313
  线程ID: 41
日志级别: 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.[ec17eec9-bb8b-4642-8a12-0b33afb02d1b]
 FROM [##339566ceb8684d329aa2c9a62515384e]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:27:20,480
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##a1c7c4fd306a4a9ea46b765e103ee796] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:27:20,485
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##a1c7c4fd306a4a9ea46b765e103ee796] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##a1c7c4fd306a4a9ea46b765e103ee796] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##41d9d59bcd8a45b5a90b6947cb8d378f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:27:20,578
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##a1c7c4fd306a4a9ea46b765e103ee796] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##a1c7c4fd306a4a9ea46b765e103ee796] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##41d9d59bcd8a45b5a90b6947cb8d378f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:27:20,676
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##a1c7c4fd306a4a9ea46b765e103ee796] 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 ##a1c7c4fd306a4a9ea46b765e103ee796 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##41d9d59bcd8a45b5a90b6947cb8d378f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:27:20,850
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##a1c7c4fd306a4a9ea46b765e103ee796] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:27:20,852
  线程ID: 60
日志级别: 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.[ec17eec9-bb8b-4642-8a12-0b33afb02d1b]
 FROM [##a1c7c4fd306a4a9ea46b765e103ee796]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:28:46,854
  线程ID: 83
日志级别: 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.[afd38008-e85c-40e3-8dcd-41986fb924b7]
FROM [##6c729967ce04498a9c4d27bc36eb5c5a]
ORDER BY Goods_no


    时间: 2022-12-25 14:29:02,655
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##49df22f730b048e7b0d0188fa40d831c] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:29:02,660
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##49df22f730b048e7b0d0188fa40d831c] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##49df22f730b048e7b0d0188fa40d831c] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##298792dc5b4147e3810febd6a5fcd09b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:29:02,742
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##49df22f730b048e7b0d0188fa40d831c] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##49df22f730b048e7b0d0188fa40d831c] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##298792dc5b4147e3810febd6a5fcd09b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:29:02,824
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##49df22f730b048e7b0d0188fa40d831c] 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 ##49df22f730b048e7b0d0188fa40d831c WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##298792dc5b4147e3810febd6a5fcd09b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:29:02,993
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##49df22f730b048e7b0d0188fa40d831c] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:29:02,996
  线程ID: 52
日志级别: 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.[ec17eec9-bb8b-4642-8a12-0b33afb02d1b]
 FROM [##49df22f730b048e7b0d0188fa40d831c]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:29:12,949
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##2f2ff32fc94a4f19bf60de352d1a3007] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:29:12,953
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##2f2ff32fc94a4f19bf60de352d1a3007] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##2f2ff32fc94a4f19bf60de352d1a3007] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##80a1d61a967c4a89bcd2be3e5b66896b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:29:13,037
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##2f2ff32fc94a4f19bf60de352d1a3007] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##2f2ff32fc94a4f19bf60de352d1a3007] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##80a1d61a967c4a89bcd2be3e5b66896b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:29:13,125
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##2f2ff32fc94a4f19bf60de352d1a3007] 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 ##2f2ff32fc94a4f19bf60de352d1a3007 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##80a1d61a967c4a89bcd2be3e5b66896b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:29:13,295
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##2f2ff32fc94a4f19bf60de352d1a3007] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:29:13,298
  线程ID: 52
日志级别: 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.[ec17eec9-bb8b-4642-8a12-0b33afb02d1b]
 FROM [##2f2ff32fc94a4f19bf60de352d1a3007]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:29:18,736
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##d8d3cdf81bfd41e4ad33b8b882e65e10] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:29:18,739
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##d8d3cdf81bfd41e4ad33b8b882e65e10] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##d8d3cdf81bfd41e4ad33b8b882e65e10] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##debed7fa68054adc84491b530bda2314] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:29:18,823
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##d8d3cdf81bfd41e4ad33b8b882e65e10] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##d8d3cdf81bfd41e4ad33b8b882e65e10] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##debed7fa68054adc84491b530bda2314] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:29:18,908
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##d8d3cdf81bfd41e4ad33b8b882e65e10] 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 ##d8d3cdf81bfd41e4ad33b8b882e65e10 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##debed7fa68054adc84491b530bda2314] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:29:19,083
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##d8d3cdf81bfd41e4ad33b8b882e65e10] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:29:19,084
  线程ID: 50
日志级别: 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.[ec17eec9-bb8b-4642-8a12-0b33afb02d1b]
 FROM [##d8d3cdf81bfd41e4ad33b8b882e65e10]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:29:24,853
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##11044418cc2e43dcb322d445b9dd10a4] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:29:24,857
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##11044418cc2e43dcb322d445b9dd10a4] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##11044418cc2e43dcb322d445b9dd10a4] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##6cb60459821c4e039a0d1337f8e99f90] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:29:24,945
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##11044418cc2e43dcb322d445b9dd10a4] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##11044418cc2e43dcb322d445b9dd10a4] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##6cb60459821c4e039a0d1337f8e99f90] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:29:25,032
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##11044418cc2e43dcb322d445b9dd10a4] 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 ##11044418cc2e43dcb322d445b9dd10a4 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##6cb60459821c4e039a0d1337f8e99f90] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:29:25,202
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##11044418cc2e43dcb322d445b9dd10a4] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:29:25,204
  线程ID: 50
日志级别: 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.[ec17eec9-bb8b-4642-8a12-0b33afb02d1b]
 FROM [##11044418cc2e43dcb322d445b9dd10a4]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:29:43,675
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##44c682f73ec647deabcf511368dedf44] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:29:43,680
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##44c682f73ec647deabcf511368dedf44] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##44c682f73ec647deabcf511368dedf44] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##619f159058054f53a367dd1949fb0042] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:29:43,793
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##44c682f73ec647deabcf511368dedf44] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##44c682f73ec647deabcf511368dedf44] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##619f159058054f53a367dd1949fb0042] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:29:43,910
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##44c682f73ec647deabcf511368dedf44] 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 ##44c682f73ec647deabcf511368dedf44 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##619f159058054f53a367dd1949fb0042] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:29:44,093
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##44c682f73ec647deabcf511368dedf44] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:29:44,095
  线程ID: 52
日志级别: 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.[18928104-018d-47d6-ac72-16f3183e97e3]
 FROM [##44c682f73ec647deabcf511368dedf44]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:29:44,476
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##15f7559e5fbc4ddbaa0dbbec9b0f3c21] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:29:44,481
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##15f7559e5fbc4ddbaa0dbbec9b0f3c21] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##15f7559e5fbc4ddbaa0dbbec9b0f3c21] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##f836cd3cd13d484b8019765f2e59753f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:29:44,594
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##15f7559e5fbc4ddbaa0dbbec9b0f3c21] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##15f7559e5fbc4ddbaa0dbbec9b0f3c21] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##f836cd3cd13d484b8019765f2e59753f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:29:44,711
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##15f7559e5fbc4ddbaa0dbbec9b0f3c21] 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 ##15f7559e5fbc4ddbaa0dbbec9b0f3c21 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##f836cd3cd13d484b8019765f2e59753f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:29:44,894
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##15f7559e5fbc4ddbaa0dbbec9b0f3c21] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:29:44,896
  线程ID: 60
日志级别: 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.[1cf98054-00ed-469a-a604-dfaa2908f189]
 FROM [##15f7559e5fbc4ddbaa0dbbec9b0f3c21]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:32:35,673
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##c92115d95abc469992575c685106b2d8] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:32:35,678
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##c92115d95abc469992575c685106b2d8] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##c92115d95abc469992575c685106b2d8] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##089a78e12ea2443ea360a40c88cb21e4] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:32:35,791
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##c92115d95abc469992575c685106b2d8] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##c92115d95abc469992575c685106b2d8] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##089a78e12ea2443ea360a40c88cb21e4] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:32:35,908
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##c92115d95abc469992575c685106b2d8] 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 ##c92115d95abc469992575c685106b2d8 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##089a78e12ea2443ea360a40c88cb21e4] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:32:36,088
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##c92115d95abc469992575c685106b2d8] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:32:36,090
  线程ID: 60
日志级别: 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.[cf1295e6-6a25-4c71-8064-d1700b16775f]
 FROM [##c92115d95abc469992575c685106b2d8]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:37:55,977
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##5e10c76ae8404953a256a7ecb9ae3e6c] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo )


    时间: 2022-12-25 14:37:55,982
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##5e10c76ae8404953a256a7ecb9ae3e6c] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT DealereturnID FROM Pureceipt 
      WHERE Type = 3 AND [##5e10c76ae8404953a256a7ecb9ae3e6c].DealereturnID = DealereturnID)


    时间: 2022-12-25 14:37:55,988
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##5e10c76ae8404953a256a7ecb9ae3e6c] 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 [##5e10c76ae8404953a256a7ecb9ae3e6c] A INNER JOIN  Pureceipt B ON A.DealereturnID = B.DealereturnID
 WHERE B.Type = 3 


    时间: 2022-12-25 14:37:56,001
  线程ID: 50
日志级别: 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 [##5e10c76ae8404953a256a7ecb9ae3e6c] 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 ##5e10c76ae8404953a256a7ecb9ae3e6c WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##2c8cbde093c3405086fe0315a0ebd507] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2022-12-25 14:37:56,188
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##5e10c76ae8404953a256a7ecb9ae3e6c] SET ReceiveQuantity = B.Quantity 
 FROM [##5e10c76ae8404953a256a7ecb9ae3e6c] 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 ##5e10c76ae8404953a256a7ecb9ae3e6c WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##2c8cbde093c3405086fe0315a0ebd507] WHERE Goods_No = C.Goods_No)
       GROUP BY A.DealereturnID 
      ) B ON A.DealereturnID = B.DealereturnID 


    时间: 2022-12-25 14:37:56,567
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##5e10c76ae8404953a256a7ecb9ae3e6c] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 

    时间: 2022-12-25 14:37:56,570
  线程ID: 50
日志级别: 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.[7ac0e59c-d647-48d3-bf95-13832c8a488d]
 FROM [##5e10c76ae8404953a256a7ecb9ae3e6c]
 ORDER BY Return_Date DESC, DealereturnID ASC


    时间: 2022-12-25 14:43:18,268
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##2ba58690564448b4983853b9e2a8db20] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:43:18,273
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##2ba58690564448b4983853b9e2a8db20] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##2ba58690564448b4983853b9e2a8db20] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##a02c1ad32514469ea56cdfab4cc9b0a1] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:43:18,374
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##2ba58690564448b4983853b9e2a8db20] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##2ba58690564448b4983853b9e2a8db20] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##a02c1ad32514469ea56cdfab4cc9b0a1] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:43:18,481
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##2ba58690564448b4983853b9e2a8db20] 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 ##2ba58690564448b4983853b9e2a8db20 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##a02c1ad32514469ea56cdfab4cc9b0a1] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:43:18,670
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##2ba58690564448b4983853b9e2a8db20] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:43:18,672
  线程ID: 41
日志级别: 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.[c158a8de-a21b-4aa6-9ab0-cd3faa90b41b]
 FROM [##2ba58690564448b4983853b9e2a8db20]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:43:19,093
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##3814d649f71442dbab71667cbccc8624] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:43:19,096
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##3814d649f71442dbab71667cbccc8624] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##3814d649f71442dbab71667cbccc8624] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##f9593384ab8041bbbba4c69c7c3c0eb0] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:43:19,198
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##3814d649f71442dbab71667cbccc8624] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##3814d649f71442dbab71667cbccc8624] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##f9593384ab8041bbbba4c69c7c3c0eb0] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:43:19,306
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##3814d649f71442dbab71667cbccc8624] 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 ##3814d649f71442dbab71667cbccc8624 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##f9593384ab8041bbbba4c69c7c3c0eb0] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:43:19,498
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##3814d649f71442dbab71667cbccc8624] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:43:19,500
  线程ID: 52
日志级别: 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.[0c0f0a1c-4246-4174-ab75-0594f1807045]
 FROM [##3814d649f71442dbab71667cbccc8624]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:43:59,291
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##b76f85caff2c41bb92b4d5af0b870505] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo )


    时间: 2022-12-25 14:43:59,296
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##b76f85caff2c41bb92b4d5af0b870505] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT DealereturnID FROM Pureceipt 
      WHERE Type = 3 AND [##b76f85caff2c41bb92b4d5af0b870505].DealereturnID = DealereturnID)


    时间: 2022-12-25 14:43:59,304
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##b76f85caff2c41bb92b4d5af0b870505] 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 [##b76f85caff2c41bb92b4d5af0b870505] A INNER JOIN  Pureceipt B ON A.DealereturnID = B.DealereturnID
 WHERE B.Type = 3 


    时间: 2022-12-25 14:43:59,314
  线程ID: 41
日志级别: 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 [##b76f85caff2c41bb92b4d5af0b870505] 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 ##b76f85caff2c41bb92b4d5af0b870505 WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##4f474b81a3c740cfbbcade8b54df30ee] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2022-12-25 14:43:59,487
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##b76f85caff2c41bb92b4d5af0b870505] SET ReceiveQuantity = B.Quantity 
 FROM [##b76f85caff2c41bb92b4d5af0b870505] 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 ##b76f85caff2c41bb92b4d5af0b870505 WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##4f474b81a3c740cfbbcade8b54df30ee] WHERE Goods_No = C.Goods_No)
       GROUP BY A.DealereturnID 
      ) B ON A.DealereturnID = B.DealereturnID 


    时间: 2022-12-25 14:43:59,865
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##b76f85caff2c41bb92b4d5af0b870505] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 

    时间: 2022-12-25 14:43:59,868
  线程ID: 41
日志级别: 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.[7ac0e59c-d647-48d3-bf95-13832c8a488d]
 FROM [##b76f85caff2c41bb92b4d5af0b870505]
 ORDER BY Return_Date DESC, DealereturnID ASC


    时间: 2022-12-25 14:44:08,699
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##f132fa3b54ca467ebe5c36e075da1eb4] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:44:08,705
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##f132fa3b54ca467ebe5c36e075da1eb4] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##f132fa3b54ca467ebe5c36e075da1eb4] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##e6853e19a7ca4b5896d212e7230a97b0] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:44:08,812
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##f132fa3b54ca467ebe5c36e075da1eb4] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##f132fa3b54ca467ebe5c36e075da1eb4] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##e6853e19a7ca4b5896d212e7230a97b0] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:44:08,930
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##f132fa3b54ca467ebe5c36e075da1eb4] 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 ##f132fa3b54ca467ebe5c36e075da1eb4 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##e6853e19a7ca4b5896d212e7230a97b0] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:44:09,115
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##f132fa3b54ca467ebe5c36e075da1eb4] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:44:09,118
  线程ID: 60
日志级别: 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.[cf1295e6-6a25-4c71-8064-d1700b16775f]
 FROM [##f132fa3b54ca467ebe5c36e075da1eb4]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 14:45:11,925
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##4bf9759143674359bc7cda39c779daae] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2022-12-25 14:45:11,929
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##4bf9759143674359bc7cda39c779daae] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##4bf9759143674359bc7cda39c779daae] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##1405f880a81242b2b4a9d3290a7823ea] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:45:12,042
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##4bf9759143674359bc7cda39c779daae] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##4bf9759143674359bc7cda39c779daae] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##1405f880a81242b2b4a9d3290a7823ea] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:45:12,160
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##4bf9759143674359bc7cda39c779daae] 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 ##4bf9759143674359bc7cda39c779daae WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##1405f880a81242b2b4a9d3290a7823ea] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2022-12-25 14:45:12,338
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##4bf9759143674359bc7cda39c779daae] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2022-12-25 14:45:12,340
  线程ID: 41
日志级别: 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.[6ae1bf95-a66e-4304-8ed5-88b934010c71]
 FROM [##4bf9759143674359bc7cda39c779daae]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2022-12-25 15:41:03,260
  线程ID: 28
日志级别: 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.[7a93d594-ca77-4699-ae53-c1507072dfdb]
FROM [##6563e1663e2f42688e85cc061934fd54]
ORDER BY Goods_no


    时间: 2022-12-25 15:41:43,125
  线程ID: 94
日志级别: 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 [##45c6bccc9df24bbc9f81a4212caa7a18]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-12-25 15:41:43,554
  线程ID: 94
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##2d326ca31fda475b889ab9b2b1643dde] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-12-25 15:41:43,556
  线程ID: 94
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##45c6bccc9df24bbc9f81a4212caa7a18] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##2d326ca31fda475b889ab9b2b1643dde]


    时间: 2022-12-25 15:41:43,558
  线程ID: 94
日志级别: 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 [货号], SUM([渠道库存#数量]) AS [渠道库存], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[8b7d5653-656e-4e0a-9e5e-326c7a814d7d]
FROM ##45c6bccc9df24bbc9f81a4212caa7a18 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

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


    时间: 2022-12-25 15:50:22,113
  线程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.[7a93d594-ca77-4699-ae53-c1507072dfdb]
FROM [##96280f20220b4066ab6b830c139d16a9]
ORDER BY Goods_no


    时间: 2022-12-25 15:50:39,415
  线程ID: 28
日志级别: 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 [##de384f47f23248789c8e780c3e490de7]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-12-25 15:50:39,794
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##52f1f2371902411a9a7fc3cb4b4f13c5] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-12-25 15:50:39,795
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##de384f47f23248789c8e780c3e490de7] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##52f1f2371902411a9a7fc3cb4b4f13c5]


    时间: 2022-12-25 15:50:39,798
  线程ID: 28
日志级别: 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 [货号], SUM([渠道库存#数量]) AS [渠道库存], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[8b7d5653-656e-4e0a-9e5e-326c7a814d7d]
FROM ##de384f47f23248789c8e780c3e490de7 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

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


    时间: 2022-12-25 15:58:17,497
  线程ID: 93
日志级别: 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.[7a93d594-ca77-4699-ae53-c1507072dfdb]
FROM [##7d12c81e60ce4a90b2a742324ae1edd8]
ORDER BY Goods_no


    时间: 2022-12-25 15:58:26,320
  线程ID: 90
日志级别: 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 [##9f5d5df3fa6042de8ee867ae2ff9bb38]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-12-25 15:58:26,673
  线程ID: 90
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##8dea25ec94774f759a23a96ad15f406c] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-12-25 15:58:26,675
  线程ID: 90
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##9f5d5df3fa6042de8ee867ae2ff9bb38] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##8dea25ec94774f759a23a96ad15f406c]


    时间: 2022-12-25 15:58:26,677
  线程ID: 90
日志级别: 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 [货号], SUM([渠道库存#数量]) AS [渠道库存], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[8b7d5653-656e-4e0a-9e5e-326c7a814d7d]
FROM ##9f5d5df3fa6042de8ee867ae2ff9bb38 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

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


    时间: 2022-12-25 18:25:27,845
  线程ID: 28
日志级别: 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.[7a93d594-ca77-4699-ae53-c1507072dfdb]
FROM [##34dd9913332f4979909062bf245291bd]
ORDER BY Goods_no


    时间: 2022-12-25 18:25:39,454
  线程ID: 76
日志级别: 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 [##2c046980b27c4cc7ab334a23c90986e3]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-12-25 18:25:39,842
  线程ID: 76
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##6c4472f7e44441b1b140f8d2fedd4641] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-12-25 18:25:39,844
  线程ID: 76
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##2c046980b27c4cc7ab334a23c90986e3] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##6c4472f7e44441b1b140f8d2fedd4641]


    时间: 2022-12-25 18:25:39,846
  线程ID: 76
日志级别: 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 [货号], SUM([渠道库存#数量]) AS [渠道库存], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[8b7d5653-656e-4e0a-9e5e-326c7a814d7d]
FROM ##2c046980b27c4cc7ab334a23c90986e3 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

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


    时间: 2022-12-25 18:27:54,563
  线程ID: 92
日志级别: 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 [##e5b1e092d22349139bea472db990dffc]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-12-25 18:27:54,948
  线程ID: 92
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##951aa61584894fd5ad51c4c7efc90211] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-12-25 18:27:54,950
  线程ID: 92
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##e5b1e092d22349139bea472db990dffc] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##951aa61584894fd5ad51c4c7efc90211]


    时间: 2022-12-25 18:27:54,952
  线程ID: 92
日志级别: 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 [货号], SUM([渠道库存#数量]) AS [渠道库存], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[8b7d5653-656e-4e0a-9e5e-326c7a814d7d]
FROM ##e5b1e092d22349139bea472db990dffc 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

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