From bf86b73931230ea61ad8c5984367cea8a5f8baa6 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期五, 12 九月 2025 19:36:52 +0800
Subject: [PATCH] 11

---
 MES.Service/Modes/MesDepots.cs |  258 +++++++++++++++++++++++----------------------------
 1 files changed, 117 insertions(+), 141 deletions(-)

diff --git a/MES.Service/Modes/MesDepots.cs b/MES.Service/Modes/MesDepots.cs
index 170f4a3..877c158 100644
--- a/MES.Service/Modes/MesDepots.cs
+++ b/MES.Service/Modes/MesDepots.cs
@@ -15,256 +15,232 @@
     public Guid Guid { get; set; }
 
     /// <summary>
-    /// 浠撳簱ID
-    /// </summary>
-    [SugarColumn(ColumnName = "depot_id", IsIdentity = true)]
+    /// 浠撳簱ID 
+    ///</summary>
+    [SugarColumn(ColumnName = "depot_id")]
     public decimal DepotId { get; set; }
 
     /// <summary>
-    /// 浠撳簱缂栫爜
-    /// </summary>
-    [SugarColumn(ColumnName = "depot_code", Length = 50, IsNullable = true)]
+    /// 浠撳簱缂栫爜 
+    ///</summary>
+    [SugarColumn(ColumnName = "depot_code")]
     public string? DepotCode { get; set; }
 
     /// <summary>
-    /// 浠撳簱鍚嶇О
-    /// </summary>
-    [SugarColumn(ColumnName = "depot_name", Length = 100, IsNullable = true)]
+    /// 浠撳簱鍚嶇О 
+    ///</summary>
+    [SugarColumn(ColumnName = "depot_name")]
     public string? DepotName { get; set; }
 
     /// <summary>
-    /// 澶囨敞
-    /// </summary>
-    [SugarColumn(ColumnName = "description", Length = 255, IsNullable = true)]
+    /// 澶囨敞 
+    ///</summary>
+    [SugarColumn(ColumnName = "description")]
     public string? Description { get; set; }
 
     /// <summary>
-    /// 浠撳簱璐熻矗浜�
-    /// </summary>
-    [SugarColumn(ColumnName = "create_by", Length = 20, IsNullable = true)]
+    /// 浠撳簱璐熻矗浜� 
+    ///</summary>
+    [SugarColumn(ColumnName = "create_by")]
     public string? CreateBy { get; set; }
 
     /// <summary>
-    /// 鍒涘缓鏃堕棿
-    /// </summary>
-    [SugarColumn(ColumnName = "create_date", IsNullable = true)]
+    /// 鍒涘缓鏃堕棿 
+    ///</summary>
+    [SugarColumn(ColumnName = "create_date")]
     public DateTime? CreateDate { get; set; }
 
     /// <summary>
-    /// 鏈�鍚庢洿鏂颁汉
-    /// </summary>
-    [SugarColumn(ColumnName = "lastupdate_by", Length = 20, IsNullable = true)]
+    /// 鏈�鍚庢洿鏂颁汉 
+    ///</summary>
+    [SugarColumn(ColumnName = "lastupdate_by")]
     public string? LastupdateBy { get; set; }
 
     /// <summary>
-    /// 鏈�鍚庢洿鏂版椂闂�
-    /// </summary>
-    [SugarColumn(ColumnName = "lastupdate_date", IsNullable = true)]
+    /// 鏈�鍚庢洿鏂版椂闂� 
+    ///</summary>
+    [SugarColumn(ColumnName = "lastupdate_date")]
     public DateTime? LastupdateDate { get; set; }
 
     /// <summary>
-    /// 浠撳簱绫诲瀷
-    /// </summary>
-    [SugarColumn(ColumnName = "depottype", Length = 30, IsNullable = true)]
+    /// 浠撳簱绫诲瀷 
+    ///</summary>
+    [SugarColumn(ColumnName = "depottype")]
     public string? Depottype { get; set; }
 
     /// <summary>
-    /// 鍒嗗巶缂栫爜
-    /// </summary>
-    [SugarColumn(ColumnName = "factory", Length = 20, IsNullable = true)]
+    /// 鍒嗗巶缂栫爜 
+    ///</summary>
+    [SugarColumn(ColumnName = "factory")]
     public string? Factory { get; set; }
 
     /// <summary>
