时间: 2023-05-22 10:54:38,991 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , 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 [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(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 [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##5f91df11494c4a6cbcd516c97d5d6244] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-05-22 10:54:39,421 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##4a9ca2c3699942f9b6b986363394a060] where 2=2 and ISNULL(S1,0)=0 时间: 2023-05-22 10:54:39,424 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5f91df11494c4a6cbcd516c97d5d6244] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4a9ca2c3699942f9b6b986363394a060] 时间: 2023-05-22 10:54:39,491 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##11db06dd6fd643eeaa21ea420a7620ad a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-05-22 10:54:39,494 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##11db06dd6fd643eeaa21ea420a7620ad SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-05-22 10:54:39,497 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##11db06dd6fd643eeaa21ea420a7620ad 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.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-05-22 10:54:39,527 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##11db06dd6fd643eeaa21ea420a7620ad SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-05-22 10:54:39,529 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##11db06dd6fd643eeaa21ea420a7620ad SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-05-22 10:54:39,532 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5f91df11494c4a6cbcd516c97d5d6244] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##3a5dee9f5b8643568f8cd497efd072d5] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-05-22 10:54:39,549 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[8f3d93bd-d5d7-4204-9dbb-84e1436cb786] FROM ##5f91df11494c4a6cbcd516c97d5d6244 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-05-22 12:26:27,783 线程ID: 44 日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[de302153-3f57-468f-bb5c-a85397f35c05] FROM [##8cf4d5c410f54a7382bec433234e3789] ORDER BY Goods_no 时间: 2023-05-22 12:26:33,462 线程ID: 88 日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[de302153-3f57-468f-bb5c-a85397f35c05] FROM [##e9bf7c7b2d2042fcb0d991e40fe3f8f1] ORDER BY Goods_no 时间: 2023-05-22 12:26:35,670 线程ID: 72 日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[de302153-3f57-468f-bb5c-a85397f35c05] FROM [##5100705d95794ea5a2aca398eccbf681] ORDER BY Goods_no 时间: 2023-05-22 12:28:36,601 线程ID: 67 日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[de302153-3f57-468f-bb5c-a85397f35c05] FROM [##5f22cc7dccd640b8a5a553a6fe6bf7e1] ORDER BY Goods_no 时间: 2023-05-22 12:28:39,613 线程ID: 39 日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[de302153-3f57-468f-bb5c-a85397f35c05] FROM [##e50ffc110b6642aebf99fb1ab299018d] ORDER BY Goods_no 时间: 2023-05-22 12:29:28,195 线程ID: 72 日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[de302153-3f57-468f-bb5c-a85397f35c05] FROM [##5b1f1b52ea8e406e80f43c32fb7a371b] ORDER BY Goods_no 时间: 2023-05-22 12:29:31,571 线程ID: 45 日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[de302153-3f57-468f-bb5c-a85397f35c05] FROM [##1ec16b262ad84f168c81bc56df0e1669] ORDER BY Goods_no 时间: 2023-05-22 12:30:02,456 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , 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 [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(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 [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##06d1cebcc86a47398ea99f0d09209ccd] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-05-22 12:30:02,796 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##75c9d4699c164c538efd93b4639a286c] where 2=2 and ISNULL(S1,0)=0 时间: 2023-05-22 12:30:02,797 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##06d1cebcc86a47398ea99f0d09209ccd] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##75c9d4699c164c538efd93b4639a286c] 时间: 2023-05-22 12:30:02,851 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##d09010b8a19b48109652e3c1c829059e a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-05-22 12:30:02,853 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d09010b8a19b48109652e3c1c829059e SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-05-22 12:30:02,854 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##d09010b8a19b48109652e3c1c829059e 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.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-05-22 12:30:02,883 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d09010b8a19b48109652e3c1c829059e SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-05-22 12:30:02,885 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d09010b8a19b48109652e3c1c829059e SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-05-22 12:30:02,888 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##06d1cebcc86a47398ea99f0d09209ccd] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##2305ff3ab9144f6b9c85e9f2b328b194] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-05-22 12:30:02,892 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[8cc36fa9-b62a-4e39-9d0c-99046aca4e9c] FROM ##06d1cebcc86a47398ea99f0d09209ccd A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-05-22 15:04:13,315 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , 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 [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(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 [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##37014e8cbc614b88992525c3c94f94bc] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-05-22 15:04:13,733 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##62b1ce024d7e47efb514d7a9f97d3986] where 2=2 and ISNULL(S1,0)=0 时间: 2023-05-22 15:04:13,735 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##37014e8cbc614b88992525c3c94f94bc] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##62b1ce024d7e47efb514d7a9f97d3986] 时间: 2023-05-22 15:04:13,802 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##eb7830e2f40443aca5b4732677b3485e a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-05-22 15:04:13,804 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##eb7830e2f40443aca5b4732677b3485e SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-05-22 15:04:13,808 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##eb7830e2f40443aca5b4732677b3485e 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.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-05-22 15:04:13,843 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##eb7830e2f40443aca5b4732677b3485e SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-05-22 15:04:13,845 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##eb7830e2f40443aca5b4732677b3485e SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-05-22 15:04:13,848 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##37014e8cbc614b88992525c3c94f94bc] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##e94772237146432a885defbff05bc152] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-05-22 15:04:13,863 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[8f3d93bd-d5d7-4204-9dbb-84e1436cb786] FROM ##37014e8cbc614b88992525c3c94f94bc A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-05-22 15:10:45,439 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , 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 [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(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 [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##32f155edba9f40e58b2795239e6068a3] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-05-22 15:10:45,848 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##f637bd3332b94d94b6ee9eafb5b798a0] where 2=2 and ISNULL(S1,0)=0 时间: 2023-05-22 15:10:45,850 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##32f155edba9f40e58b2795239e6068a3] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f637bd3332b94d94b6ee9eafb5b798a0] 时间: 2023-05-22 15:10:45,914 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##fd4b3b85f087459496aa36a7af87111e a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-05-22 15:10:45,916 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fd4b3b85f087459496aa36a7af87111e SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-05-22 15:10:45,917 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##fd4b3b85f087459496aa36a7af87111e 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.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-05-22 15:10:45,945 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fd4b3b85f087459496aa36a7af87111e SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-05-22 15:10:45,947 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fd4b3b85f087459496aa36a7af87111e SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-05-22 15:10:45,950 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##32f155edba9f40e58b2795239e6068a3] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##707e4022251c42df9fee5313c450084b] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-05-22 15:10:45,953 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[8f3d93bd-d5d7-4204-9dbb-84e1436cb786] FROM ##32f155edba9f40e58b2795239e6068a3 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-05-22 15:12:30,014 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , 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 [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(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 [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##d4be2afce9574764b4d3a242038e6b5a] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-05-22 15:12:30,385 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##ae7fa622e3cc4685a52f7013e4eb2441] where 2=2 and ISNULL(S1,0)=0 时间: 2023-05-22 15:12:30,387 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d4be2afce9574764b4d3a242038e6b5a] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##ae7fa622e3cc4685a52f7013e4eb2441] 时间: 2023-05-22 15:12:30,444 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##c46d8cfdd7834ca4842b02a896315191 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-05-22 15:12:30,446 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c46d8cfdd7834ca4842b02a896315191 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-05-22 15:12:30,448 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##c46d8cfdd7834ca4842b02a896315191 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.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-05-22 15:12:30,477 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c46d8cfdd7834ca4842b02a896315191 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-05-22 15:12:30,478 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c46d8cfdd7834ca4842b02a896315191 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-05-22 15:12:30,481 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d4be2afce9574764b4d3a242038e6b5a] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##1e18ac6343ef420fa4323ea0db2b45cf] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-05-22 15:12:30,485 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[8f3d93bd-d5d7-4204-9dbb-84e1436cb786] FROM ##d4be2afce9574764b4d3a242038e6b5a A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-05-22 15:29:56,173 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##8adb1cccd1fe4194a5cfcee6cadb2fe2] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##8adb1cccd1fe4194a5cfcee6cadb2fe2] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##8adb1cccd1fe4194a5cfcee6cadb2fe2] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##8adb1cccd1fe4194a5cfcee6cadb2fe2] WHERE A.DeliveryID = DeliveryID ) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##8adb1cccd1fe4194a5cfcee6cadb2fe2] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##8adb1cccd1fe4194a5cfcee6cadb2fe2] WHERE A.Purchase_ID = Purchase_ID ) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##8adb1cccd1fe4194a5cfcee6cadb2fe2] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##8adb1cccd1fe4194a5cfcee6cadb2fe2] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##8adb1cccd1fe4194a5cfcee6cadb2fe2] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2023-05-22 15:29:56,281 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[fa9ffdcb-fa46-41df-ad99-befb0c901ca6] FROM [##8adb1cccd1fe4194a5cfcee6cadb2fe2] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2023-05-22 15:37:29,814 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , 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 [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(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 [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##29349dfc24bf4e2e9641aa4d0dd0a73b] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-05-22 15:37:30,150 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##a3bb5c2c87a74ae2beaf63363b36e17e] where 2=2 and ISNULL(S1,0)=0 时间: 2023-05-22 15:37:30,152 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##29349dfc24bf4e2e9641aa4d0dd0a73b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a3bb5c2c87a74ae2beaf63363b36e17e] 时间: 2023-05-22 15:37:30,206 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b91f5d333d9546f19107fe027c9bf19f a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-05-22 15:37:30,208 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b91f5d333d9546f19107fe027c9bf19f SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-05-22 15:37:30,210 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b91f5d333d9546f19107fe027c9bf19f 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.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-05-22 15:37:30,239 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b91f5d333d9546f19107fe027c9bf19f SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-05-22 15:37:30,240 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b91f5d333d9546f19107fe027c9bf19f SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-05-22 15:37:30,243 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##29349dfc24bf4e2e9641aa4d0dd0a73b] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##09f8fd8a82b9435da98dacd87a614a92] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-05-22 15:37:30,247 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[7a1d751e-b9a2-4ef9-ad51-6616725ea3b8] FROM ##29349dfc24bf4e2e9641aa4d0dd0a73b A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-05-22 16:01:56,690 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##dae8381d4bbc4562bdc58de805120c16] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2023-05-22 16:01:56,696 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##dae8381d4bbc4562bdc58de805120c16] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##dae8381d4bbc4562bdc58de805120c16] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2023-05-22 16:01:56,701 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##dae8381d4bbc4562bdc58de805120c16] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2023-05-22 16:01:56,705 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##dae8381d4bbc4562bdc58de805120c16] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2023-05-22 16:01:56,710 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##dae8381d4bbc4562bdc58de805120c16 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##dae8381d4bbc4562bdc58de805120c16 WHERE A.SortingID = SortingID ) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2023-05-22 16:01:56,723 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##dae8381d4bbc4562bdc58de805120c16 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##dae8381d4bbc4562bdc58de805120c16 WHERE A.OrderID = OrderID ) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2023-05-22 16:01:56,736 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##dae8381d4bbc4562bdc58de805120c16 A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount FROM DeliveryGoods A LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM ##dae8381d4bbc4562bdc58de805120c16 WHERE A.DeliveryID = DeliveryID ) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-05-22 16:01:56,775 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##dae8381d4bbc4562bdc58de805120c16 A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##dae8381d4bbc4562bdc58de805120c16 WHERE B.DeliveryID = DeliveryID ) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-05-22 16:01:56,884 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##dae8381d4bbc4562bdc58de805120c16 A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM ##dae8381d4bbc4562bdc58de805120c16 C WHERE B.DeliveryID = C.DeliveryID ) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-05-22 16:01:56,953 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##dae8381d4bbc4562bdc58de805120c16 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2023-05-22 16:01:56,955 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##dae8381d4bbc4562bdc58de805120c16] A INNER JOIN ( SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo WHERE A.AccBillType = 'WareDelivery' AND EXISTS( SELECT 1 FROM [##dae8381d4bbc4562bdc58de805120c16] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-05-22 16:01:56,993 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号] , Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号] , CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号] , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [结算额] , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数] , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数] , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[59719929-751d-4b59-b6cc-0e75a0415def] FROM [##dae8381d4bbc4562bdc58de805120c16] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-05-22 17:40:06,713 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Vip 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 [##e2cadad9583542dda9f508d3d08cf402] FROM CustomerVip A 时间: 2023-05-22 17:40:06,719 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: EXEC p_VipGetIntegral @VipTable = '##b514421e31604468b9946b965a15cd1c', @EndDate = '2023/4/21', @DataTable = '##5ef5f613b6fe44b1a3a56598448795fe' 时间: 2023-05-22 17:40:06,858 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##e2cadad9583542dda9f508d3d08cf402 ([卡号], [期初积分]) SELECT A.VIP, SUM(A.IntegralAmount) FROM ##5ef5f613b6fe44b1a3a56598448795fe A GROUP BY A.VIP 时间: 2023-05-22 17:40:06,861 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##e2cadad9583542dda9f508d3d08cf402 ([卡号], [金额充值赠送]) SELECT A.Vip, SUM(A.Integral) FROM VIPAddValue A WHERE A.Posted = 1 AND A.VipAddValue_Date>='2023/4/22' AND A.VipAddValue_Date<='2023/5/22 23:59:59' AND EXISTS(SELECT 1 FROM ##b514421e31604468b9946b965a15cd1c WHERE VIP=A.VIP) GROUP BY A.VIP 时间: 2023-05-22 17:40:06,866 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT Vip INTO ##426b1662883a4fb39e914fc606d9de9f FROM ##b514421e31604468b9946b965a15cd1c 时间: 2023-05-22 17:40:06,868 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: EXEC p_VipGetIntegral @VipTable = '##426b1662883a4fb39e914fc606d9de9f', @DataTable = '##c01b256e5773426699bdb777fffefb24', @IsUsabeIntegral = 1 时间: 2023-05-22 17:40:07,032 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##e2cadad9583542dda9f508d3d08cf402 ([卡号], [可用积分], [当前积分]) SELECT A.VIP, SUM(A.IntegralAmount), SUM(A.Integral) FROM ##c01b256e5773426699bdb777fffefb24 A GROUP BY A.VIP 时间: 2023-05-22 17:40:07,035 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##e2cadad9583542dda9f508d3d08cf402 ([卡号], [消费积分]) SELECT A.Vip_Card, SUM(A.IntegralAmount) FROM [vn_Check] A WHERE A.Posted = 1 AND A.CheckDate>='2023/4/22' AND A.CheckDate<='2023/5/22 23:59:59' AND EXISTS(SELECT 1 FROM ##b514421e31604468b9946b965a15cd1c WHERE VIP=A.Vip_Card) GROUP BY A.Vip_Card 时间: 2023-05-22 17:40:07,065 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##e2cadad9583542dda9f508d3d08cf402 ([卡号], [增提积分]) SELECT A.VIP, SUM(A.Integral) FROM [VIPAddIntegral] A WHERE A.Posted = 1 AND A.VipAddIntegral_Date>='2023/4/22' AND A.VipAddIntegral_Date<='2023/5/22 23:59:59' AND EXISTS(SELECT 1 FROM ##b514421e31604468b9946b965a15cd1c WHERE VIP=A.VIP) GROUP BY A.VIP, A.VipAddIntegralID, A.VipAddIntegral_Date 时间: 2023-05-22 17:40:07,069 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##e2cadad9583542dda9f508d3d08cf402 ([卡号], [积分换购]) SELECT A.VIP, SUM(A.Amount) FROM [VipIntegralExchange] A WHERE A.Posted = 1 AND A.ExchangeDate>='2023/4/22' AND A.ExchangeDate<='2023/5/22 23:59:59' AND EXISTS(SELECT 1 FROM ##b514421e31604468b9946b965a15cd1c WHERE VIP=A.VIP) GROUP BY A.VIP 时间: 2023-05-22 17:40:07,074 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##e2cadad9583542dda9f508d3d08cf402 ([卡号], [抵减积分]) SELECT A.Vip_Card, SUM(B.Integral) FROM [vn_Check] A INNER JOIN CheckCounteractIntegral B ON A.CheckId=B.CheckId WHERE A.Posted = 1 AND A.CheckDate>='2023/4/22' AND A.CheckDate<='2023/5/22 23:59:59' AND EXISTS(SELECT 1 FROM ##b514421e31604468b9946b965a15cd1c WHERE VIP=A.Vip_Card) GROUP BY A.Vip_Card 时间: 2023-05-22 17:40:07,135 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##e2cadad9583542dda9f508d3d08cf402 ([卡号], [积分转入]) SELECT A.TurnInCard, SUM(A.TurnInIntegral) FROM [IntegralTurnCard] A WHERE A.Posted = 1 AND A.IntegralTurnCard_Date>='2023/4/22' AND A.IntegralTurnCard_Date<='2023/5/22 23:59:59' AND EXISTS(SELECT 1 FROM ##b514421e31604468b9946b965a15cd1c WHERE VIP=A.TurnInCard) GROUP BY A.TurnInCard 时间: 2023-05-22 17:40:07,141 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##e2cadad9583542dda9f508d3d08cf402 ([卡号], [积分转出]) SELECT A.TurnOutCard, SUM(A.TurnInIntegral) FROM [IntegralTurnCard] A WHERE A.Posted = 1 AND A.IntegralTurnCard_Date>='2023/4/22' AND A.IntegralTurnCard_Date<='2023/5/22 23:59:59' AND EXISTS(SELECT 1 FROM ##b514421e31604468b9946b965a15cd1c WHERE VIP=A.TurnOutCard) GROUP BY A.TurnOutCard 时间: 2023-05-22 17:40:07,147 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##e2cadad9583542dda9f508d3d08cf402 ([卡号], [零售订单积分]) SELECT A.VIP, SUM(A.Integral) FROM [KS2_RetailOrderIntegral] A WHERE 1 = 1 AND A.InputTime>='2023/4/22' AND A.InputTime<='2023/5/22 23:59:59' AND EXISTS(SELECT 1 FROM ##b514421e31604468b9946b965a15cd1c WHERE VIP=A.VIP) GROUP BY A.VIP 时间: 2023-05-22 17:40:07,154 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e2cadad9583542dda9f508d3d08cf402 SET [本期积分] = ISNULL([消费积分],0) - ISNULL([抵减积分],0) - ISNULL([积分换购],0) + ISNULL([金额充值赠送],0) + ISNULL([增提积分],0) 时间: 2023-05-22 17:40:07,155 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e2cadad9583542dda9f508d3d08cf402 SET [累计积分] = ISNULL([期初积分],0) + ISNULL([消费积分],0) - ISNULL([抵减积分],0) - ISNULL([积分换购],0) + ISNULL([金额充值赠送],0) + ISNULL([增提积分],0) + ISNULL([积分转入],0) - ISNULL([积分转出],0) + ISNULL([零售订单积分],0) 时间: 2023-05-22 17:40:07,159 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Vip , CAST(NULL AS VARCHAR(10)) AS [首次消费日期] , CAST(NULL AS VARCHAR(10)) AS [最后消费日期] , CAST(NULL AS VARCHAR(50)) AS [最后消费渠道] , CAST(NULL AS DECIMAL(30,2)) AS [消费金额] , CAST(NULL AS DECIMAL(30,2)) AS [累计消费金额] , CAST(NULL AS NVARCHAR(50)) AS [活跃度] , CAST(NULL AS INT) AS [活跃度2] INTO [##b5c1948ada344c5b86da2f11ae9c9e53] FROM CustomerVip A 时间: 2023-05-22 17:40:07,162 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##b5c1948ada344c5b86da2f11ae9c9e53(Vip,活跃度) SELECT A.Vip,'深度休眠' FROM ##b514421e31604468b9946b965a15cd1c A INNER JOIN CustomerVip B ON A.Vip = B.Vip WHERE EXISTS(SELECT 1 FROM ##1d66f12703734243931e33a30a66ad1d C WHERE B.Customer_ID = C.Customer_ID) 时间: 2023-05-22 17:40:07,174 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteData AS ( SELECT a.VIP_Card VIP, MIN(a.CheckDate) AS MinDate, MAX(a.CheckDate) AS MaxDate FROM vn_check a WHERE ISNULL(A.Posted,0) = 1 AND EXISTS(SELECT 1 FROM ##b514421e31604468b9946b965a15cd1c B WHERE a.VIP_Card = B.Vip) GROUP BY a.VIP_Card ) UPDATE A SET A.首次消费日期 = CONVERT(VARCHAR(10),B.MinDate,120) ,A.最后消费日期 = CONVERT(VARCHAR(10),B.MaxDate,120) FROM ##b5c1948ada344c5b86da2f11ae9c9e53 A INNER JOIN cteData B ON A.Vip = B.VIP 时间: 2023-05-22 17:40:07,272 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteSaleData AS ( SELECT a.VIP_Card Vip, SUM(ISNULL(b.DiscountPrice, 0) * (ISNULL([S1], 0))) Amount FROM vn_check a INNER JOIN VN_CheckGoods b ON a.CheckID = b.CheckID INNER JOIN VN_CheckDetail c ON b.CheckGoodsID = c.CheckGoodsID WHERE a.Posted = 1 AND EXISTS(SELECT 1 FROM ##b514421e31604468b9946b965a15cd1c WHERE Vip = a.VIP_Card ) AND a.CheckDate>'2023/4/21' and a.CheckDate<'2023/5/23' GROUP BY a.VIP_Card ) UPDATE A SET A.消费金额 = B.Amount FROM ##b5c1948ada344c5b86da2f11ae9c9e53 A INNER JOIN cteSaleData B ON A.Vip = B.Vip 时间: 2023-05-22 17:40:07,342 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteSaleData AS ( SELECT a.VIP_Card Vip, SUM(ISNULL(b.DiscountPrice, 0) * (ISNULL([S1], 0))) Amount FROM vn_check a INNER JOIN VN_CheckGoods b ON a.CheckID = b.CheckID INNER JOIN VN_CheckDetail c ON b.CheckGoodsID = c.CheckGoodsID WHERE a.Posted = 1 AND EXISTS(SELECT 1 FROM ##b514421e31604468b9946b965a15cd1c WHERE Vip = a.VIP_Card ) GROUP BY a.VIP_Card ) UPDATE A SET A.累计消费金额 = B.Amount FROM ##b5c1948ada344c5b86da2f11ae9c9e53 A INNER JOIN cteSaleData B ON A.Vip = B.Vip 时间: 2023-05-22 17:40:07,421 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteLastSale AS ( SELECT a.Customer_ID, a.VIP_Card VIP, MAX(A.CheckDate) AS CheckDate FROM vn_Check a WHERE ISNULL(a.Posted,0) = 1 AND EXISTS(SELECT 1 FROM ##b514421e31604468b9946b965a15cd1c B WHERE a.VIP_Card = B.Vip) GROUP BY a.Customer_ID, a.VIP_Card ) ,cteMax AS ( SELECT Vip, MAX(CheckDate) AS CheckDate FROM cteLastSale GROUP BY Vip ) ,cteSet AS ( SELECT A.* FROM cteLastSale A WHERE EXISTS(SELECT 1 FROM cteMax B WHERE A.Vip = B.Vip AND A.CheckDate = B.CheckDate) ) UPDATE A SET A.最后消费渠道 = C.Abbrev FROM ##b5c1948ada344c5b86da2f11ae9c9e53 A INNER JOIN cteSet B ON A.Vip = B.Vip INNER JOIN Customer C ON B.Customer_ID = C.Customer_ID 时间: 2023-05-22 17:40:07,686 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.Vip = A.Vip ,A.活跃度2 = DATEDIFF(DAY,CAST(A.最后消费日期 AS DATETIME),GETDATE()) FROM ##b5c1948ada344c5b86da2f11ae9c9e53 A WHERE ISNULL(A.最后消费日期,'') != '' 时间: 2023-05-22 17:40:07,688 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '活跃' FROM ##b5c1948ada344c5b86da2f11ae9c9e53 A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) <= 90 时间: 2023-05-22 17:40:07,690 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '较活跃' FROM ##b5c1948ada344c5b86da2f11ae9c9e53 A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 90 AND CAST(A.活跃度2 AS INT) < 180 时间: 2023-05-22 17:40:07,691 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '警戒' FROM ##b5c1948ada344c5b86da2f11ae9c9e53 A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 180 AND CAST(A.活跃度2 AS INT) < 365 时间: 2023-05-22 17:40:07,692 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '休眠' FROM ##b5c1948ada344c5b86da2f11ae9c9e53 A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 365 AND CAST(A.活跃度2 AS INT) < 730 时间: 2023-05-22 17:40:07,693 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '深度休眠' FROM ##b5c1948ada344c5b86da2f11ae9c9e53 A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 730 时间: 2023-05-22 17:40:07,695 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,Vip.VIP AS [VIP卡号], CV.Name AS [VIP姓名], B.首次消费日期 AS [首次消费日期], B.最后消费日期 AS [最后消费日期], B.最后消费渠道 AS [最后消费渠道], B.消费金额 AS [消费金额], B.累计消费金额 AS [累计消费金额], B.活跃度 AS [活跃度], SUM(期初积分) AS [期初积分], SUM(消费积分) AS [销售积分#消费积分], SUM(增提积分) AS [销售积分#增提积分], SUM(抵减积分) AS [销售积分#抵减积分], SUM(积分换购) AS [销售积分#积分换购], SUM(金额充值赠送) AS [销售积分#金额充值赠送], SUM(本期积分) AS [销售积分#本期积分], SUM(积分转入) AS [积分转入], SUM(积分转出) AS [积分转出], SUM(零售订单积分) AS [零售订单积分], SUM(可用积分) AS [可用积分], SUM(累计积分) AS [累计积分], CASE WHEN ISNULL(SUM([累计积分]),0) = 0 THEN 0 ELSE CAST(SUM([本期积分]) / SUM([累计积分]) AS NUMERIC(18,2)) END AS [占比], SUM(当前积分) AS [当前积分] INTO tempdb.dbo.[c109aad6-8abc-42cb-8e8e-e8c6cfcb29f5] FROM [##b514421e31604468b9946b965a15cd1c] Vip LEFT JOIN [##e2cadad9583542dda9f508d3d08cf402] A ON Vip.VIP=A.[卡号] LEFT JOIN [##b5c1948ada344c5b86da2f11ae9c9e53] B ON Vip.VIP=B.Vip LEFT JOIN CustomerVIP CV ON Vip.VIP=CV.VIP LEFT JOIN Customer CV1 ON CV.Customer_ID=CV1.Customer_ID GROUP BY Vip.VIP, CV.Name, B.首次消费日期, B.最后消费日期, B.最后消费渠道, B.消费金额, B.累计消费金额, B.活跃度 HAVING 1=1 ORDER BY Vip.VIP, CV.Name, B.首次消费日期, B.最后消费日期, B.最后消费渠道, B.消费金额, B.累计消费金额, B.活跃度 时间: 2023-05-22 17:42:54,542 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Vip 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 [##421a890b811b4e029a17898f623ecd14] FROM CustomerVip A 时间: 2023-05-22 17:42:54,544 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: EXEC p_VipGetIntegral @VipTable = '##9e45cd6a0e6e4b919b7b7b90a5bf80e5', @EndDate = '2020/12/31', @DataTable = '##d14f1eee93984d6ca9f453009258a9fb' 时间: 2023-05-22 17:42:54,670 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##421a890b811b4e029a17898f623ecd14 ([卡号], [期初积分]) SELECT A.VIP, SUM(A.IntegralAmount) FROM ##d14f1eee93984d6ca9f453009258a9fb A GROUP BY A.VIP 时间: 2023-05-22 17:42:54,672 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##421a890b811b4e029a17898f623ecd14 ([卡号], [金额充值赠送]) SELECT A.Vip, SUM(A.Integral) FROM VIPAddValue A WHERE A.Posted = 1 AND A.VipAddValue_Date>='2021/1/1' AND A.VipAddValue_Date<='2023/5/22 23:59:59' AND EXISTS(SELECT 1 FROM ##9e45cd6a0e6e4b919b7b7b90a5bf80e5 WHERE VIP=A.VIP) GROUP BY A.VIP 时间: 2023-05-22 17:42:54,677 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT Vip INTO ##3af629895d60497c884939e7fd927201 FROM ##9e45cd6a0e6e4b919b7b7b90a5bf80e5 时间: 2023-05-22 17:42:54,679 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: EXEC p_VipGetIntegral @VipTable = '##3af629895d60497c884939e7fd927201', @DataTable = '##033863b29322467a996ddbb07c2995e8', @IsUsabeIntegral = 1 时间: 2023-05-22 17:42:54,831 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##421a890b811b4e029a17898f623ecd14 ([卡号], [可用积分], [当前积分]) SELECT A.VIP, SUM(A.IntegralAmount), SUM(A.Integral) FROM ##033863b29322467a996ddbb07c2995e8 A GROUP BY A.VIP 时间: 2023-05-22 17:42:54,835 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##421a890b811b4e029a17898f623ecd14 ([卡号], [消费积分]) SELECT A.Vip_Card, SUM(A.IntegralAmount) FROM [vn_Check] A WHERE A.Posted = 1 AND A.CheckDate>='2021/1/1' AND A.CheckDate<='2023/5/22 23:59:59' AND EXISTS(SELECT 1 FROM ##9e45cd6a0e6e4b919b7b7b90a5bf80e5 WHERE VIP=A.Vip_Card) GROUP BY A.Vip_Card 时间: 2023-05-22 17:42:54,895 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##421a890b811b4e029a17898f623ecd14 ([卡号], [增提积分]) SELECT A.VIP, SUM(A.Integral) FROM [VIPAddIntegral] A WHERE A.Posted = 1 AND A.VipAddIntegral_Date>='2021/1/1' AND A.VipAddIntegral_Date<='2023/5/22 23:59:59' AND EXISTS(SELECT 1 FROM ##9e45cd6a0e6e4b919b7b7b90a5bf80e5 WHERE VIP=A.VIP) GROUP BY A.VIP, A.VipAddIntegralID, A.VipAddIntegral_Date 时间: 2023-05-22 17:42:54,899 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##421a890b811b4e029a17898f623ecd14 ([卡号], [积分换购]) SELECT A.VIP, SUM(A.Amount) FROM [VipIntegralExchange] A WHERE A.Posted = 1 AND A.ExchangeDate>='2021/1/1' AND A.ExchangeDate<='2023/5/22 23:59:59' AND EXISTS(SELECT 1 FROM ##9e45cd6a0e6e4b919b7b7b90a5bf80e5 WHERE VIP=A.VIP) GROUP BY A.VIP 时间: 2023-05-22 17:42:54,904 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##421a890b811b4e029a17898f623ecd14 ([卡号], [抵减积分]) SELECT A.Vip_Card, SUM(B.Integral) FROM [vn_Check] A INNER JOIN CheckCounteractIntegral B ON A.CheckId=B.CheckId WHERE A.Posted = 1 AND A.CheckDate>='2021/1/1' AND A.CheckDate<='2023/5/22 23:59:59' AND EXISTS(SELECT 1 FROM ##9e45cd6a0e6e4b919b7b7b90a5bf80e5 WHERE VIP=A.Vip_Card) GROUP BY A.Vip_Card 时间: 2023-05-22 17:42:55,002 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##421a890b811b4e029a17898f623ecd14 ([卡号], [积分转入]) SELECT A.TurnInCard, SUM(A.TurnInIntegral) FROM [IntegralTurnCard] A WHERE A.Posted = 1 AND A.IntegralTurnCard_Date>='2021/1/1' AND A.IntegralTurnCard_Date<='2023/5/22 23:59:59' AND EXISTS(SELECT 1 FROM ##9e45cd6a0e6e4b919b7b7b90a5bf80e5 WHERE VIP=A.TurnInCard) GROUP BY A.TurnInCard 时间: 2023-05-22 17:42:55,008 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##421a890b811b4e029a17898f623ecd14 ([卡号], [积分转出]) SELECT A.TurnOutCard, SUM(A.TurnInIntegral) FROM [IntegralTurnCard] A WHERE A.Posted = 1 AND A.IntegralTurnCard_Date>='2021/1/1' AND A.IntegralTurnCard_Date<='2023/5/22 23:59:59' AND EXISTS(SELECT 1 FROM ##9e45cd6a0e6e4b919b7b7b90a5bf80e5 WHERE VIP=A.TurnOutCard) GROUP BY A.TurnOutCard 时间: 2023-05-22 17:42:55,012 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##421a890b811b4e029a17898f623ecd14 ([卡号], [零售订单积分]) SELECT A.VIP, SUM(A.Integral) FROM [KS2_RetailOrderIntegral] A WHERE 1 = 1 AND A.InputTime>='2021/1/1' AND A.InputTime<='2023/5/22 23:59:59' AND EXISTS(SELECT 1 FROM ##9e45cd6a0e6e4b919b7b7b90a5bf80e5 WHERE VIP=A.VIP) GROUP BY A.VIP 时间: 2023-05-22 17:42:55,018 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##421a890b811b4e029a17898f623ecd14 SET [本期积分] = ISNULL([消费积分],0) - ISNULL([抵减积分],0) - ISNULL([积分换购],0) + ISNULL([金额充值赠送],0) + ISNULL([增提积分],0) 时间: 2023-05-22 17:42:55,019 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##421a890b811b4e029a17898f623ecd14 SET [累计积分] = ISNULL([期初积分],0) + ISNULL([消费积分],0) - ISNULL([抵减积分],0) - ISNULL([积分换购],0) + ISNULL([金额充值赠送],0) + ISNULL([增提积分],0) + ISNULL([积分转入],0) - ISNULL([积分转出],0) + ISNULL([零售订单积分],0) 时间: 2023-05-22 17:42:55,020 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Vip , CAST(NULL AS VARCHAR(10)) AS [首次消费日期] , CAST(NULL AS VARCHAR(10)) AS [最后消费日期] , CAST(NULL AS VARCHAR(50)) AS [最后消费渠道] , CAST(NULL AS DECIMAL(30,2)) AS [消费金额] , CAST(NULL AS DECIMAL(30,2)) AS [累计消费金额] , CAST(NULL AS NVARCHAR(50)) AS [活跃度] , CAST(NULL AS INT) AS [活跃度2] INTO [##78413de6e4bd4d5ab449708b39acdc56] FROM CustomerVip A 时间: 2023-05-22 17:42:55,022 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##78413de6e4bd4d5ab449708b39acdc56(Vip,活跃度) SELECT A.Vip,'深度休眠' FROM ##9e45cd6a0e6e4b919b7b7b90a5bf80e5 A INNER JOIN CustomerVip B ON A.Vip = B.Vip WHERE EXISTS(SELECT 1 FROM ##a5754e8939da44019cca6e9f7269de3f C WHERE B.Customer_ID = C.Customer_ID) 时间: 2023-05-22 17:42:55,031 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteData AS ( SELECT a.VIP_Card VIP, MIN(a.CheckDate) AS MinDate, MAX(a.CheckDate) AS MaxDate FROM vn_check a WHERE ISNULL(A.Posted,0) = 1 AND EXISTS(SELECT 1 FROM ##9e45cd6a0e6e4b919b7b7b90a5bf80e5 B WHERE a.VIP_Card = B.Vip) GROUP BY a.VIP_Card ) UPDATE A SET A.首次消费日期 = CONVERT(VARCHAR(10),B.MinDate,120) ,A.最后消费日期 = CONVERT(VARCHAR(10),B.MaxDate,120) FROM ##78413de6e4bd4d5ab449708b39acdc56 A INNER JOIN cteData B ON A.Vip = B.VIP 时间: 2023-05-22 17:42:55,111 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteSaleData AS ( SELECT a.VIP_Card Vip, SUM(ISNULL(b.DiscountPrice, 0) * (ISNULL([S1], 0))) Amount FROM vn_check a INNER JOIN VN_CheckGoods b ON a.CheckID = b.CheckID INNER JOIN VN_CheckDetail c ON b.CheckGoodsID = c.CheckGoodsID WHERE a.Posted = 1 AND EXISTS(SELECT 1 FROM ##9e45cd6a0e6e4b919b7b7b90a5bf80e5 WHERE Vip = a.VIP_Card ) AND a.CheckDate>'2020/12/31' and a.CheckDate<'2023/5/23' GROUP BY a.VIP_Card ) UPDATE A SET A.消费金额 = B.Amount FROM ##78413de6e4bd4d5ab449708b39acdc56 A INNER JOIN cteSaleData B ON A.Vip = B.Vip 时间: 2023-05-22 17:42:55,204 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteSaleData AS ( SELECT a.VIP_Card Vip, SUM(ISNULL(b.DiscountPrice, 0) * (ISNULL([S1], 0))) Amount FROM vn_check a INNER JOIN VN_CheckGoods b ON a.CheckID = b.CheckID INNER JOIN VN_CheckDetail c ON b.CheckGoodsID = c.CheckGoodsID WHERE a.Posted = 1 AND EXISTS(SELECT 1 FROM ##9e45cd6a0e6e4b919b7b7b90a5bf80e5 WHERE Vip = a.VIP_Card ) GROUP BY a.VIP_Card ) UPDATE A SET A.累计消费金额 = B.Amount FROM ##78413de6e4bd4d5ab449708b39acdc56 A INNER JOIN cteSaleData B ON A.Vip = B.Vip 时间: 2023-05-22 17:42:55,284 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteLastSale AS ( SELECT a.Customer_ID, a.VIP_Card VIP, MAX(A.CheckDate) AS CheckDate FROM vn_Check a WHERE ISNULL(a.Posted,0) = 1 AND EXISTS(SELECT 1 FROM ##9e45cd6a0e6e4b919b7b7b90a5bf80e5 B WHERE a.VIP_Card = B.Vip) GROUP BY a.Customer_ID, a.VIP_Card ) ,cteMax AS ( SELECT Vip, MAX(CheckDate) AS CheckDate FROM cteLastSale GROUP BY Vip ) ,cteSet AS ( SELECT A.* FROM cteLastSale A WHERE EXISTS(SELECT 1 FROM cteMax B WHERE A.Vip = B.Vip AND A.CheckDate = B.CheckDate) ) UPDATE A SET A.最后消费渠道 = C.Abbrev FROM ##78413de6e4bd4d5ab449708b39acdc56 A INNER JOIN cteSet B ON A.Vip = B.Vip INNER JOIN Customer C ON B.Customer_ID = C.Customer_ID 时间: 2023-05-22 17:42:55,559 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.Vip = A.Vip ,A.活跃度2 = DATEDIFF(DAY,CAST(A.最后消费日期 AS DATETIME),GETDATE()) FROM ##78413de6e4bd4d5ab449708b39acdc56 A WHERE ISNULL(A.最后消费日期,'') != '' 时间: 2023-05-22 17:42:55,562 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '活跃' FROM ##78413de6e4bd4d5ab449708b39acdc56 A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) <= 90 时间: 2023-05-22 17:42:55,563 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '较活跃' FROM ##78413de6e4bd4d5ab449708b39acdc56 A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 90 AND CAST(A.活跃度2 AS INT) < 180 时间: 2023-05-22 17:42:55,565 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '警戒' FROM ##78413de6e4bd4d5ab449708b39acdc56 A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 180 AND CAST(A.活跃度2 AS INT) < 365 时间: 2023-05-22 17:42:55,566 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '休眠' FROM ##78413de6e4bd4d5ab449708b39acdc56 A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 365 AND CAST(A.活跃度2 AS INT) < 730 时间: 2023-05-22 17:42:55,567 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '深度休眠' FROM ##78413de6e4bd4d5ab449708b39acdc56 A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 730 时间: 2023-05-22 17:42:55,569 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,Vip.VIP AS [VIP卡号], CV.Name AS [VIP姓名], B.首次消费日期 AS [首次消费日期], B.最后消费日期 AS [最后消费日期], B.最后消费渠道 AS [最后消费渠道], B.消费金额 AS [消费金额], B.累计消费金额 AS [累计消费金额], B.活跃度 AS [活跃度], SUM(期初积分) AS [期初积分], SUM(消费积分) AS [销售积分#消费积分], SUM(增提积分) AS [销售积分#增提积分], SUM(抵减积分) AS [销售积分#抵减积分], SUM(积分换购) AS [销售积分#积分换购], SUM(金额充值赠送) AS [销售积分#金额充值赠送], SUM(本期积分) AS [销售积分#本期积分], SUM(积分转入) AS [积分转入], SUM(积分转出) AS [积分转出], SUM(零售订单积分) AS [零售订单积分], SUM(可用积分) AS [可用积分], SUM(累计积分) AS [累计积分], CASE WHEN ISNULL(SUM([累计积分]),0) = 0 THEN 0 ELSE CAST(SUM([本期积分]) / SUM([累计积分]) AS NUMERIC(18,2)) END AS [占比], SUM(当前积分) AS [当前积分] INTO tempdb.dbo.[c109aad6-8abc-42cb-8e8e-e8c6cfcb29f5] FROM [##9e45cd6a0e6e4b919b7b7b90a5bf80e5] Vip LEFT JOIN [##421a890b811b4e029a17898f623ecd14] A ON Vip.VIP=A.[卡号] LEFT JOIN [##78413de6e4bd4d5ab449708b39acdc56] B ON Vip.VIP=B.Vip LEFT JOIN CustomerVIP CV ON Vip.VIP=CV.VIP LEFT JOIN Customer CV1 ON CV.Customer_ID=CV1.Customer_ID GROUP BY Vip.VIP, CV.Name, B.首次消费日期, B.最后消费日期, B.最后消费渠道, B.消费金额, B.累计消费金额, B.活跃度 HAVING 1=1 ORDER BY Vip.VIP, CV.Name, B.首次消费日期, B.最后消费日期, B.最后消费渠道, B.消费金额, B.累计消费金额, B.活跃度 时间: 2023-05-22 18:16:35,797 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , 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 [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(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 [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##caa1e2ecbc4e45df9fccaeeaff7d5805] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-05-22 18:16:36,137 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##07362644447c4addb8c92477173b5c37] where 2=2 and ISNULL(S1,0)=0 时间: 2023-05-22 18:16:36,137 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##caa1e2ecbc4e45df9fccaeeaff7d5805] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##07362644447c4addb8c92477173b5c37] 时间: 2023-05-22 18:16:36,191 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##80bf7e01691140949352bc8c709a4c32 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-05-22 18:16:36,194 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##80bf7e01691140949352bc8c709a4c32 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-05-22 18:16:36,195 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##80bf7e01691140949352bc8c709a4c32 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.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-05-22 18:16:36,224 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##80bf7e01691140949352bc8c709a4c32 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-05-22 18:16:36,225 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##80bf7e01691140949352bc8c709a4c32 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-05-22 18:16:36,228 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##caa1e2ecbc4e45df9fccaeeaff7d5805] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##2877d507eabf4964befca996169d731c] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-05-22 18:16:36,231 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[8f3d93bd-d5d7-4204-9dbb-84e1436cb786] FROM ##caa1e2ecbc4e45df9fccaeeaff7d5805 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-05-22 18:18:54,796 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##57a8fe9bdde04a9ab686f81373bce3f1] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2023-05-22 18:18:54,803 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##57a8fe9bdde04a9ab686f81373bce3f1] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##57a8fe9bdde04a9ab686f81373bce3f1] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2023-05-22 18:18:54,811 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##57a8fe9bdde04a9ab686f81373bce3f1] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2023-05-22 18:18:54,821 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##57a8fe9bdde04a9ab686f81373bce3f1] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2023-05-22 18:18:54,830 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##57a8fe9bdde04a9ab686f81373bce3f1 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##57a8fe9bdde04a9ab686f81373bce3f1 WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##917417cb4cd04ae88eaa8f31946fc0ee] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2023-05-22 18:18:54,915 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##57a8fe9bdde04a9ab686f81373bce3f1 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##57a8fe9bdde04a9ab686f81373bce3f1 WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##917417cb4cd04ae88eaa8f31946fc0ee] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2023-05-22 18:18:55,004 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##57a8fe9bdde04a9ab686f81373bce3f1 A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount FROM DeliveryGoods A LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM ##57a8fe9bdde04a9ab686f81373bce3f1 WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##917417cb4cd04ae88eaa8f31946fc0ee] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-05-22 18:18:55,140 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##57a8fe9bdde04a9ab686f81373bce3f1 A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##57a8fe9bdde04a9ab686f81373bce3f1 WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##917417cb4cd04ae88eaa8f31946fc0ee] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-05-22 18:18:55,505 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##57a8fe9bdde04a9ab686f81373bce3f1 A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM ##57a8fe9bdde04a9ab686f81373bce3f1 C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##917417cb4cd04ae88eaa8f31946fc0ee] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-05-22 18:18:55,784 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##57a8fe9bdde04a9ab686f81373bce3f1 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2023-05-22 18:18:55,786 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##57a8fe9bdde04a9ab686f81373bce3f1] A INNER JOIN ( SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo WHERE A.AccBillType = 'WareDelivery' AND EXISTS( SELECT 1 FROM [##57a8fe9bdde04a9ab686f81373bce3f1] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-05-22 18:18:55,826 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号] , Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号] , CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号] , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [结算额] , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数] , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数] , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[59719929-751d-4b59-b6cc-0e75a0415def] FROM [##57a8fe9bdde04a9ab686f81373bce3f1] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-05-22 18:19:02,639 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##195fea74351249078e8f8e8b451fe5b2] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2023-05-22 18:19:02,642 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##195fea74351249078e8f8e8b451fe5b2] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##195fea74351249078e8f8e8b451fe5b2] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2023-05-22 18:19:02,648 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##195fea74351249078e8f8e8b451fe5b2] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2023-05-22 18:19:02,652 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##195fea74351249078e8f8e8b451fe5b2] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2023-05-22 18:19:02,656 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##195fea74351249078e8f8e8b451fe5b2 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##195fea74351249078e8f8e8b451fe5b2 WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##b8c32789f7c947858a48bee2f735553e] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2023-05-22 18:19:02,718 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##195fea74351249078e8f8e8b451fe5b2 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##195fea74351249078e8f8e8b451fe5b2 WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##b8c32789f7c947858a48bee2f735553e] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2023-05-22 18:19:02,782 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##195fea74351249078e8f8e8b451fe5b2 A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount FROM DeliveryGoods A LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM ##195fea74351249078e8f8e8b451fe5b2 WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##b8c32789f7c947858a48bee2f735553e] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-05-22 18:19:02,902 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##195fea74351249078e8f8e8b451fe5b2 A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##195fea74351249078e8f8e8b451fe5b2 WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##b8c32789f7c947858a48bee2f735553e] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-05-22 18:19:03,437 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##195fea74351249078e8f8e8b451fe5b2 A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM ##195fea74351249078e8f8e8b451fe5b2 C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##b8c32789f7c947858a48bee2f735553e] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-05-22 18:19:03,835 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##195fea74351249078e8f8e8b451fe5b2 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2023-05-22 18:19:03,836 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##195fea74351249078e8f8e8b451fe5b2] A INNER JOIN ( SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo WHERE A.AccBillType = 'WareDelivery' AND EXISTS( SELECT 1 FROM [##195fea74351249078e8f8e8b451fe5b2] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-05-22 18:19:03,873 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号] , Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号] , CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号] , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [结算额] , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数] , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数] , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[59719929-751d-4b59-b6cc-0e75a0415def] FROM [##195fea74351249078e8f8e8b451fe5b2] ORDER BY Delivery_Date DESC, DeliveryID ASC