时间: 2021-01-22 14:25:28,461 线程ID: 19 日志级别: 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 [渠道简称], A.Goods_no AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], SUM([S1]) AS [尺码#S1], SUM(A.Quantity) AS [数量] INTO tempdb.dbo.[cd1a1219-6e91-4f17-8059-8eb4a67b3750] FROM ##b9f320da7cef4e17b42bed581d17a8f9 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, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color ORDER BY CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color 时间: 2021-01-22 14:25:35,226 线程ID: 21 日志级别: 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 [渠道简称], A.Goods_no AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], SUM([S1]) AS [尺码#S1], SUM(A.Quantity) AS [数量] INTO tempdb.dbo.[cd1a1219-6e91-4f17-8059-8eb4a67b3750] FROM ##55b8f95c864c4fffb89d4fa97005d5d8 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, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color ORDER BY CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color 时间: 2021-01-22 14:25:37,984 线程ID: 21 日志级别: 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 [渠道简称], A.Goods_no AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], SUM([S1]) AS [尺码#S1], SUM(A.Quantity) AS [数量] INTO tempdb.dbo.[cd1a1219-6e91-4f17-8059-8eb4a67b3750] FROM ##858caea705084aa2815c28ab1fada808 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, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color ORDER BY CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color 时间: 2021-01-22 14:25:42,910 线程ID: 21 日志级别: 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 [渠道简称], A.Goods_no AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], SUM([S1]) AS [尺码#S1], SUM(A.Quantity) AS [数量] INTO tempdb.dbo.[cd1a1219-6e91-4f17-8059-8eb4a67b3750] FROM ##618e32d33eda4d9b8372e37d2cfd5b8f 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, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color ORDER BY CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color 时间: 2021-01-22 14:25:46,518 线程ID: 24 日志级别: 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 [渠道简称], A.Goods_no AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], SUM([S1]) AS [尺码#S1], SUM(A.Quantity) AS [数量] INTO tempdb.dbo.[cd1a1219-6e91-4f17-8059-8eb4a67b3750] FROM ##271ea42bf9a64814922486000c91ae42 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, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color ORDER BY CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color 时间: 2021-01-22 14:27:31,482 线程ID: 5 日志级别: 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 [渠道简称], A.Goods_no AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], SUM([S1]) AS [尺码#S1], SUM(A.Quantity) AS [数量], A.PdStockID AS [单号] INTO tempdb.dbo.[cd1a1219-6e91-4f17-8059-8eb4a67b3750] FROM ##495392a1715448c49452eed19fc2e385 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, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color, A.PdStockID ORDER BY CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color, A.PdStockID 时间: 2021-01-22 14:27:40,469 线程ID: 19 日志级别: 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 [渠道简称], A.Goods_no AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], SUM([S1]) AS [尺码#S1], SUM(A.Quantity) AS [数量] INTO tempdb.dbo.[cd1a1219-6e91-4f17-8059-8eb4a67b3750] FROM ##9afbde19162142808a918e2a074797fc 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, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color ORDER BY CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color 时间: 2021-01-22 14:28:05,322 线程ID: 19 日志级别: 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.Category AS [类别], A.Goods_no AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], SUM([S1]) AS [尺码#S1], SUM(A.Quantity) AS [数量] INTO tempdb.dbo.[cd1a1219-6e91-4f17-8059-8eb4a67b3750] FROM ##4f2ca1134d144a57bc67b32a70dbce69 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.Category, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color ORDER BY CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Category, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color 时间: 2021-01-22 14:28:24,243 线程ID: 7 日志级别: 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.Range AS [系列], A.Goods_no AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], SUM([S1]) AS [尺码#S1], SUM(A.Quantity) AS [数量] INTO tempdb.dbo.[cd1a1219-6e91-4f17-8059-8eb4a67b3750] FROM ##23d276d9113546bcbb621a15a581fca5 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.Range, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color ORDER BY CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Range, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color 时间: 2021-01-22 17:43:31,159 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##0dd6b8caea1549e68c856a70f99ee8f9] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-22 17:43:31,163 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##0dd6b8caea1549e68c856a70f99ee8f9] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##0dd6b8caea1549e68c856a70f99ee8f9 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##b916254ec65845708eb303e88b0270f0] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-22 17:43:31,268 线程ID: 114 日志级别: 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.[bad9a2eb-92b6-418c-8b4a-2eb15010a821] FROM [##0dd6b8caea1549e68c856a70f99ee8f9] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-22 17:46:59,501 线程ID: 120 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##95ed13258d7c43aeb175afc43c474ec0] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-22 17:46:59,506 线程ID: 120 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##95ed13258d7c43aeb175afc43c474ec0] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##95ed13258d7c43aeb175afc43c474ec0 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##90d6f8ab688041229a2bd0eaa3c23503] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-22 17:46:59,615 线程ID: 120 日志级别: 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.[5f142c30-e424-4762-b5c0-4e0adc7513d1] FROM [##95ed13258d7c43aeb175afc43c474ec0] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-22 17:48:32,247 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##a437a97413104b7898163a62f7124f6a] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-22 17:48:32,252 线程ID: 95 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##a437a97413104b7898163a62f7124f6a] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##a437a97413104b7898163a62f7124f6a WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##2e0efcb904854ab3a72e87f69e64264e] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-22 17:48:32,358 线程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.[841efe8b-524e-42c6-88ec-b49aa734f561] FROM [##a437a97413104b7898163a62f7124f6a] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-22 17:49:59,284 线程ID: 120 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##90cb9e15e92647aabd172b9cb5fcea33] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-22 17:49:59,288 线程ID: 120 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##90cb9e15e92647aabd172b9cb5fcea33] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##90cb9e15e92647aabd172b9cb5fcea33 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##a4d51729b8654caa966a218000d607b3] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-22 17:49:59,371 线程ID: 120 日志级别: 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.[5f142c30-e424-4762-b5c0-4e0adc7513d1] FROM [##90cb9e15e92647aabd172b9cb5fcea33] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-22 17:59:02,852 线程ID: 115 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##d015977da74f4def9cef4bb2f41b53ae] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-22 17:59:02,857 线程ID: 115 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##d015977da74f4def9cef4bb2f41b53ae] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##d015977da74f4def9cef4bb2f41b53ae WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##89baf766b5814f9cb4f4c0629dad4ad0] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-22 17:59:02,952 线程ID: 115 日志级别: 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.[5f142c30-e424-4762-b5c0-4e0adc7513d1] FROM [##d015977da74f4def9cef4bb2f41b53ae] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-22 18:02:19,802 线程ID: 117 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##cf09471e686e48e389119b8d77505d12] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-22 18:02:19,806 线程ID: 117 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##cf09471e686e48e389119b8d77505d12] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##cf09471e686e48e389119b8d77505d12 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##24cb5a105cc44a0486760720bd7a4fa5] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-22 18:02:19,932 线程ID: 117 日志级别: 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.[841efe8b-524e-42c6-88ec-b49aa734f561] FROM [##cf09471e686e48e389119b8d77505d12] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-22 18:19:24,487 线程ID: 122 日志级别: 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.[4cfdce05-5319-4568-80ac-983ca3b957b0] FROM [##8a961fe7ba064c32962fb531376b16af] ORDER BY Goods_no 时间: 2021-01-22 18:23:34,976 线程ID: 22 日志级别: 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.[d14d1219-d119-4831-9f74-a2920775ef2d] FROM [##ebfa71c8bfaf4f87a66fc6c93a0661f0] ORDER BY Goods_no 时间: 2021-01-22 22:09:00,663 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##f0f337cf8cd64ff5a7e8bdb67aed8f2c] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-22 22:09:00,665 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##f0f337cf8cd64ff5a7e8bdb67aed8f2c] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##f0f337cf8cd64ff5a7e8bdb67aed8f2c WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##cfc4d01f0e5842a98465ce5b4adb5e85] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-22 22:09:00,749 线程ID: 14 日志级别: 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.[5f142c30-e424-4762-b5c0-4e0adc7513d1] FROM [##f0f337cf8cd64ff5a7e8bdb67aed8f2c] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-22 22:09:06,825 线程ID: 91 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##0bb7c5bd19064d4c8ced6e2cdd47c129] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-22 22:09:06,830 线程ID: 91 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##0bb7c5bd19064d4c8ced6e2cdd47c129] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##0bb7c5bd19064d4c8ced6e2cdd47c129 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##13e0a6019a2e4d14bebcadb614cb0e13] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-22 22:09:06,940 线程ID: 91 日志级别: 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.[5f142c30-e424-4762-b5c0-4e0adc7513d1] FROM [##0bb7c5bd19064d4c8ced6e2cdd47c129] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-22 22:09:17,685 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##8b117c5ece61427589ee49c10d7ffc68] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-22 22:09:17,687 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##8b117c5ece61427589ee49c10d7ffc68] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##8b117c5ece61427589ee49c10d7ffc68 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##d202a6052ac94bcebefbe83b70a7e7a8] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-22 22:09:17,780 线程ID: 119 日志级别: 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.[5f142c30-e424-4762-b5c0-4e0adc7513d1] FROM [##8b117c5ece61427589ee49c10d7ffc68] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-22 22:10:23,215 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##735ebe4df7bb4013a34dfcacd52998ed] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-22 22:10:23,219 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##735ebe4df7bb4013a34dfcacd52998ed] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##735ebe4df7bb4013a34dfcacd52998ed WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##56f800f8d15343db9231f509e90102cd] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-22 22:10:23,310 线程ID: 119 日志级别: 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.[5f142c30-e424-4762-b5c0-4e0adc7513d1] FROM [##735ebe4df7bb4013a34dfcacd52998ed] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-22 22:10:34,273 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##2ef8d3f1110949998d773c325360c009] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-22 22:10:34,273 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##2ef8d3f1110949998d773c325360c009] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##2ef8d3f1110949998d773c325360c009 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##907adc19619b413baa9692c95abb7f59] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-22 22:10:34,368 线程ID: 119 日志级别: 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.[5f142c30-e424-4762-b5c0-4e0adc7513d1] FROM [##2ef8d3f1110949998d773c325360c009] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-22 22:10:47,405 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##c621c1441aff4d93b5ac465dfc6dfc1c] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-22 22:10:47,408 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##c621c1441aff4d93b5ac465dfc6dfc1c] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##c621c1441aff4d93b5ac465dfc6dfc1c WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##a1eb5496dd3345f68774b9008733e563] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-22 22:10:47,499 线程ID: 14 日志级别: 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.[5f142c30-e424-4762-b5c0-4e0adc7513d1] FROM [##c621c1441aff4d93b5ac465dfc6dfc1c] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-22 22:11:15,384 线程ID: 90 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##ea89e28e72214306941ecbc75d70856c] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-22 22:11:15,388 线程ID: 90 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##ea89e28e72214306941ecbc75d70856c] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##ea89e28e72214306941ecbc75d70856c WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##56fa9b1a6cba44cba5dbfaa305a7a8db] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-22 22:11:15,478 线程ID: 90 日志级别: 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.[5f142c30-e424-4762-b5c0-4e0adc7513d1] FROM [##ea89e28e72214306941ecbc75d70856c] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-22 22:11:24,785 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##476e06f020464166aa1023fbffd90800] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-22 22:11:24,789 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##476e06f020464166aa1023fbffd90800] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##476e06f020464166aa1023fbffd90800 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##dfb7b512535b4159a50019a72d22ab12] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-22 22:11:24,889 线程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.[5f142c30-e424-4762-b5c0-4e0adc7513d1] FROM [##476e06f020464166aa1023fbffd90800] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-22 22:11:36,420 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##9b09752550194d37bf01ae128e9d25a3] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-22 22:11:36,423 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##9b09752550194d37bf01ae128e9d25a3] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##9b09752550194d37bf01ae128e9d25a3 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##e70d4c3cde5446f8bfd4ad53ac8623c5] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-22 22:11:36,517 线程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.[5f142c30-e424-4762-b5c0-4e0adc7513d1] FROM [##9b09752550194d37bf01ae128e9d25a3] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-22 22:11:41,132 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##7642fbe78ac34588b5176bf5171c66c1] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-22 22:11:41,136 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##7642fbe78ac34588b5176bf5171c66c1] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##7642fbe78ac34588b5176bf5171c66c1 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##dae043c5dd3d41ff8ab13a7dacd0fae1] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-22 22:11:41,229 线程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.[5f142c30-e424-4762-b5c0-4e0adc7513d1] FROM [##7642fbe78ac34588b5176bf5171c66c1] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-22 22:11:41,930 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##4ab9c5ce2fae4d29ba32e68fedd238b9] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-22 22:11:41,934 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##4ab9c5ce2fae4d29ba32e68fedd238b9] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##4ab9c5ce2fae4d29ba32e68fedd238b9 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##77a858c9e055435c9fed41a47b712a99] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-22 22:11:42,024 线程ID: 14 日志级别: 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.[5f142c30-e424-4762-b5c0-4e0adc7513d1] FROM [##4ab9c5ce2fae4d29ba32e68fedd238b9] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-22 22:14:18,051 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##7840d26a2122464195944290e43be136] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2021-01-22 22:14:18,056 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##7840d26a2122464195944290e43be136] 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 ##7840d26a2122464195944290e43be136 WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##425bb86504ce44d193bd57d2d00591ce] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2021-01-22 22:14:18,343 线程ID: 119 日志级别: 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.[896b0d53-1cdf-47f0-91e6-3e9382a6b437] FROM [##7840d26a2122464195944290e43be136] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2021-01-22 22:14:58,995 线程ID: 90 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##34e262804888416280e167f3ef5d55a7] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2021-01-22 22:14:58,998 线程ID: 90 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##34e262804888416280e167f3ef5d55a7] 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 ##34e262804888416280e167f3ef5d55a7 WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##a89335f9b0054dfea954af1a883a8fb7] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2021-01-22 22:14:59,200 线程ID: 90 日志级别: 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.[896b0d53-1cdf-47f0-91e6-3e9382a6b437] FROM [##34e262804888416280e167f3ef5d55a7] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2021-01-22 22:15:08,556 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##eeb8b8bcf8744baea90cfcbbb86767aa] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2021-01-22 22:15:08,559 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##eeb8b8bcf8744baea90cfcbbb86767aa] 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 ##eeb8b8bcf8744baea90cfcbbb86767aa WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##22a199b7336f4100ad5a53e1403c6491] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2021-01-22 22:15:08,762 线程ID: 119 日志级别: 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.[896b0d53-1cdf-47f0-91e6-3e9382a6b437] FROM [##eeb8b8bcf8744baea90cfcbbb86767aa] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2021-01-22 22:15:16,728 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##5a886cc47ee64107a9cd282dd89e4d10] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2021-01-22 22:15:16,731 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##5a886cc47ee64107a9cd282dd89e4d10] 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 ##5a886cc47ee64107a9cd282dd89e4d10 WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##d38f36cf2c9944689ff13d27cac89ab3] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2021-01-22 22:15:16,983 线程ID: 119 日志级别: 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.[896b0d53-1cdf-47f0-91e6-3e9382a6b437] FROM [##5a886cc47ee64107a9cd282dd89e4d10] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2021-01-22 22:16:10,204 线程ID: 90 日志级别: 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 [##a4cba87c217e49e8ab6f0fee9c71b040] FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT 时间: 2021-01-22 22:16:10,456 线程ID: 90 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4cba87c217e49e8ab6f0fee9c71b040] (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 [##340ddb6f3b404e419eef8a1c63163057] A INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID 时间: 2021-01-22 22:17:56,925 线程ID: 90 日志级别: 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 [##15036aa99c424eee80cd8ceaa8c12b08] FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT 时间: 2021-01-22 22:17:57,230 线程ID: 90 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##15036aa99c424eee80cd8ceaa8c12b08] (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 [##e33baa0faf804e84b79597e01de3737a] A INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID 时间: 2021-01-22 22:18:50,755 线程ID: 66 日志级别: 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 [##bf6d88a81019426bbf0387248288c4a0] FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT 时间: 2021-01-22 22:18:51,049 线程ID: 66 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bf6d88a81019426bbf0387248288c4a0] (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 [##bdb15a53aec142d3a87a3154cf7b1ac7] A INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID 时间: 2021-01-22 22:20:39,936 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##647f23365dbc496ca2f117353ee446bb] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2021-01-22 22:20:39,939 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##647f23365dbc496ca2f117353ee446bb] 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 ##647f23365dbc496ca2f117353ee446bb WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##bc958b4654d84f709e77b91ffd74646b] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2021-01-22 22:20:40,224 线程ID: 42 日志级别: 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.[896b0d53-1cdf-47f0-91e6-3e9382a6b437] FROM [##647f23365dbc496ca2f117353ee446bb] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2021-01-22 22:22:01,696 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##b9051e030e63427e91b023a39b1f9d9d] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2021-01-22 22:22:01,699 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##b9051e030e63427e91b023a39b1f9d9d] 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 ##b9051e030e63427e91b023a39b1f9d9d WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##ece66bbf68d74b269d2d09255e2e8f63] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2021-01-22 22:22:02,008 线程ID: 89 日志级别: 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.[01b4ce21-09bd-4f3c-a4d2-babf5f47bfea] FROM [##b9051e030e63427e91b023a39b1f9d9d] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2021-01-22 22:23:15,450 线程ID: 66 日志级别: 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 [##224b1ae6641742e193573ae78c2c565f] FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT 时间: 2021-01-22 22:23:15,753 线程ID: 66 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##224b1ae6641742e193573ae78c2c565f] (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 [##8296bfa794fc46e79a13df7f68bf137b] A INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID 时间: 2021-01-22 22:24:18,738 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##1caeaea483e749198af30460611d32a5] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2021-01-22 22:24:18,741 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##1caeaea483e749198af30460611d32a5] 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 ##1caeaea483e749198af30460611d32a5 WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##359659f71e29403887c2fa9fbe71e692] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2021-01-22 22:24:18,954 线程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.[01b4ce21-09bd-4f3c-a4d2-babf5f47bfea] FROM [##1caeaea483e749198af30460611d32a5] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2021-01-22 22:24:56,591 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Tin_Date AS BillDate, A.TinShop AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [入库S1], CAST(NULL AS INT) AS [入库数量], CAST(NULL AS NUMERIC(15, 2)) AS [入库吊牌额] , CAST(C.[S1] AS INT) AS [出库S1], CAST(NULL AS INT) AS [出库数量], CAST(NULL AS NUMERIC(15, 2)) AS [出库吊牌额] , CAST(C.[S1] AS INT) AS [销售S1], CAST(NULL AS INT) AS [销售数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售吊牌额] , CAST(C.[S1] AS INT) AS [损益S1], CAST(NULL AS INT) AS [损益数量], CAST(NULL AS NUMERIC(15, 2)) AS [损益吊牌额] , CAST(C.[S1] AS INT) AS [库存S1], CAST(NULL AS INT) AS [库存数量], CAST(NULL AS NUMERIC(15, 2)) AS [库存吊牌额] INTO [##b51857ea276943b8a1fbbb023ca35e74] FROM ShopTin A, Barcode B, DeliveryDetail C 时间: 2021-01-22 22:24:56,748 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/22', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##b4c94165fffc4ef5ba738f7e6d5eabba] 时间: 2021-01-22 22:24:56,906 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/23', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f339a524244347669788d3a4d636766d] 时间: 2021-01-22 22:24:57,051 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/24', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##337ca14e2a2d4b819a0fa1be82501cef] 时间: 2021-01-22 22:24:57,193 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/25', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##86cb4e789dab4c2289d3efec88160395] 时间: 2021-01-22 22:24:57,338 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/26', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##6ff191e83dd144668113a2f3ecb5729b] 时间: 2021-01-22 22:24:57,480 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/27', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a42a33967e4644dfaea356f3573e7738] 时间: 2021-01-22 22:24:57,623 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/28', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##15e355892510430d8ee03ce27e2199fd] 时间: 2021-01-22 22:24:57,766 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/29', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##674685ac06ad43d18d452130caaacff3] 时间: 2021-01-22 22:24:57,919 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/30', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##9549a7ee8fe743dd9c3f89a9be6aca1c] 时间: 2021-01-22 22:24:58,082 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/31', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##e466c3d51af94af5af7bd4f1f38ae402] 时间: 2021-01-22 22:24:58,226 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/1', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##b0bf3f15a32641888e3502b03c977f3b] 时间: 2021-01-22 22:24:58,367 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/2', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##e3e934b69a1c489199ad461598684e9d] 时间: 2021-01-22 22:24:58,510 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/3', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##9f8f95c547c44baa9102dbd1ab0aebac] 时间: 2021-01-22 22:24:58,658 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/4', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c2dd917bb87244b79db4c103dd61e34a] 时间: 2021-01-22 22:24:58,804 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/5', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##d456710255df43cb98f884cf7f5d8084] 时间: 2021-01-22 22:24:58,977 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/6', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##015778b66b2d4b64849a7e6726347cbf] 时间: 2021-01-22 22:24:59,154 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/7', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c433255472cf469dab1e8ad167569878] 时间: 2021-01-22 22:24:59,304 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/8', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##971e03130cbf4603b34d795ed381f9d3] 时间: 2021-01-22 22:24:59,447 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/9', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##9077129142814024b14be90b8234431b] 时间: 2021-01-22 22:24:59,591 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/10', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##20a898c84b084ba2b9101253a5b57b8a] 时间: 2021-01-22 22:24:59,734 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/11', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##2b28f69ccaa044d19d66b537bdcb4308] 时间: 2021-01-22 22:24:59,883 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/12', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c46d366cc9d740d1ac492cbd298a408d] 时间: 2021-01-22 22:25:00,031 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/13', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##6ea45b1efcb54ed59dc9617b79b4806d] 时间: 2021-01-22 22:25:00,182 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/14', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f7f5946115b34212afc9331b89273fae] 时间: 2021-01-22 22:25:00,326 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/15', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##82b1f1fbe5354e00bb76075d2fa8dbda] 时间: 2021-01-22 22:25:00,474 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/16', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##e491246230244959a02b879f0d6ed8ed] 时间: 2021-01-22 22:25:00,623 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/17', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##497370d2e1f441c1a0a08d3f6dcd52bd] 时间: 2021-01-22 22:25:00,767 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/18', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##00df5d64efae4bca9b750cc258d4f9f2] 时间: 2021-01-22 22:25:00,914 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/19', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##0920a42ac0be47cab2e48226ec62bdd7] 时间: 2021-01-22 22:25:01,057 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/20', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##6c25d4fea9c14113abab919ea2a9b3de] 时间: 2021-01-22 22:25:01,196 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/21', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a9801c7939514d7b96fceb2f3ad248b2] 时间: 2021-01-22 22:25:01,341 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/22', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##7b1cce7e201348b194006f934f91c1c3] 时间: 2021-01-22 22:25:01,345 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Tin_Date AS BillDate, A.TinShop AS Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##d46b99ef07f24ca398d3fda956635ba5] FROM ShopTin A INNER JOIN ShopTinGoods B ON A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted = 1 AND A.Tin_Date >= '2020/12/22' AND A.Tin_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##e74408be64034168ba6f3abe129a4f55] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##83ffce3c557945e1980a8f93dd88878c] WHERE Goods_No = B.Goods_No) GROUP BY A.Tin_Date, A.TinShop, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:25:01,370 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [入库S1], 入库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##d46b99ef07f24ca398d3fda956635ba5] 时间: 2021-01-22 22:25:01,373 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Tout_Date AS BillDate, A.ToutShop AS Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##17fa9619652e4b03a73f679554c44f02] FROM ShopTout A INNER JOIN ShopToutGoods B ON A.ShopToutID = B.ShopToutID INNER JOIN ShopToutDetail C ON B.ShopToutGoodsID = C.ShopToutGoodsID WHERE A.Posted = 1 AND A.Tout_Date >= '2020/12/22' AND A.Tout_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##e74408be64034168ba6f3abe129a4f55] WHERE Customer_ID = A.ToutShop) AND EXISTS (SELECT 1 FROM [##83ffce3c557945e1980a8f93dd88878c] WHERE Goods_No = B.Goods_No) GROUP BY A.Tout_Date, A.ToutShop, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:25:01,398 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [出库S1], 出库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##17fa9619652e4b03a73f679554c44f02] 时间: 2021-01-22 22:25:01,400 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Return_Date AS BillDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##d43f0ddc05764adfb81536c701d4dc64] FROM Dealereturn A INNER JOIN DealereturnGoods B ON A.DealereturnID = B.DealereturnID INNER JOIN DealereturnDetail C ON B.DealereturnGoodsID = C.DealereturnGoodsID WHERE A.Posted = 1 AND A.Return_Date >= '2020/12/22' AND A.Return_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##e74408be64034168ba6f3abe129a4f55] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##83ffce3c557945e1980a8f93dd88878c] WHERE Goods_No = B.Goods_No) GROUP BY A.Return_Date, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:25:01,424 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [出库S1], 出库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##d43f0ddc05764adfb81536c701d4dc64] 时间: 2021-01-22 22:25:01,426 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.CheckDate AS BillDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##e411178e4b6241d1ae4e5a66f10b580c] FROM vn_Check A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID WHERE A.Posted = 1 AND A.CheckDate >= '2020/12/22' AND A.CheckDate <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##e74408be64034168ba6f3abe129a4f55] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##83ffce3c557945e1980a8f93dd88878c] WHERE Goods_No = B.Goods_No) GROUP BY A.CheckDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:25:01,463 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [销售S1], 销售数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##e411178e4b6241d1ae4e5a66f10b580c] 时间: 2021-01-22 22:25:01,465 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Balance_Date AS BillDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##c6c2180681d64c7eaba2523a13cf7a55] FROM Balance A INNER JOIN BalanceGoods B ON A.BalanceID = B.BalanceID INNER JOIN BalanceDetail C ON B.BalanceGoodsID = C.BalanceGoodsID WHERE A.Posted = 1 AND A.Type=2 AND A.Balance_Date >= '2020/12/22' AND A.Balance_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##e74408be64034168ba6f3abe129a4f55] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##83ffce3c557945e1980a8f93dd88878c] WHERE Goods_No = B.Goods_No) GROUP BY A.Balance_Date, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:25:01,509 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b51857ea276943b8a1fbbb023ca35e74] (BillDate, Customer_ID, Goods_No, ColorID, Long, [损益S1], 损益数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c6c2180681d64c7eaba2523a13cf7a55] 时间: 2021-01-22 22:25:01,511 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b51857ea276943b8a1fbbb023ca35e74 SET 入库吊牌额 = 入库数量 * GS.UnitPrice, 出库吊牌额 = 出库数量 * GS.UnitPrice, 销售吊牌额 = 销售数量 * GS.UnitPrice, 损益吊牌额 = 损益数量 * GS.UnitPrice, 库存吊牌额 = 库存数量 * GS.UnitPrice FROM ##b51857ea276943b8a1fbbb023ca35e74 A INNER JOIN Goods GS ON GS.Goods_No=A.Goods_No 时间: 2021-01-22 22:25:01,519 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BillDate, Customer_ID, Goods_No, ColorID, Long , SUM(入库数量) AS 入库数量 , SUM(入库吊牌额) AS 入库吊牌额 , SUM(出库数量) AS 出库数量 , SUM(出库吊牌额) AS 出库吊牌额 , SUM(销售数量) AS 销售数量 , SUM(销售吊牌额) AS 销售吊牌额 , SUM(损益数量) AS 损益数量 , SUM(损益吊牌额) AS 损益吊牌额 , SUM(库存数量) AS 库存数量 , SUM(库存吊牌额) AS 库存吊牌额 INTO ##8313a8b5a61e4a7a9c6ecef23b0e2294 FROM ##b51857ea276943b8a1fbbb023ca35e74 GROUP BY BillDate, Customer_ID, Goods_No, ColorID, Long 时间: 2021-01-22 22:25:01,527 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.BillDate AS [日期], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], GS.UnitPrice AS [吊牌价], CAST(NULL AS IMAGE) AS [图片], [Z004(南山益田店)#入库#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [入库数量] ELSE 0 END) , [Z004(南山益田店)#入库#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [入库吊牌额] ELSE 0 END) , [Z004(南山益田店)#出库#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [出库数量] ELSE 0 END) , [Z004(南山益田店)#出库#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [出库吊牌额] ELSE 0 END) , [Z004(南山益田店)#销售#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [销售数量] ELSE 0 END) , [Z004(南山益田店)#销售#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [销售吊牌额] ELSE 0 END) , [Z004(南山益田店)#损益#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [损益数量] ELSE 0 END) , [Z004(南山益田店)#损益#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [损益吊牌额] ELSE 0 END) , [Z004(南山益田店)#库存#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [库存数量] ELSE 0 END) , [Z004(南山益田店)#库存#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [库存吊牌额] ELSE 0 END) INTO tempdb.dbo.[b886b154-ae01-4e00-b226-b16cb4d4c9eb] FROM [##8313a8b5a61e4a7a9c6ecef23b0e2294] A INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID GROUP BY A.BillDate, A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, GS.UnitPrice ORDER BY A.BillDate, A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, GS.UnitPrice 时间: 2021-01-22 22:25:14,900 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Tin_Date AS BillDate, A.TinShop AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [入库S1], CAST(NULL AS INT) AS [入库数量], CAST(NULL AS NUMERIC(15, 2)) AS [入库吊牌额] , CAST(C.[S1] AS INT) AS [出库S1], CAST(NULL AS INT) AS [出库数量], CAST(NULL AS NUMERIC(15, 2)) AS [出库吊牌额] , CAST(C.[S1] AS INT) AS [销售S1], CAST(NULL AS INT) AS [销售数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售吊牌额] , CAST(C.[S1] AS INT) AS [损益S1], CAST(NULL AS INT) AS [损益数量], CAST(NULL AS NUMERIC(15, 2)) AS [损益吊牌额] , CAST(C.[S1] AS INT) AS [库存S1], CAST(NULL AS INT) AS [库存数量], CAST(NULL AS NUMERIC(15, 2)) AS [库存吊牌额] INTO [##2b90b52f140f4890a726b4197d772c25] FROM ShopTin A, Barcode B, DeliveryDetail C 时间: 2021-01-22 22:25:15,054 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/22', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##79c19a1743d340f5a55a81334e9c0ebb] 时间: 2021-01-22 22:25:15,205 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/23', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##218577d92c0e47bc81a15567a0708ee6] 时间: 2021-01-22 22:25:15,348 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/24', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##35e6f74d6d0148dab40eb771869b44c3] 时间: 2021-01-22 22:25:15,498 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/25', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##888d37245b1b48628dc6b475d34774c9] 时间: 2021-01-22 22:25:15,642 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/26', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##217bb9b577cd44f28cf4efd9664c7989] 时间: 2021-01-22 22:25:15,790 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/27', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##bd69ce0097e04b5c885bc4037d50e1ba] 时间: 2021-01-22 22:25:15,943 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/28', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##6a5f25d7a7ee489ead191a87f7ee1dca] 时间: 2021-01-22 22:25:16,094 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/29', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##10be53aee171437388f740440c5b617d] 时间: 2021-01-22 22:25:16,238 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/30', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4c2d579ae8b949299c42b921b0eb8517] 时间: 2021-01-22 22:25:16,381 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/31', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4a272ae175194ebcb0ab0f5668cff64b] 时间: 2021-01-22 22:25:16,523 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/1', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4a27bb1d7a2d4b7982daec622fabc090] 时间: 2021-01-22 22:25:16,668 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/2', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##b81ccbfb109f4a9eb8b7e956fd222a2a] 时间: 2021-01-22 22:25:16,819 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/3', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##2d793f37f77f48a191af04f924982504] 时间: 2021-01-22 22:25:16,971 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/4', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##e5cf5f2813054b529ee2d66d684eec4d] 时间: 2021-01-22 22:25:17,122 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/5', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##bfec7bc37dec4a1c9e95e1bb55a3ea26] 时间: 2021-01-22 22:25:17,267 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/6', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##8b56d6b363934151a2a3f2793c457111] 时间: 2021-01-22 22:25:17,413 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/7', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##869cb492253e491f86e8342d8a80ffd0] 时间: 2021-01-22 22:25:17,555 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/8', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##59cb7b92b0bf4e4ebb24eb96ba64102b] 时间: 2021-01-22 22:25:17,697 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/9', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##1e339f6c089f45099065fc8ec520db22] 时间: 2021-01-22 22:25:17,845 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/10', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##186c63d1c103491eb74afcb90f70bd59] 时间: 2021-01-22 22:25:17,995 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/11', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a4d601a27f05469ca801dd19ecf01bb2] 时间: 2021-01-22 22:25:18,141 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/12', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##794dc27318af4cd3be25b2f84d20c98d] 时间: 2021-01-22 22:25:18,292 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/13', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##cab7ca44d0be4e77b4baaaea0d6007f5] 时间: 2021-01-22 22:25:18,442 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/14', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a047e5094ce84b45a41ccc4cd55f2944] 时间: 2021-01-22 22:25:18,592 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/15', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##9d2c8c2f17044d55a748993122d1eecf] 时间: 2021-01-22 22:25:18,739 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/16', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##d06d1be3f1cb4e9baf23d765db7c3d07] 时间: 2021-01-22 22:25:18,895 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/17', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##722d0280b66141b78084d014e836d23f] 时间: 2021-01-22 22:25:19,034 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/18', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##027cfc8ef1e4452a8035bc10b9069882] 时间: 2021-01-22 22:25:19,176 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/19', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##e4cfd20ed8f84d949fc9505d4bbeb8e6] 时间: 2021-01-22 22:25:19,319 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/20', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c15a4750454545cd8dfcc8b29731f0f8] 时间: 2021-01-22 22:25:19,460 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/21', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##eb8873ab34df4a6a863e6a0e8b1ecd21] 时间: 2021-01-22 22:25:19,602 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/22', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##8fe2ecbe6bfa42a49e08bf2323224c4c] 时间: 2021-01-22 22:25:19,604 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Tin_Date AS BillDate, A.TinShop AS Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##a62500de07034e8ab6ed769ea409475c] FROM ShopTin A INNER JOIN ShopTinGoods B ON A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted = 1 AND A.Tin_Date >= '2020/12/22' AND A.Tin_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##2b7b1a1b043a4c7482461d2ad4324cbd] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##181dd37f278647329db2634d61cb3eb9] WHERE Goods_No = B.Goods_No) GROUP BY A.Tin_Date, A.TinShop, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:25:19,630 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [入库S1], 入库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a62500de07034e8ab6ed769ea409475c] 时间: 2021-01-22 22:25:19,631 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Tout_Date AS BillDate, A.ToutShop AS Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##f16a79a6b05c44ed91a03314f0ab1c60] FROM ShopTout A INNER JOIN ShopToutGoods B ON A.ShopToutID = B.ShopToutID INNER JOIN ShopToutDetail C ON B.ShopToutGoodsID = C.ShopToutGoodsID WHERE A.Posted = 1 AND A.Tout_Date >= '2020/12/22' AND A.Tout_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##2b7b1a1b043a4c7482461d2ad4324cbd] WHERE Customer_ID = A.ToutShop) AND EXISTS (SELECT 1 FROM [##181dd37f278647329db2634d61cb3eb9] WHERE Goods_No = B.Goods_No) GROUP BY A.Tout_Date, A.ToutShop, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:25:19,656 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [出库S1], 出库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f16a79a6b05c44ed91a03314f0ab1c60] 时间: 2021-01-22 22:25:19,657 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Return_Date AS BillDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##c0bd86acf8724d4081719295d1adf2d8] FROM Dealereturn A INNER JOIN DealereturnGoods B ON A.DealereturnID = B.DealereturnID INNER JOIN DealereturnDetail C ON B.DealereturnGoodsID = C.DealereturnGoodsID WHERE A.Posted = 1 AND A.Return_Date >= '2020/12/22' AND A.Return_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##2b7b1a1b043a4c7482461d2ad4324cbd] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##181dd37f278647329db2634d61cb3eb9] WHERE Goods_No = B.Goods_No) GROUP BY A.Return_Date, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:25:19,681 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [出库S1], 出库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c0bd86acf8724d4081719295d1adf2d8] 时间: 2021-01-22 22:25:19,682 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.CheckDate AS BillDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##250bc755b7e24c0b9aed653e75088f10] FROM vn_Check A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID WHERE A.Posted = 1 AND A.CheckDate >= '2020/12/22' AND A.CheckDate <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##2b7b1a1b043a4c7482461d2ad4324cbd] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##181dd37f278647329db2634d61cb3eb9] WHERE Goods_No = B.Goods_No) GROUP BY A.CheckDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:25:19,718 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [销售S1], 销售数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##250bc755b7e24c0b9aed653e75088f10] 时间: 2021-01-22 22:25:19,719 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Balance_Date AS BillDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##da928c4ce5f4485a8a2d72adddfeb591] FROM Balance A INNER JOIN BalanceGoods B ON A.BalanceID = B.BalanceID INNER JOIN BalanceDetail C ON B.BalanceGoodsID = C.BalanceGoodsID WHERE A.Posted = 1 AND A.Type=2 AND A.Balance_Date >= '2020/12/22' AND A.Balance_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##2b7b1a1b043a4c7482461d2ad4324cbd] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##181dd37f278647329db2634d61cb3eb9] WHERE Goods_No = B.Goods_No) GROUP BY A.Balance_Date, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:25:19,765 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b90b52f140f4890a726b4197d772c25] (BillDate, Customer_ID, Goods_No, ColorID, Long, [损益S1], 损益数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##da928c4ce5f4485a8a2d72adddfeb591] 时间: 2021-01-22 22:25:19,766 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2b90b52f140f4890a726b4197d772c25 SET 入库吊牌额 = 入库数量 * GS.UnitPrice, 出库吊牌额 = 出库数量 * GS.UnitPrice, 销售吊牌额 = 销售数量 * GS.UnitPrice, 损益吊牌额 = 损益数量 * GS.UnitPrice, 库存吊牌额 = 库存数量 * GS.UnitPrice FROM ##2b90b52f140f4890a726b4197d772c25 A INNER JOIN Goods GS ON GS.Goods_No=A.Goods_No 时间: 2021-01-22 22:25:19,773 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BillDate, Customer_ID, Goods_No, ColorID, Long , SUM(入库数量) AS 入库数量 , SUM(入库吊牌额) AS 入库吊牌额 , SUM(出库数量) AS 出库数量 , SUM(出库吊牌额) AS 出库吊牌额 , SUM(销售数量) AS 销售数量 , SUM(销售吊牌额) AS 销售吊牌额 , SUM(损益数量) AS 损益数量 , SUM(损益吊牌额) AS 损益吊牌额 , SUM(库存数量) AS 库存数量 , SUM(库存吊牌额) AS 库存吊牌额 INTO ##bd2995771a194747874a70beb3ee4d20 FROM ##2b90b52f140f4890a726b4197d772c25 GROUP BY BillDate, Customer_ID, Goods_No, ColorID, Long 时间: 2021-01-22 22:25:19,783 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.BillDate AS [日期], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], GS.UnitPrice AS [吊牌价], [Z004(南山益田店)#入库#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [入库数量] ELSE 0 END) , [Z004(南山益田店)#入库#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [入库吊牌额] ELSE 0 END) , [Z004(南山益田店)#出库#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [出库数量] ELSE 0 END) , [Z004(南山益田店)#出库#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [出库吊牌额] ELSE 0 END) , [Z004(南山益田店)#销售#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [销售数量] ELSE 0 END) , [Z004(南山益田店)#销售#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [销售吊牌额] ELSE 0 END) , [Z004(南山益田店)#损益#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [损益数量] ELSE 0 END) , [Z004(南山益田店)#损益#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [损益吊牌额] ELSE 0 END) , [Z004(南山益田店)#库存#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [库存数量] ELSE 0 END) , [Z004(南山益田店)#库存#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [库存吊牌额] ELSE 0 END) INTO tempdb.dbo.[b886b154-ae01-4e00-b226-b16cb4d4c9eb] FROM [##bd2995771a194747874a70beb3ee4d20] A INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID GROUP BY A.BillDate, A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, GS.UnitPrice ORDER BY A.BillDate, A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, GS.UnitPrice 时间: 2021-01-22 22:25:31,359 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Tin_Date AS BillDate, A.TinShop AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [入库S1], CAST(NULL AS INT) AS [入库数量], CAST(NULL AS NUMERIC(15, 2)) AS [入库吊牌额] , CAST(C.[S1] AS INT) AS [出库S1], CAST(NULL AS INT) AS [出库数量], CAST(NULL AS NUMERIC(15, 2)) AS [出库吊牌额] , CAST(C.[S1] AS INT) AS [销售S1], CAST(NULL AS INT) AS [销售数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售吊牌额] , CAST(C.[S1] AS INT) AS [损益S1], CAST(NULL AS INT) AS [损益数量], CAST(NULL AS NUMERIC(15, 2)) AS [损益吊牌额] , CAST(C.[S1] AS INT) AS [库存S1], CAST(NULL AS INT) AS [库存数量], CAST(NULL AS NUMERIC(15, 2)) AS [库存吊牌额] INTO [##6d2b35f8b6fe4353a5895402923ac61f] FROM ShopTin A, Barcode B, DeliveryDetail C 时间: 2021-01-22 22:25:31,524 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6d2b35f8b6fe4353a5895402923ac61f] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/18', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##3fd01710f5d240e0b892c1d44595b1fc] 时间: 2021-01-22 22:25:31,671 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6d2b35f8b6fe4353a5895402923ac61f] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/19', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##b9b4f5e76a4f492aa20bdb88eb66f6f3] 时间: 2021-01-22 22:25:31,816 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6d2b35f8b6fe4353a5895402923ac61f] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/20', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##7e7d937f7d0e4e3a9bf5ded085061773] 时间: 2021-01-22 22:25:31,964 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6d2b35f8b6fe4353a5895402923ac61f] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/21', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##526188165f554360bf0caeeebfe9cfc9] 时间: 2021-01-22 22:25:32,107 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6d2b35f8b6fe4353a5895402923ac61f] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/22', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##156b3626e1de4a08af18534dae44728c] 时间: 2021-01-22 22:25:32,108 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Tin_Date AS BillDate, A.TinShop AS Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##3db58a742b7f4a8db4b606436a514e85] FROM ShopTin A INNER JOIN ShopTinGoods B ON A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted = 1 AND A.Tin_Date >= '2021/1/18' AND A.Tin_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##016499db5dc145df8b5300d2c922174a] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##105e9f90138f41f6bbc8bdf582f8e959] WHERE Goods_No = B.Goods_No) GROUP BY A.Tin_Date, A.TinShop, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:25:32,133 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6d2b35f8b6fe4353a5895402923ac61f] (BillDate, Customer_ID, Goods_No, ColorID, Long, [入库S1], 入库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##3db58a742b7f4a8db4b606436a514e85] 时间: 2021-01-22 22:25:32,134 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Tout_Date AS BillDate, A.ToutShop AS Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##b8922fcd484a4cd0ab7116b33d17d295] FROM ShopTout A INNER JOIN ShopToutGoods B ON A.ShopToutID = B.ShopToutID INNER JOIN ShopToutDetail C ON B.ShopToutGoodsID = C.ShopToutGoodsID WHERE A.Posted = 1 AND A.Tout_Date >= '2021/1/18' AND A.Tout_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##016499db5dc145df8b5300d2c922174a] WHERE Customer_ID = A.ToutShop) AND EXISTS (SELECT 1 FROM [##105e9f90138f41f6bbc8bdf582f8e959] WHERE Goods_No = B.Goods_No) GROUP BY A.Tout_Date, A.ToutShop, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:25:32,162 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6d2b35f8b6fe4353a5895402923ac61f] (BillDate, Customer_ID, Goods_No, ColorID, Long, [出库S1], 出库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##b8922fcd484a4cd0ab7116b33d17d295] 时间: 2021-01-22 22:25:32,163 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Return_Date AS BillDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##01ffcfa1446746b9a6bc60c4b9c45caa] FROM Dealereturn A INNER JOIN DealereturnGoods B ON A.DealereturnID = B.DealereturnID INNER JOIN DealereturnDetail C ON B.DealereturnGoodsID = C.DealereturnGoodsID WHERE A.Posted = 1 AND A.Return_Date >= '2021/1/18' AND A.Return_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##016499db5dc145df8b5300d2c922174a] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##105e9f90138f41f6bbc8bdf582f8e959] WHERE Goods_No = B.Goods_No) GROUP BY A.Return_Date, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:25:32,187 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6d2b35f8b6fe4353a5895402923ac61f] (BillDate, Customer_ID, Goods_No, ColorID, Long, [出库S1], 出库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##01ffcfa1446746b9a6bc60c4b9c45caa] 时间: 2021-01-22 22:25:32,188 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.CheckDate AS BillDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##b646df1b10c94f24b05c433262ac8229] FROM vn_Check A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID WHERE A.Posted = 1 AND A.CheckDate >= '2021/1/18' AND A.CheckDate <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##016499db5dc145df8b5300d2c922174a] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##105e9f90138f41f6bbc8bdf582f8e959] WHERE Goods_No = B.Goods_No) GROUP BY A.CheckDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:25:32,224 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6d2b35f8b6fe4353a5895402923ac61f] (BillDate, Customer_ID, Goods_No, ColorID, Long, [销售S1], 销售数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##b646df1b10c94f24b05c433262ac8229] 时间: 2021-01-22 22:25:32,225 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Balance_Date AS BillDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##e7aefcedb89e40238aa400e8b6c242d1] FROM Balance A INNER JOIN BalanceGoods B ON A.BalanceID = B.BalanceID INNER JOIN BalanceDetail C ON B.BalanceGoodsID = C.BalanceGoodsID WHERE A.Posted = 1 AND A.Type=2 AND A.Balance_Date >= '2021/1/18' AND A.Balance_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##016499db5dc145df8b5300d2c922174a] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##105e9f90138f41f6bbc8bdf582f8e959] WHERE Goods_No = B.Goods_No) GROUP BY A.Balance_Date, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:25:32,271 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6d2b35f8b6fe4353a5895402923ac61f] (BillDate, Customer_ID, Goods_No, ColorID, Long, [损益S1], 损益数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##e7aefcedb89e40238aa400e8b6c242d1] 时间: 2021-01-22 22:25:32,272 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6d2b35f8b6fe4353a5895402923ac61f SET 入库吊牌额 = 入库数量 * GS.UnitPrice, 出库吊牌额 = 出库数量 * GS.UnitPrice, 销售吊牌额 = 销售数量 * GS.UnitPrice, 损益吊牌额 = 损益数量 * GS.UnitPrice, 库存吊牌额 = 库存数量 * GS.UnitPrice FROM ##6d2b35f8b6fe4353a5895402923ac61f A INNER JOIN Goods GS ON GS.Goods_No=A.Goods_No 时间: 2021-01-22 22:25:32,278 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BillDate, Customer_ID, Goods_No, ColorID, Long , SUM(入库数量) AS 入库数量 , SUM(入库吊牌额) AS 入库吊牌额 , SUM(出库数量) AS 出库数量 , SUM(出库吊牌额) AS 出库吊牌额 , SUM(销售数量) AS 销售数量 , SUM(销售吊牌额) AS 销售吊牌额 , SUM(损益数量) AS 损益数量 , SUM(损益吊牌额) AS 损益吊牌额 , SUM(库存数量) AS 库存数量 , SUM(库存吊牌额) AS 库存吊牌额 INTO ##e0511a6a50824c2a983e6d2ba3ca288b FROM ##6d2b35f8b6fe4353a5895402923ac61f GROUP BY BillDate, Customer_ID, Goods_No, ColorID, Long 时间: 2021-01-22 22:25:32,286 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.BillDate AS [日期], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], GS.UnitPrice AS [吊牌价], [Z004(南山益田店)#入库#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [入库数量] ELSE 0 END) , [Z004(南山益田店)#入库#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [入库吊牌额] ELSE 0 END) , [Z004(南山益田店)#出库#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [出库数量] ELSE 0 END) , [Z004(南山益田店)#出库#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [出库吊牌额] ELSE 0 END) , [Z004(南山益田店)#销售#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [销售数量] ELSE 0 END) , [Z004(南山益田店)#销售#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [销售吊牌额] ELSE 0 END) , [Z004(南山益田店)#损益#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [损益数量] ELSE 0 END) , [Z004(南山益田店)#损益#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [损益吊牌额] ELSE 0 END) , [Z004(南山益田店)#库存#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [库存数量] ELSE 0 END) , [Z004(南山益田店)#库存#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [库存吊牌额] ELSE 0 END) INTO tempdb.dbo.[b886b154-ae01-4e00-b226-b16cb4d4c9eb] FROM [##e0511a6a50824c2a983e6d2ba3ca288b] A INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID GROUP BY A.BillDate, A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, GS.UnitPrice ORDER BY A.BillDate, A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, GS.UnitPrice 时间: 2021-01-22 22:26:11,846 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Tin_Date AS BillDate, A.TinShop AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [入库S1], CAST(NULL AS INT) AS [入库数量], CAST(NULL AS NUMERIC(15, 2)) AS [入库吊牌额] , CAST(C.[S1] AS INT) AS [出库S1], CAST(NULL AS INT) AS [出库数量], CAST(NULL AS NUMERIC(15, 2)) AS [出库吊牌额] , CAST(C.[S1] AS INT) AS [销售S1], CAST(NULL AS INT) AS [销售数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售吊牌额] , CAST(C.[S1] AS INT) AS [损益S1], CAST(NULL AS INT) AS [损益数量], CAST(NULL AS NUMERIC(15, 2)) AS [损益吊牌额] , CAST(C.[S1] AS INT) AS [库存S1], CAST(NULL AS INT) AS [库存数量], CAST(NULL AS NUMERIC(15, 2)) AS [库存吊牌额] INTO [##4846a73ee0504b7b9a62066a0b01a0a8] FROM ShopTin A, Barcode B, DeliveryDetail C 时间: 2021-01-22 22:26:12,011 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4846a73ee0504b7b9a62066a0b01a0a8] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/17', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##526101a02982472b866ca681feca7efa] 时间: 2021-01-22 22:26:12,157 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4846a73ee0504b7b9a62066a0b01a0a8] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/18', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##292d02df529f457a8d0ddd55f265c63d] 时间: 2021-01-22 22:26:12,297 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4846a73ee0504b7b9a62066a0b01a0a8] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/19', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##ca778a8b6978412591471fddccef6067] 时间: 2021-01-22 22:26:12,437 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4846a73ee0504b7b9a62066a0b01a0a8] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/20', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##b0927335b0784bb59586a8efc9f3b274] 时间: 2021-01-22 22:26:12,577 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4846a73ee0504b7b9a62066a0b01a0a8] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/21', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4e572aef0d434835a55123cc8da6cca7] 时间: 2021-01-22 22:26:12,722 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4846a73ee0504b7b9a62066a0b01a0a8] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/22', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##cfb62f2402a84a51b8af6e4c9c54e200] 时间: 2021-01-22 22:26:12,724 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Tin_Date AS BillDate, A.TinShop AS Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##e9b0ae9108884495902505d0d1669d07] FROM ShopTin A INNER JOIN ShopTinGoods B ON A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted = 1 AND A.Tin_Date >= '2021/1/17' AND A.Tin_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##0b73b06a80d94d9cbf0931845c3728f3] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##b646a271e1dd4be5a7310c9ae6973f8c] WHERE Goods_No = B.Goods_No) GROUP BY A.Tin_Date, A.TinShop, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:26:12,749 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4846a73ee0504b7b9a62066a0b01a0a8] (BillDate, Customer_ID, Goods_No, ColorID, Long, [入库S1], 入库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##e9b0ae9108884495902505d0d1669d07] 时间: 2021-01-22 22:26:12,750 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Tout_Date AS BillDate, A.ToutShop AS Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##2b70469a27c549638525694064e4488c] FROM ShopTout A INNER JOIN ShopToutGoods B ON A.ShopToutID = B.ShopToutID INNER JOIN ShopToutDetail C ON B.ShopToutGoodsID = C.ShopToutGoodsID WHERE A.Posted = 1 AND A.Tout_Date >= '2021/1/17' AND A.Tout_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##0b73b06a80d94d9cbf0931845c3728f3] WHERE Customer_ID = A.ToutShop) AND EXISTS (SELECT 1 FROM [##b646a271e1dd4be5a7310c9ae6973f8c] WHERE Goods_No = B.Goods_No) GROUP BY A.Tout_Date, A.ToutShop, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:26:12,777 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4846a73ee0504b7b9a62066a0b01a0a8] (BillDate, Customer_ID, Goods_No, ColorID, Long, [出库S1], 出库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##2b70469a27c549638525694064e4488c] 时间: 2021-01-22 22:26:12,778 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Return_Date AS BillDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##e449261d83be4918806c52c8ebf58247] FROM Dealereturn A INNER JOIN DealereturnGoods B ON A.DealereturnID = B.DealereturnID INNER JOIN DealereturnDetail C ON B.DealereturnGoodsID = C.DealereturnGoodsID WHERE A.Posted = 1 AND A.Return_Date >= '2021/1/17' AND A.Return_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##0b73b06a80d94d9cbf0931845c3728f3] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##b646a271e1dd4be5a7310c9ae6973f8c] WHERE Goods_No = B.Goods_No) GROUP BY A.Return_Date, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:26:12,803 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4846a73ee0504b7b9a62066a0b01a0a8] (BillDate, Customer_ID, Goods_No, ColorID, Long, [出库S1], 出库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##e449261d83be4918806c52c8ebf58247] 时间: 2021-01-22 22:26:12,806 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.CheckDate AS BillDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##b8bcb64e0eb340c1aae3173e9ef173be] FROM vn_Check A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID WHERE A.Posted = 1 AND A.CheckDate >= '2021/1/17' AND A.CheckDate <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##0b73b06a80d94d9cbf0931845c3728f3] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##b646a271e1dd4be5a7310c9ae6973f8c] WHERE Goods_No = B.Goods_No) GROUP BY A.CheckDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:26:12,841 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4846a73ee0504b7b9a62066a0b01a0a8] (BillDate, Customer_ID, Goods_No, ColorID, Long, [销售S1], 销售数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##b8bcb64e0eb340c1aae3173e9ef173be] 时间: 2021-01-22 22:26:12,842 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Balance_Date AS BillDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##c4a99c961226427d920f48cbd8339ff7] FROM Balance A INNER JOIN BalanceGoods B ON A.BalanceID = B.BalanceID INNER JOIN BalanceDetail C ON B.BalanceGoodsID = C.BalanceGoodsID WHERE A.Posted = 1 AND A.Type=2 AND A.Balance_Date >= '2021/1/17' AND A.Balance_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##0b73b06a80d94d9cbf0931845c3728f3] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##b646a271e1dd4be5a7310c9ae6973f8c] WHERE Goods_No = B.Goods_No) GROUP BY A.Balance_Date, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:26:12,892 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4846a73ee0504b7b9a62066a0b01a0a8] (BillDate, Customer_ID, Goods_No, ColorID, Long, [损益S1], 损益数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c4a99c961226427d920f48cbd8339ff7] 时间: 2021-01-22 22:26:12,893 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4846a73ee0504b7b9a62066a0b01a0a8 SET 入库吊牌额 = 入库数量 * GS.UnitPrice, 出库吊牌额 = 出库数量 * GS.UnitPrice, 销售吊牌额 = 销售数量 * GS.UnitPrice, 损益吊牌额 = 损益数量 * GS.UnitPrice, 库存吊牌额 = 库存数量 * GS.UnitPrice FROM ##4846a73ee0504b7b9a62066a0b01a0a8 A INNER JOIN Goods GS ON GS.Goods_No=A.Goods_No 时间: 2021-01-22 22:26:12,899 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BillDate, Customer_ID, Goods_No, ColorID, Long , SUM(入库数量) AS 入库数量 , SUM(入库吊牌额) AS 入库吊牌额 , SUM(出库数量) AS 出库数量 , SUM(出库吊牌额) AS 出库吊牌额 , SUM(销售数量) AS 销售数量 , SUM(销售吊牌额) AS 销售吊牌额 , SUM(损益数量) AS 损益数量 , SUM(损益吊牌额) AS 损益吊牌额 , SUM(库存数量) AS 库存数量 , SUM(库存吊牌额) AS 库存吊牌额 INTO ##8be277de8f33457c96d226745e680105 FROM ##4846a73ee0504b7b9a62066a0b01a0a8 GROUP BY BillDate, Customer_ID, Goods_No, ColorID, Long 时间: 2021-01-22 22:26:12,906 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.BillDate AS [日期], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], GS.UnitPrice AS [吊牌价], [Z004(南山益田店)#入库#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [入库数量] ELSE 0 END) , [Z004(南山益田店)#入库#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [入库吊牌额] ELSE 0 END) , [Z004(南山益田店)#出库#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [出库数量] ELSE 0 END) , [Z004(南山益田店)#出库#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [出库吊牌额] ELSE 0 END) , [Z004(南山益田店)#销售#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [销售数量] ELSE 0 END) , [Z004(南山益田店)#销售#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [销售吊牌额] ELSE 0 END) , [Z004(南山益田店)#损益#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [损益数量] ELSE 0 END) , [Z004(南山益田店)#损益#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [损益吊牌额] ELSE 0 END) , [Z004(南山益田店)#库存#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [库存数量] ELSE 0 END) , [Z004(南山益田店)#库存#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [库存吊牌额] ELSE 0 END) INTO tempdb.dbo.[b886b154-ae01-4e00-b226-b16cb4d4c9eb] FROM [##8be277de8f33457c96d226745e680105] A INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID GROUP BY A.BillDate, A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, GS.UnitPrice ORDER BY A.BillDate, A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, GS.UnitPrice 时间: 2021-01-22 22:26:27,038 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Tin_Date AS BillDate, A.TinShop AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [入库S1], CAST(NULL AS INT) AS [入库数量], CAST(NULL AS NUMERIC(15, 2)) AS [入库吊牌额] , CAST(C.[S1] AS INT) AS [出库S1], CAST(NULL AS INT) AS [出库数量], CAST(NULL AS NUMERIC(15, 2)) AS [出库吊牌额] , CAST(C.[S1] AS INT) AS [销售S1], CAST(NULL AS INT) AS [销售数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售吊牌额] , CAST(C.[S1] AS INT) AS [损益S1], CAST(NULL AS INT) AS [损益数量], CAST(NULL AS NUMERIC(15, 2)) AS [损益吊牌额] , CAST(C.[S1] AS INT) AS [库存S1], CAST(NULL AS INT) AS [库存数量], CAST(NULL AS NUMERIC(15, 2)) AS [库存吊牌额] INTO [##a8e1219fe94f4d92921890ba479a647d] FROM ShopTin A, Barcode B, DeliveryDetail C 时间: 2021-01-22 22:26:27,195 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/1', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##58b74e917d3a4720956d89c0a6a931db] 时间: 2021-01-22 22:26:27,346 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/2', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##d9b2e8bc6a7c432cbe827c82acda2c1a] 时间: 2021-01-22 22:26:27,496 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/3', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##2d1a62cede2d4b2aa7e456f478fe6039] 时间: 2021-01-22 22:26:27,641 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/4', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##19969e3650b44b3a82e0ac4c7c4d6810] 时间: 2021-01-22 22:26:27,784 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/5', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a052eff5b47640e89cb757b267151595] 时间: 2021-01-22 22:26:27,935 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/6', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##7fb47f0740cf409f97bae4928d4319a2] 时间: 2021-01-22 22:26:28,079 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/7', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f2646cc0a2864a47857d3e5275304eac] 时间: 2021-01-22 22:26:28,226 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/8', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##3ccf9b3e842f4872a16aac07b8999abb] 时间: 2021-01-22 22:26:28,370 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/9', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##8d70019b2942450cbbb974e7afeaf2c8] 时间: 2021-01-22 22:26:28,520 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/10', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##2121f29132ef4c04a910aa22d7f05887] 时间: 2021-01-22 22:26:28,660 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/11', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c682bd96810d4acd8ce38da015b11366] 时间: 2021-01-22 22:26:28,805 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/12', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##04fa9ca06da041d496e49fdbd52bc0a4] 时间: 2021-01-22 22:26:28,954 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/13', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##9c7403074b304c50940e7b83a2328230] 时间: 2021-01-22 22:26:29,104 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/14', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##bc94fd67f84c403da8dda695fe5f56ef] 时间: 2021-01-22 22:26:29,253 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/15', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##501dadc975b24f1bb06158e0bb9699e7] 时间: 2021-01-22 22:26:29,402 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/16', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##79943074db0a4ac988c8fe488c75d90f] 时间: 2021-01-22 22:26:29,551 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/17', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##233e04154b884aad9b348ffec48dee6a] 时间: 2021-01-22 22:26:29,692 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/18', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4cb12b91af72434898b903fc166d619e] 时间: 2021-01-22 22:26:29,836 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/19', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c3353a02567c4ea6998da910cf309d85] 时间: 2021-01-22 22:26:29,984 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/20', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##498e7edefb474afcbd0c9481963578bc] 时间: 2021-01-22 22:26:30,128 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/21', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##5296672c3cf740bca2891203f09a2751] 时间: 2021-01-22 22:26:30,274 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/22', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##9d404553a8004bf08e83a20bffd31def] 时间: 2021-01-22 22:26:30,276 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Tin_Date AS BillDate, A.TinShop AS Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##aa71506456124462bd2b341241973bea] FROM ShopTin A INNER JOIN ShopTinGoods B ON A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted = 1 AND A.Tin_Date >= '2021/1/1' AND A.Tin_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##b2baa7d2f5114850b0f6b2a592753b04] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##de6280be43d9476a8617db12149ed7ce] WHERE Goods_No = B.Goods_No) GROUP BY A.Tin_Date, A.TinShop, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:26:30,300 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [入库S1], 入库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##aa71506456124462bd2b341241973bea] 时间: 2021-01-22 22:26:30,301 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Tout_Date AS BillDate, A.ToutShop AS Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##c1221f3aa7f04105b13d4b39bd7a88e4] FROM ShopTout A INNER JOIN ShopToutGoods B ON A.ShopToutID = B.ShopToutID INNER JOIN ShopToutDetail C ON B.ShopToutGoodsID = C.ShopToutGoodsID WHERE A.Posted = 1 AND A.Tout_Date >= '2021/1/1' AND A.Tout_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##b2baa7d2f5114850b0f6b2a592753b04] WHERE Customer_ID = A.ToutShop) AND EXISTS (SELECT 1 FROM [##de6280be43d9476a8617db12149ed7ce] WHERE Goods_No = B.Goods_No) GROUP BY A.Tout_Date, A.ToutShop, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:26:30,328 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [出库S1], 出库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c1221f3aa7f04105b13d4b39bd7a88e4] 时间: 2021-01-22 22:26:30,329 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Return_Date AS BillDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##ec7c686b33aa4615869020f184e454a4] FROM Dealereturn A INNER JOIN DealereturnGoods B ON A.DealereturnID = B.DealereturnID INNER JOIN DealereturnDetail C ON B.DealereturnGoodsID = C.DealereturnGoodsID WHERE A.Posted = 1 AND A.Return_Date >= '2021/1/1' AND A.Return_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##b2baa7d2f5114850b0f6b2a592753b04] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##de6280be43d9476a8617db12149ed7ce] WHERE Goods_No = B.Goods_No) GROUP BY A.Return_Date, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:26:30,353 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [出库S1], 出库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##ec7c686b33aa4615869020f184e454a4] 时间: 2021-01-22 22:26:30,354 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.CheckDate AS BillDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##07528d99a5314b289188627f93950a43] FROM vn_Check A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID WHERE A.Posted = 1 AND A.CheckDate >= '2021/1/1' AND A.CheckDate <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##b2baa7d2f5114850b0f6b2a592753b04] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##de6280be43d9476a8617db12149ed7ce] WHERE Goods_No = B.Goods_No) GROUP BY A.CheckDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:26:30,391 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [销售S1], 销售数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##07528d99a5314b289188627f93950a43] 时间: 2021-01-22 22:26:30,392 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Balance_Date AS BillDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##22f8705a5c8144cba07ef9b685d8b00a] FROM Balance A INNER JOIN BalanceGoods B ON A.BalanceID = B.BalanceID INNER JOIN BalanceDetail C ON B.BalanceGoodsID = C.BalanceGoodsID WHERE A.Posted = 1 AND A.Type=2 AND A.Balance_Date >= '2021/1/1' AND A.Balance_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##b2baa7d2f5114850b0f6b2a592753b04] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##de6280be43d9476a8617db12149ed7ce] WHERE Goods_No = B.Goods_No) GROUP BY A.Balance_Date, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:26:30,436 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8e1219fe94f4d92921890ba479a647d] (BillDate, Customer_ID, Goods_No, ColorID, Long, [损益S1], 损益数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##22f8705a5c8144cba07ef9b685d8b00a] 时间: 2021-01-22 22:26:30,437 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a8e1219fe94f4d92921890ba479a647d SET 入库吊牌额 = 入库数量 * GS.UnitPrice, 出库吊牌额 = 出库数量 * GS.UnitPrice, 销售吊牌额 = 销售数量 * GS.UnitPrice, 损益吊牌额 = 损益数量 * GS.UnitPrice, 库存吊牌额 = 库存数量 * GS.UnitPrice FROM ##a8e1219fe94f4d92921890ba479a647d A INNER JOIN Goods GS ON GS.Goods_No=A.Goods_No 时间: 2021-01-22 22:26:30,443 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BillDate, Customer_ID, Goods_No, ColorID, Long , SUM(入库数量) AS 入库数量 , SUM(入库吊牌额) AS 入库吊牌额 , SUM(出库数量) AS 出库数量 , SUM(出库吊牌额) AS 出库吊牌额 , SUM(销售数量) AS 销售数量 , SUM(销售吊牌额) AS 销售吊牌额 , SUM(损益数量) AS 损益数量 , SUM(损益吊牌额) AS 损益吊牌额 , SUM(库存数量) AS 库存数量 , SUM(库存吊牌额) AS 库存吊牌额 INTO ##c60a953211814f5abc200945f8fa764d FROM ##a8e1219fe94f4d92921890ba479a647d GROUP BY BillDate, Customer_ID, Goods_No, ColorID, Long 时间: 2021-01-22 22:26:30,452 线程ID: 119 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.BillDate AS [日期], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], GS.UnitPrice AS [吊牌价], [Z004(南山益田店)#入库#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [入库数量] ELSE 0 END) , [Z004(南山益田店)#入库#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [入库吊牌额] ELSE 0 END) , [Z004(南山益田店)#出库#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [出库数量] ELSE 0 END) , [Z004(南山益田店)#出库#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [出库吊牌额] ELSE 0 END) , [Z004(南山益田店)#销售#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [销售数量] ELSE 0 END) , [Z004(南山益田店)#销售#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [销售吊牌额] ELSE 0 END) , [Z004(南山益田店)#损益#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [损益数量] ELSE 0 END) , [Z004(南山益田店)#损益#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [损益吊牌额] ELSE 0 END) , [Z004(南山益田店)#库存#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [库存数量] ELSE 0 END) , [Z004(南山益田店)#库存#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [库存吊牌额] ELSE 0 END) INTO tempdb.dbo.[b886b154-ae01-4e00-b226-b16cb4d4c9eb] FROM [##c60a953211814f5abc200945f8fa764d] A INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID GROUP BY A.BillDate, A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, GS.UnitPrice ORDER BY A.BillDate, A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, GS.UnitPrice 时间: 2021-01-22 22:27:08,396 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Tin_Date AS BillDate, A.TinShop AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [入库S1], CAST(NULL AS INT) AS [入库数量], CAST(NULL AS NUMERIC(15, 2)) AS [入库吊牌额] , CAST(C.[S1] AS INT) AS [出库S1], CAST(NULL AS INT) AS [出库数量], CAST(NULL AS NUMERIC(15, 2)) AS [出库吊牌额] , CAST(C.[S1] AS INT) AS [销售S1], CAST(NULL AS INT) AS [销售数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售吊牌额] , CAST(C.[S1] AS INT) AS [损益S1], CAST(NULL AS INT) AS [损益数量], CAST(NULL AS NUMERIC(15, 2)) AS [损益吊牌额] , CAST(C.[S1] AS INT) AS [库存S1], CAST(NULL AS INT) AS [库存数量], CAST(NULL AS NUMERIC(15, 2)) AS [库存吊牌额] INTO [##e23d8ce9b68f4d5c9bad650c7a3e4c34] FROM ShopTin A, Barcode B, DeliveryDetail C 时间: 2021-01-22 22:27:08,548 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e23d8ce9b68f4d5c9bad650c7a3e4c34] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/18', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##d437d4a3cd134468aec4908f8c3536b0] 时间: 2021-01-22 22:27:08,695 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e23d8ce9b68f4d5c9bad650c7a3e4c34] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/19', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##cfe0e3bfd44546f8abc0ff6f2d5cd5c2] 时间: 2021-01-22 22:27:08,838 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e23d8ce9b68f4d5c9bad650c7a3e4c34] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/20', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##d8e8835f38b140feb77b93c8b7dadf40] 时间: 2021-01-22 22:27:08,984 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e23d8ce9b68f4d5c9bad650c7a3e4c34] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/21', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##36af78c4d159445dbc5099c1d3864e57] 时间: 2021-01-22 22:27:09,130 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e23d8ce9b68f4d5c9bad650c7a3e4c34] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/22', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##89af7b1641a14ccb865abe8d6821a0b1] 时间: 2021-01-22 22:27:09,131 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Tin_Date AS BillDate, A.TinShop AS Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##9abfa19163e44707871a46c664d2d253] FROM ShopTin A INNER JOIN ShopTinGoods B ON A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted = 1 AND A.Tin_Date >= '2021/1/18' AND A.Tin_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##518a05b137d04590a75228b700fed116] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##8aef9d1a237048f49b0cb2b187ba6bee] WHERE Goods_No = B.Goods_No) GROUP BY A.Tin_Date, A.TinShop, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:27:09,155 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e23d8ce9b68f4d5c9bad650c7a3e4c34] (BillDate, Customer_ID, Goods_No, ColorID, Long, [入库S1], 入库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##9abfa19163e44707871a46c664d2d253] 时间: 2021-01-22 22:27:09,156 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Tout_Date AS BillDate, A.ToutShop AS Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##6fe8e2e65e42480c82b0b1d6b3a17c17] FROM ShopTout A INNER JOIN ShopToutGoods B ON A.ShopToutID = B.ShopToutID INNER JOIN ShopToutDetail C ON B.ShopToutGoodsID = C.ShopToutGoodsID WHERE A.Posted = 1 AND A.Tout_Date >= '2021/1/18' AND A.Tout_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##518a05b137d04590a75228b700fed116] WHERE Customer_ID = A.ToutShop) AND EXISTS (SELECT 1 FROM [##8aef9d1a237048f49b0cb2b187ba6bee] WHERE Goods_No = B.Goods_No) GROUP BY A.Tout_Date, A.ToutShop, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:27:09,182 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e23d8ce9b68f4d5c9bad650c7a3e4c34] (BillDate, Customer_ID, Goods_No, ColorID, Long, [出库S1], 出库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##6fe8e2e65e42480c82b0b1d6b3a17c17] 时间: 2021-01-22 22:27:09,183 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Return_Date AS BillDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##27e18a37f57244119f2c0d0440502625] FROM Dealereturn A INNER JOIN DealereturnGoods B ON A.DealereturnID = B.DealereturnID INNER JOIN DealereturnDetail C ON B.DealereturnGoodsID = C.DealereturnGoodsID WHERE A.Posted = 1 AND A.Return_Date >= '2021/1/18' AND A.Return_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##518a05b137d04590a75228b700fed116] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##8aef9d1a237048f49b0cb2b187ba6bee] WHERE Goods_No = B.Goods_No) GROUP BY A.Return_Date, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:27:09,208 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e23d8ce9b68f4d5c9bad650c7a3e4c34] (BillDate, Customer_ID, Goods_No, ColorID, Long, [出库S1], 出库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##27e18a37f57244119f2c0d0440502625] 时间: 2021-01-22 22:27:09,209 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.CheckDate AS BillDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##638a5c7da0984464b7d4a32078a9c303] FROM vn_Check A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID WHERE A.Posted = 1 AND A.CheckDate >= '2021/1/18' AND A.CheckDate <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##518a05b137d04590a75228b700fed116] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##8aef9d1a237048f49b0cb2b187ba6bee] WHERE Goods_No = B.Goods_No) GROUP BY A.CheckDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:27:09,244 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e23d8ce9b68f4d5c9bad650c7a3e4c34] (BillDate, Customer_ID, Goods_No, ColorID, Long, [销售S1], 销售数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##638a5c7da0984464b7d4a32078a9c303] 时间: 2021-01-22 22:27:09,245 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Balance_Date AS BillDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long , SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)) AS Quantity INTO [##907233e52cb6440d810a00fbf88f067d] FROM Balance A INNER JOIN BalanceGoods B ON A.BalanceID = B.BalanceID INNER JOIN BalanceDetail C ON B.BalanceGoodsID = C.BalanceGoodsID WHERE A.Posted = 1 AND A.Type=2 AND A.Balance_Date >= '2021/1/18' AND A.Balance_Date <= '2021/1/22' AND EXISTS (SELECT 1 FROM [##518a05b137d04590a75228b700fed116] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##8aef9d1a237048f49b0cb2b187ba6bee] WHERE Goods_No = B.Goods_No) GROUP BY A.Balance_Date, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-22 22:27:09,290 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e23d8ce9b68f4d5c9bad650c7a3e4c34] (BillDate, Customer_ID, Goods_No, ColorID, Long, [损益S1], 损益数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##907233e52cb6440d810a00fbf88f067d] 时间: 2021-01-22 22:27:09,291 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e23d8ce9b68f4d5c9bad650c7a3e4c34 SET 入库吊牌额 = 入库数量 * GS.UnitPrice, 出库吊牌额 = 出库数量 * GS.UnitPrice, 销售吊牌额 = 销售数量 * GS.UnitPrice, 损益吊牌额 = 损益数量 * GS.UnitPrice, 库存吊牌额 = 库存数量 * GS.UnitPrice FROM ##e23d8ce9b68f4d5c9bad650c7a3e4c34 A INNER JOIN Goods GS ON GS.Goods_No=A.Goods_No 时间: 2021-01-22 22:27:09,297 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BillDate, Customer_ID, Goods_No, ColorID, Long , SUM(入库数量) AS 入库数量 , SUM(入库吊牌额) AS 入库吊牌额 , SUM(出库数量) AS 出库数量 , SUM(出库吊牌额) AS 出库吊牌额 , SUM(销售数量) AS 销售数量 , SUM(销售吊牌额) AS 销售吊牌额 , SUM(损益数量) AS 损益数量 , SUM(损益吊牌额) AS 损益吊牌额 , SUM(库存数量) AS 库存数量 , SUM(库存吊牌额) AS 库存吊牌额 INTO ##fa4f60e6a3594b11a1fdba10bb2ea46d FROM ##e23d8ce9b68f4d5c9bad650c7a3e4c34 GROUP BY BillDate, Customer_ID, Goods_No, ColorID, Long 时间: 2021-01-22 22:27:09,305 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.BillDate AS [日期], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], GS.UnitPrice AS [吊牌价], [Z004(南山益田店)#入库#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [入库数量] ELSE 0 END) , [Z004(南山益田店)#入库#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [入库吊牌额] ELSE 0 END) , [Z004(南山益田店)#出库#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [出库数量] ELSE 0 END) , [Z004(南山益田店)#出库#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [出库吊牌额] ELSE 0 END) , [Z004(南山益田店)#销售#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [销售数量] ELSE 0 END) , [Z004(南山益田店)#销售#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [销售吊牌额] ELSE 0 END) , [Z004(南山益田店)#损益#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [损益数量] ELSE 0 END) , [Z004(南山益田店)#损益#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [损益吊牌额] ELSE 0 END) , [Z004(南山益田店)#库存#数量]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [库存数量] ELSE 0 END) , [Z004(南山益田店)#库存#吊牌额]=SUM(CASE WHEN A.Customer_ID='Z004' THEN [库存吊牌额] ELSE 0 END) INTO tempdb.dbo.[b886b154-ae01-4e00-b226-b16cb4d4c9eb] FROM [##fa4f60e6a3594b11a1fdba10bb2ea46d] A INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID GROUP BY A.BillDate, A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, GS.UnitPrice ORDER BY A.BillDate, A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, GS.UnitPrice 时间: 2021-01-22 22:32:12,803 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##44c1bf7d57c5469b8285679e24ceb0f8] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2021-01-22 22:32:12,806 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##44c1bf7d57c5469b8285679e24ceb0f8] 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 ##44c1bf7d57c5469b8285679e24ceb0f8 WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##17a3217b78014742b33646ba7b1f0df1] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2021-01-22 22:32:13,016 线程ID: 57 日志级别: 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.[01b4ce21-09bd-4f3c-a4d2-babf5f47bfea] FROM [##44c1bf7d57c5469b8285679e24ceb0f8] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2021-01-22 22:32:16,823 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##fd3b7f779ef84f44a54babae85955e90] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2021-01-22 22:32:16,826 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##fd3b7f779ef84f44a54babae85955e90] 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 ##fd3b7f779ef84f44a54babae85955e90 WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##3b14f753b94f4c37b6fe5d207b698f0d] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2021-01-22 22:32:17,130 线程ID: 9 日志级别: 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.[01b4ce21-09bd-4f3c-a4d2-babf5f47bfea] FROM [##fd3b7f779ef84f44a54babae85955e90] ORDER BY Balance_Date DESC, BalanceID ASC