时间: 2021-04-19 10:30:55,717 线程ID: 70 日志级别: 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.[f3076b28-151d-4acf-82d4-26fe4bb2e98a] FROM [##ae9d6208fdc443639fec6fea4ac712bf] ORDER BY Goods_no 时间: 2021-04-19 10:31:15,362 线程ID: 65 日志级别: 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 [##47c5049cf68548598bb16fcb7caec8fd] FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT 时间: 2021-04-19 10:31:15,684 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##47c5049cf68548598bb16fcb7caec8fd] (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 [##d4bb0c2dbbdd45f0ab74be93cfee98d4] A INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID 时间: 2021-04-19 10:34:04,921 线程ID: 65 日志级别: 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.[b8330eaa-8339-45b7-90e7-3feed3cfccbc] FROM [##fb64bfdbb58a48479a13448838dfd4d7] ORDER BY Goods_no 时间: 2021-04-19 10:34:21,709 线程ID: 67 日志级别: 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 [##6fa32dbbb2ed4065b5a10b9d0bb8b3a6] FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT 时间: 2021-04-19 10:34:22,041 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6fa32dbbb2ed4065b5a10b9d0bb8b3a6] (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 [##cb826231f14e4bd098345d45924559a0] A INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID 时间: 2021-04-19 10:34:23,075 线程ID: 65 日志级别: 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 [##544a921a56c24d5caa334187f653e62f] FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT 时间: 2021-04-19 10:34:23,411 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##544a921a56c24d5caa334187f653e62f] (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 [##ad04a0c194f64640b3a5a4809b412bc5] A INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID 时间: 2021-04-19 10:35:20,507 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##f79508afcf3a4448b15697c2e7c0a792 ADD 销售类型 VARCHAR(50) 时间: 2021-04-19 10:35:20,511 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##f79508afcf3a4448b15697c2e7c0a792 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-04-19 10:35:20,518 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f79508afcf3a4448b15697c2e7c0a792 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-04-19 10:35:20,521 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##f79508afcf3a4448b15697c2e7c0a792 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-04-19 10:35:20,550 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f79508afcf3a4448b15697c2e7c0a792 SET 销售类型='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') AND Status = '退货' 时间: 2021-04-19 10:35:20,552 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f79508afcf3a4448b15697c2e7c0a792 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-04-19 10:35:20,590 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##f79508afcf3a4448b15697c2e7c0a792 时间: 2021-04-19 10:35:39,045 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##bef7ff10ade049e886ba58dcee8d8cff ADD 销售类型 VARCHAR(50) 时间: 2021-04-19 10:35:39,046 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##bef7ff10ade049e886ba58dcee8d8cff a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-04-19 10:35:39,049 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##bef7ff10ade049e886ba58dcee8d8cff SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-04-19 10:35:39,053 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##bef7ff10ade049e886ba58dcee8d8cff a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-04-19 10:35:39,081 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##bef7ff10ade049e886ba58dcee8d8cff SET 销售类型='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') AND Status = '退货' 时间: 2021-04-19 10:35:39,082 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##bef7ff10ade049e886ba58dcee8d8cff SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-04-19 10:35:39,123 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##bef7ff10ade049e886ba58dcee8d8cff 时间: 2021-04-19 10:35:40,476 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##9c22711ab2a5410c8de46c79d0fcbb27 ADD 销售类型 VARCHAR(50) 时间: 2021-04-19 10:35:40,477 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##9c22711ab2a5410c8de46c79d0fcbb27 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-04-19 10:35:40,479 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9c22711ab2a5410c8de46c79d0fcbb27 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-04-19 10:35:40,482 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##9c22711ab2a5410c8de46c79d0fcbb27 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-04-19 10:35:40,511 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9c22711ab2a5410c8de46c79d0fcbb27 SET 销售类型='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') AND Status = '退货' 时间: 2021-04-19 10:35:40,513 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9c22711ab2a5410c8de46c79d0fcbb27 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-04-19 10:35:40,553 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##9c22711ab2a5410c8de46c79d0fcbb27 时间: 2021-04-19 10:46:20,517 线程ID: 79 日志级别: 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.[f3076b28-151d-4acf-82d4-26fe4bb2e98a] FROM [##35d4d82e069748778bc3e6c0fbb598ac] ORDER BY Goods_no 时间: 2021-04-19 10:46:31,607 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##8038d42523704a6d96f4cdc9089a6075 ADD 销售类型 VARCHAR(50) 时间: 2021-04-19 10:46:31,609 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##8038d42523704a6d96f4cdc9089a6075 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-04-19 10:46:31,611 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8038d42523704a6d96f4cdc9089a6075 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-04-19 10:46:31,615 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##8038d42523704a6d96f4cdc9089a6075 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-04-19 10:46:31,650 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8038d42523704a6d96f4cdc9089a6075 SET 销售类型='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') AND Status = '退货' 时间: 2021-04-19 10:46:31,652 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8038d42523704a6d96f4cdc9089a6075 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-04-19 10:46:31,693 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##8038d42523704a6d96f4cdc9089a6075 时间: 2021-04-19 10:46:44,003 线程ID: 80 日志级别: 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 [##b3f4de1607784ad2a267d26fccea7996] FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT 时间: 2021-04-19 10:46:44,317 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b3f4de1607784ad2a267d26fccea7996] (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 [##9055bd2352324c2c82d4ef5c64c85f9c] A INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID 时间: 2021-04-19 11:19:02,067 线程ID: 79 日志级别: 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 [##874e62c5cb3e4332bfd404922102552c] FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT 时间: 2021-04-19 11:19:02,388 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##874e62c5cb3e4332bfd404922102552c] (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 [##32aa01ea50134165b4efbb459148ba84] A INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID 时间: 2021-04-19 11:19:30,674 线程ID: 71 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##8fbaa28f5177447b99d52546ab0c3f8f ADD 销售类型 VARCHAR(50) 时间: 2021-04-19 11:19:30,677 线程ID: 71 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##8fbaa28f5177447b99d52546ab0c3f8f a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-04-19 11:19:30,679 线程ID: 71 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8fbaa28f5177447b99d52546ab0c3f8f SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-04-19 11:19:30,681 线程ID: 71 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##8fbaa28f5177447b99d52546ab0c3f8f a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-04-19 11:19:30,714 线程ID: 71 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8fbaa28f5177447b99d52546ab0c3f8f SET 销售类型='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') AND Status = '退货' 时间: 2021-04-19 11:19:30,716 线程ID: 71 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8fbaa28f5177447b99d52546ab0c3f8f SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-04-19 11:19:30,754 线程ID: 71 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##8fbaa28f5177447b99d52546ab0c3f8f 时间: 2021-04-19 11:21:06,313 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##f2152801ac364d1e95b69e1742ffabf6 ADD 销售类型 VARCHAR(50) 时间: 2021-04-19 11:21:06,315 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##f2152801ac364d1e95b69e1742ffabf6 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-04-19 11:21:06,318 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f2152801ac364d1e95b69e1742ffabf6 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-04-19 11:21:06,321 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##f2152801ac364d1e95b69e1742ffabf6 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-04-19 11:21:06,354 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f2152801ac364d1e95b69e1742ffabf6 SET 销售类型='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') AND Status = '退货' 时间: 2021-04-19 11:21:06,356 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f2152801ac364d1e95b69e1742ffabf6 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-04-19 11:21:06,393 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##f2152801ac364d1e95b69e1742ffabf6 时间: 2021-04-19 11:23:46,614 线程ID: 75 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[b8330eaa-8339-45b7-90e7-3feed3cfccbc] FROM [##aaf9f1534db84060952510226e78b5d5] ORDER BY Goods_no 时间: 2021-04-19 11:24:04,041 线程ID: 74 日志级别: 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.[b8330eaa-8339-45b7-90e7-3feed3cfccbc] FROM [##19e2d1d4e9794cec8f0358f7e9017cf9] ORDER BY Goods_no 时间: 2021-04-19 11:24:05,431 线程ID: 73 日志级别: 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.[b8330eaa-8339-45b7-90e7-3feed3cfccbc] FROM [##e16399caeb7d4ef3a0705f1f299ffa36] ORDER BY Goods_no 时间: 2021-04-19 11:24:07,952 线程ID: 73 日志级别: 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.[b8330eaa-8339-45b7-90e7-3feed3cfccbc] FROM [##1653414b34e749e194b1f795fe307a76] ORDER BY Goods_no 时间: 2021-04-19 11:24:08,109 线程ID: 74 日志级别: 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.[b8330eaa-8339-45b7-90e7-3feed3cfccbc] FROM [##ce0f5343839b4b48b7f34daf961e4fe8] ORDER BY Goods_no 时间: 2021-04-19 11:24:08,350 线程ID: 79 日志级别: 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.[b8330eaa-8339-45b7-90e7-3feed3cfccbc] FROM [##8f9265b81d9947a2ba0aeb23c84aad16] ORDER BY Goods_no 时间: 2021-04-19 11:24:08,513 线程ID: 83 日志级别: 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.[b8330eaa-8339-45b7-90e7-3feed3cfccbc] FROM [##99a9aac8b78049189c46dbb0023b1d53] ORDER BY Goods_no 时间: 2021-04-19 11:24:16,456 线程ID: 78 日志级别: 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 [##bd2e624d6b524b56a9213d7215cac08b] FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT 时间: 2021-04-19 11:24:16,773 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bd2e624d6b524b56a9213d7215cac08b] (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 [##43b1f0742b914c37a23bf287057c8685] A INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID 时间: 2021-04-19 11:24:37,526 线程ID: 75 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##eb7f29f895974755bee9d46c7784a677 ADD 销售类型 VARCHAR(50) 时间: 2021-04-19 11:24:37,527 线程ID: 75 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##eb7f29f895974755bee9d46c7784a677 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-04-19 11:24:37,529 线程ID: 75 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##eb7f29f895974755bee9d46c7784a677 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-04-19 11:24:37,533 线程ID: 75 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##eb7f29f895974755bee9d46c7784a677 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-04-19 11:24:37,565 线程ID: 75 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##eb7f29f895974755bee9d46c7784a677 SET 销售类型='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') AND Status = '退货' 时间: 2021-04-19 11:24:37,567 线程ID: 75 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##eb7f29f895974755bee9d46c7784a677 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-04-19 11:24:37,606 线程ID: 75 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##eb7f29f895974755bee9d46c7784a677 时间: 2021-04-19 11:24:57,127 线程ID: 75 日志级别: 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 [##e6a12aea8f0f4bee9bbee176b56cd52f] FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT 时间: 2021-04-19 11:24:57,440 线程ID: 75 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e6a12aea8f0f4bee9bbee176b56cd52f] (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 [##8b705d258f5548368f3000d8e8c23f93] A INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID 时间: 2021-04-19 11:26:29,502 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##33ec8df5479242f59d11b78aa4b3241b ADD 销售类型 VARCHAR(50) 时间: 2021-04-19 11:26:29,504 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##33ec8df5479242f59d11b78aa4b3241b a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-04-19 11:26:29,506 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##33ec8df5479242f59d11b78aa4b3241b SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-04-19 11:26:29,510 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##33ec8df5479242f59d11b78aa4b3241b a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-04-19 11:26:29,544 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##33ec8df5479242f59d11b78aa4b3241b SET 销售类型='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') AND Status = '退货' 时间: 2021-04-19 11:26:29,546 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##33ec8df5479242f59d11b78aa4b3241b SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-04-19 11:26:29,602 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##33ec8df5479242f59d11b78aa4b3241b 时间: 2021-04-19 11:26:44,344 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##5b3fedf6c46d4af0a1327c5445bebc21 ADD 销售类型 VARCHAR(50) 时间: 2021-04-19 11:26:44,345 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##5b3fedf6c46d4af0a1327c5445bebc21 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-04-19 11:26:44,348 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5b3fedf6c46d4af0a1327c5445bebc21 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-04-19 11:26:44,350 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##5b3fedf6c46d4af0a1327c5445bebc21 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-04-19 11:26:44,386 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5b3fedf6c46d4af0a1327c5445bebc21 SET 销售类型='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') AND Status = '退货' 时间: 2021-04-19 11:26:44,388 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5b3fedf6c46d4af0a1327c5445bebc21 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-04-19 11:26:44,427 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##5b3fedf6c46d4af0a1327c5445bebc21 时间: 2021-04-19 11:27:17,854 线程ID: 79 日志级别: 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 [##b990aa44012d43d2a5a2415dd429adb4] FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT 时间: 2021-04-19 11:27:18,162 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b990aa44012d43d2a5a2415dd429adb4] (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 [##5f72880bd85a424ca3dbfcc85f8daae3] A INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID 时间: 2021-04-19 11:27:41,648 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##9bd7395b1035407fa61c5817b759c4b2 ADD 销售类型 VARCHAR(50) 时间: 2021-04-19 11:27:41,649 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##9bd7395b1035407fa61c5817b759c4b2 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-04-19 11:27:41,651 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9bd7395b1035407fa61c5817b759c4b2 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-04-19 11:27:41,654 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##9bd7395b1035407fa61c5817b759c4b2 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-04-19 11:27:41,687 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9bd7395b1035407fa61c5817b759c4b2 SET 销售类型='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') AND Status = '退货' 时间: 2021-04-19 11:27:41,689 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9bd7395b1035407fa61c5817b759c4b2 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-04-19 11:27:41,727 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##9bd7395b1035407fa61c5817b759c4b2 时间: 2021-04-19 11:27:44,504 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##5b64ce8564184467b2fe556d129f0feb ADD 销售类型 VARCHAR(50) 时间: 2021-04-19 11:27:44,505 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##5b64ce8564184467b2fe556d129f0feb a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-04-19 11:27:44,509 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5b64ce8564184467b2fe556d129f0feb SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-04-19 11:27:44,512 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##5b64ce8564184467b2fe556d129f0feb a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-04-19 11:27:44,544 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5b64ce8564184467b2fe556d129f0feb SET 销售类型='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') AND Status = '退货' 时间: 2021-04-19 11:27:44,546 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5b64ce8564184467b2fe556d129f0feb SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-04-19 11:27:44,584 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##5b64ce8564184467b2fe556d129f0feb 时间: 2021-04-19 11:31:47,338 线程ID: 64 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##0d2286590b9846bebf0d7913609f3c4b] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-04-19 11:31:47,345 线程ID: 64 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##0d2286590b9846bebf0d7913609f3c4b] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##0d2286590b9846bebf0d7913609f3c4b WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##45f33c163edd49a5a4ccb57bc9cba4b8] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-04-19 11:31:47,476 线程ID: 64 日志级别: 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.[69e187db-aecc-4efc-9741-d4b65a536ba2] FROM [##0d2286590b9846bebf0d7913609f3c4b] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-04-19 11:32:08,848 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##792f3d00ef774df0b69b15f6e1440a1a] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-04-19 11:32:08,852 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##792f3d00ef774df0b69b15f6e1440a1a] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##792f3d00ef774df0b69b15f6e1440a1a WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##88598205da57401ba8798795cf0c3e6a] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-04-19 11:32:08,988 线程ID: 82 日志级别: 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.[69e187db-aecc-4efc-9741-d4b65a536ba2] FROM [##792f3d00ef774df0b69b15f6e1440a1a] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-04-19 11:43:46,657 线程ID: 70 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##4408dbc008af4da9b2e16b3007116e53 ADD 销售类型 VARCHAR(50) 时间: 2021-04-19 11:43:46,659 线程ID: 70 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##4408dbc008af4da9b2e16b3007116e53 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-04-19 11:43:46,662 线程ID: 70 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4408dbc008af4da9b2e16b3007116e53 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-04-19 11:43:46,667 线程ID: 70 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##4408dbc008af4da9b2e16b3007116e53 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-04-19 11:43:46,704 线程ID: 70 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4408dbc008af4da9b2e16b3007116e53 SET 销售类型='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') AND Status = '退货' 时间: 2021-04-19 11:43:46,705 线程ID: 70 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4408dbc008af4da9b2e16b3007116e53 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-04-19 11:43:46,747 线程ID: 70 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##4408dbc008af4da9b2e16b3007116e53 时间: 2021-04-19 11:44:00,255 线程ID: 77 日志级别: 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 [##da1225521dd740cbb4a46083ba298f2d] FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT 时间: 2021-04-19 11:44:00,615 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##da1225521dd740cbb4a46083ba298f2d] (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 [##62c0d85475b9482d99a42499f77c06a6] A INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID 时间: 2021-04-19 14:00:32,491 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST([S1] AS INT) AS [盘点数#S1] , CAST([S1] AS INT) AS [账面数#S1] , CAST([S1] AS INT) AS [差异数#S1] , CAST(NULL AS INT) AS 盘点数#数量 , CAST(NULL AS INT) AS 账面数#数量 , CAST(NULL AS INT) AS 差异数#数量 , CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#零售金额 , CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#计划成本金额 , CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#公司计划成本金额 , CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#公司成本金额 , CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#吊牌金额 , CAST(NULL AS DECIMAL(30, 2)) AS 账面数#零售金额 , CAST(NULL AS DECIMAL(30, 2)) AS 账面数#计划成本金额 , CAST(NULL AS DECIMAL(30, 2)) AS 账面数#公司计划成本金额 , CAST(NULL AS DECIMAL(30, 2)) AS 账面数#公司成本金额 , CAST(NULL AS DECIMAL(30, 2)) AS 账面数#吊牌金额 , CAST(NULL AS DECIMAL(30, 2)) AS 差异数#零售金额 , CAST(NULL AS DECIMAL(30, 2)) AS 差异数#计划成本金额 , CAST(NULL AS DECIMAL(30, 2)) AS 差异数#公司计划成本金额 , CAST(NULL AS DECIMAL(30, 2)) AS 差异数#公司成本金额 , CAST(NULL AS DECIMAL(30, 2)) AS 差异数#吊牌金额 INTO [##715c068aae8f43209e9c35b53d00491b] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-04-19 14:00:32,500 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, B.Goods_no, C.Colorid, C.Long , SUM(C.[S1]) AS [S1] INTO ##1fdd8c171b3b4eb48980209bb1e95772 FROM PdStock AS A LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID WHERE A.Type=2 AND PdTimes='三盘' AND A.PdStock_Date='2021/4/17' AND EXISTS (SELECT 1 FROM [##246da17d4efc4d2493082b98dc562e7e] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##8a80a4158f314ef189fe09fd6814f744] WHERE Goods_no = B.Goods_no) GROUP BY A.Customer_id, B.Goods_No, C.ColorID, C.Long 时间: 2021-04-19 14:00:32,520 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##715c068aae8f43209e9c35b53d00491b (Customer_ID, Goods_no, Colorid, Long , [盘点数#S1] , 盘点数#数量) SELECT Customer_ID, Goods_No, ColorID, Long , SUM([S1]) AS [S1] , SUM(ISNULL([S1], 0)) FROM ##1fdd8c171b3b4eb48980209bb1e95772 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2021-04-19 14:00:32,523 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##1fdd8c171b3b4eb48980209bb1e95772 时间: 2021-04-19 14:00:32,526 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, B.Goods_no, C.Colorid, C.Long , SUM(C.[S1]) AS [S1] INTO ##8a8bc7cd12ef4f1e8529576aaf142e2d FROM PdStock AS A LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID WHERE A.Type=2 AND PdTimes='二盘' AND A.PdStock_Date='2021/4/17' AND EXISTS (SELECT 1 FROM [##246da17d4efc4d2493082b98dc562e7e] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##8a80a4158f314ef189fe09fd6814f744] WHERE Goods_no = B.Goods_no) AND RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) NOT IN (SELECT RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) FROM PdStock AS A LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsId=C.PdStockGoodsId WHERE A.Type=2 AND PdTimes='三盘' AND A.PdStock_Date='2021/4/17' AND EXISTS (SELECT 1 FROM [##246da17d4efc4d2493082b98dc562e7e] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##8a80a4158f314ef189fe09fd6814f744] WHERE Goods_no = B.Goods_no) ) GROUP BY A.Customer_id, B.Goods_No, C.ColorID, C.Long 时间: 2021-04-19 14:00:32,566 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##715c068aae8f43209e9c35b53d00491b (Customer_ID, Goods_No, ColorID, Long , [盘点数#S1] , 盘点数#数量) SELECT Customer_ID, Goods_No, ColorID, Long , SUM([S1]) AS [S1] , SUM(ISNULL([S1], 0)) FROM ##8a8bc7cd12ef4f1e8529576aaf142e2d GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2021-04-19 14:00:32,569 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##8a8bc7cd12ef4f1e8529576aaf142e2d 时间: 2021-04-19 14:00:32,570 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, B.Goods_no, C.Colorid, C.Long , SUM(C.[S1]) AS [S1] INTO ##1dd31955b7af41ca8892d933239d289d FROM PdStock AS A LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID WHERE A.Type=2 AND PdTimes='一盘' AND A.PdStock_date='2021/4/17' AND EXISTS (SELECT 1 FROM [##246da17d4efc4d2493082b98dc562e7e] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##8a80a4158f314ef189fe09fd6814f744] WHERE Goods_no = B.Goods_no) AND RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) NOT IN (SELECT RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) FROM PdStock AS A LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID WHERE A.Type=2 AND PdTimes='二盘' AND A.PdStock_date='2021/4/17' AND EXISTS (SELECT 1 FROM [##246da17d4efc4d2493082b98dc562e7e] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##8a80a4158f314ef189fe09fd6814f744] WHERE Goods_no = B.Goods_no) ) AND RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) NOT IN (SELECT RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) FROM PdStock AS A LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID WHERE A.Type=2 AND PdTimes='三盘' AND A.PdStock_date='2021/4/17' AND EXISTS (SELECT 1 FROM [##246da17d4efc4d2493082b98dc562e7e] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##8a80a4158f314ef189fe09fd6814f744] WHERE Goods_no = B.Goods_no) ) GROUP BY A.Customer_id, B.Goods_No, C.ColorID, C.Long 时间: 2021-04-19 14:00:32,643 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##715c068aae8f43209e9c35b53d00491b (Customer_ID, Goods_No, ColorID, Long , [盘点数#S1] , 盘点数#数量) SELECT Customer_ID, Goods_No, ColorID, Long , SUM([S1]) AS [S1] , SUM(ISNULL([S1], 0)) FROM ##1dd31955b7af41ca8892d933239d289d GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2021-04-19 14:00:32,652 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##1dd31955b7af41ca8892d933239d289d 时间: 2021-04-19 14:00:32,942 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##715c068aae8f43209e9c35b53d00491b (Customer_ID, Goods_No, ColorID, Long , [账面数#S1] , 账面数#数量) SELECT Customer_ID, Goods_No, ColorID, Long , SUM([S1]) AS [S1] , SUM(ISNULL([S1], 0)) FROM ##7d6730062f3746db859b26453d1c2839 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2021-04-19 14:00:32,950 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##7d6730062f3746db859b26453d1c2839 时间: 2021-04-19 14:00:32,952 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##715c068aae8f43209e9c35b53d00491b SET 差异数#S1 = ISNULL(账面数#S1, 0) - ISNULL(盘点数#S1, 0), 差异数#数量=ISNULL(盘点数#数量,0)-ISNULL(账面数#数量,0) 时间: 2021-04-19 14:00:32,955 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##715c068aae8f43209e9c35b53d00491b SET 盘点数#吊牌金额=盘点数#数量*G.Unitprice , 账面数#吊牌金额=账面数#数量*G.unitprice , 差异数#吊牌金额=差异数#数量*G.unitprice FROM Goods AS G WHERE ##715c068aae8f43209e9c35b53d00491b.Goods_No=G.Goods_No 时间: 2021-04-19 14:00:32,973 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##715c068aae8f43209e9c35b53d00491b SET 盘点数#计划成本金额=盘点数#数量 * ISNULL(VP.CostPrice, 0) , 账面数#计划成本金额 = 账面数#数量 * ISNULL(VP.CostPrice, 0) , 差异数#计划成本金额 = 差异数#数量 * ISNULL(VP.CostPrice, 0) FROM ##715c068aae8f43209e9c35b53d00491b A INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID LEFT JOIN [vPlan] AS VP ON A.Goods_No=VP.Goods_No 时间: 2021-04-19 14:00:32,988 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##715c068aae8f43209e9c35b53d00491b SET 盘点数#公司计划成本金额=盘点数#数量 * ISNULL(CPYP.CostPrice, 0) , 账面数#公司计划成本金额 = 账面数#数量 * ISNULL(CPYP.CostPrice, 0) , 差异数#公司计划成本金额 = 差异数#数量 * ISNULL(CPYP.CostPrice, 0) FROM ##715c068aae8f43209e9c35b53d00491b A INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID LEFT JOIN CompanyCostPlan CPYP ON CPYP.Company_ID = CT.Company_ID AND CPYP.Goods_No = A.Goods_No 时间: 2021-04-19 14:02:15,647 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##2d4365c49aa748baad62daff90f5f93e] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2021-04-19 14:02:15,653 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##2d4365c49aa748baad62daff90f5f93e] 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 ##2d4365c49aa748baad62daff90f5f93e WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##c451316b9b7a4e5c90a86a82ff1b482f] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2021-04-19 14:02:15,818 线程ID: 31 日志级别: 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.[7099ff15-0652-4f68-8a2b-7b2a096b7e4a] FROM [##2d4365c49aa748baad62daff90f5f93e] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2021-04-19 14:05:18,585 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##275607da990045568d5667b8f13608d5] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2021-04-19 14:05:18,588 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##275607da990045568d5667b8f13608d5] 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 ##275607da990045568d5667b8f13608d5 WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##9094eecfd9b4456fabdb30779c447776] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2021-04-19 14:05:18,752 线程ID: 36 日志级别: 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.[f1db2988-d7b8-45d0-b44e-4ad8c7408840] FROM [##275607da990045568d5667b8f13608d5] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2021-04-19 14:06:11,774 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: select top 0 cast('' as varchar(50)) as 发生日期, CAST('' AS VARCHAR(20)) as 操作类型,CAST('' AS VARCHAR(50)) as 单据类型 , cast('' as varCHAR(max)) as 对应单位 ,cast('' as varCHAR(max)) as 对应单位简称,cast('' as varCHAR(max)) as 单号,cast('' as varCHAR(max)) as 手工单号, cast('' as varCHAR(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型,cast('' AS VARCHAR(50)) 零售订单号, cast('' AS VARCHAR(50)) 预售零售订单号,cast('' AS VARCHAR(50)) 货号,cast('' AS VARCHAR(50)) 品名,CAST('' AS VARCHAR(20)) as 颜色, cast('' AS VARCHAR(50)) as 颜色说明,CAST('' AS VARCHAR(20)) as 内长 , CAST(0 AS INT) AS [S1] , CAST('' AS INT) AS 数量 INTO ##56a4eba962fe4c13a3c0d63f52b8a771 from Goods 时间: 2021-04-19 14:06:11,777 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##56a4eba962fe4c13a3c0d63f52b8a771 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型, CAST('店铺收货' AS VARCHAR(20)) as 单据类型, CAST(a.fmwarehouse_no AS VARCHAR(50)) as 对应单位, CAST(w.Warehouse_Na AS VARCHAR(50)) AS 对应单位简称,a.ShopTinid as 单号, CAST(a.manual_id AS VARCHAR(50)) as 手工单号,cast(a.Remark as varchar(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型, cast('' AS VARCHAR(50)) 零售订单号,cast('' AS VARCHAR(50)) 预售零售订单号,b.goods_no as 货号,goods.goods_name as 品名, CAST(c.colorid AS VARCHAR(20)) as 颜色,vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.fmwarehouse_no where a.type=1 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2011105' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.fmwarehouse_no, w.Warehouse_Na,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:11,789 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##56a4eba962fe4c13a3c0d63f52b8a771 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺调入' as 单据类型,a.toutshop as 对应单位, co.Abbrev AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer co ON co.Customer_ID = a.TOutShop where a.type=2 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2011105' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.toutshop,co.Abbrev,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:11,805 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##56a4eba962fe4c13a3c0d63f52b8a771 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺采购收货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明, c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.type=3 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2011105' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.supply_no, s.Supply_Abv,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:11,818 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##56a4eba962fe4c13a3c0d63f52b8a771 select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺退货' as 单据类型,a.warehouse_no as 对应单位, w.Warehouse_Na AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.Warehouse_No where a.posted=1 AND (ISNULL(a.Type,'')='' OR a.Type=1) and a.customer_ID = 'Z004' and b.goods_No = '2011105' and a.return_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.warehouse_no,w.Warehouse_Na,a.Dealereturnid, a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:11,830 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##56a4eba962fe4c13a3c0d63f52b8a771 select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺采购退货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.posted=1 AND (a.Type=2) and a.customer_ID = 'Z004' and b.goods_No = '2011105' and a.return_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.supply_no,s.Supply_Abv,a.Dealereturnid,a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:11,842 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT CONVERT(VARCHAR(20),a.CheckDate,120) CheckDate ,'减少' HandleType,'店铺零售' DocType ,a.Customer_ID, ct.Abbrev,a.CheckID, a.Manual_ID,CAST(b.SaleTypeID AS VARCHAR) 销售类型,a.RetailOrderID 零售订单号,b.RetailOrderID 预售零售订单号,b.Status 销售状态,cast(a.Remark as varchar(max)) as 备注, b.Goods_No,goods.Goods_Name,c.ColorID,vGoodsColor.color,c.long, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [Quantity] into ##93635da953a84304b55a59ce128f8580 from [vn_Check] as a left join vn_checkgoods as b on a.checkid=b.checkid left join vn_checkdetail as c on b.checkgoodsid=c.checkgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.Customer_ID where a.posted=1 AND NOT EXISTS(SELECT 1 FROM DictSaleType WHERE ID=ISNULL(b.SaleTypeID,0) AND IsAdjustStock=0) and a.customer_ID = 'Z004' and a.customer_id in (select customer_id from customer where mathod='自营' or mathod='专柜' or mathod='加盟' or mathod='代理') and b.goods_No = '2011105' and a.Checkdate < '2021/4/20 0:00:00' group by b.Status,b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.customer_id,ct.Abbrev,a.checkid,a.manual_id,a.checkdate, b.SaleTypeID,a.RetailOrderID,b.RetailOrderID ,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:11,867 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.零售订单号='' FROM ##93635da953a84304b55a59ce128f8580 A WHERE 销售状态='退货' AND EXISTS(SELECT 1 FROM KS2_RetailOrder WHERE RetailOrderID=A.零售订单号 AND ISNULL(SaleTypeID,0) IN (1,2)) 时间: 2021-04-19 14:06:11,871 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##56a4eba962fe4c13a3c0d63f52b8a771 SELECT CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,备注,销售类型,零售订单号,预售零售订单号,Goods_No,Goods_Name,ColorID,color,long, SUM(c.[S1]) AS [S1], sum(Quantity) FROM ##93635da953a84304b55a59ce128f8580 c GROUP BY CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,销售类型,零售订单号,预售零售订单号,备注,Goods_No,Goods_Name,ColorID,color,long 时间: 2021-04-19 14:06:11,875 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##56a4eba962fe4c13a3c0d63f52b8a771 select convert(VARCHAR(20),a.tout_date,120) as 发生日期,'减少' as 操作类型,'店铺调出' as 单据类型,a.tinshop as 对应单位, cti.Abbrev AS 对应单位简称,a.shoptoutid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from shoptout as a left join shoptoutgoods as b on a.shoptoutid=b.shoptoutid left join shoptoutdetail as c on b.shoptoutgoodsid=c.shoptoutgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer cti ON cti.Customer_ID = a.TinShop where a.posted=1 and a.toutshop = 'Z004' and b.goods_No = '2011105' and a.tout_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.tinshop,cti.Abbrev,a.shoptoutid,a.manual_id,a.tout_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:11,892 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##56a4eba962fe4c13a3c0d63f52b8a771 select convert(VARCHAR(20),a.balance_date,120) as 发生日期,'减少' as 操作类型,'店铺损益' as 单据类型,a.customer_id as 对应单位, ct.Abbrev AS 对应单位简称, a.balanceid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from balance as a left join balancegoods as b on a.balanceid=b.balanceid left join balancedetail as c on b.balancegoodsid=c.balancegoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.customer_id where a.posted=1 and a.type=2 and a.customer_ID = 'Z004' and b.goods_No = '2011105' and a.balance_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.customer_id, ct.Abbrev,a.balanceid,a.manual_id,a.balance_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:11,904 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##56a4eba962fe4c13a3c0d63f52b8a771 SET 销售类型=ISNULL(销售类型,'') 时间: 2021-04-19 14:06:11,906 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##56a4eba962fe4c13a3c0d63f52b8a771 a INNER JOIN DictSaleType b ON a.销售类型=CAST(b.ID AS VARCHAR) WHERE a.单据类型 IN('店铺零售','加盟店铺零售') 时间: 2021-04-19 14:06:11,910 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##56a4eba962fe4c13a3c0d63f52b8a771 SET 销售类型='线上发货' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 零售订单号 IS NOT NULL AND 零售订单号 <> '' 时间: 2021-04-19 14:06:11,912 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##56a4eba962fe4c13a3c0d63f52b8a771 SET 销售类型='正常销售' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 销售类型 NOT IN ('预售自提','预售直发','线上发货') 时间: 2021-04-19 14:06:11,913 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: DELETE a FROM ##56a4eba962fe4c13a3c0d63f52b8a771 a WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND a.销售类型 NOT IN('正常销售','预售直发','预售自提') 时间: 2021-04-19 14:06:11,914 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,A.* INTO tempdb.dbo.[0053f085-18a2-4cdf-b3b5-ba0b24d4bac8] FROM ##56a4eba962fe4c13a3c0d63f52b8a771 A INNER JOIN Goods g ON a.货号 = g.Goods_No 时间: 2021-04-19 14:06:22,350 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: select cast('2021/03/17' as varchar(50)) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型,CAST('上期余额' AS VARCHAR(50)) as 单据类型 , cast('' as varCHAR(max)) as 对应单位 ,cast('' as varCHAR(max)) as 对应单位简称,cast('' as varCHAR(max)) as 单号,cast('' as varCHAR(max)) as 手工单号, cast('' as varCHAR(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型,cast('' AS VARCHAR(50)) 零售订单号, cast('' AS VARCHAR(50)) 预售零售订单号,c.goods_no as 货号,goods.goods_name as 品名,CAST(c.colorid AS VARCHAR(20)) as 颜色, vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长 , SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] INTO ##2d4fe8de504d40a1aa4f2b903168fd16 from [Hcstock#20210317#Z004] c left join [goods] on c.goods_no = goods.goods_no left join vGoodsColor on c.Goods_No = vGoodsColor.Goods_No AND c.colorid = vGoodsColor.colorid where c.goods_no = '2011105' group by c.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long 时间: 2021-04-19 14:06:22,363 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##2d4fe8de504d40a1aa4f2b903168fd16 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型, CAST('店铺收货' AS VARCHAR(20)) as 单据类型, CAST(a.fmwarehouse_no AS VARCHAR(50)) as 对应单位, CAST(w.Warehouse_Na AS VARCHAR(50)) AS 对应单位简称,a.ShopTinid as 单号, CAST(a.manual_id AS VARCHAR(50)) as 手工单号,cast(a.Remark as varchar(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型, cast('' AS VARCHAR(50)) 零售订单号,cast('' AS VARCHAR(50)) 预售零售订单号,b.goods_no as 货号,goods.goods_name as 品名, CAST(c.colorid AS VARCHAR(20)) as 颜色,vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.fmwarehouse_no where a.type=1 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2011105' and a.tin_date > '2021/03/17' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.fmwarehouse_no, w.Warehouse_Na,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:22,375 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##2d4fe8de504d40a1aa4f2b903168fd16 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺调入' as 单据类型,a.toutshop as 对应单位, co.Abbrev AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer co ON co.Customer_ID = a.TOutShop where a.type=2 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2011105' and a.tin_date > '2021/03/17' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.toutshop,co.Abbrev,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:22,387 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##2d4fe8de504d40a1aa4f2b903168fd16 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺采购收货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明, c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.type=3 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2011105' and a.tin_date > '2021/03/17' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.supply_no, s.Supply_Abv,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:22,399 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##2d4fe8de504d40a1aa4f2b903168fd16 select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺退货' as 单据类型,a.warehouse_no as 对应单位, w.Warehouse_Na AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.Warehouse_No where a.posted=1 AND (ISNULL(a.Type,'')='' OR a.Type=1) and a.customer_ID = 'Z004' and b.goods_No = '2011105' and a.return_date > '2021/03/17' and a.return_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.warehouse_no,w.Warehouse_Na,a.Dealereturnid, a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:22,411 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##2d4fe8de504d40a1aa4f2b903168fd16 select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺采购退货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.posted=1 AND (a.Type=2) and a.customer_ID = 'Z004' and b.goods_No = '2011105' and a.return_date > '2021/03/17' and a.return_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.supply_no,s.Supply_Abv,a.Dealereturnid,a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:22,421 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT CONVERT(VARCHAR(20),a.CheckDate,120) CheckDate ,'减少' HandleType,'店铺零售' DocType ,a.Customer_ID, ct.Abbrev,a.CheckID, a.Manual_ID,CAST(b.SaleTypeID AS VARCHAR) 销售类型,a.RetailOrderID 零售订单号,b.RetailOrderID 预售零售订单号,b.Status 销售状态,cast(a.Remark as varchar(max)) as 备注, b.Goods_No,goods.Goods_Name,c.ColorID,vGoodsColor.color,c.long, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [Quantity] into ##bafc03acb82a4df7a71647e2c9658f70 from [vn_Check] as a left join vn_checkgoods as b on a.checkid=b.checkid left join vn_checkdetail as c on b.checkgoodsid=c.checkgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.Customer_ID where a.posted=1 AND NOT EXISTS(SELECT 1 FROM DictSaleType WHERE ID=ISNULL(b.SaleTypeID,0) AND IsAdjustStock=0) and a.customer_ID = 'Z004' and a.customer_id in (select customer_id from customer where mathod='自营' or mathod='专柜' or mathod='加盟' or mathod='代理') and b.goods_No = '2011105' and a.Checkdate > '2021/03/17' and a.Checkdate < '2021/4/20 0:00:00' group by b.Status,b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.customer_id,ct.Abbrev,a.checkid,a.manual_id,a.checkdate, b.SaleTypeID,a.RetailOrderID,b.RetailOrderID ,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:22,443 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.零售订单号='' FROM ##bafc03acb82a4df7a71647e2c9658f70 A WHERE 销售状态='退货' AND EXISTS(SELECT 1 FROM KS2_RetailOrder WHERE RetailOrderID=A.零售订单号 AND ISNULL(SaleTypeID,0) IN (1,2)) 时间: 2021-04-19 14:06:22,448 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##2d4fe8de504d40a1aa4f2b903168fd16 SELECT CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,备注,销售类型,零售订单号,预售零售订单号,Goods_No,Goods_Name,ColorID,color,long, SUM(c.[S1]) AS [S1], sum(Quantity) FROM ##bafc03acb82a4df7a71647e2c9658f70 c GROUP BY CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,销售类型,零售订单号,预售零售订单号,备注,Goods_No,Goods_Name,ColorID,color,long 时间: 2021-04-19 14:06:22,451 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##2d4fe8de504d40a1aa4f2b903168fd16 select convert(VARCHAR(20),a.tout_date,120) as 发生日期,'减少' as 操作类型,'店铺调出' as 单据类型,a.tinshop as 对应单位, cti.Abbrev AS 对应单位简称,a.shoptoutid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from shoptout as a left join shoptoutgoods as b on a.shoptoutid=b.shoptoutid left join shoptoutdetail as c on b.shoptoutgoodsid=c.shoptoutgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer cti ON cti.Customer_ID = a.TinShop where a.posted=1 and a.toutshop = 'Z004' and b.goods_No = '2011105' and a.tout_date > '2021/03/17' and a.tout_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.tinshop,cti.Abbrev,a.shoptoutid,a.manual_id,a.tout_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:22,466 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##2d4fe8de504d40a1aa4f2b903168fd16 select convert(VARCHAR(20),a.balance_date,120) as 发生日期,'减少' as 操作类型,'店铺损益' as 单据类型,a.customer_id as 对应单位, ct.Abbrev AS 对应单位简称, a.balanceid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from balance as a left join balancegoods as b on a.balanceid=b.balanceid left join balancedetail as c on b.balancegoodsid=c.balancegoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.customer_id where a.posted=1 and a.type=2 and a.customer_ID = 'Z004' and b.goods_No = '2011105' and a.balance_date > '2021/03/17' and a.balance_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.customer_id, ct.Abbrev,a.balanceid,a.manual_id,a.balance_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:22,478 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2d4fe8de504d40a1aa4f2b903168fd16 SET 销售类型=ISNULL(销售类型,'') 时间: 2021-04-19 14:06:22,480 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##2d4fe8de504d40a1aa4f2b903168fd16 a INNER JOIN DictSaleType b ON a.销售类型=CAST(b.ID AS VARCHAR) WHERE a.单据类型 IN('店铺零售','加盟店铺零售') 时间: 2021-04-19 14:06:22,484 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2d4fe8de504d40a1aa4f2b903168fd16 SET 销售类型='线上发货' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 零售订单号 IS NOT NULL AND 零售订单号 <> '' 时间: 2021-04-19 14:06:22,486 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2d4fe8de504d40a1aa4f2b903168fd16 SET 销售类型='正常销售' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 销售类型 NOT IN ('预售自提','预售直发','线上发货') 时间: 2021-04-19 14:06:22,488 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: DELETE a FROM ##2d4fe8de504d40a1aa4f2b903168fd16 a WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND a.销售类型 NOT IN('正常销售','预售直发','预售自提') 时间: 2021-04-19 14:06:22,489 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,A.* INTO tempdb.dbo.[0053f085-18a2-4cdf-b3b5-ba0b24d4bac8] FROM ##2d4fe8de504d40a1aa4f2b903168fd16 A INNER JOIN Goods g ON a.货号 = g.Goods_No 时间: 2021-04-19 14:06:29,986 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: select cast('2021/03/17' as varchar(50)) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型,CAST('上期余额' AS VARCHAR(50)) as 单据类型 , cast('' as varCHAR(max)) as 对应单位 ,cast('' as varCHAR(max)) as 对应单位简称,cast('' as varCHAR(max)) as 单号,cast('' as varCHAR(max)) as 手工单号, cast('' as varCHAR(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型,cast('' AS VARCHAR(50)) 零售订单号, cast('' AS VARCHAR(50)) 预售零售订单号,c.goods_no as 货号,goods.goods_name as 品名,CAST(c.colorid AS VARCHAR(20)) as 颜色, vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长 , SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] INTO ##c3e4a1e5ce9546d8b657ceccf01c4eb8 from [Hcstock#20210317#Z004] c left join [goods] on c.goods_no = goods.goods_no left join vGoodsColor on c.Goods_No = vGoodsColor.Goods_No AND c.colorid = vGoodsColor.colorid where c.goods_no = '2011105' group by c.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long 时间: 2021-04-19 14:06:29,994 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##c3e4a1e5ce9546d8b657ceccf01c4eb8 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型, CAST('店铺收货' AS VARCHAR(20)) as 单据类型, CAST(a.fmwarehouse_no AS VARCHAR(50)) as 对应单位, CAST(w.Warehouse_Na AS VARCHAR(50)) AS 对应单位简称,a.ShopTinid as 单号, CAST(a.manual_id AS VARCHAR(50)) as 手工单号,cast(a.Remark as varchar(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型, cast('' AS VARCHAR(50)) 零售订单号,cast('' AS VARCHAR(50)) 预售零售订单号,b.goods_no as 货号,goods.goods_name as 品名, CAST(c.colorid AS VARCHAR(20)) as 颜色,vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.fmwarehouse_no where a.type=1 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2011105' and a.tin_date > '2021/03/17' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.fmwarehouse_no, w.Warehouse_Na,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:30,007 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##c3e4a1e5ce9546d8b657ceccf01c4eb8 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺调入' as 单据类型,a.toutshop as 对应单位, co.Abbrev AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer co ON co.Customer_ID = a.TOutShop where a.type=2 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2011105' and a.tin_date > '2021/03/17' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.toutshop,co.Abbrev,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:30,020 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##c3e4a1e5ce9546d8b657ceccf01c4eb8 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺采购收货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明, c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.type=3 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2011105' and a.tin_date > '2021/03/17' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.supply_no, s.Supply_Abv,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:30,031 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##c3e4a1e5ce9546d8b657ceccf01c4eb8 select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺退货' as 单据类型,a.warehouse_no as 对应单位, w.Warehouse_Na AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.Warehouse_No where a.posted=1 AND (ISNULL(a.Type,'')='' OR a.Type=1) and a.customer_ID = 'Z004' and b.goods_No = '2011105' and a.return_date > '2021/03/17' and a.return_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.warehouse_no,w.Warehouse_Na,a.Dealereturnid, a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:30,044 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##c3e4a1e5ce9546d8b657ceccf01c4eb8 select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺采购退货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.posted=1 AND (a.Type=2) and a.customer_ID = 'Z004' and b.goods_No = '2011105' and a.return_date > '2021/03/17' and a.return_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.supply_no,s.Supply_Abv,a.Dealereturnid,a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:30,056 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT CONVERT(VARCHAR(20),a.CheckDate,120) CheckDate ,'减少' HandleType,'店铺零售' DocType ,a.Customer_ID, ct.Abbrev,a.CheckID, a.Manual_ID,CAST(b.SaleTypeID AS VARCHAR) 销售类型,a.RetailOrderID 零售订单号,b.RetailOrderID 预售零售订单号,b.Status 销售状态,cast(a.Remark as varchar(max)) as 备注, b.Goods_No,goods.Goods_Name,c.ColorID,vGoodsColor.color,c.long, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [Quantity] into ##388b6f0c0c3e49e3b95c5c6019c96b8e from [vn_Check] as a left join vn_checkgoods as b on a.checkid=b.checkid left join vn_checkdetail as c on b.checkgoodsid=c.checkgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.Customer_ID where a.posted=1 AND NOT EXISTS(SELECT 1 FROM DictSaleType WHERE ID=ISNULL(b.SaleTypeID,0) AND IsAdjustStock=0) and a.customer_ID = 'Z004' and a.customer_id in (select customer_id from customer where mathod='自营' or mathod='专柜' or mathod='加盟' or mathod='代理') and b.goods_No = '2011105' and a.Checkdate > '2021/03/17' and a.Checkdate < '2021/4/20 0:00:00' group by b.Status,b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.customer_id,ct.Abbrev,a.checkid,a.manual_id,a.checkdate, b.SaleTypeID,a.RetailOrderID,b.RetailOrderID ,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:30,078 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.零售订单号='' FROM ##388b6f0c0c3e49e3b95c5c6019c96b8e A WHERE 销售状态='退货' AND EXISTS(SELECT 1 FROM KS2_RetailOrder WHERE RetailOrderID=A.零售订单号 AND ISNULL(SaleTypeID,0) IN (1,2)) 时间: 2021-04-19 14:06:30,083 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##c3e4a1e5ce9546d8b657ceccf01c4eb8 SELECT CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,备注,销售类型,零售订单号,预售零售订单号,Goods_No,Goods_Name,ColorID,color,long, SUM(c.[S1]) AS [S1], sum(Quantity) FROM ##388b6f0c0c3e49e3b95c5c6019c96b8e c GROUP BY CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,销售类型,零售订单号,预售零售订单号,备注,Goods_No,Goods_Name,ColorID,color,long 时间: 2021-04-19 14:06:30,087 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##c3e4a1e5ce9546d8b657ceccf01c4eb8 select convert(VARCHAR(20),a.tout_date,120) as 发生日期,'减少' as 操作类型,'店铺调出' as 单据类型,a.tinshop as 对应单位, cti.Abbrev AS 对应单位简称,a.shoptoutid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from shoptout as a left join shoptoutgoods as b on a.shoptoutid=b.shoptoutid left join shoptoutdetail as c on b.shoptoutgoodsid=c.shoptoutgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer cti ON cti.Customer_ID = a.TinShop where a.posted=1 and a.toutshop = 'Z004' and b.goods_No = '2011105' and a.tout_date > '2021/03/17' and a.tout_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.tinshop,cti.Abbrev,a.shoptoutid,a.manual_id,a.tout_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:30,103 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##c3e4a1e5ce9546d8b657ceccf01c4eb8 select convert(VARCHAR(20),a.balance_date,120) as 发生日期,'减少' as 操作类型,'店铺损益' as 单据类型,a.customer_id as 对应单位, ct.Abbrev AS 对应单位简称, a.balanceid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from balance as a left join balancegoods as b on a.balanceid=b.balanceid left join balancedetail as c on b.balancegoodsid=c.balancegoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.customer_id where a.posted=1 and a.type=2 and a.customer_ID = 'Z004' and b.goods_No = '2011105' and a.balance_date > '2021/03/17' and a.balance_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.customer_id, ct.Abbrev,a.balanceid,a.manual_id,a.balance_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:30,114 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c3e4a1e5ce9546d8b657ceccf01c4eb8 SET 销售类型=ISNULL(销售类型,'') 时间: 2021-04-19 14:06:30,115 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##c3e4a1e5ce9546d8b657ceccf01c4eb8 a INNER JOIN DictSaleType b ON a.销售类型=CAST(b.ID AS VARCHAR) WHERE a.单据类型 IN('店铺零售','加盟店铺零售') 时间: 2021-04-19 14:06:30,120 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c3e4a1e5ce9546d8b657ceccf01c4eb8 SET 销售类型='线上发货' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 零售订单号 IS NOT NULL AND 零售订单号 <> '' 时间: 2021-04-19 14:06:30,122 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c3e4a1e5ce9546d8b657ceccf01c4eb8 SET 销售类型='正常销售' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 销售类型 NOT IN ('预售自提','预售直发','线上发货') 时间: 2021-04-19 14:06:30,123 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: DELETE a FROM ##c3e4a1e5ce9546d8b657ceccf01c4eb8 a WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND a.销售类型 NOT IN('正常销售','预售直发','预售自提') 时间: 2021-04-19 14:06:30,124 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,A.* INTO tempdb.dbo.[0053f085-18a2-4cdf-b3b5-ba0b24d4bac8] FROM ##c3e4a1e5ce9546d8b657ceccf01c4eb8 A INNER JOIN Goods g ON a.货号 = g.Goods_No 时间: 2021-04-19 14:06:33,628 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: select cast('2021/02/17' as varchar(50)) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型,CAST('上期余额' AS VARCHAR(50)) as 单据类型 , cast('' as varCHAR(max)) as 对应单位 ,cast('' as varCHAR(max)) as 对应单位简称,cast('' as varCHAR(max)) as 单号,cast('' as varCHAR(max)) as 手工单号, cast('' as varCHAR(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型,cast('' AS VARCHAR(50)) 零售订单号, cast('' AS VARCHAR(50)) 预售零售订单号,c.goods_no as 货号,goods.goods_name as 品名,CAST(c.colorid AS VARCHAR(20)) as 颜色, vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长 , SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] INTO ##0b5a85c6a2a741bb977254eafd899b47 from [Hcstock#20210217#Z004] c left join [goods] on c.goods_no = goods.goods_no left join vGoodsColor on c.Goods_No = vGoodsColor.Goods_No AND c.colorid = vGoodsColor.colorid where c.goods_no = '2011105' group by c.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long 时间: 2021-04-19 14:06:33,638 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##0b5a85c6a2a741bb977254eafd899b47 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型, CAST('店铺收货' AS VARCHAR(20)) as 单据类型, CAST(a.fmwarehouse_no AS VARCHAR(50)) as 对应单位, CAST(w.Warehouse_Na AS VARCHAR(50)) AS 对应单位简称,a.ShopTinid as 单号, CAST(a.manual_id AS VARCHAR(50)) as 手工单号,cast(a.Remark as varchar(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型, cast('' AS VARCHAR(50)) 零售订单号,cast('' AS VARCHAR(50)) 预售零售订单号,b.goods_no as 货号,goods.goods_name as 品名, CAST(c.colorid AS VARCHAR(20)) as 颜色,vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.fmwarehouse_no where a.type=1 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2011105' and a.tin_date > '2021/02/17' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.fmwarehouse_no, w.Warehouse_Na,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:33,656 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##0b5a85c6a2a741bb977254eafd899b47 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺调入' as 单据类型,a.toutshop as 对应单位, co.Abbrev AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer co ON co.Customer_ID = a.TOutShop where a.type=2 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2011105' and a.tin_date > '2021/02/17' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.toutshop,co.Abbrev,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:33,671 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##0b5a85c6a2a741bb977254eafd899b47 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺采购收货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明, c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.type=3 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2011105' and a.tin_date > '2021/02/17' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.supply_no, s.Supply_Abv,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:33,684 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##0b5a85c6a2a741bb977254eafd899b47 select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺退货' as 单据类型,a.warehouse_no as 对应单位, w.Warehouse_Na AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.Warehouse_No where a.posted=1 AND (ISNULL(a.Type,'')='' OR a.Type=1) and a.customer_ID = 'Z004' and b.goods_No = '2011105' and a.return_date > '2021/02/17' and a.return_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.warehouse_no,w.Warehouse_Na,a.Dealereturnid, a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:33,695 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##0b5a85c6a2a741bb977254eafd899b47 select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺采购退货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.posted=1 AND (a.Type=2) and a.customer_ID = 'Z004' and b.goods_No = '2011105' and a.return_date > '2021/02/17' and a.return_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.supply_no,s.Supply_Abv,a.Dealereturnid,a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:33,708 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT CONVERT(VARCHAR(20),a.CheckDate,120) CheckDate ,'减少' HandleType,'店铺零售' DocType ,a.Customer_ID, ct.Abbrev,a.CheckID, a.Manual_ID,CAST(b.SaleTypeID AS VARCHAR) 销售类型,a.RetailOrderID 零售订单号,b.RetailOrderID 预售零售订单号,b.Status 销售状态,cast(a.Remark as varchar(max)) as 备注, b.Goods_No,goods.Goods_Name,c.ColorID,vGoodsColor.color,c.long, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [Quantity] into ##484dbd09f3364c37b1f807f26a9e24f0 from [vn_Check] as a left join vn_checkgoods as b on a.checkid=b.checkid left join vn_checkdetail as c on b.checkgoodsid=c.checkgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.Customer_ID where a.posted=1 AND NOT EXISTS(SELECT 1 FROM DictSaleType WHERE ID=ISNULL(b.SaleTypeID,0) AND IsAdjustStock=0) and a.customer_ID = 'Z004' and a.customer_id in (select customer_id from customer where mathod='自营' or mathod='专柜' or mathod='加盟' or mathod='代理') and b.goods_No = '2011105' and a.Checkdate > '2021/02/17' and a.Checkdate < '2021/4/20 0:00:00' group by b.Status,b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.customer_id,ct.Abbrev,a.checkid,a.manual_id,a.checkdate, b.SaleTypeID,a.RetailOrderID,b.RetailOrderID ,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:33,732 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.零售订单号='' FROM ##484dbd09f3364c37b1f807f26a9e24f0 A WHERE 销售状态='退货' AND EXISTS(SELECT 1 FROM KS2_RetailOrder WHERE RetailOrderID=A.零售订单号 AND ISNULL(SaleTypeID,0) IN (1,2)) 时间: 2021-04-19 14:06:33,737 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##0b5a85c6a2a741bb977254eafd899b47 SELECT CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,备注,销售类型,零售订单号,预售零售订单号,Goods_No,Goods_Name,ColorID,color,long, SUM(c.[S1]) AS [S1], sum(Quantity) FROM ##484dbd09f3364c37b1f807f26a9e24f0 c GROUP BY CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,销售类型,零售订单号,预售零售订单号,备注,Goods_No,Goods_Name,ColorID,color,long 时间: 2021-04-19 14:06:33,741 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##0b5a85c6a2a741bb977254eafd899b47 select convert(VARCHAR(20),a.tout_date,120) as 发生日期,'减少' as 操作类型,'店铺调出' as 单据类型,a.tinshop as 对应单位, cti.Abbrev AS 对应单位简称,a.shoptoutid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from shoptout as a left join shoptoutgoods as b on a.shoptoutid=b.shoptoutid left join shoptoutdetail as c on b.shoptoutgoodsid=c.shoptoutgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer cti ON cti.Customer_ID = a.TinShop where a.posted=1 and a.toutshop = 'Z004' and b.goods_No = '2011105' and a.tout_date > '2021/02/17' and a.tout_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.tinshop,cti.Abbrev,a.shoptoutid,a.manual_id,a.tout_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:33,758 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##0b5a85c6a2a741bb977254eafd899b47 select convert(VARCHAR(20),a.balance_date,120) as 发生日期,'减少' as 操作类型,'店铺损益' as 单据类型,a.customer_id as 对应单位, ct.Abbrev AS 对应单位简称, a.balanceid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from balance as a left join balancegoods as b on a.balanceid=b.balanceid left join balancedetail as c on b.balancegoodsid=c.balancegoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.customer_id where a.posted=1 and a.type=2 and a.customer_ID = 'Z004' and b.goods_No = '2011105' and a.balance_date > '2021/02/17' and a.balance_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.customer_id, ct.Abbrev,a.balanceid,a.manual_id,a.balance_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:33,768 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0b5a85c6a2a741bb977254eafd899b47 SET 销售类型=ISNULL(销售类型,'') 时间: 2021-04-19 14:06:33,770 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##0b5a85c6a2a741bb977254eafd899b47 a INNER JOIN DictSaleType b ON a.销售类型=CAST(b.ID AS VARCHAR) WHERE a.单据类型 IN('店铺零售','加盟店铺零售') 时间: 2021-04-19 14:06:33,775 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0b5a85c6a2a741bb977254eafd899b47 SET 销售类型='线上发货' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 零售订单号 IS NOT NULL AND 零售订单号 <> '' 时间: 2021-04-19 14:06:33,777 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0b5a85c6a2a741bb977254eafd899b47 SET 销售类型='正常销售' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 销售类型 NOT IN ('预售自提','预售直发','线上发货') 时间: 2021-04-19 14:06:33,781 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: DELETE a FROM ##0b5a85c6a2a741bb977254eafd899b47 a WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND a.销售类型 NOT IN('正常销售','预售直发','预售自提') 时间: 2021-04-19 14:06:33,782 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,A.* INTO tempdb.dbo.[0053f085-18a2-4cdf-b3b5-ba0b24d4bac8] FROM ##0b5a85c6a2a741bb977254eafd899b47 A INNER JOIN Goods g ON a.货号 = g.Goods_No 时间: 2021-04-19 14:06:36,368 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: select top 0 cast('' as varchar(50)) as 发生日期, CAST('' AS VARCHAR(20)) as 操作类型,CAST('' AS VARCHAR(50)) as 单据类型 , cast('' as varCHAR(max)) as 对应单位 ,cast('' as varCHAR(max)) as 对应单位简称,cast('' as varCHAR(max)) as 单号,cast('' as varCHAR(max)) as 手工单号, cast('' as varCHAR(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型,cast('' AS VARCHAR(50)) 零售订单号, cast('' AS VARCHAR(50)) 预售零售订单号,cast('' AS VARCHAR(50)) 货号,cast('' AS VARCHAR(50)) 品名,CAST('' AS VARCHAR(20)) as 颜色, cast('' AS VARCHAR(50)) as 颜色说明,CAST('' AS VARCHAR(20)) as 内长 , CAST(0 AS INT) AS [S1] , CAST('' AS INT) AS 数量 INTO ##ed2b1f68560f47f1a19bb72f19138d3e from Goods 时间: 2021-04-19 14:06:36,371 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##ed2b1f68560f47f1a19bb72f19138d3e select convert(VARCHAR(20),a.Tin_date,120) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型, CAST('店铺收货' AS VARCHAR(20)) as 单据类型, CAST(a.fmwarehouse_no AS VARCHAR(50)) as 对应单位, CAST(w.Warehouse_Na AS VARCHAR(50)) AS 对应单位简称,a.ShopTinid as 单号, CAST(a.manual_id AS VARCHAR(50)) as 手工单号,cast(a.Remark as varchar(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型, cast('' AS VARCHAR(50)) 零售订单号,cast('' AS VARCHAR(50)) 预售零售订单号,b.goods_no as 货号,goods.goods_name as 品名, CAST(c.colorid AS VARCHAR(20)) as 颜色,vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.fmwarehouse_no where a.type=1 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2011105' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.fmwarehouse_no, w.Warehouse_Na,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:36,384 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##ed2b1f68560f47f1a19bb72f19138d3e select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺调入' as 单据类型,a.toutshop as 对应单位, co.Abbrev AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer co ON co.Customer_ID = a.TOutShop where a.type=2 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2011105' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.toutshop,co.Abbrev,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:36,399 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##ed2b1f68560f47f1a19bb72f19138d3e select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺采购收货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明, c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.type=3 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2011105' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.supply_no, s.Supply_Abv,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:36,412 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##ed2b1f68560f47f1a19bb72f19138d3e select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺退货' as 单据类型,a.warehouse_no as 对应单位, w.Warehouse_Na AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.Warehouse_No where a.posted=1 AND (ISNULL(a.Type,'')='' OR a.Type=1) and a.customer_ID = 'Z004' and b.goods_No = '2011105' and a.return_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.warehouse_no,w.Warehouse_Na,a.Dealereturnid, a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:36,423 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##ed2b1f68560f47f1a19bb72f19138d3e select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺采购退货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.posted=1 AND (a.Type=2) and a.customer_ID = 'Z004' and b.goods_No = '2011105' and a.return_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.supply_no,s.Supply_Abv,a.Dealereturnid,a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:36,434 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT CONVERT(VARCHAR(20),a.CheckDate,120) CheckDate ,'减少' HandleType,'店铺零售' DocType ,a.Customer_ID, ct.Abbrev,a.CheckID, a.Manual_ID,CAST(b.SaleTypeID AS VARCHAR) 销售类型,a.RetailOrderID 零售订单号,b.RetailOrderID 预售零售订单号,b.Status 销售状态,cast(a.Remark as varchar(max)) as 备注, b.Goods_No,goods.Goods_Name,c.ColorID,vGoodsColor.color,c.long, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [Quantity] into ##05dcbdfd645a4740bab6f2027dda4d51 from [vn_Check] as a left join vn_checkgoods as b on a.checkid=b.checkid left join vn_checkdetail as c on b.checkgoodsid=c.checkgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.Customer_ID where a.posted=1 AND NOT EXISTS(SELECT 1 FROM DictSaleType WHERE ID=ISNULL(b.SaleTypeID,0) AND IsAdjustStock=0) and a.customer_ID = 'Z004' and a.customer_id in (select customer_id from customer where mathod='自营' or mathod='专柜' or mathod='加盟' or mathod='代理') and b.goods_No = '2011105' and a.Checkdate < '2021/4/20 0:00:00' group by b.Status,b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.customer_id,ct.Abbrev,a.checkid,a.manual_id,a.checkdate, b.SaleTypeID,a.RetailOrderID,b.RetailOrderID ,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:36,457 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.零售订单号='' FROM ##05dcbdfd645a4740bab6f2027dda4d51 A WHERE 销售状态='退货' AND EXISTS(SELECT 1 FROM KS2_RetailOrder WHERE RetailOrderID=A.零售订单号 AND ISNULL(SaleTypeID,0) IN (1,2)) 时间: 2021-04-19 14:06:36,462 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##ed2b1f68560f47f1a19bb72f19138d3e SELECT CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,备注,销售类型,零售订单号,预售零售订单号,Goods_No,Goods_Name,ColorID,color,long, SUM(c.[S1]) AS [S1], sum(Quantity) FROM ##05dcbdfd645a4740bab6f2027dda4d51 c GROUP BY CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,销售类型,零售订单号,预售零售订单号,备注,Goods_No,Goods_Name,ColorID,color,long 时间: 2021-04-19 14:06:36,466 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##ed2b1f68560f47f1a19bb72f19138d3e select convert(VARCHAR(20),a.tout_date,120) as 发生日期,'减少' as 操作类型,'店铺调出' as 单据类型,a.tinshop as 对应单位, cti.Abbrev AS 对应单位简称,a.shoptoutid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from shoptout as a left join shoptoutgoods as b on a.shoptoutid=b.shoptoutid left join shoptoutdetail as c on b.shoptoutgoodsid=c.shoptoutgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer cti ON cti.Customer_ID = a.TinShop where a.posted=1 and a.toutshop = 'Z004' and b.goods_No = '2011105' and a.tout_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.tinshop,cti.Abbrev,a.shoptoutid,a.manual_id,a.tout_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:36,482 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##ed2b1f68560f47f1a19bb72f19138d3e select convert(VARCHAR(20),a.balance_date,120) as 发生日期,'减少' as 操作类型,'店铺损益' as 单据类型,a.customer_id as 对应单位, ct.Abbrev AS 对应单位简称, a.balanceid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from balance as a left join balancegoods as b on a.balanceid=b.balanceid left join balancedetail as c on b.balancegoodsid=c.balancegoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.customer_id where a.posted=1 and a.type=2 and a.customer_ID = 'Z004' and b.goods_No = '2011105' and a.balance_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.customer_id, ct.Abbrev,a.balanceid,a.manual_id,a.balance_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:36,495 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ed2b1f68560f47f1a19bb72f19138d3e SET 销售类型=ISNULL(销售类型,'') 时间: 2021-04-19 14:06:36,496 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##ed2b1f68560f47f1a19bb72f19138d3e a INNER JOIN DictSaleType b ON a.销售类型=CAST(b.ID AS VARCHAR) WHERE a.单据类型 IN('店铺零售','加盟店铺零售') 时间: 2021-04-19 14:06:36,501 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ed2b1f68560f47f1a19bb72f19138d3e SET 销售类型='线上发货' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 零售订单号 IS NOT NULL AND 零售订单号 <> '' 时间: 2021-04-19 14:06:36,503 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ed2b1f68560f47f1a19bb72f19138d3e SET 销售类型='正常销售' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 销售类型 NOT IN ('预售自提','预售直发','线上发货') 时间: 2021-04-19 14:06:36,504 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: DELETE a FROM ##ed2b1f68560f47f1a19bb72f19138d3e a WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND a.销售类型 NOT IN('正常销售','预售直发','预售自提') 时间: 2021-04-19 14:06:36,507 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,A.* INTO tempdb.dbo.[0053f085-18a2-4cdf-b3b5-ba0b24d4bac8] FROM ##ed2b1f68560f47f1a19bb72f19138d3e A INNER JOIN Goods g ON a.货号 = g.Goods_No 时间: 2021-04-19 14:06:37,734 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: select top 0 cast('' as varchar(50)) as 发生日期, CAST('' AS VARCHAR(20)) as 操作类型,CAST('' AS VARCHAR(50)) as 单据类型 , cast('' as varCHAR(max)) as 对应单位 ,cast('' as varCHAR(max)) as 对应单位简称,cast('' as varCHAR(max)) as 单号,cast('' as varCHAR(max)) as 手工单号, cast('' as varCHAR(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型,cast('' AS VARCHAR(50)) 零售订单号, cast('' AS VARCHAR(50)) 预售零售订单号,cast('' AS VARCHAR(50)) 货号,cast('' AS VARCHAR(50)) 品名,CAST('' AS VARCHAR(20)) as 颜色, cast('' AS VARCHAR(50)) as 颜色说明,CAST('' AS VARCHAR(20)) as 内长 , CAST(0 AS INT) AS [S1] , CAST('' AS INT) AS 数量 INTO ##7b46e369a9c14ae28cddef84601653cc from Goods 时间: 2021-04-19 14:06:37,737 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##7b46e369a9c14ae28cddef84601653cc select convert(VARCHAR(20),a.Tin_date,120) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型, CAST('店铺收货' AS VARCHAR(20)) as 单据类型, CAST(a.fmwarehouse_no AS VARCHAR(50)) as 对应单位, CAST(w.Warehouse_Na AS VARCHAR(50)) AS 对应单位简称,a.ShopTinid as 单号, CAST(a.manual_id AS VARCHAR(50)) as 手工单号,cast(a.Remark as varchar(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型, cast('' AS VARCHAR(50)) 零售订单号,cast('' AS VARCHAR(50)) 预售零售订单号,b.goods_no as 货号,goods.goods_name as 品名, CAST(c.colorid AS VARCHAR(20)) as 颜色,vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.fmwarehouse_no where a.type=1 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2011105' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.fmwarehouse_no, w.Warehouse_Na,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:37,749 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##7b46e369a9c14ae28cddef84601653cc select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺调入' as 单据类型,a.toutshop as 对应单位, co.Abbrev AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer co ON co.Customer_ID = a.TOutShop where a.type=2 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2011105' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.toutshop,co.Abbrev,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:37,762 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##7b46e369a9c14ae28cddef84601653cc select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺采购收货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明, c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.type=3 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2011105' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.supply_no, s.Supply_Abv,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:37,774 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##7b46e369a9c14ae28cddef84601653cc select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺退货' as 单据类型,a.warehouse_no as 对应单位, w.Warehouse_Na AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.Warehouse_No where a.posted=1 AND (ISNULL(a.Type,'')='' OR a.Type=1) and a.customer_ID = 'Z004' and b.goods_No = '2011105' and a.return_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.warehouse_no,w.Warehouse_Na,a.Dealereturnid, a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:37,787 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##7b46e369a9c14ae28cddef84601653cc select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺采购退货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.posted=1 AND (a.Type=2) and a.customer_ID = 'Z004' and b.goods_No = '2011105' and a.return_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.supply_no,s.Supply_Abv,a.Dealereturnid,a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:37,797 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT CONVERT(VARCHAR(20),a.CheckDate,120) CheckDate ,'减少' HandleType,'店铺零售' DocType ,a.Customer_ID, ct.Abbrev,a.CheckID, a.Manual_ID,CAST(b.SaleTypeID AS VARCHAR) 销售类型,a.RetailOrderID 零售订单号,b.RetailOrderID 预售零售订单号,b.Status 销售状态,cast(a.Remark as varchar(max)) as 备注, b.Goods_No,goods.Goods_Name,c.ColorID,vGoodsColor.color,c.long, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [Quantity] into ##f56031d566734b6183c6539e87edb214 from [vn_Check] as a left join vn_checkgoods as b on a.checkid=b.checkid left join vn_checkdetail as c on b.checkgoodsid=c.checkgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.Customer_ID where a.posted=1 AND NOT EXISTS(SELECT 1 FROM DictSaleType WHERE ID=ISNULL(b.SaleTypeID,0) AND IsAdjustStock=0) and a.customer_ID = 'Z004' and a.customer_id in (select customer_id from customer where mathod='自营' or mathod='专柜' or mathod='加盟' or mathod='代理') and b.goods_No = '2011105' and a.Checkdate < '2021/4/20 0:00:00' group by b.Status,b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.customer_id,ct.Abbrev,a.checkid,a.manual_id,a.checkdate, b.SaleTypeID,a.RetailOrderID,b.RetailOrderID ,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:37,821 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.零售订单号='' FROM ##f56031d566734b6183c6539e87edb214 A WHERE 销售状态='退货' AND EXISTS(SELECT 1 FROM KS2_RetailOrder WHERE RetailOrderID=A.零售订单号 AND ISNULL(SaleTypeID,0) IN (1,2)) 时间: 2021-04-19 14:06:37,825 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##7b46e369a9c14ae28cddef84601653cc SELECT CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,备注,销售类型,零售订单号,预售零售订单号,Goods_No,Goods_Name,ColorID,color,long, SUM(c.[S1]) AS [S1], sum(Quantity) FROM ##f56031d566734b6183c6539e87edb214 c GROUP BY CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,销售类型,零售订单号,预售零售订单号,备注,Goods_No,Goods_Name,ColorID,color,long 时间: 2021-04-19 14:06:37,829 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##7b46e369a9c14ae28cddef84601653cc select convert(VARCHAR(20),a.tout_date,120) as 发生日期,'减少' as 操作类型,'店铺调出' as 单据类型,a.tinshop as 对应单位, cti.Abbrev AS 对应单位简称,a.shoptoutid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from shoptout as a left join shoptoutgoods as b on a.shoptoutid=b.shoptoutid left join shoptoutdetail as c on b.shoptoutgoodsid=c.shoptoutgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer cti ON cti.Customer_ID = a.TinShop where a.posted=1 and a.toutshop = 'Z004' and b.goods_No = '2011105' and a.tout_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.tinshop,cti.Abbrev,a.shoptoutid,a.manual_id,a.tout_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:37,843 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##7b46e369a9c14ae28cddef84601653cc select convert(VARCHAR(20),a.balance_date,120) as 发生日期,'减少' as 操作类型,'店铺损益' as 单据类型,a.customer_id as 对应单位, ct.Abbrev AS 对应单位简称, a.balanceid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from balance as a left join balancegoods as b on a.balanceid=b.balanceid left join balancedetail as c on b.balancegoodsid=c.balancegoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.customer_id where a.posted=1 and a.type=2 and a.customer_ID = 'Z004' and b.goods_No = '2011105' and a.balance_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.customer_id, ct.Abbrev,a.balanceid,a.manual_id,a.balance_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 14:06:37,855 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7b46e369a9c14ae28cddef84601653cc SET 销售类型=ISNULL(销售类型,'') 时间: 2021-04-19 14:06:37,856 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##7b46e369a9c14ae28cddef84601653cc a INNER JOIN DictSaleType b ON a.销售类型=CAST(b.ID AS VARCHAR) WHERE a.单据类型 IN('店铺零售','加盟店铺零售') 时间: 2021-04-19 14:06:37,860 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7b46e369a9c14ae28cddef84601653cc SET 销售类型='线上发货' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 零售订单号 IS NOT NULL AND 零售订单号 <> '' 时间: 2021-04-19 14:06:37,862 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7b46e369a9c14ae28cddef84601653cc SET 销售类型='正常销售' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 销售类型 NOT IN ('预售自提','预售直发','线上发货') 时间: 2021-04-19 14:06:37,864 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: DELETE a FROM ##7b46e369a9c14ae28cddef84601653cc a WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND a.销售类型 NOT IN('正常销售','预售直发','预售自提') 时间: 2021-04-19 14:06:37,865 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,A.* INTO tempdb.dbo.[0053f085-18a2-4cdf-b3b5-ba0b24d4bac8] FROM ##7b46e369a9c14ae28cddef84601653cc A INNER JOIN Goods g ON a.货号 = g.Goods_No 时间: 2021-04-19 14:14:41,455 线程ID: 64 日志级别: 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.[b8330eaa-8339-45b7-90e7-3feed3cfccbc] FROM [##568ec9a2737c46d6b797c3e7ebfe428a] ORDER BY Goods_no 时间: 2021-04-19 14:14:44,785 线程ID: 80 日志级别: 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.[b8330eaa-8339-45b7-90e7-3feed3cfccbc] FROM [##f60baf17412943198126b0ea5eb5662a] ORDER BY Goods_no 时间: 2021-04-19 14:14:45,724 线程ID: 80 日志级别: 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.[b8330eaa-8339-45b7-90e7-3feed3cfccbc] FROM [##d79965a775a5459e8663a35186f7fc55] ORDER BY Goods_no 时间: 2021-04-19 14:16:40,345 线程ID: 35 日志级别: 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.[b8330eaa-8339-45b7-90e7-3feed3cfccbc] FROM [##da42299cb1434f3bb7982aea587b4b03] ORDER BY Goods_no 时间: 2021-04-19 14:29:10,898 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST([S1] AS INT) AS [盘点数#S1] , CAST([S1] AS INT) AS [账面数#S1] , CAST([S1] AS INT) AS [差异数#S1] , CAST(NULL AS INT) AS 盘点数#数量 , CAST(NULL AS INT) AS 账面数#数量 , CAST(NULL AS INT) AS 差异数#数量 , CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#零售金额 , CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#计划成本金额 , CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#公司计划成本金额 , CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#公司成本金额 , CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#吊牌金额 , CAST(NULL AS DECIMAL(30, 2)) AS 账面数#零售金额 , CAST(NULL AS DECIMAL(30, 2)) AS 账面数#计划成本金额 , CAST(NULL AS DECIMAL(30, 2)) AS 账面数#公司计划成本金额 , CAST(NULL AS DECIMAL(30, 2)) AS 账面数#公司成本金额 , CAST(NULL AS DECIMAL(30, 2)) AS 账面数#吊牌金额 , CAST(NULL AS DECIMAL(30, 2)) AS 差异数#零售金额 , CAST(NULL AS DECIMAL(30, 2)) AS 差异数#计划成本金额 , CAST(NULL AS DECIMAL(30, 2)) AS 差异数#公司计划成本金额 , CAST(NULL AS DECIMAL(30, 2)) AS 差异数#公司成本金额 , CAST(NULL AS DECIMAL(30, 2)) AS 差异数#吊牌金额 INTO [##393ab566324147f588fc637cc56efc28] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-04-19 14:29:10,902 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, B.Goods_no, C.Colorid, C.Long , SUM(C.[S1]) AS [S1] INTO ##592d7c55937c4f2a987fd804a6fc6aeb FROM PdStock AS A LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID WHERE A.Type=2 AND PdTimes='三盘' AND A.PdStock_Date='2021/4/17' AND EXISTS (SELECT 1 FROM [##0156be2ce026482abb9db4c0b0cb000f] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##75e8cdde36b74afc8fdfae4e92a46d9a] WHERE Goods_no = B.Goods_no) GROUP BY A.Customer_id, B.Goods_No, C.ColorID, C.Long 时间: 2021-04-19 14:29:10,922 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##393ab566324147f588fc637cc56efc28 (Customer_ID, Goods_no, Colorid, Long , [盘点数#S1] , 盘点数#数量) SELECT Customer_ID, Goods_No, ColorID, Long , SUM([S1]) AS [S1] , SUM(ISNULL([S1], 0)) FROM ##592d7c55937c4f2a987fd804a6fc6aeb GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2021-04-19 14:29:10,924 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##592d7c55937c4f2a987fd804a6fc6aeb 时间: 2021-04-19 14:29:10,926 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, B.Goods_no, C.Colorid, C.Long , SUM(C.[S1]) AS [S1] INTO ##687c250b5db845c09f48d2bf17cc9df2 FROM PdStock AS A LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID WHERE A.Type=2 AND PdTimes='二盘' AND A.PdStock_Date='2021/4/17' AND EXISTS (SELECT 1 FROM [##0156be2ce026482abb9db4c0b0cb000f] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##75e8cdde36b74afc8fdfae4e92a46d9a] WHERE Goods_no = B.Goods_no) AND RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) NOT IN (SELECT RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) FROM PdStock AS A LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsId=C.PdStockGoodsId WHERE A.Type=2 AND PdTimes='三盘' AND A.PdStock_Date='2021/4/17' AND EXISTS (SELECT 1 FROM [##0156be2ce026482abb9db4c0b0cb000f] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##75e8cdde36b74afc8fdfae4e92a46d9a] WHERE Goods_no = B.Goods_no) ) GROUP BY A.Customer_id, B.Goods_No, C.ColorID, C.Long 时间: 2021-04-19 14:29:10,965 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##393ab566324147f588fc637cc56efc28 (Customer_ID, Goods_No, ColorID, Long , [盘点数#S1] , 盘点数#数量) SELECT Customer_ID, Goods_No, ColorID, Long , SUM([S1]) AS [S1] , SUM(ISNULL([S1], 0)) FROM ##687c250b5db845c09f48d2bf17cc9df2 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2021-04-19 14:29:10,968 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##687c250b5db845c09f48d2bf17cc9df2 时间: 2021-04-19 14:29:10,969 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, B.Goods_no, C.Colorid, C.Long , SUM(C.[S1]) AS [S1] INTO ##58022bea289d4423829b71699668c9b8 FROM PdStock AS A LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID WHERE A.Type=2 AND PdTimes='一盘' AND A.PdStock_date='2021/4/17' AND EXISTS (SELECT 1 FROM [##0156be2ce026482abb9db4c0b0cb000f] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##75e8cdde36b74afc8fdfae4e92a46d9a] WHERE Goods_no = B.Goods_no) AND RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) NOT IN (SELECT RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) FROM PdStock AS A LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID WHERE A.Type=2 AND PdTimes='二盘' AND A.PdStock_date='2021/4/17' AND EXISTS (SELECT 1 FROM [##0156be2ce026482abb9db4c0b0cb000f] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##75e8cdde36b74afc8fdfae4e92a46d9a] WHERE Goods_no = B.Goods_no) ) AND RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) NOT IN (SELECT RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) FROM PdStock AS A LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID WHERE A.Type=2 AND PdTimes='三盘' AND A.PdStock_date='2021/4/17' AND EXISTS (SELECT 1 FROM [##0156be2ce026482abb9db4c0b0cb000f] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##75e8cdde36b74afc8fdfae4e92a46d9a] WHERE Goods_no = B.Goods_no) ) GROUP BY A.Customer_id, B.Goods_No, C.ColorID, C.Long 时间: 2021-04-19 14:29:11,040 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##393ab566324147f588fc637cc56efc28 (Customer_ID, Goods_No, ColorID, Long , [盘点数#S1] , 盘点数#数量) SELECT Customer_ID, Goods_No, ColorID, Long , SUM([S1]) AS [S1] , SUM(ISNULL([S1], 0)) FROM ##58022bea289d4423829b71699668c9b8 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2021-04-19 14:29:11,050 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##58022bea289d4423829b71699668c9b8 时间: 2021-04-19 14:29:11,356 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##393ab566324147f588fc637cc56efc28 (Customer_ID, Goods_No, ColorID, Long , [账面数#S1] , 账面数#数量) SELECT Customer_ID, Goods_No, ColorID, Long , SUM([S1]) AS [S1] , SUM(ISNULL([S1], 0)) FROM ##93cfdd88fd0c4f16b9b12d586158f2bd GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2021-04-19 14:29:11,365 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##93cfdd88fd0c4f16b9b12d586158f2bd 时间: 2021-04-19 14:29:11,366 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##393ab566324147f588fc637cc56efc28 SET 差异数#S1 = ISNULL(账面数#S1, 0) - ISNULL(盘点数#S1, 0), 差异数#数量=ISNULL(盘点数#数量,0)-ISNULL(账面数#数量,0) 时间: 2021-04-19 14:29:11,369 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##393ab566324147f588fc637cc56efc28 SET 盘点数#吊牌金额=盘点数#数量*G.Unitprice , 账面数#吊牌金额=账面数#数量*G.unitprice , 差异数#吊牌金额=差异数#数量*G.unitprice FROM Goods AS G WHERE ##393ab566324147f588fc637cc56efc28.Goods_No=G.Goods_No 时间: 2021-04-19 14:29:11,384 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##393ab566324147f588fc637cc56efc28 SET 盘点数#计划成本金额=盘点数#数量 * ISNULL(VP.CostPrice, 0) , 账面数#计划成本金额 = 账面数#数量 * ISNULL(VP.CostPrice, 0) , 差异数#计划成本金额 = 差异数#数量 * ISNULL(VP.CostPrice, 0) FROM ##393ab566324147f588fc637cc56efc28 A INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID LEFT JOIN [vPlan] AS VP ON A.Goods_No=VP.Goods_No 时间: 2021-04-19 14:29:11,405 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##393ab566324147f588fc637cc56efc28 SET 盘点数#公司计划成本金额=盘点数#数量 * ISNULL(CPYP.CostPrice, 0) , 账面数#公司计划成本金额 = 账面数#数量 * ISNULL(CPYP.CostPrice, 0) , 差异数#公司计划成本金额 = 差异数#数量 * ISNULL(CPYP.CostPrice, 0) FROM ##393ab566324147f588fc637cc56efc28 A INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID LEFT JOIN CompanyCostPlan CPYP ON CPYP.Company_ID = CT.Company_ID AND CPYP.Goods_No = A.Goods_No 时间: 2021-04-19 15:52:46,698 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##1c19c8c4a5904f66b1ad88d8ab49df85] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2021-04-19 15:52:46,702 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##1c19c8c4a5904f66b1ad88d8ab49df85] 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 ##1c19c8c4a5904f66b1ad88d8ab49df85 WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##453024cad6b943c98aeb7af71cfe48df] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2021-04-19 15:52:46,976 线程ID: 68 日志级别: 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.[a341c6bd-ec09-4fcc-baac-5be0f01460df] FROM [##1c19c8c4a5904f66b1ad88d8ab49df85] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2021-04-19 16:46:49,737 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: select cast('2021/04/17' as varchar(50)) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型,CAST('上期余额' AS VARCHAR(50)) as 单据类型 , cast('' as varCHAR(max)) as 对应单位 ,cast('' as varCHAR(max)) as 对应单位简称,cast('' as varCHAR(max)) as 单号,cast('' as varCHAR(max)) as 手工单号, cast('' as varCHAR(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型,cast('' AS VARCHAR(50)) 零售订单号, cast('' AS VARCHAR(50)) 预售零售订单号,c.goods_no as 货号,goods.goods_name as 品名,CAST(c.colorid AS VARCHAR(20)) as 颜色, vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长 , SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] INTO ##254f3136806a4637a4540732f8326721 from [Hcstock#20210417#Z004] c left join [goods] on c.goods_no = goods.goods_no left join vGoodsColor on c.Goods_No = vGoodsColor.Goods_No AND c.colorid = vGoodsColor.colorid where c.goods_no = '2021228' group by c.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long 时间: 2021-04-19 16:46:49,753 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##254f3136806a4637a4540732f8326721 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型, CAST('店铺收货' AS VARCHAR(20)) as 单据类型, CAST(a.fmwarehouse_no AS VARCHAR(50)) as 对应单位, CAST(w.Warehouse_Na AS VARCHAR(50)) AS 对应单位简称,a.ShopTinid as 单号, CAST(a.manual_id AS VARCHAR(50)) as 手工单号,cast(a.Remark as varchar(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型, cast('' AS VARCHAR(50)) 零售订单号,cast('' AS VARCHAR(50)) 预售零售订单号,b.goods_no as 货号,goods.goods_name as 品名, CAST(c.colorid AS VARCHAR(20)) as 颜色,vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.fmwarehouse_no where a.type=1 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2021228' and a.tin_date > '2021/04/17' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.fmwarehouse_no, w.Warehouse_Na,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 16:46:49,766 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##254f3136806a4637a4540732f8326721 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺调入' as 单据类型,a.toutshop as 对应单位, co.Abbrev AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer co ON co.Customer_ID = a.TOutShop where a.type=2 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2021228' and a.tin_date > '2021/04/17' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.toutshop,co.Abbrev,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 16:46:49,779 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##254f3136806a4637a4540732f8326721 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺采购收货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明, c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.type=3 and a.posted=1 and a.tinshop = 'Z004' and b.goods_No = '2021228' and a.tin_date > '2021/04/17' and a.tin_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.supply_no, s.Supply_Abv,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 16:46:49,792 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##254f3136806a4637a4540732f8326721 select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺退货' as 单据类型,a.warehouse_no as 对应单位, w.Warehouse_Na AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.Warehouse_No where a.posted=1 AND (ISNULL(a.Type,'')='' OR a.Type=1) and a.customer_ID = 'Z004' and b.goods_No = '2021228' and a.return_date > '2021/04/17' and a.return_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.warehouse_no,w.Warehouse_Na,a.Dealereturnid, a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 16:46:49,804 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##254f3136806a4637a4540732f8326721 select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺采购退货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.posted=1 AND (a.Type=2) and a.customer_ID = 'Z004' and b.goods_No = '2021228' and a.return_date > '2021/04/17' and a.return_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.supply_no,s.Supply_Abv,a.Dealereturnid,a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 16:46:49,815 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT CONVERT(VARCHAR(20),a.CheckDate,120) CheckDate ,'减少' HandleType,'店铺零售' DocType ,a.Customer_ID, ct.Abbrev,a.CheckID, a.Manual_ID,CAST(b.SaleTypeID AS VARCHAR) 销售类型,a.RetailOrderID 零售订单号,b.RetailOrderID 预售零售订单号,b.Status 销售状态,cast(a.Remark as varchar(max)) as 备注, b.Goods_No,goods.Goods_Name,c.ColorID,vGoodsColor.color,c.long, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [Quantity] into ##7dd9c8c15bfc4c9d90a1bf62cdb16be3 from [vn_Check] as a left join vn_checkgoods as b on a.checkid=b.checkid left join vn_checkdetail as c on b.checkgoodsid=c.checkgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.Customer_ID where a.posted=1 AND NOT EXISTS(SELECT 1 FROM DictSaleType WHERE ID=ISNULL(b.SaleTypeID,0) AND IsAdjustStock=0) and a.customer_ID = 'Z004' and a.customer_id in (select customer_id from customer where mathod='自营' or mathod='专柜' or mathod='加盟' or mathod='代理') and b.goods_No = '2021228' and a.Checkdate > '2021/04/17' and a.Checkdate < '2021/4/20 0:00:00' group by b.Status,b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.customer_id,ct.Abbrev,a.checkid,a.manual_id,a.checkdate, b.SaleTypeID,a.RetailOrderID,b.RetailOrderID ,cast(a.Remark as varchar(max)) 时间: 2021-04-19 16:46:49,840 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.零售订单号='' FROM ##7dd9c8c15bfc4c9d90a1bf62cdb16be3 A WHERE 销售状态='退货' AND EXISTS(SELECT 1 FROM KS2_RetailOrder WHERE RetailOrderID=A.零售订单号 AND ISNULL(SaleTypeID,0) IN (1,2)) 时间: 2021-04-19 16:46:49,846 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##254f3136806a4637a4540732f8326721 SELECT CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,备注,销售类型,零售订单号,预售零售订单号,Goods_No,Goods_Name,ColorID,color,long, SUM(c.[S1]) AS [S1], sum(Quantity) FROM ##7dd9c8c15bfc4c9d90a1bf62cdb16be3 c GROUP BY CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,销售类型,零售订单号,预售零售订单号,备注,Goods_No,Goods_Name,ColorID,color,long 时间: 2021-04-19 16:46:49,859 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##254f3136806a4637a4540732f8326721 select convert(VARCHAR(20),a.tout_date,120) as 发生日期,'减少' as 操作类型,'店铺调出' as 单据类型,a.tinshop as 对应单位, cti.Abbrev AS 对应单位简称,a.shoptoutid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from shoptout as a left join shoptoutgoods as b on a.shoptoutid=b.shoptoutid left join shoptoutdetail as c on b.shoptoutgoodsid=c.shoptoutgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer cti ON cti.Customer_ID = a.TinShop where a.posted=1 and a.toutshop = 'Z004' and b.goods_No = '2021228' and a.tout_date > '2021/04/17' and a.tout_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.tinshop,cti.Abbrev,a.shoptoutid,a.manual_id,a.tout_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 16:46:49,874 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##254f3136806a4637a4540732f8326721 select convert(VARCHAR(20),a.balance_date,120) as 发生日期,'减少' as 操作类型,'店铺损益' as 单据类型,a.customer_id as 对应单位, ct.Abbrev AS 对应单位简称, a.balanceid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from balance as a left join balancegoods as b on a.balanceid=b.balanceid left join balancedetail as c on b.balancegoodsid=c.balancegoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.customer_id where a.posted=1 and a.type=2 and a.customer_ID = 'Z004' and b.goods_No = '2021228' and a.balance_date > '2021/04/17' and a.balance_date < '2021/4/20 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.customer_id, ct.Abbrev,a.balanceid,a.manual_id,a.balance_date,cast(a.Remark as varchar(max)) 时间: 2021-04-19 16:46:49,891 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##254f3136806a4637a4540732f8326721 SET 销售类型=ISNULL(销售类型,'') 时间: 2021-04-19 16:46:49,892 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##254f3136806a4637a4540732f8326721 a INNER JOIN DictSaleType b ON a.销售类型=CAST(b.ID AS VARCHAR) WHERE a.单据类型 IN('店铺零售','加盟店铺零售') 时间: 2021-04-19 16:46:49,896 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##254f3136806a4637a4540732f8326721 SET 销售类型='线上发货' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 零售订单号 IS NOT NULL AND 零售订单号 <> '' 时间: 2021-04-19 16:46:49,898 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##254f3136806a4637a4540732f8326721 SET 销售类型='正常销售' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 销售类型 NOT IN ('预售自提','预售直发','线上发货') 时间: 2021-04-19 16:46:49,900 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: DELETE a FROM ##254f3136806a4637a4540732f8326721 a WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND a.销售类型 NOT IN('正常销售','预售直发','预售自提') 时间: 2021-04-19 16:46:49,901 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,A.* INTO tempdb.dbo.[94fa4a53-88ea-4395-a359-708779080782] FROM ##254f3136806a4637a4540732f8326721 A INNER JOIN Goods g ON a.货号 = g.Goods_No