2025-03-08 11:26:35.8434||Info[7]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [s].[MODULE] AS [Module], [s].[ACTIONNAME] AS [ActionName], [s].[COMMENT] AS [Comment], [s].[URLPATH] AS [UrlPath], [s].[TEMPLATE] AS [Template]
FROM [SYS_ACTION_OPERATE_LOG] AS [s]
WHERE ([s].[IS_DELETE] = CAST(0 AS bit)) AND ([s].[IS_ENABLE] = CAST(1 AS bit))|||| end


2025-03-08 11:26:35.8434||Info[7]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [s].[MODULE] AS [Module], [s].[ACTIONNAME] AS [ActionName], [s].[COMMENT] AS [Comment], [s].[URLPATH] AS [UrlPath], [s].[TEMPLATE] AS [Template]
FROM [SYS_ACTION_OPERATE_LOG] AS [s]
WHERE ([s].[IS_DELETE] = CAST(0 AS bit)) AND ([s].[IS_ENABLE] = CAST(1 AS bit))|||| end


2025-03-08 11:26:44.8033||Info[6]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [s].[ID], [s].[CATEGORY], [s].[CREATE_DT], [s].[CREATE_USER_ID], [s].[CREATER], [s].[DISPLAY_NO], [s].[GROUP_NAME], [s].[IS_DELETE], [s].[IS_HIDE], [s].[REMARK], [s].[TEXT], [s].[UPDATE_DT], [s].[UPDATE_USER_ID], [s].[UPDATER], [s].[VALUE]
FROM [SYS_CONFIGURATION] AS [s]
WHERE [s].[IS_DELETE] = False
ORDER BY [s].[UPDATE_DT] DESC|||| end


2025-03-08 11:26:44.8033||Info[6]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [s].[ID], [s].[CATEGORY], [s].[CREATE_DT], [s].[CREATE_USER_ID], [s].[CREATER], [s].[DISPLAY_NO], [s].[GROUP_NAME], [s].[IS_DELETE], [s].[IS_HIDE], [s].[REMARK], [s].[TEXT], [s].[UPDATE_DT], [s].[UPDATE_USER_ID], [s].[UPDATER], [s].[VALUE]
FROM [SYS_CONFIGURATION] AS [s]
WHERE [s].[IS_DELETE] = False
ORDER BY [s].[UPDATE_DT] DESC|||| end


2025-03-08 11:26:45.1534||Info[6]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [s].[ID], [s].[CN], [s].[CREATE_DT], [s].[CREATE_USER_ID], [s].[CREATER], [s].[EN], [s].[IS_DELETE], [s].[LANG], [s].[UPDATE_DT], [s].[UPDATE_USER_ID], [s].[UPDATER]
FROM [SYS_LOCALIZATION] AS [s]
WHERE [s].[IS_DELETE] = False
ORDER BY [s].[UPDATE_DT] DESC|||| end


2025-03-08 11:26:45.1534||Info[6]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [s].[ID], [s].[CN], [s].[CREATE_DT], [s].[CREATE_USER_ID], [s].[CREATER], [s].[EN], [s].[IS_DELETE], [s].[LANG], [s].[UPDATE_DT], [s].[UPDATE_USER_ID], [s].[UPDATER]
FROM [SYS_LOCALIZATION] AS [s]
WHERE [s].[IS_DELETE] = False
ORDER BY [s].[UPDATE_DT] DESC|||| end


2025-03-08 11:26:45.1702||Info[6]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN] AS [w]
WHERE [w].[IS_DELETE] = False|||| end


2025-03-08 11:26:45.1702||Info[6]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN] AS [w]
WHERE [w].[IS_DELETE] = False|||| end