-    /// 鐗╂枡浣跨敤 (榛樿 0)
-    /// </summary>
-    [SugarColumn(ColumnName = "type_1", IsNullable = true)]
+    /// 鐗╂枡浣跨敤 
+    /// 榛樿鍊�: ((0))
+    ///</summary>
+    [SugarColumn(ColumnName = "type_1")]
     public int? Type1 { get; set; }
 
     /// <summary>
-    /// 鎴愬搧浣跨敤 (榛樿 0)
-    /// </summary>
-    [SugarColumn(ColumnName = "type_2", IsNullable = true)]
+    /// 鎴愬搧浣跨敤 
+    /// 榛樿鍊�: ((0))
+    ///</summary>
+    [SugarColumn(ColumnName = "type_2")]
     public int? Type2 { get; set; }
 
     /// <summary>
-    /// 浠撳簱绫诲瀷缂栫爜
-    /// </summary>
-    [SugarColumn(ColumnName = "depottypecode", IsNullable = true)]
+    /// 浠撳簱绫诲瀷缂栫爜 
+    ///</summary>
+    [SugarColumn(ColumnName = "depottypecode")]
     public int? Depottypecode { get; set; }
 
     /// <summary>
-    /// 鍏徃浠ｇ爜
-    /// </summary>
-    [SugarColumn(ColumnName = "company", Length = 20, IsNullable = true)]
+    /// 鍏徃浠ｇ爜 
+    ///</summary>
+    [SugarColumn(ColumnName = "company")]
     public string? Company { get; set; }
 
     /// <summary>
-    /// 鐪嬫澘鍥炬爣鏍峰紡
-    /// </summary>
-    [SugarColumn(ColumnName = "icon_type", IsNullable = true)]
+    /// 鐪嬫澘鍥炬爣鏍峰紡 
+    ///</summary>
+    [SugarColumn(ColumnName = "icon_type")]
     public int? IconType { get; set; }
 
     /// <summary>
-    /// 鏄惁濮斿浠撳簱 (榛樿 0)
-    /// </summary>
-    [SugarColumn(ColumnName = "is_wy", IsNullable = true)]
+    /// 鏄惁濮斿浠撳簱 
+    /// 榛樿鍊�: ((0))
+    ///</summary>
+    [SugarColumn(ColumnName = "is_wy")]
     public int? IsWy { get; set; }
 
     /// <summary>
-    /// 绂佺敤鐘舵�� (榛樿 0) 娉ㄦ剰锛氬師琛ㄤ负 nvarchar(10) 涓旈粯璁� '0'
-    /// </summary>
-    [SugarColumn(ColumnName = "is_ng", Length = 10, IsNullable = true)]
+    /// 绂佺敤鐘舵�� 
+    /// 榛樿鍊�: ((0))
+    ///</summary>
+    [SugarColumn(ColumnName = "is_ng")]
     public string? IsNg { get; set; }
 
     /// <summary>
-    /// 浠撳簱鍦板潃
-    /// </summary>
-    [SugarColumn(ColumnName = "cwhaddress", Length = 200, IsNullable = true)]
+    /// 浠撳簱鍦板潃 
+    ///</summary>
+    [SugarColumn(ColumnName = "cwhaddress")]
     public string? Cwhaddress { get; set; }
 
     /// <summary>
-    /// 鐪嬫澘鏄剧ず鍖哄煙缂栧彿 (榛樿 1)
-    /// </summary>
-    [SugarColumn(ColumnName = "pi_type", Length = 10, IsNullable = true)]
+    /// 鐪嬫澘鏄剧ず鍖哄煙缂栧彿 
+    /// 榛樿鍊�: ((1))
+    ///</summary>
+    [SugarColumn(ColumnName = "pi_type")]
     public string? PiType { get; set; }
 
     /// <summary>
-    /// 鍒嗙粍
-    /// </summary>
-    [SugarColumn(ColumnName = "zuid", Length = 20, IsNullable = true)]
+    /// 鍒嗙粍 
+    ///</summary>
+    [SugarColumn(ColumnName = "zuid")]
     public string? Zuid { get; set; }
 
     /// <summary>
