时间: 2021-01-24 09:52:20,515
  线程ID: 79
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##b71c59fc711d42a69b2aebcea5e98898] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CBalance' AND A.BalanceID = BillNo )


    时间: 2021-01-24 09:52:20,530
  线程ID: 79
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##b71c59fc711d42a69b2aebcea5e98898] 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 ##b71c59fc711d42a69b2aebcea5e98898 WHERE A.BalanceID = BalanceID )
        GROUP BY A.BalanceID
    ) B ON A.BalanceID = B.BalanceID


    时间: 2021-01-24 09:52:20,575
  线程ID: 79
日志级别: 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.[ab69b94f-bbdb-4ea1-91fe-432d882f2519]
 FROM [##b71c59fc711d42a69b2aebcea5e98898]
 ORDER BY Balance_Date DESC, BalanceID ASC


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


    时间: 2021-01-24 09:54:01,788
  线程ID: 86
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##cab532030f6349de82e7f7d823ff727c] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##cab532030f6349de82e7f7d823ff727c WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##6119d33d615a4cec88b87d6fb16475de] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-24 09:54:01,879
  线程ID: 86
日志级别: 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 [##cab532030f6349de82e7f7d823ff727c]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-24 10:02:25,289
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##2a689effe7354aa9b3ecfa37990ba70e] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CBalance' AND A.BalanceID = BillNo )


    时间: 2021-01-24 10:02:25,292
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##2a689effe7354aa9b3ecfa37990ba70e] 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 ##2a689effe7354aa9b3ecfa37990ba70e WHERE A.BalanceID = BalanceID )
        GROUP BY A.BalanceID
    ) B ON A.BalanceID = B.BalanceID


    时间: 2021-01-24 10:02:25,338
  线程ID: 84
日志级别: 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.[e49b9ef6-ef54-4e00-bc2d-e4a1b4473f4e]
 FROM [##2a689effe7354aa9b3ecfa37990ba70e]
 ORDER BY Balance_Date DESC, BalanceID ASC


    时间: 2021-01-24 10:03:50,400
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##be2df51137af45399b2d6abf5fe2a1fc] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CBalance' AND A.BalanceID = BillNo )


    时间: 2021-01-24 10:03:50,403
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##be2df51137af45399b2d6abf5fe2a1fc] 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 ##be2df51137af45399b2d6abf5fe2a1fc WHERE A.BalanceID = BalanceID )
     AND EXISTS (SELECT 1 FROM [##c4c78d5e18704af4b1b932930043eb86] WHERE Goods_No = A.Goods_No)
        GROUP BY A.BalanceID
    ) B ON A.BalanceID = B.BalanceID


    时间: 2021-01-24 10:03:50,606
  线程ID: 65
日志级别: 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.[dcd21f1b-eb2a-4e28-9fe2-4bab29552264]
 FROM [##be2df51137af45399b2d6abf5fe2a1fc]
 ORDER BY Balance_Date DESC, BalanceID ASC


    时间: 2021-01-24 10:03:50,855
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##21603c600dbe424f99a01491f5d66a89] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CBalance' AND A.BalanceID = BillNo )


    时间: 2021-01-24 10:03:50,858
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##21603c600dbe424f99a01491f5d66a89] 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 ##21603c600dbe424f99a01491f5d66a89 WHERE A.BalanceID = BalanceID )
     AND EXISTS (SELECT 1 FROM [##320ed991a1ec4b889cfa76a9a58722a9] WHERE Goods_No = A.Goods_No)
        GROUP BY A.BalanceID
    ) B ON A.BalanceID = B.BalanceID


    时间: 2021-01-24 10:03:51,065
  线程ID: 60
日志级别: 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.[5078ee1e-4892-47e5-8192-06bd128e23f1]
 FROM [##21603c600dbe424f99a01491f5d66a89]
 ORDER BY Balance_Date DESC, BalanceID ASC


    时间: 2021-01-24 10:04:17,445
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##605bace058a0438aa28c7da892579c16] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CBalance' AND A.BalanceID = BillNo )


    时间: 2021-01-24 10:04:17,448
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##605bace058a0438aa28c7da892579c16] 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 ##605bace058a0438aa28c7da892579c16 WHERE A.BalanceID = BalanceID )
     AND EXISTS (SELECT 1 FROM [##17e41f043c8b4db3b855eedd86f72317] WHERE Goods_No = A.Goods_No)
        GROUP BY A.BalanceID
    ) B ON A.BalanceID = B.BalanceID


    时间: 2021-01-24 10:04:17,732
  线程ID: 61
日志级别: 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.[e49b9ef6-ef54-4e00-bc2d-e4a1b4473f4e]
 FROM [##605bace058a0438aa28c7da892579c16]
 ORDER BY Balance_Date DESC, BalanceID ASC


    时间: 2021-01-24 10:06:29,059
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##2ab98c0823db43c095c840890679bdc1] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-24 10:06:29,062
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##2ab98c0823db43c095c840890679bdc1] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##2ab98c0823db43c095c840890679bdc1 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##05998dedf519478082ba00aa7b75ee4b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-24 10:06:29,164
  线程ID: 65
日志级别: 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 [##2ab98c0823db43c095c840890679bdc1]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-24 10:09:26,172
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##c317ce1328b6453aa89f30edc5e2b0cb] 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 ##c317ce1328b6453aa89f30edc5e2b0cb WHERE A.BalanceID = BalanceID )
     AND EXISTS (SELECT 1 FROM [##3ff69d9d8a5244d6ba37ccfdaafc7192] WHERE Goods_No = A.Goods_No)
        GROUP BY A.BalanceID
    ) B ON A.BalanceID = B.BalanceID


    时间: 2021-01-24 10:09:26,388
  线程ID: 84
日志级别: 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.[add32f79-8eba-4ffa-9bc7-3a9759bca158]
 FROM [##c317ce1328b6453aa89f30edc5e2b0cb]
 ORDER BY Balance_Date DESC, BalanceID ASC


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


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


    时间: 2021-01-24 10:09:26,856
  线程ID: 59
日志级别: 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.[1e164a9f-8425-4e67-92b7-98fae551f7f2]
 FROM [##faed0af56a7245739b7c0ebaa65f5ea0]
 ORDER BY Balance_Date DESC, BalanceID ASC


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


    时间: 2021-01-24 10:09:57,260
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##e7081b304d694991ae4e75311ba357e2] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##e7081b304d694991ae4e75311ba357e2 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##88c5ef9ecd59434a98197c14297c739d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-24 10:09:57,361
  线程ID: 52
日志级别: 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 [##e7081b304d694991ae4e75311ba357e2]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-24 10:10:47,410
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##71f796d45702462fb02d467c7080be9c] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##71f796d45702462fb02d467c7080be9c WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##08720ad8ca58449f84879592d34aa5a7] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-24 10:10:47,512
  线程ID: 61
日志级别: 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 [##71f796d45702462fb02d467c7080be9c]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-24 10:10:51,242
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##2c7b218f1aa34866a33a8f137a2c73fa] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##2c7b218f1aa34866a33a8f137a2c73fa WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##5f99933a39544407bd4cffa9a416faa0] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-24 10:10:51,343
  线程ID: 52
日志级别: 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 [##2c7b218f1aa34866a33a8f137a2c73fa]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-24 10:12:34,486
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##5faa7194be534d9e8c2bceb590a15c22] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CBalance' AND A.BalanceID = BillNo )


    时间: 2021-01-24 10:12:34,489
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##5faa7194be534d9e8c2bceb590a15c22] 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 ##5faa7194be534d9e8c2bceb590a15c22 WHERE A.BalanceID = BalanceID )
     AND EXISTS (SELECT 1 FROM [##b9b49c50b3da4efc93be33b777362819] WHERE Goods_No = A.Goods_No)
        GROUP BY A.BalanceID
    ) B ON A.BalanceID = B.BalanceID


    时间: 2021-01-24 10:12:34,704
  线程ID: 84
日志级别: 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.[e49b9ef6-ef54-4e00-bc2d-e4a1b4473f4e]
 FROM [##5faa7194be534d9e8c2bceb590a15c22]
 ORDER BY Balance_Date DESC, BalanceID ASC


    时间: 2021-01-24 10:14:55,906
  线程ID: 59
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:      UPDATE A SET SaleType='线上发货'
     FROM [##9ed8d48347d14e99af8a203edc5828b7] A 
     WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') 
     AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' 
UPDATE [##9ed8d48347d14e99af8a203edc5828b7]  SET SaleType='正常销售' 
WHERE SaleType='正常' OR SaleType IS NULL OR SaleType = '' 
DELETE FROM [##9ed8d48347d14e99af8a203edc5828b7] WHERE 1=1
AND NOT EXISTS(SELECT 1 FROM ##f26075a2f2fb4da7bd49d4cc529fdf88 B WHERE B.data = SaleType)


    时间: 2021-01-24 10:14:55,913
  线程ID: 59
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE [##9ed8d48347d14e99af8a203edc5828b7] DROP COLUMN SaleType, OnlineSaleTypeID, RetailOrderID

    时间: 2021-01-24 10:14:55,914
  线程ID: 59
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##9ed8d48347d14e99af8a203edc5828b7] A
 WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'ShopCheck2' AND A.CheckID = BillNo ) 


    时间: 2021-01-24 10:14:55,918
  线程ID: 59
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##9ed8d48347d14e99af8a203edc5828b7] 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 ##9ed8d48347d14e99af8a203edc5828b7 WHERE A.CheckID = CheckID )
     AND EXISTS (SELECT 1 FROM [##95710bac26cd4b2d88aedd9cb1c4f0bd] WHERE Goods_No = A.Goods_No)
        GROUP BY A.CheckID
    ) B ON A.CheckID = B.CheckID


    时间: 2021-01-24 10:14:55,957
  线程ID: 59
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT DISTINCT * INTO [##7116baaacf2f43f695a49fdbbe441ee0] FROM [##9ed8d48347d14e99af8a203edc5828b7]

    时间: 2021-01-24 10:14:55,971
  线程ID: 59
日志级别: 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 [##7116baaacf2f43f695a49fdbbe441ee0]
 ORDER BY CheckDate DESC, CheckID ASC


    时间: 2021-01-24 10:16:47,963
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(CT.Company_ID AS VARCHAR(50)) AS Company_ID, A.Customer_ID, B.Goods_No, C.ColorID, CAST('' AS VARCHAR(50)) AS Long
    , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量
    , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量
    , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量
INTO [##549f8404132744699b41bf39307ee123]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-01-24 10:16:48,278
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##549f8404132744699b41bf39307ee123] (Company_ID, Customer_ID, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT CT.Company_ID, A.Customer_ID, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##e36ddc147f9b4d388526385826cb1ffc] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID