时间: 2021-03-18 11:59:21,549
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##92c4dd39f0bf44bb83112df2788f2680 ADD 销售类型 VARCHAR(50)

    时间: 2021-03-18 11:59:21,559
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##92c4dd39f0bf44bb83112df2788f2680 a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-03-18 11:59:21,567
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##92c4dd39f0bf44bb83112df2788f2680 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-03-18 11:59:21,574
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##92c4dd39f0bf44bb83112df2788f2680 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.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-03-18 11:59:21,612
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##92c4dd39f0bf44bb83112df2788f2680 SET 销售类型='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') 
AND Status = '退货'


    时间: 2021-03-18 11:59:21,614
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##92c4dd39f0bf44bb83112df2788f2680 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-03-18 11:59:21,661
  线程ID: 35
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##92c4dd39f0bf44bb83112df2788f2680

    时间: 2021-03-18 16:12:09,009
  线程ID: 31
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##66dd72c8e41d41e2b615941aa385f02c] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-03-18 16:12:09,015
  线程ID: 31
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##66dd72c8e41d41e2b615941aa385f02c] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##66dd72c8e41d41e2b615941aa385f02c WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##b88f7215900a44e38234fa333678e87e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-03-18 16:12:09,146
  线程ID: 31
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号]
     , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[b75a6795-43a6-48f1-868a-07a2883804d1]
 FROM [##66dd72c8e41d41e2b615941aa385f02c]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-03-18 16:12:21,846
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##29d665f46449482faf8926feaae20cbe] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-03-18 16:12:21,851
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##29d665f46449482faf8926feaae20cbe] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##29d665f46449482faf8926feaae20cbe WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##7b37ab319d32498d8767caa2dfac1641] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-03-18 16:12:21,971
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号]
     , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[b75a6795-43a6-48f1-868a-07a2883804d1]
 FROM [##29d665f46449482faf8926feaae20cbe]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-03-18 16:16:15,753
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(CT.Company_ID AS VARCHAR(50)) AS Company_ID, A.Customer_ID, B.Goods_No, C.ColorID, CAST('' AS VARCHAR(50)) AS 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 库存合计#数量
INTO [##c000f23544914ba38ac81c4acc43f637]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-03-18 16:16:16,167
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##c000f23544914ba38ac81c4acc43f637] (Company_ID, Customer_ID, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT CT.Company_ID, A.Customer_ID, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##7b6219beae7c4bd0af3ded8a274f2e33] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-03-18 16:16:21,868
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(CT.Company_ID AS VARCHAR(50)) AS Company_ID, A.Customer_ID, B.Goods_No, C.ColorID, CAST('' AS VARCHAR(50)) AS 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 库存合计#数量
INTO [##7c4b00f78aaf4bd99b90be3f36b6fa12]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-03-18 16:16:22,314
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##7c4b00f78aaf4bd99b90be3f36b6fa12] (Company_ID, Customer_ID, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT CT.Company_ID, A.Customer_ID, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##f48a25c7001f4c11b6cc1c4f0b09dfd5] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-03-18 16:16:26,360
  线程ID: 34
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(CT.Company_ID AS VARCHAR(50)) AS Company_ID, A.Customer_ID, B.Goods_No, C.ColorID, CAST('' AS VARCHAR(50)) AS 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 库存合计#数量
INTO [##df8b9010b7ed49278acb6708bb23d9ba]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-03-18 16:16:26,795
  线程ID: 34
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##df8b9010b7ed49278acb6708bb23d9ba] (Company_ID, Customer_ID, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT CT.Company_ID, A.Customer_ID, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##32008d59aafe46ae9d0ce683eccb1343] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-03-18 16:19:43,268
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long
, CAST([S1] AS INT) AS [盘点数#S1]
, CAST([S1] AS INT) AS [账面数#S1]
, CAST([S1] AS INT) AS [差异数#S1]
, CAST(NULL AS INT) AS 盘点数#数量
, CAST(NULL AS INT) AS 账面数#数量
, CAST(NULL AS INT) AS 差异数#数量
, CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#零售金额
, CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#计划成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#公司计划成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#公司成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#吊牌金额
, CAST(NULL AS DECIMAL(30, 2)) AS 账面数#零售金额
, CAST(NULL AS DECIMAL(30, 2)) AS 账面数#计划成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 账面数#公司计划成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 账面数#公司成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 账面数#吊牌金额
, CAST(NULL AS DECIMAL(30, 2)) AS 差异数#零售金额
, CAST(NULL AS DECIMAL(30, 2)) AS 差异数#计划成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 差异数#公司计划成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 差异数#公司成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 差异数#吊牌金额
INTO [##b31d6d471b9b4a849e4d1e8f7ea2a005]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-03-18 16:19:43,278
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.Customer_ID, B.Goods_no, C.Colorid, C.Long
     , SUM(C.[S1]) AS [S1]
 INTO ##f7094c8f04fd49db8da4cbf1c25a81db
 FROM PdStock AS A
 LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId
 LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID
 WHERE A.Type=2 AND PdTimes='三盘' AND A.PdStock_Date='2021/3/18'
 AND A.Posted=1
 AND EXISTS (SELECT 1 FROM [##84f909dc5c2e49588c1748499a93750e] WHERE Customer_ID = A.Customer_ID)
 AND EXISTS (SELECT 1 FROM [##2d1410fbd9a24d66baf7ea15136e3060] WHERE Goods_no = B.Goods_no)
 GROUP BY A.Customer_id, B.Goods_No, C.ColorID, C.Long


    时间: 2021-03-18 16:19:43,299
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##b31d6d471b9b4a849e4d1e8f7ea2a005 (Customer_ID, Goods_no, Colorid, Long
     , [盘点数#S1]
     , 盘点数#数量)
SELECT Customer_ID, Goods_No, ColorID, Long
     , SUM([S1]) AS [S1]
     , SUM(ISNULL([S1], 0))
FROM ##f7094c8f04fd49db8da4cbf1c25a81db
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-03-18 16:19:43,301
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##f7094c8f04fd49db8da4cbf1c25a81db

    时间: 2021-03-18 16:19:43,304
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.Customer_ID, B.Goods_no, C.Colorid, C.Long
     , SUM(C.[S1]) AS [S1]
 INTO ##1fc35075578742cca3137050991f7920
 FROM PdStock AS A
 LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId
 LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID
 WHERE A.Type=2 AND PdTimes='二盘' AND A.PdStock_Date='2021/3/18'
 AND A.Posted=1
 AND EXISTS (SELECT 1 FROM [##84f909dc5c2e49588c1748499a93750e] WHERE Customer_ID = A.Customer_ID)
 AND EXISTS (SELECT 1 FROM [##2d1410fbd9a24d66baf7ea15136e3060] WHERE Goods_no = B.Goods_no)
 AND RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,''))
 NOT IN (SELECT RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) FROM PdStock AS A
 LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId
 LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsId=C.PdStockGoodsId
 WHERE A.Type=2 AND PdTimes='三盘' AND A.PdStock_Date='2021/3/18'
 AND A.Posted=1
 AND EXISTS (SELECT 1 FROM [##84f909dc5c2e49588c1748499a93750e] WHERE Customer_ID = A.Customer_ID)
 AND EXISTS (SELECT 1 FROM [##2d1410fbd9a24d66baf7ea15136e3060] WHERE Goods_no = B.Goods_no)
 )
 GROUP BY A.Customer_id, B.Goods_No, C.ColorID, C.Long


    时间: 2021-03-18 16:19:43,345
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##b31d6d471b9b4a849e4d1e8f7ea2a005 (Customer_ID, Goods_No, ColorID, Long
     , [盘点数#S1]
     , 盘点数#数量)
SELECT Customer_ID, Goods_No, ColorID, Long
     , SUM([S1]) AS [S1]
     , SUM(ISNULL([S1], 0))
FROM ##1fc35075578742cca3137050991f7920
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-03-18 16:19:43,351
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##1fc35075578742cca3137050991f7920

    时间: 2021-03-18 16:19:43,352
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.Customer_ID, B.Goods_no, C.Colorid, C.Long
     , SUM(C.[S1]) AS [S1]
 INTO ##2376f72a05ff4841864d1a94b194a096
 FROM PdStock AS A
 LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId
 LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID
 WHERE A.Type=2 AND PdTimes='一盘' AND A.PdStock_date='2021/3/18'
 AND A.Posted=1
 AND EXISTS (SELECT 1 FROM [##84f909dc5c2e49588c1748499a93750e] WHERE Customer_ID = A.Customer_ID)
 AND EXISTS (SELECT 1 FROM [##2d1410fbd9a24d66baf7ea15136e3060] WHERE Goods_no = B.Goods_no)
 AND RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,''))
 NOT IN (SELECT RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) FROM PdStock AS A
 LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId
 LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID
 WHERE A.Type=2 AND PdTimes='二盘' AND A.PdStock_date='2021/3/18'
 AND A.Posted=1
 AND EXISTS (SELECT 1 FROM [##84f909dc5c2e49588c1748499a93750e] WHERE Customer_ID = A.Customer_ID)
 AND EXISTS (SELECT 1 FROM [##2d1410fbd9a24d66baf7ea15136e3060] WHERE Goods_no = B.Goods_no)
 )
 AND RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) 
 NOT IN (SELECT RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) FROM PdStock AS A
 LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId
 LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID
 WHERE A.Type=2 AND PdTimes='三盘' AND A.PdStock_date='2021/3/18'
 AND A.Posted=1
 AND EXISTS (SELECT 1 FROM [##84f909dc5c2e49588c1748499a93750e] WHERE Customer_ID = A.Customer_ID)
 AND EXISTS (SELECT 1 FROM [##2d1410fbd9a24d66baf7ea15136e3060] WHERE Goods_no = B.Goods_no)
 )
 GROUP BY A.Customer_id, B.Goods_No, C.ColorID, C.Long


    时间: 2021-03-18 16:19:43,444
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##b31d6d471b9b4a849e4d1e8f7ea2a005 (Customer_ID, Goods_No, ColorID, Long
     , [盘点数#S1]
     , 盘点数#数量)
SELECT Customer_ID, Goods_No, ColorID, Long
     , SUM([S1]) AS [S1]
     , SUM(ISNULL([S1], 0))
FROM ##2376f72a05ff4841864d1a94b194a096
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-03-18 16:19:43,460
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##2376f72a05ff4841864d1a94b194a096

    时间: 2021-03-18 16:19:43,866
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##b31d6d471b9b4a849e4d1e8f7ea2a005 (Customer_ID, Goods_No, ColorID, Long
     , [账面数#S1]
     , 账面数#数量)
SELECT Customer_ID, Goods_No, ColorID, Long
     , SUM([S1]) AS [S1]
     , SUM(ISNULL([S1], 0))
FROM ##75a25994b1354a52b305167451e3c63d
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-03-18 16:19:43,893
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##75a25994b1354a52b305167451e3c63d

    时间: 2021-03-18 16:19:43,907
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b31d6d471b9b4a849e4d1e8f7ea2a005 SET 
差异数#S1
 = ISNULL(账面数#S1, 0) - ISNULL(盘点数#S1, 0), 差异数#数量=ISNULL(账面数#数量,0)-ISNULL(盘点数#数量,0)


    时间: 2021-03-18 16:19:43,915
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b31d6d471b9b4a849e4d1e8f7ea2a005 SET 盘点数#吊牌金额=盘点数#数量*G.Unitprice
, 账面数#吊牌金额=账面数#数量*G.unitprice
, 差异数#吊牌金额=差异数#数量*G.unitprice
 FROM Goods AS G WHERE ##b31d6d471b9b4a849e4d1e8f7ea2a005.Goods_No=G.Goods_No


    时间: 2021-03-18 16:19:43,965
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b31d6d471b9b4a849e4d1e8f7ea2a005 SET 盘点数#计划成本金额=盘点数#数量 * ISNULL(VP.CostPrice, 0)
, 账面数#计划成本金额 = 账面数#数量 * ISNULL(VP.CostPrice, 0)
, 差异数#计划成本金额 = 差异数#数量 * ISNULL(VP.CostPrice, 0)
FROM ##b31d6d471b9b4a849e4d1e8f7ea2a005 A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID
LEFT JOIN [vPlan] AS VP ON A.Goods_No=VP.Goods_No


    时间: 2021-03-18 16:19:44,008
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b31d6d471b9b4a849e4d1e8f7ea2a005 SET 盘点数#公司计划成本金额=盘点数#数量 * ISNULL(CPYP.CostPrice, 0)
, 账面数#公司计划成本金额 = 账面数#数量 * ISNULL(CPYP.CostPrice, 0)
, 差异数#公司计划成本金额 = 差异数#数量 * ISNULL(CPYP.CostPrice, 0)
FROM ##b31d6d471b9b4a849e4d1e8f7ea2a005 A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID
LEFT JOIN CompanyCostPlan CPYP ON CPYP.Company_ID = CT.Company_ID AND CPYP.Goods_No = A.Goods_No


    时间: 2021-03-18 16:19:47,161
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long
, CAST([S1] AS INT) AS [盘点数#S1]
, CAST([S1] AS INT) AS [账面数#S1]
, CAST([S1] AS INT) AS [差异数#S1]
, CAST(NULL AS INT) AS 盘点数#数量
, CAST(NULL AS INT) AS 账面数#数量
, CAST(NULL AS INT) AS 差异数#数量
, CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#零售金额
, CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#计划成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#公司计划成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#公司成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#吊牌金额
, CAST(NULL AS DECIMAL(30, 2)) AS 账面数#零售金额
, CAST(NULL AS DECIMAL(30, 2)) AS 账面数#计划成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 账面数#公司计划成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 账面数#公司成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 账面数#吊牌金额
, CAST(NULL AS DECIMAL(30, 2)) AS 差异数#零售金额
, CAST(NULL AS DECIMAL(30, 2)) AS 差异数#计划成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 差异数#公司计划成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 差异数#公司成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 差异数#吊牌金额
INTO [##c51823c809854393b2b7541b0a390aaf]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-03-18 16:19:47,163
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.Customer_ID, B.Goods_no, C.Colorid, C.Long
     , SUM(C.[S1]) AS [S1]
 INTO ##c6726781a53348f880e7dcd5db599f82
 FROM PdStock AS A
 LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId
 LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID
 WHERE A.Type=2 AND PdTimes='三盘' AND A.PdStock_Date='2021/3/18'
 AND EXISTS (SELECT 1 FROM [##8ea4a82fccef438c980811348f46f8fa] WHERE Customer_ID = A.Customer_ID)
 AND EXISTS (SELECT 1 FROM [##4764c64b67ac4624bd92d1de1e8927b2] WHERE Goods_no = B.Goods_no)
 GROUP BY A.Customer_id, B.Goods_No, C.ColorID, C.Long


    时间: 2021-03-18 16:19:47,185
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##c51823c809854393b2b7541b0a390aaf (Customer_ID, Goods_no, Colorid, Long
     , [盘点数#S1]
     , 盘点数#数量)
SELECT Customer_ID, Goods_No, ColorID, Long
     , SUM([S1]) AS [S1]
     , SUM(ISNULL([S1], 0))
FROM ##c6726781a53348f880e7dcd5db599f82
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-03-18 16:19:47,187
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##c6726781a53348f880e7dcd5db599f82

    时间: 2021-03-18 16:19:47,188
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.Customer_ID, B.Goods_no, C.Colorid, C.Long
     , SUM(C.[S1]) AS [S1]
 INTO ##10b55598aad9449393c727b30f4c6372
 FROM PdStock AS A
 LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId
 LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID
 WHERE A.Type=2 AND PdTimes='二盘' AND A.PdStock_Date='2021/3/18'
 AND EXISTS (SELECT 1 FROM [##8ea4a82fccef438c980811348f46f8fa] WHERE Customer_ID = A.Customer_ID)
 AND EXISTS (SELECT 1 FROM [##4764c64b67ac4624bd92d1de1e8927b2] WHERE Goods_no = B.Goods_no)
 AND RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,''))
 NOT IN (SELECT RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) FROM PdStock AS A
 LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId
 LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsId=C.PdStockGoodsId
 WHERE A.Type=2 AND PdTimes='三盘' AND A.PdStock_Date='2021/3/18'
 AND EXISTS (SELECT 1 FROM [##8ea4a82fccef438c980811348f46f8fa] WHERE Customer_ID = A.Customer_ID)
 AND EXISTS (SELECT 1 FROM [##4764c64b67ac4624bd92d1de1e8927b2] WHERE Goods_no = B.Goods_no)
 )
 GROUP BY A.Customer_id, B.Goods_No, C.ColorID, C.Long


    时间: 2021-03-18 16:19:47,228
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##c51823c809854393b2b7541b0a390aaf (Customer_ID, Goods_No, ColorID, Long
     , [盘点数#S1]
     , 盘点数#数量)
SELECT Customer_ID, Goods_No, ColorID, Long
     , SUM([S1]) AS [S1]
     , SUM(ISNULL([S1], 0))
FROM ##10b55598aad9449393c727b30f4c6372
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-03-18 16:19:47,230
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##10b55598aad9449393c727b30f4c6372

    时间: 2021-03-18 16:19:47,231
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.Customer_ID, B.Goods_no, C.Colorid, C.Long
     , SUM(C.[S1]) AS [S1]
 INTO ##ba9c6c4f95dd42e6a8ec6bf3e684ec1e
 FROM PdStock AS A
 LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId
 LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID
 WHERE A.Type=2 AND PdTimes='一盘' AND A.PdStock_date='2021/3/18'
 AND EXISTS (SELECT 1 FROM [##8ea4a82fccef438c980811348f46f8fa] WHERE Customer_ID = A.Customer_ID)
 AND EXISTS (SELECT 1 FROM [##4764c64b67ac4624bd92d1de1e8927b2] WHERE Goods_no = B.Goods_no)
 AND RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,''))
 NOT IN (SELECT RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) FROM PdStock AS A
 LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId
 LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID
 WHERE A.Type=2 AND PdTimes='二盘' AND A.PdStock_date='2021/3/18'
 AND EXISTS (SELECT 1 FROM [##8ea4a82fccef438c980811348f46f8fa] WHERE Customer_ID = A.Customer_ID)
 AND EXISTS (SELECT 1 FROM [##4764c64b67ac4624bd92d1de1e8927b2] WHERE Goods_no = B.Goods_no)
 )
 AND RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) 
 NOT IN (SELECT RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) FROM PdStock AS A
 LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId
 LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID
 WHERE A.Type=2 AND PdTimes='三盘' AND A.PdStock_date='2021/3/18'
 AND EXISTS (SELECT 1 FROM [##8ea4a82fccef438c980811348f46f8fa] WHERE Customer_ID = A.Customer_ID)
 AND EXISTS (SELECT 1 FROM [##4764c64b67ac4624bd92d1de1e8927b2] WHERE Goods_no = B.Goods_no)
 )
 GROUP BY A.Customer_id, B.Goods_No, C.ColorID, C.Long


    时间: 2021-03-18 16:19:47,325
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##c51823c809854393b2b7541b0a390aaf (Customer_ID, Goods_No, ColorID, Long
     , [盘点数#S1]
     , 盘点数#数量)
SELECT Customer_ID, Goods_No, ColorID, Long
     , SUM([S1]) AS [S1]
     , SUM(ISNULL([S1], 0))
FROM ##ba9c6c4f95dd42e6a8ec6bf3e684ec1e
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-03-18 16:19:47,340
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##ba9c6c4f95dd42e6a8ec6bf3e684ec1e

    时间: 2021-03-18 16:19:47,749
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##c51823c809854393b2b7541b0a390aaf (Customer_ID, Goods_No, ColorID, Long
     , [账面数#S1]
     , 账面数#数量)
SELECT Customer_ID, Goods_No, ColorID, Long
     , SUM([S1]) AS [S1]
     , SUM(ISNULL([S1], 0))
FROM ##7de412797fbd40e5b299484d4b519dca
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-03-18 16:19:47,774
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##7de412797fbd40e5b299484d4b519dca

    时间: 2021-03-18 16:19:47,775
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c51823c809854393b2b7541b0a390aaf SET 
差异数#S1
 = ISNULL(账面数#S1, 0) - ISNULL(盘点数#S1, 0), 差异数#数量=ISNULL(盘点数#数量,0)-ISNULL(账面数#数量,0)


    时间: 2021-03-18 16:19:47,785
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c51823c809854393b2b7541b0a390aaf SET 盘点数#吊牌金额=盘点数#数量*G.Unitprice
, 账面数#吊牌金额=账面数#数量*G.unitprice
, 差异数#吊牌金额=差异数#数量*G.unitprice
 FROM Goods AS G WHERE ##c51823c809854393b2b7541b0a390aaf.Goods_No=G.Goods_No


    时间: 2021-03-18 16:19:47,815
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c51823c809854393b2b7541b0a390aaf SET 盘点数#计划成本金额=盘点数#数量 * ISNULL(VP.CostPrice, 0)
, 账面数#计划成本金额 = 账面数#数量 * ISNULL(VP.CostPrice, 0)
, 差异数#计划成本金额 = 差异数#数量 * ISNULL(VP.CostPrice, 0)
FROM ##c51823c809854393b2b7541b0a390aaf A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID
LEFT JOIN [vPlan] AS VP ON A.Goods_No=VP.Goods_No


    时间: 2021-03-18 16:19:47,860
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c51823c809854393b2b7541b0a390aaf SET 盘点数#公司计划成本金额=盘点数#数量 * ISNULL(CPYP.CostPrice, 0)
, 账面数#公司计划成本金额 = 账面数#数量 * ISNULL(CPYP.CostPrice, 0)
, 差异数#公司计划成本金额 = 差异数#数量 * ISNULL(CPYP.CostPrice, 0)
FROM ##c51823c809854393b2b7541b0a390aaf A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID
LEFT JOIN CompanyCostPlan CPYP ON CPYP.Company_ID = CT.Company_ID AND CPYP.Goods_No = A.Goods_No


    时间: 2021-03-18 16:20:48,177
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long
, CAST([S1] AS INT) AS [盘点数#S1]
, CAST([S1] AS INT) AS [账面数#S1]
, CAST([S1] AS INT) AS [差异数#S1]
, CAST(NULL AS INT) AS 盘点数#数量
, CAST(NULL AS INT) AS 账面数#数量
, CAST(NULL AS INT) AS 差异数#数量
, CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#零售金额
, CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#计划成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#公司计划成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#公司成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 盘点数#吊牌金额
, CAST(NULL AS DECIMAL(30, 2)) AS 账面数#零售金额
, CAST(NULL AS DECIMAL(30, 2)) AS 账面数#计划成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 账面数#公司计划成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 账面数#公司成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 账面数#吊牌金额
, CAST(NULL AS DECIMAL(30, 2)) AS 差异数#零售金额
, CAST(NULL AS DECIMAL(30, 2)) AS 差异数#计划成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 差异数#公司计划成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 差异数#公司成本金额
, CAST(NULL AS DECIMAL(30, 2)) AS 差异数#吊牌金额
INTO [##7980064d9c3b424db79a6ec60af52a43]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-03-18 16:20:48,182
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.Customer_ID, B.Goods_no, C.Colorid, C.Long
     , SUM(C.[S1]) AS [S1]
 INTO ##adf8fc0944a94f62befd8e358ae0eead
 FROM PdStock AS A
 LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId
 LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID
 WHERE A.Type=2 AND PdTimes='三盘' AND A.PdStock_Date='2021/3/18'
 AND EXISTS (SELECT 1 FROM [##8ed17a32e3c74dc0930fd7e819d9f986] WHERE Customer_ID = A.Customer_ID)
 AND EXISTS (SELECT 1 FROM [##2d3e8ff07c71437ab2a48a174b21f8f8] WHERE Goods_no = B.Goods_no)
 GROUP BY A.Customer_id, B.Goods_No, C.ColorID, C.Long


    时间: 2021-03-18 16:20:48,203
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##7980064d9c3b424db79a6ec60af52a43 (Customer_ID, Goods_no, Colorid, Long
     , [盘点数#S1]
     , 盘点数#数量)
SELECT Customer_ID, Goods_No, ColorID, Long
     , SUM([S1]) AS [S1]
     , SUM(ISNULL([S1], 0))
FROM ##adf8fc0944a94f62befd8e358ae0eead
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-03-18 16:20:48,205
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##adf8fc0944a94f62befd8e358ae0eead

    时间: 2021-03-18 16:20:48,206
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.Customer_ID, B.Goods_no, C.Colorid, C.Long
     , SUM(C.[S1]) AS [S1]
 INTO ##ea74188f9baf44f4953f3addc5e5c1a8
 FROM PdStock AS A
 LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId
 LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID
 WHERE A.Type=2 AND PdTimes='二盘' AND A.PdStock_Date='2021/3/18'
 AND EXISTS (SELECT 1 FROM [##8ed17a32e3c74dc0930fd7e819d9f986] WHERE Customer_ID = A.Customer_ID)
 AND EXISTS (SELECT 1 FROM [##2d3e8ff07c71437ab2a48a174b21f8f8] WHERE Goods_no = B.Goods_no)
 AND RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,''))
 NOT IN (SELECT RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) FROM PdStock AS A
 LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId
 LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsId=C.PdStockGoodsId
 WHERE A.Type=2 AND PdTimes='三盘' AND A.PdStock_Date='2021/3/18'
 AND EXISTS (SELECT 1 FROM [##8ed17a32e3c74dc0930fd7e819d9f986] WHERE Customer_ID = A.Customer_ID)
 AND EXISTS (SELECT 1 FROM [##2d3e8ff07c71437ab2a48a174b21f8f8] WHERE Goods_no = B.Goods_no)
 )
 GROUP BY A.Customer_id, B.Goods_No, C.ColorID, C.Long


    时间: 2021-03-18 16:20:48,246
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##7980064d9c3b424db79a6ec60af52a43 (Customer_ID, Goods_No, ColorID, Long
     , [盘点数#S1]
     , 盘点数#数量)
SELECT Customer_ID, Goods_No, ColorID, Long
     , SUM([S1]) AS [S1]
     , SUM(ISNULL([S1], 0))
FROM ##ea74188f9baf44f4953f3addc5e5c1a8
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-03-18 16:20:48,249
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##ea74188f9baf44f4953f3addc5e5c1a8

    时间: 2021-03-18 16:20:48,250
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.Customer_ID, B.Goods_no, C.Colorid, C.Long
     , SUM(C.[S1]) AS [S1]
 INTO ##c6e9c98fe492401895b966efdbc708bd
 FROM PdStock AS A
 LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId
 LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID
 WHERE A.Type=2 AND PdTimes='一盘' AND A.PdStock_date='2021/3/18'
 AND EXISTS (SELECT 1 FROM [##8ed17a32e3c74dc0930fd7e819d9f986] WHERE Customer_ID = A.Customer_ID)
 AND EXISTS (SELECT 1 FROM [##2d3e8ff07c71437ab2a48a174b21f8f8] WHERE Goods_no = B.Goods_no)
 AND RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,''))
 NOT IN (SELECT RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) FROM PdStock AS A
 LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId
 LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID
 WHERE A.Type=2 AND PdTimes='二盘' AND A.PdStock_date='2021/3/18'
 AND EXISTS (SELECT 1 FROM [##8ed17a32e3c74dc0930fd7e819d9f986] WHERE Customer_ID = A.Customer_ID)
 AND EXISTS (SELECT 1 FROM [##2d3e8ff07c71437ab2a48a174b21f8f8] WHERE Goods_no = B.Goods_no)
 )
 AND RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) 
 NOT IN (SELECT RTRIM(ISNULL(B.Goods_no,'')) + RTRIM(ISNULL(A.Customer_ID,'')) FROM PdStock AS A
 LEFT JOIN PdStockGoods AS B ON A.PdStockId=B.PdStockId
 LEFT JOIN PdStockDetail AS C ON B.PdStockGoodsID=C.PdStockGoodsID
 WHERE A.Type=2 AND PdTimes='三盘' AND A.PdStock_date='2021/3/18'
 AND EXISTS (SELECT 1 FROM [##8ed17a32e3c74dc0930fd7e819d9f986] WHERE Customer_ID = A.Customer_ID)
 AND EXISTS (SELECT 1 FROM [##2d3e8ff07c71437ab2a48a174b21f8f8] WHERE Goods_no = B.Goods_no)
 )
 GROUP BY A.Customer_id, B.Goods_No, C.ColorID, C.Long


    时间: 2021-03-18 16:20:48,342
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##7980064d9c3b424db79a6ec60af52a43 (Customer_ID, Goods_No, ColorID, Long
     , [盘点数#S1]
     , 盘点数#数量)
SELECT Customer_ID, Goods_No, ColorID, Long
     , SUM([S1]) AS [S1]
     , SUM(ISNULL([S1], 0))
FROM ##c6e9c98fe492401895b966efdbc708bd
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-03-18 16:20:48,361
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##c6e9c98fe492401895b966efdbc708bd

    时间: 2021-03-18 16:20:48,769
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##7980064d9c3b424db79a6ec60af52a43 (Customer_ID, Goods_No, ColorID, Long
     , [账面数#S1]
     , 账面数#数量)
SELECT Customer_ID, Goods_No, ColorID, Long
     , SUM([S1]) AS [S1]
     , SUM(ISNULL([S1], 0))
FROM ##5d751567ddf04fd4a34f21426d022333
GROUP BY Customer_ID, Goods_No, ColorID, Long


    时间: 2021-03-18 16:20:48,794
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##5d751567ddf04fd4a34f21426d022333

    时间: 2021-03-18 16:20:48,796
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##7980064d9c3b424db79a6ec60af52a43 SET 
差异数#S1
 = ISNULL(账面数#S1, 0) - ISNULL(盘点数#S1, 0), 差异数#数量=ISNULL(盘点数#数量,0)-ISNULL(账面数#数量,0)


    时间: 2021-03-18 16:20:48,805
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##7980064d9c3b424db79a6ec60af52a43 SET 盘点数#吊牌金额=盘点数#数量*G.Unitprice
, 账面数#吊牌金额=账面数#数量*G.unitprice
, 差异数#吊牌金额=差异数#数量*G.unitprice
 FROM Goods AS G WHERE ##7980064d9c3b424db79a6ec60af52a43.Goods_No=G.Goods_No


    时间: 2021-03-18 16:20:48,838
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##7980064d9c3b424db79a6ec60af52a43 SET 盘点数#计划成本金额=盘点数#数量 * ISNULL(VP.CostPrice, 0)
, 账面数#计划成本金额 = 账面数#数量 * ISNULL(VP.CostPrice, 0)
, 差异数#计划成本金额 = 差异数#数量 * ISNULL(VP.CostPrice, 0)
FROM ##7980064d9c3b424db79a6ec60af52a43 A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID
LEFT JOIN [vPlan] AS VP ON A.Goods_No=VP.Goods_No


    时间: 2021-03-18 16:20:49,255
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##7980064d9c3b424db79a6ec60af52a43 SET 盘点数#公司计划成本金额=盘点数#数量 * ISNULL(CPYP.CostPrice, 0)
, 账面数#公司计划成本金额 = 账面数#数量 * ISNULL(CPYP.CostPrice, 0)
, 差异数#公司计划成本金额 = 差异数#数量 * ISNULL(CPYP.CostPrice, 0)
FROM ##7980064d9c3b424db79a6ec60af52a43 A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID
LEFT JOIN CompanyCostPlan CPYP ON CPYP.Company_ID = CT.Company_ID AND CPYP.Goods_No = A.Goods_No


    时间: 2021-03-18 16:48:08,385
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##1de8556fc64a4bb5b04dcfdc9f57b4c4] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CBalance' AND A.BalanceID = BillNo )


    时间: 2021-03-18 16:48:08,389
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##1de8556fc64a4bb5b04dcfdc9f57b4c4] A
    INNER JOIN (
        SELECT A.BalanceID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount
        FROM [BalanceGoods] A 
             INNER JOIN Goods B ON A.Goods_No = B.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##1de8556fc64a4bb5b04dcfdc9f57b4c4 WHERE A.BalanceID = BalanceID )
     AND EXISTS (SELECT 1 FROM [##da6c8ca61c0d4758a5c1c1539783a83f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.BalanceID
    ) B ON A.BalanceID = B.BalanceID


    时间: 2021-03-18 16:48:08,595
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BalanceID AS [单号], Manual_ID AS [手工单号], Balance_Date [日期]
, rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称]
, Quantity AS [数量]
, DpAmount AS [吊牌额]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], Balance_Date AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[32952f2b-3cc2-4a6d-bff7-6f2b9b9ea200]
 FROM [##1de8556fc64a4bb5b04dcfdc9f57b4c4]
 ORDER BY Balance_Date DESC, BalanceID ASC


    时间: 2021-03-18 16:56:39,492
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##2e7a1352be454937ade16f21a008dd42] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CBalance' AND A.BalanceID = BillNo )


    时间: 2021-03-18 16:56:39,496
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##2e7a1352be454937ade16f21a008dd42] A
    INNER JOIN (
        SELECT A.BalanceID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount
        FROM [BalanceGoods] A 
             INNER JOIN Goods B ON A.Goods_No = B.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##2e7a1352be454937ade16f21a008dd42 WHERE A.BalanceID = BalanceID )
        GROUP BY A.BalanceID
    ) B ON A.BalanceID = B.BalanceID


    时间: 2021-03-18 16:56:39,544
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BalanceID AS [单号], Manual_ID AS [手工单号], Balance_Date [日期]
, rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称]
, Quantity AS [数量]
, DpAmount AS [吊牌额]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], Balance_Date AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[41fed232-185b-4846-896c-01d177a41587]
 FROM [##2e7a1352be454937ade16f21a008dd42]
 ORDER BY Balance_Date DESC, BalanceID ASC


    时间: 2021-03-18 17:18:23,279
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##19617220826f4c88bbb2e5fb8fcad036] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CBalance' AND A.BalanceID = BillNo )


    时间: 2021-03-18 17:18:23,283
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##19617220826f4c88bbb2e5fb8fcad036] A
    INNER JOIN (
        SELECT A.BalanceID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount
        FROM [BalanceGoods] A 
             INNER JOIN Goods B ON A.Goods_No = B.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##19617220826f4c88bbb2e5fb8fcad036 WHERE A.BalanceID = BalanceID )
     AND EXISTS (SELECT 1 FROM [##08dbe948c8744a8a9370271bb979b6d3] WHERE Goods_No = A.Goods_No)
        GROUP BY A.BalanceID
    ) B ON A.BalanceID = B.BalanceID


    时间: 2021-03-18 17:18:23,474
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BalanceID AS [单号], Manual_ID AS [手工单号], Balance_Date [日期]
, rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称]
, Quantity AS [数量]
, DpAmount AS [吊牌额]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], Balance_Date AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[227f8168-66bd-46bb-8e3f-78299db4a075]
 FROM [##19617220826f4c88bbb2e5fb8fcad036]
 ORDER BY Balance_Date DESC, BalanceID ASC


    时间: 2021-03-18 17:18:39,393
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##718d6323cd874e5082d751ed4afecc12] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CBalance' AND A.BalanceID = BillNo )


    时间: 2021-03-18 17:18:39,396
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##718d6323cd874e5082d751ed4afecc12] A
    INNER JOIN (
        SELECT A.BalanceID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount
        FROM [BalanceGoods] A 
             INNER JOIN Goods B ON A.Goods_No = B.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##718d6323cd874e5082d751ed4afecc12 WHERE A.BalanceID = BalanceID )
     AND EXISTS (SELECT 1 FROM [##d968313135bc4589b1d73809b5d5733d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.BalanceID
    ) B ON A.BalanceID = B.BalanceID


    时间: 2021-03-18 17:18:39,583
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BalanceID AS [单号], Manual_ID AS [手工单号], Balance_Date [日期]
, rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称]
, Quantity AS [数量]
, DpAmount AS [吊牌额]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], Balance_Date AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[227f8168-66bd-46bb-8e3f-78299db4a075]
 FROM [##718d6323cd874e5082d751ed4afecc12]
 ORDER BY Balance_Date DESC, BalanceID ASC


    时间: 2021-03-18 17:19:44,738
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##367c317a9b3849489cca5df9f111584d] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CBalance' AND A.BalanceID = BillNo )


    时间: 2021-03-18 17:19:44,742
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##367c317a9b3849489cca5df9f111584d] A
    INNER JOIN (
        SELECT A.BalanceID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount
        FROM [BalanceGoods] A 
             INNER JOIN Goods B ON A.Goods_No = B.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##367c317a9b3849489cca5df9f111584d WHERE A.BalanceID = BalanceID )
     AND EXISTS (SELECT 1 FROM [##be5874f3e96840eca2250d3bc958b9a3] WHERE Goods_No = A.Goods_No)
        GROUP BY A.BalanceID
    ) B ON A.BalanceID = B.BalanceID


    时间: 2021-03-18 17:19:44,915
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BalanceID AS [单号], Manual_ID AS [手工单号], Balance_Date [日期]
, rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称]
, Quantity AS [数量]
, DpAmount AS [吊牌额]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], Balance_Date AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[227f8168-66bd-46bb-8e3f-78299db4a075]
 FROM [##367c317a9b3849489cca5df9f111584d]
 ORDER BY Balance_Date DESC, BalanceID ASC