2025-03-08 11:26:45.1860||Info[6]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[ACTUAL_START_DT], [w].[CODE], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[END_DT], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INVENTORY_COUNT], [w].[IS_DELETE], [w].[PLAN_START_DT], [w].[STATUS], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN] AS [w]
WHERE [w].[IS_DELETE] = False
ORDER BY [w].[UPDATE_DT] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:26:45.1860||Info[6]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[ACTUAL_START_DT], [w].[CODE], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[END_DT], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INVENTORY_COUNT], [w].[IS_DELETE], [w].[PLAN_START_DT], [w].[STATUS], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN] AS [w]
WHERE [w].[IS_DELETE] = False
ORDER BY [w].[UPDATE_DT] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:26:48.4618||Info[4]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:26:48.4618||Info[4]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:26:48.4995||Info[4]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:26:48.4995||Info[4]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:27:09.1817||Info[5]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_DATA] AS [w]
WHERE ((	M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(	M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:27:09.1817||Info[5]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_DATA] AS [w]
WHERE ((	M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(	M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:27:09.2785||Info[5]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DRAWING_NO], [w].[EFFECTIVE_DT], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[IS_CONSIGNMENT], [w].[IS_DELETE], [w].[IS_OCCUPY], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[PRODUCTION_DT], [w].[QTY], [w].[REMARK], [w].[STATUS], [w].[SUPPLIER_CODE], [w].[SUPPLIER_NAME], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_LOCATION_BIN], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_DATA] AS [w]
WHERE ((	M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(	M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[UPDATE_DT] DESC, [w].[BARCODE]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:27:09.2785||Info[5]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DRAWING_NO], [w].[EFFECTIVE_DT], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[IS_CONSIGNMENT], [w].[IS_DELETE], [w].[IS_OCCUPY], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[PRODUCTION_DT], [w].[QTY], [w].[REMARK], [w].[STATUS], [w].[SUPPLIER_CODE], [w].[SUPPLIER_NAME], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_LOCATION_BIN], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_DATA] AS [w]
WHERE ((	M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(	M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[UPDATE_DT] DESC, [w].[BARCODE]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:27:11.5598||Info[5]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_DATA] AS [w]
WHERE ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:27:11.5598||Info[5]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_DATA] AS [w]
WHERE ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:27:11.6707||Info[5]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DRAWING_NO], [w].[EFFECTIVE_DT], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[IS_CONSIGNMENT], [w].[IS_DELETE], [w].[IS_OCCUPY], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[PRODUCTION_DT], [w].[QTY], [w].[REMARK], [w].[STATUS], [w].[SUPPLIER_CODE], [w].[SUPPLIER_NAME], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_LOCATION_BIN], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_DATA] AS [w]
WHERE ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[UPDATE_DT] DESC, [w].[BARCODE]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:27:11.6707||Info[5]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DRAWING_NO], [w].[EFFECTIVE_DT], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[IS_CONSIGNMENT], [w].[IS_DELETE], [w].[IS_OCCUPY], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[PRODUCTION_DT], [w].[QTY], [w].[REMARK], [w].[STATUS], [w].[SUPPLIER_CODE], [w].[SUPPLIER_NAME], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_LOCATION_BIN], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_DATA] AS [w]
WHERE ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[UPDATE_DT] DESC, [w].[BARCODE]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:27:17.8527||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[IS_DELETE] = CAST(0 AS bit)) AND [w].[ID] IN ('81de13b2-27da-5d8b-91cd-3a18769e9ffe')|||| end


2025-03-08 11:27:17.8527||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[IS_DELETE] = CAST(0 AS bit)) AND [w].[ID] IN ('81de13b2-27da-5d8b-91cd-3a18769e9ffe')|||| end


2025-03-08 11:27:17.8715||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[IS_DELETE] = CAST(0 AS bit)) AND [w].[ID] IN ('81de13b2-27da-5d8b-91cd-3a18769e9ffe')|||| end


2025-03-08 11:27:17.8715||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[IS_DELETE] = CAST(0 AS bit)) AND [w].[ID] IN ('81de13b2-27da-5d8b-91cd-3a18769e9ffe')|||| end


