时间: 2021-02-04 11:26:35,033 线程ID: 38 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##1a26b9c397634bb0843a91e371ec819b] ORDER BY Goods_no 时间: 2021-02-04 11:29:08,750 线程ID: 38 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##b5aac94e9e5f429b98fb2a85f6c8bcf6] ORDER BY Goods_no 时间: 2021-02-04 11:29:12,463 线程ID: 36 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##e9ccc3fcd06b47c38326be04a1196de6] ORDER BY Goods_no 时间: 2021-02-04 11:29:12,633 线程ID: 36 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##ff24e2fd287848d9b0d508473fc88c19] ORDER BY Goods_no 时间: 2021-02-04 11:29:13,451 线程ID: 52 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##2f451eb7832546b68b55432d366de415] ORDER BY Goods_no 时间: 2021-02-04 11:29:13,614 线程ID: 52 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##6a2bf88575a14032bc4881be6219db22] ORDER BY Goods_no 时间: 2021-02-04 11:29:22,680 线程ID: 33 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##4f1cc161bac64662bf6fce882ae9aa7e] ORDER BY Goods_no 时间: 2021-02-04 11:29:24,692 线程ID: 32 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##a591b7614e64480e9587a2617655f00d] ORDER BY Goods_no 时间: 2021-02-04 11:29:24,859 线程ID: 33 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##9d95ada4082846f6b46d30ca9f780b13] ORDER BY Goods_no 时间: 2021-02-04 11:29:25,054 线程ID: 38 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##003fbe69ddad4267836d70b0d1428d24] ORDER BY Goods_no 时间: 2021-02-04 11:29:25,200 线程ID: 38 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##b8a95629606f456589dfb4367059a82d] ORDER BY Goods_no 时间: 2021-02-04 11:29:29,427 线程ID: 52 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##9acf9c9bc8d84f238173f90b4dfbc4d6] ORDER BY Goods_no 时间: 2021-02-04 11:29:29,596 线程ID: 38 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##c2a2599f9ede4bb8aa6a3421000b4a57] ORDER BY Goods_no 时间: 2021-02-04 11:29:29,759 线程ID: 32 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##78f57bfe56944531a93b7a48c6ede263] ORDER BY Goods_no 时间: 2021-02-04 11:29:32,923 线程ID: 36 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##32b4beab8f554ce385e3b91c5754ad3d] ORDER BY Goods_no 时间: 2021-02-04 11:29:33,071 线程ID: 52 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##3299228de31b4afdb0447e45d86b3194] ORDER BY Goods_no 时间: 2021-02-04 11:29:33,224 线程ID: 50 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##f95486ac53c34614a6a2508369821509] ORDER BY Goods_no 时间: 2021-02-04 11:29:33,394 线程ID: 36 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##c2f3bb8f3ef04550b0f14af056959d2a] ORDER BY Goods_no 时间: 2021-02-04 11:32:13,877 线程ID: 50 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##976baedb118640f8a95794ad8d7afc8b] ORDER BY Goods_no 时间: 2021-02-04 11:33:14,268 线程ID: 84 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##c00172f06a1d4c19b830a48a8748330b] ORDER BY Goods_no 时间: 2021-02-04 11:36:09,360 线程ID: 71 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##f13b8c1b19174ea6b1dfd276b113047e] ORDER BY Goods_no 时间: 2021-02-04 11:36:10,649 线程ID: 81 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##865c108c30c74c68aaf8aa06ce3b617c] ORDER BY Goods_no 时间: 2021-02-04 11:36:10,797 线程ID: 84 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##47fb21e8407f4478a55ebd263a7f42c9] ORDER BY Goods_no 时间: 2021-02-04 11:36:19,496 线程ID: 52 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##2a83a3775f594175ab35e5f2c6a77801] ORDER BY Goods_no 时间: 2021-02-04 11:36:19,665 线程ID: 71 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##a5923e26b2c749ed8232356590e68435] ORDER BY Goods_no 时间: 2021-02-04 11:36:19,844 线程ID: 84 日志级别: 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.[f151021e-c11c-440a-959f-e28a31f5d44b] FROM [##0bc589d11d77407983c8463ece12fa20] ORDER BY Goods_no 时间: 2021-02-04 14:25:25,777 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##d9c9c0837ecc4cef8f7aae892812b35d] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-02-04 14:25:25,793 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##d9c9c0837ecc4cef8f7aae892812b35d] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##d9c9c0837ecc4cef8f7aae892812b35d] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##5aeb97c3353c4b4489d38e52d1c86261] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 14:25:25,862 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##d9c9c0837ecc4cef8f7aae892812b35d] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##d9c9c0837ecc4cef8f7aae892812b35d] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##5aeb97c3353c4b4489d38e52d1c86261] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 14:25:25,930 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##d9c9c0837ecc4cef8f7aae892812b35d] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopTinSSGoods] A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##d9c9c0837ecc4cef8f7aae892812b35d WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##5aeb97c3353c4b4489d38e52d1c86261] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 14:25:26,094 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##d9c9c0837ecc4cef8f7aae892812b35d] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-04 14:25:26,094 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号] , TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[96dbfe71-e7a1-468f-8cd6-a26be8f20840] FROM [##d9c9c0837ecc4cef8f7aae892812b35d] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-04 14:25:38,619 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##c3e3d213706041cd83dc51c945ae86b6] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-02-04 14:25:38,619 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##c3e3d213706041cd83dc51c945ae86b6] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##c3e3d213706041cd83dc51c945ae86b6] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##56f36ab5991d4534bed61444f2e669fc] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 14:25:38,698 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##c3e3d213706041cd83dc51c945ae86b6] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##c3e3d213706041cd83dc51c945ae86b6] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##56f36ab5991d4534bed61444f2e669fc] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 14:25:38,770 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##c3e3d213706041cd83dc51c945ae86b6] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopTinSSGoods] A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##c3e3d213706041cd83dc51c945ae86b6 WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##56f36ab5991d4534bed61444f2e669fc] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 14:25:38,923 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##c3e3d213706041cd83dc51c945ae86b6] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-04 14:25:38,923 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号] , TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[96dbfe71-e7a1-468f-8cd6-a26be8f20840] FROM [##c3e3d213706041cd83dc51c945ae86b6] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-04 14:25:40,798 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##af7a4e48ead74025945f8e26e80b957a] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-02-04 14:25:40,808 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##af7a4e48ead74025945f8e26e80b957a] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##af7a4e48ead74025945f8e26e80b957a] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##b84e5a24cbba4d59b14b807063aee59d] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 14:25:40,890 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##af7a4e48ead74025945f8e26e80b957a] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##af7a4e48ead74025945f8e26e80b957a] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##b84e5a24cbba4d59b14b807063aee59d] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 14:25:40,959 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##af7a4e48ead74025945f8e26e80b957a] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopTinSSGoods] A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##af7a4e48ead74025945f8e26e80b957a WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##b84e5a24cbba4d59b14b807063aee59d] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 14:25:41,122 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##af7a4e48ead74025945f8e26e80b957a] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-04 14:25:41,122 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号] , TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[96dbfe71-e7a1-468f-8cd6-a26be8f20840] FROM [##af7a4e48ead74025945f8e26e80b957a] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-04 14:25:42,882 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##930d6c5935de4a128e6d776828585455] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-02-04 14:25:42,882 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##930d6c5935de4a128e6d776828585455] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##930d6c5935de4a128e6d776828585455] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##5ee5e0b4f22f4f85ad16350789ea5261] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 14:25:42,945 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##930d6c5935de4a128e6d776828585455] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##930d6c5935de4a128e6d776828585455] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##5ee5e0b4f22f4f85ad16350789ea5261] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 14:25:43,000 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##930d6c5935de4a128e6d776828585455] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopTinSSGoods] A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##930d6c5935de4a128e6d776828585455 WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##5ee5e0b4f22f4f85ad16350789ea5261] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 14:25:43,164 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##930d6c5935de4a128e6d776828585455] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-04 14:25:43,164 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号] , TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[96dbfe71-e7a1-468f-8cd6-a26be8f20840] FROM [##930d6c5935de4a128e6d776828585455] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-04 16:35:06,216 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##39211e93474247e484cb152511049217] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo ) 时间: 2021-02-04 16:35:06,216 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##39211e93474247e484cb152511049217] SET IsForWay = 1 WHERE NOT Exists( SELECT DealereturnID FROM Pureceipt WHERE Type = 3 AND [##39211e93474247e484cb152511049217].DealereturnID = DealereturnID) 时间: 2021-02-04 16:35:06,263 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##39211e93474247e484cb152511049217] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END FROM [##39211e93474247e484cb152511049217] A INNER JOIN Pureceipt B ON A.DealereturnID = B.DealereturnID WHERE B.Type = 3 时间: 2021-02-04 16:35:06,263 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##39211e93474247e484cb152511049217] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [DealeReturnGoods] A INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##39211e93474247e484cb152511049217 WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##8056f98efb4d48e9804dec639ceaaacb] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2021-02-04 16:35:06,417 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##39211e93474247e484cb152511049217] SET ReceiveQuantity = B.Quantity FROM [##39211e93474247e484cb152511049217] A INNER JOIN ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity FROM Pureceipt A INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID WHERE EXISTS( SELECT 1 FROM ##39211e93474247e484cb152511049217 WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##8056f98efb4d48e9804dec639ceaaacb] WHERE Goods_No = C.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2021-02-04 16:35:06,569 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##39211e93474247e484cb152511049217] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 时间: 2021-02-04 16:35:06,569 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期] , rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号] , Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[de11fc56-fd81-482d-853d-47cbe4fd54d9] FROM [##39211e93474247e484cb152511049217] ORDER BY Return_Date DESC, DealereturnID ASC 时间: 2021-02-04 16:36:42,984 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##b7edbf6c5ba94216820de1ffed1c540c] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptSSGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID LEFT JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM [##b7edbf6c5ba94216820de1ffed1c540c] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##80d935e6e2024f739a61614495c3284b] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 16:36:43,199 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OldQuantity = ISNULL(B.Quantity,0) FROM [##b7edbf6c5ba94216820de1ffed1c540c] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##b7edbf6c5ba94216820de1ffed1c540c] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##80d935e6e2024f739a61614495c3284b] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 16:36:43,404 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0) FROM [##b7edbf6c5ba94216820de1ffed1c540c] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM DealeReturnGoods A INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID WHERE EXISTS( SELECT 1 FROM [##b7edbf6c5ba94216820de1ffed1c540c] WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##80d935e6e2024f739a61614495c3284b] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2021-02-04 16:36:43,538 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0) FROM [##b7edbf6c5ba94216820de1ffed1c540c] A INNER JOIN ( SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM RenoticeGoods A INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID WHERE EXISTS( SELECT 1 FROM [##b7edbf6c5ba94216820de1ffed1c540c] WHERE A.RenoticeID = RenoticeID ) AND EXISTS (SELECT 1 FROM [##80d935e6e2024f739a61614495c3284b] WHERE Goods_No = A.Goods_No) GROUP BY A.RenoticeID ) B ON A.RenoticeID = B.RenoticeID 时间: 2021-02-04 16:36:43,785 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0) FROM [##b7edbf6c5ba94216820de1ffed1c540c] A INNER JOIN ( SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReturnGoods A INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID WHERE EXISTS( SELECT 1 FROM [##b7edbf6c5ba94216820de1ffed1c540c] WHERE A.PuReturnID = PuReturnID ) AND EXISTS (SELECT 1 FROM [##80d935e6e2024f739a61614495c3284b] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReturnID ) B ON A.PuReturnID = B.PuReturnID 时间: 2021-02-04 16:36:44,008 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET CompareQuantity = ISNULL(B.CompareQuantity,0) FROM [##b7edbf6c5ba94216820de1ffed1c540c] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.CompareQuantity,0)) As CompareQuantity FROM PuReceiptCompare A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##b7edbf6c5ba94216820de1ffed1c540c] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##80d935e6e2024f739a61614495c3284b] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 16:36:44,188 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号], BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], PriceType [价格类型], Quantity AS [数量], DpAmount AS [吊牌额], BalanceAmount AS [结算额], PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数], OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus 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.[d06b4a66-ff28-4593-863a-20bed7c800e7] FROM [##b7edbf6c5ba94216820de1ffed1c540c] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2021-02-04 16:36:46,134 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##2acad71aaac74b2c9727e85451a8def8] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptSSGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID LEFT JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM [##2acad71aaac74b2c9727e85451a8def8] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##bd5c2ff945b743dc8ae2cd6b011f329f] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 16:36:46,297 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OldQuantity = ISNULL(B.Quantity,0) FROM [##2acad71aaac74b2c9727e85451a8def8] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##2acad71aaac74b2c9727e85451a8def8] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##bd5c2ff945b743dc8ae2cd6b011f329f] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 16:36:46,492 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0) FROM [##2acad71aaac74b2c9727e85451a8def8] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM DealeReturnGoods A INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID WHERE EXISTS( SELECT 1 FROM [##2acad71aaac74b2c9727e85451a8def8] WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##bd5c2ff945b743dc8ae2cd6b011f329f] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2021-02-04 16:36:46,625 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0) FROM [##2acad71aaac74b2c9727e85451a8def8] A INNER JOIN ( SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM RenoticeGoods A INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID WHERE EXISTS( SELECT 1 FROM [##2acad71aaac74b2c9727e85451a8def8] WHERE A.RenoticeID = RenoticeID ) AND EXISTS (SELECT 1 FROM [##bd5c2ff945b743dc8ae2cd6b011f329f] WHERE Goods_No = A.Goods_No) GROUP BY A.RenoticeID ) B ON A.RenoticeID = B.RenoticeID 时间: 2021-02-04 16:36:46,826 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0) FROM [##2acad71aaac74b2c9727e85451a8def8] A INNER JOIN ( SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReturnGoods A INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID WHERE EXISTS( SELECT 1 FROM [##2acad71aaac74b2c9727e85451a8def8] WHERE A.PuReturnID = PuReturnID ) AND EXISTS (SELECT 1 FROM [##bd5c2ff945b743dc8ae2cd6b011f329f] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReturnID ) B ON A.PuReturnID = B.PuReturnID 时间: 2021-02-04 16:36:47,027 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET CompareQuantity = ISNULL(B.CompareQuantity,0) FROM [##2acad71aaac74b2c9727e85451a8def8] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.CompareQuantity,0)) As CompareQuantity FROM PuReceiptCompare A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##2acad71aaac74b2c9727e85451a8def8] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##bd5c2ff945b743dc8ae2cd6b011f329f] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 16:36:47,190 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号], BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], PriceType [价格类型], Quantity AS [数量], DpAmount AS [吊牌额], BalanceAmount AS [结算额], PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数], OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus 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.[d06b4a66-ff28-4593-863a-20bed7c800e7] FROM [##2acad71aaac74b2c9727e85451a8def8] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2021-02-04 16:36:49,721 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##db2456f1cc0341c7ba3718cf808523ac] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptSSGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID LEFT JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM [##db2456f1cc0341c7ba3718cf808523ac] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##6fff9716000c4d0388c0b4c1c209ed28] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 16:36:49,878 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OldQuantity = ISNULL(B.Quantity,0) FROM [##db2456f1cc0341c7ba3718cf808523ac] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##db2456f1cc0341c7ba3718cf808523ac] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##6fff9716000c4d0388c0b4c1c209ed28] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 16:36:50,095 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0) FROM [##db2456f1cc0341c7ba3718cf808523ac] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM DealeReturnGoods A INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID WHERE EXISTS( SELECT 1 FROM [##db2456f1cc0341c7ba3718cf808523ac] WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##6fff9716000c4d0388c0b4c1c209ed28] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2021-02-04 16:36:50,226 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0) FROM [##db2456f1cc0341c7ba3718cf808523ac] A INNER JOIN ( SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM RenoticeGoods A INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID WHERE EXISTS( SELECT 1 FROM [##db2456f1cc0341c7ba3718cf808523ac] WHERE A.RenoticeID = RenoticeID ) AND EXISTS (SELECT 1 FROM [##6fff9716000c4d0388c0b4c1c209ed28] WHERE Goods_No = A.Goods_No) GROUP BY A.RenoticeID ) B ON A.RenoticeID = B.RenoticeID 时间: 2021-02-04 16:36:50,412 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0) FROM [##db2456f1cc0341c7ba3718cf808523ac] A INNER JOIN ( SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReturnGoods A INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID WHERE EXISTS( SELECT 1 FROM [##db2456f1cc0341c7ba3718cf808523ac] WHERE A.PuReturnID = PuReturnID ) AND EXISTS (SELECT 1 FROM [##6fff9716000c4d0388c0b4c1c209ed28] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReturnID ) B ON A.PuReturnID = B.PuReturnID 时间: 2021-02-04 16:36:50,613 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET CompareQuantity = ISNULL(B.CompareQuantity,0) FROM [##db2456f1cc0341c7ba3718cf808523ac] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.CompareQuantity,0)) As CompareQuantity FROM PuReceiptCompare A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##db2456f1cc0341c7ba3718cf808523ac] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##6fff9716000c4d0388c0b4c1c209ed28] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 16:36:50,766 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号], BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], PriceType [价格类型], Quantity AS [数量], DpAmount AS [吊牌额], BalanceAmount AS [结算额], PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数], OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus 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.[d06b4a66-ff28-4593-863a-20bed7c800e7] FROM [##db2456f1cc0341c7ba3718cf808523ac] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2021-02-04 16:37:00,940 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##8cf07431c9674b6c8dda9d0d399134da] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptSSGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID LEFT JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM [##8cf07431c9674b6c8dda9d0d399134da] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##a0541cac7251430391cd06579908b39a] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 16:37:01,114 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OldQuantity = ISNULL(B.Quantity,0) FROM [##8cf07431c9674b6c8dda9d0d399134da] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##8cf07431c9674b6c8dda9d0d399134da] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##a0541cac7251430391cd06579908b39a] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 16:37:01,320 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0) FROM [##8cf07431c9674b6c8dda9d0d399134da] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM DealeReturnGoods A INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID WHERE EXISTS( SELECT 1 FROM [##8cf07431c9674b6c8dda9d0d399134da] WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##a0541cac7251430391cd06579908b39a] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2021-02-04 16:37:01,458 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0) FROM [##8cf07431c9674b6c8dda9d0d399134da] A INNER JOIN ( SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM RenoticeGoods A INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID WHERE EXISTS( SELECT 1 FROM [##8cf07431c9674b6c8dda9d0d399134da] WHERE A.RenoticeID = RenoticeID ) AND EXISTS (SELECT 1 FROM [##a0541cac7251430391cd06579908b39a] WHERE Goods_No = A.Goods_No) GROUP BY A.RenoticeID ) B ON A.RenoticeID = B.RenoticeID 时间: 2021-02-04 16:37:01,644 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0) FROM [##8cf07431c9674b6c8dda9d0d399134da] A INNER JOIN ( SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReturnGoods A INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID WHERE EXISTS( SELECT 1 FROM [##8cf07431c9674b6c8dda9d0d399134da] WHERE A.PuReturnID = PuReturnID ) AND EXISTS (SELECT 1 FROM [##a0541cac7251430391cd06579908b39a] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReturnID ) B ON A.PuReturnID = B.PuReturnID 时间: 2021-02-04 16:37:01,844 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET CompareQuantity = ISNULL(B.CompareQuantity,0) FROM [##8cf07431c9674b6c8dda9d0d399134da] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.CompareQuantity,0)) As CompareQuantity FROM PuReceiptCompare A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##8cf07431c9674b6c8dda9d0d399134da] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##a0541cac7251430391cd06579908b39a] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 16:37:02,039 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号], BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], PriceType [价格类型], Quantity AS [数量], DpAmount AS [吊牌额], BalanceAmount AS [结算额], PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数], OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus 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.[d06b4a66-ff28-4593-863a-20bed7c800e7] FROM [##8cf07431c9674b6c8dda9d0d399134da] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2021-02-04 16:38:15,062 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称] ,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式] ,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额] ,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣] ,[Group] [组], Company_ID [公司编号], SaleMan [业务员] ,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别] INTO tempdb.dbo.[a5ba6ed6-557d-4d92-8299-b38386f7a33c] FROM Customer A INNER JOIN [##23691ad1b2f64729bfd35c9ead24cf94] B ON A.Customer_ID = B.Customer_ID ORDER BY A.Customer_ID 时间: 2021-02-04 16:58:41,860 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##b1fcfd87395f4df9be1ddf13a9b2e304] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptSSGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID LEFT JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM [##b1fcfd87395f4df9be1ddf13a9b2e304] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##495d005465a84628bbf3b584e5e5a5d4] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 16:58:42,015 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OldQuantity = ISNULL(B.Quantity,0) FROM [##b1fcfd87395f4df9be1ddf13a9b2e304] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##b1fcfd87395f4df9be1ddf13a9b2e304] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##495d005465a84628bbf3b584e5e5a5d4] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 16:58:42,216 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0) FROM [##b1fcfd87395f4df9be1ddf13a9b2e304] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM DealeReturnGoods A INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID WHERE EXISTS( SELECT 1 FROM [##b1fcfd87395f4df9be1ddf13a9b2e304] WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##495d005465a84628bbf3b584e5e5a5d4] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2021-02-04 16:58:42,348 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0) FROM [##b1fcfd87395f4df9be1ddf13a9b2e304] A INNER JOIN ( SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM RenoticeGoods A INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID WHERE EXISTS( SELECT 1 FROM [##b1fcfd87395f4df9be1ddf13a9b2e304] WHERE A.RenoticeID = RenoticeID ) AND EXISTS (SELECT 1 FROM [##495d005465a84628bbf3b584e5e5a5d4] WHERE Goods_No = A.Goods_No) GROUP BY A.RenoticeID ) B ON A.RenoticeID = B.RenoticeID 时间: 2021-02-04 16:58:42,505 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0) FROM [##b1fcfd87395f4df9be1ddf13a9b2e304] A INNER JOIN ( SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReturnGoods A INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID WHERE EXISTS( SELECT 1 FROM [##b1fcfd87395f4df9be1ddf13a9b2e304] WHERE A.PuReturnID = PuReturnID ) AND EXISTS (SELECT 1 FROM [##495d005465a84628bbf3b584e5e5a5d4] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReturnID ) B ON A.PuReturnID = B.PuReturnID 时间: 2021-02-04 16:58:42,653 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET CompareQuantity = ISNULL(B.CompareQuantity,0) FROM [##b1fcfd87395f4df9be1ddf13a9b2e304] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.CompareQuantity,0)) As CompareQuantity FROM PuReceiptCompare A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##b1fcfd87395f4df9be1ddf13a9b2e304] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##495d005465a84628bbf3b584e5e5a5d4] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 16:58:42,839 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号], BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], PriceType [价格类型], Quantity AS [数量], DpAmount AS [吊牌额], BalanceAmount AS [结算额], PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数], OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus 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.[1a85d6f5-bb03-4ab3-8323-9890dda7a8e5] FROM [##b1fcfd87395f4df9be1ddf13a9b2e304] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2021-02-04 17:00:47,082 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##671e891f751a48c397b477c6c2276541] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptSSGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID LEFT JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM [##671e891f751a48c397b477c6c2276541] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 17:00:47,127 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OldQuantity = ISNULL(B.Quantity,0) FROM [##671e891f751a48c397b477c6c2276541] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##671e891f751a48c397b477c6c2276541] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 17:00:47,164 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0) FROM [##671e891f751a48c397b477c6c2276541] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM DealeReturnGoods A INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID WHERE EXISTS( SELECT 1 FROM [##671e891f751a48c397b477c6c2276541] WHERE A.DealereturnID = DealereturnID ) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2021-02-04 17:00:47,211 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0) FROM [##671e891f751a48c397b477c6c2276541] A INNER JOIN ( SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM RenoticeGoods A INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID WHERE EXISTS( SELECT 1 FROM [##671e891f751a48c397b477c6c2276541] WHERE A.RenoticeID = RenoticeID ) GROUP BY A.RenoticeID ) B ON A.RenoticeID = B.RenoticeID 时间: 2021-02-04 17:00:47,254 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0) FROM [##671e891f751a48c397b477c6c2276541] A INNER JOIN ( SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReturnGoods A INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID WHERE EXISTS( SELECT 1 FROM [##671e891f751a48c397b477c6c2276541] WHERE A.PuReturnID = PuReturnID ) GROUP BY A.PuReturnID ) B ON A.PuReturnID = B.PuReturnID 时间: 2021-02-04 17:00:47,301 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET CompareQuantity = ISNULL(B.CompareQuantity,0) FROM [##671e891f751a48c397b477c6c2276541] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.CompareQuantity,0)) As CompareQuantity FROM PuReceiptCompare A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##671e891f751a48c397b477c6c2276541] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 17:00:47,356 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号], BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], PriceType [价格类型], Quantity AS [数量], DpAmount AS [吊牌额], BalanceAmount AS [结算额], PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数], OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus 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.[684ca829-cb29-4547-949d-3ae5f7fb278c] FROM [##671e891f751a48c397b477c6c2276541] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2021-02-04 17:02:28,722 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##2c477f13753d4feba1672b7bd85d2861] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptSSGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID LEFT JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM [##2c477f13753d4feba1672b7bd85d2861] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 17:02:28,771 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OldQuantity = ISNULL(B.Quantity,0) FROM [##2c477f13753d4feba1672b7bd85d2861] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##2c477f13753d4feba1672b7bd85d2861] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 17:02:28,834 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0) FROM [##2c477f13753d4feba1672b7bd85d2861] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM DealeReturnGoods A INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID WHERE EXISTS( SELECT 1 FROM [##2c477f13753d4feba1672b7bd85d2861] WHERE A.DealereturnID = DealereturnID ) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2021-02-04 17:02:28,875 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0) FROM [##2c477f13753d4feba1672b7bd85d2861] A INNER JOIN ( SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM RenoticeGoods A INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID WHERE EXISTS( SELECT 1 FROM [##2c477f13753d4feba1672b7bd85d2861] WHERE A.RenoticeID = RenoticeID ) GROUP BY A.RenoticeID ) B ON A.RenoticeID = B.RenoticeID 时间: 2021-02-04 17:02:28,910 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0) FROM [##2c477f13753d4feba1672b7bd85d2861] A INNER JOIN ( SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReturnGoods A INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID WHERE EXISTS( SELECT 1 FROM [##2c477f13753d4feba1672b7bd85d2861] WHERE A.PuReturnID = PuReturnID ) GROUP BY A.PuReturnID ) B ON A.PuReturnID = B.PuReturnID 时间: 2021-02-04 17:02:28,947 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET CompareQuantity = ISNULL(B.CompareQuantity,0) FROM [##2c477f13753d4feba1672b7bd85d2861] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.CompareQuantity,0)) As CompareQuantity FROM PuReceiptCompare A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##2c477f13753d4feba1672b7bd85d2861] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2021-02-04 17:02:28,988 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号], BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], PriceType [价格类型], Quantity AS [数量], DpAmount AS [吊牌额], BalanceAmount AS [结算额], PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数], OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus 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.[c3aa32e0-5dde-43a2-bca3-a0767e59d279] FROM [##2c477f13753d4feba1672b7bd85d2861] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2021-02-04 17:27:40,634 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##d94d9ef99c3b464e82d988e67d58ed5e] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-02-04 17:27:40,634 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##d94d9ef99c3b464e82d988e67d58ed5e] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##d94d9ef99c3b464e82d988e67d58ed5e] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##c22d1faaa34944669de001139212e607] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 17:27:40,735 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##d94d9ef99c3b464e82d988e67d58ed5e] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##d94d9ef99c3b464e82d988e67d58ed5e] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##c22d1faaa34944669de001139212e607] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 17:27:40,835 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##d94d9ef99c3b464e82d988e67d58ed5e] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopTinSSGoods] A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##d94d9ef99c3b464e82d988e67d58ed5e WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##c22d1faaa34944669de001139212e607] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 17:27:41,004 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##d94d9ef99c3b464e82d988e67d58ed5e] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-04 17:27:41,004 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号] , TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[f1c77aad-bae1-4333-b59a-193f47827309] FROM [##d94d9ef99c3b464e82d988e67d58ed5e] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-04 17:27:46,936 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##fbac2a1ec8e6444893a548db1998945f] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-02-04 17:27:46,936 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##fbac2a1ec8e6444893a548db1998945f] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##fbac2a1ec8e6444893a548db1998945f] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##3057fa73ff604cbdaf6460386aea1e56] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 17:27:46,993 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##fbac2a1ec8e6444893a548db1998945f] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##fbac2a1ec8e6444893a548db1998945f] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##3057fa73ff604cbdaf6460386aea1e56] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 17:27:47,062 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##fbac2a1ec8e6444893a548db1998945f] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopTinSSGoods] A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##fbac2a1ec8e6444893a548db1998945f WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##3057fa73ff604cbdaf6460386aea1e56] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 17:27:47,194 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##fbac2a1ec8e6444893a548db1998945f] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-04 17:27:47,194 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号] , TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[f1c77aad-bae1-4333-b59a-193f47827309] FROM [##fbac2a1ec8e6444893a548db1998945f] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-04 17:27:49,216 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##e4a4056c7c2c44b7b9e9fb2ee17cd707] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-02-04 17:27:49,216 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##e4a4056c7c2c44b7b9e9fb2ee17cd707] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##e4a4056c7c2c44b7b9e9fb2ee17cd707] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##73da7b48966b4cd693ad5cbe09d856b9] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 17:27:49,285 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##e4a4056c7c2c44b7b9e9fb2ee17cd707] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##e4a4056c7c2c44b7b9e9fb2ee17cd707] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##73da7b48966b4cd693ad5cbe09d856b9] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 17:27:49,347 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##e4a4056c7c2c44b7b9e9fb2ee17cd707] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopTinSSGoods] A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##e4a4056c7c2c44b7b9e9fb2ee17cd707 WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##73da7b48966b4cd693ad5cbe09d856b9] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-04 17:27:49,517 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##e4a4056c7c2c44b7b9e9fb2ee17cd707] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-04 17:27:49,517 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号] , TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[f1c77aad-bae1-4333-b59a-193f47827309] FROM [##e4a4056c7c2c44b7b9e9fb2ee17cd707] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-04 17:46:43,274 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##0adb821b2711422987d23c3cabfffae7] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2021-02-04 17:46:43,290 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##0adb821b2711422987d23c3cabfffae7] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##0adb821b2711422987d23c3cabfffae7] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2021-02-04 17:46:43,290 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##0adb821b2711422987d23c3cabfffae7] SET IsInStock = CASE WHEN (select 1 from PuReceipt B where B.DeliveryID = A.DeliveryID) = 1 THEN 1 ELSE 0 END FROM [##0adb821b2711422987d23c3cabfffae7] A WHERE 1 = 1 时间: 2021-02-04 17:46:43,290 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##0adb821b2711422987d23c3cabfffae7 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##0adb821b2711422987d23c3cabfffae7 WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##6e37b7d0c0c349af9ca138fc38e03701] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2021-02-04 17:46:43,359 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##0adb821b2711422987d23c3cabfffae7 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##0adb821b2711422987d23c3cabfffae7 WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##6e37b7d0c0c349af9ca138fc38e03701] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2021-02-04 17:46:43,423 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##0adb821b2711422987d23c3cabfffae7 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 ##0adb821b2711422987d23c3cabfffae7 WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##6e37b7d0c0c349af9ca138fc38e03701] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-02-04 17:46:43,475 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##0adb821b2711422987d23c3cabfffae7 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 ##0adb821b2711422987d23c3cabfffae7 WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##6e37b7d0c0c349af9ca138fc38e03701] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-02-04 17:46:43,733 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##0adb821b2711422987d23c3cabfffae7 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 ##0adb821b2711422987d23c3cabfffae7 C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##6e37b7d0c0c349af9ca138fc38e03701] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-02-04 17:46:43,988 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0adb821b2711422987d23c3cabfffae7 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2021-02-04 17:46:43,989 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##0adb821b2711422987d23c3cabfffae7] 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 [##0adb821b2711422987d23c3cabfffae7] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-02-04 17:46:44,028 线程ID: 72 日志级别: 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.[d358cfe6-2fb2-4d03-8ea9-fd059c2f646f] FROM [##0adb821b2711422987d23c3cabfffae7] ORDER BY Delivery_Date DESC, DeliveryID ASC