时间: 2022-07-30 14:00:10,659
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  SELECT b.Abbrev ,substring(convert(varchar,convert(datetime,a.CheckWorkDate,120),120),1,10) as CheckWorkDate ,c.Name, cus.Customer_id as Customer_id2 ,cus.Abbrev as Abbrev2  
 ,a.Customer_id ,a.Class ,a.Employee ,substring(convert(varchar,convert(datetime,a.OnDuty,120),120),12,8) as WorkTime 
 ,substring(convert(varchar,convert(datetime,a.OffDuty,120),120),12,8) AS GoOffWorkTime 
 INTO ##51bc2bf862db422c84297c0772cacf66
 FROM CheckWork a 
 INNER JOIN Customer b ON a.Customer_ID=b.Customer_id 
 INNER JOIN BuisnessMan c ON a.Employee=c.BuisnessManID 
 LEFT JOIN Customer cus ON cus.Customer_ID=c.CustomerID 
 WHERE Exists(select 1 from  ##7661d87a075c41b39e71959b64916442 where Customer_ID=a.Customer_ID)
   AND a.CheckWorkDate >='2022/6/30 0:00:00' AND a.CheckWorkDate <='2022/7/30 0:00:00'

    时间: 2022-07-30 14:00:17,110
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  SELECT b.Abbrev ,substring(convert(varchar,convert(datetime,a.CheckWorkDate,120),120),1,10) as CheckWorkDate ,c.Name, cus.Customer_id as Customer_id2 ,cus.Abbrev as Abbrev2  
 ,a.Customer_id ,a.Class ,a.Employee ,substring(convert(varchar,convert(datetime,a.OnDuty,120),120),12,8) as WorkTime 
 ,substring(convert(varchar,convert(datetime,a.OffDuty,120),120),12,8) AS GoOffWorkTime 
 INTO ##9809155a8a9a4589a979e9ac13175fe4
 FROM CheckWork a 
 INNER JOIN Customer b ON a.Customer_ID=b.Customer_id 
 INNER JOIN BuisnessMan c ON a.Employee=c.BuisnessManID 
 LEFT JOIN Customer cus ON cus.Customer_ID=c.CustomerID 
 WHERE Exists(select 1 from  ##35ff1721fe724e0eb6ff4b92063a69f7 where Customer_ID=a.Customer_ID)
   AND a.CheckWorkDate >='2022/6/30 0:00:00' AND a.CheckWorkDate <='2022/7/30 0:00:00'

    时间: 2022-07-30 14:10:41,874
  线程ID: 15
日志级别: 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 库存合计#数量
    , 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 [##377ce6d4f61d4422bfff241c7c2ce547]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2022-07-30 14:10:42,151
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##377ce6d4f61d4422bfff241c7c2ce547] (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 [##3ab68588d54a4567b68ccd6ac82e5a3c] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 14:10:42,370
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##377ce6d4f61d4422bfff241c7c2ce547] (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 [##9589af44d36043f79fbbeef923950039] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 14:10:42,376
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##377ce6d4f61d4422bfff241c7c2ce547] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2022-07-30 14:10:47,460
  线程ID: 10
日志级别: 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 库存合计#数量
    , 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 [##1558cdabdae24801a286bfe5f85eb6d3]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2022-07-30 14:10:47,778
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##1558cdabdae24801a286bfe5f85eb6d3] (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 [##cbf4109d2e6b4bc7a4563d074b275da2] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 14:10:47,990
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##1558cdabdae24801a286bfe5f85eb6d3] (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 [##440d3fae4bf840aa8c76f1bc94f67ba8] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 14:10:47,994
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##1558cdabdae24801a286bfe5f85eb6d3] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2022-07-30 14:14:19,307
  线程ID: 23
日志级别: 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 库存合计#数量
    , 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 [##6caa4851716b4af7a4655cdc7cacc0aa]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2022-07-30 14:14:19,628
  线程ID: 23
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##6caa4851716b4af7a4655cdc7cacc0aa] (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 [##9b710a9106f04bf6875aaa69f31f7a14] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 14:14:19,853
  线程ID: 23
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##6caa4851716b4af7a4655cdc7cacc0aa] (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 [##f6094705a03549f08a8257f399ba56db] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 14:14:19,856
  线程ID: 23
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##6caa4851716b4af7a4655cdc7cacc0aa] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2022-07-30 14:14:32,113
  线程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 库存合计#数量
    , 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 [##6921f668d3a041a6b3fb4cd03d29ebe5]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2022-07-30 14:14:32,441
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##6921f668d3a041a6b3fb4cd03d29ebe5] (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 [##4ce4b7a8855048948f59e369b83d7176] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 14:14:32,662
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##6921f668d3a041a6b3fb4cd03d29ebe5] (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 [##a56b7b2ca1784b02932b78253e9fa5ac] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 14:14:32,665
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##6921f668d3a041a6b3fb4cd03d29ebe5] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2022-07-30 16:53:55,544
  线程ID: 74
日志级别: 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 库存合计#数量
    , 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 [##f741c3446f2f4d7386bbe98aa7db5730]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2022-07-30 16:53:55,824
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##f741c3446f2f4d7386bbe98aa7db5730] (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 [##8c9694b5cbc64eaca7afa7ba7b4bbed5] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 16:53:56,041
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##f741c3446f2f4d7386bbe98aa7db5730] (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 [##2abafc06ad9c440692af1b9699a8d11a] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 16:53:56,043
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##f741c3446f2f4d7386bbe98aa7db5730] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2022-07-30 16:53:59,585
  线程ID: 67
日志级别: 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 库存合计#数量
    , 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 [##0800547ce8174a1bafecc2c21edfd386]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2022-07-30 16:53:59,854
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0800547ce8174a1bafecc2c21edfd386] (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 [##f087bb657a8846518e81c4304a0e4415] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 16:54:00,073
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0800547ce8174a1bafecc2c21edfd386] (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 [##33abd7e59c004e31acaf0a86bc132bbe] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 16:54:00,076
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##0800547ce8174a1bafecc2c21edfd386] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2022-07-30 17:52:50,433
  线程ID: 67
日志级别: 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 库存合计#数量
    , 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 [##3ae24bfb8e5b47fc9ae7619409d476d6]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2022-07-30 17:52:50,714
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##3ae24bfb8e5b47fc9ae7619409d476d6] (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 [##7fe95a1603f9431582924b40840feb18] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 17:52:50,939
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##3ae24bfb8e5b47fc9ae7619409d476d6] (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 [##38ee5bd63b8f41c0a4bfe2962536b491] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 17:52:50,941
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##3ae24bfb8e5b47fc9ae7619409d476d6] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2022-07-30 17:52:58,454
  线程ID: 66
日志级别: 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 库存合计#数量
    , 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 [##a0efc4e0dee84b52a5081352c08ab137]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2022-07-30 17:52:58,727
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##a0efc4e0dee84b52a5081352c08ab137] (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 [##f6442404dac840e3acfb4c656fc20818] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 17:52:58,947
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##a0efc4e0dee84b52a5081352c08ab137] (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 [##dc6c1c73d50542fca3a3f6eb40f0a025] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 17:52:58,950
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##a0efc4e0dee84b52a5081352c08ab137] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2022-07-30 17:53:31,112
  线程ID: 83
日志级别: 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 库存合计#数量
    , 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 [##1f9b99a3be23468db33e4970c8e9c3cf]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2022-07-30 17:53:31,383
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##1f9b99a3be23468db33e4970c8e9c3cf] (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 [##52e6a21cd6e841a689f646c64d7e9c1e] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 17:53:31,595
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##1f9b99a3be23468db33e4970c8e9c3cf] (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 [##084b792fae894e83839af7319516bfd5] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 17:53:31,598
  线程ID: 83
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##1f9b99a3be23468db33e4970c8e9c3cf] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2022-07-30 17:53:43,178
  线程ID: 67
日志级别: 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 库存合计#数量
    , 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 [##c9c13199b9264b2bb9779b48c5dc7af8]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2022-07-30 17:53:43,503
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##c9c13199b9264b2bb9779b48c5dc7af8] (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 [##c93b17c816af4e4589fed93da7cbd668] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 17:53:43,719
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##c9c13199b9264b2bb9779b48c5dc7af8] (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 [##9c0fe7cc02e2406abba0458de5085658] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2022-07-30 17:53:43,722
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##c9c13199b9264b2bb9779b48c5dc7af8] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)