From b884e533c4d906d3e004ea51750591f04863f881 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期五, 22 八月 2025 19:37:06 +0800
Subject: [PATCH] 基础资料的更新
---
MES.Service/Modes/MesDepots.cs | 284 +++++++++++++++++++++++---------------------------------
1 files changed, 119 insertions(+), 165 deletions(-)
diff --git a/MES.Service/Modes/MesDepots.cs b/MES.Service/Modes/MesDepots.cs
index ac6cc7b..da16258 100644
--- a/MES.Service/Modes/MesDepots.cs
+++ b/MES.Service/Modes/MesDepots.cs
@@ -8,248 +8,202 @@
public class MesDepots
{
/// <summary>
- /// 榛樿鍊�: (newid())
- /// </summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
[SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
- public string Guid { get; set; }
+ public Guid Guid { get; set; }
/// <summary>
- /// ID(SEQ_INV_ID)
- /// </summary>
- [SugarColumn(ColumnName = "depot_id")]
- public decimal DepotId { get; set; }
+ /// ID(SEQ_INV_ID)
+ ///</summary>
+ [SugarColumn(ColumnName = "DEPOT_ID")]
+ public long DepotId { get; set; }
/// <summary>
- /// 浠撳簱绫诲埆缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "depot_code")]
+ /// 浠撳簱绫诲埆缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName = "DEPOT_CODE")]
public string? DepotCode { get; set; }
/// <summary>
- /// 浠撳簱绫诲埆鍚嶇О
- /// </summary>
- [SugarColumn(ColumnName = "depot_name")]
+ /// 浠撳簱绫诲埆鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName = "DEPOT_NAME")]
public string? DepotName { get; set; }
/// <summary>
- /// 澶囨敞
- /// </summary>
- [SugarColumn(ColumnName = "description")]
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName = "DESCRIPTION")]
public string? Description { get; set; }
/// <summary>
- /// 浠撳簱璐熻矗浜�
- /// </summary>
- [SugarColumn(ColumnName = "create_by")]
+ /// 浠撳簱璐熻矗浜�
+ ///</summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
public string? CreateBy { get; set; }
/// <summary>
- /// 鍒涘缓鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "create_date")]
- public DateTime? CreateDate { get; set; }
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
+ public string? CreateDate { get; set; }
/// <summary>
- /// 鏈�鍚庢洿鏂颁汉
- /// </summary>
- [SugarColumn(ColumnName = "lastupdate_by")]
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
public string? LastupdateBy { get; set; }
/// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "lastupdate_date")]
- public DateTime? LastupdateDate { get; set; }
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ public string? LastupdateDate { get; set; }
/// <summary>
- /// 浠撳簱绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "depottype")]
+ /// 浠撳簱绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName = "DEPOTTYPE")]
public string? Depottype { get; set; }
/// <summary>
- /// 鍒嗗巶缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "factory")]
+ /// 鍒嗗巶缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName = "FACTORY")]
public string? Factory { get; set; }
/// <summary>
- /// 鐗╂枡浣跨敤
- /// 榛樿鍊�: ((0))
- /// </summary>
- [SugarColumn(ColumnName = "type_1")]
- public int? Type1 { get; set; }
+ /// 鐗╂枡浣跨敤
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName = "TYPE_1")]
+ public long? Type1 { get; set; }
/// <summary>
- /// 鎴愬搧浣跨敤
- /// 榛樿鍊�: ((0))
- /// </summary>
- [SugarColumn(ColumnName = "type_2")]
- public int? Type2 { get; set; }
+ /// 鎴愬搧浣跨敤
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName = "TYPE_2")]
+ public long? Type2 { get; set; }
/// <summary>
- /// 浠撳簱绫诲瀷缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "depottypecode")]
- public int? Depottypecode { get; set; }
+ /// 浠撳簱绫诲瀷缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName = "DEPOTTYPECODE")]
+ public long? Depottypecode { get; set; }
/// <summary>
- /// 鍏徃浠ｇ爜
- /// </summary>
- [SugarColumn(ColumnName = "company")]
+ /// 鍏徃浠ｇ爜
+ ///</summary>
+ [SugarColumn(ColumnName = "COMPANY")]
public string? Company { get; set; }
/// <summary>
- /// 鐪嬫澘鍥炬爣鏍峰紡
- /// </summary>
- [SugarColumn(ColumnName = "icon_type")]
- public int? IconType { get; set; }
+ /// 鐪嬫澘鍥炬爣鏍峰紡
+ ///</summary>
+ [SugarColumn(ColumnName = "ICON_TYPE")]
+ public long? IconType { get; set; }
/// <summary>
- /// 鏄惁濮斿浠撳簱
- /// 榛樿鍊�: ((0))
- /// </summary>
- [SugarColumn(ColumnName = "is_wy")]
- public int? IsWy { get; set; }
+ /// 鏄惁濮斿浠撳簱
+ /// 榛樿鍊�: ((0))
+ ///</summary>
+ [SugarColumn(ColumnName = "IS_WY")]
+ public long? IsWy { get; set; }
/// <summary>
- /// 鏄惁涓嶈壇鍝佷粨
- /// 榛樿鍊�: ((0))
- /// </summary>
- [SugarColumn(ColumnName = "is_ng")]
+ /// 鏄惁涓嶈壇鍝佷粨
+ /// 榛樿鍊�: ('0')
+ ///</summary>
+ [SugarColumn(ColumnName = "IS_NG")]
public string? IsNg { get; set; }
/// <summary>
- /// 浠撳簱鍦板潃
- /// </summary>
- [SugarColumn(ColumnName = "cwhaddress")]
+ /// 浠撳簱鍦板潃
+ ///</summary>
+ [SugarColumn(ColumnName = "CWHADDRESS")]
public string? Cwhaddress { get; set; }
/// <summary>
- /// 鐪嬫澘鏄剧ず鍖哄煙缂栧彿
- /// 榛樿鍊�: ((1))
- /// </summary>
- [SugarColumn(ColumnName = "pi_type")]
+ /// 鐪嬫澘鏄剧ず鍖哄煙缂栧彿
+ /// 榛樿鍊�: ('1')
+ ///</summary>
+ [SugarColumn(ColumnName = "PI_TYPE")]
public string? PiType { get; set; }
/// <summary>
- /// 鍒嗙粍
- /// </summary>
- [SugarColumn(ColumnName = "zuid")]
+ /// 鍒嗙粍
+ ///</summary>
+ [SugarColumn(ColumnName = "ZUID")]
public string? Zuid { get; set; }
/// <summary>
- /// 鍏佽鍗虫椂搴撳瓨璐熷簱瀛�
- /// </summary>
- [SugarColumn(ColumnName = "is_fkc")]
+ /// 鍏佽鍗虫椂搴撳瓨璐熷簱瀛�
+ ///</summary>
+ [SugarColumn(ColumnName = "IS_FKC")]
public string? IsFkc { get; set; }
/// <summary>
- /// 鐢熶骇杞﹂棿
- /// </summary>
- [SugarColumn(ColumnName = "production_workshop")]
+ /// 鐢熶骇杞﹂棿
+ ///</summary>
+ [SugarColumn(ColumnName = "PRODUCTION_WORKSHOP")]
public string? ProductionWorkshop { get; set; }
/// <summary>
- /// 鐗╂枡灞炴��
- /// </summary>
- [SugarColumn(ColumnName = "material_properti")]
+ /// 0=鏅�氫粨,1=闇插ぉ浠�,2=瀵勫浠�,3=澶栧瘎浠�,4=鍦ㄥ埗鍝侊紝5=鎶ュ簾
+ ///</summary>
+ [SugarColumn(ColumnName = "MATERIAL_PROPERTI")]
public string? MaterialProperti { get; set; }
/// <summary>
- /// 鑷畾涔夊瓧娈�3
- /// </summary>
- [SugarColumn(ColumnName = "remark3")]
+ /// 鍒涘缓缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName = "CREATE_ORG")]
+ public long? CreateOrg { get; set; }
+
+ /// <summary>
+ /// 浣跨敤缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName = "USE_ORG")]
+ public long? UseOrg { get; set; }
+
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�3
+ ///</summary>
+ [SugarColumn(ColumnName = "REMARK3")]
public string? Remark3 { get; set; }
/// <summary>
- /// 鑷畾涔夊瓧娈�4
- /// </summary>
- [SugarColumn(ColumnName = "remark4")]
+ /// 鑷畾涔夊瓧娈�4
+ ///</summary>
+ [SugarColumn(ColumnName = "REMARK4")]
public string? Remark4 { get; set; }
/// <summary>
- /// 鑷畾涔夊瓧娈�5
- /// </summary>
- [SugarColumn(ColumnName = "remark5")]
+ /// 鑷畾涔夊瓧娈�5
+ ///</summary>
+ [SugarColumn(ColumnName = "REMARK5")]
public string? Remark5 { get; set; }
/// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "check_date")]
- public DateTime? CheckDate { get; set; }
+ /// 0 =涓嶇敓鏁堬紝 1=鐢熸晥
+ ///</summary>
+ [SugarColumn(ColumnName = "FORBID_STATUS")]
+ public string? ForbidStatus { get; set; }
/// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "check_by")]
- public string? CheckBy { get; set; }
+ /// 鍗曟嵁鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName = "DOCUMENT_STATUS")]
+ public string? DocumentStatus { get; set; }
/// <summary>
- /// 榛樿鍊�: ((0))
- /// </summary>
- [SugarColumn(ColumnName = "check_status")]
- public bool? CheckStatus { get; set; }
-
- /// <summary>
- /// 鍒涘缓缁勭粐
- /// </summary>
- [SugarColumn(ColumnName = "Fumbrella")]
- public string? Fumbrella { get; set; }
-
- /// <summary>
- /// 浣跨敤缁勭粐
- /// </summary>
- [SugarColumn(ColumnName = "FSubsidiary")]
- public string? FSubsidiary { get; set; }
-
- /// <summary>
- /// 渚涘簲鍟�
- /// </summary>
- [SugarColumn(ColumnName = "SUPPLIER_ID")]
- public string? SupplierId { get; set; }
-
- /// <summary>
- /// 瀹㈡埛
- /// </summary>
- [SugarColumn(ColumnName = "Client_Id")]
- public string? ClientId { get; set; }
-
- /// <summary>
- /// 閮ㄩ棬
- /// </summary>
- [SugarColumn(ColumnName = "department")]
- public string? Department { get; set; }
-
- /// <summary>
- /// 鑱旂郴鐢佃瘽
- /// </summary>
- [SugarColumn(ColumnName = "Phone")]
- public string? Phone { get; set; }
+ /// 鎵瑰彿绠＄悊
+ ///</summary>
+ [SugarColumn(ColumnName = "IS_LOT")]
+ public string? IsLot { get; set; }
[SugarColumn(IsIgnore = true)] public string? Type { get; set; }
-
- /// <summary>
- /// 瀹㈡埛
- /// </summary>
- [SugarColumn(ColumnName = "FCustomerId")]
- public string? FCustomerId { get; set; }
- /// <summary>
- /// 鏁版嵁鐘舵��
- /// </summary>
- [SugarColumn(ColumnName = "FDocumentStatus")]
- public string? FDocumentStatus { get; set; }
- /// <summary>
- /// 搴撳瓨鐘舵�佺被鍨�
- /// </summary>
- [SugarColumn(ColumnName = "FStockStatusType")]
- public string? FStockStatusType { get; set; }
-
- /// <summary>
- /// 鍚敤浠撲綅绠＄悊
- /// </summary>
- [SugarColumn(ColumnName = "FISOPENLOCATION")]
- public string? FISOPENLOCATION { get; set; }
-
-
-
}
\ No newline at end of file
--
Gitblit v1.9.3