时间: 2021-01-18 14:03:24,605 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SaleType='线上发货' FROM [##a31cd0f5a8a0482582e77dc047e0c4a9] A WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' UPDATE [##a31cd0f5a8a0482582e77dc047e0c4a9] SET SaleType='正常销售' WHERE SaleType='正常' OR SaleType IS NULL OR SaleType = '' DELETE FROM [##a31cd0f5a8a0482582e77dc047e0c4a9] WHERE 1=1 AND NOT EXISTS(SELECT 1 FROM ##29b68f9d88ba44f28e06e0b8f6107269 B WHERE B.data = SaleType) 时间: 2021-01-18 14:03:24,626 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE [##a31cd0f5a8a0482582e77dc047e0c4a9] DROP COLUMN SaleType, OnlineSaleTypeID, RetailOrderID 时间: 2021-01-18 14:03:24,631 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##a31cd0f5a8a0482582e77dc047e0c4a9] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'ShopCheck2' AND A.CheckID = BillNo ) 时间: 2021-01-18 14:03:24,636 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##a31cd0f5a8a0482582e77dc047e0c4a9] A INNER JOIN ( SELECT A.CheckID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.DiscountPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(GDP.DpPriceByRetail,0) ) As DpAmount FROM [vn_CheckGoods] A INNER JOIN vn_Check B ON A.CheckID = B.CheckID LEFT JOIN [Customer] CT ON CT.Customer_ID=B.Customer_ID LEFT JOIN vGoodsDpPrice GDP ON CT.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM ##a31cd0f5a8a0482582e77dc047e0c4a9 WHERE A.CheckID = CheckID ) AND EXISTS (SELECT 1 FROM [##1f804e01def44a269b351d1ed638d357] WHERE Goods_No = A.Goods_No) GROUP BY A.CheckID ) B ON A.CheckID = B.CheckID 时间: 2021-01-18 14:03:24,726 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT * INTO [##fba2480e09604599a07e1d06e17681b9] FROM [##a31cd0f5a8a0482582e77dc047e0c4a9] 时间: 2021-01-18 14:03:24,770 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CheckID AS [单号], Manual_ID AS [手工单号], CheckDate AS [日期] , Customer_ID AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [生意额] , JiZhang AS [记账状态#记账], JzOperator AS [记账状态#记账人], JzDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人],PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[9a09eb92-2973-41d7-a704-53202718c526] FROM [##fba2480e09604599a07e1d06e17681b9] ORDER BY CheckDate DESC, CheckID ASC 时间: 2021-01-18 14:03:35,534 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SaleType='线上发货' FROM [##c4af7ba7ea924d3692d5c1c1436efd19] A WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' UPDATE [##c4af7ba7ea924d3692d5c1c1436efd19] SET SaleType='正常销售' WHERE SaleType='正常' OR SaleType IS NULL OR SaleType = '' DELETE FROM [##c4af7ba7ea924d3692d5c1c1436efd19] WHERE 1=1 AND NOT EXISTS(SELECT 1 FROM ##fd007e015c584449ba0df4a40a4c330d B WHERE B.data = SaleType) 时间: 2021-01-18 14:03:35,540 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE [##c4af7ba7ea924d3692d5c1c1436efd19] DROP COLUMN SaleType, OnlineSaleTypeID, RetailOrderID 时间: 2021-01-18 14:03:35,542 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##c4af7ba7ea924d3692d5c1c1436efd19] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'ShopCheck2' AND A.CheckID = BillNo ) 时间: 2021-01-18 14:03:35,545 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##c4af7ba7ea924d3692d5c1c1436efd19] A INNER JOIN ( SELECT A.CheckID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.DiscountPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(GDP.DpPriceByRetail,0) ) As DpAmount FROM [vn_CheckGoods] A INNER JOIN vn_Check B ON A.CheckID = B.CheckID LEFT JOIN [Customer] CT ON CT.Customer_ID=B.Customer_ID LEFT JOIN vGoodsDpPrice GDP ON CT.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM ##c4af7ba7ea924d3692d5c1c1436efd19 WHERE A.CheckID = CheckID ) AND EXISTS (SELECT 1 FROM [##850af1ea6e314ea1abdb1b19aeb32e76] WHERE Goods_No = A.Goods_No) GROUP BY A.CheckID ) B ON A.CheckID = B.CheckID 时间: 2021-01-18 14:03:35,594 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT * INTO [##95ebf481e4b945f0bef6db7b1fd5d43b] FROM [##c4af7ba7ea924d3692d5c1c1436efd19] 时间: 2021-01-18 14:03:35,609 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CheckID AS [单号], Manual_ID AS [手工单号], CheckDate AS [日期] , Customer_ID AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [生意额] , JiZhang AS [记账状态#记账], JzOperator AS [记账状态#记账人], JzDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人],PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[9a09eb92-2973-41d7-a704-53202718c526] FROM [##95ebf481e4b945f0bef6db7b1fd5d43b] ORDER BY CheckDate DESC, CheckID ASC 时间: 2021-01-18 14:05:52,552 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SaleType='线上发货' FROM [##03098f464674465b96686ec89bdeec66] A WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' UPDATE [##03098f464674465b96686ec89bdeec66] SET SaleType='正常销售' WHERE SaleType='正常' OR SaleType IS NULL OR SaleType = '' DELETE FROM [##03098f464674465b96686ec89bdeec66] WHERE 1=1 AND NOT EXISTS(SELECT 1 FROM ##805cb265ea484bbba55d736d2b36a42c B WHERE B.data = SaleType) 时间: 2021-01-18 14:05:52,559 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE [##03098f464674465b96686ec89bdeec66] DROP COLUMN SaleType, OnlineSaleTypeID, RetailOrderID 时间: 2021-01-18 14:05:52,560 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##03098f464674465b96686ec89bdeec66] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'ShopCheck2' AND A.CheckID = BillNo ) 时间: 2021-01-18 14:05:52,563 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##03098f464674465b96686ec89bdeec66] A INNER JOIN ( SELECT A.CheckID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.DiscountPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(GDP.DpPriceByRetail,0) ) As DpAmount FROM [vn_CheckGoods] A INNER JOIN vn_Check B ON A.CheckID = B.CheckID LEFT JOIN [Customer] CT ON CT.Customer_ID=B.Customer_ID LEFT JOIN vGoodsDpPrice GDP ON CT.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM ##03098f464674465b96686ec89bdeec66 WHERE A.CheckID = CheckID ) AND EXISTS (SELECT 1 FROM [##2917165e959e4b2c9d6910c02e99b2fa] WHERE Goods_No = A.Goods_No) GROUP BY A.CheckID ) B ON A.CheckID = B.CheckID 时间: 2021-01-18 14:05:52,614 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT * INTO [##64a358efce3143fcae2fe0d2160ecf13] FROM [##03098f464674465b96686ec89bdeec66] 时间: 2021-01-18 14:05:52,629 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CheckID AS [单号], Manual_ID AS [手工单号], CheckDate AS [日期] , Customer_ID AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [生意额] , JiZhang AS [记账状态#记账], JzOperator AS [记账状态#记账人], JzDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人],PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[6316a338-d316-47d1-a47f-39d69dc92216] FROM [##64a358efce3143fcae2fe0d2160ecf13] ORDER BY CheckDate DESC, CheckID ASC 时间: 2021-01-18 14:57:38,349 线程ID: 66 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##5945f309da784e899221aa1695958a44] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-18 14:57:38,355 线程ID: 66 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##5945f309da784e899221aa1695958a44] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##5945f309da784e899221aa1695958a44 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##a561bd5a854149f6a6dc5ad01adef2bb] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-18 14:57:38,465 线程ID: 66 日志级别: 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.[c03db129-1394-4101-8715-6a0c70d0a1be] FROM [##5945f309da784e899221aa1695958a44] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-18 14:57:47,031 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##c32c1d4e4157409ea21faec76a3ca338] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-18 14:57:47,034 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##c32c1d4e4157409ea21faec76a3ca338] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##c32c1d4e4157409ea21faec76a3ca338 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##47e1c93d809f43d7b8687757f56eb289] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-18 14:57:47,117 线程ID: 83 日志级别: 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.[c03db129-1394-4101-8715-6a0c70d0a1be] FROM [##c32c1d4e4157409ea21faec76a3ca338] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-18 14:57:50,965 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##a202697fa4994ad6b49339371d767816] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-18 14:57:50,968 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##a202697fa4994ad6b49339371d767816] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##a202697fa4994ad6b49339371d767816 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##ffc5919766684b41a3ed07fdebefc61c] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-18 14:57:51,080 线程ID: 83 日志级别: 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.[c03db129-1394-4101-8715-6a0c70d0a1be] FROM [##a202697fa4994ad6b49339371d767816] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-18 21:42:38,995 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##6071e640442242798d3d02438aadf86f] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-18 21:42:38,998 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##6071e640442242798d3d02438aadf86f] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##6071e640442242798d3d02438aadf86f WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##9339a219271d4a16892d9e0b7e35c7c2] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-18 21:42:39,098 线程ID: 60 日志级别: 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.[c03db129-1394-4101-8715-6a0c70d0a1be] FROM [##6071e640442242798d3d02438aadf86f] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-18 21:44:04,656 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##ce94f3143fc540edb722d68cd4767d6a] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-18 21:44:04,659 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##ce94f3143fc540edb722d68cd4767d6a] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##ce94f3143fc540edb722d68cd4767d6a WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##0256cdd0c6be4b149321b41d250e3e19] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-18 21:44:04,759 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[c03db129-1394-4101-8715-6a0c70d0a1be] FROM [##ce94f3143fc540edb722d68cd4767d6a] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-18 21:44:49,463 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SaleType='线上发货' FROM [##059b020735524686b0a3791f55bb0d36] A WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' UPDATE [##059b020735524686b0a3791f55bb0d36] SET SaleType='正常销售' WHERE SaleType='正常' OR SaleType IS NULL OR SaleType = '' DELETE FROM [##059b020735524686b0a3791f55bb0d36] WHERE 1=1 AND NOT EXISTS(SELECT 1 FROM ##3cef79f97d98482287cf0aaeaabfdda1 B WHERE B.data = SaleType) 时间: 2021-01-18 21:44:49,469 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE [##059b020735524686b0a3791f55bb0d36] DROP COLUMN SaleType, OnlineSaleTypeID, RetailOrderID 时间: 2021-01-18 21:44:49,470 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##059b020735524686b0a3791f55bb0d36] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'ShopCheck2' AND A.CheckID = BillNo ) 时间: 2021-01-18 21:44:49,474 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##059b020735524686b0a3791f55bb0d36] A INNER JOIN ( SELECT A.CheckID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.DiscountPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(GDP.DpPriceByRetail,0) ) As DpAmount FROM [vn_CheckGoods] A INNER JOIN vn_Check B ON A.CheckID = B.CheckID LEFT JOIN [Customer] CT ON CT.Customer_ID=B.Customer_ID LEFT JOIN vGoodsDpPrice GDP ON CT.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM ##059b020735524686b0a3791f55bb0d36 WHERE A.CheckID = CheckID ) AND EXISTS (SELECT 1 FROM [##70077bd84e414dd5b21e9921b611a471] WHERE Goods_No = A.Goods_No) GROUP BY A.CheckID ) B ON A.CheckID = B.CheckID 时间: 2021-01-18 21:44:49,526 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT * INTO [##dc3d0daccf774b70900390c438c9f0e0] FROM [##059b020735524686b0a3791f55bb0d36] 时间: 2021-01-18 21:44:49,540 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CheckID AS [单号], Manual_ID AS [手工单号], CheckDate AS [日期] , Customer_ID AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [生意额] , JiZhang AS [记账状态#记账], JzOperator AS [记账状态#记账人], JzDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人],PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[6316a338-d316-47d1-a47f-39d69dc92216] FROM [##dc3d0daccf774b70900390c438c9f0e0] ORDER BY CheckDate DESC, CheckID ASC 时间: 2021-01-18 21:45:21,816 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##e3c4327b17e24d5185508263d1e1cb0f] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CMoveOut' AND A.ShopToutID = BillNo ) 时间: 2021-01-18 21:45:21,822 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##e3c4327b17e24d5185508263d1e1cb0f] SET IsForWay = 1 WHERE NOT Exists( SELECT ShopToutID FROM ShopTin WHERE 1 = 1 AND [##e3c4327b17e24d5185508263d1e1cb0f].ShopToutID = ShopToutID) 时间: 2021-01-18 21:45:21,824 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##e3c4327b17e24d5185508263d1e1cb0f] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##e3c4327b17e24d5185508263d1e1cb0f] A INNER JOIN ShopTin B ON A.ShopToutID = B.ShopToutID WHERE 1 = 1 时间: 2021-01-18 21:45:21,827 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##e3c4327b17e24d5185508263d1e1cb0f] A INNER JOIN ( SELECT A.ShopToutID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopToutGoods] A INNER JOIN ShopTout B ON A.ShopToutID = B.ShopToutID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##e3c4327b17e24d5185508263d1e1cb0f WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##6017aa72944c4671b88035e9f3f73828] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2021-01-18 21:45:22,010 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ShopTinQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) FROM [##e3c4327b17e24d5185508263d1e1cb0f] A INNER JOIN ( SELECT A.ShopToutID, SUM(B.Quantity) AS Quantity FROM ShopTin A INNER JOIN [ShopTinSSGoods] B ON A.ShopTinID = B.ShopTinID WHERE EXISTS( SELECT 1 FROM [##e3c4327b17e24d5185508263d1e1cb0f] WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##6017aa72944c4671b88035e9f3f73828] WHERE Goods_No = B.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2021-01-18 21:45:22,143 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##e3c4327b17e24d5185508263d1e1cb0f] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ShopTinQuantity,0) 时间: 2021-01-18 21:45:22,147 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopToutID AS [单号], Manual_ID AS [手工单号], Tout_Date AS [日期] , ShopApplyOutID AS [调出通知单], rtrim(ToutShop) AS [调出渠道编号], ToutShopAbbrev AS [调出渠道简称], rtrim(TinShop) AS [调入渠道编号] , TinShopAbbrev AS [调入渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , ShopTinQuantity AS [业务状态#调入数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[577f39f0-3601-4426-9468-53a80078d85b] FROM [##e3c4327b17e24d5185508263d1e1cb0f] ORDER BY Tout_Date DESC, ShopToutID ASC 时间: 2021-01-18 21:51:58,008 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SaleType='线上发货' FROM [##e1ec21c95a344290856ef25030c103ed] A WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' UPDATE [##e1ec21c95a344290856ef25030c103ed] SET SaleType='正常销售' WHERE SaleType='正常' OR SaleType IS NULL OR SaleType = '' DELETE FROM [##e1ec21c95a344290856ef25030c103ed] WHERE 1=1 AND NOT EXISTS(SELECT 1 FROM ##8b8865111ae24a6ebd5d37761e1b41f9 B WHERE B.data = SaleType) 时间: 2021-01-18 21:51:58,014 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE [##e1ec21c95a344290856ef25030c103ed] DROP COLUMN SaleType, OnlineSaleTypeID, RetailOrderID 时间: 2021-01-18 21:51:58,016 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##e1ec21c95a344290856ef25030c103ed] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'ShopCheck2' AND A.CheckID = BillNo ) 时间: 2021-01-18 21:51:58,019 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##e1ec21c95a344290856ef25030c103ed] A INNER JOIN ( SELECT A.CheckID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.DiscountPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(GDP.DpPriceByRetail,0) ) As DpAmount FROM [vn_CheckGoods] A INNER JOIN vn_Check B ON A.CheckID = B.CheckID LEFT JOIN [Customer] CT ON CT.Customer_ID=B.Customer_ID LEFT JOIN vGoodsDpPrice GDP ON CT.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM ##e1ec21c95a344290856ef25030c103ed WHERE A.CheckID = CheckID ) AND EXISTS (SELECT 1 FROM [##a0e742b466ed4f9cbe7e061844384df4] WHERE Goods_No = A.Goods_No) GROUP BY A.CheckID ) B ON A.CheckID = B.CheckID 时间: 2021-01-18 21:51:58,054 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT * INTO [##373848bb514e4d0ba8135acbd52df64d] FROM [##e1ec21c95a344290856ef25030c103ed] 时间: 2021-01-18 21:51:58,067 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CheckID AS [单号], Manual_ID AS [手工单号], CheckDate AS [日期] , Customer_ID AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [生意额] , JiZhang AS [记账状态#记账], JzOperator AS [记账状态#记账人], JzDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人],PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[6316a338-d316-47d1-a47f-39d69dc92216] FROM [##373848bb514e4d0ba8135acbd52df64d] ORDER BY CheckDate DESC, CheckID ASC 时间: 2021-01-18 21:53:12,137 线程ID: 58 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##fba73ff254f74b84b73345175547c7e3] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-01-18 21:53:12,140 线程ID: 58 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##fba73ff254f74b84b73345175547c7e3] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##fba73ff254f74b84b73345175547c7e3 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##8c3ca63e858c469fa49272abf77f2861] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-01-18 21:53:12,229 线程ID: 58 日志级别: 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.[c03db129-1394-4101-8715-6a0c70d0a1be] FROM [##fba73ff254f74b84b73345175547c7e3] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-01-18 21:54:47,251 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CONVERT(Varchar(20), LogTime,120) AS 日志时间, L.PcID AS 计算机编号,L.PcName AS 计算机名称,L.IP,L.Location AS 区域 , CAST(LogType AS VARCHAR(10)) AS 日志类型,L.Source AS 日志来源, L.UserNo AS 用户编号 ,r.UserName AS 用户名称, L.Module AS 模块名称, L.[Action] AS 操作,L.BillNo AS 单号,L.Message AS 消息 INTO tempdb.dbo.[a3b53386-671e-412f-af00-581b12b5f643] FROM LogData L INNER JOIN [Right] r on r.UserNo= L.UserNo INNER JOIN DictLogType dict on dict.ID= L.LogTypeID WHERE 1=1 AND L.LogTime >= '2021-01-17' AND L.LogTime <= '2021-01-18 23:59:59.999' ORDER BY L.LogTime DESC 时间: 2021-01-18 21:56:41,644 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SaleType='线上发货' FROM [##a7f0318f89154310bc46818c7acabc15] A WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' UPDATE [##a7f0318f89154310bc46818c7acabc15] SET SaleType='正常销售' WHERE SaleType='正常' OR SaleType IS NULL OR SaleType = '' DELETE FROM [##a7f0318f89154310bc46818c7acabc15] WHERE 1=1 AND NOT EXISTS(SELECT 1 FROM ##75939ebf03e44389bd68abc52be9aea3 B WHERE B.data = SaleType) 时间: 2021-01-18 21:56:41,650 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE [##a7f0318f89154310bc46818c7acabc15] DROP COLUMN SaleType, OnlineSaleTypeID, RetailOrderID 时间: 2021-01-18 21:56:41,652 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##a7f0318f89154310bc46818c7acabc15] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'ShopCheck2' AND A.CheckID = BillNo ) 时间: 2021-01-18 21:56:41,655 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##a7f0318f89154310bc46818c7acabc15] A INNER JOIN ( SELECT A.CheckID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.DiscountPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(GDP.DpPriceByRetail,0) ) As DpAmount FROM [vn_CheckGoods] A INNER JOIN vn_Check B ON A.CheckID = B.CheckID LEFT JOIN [Customer] CT ON CT.Customer_ID=B.Customer_ID LEFT JOIN vGoodsDpPrice GDP ON CT.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM ##a7f0318f89154310bc46818c7acabc15 WHERE A.CheckID = CheckID ) AND EXISTS (SELECT 1 FROM [##55e00c6491044ca7b1c1351855f1e56a] WHERE Goods_No = A.Goods_No) GROUP BY A.CheckID ) B ON A.CheckID = B.CheckID 时间: 2021-01-18 21:56:41,694 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT * INTO [##964d69adda3f421b8432aa3e0d23effc] FROM [##a7f0318f89154310bc46818c7acabc15] 时间: 2021-01-18 21:56:41,709 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CheckID AS [单号], Manual_ID AS [手工单号], CheckDate AS [日期] , Customer_ID AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [生意额] , JiZhang AS [记账状态#记账], JzOperator AS [记账状态#记账人], JzDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人],PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[6316a338-d316-47d1-a47f-39d69dc92216] FROM [##964d69adda3f421b8432aa3e0d23effc] ORDER BY CheckDate DESC, CheckID ASC 时间: 2021-01-18 22:05:23,533 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CT.Abbrev AS [渠道简称], SUM(A.Quantity) AS [数量], GS.Category2 AS [二级类别], GS.Range AS [系列], GS.Pattern AS [款型] INTO tempdb.dbo.[e2d2c867-b9e7-4241-ab47-84889e2359a4] FROM ##59d71c2cf3a645a489def4374d2e4aa2 A LEFT JOIN Customer CT ON A.Customer_ID = CT.Customer_ID LEFT JOIN Goods GS ON A.Goods_No = GS.Goods_No LEFT JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID GROUP BY CT.Abbrev, GS.Category2, GS.Range, GS.Pattern ORDER BY CT.Abbrev, GS.Category2, GS.Range, GS.Pattern 时间: 2021-01-18 22:05:28,338 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CT.Abbrev AS [渠道简称], SUM(A.Quantity) AS [数量], GS.Category2 AS [二级类别], GS.Range AS [系列], GS.Pattern AS [款型] INTO tempdb.dbo.[e2d2c867-b9e7-4241-ab47-84889e2359a4] FROM ##09c4727246664ca7b1bca38b07f41d21 A LEFT JOIN Customer CT ON A.Customer_ID = CT.Customer_ID LEFT JOIN Goods GS ON A.Goods_No = GS.Goods_No LEFT JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID GROUP BY CT.Abbrev, GS.Category2, GS.Range, GS.Pattern ORDER BY CT.Abbrev, GS.Category2, GS.Range, GS.Pattern 时间: 2021-01-18 22:05:54,672 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CT.Abbrev AS [渠道简称], SUM(A.Quantity) AS [数量], GS.Category2 AS [二级类别], GS.Range AS [系列], GS.Pattern AS [款型] INTO tempdb.dbo.[e2d2c867-b9e7-4241-ab47-84889e2359a4] FROM ##5ea06663d1f944f1aed7629adfda41b9 A LEFT JOIN Customer CT ON A.Customer_ID = CT.Customer_ID LEFT JOIN Goods GS ON A.Goods_No = GS.Goods_No LEFT JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID GROUP BY CT.Abbrev, GS.Category2, GS.Range, GS.Pattern ORDER BY CT.Abbrev, GS.Category2, GS.Range, GS.Pattern 时间: 2021-01-18 22:06:10,005 线程ID: 58 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CT.Abbrev AS [渠道简称], GS.Range AS [系列], GS.Pattern AS [款型], SUM(A.Quantity) AS [数量] INTO tempdb.dbo.[e2d2c867-b9e7-4241-ab47-84889e2359a4] FROM ##a46a9f3d2356462fad67cf71ed620a43 A LEFT JOIN Customer CT ON A.Customer_ID = CT.Customer_ID LEFT JOIN Goods GS ON A.Goods_No = GS.Goods_No LEFT JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID GROUP BY CT.Abbrev, GS.Range, GS.Pattern ORDER BY CT.Abbrev, GS.Range, GS.Pattern 时间: 2021-01-18 22:08:04,160 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CT.Abbrev AS [渠道简称], GS.Range AS [系列], SUM(A.Quantity) AS [数量] INTO tempdb.dbo.[e2d2c867-b9e7-4241-ab47-84889e2359a4] FROM ##d53d44e6c5434e2c90650cd814a75737 A LEFT JOIN Customer CT ON A.Customer_ID = CT.Customer_ID LEFT JOIN Goods GS ON A.Goods_No = GS.Goods_No LEFT JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID GROUP BY CT.Abbrev, GS.Range ORDER BY CT.Abbrev, GS.Range 时间: 2021-01-18 22:08:37,443 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CT.Abbrev AS [渠道简称], GS.Range AS [系列], SUM(A.Quantity) AS [数量] INTO tempdb.dbo.[e2d2c867-b9e7-4241-ab47-84889e2359a4] FROM ##a3008b47ca384b93847316dba1fe6d5a A LEFT JOIN Customer CT ON A.Customer_ID = CT.Customer_ID LEFT JOIN Goods GS ON A.Goods_No = GS.Goods_No LEFT JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID GROUP BY CT.Abbrev, GS.Range ORDER BY CT.Abbrev, GS.Range 时间: 2021-01-18 22:08:44,339 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CT.Abbrev AS [渠道简称], GS.Range AS [系列], SUM(A.Quantity) AS [数量] INTO tempdb.dbo.[e2d2c867-b9e7-4241-ab47-84889e2359a4] FROM ##f783fae73722455d94154bbaca7a9834 A LEFT JOIN Customer CT ON A.Customer_ID = CT.Customer_ID LEFT JOIN Goods GS ON A.Goods_No = GS.Goods_No LEFT JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID GROUP BY CT.Abbrev, GS.Range ORDER BY CT.Abbrev, GS.Range 时间: 2021-01-18 22:13:33,647 线程ID: 11 日志级别: 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 [##a4746afa3b38435d80f3218ca4343834] FROM ShopTin A, Barcode B, DeliveryDetail C 时间: 2021-01-18 22:13:33,842 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/17', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##b0f3520a73bc4909b295f3ee4ba30d86] 时间: 2021-01-18 22:13:34,022 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/18', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##73b5bba530514ed186ecb6c1d0f4fcb8] 时间: 2021-01-18 22:13:34,200 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/19', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##ca42f2b9a5a849ddb53d602104fd841b] 时间: 2021-01-18 22:13:34,377 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/20', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##34e0248ad8704d59b1eb92186e5e1582] 时间: 2021-01-18 22:13:34,553 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/21', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##179a3d742b3944b0a225fc052af2034b] 时间: 2021-01-18 22:13:34,737 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/22', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##41a84309802244e6a8a844ac607c6475] 时间: 2021-01-18 22:13:34,915 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/23', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##3bfc34b5f0d040b98f51787512555389] 时间: 2021-01-18 22:13:35,091 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/24', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##24de392195f748b68c9a0f9aa6d68ae9] 时间: 2021-01-18 22:13:35,355 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/25', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##d82bad878c744eb5a422bbbbf33d594b] 时间: 2021-01-18 22:13:35,533 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/26', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##0c3e0fb74f8a40c98f366444bdaff4ed] 时间: 2021-01-18 22:13:35,721 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/27', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f4e2bc7c02ea496a9ea0eabc990364d3] 时间: 2021-01-18 22:13:35,899 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/28', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a21e4f8dd86749f0ba9ed13b0aedbb86] 时间: 2021-01-18 22:13:36,079 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/29', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##5b03a9432bba4e9c8031b102b6c03bb3] 时间: 2021-01-18 22:13:36,259 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/30', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##048ca4f3aad641ff91520c4948bfeab4] 时间: 2021-01-18 22:13:36,441 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/31', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a3c94c00522d4507bfc44282f62f30ea] 时间: 2021-01-18 22:13:36,624 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/1', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##7157b04e6aa6486fb2ddaef9c8564560] 时间: 2021-01-18 22:13:36,810 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/2', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##df6f14ba6f414758a9ef0275cc6015cf] 时间: 2021-01-18 22:13:36,988 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/3', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##d5b6890174f14d09b4ce393089c6520c] 时间: 2021-01-18 22:13:37,169 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/4', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##98f9cf6555054e6eae17cccebee3fa05] 时间: 2021-01-18 22:13:37,348 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/5', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##df45b940438a48488142d56ca2693b70] 时间: 2021-01-18 22:13:37,526 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/6', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##38aae58e0fa341da80f649e166c0960b] 时间: 2021-01-18 22:13:37,712 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/7', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##05f0c9100a624b269cad864830002af6] 时间: 2021-01-18 22:13:37,889 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/8', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##cba56599385a4ec0b0df61b6d98a3eed] 时间: 2021-01-18 22:13:38,065 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/9', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##260c531eb23043a0b62b404c27f26a5c] 时间: 2021-01-18 22:13:38,243 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/10', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##236f80d650ae41c4b5e0d1fc2baba960] 时间: 2021-01-18 22:13:38,420 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/11', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##acb617c510ab435c9e29d89cf5b4ad13] 时间: 2021-01-18 22:13:38,598 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/12', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##fd4e17d29c5d45ad8ed429a691ccc135] 时间: 2021-01-18 22:13:38,779 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/13', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##782db9e444ca4898b2a0fa8b44123563] 时间: 2021-01-18 22:13:38,987 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/14', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##15d9fc7ddbf94f3e8acbe6d8eb04708d] 时间: 2021-01-18 22:13:39,197 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/15', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##7b240109fa0347a5a17a7d14e1066ee0] 时间: 2021-01-18 22:13:39,409 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/16', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##0e459e683f744686b7562e3221989bdb] 时间: 2021-01-18 22:13:39,624 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/17', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4206e5387e4c4310bf16c6d06d466800] 时间: 2021-01-18 22:13:39,839 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/18', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##2eff71a81cfd4f178b990ed9958930de] 时间: 2021-01-18 22:13:39,842 线程ID: 11 日志级别: 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 [##67e06bbef823437981fde18c56472b48] 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/17' AND A.Tin_Date <= '2021/1/18' AND EXISTS (SELECT 1 FROM [##c7f5d36a76e9439faf9ad185cd0ab47b] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##3ace73364c234451871d6835d336af0b] WHERE Goods_No = B.Goods_No) GROUP BY A.Tin_Date, A.TinShop, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-18 22:13:39,885 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [入库S1], 入库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##67e06bbef823437981fde18c56472b48] 时间: 2021-01-18 22:13:39,887 线程ID: 11 日志级别: 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 [##7d8aad866d5e4f9b9938f4b7d18556ed] 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/17' AND A.Tout_Date <= '2021/1/18' AND EXISTS (SELECT 1 FROM [##c7f5d36a76e9439faf9ad185cd0ab47b] WHERE Customer_ID = A.ToutShop) AND EXISTS (SELECT 1 FROM [##3ace73364c234451871d6835d336af0b] WHERE Goods_No = B.Goods_No) GROUP BY A.Tout_Date, A.ToutShop, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-18 22:13:39,932 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [出库S1], 出库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##7d8aad866d5e4f9b9938f4b7d18556ed] 时间: 2021-01-18 22:13:39,934 线程ID: 11 日志级别: 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 [##f2ab1eee1d71435481fdc560368f61b1] 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/17' AND A.Return_Date <= '2021/1/18' AND EXISTS (SELECT 1 FROM [##c7f5d36a76e9439faf9ad185cd0ab47b] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##3ace73364c234451871d6835d336af0b] WHERE Goods_No = B.Goods_No) GROUP BY A.Return_Date, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-18 22:13:39,975 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [出库S1], 出库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f2ab1eee1d71435481fdc560368f61b1] 时间: 2021-01-18 22:13:39,977 线程ID: 11 日志级别: 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 [##59d37b37912a4356bd77756fb27c8c4d] 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/17' AND A.CheckDate <= '2021/1/18' AND EXISTS (SELECT 1 FROM [##c7f5d36a76e9439faf9ad185cd0ab47b] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##3ace73364c234451871d6835d336af0b] WHERE Goods_No = B.Goods_No) GROUP BY A.CheckDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-18 22:13:40,030 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [销售S1], 销售数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##59d37b37912a4356bd77756fb27c8c4d] 时间: 2021-01-18 22:13:40,032 线程ID: 11 日志级别: 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 [##0c8ee8ce5381411ab1e3415fa0458d1f] 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/17' AND A.Balance_Date <= '2021/1/18' AND EXISTS (SELECT 1 FROM [##c7f5d36a76e9439faf9ad185cd0ab47b] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##3ace73364c234451871d6835d336af0b] WHERE Goods_No = B.Goods_No) GROUP BY A.Balance_Date, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-18 22:13:40,090 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a4746afa3b38435d80f3218ca4343834] (BillDate, Customer_ID, Goods_No, ColorID, Long, [损益S1], 损益数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##0c8ee8ce5381411ab1e3415fa0458d1f] 时间: 2021-01-18 22:13:40,092 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a4746afa3b38435d80f3218ca4343834 SET 入库吊牌额 = 入库数量 * GS.UnitPrice, 出库吊牌额 = 出库数量 * GS.UnitPrice, 销售吊牌额 = 销售数量 * GS.UnitPrice, 损益吊牌额 = 损益数量 * GS.UnitPrice, 库存吊牌额 = 库存数量 * GS.UnitPrice FROM ##a4746afa3b38435d80f3218ca4343834 A INNER JOIN Goods GS ON GS.Goods_No=A.Goods_No 时间: 2021-01-18 22:13:40,187 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BillDate, Customer_ID, Goods_No, ColorID, Long , SUM(入库数量) AS 入库数量 , SUM(出库数量) AS 出库数量 , SUM(销售数量) AS 销售数量 , SUM(损益数量) AS 损益数量 , SUM(库存数量) AS 库存数量 INTO ##a8ca4d6e78b64e9e92450884c79ebb54 FROM ##a4746afa3b38435d80f3218ca4343834 GROUP BY BillDate, Customer_ID, Goods_No, ColorID, Long 时间: 2021-01-18 22:13:40,267 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.BillDate AS [日期], GS.Range AS [系列], A.Goods_No 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) INTO tempdb.dbo.[db28ce10-5406-437e-89b7-38693a9d108b] FROM [##a8ca4d6e78b64e9e92450884c79ebb54] 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, GS.Range, A.Goods_No ORDER BY A.BillDate, GS.Range, A.Goods_No 时间: 2021-01-18 22:13:49,354 线程ID: 33 日志级别: 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 [##a26a76cda3644d2a9a6c6da8a8b43e6e] FROM ShopTin A, Barcode B, DeliveryDetail C 时间: 2021-01-18 22:13:49,542 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/17', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##67789de72e354f3fa4937774832a56d6] 时间: 2021-01-18 22:13:49,735 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/18', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##67755f1c104a400282ae36d39404a593] 时间: 2021-01-18 22:13:49,914 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/19', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##8395a87cbd2648acb714fca4cffc1136] 时间: 2021-01-18 22:13:50,095 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/20', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##8c8253269b6f4e23aa82156fdefb11c5] 时间: 2021-01-18 22:13:50,273 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/21', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##5771f5887059416e8535d3549d902c40] 时间: 2021-01-18 22:13:50,455 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/22', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f9cfac2a847944b2ba5b34bfc662cea0] 时间: 2021-01-18 22:13:50,635 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/23', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##26baa817ccb24974af5525bbe46862fc] 时间: 2021-01-18 22:13:50,818 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/24', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##29500ee052de4c05b2a80bcb18ce94f1] 时间: 2021-01-18 22:13:50,996 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/25', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##dab0aeae40bf4adaa074c3b99c5475bd] 时间: 2021-01-18 22:13:51,173 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/26', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##67ccffad86bf45f7a6dfb90e1a99b75c] 时间: 2021-01-18 22:13:51,352 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/27', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##52e5fb1c413146aeb869b293edf2296f] 时间: 2021-01-18 22:13:51,529 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/28', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##155f96b044b945898465ca2a0679aeeb] 时间: 2021-01-18 22:13:51,711 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/29', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##739207f561b5414e9ba0196481d60af2] 时间: 2021-01-18 22:13:51,890 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/30', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##490021af3c844fcfb6726bf7c1d7f4c5] 时间: 2021-01-18 22:13:52,067 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2020/12/31', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##70c18a394eb44c27bc0e2184f93028ca] 时间: 2021-01-18 22:13:52,244 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/1', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f0d736595d114cc48d9c34c65889b43b] 时间: 2021-01-18 22:13:52,421 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/2', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##032d110782c840b29e8ee61758dee568] 时间: 2021-01-18 22:13:52,597 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/3', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c17427ff594e49a4853214ff02c8766f] 时间: 2021-01-18 22:13:52,775 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/4', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##78c0fdb18f9c40648ec3bf6bafb24469] 时间: 2021-01-18 22:13:52,951 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/5', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c622d201a72c4033bde68293bbf3eef7] 时间: 2021-01-18 22:13:53,127 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/6', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##b5c69abf3c2a4fb0848b0cf1ced451a8] 时间: 2021-01-18 22:13:53,306 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/7', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##7217a16837604ea99694561c1eccbdcb] 时间: 2021-01-18 22:13:53,482 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/8', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##16cc14aecc9248f5b3b8de97bc71f4fe] 时间: 2021-01-18 22:13:53,661 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/9', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##185a76ec1bb04eba808695588b764e26] 时间: 2021-01-18 22:13:53,841 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/10', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##eb56b38e6cdb442e8ab821b6d9f71a9b] 时间: 2021-01-18 22:13:54,016 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/11', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##7ff7f05ea55142e0896b46662af126ee] 时间: 2021-01-18 22:13:54,193 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/12', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##6314a551c24d4f15b19a4b24afd82c37] 时间: 2021-01-18 22:13:54,369 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/13', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##0fba1a568acf4d448aa275c5dec51b62] 时间: 2021-01-18 22:13:54,580 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/14', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f84a05cee70c429889efb003fe68abd6] 时间: 2021-01-18 22:13:54,796 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/15', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##8f0d9907f68b4747a8f04258b6071f44] 时间: 2021-01-18 22:13:55,004 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/16', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##87e2237afc9a4a05884364820b8372a8] 时间: 2021-01-18 22:13:55,221 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/17', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##19b09c0b0b0a41babd1324c30e6b2712] 时间: 2021-01-18 22:13:55,432 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/18', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##cc28a48ea2ae41e48902616eace67a36] 时间: 2021-01-18 22:13:55,434 线程ID: 33 日志级别: 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 [##4450450e832b4c2ca5c1d4a09093c827] 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/17' AND A.Tin_Date <= '2021/1/18' AND EXISTS (SELECT 1 FROM [##4e7f25d6a7c44ca4b2025fec6b4cf120] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##1d52cf5cb5574daeaf399d1251e3c862] WHERE Goods_No = B.Goods_No) GROUP BY A.Tin_Date, A.TinShop, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-18 22:13:55,478 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [入库S1], 入库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4450450e832b4c2ca5c1d4a09093c827] 时间: 2021-01-18 22:13:55,479 线程ID: 33 日志级别: 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 [##95e78743a7564d68bd899e699c93518c] 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/17' AND A.Tout_Date <= '2021/1/18' AND EXISTS (SELECT 1 FROM [##4e7f25d6a7c44ca4b2025fec6b4cf120] WHERE Customer_ID = A.ToutShop) AND EXISTS (SELECT 1 FROM [##1d52cf5cb5574daeaf399d1251e3c862] WHERE Goods_No = B.Goods_No) GROUP BY A.Tout_Date, A.ToutShop, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-18 22:13:55,524 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [出库S1], 出库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##95e78743a7564d68bd899e699c93518c] 时间: 2021-01-18 22:13:55,525 线程ID: 33 日志级别: 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 [##1c91a0a332244c76b7cffe73e7a1aff0] 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/17' AND A.Return_Date <= '2021/1/18' AND EXISTS (SELECT 1 FROM [##4e7f25d6a7c44ca4b2025fec6b4cf120] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##1d52cf5cb5574daeaf399d1251e3c862] WHERE Goods_No = B.Goods_No) GROUP BY A.Return_Date, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-18 22:13:55,584 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [出库S1], 出库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##1c91a0a332244c76b7cffe73e7a1aff0] 时间: 2021-01-18 22:13:55,586 线程ID: 33 日志级别: 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 [##b6be3c6cf22440e9ba8eda6afcf3b102] 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/17' AND A.CheckDate <= '2021/1/18' AND EXISTS (SELECT 1 FROM [##4e7f25d6a7c44ca4b2025fec6b4cf120] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##1d52cf5cb5574daeaf399d1251e3c862] WHERE Goods_No = B.Goods_No) GROUP BY A.CheckDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-18 22:13:55,660 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [销售S1], 销售数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##b6be3c6cf22440e9ba8eda6afcf3b102] 时间: 2021-01-18 22:13:55,661 线程ID: 33 日志级别: 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 [##97b398ab32b542a187674d83e5ac6aed] 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/17' AND A.Balance_Date <= '2021/1/18' AND EXISTS (SELECT 1 FROM [##4e7f25d6a7c44ca4b2025fec6b4cf120] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##1d52cf5cb5574daeaf399d1251e3c862] WHERE Goods_No = B.Goods_No) GROUP BY A.Balance_Date, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-18 22:13:55,750 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a26a76cda3644d2a9a6c6da8a8b43e6e] (BillDate, Customer_ID, Goods_No, ColorID, Long, [损益S1], 损益数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##97b398ab32b542a187674d83e5ac6aed] 时间: 2021-01-18 22:13:55,753 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a26a76cda3644d2a9a6c6da8a8b43e6e SET 入库吊牌额 = 入库数量 * GS.UnitPrice, 出库吊牌额 = 出库数量 * GS.UnitPrice, 销售吊牌额 = 销售数量 * GS.UnitPrice, 损益吊牌额 = 损益数量 * GS.UnitPrice, 库存吊牌额 = 库存数量 * GS.UnitPrice FROM ##a26a76cda3644d2a9a6c6da8a8b43e6e A INNER JOIN Goods GS ON GS.Goods_No=A.Goods_No 时间: 2021-01-18 22:13:55,861 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BillDate, Customer_ID, Goods_No, ColorID, Long , SUM(入库数量) AS 入库数量 , SUM(出库数量) AS 出库数量 , SUM(销售数量) AS 销售数量 , SUM(损益数量) AS 损益数量 , SUM(库存数量) AS 库存数量 INTO ##cd286d14a25b4893a17b2b68e2d816bb FROM ##a26a76cda3644d2a9a6c6da8a8b43e6e GROUP BY BillDate, Customer_ID, Goods_No, ColorID, Long 时间: 2021-01-18 22:13:55,941 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.BillDate AS [日期], GS.Range 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) INTO tempdb.dbo.[db28ce10-5406-437e-89b7-38693a9d108b] FROM [##cd286d14a25b4893a17b2b68e2d816bb] 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, GS.Range ORDER BY A.BillDate, GS.Range 时间: 2021-01-18 22:14:19,961 线程ID: 16 日志级别: 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 [##392b777611554c5b80371c0556889bf6] FROM ShopTin A, Barcode B, DeliveryDetail C 时间: 2021-01-18 22:14:20,189 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##392b777611554c5b80371c0556889bf6] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/16', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##ecd5f1791c604112ab3616587a2c224d] 时间: 2021-01-18 22:14:20,412 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##392b777611554c5b80371c0556889bf6] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/17', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##5c973878e51e4fc28cf297466f3c4f02] 时间: 2021-01-18 22:14:20,634 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##392b777611554c5b80371c0556889bf6] (BillDate, Customer_ID, Goods_No, ColorID, Long, [库存S1], [库存数量]) SELECT '2021/1/18', Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##3e575572f1e74824bafd7d755b84f787] 时间: 2021-01-18 22:14:20,636 线程ID: 16 日志级别: 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 [##f503b65317b942af9325900b95f490b8] 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/16' AND A.Tin_Date <= '2021/1/18' AND EXISTS (SELECT 1 FROM [##25e00c7231474faf97e6a63b79cebe0c] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##da21e6b0a52741d39269e51c691e9c19] WHERE Goods_No = B.Goods_No) GROUP BY A.Tin_Date, A.TinShop, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-18 22:14:20,679 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##392b777611554c5b80371c0556889bf6] (BillDate, Customer_ID, Goods_No, ColorID, Long, [入库S1], 入库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f503b65317b942af9325900b95f490b8] 时间: 2021-01-18 22:14:20,681 线程ID: 16 日志级别: 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 [##e940ace55fd5477792480ec70ff74f3d] 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/16' AND A.Tout_Date <= '2021/1/18' AND EXISTS (SELECT 1 FROM [##25e00c7231474faf97e6a63b79cebe0c] WHERE Customer_ID = A.ToutShop) AND EXISTS (SELECT 1 FROM [##da21e6b0a52741d39269e51c691e9c19] WHERE Goods_No = B.Goods_No) GROUP BY A.Tout_Date, A.ToutShop, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-18 22:14:20,730 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##392b777611554c5b80371c0556889bf6] (BillDate, Customer_ID, Goods_No, ColorID, Long, [出库S1], 出库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##e940ace55fd5477792480ec70ff74f3d] 时间: 2021-01-18 22:14:20,731 线程ID: 16 日志级别: 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 [##26fee5ddd8114896850778b612a9a7bc] 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/16' AND A.Return_Date <= '2021/1/18' AND EXISTS (SELECT 1 FROM [##25e00c7231474faf97e6a63b79cebe0c] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##da21e6b0a52741d39269e51c691e9c19] WHERE Goods_No = B.Goods_No) GROUP BY A.Return_Date, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-18 22:14:20,771 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##392b777611554c5b80371c0556889bf6] (BillDate, Customer_ID, Goods_No, ColorID, Long, [出库S1], 出库数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##26fee5ddd8114896850778b612a9a7bc] 时间: 2021-01-18 22:14:20,772 线程ID: 16 日志级别: 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 [##251069f7556b4cd7b8c31ab438ee4a87] 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/16' AND A.CheckDate <= '2021/1/18' AND EXISTS (SELECT 1 FROM [##25e00c7231474faf97e6a63b79cebe0c] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##da21e6b0a52741d39269e51c691e9c19] WHERE Goods_No = B.Goods_No) GROUP BY A.CheckDate, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-18 22:14:20,820 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##392b777611554c5b80371c0556889bf6] (BillDate, Customer_ID, Goods_No, ColorID, Long, [销售S1], 销售数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##251069f7556b4cd7b8c31ab438ee4a87] 时间: 2021-01-18 22:14:20,821 线程ID: 16 日志级别: 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 [##4e7281cb089441f5beffbbefdfafc80d] 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/16' AND A.Balance_Date <= '2021/1/18' AND EXISTS (SELECT 1 FROM [##25e00c7231474faf97e6a63b79cebe0c] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##da21e6b0a52741d39269e51c691e9c19] WHERE Goods_No = B.Goods_No) GROUP BY A.Balance_Date, A.Customer_ID, B.Goods_No, C.ColorID, C.Long 时间: 2021-01-18 22:14:20,876 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##392b777611554c5b80371c0556889bf6] (BillDate, Customer_ID, Goods_No, ColorID, Long, [损益S1], 损益数量) SELECT BillDate, Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4e7281cb089441f5beffbbefdfafc80d] 时间: 2021-01-18 22:14:20,878 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##392b777611554c5b80371c0556889bf6 SET 入库吊牌额 = 入库数量 * GS.UnitPrice, 出库吊牌额 = 出库数量 * GS.UnitPrice, 销售吊牌额 = 销售数量 * GS.UnitPrice, 损益吊牌额 = 损益数量 * GS.UnitPrice, 库存吊牌额 = 库存数量 * GS.UnitPrice FROM ##392b777611554c5b80371c0556889bf6 A INNER JOIN Goods GS ON GS.Goods_No=A.Goods_No 时间: 2021-01-18 22:14:20,892 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BillDate, Customer_ID, Goods_No, ColorID, Long , SUM(入库数量) AS 入库数量 , SUM(出库数量) AS 出库数量 , SUM(销售数量) AS 销售数量 , SUM(损益数量) AS 损益数量 , SUM(库存数量) AS 库存数量 INTO ##c65c3d4894c04a8d88c037a6e5483acb FROM ##392b777611554c5b80371c0556889bf6 GROUP BY BillDate, Customer_ID, Goods_No, ColorID, Long 时间: 2021-01-18 22:14:20,907 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.BillDate AS [日期], GS.Range 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) INTO tempdb.dbo.[db28ce10-5406-437e-89b7-38693a9d108b] FROM [##c65c3d4894c04a8d88c037a6e5483acb] 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, GS.Range ORDER BY A.BillDate, GS.Range 时间: 2021-01-18 22:19:00,871 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.PdStockID AS [单号], CONVERT(VARCHAR(10), A.PdStock_Date, 120) AS [单据日期], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], GS.Range AS [系列], GS.Pattern AS [款型], A.Goods_no AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], SUM(A.Quantity) AS [数量], GS.UnitPrice AS [吊牌价], SUM(A.Quantity * GS.UnitPrice) AS [吊牌额] INTO tempdb.dbo.[699b6c2b-de4c-418f-abc8-c3f0f43dfa0d] FROM ##33dadfba9b674699ab578cbf062d5ea5 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 A.PdStockID, CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Range, GS.Pattern, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color, GS.UnitPrice ORDER BY A.PdStockID, CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Range, GS.Pattern, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color, GS.UnitPrice 时间: 2021-01-18 22:23:31,716 线程ID: 55 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.PdStockID AS [单号], CONVERT(VARCHAR(10), A.PdStock_Date, 120) AS [单据日期], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], GS.Range AS [系列], GS.Pattern AS [款型], A.Goods_no AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], SUM(A.Quantity) AS [数量], GS.UnitPrice AS [吊牌价], SUM(A.Quantity * GS.UnitPrice) AS [吊牌额] INTO tempdb.dbo.[699b6c2b-de4c-418f-abc8-c3f0f43dfa0d] FROM ##694ac843906b4f82b5e150611d820918 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 A.PdStockID, CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Range, GS.Pattern, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color, GS.UnitPrice ORDER BY A.PdStockID, CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Range, GS.Pattern, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color, GS.UnitPrice 时间: 2021-01-18 22:24:26,936 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CT.Abbrev AS [渠道简称], SUM(A.Quantity) AS [数量] INTO tempdb.dbo.[699b6c2b-de4c-418f-abc8-c3f0f43dfa0d] FROM ##e233b3b521d04a86a5c1db730c2726b3 A LEFT JOIN Customer CT ON A.Customer_ID = CT.Customer_ID LEFT JOIN Goods GS ON A.Goods_No = GS.Goods_No LEFT JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID GROUP BY CT.Abbrev ORDER BY CT.Abbrev 时间: 2021-01-18 22:25:39,815 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SaleType='线上发货' FROM [##1a95fbbeafbf4594b036bf4884067382] A WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' UPDATE [##1a95fbbeafbf4594b036bf4884067382] SET SaleType='正常销售' WHERE SaleType='正常' OR SaleType IS NULL OR SaleType = '' DELETE FROM [##1a95fbbeafbf4594b036bf4884067382] WHERE 1=1 AND NOT EXISTS(SELECT 1 FROM ##9696be13c41a479fa95d139106263dc4 B WHERE B.data = SaleType) 时间: 2021-01-18 22:25:39,829 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE [##1a95fbbeafbf4594b036bf4884067382] DROP COLUMN SaleType, OnlineSaleTypeID, RetailOrderID 时间: 2021-01-18 22:25:39,831 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##1a95fbbeafbf4594b036bf4884067382] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'ShopCheck2' AND A.CheckID = BillNo ) 时间: 2021-01-18 22:25:39,837 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##1a95fbbeafbf4594b036bf4884067382] A INNER JOIN ( SELECT A.CheckID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.DiscountPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(GDP.DpPriceByRetail,0) ) As DpAmount FROM [vn_CheckGoods] A INNER JOIN vn_Check B ON A.CheckID = B.CheckID LEFT JOIN [Customer] CT ON CT.Customer_ID=B.Customer_ID LEFT JOIN vGoodsDpPrice GDP ON CT.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM ##1a95fbbeafbf4594b036bf4884067382 WHERE A.CheckID = CheckID ) AND EXISTS (SELECT 1 FROM [##7b9d30fc2d4c4acf995356e771eecbb6] WHERE Goods_No = A.Goods_No) GROUP BY A.CheckID ) B ON A.CheckID = B.CheckID 时间: 2021-01-18 22:25:39,909 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT * INTO [##58477892a4e24b55aaa19e464055f726] FROM [##1a95fbbeafbf4594b036bf4884067382] 时间: 2021-01-18 22:25:39,930 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CheckID AS [单号], Manual_ID AS [手工单号], CheckDate AS [日期] , Customer_ID AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [生意额] , JiZhang AS [记账状态#记账], JzOperator AS [记账状态#记账人], JzDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人],PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[6316a338-d316-47d1-a47f-39d69dc92216] FROM [##58477892a4e24b55aaa19e464055f726] ORDER BY CheckDate DESC, CheckID ASC