From ed82ad3a75afb740911cd9128fbada56566a571f Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周一, 23 12月 2024 09:15:33 +0800 Subject: [PATCH] 040310 许工说这个工位机器人达不到,强行锁定 【Editby shaocx,2024-12-23】 --- 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