-    /// 鍏佽鍗虫椂搴撳瓨璐熷簱瀛�
-    /// </summary>
-    [SugarColumn(ColumnName = "is_fkc", Length = 30, IsNullable = true)]
+    /// 鍏佽鍗虫椂搴撳瓨璐熷簱瀛� 
+    ///</summary>
+    [SugarColumn(ColumnName = "is_fkc")]
     public string? IsFkc { get; set; }
 
     /// <summary>
-    /// 鐢熶骇杞﹂棿
-    /// </summary>
-    [SugarColumn(ColumnName = "production_workshop", Length = 32,
-        IsNullable = true)]
+    /// 鐢熶骇杞﹂棿 
+    ///</summary>
+    [SugarColumn(ColumnName = "production_workshop")]
     public string? ProductionWorkshop { get; set; }
 
     /// <summary>
-    /// 鐗╂枡灞炴��
-    /// </summary>
-    [SugarColumn(ColumnName = "material_properti", Length = 32,
-        IsNullable = true)]
+    /// 鐗╂枡灞炴�� 
+    ///</summary>
+    [SugarColumn(ColumnName = "material_properti")]
     public string? MaterialProperti { get; set; }
 
     /// <summary>
-    /// 鑷畾涔夊瓧娈�3
-    /// </summary>
-    [SugarColumn(ColumnName = "remark3", Length = 32, IsNullable = true)]
+    /// 鑷畾涔夊瓧娈�3 
+    ///</summary>
+    [SugarColumn(ColumnName = "remark3")]
     public string? Remark3 { get; set; }
 
     /// <summary>
-    /// 鑷畾涔夊瓧娈�4
-    /// </summary>
-    [SugarColumn(ColumnName = "remark4", Length = 32, IsNullable = true)]
+    /// 鑷畾涔夊瓧娈�4 
+    ///</summary>
+    [SugarColumn(ColumnName = "remark4")]
     public string? Remark4 { get; set; }
 
     /// <summary>
-    /// 鑷畾涔夊瓧娈�5
-    /// </summary>
-    [SugarColumn(ColumnName = "remark5", Length = 32, IsNullable = true)]
+    /// 鑷畾涔夊瓧娈�5锛屼粨搴撳睘鎬� 
+    ///</summary>
+    [SugarColumn(ColumnName = "remark5")]
     public string? Remark5 { get; set; }
 
     /// <summary>
-    /// 鐐规鏃堕棿
-    /// </summary>
-    [SugarColumn(ColumnName = "check_date", IsNullable = true)]
+    ///  
+    ///</summary>
+    [SugarColumn(ColumnName = "check_date")]
     public DateTime? CheckDate { get; set; }
 
     /// <summary>
-    /// 鐐规浜�
-    /// </summary>
-    [SugarColumn(ColumnName = "check_by", Length = 50, IsNullable = true)]
+    ///  
+    ///</summary>
+    [SugarColumn(ColumnName = "check_by")]
     public string? CheckBy { get; set; }
 
     /// <summary>
-    /// 鐐规鐘舵�� (榛樿 0)
-    /// </summary>
-    [SugarColumn(ColumnName = "check_status", IsNullable = true)]
+    ///  
+    /// 榛樿鍊�: ((0))
+    ///</summary>
+    [SugarColumn(ColumnName = "check_status")]
     public bool? CheckStatus { get; set; }
 
     /// <summary>
-    /// 鍒涘缓缁勭粐
-    /// </summary>
-    [SugarColumn(ColumnName = "Fumbrella", Length = 32, IsNullable = true)]
+    /// 鍒涘缓缁勭粐 
+    ///</summary>
+    [SugarColumn(ColumnName = "Fumbrella")]
     public string? Fumbrella { get; set; }
 
     /// <summary>
-    /// 浣跨敤缁勭粐
-    /// </summary>
-    [SugarColumn(ColumnName = "FSubsidiary", Length = 32, IsNullable = true)]
+    /// 浣跨敤缁勭粐 
+    ///</summary>
+    [SugarColumn(ColumnName = "FSubsidiary")]
     public string? FSubsidiary { get; set; }
 
     /// <summary>
