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
---
LA24030_LuLiPackageLine_Wms/Admin.NET.Application/View/WmsStockQuan/V_Station_Quan.cs | 155 ++++++++++++++++++++++++++++++++++++++
DBScript/01_DDL/03_DDL_VIEW.sql | 51 ++++++++++++
2 files changed, 206 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
diff --git a/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/View/WmsStockQuan/V_Station_Quan.cs b/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/View/WmsStockQuan/V_Station_Quan.cs
new file mode 100644
index 0000000..9ba7dba
--- /dev/null
+++ b/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/View/WmsStockQuan/V_Station_Quan.cs
@@ -0,0 +1,155 @@
+锘縰sing Admin.NET.Application;
+using Admin.NET.Core;
+
+
+namespace Admin.NET.Application.Entity
+{
+ /// <summary>
+ /// 鏈哄櫒浜虹紦瀛樺簱鐨勫簱浣嶆煡璇㈣鍥�
+ /// </summary>
+ [MySugarTableViewAttribute("V_Station_Quan", "鏈哄櫒浜虹紦瀛樺簱鐨勫簱瀛樻煡璇㈣鍥�")]
+ public class V_Station_Quan : WmsBasePlace
+ {
+ /// <summary>
+ /// 杩涘叆鏃堕棿
+ /// </summary>
+
+ [SugarColumn(ColumnName = "InTime", ColumnDescription = "杩涘叆鏃堕棿")]
+ public DateTime? InTime { get; set; }
+
+
+
+ /// <summary>
+ /// 閮ㄤ欢鏉＄爜
+ /// </summary>
+ [Required]
+ [SugarColumn(ColumnName = "Upi", ColumnDescription = "閮ㄤ欢鏉＄爜", Length = 100)]
+ public string Upi { get; set; }
+
+ /// <summary>
+ /// 閮ㄤ欢鍚嶇О
+ /// </summary>
+ [Required]
+ [SugarColumn(ColumnName = "DetailName", ColumnDescription = "閮ㄤ欢鍚嶇О", Length = 100)]
+ public string DetailName { get; set; }
+
+ /// <summary>
+ /// 鎵规
+ /// </summary>
+ [Required]
+ [SugarColumn(ColumnName = "PlanNo", ColumnDescription = "鎵规", Length = 100)]
+ public string PlanNo { get; set; }
+
+ /// <summary>
+ /// 璁㈠崟鍙�
+ /// </summary>
+ [Required]
+ [SugarColumn(ColumnName = "OrderId", ColumnDescription = "璁㈠崟鍙�", Length = 100)]
+ public string OrderId { get; set; }
+
+
+
+ /// <summary>
+ /// 鍖呰鍙�
+ /// </summary>
+ [Required]
+ [SugarColumn(ColumnName = "PackageCode", ColumnDescription = "鍖呰鍙�", Length = 100)]
+ public string PackageCode { get; set; }
+
+ [SugarColumn(ColumnName = "Length", ColumnDescription = "闀�")]
+ public float Length { get; set; }
+
+ [SugarColumn(ColumnName = "Width", ColumnDescription = "瀹�")]
+ public float Width { get; set; }
+
+ [SugarColumn(ColumnName = "Thk", ColumnDescription = "鍘�")]
+ public float Thk { get; set; }
+
+
+
+ #region 搴撳瓨鐘舵��
+
+ /// <summary>
+ /// 搴撳瓨鐘舵��
+ /// </summary>
+ [Required]
+
+ [SugarColumn(ColumnName = "StockStatus", ColumnDescription = "搴撳瓨鐘舵��")]
+ public StockStatusEnum StockStatus { get; set; }
+
+
+ /// <summary>
+ /// 搴撳瓨鐘舵�佸悕绉�
+ /// </summary>
+ [Required]
+ [SugarColumn(ColumnName = "StockStatusName", ColumnDescription = "搴撳瓨鐘舵�佸悕绉�", Length = 50)]
+
+ public string StockStatusName { get; set; }
+
+
+
+
+
+ /// <summary>
+ /// 鎿嶄綔鍘熷洜
+ /// </summary>
+ [SugarColumn(ColumnName = "OperReason", ColumnDescription = "鎿嶄綔鍘熷洜", Length = 255)]
+
+ public string? OperReason { get; set; }
+
+
+ /// <summary>
+ /// 鎿嶄綔浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "OperUser", ColumnDescription = "鎿嶄綔浜�", Length = 50)]
+
+ public string? OperUser { get; set; }
+
+
+ /// <summary>
+ /// 鎿嶄綔鏃堕棿
+ /// </summary>
+
+ [SugarColumn(ColumnName = "OperTime", ColumnDescription = "鎿嶄綔鏃堕棿")]
+ public DateTime? OperTime { get; set; }
+
+ #region 閿佸畾
+
+ /// <summary>
+ /// 閿佸畾鐘舵��
+ /// </summary>
+ [Required]
+
+ [SugarColumn(ColumnName = "LockStatus", ColumnDescription = "閿佸畾鐘舵��")]
+ public LockStatusEnum LockStatus { get; set; }
+
+
+ /// <summary>
+ /// 閿佸畾鍘熷洜
+ /// </summary>
+ [SugarColumn(ColumnName = "LockReason", ColumnDescription = "閿佸畾鍘熷洜", Length = 255)]
+
+ public string? LockReason { get; set; }
+
+
+ /// <summary>
+ /// 閿佸畾浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "LockUser", ColumnDescription = "閿佸畾浜�", Length = 50)]
+
+ public string? LockUser { get; set; }
+
+
+ /// <summary>
+ /// 閿佸畾鏃堕棿
+ /// </summary>
+
+ [SugarColumn(ColumnName = "LockTime", ColumnDescription = "閿佸畾鏃堕棿")]
+ public DateTime? LockTime { get; set; }
+
+ #endregion
+
+
+ #endregion
+ }
+}
\ No newline at end of file
--
Gitblit v1.9.3