2025-03-09 11:07:26.8745||Info[193]||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-09 11:07:26.8745||Info[193]||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-09 11:07:26.8745||Info[193]||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] = NX男款西服外套)) AND ([w].[EXT1] = 160)) 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-09 11:07:26.8745||Info[193]||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] = NX男款西服外套)) AND ([w].[EXT1] = 160)) 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-09 11:07:26.9126||Info[193]||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] = NX男款西服外套)) AND ([w].[EXT1] = 160)) 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 200 ROWS ONLY|||| end


2025-03-09 11:07:26.9126||Info[193]||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] = NX男款西服外套)) AND ([w].[EXT1] = 160)) 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 200 ROWS ONLY|||| end


2025-03-09 11:07:34.7703||Info[126]||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] = NX女款西服外套)) AND ([w].[EXT1] = 160)) 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-09 11:07:34.7703||Info[126]||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] = NX女款西服外套)) AND ([w].[EXT1] = 160)) 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-09 11:07:34.7944||Info[126]||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] = NX女款西服外套)) AND ([w].[EXT1] = 160)) 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 200 ROWS ONLY|||| end


2025-03-09 11:07:34.7944||Info[126]||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] = NX女款西服外套)) AND ([w].[EXT1] = 160)) 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 200 ROWS ONLY|||| end