时间: 2021-02-23 10:21:13,484
  线程ID: 25
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>202</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__businessman__>
    <ID>buisnessmanid</ID>
    <Caption>营业员编号</Caption>
    <Data>1001</Data>
    <ConditionType>2</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>202</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2021-02-23 10:21:13,536
  线程ID: 25
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##caeb01281846427d8fc4797164f1dd2a]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
   AND A.BuisnessManID = @buisnessmanid


 ) A
ORDER BY BuisnessManID


    时间: 2021-02-23 10:21:13,543
  线程ID: 25
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BuisnessManID AS [营业员编号], Name AS [营业员姓名]
     , CustomerID AS [渠道编号], Abbrev AS [渠道简称], Tel1 AS [电话], WorkDate AS [入职日期]
     , [Type] AS [类型], [Status] AS [状态], ParentBuisnessManID AS [营业员上线], ShutOut AS [停用]
INTO tempdb.dbo.[ff72e803-683d-4df7-879d-3746597541f1]
 FROM [##f1be3766ad554db1a35987852af39c98]
 ORDER BY BuisnessManID ASC, WorkDate DESC


    时间: 2021-02-23 10:21:20,356
  线程ID: 32
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>202</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__businessman__>
    <ID>buisnessmanid</ID>
    <Caption>营业员编号</Caption>
    <Data>1002</Data>
    <ConditionType>2</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>202</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2021-02-23 10:21:20,359
  线程ID: 32
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##85aa760ee9204ab59d186b15e33331fd]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
   AND A.BuisnessManID = @buisnessmanid


 ) A
ORDER BY BuisnessManID


    时间: 2021-02-23 10:21:20,368
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BuisnessManID AS [营业员编号], Name AS [营业员姓名]
     , CustomerID AS [渠道编号], Abbrev AS [渠道简称], Tel1 AS [电话], WorkDate AS [入职日期]
     , [Type] AS [类型], [Status] AS [状态], ParentBuisnessManID AS [营业员上线], ShutOut AS [停用]
INTO tempdb.dbo.[ff72e803-683d-4df7-879d-3746597541f1]
 FROM [##8d33c348d3a844dc86aff4e6017b1b5a]
 ORDER BY BuisnessManID ASC, WorkDate DESC


    时间: 2021-02-23 10:54:08,046
  线程ID: 17
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>202</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__businessman__>
    <ID>buisnessmanid</ID>
    <Caption>营业员编号</Caption>
    <Data>1004</Data>
    <ConditionType>2</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>202</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2021-02-23 10:54:08,049
  线程ID: 17
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##37d40faf448845578b5bfd235dddb4e2]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
   AND A.BuisnessManID = @buisnessmanid


 ) A
ORDER BY BuisnessManID


    时间: 2021-02-23 10:54:08,056
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BuisnessManID AS [营业员编号], Name AS [营业员姓名]
     , CustomerID AS [渠道编号], Abbrev AS [渠道简称], Tel1 AS [电话], WorkDate AS [入职日期]
     , [Type] AS [类型], [Status] AS [状态], ParentBuisnessManID AS [营业员上线], ShutOut AS [停用]
INTO tempdb.dbo.[ff72e803-683d-4df7-879d-3746597541f1]
 FROM [##953d8ca920714e49b62f58c1a3e6e38d]
 ORDER BY BuisnessManID ASC, WorkDate DESC


    时间: 2021-02-23 10:56:40,254
  线程ID: 7
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>202</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__businessman__>
    <ID>buisnessmanid</ID>
    <Caption>营业员编号</Caption>
    <Data>1013</Data>
    <ConditionType>2</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>202</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2021-02-23 10:56:40,255
  线程ID: 7
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##20e3a028bfdd4c9783f557d1281ca2b5]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1
   AND A.BuisnessManID = @buisnessmanid


 ) A
ORDER BY BuisnessManID


    时间: 2021-02-23 10:56:40,265
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BuisnessManID AS [营业员编号], Name AS [营业员姓名]
     , CustomerID AS [渠道编号], Abbrev AS [渠道简称], Tel1 AS [电话], WorkDate AS [入职日期]
     , [Type] AS [类型], [Status] AS [状态], ParentBuisnessManID AS [营业员上线], ShutOut AS [停用]
