时间: 2022-06-23 12:33:20,095 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##11039f2130e94db9af17ae79002ac2b5] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2022-06-23 12:33:20,115 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##11039f2130e94db9af17ae79002ac2b5] 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 ##11039f2130e94db9af17ae79002ac2b5 WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##8e3e83c1c73a4b3fb2b37ab2bdd572f5] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2022-06-23 12:33:20,343 线程ID: 88 日志级别: 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.[839000f5-8f0e-46c1-9cd9-b9bf7a1ee87e] FROM [##11039f2130e94db9af17ae79002ac2b5] ORDER BY Balance_Date DESC, BalanceID ASC