时间: 2021-03-19 10:34:38,752
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##8c7e91c95b934c899c4f915f2b185708] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-03-19 10:34:38,768
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##8c7e91c95b934c899c4f915f2b185708] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##8c7e91c95b934c899c4f915f2b185708 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##48194b17125a4091992739fd224a6760] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-03-19 10:34:38,893
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号]
     , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[6782ef1f-ce68-4979-8ba3-d052d70a26f7]
 FROM [##8c7e91c95b934c899c4f915f2b185708]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-03-19 10:36:12,657
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##db06b60cebb745afb9c019f81681d03f] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-03-19 10:36:12,660
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##db06b60cebb745afb9c019f81681d03f] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##db06b60cebb745afb9c019f81681d03f WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##47aa805d93874d9192a8a65323028c2a] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-03-19 10:36:12,802
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号]
     , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[6782ef1f-ce68-4979-8ba3-d052d70a26f7]
 FROM [##db06b60cebb745afb9c019f81681d03f]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-03-19 10:37:04,722
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##501d21ca134e41a1936192963f0d6cf8] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-03-19 10:37:04,725
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##501d21ca134e41a1936192963f0d6cf8] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##501d21ca134e41a1936192963f0d6cf8 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##99443c0df3f24177aa2d16679121863f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-03-19 10:37:04,863
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号]
     , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[6782ef1f-ce68-4979-8ba3-d052d70a26f7]
 FROM [##501d21ca134e41a1936192963f0d6cf8]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-03-19 10:38:24,742
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##0dce717c26f64b489766f8a775d23178] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2021-03-19 10:38:24,745
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##0dce717c26f64b489766f8a775d23178] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##0dce717c26f64b489766f8a775d23178] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2021-03-19 10:38:24,751
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##0dce717c26f64b489766f8a775d23178] SET IsInStock = CASE WHEN (select 1 from PuReceipt B where B.DeliveryID = A.DeliveryID) = 1 THEN 1 ELSE 0 END 
 FROM [##0dce717c26f64b489766f8a775d23178] A 
 WHERE 1 = 1 


    时间: 2021-03-19 10:38:24,753
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##0dce717c26f64b489766f8a775d23178 A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##0dce717c26f64b489766f8a775d23178 WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##18ee799b06bd458e8e07176dd2f0b314] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2021-03-19 10:38:24,817
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##0dce717c26f64b489766f8a775d23178 A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##0dce717c26f64b489766f8a775d23178 WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##18ee799b06bd458e8e07176dd2f0b314] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2021-03-19 10:38:24,883
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##0dce717c26f64b489766f8a775d23178 A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##0dce717c26f64b489766f8a775d23178 WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##18ee799b06bd458e8e07176dd2f0b314] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-03-19 10:38:24,982
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##0dce717c26f64b489766f8a775d23178 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##0dce717c26f64b489766f8a775d23178 WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##18ee799b06bd458e8e07176dd2f0b314] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-03-19 10:38:25,183
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##0dce717c26f64b489766f8a775d23178 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##0dce717c26f64b489766f8a775d23178 C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##18ee799b06bd458e8e07176dd2f0b314] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-03-19 10:38:25,432
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##0dce717c26f64b489766f8a775d23178
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


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


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


    时间: 2021-03-19 10:38:55,310
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##08fdd4b7ac2740609550850d1460de90] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2021-03-19 10:38:55,314
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##08fdd4b7ac2740609550850d1460de90] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##08fdd4b7ac2740609550850d1460de90] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2021-03-19 10:38:55,320
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##08fdd4b7ac2740609550850d1460de90] SET IsInStock = CASE WHEN (select 1 from PuReceipt B where B.DeliveryID = A.DeliveryID) = 1 THEN 1 ELSE 0 END 
 FROM [##08fdd4b7ac2740609550850d1460de90] A 
 WHERE 1 = 1 


    时间: 2021-03-19 10:38:55,322
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##08fdd4b7ac2740609550850d1460de90 A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##08fdd4b7ac2740609550850d1460de90 WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##f7783af469e84d1498dc5cb191d62589] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2021-03-19 10:38:55,382
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##08fdd4b7ac2740609550850d1460de90 A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##08fdd4b7ac2740609550850d1460de90 WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##f7783af469e84d1498dc5cb191d62589] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2021-03-19 10:38:55,441
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##08fdd4b7ac2740609550850d1460de90 A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##08fdd4b7ac2740609550850d1460de90 WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##f7783af469e84d1498dc5cb191d62589] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-03-19 10:38:55,525
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##08fdd4b7ac2740609550850d1460de90 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##08fdd4b7ac2740609550850d1460de90 WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##f7783af469e84d1498dc5cb191d62589] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-03-19 10:38:55,692
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##08fdd4b7ac2740609550850d1460de90 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##08fdd4b7ac2740609550850d1460de90 C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##f7783af469e84d1498dc5cb191d62589] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-03-19 10:38:55,901
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##08fdd4b7ac2740609550850d1460de90
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2021-03-19 10:38:55,903
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##08fdd4b7ac2740609550850d1460de90] A
    INNER JOIN (
        SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount
        FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo
        WHERE A.AccBillType = 'WareDelivery' 
          AND EXISTS( SELECT 1 FROM [##08fdd4b7ac2740609550850d1460de90] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


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


    时间: 2021-03-19 10:40:47,609
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##9087049eff2147d2993a459b0a22a258] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2021-03-19 10:40:47,613
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##9087049eff2147d2993a459b0a22a258] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##9087049eff2147d2993a459b0a22a258] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2021-03-19 10:40:47,621
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##9087049eff2147d2993a459b0a22a258] SET IsInStock = CASE WHEN (select 1 from PuReceipt B where B.DeliveryID = A.DeliveryID) = 1 THEN 1 ELSE 0 END 
 FROM [##9087049eff2147d2993a459b0a22a258] A 
 WHERE 1 = 1 


    时间: 2021-03-19 10:40:47,624
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##9087049eff2147d2993a459b0a22a258 A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##9087049eff2147d2993a459b0a22a258 WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##050ea5f0bb794e68b7de5811d1dcd03c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2021-03-19 10:40:47,708
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##9087049eff2147d2993a459b0a22a258 A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##9087049eff2147d2993a459b0a22a258 WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##050ea5f0bb794e68b7de5811d1dcd03c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2021-03-19 10:40:47,790
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##9087049eff2147d2993a459b0a22a258 A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##9087049eff2147d2993a459b0a22a258 WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##050ea5f0bb794e68b7de5811d1dcd03c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-03-19 10:40:47,909
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##9087049eff2147d2993a459b0a22a258 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##9087049eff2147d2993a459b0a22a258 WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##050ea5f0bb794e68b7de5811d1dcd03c] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-03-19 10:40:48,059
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##9087049eff2147d2993a459b0a22a258 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##9087049eff2147d2993a459b0a22a258 C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##050ea5f0bb794e68b7de5811d1dcd03c] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-03-19 10:40:48,269
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##9087049eff2147d2993a459b0a22a258
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2021-03-19 10:40:48,271
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##9087049eff2147d2993a459b0a22a258] A
    INNER JOIN (
        SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount
        FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo
        WHERE A.AccBillType = 'WareDelivery' 
          AND EXISTS( SELECT 1 FROM [##9087049eff2147d2993a459b0a22a258] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


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


    时间: 2021-03-19 14:34:56,730
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##58c224396d894ebd881d33614cb19e5a] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-03-19 14:34:56,734
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##58c224396d894ebd881d33614cb19e5a] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##58c224396d894ebd881d33614cb19e5a WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##6bfd58a65a13494292aac2d704cbbf5f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-03-19 14:34:56,875
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号]
     , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[6782ef1f-ce68-4979-8ba3-d052d70a26f7]
 FROM [##58c224396d894ebd881d33614cb19e5a]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-03-19 14:34:58,137
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##89a39d8de5b649b19390a460c8191e64] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-03-19 14:34:58,142
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##89a39d8de5b649b19390a460c8191e64] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##89a39d8de5b649b19390a460c8191e64 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##88fc94ebb08b4cbfb2bb7dcde32ae7b4] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-03-19 14:34:58,289
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号]
     , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[6782ef1f-ce68-4979-8ba3-d052d70a26f7]
 FROM [##89a39d8de5b649b19390a460c8191e64]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-03-19 14:35:04,459
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##9770eee511724dd6ac54706579f3e6c6] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-03-19 14:35:04,464
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##9770eee511724dd6ac54706579f3e6c6] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##9770eee511724dd6ac54706579f3e6c6 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##3f60b1e2d6694ef3b3767ff322d2483e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-03-19 14:35:04,628
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号]
     , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[6782ef1f-ce68-4979-8ba3-d052d70a26f7]
 FROM [##9770eee511724dd6ac54706579f3e6c6]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-03-19 14:37:18,891
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##e4e14dfa3de5456e8c55ac2b8e81f6c8] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-03-19 14:37:18,894
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##e4e14dfa3de5456e8c55ac2b8e81f6c8] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##e4e14dfa3de5456e8c55ac2b8e81f6c8 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##b9b1538c18014532a311f90a64902093] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-03-19 14:37:19,042
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号]
     , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[d8df77d5-aba3-4ffe-8f17-2c278eef9809]
 FROM [##e4e14dfa3de5456e8c55ac2b8e81f6c8]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-03-19 14:37:30,857
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##b6ba21e4f2f44c489ebaeafe4dae7265] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-03-19 14:37:30,862
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##b6ba21e4f2f44c489ebaeafe4dae7265] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##b6ba21e4f2f44c489ebaeafe4dae7265 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##27246cebf7ba4d4da20100a27ebcc63b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-03-19 14:37:30,991
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号]
     , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[d8df77d5-aba3-4ffe-8f17-2c278eef9809]
 FROM [##b6ba21e4f2f44c489ebaeafe4dae7265]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-03-19 14:40:45,060
  线程ID: 34
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##627a581e003d4473bba23cbdc2165c08] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2021-03-19 14:40:45,064
  线程ID: 34
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##627a581e003d4473bba23cbdc2165c08] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##627a581e003d4473bba23cbdc2165c08] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2021-03-19 14:40:45,069
  线程ID: 34
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##627a581e003d4473bba23cbdc2165c08] SET IsInStock = CASE WHEN (select 1 from PuReceipt B where B.DeliveryID = A.DeliveryID) = 1 THEN 1 ELSE 0 END 
 FROM [##627a581e003d4473bba23cbdc2165c08] A 
 WHERE 1 = 1 


    时间: 2021-03-19 14:40:45,071
  线程ID: 34
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##627a581e003d4473bba23cbdc2165c08 A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##627a581e003d4473bba23cbdc2165c08 WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##b92861c6725b4193bb1d1ebea84a03cf] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2021-03-19 14:40:45,126
  线程ID: 34
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##627a581e003d4473bba23cbdc2165c08 A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##627a581e003d4473bba23cbdc2165c08 WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##b92861c6725b4193bb1d1ebea84a03cf] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2021-03-19 14:40:45,183
  线程ID: 34
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##627a581e003d4473bba23cbdc2165c08 A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##627a581e003d4473bba23cbdc2165c08 WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##b92861c6725b4193bb1d1ebea84a03cf] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-03-19 14:40:45,264
  线程ID: 34
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##627a581e003d4473bba23cbdc2165c08 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##627a581e003d4473bba23cbdc2165c08 WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##b92861c6725b4193bb1d1ebea84a03cf] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-03-19 14:40:45,435
  线程ID: 34
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##627a581e003d4473bba23cbdc2165c08 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##627a581e003d4473bba23cbdc2165c08 C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##b92861c6725b4193bb1d1ebea84a03cf] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-03-19 14:40:45,644
  线程ID: 34
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##627a581e003d4473bba23cbdc2165c08
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


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


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


    时间: 2021-03-19 14:41:25,880
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##46e367d8988f4c7f9dc6e7213ac306ee] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2021-03-19 14:41:25,883
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##46e367d8988f4c7f9dc6e7213ac306ee] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##46e367d8988f4c7f9dc6e7213ac306ee] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2021-03-19 14:41:25,890
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##46e367d8988f4c7f9dc6e7213ac306ee] SET IsInStock = CASE WHEN (select 1 from PuReceipt B where B.DeliveryID = A.DeliveryID) = 1 THEN 1 ELSE 0 END 
 FROM [##46e367d8988f4c7f9dc6e7213ac306ee] A 
 WHERE 1 = 1 


    时间: 2021-03-19 14:41:25,892
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##46e367d8988f4c7f9dc6e7213ac306ee A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##46e367d8988f4c7f9dc6e7213ac306ee WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##dbbabef0cdec49a2af9617317dd6d872] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2021-03-19 14:41:25,949
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##46e367d8988f4c7f9dc6e7213ac306ee A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##46e367d8988f4c7f9dc6e7213ac306ee WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##dbbabef0cdec49a2af9617317dd6d872] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2021-03-19 14:41:26,004
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##46e367d8988f4c7f9dc6e7213ac306ee A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##46e367d8988f4c7f9dc6e7213ac306ee WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##dbbabef0cdec49a2af9617317dd6d872] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-03-19 14:41:26,084
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##46e367d8988f4c7f9dc6e7213ac306ee A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##46e367d8988f4c7f9dc6e7213ac306ee WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##dbbabef0cdec49a2af9617317dd6d872] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-03-19 14:41:26,206
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##46e367d8988f4c7f9dc6e7213ac306ee A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##46e367d8988f4c7f9dc6e7213ac306ee C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##dbbabef0cdec49a2af9617317dd6d872] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-03-19 14:41:26,337
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##46e367d8988f4c7f9dc6e7213ac306ee
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2021-03-19 14:41:26,338
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##46e367d8988f4c7f9dc6e7213ac306ee] A
    INNER JOIN (
        SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount
        FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo
        WHERE A.AccBillType = 'WareDelivery' 
          AND EXISTS( SELECT 1 FROM [##46e367d8988f4c7f9dc6e7213ac306ee] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


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