From c0e20b1b0f1298cdc0af0037d60e74d51e364501 Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周三, 17 9月 2025 14:38:06 +0800 Subject: [PATCH] //去掉这个删除验证 【Editby shaocx,2025-09-17】 --- 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