2025-03-08 11:27:18.0919||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:27:18.0919||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:27:18.1160||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:27:18.1160||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:27:34.2261||Info[10]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:27:34.2261||Info[10]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:27:34.2662||Info[10]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:27:34.2662||Info[10]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:27:37.1887||Info[6]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ([w].[STATUS] <> 99) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 11:27:37.1887||Info[6]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ([w].[STATUS] <> 99) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 11:27:37.2827||Info[6]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ([w].[STATUS] <> 99) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:27:37.2827||Info[6]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ([w].[STATUS] <> 99) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:27:38.1638||Info[7]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_DATA] AS [w]
WHERE ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:27:38.1638||Info[7]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_DATA] AS [w]
WHERE ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:27:38.2769||Info[7]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DRAWING_NO], [w].[EFFECTIVE_DT], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[IS_CONSIGNMENT], [w].[IS_DELETE], [w].[IS_OCCUPY], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[PRODUCTION_DT], [w].[QTY], [w].[REMARK], [w].[STATUS], [w].[SUPPLIER_CODE], [w].[SUPPLIER_NAME], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_LOCATION_BIN], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_DATA] AS [w]
WHERE ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[UPDATE_DT] DESC, [w].[BARCODE]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:27:38.2769||Info[7]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DRAWING_NO], [w].[EFFECTIVE_DT], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[IS_CONSIGNMENT], [w].[IS_DELETE], [w].[IS_OCCUPY], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[PRODUCTION_DT], [w].[QTY], [w].[REMARK], [w].[STATUS], [w].[SUPPLIER_CODE], [w].[SUPPLIER_NAME], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_LOCATION_BIN], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_DATA] AS [w]
WHERE ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[UPDATE_DT] DESC, [w].[BARCODE]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:27:48.5381||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 180)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 11:27:48.5381||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 180)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 11:27:48.5702||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 180)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:27:48.5702||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 180)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:27:50.3225||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[IS_DELETE] = CAST(0 AS bit)) AND [w].[ID] IN ('81de13b2-27da-5d8b-91cd-3a18769e9ffe')|||| end


2025-03-08 11:27:50.3225||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[IS_DELETE] = CAST(0 AS bit)) AND [w].[ID] IN ('81de13b2-27da-5d8b-91cd-3a18769e9ffe')|||| end


2025-03-08 11:27:50.3225||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[IS_DELETE] = CAST(0 AS bit)) AND [w].[ID] IN ('81de13b2-27da-5d8b-91cd-3a18769e9ffe')|||| end


2025-03-08 11:27:50.3225||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[IS_DELETE] = CAST(0 AS bit)) AND [w].[ID] IN ('81de13b2-27da-5d8b-91cd-3a18769e9ffe')|||| end


2025-03-08 11:27:50.4605||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:27:50.4605||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:27:50.4861||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:27:50.4861||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:27:55.8380||Info[7]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_DATA] AS [w]
WHERE ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:27:55.8380||Info[7]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_DATA] AS [w]
WHERE ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:27:55.9387||Info[7]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DRAWING_NO], [w].[EFFECTIVE_DT], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[IS_CONSIGNMENT], [w].[IS_DELETE], [w].[IS_OCCUPY], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[PRODUCTION_DT], [w].[QTY], [w].[REMARK], [w].[STATUS], [w].[SUPPLIER_CODE], [w].[SUPPLIER_NAME], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_LOCATION_BIN], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_DATA] AS [w]
WHERE ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[UPDATE_DT] DESC, [w].[BARCODE]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:27:55.9387||Info[7]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DRAWING_NO], [w].[EFFECTIVE_DT], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[IS_CONSIGNMENT], [w].[IS_DELETE], [w].[IS_OCCUPY], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[PRODUCTION_DT], [w].[QTY], [w].[REMARK], [w].[STATUS], [w].[SUPPLIER_CODE], [w].[SUPPLIER_NAME], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_LOCATION_BIN], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_DATA] AS [w]
WHERE ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[UPDATE_DT] DESC, [w].[BARCODE]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:27:59.0341||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT TOP(1) [w].[ID], [w].[BARCODE], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DRAWING_NO], [w].[EFFECTIVE_DT], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[IS_CONSIGNMENT], [w].[IS_DELETE], [w].[IS_OCCUPY], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[PRODUCTION_DT], [w].[QTY], [w].[REMARK], [w].[STATUS], [w].[SUPPLIER_CODE], [w].[SUPPLIER_NAME], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_LOCATION_BIN], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_DATA] AS [w]
WHERE [w].[ID] = 26298541-406e-4631-b5cd-dfc10a11ec6e|||| end


2025-03-08 11:27:59.0341||Info[9]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT TOP(1) [w].[ID], [w].[BARCODE], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DRAWING_NO], [w].[EFFECTIVE_DT], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[IS_CONSIGNMENT], [w].[IS_DELETE], [w].[IS_OCCUPY], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[PRODUCTION_DT], [w].[QTY], [w].[REMARK], [w].[STATUS], [w].[SUPPLIER_CODE], [w].[SUPPLIER_NAME], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_LOCATION_BIN], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_DATA] AS [w]
WHERE [w].[ID] = 26298541-406e-4631-b5cd-dfc10a11ec6e|||| end


2025-03-08 11:28:05.6087||Info[21]||EQuality.Framework.Dal.HintCommandInterceptor||SET NOCOUNT ON;
UPDATE [WMS_DATA] SET [BARCODE] = M012:115|3X001:-1431293937, [DRAWING_NO] = , [EFFECTIVE_DT] = , [EXT1] = 115, [EXT2] = 115, [EXT3] = , [EXT4] = , [EXT5] = , [EXT6] = , [INSERT_DT] = 2024/3/13 10:58:33, [IS_CONSIGNMENT] = 0, [IS_DELETE] = 1, [IS_OCCUPY] = 2, [LOT_NO] = 3, [MATERIAL_NAME] = 4, [MATERIAL_NO] = 5, [MATERIAL_SPECS] = 6, [MATERIAL_TYPE] = 7, [PRODUCTION_DT] = 8, [QTY] = 9, [REMARK] = 0, [STATUS] = 1, [SUPPLIER_CODE] = 2, [SUPPLIER_NAME] = 3, [UNIT] = 4, [UPDATE_DT] = 5, [UPDATE_USER_ID] = 6, [UPDATER] = 7, [WMS_LOCATION_BIN] = 8, [WMS_WAREHOUSE_CODE] = 9, [WMS_WAREHOUSE_NAME] = 1150
WHERE [ID] = 26298541-406e-4631-b5cd-dfc10a11ec6e;
SELECT @@ROWCOUNT;

|||| end


2025-03-08 11:28:05.6087||Info[21]||EQuality.Framework.Dal.HintCommandInterceptor||SET NOCOUNT ON;
UPDATE [WMS_DATA] SET [BARCODE] = M012:115|3X001:-1431293937, [DRAWING_NO] = , [EFFECTIVE_DT] = , [EXT1] = 115, [EXT2] = 115, [EXT3] = , [EXT4] = , [EXT5] = , [EXT6] = , [INSERT_DT] = 2024/3/13 10:58:33, [IS_CONSIGNMENT] = 0, [IS_DELETE] = 1, [IS_OCCUPY] = 2, [LOT_NO] = 3, [MATERIAL_NAME] = 4, [MATERIAL_NO] = 5, [MATERIAL_SPECS] = 6, [MATERIAL_TYPE] = 7, [PRODUCTION_DT] = 8, [QTY] = 9, [REMARK] = 0, [STATUS] = 1, [SUPPLIER_CODE] = 2, [SUPPLIER_NAME] = 3, [UNIT] = 4, [UPDATE_DT] = 5, [UPDATE_USER_ID] = 6, [UPDATER] = 7, [WMS_LOCATION_BIN] = 8, [WMS_WAREHOUSE_CODE] = 9, [WMS_WAREHOUSE_NAME] = 1150
WHERE [ID] = 26298541-406e-4631-b5cd-dfc10a11ec6e;
SELECT @@ROWCOUNT;

|||| end


2025-03-08 11:28:05.6976||Info[21]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_DATA] AS [w]
WHERE ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:28:05.6976||Info[21]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_DATA] AS [w]
WHERE ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:28:05.7944||Info[21]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DRAWING_NO], [w].[EFFECTIVE_DT], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[IS_CONSIGNMENT], [w].[IS_DELETE], [w].[IS_OCCUPY], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[PRODUCTION_DT], [w].[QTY], [w].[REMARK], [w].[STATUS], [w].[SUPPLIER_CODE], [w].[SUPPLIER_NAME], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_LOCATION_BIN], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_DATA] AS [w]
WHERE ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[UPDATE_DT] DESC, [w].[BARCODE]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:28:05.7944||Info[21]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DRAWING_NO], [w].[EFFECTIVE_DT], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[IS_CONSIGNMENT], [w].[IS_DELETE], [w].[IS_OCCUPY], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[PRODUCTION_DT], [w].[QTY], [w].[REMARK], [w].[STATUS], [w].[SUPPLIER_CODE], [w].[SUPPLIER_NAME], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_LOCATION_BIN], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_DATA] AS [w]
WHERE ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0)) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[UPDATE_DT] DESC, [w].[BARCODE]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:28:07.1594||Info[21]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 175)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 11:28:07.1594||Info[21]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 175)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 11:28:07.1844||Info[21]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 175)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:28:07.1844||Info[21]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 175)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:28:12.8851||Info[11]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 185)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 11:28:12.8851||Info[11]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 185)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 11:28:12.9203||Info[11]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 185)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:28:12.9203||Info[11]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 185)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:28:29.9400||Info[20]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:28:29.9400||Info[20]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:28:29.9726||Info[20]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:28:29.9726||Info[20]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X001:-1431293937 = N'') OR (CHARINDEX(M012:115|3X001:-1431293937, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:28:36.2553||Info[8]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:28:36.2553||Info[8]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:28:36.2893||Info[8]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:28:36.2893||Info[8]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:30:40.2028||Info[23]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN] AS [w]
WHERE [w].[IS_DELETE] = False|||| end


2025-03-08 11:30:40.2028||Info[23]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN] AS [w]
WHERE [w].[IS_DELETE] = False|||| end


2025-03-08 11:30:40.2028||Info[23]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[ACTUAL_START_DT], [w].[CODE], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[END_DT], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INVENTORY_COUNT], [w].[IS_DELETE], [w].[PLAN_START_DT], [w].[STATUS], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN] AS [w]
WHERE [w].[IS_DELETE] = False
ORDER BY [w].[UPDATE_DT] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:30:40.2028||Info[23]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[ACTUAL_START_DT], [w].[CODE], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[END_DT], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INVENTORY_COUNT], [w].[IS_DELETE], [w].[PLAN_START_DT], [w].[STATUS], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN] AS [w]
WHERE [w].[IS_DELETE] = False
ORDER BY [w].[UPDATE_DT] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:30:42.0366||Info[23]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:30:42.0366||Info[23]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:30:42.0710||Info[23]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:30:42.0710||Info[23]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:32:43.6158||Info[32]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:32:43.6158||Info[32]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:32:43.6440||Info[32]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 200 ROWS ONLY|||| end


