时间: 2021-02-20 10:33:15,120 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##99a4f97f54dc463d9d232071de673262] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-02-20 10:33:15,128 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##99a4f97f54dc463d9d232071de673262] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##99a4f97f54dc463d9d232071de673262] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##562a466958f247c28f2cfc301a9f5ccc] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 10:33:15,208 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##99a4f97f54dc463d9d232071de673262] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##99a4f97f54dc463d9d232071de673262] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##562a466958f247c28f2cfc301a9f5ccc] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 10:33:15,285 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##99a4f97f54dc463d9d232071de673262] 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 ##99a4f97f54dc463d9d232071de673262 WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##562a466958f247c28f2cfc301a9f5ccc] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 10:33:15,437 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##99a4f97f54dc463d9d232071de673262] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-20 10:33:15,440 线程ID: 74 日志级别: 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.[10ad808e-779d-4a26-967e-4bac3f454ec9] FROM [##99a4f97f54dc463d9d232071de673262] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-20 10:50:15,873 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##80c9b4efe2fb429ca2e928601460c18a] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-02-20 10:50:15,877 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##80c9b4efe2fb429ca2e928601460c18a] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##80c9b4efe2fb429ca2e928601460c18a] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##7b6595d1c7eb4372826e46b3234ad81b] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 10:50:15,954 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##80c9b4efe2fb429ca2e928601460c18a] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##80c9b4efe2fb429ca2e928601460c18a] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##7b6595d1c7eb4372826e46b3234ad81b] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 10:50:16,031 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##80c9b4efe2fb429ca2e928601460c18a] 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 ##80c9b4efe2fb429ca2e928601460c18a WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##7b6595d1c7eb4372826e46b3234ad81b] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 10:50:16,168 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##80c9b4efe2fb429ca2e928601460c18a] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-20 10:50:16,171 线程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.[10ad808e-779d-4a26-967e-4bac3f454ec9] FROM [##80c9b4efe2fb429ca2e928601460c18a] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-20 10:50:17,751 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##d326216fba4e43dbb76e04a9c546fbe1] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-02-20 10:50:17,755 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##d326216fba4e43dbb76e04a9c546fbe1] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##d326216fba4e43dbb76e04a9c546fbe1] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##51da6af2d9e044108b31d4e346da4438] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 10:50:17,836 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##d326216fba4e43dbb76e04a9c546fbe1] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##d326216fba4e43dbb76e04a9c546fbe1] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##51da6af2d9e044108b31d4e346da4438] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 10:50:17,903 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##d326216fba4e43dbb76e04a9c546fbe1] 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 ##d326216fba4e43dbb76e04a9c546fbe1 WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##51da6af2d9e044108b31d4e346da4438] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 10:50:18,048 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##d326216fba4e43dbb76e04a9c546fbe1] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-20 10:50:18,051 线程ID: 8 日志级别: 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.[10ad808e-779d-4a26-967e-4bac3f454ec9] FROM [##d326216fba4e43dbb76e04a9c546fbe1] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-20 10:50:19,413 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##59c6f182f80f49d49b096f0973acf528] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-02-20 10:50:19,417 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##59c6f182f80f49d49b096f0973acf528] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##59c6f182f80f49d49b096f0973acf528] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##0664c28b6b194c7d975de622982a80c5] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 10:50:19,492 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##59c6f182f80f49d49b096f0973acf528] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##59c6f182f80f49d49b096f0973acf528] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##0664c28b6b194c7d975de622982a80c5] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 10:50:19,565 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##59c6f182f80f49d49b096f0973acf528] 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 ##59c6f182f80f49d49b096f0973acf528 WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##0664c28b6b194c7d975de622982a80c5] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 10:50:19,716 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##59c6f182f80f49d49b096f0973acf528] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-20 10:50:19,718 线程ID: 8 日志级别: 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.[10ad808e-779d-4a26-967e-4bac3f454ec9] FROM [##59c6f182f80f49d49b096f0973acf528] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-20 10:50:20,978 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##86f971403d994bcea95f6397bdab78ef] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-02-20 10:50:20,981 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##86f971403d994bcea95f6397bdab78ef] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##86f971403d994bcea95f6397bdab78ef] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##e8ffc75b8e9b4e84805877d8a8455064] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 10:50:21,051 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##86f971403d994bcea95f6397bdab78ef] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##86f971403d994bcea95f6397bdab78ef] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##e8ffc75b8e9b4e84805877d8a8455064] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 10:50:21,119 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##86f971403d994bcea95f6397bdab78ef] 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 ##86f971403d994bcea95f6397bdab78ef WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##e8ffc75b8e9b4e84805877d8a8455064] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 10:50:21,259 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##86f971403d994bcea95f6397bdab78ef] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-20 10:50:21,261 线程ID: 33 日志级别: 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.[10ad808e-779d-4a26-967e-4bac3f454ec9] FROM [##86f971403d994bcea95f6397bdab78ef] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-20 11:10:37,802 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##cbb3f9e623a049b7923ba28e2c78a210] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CMoveIn' AND A.ShopTInID = BillNo ) 时间: 2021-02-20 11:10:37,809 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##cbb3f9e623a049b7923ba28e2c78a210] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##cbb3f9e623a049b7923ba28e2c78a210] A INNER JOIN ShopTin B ON A.ShopTInID = B.ShopTInID WHERE 1 = 1 时间: 2021-02-20 11:10:37,812 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0), BalanceAmount = ISNULL(B.BalanceAmount,0) FROM [##cbb3f9e623a049b7923ba28e2c78a210] A INNER JOIN ( SELECT A.ShopTinID, 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, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As BalanceAmount 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.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##cbb3f9e623a049b7923ba28e2c78a210 WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##e080efb95e1a44a284087ee5776f2b1e] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 11:10:37,964 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) FROM [##cbb3f9e623a049b7923ba28e2c78a210] A INNER JOIN ( SELECT A.ShopTinID, SUM(B.Quantity) AS Quantity FROM ShopTin A INNER JOIN [ShopTinGoods] B ON A.ShopTinID = B.ShopTinID WHERE EXISTS( SELECT 1 FROM [##cbb3f9e623a049b7923ba28e2c78a210] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##e080efb95e1a44a284087ee5776f2b1e] WHERE Goods_No = B.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 11:10:38,208 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##cbb3f9e623a049b7923ba28e2c78a210] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-20 11:10:38,213 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , rtrim(ToutShop) AS [调出渠道编号], ToutShopAbv 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.[6407293d-d216-4f2e-b461-d75dc90c19ff] FROM [##cbb3f9e623a049b7923ba28e2c78a210] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-20 11:25:19,147 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##5d5c12ba1b3245bc8d2d6982ff1cbfb9] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CMoveIn' AND A.ShopTInID = BillNo ) 时间: 2021-02-20 11:25:19,151 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##5d5c12ba1b3245bc8d2d6982ff1cbfb9] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##5d5c12ba1b3245bc8d2d6982ff1cbfb9] A INNER JOIN ShopTin B ON A.ShopTInID = B.ShopTInID WHERE 1 = 1 时间: 2021-02-20 11:25:19,154 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0), BalanceAmount = ISNULL(B.BalanceAmount,0) FROM [##5d5c12ba1b3245bc8d2d6982ff1cbfb9] A INNER JOIN ( SELECT A.ShopTinID, 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, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As BalanceAmount 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.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##5d5c12ba1b3245bc8d2d6982ff1cbfb9 WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##d9ec732363444e08961908c43002f7c2] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 11:25:19,308 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) FROM [##5d5c12ba1b3245bc8d2d6982ff1cbfb9] A INNER JOIN ( SELECT A.ShopTinID, SUM(B.Quantity) AS Quantity FROM ShopTin A INNER JOIN [ShopTinGoods] B ON A.ShopTinID = B.ShopTinID WHERE EXISTS( SELECT 1 FROM [##5d5c12ba1b3245bc8d2d6982ff1cbfb9] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##d9ec732363444e08961908c43002f7c2] WHERE Goods_No = B.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 11:25:19,530 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##5d5c12ba1b3245bc8d2d6982ff1cbfb9] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-20 11:25:19,533 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , rtrim(ToutShop) AS [调出渠道编号], ToutShopAbv 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.[547ea9dc-4e9b-4666-bbbb-b428dc3a35ec] FROM [##5d5c12ba1b3245bc8d2d6982ff1cbfb9] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-20 11:25:19,844 线程ID: 107 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##2a7f7982e2294df39cf4a6a6d707b3b9] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CMoveIn' AND A.ShopTInID = BillNo ) 时间: 2021-02-20 11:25:19,847 线程ID: 107 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##2a7f7982e2294df39cf4a6a6d707b3b9] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##2a7f7982e2294df39cf4a6a6d707b3b9] A INNER JOIN ShopTin B ON A.ShopTInID = B.ShopTInID WHERE 1 = 1 时间: 2021-02-20 11:25:19,850 线程ID: 107 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0), BalanceAmount = ISNULL(B.BalanceAmount,0) FROM [##2a7f7982e2294df39cf4a6a6d707b3b9] A INNER JOIN ( SELECT A.ShopTinID, 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, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As BalanceAmount 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.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##2a7f7982e2294df39cf4a6a6d707b3b9 WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##dc1deab7bde643268e397fe33134956d] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 11:25:20,000 线程ID: 107 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) FROM [##2a7f7982e2294df39cf4a6a6d707b3b9] A INNER JOIN ( SELECT A.ShopTinID, SUM(B.Quantity) AS Quantity FROM ShopTin A INNER JOIN [ShopTinGoods] B ON A.ShopTinID = B.ShopTinID WHERE EXISTS( SELECT 1 FROM [##2a7f7982e2294df39cf4a6a6d707b3b9] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##dc1deab7bde643268e397fe33134956d] WHERE Goods_No = B.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 11:25:20,210 线程ID: 107 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##2a7f7982e2294df39cf4a6a6d707b3b9] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-20 11:25:20,214 线程ID: 107 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , rtrim(ToutShop) AS [调出渠道编号], ToutShopAbv 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.[e22fa9b9-f9c7-4fd9-b7e5-6e305bca8719] FROM [##2a7f7982e2294df39cf4a6a6d707b3b9] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-20 11:26:01,409 线程ID: 107 日志级别: 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.[80436d1b-6c69-473a-931f-57dafc21e505] FROM Customer A INNER JOIN [##3d58805e45944c47905b84dc4395854b] B ON A.Customer_ID = B.Customer_ID ORDER BY A.Customer_ID 时间: 2021-02-20 11:26:33,587 线程ID: 112 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##05a4f76631204091817356615a0c22cb] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CMoveIn' AND A.ShopTInID = BillNo ) 时间: 2021-02-20 11:26:33,592 线程ID: 112 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##05a4f76631204091817356615a0c22cb] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##05a4f76631204091817356615a0c22cb] A INNER JOIN ShopTin B ON A.ShopTInID = B.ShopTInID WHERE 1 = 1 时间: 2021-02-20 11:26:33,595 线程ID: 112 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0), BalanceAmount = ISNULL(B.BalanceAmount,0) FROM [##05a4f76631204091817356615a0c22cb] A INNER JOIN ( SELECT A.ShopTinID, 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, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As BalanceAmount 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.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##05a4f76631204091817356615a0c22cb WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##3adcace3b80349c6b62d9f468168279f] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 11:26:33,751 线程ID: 112 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) FROM [##05a4f76631204091817356615a0c22cb] A INNER JOIN ( SELECT A.ShopTinID, SUM(B.Quantity) AS Quantity FROM ShopTin A INNER JOIN [ShopTinGoods] B ON A.ShopTinID = B.ShopTinID WHERE EXISTS( SELECT 1 FROM [##05a4f76631204091817356615a0c22cb] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##3adcace3b80349c6b62d9f468168279f] WHERE Goods_No = B.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 11:26:33,996 线程ID: 112 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##05a4f76631204091817356615a0c22cb] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-20 11:26:33,999 线程ID: 112 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , rtrim(ToutShop) AS [调出渠道编号], ToutShopAbv 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.[b583f2a4-8ccf-4370-b76c-347c588e4051] FROM [##05a4f76631204091817356615a0c22cb] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-20 11:42:31,050 线程ID: 106 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##d49efacf177b453db59de5187d28f602] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CMoveIn' AND A.ShopTInID = BillNo ) 时间: 2021-02-20 11:42:31,054 线程ID: 106 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##d49efacf177b453db59de5187d28f602] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##d49efacf177b453db59de5187d28f602] A INNER JOIN ShopTin B ON A.ShopTInID = B.ShopTInID WHERE 1 = 1 时间: 2021-02-20 11:42:31,056 线程ID: 106 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0), BalanceAmount = ISNULL(B.BalanceAmount,0) FROM [##d49efacf177b453db59de5187d28f602] A INNER JOIN ( SELECT A.ShopTinID, 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, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As BalanceAmount 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.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##d49efacf177b453db59de5187d28f602 WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##93665c66a8b6454e9b8efc4a0353de80] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 11:42:31,198 线程ID: 106 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) FROM [##d49efacf177b453db59de5187d28f602] A INNER JOIN ( SELECT A.ShopTinID, SUM(B.Quantity) AS Quantity FROM ShopTin A INNER JOIN [ShopTinGoods] B ON A.ShopTinID = B.ShopTinID WHERE EXISTS( SELECT 1 FROM [##d49efacf177b453db59de5187d28f602] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##93665c66a8b6454e9b8efc4a0353de80] WHERE Goods_No = B.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 11:42:31,413 线程ID: 106 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##d49efacf177b453db59de5187d28f602] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-20 11:42:31,417 线程ID: 106 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , rtrim(ToutShop) AS [调出渠道编号], ToutShopAbv 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.[6a2d6a65-5e72-4b8b-9d20-7f1e8824c512] FROM [##d49efacf177b453db59de5187d28f602] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-20 14:09:34,970 线程ID: 107 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##786968fb704942ecb3d6bb82a8778896] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-02-20 14:09:34,976 线程ID: 107 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##786968fb704942ecb3d6bb82a8778896] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##786968fb704942ecb3d6bb82a8778896 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##a161ac7de16e44438d149c530e67d768] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-02-20 14:09:35,116 线程ID: 107 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[952e1824-4f90-484c-b59e-5b5bbbb98b5a] FROM [##786968fb704942ecb3d6bb82a8778896] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-02-20 14:09:35,878 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##eaa41562215046d58fa374be52cefe32] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-02-20 14:09:35,882 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##eaa41562215046d58fa374be52cefe32] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##eaa41562215046d58fa374be52cefe32 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##aab89390a53545ac8d0bfc751df2d527] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-02-20 14:09:36,014 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[952e1824-4f90-484c-b59e-5b5bbbb98b5a] FROM [##eaa41562215046d58fa374be52cefe32] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-02-20 14:10:54,394 线程ID: 112 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##6fad1482056546f9a60061bcfd34baaa] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-02-20 14:10:54,398 线程ID: 112 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##6fad1482056546f9a60061bcfd34baaa] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##6fad1482056546f9a60061bcfd34baaa WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##9b0058df851d430ea196cc75432343e6] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-02-20 14:10:54,532 线程ID: 112 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[0c73f1ed-5516-445e-b141-531071de53e4] FROM [##6fad1482056546f9a60061bcfd34baaa] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-02-20 14:10:54,824 线程ID: 110 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##1431cc3d3180476da0a99dcfd17b3672] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-02-20 14:10:54,829 线程ID: 110 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##1431cc3d3180476da0a99dcfd17b3672] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##1431cc3d3180476da0a99dcfd17b3672 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##ce7c86a1a6814d8497ef5a1e04ae4838] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-02-20 14:10:54,961 线程ID: 110 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[ba20059a-866d-4b19-a273-411b8184c553] FROM [##1431cc3d3180476da0a99dcfd17b3672] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-02-20 14:11:32,451 线程ID: 106 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##d0a81326811549099a1b76d21499041d] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-02-20 14:11:32,455 线程ID: 106 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##d0a81326811549099a1b76d21499041d] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##d0a81326811549099a1b76d21499041d WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##24fc19a98507435db72d051df2cfdc0f] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-02-20 14:11:32,606 线程ID: 106 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[598758ce-5ff8-4f0e-8313-741306b1879f] FROM [##d0a81326811549099a1b76d21499041d] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-02-20 14:12:15,213 线程ID: 112 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##0bb07085bf1c4dda84247d39c8354aea] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-02-20 14:12:15,217 线程ID: 112 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##0bb07085bf1c4dda84247d39c8354aea] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##0bb07085bf1c4dda84247d39c8354aea WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##8f74547969354178b8d61bfb8379958d] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-02-20 14:12:15,383 线程ID: 112 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[eda7ff20-5ba7-4335-a495-840de53f06be] FROM [##0bb07085bf1c4dda84247d39c8354aea] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-02-20 14:12:35,146 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##fa6ec41b813f4767829456eca02877d4] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-02-20 14:12:35,149 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##fa6ec41b813f4767829456eca02877d4] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##fa6ec41b813f4767829456eca02877d4 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##a8f4e6c4e73543b0a322cf014addd2c3] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-02-20 14:12:35,289 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[7c07db98-161a-4690-8c2f-6f8f3cda2246] FROM [##fa6ec41b813f4767829456eca02877d4] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-02-20 14:12:35,579 线程ID: 110 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##dac15d5b97a94175870f642f886cf7bd] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-02-20 14:12:35,584 线程ID: 110 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##dac15d5b97a94175870f642f886cf7bd] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##dac15d5b97a94175870f642f886cf7bd WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##9ecb528277b848b5b143d77ac0507d38] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-02-20 14:12:35,724 线程ID: 110 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[3cbbc2d9-5991-46e5-99b4-b3282a249663] FROM [##dac15d5b97a94175870f642f886cf7bd] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-02-20 14:13:01,915 线程ID: 69 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##d500eac9215d463bb2f4e411fc5c55d8] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-02-20 14:13:01,918 线程ID: 69 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##d500eac9215d463bb2f4e411fc5c55d8] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##d500eac9215d463bb2f4e411fc5c55d8 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##f9f185944898410db30e1fbdb186a412] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-02-20 14:13:02,081 线程ID: 69 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[792bebf3-936e-4832-9cbe-23c6740c9a89] FROM [##d500eac9215d463bb2f4e411fc5c55d8] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-02-20 14:28:45,010 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##77f453c7d2f04618ab38752954b77908] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-02-20 14:28:45,014 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##77f453c7d2f04618ab38752954b77908] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##77f453c7d2f04618ab38752954b77908 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##08936687228f456f9c25286dcaba2288] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-02-20 14:28:45,185 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[792bebf3-936e-4832-9cbe-23c6740c9a89] FROM [##77f453c7d2f04618ab38752954b77908] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-02-20 15:43:35,439 线程ID: 69 日志级别: 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.[e1767ef1-6ccd-40d9-a6d2-6489047c808e] FROM [##cdaf49a534f8443e8c025195a27c4ca1] ORDER BY Goods_no 时间: 2021-02-20 15:43:37,073 线程ID: 110 日志级别: 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.[e1767ef1-6ccd-40d9-a6d2-6489047c808e] FROM [##3813c82ebd8144409c5ac1509ed4d25a] ORDER BY Goods_no 时间: 2021-02-20 15:43:37,236 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[e1767ef1-6ccd-40d9-a6d2-6489047c808e] FROM [##39eb9bf4708543879958466a93f7f5a8] ORDER BY Goods_no 时间: 2021-02-20 15:43:37,388 线程ID: 109 日志级别: 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.[e1767ef1-6ccd-40d9-a6d2-6489047c808e] FROM [##78051144ceb34692927327fba9a4a3e4] ORDER BY Goods_no 时间: 2021-02-20 15:43:37,542 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[e1767ef1-6ccd-40d9-a6d2-6489047c808e] FROM [##6ec56fd851dc4239b6f36b1b2ef539d5] ORDER BY Goods_no 时间: 2021-02-20 16:08:11,897 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##740f1fda0d4a4b49806dbe217ae5b358] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2021-02-20 16:08:11,902 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##740f1fda0d4a4b49806dbe217ae5b358] A INNER JOIN ( SELECT A.BalanceID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount FROM [BalanceGoods] A INNER JOIN Goods B ON A.Goods_No = B.Goods_No WHERE EXISTS( SELECT 1 FROM ##740f1fda0d4a4b49806dbe217ae5b358 WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##e4c8e3e0541f4e82bebb7ff0e7814874] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2021-02-20 16:08:12,226 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BalanceID AS [单号], Manual_ID AS [手工单号], Balance_Date [日期] , rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称] , Quantity AS [数量] , DpAmount AS [吊牌额] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], Balance_Date AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[a10f6313-06ce-427c-a1be-fc7ef718e5a5] FROM [##740f1fda0d4a4b49806dbe217ae5b358] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2021-02-20 16:11:36,448 线程ID: 106 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##e1b903deca2449a8b648126a77ae485f] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2021-02-20 16:11:36,452 线程ID: 106 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##e1b903deca2449a8b648126a77ae485f] A INNER JOIN ( SELECT A.BalanceID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount FROM [BalanceGoods] A INNER JOIN Goods B ON A.Goods_No = B.Goods_No WHERE EXISTS( SELECT 1 FROM ##e1b903deca2449a8b648126a77ae485f WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##e4f64bd6fa7c4775ad5233589f53ac87] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2021-02-20 16:11:36,792 线程ID: 106 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BalanceID AS [单号], Manual_ID AS [手工单号], Balance_Date [日期] , rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称] , Quantity AS [数量] , DpAmount AS [吊牌额] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], Balance_Date AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[b34cdb69-dfcc-4798-a67d-4cf3546e82aa] FROM [##e1b903deca2449a8b648126a77ae485f] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2021-02-20 16:11:37,182 线程ID: 69 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##37dbbadfa91b46f4802124e1e2309eb8] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2021-02-20 16:11:37,185 线程ID: 69 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##37dbbadfa91b46f4802124e1e2309eb8] A INNER JOIN ( SELECT A.BalanceID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount FROM [BalanceGoods] A INNER JOIN Goods B ON A.Goods_No = B.Goods_No WHERE EXISTS( SELECT 1 FROM ##37dbbadfa91b46f4802124e1e2309eb8 WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##51fec9e4dc6c4038ba5d0255e98282d6] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2021-02-20 16:11:37,518 线程ID: 69 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BalanceID AS [单号], Manual_ID AS [手工单号], Balance_Date [日期] , rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称] , Quantity AS [数量] , DpAmount AS [吊牌额] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], Balance_Date AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[947bbd73-7141-4784-9254-923e40d6e965] FROM [##37dbbadfa91b46f4802124e1e2309eb8] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2021-02-20 16:12:04,836 线程ID: 69 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##09c840ddf7ca47e5817c50acb971289a] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2021-02-20 16:12:04,840 线程ID: 69 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##09c840ddf7ca47e5817c50acb971289a] A INNER JOIN ( SELECT A.BalanceID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount FROM [BalanceGoods] A INNER JOIN Goods B ON A.Goods_No = B.Goods_No WHERE EXISTS( SELECT 1 FROM ##09c840ddf7ca47e5817c50acb971289a WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##ed970441166f4a4a86af6178f0b675c3] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2021-02-20 16:12:05,160 线程ID: 69 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BalanceID AS [单号], Manual_ID AS [手工单号], Balance_Date [日期] , rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称] , Quantity AS [数量] , DpAmount AS [吊牌额] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], Balance_Date AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[a10f6313-06ce-427c-a1be-fc7ef718e5a5] FROM [##09c840ddf7ca47e5817c50acb971289a] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2021-02-20 16:12:05,955 线程ID: 109 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##3fbd7910670f47829fef483c2c55a22e] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2021-02-20 16:12:05,958 线程ID: 109 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##3fbd7910670f47829fef483c2c55a22e] A INNER JOIN ( SELECT A.BalanceID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount FROM [BalanceGoods] A INNER JOIN Goods B ON A.Goods_No = B.Goods_No WHERE EXISTS( SELECT 1 FROM ##3fbd7910670f47829fef483c2c55a22e WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##4bc9e5adfd314ad9803e37f5fab2baec] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2021-02-20 16:12:06,286 线程ID: 109 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BalanceID AS [单号], Manual_ID AS [手工单号], Balance_Date [日期] , rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称] , Quantity AS [数量] , DpAmount AS [吊牌额] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], Balance_Date AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[a10f6313-06ce-427c-a1be-fc7ef718e5a5] FROM [##3fbd7910670f47829fef483c2c55a22e] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2021-02-20 16:12:34,015 线程ID: 109 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##7d00633d90434c8b961bf9a6b621fd73] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CMoveIn' AND A.ShopTInID = BillNo ) 时间: 2021-02-20 16:12:34,019 线程ID: 109 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##7d00633d90434c8b961bf9a6b621fd73] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##7d00633d90434c8b961bf9a6b621fd73] A INNER JOIN ShopTin B ON A.ShopTInID = B.ShopTInID WHERE 1 = 1 时间: 2021-02-20 16:12:34,022 线程ID: 109 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0), BalanceAmount = ISNULL(B.BalanceAmount,0) FROM [##7d00633d90434c8b961bf9a6b621fd73] A INNER JOIN ( SELECT A.ShopTinID, 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, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As BalanceAmount 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.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##7d00633d90434c8b961bf9a6b621fd73 WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##ce60e11948bb4d07b847e1d03dfced69] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 16:12:34,190 线程ID: 109 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) FROM [##7d00633d90434c8b961bf9a6b621fd73] A INNER JOIN ( SELECT A.ShopTinID, SUM(B.Quantity) AS Quantity FROM ShopTin A INNER JOIN [ShopTinGoods] B ON A.ShopTinID = B.ShopTinID WHERE EXISTS( SELECT 1 FROM [##7d00633d90434c8b961bf9a6b621fd73] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##ce60e11948bb4d07b847e1d03dfced69] WHERE Goods_No = B.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 16:12:34,473 线程ID: 109 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##7d00633d90434c8b961bf9a6b621fd73] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-20 16:12:34,476 线程ID: 109 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , rtrim(ToutShop) AS [调出渠道编号], ToutShopAbv 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.[7d4acf8e-f34e-4654-9a98-e437585d2267] FROM [##7d00633d90434c8b961bf9a6b621fd73] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-20 16:12:36,119 线程ID: 69 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##004860455dbf49afb724128c7443ce46] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CMoveIn' AND A.ShopTInID = BillNo ) 时间: 2021-02-20 16:12:36,123 线程ID: 69 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##004860455dbf49afb724128c7443ce46] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##004860455dbf49afb724128c7443ce46] A INNER JOIN ShopTin B ON A.ShopTInID = B.ShopTInID WHERE 1 = 1 时间: 2021-02-20 16:12:36,126 线程ID: 69 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0), BalanceAmount = ISNULL(B.BalanceAmount,0) FROM [##004860455dbf49afb724128c7443ce46] A INNER JOIN ( SELECT A.ShopTinID, 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, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As BalanceAmount 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.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##004860455dbf49afb724128c7443ce46 WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##c2179beddb584090af7b74e27b59d8b2] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 16:12:36,306 线程ID: 69 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) FROM [##004860455dbf49afb724128c7443ce46] A INNER JOIN ( SELECT A.ShopTinID, SUM(B.Quantity) AS Quantity FROM ShopTin A INNER JOIN [ShopTinGoods] B ON A.ShopTinID = B.ShopTinID WHERE EXISTS( SELECT 1 FROM [##004860455dbf49afb724128c7443ce46] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##c2179beddb584090af7b74e27b59d8b2] WHERE Goods_No = B.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 16:12:36,567 线程ID: 69 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##004860455dbf49afb724128c7443ce46] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-20 16:12:36,571 线程ID: 69 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , rtrim(ToutShop) AS [调出渠道编号], ToutShopAbv 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.[7d4acf8e-f34e-4654-9a98-e437585d2267] FROM [##004860455dbf49afb724128c7443ce46] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-20 16:12:37,852 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##be30f459ea054c1ba59cbc0328be3afa] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CMoveIn' AND A.ShopTInID = BillNo ) 时间: 2021-02-20 16:12:37,856 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##be30f459ea054c1ba59cbc0328be3afa] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##be30f459ea054c1ba59cbc0328be3afa] A INNER JOIN ShopTin B ON A.ShopTInID = B.ShopTInID WHERE 1 = 1 时间: 2021-02-20 16:12:37,859 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0), BalanceAmount = ISNULL(B.BalanceAmount,0) FROM [##be30f459ea054c1ba59cbc0328be3afa] A INNER JOIN ( SELECT A.ShopTinID, 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, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As BalanceAmount 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.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##be30f459ea054c1ba59cbc0328be3afa WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##4bf9b9c0c1d74cdcbe5362fbde961cec] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 16:12:38,025 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) FROM [##be30f459ea054c1ba59cbc0328be3afa] A INNER JOIN ( SELECT A.ShopTinID, SUM(B.Quantity) AS Quantity FROM ShopTin A INNER JOIN [ShopTinGoods] B ON A.ShopTinID = B.ShopTinID WHERE EXISTS( SELECT 1 FROM [##be30f459ea054c1ba59cbc0328be3afa] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##4bf9b9c0c1d74cdcbe5362fbde961cec] WHERE Goods_No = B.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-02-20 16:12:38,273 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##be30f459ea054c1ba59cbc0328be3afa] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-02-20 16:12:38,277 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , rtrim(ToutShop) AS [调出渠道编号], ToutShopAbv 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.[7d4acf8e-f34e-4654-9a98-e437585d2267] FROM [##be30f459ea054c1ba59cbc0328be3afa] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-02-20 16:12:46,271 线程ID: 112 日志级别: 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.[4851613f-5c04-4dee-8716-cd512a9783c9] FROM Customer A INNER JOIN [##0669d2699f0b484aa31c79c096a6c401] B ON A.Customer_ID = B.Customer_ID ORDER BY A.Customer_ID 时间: 2021-02-20 16:14:26,599 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##e5d8ea87d1d84ae1ac74103041d27337] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-02-20 16:14:26,604 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##e5d8ea87d1d84ae1ac74103041d27337] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##e5d8ea87d1d84ae1ac74103041d27337 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##d2b74883819a47bc92749b9c450d98bb] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-02-20 16:14:26,756 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[a4e496df-334e-4b37-aa5a-aabcd0f4835f] FROM [##e5d8ea87d1d84ae1ac74103041d27337] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-02-20 17:26:35,987 线程ID: 106 日志级别: 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.[395978cd-ee3f-41cb-8f03-8a74506836b7] FROM [##e97a1072952c4a12ad0b9827778e83db] ORDER BY Goods_no 时间: 2021-02-20 17:42:16,337 线程ID: 106 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##847d9cc84353482eb707c536facd0663] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-02-20 17:42:16,341 线程ID: 106 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##847d9cc84353482eb707c536facd0663] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##847d9cc84353482eb707c536facd0663 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##581304191c2f4049ba756a74d7bbcfe4] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-02-20 17:42:16,478 线程ID: 106 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[6ba10943-0092-4b6b-8d4f-68a4b46d16f8] FROM [##847d9cc84353482eb707c536facd0663] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-02-20 17:43:08,413 线程ID: 112 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##c97b74c3dd3a4374bc893bbb1592ef40] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2021-02-20 17:43:08,418 线程ID: 112 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##c97b74c3dd3a4374bc893bbb1592ef40] A INNER JOIN ( SELECT A.BalanceID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount FROM [BalanceGoods] A INNER JOIN Goods B ON A.Goods_No = B.Goods_No WHERE EXISTS( SELECT 1 FROM ##c97b74c3dd3a4374bc893bbb1592ef40 WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##c12aea2558ed4259850c50dca3958b7c] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2021-02-20 17:43:08,681 线程ID: 112 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BalanceID AS [单号], Manual_ID AS [手工单号], Balance_Date [日期] , rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称] , Quantity AS [数量] , DpAmount AS [吊牌额] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], Balance_Date AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[28f7f4d4-3a45-430f-bbd7-881093959d73] FROM [##c97b74c3dd3a4374bc893bbb1592ef40] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2021-02-20 18:01:51,854 线程ID: 110 日志级别: 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.[395978cd-ee3f-41cb-8f03-8a74506836b7] FROM [##4f6b55811f234cb99d21be85080a37f6] ORDER BY Goods_no