From f0088fd96c74f68ba912593710dd9271bcee581d Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周一, 23 12月 2024 10:12:32 +0800
Subject: [PATCH] NG处理，pda上增加一键 清理 板件队列（从 269 到bz01的队列数据）

---
 DBScript/01_DDL/03_DDL_VIEW.sql |   52 ++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 52 insertions(+), 0 deletions(-)

diff --git a/DBScript/01_DDL/03_DDL_VIEW.sql b/DBScript/01_DDL/03_DDL_VIEW.sql
index cd0c846..b646689 100644
--- a/DBScript/01_DDL/03_DDL_VIEW.sql
+++ b/DBScript/01_DDL/03_DDL_VIEW.sql
@@ -22,6 +22,58 @@
 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琛ㄧず 姝ｅ父
+AND station.PlaceCode <> '040310'  -- 040310 璁稿伐璇磋繖涓伐浣嶆満鍣ㄤ汉杈句笉鍒帮紝寮鸿閿佸畾 銆怑ditby shaocx,2024-12-23銆�
 AND svs.Id IS NULL 
 
+GO
+
+ /**
+ **  鏈哄櫒浜虹紦瀛樺簱鐨勫簱浣嶆煡璇㈣鍥�
+ **/
+IF EXISTS(SELECT 1 FROM sys.views WHERE name='V_Station_Quan') 
+   DROP VIEW V_Station_Quan 
+GO 
+CREATE VIEW V_Station_Quan
+AS
+
+ SELECT
+
+station.Id, station.PlaceCode, station.PlaceName, station.PlaceType, station.PlaceTypeName, station.[Length], 
+station.Width, station.Height, station.Thick, station.PlaceStatus, station.AreaId, station.AreaCode, station.AreaName, station.RowNo,
+ station.ColumnNo, station.LayerNo, station.LaneNo, station.IsVirtually, station.IsDisabled,
+ station.CreateTime, station.UpdateTime, station.CreateUserId, station.CreateUserName, station.UpdateUserId, station.UpdateUserName, station.IsDelete,
+ svs.InTime,svs.Upi,svs.DetailName,svs.PlanNo,svs.OrderId,svs.PackageCode,
+ svs.Length,svs.Width,svs.Thk,svs.StockStatus,svs.StockStatusName,
+  svs.OperReason,svs.OperUser,svs.OperTime,svs.LockStatus,svs.LockReason,svs.LockUser,svs.LockTime
+
+FROM dbo.wms_base_place as station
+LEFT JOIN dbo.wms_stock_quan as svs ON station.placeCode=svs.placeCode
+
+
+GO
+
+
+/**
+ **  鏈哄櫒浜虹紦瀛樺簱鐨勫簱瀛樻煡璇㈣鍥�
+ **/
+IF EXISTS(SELECT 1 FROM sys.views WHERE name='V_Station_Quan') 
+   DROP VIEW V_Station_Quan 
+GO 
+CREATE VIEW V_Station_Quan
+AS
+
+ SELECT
+
+station.Id, station.PlaceCode, station.PlaceName, station.PlaceType, station.PlaceTypeName, station.[Length], 
+station.Width, station.Height, station.Thick, station.PlaceStatus, station.AreaId, station.AreaCode, station.AreaName, station.RowNo,
+ station.ColumnNo, station.LayerNo, station.LaneNo, station.IsVirtually, station.IsDisabled,
+ station.CreateTime, station.UpdateTime, station.CreateUserId, station.CreateUserName, station.UpdateUserId, station.UpdateUserName, station.IsDelete,
+ svs.InTime,svs.Upi,svs.DetailName,svs.PlanNo,svs.OrderId,svs.PackageCode,
+ svs.Length,svs.Width,svs.Thk,svs.StockStatus,svs.StockStatusName,
+  svs.OperReason,svs.OperUser,svs.OperTime,svs.LockStatus,svs.LockReason,svs.LockUser,svs.LockTime
+
+FROM dbo.wms_base_place as station
+LEFT JOIN dbo.wms_stock_quan as svs ON station.placeCode=svs.placeCode
+
+
 GO
\ No newline at end of file

--
Gitblit v1.9.3