From 37184b1d1ac000a6ee40e397e2336b213e705902 Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周四, 17 4月 2025 13:08:45 +0800 Subject: [PATCH] 包中只有一块板时,认定为 不齐包 【Editby shaocx,2025-04-01】 --- DBScript/01_DDL/03_DDL_VIEW.sql | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diff --git a/DBScript/01_DDL/03_DDL_VIEW.sql b/DBScript/01_DDL/03_DDL_VIEW.sql index 629ae81..b646689 100644 --- a/DBScript/01_DDL/03_DDL_VIEW.sql +++ b/DBScript/01_DDL/03_DDL_VIEW.sql @@ -22,6 +22,7 @@ LEFT JOIN dbo.wms_stock_quan as svs ON station.placeCode=svs.placeCode WHERE station.IsDisabled=0 AND station.IsDelete=0 AND station.PlaceStatus=1 -- 1琛ㄧず 姝e父 +AND station.PlaceCode <> '040310' -- 040310 璁稿伐璇磋繖涓伐浣嶆満鍣ㄤ汉杈句笉鍒帮紝寮鸿閿佸畾 銆怑ditby shaocx,2024-12-23銆� AND svs.Id IS NULL GO -- Gitblit v1.9.3