INTO tempdb.dbo.[9379991a-73ef-4c39-95a9-e81e937c2bdf]
 FROM [##2243b377189f45ab90a9a28f1159ab5c]
 ORDER BY BuisnessManID ASC, WorkDate DESC


    时间: 2021-02-23 11:18:53,575
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称]
,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式]
,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额]
,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣]
,[Group] [组], Company_ID [公司编号], SaleMan [业务员]
,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别]
INTO tempdb.dbo.[bba5febe-ae3b-4811-9d24-a9531be031fa]
 FROM Customer A
 INNER JOIN [##eaa7ed5e42a948ca9315238545d8a49f] B ON A.Customer_ID = B.Customer_ID
 ORDER BY A.Customer_ID


    时间: 2021-02-23 15:59:09,534
  线程ID: 28
日志级别: 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 [##dec1f09766e24f8e81ea36147370cc0c]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-02-23 15:59:09,895
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##dec1f09766e24f8e81ea36147370cc0c] (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 [##4ec9d025fe104884b1a0bb5766993ad8] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-02-23 15:59:26,399
  线程ID: 46
日志级别: 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 [##963f2263d7874994a7f8c0dc05ea5de4]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-02-23 15:59:26,590
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##963f2263d7874994a7f8c0dc05ea5de4] (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 [##fabf716984b64656ac24e6940a192318] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-02-23 15:59:30,863
  线程ID: 18
日志级别: 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 [##fab4cb5649194f2388662c0613b21b75]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-02-23 15:59:31,071
  线程ID: 18
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##fab4cb5649194f2388662c0613b21b75] (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 [##889751f7a5c441ca9bba9a2f78550e30] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-02-23 16:00:23,826
  线程ID: 29
日志级别: 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 [##b79cdc0bdb124cafbb4d720b7847d6a6]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-02-23 16:00:24,029
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b79cdc0bdb124cafbb4d720b7847d6a6] (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 [##71b8541fca36494b97c4d65046ba2779] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-02-23 16:00:49,648
  线程ID: 18
日志级别: 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 [##2938daa3945c4b2ab0fc5ce7080e6fe2]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-02-23 16:00:49,857
  线程ID: 18
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##2938daa3945c4b2ab0fc5ce7080e6fe2] (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 [##39f6a779562f49f9916369fb9c8c8e33] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-02-23 16:01:10,363
  线程ID: 18
日志级别: 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 [##5b48ffe03d0848368954ccef2499db0d]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-02-23 16:01:10,585
  线程ID: 18
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##5b48ffe03d0848368954ccef2499db0d] (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 [##d6aea0fa701144d6b3ed1041139410b4] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-02-23 16:01:25,199
  线程ID: 44
日志级别: 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 [##242c831ae6ef45dc8db57daa1342d00a]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-02-23 16:01:25,405
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##242c831ae6ef45dc8db57daa1342d00a] (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 [##a66b24ed9a824e7787be6fb0d9f0879c] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-02-23 16:01:37,493
  线程ID: 47
日志级别: 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 [##9dfbf34bee3b427781a07ebf2b1dd1d2]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-02-23 16:01:37,702
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##9dfbf34bee3b427781a07ebf2b1dd1d2] (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 [##018ac4d16ef24b8492de73b58c622045] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-02-23 16:01:48,837
  线程ID: 46
日志级别: 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 [##d8d3e5b1d73c457e8cd3ae486a5768b2]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-02-23 16:01:49,038
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##d8d3e5b1d73c457e8cd3ae486a5768b2] (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 [##f5fe275ce8a44de58ed6a9debec0651e] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


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


    时间: 2021-02-23 17:28:42,387
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##c85ff2f2444a4a7485a369a5f8c05b0e] 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 ##c85ff2f2444a4a7485a369a5f8c05b0e WHERE A.BalanceID = BalanceID )
     AND EXISTS (SELECT 1 FROM [##3397efe4365d4a79be383d6155a4263b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.BalanceID
    ) B ON A.BalanceID = B.BalanceID


    时间: 2021-02-23 17:28:42,653
  线程ID: 84
日志级别: 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.[b5861ba3-8bd7-4a07-a545-8e8333cda2dc]
 FROM [##c85ff2f2444a4a7485a369a5f8c05b0e]
 ORDER BY Balance_Date DESC, BalanceID ASC