时间: 2021-09-03 11:56:36,002
  线程ID: 37
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##f72f43a7d45b4cfcb187c6202d0c77a4]
ORDER BY Goods_no


    时间: 2021-09-03 11:56:40,787
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##9b40a5ab0fa14b33b8f55f845058c83e]
ORDER BY Goods_no


    时间: 2021-09-03 11:56:41,502
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##c1d692565ba8453087eb88345856799a]
ORDER BY Goods_no


    时间: 2021-09-03 11:56:42,224
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##011228203d7845d7b8c31ce505884775]
ORDER BY Goods_no


    时间: 2021-09-03 11:57:26,836
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##c622d293f8bf46c898cebe67bc845899]
ORDER BY Goods_no


    时间: 2021-09-03 17:14:46,949
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.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 [##a45c25fa38954dce810203be38e5fa86]
FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W


    时间: 2021-09-03 17:14:47,167
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##a45c25fa38954dce810203be38e5fa86] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##2d848d17e4074bf1b9bb30f2bd8b50c8] A
INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No


    时间: 2021-09-03 17:14:47,178
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##a45c25fa38954dce810203be38e5fa86] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2021-09-03 17:15:13,279
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.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 [##4ba6b6d685a84e078610c287478d778f]
FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W


    时间: 2021-09-03 17:15:13,488
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##4ba6b6d685a84e078610c287478d778f] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##cf1ebac35b564935b73a87b7be728306] A
INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No


    时间: 2021-09-03 17:15:13,491
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##4ba6b6d685a84e078610c287478d778f] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2021-09-03 17:15:23,666
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.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 [##79a78b00dde0430aa705bde6de19799f]
FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W


    时间: 2021-09-03 17:15:23,879
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##79a78b00dde0430aa705bde6de19799f] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##0dca83d7466843e3a79745c0af147ac7] A
INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No


    时间: 2021-09-03 17:15:23,882
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##79a78b00dde0430aa705bde6de19799f] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2021-09-03 17:15:26,917
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.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 [##f1abd607db7d4df786db8a47f0ec2723]
FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W


    时间: 2021-09-03 17:15:27,137
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##f1abd607db7d4df786db8a47f0ec2723] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##b0dbeeeeda934afc918bbd719c56eb25] A
INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No


    时间: 2021-09-03 17:15:27,140
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##f1abd607db7d4df786db8a47f0ec2723] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2021-09-03 17:15:47,593
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.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 [##f69010764bc84092b0bae0d41096968e]
FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W


    时间: 2021-09-03 17:15:47,821
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##f69010764bc84092b0bae0d41096968e] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##979031e5442b4ec0bec76f6f806fb562] A
INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No


    时间: 2021-09-03 17:15:47,825
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##f69010764bc84092b0bae0d41096968e] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2021-09-03 17:15:58,184
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.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 [##a3121bbb717e447db7a292cf7617c5dd]
FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W


    时间: 2021-09-03 17:15:58,404
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##a3121bbb717e447db7a292cf7617c5dd] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##f8281583fafa4f508b6c5d67c7d06a5c] A
INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No


    时间: 2021-09-03 17:15:58,408
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##a3121bbb717e447db7a292cf7617c5dd] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2021-09-03 17:16:04,129
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.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 [##964ca28936974ba6ae05e736fb10c156]
FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W


    时间: 2021-09-03 17:16:04,358
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##964ca28936974ba6ae05e736fb10c156] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##fd2a327aef814baa9127303065d65744] A
INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No


    时间: 2021-09-03 17:16:04,361
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##964ca28936974ba6ae05e736fb10c156] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2021-09-03 17:16:17,453
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.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 [##174d0ab3901a47629805af7630e62389]
FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W


    时间: 2021-09-03 17:16:17,674
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##174d0ab3901a47629805af7630e62389] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##da06411ea8c94bbe90103661169be974] A
INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No


    时间: 2021-09-03 17:16:17,678
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##174d0ab3901a47629805af7630e62389] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2021-09-03 17:17:04,978
  线程ID: 12
日志级别: 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 [##43b6eeccf3bc40dfbf223a279a472efb]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-09-03 17:17:05,599
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##43b6eeccf3bc40dfbf223a279a472efb] (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 [##b075e6dcd41444d6b705d05ac079740f] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-09-03 17:17:08,405
  线程ID: 103
日志级别: 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 [##218717c18e984ffcb39cc36c20850015]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-09-03 17:17:09,017
  线程ID: 103
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##218717c18e984ffcb39cc36c20850015] (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 [##4815ff093f4a41a0a12aa92c780514cb] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-09-03 17:17:57,179
  线程ID: 79
日志级别: 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 [##4d4cf25661b6473cac612e791daec9a2]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-09-03 17:17:57,777
  线程ID: 79
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##4d4cf25661b6473cac612e791daec9a2] (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 [##94e72c93e24b4facad0f38e293669fc1] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-09-03 17:21:28,711
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.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 [##c38f27bcba3541298dd874559e93133b]
FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W


    时间: 2021-09-03 17:21:28,926
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##c38f27bcba3541298dd874559e93133b] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##add0d3d572a947379548856a7130c9b1] A
INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No


    时间: 2021-09-03 17:21:56,413
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 A.Warehouse_No, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size
    , 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(NULL AS NUMERIC(15, 2)) AS [厂家来货#金额]
    , CAST(C.[S1] AS INT) AS [采购退货#S1], CAST(NULL AS INT) AS [采购退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [采购退货#金额]
    , CAST(C.[S1] AS INT) AS [净收货#S1], CAST(NULL AS INT) AS [净收货#数量], CAST(NULL AS NUMERIC(15, 2)) 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 [仓库出货#批发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [仓库出货#批发#金额]
    , CAST(C.[S1] AS INT) AS [仓库出货#零售#S1], CAST(NULL AS INT) AS [仓库出货#零售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [仓库出货#零售#金额]
    , CAST(C.[S1] AS INT) AS [收退货#批发#S1], CAST(NULL AS INT) AS [收退货#批发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [收退货#批发#金额]
    , CAST(C.[S1] AS INT) AS [收退货#零售#S1], CAST(NULL AS INT) AS [收退货#零售#数量], CAST(NULL AS NUMERIC(15, 2)) 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 [在途库存#数量]
    , CAST(NULL AS Datetime) AS [首次入库日期]
    , CAST(NULL AS Datetime) AS [末次入库日期]
    , CAST(NULL AS Datetime) AS [首次出货日期]
    , CAST(NULL AS Datetime) AS [末次出货日期]
INTO [##0225867b1c914921a010e71914386367]
FROM Warehouse A, Barcode B, DeliveryDetail C


    时间: 2021-09-03 17:21:56,619
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0225867b1c914921a010e71914386367] (Warehouse_No, Goods_No, ColorID, Long, [期初库存#S1], [期初库存#数量])
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##88c38cf97fde40e7ba30d2a841297f4a]


    时间: 2021-09-03 17:21:56,669
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0225867b1c914921a010e71914386367] (Warehouse_No, Goods_No, ColorID, Long, [厂家来货#S1], 厂家来货#数量, 厂家来货#金额, 首次入库日期, 末次入库日期)
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount, 首次入库日期, 末次入库日期
FROM [##aa787eacbae048bb894a290996fa41eb]


    时间: 2021-09-03 17:21:56,718
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0225867b1c914921a010e71914386367] (Warehouse_No, Goods_No, ColorID, Long, [采购退货#S1], 采购退货#数量, 采购退货#金额)
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount
FROM [##b6ae2166fa4d49738c14dfa930540348]


    时间: 2021-09-03 17:21:56,762
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0225867b1c914921a010e71914386367] (Warehouse_No, Goods_No, ColorID, Long, [仓库调入#S1], 仓库调入#数量)
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##00fabafd60d74fcb80677e7839ef284f]


    时间: 2021-09-03 17:21:56,811
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0225867b1c914921a010e71914386367] (Warehouse_No, Goods_No, ColorID, Long, [收退货#批发#S1], [收退货#批发#数量], [收退货#批发#金额])
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount
FROM [##b48da26827994438acce8b3cfd47bd78]


    时间: 2021-09-03 17:21:56,856
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0225867b1c914921a010e71914386367] (Warehouse_No, Goods_No, ColorID, Long, [收退货#零售#S1], [收退货#零售#数量], [收退货#零售#金额])
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount
FROM [##a847643fd24e4e2cad67b17f6828cda1]


    时间: 2021-09-03 17:21:56,945
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0225867b1c914921a010e71914386367] (Warehouse_No, Goods_No, ColorID, Long, [仓库出货#批发#S1], [仓库出货#批发#数量], [仓库出货#批发#金额], 首次出货日期, 末次出货日期)
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount, 首次出货日期, 末次出货日期
FROM [##68a66e0a933a4025953a548b08f9cf51]


    时间: 2021-09-03 17:21:57,088
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0225867b1c914921a010e71914386367] (Warehouse_No, Goods_No, ColorID, Long, [仓库出货#零售#S1], [仓库出货#零售#数量], [仓库出货#零售#金额], 首次出货日期, 末次出货日期)
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount, 首次出货日期, 末次出货日期
FROM [##9c0ca328d185467da44472d253f9ef15]


    时间: 2021-09-03 17:21:57,181
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0225867b1c914921a010e71914386367] (Warehouse_No, Goods_No, ColorID, Long, [仓库调出#S1], 仓库调出#数量)
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##079fe9b2392b402cb5b68d3046489f6a]


    时间: 2021-09-03 17:21:57,269
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0225867b1c914921a010e71914386367] (Warehouse_No, Goods_No, ColorID, Long, [仓库损益#S1], 仓库损益#数量)
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##0ca870d3245746309e3cf4a480b9f9c7]


    时间: 2021-09-03 17:21:57,332
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0225867b1c914921a010e71914386367] (Warehouse_No, Goods_No, ColorID, Long, [包装#拆分#S1], 包装#拆分#数量)
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##c6deec5c001c4451ba594f2b753eab53]


    时间: 2021-09-03 17:21:57,381
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0225867b1c914921a010e71914386367] (Warehouse_No, Goods_No, ColorID, Long, [包装#组成#S1], 包装#组成#数量)
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##80b39dd8026e4a9892d72113a77ba540]


    时间: 2021-09-03 17:21:57,693
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0225867b1c914921a010e71914386367] (Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], [在途库存#数量])
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##cb434efb99774da6b59cb6bb335c2da6]


    时间: 2021-09-03 17:21:57,699
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##0225867b1c914921a010e71914386367] SET 净收货#数量 = ISNULL(厂家来货#数量,0) - ISNULL(采购退货#数量,0), 净收货#金额 = ISNULL(厂家来货#金额,0) - ISNULL(采购退货#金额,0)

    时间: 2021-09-03 17:21:57,706
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##0225867b1c914921a010e71914386367] SET 期末库存#数量 = ISNULL(期初库存#数量,0) + ISNULL(厂家来货#数量,0) + ISNULL(仓库调入#数量,0) + ISNULL(收退货#批发#数量,0) + ISNULL(收退货#零售#数量,0) - ISNULL(仓库出货#批发#数量,0) - ISNULL(仓库出货#零售#数量,0) - ISNULL(仓库调出#数量,0) - ISNULL(采购退货#数量,0) - ISNULL(仓库损益#数量,0) - ISNULL(包装#拆分#数量,0) + ISNULL(包装#组成#数量,0)

    时间: 2021-09-03 17:21:57,712
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Warehouse_No AS [仓库编号], W.Warehouse_Na AS [仓库名称], GS.Goods_Name AS [货品名称], SUM([期初库存#数量]) AS [期初库存], SUM([厂家来货#数量]) AS [厂家来货], SUM([采购退货#数量]) AS [采购退货], SUM([净收货#数量]) AS [净收货], SUM([仓库调出#数量]) AS [仓库调出], SUM([仓库调入#数量]) AS [仓库调入], SUM([仓库损益#数量]) AS [仓库损益], SUM([仓库出货#批发#数量]) AS [仓库出货#批发], SUM([期末库存#数量]) AS [期末库存]
INTO tempdb.dbo.[32397706-1575-4ddc-be86-132c940e3962]
FROM [##0225867b1c914921a010e71914386367] A
              INNER JOIN Warehouse W ON A.Warehouse_No = W.Warehouse_No
              INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No
              INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID
              LEFT  JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  A.Warehouse_No, W.Warehouse_Na, GS.Goods_Name
HAVING (ISNULL(SUM([期初库存#S1]), 0) <> 0) OR (ISNULL(SUM([厂家来货#S1]), 0) <> 0) OR (ISNULL(SUM([采购退货#S1]), 0) <> 0) OR (ISNULL(SUM([仓库调出#S1]), 0) <> 0) OR (ISNULL(SUM([仓库调入#S1]), 0) <> 0) OR (ISNULL(SUM([仓库损益#S1]), 0) <> 0) OR (ISNULL(SUM([仓库出货#批发#S1]), 0) <> 0) OR (ISNULL(SUM([仓库出货#零售#S1]), 0) <> 0) OR (ISNULL(SUM([收退货#批发#S1]), 0) <> 0) OR (ISNULL(SUM([收退货#零售#S1]), 0) <> 0) OR (ISNULL(SUM([包装#拆分#S1]), 0) <> 0) OR (ISNULL(SUM([包装#组成#S1]), 0) <> 0)
ORDER BY  A.Warehouse_No, W.Warehouse_Na, GS.Goods_Name


    时间: 2021-09-03 17:22:03,546
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 A.Warehouse_No, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size
    , 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(NULL AS NUMERIC(15, 2)) AS [厂家来货#金额]
    , CAST(C.[S1] AS INT) AS [采购退货#S1], CAST(NULL AS INT) AS [采购退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [采购退货#金额]
    , CAST(C.[S1] AS INT) AS [净收货#S1], CAST(NULL AS INT) AS [净收货#数量], CAST(NULL AS NUMERIC(15, 2)) 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 [仓库出货#批发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [仓库出货#批发#金额]
    , CAST(C.[S1] AS INT) AS [仓库出货#零售#S1], CAST(NULL AS INT) AS [仓库出货#零售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [仓库出货#零售#金额]
    , CAST(C.[S1] AS INT) AS [收退货#批发#S1], CAST(NULL AS INT) AS [收退货#批发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [收退货#批发#金额]
    , CAST(C.[S1] AS INT) AS [收退货#零售#S1], CAST(NULL AS INT) AS [收退货#零售#数量], CAST(NULL AS NUMERIC(15, 2)) 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 [在途库存#数量]
    , CAST(NULL AS Datetime) AS [首次入库日期]
    , CAST(NULL AS Datetime) AS [末次入库日期]
    , CAST(NULL AS Datetime) AS [首次出货日期]
    , CAST(NULL AS Datetime) AS [末次出货日期]
INTO [##715d3fc5f42d4b64970b359e8cb8e787]
FROM Warehouse A, Barcode B, DeliveryDetail C


    时间: 2021-09-03 17:22:03,766
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##715d3fc5f42d4b64970b359e8cb8e787] (Warehouse_No, Goods_No, ColorID, Long, [期初库存#S1], [期初库存#数量])
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##87d20d05be2248f68d27dbc0fddb3ed6]


    时间: 2021-09-03 17:22:03,811
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##715d3fc5f42d4b64970b359e8cb8e787] (Warehouse_No, Goods_No, ColorID, Long, [厂家来货#S1], 厂家来货#数量, 厂家来货#金额, 首次入库日期, 末次入库日期)
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount, 首次入库日期, 末次入库日期
FROM [##d50e75cdbb044871b1818fa60cf7ab41]


    时间: 2021-09-03 17:22:03,859
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##715d3fc5f42d4b64970b359e8cb8e787] (Warehouse_No, Goods_No, ColorID, Long, [采购退货#S1], 采购退货#数量, 采购退货#金额)
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount
FROM [##ef443514c2eb4308bccb8afe25e626ce]


    时间: 2021-09-03 17:22:03,901
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##715d3fc5f42d4b64970b359e8cb8e787] (Warehouse_No, Goods_No, ColorID, Long, [仓库调入#S1], 仓库调入#数量)
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##42f653a570814086a8e920c2d6da07d1]


    时间: 2021-09-03 17:22:03,954
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##715d3fc5f42d4b64970b359e8cb8e787] (Warehouse_No, Goods_No, ColorID, Long, [收退货#批发#S1], [收退货#批发#数量], [收退货#批发#金额])
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount
FROM [##416f3998a8574c77a9078448262cd83c]


    时间: 2021-09-03 17:22:04,004
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##715d3fc5f42d4b64970b359e8cb8e787] (Warehouse_No, Goods_No, ColorID, Long, [收退货#零售#S1], [收退货#零售#数量], [收退货#零售#金额])
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount
FROM [##cd41c81ac77f40d8b14063a02b8788ff]


    时间: 2021-09-03 17:22:04,091
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##715d3fc5f42d4b64970b359e8cb8e787] (Warehouse_No, Goods_No, ColorID, Long, [仓库出货#批发#S1], [仓库出货#批发#数量], [仓库出货#批发#金额], 首次出货日期, 末次出货日期)
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount, 首次出货日期, 末次出货日期
FROM [##f6f01d9b62e345b1bec7baec468e37d8]


    时间: 2021-09-03 17:22:04,237
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##715d3fc5f42d4b64970b359e8cb8e787] (Warehouse_No, Goods_No, ColorID, Long, [仓库出货#零售#S1], [仓库出货#零售#数量], [仓库出货#零售#金额], 首次出货日期, 末次出货日期)
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount, 首次出货日期, 末次出货日期
FROM [##fd9a6f3996064cd2afdd2651cbbe8367]


    时间: 2021-09-03 17:22:04,325
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##715d3fc5f42d4b64970b359e8cb8e787] (Warehouse_No, Goods_No, ColorID, Long, [仓库调出#S1], 仓库调出#数量)
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##01a093cc4473466bbe6c982a595c2c7a]


    时间: 2021-09-03 17:22:04,420
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##715d3fc5f42d4b64970b359e8cb8e787] (Warehouse_No, Goods_No, ColorID, Long, [仓库损益#S1], 仓库损益#数量)
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##6d7a64a3b8fd419ab9a7e7083176d401]


    时间: 2021-09-03 17:22:04,473
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##715d3fc5f42d4b64970b359e8cb8e787] (Warehouse_No, Goods_No, ColorID, Long, [包装#拆分#S1], 包装#拆分#数量)
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##fdf74d61b3c24368b465ef4bb71fc3e3]


    时间: 2021-09-03 17:22:04,519
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##715d3fc5f42d4b64970b359e8cb8e787] (Warehouse_No, Goods_No, ColorID, Long, [包装#组成#S1], 包装#组成#数量)
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##c63db6c0fcfe4148b68aec5fa0a25233]


    时间: 2021-09-03 17:22:04,824
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##715d3fc5f42d4b64970b359e8cb8e787] (Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], [在途库存#数量])
SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##02035d01de194278b48b6a4f1e51d92e]


    时间: 2021-09-03 17:22:04,829
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##715d3fc5f42d4b64970b359e8cb8e787] SET 净收货#数量 = ISNULL(厂家来货#数量,0) - ISNULL(采购退货#数量,0), 净收货#金额 = ISNULL(厂家来货#金额,0) - ISNULL(采购退货#金额,0)

    时间: 2021-09-03 17:22:04,835
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##715d3fc5f42d4b64970b359e8cb8e787] SET 期末库存#数量 = ISNULL(期初库存#数量,0) + ISNULL(厂家来货#数量,0) + ISNULL(仓库调入#数量,0) + ISNULL(收退货#批发#数量,0) + ISNULL(收退货#零售#数量,0) - ISNULL(仓库出货#批发#数量,0) - ISNULL(仓库出货#零售#数量,0) - ISNULL(仓库调出#数量,0) - ISNULL(采购退货#数量,0) - ISNULL(仓库损益#数量,0) - ISNULL(包装#拆分#数量,0) + ISNULL(包装#组成#数量,0)

    时间: 2021-09-03 17:22:04,843
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Warehouse_No AS [仓库编号], W.Warehouse_Na AS [仓库名称], SUM([期初库存#数量]) AS [期初库存], SUM([厂家来货#数量]) AS [厂家来货], SUM([采购退货#数量]) AS [采购退货], SUM([净收货#数量]) AS [净收货], SUM([仓库调出#数量]) AS [仓库调出], SUM([仓库调入#数量]) AS [仓库调入], SUM([仓库损益#数量]) AS [仓库损益], SUM([仓库出货#批发#数量]) AS [仓库出货#批发], SUM([期末库存#数量]) AS [期末库存]
INTO tempdb.dbo.[32397706-1575-4ddc-be86-132c940e3962]
FROM [##715d3fc5f42d4b64970b359e8cb8e787] A
              INNER JOIN Warehouse W ON A.Warehouse_No = W.Warehouse_No
              INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No
              INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID
              LEFT  JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  A.Warehouse_No, W.Warehouse_Na
HAVING (ISNULL(SUM([期初库存#S1]), 0) <> 0) OR (ISNULL(SUM([厂家来货#S1]), 0) <> 0) OR (ISNULL(SUM([采购退货#S1]), 0) <> 0) OR (ISNULL(SUM([仓库调出#S1]), 0) <> 0) OR (ISNULL(SUM([仓库调入#S1]), 0) <> 0) OR (ISNULL(SUM([仓库损益#S1]), 0) <> 0) OR (ISNULL(SUM([仓库出货#批发#S1]), 0) <> 0) OR (ISNULL(SUM([仓库出货#零售#S1]), 0) <> 0) OR (ISNULL(SUM([收退货#批发#S1]), 0) <> 0) OR (ISNULL(SUM([收退货#零售#S1]), 0) <> 0) OR (ISNULL(SUM([包装#拆分#S1]), 0) <> 0) OR (ISNULL(SUM([包装#组成#S1]), 0) <> 0)
ORDER BY  A.Warehouse_No, W.Warehouse_Na


    时间: 2021-09-03 17:22:06,307
  线程ID: 106
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , 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(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS INT) AS [15DayCheckQuantity]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) 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 [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1]
    , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1]
INTO [##b40f760cbc4c483a97e3285fd6ab3820]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-09-03 17:22:06,894
  线程ID: 106
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##758f5eb559cf4d359783278047732476] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-09-03 17:22:06,899
  线程ID: 106
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b40f760cbc4c483a97e3285fd6ab3820] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##758f5eb559cf4d359783278047732476]


    时间: 2021-09-03 17:22:06,988
  线程ID: 106
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##959bfe5e4a5a439f81ca975cc5a5f03d a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-09-03 17:22:06,995
  线程ID: 106
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##959bfe5e4a5a439f81ca975cc5a5f03d SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-09-03 17:22:07,001
  线程ID: 106
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##959bfe5e4a5a439f81ca975cc5a5f03d 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.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-09-03 17:22:07,035
  线程ID: 106
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##959bfe5e4a5a439f81ca975cc5a5f03d SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-09-03 17:22:07,037
  线程ID: 106
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##959bfe5e4a5a439f81ca975cc5a5f03d SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-09-03 17:22:07,044
  线程ID: 106
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b40f760cbc4c483a97e3285fd6ab3820] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##4acd8840f61743e1baf088888151fb83]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-09-03 17:22:07,062
  线程ID: 106
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称]
INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e]
FROM ##b40f760cbc4c483a97e3285fd6ab3820 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END

ORDER BY  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END


    时间: 2021-09-03 17:25:11,808
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.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 [##54a5bf7919f342d883ac8f69f4e4577a]
FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W


    时间: 2021-09-03 17:25:12,026
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##54a5bf7919f342d883ac8f69f4e4577a] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##9ee5f89361524bf586e273d378c5f066] A
INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No


    时间: 2021-09-03 17:25:12,306
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##54a5bf7919f342d883ac8f69f4e4577a] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量)
SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##c6ff3948cc8a442d96ea496301c7c3b3] A
INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No


    时间: 2021-09-03 17:35:25,281
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50)) AS ItemID, A.Customer_Na AS ItemName, CAST(NULL AS VARCHAR(50)) AS Company_ID, CAST(NULL AS VARCHAR(50)) AS Company_Abv
    , B.Goods_No, C.ColorID, C.Long, A.Input_Date AS FirstReceiveDate
    , 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 [##b7054a1fa04646d397d1751915d8ef8b]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-09-03 17:35:25,508
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b7054a1fa04646d397d1751915d8ef8b] (ItemType, ItemID, ItemName, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT 1, Warehouse_No, '', Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##429e8494ddab43219f20a7dd6b8fab4c]


    时间: 2021-09-03 17:35:25,790
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b7054a1fa04646d397d1751915d8ef8b] (ItemType, ItemID, ItemName, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量)
SELECT 1, Warehouse_No, '', Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##53ab27f4e5ab404aa65b3166b15a8ab5]


    时间: 2021-09-03 17:35:26,409
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b7054a1fa04646d397d1751915d8ef8b] (ItemType, ItemID, ItemName, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT 2, Customer_ID, '', Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##5cbe9d2f5d8f4706a38db6cc71882148]


    时间: 2021-09-03 17:35:26,694
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b7054a1fa04646d397d1751915d8ef8b] (ItemType, ItemID, ItemName, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量)
SELECT 2, Customer_ID, '', Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##e03b76d5c9c8462180a6b294c000b9d3]


    时间: 2021-09-03 17:35:26,698
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##b7054a1fa04646d397d1751915d8ef8b] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2021-09-03 17:35:26,706
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET ItemName = B.Warehouse_Na, Company_ID = B.Company_ID, Company_Abv = C.Company_Abv
FROM [##b7054a1fa04646d397d1751915d8ef8b] A LEFT JOIN Warehouse B ON A.ItemID = B.Warehouse_No
                           LEFT JOIN Company C ON B.Company_ID = C.Company_ID
WHERE ItemType = 1;
UPDATE A SET ItemName = B.Abbrev, Company_ID = B.Company_ID, Company_Abv = C.Company_Abv
FROM [##b7054a1fa04646d397d1751915d8ef8b] A LEFT JOIN Customer B ON A.ItemID = B.Customer_ID
                           LEFT JOIN Company C ON B.Company_ID = C.Company_ID
WHERE ItemType = 2


    时间: 2021-09-03 17:35:26,784
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.ItemID AS [项目编号], A.ItemName AS [项目名称], GS.Range AS [系列], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([库存#数量]) AS [库存], SUM([在途库存#数量]) AS [在途库存], SUM([库存合计#数量]) AS [库存合计]
INTO tempdb.dbo.[fd85de54-4775-4712-b398-8215dabd0086]
FROM [##b7054a1fa04646d397d1751915d8ef8b] A
              INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No
              LEFT  JOIN Customer C ON A.itemID = C.Customer_id
              LEFT  JOIN Warehouse W ON A.itemID = W.Warehouse_No
              INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID
              LEFT  JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.ItemID, A.ItemName, GS.Range, A.Goods_No, GS.Goods_Name
HAVING (ISNULL(SUM([库存#S1]), 0) <> 0) OR (ISNULL(SUM([在途库存#S1]), 0) <> 0)
ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.ItemID, A.ItemName, GS.Range, A.Goods_No, GS.Goods_Name


    时间: 2021-09-03 17:36:19,092
  线程ID: 18
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50)) AS ItemID, A.Customer_Na AS ItemName, CAST(NULL AS VARCHAR(50)) AS Company_ID, CAST(NULL AS VARCHAR(50)) AS Company_Abv
    , B.Goods_No, C.ColorID, C.Long, A.Input_Date AS FirstReceiveDate
    , 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 [##4dffea272d5042e8b8199140698bdd44]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-09-03 17:36:19,311
  线程ID: 18
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##4dffea272d5042e8b8199140698bdd44] (ItemType, ItemID, ItemName, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT 1, Warehouse_No, '', Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##74c14ce8e0d64ece9d65c97c1f7c71ca]


    时间: 2021-09-03 17:36:19,586
  线程ID: 18
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##4dffea272d5042e8b8199140698bdd44] (ItemType, ItemID, ItemName, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量)
SELECT 1, Warehouse_No, '', Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##e42c03b097e2445b82b0f9e94ebaab47]


    时间: 2021-09-03 17:36:20,188
  线程ID: 18
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##4dffea272d5042e8b8199140698bdd44] (ItemType, ItemID, ItemName, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT 2, Customer_ID, '', Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##6e14533807b0420f8a91eb0941c18cc9]


    时间: 2021-09-03 17:36:20,502
  线程ID: 18
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##4dffea272d5042e8b8199140698bdd44] (ItemType, ItemID, ItemName, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量)
SELECT 2, Customer_ID, '', Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##92e0c49235284bc391ef23799f9c0d55]


    时间: 2021-09-03 17:36:20,504
  线程ID: 18
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##4dffea272d5042e8b8199140698bdd44] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)

    时间: 2021-09-03 17:36:20,510
  线程ID: 18
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET ItemName = B.Warehouse_Na, Company_ID = B.Company_ID, Company_Abv = C.Company_Abv
FROM [##4dffea272d5042e8b8199140698bdd44] A LEFT JOIN Warehouse B ON A.ItemID = B.Warehouse_No
                           LEFT JOIN Company C ON B.Company_ID = C.Company_ID
WHERE ItemType = 1;
UPDATE A SET ItemName = B.Abbrev, Company_ID = B.Company_ID, Company_Abv = C.Company_Abv
FROM [##4dffea272d5042e8b8199140698bdd44] A LEFT JOIN Customer B ON A.ItemID = B.Customer_ID
                           LEFT JOIN Company C ON B.Company_ID = C.Company_ID
WHERE ItemType = 2


    时间: 2021-09-03 17:36:20,591
  线程ID: 18
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.ItemID AS [项目编号], A.ItemName AS [项目名称], GS.Range AS [系列], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.UnitPrice AS [吊牌价], SUM([库存#数量]) AS [库存], SUM([在途库存#数量]) AS [在途库存], SUM([库存合计#数量]) AS [库存合计]
INTO tempdb.dbo.[fd85de54-4775-4712-b398-8215dabd0086]
FROM [##4dffea272d5042e8b8199140698bdd44] A
              INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No
              LEFT  JOIN Customer C ON A.itemID = C.Customer_id
              LEFT  JOIN Warehouse W ON A.itemID = W.Warehouse_No
              INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID
              LEFT  JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.ItemID, A.ItemName, GS.Range, A.Goods_No, GS.Goods_Name, GS.UnitPrice
HAVING (ISNULL(SUM([库存#S1]), 0) <> 0) OR (ISNULL(SUM([在途库存#S1]), 0) <> 0)
ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.ItemID, A.ItemName, GS.Range, A.Goods_No, GS.Goods_Name, GS.UnitPrice


    时间: 2021-09-03 17:59:03,410
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , 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(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS INT) AS [15DayCheckQuantity]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) 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 [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1]
    , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1]
INTO [##25bb0924bf604778a539da1f8aef7339]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-09-03 17:59:03,998
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##d86632bda94246eaadb6c6dff7fc7b97] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-09-03 17:59:04,004
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##25bb0924bf604778a539da1f8aef7339] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##d86632bda94246eaadb6c6dff7fc7b97]


    时间: 2021-09-03 17:59:04,094
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##53fffedc7cd8463ba6be60174b50f0f0 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-09-03 17:59:04,100
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##53fffedc7cd8463ba6be60174b50f0f0 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-09-03 17:59:04,107
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##53fffedc7cd8463ba6be60174b50f0f0 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.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-09-03 17:59:04,142
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##53fffedc7cd8463ba6be60174b50f0f0 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-09-03 17:59:04,143
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##53fffedc7cd8463ba6be60174b50f0f0 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-09-03 17:59:04,149
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##25bb0924bf604778a539da1f8aef7339] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额)
SELECT  Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount
FROM [##3ac21cf03e37491d9b951a69b3a2e1c0]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-09-03 17:59:04,159
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Pattern AS [款型], GS.Category AS [类别]
INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e]
FROM ##25bb0924bf604778a539da1f8aef7339 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Pattern, GS.Category

ORDER BY  A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Pattern, GS.Category


    时间: 2021-09-03 18:02:44,353
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##83f452162ce946e4b2d320aa91c57a1b]
ORDER BY Goods_no


    时间: 2021-09-03 18:02:45,827
  线程ID: 108
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##afebbac6c9264bb5a44e6cb1f8b5a378]
ORDER BY Goods_no


    时间: 2021-09-03 18:02:47,073
  线程ID: 95
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##7bddb3126ceb4fd0b7284a6042ce6cb1]
ORDER BY Goods_no


    时间: 2021-09-03 18:02:47,246
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##f151906914a94a3f8a8fd67fa54087f9]
ORDER BY Goods_no


    时间: 2021-09-03 18:02:47,426
  线程ID: 108
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##d92ed78035114328a99a510f99670f67]
ORDER BY Goods_no


    时间: 2021-09-03 18:02:47,626
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##6df098b8a714466c8544a27dddd2e27f]
ORDER BY Goods_no


    时间: 2021-09-03 18:02:54,301
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##3d4944f5249a454a93ccd4d44b29341f]
ORDER BY Goods_no


    时间: 2021-09-03 18:02:54,460
  线程ID: 108
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##02a3b8d7b49c43d1b9c88f89fa947be5]
ORDER BY Goods_no


    时间: 2021-09-03 18:02:54,612
  线程ID: 95
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##ce7099401c634f39831094e5af964682]
ORDER BY Goods_no


    时间: 2021-09-03 18:02:54,782
  线程ID: 95
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##e8688c7bf81e401092da5d59e5043c21]
ORDER BY Goods_no


    时间: 2021-09-03 18:02:54,950
  线程ID: 108
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##9ef402435c7448b8b3a049e4c53cb223]
ORDER BY Goods_no


    时间: 2021-09-03 18:02:55,100
  线程ID: 108
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##cd9ce9b986dd48bcbd30747112502dbc]
ORDER BY Goods_no


    时间: 2021-09-03 18:02:55,253
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##fa1ce89cf5ce43ddb8d8854b7e76a01a]
ORDER BY Goods_no


    时间: 2021-09-03 18:02:55,398
  线程ID: 95
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##120214300811483db71640446b6c21ca]
ORDER BY Goods_no


    时间: 2021-09-03 18:02:55,541
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##f186ed42896144cd870b76db790653a7]
ORDER BY Goods_no


    时间: 2021-09-03 18:02:55,682
  线程ID: 108
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##f1e72aa0d8a344989a36306650c5db0b]
ORDER BY Goods_no


    时间: 2021-09-03 18:02:55,832
  线程ID: 108
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##17b4af28cb2f4441a923cecec9d6993e]
ORDER BY Goods_no


    时间: 2021-09-03 18:03:22,011
  线程ID: 10
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##16ed6e639aa94d91a8f0e08ce79e2b33]
ORDER BY Goods_no


    时间: 2021-09-03 18:03:45,966
  线程ID: 95
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##1043936b3e8341719f6e91c273e2d162]
ORDER BY Goods_no


    时间: 2021-09-03 18:04:03,908
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##c975bbc75ddd4603ac8e3cf91aa3b5b6]
ORDER BY Goods_no


    时间: 2021-09-03 18:04:24,724
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##f7f9b9d774604db284ea11de8fff6bb1]
ORDER BY Goods_no


    时间: 2021-09-03 18:04:34,293
  线程ID: 97
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##fc7691c3174e4ab7af8349570be4294f]
ORDER BY Goods_no


    时间: 2021-09-03 18:05:06,978
  线程ID: 109
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##abf23e537c0b4c0dacb1dbf76544d179]
ORDER BY Goods_no