时间: 2021-02-28 19:32:38,747
  线程ID: 10
日志级别: 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 ##0c0465befc5248868c91607bc347e9d2
 FROM CheckGoods b,CheckDetail c


    时间: 2021-02-28 19:32:38,776
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##0c0465befc5248868c91607bc347e9d2
(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 ##66d4f0f78b19448d977c9fe421f4d26b WHERE Customer_ID=A.Customer_ID) 
AND EXISTS (SELECT 1 FROM ##c52cd8513b944be5915dd3dca2731cbc WHERE Goods_No=B.Goods_No) 
AND A.CheckDate >= '2021-02-28' 
AND A.CheckDate <= '2021-02-28' 
GROUP BY B.Goods_No, C.ColorID, C.Long


    时间: 2021-02-28 19:32:38,890
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##0c0465befc5248868c91607bc347e9d2
(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 ##66d4f0f78b19448d977c9fe421f4d26b WHERE Customer_ID=A.Customer_ID) 
AND EXISTS (SELECT 1 FROM ##c52cd8513b944be5915dd3dca2731cbc WHERE Goods_No=B.Goods_No) 
AND A.CheckDate >= '2021-02-28' 
AND A.CheckDate <= '2021-02-28' 
GROUP BY B.Goods_No, C.ColorID, C.Long


    时间: 2021-02-28 19:32:38,945
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  GS.UnitPrice AS [吊牌价], GS.Goods_Name AS [货品名称], CAST(NULL AS IMAGE) AS [图片]
 , SUM(自营#数量) AS 自营#数量, SUM(自营#生意额) AS 自营#生意额
 , SUM(加盟#数量) AS 加盟#数量, SUM(加盟#生意额) AS 加盟#生意额
 , SUM(合计#数量) AS 合计#数量, SUM(合计#生意额) AS 合计#生意额
INTO tempdb.dbo.[f79a7028-c9f2-4d7e-9937-8e54d972451e]
FROM ##0c0465befc5248868c91607bc347e9d2 A
         LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No

GROUP BY  GS.UnitPrice, GS.Goods_Name

ORDER BY  GS.UnitPrice, GS.Goods_Name