-    /// 渚涘簲鍟�
-    /// </summary>
-    [SugarColumn(ColumnName = "SUPPLIER_ID", Length = 50, IsNullable = true)]
+    /// 渚涘簲鍟� 
+    ///</summary>
+    [SugarColumn(ColumnName = "SUPPLIER_ID")]
     public string? SupplierId { get; set; }
 
     /// <summary>
-    /// 瀹㈡埛
-    /// </summary>
-    [SugarColumn(ColumnName = "Client_Id", Length = 50, IsNullable = true)]
+    /// 瀹㈡埛 
+    ///</summary>
+    [SugarColumn(ColumnName = "Client_Id")]
     public string? ClientId { get; set; }
 
     /// <summary>
-    /// 閮ㄩ棬
-    /// </summary>
-    [SugarColumn(ColumnName = "department", Length = 50, IsNullable = true)]
+    /// 閮ㄩ棬 
+    ///</summary>
+    [SugarColumn(ColumnName = "department")]
     public string? Department { get; set; }
 
     /// <summary>
-    /// 鑱旂郴鐢佃瘽
-    /// </summary>
-    [SugarColumn(ColumnName = "Phone", Length = 50, IsNullable = true)]
+    /// 鑱旂郴鐢佃瘽 
+    ///</summary>
+    [SugarColumn(ColumnName = "Phone")]
     public string? Phone { get; set; }
 
     /// <summary>
-    /// Z=鏆傚瓨,A=鍒涘缓,B=瀹℃牳涓�,C=宸插鏍�,D=閲嶆柊瀹℃牳
-    /// </summary>
-    [SugarColumn(ColumnName = "DOCUMENT_STATUS", Length = 10,
-        IsNullable = true)]
+    /// Z=鏆傚瓨,A=鍒涘缓,B=瀹℃牳涓�,C=宸插鏍�,D=閲嶆柊瀹℃牳 
+    ///</summary>
+    [SugarColumn(ColumnName = "DOCUMENT_STATUS")]
     public string? DocumentStatus { get; set; }
 
     /// <summary>
-    /// 0=鍙敤,4=鍦ㄩ��,6=搴熷搧,2=鍐荤粨,5=鏀惰揣鍐荤粨,1=寰呮,8=涓嶅弬涓庢牳绠�,3=閫�鍥炲喕缁�,7=涓嶈壇
-    /// </summary>
-    [SugarColumn(ColumnName = "STOCK_STATUS_TYPE", Length = 50,
-        IsNullable = true)]
+    /// 0=鍙敤,4=鍦ㄩ��,6=搴熷搧,2=鍐荤粨,5=鏀惰揣鍐荤粨,1=寰呮,8=涓嶅弬涓庢牳绠�,3=閫�鍥炲喕缁�,7=涓嶈壇 
+    ///</summary>
+    [SugarColumn(ColumnName = "STOCK_STATUS_TYPE")]
     public string? StockStatusType { get; set; }
-
-    /// <summary>
-    /// 鏁版嵁鐘舵��
-    /// </summary>
-    [SugarColumn(ColumnName = "FDocumentStatus", Length = 100,
-        IsNullable = true)]
-    public string? FDocumentStatus { get; set; }
-
-    /// <summary>
-    /// 瀹㈡埛 (鏁存暟)
-    /// </summary>
-    [SugarColumn(ColumnName = "FCustomerId", IsNullable = true)]
-    public int? FCustomerId { get; set; }
-
-    /// <summary>
-    /// 搴撳瓨鐘舵�佺被鍨�
-    /// </summary>
-    [SugarColumn(ColumnName = "FStockStatusType", Length = 50,
-        IsNullable = true)]
-    public string? FStockStatusType { get; set; }
-
-    /// <summary>
-    /// 鍚敤浠撲綅绠＄悊
-    /// </summary>
-    [SugarColumn(ColumnName = "FISOPENLOCATION", Length = 5, IsNullable = true)]
-    public string? FIsOpenLocation { get; set; }
 
 
     [SugarColumn(IsIgnore = true)] public string? Type { get; set; }

--
Gitblit v1.9.3