时间: 2021-01-26 17:02:04,626
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##bbc81205c53841b29b3f69933616b3e4] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


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


    时间: 2021-01-26 17:02:04,635
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##bbc81205c53841b29b3f69933616b3e4] SET IsInStock = CASE WHEN (select 1 from PuReceipt B where B.DeliveryID = A.DeliveryID) = 1 THEN 1 ELSE 0 END 
 FROM [##bbc81205c53841b29b3f69933616b3e4] A 
 WHERE 1 = 1 


    时间: 2021-01-26 17:02:04,639
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##bbc81205c53841b29b3f69933616b3e4 A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##bbc81205c53841b29b3f69933616b3e4 WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##fc6964c1ec3d45e3942d88765d9d1a31] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2021-01-26 17:02:04,701
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##bbc81205c53841b29b3f69933616b3e4 A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##bbc81205c53841b29b3f69933616b3e4 WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##fc6964c1ec3d45e3942d88765d9d1a31] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2021-01-26 17:02:04,762
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##bbc81205c53841b29b3f69933616b3e4 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 ##bbc81205c53841b29b3f69933616b3e4 WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##fc6964c1ec3d45e3942d88765d9d1a31] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-01-26 17:02:04,819
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##bbc81205c53841b29b3f69933616b3e4 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 ##bbc81205c53841b29b3f69933616b3e4 WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##fc6964c1ec3d45e3942d88765d9d1a31] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-01-26 17:02:04,988
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##bbc81205c53841b29b3f69933616b3e4 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 ##bbc81205c53841b29b3f69933616b3e4 C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##fc6964c1ec3d45e3942d88765d9d1a31] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-01-26 17:02:05,142
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##bbc81205c53841b29b3f69933616b3e4
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2021-01-26 17:02:05,144
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##bbc81205c53841b29b3f69933616b3e4] 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 [##bbc81205c53841b29b3f69933616b3e4] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-01-26 17:02:05,177
  线程ID: 22
日志级别: 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.[b578e2cd-fe87-42aa-9ccd-bf290a1eec92]
 FROM [##bbc81205c53841b29b3f69933616b3e4]
 ORDER BY Delivery_Date DESC, DeliveryID ASC


    时间: 2021-01-26 17:08:09,586
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:      UPDATE A SET SaleType='线上发货'
     FROM [##cf31becbaf204a7bbfe8129efb56e812] A 
     WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') 
     AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' 
UPDATE [##cf31becbaf204a7bbfe8129efb56e812]  SET SaleType='正常销售' 
WHERE SaleType='正常' OR SaleType IS NULL OR SaleType = '' 
DELETE FROM [##cf31becbaf204a7bbfe8129efb56e812] WHERE 1=1
AND NOT EXISTS(SELECT 1 FROM ##051ea1f484cc4790874a8043aaa88795 B WHERE B.data = SaleType)


    时间: 2021-01-26 17:08:09,595
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE [##cf31becbaf204a7bbfe8129efb56e812] DROP COLUMN SaleType, OnlineSaleTypeID, RetailOrderID

    时间: 2021-01-26 17:08:09,596
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##cf31becbaf204a7bbfe8129efb56e812] A
 WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'ShopCheck2' AND A.CheckID = BillNo ) 


    时间: 2021-01-26 17:08:09,601
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##cf31becbaf204a7bbfe8129efb56e812] A
    INNER JOIN (
        SELECT A.CheckID, SUM(ISNULL(A.Quantity,0)) As Quantity, 
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.DiscountPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(GDP.DpPriceByRetail,0) ) As DpAmount
        FROM [vn_CheckGoods] A 
             INNER JOIN vn_Check B ON A.CheckID = B.CheckID
             LEFT JOIN [Customer] CT ON CT.Customer_ID=B.Customer_ID
             LEFT JOIN vGoodsDpPrice GDP ON CT.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##cf31becbaf204a7bbfe8129efb56e812 WHERE A.CheckID = CheckID )
     AND EXISTS (SELECT 1 FROM [##30652a79bf034fd7a991dfa20ed9573c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.CheckID
    ) B ON A.CheckID = B.CheckID


    时间: 2021-01-26 17:08:09,660
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT DISTINCT * INTO [##a0b075b15f4e4f61b0d765d8d860cacb] FROM [##cf31becbaf204a7bbfe8129efb56e812]

    时间: 2021-01-26 17:08:09,678
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CheckID AS [单号], Manual_ID AS [手工单号], CheckDate AS [日期]
, Customer_ID AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
        , DpAmount AS [吊牌额]
, Amount AS [生意额]
, JiZhang AS [记账状态#记账], JzOperator AS [记账状态#记账人], JzDate AS [记账状态#记账日期]
, Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期]
, Posted AS [单据状态#审核], PostUser AS [单据状态#审核人],PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期]
, PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[803e3228-eaec-4811-a95c-33630436e146]
 FROM [##a0b075b15f4e4f61b0d765d8d860cacb]
 ORDER BY CheckDate DESC, CheckID ASC


    时间: 2021-01-26 17:09:18,211
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##c781b197bb2c44c0ab7650e8f7876bbd] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-26 17:09:18,218
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##c781b197bb2c44c0ab7650e8f7876bbd] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##c781b197bb2c44c0ab7650e8f7876bbd WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##7bc3b39bd054484c9271a2f52bb46f74] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-26 17:09:18,329
  线程ID: 84
日志级别: 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.[e049a0e9-359b-4547-9b41-c14f390f7aa2]
 FROM [##c781b197bb2c44c0ab7650e8f7876bbd]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-26 17:10:05,625
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##ba36666af1e84a35ac11b77347c06cb7] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-26 17:10:05,629
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##ba36666af1e84a35ac11b77347c06cb7] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##ba36666af1e84a35ac11b77347c06cb7 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##aa5ecd92e3fd4f048c56bdf6623afea8] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-26 17:10:05,729
  线程ID: 75
日志级别: 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.[e049a0e9-359b-4547-9b41-c14f390f7aa2]
 FROM [##ba36666af1e84a35ac11b77347c06cb7]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-26 17:36:28,606
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##320b65d0465a46d28257919cc68d996d] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-26 17:36:28,609
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##320b65d0465a46d28257919cc68d996d] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##320b65d0465a46d28257919cc68d996d WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##0f0493cbdf8d45fa802b874435328b4f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-26 17:36:28,709
  线程ID: 57
日志级别: 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.[e049a0e9-359b-4547-9b41-c14f390f7aa2]
 FROM [##320b65d0465a46d28257919cc68d996d]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-26 17:36:35,293
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##06de2928a2184d849575be70b0e1f1d4] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-26 17:36:35,297
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##06de2928a2184d849575be70b0e1f1d4] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##06de2928a2184d849575be70b0e1f1d4 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##6cf1ad4e75384d8494f9767d2d922a42] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-26 17:36:35,396
  线程ID: 57
日志级别: 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.[e049a0e9-359b-4547-9b41-c14f390f7aa2]
 FROM [##06de2928a2184d849575be70b0e1f1d4]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-26 17:36:38,272
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##2de394d6bc514b1c9fc812f9b281d113] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-26 17:36:38,275
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##2de394d6bc514b1c9fc812f9b281d113] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##2de394d6bc514b1c9fc812f9b281d113 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##bda6d337265c44bca22615d5f7fc20c5] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-26 17:36:38,374
  线程ID: 22
日志级别: 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.[e049a0e9-359b-4547-9b41-c14f390f7aa2]
 FROM [##2de394d6bc514b1c9fc812f9b281d113]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-26 17:40:05,172
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##003717e2b70840aca2baa3647135e6c5] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-26 17:40:05,175
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##003717e2b70840aca2baa3647135e6c5] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##003717e2b70840aca2baa3647135e6c5 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##c64aa057cb73441fa68853ebb1ce7924] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-26 17:40:05,283
  线程ID: 75
日志级别: 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.[e049a0e9-359b-4547-9b41-c14f390f7aa2]
 FROM [##003717e2b70840aca2baa3647135e6c5]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-26 17:43:26,815
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##6e559ae3bcfe40e4a920719c2188816a] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-26 17:43:26,818
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##6e559ae3bcfe40e4a920719c2188816a] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##6e559ae3bcfe40e4a920719c2188816a WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##2fd4c1d8d9624b7a87fc6ba52502c9d0] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-26 17:43:26,922
  线程ID: 84
日志级别: 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.[e049a0e9-359b-4547-9b41-c14f390f7aa2]
 FROM [##6e559ae3bcfe40e4a920719c2188816a]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-26 17:43:40,894
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##cca4b2c5cdba41b2b1b8a2be5b984890] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-26 17:43:40,897
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##cca4b2c5cdba41b2b1b8a2be5b984890] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##cca4b2c5cdba41b2b1b8a2be5b984890 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##f425dc4e704b4d4087f8dfaf859c513e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-26 17:43:40,992
  线程ID: 98
日志级别: 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.[e049a0e9-359b-4547-9b41-c14f390f7aa2]
 FROM [##cca4b2c5cdba41b2b1b8a2be5b984890]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-26 17:47:59,800
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##245ad844ee3a465a9b24e1d7aa75165b] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-26 17:47:59,805
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##245ad844ee3a465a9b24e1d7aa75165b] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##245ad844ee3a465a9b24e1d7aa75165b WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##f23c7409296448b7ad2f080cfd213313] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-26 17:47:59,910
  线程ID: 22
日志级别: 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.[122e5350-994b-4d8e-a3bb-542817fb588b]
 FROM [##245ad844ee3a465a9b24e1d7aa75165b]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-26 17:48:12,711
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##b492146792be4985a42c033aa70947b6] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-26 17:48:12,715
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##b492146792be4985a42c033aa70947b6] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##b492146792be4985a42c033aa70947b6 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##ce5ce3288fbc42c3857b7f3f438172f3] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-26 17:48:12,809
  线程ID: 75
日志级别: 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.[122e5350-994b-4d8e-a3bb-542817fb588b]
 FROM [##b492146792be4985a42c033aa70947b6]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-26 17:48:30,051
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##4e3974985d1342278942919354ae2de3] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-26 17:48:30,054
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##4e3974985d1342278942919354ae2de3] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##4e3974985d1342278942919354ae2de3 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##f77ba9c69da64d97a86c2fe55293eea5] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-26 17:48:30,154
  线程ID: 17
日志级别: 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.[122e5350-994b-4d8e-a3bb-542817fb588b]
 FROM [##4e3974985d1342278942919354ae2de3]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-26 17:48:31,405
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##d3d413a05dc5429a931badbab57c797e] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-26 17:48:31,408
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##d3d413a05dc5429a931badbab57c797e] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##d3d413a05dc5429a931badbab57c797e WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##2354cda683154004bc848f0eac145a56] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-26 17:48:31,501
  线程ID: 75
日志级别: 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.[122e5350-994b-4d8e-a3bb-542817fb588b]
 FROM [##d3d413a05dc5429a931badbab57c797e]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-26 17:48:32,935
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##956a77d5e1a64599b2dd1f08f46fc642] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-26 17:48:32,938
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##956a77d5e1a64599b2dd1f08f46fc642] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##956a77d5e1a64599b2dd1f08f46fc642 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##2b3c87f44a44408ab40aa8389919b01e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-26 17:48:33,034
  线程ID: 84
日志级别: 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.[122e5350-994b-4d8e-a3bb-542817fb588b]
 FROM [##956a77d5e1a64599b2dd1f08f46fc642]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-26 17:48:33,603
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##365ce9e2ac7a4a8fb61b4aa6755d94f1] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-26 17:48:33,606
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##365ce9e2ac7a4a8fb61b4aa6755d94f1] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##365ce9e2ac7a4a8fb61b4aa6755d94f1 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##3593c986bb4f405a9c38d4217f45c4cc] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-26 17:48:33,700
  线程ID: 75
日志级别: 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.[122e5350-994b-4d8e-a3bb-542817fb588b]
 FROM [##365ce9e2ac7a4a8fb61b4aa6755d94f1]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-26 17:48:34,282
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##e1490d13c2244814a930bb852a333d81] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-26 17:48:34,285
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##e1490d13c2244814a930bb852a333d81] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##e1490d13c2244814a930bb852a333d81 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##6dd01d4447fb41ae96229c4caa009cd1] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-26 17:48:34,378
  线程ID: 17
日志级别: 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.[122e5350-994b-4d8e-a3bb-542817fb588b]
 FROM [##e1490d13c2244814a930bb852a333d81]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-26 17:48:34,953
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##91b97a53528f46ab8b3daf2d3a25fe9a] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-26 17:48:34,957
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##91b97a53528f46ab8b3daf2d3a25fe9a] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##91b97a53528f46ab8b3daf2d3a25fe9a WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##d044f9513b1143c2b43a9fbb942ef129] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-26 17:48:35,051
  线程ID: 98
日志级别: 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.[122e5350-994b-4d8e-a3bb-542817fb588b]
 FROM [##91b97a53528f46ab8b3daf2d3a25fe9a]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-26 17:48:35,607
  线程ID: 76
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##8ada3b0492df4401a943c1eba6ba9bf1] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-26 17:48:35,610
  线程ID: 76
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##8ada3b0492df4401a943c1eba6ba9bf1] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##8ada3b0492df4401a943c1eba6ba9bf1 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##84cafc16fb9649b0a2d1efc0b1acaf2e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-26 17:48:35,705
  线程ID: 76
日志级别: 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.[122e5350-994b-4d8e-a3bb-542817fb588b]
 FROM [##8ada3b0492df4401a943c1eba6ba9bf1]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-26 17:55:21,932
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##32d0b48006614ddeb452a65cecca2824] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-26 17:55:21,936
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##32d0b48006614ddeb452a65cecca2824] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##32d0b48006614ddeb452a65cecca2824 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##900c8f26480c43989f472c200050c599] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-26 17:55:22,042
  线程ID: 75
日志级别: 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.[d99d6b51-3cb0-4c1c-98ea-ac234b4d39a7]
 FROM [##32d0b48006614ddeb452a65cecca2824]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-26 17:56:14,997
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##960863a349114a90b058b4886346341c] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CBalance' AND A.BalanceID = BillNo )


    时间: 2021-01-26 17:56:15,010
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##960863a349114a90b058b4886346341c] 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 ##960863a349114a90b058b4886346341c WHERE A.BalanceID = BalanceID )
     AND EXISTS (SELECT 1 FROM [##59b370a766ad4fd3bf540cf267c34349] WHERE Goods_No = A.Goods_No)
        GROUP BY A.BalanceID
    ) B ON A.BalanceID = B.BalanceID


    时间: 2021-01-26 17:56:15,327
  线程ID: 17
日志级别: 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.[2993acf1-e140-4d5a-bc26-d777f341e019]
 FROM [##960863a349114a90b058b4886346341c]
 ORDER BY Balance_Date DESC, BalanceID ASC