时间: 2022-07-25 11:45:48,782
  线程ID: 105
日志级别: 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 ##8693974affab4f6fbaf04207fe998949
 FROM CheckGoods b,CheckDetail c


    时间: 2022-07-25 11:45:48,814
  线程ID: 105
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##8693974affab4f6fbaf04207fe998949
(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 ##d462f80e5ea742e7ad70833e1bc37a27 WHERE Customer_ID=A.Customer_ID) 
AND EXISTS (SELECT 1 FROM ##26a2b1793c974591b86799bfa8551e2b WHERE Goods_No=B.Goods_No) 
AND A.CheckDate >= '2022-06-25' 
AND A.CheckDate <= '2022-07-25' 
GROUP BY B.Goods_No, C.ColorID, C.Long


    时间: 2022-07-25 11:45:48,896
  线程ID: 105
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##8693974affab4f6fbaf04207fe998949
(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 ##d462f80e5ea742e7ad70833e1bc37a27 WHERE Customer_ID=A.Customer_ID) 
AND EXISTS (SELECT 1 FROM ##26a2b1793c974591b86799bfa8551e2b WHERE Goods_No=B.Goods_No) 
AND A.CheckDate >= '2022-06-25' 
AND A.CheckDate <= '2022-07-25' 
GROUP BY B.Goods_No, C.ColorID, C.Long


    时间: 2022-07-25 11:45:48,949
  线程ID: 105
日志级别: 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.[41dc59f9-b6e0-4b2a-a3af-98aafe9e39a8]
FROM ##8693974affab4f6fbaf04207fe998949 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


    时间: 2022-07-25 11:47:56,261
  线程ID: 53
日志级别: 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 ##a1063150784d409cb658c1ad9d1f4dec
 FROM CheckGoods b,CheckDetail c


    时间: 2022-07-25 11:47:56,263
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##a1063150784d409cb658c1ad9d1f4dec
(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 ##acaf4293c82e4f95a7ce2c5fda2f7cf7 WHERE Customer_ID=A.Customer_ID) 
AND EXISTS (SELECT 1 FROM ##de92f368145d47009777e061a9e04fb2 WHERE Goods_No=B.Goods_No) 
AND A.CheckDate >= '2022-06-25' 
AND A.CheckDate <= '2022-07-25' 
GROUP BY B.Goods_No, C.ColorID, C.Long


    时间: 2022-07-25 11:47:56,345
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##a1063150784d409cb658c1ad9d1f4dec
(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 ##acaf4293c82e4f95a7ce2c5fda2f7cf7 WHERE Customer_ID=A.Customer_ID) 
AND EXISTS (SELECT 1 FROM ##de92f368145d47009777e061a9e04fb2 WHERE Goods_No=B.Goods_No) 
AND A.CheckDate >= '2022-06-25' 
AND A.CheckDate <= '2022-07-25' 
GROUP BY B.Goods_No, C.ColorID, C.Long


    时间: 2022-07-25 11:47:56,394
  线程ID: 53
日志级别: 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 [图片]
 , SUM(自营#数量) AS 自营#数量, SUM(自营#生意额) AS 自营#生意额
 , SUM(加盟#数量) AS 加盟#数量, SUM(加盟#生意额) AS 加盟#生意额
 , SUM(合计#数量) AS 合计#数量, SUM(合计#生意额) AS 合计#生意额
INTO tempdb.dbo.[41dc59f9-b6e0-4b2a-a3af-98aafe9e39a8]
FROM ##a1063150784d409cb658c1ad9d1f4dec 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

ORDER BY  A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice


    时间: 2022-07-25 11:48:57,856
  线程ID: 107
日志级别: 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 ##54e11ae43fc04c7f943cbe88087b2c64
 FROM CheckGoods b,CheckDetail c


    时间: 2022-07-25 11:48:57,858
  线程ID: 107
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##54e11ae43fc04c7f943cbe88087b2c64
(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 ##e7b3cd824226480c9ba6a09921d05fec WHERE Customer_ID=A.Customer_ID) 
AND EXISTS (SELECT 1 FROM ##2e311750842f416c81ce95a9307a6431 WHERE Goods_No=B.Goods_No) 
AND A.CheckDate >= '2022-07-01' 
AND A.CheckDate <= '2022-07-25' 
GROUP BY B.Goods_No, C.ColorID, C.Long


    时间: 2022-07-25 11:48:57,936
  线程ID: 107
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##54e11ae43fc04c7f943cbe88087b2c64
(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 ##e7b3cd824226480c9ba6a09921d05fec WHERE Customer_ID=A.Customer_ID) 
AND EXISTS (SELECT 1 FROM ##2e311750842f416c81ce95a9307a6431 WHERE Goods_No=B.Goods_No) 
AND A.CheckDate >= '2022-07-01' 
AND A.CheckDate <= '2022-07-25' 
GROUP BY B.Goods_No, C.ColorID, C.Long


    时间: 2022-07-25 11:48:57,992
  线程ID: 107
日志级别: 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 [图片]
 , SUM(自营#数量) AS 自营#数量, SUM(自营#生意额) AS 自营#生意额
 , SUM(加盟#数量) AS 加盟#数量, SUM(加盟#生意额) AS 加盟#生意额
 , SUM(合计#数量) AS 合计#数量, SUM(合计#生意额) AS 合计#生意额
INTO tempdb.dbo.[41dc59f9-b6e0-4b2a-a3af-98aafe9e39a8]
FROM ##54e11ae43fc04c7f943cbe88087b2c64 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

ORDER BY  A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice


    时间: 2022-07-25 11:54:51,835
  线程ID: 105
日志级别: 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 ##a9658964bed04387845c7637323a1512
 FROM CheckGoods b,CheckDetail c


    时间: 2022-07-25 11:54:51,837
  线程ID: 105
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##a9658964bed04387845c7637323a1512
(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 ##994c40e4880e4008b2a483675ffe7dcf WHERE Customer_ID=A.Customer_ID) 
AND EXISTS (SELECT 1 FROM ##4c9a229f03bf4328b02ae10634463f7d WHERE Goods_No=B.Goods_No) 
AND A.CheckDate >= '2022-07-01' 
AND A.CheckDate <= '2022-07-25' 
GROUP BY B.Goods_No, C.ColorID, C.Long


    时间: 2022-07-25 11:54:51,915
  线程ID: 105
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##a9658964bed04387845c7637323a1512
(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 ##994c40e4880e4008b2a483675ffe7dcf WHERE Customer_ID=A.Customer_ID) 
AND EXISTS (SELECT 1 FROM ##4c9a229f03bf4328b02ae10634463f7d WHERE Goods_No=B.Goods_No) 
AND A.CheckDate >= '2022-07-01' 
AND A.CheckDate <= '2022-07-25' 
GROUP BY B.Goods_No, C.ColorID, C.Long


    时间: 2022-07-25 11:54:51,965
  线程ID: 105
日志级别: 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 [图片]
 , SUM(自营#数量) AS 自营#数量, SUM(自营#生意额) AS 自营#生意额
 , SUM(加盟#数量) AS 加盟#数量, SUM(加盟#生意额) AS 加盟#生意额
 , SUM(合计#数量) AS 合计#数量, SUM(合计#生意额) AS 合计#生意额
INTO tempdb.dbo.[41dc59f9-b6e0-4b2a-a3af-98aafe9e39a8]
FROM ##a9658964bed04387845c7637323a1512 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

ORDER BY  A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice


    时间: 2022-07-25 12:04:29,785
  线程ID: 107
日志级别: 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 ##c1fa0709dab54e70a09388ea5b1c9ebc
 FROM CheckGoods b,CheckDetail c


    时间: 2022-07-25 12:04:29,787
  线程ID: 107
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##c1fa0709dab54e70a09388ea5b1c9ebc
(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 ##ef0ed143cda14bc9bf9ce754848817b9 WHERE Customer_ID=A.Customer_ID) 
AND EXISTS (SELECT 1 FROM ##85ffd60430444831ad765f24e1819265 WHERE Goods_No=B.Goods_No) 
AND A.CheckDate >= '2021-07-01' 
AND A.CheckDate <= '2022-07-25' 
GROUP BY B.Goods_No, C.ColorID, C.Long


    时间: 2022-07-25 12:04:30,001
  线程ID: 107
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##c1fa0709dab54e70a09388ea5b1c9ebc
(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 ##ef0ed143cda14bc9bf9ce754848817b9 WHERE Customer_ID=A.Customer_ID) 
AND EXISTS (SELECT 1 FROM ##85ffd60430444831ad765f24e1819265 WHERE Goods_No=B.Goods_No) 
AND A.CheckDate >= '2021-07-01' 
AND A.CheckDate <= '2022-07-25' 
GROUP BY B.Goods_No, C.ColorID, C.Long


    时间: 2022-07-25 12:04:30,048
  线程ID: 107
日志级别: 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 [图片]
 , SUM(自营#数量) AS 自营#数量, SUM(自营#生意额) AS 自营#生意额
 , SUM(加盟#数量) AS 加盟#数量, SUM(加盟#生意额) AS 加盟#生意额
 , SUM(合计#数量) AS 合计#数量, SUM(合计#生意额) AS 合计#生意额
INTO tempdb.dbo.[41dc59f9-b6e0-4b2a-a3af-98aafe9e39a8]
FROM ##c1fa0709dab54e70a09388ea5b1c9ebc 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

ORDER BY  A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice