时间: 2021-04-28 16:49:12,113
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5a72053f-4fed-45ae-a888-c5d26f4b741e]
FROM [##d14bc8bcd32d4c9cbb19d1a3200ce7c6]
ORDER BY Goods_no


    时间: 2021-04-28 17:00:26,244
  线程ID: 8
日志级别: 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 [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[5a72053f-4fed-45ae-a888-c5d26f4b741e]
FROM [##f26c82f7fb444d7c983c342628249dcd]
ORDER BY Goods_no


    时间: 2021-04-28 17:05:16,229
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##0101683d309245a8978f381f6517de84] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CBalance' AND A.BalanceID = BillNo )


    时间: 2021-04-28 17:05:16,236
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##0101683d309245a8978f381f6517de84] A
    INNER JOIN (
        SELECT A.BalanceID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount
        FROM [BalanceGoods] A 
             INNER JOIN Goods B ON A.Goods_No = B.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##0101683d309245a8978f381f6517de84 WHERE A.BalanceID = BalanceID )
     AND EXISTS (SELECT 1 FROM [##6368c3b2a2cc44b38f87120db4c65284] WHERE Goods_No = A.Goods_No)
        GROUP BY A.BalanceID
    ) B ON A.BalanceID = B.BalanceID


    时间: 2021-04-28 17:05:16,425
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BalanceID AS [单号], Manual_ID AS [手工单号], Balance_Date [日期]
, rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称]
, Quantity AS [数量]
, DpAmount AS [吊牌额]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], Balance_Date AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[e6f45f0b-b380-4122-858b-61777ba0d942]
 FROM [##0101683d309245a8978f381f6517de84]
 ORDER BY Balance_Date DESC, BalanceID ASC


    时间: 2021-04-28 17:06:06,889
  线程ID: 114
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##1e01487e7b76443aa131bb1c7738d1c1] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CMoveOut' AND A.ShopToutID = BillNo )


    时间: 2021-04-28 17:06:06,896
  线程ID: 114
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##1e01487e7b76443aa131bb1c7738d1c1] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT ShopToutID FROM ShopTin 
      WHERE 1 = 1 AND [##1e01487e7b76443aa131bb1c7738d1c1].ShopToutID = ShopToutID)


    时间: 2021-04-28 17:06:06,903
  线程ID: 114
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##1e01487e7b76443aa131bb1c7738d1c1] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##1e01487e7b76443aa131bb1c7738d1c1] A INNER JOIN  ShopTin B ON A.ShopToutID = B.ShopToutID
 WHERE 1 = 1 


    时间: 2021-04-28 17:06:06,910
  线程ID: 114
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##1e01487e7b76443aa131bb1c7738d1c1] A
    INNER JOIN (
        SELECT A.ShopToutID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [ShopToutGoods] A 
             INNER JOIN ShopTout B ON A.ShopToutID = B.ShopToutID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.ToutShop = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##1e01487e7b76443aa131bb1c7738d1c1 WHERE A.ShopToutID = ShopToutID )
     AND EXISTS (SELECT 1 FROM [##6c54270aecf24f48b2ad7449ebac437c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopToutID
    ) B ON A.ShopToutID = B.ShopToutID


    时间: 2021-04-28 17:06:07,026
  线程ID: 114
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ShopTinQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) 
 FROM [##1e01487e7b76443aa131bb1c7738d1c1] A
    INNER JOIN (
        SELECT A.ShopToutID, SUM(B.Quantity) AS Quantity 
        FROM ShopTin A 
        INNER JOIN [ShopTinSSGoods] B ON A.ShopTinID = B.ShopTinID
        WHERE EXISTS( SELECT 1 FROM [##1e01487e7b76443aa131bb1c7738d1c1] WHERE A.ShopToutID = ShopToutID )
     AND EXISTS (SELECT 1 FROM [##6c54270aecf24f48b2ad7449ebac437c] WHERE Goods_No = B.Goods_No)
        GROUP BY A.ShopToutID
    ) B ON A.ShopToutID = B.ShopToutID


    时间: 2021-04-28 17:06:07,236
  线程ID: 114
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##1e01487e7b76443aa131bb1c7738d1c1] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ShopTinQuantity,0) 

    时间: 2021-04-28 17:06:07,241
  线程ID: 114
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopToutID AS [单号], Manual_ID AS [手工单号], Tout_Date AS [日期]
, ShopApplyOutID AS [调出通知单], rtrim(ToutShop) AS [调出渠道编号], ToutShopAbbrev AS [调出渠道简称], rtrim(TinShop) AS [调入渠道编号]
, TinShopAbbrev AS [调入渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , ShopTinQuantity AS [业务状态#调入数], ChangeQuantity AS [业务状态#差异数]
     , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[3baedb23-e55c-4ef4-9be0-0df9bb9f1d28]
 FROM [##1e01487e7b76443aa131bb1c7738d1c1]
 ORDER BY Tout_Date DESC, ShopToutID ASC


    时间: 2021-04-28 17:06:11,717
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##4eb321323bb348eea8ba03789d288642] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CMoveOut' AND A.ShopToutID = BillNo )


    时间: 2021-04-28 17:06:11,722
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##4eb321323bb348eea8ba03789d288642] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT ShopToutID FROM ShopTin 
      WHERE 1 = 1 AND [##4eb321323bb348eea8ba03789d288642].ShopToutID = ShopToutID)


    时间: 2021-04-28 17:06:11,728
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##4eb321323bb348eea8ba03789d288642] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##4eb321323bb348eea8ba03789d288642] A INNER JOIN  ShopTin B ON A.ShopToutID = B.ShopToutID
 WHERE 1 = 1 


    时间: 2021-04-28 17:06:11,735
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##4eb321323bb348eea8ba03789d288642] A
    INNER JOIN (
        SELECT A.ShopToutID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [ShopToutGoods] A 
             INNER JOIN ShopTout B ON A.ShopToutID = B.ShopToutID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.ToutShop = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##4eb321323bb348eea8ba03789d288642 WHERE A.ShopToutID = ShopToutID )
     AND EXISTS (SELECT 1 FROM [##2cef320d12a1417083631568736225a0] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopToutID
    ) B ON A.ShopToutID = B.ShopToutID


    时间: 2021-04-28 17:06:11,853
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ShopTinQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) 
 FROM [##4eb321323bb348eea8ba03789d288642] A
    INNER JOIN (
        SELECT A.ShopToutID, SUM(B.Quantity) AS Quantity 
        FROM ShopTin A 
        INNER JOIN [ShopTinSSGoods] B ON A.ShopTinID = B.ShopTinID
        WHERE EXISTS( SELECT 1 FROM [##4eb321323bb348eea8ba03789d288642] WHERE A.ShopToutID = ShopToutID )
     AND EXISTS (SELECT 1 FROM [##2cef320d12a1417083631568736225a0] WHERE Goods_No = B.Goods_No)
        GROUP BY A.ShopToutID
    ) B ON A.ShopToutID = B.ShopToutID


    时间: 2021-04-28 17:06:12,067
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##4eb321323bb348eea8ba03789d288642] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ShopTinQuantity,0) 

    时间: 2021-04-28 17:06:12,070
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopToutID AS [单号], Manual_ID AS [手工单号], Tout_Date AS [日期]
, ShopApplyOutID AS [调出通知单], rtrim(ToutShop) AS [调出渠道编号], ToutShopAbbrev AS [调出渠道简称], rtrim(TinShop) AS [调入渠道编号]
, TinShopAbbrev AS [调入渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , ShopTinQuantity AS [业务状态#调入数], ChangeQuantity AS [业务状态#差异数]
     , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[3baedb23-e55c-4ef4-9be0-0df9bb9f1d28]
 FROM [##4eb321323bb348eea8ba03789d288642]
 ORDER BY Tout_Date DESC, ShopToutID ASC


    时间: 2021-04-28 17:06:12,665
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##2df52b55cc2b4dccadfba6a1c4713f83] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CMoveOut' AND A.ShopToutID = BillNo )


    时间: 2021-04-28 17:06:12,670
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##2df52b55cc2b4dccadfba6a1c4713f83] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT ShopToutID FROM ShopTin 
      WHERE 1 = 1 AND [##2df52b55cc2b4dccadfba6a1c4713f83].ShopToutID = ShopToutID)


    时间: 2021-04-28 17:06:12,676
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##2df52b55cc2b4dccadfba6a1c4713f83] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##2df52b55cc2b4dccadfba6a1c4713f83] A INNER JOIN  ShopTin B ON A.ShopToutID = B.ShopToutID
 WHERE 1 = 1 


    时间: 2021-04-28 17:06:12,684
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##2df52b55cc2b4dccadfba6a1c4713f83] A
    INNER JOIN (
        SELECT A.ShopToutID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [ShopToutGoods] A 
             INNER JOIN ShopTout B ON A.ShopToutID = B.ShopToutID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.ToutShop = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##2df52b55cc2b4dccadfba6a1c4713f83 WHERE A.ShopToutID = ShopToutID )
     AND EXISTS (SELECT 1 FROM [##9a8b636ebcb249469bc5cec812f9f180] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopToutID
    ) B ON A.ShopToutID = B.ShopToutID


    时间: 2021-04-28 17:06:12,800
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ShopTinQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) 
 FROM [##2df52b55cc2b4dccadfba6a1c4713f83] A
    INNER JOIN (
        SELECT A.ShopToutID, SUM(B.Quantity) AS Quantity 
        FROM ShopTin A 
        INNER JOIN [ShopTinSSGoods] B ON A.ShopTinID = B.ShopTinID
        WHERE EXISTS( SELECT 1 FROM [##2df52b55cc2b4dccadfba6a1c4713f83] WHERE A.ShopToutID = ShopToutID )
     AND EXISTS (SELECT 1 FROM [##9a8b636ebcb249469bc5cec812f9f180] WHERE Goods_No = B.Goods_No)
        GROUP BY A.ShopToutID
    ) B ON A.ShopToutID = B.ShopToutID


    时间: 2021-04-28 17:06:13,011
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##2df52b55cc2b4dccadfba6a1c4713f83] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ShopTinQuantity,0) 

    时间: 2021-04-28 17:06:13,015
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopToutID AS [单号], Manual_ID AS [手工单号], Tout_Date AS [日期]
, ShopApplyOutID AS [调出通知单], rtrim(ToutShop) AS [调出渠道编号], ToutShopAbbrev AS [调出渠道简称], rtrim(TinShop) AS [调入渠道编号]
, TinShopAbbrev AS [调入渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , ShopTinQuantity AS [业务状态#调入数], ChangeQuantity AS [业务状态#差异数]
     , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[3baedb23-e55c-4ef4-9be0-0df9bb9f1d28]
 FROM [##2df52b55cc2b4dccadfba6a1c4713f83]
 ORDER BY Tout_Date DESC, ShopToutID ASC


    时间: 2021-04-28 17:06:13,611
  线程ID: 115
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##1384964a039f49d6a06622befec1f7f8] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CMoveOut' AND A.ShopToutID = BillNo )


    时间: 2021-04-28 17:06:13,616
  线程ID: 115
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##1384964a039f49d6a06622befec1f7f8] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT ShopToutID FROM ShopTin 
      WHERE 1 = 1 AND [##1384964a039f49d6a06622befec1f7f8].ShopToutID = ShopToutID)


    时间: 2021-04-28 17:06:13,623
  线程ID: 115
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##1384964a039f49d6a06622befec1f7f8] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##1384964a039f49d6a06622befec1f7f8] A INNER JOIN  ShopTin B ON A.ShopToutID = B.ShopToutID
 WHERE 1 = 1 


    时间: 2021-04-28 17:06:13,630
  线程ID: 115
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##1384964a039f49d6a06622befec1f7f8] A
    INNER JOIN (
        SELECT A.ShopToutID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [ShopToutGoods] A 
             INNER JOIN ShopTout B ON A.ShopToutID = B.ShopToutID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.ToutShop = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##1384964a039f49d6a06622befec1f7f8 WHERE A.ShopToutID = ShopToutID )
     AND EXISTS (SELECT 1 FROM [##37d1d721b0fe47a08737ce6ccc128118] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopToutID
    ) B ON A.ShopToutID = B.ShopToutID


    时间: 2021-04-28 17:06:13,737
  线程ID: 115
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ShopTinQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) 
 FROM [##1384964a039f49d6a06622befec1f7f8] A
    INNER JOIN (
        SELECT A.ShopToutID, SUM(B.Quantity) AS Quantity 
        FROM ShopTin A 
        INNER JOIN [ShopTinSSGoods] B ON A.ShopTinID = B.ShopTinID
        WHERE EXISTS( SELECT 1 FROM [##1384964a039f49d6a06622befec1f7f8] WHERE A.ShopToutID = ShopToutID )
     AND EXISTS (SELECT 1 FROM [##37d1d721b0fe47a08737ce6ccc128118] WHERE Goods_No = B.Goods_No)
        GROUP BY A.ShopToutID
    ) B ON A.ShopToutID = B.ShopToutID


    时间: 2021-04-28 17:06:13,952
  线程ID: 115
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##1384964a039f49d6a06622befec1f7f8] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ShopTinQuantity,0) 

    时间: 2021-04-28 17:06:13,955
  线程ID: 115
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopToutID AS [单号], Manual_ID AS [手工单号], Tout_Date AS [日期]
, ShopApplyOutID AS [调出通知单], rtrim(ToutShop) AS [调出渠道编号], ToutShopAbbrev AS [调出渠道简称], rtrim(TinShop) AS [调入渠道编号]
, TinShopAbbrev AS [调入渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , ShopTinQuantity AS [业务状态#调入数], ChangeQuantity AS [业务状态#差异数]
     , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[3baedb23-e55c-4ef4-9be0-0df9bb9f1d28]
 FROM [##1384964a039f49d6a06622befec1f7f8]
 ORDER BY Tout_Date DESC, ShopToutID ASC


    时间: 2021-04-28 17:11:20,368
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##b0d500a2961b41778e1ce64ba43dff29] 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 [##b0d500a2961b41778e1ce64ba43dff29] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##9cba7e4022464a629514997ea1c1324d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:20,517
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##b0d500a2961b41778e1ce64ba43dff29] 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 [##b0d500a2961b41778e1ce64ba43dff29] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##9cba7e4022464a629514997ea1c1324d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:20,699
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##b0d500a2961b41778e1ce64ba43dff29] 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 [##b0d500a2961b41778e1ce64ba43dff29] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##9cba7e4022464a629514997ea1c1324d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2021-04-28 17:11:20,839
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##b0d500a2961b41778e1ce64ba43dff29] 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 [##b0d500a2961b41778e1ce64ba43dff29] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##9cba7e4022464a629514997ea1c1324d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2021-04-28 17:11:20,994
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##b0d500a2961b41778e1ce64ba43dff29] 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 [##b0d500a2961b41778e1ce64ba43dff29] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##9cba7e4022464a629514997ea1c1324d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2021-04-28 17:11:21,159
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET CompareQuantity = ISNULL(B.CompareQuantity,0)
 FROM [##b0d500a2961b41778e1ce64ba43dff29] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.CompareQuantity,0)) As CompareQuantity
        FROM PuReceiptCompare A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##b0d500a2961b41778e1ce64ba43dff29] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##9cba7e4022464a629514997ea1c1324d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:21,321
  线程ID: 8
日志级别: 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.[14ccbdb2-5912-4160-8c3a-facd81bbda40]
 FROM [##b0d500a2961b41778e1ce64ba43dff29] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2021-04-28 17:11:21,610
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##5e72463f63c44deaa5812c446f0f0430] 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 [##5e72463f63c44deaa5812c446f0f0430] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##5b59e8117be448188fedaa1dffa90692] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:21,760
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##5e72463f63c44deaa5812c446f0f0430] 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 [##5e72463f63c44deaa5812c446f0f0430] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##5b59e8117be448188fedaa1dffa90692] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:21,946
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##5e72463f63c44deaa5812c446f0f0430] 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 [##5e72463f63c44deaa5812c446f0f0430] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##5b59e8117be448188fedaa1dffa90692] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2021-04-28 17:11:22,087
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##5e72463f63c44deaa5812c446f0f0430] 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 [##5e72463f63c44deaa5812c446f0f0430] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##5b59e8117be448188fedaa1dffa90692] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2021-04-28 17:11:22,244
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##5e72463f63c44deaa5812c446f0f0430] 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 [##5e72463f63c44deaa5812c446f0f0430] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##5b59e8117be448188fedaa1dffa90692] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2021-04-28 17:11:22,401
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET CompareQuantity = ISNULL(B.CompareQuantity,0)
 FROM [##5e72463f63c44deaa5812c446f0f0430] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.CompareQuantity,0)) As CompareQuantity
        FROM PuReceiptCompare A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##5e72463f63c44deaa5812c446f0f0430] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##5b59e8117be448188fedaa1dffa90692] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:22,551
  线程ID: 8
日志级别: 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.[14ccbdb2-5912-4160-8c3a-facd81bbda40]
 FROM [##5e72463f63c44deaa5812c446f0f0430] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2021-04-28 17:11:30,086
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##c390b51f949e4a0bbc89169815b5cc95] 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 [##c390b51f949e4a0bbc89169815b5cc95] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##40b2eddc33374d3d85c65772119e6221] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:30,250
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##c390b51f949e4a0bbc89169815b5cc95] 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 [##c390b51f949e4a0bbc89169815b5cc95] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##40b2eddc33374d3d85c65772119e6221] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:30,441
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##c390b51f949e4a0bbc89169815b5cc95] 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 [##c390b51f949e4a0bbc89169815b5cc95] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##40b2eddc33374d3d85c65772119e6221] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2021-04-28 17:11:30,578
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##c390b51f949e4a0bbc89169815b5cc95] 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 [##c390b51f949e4a0bbc89169815b5cc95] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##40b2eddc33374d3d85c65772119e6221] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2021-04-28 17:11:30,735
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##c390b51f949e4a0bbc89169815b5cc95] 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 [##c390b51f949e4a0bbc89169815b5cc95] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##40b2eddc33374d3d85c65772119e6221] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2021-04-28 17:11:30,899
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET CompareQuantity = ISNULL(B.CompareQuantity,0)
 FROM [##c390b51f949e4a0bbc89169815b5cc95] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.CompareQuantity,0)) As CompareQuantity
        FROM PuReceiptCompare A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##c390b51f949e4a0bbc89169815b5cc95] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##40b2eddc33374d3d85c65772119e6221] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:31,061
  线程ID: 17
日志级别: 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.[14ccbdb2-5912-4160-8c3a-facd81bbda40]
 FROM [##c390b51f949e4a0bbc89169815b5cc95] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2021-04-28 17:11:32,392
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##5168a65662d543bc8b8d9a322ba1e556] 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 [##5168a65662d543bc8b8d9a322ba1e556] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##e0c896c05e034af2b26f4d47f09b7082] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:32,537
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##5168a65662d543bc8b8d9a322ba1e556] 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 [##5168a65662d543bc8b8d9a322ba1e556] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##e0c896c05e034af2b26f4d47f09b7082] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:32,728
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##5168a65662d543bc8b8d9a322ba1e556] 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 [##5168a65662d543bc8b8d9a322ba1e556] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##e0c896c05e034af2b26f4d47f09b7082] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2021-04-28 17:11:32,865
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##5168a65662d543bc8b8d9a322ba1e556] 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 [##5168a65662d543bc8b8d9a322ba1e556] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##e0c896c05e034af2b26f4d47f09b7082] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2021-04-28 17:11:33,024
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##5168a65662d543bc8b8d9a322ba1e556] 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 [##5168a65662d543bc8b8d9a322ba1e556] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##e0c896c05e034af2b26f4d47f09b7082] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2021-04-28 17:11:33,189
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET CompareQuantity = ISNULL(B.CompareQuantity,0)
 FROM [##5168a65662d543bc8b8d9a322ba1e556] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.CompareQuantity,0)) As CompareQuantity
        FROM PuReceiptCompare A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##5168a65662d543bc8b8d9a322ba1e556] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##e0c896c05e034af2b26f4d47f09b7082] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:33,350
  线程ID: 17
日志级别: 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.[14ccbdb2-5912-4160-8c3a-facd81bbda40]
 FROM [##5168a65662d543bc8b8d9a322ba1e556] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2021-04-28 17:11:33,650
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##e37612b434404d70a9428e468dbf119f] 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 [##e37612b434404d70a9428e468dbf119f] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##064e800de8a44ba7b887c68eef61bbdb] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:33,804
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##e37612b434404d70a9428e468dbf119f] 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 [##e37612b434404d70a9428e468dbf119f] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##064e800de8a44ba7b887c68eef61bbdb] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:33,986
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##e37612b434404d70a9428e468dbf119f] 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 [##e37612b434404d70a9428e468dbf119f] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##064e800de8a44ba7b887c68eef61bbdb] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2021-04-28 17:11:34,128
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##e37612b434404d70a9428e468dbf119f] 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 [##e37612b434404d70a9428e468dbf119f] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##064e800de8a44ba7b887c68eef61bbdb] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2021-04-28 17:11:34,280
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##e37612b434404d70a9428e468dbf119f] 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 [##e37612b434404d70a9428e468dbf119f] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##064e800de8a44ba7b887c68eef61bbdb] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2021-04-28 17:11:34,438
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET CompareQuantity = ISNULL(B.CompareQuantity,0)
 FROM [##e37612b434404d70a9428e468dbf119f] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.CompareQuantity,0)) As CompareQuantity
        FROM PuReceiptCompare A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##e37612b434404d70a9428e468dbf119f] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##064e800de8a44ba7b887c68eef61bbdb] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:34,600
  线程ID: 57
日志级别: 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.[14ccbdb2-5912-4160-8c3a-facd81bbda40]
 FROM [##e37612b434404d70a9428e468dbf119f] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2021-04-28 17:11:34,867
  线程ID: 33
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##4b6d70b51b0e4248bf2fc7a0aab923ef] 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 [##4b6d70b51b0e4248bf2fc7a0aab923ef] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##4e21fa1ab43e404ea92a29bbeb043d45] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:35,025
  线程ID: 33
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##4b6d70b51b0e4248bf2fc7a0aab923ef] 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 [##4b6d70b51b0e4248bf2fc7a0aab923ef] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##4e21fa1ab43e404ea92a29bbeb043d45] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:35,223
  线程ID: 33
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##4b6d70b51b0e4248bf2fc7a0aab923ef] 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 [##4b6d70b51b0e4248bf2fc7a0aab923ef] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##4e21fa1ab43e404ea92a29bbeb043d45] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2021-04-28 17:11:35,369
  线程ID: 33
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##4b6d70b51b0e4248bf2fc7a0aab923ef] 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 [##4b6d70b51b0e4248bf2fc7a0aab923ef] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##4e21fa1ab43e404ea92a29bbeb043d45] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2021-04-28 17:11:35,528
  线程ID: 33
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##4b6d70b51b0e4248bf2fc7a0aab923ef] 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 [##4b6d70b51b0e4248bf2fc7a0aab923ef] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##4e21fa1ab43e404ea92a29bbeb043d45] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2021-04-28 17:11:35,688
  线程ID: 33
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET CompareQuantity = ISNULL(B.CompareQuantity,0)
 FROM [##4b6d70b51b0e4248bf2fc7a0aab923ef] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.CompareQuantity,0)) As CompareQuantity
        FROM PuReceiptCompare A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##4b6d70b51b0e4248bf2fc7a0aab923ef] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##4e21fa1ab43e404ea92a29bbeb043d45] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:35,843
  线程ID: 33
日志级别: 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.[14ccbdb2-5912-4160-8c3a-facd81bbda40]
 FROM [##4b6d70b51b0e4248bf2fc7a0aab923ef] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2021-04-28 17:11:46,652
  线程ID: 115
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##13852f93b5b14021a8f83ebd2a328f98] 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 [##13852f93b5b14021a8f83ebd2a328f98] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##298dc88f62a04176a3e955922aa4fa1d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:46,800
  线程ID: 115
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##13852f93b5b14021a8f83ebd2a328f98] 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 [##13852f93b5b14021a8f83ebd2a328f98] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##298dc88f62a04176a3e955922aa4fa1d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:46,984
  线程ID: 115
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##13852f93b5b14021a8f83ebd2a328f98] 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 [##13852f93b5b14021a8f83ebd2a328f98] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##298dc88f62a04176a3e955922aa4fa1d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2021-04-28 17:11:47,125
  线程ID: 115
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##13852f93b5b14021a8f83ebd2a328f98] 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 [##13852f93b5b14021a8f83ebd2a328f98] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##298dc88f62a04176a3e955922aa4fa1d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2021-04-28 17:11:47,286
  线程ID: 115
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##13852f93b5b14021a8f83ebd2a328f98] 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 [##13852f93b5b14021a8f83ebd2a328f98] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##298dc88f62a04176a3e955922aa4fa1d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2021-04-28 17:11:47,449
  线程ID: 115
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET CompareQuantity = ISNULL(B.CompareQuantity,0)
 FROM [##13852f93b5b14021a8f83ebd2a328f98] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.CompareQuantity,0)) As CompareQuantity
        FROM PuReceiptCompare A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##13852f93b5b14021a8f83ebd2a328f98] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##298dc88f62a04176a3e955922aa4fa1d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-04-28 17:11:47,611
  线程ID: 115
日志级别: 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.[14ccbdb2-5912-4160-8c3a-facd81bbda40]
 FROM [##13852f93b5b14021a8f83ebd2a328f98] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2021-04-28 17:12:03,256
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##2dfdecf0db9a4944b71806991af3f67e] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo )


    时间: 2021-04-28 17:12:03,265
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##2dfdecf0db9a4944b71806991af3f67e] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT DealereturnID FROM Pureceipt 
      WHERE Type = 3 AND [##2dfdecf0db9a4944b71806991af3f67e].DealereturnID = DealereturnID)


    时间: 2021-04-28 17:12:03,309
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##2dfdecf0db9a4944b71806991af3f67e] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END  
                              , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END  
 FROM [##2dfdecf0db9a4944b71806991af3f67e] A INNER JOIN  Pureceipt B ON A.DealereturnID = B.DealereturnID
 WHERE B.Type = 3 


    时间: 2021-04-28 17:12:03,316
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##2dfdecf0db9a4944b71806991af3f67e] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [DealeReturnGoods] A 
             INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##2dfdecf0db9a4944b71806991af3f67e WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##78666c0990244fe2970adc7a2a1e925d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2021-04-28 17:12:03,438
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##2dfdecf0db9a4944b71806991af3f67e] SET ReceiveQuantity = B.Quantity 
 FROM [##2dfdecf0db9a4944b71806991af3f67e] A INNER JOIN 
     ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity 
       FROM Pureceipt A 
            INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID 
        WHERE EXISTS( SELECT 1 FROM ##2dfdecf0db9a4944b71806991af3f67e WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##78666c0990244fe2970adc7a2a1e925d] WHERE Goods_No = C.Goods_No)
       GROUP BY A.DealereturnID 
      ) B ON A.DealereturnID = B.DealereturnID 


    时间: 2021-04-28 17:12:03,636
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##2dfdecf0db9a4944b71806991af3f67e] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 

    时间: 2021-04-28 17:12:03,640
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期]
, rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号]
, Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [零售额]
     , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数]
     , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[8727c8cb-b5ba-4244-9567-535c0dc44657]
 FROM [##2dfdecf0db9a4944b71806991af3f67e]
 ORDER BY Return_Date DESC, DealereturnID ASC


    时间: 2021-04-28 17:12:04,398
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##9c61b92b5c1d42c5ba808acc992b9dea] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo )


    时间: 2021-04-28 17:12:04,404
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##9c61b92b5c1d42c5ba808acc992b9dea] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT DealereturnID FROM Pureceipt 
      WHERE Type = 3 AND [##9c61b92b5c1d42c5ba808acc992b9dea].DealereturnID = DealereturnID)


    时间: 2021-04-28 17:12:04,448
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##9c61b92b5c1d42c5ba808acc992b9dea] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END  
                              , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END  
 FROM [##9c61b92b5c1d42c5ba808acc992b9dea] A INNER JOIN  Pureceipt B ON A.DealereturnID = B.DealereturnID
 WHERE B.Type = 3 


    时间: 2021-04-28 17:12:04,454
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##9c61b92b5c1d42c5ba808acc992b9dea] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [DealeReturnGoods] A 
             INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##9c61b92b5c1d42c5ba808acc992b9dea WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##f6bae2266c764013bb80b22d6b34f98d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2021-04-28 17:12:04,585
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##9c61b92b5c1d42c5ba808acc992b9dea] SET ReceiveQuantity = B.Quantity 
 FROM [##9c61b92b5c1d42c5ba808acc992b9dea] A INNER JOIN 
     ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity 
       FROM Pureceipt A 
            INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID 
        WHERE EXISTS( SELECT 1 FROM ##9c61b92b5c1d42c5ba808acc992b9dea WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##f6bae2266c764013bb80b22d6b34f98d] WHERE Goods_No = C.Goods_No)
       GROUP BY A.DealereturnID 
      ) B ON A.DealereturnID = B.DealereturnID 


    时间: 2021-04-28 17:12:04,797
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##9c61b92b5c1d42c5ba808acc992b9dea] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 

    时间: 2021-04-28 17:12:04,800
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期]
, rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号]
, Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [零售额]
     , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数]
     , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[8727c8cb-b5ba-4244-9567-535c0dc44657]
 FROM [##9c61b92b5c1d42c5ba808acc992b9dea]
 ORDER BY Return_Date DESC, DealereturnID ASC


    时间: 2021-04-28 17:12:05,389
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##628bf9052543484480bbee17116104c6] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo )


    时间: 2021-04-28 17:12:05,394
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##628bf9052543484480bbee17116104c6] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT DealereturnID FROM Pureceipt 
      WHERE Type = 3 AND [##628bf9052543484480bbee17116104c6].DealereturnID = DealereturnID)


    时间: 2021-04-28 17:12:05,433
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##628bf9052543484480bbee17116104c6] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END  
                              , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END  
 FROM [##628bf9052543484480bbee17116104c6] A INNER JOIN  Pureceipt B ON A.DealereturnID = B.DealereturnID
 WHERE B.Type = 3 


    时间: 2021-04-28 17:12:05,441
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##628bf9052543484480bbee17116104c6] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [DealeReturnGoods] A 
             INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##628bf9052543484480bbee17116104c6 WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##ada39efcef87411b8ac26d379b6696dd] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2021-04-28 17:12:05,559
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##628bf9052543484480bbee17116104c6] SET ReceiveQuantity = B.Quantity 
 FROM [##628bf9052543484480bbee17116104c6] A INNER JOIN 
     ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity 
       FROM Pureceipt A 
            INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID 
        WHERE EXISTS( SELECT 1 FROM ##628bf9052543484480bbee17116104c6 WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##ada39efcef87411b8ac26d379b6696dd] WHERE Goods_No = C.Goods_No)
       GROUP BY A.DealereturnID 
      ) B ON A.DealereturnID = B.DealereturnID 


    时间: 2021-04-28 17:12:05,752
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##628bf9052543484480bbee17116104c6] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 

    时间: 2021-04-28 17:12:05,755
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期]
, rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号]
, Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [零售额]
     , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数]
     , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[8727c8cb-b5ba-4244-9567-535c0dc44657]
 FROM [##628bf9052543484480bbee17116104c6]
 ORDER BY Return_Date DESC, DealereturnID ASC


    时间: 2021-04-28 17:12:06,350
  线程ID: 33
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##7b14be9e038b49d5960276e1de374901] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo )


    时间: 2021-04-28 17:12:06,354
  线程ID: 33
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##7b14be9e038b49d5960276e1de374901] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT DealereturnID FROM Pureceipt 
      WHERE Type = 3 AND [##7b14be9e038b49d5960276e1de374901].DealereturnID = DealereturnID)


    时间: 2021-04-28 17:12:06,395
  线程ID: 33
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##7b14be9e038b49d5960276e1de374901] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END  
                              , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END  
 FROM [##7b14be9e038b49d5960276e1de374901] A INNER JOIN  Pureceipt B ON A.DealereturnID = B.DealereturnID
 WHERE B.Type = 3 


    时间: 2021-04-28 17:12:06,404
  线程ID: 33
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##7b14be9e038b49d5960276e1de374901] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [DealeReturnGoods] A 
             INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##7b14be9e038b49d5960276e1de374901 WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##918d4171e3e1420d9c1e7f3a5a17c008] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2021-04-28 17:12:06,532
  线程ID: 33
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##7b14be9e038b49d5960276e1de374901] SET ReceiveQuantity = B.Quantity 
 FROM [##7b14be9e038b49d5960276e1de374901] A INNER JOIN 
     ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity 
       FROM Pureceipt A 
            INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID 
        WHERE EXISTS( SELECT 1 FROM ##7b14be9e038b49d5960276e1de374901 WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##918d4171e3e1420d9c1e7f3a5a17c008] WHERE Goods_No = C.Goods_No)
       GROUP BY A.DealereturnID 
      ) B ON A.DealereturnID = B.DealereturnID 


    时间: 2021-04-28 17:12:06,731
  线程ID: 33
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##7b14be9e038b49d5960276e1de374901] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 

    时间: 2021-04-28 17:12:06,733
  线程ID: 33
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期]
, rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号]
, Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [零售额]
     , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数]
     , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[8727c8cb-b5ba-4244-9567-535c0dc44657]
 FROM [##7b14be9e038b49d5960276e1de374901]
 ORDER BY Return_Date DESC, DealereturnID ASC


    时间: 2021-04-28 17:13:47,249
  线程ID: 114
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称]
,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式]
,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额]
,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣]
,[Group] [组], Company_ID [公司编号], SaleMan [业务员]
,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别]
INTO tempdb.dbo.[d5e8bb3f-98d3-48bd-aac3-e8c1cb41cba5]
 FROM Customer A
 INNER JOIN [##9c7c196df66b470bb417a94fd5ac94a7] B ON A.Customer_ID = B.Customer_ID
 ORDER BY A.Customer_ID