时间: 2022-05-12 14:44:38,707
  线程ID: 37
日志级别: 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.[8ba39021-d241-4b96-a980-e32a52399334]
FROM [##f078003747ce49c0a02c6069c10a43a0]
ORDER BY Goods_no


    时间: 2022-05-12 14:44:43,377
  线程ID: 49
日志级别: 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.[8ba39021-d241-4b96-a980-e32a52399334]
FROM [##8c8fc65846fc4d5c9a54f1455af2573e]
ORDER BY Goods_no


    时间: 2022-05-12 14:44:44,349
  线程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.[8ba39021-d241-4b96-a980-e32a52399334]
FROM [##d5d4329f975a4d2792657aee7b22f0f7]
ORDER BY Goods_no


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


    时间: 2022-05-12 14:44:55,417
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##4b7ae693bf22499fb7bd3c981c4b0fd3] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 14:44:55,420
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##2551cacdd49847ea89e184c852ff4609] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##4b7ae693bf22499fb7bd3c981c4b0fd3]


    时间: 2022-05-12 14:44:55,497
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##13727482cdfe40f0b63b51d3b61dabd8 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-05-12 14:44:55,500
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##13727482cdfe40f0b63b51d3b61dabd8 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-05-12 14:44:55,502
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##13727482cdfe40f0b63b51d3b61dabd8 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-05-12 14:44:55,533
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##13727482cdfe40f0b63b51d3b61dabd8 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-12 14:44:55,534
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##13727482cdfe40f0b63b51d3b61dabd8 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-12 14:44:55,538
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##2551cacdd49847ea89e184c852ff4609] (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 [##0c9c945b51f54cf9b91bd1e3599134e0]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-12 14:44:56,071
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##0cb832e101074e578fe46f957b44feb6] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 14:44:56,073
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##2551cacdd49847ea89e184c852ff4609] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##0cb832e101074e578fe46f957b44feb6]


    时间: 2022-05-12 14:44:56,087
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##2551cacdd49847ea89e184c852ff4609 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2022-05-12 14:46:04,043
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##3c69995435af48d58423bac6c32d74dc] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


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


    时间: 2022-05-12 14:46:04,057
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 0 
 FROM [##3c69995435af48d58423bac6c32d74dc] A 
 WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 


    时间: 2022-05-12 14:46:04,061
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 1 
 FROM [##3c69995435af48d58423bac6c32d74dc] A 
 WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 


    时间: 2022-05-12 14:46:04,066
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##3c69995435af48d58423bac6c32d74dc A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##3c69995435af48d58423bac6c32d74dc WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##b82453e7a9a24cefac7f540759b588dd] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-05-12 14:46:04,110
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##3c69995435af48d58423bac6c32d74dc A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##3c69995435af48d58423bac6c32d74dc WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##b82453e7a9a24cefac7f540759b588dd] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2022-05-12 14:46:04,153
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##3c69995435af48d58423bac6c32d74dc 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 ##3c69995435af48d58423bac6c32d74dc WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##b82453e7a9a24cefac7f540759b588dd] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-05-12 14:46:04,241
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##3c69995435af48d58423bac6c32d74dc 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 ##3c69995435af48d58423bac6c32d74dc WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##b82453e7a9a24cefac7f540759b588dd] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-05-12 14:46:04,456
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##3c69995435af48d58423bac6c32d74dc 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 ##3c69995435af48d58423bac6c32d74dc C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##b82453e7a9a24cefac7f540759b588dd] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-05-12 14:46:04,622
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##3c69995435af48d58423bac6c32d74dc
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2022-05-12 14:46:04,623
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##3c69995435af48d58423bac6c32d74dc] 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 [##3c69995435af48d58423bac6c32d74dc] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-05-12 14:46:04,658
  线程ID: 24
日志级别: 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.[4c9e39fb-b7d4-4f89-8211-7b3c106b0bf7]
 FROM [##3c69995435af48d58423bac6c32d74dc]
 ORDER BY Delivery_Date DESC, DeliveryID ASC


    时间: 2022-05-12 14:46:34,489
  线程ID: 23
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##8b744988ca4d4fa8a9bdebfe298d84a3] A
    INNER JOIN (
        SELECT A.PuReceiptID, 
               SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, 
               SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, 
               SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptSSGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
             LEFT  JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##8b744988ca4d4fa8a9bdebfe298d84a3] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##cfbbdcab2e6941589a6eb06567c73a17] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:46:34,669
  线程ID: 23
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##8b744988ca4d4fa8a9bdebfe298d84a3] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##8b744988ca4d4fa8a9bdebfe298d84a3] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##cfbbdcab2e6941589a6eb06567c73a17] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:46:34,817
  线程ID: 23
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##8b744988ca4d4fa8a9bdebfe298d84a3] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM DealeReturnGoods A
             INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID
        WHERE EXISTS( SELECT 1 FROM [##8b744988ca4d4fa8a9bdebfe298d84a3] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##cfbbdcab2e6941589a6eb06567c73a17] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2022-05-12 14:46:34,961
  线程ID: 23
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##8b744988ca4d4fa8a9bdebfe298d84a3] A
    INNER JOIN (
        SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM RenoticeGoods A
             INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID
        WHERE EXISTS( SELECT 1 FROM [##8b744988ca4d4fa8a9bdebfe298d84a3] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##cfbbdcab2e6941589a6eb06567c73a17] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2022-05-12 14:46:35,093
  线程ID: 23
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##8b744988ca4d4fa8a9bdebfe298d84a3] A
    INNER JOIN (
        SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReturnGoods A
             INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID
        WHERE EXISTS( SELECT 1 FROM [##8b744988ca4d4fa8a9bdebfe298d84a3] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##cfbbdcab2e6941589a6eb06567c73a17] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2022-05-12 14:46:35,224
  线程ID: 23
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0)
 FROM ##8b744988ca4d4fa8a9bdebfe298d84a3 A

    时间: 2022-05-12 14:46:35,226
  线程ID: 23
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号],
        BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型],
        rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称],
        SaleMan [业务员], PriceType [价格类型], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BalanceAmount AS [结算额],
        PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数],
        OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus AS [业务状态#退货状态],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核名称],PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[6b312f4b-f87d-4c68-a67f-67440bcbaf62]
 FROM [##8b744988ca4d4fa8a9bdebfe298d84a3] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2022-05-12 14:46:41,897
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##1fff77c7043f4a00a953a0620574d1d2] A
    INNER JOIN (
        SELECT A.PuReceiptID, 
               SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, 
               SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, 
               SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptSSGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
             LEFT  JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##1fff77c7043f4a00a953a0620574d1d2] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##c59392d27a0c42a89ccd0cac962f803e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:46:42,074
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##1fff77c7043f4a00a953a0620574d1d2] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##1fff77c7043f4a00a953a0620574d1d2] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##c59392d27a0c42a89ccd0cac962f803e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:46:42,218
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##1fff77c7043f4a00a953a0620574d1d2] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM DealeReturnGoods A
             INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID
        WHERE EXISTS( SELECT 1 FROM [##1fff77c7043f4a00a953a0620574d1d2] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##c59392d27a0c42a89ccd0cac962f803e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2022-05-12 14:46:42,365
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##1fff77c7043f4a00a953a0620574d1d2] A
    INNER JOIN (
        SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM RenoticeGoods A
             INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID
        WHERE EXISTS( SELECT 1 FROM [##1fff77c7043f4a00a953a0620574d1d2] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##c59392d27a0c42a89ccd0cac962f803e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2022-05-12 14:46:42,490
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##1fff77c7043f4a00a953a0620574d1d2] A
    INNER JOIN (
        SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReturnGoods A
             INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID
        WHERE EXISTS( SELECT 1 FROM [##1fff77c7043f4a00a953a0620574d1d2] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##c59392d27a0c42a89ccd0cac962f803e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2022-05-12 14:46:42,613
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0)
 FROM ##1fff77c7043f4a00a953a0620574d1d2 A

    时间: 2022-05-12 14:46:42,616
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号],
        BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型],
        rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称],
        SaleMan [业务员], PriceType [价格类型], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BalanceAmount AS [结算额],
        PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数],
        OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus AS [业务状态#退货状态],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核名称],PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[6b312f4b-f87d-4c68-a67f-67440bcbaf62]
 FROM [##1fff77c7043f4a00a953a0620574d1d2] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2022-05-12 14:46:46,441
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##d88e63a4f041460ebc74f578d07f8c92] A
    INNER JOIN (
        SELECT A.PuReceiptID, 
               SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, 
               SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, 
               SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptSSGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
             LEFT  JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##d88e63a4f041460ebc74f578d07f8c92] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##3648656b4be0478eb5d1702611d53fa4] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:46:46,617
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##d88e63a4f041460ebc74f578d07f8c92] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##d88e63a4f041460ebc74f578d07f8c92] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##3648656b4be0478eb5d1702611d53fa4] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:46:46,764
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##d88e63a4f041460ebc74f578d07f8c92] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM DealeReturnGoods A
             INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID
        WHERE EXISTS( SELECT 1 FROM [##d88e63a4f041460ebc74f578d07f8c92] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##3648656b4be0478eb5d1702611d53fa4] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2022-05-12 14:46:46,910
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##d88e63a4f041460ebc74f578d07f8c92] A
    INNER JOIN (
        SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM RenoticeGoods A
             INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID
        WHERE EXISTS( SELECT 1 FROM [##d88e63a4f041460ebc74f578d07f8c92] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##3648656b4be0478eb5d1702611d53fa4] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2022-05-12 14:46:47,030
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##d88e63a4f041460ebc74f578d07f8c92] A
    INNER JOIN (
        SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReturnGoods A
             INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID
        WHERE EXISTS( SELECT 1 FROM [##d88e63a4f041460ebc74f578d07f8c92] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##3648656b4be0478eb5d1702611d53fa4] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2022-05-12 14:46:47,153
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0)
 FROM ##d88e63a4f041460ebc74f578d07f8c92 A

    时间: 2022-05-12 14:46:47,156
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号],
        BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型],
        rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称],
        SaleMan [业务员], PriceType [价格类型], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BalanceAmount AS [结算额],
        PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数],
        OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus AS [业务状态#退货状态],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核名称],PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[6b312f4b-f87d-4c68-a67f-67440bcbaf62]
 FROM [##d88e63a4f041460ebc74f578d07f8c92] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2022-05-12 14:46:47,810
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##f055b0ae39594135b431770b63521b07] A
    INNER JOIN (
        SELECT A.PuReceiptID, 
               SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, 
               SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, 
               SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptSSGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
             LEFT  JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##f055b0ae39594135b431770b63521b07] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##409e3290c4e54e47892ee7035115aff3] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:46:47,987
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##f055b0ae39594135b431770b63521b07] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##f055b0ae39594135b431770b63521b07] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##409e3290c4e54e47892ee7035115aff3] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:46:48,134
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##f055b0ae39594135b431770b63521b07] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM DealeReturnGoods A
             INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID
        WHERE EXISTS( SELECT 1 FROM [##f055b0ae39594135b431770b63521b07] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##409e3290c4e54e47892ee7035115aff3] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2022-05-12 14:46:48,279
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##f055b0ae39594135b431770b63521b07] A
    INNER JOIN (
        SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM RenoticeGoods A
             INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID
        WHERE EXISTS( SELECT 1 FROM [##f055b0ae39594135b431770b63521b07] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##409e3290c4e54e47892ee7035115aff3] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2022-05-12 14:46:48,399
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##f055b0ae39594135b431770b63521b07] A
    INNER JOIN (
        SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReturnGoods A
             INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID
        WHERE EXISTS( SELECT 1 FROM [##f055b0ae39594135b431770b63521b07] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##409e3290c4e54e47892ee7035115aff3] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2022-05-12 14:46:48,520
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0)
 FROM ##f055b0ae39594135b431770b63521b07 A

    时间: 2022-05-12 14:46:48,522
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号],
        BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型],
        rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称],
        SaleMan [业务员], PriceType [价格类型], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BalanceAmount AS [结算额],
        PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数],
        OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus AS [业务状态#退货状态],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核名称],PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[6b312f4b-f87d-4c68-a67f-67440bcbaf62]
 FROM [##f055b0ae39594135b431770b63521b07] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2022-05-12 14:46:48,777
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##bb1e132239ad4870826e5e452db7b3f3] A
    INNER JOIN (
        SELECT A.PuReceiptID, 
               SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, 
               SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, 
               SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptSSGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
             LEFT  JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##bb1e132239ad4870826e5e452db7b3f3] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##e0b466e7f73a4db6930affc9778d34bc] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:46:48,952
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##bb1e132239ad4870826e5e452db7b3f3] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##bb1e132239ad4870826e5e452db7b3f3] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##e0b466e7f73a4db6930affc9778d34bc] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:46:49,095
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##bb1e132239ad4870826e5e452db7b3f3] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM DealeReturnGoods A
             INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID
        WHERE EXISTS( SELECT 1 FROM [##bb1e132239ad4870826e5e452db7b3f3] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##e0b466e7f73a4db6930affc9778d34bc] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2022-05-12 14:46:49,246
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##bb1e132239ad4870826e5e452db7b3f3] A
    INNER JOIN (
        SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM RenoticeGoods A
             INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID
        WHERE EXISTS( SELECT 1 FROM [##bb1e132239ad4870826e5e452db7b3f3] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##e0b466e7f73a4db6930affc9778d34bc] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2022-05-12 14:46:49,367
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##bb1e132239ad4870826e5e452db7b3f3] A
    INNER JOIN (
        SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReturnGoods A
             INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID
        WHERE EXISTS( SELECT 1 FROM [##bb1e132239ad4870826e5e452db7b3f3] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##e0b466e7f73a4db6930affc9778d34bc] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2022-05-12 14:46:49,489
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0)
 FROM ##bb1e132239ad4870826e5e452db7b3f3 A

    时间: 2022-05-12 14:46:49,492
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号],
        BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型],
        rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称],
        SaleMan [业务员], PriceType [价格类型], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BalanceAmount AS [结算额],
        PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数],
        OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus AS [业务状态#退货状态],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核名称],PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[6b312f4b-f87d-4c68-a67f-67440bcbaf62]
 FROM [##bb1e132239ad4870826e5e452db7b3f3] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2022-05-12 14:46:49,752
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##62ee9cfd95dd499188425b7aab09b96f] A
    INNER JOIN (
        SELECT A.PuReceiptID, 
               SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, 
               SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, 
               SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptSSGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
             LEFT  JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##62ee9cfd95dd499188425b7aab09b96f] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##3d2f37393fd6436980509b13233fe955] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:46:49,926
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##62ee9cfd95dd499188425b7aab09b96f] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##62ee9cfd95dd499188425b7aab09b96f] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##3d2f37393fd6436980509b13233fe955] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:46:50,068
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##62ee9cfd95dd499188425b7aab09b96f] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM DealeReturnGoods A
             INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID
        WHERE EXISTS( SELECT 1 FROM [##62ee9cfd95dd499188425b7aab09b96f] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##3d2f37393fd6436980509b13233fe955] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2022-05-12 14:46:50,219
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##62ee9cfd95dd499188425b7aab09b96f] A
    INNER JOIN (
        SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM RenoticeGoods A
             INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID
        WHERE EXISTS( SELECT 1 FROM [##62ee9cfd95dd499188425b7aab09b96f] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##3d2f37393fd6436980509b13233fe955] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2022-05-12 14:46:50,342
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##62ee9cfd95dd499188425b7aab09b96f] A
    INNER JOIN (
        SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReturnGoods A
             INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID
        WHERE EXISTS( SELECT 1 FROM [##62ee9cfd95dd499188425b7aab09b96f] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##3d2f37393fd6436980509b13233fe955] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2022-05-12 14:46:50,464
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0)
 FROM ##62ee9cfd95dd499188425b7aab09b96f A

    时间: 2022-05-12 14:46:50,467
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号],
        BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型],
        rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称],
        SaleMan [业务员], PriceType [价格类型], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BalanceAmount AS [结算额],
        PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数],
        OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus AS [业务状态#退货状态],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核名称],PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[6b312f4b-f87d-4c68-a67f-67440bcbaf62]
 FROM [##62ee9cfd95dd499188425b7aab09b96f] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2022-05-12 14:46:50,724
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##a0b4724e3fe34c70929aafac9fa53063] A
    INNER JOIN (
        SELECT A.PuReceiptID, 
               SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, 
               SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, 
               SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptSSGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
             LEFT  JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##a0b4724e3fe34c70929aafac9fa53063] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##3817bdf71f48403eb5172b30956d3eb6] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:46:50,899
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##a0b4724e3fe34c70929aafac9fa53063] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##a0b4724e3fe34c70929aafac9fa53063] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##3817bdf71f48403eb5172b30956d3eb6] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:46:51,049
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##a0b4724e3fe34c70929aafac9fa53063] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM DealeReturnGoods A
             INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID
        WHERE EXISTS( SELECT 1 FROM [##a0b4724e3fe34c70929aafac9fa53063] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##3817bdf71f48403eb5172b30956d3eb6] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2022-05-12 14:46:51,219
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##a0b4724e3fe34c70929aafac9fa53063] A
    INNER JOIN (
        SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM RenoticeGoods A
             INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID
        WHERE EXISTS( SELECT 1 FROM [##a0b4724e3fe34c70929aafac9fa53063] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##3817bdf71f48403eb5172b30956d3eb6] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2022-05-12 14:46:51,341
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##a0b4724e3fe34c70929aafac9fa53063] A
    INNER JOIN (
        SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReturnGoods A
             INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID
        WHERE EXISTS( SELECT 1 FROM [##a0b4724e3fe34c70929aafac9fa53063] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##3817bdf71f48403eb5172b30956d3eb6] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2022-05-12 14:46:51,467
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0)
 FROM ##a0b4724e3fe34c70929aafac9fa53063 A

    时间: 2022-05-12 14:46:51,469
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号],
        BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型],
        rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称],
        SaleMan [业务员], PriceType [价格类型], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BalanceAmount AS [结算额],
        PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数],
        OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus AS [业务状态#退货状态],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核名称],PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[6b312f4b-f87d-4c68-a67f-67440bcbaf62]
 FROM [##a0b4724e3fe34c70929aafac9fa53063] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2022-05-12 14:46:51,724
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##20afc5c17e564e748037b2474bc5c7ad] A
    INNER JOIN (
        SELECT A.PuReceiptID, 
               SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, 
               SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, 
               SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptSSGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
             LEFT  JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##20afc5c17e564e748037b2474bc5c7ad] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##701142183a244658b0a851927d31f7f2] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:46:51,900
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##20afc5c17e564e748037b2474bc5c7ad] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##20afc5c17e564e748037b2474bc5c7ad] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##701142183a244658b0a851927d31f7f2] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:46:52,048
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##20afc5c17e564e748037b2474bc5c7ad] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM DealeReturnGoods A
             INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID
        WHERE EXISTS( SELECT 1 FROM [##20afc5c17e564e748037b2474bc5c7ad] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##701142183a244658b0a851927d31f7f2] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2022-05-12 14:46:52,197
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##20afc5c17e564e748037b2474bc5c7ad] A
    INNER JOIN (
        SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM RenoticeGoods A
             INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID
        WHERE EXISTS( SELECT 1 FROM [##20afc5c17e564e748037b2474bc5c7ad] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##701142183a244658b0a851927d31f7f2] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2022-05-12 14:46:52,316
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##20afc5c17e564e748037b2474bc5c7ad] A
    INNER JOIN (
        SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReturnGoods A
             INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID
        WHERE EXISTS( SELECT 1 FROM [##20afc5c17e564e748037b2474bc5c7ad] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##701142183a244658b0a851927d31f7f2] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2022-05-12 14:46:52,439
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0)
 FROM ##20afc5c17e564e748037b2474bc5c7ad A

    时间: 2022-05-12 14:46:52,442
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号],
        BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型],
        rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称],
        SaleMan [业务员], PriceType [价格类型], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BalanceAmount AS [结算额],
        PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数],
        OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus AS [业务状态#退货状态],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核名称],PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[6b312f4b-f87d-4c68-a67f-67440bcbaf62]
 FROM [##20afc5c17e564e748037b2474bc5c7ad] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2022-05-12 14:46:52,697
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##7c4da9eea09940ba9fe9946256b7a426] A
    INNER JOIN (
        SELECT A.PuReceiptID, 
               SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, 
               SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, 
               SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptSSGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
             LEFT  JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##7c4da9eea09940ba9fe9946256b7a426] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##068c68e5a3604d7885dd423447f72c7d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:46:52,871
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##7c4da9eea09940ba9fe9946256b7a426] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##7c4da9eea09940ba9fe9946256b7a426] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##068c68e5a3604d7885dd423447f72c7d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:46:53,016
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##7c4da9eea09940ba9fe9946256b7a426] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM DealeReturnGoods A
             INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID
        WHERE EXISTS( SELECT 1 FROM [##7c4da9eea09940ba9fe9946256b7a426] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##068c68e5a3604d7885dd423447f72c7d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2022-05-12 14:46:53,163
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##7c4da9eea09940ba9fe9946256b7a426] A
    INNER JOIN (
        SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM RenoticeGoods A
             INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID
        WHERE EXISTS( SELECT 1 FROM [##7c4da9eea09940ba9fe9946256b7a426] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##068c68e5a3604d7885dd423447f72c7d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2022-05-12 14:46:53,286
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##7c4da9eea09940ba9fe9946256b7a426] A
    INNER JOIN (
        SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReturnGoods A
             INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID
        WHERE EXISTS( SELECT 1 FROM [##7c4da9eea09940ba9fe9946256b7a426] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##068c68e5a3604d7885dd423447f72c7d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2022-05-12 14:46:53,414
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0)
 FROM ##7c4da9eea09940ba9fe9946256b7a426 A

    时间: 2022-05-12 14:46:53,416
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号],
        BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型],
        rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称],
        SaleMan [业务员], PriceType [价格类型], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BalanceAmount AS [结算额],
        PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数],
        OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus AS [业务状态#退货状态],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核名称],PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[6b312f4b-f87d-4c68-a67f-67440bcbaf62]
 FROM [##7c4da9eea09940ba9fe9946256b7a426] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2022-05-12 14:47:21,620
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##19eaaaefdd8848e49f4c173a462c11ea] A
    INNER JOIN (
        SELECT A.PuReceiptID, 
               SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, 
               SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, 
               SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptSSGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
             LEFT  JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##19eaaaefdd8848e49f4c173a462c11ea] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##a6247cc817b747e292a830a499c82310] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:47:21,801
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##19eaaaefdd8848e49f4c173a462c11ea] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##19eaaaefdd8848e49f4c173a462c11ea] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##a6247cc817b747e292a830a499c82310] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:47:21,946
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##19eaaaefdd8848e49f4c173a462c11ea] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM DealeReturnGoods A
             INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID
        WHERE EXISTS( SELECT 1 FROM [##19eaaaefdd8848e49f4c173a462c11ea] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##a6247cc817b747e292a830a499c82310] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2022-05-12 14:47:22,094
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##19eaaaefdd8848e49f4c173a462c11ea] A
    INNER JOIN (
        SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM RenoticeGoods A
             INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID
        WHERE EXISTS( SELECT 1 FROM [##19eaaaefdd8848e49f4c173a462c11ea] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##a6247cc817b747e292a830a499c82310] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2022-05-12 14:47:22,218
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##19eaaaefdd8848e49f4c173a462c11ea] A
    INNER JOIN (
        SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReturnGoods A
             INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID
        WHERE EXISTS( SELECT 1 FROM [##19eaaaefdd8848e49f4c173a462c11ea] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##a6247cc817b747e292a830a499c82310] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2022-05-12 14:47:22,338
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0)
 FROM ##19eaaaefdd8848e49f4c173a462c11ea A

    时间: 2022-05-12 14:47:22,341
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号],
        BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型],
        rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称],
        SaleMan [业务员], PriceType [价格类型], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BalanceAmount AS [结算额],
        PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数],
        OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus AS [业务状态#退货状态],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核名称],PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[6b312f4b-f87d-4c68-a67f-67440bcbaf62]
 FROM [##19eaaaefdd8848e49f4c173a462c11ea] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2022-05-12 14:47:23,244
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##0f36af7122d54e6390101f555b128803] A
    INNER JOIN (
        SELECT A.PuReceiptID, 
               SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, 
               SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, 
               SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptSSGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
             LEFT  JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##0f36af7122d54e6390101f555b128803] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##2de78db3593d413aa4f34abdf9e9d095] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:47:23,416
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##0f36af7122d54e6390101f555b128803] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##0f36af7122d54e6390101f555b128803] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##2de78db3593d413aa4f34abdf9e9d095] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:47:23,562
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##0f36af7122d54e6390101f555b128803] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM DealeReturnGoods A
             INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID
        WHERE EXISTS( SELECT 1 FROM [##0f36af7122d54e6390101f555b128803] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##2de78db3593d413aa4f34abdf9e9d095] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2022-05-12 14:47:23,709
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##0f36af7122d54e6390101f555b128803] A
    INNER JOIN (
        SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM RenoticeGoods A
             INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID
        WHERE EXISTS( SELECT 1 FROM [##0f36af7122d54e6390101f555b128803] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##2de78db3593d413aa4f34abdf9e9d095] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2022-05-12 14:47:23,830
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##0f36af7122d54e6390101f555b128803] A
    INNER JOIN (
        SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReturnGoods A
             INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID
        WHERE EXISTS( SELECT 1 FROM [##0f36af7122d54e6390101f555b128803] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##2de78db3593d413aa4f34abdf9e9d095] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2022-05-12 14:47:23,951
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0)
 FROM ##0f36af7122d54e6390101f555b128803 A

    时间: 2022-05-12 14:47:23,953
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号],
        BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型],
        rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称],
        SaleMan [业务员], PriceType [价格类型], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BalanceAmount AS [结算额],
        PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数],
        OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus AS [业务状态#退货状态],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核名称],PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[6b312f4b-f87d-4c68-a67f-67440bcbaf62]
 FROM [##0f36af7122d54e6390101f555b128803] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2022-05-12 14:47:24,823
  线程ID: 37
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##8c8dc3bbd71146a2a12d6c62f28edbb2] A
    INNER JOIN (
        SELECT A.PuReceiptID, 
               SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, 
               SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, 
               SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptSSGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
             LEFT  JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##8c8dc3bbd71146a2a12d6c62f28edbb2] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##21600856bc34402b85f5e94698fede8b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:47:24,996
  线程ID: 37
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##8c8dc3bbd71146a2a12d6c62f28edbb2] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##8c8dc3bbd71146a2a12d6c62f28edbb2] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##21600856bc34402b85f5e94698fede8b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2022-05-12 14:47:25,138
  线程ID: 37
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##8c8dc3bbd71146a2a12d6c62f28edbb2] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM DealeReturnGoods A
             INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID
        WHERE EXISTS( SELECT 1 FROM [##8c8dc3bbd71146a2a12d6c62f28edbb2] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##21600856bc34402b85f5e94698fede8b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2022-05-12 14:47:25,283
  线程ID: 37
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##8c8dc3bbd71146a2a12d6c62f28edbb2] A
    INNER JOIN (
        SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM RenoticeGoods A
             INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID
        WHERE EXISTS( SELECT 1 FROM [##8c8dc3bbd71146a2a12d6c62f28edbb2] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##21600856bc34402b85f5e94698fede8b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2022-05-12 14:47:25,404
  线程ID: 37
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##8c8dc3bbd71146a2a12d6c62f28edbb2] A
    INNER JOIN (
        SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReturnGoods A
             INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID
        WHERE EXISTS( SELECT 1 FROM [##8c8dc3bbd71146a2a12d6c62f28edbb2] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##21600856bc34402b85f5e94698fede8b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2022-05-12 14:47:25,525
  线程ID: 37
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0)
 FROM ##8c8dc3bbd71146a2a12d6c62f28edbb2 A

    时间: 2022-05-12 14:47:25,528
  线程ID: 37
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号],
        BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型],
        rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称],
        SaleMan [业务员], PriceType [价格类型], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BalanceAmount AS [结算额],
        PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数],
        OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus AS [业务状态#退货状态],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核名称],PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[6b312f4b-f87d-4c68-a67f-67440bcbaf62]
 FROM [##8c8dc3bbd71146a2a12d6c62f28edbb2] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2022-05-12 17:05:17,004
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[8ba39021-d241-4b96-a980-e32a52399334]
FROM [##1fcb281e2e004485bb73eccfc26f25c3]
ORDER BY Goods_no


    时间: 2022-05-12 17:05:30,484
  线程ID: 73
日志级别: 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 [##2f13b4b569dc43f9bae26c4b3e41d58e]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-05-12 17:05:30,817
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##66134e9fdf26480bbd9b5b3c1e25bd58] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:05:30,818
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##2f13b4b569dc43f9bae26c4b3e41d58e] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##66134e9fdf26480bbd9b5b3c1e25bd58]


    时间: 2022-05-12 17:05:30,883
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##8347b6cd33f042299a9225006c3c8316 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-05-12 17:05:30,885
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##8347b6cd33f042299a9225006c3c8316 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-05-12 17:05:30,888
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##8347b6cd33f042299a9225006c3c8316 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-05-12 17:05:30,917
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##8347b6cd33f042299a9225006c3c8316 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-12 17:05:30,919
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##8347b6cd33f042299a9225006c3c8316 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-12 17:05:30,922
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##2f13b4b569dc43f9bae26c4b3e41d58e] (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 [##3e8300c5fa1b4420a62beaa1396b6f2c]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-12 17:05:31,347
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##6207bb71ce7942659f558c6a61a1831f] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:05:31,348
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##2f13b4b569dc43f9bae26c4b3e41d58e] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##6207bb71ce7942659f558c6a61a1831f]


    时间: 2022-05-12 17:05:31,350
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##2f13b4b569dc43f9bae26c4b3e41d58e A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2022-05-12 17:06:56,576
  线程ID: 69
日志级别: 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.[8ba39021-d241-4b96-a980-e32a52399334]
FROM [##20dc67d11b524170bedc5369f85d9e75]
ORDER BY Goods_no


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


    时间: 2022-05-12 17:07:37,635
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##28abadac63cb4facaff383946c140c93] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:07:37,635
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b2f254ada07f40f887c86c8b3443e276] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##28abadac63cb4facaff383946c140c93]


    时间: 2022-05-12 17:07:37,701
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##73bf9c6530b54b779b336fe24b89db85 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-05-12 17:07:37,704
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##73bf9c6530b54b779b336fe24b89db85 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-05-12 17:07:37,706
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##73bf9c6530b54b779b336fe24b89db85 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-05-12 17:07:37,735
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##73bf9c6530b54b779b336fe24b89db85 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-12 17:07:37,737
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##73bf9c6530b54b779b336fe24b89db85 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-12 17:07:37,740
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b2f254ada07f40f887c86c8b3443e276] (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 [##7979861f3564464cb25e5fb0eba2ece3]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-12 17:07:38,152
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##b3a1358349f54d4792e4093cc937d020] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:07:38,153
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b2f254ada07f40f887c86c8b3443e276] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##b3a1358349f54d4792e4093cc937d020]


    时间: 2022-05-12 17:07:38,155
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##b2f254ada07f40f887c86c8b3443e276 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2022-05-12 17:08:05,863
  线程ID: 55
日志级别: 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 [##3b0d7cd293884da4b1fd3351796f22e2]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-05-12 17:08:06,191
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##994b440eb77f403ea5f236bbf68b1be4] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:08:06,192
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##3b0d7cd293884da4b1fd3351796f22e2] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##994b440eb77f403ea5f236bbf68b1be4]


    时间: 2022-05-12 17:08:06,256
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##e145630689ae4e059d5717f6b5c1f9e0 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


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


    时间: 2022-05-12 17:08:06,290
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##e145630689ae4e059d5717f6b5c1f9e0 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-12 17:08:06,293
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##3b0d7cd293884da4b1fd3351796f22e2] (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 [##8e24ace32fe24674abef0719370fa48c]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-12 17:08:06,769
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##a4731aeb18da49d683ab086eaf9c0fca] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:08:06,770
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##3b0d7cd293884da4b1fd3351796f22e2] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##a4731aeb18da49d683ab086eaf9c0fca]


    时间: 2022-05-12 17:08:06,772
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##3b0d7cd293884da4b1fd3351796f22e2 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


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


    时间: 2022-05-12 17:29:29,604
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##c0b932c181e64b2fba6c66f9321e516b] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:29:29,606
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##d1994e3e0abd4cb6a8229150577d4447] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##c0b932c181e64b2fba6c66f9321e516b]


    时间: 2022-05-12 17:29:29,670
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##930de58d6d544d24a997152f25c7ad73 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-05-12 17:29:29,673
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##930de58d6d544d24a997152f25c7ad73 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-05-12 17:29:29,676
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##930de58d6d544d24a997152f25c7ad73 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-05-12 17:29:29,705
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##930de58d6d544d24a997152f25c7ad73 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-12 17:29:29,707
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##930de58d6d544d24a997152f25c7ad73 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-12 17:29:29,711
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##d1994e3e0abd4cb6a8229150577d4447] (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 [##8f485e2f43fb40faa94eda5d1407750c]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-12 17:29:30,214
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##23d23b5bf83f46c5b8340fd270e27219] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:29:30,215
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##d1994e3e0abd4cb6a8229150577d4447] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##23d23b5bf83f46c5b8340fd270e27219]


    时间: 2022-05-12 17:29:30,217
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##d1994e3e0abd4cb6a8229150577d4447 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2022-05-12 17:30:07,191
  线程ID: 74
日志级别: 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 [##19bad8453c1c461198737af22b73fd11]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-05-12 17:30:07,536
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##76af4008afc44d48bcb43e9d1165f761] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:30:07,538
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##19bad8453c1c461198737af22b73fd11] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##76af4008afc44d48bcb43e9d1165f761]


    时间: 2022-05-12 17:30:07,606
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##f692245ed4914baa8b8e00130733f558 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-05-12 17:30:07,609
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f692245ed4914baa8b8e00130733f558 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-05-12 17:30:07,612
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##f692245ed4914baa8b8e00130733f558 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-05-12 17:30:07,641
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f692245ed4914baa8b8e00130733f558 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-12 17:30:07,643
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f692245ed4914baa8b8e00130733f558 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-12 17:30:07,646
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##19bad8453c1c461198737af22b73fd11] (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 [##0ab63acf21cb46289fecefcabf42994c]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-12 17:30:08,147
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##b639652cd7134ebea0444f317ca83821] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:30:08,148
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##19bad8453c1c461198737af22b73fd11] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##b639652cd7134ebea0444f317ca83821]


    时间: 2022-05-12 17:30:08,151
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##19bad8453c1c461198737af22b73fd11 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2022-05-12 17:30:29,667
  线程ID: 63
日志级别: 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 [##0fc8d8344905403a873cf220642ec9bd]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-05-12 17:30:30,063
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##67484b85f38b496fa7a029a569b06a0e] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:30:30,065
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0fc8d8344905403a873cf220642ec9bd] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##67484b85f38b496fa7a029a569b06a0e]


    时间: 2022-05-12 17:30:30,138
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##46f739a3707c40fa83f2a3c5224bc27c a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-05-12 17:30:30,141
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##46f739a3707c40fa83f2a3c5224bc27c SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-05-12 17:30:30,144
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##46f739a3707c40fa83f2a3c5224bc27c 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-05-12 17:30:30,175
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##46f739a3707c40fa83f2a3c5224bc27c SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-12 17:30:30,177
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##46f739a3707c40fa83f2a3c5224bc27c SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-12 17:30:30,180
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0fc8d8344905403a873cf220642ec9bd] (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 [##0ae6acabd29d454ab2b15a2806ca4de9]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-12 17:30:30,677
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##c97bbd9c13914de9ac9bbca25891bd3a] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:30:30,678
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0fc8d8344905403a873cf220642ec9bd] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##c97bbd9c13914de9ac9bbca25891bd3a]


    时间: 2022-05-12 17:30:30,680
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##0fc8d8344905403a873cf220642ec9bd A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2022-05-12 17:40:45,053
  线程ID: 67
日志级别: 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 [##5761b59616c44b7ab1cea516449c5f54]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-05-12 17:40:45,401
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##f02325dfa5f846e5aaef001c862949a5] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:40:45,403
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##5761b59616c44b7ab1cea516449c5f54] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##f02325dfa5f846e5aaef001c862949a5]


    时间: 2022-05-12 17:40:45,470
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##b5b343983601451db9008421cc8bcbf6 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-05-12 17:40:45,473
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b5b343983601451db9008421cc8bcbf6 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-05-12 17:40:45,476
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##b5b343983601451db9008421cc8bcbf6 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-05-12 17:40:45,511
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b5b343983601451db9008421cc8bcbf6 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-12 17:40:45,513
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b5b343983601451db9008421cc8bcbf6 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-12 17:40:45,516
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##5761b59616c44b7ab1cea516449c5f54] (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 [##ab73a24d46f54694b1f4878b62ca9e5d]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-12 17:40:45,962
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##a1c75921b47347f9bd53c70288332f73] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:40:45,964
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##5761b59616c44b7ab1cea516449c5f54] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##a1c75921b47347f9bd53c70288332f73]


    时间: 2022-05-12 17:40:45,967
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##5761b59616c44b7ab1cea516449c5f54 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2022-05-12 17:41:16,778
  线程ID: 74
日志级别: 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 [##fbd33cafef3a45649e42b64cf5745df6]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-05-12 17:41:17,115
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##bcd9b3e15a7b45aea853ba5188757817] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:41:17,117
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##fbd33cafef3a45649e42b64cf5745df6] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##bcd9b3e15a7b45aea853ba5188757817]


    时间: 2022-05-12 17:41:17,183
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##a2e2fc43c9bd4b9d94ac5bd9f8e3ce5c a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


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


    时间: 2022-05-12 17:41:17,227
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##a2e2fc43c9bd4b9d94ac5bd9f8e3ce5c SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-12 17:41:17,231
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##fbd33cafef3a45649e42b64cf5745df6] (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 [##d5df0e6870254e8f8639a6e7bed88f7b]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-12 17:41:17,693
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##e81350fea8df46049ed6bc4c7de226f6] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:41:17,694
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##fbd33cafef3a45649e42b64cf5745df6] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##e81350fea8df46049ed6bc4c7de226f6]


    时间: 2022-05-12 17:41:17,696
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##fbd33cafef3a45649e42b64cf5745df6 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2022-05-12 17:42:10,800
  线程ID: 63
日志级别: 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 [##27e19c1fa62d423fb2ca4e92606eabf9]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-05-12 17:42:11,193
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##ff4c396e3a224df992919fddcbf88252] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:42:11,195
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##27e19c1fa62d423fb2ca4e92606eabf9] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##ff4c396e3a224df992919fddcbf88252]


    时间: 2022-05-12 17:42:11,276
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##61c1b9ab50ff489b8a7eabad7c24a674 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-05-12 17:42:11,280
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##61c1b9ab50ff489b8a7eabad7c24a674 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-05-12 17:42:11,283
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##61c1b9ab50ff489b8a7eabad7c24a674 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-05-12 17:42:11,317
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##61c1b9ab50ff489b8a7eabad7c24a674 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-12 17:42:11,319
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##61c1b9ab50ff489b8a7eabad7c24a674 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-12 17:42:11,322
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##27e19c1fa62d423fb2ca4e92606eabf9] (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 [##f8558f41979f48cfbfd1622bff64564d]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-12 17:42:11,817
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##c95915b6299143b7ae61893d50622d95] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:42:11,818
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##27e19c1fa62d423fb2ca4e92606eabf9] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##c95915b6299143b7ae61893d50622d95]


    时间: 2022-05-12 17:42:11,821
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##27e19c1fa62d423fb2ca4e92606eabf9 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2022-05-12 17:42:45,551
  线程ID: 61
日志级别: 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 [##5a158a15f47740c7b9bd574aaaf0db33]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-05-12 17:42:45,947
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##27fb2b8af1a54793aaee806a16a8c05f] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:42:45,948
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##5a158a15f47740c7b9bd574aaaf0db33] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##27fb2b8af1a54793aaee806a16a8c05f]


    时间: 2022-05-12 17:42:46,020
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##d10bd207830c45129330330f5477f86b a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-05-12 17:42:46,022
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##d10bd207830c45129330330f5477f86b SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-05-12 17:42:46,026
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##d10bd207830c45129330330f5477f86b 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-05-12 17:42:46,059
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##d10bd207830c45129330330f5477f86b SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-12 17:42:46,061
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##d10bd207830c45129330330f5477f86b SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-12 17:42:46,064
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##5a158a15f47740c7b9bd574aaaf0db33] (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 [##b75a276f3b9542498f3f4179f423b968]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-12 17:42:46,631
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##f54cb4c6c4b74be2aa14d09f530b84b7] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:42:46,632
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##5a158a15f47740c7b9bd574aaaf0db33] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##f54cb4c6c4b74be2aa14d09f530b84b7]


    时间: 2022-05-12 17:42:46,635
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##5a158a15f47740c7b9bd574aaaf0db33 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2022-05-12 17:43:08,780
  线程ID: 67
日志级别: 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 [##965c7e8e6bb742bd938555ef1ee719db]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-05-12 17:43:09,159
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##3c58404f03844798b76a591e893a6a76] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:43:09,161
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##965c7e8e6bb742bd938555ef1ee719db] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##3c58404f03844798b76a591e893a6a76]


    时间: 2022-05-12 17:43:09,229
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##cafdde63e1ef4be28b68c47a53d1e2a9 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-05-12 17:43:09,231
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##cafdde63e1ef4be28b68c47a53d1e2a9 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-05-12 17:43:09,235
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##cafdde63e1ef4be28b68c47a53d1e2a9 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-05-12 17:43:09,263
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##cafdde63e1ef4be28b68c47a53d1e2a9 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-12 17:43:09,265
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##cafdde63e1ef4be28b68c47a53d1e2a9 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-12 17:43:09,268
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##965c7e8e6bb742bd938555ef1ee719db] (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 [##50952b0584f349ebafea7fc6f3092982]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-12 17:43:09,706
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##62c0c8abec2347caaae59c029e870266] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:43:09,707
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##965c7e8e6bb742bd938555ef1ee719db] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##62c0c8abec2347caaae59c029e870266]


    时间: 2022-05-12 17:43:09,710
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##965c7e8e6bb742bd938555ef1ee719db A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


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


    时间: 2022-05-12 17:47:02,659
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##3ec32b0f88324148ba1df23d4ddd55f6] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:47:02,661
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0600362cf9a741829bec1c6cf9a32305] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##3ec32b0f88324148ba1df23d4ddd55f6]


    时间: 2022-05-12 17:47:02,727
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##0e748bc14dc84f1c9bbbbea771f60916 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-05-12 17:47:02,729
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##0e748bc14dc84f1c9bbbbea771f60916 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-05-12 17:47:02,732
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##0e748bc14dc84f1c9bbbbea771f60916 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-05-12 17:47:02,760
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##0e748bc14dc84f1c9bbbbea771f60916 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-12 17:47:02,761
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##0e748bc14dc84f1c9bbbbea771f60916 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-12 17:47:02,764
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0600362cf9a741829bec1c6cf9a32305] (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 [##b242a778d1f14620a7a26d084a5bda52]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-12 17:47:03,262
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##6e33ab7595e04003af83cadc8ec41737] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:47:03,263
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0600362cf9a741829bec1c6cf9a32305] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##6e33ab7595e04003af83cadc8ec41737]


    时间: 2022-05-12 17:47:03,265
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##0600362cf9a741829bec1c6cf9a32305 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


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


    时间: 2022-05-12 17:47:35,443
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##336720505df4478fad90590def8305b0] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:47:35,445
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##6bb3c88cea5546e5a01a5aefa00f24c3] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##336720505df4478fad90590def8305b0]


    时间: 2022-05-12 17:47:35,513
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##42761c53d9ee444ab681bb8d1329e188 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


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


    时间: 2022-05-12 17:47:35,548
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##42761c53d9ee444ab681bb8d1329e188 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-12 17:47:35,551
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##6bb3c88cea5546e5a01a5aefa00f24c3] (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 [##ad2dbf020e474c80923974e3996bc8fa]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-12 17:47:35,995
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##e8ba593e675843cc938a6047d15aade5] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:47:35,997
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##6bb3c88cea5546e5a01a5aefa00f24c3] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##e8ba593e675843cc938a6047d15aade5]


    时间: 2022-05-12 17:47:35,999
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##6bb3c88cea5546e5a01a5aefa00f24c3 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2022-05-12 17:48:02,013
  线程ID: 61
日志级别: 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 [##8164f1d0f7824263b3bdf7c7c7f9cde3]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-05-12 17:48:02,353
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##49793bfe04db469b8b3400a1a45ec4f9] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:48:02,354
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##8164f1d0f7824263b3bdf7c7c7f9cde3] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##49793bfe04db469b8b3400a1a45ec4f9]


    时间: 2022-05-12 17:48:02,422
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##74e9bc66e4c74ed7b89353c947b67985 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-05-12 17:48:02,424
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##74e9bc66e4c74ed7b89353c947b67985 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-05-12 17:48:02,428
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##74e9bc66e4c74ed7b89353c947b67985 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-05-12 17:48:02,451
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##74e9bc66e4c74ed7b89353c947b67985 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-12 17:48:02,453
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##74e9bc66e4c74ed7b89353c947b67985 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-12 17:48:02,456
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##8164f1d0f7824263b3bdf7c7c7f9cde3] (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 [##b16a8e03fc3f4f54b8dd85959ceae6b0]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-12 17:48:02,901
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##2edee6d823ca428ca7623ed5b73a906f] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-12 17:48:02,902
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##8164f1d0f7824263b3bdf7c7c7f9cde3] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##2edee6d823ca428ca7623ed5b73a906f]


    时间: 2022-05-12 17:48:02,903
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##8164f1d0f7824263b3bdf7c7c7f9cde3 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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