From 158cee87388cd002fc5c920138d2b7446f670fc2 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周一, 25 11月 2024 13:39:10 +0800
Subject: [PATCH] 22

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

diff --git a/DBScript/01_DDL/03_DDL_VIEW.sql b/DBScript/01_DDL/03_DDL_VIEW.sql
index cd0c846..629ae81 100644
--- a/DBScript/01_DDL/03_DDL_VIEW.sql
+++ b/DBScript/01_DDL/03_DDL_VIEW.sql
@@ -24,4 +24,55 @@
 AND station.PlaceStatus=1  -- 1琛ㄧず 姝ｅ父
 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