2025-03-08 11:32:43.6440||Info[32]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE ([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 200 ROWS ONLY|||| end


2025-03-08 11:33:09.7400||Info[39]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X001 = N'') OR (CHARINDEX(M012:115|3X001, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:33:09.7400||Info[39]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X001 = N'') OR (CHARINDEX(M012:115|3X001, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:33:09.7620||Info[39]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X001 = N'') OR (CHARINDEX(M012:115|3X001, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:33:09.7620||Info[39]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X001 = N'') OR (CHARINDEX(M012:115|3X001, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:33:36.3850||Info[47]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X = N'') OR (CHARINDEX(M012:115|3X, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:33:36.3850||Info[47]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X = N'') OR (CHARINDEX(M012:115|3X, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:33:36.4118||Info[47]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X = N'') OR (CHARINDEX(M012:115|3X, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:33:36.4118||Info[47]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115|3X = N'') OR (CHARINDEX(M012:115|3X, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:33:40.9986||Info[46]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115 = N'') OR (CHARINDEX(M012:115, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:33:40.9986||Info[46]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115 = N'') OR (CHARINDEX(M012:115, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:33:41.0206||Info[46]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115 = N'') OR (CHARINDEX(M012:115, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:33:41.0206||Info[46]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012:115 = N'') OR (CHARINDEX(M012:115, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:33:45.4750||Info[46]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012: = N'') OR (CHARINDEX(M012:, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:33:45.4750||Info[46]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012: = N'') OR (CHARINDEX(M012:, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)|||| end


2025-03-08 11:33:45.4966||Info[46]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012: = N'') OR (CHARINDEX(M012:, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 11:33:45.4966||Info[46]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[ID], [w].[BARCODE], [w].[BIN], [w].[CREATE_DT], [w].[CREATE_USER_ID], [w].[CREATER], [w].[DESCRIPTION], [w].[DRAWING_NO], [w].[EXT1], [w].[EXT2], [w].[EXT3], [w].[EXT4], [w].[EXT5], [w].[EXT6], [w].[INSERT_DT], [w].[INVENTORY_DT], [w].[INVENTORY_QTY], [w].[INVENTORY_STAGE], [w].[IS_ADD], [w].[IS_DELETE], [w].[LOT_NO], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[QTY], [w].[REMARK], [w].[RESULT], [w].[STATUS], [w].[UNIT], [w].[UPDATE_DT], [w].[UPDATE_USER_ID], [w].[UPDATER], [w].[WMS_INVENTORY_PLAN_CODE], [w].[WMS_INVENTORY_PLAN_ID], [w].[WMS_LOCATION_ID], [w].[WMS_WAREHOUSE_CODE], [w].[WMS_WAREHOUSE_ID], [w].[WMS_WAREHOUSE_NAME]
FROM [WMS_INVENTORY_PLAN_DETAIL] AS [w]
WHERE (([w].[WMS_INVENTORY_PLAN_CODE] = 2025030113) AND ((M012: = N'') OR (CHARINDEX(M012:, [w].[BARCODE]) > 0))) AND ([w].[IS_DELETE] = False)
ORDER BY [w].[INVENTORY_STAGE], [w].[MATERIAL_NO]
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:20:55.7910||Info[43]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [s].[ID], [s].[CN], [s].[CREATE_DT], [s].[CREATE_USER_ID], [s].[CREATER], [s].[EN], [s].[IS_DELETE], [s].[LANG], [s].[UPDATE_DT], [s].[UPDATE_USER_ID], [s].[UPDATER]
FROM [SYS_LOCALIZATION] AS [s]
WHERE [s].[IS_DELETE] = False
ORDER BY [s].[UPDATE_DT] DESC|||| end


2025-03-08 20:20:55.7910||Info[43]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [s].[ID], [s].[CN], [s].[CREATE_DT], [s].[CREATE_USER_ID], [s].[CREATER], [s].[EN], [s].[IS_DELETE], [s].[LANG], [s].[UPDATE_DT], [s].[UPDATE_USER_ID], [s].[UPDATER]
FROM [SYS_LOCALIZATION] AS [s]
WHERE [s].[IS_DELETE] = False
ORDER BY [s].[UPDATE_DT] DESC|||| end


2025-03-08 20:20:55.7991||Info[43]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ([w].[STATUS] <> 99) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:20:55.7991||Info[43]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ([w].[STATUS] <> 99) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:20:55.8945||Info[43]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ([w].[STATUS] <> 99) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:20:55.8945||Info[43]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ([w].[STATUS] <> 99) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:21:06.8155||Info[26]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:21:06.8155||Info[26]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:21:06.8395||Info[26]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:21:06.8395||Info[26]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:21:17.0265||Info[16]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青运动短裤)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:21:17.0265||Info[16]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青运动短裤)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:21:17.0563||Info[16]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青运动短裤)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:21:17.0563||Info[16]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青运动短裤)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:21:22.3052||Info[32]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青运动外套)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:21:22.3052||Info[32]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青运动外套)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:21:22.3289||Info[32]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青运动外套)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:21:22.3289||Info[32]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青运动外套)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:21:26.7668||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C秋季运动长裤)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:21:26.7668||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C秋季运动长裤)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:21:26.7909||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C秋季运动长裤)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:21:26.7909||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C秋季运动长裤)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:21:31.6371||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青冲锋衣)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:21:31.6371||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青冲锋衣)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:21:31.6639||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青冲锋衣)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:21:31.6639||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青冲锋衣)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:21:35.0146||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C冲锋衣冬裤)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:21:35.0146||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C冲锋衣冬裤)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:21:35.0378||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C冲锋衣冬裤)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:21:35.0378||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C冲锋衣冬裤)) AND ([w].[EXT1] = 170)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:22:35.7194||Info[54]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:22:35.7194||Info[54]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:22:35.7431||Info[54]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:22:35.7431||Info[54]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C白色POLO上衣)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:22:40.4923||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青运动短裤)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:22:40.4923||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青运动短裤)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:22:40.5155||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青运动短裤)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:22:40.5155||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青运动短裤)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:22:44.2715||Info[54]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青运动外套)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:22:44.2715||Info[54]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青运动外套)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:22:44.2955||Info[54]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青运动外套)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:22:44.2955||Info[54]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青运动外套)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:22:48.3462||Info[54]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C秋季运动长裤)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:22:48.3462||Info[54]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C秋季运动长裤)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:22:48.3696||Info[54]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C秋季运动长裤)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:22:48.3696||Info[54]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C秋季运动长裤)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:22:51.4276||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青冲锋衣)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:22:51.4276||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青冲锋衣)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:22:51.4568||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青冲锋衣)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:22:51.4568||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C藏青冲锋衣)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:22:55.4646||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C冲锋衣冬裤)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:22:55.4646||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT COUNT(*)
FROM (
    SELECT [w].[EXT1], [w].[EXT2], [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], SUM(CASE
        WHEN [w].[STATUS] = 1 THEN 1
        ELSE 0
    END) AS [c]
    FROM [WMS_DATA] AS [w]
    WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C冲锋衣冬裤)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
    GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
) AS [t]|||| end


2025-03-08 20:22:55.4941||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C冲锋衣冬裤)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end


2025-03-08 20:22:55.4941||Info[49]||EQuality.Framework.Dal.HintCommandInterceptor||SELECT [w].[EXT1] AS [Ext1], [w].[EXT2] AS [Ext2], [w].[MATERIAL_NAME] AS [MaterialName], [w].[MATERIAL_NO] AS [MaterialNo], [w].[MATERIAL_SPECS] AS [MaterialSpecs], [w].[MATERIAL_TYPE] AS [MaterialType], SUM(CASE
    WHEN [w].[STATUS] = 1 THEN 1
    ELSE 0
END) AS [Qty]
FROM [WMS_DATA] AS [w]
WHERE ((([w].[STATUS] <> 99) AND ([w].[MATERIAL_SPECS] = C冲锋衣冬裤)) AND ([w].[EXT1] = 165)) AND ([w].[IS_DELETE] = False)
GROUP BY [w].[MATERIAL_NAME], [w].[MATERIAL_NO], [w].[MATERIAL_SPECS], [w].[MATERIAL_TYPE], [w].[EXT1], [w].[EXT2]
ORDER BY [w].[MATERIAL_NO] DESC
OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY|||| end