时间: 2021-09-18 13:40:42,279
  线程ID: 75
日志级别: 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.[75f201b1-ce5a-4cb0-90ed-13d415fd6d45]
FROM [##c206c54dbda64d6f8bd059d807ce0637]
ORDER BY Goods_no


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


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


    时间: 2021-09-18 14:29:41,620
  线程ID: 79
日志级别: 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.[86928c69-f535-46d1-ab53-1ecc48f0053f]
 FROM [##a7fb029214294dd9bfc56ce94c024b78]
 ORDER BY PdStock_Date DESC, PdStockID ASC