From 45027a3c039d5988b4d5fc95d6803ed517e2e7db Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期二, 06 五月 2025 15:59:36 +0800
Subject: [PATCH] 1.工单计划下达时间优化
---
MES.Service/Modes/MesDepots.cs | 160 +++++++++++++++++++++++++++++++++++++++++++++++------
1 files changed, 141 insertions(+), 19 deletions(-)
diff --git a/MES.Service/Modes/MesDepots.cs b/MES.Service/Modes/MesDepots.cs
index fae92cb..022bcf5 100644
--- a/MES.Service/Modes/MesDepots.cs
+++ b/MES.Service/Modes/MesDepots.cs
@@ -3,106 +3,228 @@
namespace MES.Service.Modes;
/// <summary>
-/// 浠撳簱淇℃伅
/// </summary>
[SugarTable("MES_DEPOTS")]
public class MesDepots
{
/// <summary>
+ /// 榛樿鍊�: (newid())
+ /// </summary>
+ [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
+ public Guid Guid { get; set; }
+
+ /// <summary>
/// ID(SEQ_INV_ID)
/// </summary>
- [SugarColumn(ColumnName = "DEPOT_ID", IsPrimaryKey = true)]
+ [SugarColumn(ColumnName = "depot_id")]
public decimal DepotId { get; set; }
/// <summary>
/// 浠撳簱绫诲埆缂栫爜
/// </summary>
- [SugarColumn(ColumnName = "DEPOT_CODE")]
+ [SugarColumn(ColumnName = "depot_code")]
public string? DepotCode { get; set; }
/// <summary>
/// 浠撳簱绫诲埆鍚嶇О
/// </summary>
- [SugarColumn(ColumnName = "DEPOT_NAME")]
+ [SugarColumn(ColumnName = "depot_name")]
public string? DepotName { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "description")]
+ public string? Description { get; set; }
/// <summary>
/// 浠撳簱璐熻矗浜�
/// </summary>
- [SugarColumn(ColumnName = "CREATE_BY")]
+ [SugarColumn(ColumnName = "create_by")]
public string? CreateBy { get; set; }
/// <summary>
/// 鍒涘缓鏃堕棿
/// </summary>
- [SugarColumn(ColumnName = "CREATE_DATE")]
+ [SugarColumn(ColumnName = "create_date")]
public DateTime? CreateDate { get; set; }
/// <summary>
/// 鏈�鍚庢洿鏂颁汉
/// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+ [SugarColumn(ColumnName = "lastupdate_by")]
public string? LastupdateBy { get; set; }
/// <summary>
/// 鏈�鍚庢洿鏂版椂闂�
/// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ [SugarColumn(ColumnName = "lastupdate_date")]
public DateTime? LastupdateDate { get; set; }
/// <summary>
/// 浠撳簱绫诲瀷
/// </summary>
- [SugarColumn(ColumnName = "DEPOTTYPE")]
+ [SugarColumn(ColumnName = "depottype")]
public string? Depottype { get; set; }
/// <summary>
/// 鍒嗗巶缂栫爜
/// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
+ [SugarColumn(ColumnName = "factory")]
public string? Factory { get; set; }
+ /// <summary>
+ /// 鐗╂枡浣跨敤
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "type_1")]
+ public int? Type1 { get; set; }
+
+ /// <summary>
+ /// 鎴愬搧浣跨敤
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "type_2")]
+ public int? Type2 { get; set; }
+
+ /// <summary>
+ /// 浠撳簱绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "depottypecode")]
+ public int? Depottypecode { get; set; }
/// <summary>
/// 鍏徃浠ｇ爜
/// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
+ [SugarColumn(ColumnName = "company")]
public string? Company { get; set; }
+ /// <summary>
+ /// 鐪嬫澘鍥炬爣鏍峰紡
+ /// </summary>
+ [SugarColumn(ColumnName = "icon_type")]
+ public int? IconType { get; set; }
+
+ /// <summary>
+ /// 鏄惁濮斿浠撳簱
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "is_wy")]
+ public int? IsWy { get; set; }
/// <summary>
/// 鏄惁涓嶈壇鍝佷粨
+ /// 榛樿鍊�: ((0))
/// </summary>
- [SugarColumn(ColumnName = "IS_NG")]
+ [SugarColumn(ColumnName = "is_ng")]
public string? IsNg { get; set; }
+ /// <summary>
+ /// 浠撳簱鍦板潃
+ /// </summary>
+ [SugarColumn(ColumnName = "cwhaddress")]
+ public string? Cwhaddress { get; set; }
/// <summary>
- /// 浠撲綅缁処D
+ /// 鐪嬫澘鏄剧ず鍖哄煙缂栧彿
+ /// 榛樿鍊�: ((1))
/// </summary>
- [SugarColumn(ColumnName = "ZUID")]
+ [SugarColumn(ColumnName = "pi_type")]
+ public string? PiType { get; set; }
+
+ /// <summary>
+ /// 鍒嗙粍
+ /// </summary>
+ [SugarColumn(ColumnName = "zuid")]
public string? Zuid { get; set; }
/// <summary>
/// 鍏佽鍗虫椂搴撳瓨璐熷簱瀛�
/// </summary>
- [SugarColumn(ColumnName = "IS_FKC")]
+ [SugarColumn(ColumnName = "is_fkc")]
public string? IsFkc { get; set; }
+ /// <summary>
+ /// 鐢熶骇杞﹂棿
+ /// </summary>
+ [SugarColumn(ColumnName = "production_workshop")]
+ public string? ProductionWorkshop { get; set; }
/// <summary>
- /// 浣跨敤绲勭箶
+ /// 鐗╂枡灞炴��
+ /// </summary>
+ [SugarColumn(ColumnName = "material_properti")]
+ public string? MaterialProperti { get; set; }
+
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�3
+ /// </summary>
+ [SugarColumn(ColumnName = "remark3")]
+ public string? Remark3 { get; set; }
+
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�4
+ /// </summary>
+ [SugarColumn(ColumnName = "remark4")]
+ public string? Remark4 { get; set; }
+
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�5
+ /// </summary>
+ [SugarColumn(ColumnName = "remark5")]
+ public string? Remark5 { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "check_date")]
+ public DateTime? CheckDate { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "check_by")]
+ public string? CheckBy { 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 = "Fumbrella")]
- public string? Fumbrella { get; set; }
+ [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; }
[SugarColumn(IsIgnore = true)] public string? Type { get; set; }
}
\ No newline at end of file
--
Gitblit v1.9.3