时间: 2020-12-18 15:28:42,432
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##1be2a31db9c648328399db6ca4819be3] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2020-12-18 15:28:42,445
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##1be2a31db9c648328399db6ca4819be3] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##1be2a31db9c648328399db6ca4819be3 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##d1350d66f0c24598b130ee8e0a093300] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2020-12-18 15:28:42,531
  线程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.[3989746e-e8e1-4bc3-8bc3-49b43a3831cf]
 FROM [##1be2a31db9c648328399db6ca4819be3]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2020-12-18 15:28:52,888
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##01c217427eb6443cba7c1583bddbd1e4] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##01c217427eb6443cba7c1583bddbd1e4 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##dec73e5da498454f96b8d7c478be09f1] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2020-12-18 15:28:52,994
  线程ID: 24
日志级别: 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 [##01c217427eb6443cba7c1583bddbd1e4]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2020-12-18 15:29:43,838
  线程ID: 100
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##80c92247f558442297b6834f882ab202] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2020-12-18 15:29:43,842
  线程ID: 100
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##80c92247f558442297b6834f882ab202] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##80c92247f558442297b6834f882ab202 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##636cbb33fcf24cab955fc925d85bf307] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2020-12-18 15:29:43,928
  线程ID: 100
日志级别: 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 [##80c92247f558442297b6834f882ab202]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2020-12-18 15:30:53,844
  线程ID: 100
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##a7f8cf165a344067a2d4aa505e98ddf4] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##a7f8cf165a344067a2d4aa505e98ddf4 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##d7b0eb409d3643ea9cdcfcaa51e1ad60] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2020-12-18 15:30:53,953
  线程ID: 100
日志级别: 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 [##a7f8cf165a344067a2d4aa505e98ddf4]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2020-12-18 15:31:11,859
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##469bf540776f4a528c6bb6464d2c6248] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2020-12-18 15:31:11,862
  线程ID: 98
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##469bf540776f4a528c6bb6464d2c6248] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##469bf540776f4a528c6bb6464d2c6248 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##72df363f06d34b60ad149a0681d8c80d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2020-12-18 15:31:11,947
  线程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.[3989746e-e8e1-4bc3-8bc3-49b43a3831cf]
 FROM [##469bf540776f4a528c6bb6464d2c6248]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2020-12-18 15:38:08,091
  线程ID: 96
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##7d6d3f7b9e6a412ca77b688fbd99a3c9] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##7d6d3f7b9e6a412ca77b688fbd99a3c9 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##9599b84e8dfd4a4a8db6c9e77c041246] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2020-12-18 15:38:08,198
  线程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.[cbcac7b8-1f75-473c-9121-df983fcfc616]
 FROM [##7d6d3f7b9e6a412ca77b688fbd99a3c9]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2020-12-18 15:38:27,650
  线程ID: 96
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##3269a2428618401a9b3a4f146cd15f73] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2020-12-18 15:38:27,654
  线程ID: 96
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##3269a2428618401a9b3a4f146cd15f73] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##3269a2428618401a9b3a4f146cd15f73 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##fcdc0d82aabd44fba6657c988dbafd9d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2020-12-18 15:38:27,773
  线程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.[b4f212b2-5831-4f17-aae5-ac3c8f16b8a0]
 FROM [##3269a2428618401a9b3a4f146cd15f73]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2020-12-18 15:38:35,667
  线程ID: 94
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##a43125d85ba240a9a3849a0c1a3d5381] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2020-12-18 15:38:35,670
  线程ID: 94
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##a43125d85ba240a9a3849a0c1a3d5381] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##a43125d85ba240a9a3849a0c1a3d5381 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##1fd0ab73701f4e89883bff184a06b74b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2020-12-18 15:38:35,763
  线程ID: 94
日志级别: 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.[cbcac7b8-1f75-473c-9121-df983fcfc616]
 FROM [##a43125d85ba240a9a3849a0c1a3d5381]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2020-12-18 15:42:32,967
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CONVERT(VARCHAR(10), A.PdStock_Date, 120) AS [单据日期], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], A.Long AS [内长], SUM(A.Quantity) AS [数量], GS.UnitPrice AS [吊牌价]
INTO tempdb.dbo.[1ceb84d5-2c85-4ecd-82a3-3347aca2fba3]
FROM ##11aa09fa44da48e9bae881850e9b803d A 
      LEFT  JOIN Customer CT ON A.Customer_ID = CT.Customer_ID
      LEFT  JOIN Goods GS ON A.Goods_No = GS.Goods_No
      LEFT  JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID
      LEFT  JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, A.Long, GS.UnitPrice

ORDER BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, A.Long, GS.UnitPrice


    时间: 2020-12-18 15:45:34,740
  线程ID: 24
日志级别: 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 ##75d5e8bf19724f908299b960e787c6f5 FROM WarehouseData 

    时间: 2020-12-18 15:45:34,774
  线程ID: 24
日志级别: 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.[7b38f203-f5d8-43b4-84db-995783a556d0]
 FROM [##48fbb0ecef6248a4890bf24b1cb000cf]
 ORDER BY Warehouse_No


    时间: 2020-12-18 15:46:09,042
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##c504c240b3634d568603cc996f34dfe7] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2020-12-18 15:46:09,046
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##c504c240b3634d568603cc996f34dfe7] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##c504c240b3634d568603cc996f34dfe7 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##c9683aa38cae444198c2cbe5e9259ed9] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2020-12-18 15:46:09,155
  线程ID: 24
日志级别: 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.[4ea8a718-fabf-4168-91e9-a69aaf5cf3a6]
 FROM [##c504c240b3634d568603cc996f34dfe7]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2020-12-18 15:46:11,175
  线程ID: 96
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##7fb78db035364a7daf02d736fa4e9061] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2020-12-18 15:46:11,183
  线程ID: 96
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##7fb78db035364a7daf02d736fa4e9061] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##7fb78db035364a7daf02d736fa4e9061 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##13ef3d17b64e4515a2dd1b8500106b53] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2020-12-18 15:46:11,280
  线程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.[cbcac7b8-1f75-473c-9121-df983fcfc616]
 FROM [##7fb78db035364a7daf02d736fa4e9061]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2020-12-18 15:47:13,423
  线程ID: 95
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##eb23686bcf664b88898e4577b479a9fe] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2020-12-18 15:47:13,427
  线程ID: 95
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##eb23686bcf664b88898e4577b479a9fe] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##eb23686bcf664b88898e4577b479a9fe WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##6c6f03e7188746eeb16fde90bc14ff03] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2020-12-18 15:47:13,533
  线程ID: 95
日志级别: 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.[bd771789-a734-4b41-8f78-3b9eab67f106]
 FROM [##eb23686bcf664b88898e4577b479a9fe]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2020-12-18 16:35:29,282
  线程ID: 91
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CT.Abbrev AS [渠道简称], GS.Category AS [类别], GS.Range AS [系列], CONVERT(VARCHAR(20), A.Input_Date, 120) AS [录入日期], A.Goods_no AS [货号], GS.UnitPrice AS [吊牌价], SUM(A.Quantity) AS [数量]
INTO tempdb.dbo.[fea3cde7-a2a0-4f53-89b1-785fc66f3e30]
FROM ##118c7942f827477bbd749573651e20cc A 
      LEFT  JOIN Customer CT ON A.Customer_ID = CT.Customer_ID
      LEFT  JOIN Goods GS ON A.Goods_No = GS.Goods_No
      LEFT  JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID
      LEFT  JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  CT.Abbrev, GS.Category, GS.Range, CONVERT(VARCHAR(20), A.Input_Date, 120), A.Goods_no, GS.UnitPrice

ORDER BY  CT.Abbrev, GS.Category, GS.Range, CONVERT(VARCHAR(20), A.Input_Date, 120), A.Goods_no, GS.UnitPrice


    时间: 2020-12-18 18:21:10,230
  线程ID: 43
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[f422b600-0379-46b0-8acd-71243e59b510]
FROM [##7e122f7edaf44278944f99322ca84af6]
ORDER BY Goods_no