时间: 2020-12-16 13:34:57,074
  线程ID: 108
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##80fde1acf7f74d44b5ca79bec87eaacc] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2020-12-16 13:34:57,081
  线程ID: 108
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##80fde1acf7f74d44b5ca79bec87eaacc] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##80fde1acf7f74d44b5ca79bec87eaacc WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##49bf69b271dc4c099c5923f26dfe5778] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2020-12-16 13:34:57,201
  线程ID: 108
日志级别: 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.[3989746e-e8e1-4bc3-8bc3-49b43a3831cf]
 FROM [##80fde1acf7f74d44b5ca79bec87eaacc]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2020-12-16 13:35:08,665
  线程ID: 96
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##56ce67ef6ce74e2db9b46607f3822059] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2020-12-16 13:35:08,669
  线程ID: 96
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##56ce67ef6ce74e2db9b46607f3822059] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##56ce67ef6ce74e2db9b46607f3822059 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##01127f0eb2de4c5d86f594dbb51f4e51] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2020-12-16 13:35:08,787
  线程ID: 96
日志级别: 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.[3989746e-e8e1-4bc3-8bc3-49b43a3831cf]
 FROM [##56ce67ef6ce74e2db9b46607f3822059]
 ORDER BY PdStock_Date DESC, PdStockID ASC