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


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


    时间: 2021-01-20 14:15:43,868
  线程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.[2159d4f4-4812-4e70-b338-b7063bb9e91f]
 FROM [##6299fefdb68b49a4b4d84524cbb11b38]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-20 14:15:45,077
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##32802216ebf14555ab5ea863a5cbab0b] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-20 14:15:45,080
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##32802216ebf14555ab5ea863a5cbab0b] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##32802216ebf14555ab5ea863a5cbab0b WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##b8501b0a3eed459cbf9474c4f5bb7e3c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 14:15:45,194
  线程ID: 99
日志级别: 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.[2159d4f4-4812-4e70-b338-b7063bb9e91f]
 FROM [##32802216ebf14555ab5ea863a5cbab0b]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-20 14:15:45,915
  线程ID: 31
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##838ab4a97d2e496592b3a3994558c037] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-20 14:15:45,920
  线程ID: 31
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##838ab4a97d2e496592b3a3994558c037] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##838ab4a97d2e496592b3a3994558c037 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##117a997c2c664d76884f23af3ab81271] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 14:15:46,032
  线程ID: 31
日志级别: 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.[2159d4f4-4812-4e70-b338-b7063bb9e91f]
 FROM [##838ab4a97d2e496592b3a3994558c037]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-20 14:15:46,759
  线程ID: 30
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##3c5b29ee6eff416c8ea38ee7d4154914] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-20 14:15:46,763
  线程ID: 30
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##3c5b29ee6eff416c8ea38ee7d4154914] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##3c5b29ee6eff416c8ea38ee7d4154914 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##b1d654baf11a478384f4ad97431019d0] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 14:15:46,874
  线程ID: 30
日志级别: 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.[2159d4f4-4812-4e70-b338-b7063bb9e91f]
 FROM [##3c5b29ee6eff416c8ea38ee7d4154914]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-20 14:15:57,742
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##eb44fad9dddd4d44a4feaae9eb4e6e61] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-20 14:15:57,745
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##eb44fad9dddd4d44a4feaae9eb4e6e61] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##eb44fad9dddd4d44a4feaae9eb4e6e61 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##3892011693284ce1bf650ce08b3b59c7] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 14:15:57,856
  线程ID: 73
日志级别: 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.[2159d4f4-4812-4e70-b338-b7063bb9e91f]
 FROM [##eb44fad9dddd4d44a4feaae9eb4e6e61]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-20 14:15:58,670
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##f2ca87c46b2d4d3d8de80d76ad71868b] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-20 14:15:58,673
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##f2ca87c46b2d4d3d8de80d76ad71868b] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##f2ca87c46b2d4d3d8de80d76ad71868b WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##caa839bf032a4b69bc282a8a67ace43f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 14:15:58,785
  线程ID: 99
日志级别: 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.[2159d4f4-4812-4e70-b338-b7063bb9e91f]
 FROM [##f2ca87c46b2d4d3d8de80d76ad71868b]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-20 14:16:04,762
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##d32a9dc8a6e3445bab969eccc00fda1a] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-20 14:16:04,765
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##d32a9dc8a6e3445bab969eccc00fda1a] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##d32a9dc8a6e3445bab969eccc00fda1a WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##b0f7c1e6e149427c84ed5ef5cd2a656d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 14:16:04,876
  线程ID: 99
日志级别: 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.[ee910179-9e14-4118-9fda-daa6b25afe57]
 FROM [##d32a9dc8a6e3445bab969eccc00fda1a]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-20 14:16:16,698
  线程ID: 31
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH WarehouseData AS ( 
SELECT Warehouse_No FROM rightWare RS 
WHERE RS.Warehouse_No <> '全部'
AND RS.UserNo = '201'
UNION  
SELECT S.Warehouse_No FROM Warehouse S , rightWare RS
WHERE RS.UserNo = '201'
AND RS.Warehouse_No = '全部'
 )
SELECT * INTO ##497bb0fe6a6a43a4ab8b8a27ea52fc8f FROM WarehouseData 

    时间: 2021-01-20 14:16:16,733
  线程ID: 31
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Warehouse_No AS [仓库编号], Warehouse_Na AS [仓库名称], Region AS [区域]
,ChannelID AS [上级渠道], PreAbbrev AS [上级渠道简称]
,AccountCustomer_ID AS [应收归集户口], AccountCustomerAbbrev AS [应收归集户口简称], KeyMan AS [联系人]
,Tele AS [电话], AllowMinusStock AS [仓库库存准许负数]
,ShutOut AS [停用], Tag AS [虚拟仓]
INTO tempdb.dbo.[8efe5a1f-4c14-453d-81f5-898108434a4b]
 FROM [##63cbacd6b4d045c4b18760e254266753]
 ORDER BY Warehouse_No


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


    时间: 2021-01-20 14:16:41,751
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##f9c1b608e90e40579e0749d0eaf1c5a2] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##f9c1b608e90e40579e0749d0eaf1c5a2 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##79ce8b864fcd45e58b5052bf301ee03e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 14:16:41,862
  线程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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##f9c1b608e90e40579e0749d0eaf1c5a2]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


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


    时间: 2021-01-20 14:17:28,792
  线程ID: 31
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##dd748e9d95074b90aea2694bcf5be2bf]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


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


    时间: 2021-01-20 14:17:29,651
  线程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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##3902436d008841b390e9bb10283a7b20]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


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


    时间: 2021-01-20 14:17:30,578
  线程ID: 73
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##2e6972190b684f6b8faa8c8652444184]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-20 14:17:31,339
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##925df49afc274560aaa47554929c8ae4] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##925df49afc274560aaa47554929c8ae4 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##92b2e7f161364791b7f4abe13bc61229] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 14:17:31,476
  线程ID: 99
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##925df49afc274560aaa47554929c8ae4]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


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


    时间: 2021-01-20 14:17:32,341
  线程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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##e4d49a98a45549ebb70d8eb55470994e]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-20 14:17:57,328
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH WarehouseData AS ( 
SELECT Warehouse_No FROM rightWare RS 
WHERE RS.Warehouse_No <> '全部'
AND RS.UserNo = '201'
UNION  
SELECT S.Warehouse_No FROM Warehouse S , rightWare RS
WHERE RS.UserNo = '201'
AND RS.Warehouse_No = '全部'
 )
SELECT * INTO ##6efb558ca060469785947628715d9a84 FROM WarehouseData 

    时间: 2021-01-20 14:17:57,361
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Warehouse_No AS [仓库编号], Warehouse_Na AS [仓库名称], Region AS [区域]
,ChannelID AS [上级渠道], PreAbbrev AS [上级渠道简称]
,AccountCustomer_ID AS [应收归集户口], AccountCustomerAbbrev AS [应收归集户口简称], KeyMan AS [联系人]
,Tele AS [电话], AllowMinusStock AS [仓库库存准许负数]
,ShutOut AS [停用], Tag AS [虚拟仓]
INTO tempdb.dbo.[76b22af3-d190-48eb-b49c-f5b168550f59]
 FROM [##d5d17eb012d54f799ffefc0d3ba81150]
 ORDER BY Warehouse_No


    时间: 2021-01-20 14:21:09,845
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##8c9db53b3f6d4046b0140aca29921ade] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-20 14:21:09,849
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##8c9db53b3f6d4046b0140aca29921ade] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##8c9db53b3f6d4046b0140aca29921ade WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##264431c61d4d43aaae3b31c86a734309] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 14:21:09,961
  线程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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##8c9db53b3f6d4046b0140aca29921ade]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-20 14:21:10,684
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##d2f2639091c64ef8bdcb505df59e12c2] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##d2f2639091c64ef8bdcb505df59e12c2 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##3fc18ce1ae5940459454abb1df03e0a7] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 14:21:10,795
  线程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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##d2f2639091c64ef8bdcb505df59e12c2]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-20 14:21:11,536
  线程ID: 30
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##3dbbee2f16be420cb8976cbbdfd5b945] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-20 14:21:11,539
  线程ID: 30
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##3dbbee2f16be420cb8976cbbdfd5b945] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##3dbbee2f16be420cb8976cbbdfd5b945 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##ee60a27b0ea54a4387f5290a8963e70e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 14:21:11,653
  线程ID: 30
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##3dbbee2f16be420cb8976cbbdfd5b945]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-20 14:21:12,377
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##0ad42a20216f4ee3ae25030350452ecf] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-20 14:21:12,382
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##0ad42a20216f4ee3ae25030350452ecf] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##0ad42a20216f4ee3ae25030350452ecf WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##777b21c8516c4d0b82c69c9e8d7be7d0] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 14:21:12,495
  线程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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##0ad42a20216f4ee3ae25030350452ecf]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-20 14:21:13,223
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##adc5e95901514b5bb30d59c948c64664] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-20 14:21:13,227
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##adc5e95901514b5bb30d59c948c64664] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##adc5e95901514b5bb30d59c948c64664 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##963eee7a684a44dea724327dfdd2871e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 14:21:13,338
  线程ID: 99
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##adc5e95901514b5bb30d59c948c64664]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-20 14:23:31,074
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##dbfa388bd7e347f6948eb1ae5d61af0e] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##dbfa388bd7e347f6948eb1ae5d61af0e WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##4f78ebd22afd48a7845d16d1a419f023] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 14:23:31,185
  线程ID: 99
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##dbfa388bd7e347f6948eb1ae5d61af0e]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-20 15:28:02,230
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##ee1110b6d69a4e14b75bc04b7f85df82] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-20 15:28:02,234
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##ee1110b6d69a4e14b75bc04b7f85df82] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##ee1110b6d69a4e14b75bc04b7f85df82 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##a85b08470e884cd5b07f2df03ed0683e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 15:28:02,341
  线程ID: 16
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##ee1110b6d69a4e14b75bc04b7f85df82]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-20 15:28:12,553
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##5f2b0ef4a9bb4ba598bffac1388858d9] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-20 15:28:12,557
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##5f2b0ef4a9bb4ba598bffac1388858d9] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##5f2b0ef4a9bb4ba598bffac1388858d9 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##61a0d967b95c4b7eabb637a915a7dc6d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 15:28:12,664
  线程ID: 88
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##5f2b0ef4a9bb4ba598bffac1388858d9]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-20 15:28:26,818
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##7fa817c71dc340a68f85644ee0c01a80] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##7fa817c71dc340a68f85644ee0c01a80 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##245556737c0747f4ac05575fae9f781d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 15:28:26,915
  线程ID: 88
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##7fa817c71dc340a68f85644ee0c01a80]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-20 15:30:33,296
  线程ID: 104
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##57afdb51cb344a41a045b35f605f491a] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-20 15:30:33,300
  线程ID: 104
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##57afdb51cb344a41a045b35f605f491a] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##57afdb51cb344a41a045b35f605f491a WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##514a60eb35834fc4bba2875a1d0218c7] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 15:30:33,421
  线程ID: 104
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##57afdb51cb344a41a045b35f605f491a]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-20 15:30:34,160
  线程ID: 18
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##c2107c1984ef44f9bb9f521ad0b36365] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##c2107c1984ef44f9bb9f521ad0b36365 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##d498e3289b1e43c694a6b15d2e6e380d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 15:30:34,286
  线程ID: 18
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##c2107c1984ef44f9bb9f521ad0b36365]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-20 15:30:35,015
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##06fba9dd52f145898b20c41bd18ed881] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##06fba9dd52f145898b20c41bd18ed881 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##3234d9d531ac4db787ab8061b7a9e3e9] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 15:30:35,135
  线程ID: 16
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##06fba9dd52f145898b20c41bd18ed881]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-20 15:30:35,869
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##1900e20de61d45c7ae47bab9c8e50818] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-20 15:30:35,873
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##1900e20de61d45c7ae47bab9c8e50818] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##1900e20de61d45c7ae47bab9c8e50818 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##7d69ff285dc74a8d856ad99f55b8b965] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 15:30:35,994
  线程ID: 88
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##1900e20de61d45c7ae47bab9c8e50818]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-20 15:30:36,726
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##cdb28b9bca494db585c4c376fba6755c] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##cdb28b9bca494db585c4c376fba6755c WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##02af973c552f44cd9f56a21470a48355] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 15:30:36,850
  线程ID: 49
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##cdb28b9bca494db585c4c376fba6755c]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-20 15:30:37,627
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##ad19fb42e9314875ab8f2534f150cf8b] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##ad19fb42e9314875ab8f2534f150cf8b WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##372cf761f57348fcbd26087e0be0b08d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 15:30:37,748
  线程ID: 88
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##ad19fb42e9314875ab8f2534f150cf8b]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-20 15:30:38,569
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##404e2081b3e24cc08056ad335ae48d58] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-20 15:30:38,573
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##404e2081b3e24cc08056ad335ae48d58] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##404e2081b3e24cc08056ad335ae48d58 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##9d565ab734d3470b8d4849175e2020b5] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 15:30:38,701
  线程ID: 16
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##404e2081b3e24cc08056ad335ae48d58]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-20 15:30:39,441
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##c7a50598e7eb48f38170f2d4d4c9531d] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##c7a50598e7eb48f38170f2d4d4c9531d WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##7eb7080cca5545ea9459388216bd07c0] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 15:30:39,565
  线程ID: 16
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##c7a50598e7eb48f38170f2d4d4c9531d]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-20 15:30:40,313
  线程ID: 104
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##ea7227d97e7e4789b0b7c92b7ebd321d] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##ea7227d97e7e4789b0b7c92b7ebd321d WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##6355dae3be4d4316b9a0d511cf73b86e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 15:30:40,433
  线程ID: 104
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##ea7227d97e7e4789b0b7c92b7ebd321d]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-20 15:30:41,157
  线程ID: 104
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##ea7eed4b62694aee9efcb41464cd2930] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##ea7eed4b62694aee9efcb41464cd2930 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##43ab65b3afa04120b23c42d8562809c8] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 15:30:41,280
  线程ID: 104
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##ea7eed4b62694aee9efcb41464cd2930]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-20 15:30:42,024
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##3cefce34beed40f9aa5cf20ed61fa395] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-20 15:30:42,027
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##3cefce34beed40f9aa5cf20ed61fa395] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##3cefce34beed40f9aa5cf20ed61fa395 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##10359ad8ab264be58c56c3440fa371f1] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 15:30:42,148
  线程ID: 49
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##3cefce34beed40f9aa5cf20ed61fa395]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-20 15:30:42,880
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##c8f3880eb0f3471198576d8a15670960] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##c8f3880eb0f3471198576d8a15670960 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##ef610e7f97fc4f81902dfe2614562afc] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 15:30:42,999
  线程ID: 49
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##c8f3880eb0f3471198576d8a15670960]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-20 15:30:43,730
  线程ID: 104
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##ada5b37f3cdc4975acfa00a18ed745c3] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##ada5b37f3cdc4975acfa00a18ed745c3 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##e4d405b08ff64ddb938430f33ff82093] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 15:30:43,851
  线程ID: 104
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##ada5b37f3cdc4975acfa00a18ed745c3]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-20 15:30:44,581
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##023aa9c529994c21934aa1e8742bcced] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-20 15:30:44,584
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##023aa9c529994c21934aa1e8742bcced] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##023aa9c529994c21934aa1e8742bcced WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##dbe230804dc04afa841cf8ee298183e9] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 15:30:44,707
  线程ID: 16
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##023aa9c529994c21934aa1e8742bcced]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-20 15:30:45,427
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##cb3b015fdd41448582f327a29fe02bea] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##cb3b015fdd41448582f327a29fe02bea WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##6d8bb06fa94c440fbd32e8ee4642ce06] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 15:30:45,554
  线程ID: 88
日志级别: 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.[3c247f0a-707b-470d-827f-d994e6a76bb9]
 FROM [##cb3b015fdd41448582f327a29fe02bea]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-20 15:42:16,256
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##aa90d76ba9e446d2a2516a4fd217d192] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-20 15:42:16,260
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##aa90d76ba9e446d2a2516a4fd217d192] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##aa90d76ba9e446d2a2516a4fd217d192 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##db7fa8a68fcd44cc8c8119d4cb2ba5f1] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 15:42:16,363
  线程ID: 35
日志级别: 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.[c780385d-d59a-4154-af63-42afcb27fadf]
 FROM [##aa90d76ba9e446d2a2516a4fd217d192]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


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


    时间: 2021-01-20 18:48:27,367
  线程ID: 62
日志级别: 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.[c780385d-d59a-4154-af63-42afcb27fadf]
 FROM [##f883ef5d540442ca9a4566c6f6153d0f]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-20 18:50:56,231
  线程ID: 59
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##fa4a988dd8e04342ab05d01bde2e53ae] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##fa4a988dd8e04342ab05d01bde2e53ae WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##35911e552bfd4e168afd4d5c8926863d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-20 18:50:56,339
  线程ID: 59
日志级别: 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.[c780385d-d59a-4154-af63-42afcb27fadf]
 FROM [##fa4a988dd8e04342ab05d01bde2e53ae]
 ORDER BY PdStock_Date DESC, PdStockID ASC