时间: 2023-03-14 11:26:05,466 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 B.Goods_No, C.ColorID, C.Long , B.Quantity AS 自营#数量, B.DiscountPrice*B.Quantity AS 自营#生意额 , B.Quantity AS 加盟#数量, B.DiscountPrice*B.Quantity AS 加盟#生意额 , B.Quantity AS 合计#数量, B.DiscountPrice*B.Quantity AS 合计#生意额 INTO ##11c2cc1986134c23a78eabc161c895b6 FROM CheckGoods b,CheckDetail c 时间: 2023-03-14 11:26:05,472 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##11c2cc1986134c23a78eabc161c895b6 (Goods_No, ColorID, Long, 自营#数量, 自营#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [Check] A INNER JOIN CheckGoods B ON A.CheckID=B.CheckID INNER JOIN CheckDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##f8739c20a28d487bae3ba0076165400f WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##e8bba5a9250f4eeca63cae880b5c9b0f WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2023-02-14' AND A.CheckDate <= '2023-03-14' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-14 11:26:05,524 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##11c2cc1986134c23a78eabc161c895b6 (Goods_No, ColorID, Long, 加盟#数量, 加盟#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [CheckL] A INNER JOIN CheckLGoods B ON A.CheckID=B.CheckID INNER JOIN CheckLDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##f8739c20a28d487bae3ba0076165400f WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##e8bba5a9250f4eeca63cae880b5c9b0f WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2023-02-14' AND A.CheckDate <= '2023-03-14' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-14 11:26:05,562 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], A.Long AS [内长], GS.UnitPrice AS [吊牌价], CAST(NULL AS IMAGE) AS [图片], GS.HelpRemember AS [助记码], GS.Brand AS [品牌], GS.Category AS [类别], GS.Category2 AS [二级类别], GS.Range AS [系列], GS.Pattern AS [款型], GS.Item AS [项目], GS.Authorisation AS [授权], GS.Sex AS [性别], GS.Season AS [季节], GS.Year AS [年份], GS.Property AS [属性], GS.XingZhi AS [性质], GS.Unit AS [单位], CONVERT(VARCHAR(10),GS.NewOld,120) AS [上货日期], GS.Designer AS [设计师], GS.Material AS [面料], GS.Material1 AS [面料1], GS.Material2 AS [面料2], GS.Material3 AS [面料3], GS.InsideMaterial AS [里料成份], GS.FillMaterial AS [填充成份], GS.GoodsDate AS [货期], GS.ReturnCycle AS [回货周期], GS.EstimatedDeliveryDate AS [过季时间], GS.Manufacturer AS [厂家编号], GS.ProducingArea AS [产地], GS.Executestandard AS [执行标准], GS.Reserve1 AS [折扣类别], GS.Reserve2 AS [换货类别], GS.Reserve3 AS [客户], GS.Reserve4 AS [保留字段4], GS.SafeCategory AS [安全类别], GS.ListingBand AS [上市波段], GS.Size_class AS [尺码类别], GS.SizeTypeID AS [号型编号], GS.Input_Date AS [货品录入日期], GS.Definition1 AS [新品日期], GS.Definition2 AS [自定义2], GS.Definition3 AS [自定义3], GS.Definition4 AS [自定义4], GS.Definition5 AS [自定义5], GS.Definition6 AS [自定义6], GS.Definition7 AS [自定义7], GS.Definition8 AS [自定义8], GS.Definition9 AS [自定义9], GS.Definition10 AS [自定义10], GS.Definition11 AS [自定义11], GS.Definition12 AS [自定义12], GS.Definition13 AS [自定义13], GS.Definition14 AS [自定义14], GS.Definition15 AS [自定义15], GS.Definition16 AS [自定义16], GS.Definition17 AS [自定义17], GS.Definition18 AS [自定义18], GS.Definition19 AS [自定义19], GS.Definition20 AS [自定义20], GS.GoodsRemark AS [货品备注], GS.WholeSalePrice AS [进货价], dbo.[GetPriceSegmentByPrice](GS.UnitPrice) AS [价格段], GS.DpPrice2 AS [吊牌价2], GS.DpPrice3 AS [吊牌价3], GS.DpPrice4 AS [吊牌价4], GS.DpPrice5 AS [吊牌价5], GS.DpPrice6 AS [吊牌价6], GS.DpPrice7 AS [吊牌价7], GS.DpPrice8 AS [吊牌价8], GS.DpPrice9 AS [吊牌价9], GS.DpPrice10 AS [吊牌价10], GS.DpPrice11 AS [吊牌价11], GS.DpPrice12 AS [吊牌价12] , SUM(自营#数量) AS 自营#数量, SUM(自营#生意额) AS 自营#生意额 , SUM(加盟#数量) AS 加盟#数量, SUM(加盟#生意额) AS 加盟#生意额 , SUM(合计#数量) AS 合计#数量, SUM(合计#生意额) AS 合计#生意额 INTO tempdb.dbo.[35998c3a-1e8d-4f02-a73c-6b48cafb340b] FROM ##11c2cc1986134c23a78eabc161c895b6 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN vGoodsColor VGC ON VGC.Goods_No = A.Goods_No and VGC.ColorID = A.ColorID GROUP BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 ORDER BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 时间: 2023-03-14 11:26:07,555 线程ID: 56 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 B.Goods_No, C.ColorID, C.Long , B.Quantity AS 自营#数量, B.DiscountPrice*B.Quantity AS 自营#生意额 , B.Quantity AS 加盟#数量, B.DiscountPrice*B.Quantity AS 加盟#生意额 , B.Quantity AS 合计#数量, B.DiscountPrice*B.Quantity AS 合计#生意额 INTO ##fc1c9a0e498448afad425a95f60ecbe7 FROM CheckGoods b,CheckDetail c 时间: 2023-03-14 11:26:07,557 线程ID: 56 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##fc1c9a0e498448afad425a95f60ecbe7 (Goods_No, ColorID, Long, 自营#数量, 自营#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [Check] A INNER JOIN CheckGoods B ON A.CheckID=B.CheckID INNER JOIN CheckDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##31cade090340402aa71f79191a840c4f WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##d79137ceeffd42208c7504693be25916 WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2023-02-14' AND A.CheckDate <= '2023-03-14' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-14 11:26:07,611 线程ID: 56 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##fc1c9a0e498448afad425a95f60ecbe7 (Goods_No, ColorID, Long, 加盟#数量, 加盟#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [CheckL] A INNER JOIN CheckLGoods B ON A.CheckID=B.CheckID INNER JOIN CheckLDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##31cade090340402aa71f79191a840c4f WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##d79137ceeffd42208c7504693be25916 WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2023-02-14' AND A.CheckDate <= '2023-03-14' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-14 11:26:07,651 线程ID: 56 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], A.Long AS [内长], GS.UnitPrice AS [吊牌价], CAST(NULL AS IMAGE) AS [图片], GS.HelpRemember AS [助记码], GS.Brand AS [品牌], GS.Category AS [类别], GS.Category2 AS [二级类别], GS.Range AS [系列], GS.Pattern AS [款型], GS.Item AS [项目], GS.Authorisation AS [授权], GS.Sex AS [性别], GS.Season AS [季节], GS.Year AS [年份], GS.Property AS [属性], GS.XingZhi AS [性质], GS.Unit AS [单位], CONVERT(VARCHAR(10),GS.NewOld,120) AS [上货日期], GS.Designer AS [设计师], GS.Material AS [面料], GS.Material1 AS [面料1], GS.Material2 AS [面料2], GS.Material3 AS [面料3], GS.InsideMaterial AS [里料成份], GS.FillMaterial AS [填充成份], GS.GoodsDate AS [货期], GS.ReturnCycle AS [回货周期], GS.EstimatedDeliveryDate AS [过季时间], GS.Manufacturer AS [厂家编号], GS.ProducingArea AS [产地], GS.Executestandard AS [执行标准], GS.Reserve1 AS [折扣类别], GS.Reserve2 AS [换货类别], GS.Reserve3 AS [客户], GS.Reserve4 AS [保留字段4], GS.SafeCategory AS [安全类别], GS.ListingBand AS [上市波段], GS.Size_class AS [尺码类别], GS.SizeTypeID AS [号型编号], GS.Input_Date AS [货品录入日期], GS.Definition1 AS [新品日期], GS.Definition2 AS [自定义2], GS.Definition3 AS [自定义3], GS.Definition4 AS [自定义4], GS.Definition5 AS [自定义5], GS.Definition6 AS [自定义6], GS.Definition7 AS [自定义7], GS.Definition8 AS [自定义8], GS.Definition9 AS [自定义9], GS.Definition10 AS [自定义10], GS.Definition11 AS [自定义11], GS.Definition12 AS [自定义12], GS.Definition13 AS [自定义13], GS.Definition14 AS [自定义14], GS.Definition15 AS [自定义15], GS.Definition16 AS [自定义16], GS.Definition17 AS [自定义17], GS.Definition18 AS [自定义18], GS.Definition19 AS [自定义19], GS.Definition20 AS [自定义20], GS.GoodsRemark AS [货品备注], GS.WholeSalePrice AS [进货价], dbo.[GetPriceSegmentByPrice](GS.UnitPrice) AS [价格段], GS.DpPrice2 AS [吊牌价2], GS.DpPrice3 AS [吊牌价3], GS.DpPrice4 AS [吊牌价4], GS.DpPrice5 AS [吊牌价5], GS.DpPrice6 AS [吊牌价6], GS.DpPrice7 AS [吊牌价7], GS.DpPrice8 AS [吊牌价8], GS.DpPrice9 AS [吊牌价9], GS.DpPrice10 AS [吊牌价10], GS.DpPrice11 AS [吊牌价11], GS.DpPrice12 AS [吊牌价12] , SUM(自营#数量) AS 自营#数量, SUM(自营#生意额) AS 自营#生意额 , SUM(加盟#数量) AS 加盟#数量, SUM(加盟#生意额) AS 加盟#生意额 , SUM(合计#数量) AS 合计#数量, SUM(合计#生意额) AS 合计#生意额 INTO tempdb.dbo.[35998c3a-1e8d-4f02-a73c-6b48cafb340b] FROM ##fc1c9a0e498448afad425a95f60ecbe7 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN vGoodsColor VGC ON VGC.Goods_No = A.Goods_No and VGC.ColorID = A.ColorID GROUP BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 ORDER BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 时间: 2023-03-14 11:26:24,345 线程ID: 56 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 B.Goods_No, C.ColorID, C.Long , B.Quantity AS 自营#数量, B.DiscountPrice*B.Quantity AS 自营#生意额 , B.Quantity AS 加盟#数量, B.DiscountPrice*B.Quantity AS 加盟#生意额 , B.Quantity AS 合计#数量, B.DiscountPrice*B.Quantity AS 合计#生意额 INTO ##e76a4d2a9e4644bda5842dd2f3db73d1 FROM CheckGoods b,CheckDetail c 时间: 2023-03-14 11:26:24,347 线程ID: 56 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##e76a4d2a9e4644bda5842dd2f3db73d1 (Goods_No, ColorID, Long, 自营#数量, 自营#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [Check] A INNER JOIN CheckGoods B ON A.CheckID=B.CheckID INNER JOIN CheckDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##22a5fb5631384032955ab68ecf368e78 WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##1b2ef1925d7f4874a3a6007dcc94dd42 WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2021-09-01' AND A.CheckDate <= '2023-03-14' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-14 11:26:24,430 线程ID: 56 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##e76a4d2a9e4644bda5842dd2f3db73d1 (Goods_No, ColorID, Long, 加盟#数量, 加盟#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [CheckL] A INNER JOIN CheckLGoods B ON A.CheckID=B.CheckID INNER JOIN CheckLDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##22a5fb5631384032955ab68ecf368e78 WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##1b2ef1925d7f4874a3a6007dcc94dd42 WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2021-09-01' AND A.CheckDate <= '2023-03-14' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-14 11:26:24,472 线程ID: 56 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], A.Long AS [内长], GS.UnitPrice AS [吊牌价], CAST(NULL AS IMAGE) AS [图片], GS.HelpRemember AS [助记码], GS.Brand AS [品牌], GS.Category AS [类别], GS.Category2 AS [二级类别], GS.Range AS [系列], GS.Pattern AS [款型], GS.Item AS [项目], GS.Authorisation AS [授权], GS.Sex AS [性别], GS.Season AS [季节], GS.Year AS [年份], GS.Property AS [属性], GS.XingZhi AS [性质], GS.Unit AS [单位], CONVERT(VARCHAR(10),GS.NewOld,120) AS [上货日期], GS.Designer AS [设计师], GS.Material AS [面料], GS.Material1 AS [面料1], GS.Material2 AS [面料2], GS.Material3 AS [面料3], GS.InsideMaterial AS [里料成份], GS.FillMaterial AS [填充成份], GS.GoodsDate AS [货期], GS.ReturnCycle AS [回货周期], GS.EstimatedDeliveryDate AS [过季时间], GS.Manufacturer AS [厂家编号], GS.ProducingArea AS [产地], GS.Executestandard AS [执行标准], GS.Reserve1 AS [折扣类别], GS.Reserve2 AS [换货类别], GS.Reserve3 AS [客户], GS.Reserve4 AS [保留字段4], GS.SafeCategory AS [安全类别], GS.ListingBand AS [上市波段], GS.Size_class AS [尺码类别], GS.SizeTypeID AS [号型编号], GS.Input_Date AS [货品录入日期], GS.Definition1 AS [新品日期], GS.Definition2 AS [自定义2], GS.Definition3 AS [自定义3], GS.Definition4 AS [自定义4], GS.Definition5 AS [自定义5], GS.Definition6 AS [自定义6], GS.Definition7 AS [自定义7], GS.Definition8 AS [自定义8], GS.Definition9 AS [自定义9], GS.Definition10 AS [自定义10], GS.Definition11 AS [自定义11], GS.Definition12 AS [自定义12], GS.Definition13 AS [自定义13], GS.Definition14 AS [自定义14], GS.Definition15 AS [自定义15], GS.Definition16 AS [自定义16], GS.Definition17 AS [自定义17], GS.Definition18 AS [自定义18], GS.Definition19 AS [自定义19], GS.Definition20 AS [自定义20], GS.GoodsRemark AS [货品备注], GS.WholeSalePrice AS [进货价], dbo.[GetPriceSegmentByPrice](GS.UnitPrice) AS [价格段], GS.DpPrice2 AS [吊牌价2], GS.DpPrice3 AS [吊牌价3], GS.DpPrice4 AS [吊牌价4], GS.DpPrice5 AS [吊牌价5], GS.DpPrice6 AS [吊牌价6], GS.DpPrice7 AS [吊牌价7], GS.DpPrice8 AS [吊牌价8], GS.DpPrice9 AS [吊牌价9], GS.DpPrice10 AS [吊牌价10], GS.DpPrice11 AS [吊牌价11], GS.DpPrice12 AS [吊牌价12] , SUM(自营#数量) AS 自营#数量, SUM(自营#生意额) AS 自营#生意额 , SUM(加盟#数量) AS 加盟#数量, SUM(加盟#生意额) AS 加盟#生意额 , SUM(合计#数量) AS 合计#数量, SUM(合计#生意额) AS 合计#生意额 INTO tempdb.dbo.[35998c3a-1e8d-4f02-a73c-6b48cafb340b] FROM ##e76a4d2a9e4644bda5842dd2f3db73d1 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN vGoodsColor VGC ON VGC.Goods_No = A.Goods_No and VGC.ColorID = A.ColorID GROUP BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 ORDER BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 时间: 2023-03-14 11:26:26,677 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 B.Goods_No, C.ColorID, C.Long , B.Quantity AS 自营#数量, B.DiscountPrice*B.Quantity AS 自营#生意额 , B.Quantity AS 加盟#数量, B.DiscountPrice*B.Quantity AS 加盟#生意额 , B.Quantity AS 合计#数量, B.DiscountPrice*B.Quantity AS 合计#生意额 INTO ##494ddcb47e114dd38187a08e29d0de25 FROM CheckGoods b,CheckDetail c 时间: 2023-03-14 11:26:26,679 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##494ddcb47e114dd38187a08e29d0de25 (Goods_No, ColorID, Long, 自营#数量, 自营#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [Check] A INNER JOIN CheckGoods B ON A.CheckID=B.CheckID INNER JOIN CheckDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##7dc214fa479b45dca82fe7b495b11c9a WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##96ab55d0201c46a4bffc80ac4bb5f0fd WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2021-09-01' AND A.CheckDate <= '2023-03-14' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-14 11:26:26,761 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##494ddcb47e114dd38187a08e29d0de25 (Goods_No, ColorID, Long, 加盟#数量, 加盟#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [CheckL] A INNER JOIN CheckLGoods B ON A.CheckID=B.CheckID INNER JOIN CheckLDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##7dc214fa479b45dca82fe7b495b11c9a WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##96ab55d0201c46a4bffc80ac4bb5f0fd WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2021-09-01' AND A.CheckDate <= '2023-03-14' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-14 11:26:26,799 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], A.Long AS [内长], GS.UnitPrice AS [吊牌价], CAST(NULL AS IMAGE) AS [图片], GS.HelpRemember AS [助记码], GS.Brand AS [品牌], GS.Category AS [类别], GS.Category2 AS [二级类别], GS.Range AS [系列], GS.Pattern AS [款型], GS.Item AS [项目], GS.Authorisation AS [授权], GS.Sex AS [性别], GS.Season AS [季节], GS.Year AS [年份], GS.Property AS [属性], GS.XingZhi AS [性质], GS.Unit AS [单位], CONVERT(VARCHAR(10),GS.NewOld,120) AS [上货日期], GS.Designer AS [设计师], GS.Material AS [面料], GS.Material1 AS [面料1], GS.Material2 AS [面料2], GS.Material3 AS [面料3], GS.InsideMaterial AS [里料成份], GS.FillMaterial AS [填充成份], GS.GoodsDate AS [货期], GS.ReturnCycle AS [回货周期], GS.EstimatedDeliveryDate AS [过季时间], GS.Manufacturer AS [厂家编号], GS.ProducingArea AS [产地], GS.Executestandard AS [执行标准], GS.Reserve1 AS [折扣类别], GS.Reserve2 AS [换货类别], GS.Reserve3 AS [客户], GS.Reserve4 AS [保留字段4], GS.SafeCategory AS [安全类别], GS.ListingBand AS [上市波段], GS.Size_class AS [尺码类别], GS.SizeTypeID AS [号型编号], GS.Input_Date AS [货品录入日期], GS.Definition1 AS [新品日期], GS.Definition2 AS [自定义2], GS.Definition3 AS [自定义3], GS.Definition4 AS [自定义4], GS.Definition5 AS [自定义5], GS.Definition6 AS [自定义6], GS.Definition7 AS [自定义7], GS.Definition8 AS [自定义8], GS.Definition9 AS [自定义9], GS.Definition10 AS [自定义10], GS.Definition11 AS [自定义11], GS.Definition12 AS [自定义12], GS.Definition13 AS [自定义13], GS.Definition14 AS [自定义14], GS.Definition15 AS [自定义15], GS.Definition16 AS [自定义16], GS.Definition17 AS [自定义17], GS.Definition18 AS [自定义18], GS.Definition19 AS [自定义19], GS.Definition20 AS [自定义20], GS.GoodsRemark AS [货品备注], GS.WholeSalePrice AS [进货价], dbo.[GetPriceSegmentByPrice](GS.UnitPrice) AS [价格段], GS.DpPrice2 AS [吊牌价2], GS.DpPrice3 AS [吊牌价3], GS.DpPrice4 AS [吊牌价4], GS.DpPrice5 AS [吊牌价5], GS.DpPrice6 AS [吊牌价6], GS.DpPrice7 AS [吊牌价7], GS.DpPrice8 AS [吊牌价8], GS.DpPrice9 AS [吊牌价9], GS.DpPrice10 AS [吊牌价10], GS.DpPrice11 AS [吊牌价11], GS.DpPrice12 AS [吊牌价12] , SUM(自营#数量) AS 自营#数量, SUM(自营#生意额) AS 自营#生意额 , SUM(加盟#数量) AS 加盟#数量, SUM(加盟#生意额) AS 加盟#生意额 , SUM(合计#数量) AS 合计#数量, SUM(合计#生意额) AS 合计#生意额 INTO tempdb.dbo.[35998c3a-1e8d-4f02-a73c-6b48cafb340b] FROM ##494ddcb47e114dd38187a08e29d0de25 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN vGoodsColor VGC ON VGC.Goods_No = A.Goods_No and VGC.ColorID = A.ColorID GROUP BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 ORDER BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 时间: 2023-03-14 11:26:31,203 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 B.Goods_No, C.ColorID, C.Long , B.Quantity AS 自营#数量, B.DiscountPrice*B.Quantity AS 自营#生意额 , B.Quantity AS 加盟#数量, B.DiscountPrice*B.Quantity AS 加盟#生意额 , B.Quantity AS 合计#数量, B.DiscountPrice*B.Quantity AS 合计#生意额 INTO ##acb648dbd13d45a2ade31e15b484be09 FROM CheckGoods b,CheckDetail c 时间: 2023-03-14 11:26:31,206 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##acb648dbd13d45a2ade31e15b484be09 (Goods_No, ColorID, Long, 自营#数量, 自营#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [Check] A INNER JOIN CheckGoods B ON A.CheckID=B.CheckID INNER JOIN CheckDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##e688609a8bb944cf946138513b957abc WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##42d87a0f889046708535a36a486c9ebe WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2021-09-01' AND A.CheckDate <= '2023-03-14' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-14 11:26:31,324 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##acb648dbd13d45a2ade31e15b484be09 (Goods_No, ColorID, Long, 加盟#数量, 加盟#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [CheckL] A INNER JOIN CheckLGoods B ON A.CheckID=B.CheckID INNER JOIN CheckLDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##e688609a8bb944cf946138513b957abc WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##42d87a0f889046708535a36a486c9ebe WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2021-09-01' AND A.CheckDate <= '2023-03-14' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-14 11:26:31,366 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], A.Long AS [内长], GS.UnitPrice AS [吊牌价], CAST(NULL AS IMAGE) AS [图片], GS.HelpRemember AS [助记码], GS.Brand AS [品牌], GS.Category AS [类别], GS.Category2 AS [二级类别], GS.Range AS [系列], GS.Pattern AS [款型], GS.Item AS [项目], GS.Authorisation AS [授权], GS.Sex AS [性别], GS.Season AS [季节], GS.Year AS [年份], GS.Property AS [属性], GS.XingZhi AS [性质], GS.Unit AS [单位], CONVERT(VARCHAR(10),GS.NewOld,120) AS [上货日期], GS.Designer AS [设计师], GS.Material AS [面料], GS.Material1 AS [面料1], GS.Material2 AS [面料2], GS.Material3 AS [面料3], GS.InsideMaterial AS [里料成份], GS.FillMaterial AS [填充成份], GS.GoodsDate AS [货期], GS.ReturnCycle AS [回货周期], GS.EstimatedDeliveryDate AS [过季时间], GS.Manufacturer AS [厂家编号], GS.ProducingArea AS [产地], GS.Executestandard AS [执行标准], GS.Reserve1 AS [折扣类别], GS.Reserve2 AS [换货类别], GS.Reserve3 AS [客户], GS.Reserve4 AS [保留字段4], GS.SafeCategory AS [安全类别], GS.ListingBand AS [上市波段], GS.Size_class AS [尺码类别], GS.SizeTypeID AS [号型编号], GS.Input_Date AS [货品录入日期], GS.Definition1 AS [新品日期], GS.Definition2 AS [自定义2], GS.Definition3 AS [自定义3], GS.Definition4 AS [自定义4], GS.Definition5 AS [自定义5], GS.Definition6 AS [自定义6], GS.Definition7 AS [自定义7], GS.Definition8 AS [自定义8], GS.Definition9 AS [自定义9], GS.Definition10 AS [自定义10], GS.Definition11 AS [自定义11], GS.Definition12 AS [自定义12], GS.Definition13 AS [自定义13], GS.Definition14 AS [自定义14], GS.Definition15 AS [自定义15], GS.Definition16 AS [自定义16], GS.Definition17 AS [自定义17], GS.Definition18 AS [自定义18], GS.Definition19 AS [自定义19], GS.Definition20 AS [自定义20], GS.GoodsRemark AS [货品备注], GS.WholeSalePrice AS [进货价], dbo.[GetPriceSegmentByPrice](GS.UnitPrice) AS [价格段], GS.DpPrice2 AS [吊牌价2], GS.DpPrice3 AS [吊牌价3], GS.DpPrice4 AS [吊牌价4], GS.DpPrice5 AS [吊牌价5], GS.DpPrice6 AS [吊牌价6], GS.DpPrice7 AS [吊牌价7], GS.DpPrice8 AS [吊牌价8], GS.DpPrice9 AS [吊牌价9], GS.DpPrice10 AS [吊牌价10], GS.DpPrice11 AS [吊牌价11], GS.DpPrice12 AS [吊牌价12] , SUM(自营#数量) AS 自营#数量, SUM(自营#生意额) AS 自营#生意额 , SUM(加盟#数量) AS 加盟#数量, SUM(加盟#生意额) AS 加盟#生意额 , SUM(合计#数量) AS 合计#数量, SUM(合计#生意额) AS 合计#生意额 INTO tempdb.dbo.[35998c3a-1e8d-4f02-a73c-6b48cafb340b] FROM ##acb648dbd13d45a2ade31e15b484be09 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN vGoodsColor VGC ON VGC.Goods_No = A.Goods_No and VGC.ColorID = A.ColorID GROUP BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 ORDER BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 时间: 2023-03-14 11:28:21,476 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 B.Goods_No, C.ColorID, C.Long , B.Quantity AS 自营#数量, B.DiscountPrice*B.Quantity AS 自营#生意额 , B.Quantity AS 加盟#数量, B.DiscountPrice*B.Quantity AS 加盟#生意额 , B.Quantity AS 合计#数量, B.DiscountPrice*B.Quantity AS 合计#生意额 INTO ##d0629c0e76ce403d943f00f8ff4ef2d2 FROM CheckGoods b,CheckDetail c 时间: 2023-03-14 11:28:21,478 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d0629c0e76ce403d943f00f8ff4ef2d2 (Goods_No, ColorID, Long, 自营#数量, 自营#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [Check] A INNER JOIN CheckGoods B ON A.CheckID=B.CheckID INNER JOIN CheckDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##a5b79dc690854520b082891a5bc14a58 WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##4c4a50b158174b999dea2932f95e0500 WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2021-09-01' AND A.CheckDate <= '2023-03-14' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-14 11:28:21,592 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d0629c0e76ce403d943f00f8ff4ef2d2 (Goods_No, ColorID, Long, 加盟#数量, 加盟#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [CheckL] A INNER JOIN CheckLGoods B ON A.CheckID=B.CheckID INNER JOIN CheckLDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##a5b79dc690854520b082891a5bc14a58 WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##4c4a50b158174b999dea2932f95e0500 WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2021-09-01' AND A.CheckDate <= '2023-03-14' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-14 11:28:21,631 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], A.Long AS [内长], GS.UnitPrice AS [吊牌价], CAST(NULL AS IMAGE) AS [图片], GS.HelpRemember AS [助记码], GS.Brand AS [品牌], GS.Category AS [类别], GS.Category2 AS [二级类别], GS.Range AS [系列], GS.Pattern AS [款型], GS.Item AS [项目], GS.Authorisation AS [授权], GS.Sex AS [性别], GS.Season AS [季节], GS.Year AS [年份], GS.Property AS [属性], GS.XingZhi AS [性质], GS.Unit AS [单位], CONVERT(VARCHAR(10),GS.NewOld,120) AS [上货日期], GS.Designer AS [设计师], GS.Material AS [面料], GS.Material1 AS [面料1], GS.Material2 AS [面料2], GS.Material3 AS [面料3], GS.InsideMaterial AS [里料成份], GS.FillMaterial AS [填充成份], GS.GoodsDate AS [货期], GS.ReturnCycle AS [回货周期], GS.EstimatedDeliveryDate AS [过季时间], GS.Manufacturer AS [厂家编号], GS.ProducingArea AS [产地], GS.Executestandard AS [执行标准], GS.Reserve1 AS [折扣类别], GS.Reserve2 AS [换货类别], GS.Reserve3 AS [客户], GS.Reserve4 AS [保留字段4], GS.SafeCategory AS [安全类别], GS.ListingBand AS [上市波段], GS.Size_class AS [尺码类别], GS.SizeTypeID AS [号型编号], GS.Input_Date AS [货品录入日期], GS.Definition1 AS [新品日期], GS.Definition2 AS [自定义2], GS.Definition3 AS [自定义3], GS.Definition4 AS [自定义4], GS.Definition5 AS [自定义5], GS.Definition6 AS [自定义6], GS.Definition7 AS [自定义7], GS.Definition8 AS [自定义8], GS.Definition9 AS [自定义9], GS.Definition10 AS [自定义10], GS.Definition11 AS [自定义11], GS.Definition12 AS [自定义12], GS.Definition13 AS [自定义13], GS.Definition14 AS [自定义14], GS.Definition15 AS [自定义15], GS.Definition16 AS [自定义16], GS.Definition17 AS [自定义17], GS.Definition18 AS [自定义18], GS.Definition19 AS [自定义19], GS.Definition20 AS [自定义20], GS.GoodsRemark AS [货品备注], GS.WholeSalePrice AS [进货价], dbo.[GetPriceSegmentByPrice](GS.UnitPrice) AS [价格段], GS.DpPrice2 AS [吊牌价2], GS.DpPrice3 AS [吊牌价3], GS.DpPrice4 AS [吊牌价4], GS.DpPrice5 AS [吊牌价5], GS.DpPrice6 AS [吊牌价6], GS.DpPrice7 AS [吊牌价7], GS.DpPrice8 AS [吊牌价8], GS.DpPrice9 AS [吊牌价9], GS.DpPrice10 AS [吊牌价10], GS.DpPrice11 AS [吊牌价11], GS.DpPrice12 AS [吊牌价12] , SUM(自营#数量) AS 自营#数量, SUM(自营#生意额) AS 自营#生意额 , SUM(加盟#数量) AS 加盟#数量, SUM(加盟#生意额) AS 加盟#生意额 , SUM(合计#数量) AS 合计#数量, SUM(合计#生意额) AS 合计#生意额 INTO tempdb.dbo.[35998c3a-1e8d-4f02-a73c-6b48cafb340b] FROM ##d0629c0e76ce403d943f00f8ff4ef2d2 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN vGoodsColor VGC ON VGC.Goods_No = A.Goods_No and VGC.ColorID = A.ColorID GROUP BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 ORDER BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 时间: 2023-03-14 11:55:25,746 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##ca5544129b8142ab91b308d4e6fc686d] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-03-14 11:55:25,977 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ca5544129b8142ab91b308d4e6fc686d] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##f36e8272be574dc1a63f21ef3025c11c] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 11:55:26,315 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ca5544129b8142ab91b308d4e6fc686d] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##b9d6889262fc4be68f75677e9e75c569] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 11:55:26,913 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ca5544129b8142ab91b308d4e6fc686d] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [可用库存#S1], 可用库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##8eca2afbf8654507947f260ffbb2ef10] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 11:55:26,917 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##ca5544129b8142ab91b308d4e6fc686d] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0), [库存合计#S1] = ISNULL([库存#S1], 0) + ISNULL([在途库存#S1], 0) 时间: 2023-03-14 11:55:26,918 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ca5544129b8142ab91b308d4e6fc686d SET 占用数#数量 = ISNULL(库存#数量,0) - ISNULL(可用库存#数量, 0), [占用数#S1] = ISNULL([库存#S1], 0) - ISNULL([可用库存#S1], 0) 时间: 2023-03-14 11:56:14,809 线程ID: 56 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##ac35cd5bee5a45bdbe051f895c9edbaa] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-14 11:56:15,212 线程ID: 56 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##02b5222e33a5472f89aa1f17ff545144] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-14 11:56:15,213 线程ID: 56 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ac35cd5bee5a45bdbe051f895c9edbaa] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##02b5222e33a5472f89aa1f17ff545144] 时间: 2023-03-14 11:56:15,283 线程ID: 56 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##0f4201f6e00d445ca755b5c4f2357dae a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-14 11:56:15,285 线程ID: 56 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0f4201f6e00d445ca755b5c4f2357dae SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-14 11:56:15,287 线程ID: 56 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##0f4201f6e00d445ca755b5c4f2357dae a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-14 11:56:15,319 线程ID: 56 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0f4201f6e00d445ca755b5c4f2357dae SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-14 11:56:15,321 线程ID: 56 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0f4201f6e00d445ca755b5c4f2357dae SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-14 11:56:15,324 线程ID: 56 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ac35cd5bee5a45bdbe051f895c9edbaa] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##486a62bbe2fe46a48d1e7ad7032d097b] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-14 11:56:15,327 线程ID: 56 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[615e8138-c405-464a-8976-7ace8ea74f06] FROM ##ac35cd5bee5a45bdbe051f895c9edbaa A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-14 15:03:27,562 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##a97b7fc7ffe747bda6226c17fb55f4a4] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-14 15:03:27,944 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##7a73889d6d1e4d578806702e55fb9f71] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-14 15:03:27,946 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a97b7fc7ffe747bda6226c17fb55f4a4] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##7a73889d6d1e4d578806702e55fb9f71] 时间: 2023-03-14 15:03:28,005 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ab5c0d4816e740cb9a4317dc8a38baa2 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-14 15:03:28,007 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ab5c0d4816e740cb9a4317dc8a38baa2 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-14 15:03:28,010 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ab5c0d4816e740cb9a4317dc8a38baa2 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-14 15:03:28,041 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ab5c0d4816e740cb9a4317dc8a38baa2 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-14 15:03:28,043 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ab5c0d4816e740cb9a4317dc8a38baa2 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-14 15:03:28,045 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a97b7fc7ffe747bda6226c17fb55f4a4] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##f86eca196c214643a052029fc8ac6a4f] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-14 15:03:28,050 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[615e8138-c405-464a-8976-7ace8ea74f06] FROM ##a97b7fc7ffe747bda6226c17fb55f4a4 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-14 15:04:33,155 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##7522efa0c3d547e6bebce64a28c73d5a] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-14 15:04:33,531 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##0d7df0e26b324962bb150bfb6c1bb54c] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-14 15:04:33,532 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##7522efa0c3d547e6bebce64a28c73d5a] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##0d7df0e26b324962bb150bfb6c1bb54c] 时间: 2023-03-14 15:04:33,593 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##5eb88bbc2b0947e6a01d2de067929bcb a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-14 15:04:33,595 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5eb88bbc2b0947e6a01d2de067929bcb SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-14 15:04:33,598 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##5eb88bbc2b0947e6a01d2de067929bcb a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-14 15:04:33,628 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5eb88bbc2b0947e6a01d2de067929bcb SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-14 15:04:33,630 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5eb88bbc2b0947e6a01d2de067929bcb SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-14 15:04:33,633 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##7522efa0c3d547e6bebce64a28c73d5a] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##c4fc596aa6034be0846b15ff4c5989fa] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-14 15:04:33,638 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[6a089985-4237-46df-9d9d-4da55da3988b] FROM ##7522efa0c3d547e6bebce64a28c73d5a A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-14 15:04:38,916 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##0d21034c14754cbaaf555ea9eec78e09] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-14 15:04:39,338 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##f99698913e6d42a3818cee771c5030aa] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-14 15:04:39,339 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##0d21034c14754cbaaf555ea9eec78e09] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f99698913e6d42a3818cee771c5030aa] 时间: 2023-03-14 15:04:39,408 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##7aa29d448cd545178dbd7830cb76b4c2 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-14 15:04:39,410 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7aa29d448cd545178dbd7830cb76b4c2 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-14 15:04:39,413 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##7aa29d448cd545178dbd7830cb76b4c2 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-14 15:04:39,443 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7aa29d448cd545178dbd7830cb76b4c2 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-14 15:04:39,444 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7aa29d448cd545178dbd7830cb76b4c2 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-14 15:04:39,448 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##0d21034c14754cbaaf555ea9eec78e09] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##844722be13d249bca93e9dde51b262b9] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-14 15:04:39,453 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[6a089985-4237-46df-9d9d-4da55da3988b] FROM ##0d21034c14754cbaaf555ea9eec78e09 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-14 15:05:47,731 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##478c7739b7ba46188dd93342a8009d4e] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-03-14 15:05:47,949 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##478c7739b7ba46188dd93342a8009d4e] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##bb1cf53ce17a4ee8a984cae14fa37fb1] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:05:48,290 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##478c7739b7ba46188dd93342a8009d4e] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##0cd56507f07642538d941c4c652bdd4e] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:05:48,889 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##478c7739b7ba46188dd93342a8009d4e] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [可用库存#S1], 可用库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##8a42dd4845a84149afaa9c8afb426339] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:05:48,893 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##478c7739b7ba46188dd93342a8009d4e] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0), [库存合计#S1] = ISNULL([库存#S1], 0) + ISNULL([在途库存#S1], 0) 时间: 2023-03-14 15:05:48,895 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##478c7739b7ba46188dd93342a8009d4e SET 占用数#数量 = ISNULL(库存#数量,0) - ISNULL(可用库存#数量, 0), [占用数#S1] = ISNULL([库存#S1], 0) - ISNULL([可用库存#S1], 0) 时间: 2023-03-14 15:14:06,361 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##a31ac089a6ab46a98647b8ed97bf4b85] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-03-14 15:14:06,630 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a31ac089a6ab46a98647b8ed97bf4b85] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##8f888f7967b94e698d9c714d4b0e0677] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:14:06,983 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a31ac089a6ab46a98647b8ed97bf4b85] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##47069588eeee4aa198a3266245484031] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:14:07,586 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a31ac089a6ab46a98647b8ed97bf4b85] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [可用库存#S1], 可用库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##1a4a571118c0487f84fb41acbf24be18] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:14:07,590 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##a31ac089a6ab46a98647b8ed97bf4b85] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0), [库存合计#S1] = ISNULL([库存#S1], 0) + ISNULL([在途库存#S1], 0) 时间: 2023-03-14 15:14:07,591 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a31ac089a6ab46a98647b8ed97bf4b85 SET 占用数#数量 = ISNULL(库存#数量,0) - ISNULL(可用库存#数量, 0), [占用数#S1] = ISNULL([库存#S1], 0) - ISNULL([可用库存#S1], 0) 时间: 2023-03-14 15:14:14,683 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##f0e68cdea0ef4b76921632005aee704a] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-03-14 15:14:14,902 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f0e68cdea0ef4b76921632005aee704a] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##10e7c3bd2fb94724810f5cc815dc4c33] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:14:15,235 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f0e68cdea0ef4b76921632005aee704a] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##8aaf039a0ee34fedb15feeb0ac7ec611] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:14:15,894 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f0e68cdea0ef4b76921632005aee704a] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [可用库存#S1], 可用库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##442517d5b849426497a528a831de6f40] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:14:15,899 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##f0e68cdea0ef4b76921632005aee704a] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0), [库存合计#S1] = ISNULL([库存#S1], 0) + ISNULL([在途库存#S1], 0) 时间: 2023-03-14 15:14:15,902 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f0e68cdea0ef4b76921632005aee704a SET 占用数#数量 = ISNULL(库存#数量,0) - ISNULL(可用库存#数量, 0), [占用数#S1] = ISNULL([库存#S1], 0) - ISNULL([可用库存#S1], 0) 时间: 2023-03-14 15:14:31,730 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##36de7726bda34498a9ce94382b80ed63] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-03-14 15:14:31,952 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##36de7726bda34498a9ce94382b80ed63] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##37f550d3848b4a87a0b590ffac964b71] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:14:32,284 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##36de7726bda34498a9ce94382b80ed63] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##1a24f9a3e2c944b9bd416c4f3d9df37f] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:14:32,894 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##36de7726bda34498a9ce94382b80ed63] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [可用库存#S1], 可用库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##a6e2069732ac4cdeb8e57f7009e4da7a] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:14:32,899 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##36de7726bda34498a9ce94382b80ed63] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0), [库存合计#S1] = ISNULL([库存#S1], 0) + ISNULL([在途库存#S1], 0) 时间: 2023-03-14 15:14:32,900 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##36de7726bda34498a9ce94382b80ed63 SET 占用数#数量 = ISNULL(库存#数量,0) - ISNULL(可用库存#数量, 0), [占用数#S1] = ISNULL([库存#S1], 0) - ISNULL([可用库存#S1], 0) 时间: 2023-03-14 15:14:35,607 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##1817ee1021694511855b652156f11240] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-03-14 15:14:35,822 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##1817ee1021694511855b652156f11240] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##cff0a09745fa486bb3050f4ba09e56b9] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:14:36,155 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##1817ee1021694511855b652156f11240] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##8b601be294354a5092db68eff0ccd5b4] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:14:36,798 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##1817ee1021694511855b652156f11240] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [可用库存#S1], 可用库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##56d162cad0ef4b5e846a93585dc27358] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:14:36,803 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##1817ee1021694511855b652156f11240] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0), [库存合计#S1] = ISNULL([库存#S1], 0) + ISNULL([在途库存#S1], 0) 时间: 2023-03-14 15:14:36,804 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1817ee1021694511855b652156f11240 SET 占用数#数量 = ISNULL(库存#数量,0) - ISNULL(可用库存#数量, 0), [占用数#S1] = ISNULL([库存#S1], 0) - ISNULL([可用库存#S1], 0) 时间: 2023-03-14 15:14:38,332 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##ee9d30263cb641c9bae1908cff5b7fe7] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-03-14 15:14:38,558 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ee9d30263cb641c9bae1908cff5b7fe7] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##37d81ec10e254e99b7477849858956ee] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:14:38,891 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ee9d30263cb641c9bae1908cff5b7fe7] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##d9c9a33a7b0a4cd2ba48a40757dc4060] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:14:39,476 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ee9d30263cb641c9bae1908cff5b7fe7] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [可用库存#S1], 可用库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##c764c172b8c74a0aaf3179d8b497861f] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:14:39,480 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##ee9d30263cb641c9bae1908cff5b7fe7] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0), [库存合计#S1] = ISNULL([库存#S1], 0) + ISNULL([在途库存#S1], 0) 时间: 2023-03-14 15:14:39,481 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ee9d30263cb641c9bae1908cff5b7fe7 SET 占用数#数量 = ISNULL(库存#数量,0) - ISNULL(可用库存#数量, 0), [占用数#S1] = ISNULL([库存#S1], 0) - ISNULL([可用库存#S1], 0) 时间: 2023-03-14 15:14:49,738 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##0754159890d4495eb76f0750f1faae28] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-03-14 15:14:49,954 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##0754159890d4495eb76f0750f1faae28] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##bd655a5ea1a347709e9debe0b84648a2] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:14:50,285 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##0754159890d4495eb76f0750f1faae28] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##8b3e86b539bc42a0a5cb2f6fb7bf7a65] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:14:50,876 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##0754159890d4495eb76f0750f1faae28] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [可用库存#S1], 可用库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##474a728b74dc4c7595cdb87f564fb961] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-03-14 15:14:50,880 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##0754159890d4495eb76f0750f1faae28] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0), [库存合计#S1] = ISNULL([库存#S1], 0) + ISNULL([在途库存#S1], 0) 时间: 2023-03-14 15:14:50,883 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0754159890d4495eb76f0750f1faae28 SET 占用数#数量 = ISNULL(库存#数量,0) - ISNULL(可用库存#数量, 0), [占用数#S1] = ISNULL([库存#S1], 0) - ISNULL([可用库存#S1], 0) 时间: 2023-03-14 15:40:01,246 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##6669c21e8fd443a586fb5190ef5c3b11] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-14 15:40:01,635 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##2d46ebfe486d4e57a68cceb5aab6815f] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-14 15:40:01,637 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6669c21e8fd443a586fb5190ef5c3b11] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##2d46ebfe486d4e57a68cceb5aab6815f] 时间: 2023-03-14 15:40:01,699 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ed2af1f970ec403db317dab77b097b52 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-14 15:40:01,701 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ed2af1f970ec403db317dab77b097b52 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-14 15:40:01,704 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ed2af1f970ec403db317dab77b097b52 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-14 15:40:01,734 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ed2af1f970ec403db317dab77b097b52 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-14 15:40:01,736 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ed2af1f970ec403db317dab77b097b52 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-14 15:40:01,739 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6669c21e8fd443a586fb5190ef5c3b11] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##83650fe9c6254d7a87e6525c9f57af2a] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-14 15:40:01,743 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[6a089985-4237-46df-9d9d-4da55da3988b] FROM ##6669c21e8fd443a586fb5190ef5c3b11 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-14 15:40:21,899 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##1d6c4e4de9b3483d87b4a306602c59cb] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-14 15:40:22,204 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##9fafeb870423463d8ea2f7b5fac07e3a] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-14 15:40:22,206 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##1d6c4e4de9b3483d87b4a306602c59cb] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##9fafeb870423463d8ea2f7b5fac07e3a] 时间: 2023-03-14 15:40:22,254 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##74d9a1d7a10b4ade824fa671dfe08bc5 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-14 15:40:22,255 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##74d9a1d7a10b4ade824fa671dfe08bc5 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-14 15:40:22,257 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##74d9a1d7a10b4ade824fa671dfe08bc5 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-14 15:40:22,283 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##74d9a1d7a10b4ade824fa671dfe08bc5 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-14 15:40:22,285 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##74d9a1d7a10b4ade824fa671dfe08bc5 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-14 15:40:22,288 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##1d6c4e4de9b3483d87b4a306602c59cb] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##e87a6e6826754e2980751a27ce55c82b] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-14 15:40:22,291 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[6a089985-4237-46df-9d9d-4da55da3988b] FROM ##1d6c4e4de9b3483d87b4a306602c59cb A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-14 15:40:29,222 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##c231a70dfd4e417b8ac693e0e0bf6427] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-14 15:40:29,590 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##653b6736e0eb4d0cbc9a75f306bc71ab] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-14 15:40:29,591 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c231a70dfd4e417b8ac693e0e0bf6427] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##653b6736e0eb4d0cbc9a75f306bc71ab] 时间: 2023-03-14 15:40:29,642 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##492622163b6b4589b6a0cbb1dec323e5 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-14 15:40:29,644 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##492622163b6b4589b6a0cbb1dec323e5 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-14 15:40:29,647 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##492622163b6b4589b6a0cbb1dec323e5 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-14 15:40:29,675 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##492622163b6b4589b6a0cbb1dec323e5 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-14 15:40:29,677 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##492622163b6b4589b6a0cbb1dec323e5 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-14 15:40:29,679 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c231a70dfd4e417b8ac693e0e0bf6427] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##163ff10a3ce44c06be2b480c4f6985e1] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-14 15:40:29,685 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[6a089985-4237-46df-9d9d-4da55da3988b] FROM ##c231a70dfd4e417b8ac693e0e0bf6427 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-14 18:05:18,103 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##6c2089a4f93d4f8fbbeb3eca5d50cfbe] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##6c2089a4f93d4f8fbbeb3eca5d50cfbe] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##6c2089a4f93d4f8fbbeb3eca5d50cfbe] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##6c2089a4f93d4f8fbbeb3eca5d50cfbe] WHERE A.DeliveryID = DeliveryID ) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##6c2089a4f93d4f8fbbeb3eca5d50cfbe] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##6c2089a4f93d4f8fbbeb3eca5d50cfbe] WHERE A.Purchase_ID = Purchase_ID ) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##6c2089a4f93d4f8fbbeb3eca5d50cfbe] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##6c2089a4f93d4f8fbbeb3eca5d50cfbe] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##6c2089a4f93d4f8fbbeb3eca5d50cfbe] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2023-03-14 18:05:18,256 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[0dbf5e8c-de61-4d6d-848e-6f86ae92ef4c] FROM [##6c2089a4f93d4f8fbbeb3eca5d50cfbe] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2023-03-14 18:12:23,780 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##84adb2d0c45d45228f883c3fc2b7f0c9] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-14 18:12:24,185 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##0e7b1d8559ec4dd197e4f9a1f856bd35] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-14 18:12:24,187 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##84adb2d0c45d45228f883c3fc2b7f0c9] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##0e7b1d8559ec4dd197e4f9a1f856bd35] 时间: 2023-03-14 18:12:24,239 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a2e77df6feb04a00a5fc908a9680b484 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-14 18:12:24,241 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a2e77df6feb04a00a5fc908a9680b484 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-14 18:12:24,242 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a2e77df6feb04a00a5fc908a9680b484 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-14 18:12:24,269 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a2e77df6feb04a00a5fc908a9680b484 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-14 18:12:24,271 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a2e77df6feb04a00a5fc908a9680b484 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-14 18:12:24,273 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##84adb2d0c45d45228f883c3fc2b7f0c9] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##bb4b20e30cca4adb915a81f9dac9d3c6] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-14 18:12:24,289 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[e1f23f30-c583-4c6f-a33f-1dc76f251ee6] FROM ##84adb2d0c45d45228f883c3fc2b7f0c9 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-14 18:15:17,012 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##a0372e1772614323b8eeef7b9f776fb0] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-14 18:15:17,390 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##1adffe00584149eaa17ec2a7bd64b6af] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-14 18:15:17,391 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a0372e1772614323b8eeef7b9f776fb0] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##1adffe00584149eaa17ec2a7bd64b6af] 时间: 2023-03-14 18:15:17,444 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2b1a9fe05cff4e768d3090614adbace4 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-14 18:15:17,446 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2b1a9fe05cff4e768d3090614adbace4 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-14 18:15:17,449 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2b1a9fe05cff4e768d3090614adbace4 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-14 18:15:17,480 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2b1a9fe05cff4e768d3090614adbace4 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-14 18:15:17,482 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2b1a9fe05cff4e768d3090614adbace4 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-14 18:15:17,485 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a0372e1772614323b8eeef7b9f776fb0] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##c229e5035fd34d49800ef2a83579ee7b] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-14 18:15:17,490 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[e1f23f30-c583-4c6f-a33f-1dc76f251ee6] FROM ##a0372e1772614323b8eeef7b9f776fb0 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-14 18:25:22,603 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##7a258db00c3344e192e228322fb789b1] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-14 18:25:22,979 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##f4f96e8b9ca947669b4cd3bcf8f10cf4] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-14 18:25:22,979 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##7a258db00c3344e192e228322fb789b1] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f4f96e8b9ca947669b4cd3bcf8f10cf4] 时间: 2023-03-14 18:25:23,032 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e457fcd775d74295ad5237faa31ef642 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-14 18:25:23,034 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e457fcd775d74295ad5237faa31ef642 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-14 18:25:23,037 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e457fcd775d74295ad5237faa31ef642 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-14 18:25:23,067 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e457fcd775d74295ad5237faa31ef642 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-14 18:25:23,069 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e457fcd775d74295ad5237faa31ef642 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-14 18:25:23,071 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##7a258db00c3344e192e228322fb789b1] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##ce412e6bcc924cebad31faa62d3a10a6] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-14 18:25:23,076 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[e1f23f30-c583-4c6f-a33f-1dc76f251ee6] FROM ##7a258db00c3344e192e228322fb789b1 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-14 18:27:21,847 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##b7de5a145ae64d6384db8ee246f66f68] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-14 18:27:22,194 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##ccbba9c135fc4bb8ad5fc5f48844deb1] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-14 18:27:22,196 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b7de5a145ae64d6384db8ee246f66f68] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##ccbba9c135fc4bb8ad5fc5f48844deb1] 时间: 2023-03-14 18:27:22,244 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##83d350daeb4d4498a7b338999651b4b0 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-14 18:27:22,246 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##83d350daeb4d4498a7b338999651b4b0 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-14 18:27:22,248 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##83d350daeb4d4498a7b338999651b4b0 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-14 18:27:22,276 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##83d350daeb4d4498a7b338999651b4b0 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-14 18:27:22,278 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##83d350daeb4d4498a7b338999651b4b0 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-14 18:27:22,280 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b7de5a145ae64d6384db8ee246f66f68] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##0046071ad11148e7ac2b0b2df66d6b57] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-14 18:27:22,284 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[e1f23f30-c583-4c6f-a33f-1dc76f251ee6] FROM ##b7de5a145ae64d6384db8ee246f66f68 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-14 18:28:26,463 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##4a933e5c94e14d29945fa86db40879e9] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-14 18:28:26,808 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##f8487505b4864dc99ba425ddcbffb1c5] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-14 18:28:26,809 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4a933e5c94e14d29945fa86db40879e9] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f8487505b4864dc99ba425ddcbffb1c5] 时间: 2023-03-14 18:28:26,858 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##d9061e9000244a11962591c79d66d308 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-14 18:28:26,860 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d9061e9000244a11962591c79d66d308 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-14 18:28:26,863 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##d9061e9000244a11962591c79d66d308 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-14 18:28:26,894 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d9061e9000244a11962591c79d66d308 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-14 18:28:26,896 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d9061e9000244a11962591c79d66d308 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-14 18:28:26,899 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4a933e5c94e14d29945fa86db40879e9] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##903f96fed4a3427abf9d981acf9c72f2] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-14 18:28:26,904 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[e1f23f30-c583-4c6f-a33f-1dc76f251ee6] FROM ##4a933e5c94e14d29945fa86db40879e9 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-14 18:29:16,132 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##6c0a8362f453491e98a79596a1e8cdd0] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-14 18:29:16,571 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##ee7ce6a019254177bf26b14e00f7572b] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-14 18:29:16,573 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6c0a8362f453491e98a79596a1e8cdd0] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##ee7ce6a019254177bf26b14e00f7572b] 时间: 2023-03-14 18:29:16,630 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ca435cf0a2994298bfae8e2b90265006 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-14 18:29:16,632 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ca435cf0a2994298bfae8e2b90265006 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-14 18:29:16,635 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ca435cf0a2994298bfae8e2b90265006 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-14 18:29:16,666 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ca435cf0a2994298bfae8e2b90265006 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-14 18:29:16,667 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ca435cf0a2994298bfae8e2b90265006 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-14 18:29:16,670 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6c0a8362f453491e98a79596a1e8cdd0] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##e61f4fa1c5d04a28a0ebd5d182cfea12] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-14 18:29:16,676 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[e1f23f30-c583-4c6f-a33f-1dc76f251ee6] FROM ##6c0a8362f453491e98a79596a1e8cdd0 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-14 18:29:51,429 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##e0e2e601e5c9430ea163bd7adff2210b] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-14 18:29:51,746 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##bc22615b1d284bea904d4194606d4243] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-14 18:29:51,748 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e0e2e601e5c9430ea163bd7adff2210b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##bc22615b1d284bea904d4194606d4243] 时间: 2023-03-14 18:29:51,797 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##56d830136ccc4f18994bd72e251ea9b8 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-14 18:29:51,799 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##56d830136ccc4f18994bd72e251ea9b8 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-14 18:29:51,801 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##56d830136ccc4f18994bd72e251ea9b8 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-14 18:29:51,827 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##56d830136ccc4f18994bd72e251ea9b8 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-14 18:29:51,828 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##56d830136ccc4f18994bd72e251ea9b8 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-14 18:29:51,830 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e0e2e601e5c9430ea163bd7adff2210b] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##a85d0d9cade749bd853f0c68e33f55d1] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-14 18:29:51,833 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[e1f23f30-c583-4c6f-a33f-1dc76f251ee6] FROM ##e0e2e601e5c9430ea163bd7adff2210b A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-14 18:40:47,037 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##09f0e0d7caa4400fafe847937d4c6ba6] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-14 18:40:47,385 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##80203a2af45a4379b0d167a122d4b644] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-14 18:40:47,386 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##09f0e0d7caa4400fafe847937d4c6ba6] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##80203a2af45a4379b0d167a122d4b644] 时间: 2023-03-14 18:40:47,434 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##cbe787889c6149e6962618d1f0a4712d a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-14 18:40:47,436 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##cbe787889c6149e6962618d1f0a4712d SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-14 18:40:47,438 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##cbe787889c6149e6962618d1f0a4712d a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-14 18:40:47,464 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##cbe787889c6149e6962618d1f0a4712d SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-14 18:40:47,466 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##cbe787889c6149e6962618d1f0a4712d SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-14 18:40:47,469 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##09f0e0d7caa4400fafe847937d4c6ba6] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##1f891f9101db41c488fc4c1549b2fc31] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-14 18:40:47,472 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[e1f23f30-c583-4c6f-a33f-1dc76f251ee6] FROM ##09f0e0d7caa4400fafe847937d4c6ba6 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-14 18:42:46,538 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##e33dfd0b713e48fba9a7c97abd3a63a1] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-14 18:42:46,883 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##fa2af8c41dc74da7bb8654e3c8c6758f] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-14 18:42:46,885 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e33dfd0b713e48fba9a7c97abd3a63a1] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##fa2af8c41dc74da7bb8654e3c8c6758f] 时间: 2023-03-14 18:42:46,934 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##114d4f7f168044518aa5d44a1e3dd4ec a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-14 18:42:46,936 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##114d4f7f168044518aa5d44a1e3dd4ec SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-14 18:42:46,939 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##114d4f7f168044518aa5d44a1e3dd4ec a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-14 18:42:46,967 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##114d4f7f168044518aa5d44a1e3dd4ec SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-14 18:42:46,969 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##114d4f7f168044518aa5d44a1e3dd4ec SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-14 18:42:46,971 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e33dfd0b713e48fba9a7c97abd3a63a1] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##50e2ee32cedb48b3a28d51240a646247] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-14 18:42:46,977 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[e1f23f30-c583-4c6f-a33f-1dc76f251ee6] FROM ##e33dfd0b713e48fba9a7c97abd3a63a1 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-14 18:43:41,782 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##01c8541366e7432ea40d7cb65c9ab29e] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-14 18:43:42,137 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##3d1e55b2d4484ccb8389cee17100d07a] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-14 18:43:42,139 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##01c8541366e7432ea40d7cb65c9ab29e] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##3d1e55b2d4484ccb8389cee17100d07a] 时间: 2023-03-14 18:43:42,190 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##7463640e9aa74461b25852c8d755e390 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-14 18:43:42,192 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7463640e9aa74461b25852c8d755e390 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-14 18:43:42,194 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##7463640e9aa74461b25852c8d755e390 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-14 18:43:42,220 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7463640e9aa74461b25852c8d755e390 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-14 18:43:42,221 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7463640e9aa74461b25852c8d755e390 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-14 18:43:42,224 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##01c8541366e7432ea40d7cb65c9ab29e] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##8d5e897b0b5440e1ba552fd90f4971ba] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-14 18:43:42,227 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[e1f23f30-c583-4c6f-a33f-1dc76f251ee6] FROM ##01c8541366e7432ea40d7cb65c9ab29e A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END