时间: 2021-03-04 16:44:55,739
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##5a6fc66259c944e482a6a6ba2f9f330a] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2021-03-04 16:44:55,754
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##5a6fc66259c944e482a6a6ba2f9f330a] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##5a6fc66259c944e482a6a6ba2f9f330a] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##fedba40d9b5d4b91b9beba41bb8af0dc] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2021-03-04 16:44:55,856
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##5a6fc66259c944e482a6a6ba2f9f330a] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##5a6fc66259c944e482a6a6ba2f9f330a] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##fedba40d9b5d4b91b9beba41bb8af0dc] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2021-03-04 16:44:55,955
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##5a6fc66259c944e482a6a6ba2f9f330a] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [ShopTinSSGoods] A 
             INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##5a6fc66259c944e482a6a6ba2f9f330a WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##fedba40d9b5d4b91b9beba41bb8af0dc] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2021-03-04 16:44:56,101
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##5a6fc66259c944e482a6a6ba2f9f330a] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2021-03-04 16:44:56,107
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期]
, DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号]
, TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [零售额]
     , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[ccbaba99-21b1-4c18-bbb7-6467e8ab6014]
 FROM [##5a6fc66259c944e482a6a6ba2f9f330a]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2021-03-04 16:45:00,578
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##09097a59040b438abde37ebc93172635] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2021-03-04 16:45:00,582
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##09097a59040b438abde37ebc93172635] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##09097a59040b438abde37ebc93172635] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##dba01558f2944d17b15ee58c4ca9bea9] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2021-03-04 16:45:00,679
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##09097a59040b438abde37ebc93172635] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##09097a59040b438abde37ebc93172635] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##dba01558f2944d17b15ee58c4ca9bea9] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2021-03-04 16:45:00,773
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##09097a59040b438abde37ebc93172635] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [ShopTinSSGoods] A 
             INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##09097a59040b438abde37ebc93172635 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##dba01558f2944d17b15ee58c4ca9bea9] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2021-03-04 16:45:00,915
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##09097a59040b438abde37ebc93172635] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2021-03-04 16:45:00,918
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期]
, DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号]
, TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [零售额]
     , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[ccbaba99-21b1-4c18-bbb7-6467e8ab6014]
 FROM [##09097a59040b438abde37ebc93172635]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2021-03-04 16:45:02,289
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##5f97fa3c580e4635b17612b4417024a0] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2021-03-04 16:45:02,293
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##5f97fa3c580e4635b17612b4417024a0] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##5f97fa3c580e4635b17612b4417024a0] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##57c46a0c4059477a8dad40071ff9fd69] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2021-03-04 16:45:02,390
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##5f97fa3c580e4635b17612b4417024a0] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##5f97fa3c580e4635b17612b4417024a0] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##57c46a0c4059477a8dad40071ff9fd69] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2021-03-04 16:45:02,498
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##5f97fa3c580e4635b17612b4417024a0] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [ShopTinSSGoods] A 
             INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##5f97fa3c580e4635b17612b4417024a0 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##57c46a0c4059477a8dad40071ff9fd69] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2021-03-04 16:45:02,653
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##5f97fa3c580e4635b17612b4417024a0] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2021-03-04 16:45:02,655
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期]
, DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号]
, TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [零售额]
     , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[ccbaba99-21b1-4c18-bbb7-6467e8ab6014]
 FROM [##5f97fa3c580e4635b17612b4417024a0]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2021-03-04 16:45:04,122
  线程ID: 85
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##25cdaf518b8f4abea1ee050985fd342b] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2021-03-04 16:45:04,126
  线程ID: 85
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##25cdaf518b8f4abea1ee050985fd342b] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##25cdaf518b8f4abea1ee050985fd342b] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##5fe0c60a01e14b8a96ff149cdad6985b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2021-03-04 16:45:04,233
  线程ID: 85
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##25cdaf518b8f4abea1ee050985fd342b] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##25cdaf518b8f4abea1ee050985fd342b] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##5fe0c60a01e14b8a96ff149cdad6985b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2021-03-04 16:45:04,337
  线程ID: 85
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##25cdaf518b8f4abea1ee050985fd342b] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [ShopTinSSGoods] A 
             INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##25cdaf518b8f4abea1ee050985fd342b WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##5fe0c60a01e14b8a96ff149cdad6985b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2021-03-04 16:45:04,489
  线程ID: 85
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##25cdaf518b8f4abea1ee050985fd342b] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2021-03-04 16:45:04,491
  线程ID: 85
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期]
, DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号]
, TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [零售额]
     , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[ccbaba99-21b1-4c18-bbb7-6467e8ab6014]
 FROM [##25cdaf518b8f4abea1ee050985fd342b]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2021-03-04 16:45:16,527
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##91140385eb324f359851bb5393cc4444] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2021-03-04 16:45:16,530
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##91140385eb324f359851bb5393cc4444] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##91140385eb324f359851bb5393cc4444] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##25a8aba786164f378a29012dff42c176] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2021-03-04 16:45:16,595
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##91140385eb324f359851bb5393cc4444] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##91140385eb324f359851bb5393cc4444] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##25a8aba786164f378a29012dff42c176] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2021-03-04 16:45:16,659
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##91140385eb324f359851bb5393cc4444] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [ShopTinSSGoods] A 
             INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##91140385eb324f359851bb5393cc4444 WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##25a8aba786164f378a29012dff42c176] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2021-03-04 16:45:16,782
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##91140385eb324f359851bb5393cc4444] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2021-03-04 16:45:16,784
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期]
, DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号]
, TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [零售额]
     , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[ccbaba99-21b1-4c18-bbb7-6467e8ab6014]
 FROM [##91140385eb324f359851bb5393cc4444]
 ORDER BY Tin_Date DESC, ShopTinID ASC


    时间: 2021-03-04 16:45:50,591
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##befe10364e854b21bf0366e76b23e109] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo )


    时间: 2021-03-04 16:45:50,597
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##befe10364e854b21bf0366e76b23e109] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT DealereturnID FROM Pureceipt 
      WHERE Type = 3 AND [##befe10364e854b21bf0366e76b23e109].DealereturnID = DealereturnID)


    时间: 2021-03-04 16:45:50,635
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##befe10364e854b21bf0366e76b23e109] 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 [##befe10364e854b21bf0366e76b23e109] A INNER JOIN  Pureceipt B ON A.DealereturnID = B.DealereturnID
 WHERE B.Type = 3 


    时间: 2021-03-04 16:45:50,640
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##befe10364e854b21bf0366e76b23e109] 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 ##befe10364e854b21bf0366e76b23e109 WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##ea64e01277fb4688ae7673b11d2b6045] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2021-03-04 16:45:50,783
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##befe10364e854b21bf0366e76b23e109] SET ReceiveQuantity = B.Quantity 
 FROM [##befe10364e854b21bf0366e76b23e109] 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 ##befe10364e854b21bf0366e76b23e109 WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##ea64e01277fb4688ae7673b11d2b6045] WHERE Goods_No = C.Goods_No)
       GROUP BY A.DealereturnID 
      ) B ON A.DealereturnID = B.DealereturnID 


    时间: 2021-03-04 16:45:50,967
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##befe10364e854b21bf0366e76b23e109] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 

    时间: 2021-03-04 16:45:50,968
  线程ID: 74
日志级别: 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.[08b1e6e2-015f-4eb3-9da9-ceba5bd779aa]
 FROM [##befe10364e854b21bf0366e76b23e109]
 ORDER BY Return_Date DESC, DealereturnID ASC


    时间: 2021-03-04 16:59:24,135
  线程ID: 80
日志级别: 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.[c660783e-576d-473b-ab9c-272d7df6e578]
FROM [##8e9ff418403249f0b0c5381bbe8b02b8]
ORDER BY Goods_no


    时间: 2021-03-04 18:31:17,683
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##9635cb1795724f3b8847d889925bd561] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CBalance' AND A.BalanceID = BillNo )


    时间: 2021-03-04 18:31:17,689
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##9635cb1795724f3b8847d889925bd561] 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 ##9635cb1795724f3b8847d889925bd561 WHERE A.BalanceID = BalanceID )
        GROUP BY A.BalanceID
    ) B ON A.BalanceID = B.BalanceID


    时间: 2021-03-04 18:31:17,740
  线程ID: 80
日志级别: 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.[434b38c3-58b0-4dbc-81fa-de965abd1cec]
 FROM [##9635cb1795724f3b8847d889925bd561]
 ORDER BY Balance_Date DESC, BalanceID ASC