From 53171273a4cd9049d532f031f389364982d219d7 Mon Sep 17 00:00:00 2001
From: Rodney Chen <rodney.chen@hotmail.com>
Date: 星期五, 12 七月 2024 15:18:24 +0800
Subject: [PATCH] 更新实体
---
Tiger.Model.Net/Entitys/MES/BIZ_MES_WO.cs | 565 ++++++++++++++++++++++++++++----------------------------
1 files changed, 285 insertions(+), 280 deletions(-)
diff --git a/Tiger.Model.Net/Entitys/MES/BIZ_MES_WO.cs b/Tiger.Model.Net/Entitys/MES/BIZ_MES_WO.cs
index ad5aeda..911a867 100644
--- a/Tiger.Model.Net/Entitys/MES/BIZ_MES_WO.cs
+++ b/Tiger.Model.Net/Entitys/MES/BIZ_MES_WO.cs
@@ -6,303 +6,308 @@
namespace Tiger.Model
{
- /// <summary>
- /// 瀹炰綋锛氬伐鍗�
- /// </summary>
- [Description("Primary:ID")]
- [DisplayName("宸ュ崟")]
- [Serializable]
- [SugarTable("BIZ_MES_WO")]
- public class BIZ_MES_WO : DbEntityWithAuth
- {
- #region 鏋勯�犲嚱鏁�
- /// <summary>
- /// 瀹炰綋锛氬伐鍗�
- /// </summary>
- public BIZ_MES_WO() { }
- #endregion
+ /// <summary>
+ /// 实体：工单
+ /// </summary>
+ [Description("Primary:ID")]
+ [DisplayName("工单")]
+ [Serializable]
+ [SugarTable("BIZ_MES_WO")]
+ public class BIZ_MES_WO : DbEntityWithAuth
+ {
+ #region 构造函数
+ /// <summary>
+ /// 实体：工单
+ /// </summary>
+ public BIZ_MES_WO() {}
+ #endregion
- #region 鍏叡灞炴��
- /// <summary>
- /// 宸ュ崟鍙�
- /// </summary>
- [DisplayName("宸ュ崟鍙�")]
- public string ORDER_NO { get; set; }
- /// <summary>
- /// 宸ュ崟绫诲瀷(0Plan璁″垝|1Standard鏍囧噯|2Rework杩斿伐|3Restructuring鍦ㄥ簱鏀瑰埗|5濮斿Outsourcing|6RD鐮斿彂|7Forecast棰勬祴|8Disassemble鎷嗗嵏)
- /// </summary>
- [DisplayName("宸ュ崟绫诲瀷(0Plan璁″垝|1Standard鏍囧噯|2Rework杩斿伐|3Restructuring鍦ㄥ簱鏀瑰埗|5Outsourcing濮斿|6RD鐮斿彂|7Forecast棰勬祴|8Disassemble鎷嗗嵏)")]
- public string ORDER_TYPE { get; set; }
- /// <summary>
- /// 宸ュ崟鎻忚堪
- /// </summary>
- [DisplayName("宸ュ崟鎻忚堪")]
- public string ORDER_DESC { get; set; }
- /// <summary>
- /// 鐖跺伐鍗�
- /// </summary>
- [DisplayName("鐖跺伐鍗�")]
- public string PARENT_ORDER { get; set; }
- /// <summary>
- /// 鐘舵��(0Init鍒濆鍖東1Imported宸插鍏2Release宸蹭笅鍙憒3Working鐢熶骇涓瓅4Paused宸叉殏鍋渱5Closed宸插叧闂�)
- /// </summary>
- [DisplayName("鐘舵��(0Init鍒濆鍖東1Imported宸插鍏2Release宸蹭笅鍙憒3Working鐢熶骇涓瓅4Paused宸叉殏鍋渱5Closed宸插叧闂�)")]
- public int STATUS { get; set; }
- /// <summary>
- /// 鐗╂枡缂栫爜
- /// </summary>
- [DisplayName("鐗╂枡缂栫爜")]
- public string ITEM_CODE { get; set; }
- /// <summary>
- /// 鐗╂枡绫诲瀷
- /// </summary>
- [DisplayName("鐗╂枡绫诲瀷")]
- public string ITEM_TYPE { get; set; }
- /// <summary>
- /// 鏈哄瀷
- /// </summary>
- [DisplayName("鏈哄瀷")]
- public string ITEM_MODEL { get; set; }
- /// <summary>
- /// 浼樺厛绾�
- /// </summary>
- [DisplayName("浼樺厛绾�")]
- public string PRIORITY { get; set; }
- /// <summary>
- /// 瀹㈡埛缂栫爜
- /// </summary>
- [DisplayName("瀹㈡埛缂栫爜")]
- public string CUST_CODE { get; set; }
- /// <summary>
- /// 璺敱缂栫爜
- /// </summary>
- [DisplayName("璺敱缂栫爜")]
- public string ROUTE_CODE { get; set; }
- /// <summary>
- /// 宸ヨ壓鐘舵��(0WaitSet寰呴厤缃畖1Finish宸查厤缃畖2Cancel鍙栨秷|3Close鍏抽棴)
- /// </summary>
- [DisplayName("宸ヨ壓鐘舵��(0WaitSet寰呴厤缃畖1Finish宸查厤缃畖2Cancel鍙栨秷|3Close鍏抽棴)")]
- public int ROUTE_STATUS { get; set; }
- /// <summary>
- /// 宸ュ巶
- /// </summary>
- [DisplayName("宸ュ巶")]
- public string FACTORY { get; set; }
- /// <summary>
- /// 杞﹂棿缂栫爜
- /// </summary>
- [DisplayName("杞﹂棿缂栫爜")]
- public string WS_CODE { get; set; }
- /// <summary>
- /// 璁″垝绾夸綋
- /// </summary>
- [DisplayName("璁″垝绾夸綋")]
- public string PLAN_LINE { get; set; }
- /// <summary>
- /// 瀹為檯绾夸綋
- /// </summary>
- [DisplayName("瀹為檯绾夸綋")]
- public string ACT_LINE { get; set; }
- /// <summary>
- /// 璁″垝寮�濮嬫椂闂�
- /// </summary>
- [DisplayName("璁″垝寮�濮嬫椂闂�")]
- public DateTime PLAN_START_TIME { get; set; } = DateTime.MinValue;
- /// <summary>
- /// 璁″垝缁撴潫鏃堕棿
- /// </summary>
- [DisplayName("璁″垝缁撴潫鏃堕棿")]
- public DateTime PLAN_END_TIME { get; set; } = DateTime.MinValue;
- /// <summary>
- /// 瀹為檯寮�濮嬫椂闂�
- /// </summary>
- [DisplayName("瀹為檯寮�濮嬫椂闂�")]
- public DateTime ACT_START_TIME { get; set; } = DateTime.MinValue;
- /// <summary>
- /// 瀹為檯缁撴潫鏃堕棿
- /// </summary>
- [DisplayName("瀹為檯缁撴潫鏃堕棿")]
- public DateTime ACT_END_TIME { get; set; } = DateTime.MinValue;
- /// <summary>
- /// 鏍囧噯浣滀笟浜烘暟
- /// </summary>
- [DisplayName("鏍囧噯浣滀笟浜烘暟")]
- public int STD_WORKER_QTY { get; set; }
- /// <summary>
- /// 瀹為檯浣滀笟浜烘暟
- /// </summary>
- [DisplayName("瀹為檯浣滀笟浜烘暟")]
- public int ACT_WORKER_QTY { get; set; }
- /// <summary>
- /// 瀵煎叆鏃堕棿
- /// </summary>
- [DisplayName("瀵煎叆鏃堕棿")]
- public DateTime IMPORT_TIME { get; set; } = DateTime.MinValue;
- /// <summary>
- /// 涓嬪彂鏃堕棿
- /// </summary>
- [DisplayName("涓嬪彂鏃堕棿")]
- public DateTime RELEASE_TIME { get; set; } = DateTime.MinValue;
- /// <summary>
- /// 涓嬪彂浜�
- /// </summary>
- [DisplayName("涓嬪彂浜�")]
- public string RELEASE_USER { get; set; }
- /// <summary>
- /// 鍙樻洿鏃堕棿
- /// </summary>
- [DisplayName("鍙樻洿鏃堕棿")]
- public DateTime CHANGE_TIME { get; set; } = DateTime.MinValue;
- /// <summary>
- /// 鍙樻洿浜�
- /// </summary>
- [DisplayName("鍙樻洿浜�")]
- public string CHANGE_USER { get; set; }
- /// <summary>
- /// 璁″垝鏁伴噺
- /// </summary>
- [DisplayName("璁″垝鏁伴噺")]
- public int PLAN_QTY { get; set; }
- /// <summary>
- /// 鎶曞叆鏁伴噺
- /// </summary>
- [DisplayName("鎶曞叆鏁伴噺")]
- public int INPUT_QTY { get; set; }
- /// <summary>
- /// 瀹屽伐鏁伴噺
- /// </summary>
- [DisplayName("瀹屽伐鏁伴噺")]
- public int OUTPUT_QTY { get; set; }
- /// <summary>
- /// 鎶ュ簾鏁伴噺
- /// </summary>
- [DisplayName("鎶ュ簾鏁伴噺")]
- public int SCRAP_QTY { get; set; }
- /// <summary>
- /// 鍏ュ簱鏁伴噺
- /// </summary>
- [DisplayName("鍏ュ簱鏁伴噺")]
- public int STOCK_IN_QTY { get; set; }
- /// <summary>
- /// UPH
- /// </summary>
- [DisplayName("UPH")]
- public double UPH { get; set; }
- /// <summary>
- /// UPPH
- /// </summary>
- [DisplayName("UPPH")]
- public double UPPH { get; set; }
- /// <summary>
- /// 鏈�鍚庣殑宸ュ崟鍘嗗彶ID
- /// </summary>
- [DisplayName("鏈�鍚庣殑宸ュ崟鍘嗗彶ID")]
- public string LAST_HIST_ID { get; set; }
- /// <summary>
- /// 澶囨敞
- /// </summary>
- [DisplayName("澶囨敞")]
- public string REMARK { get; set; }
- /// <summary>
- /// 鎺ュ彛琛ㄨ褰旾D
- /// </summary>
- [DisplayName("鎺ュ彛琛ㄨ褰旾D")]
- public string FBILLNO_ID { get; set; }
- /// <summary>
- /// 澶囨枡鍗曡繑鍥炰俊鎭�
- /// </summary>
- [DisplayName("澶囨枡鍗曡繑鍥炰俊鎭�")]
- public string PREP_MSG { get; set; }
- #endregion
+ #region 公共属性
+ /// <summary>
+ /// 工单号
+ /// </summary>
+ [DisplayName("工单号")]
+ public string ORDER_NO { get; set; }
+ /// <summary>
+ /// 工单类型(0Plan计划|1Standard标准|2Rework返工|3Restructuring在库改制|5委外Outsourcing|6RD研发|7Forecast预测|8Disassemble拆卸)
+ /// </summary>
+ [DisplayName("工单类型(0Plan计划|1Standard标准|2Rework返工|3Restructuring在库改制|5委外Outsourcing|6RD研发|7Forecast预测|8Disassemble拆卸)")]
+ public int ORDER_TYPE { get; set; }
+ /// <summary>
+ /// 工单描述
+ /// </summary>
+ [DisplayName("工单描述")]
+ public string ORDER_DESC { get; set; }
+ /// <summary>
+ /// 父工单
+ /// </summary>
+ [DisplayName("父工单")]
+ public string PARENT_ORDER { get; set; }
+ /// <summary>
+ /// 状态(0Init初始化|1Imported已导入|2Release已下发|3Working生产中|4Paused已暂停|5Closed已关闭)
+ /// </summary>
+ [DisplayName("状态(0Init初始化|1Imported已导入|2Release已下发|3Working生产中|4Paused已暂停|5Closed已关闭)")]
+ public int STATUS { get; set; }
+ /// <summary>
+ /// 物料编码
+ /// </summary>
+ [DisplayName("物料编码")]
+ public string ITEM_CODE { get; set; }
+ /// <summary>
+ /// 物料类型
+ /// </summary>
+ [DisplayName("物料类型")]
+ public string ITEM_TYPE { get; set; }
+ /// <summary>
+ /// 机型
+ /// </summary>
+ [DisplayName("机型")]
+ public string ITEM_MODEL { get; set; }
+ /// <summary>
+ /// 优先级
+ /// </summary>
+ [DisplayName("优先级")]
+ public string PRIORITY { get; set; }
+ /// <summary>
+ /// 客户编码
+ /// </summary>
+ [DisplayName("客户编码")]
+ public string CUST_CODE { get; set; }
+ /// <summary>
+ /// 路由编码
+ /// </summary>
+ [DisplayName("路由编码")]
+ public string ROUTE_CODE { get; set; }
+ /// <summary>
+ /// 工艺状态(0WaitSet待配置|1Finish已配置|2Cancel取消|3Close关闭)
+ /// </summary>
+ [DisplayName("工艺状态(0WaitSet待配置|1Finish已配置|2Cancel取消|3Close关闭)")]
+ public int ROUTE_STATUS { get; set; }
+ /// <summary>
+ /// 工厂
+ /// </summary>
+ [DisplayName("工厂")]
+ public string FACTORY { get; set; }
+ /// <summary>
+ /// 车间编码
+ /// </summary>
+ [DisplayName("车间编码")]
+ public string WS_CODE { get; set; }
+ /// <summary>
+ /// 计划线体
+ /// </summary>
+ [DisplayName("计划线体")]
+ public string PLAN_LINE { get; set; }
+ /// <summary>
+ /// 实际线体
+ /// </summary>
+ [DisplayName("实际线体")]
+ public string ACT_LINE { get; set; }
+ /// <summary>
+ /// 计划开始时间
+ /// </summary>
+ [DisplayName("计划开始时间")]
+ public DateTime PLAN_START_TIME { get; set; } = DateTime.MinValue;
+ /// <summary>
+ /// 计划结束时间
+ /// </summary>
+ [DisplayName("计划结束时间")]
+ public DateTime PLAN_END_TIME { get; set; } = DateTime.MinValue;
+ /// <summary>
+ /// 实际开始时间
+ /// </summary>
+ [DisplayName("实际开始时间")]
+ public DateTime ACT_START_TIME { get; set; } = DateTime.MinValue;
+ /// <summary>
+ /// 实际结束时间
+ /// </summary>
+ [DisplayName("实际结束时间")]
+ public DateTime ACT_END_TIME { get; set; } = DateTime.MinValue;
+ /// <summary>
+ /// 标准作业人数
+ /// </summary>
+ [DisplayName("标准作业人数")]
+ public int STD_WORKER_QTY { get; set; }
+ /// <summary>
+ /// 实际作业人数
+ /// </summary>
+ [DisplayName("实际作业人数")]
+ public int ACT_WORKER_QTY { get; set; }
+ /// <summary>
+ /// 导入时间
+ /// </summary>
+ [DisplayName("导入时间")]
+ public DateTime IMPORT_TIME { get; set; } = DateTime.MinValue;
+ /// <summary>
+ /// 下发时间
+ /// </summary>
+ [DisplayName("下发时间")]
+ public DateTime RELEASE_TIME { get; set; } = DateTime.MinValue;
+ /// <summary>
+ /// 下发人
+ /// </summary>
+ [DisplayName("下发人")]
+ public string RELEASE_USER { get; set; }
+ /// <summary>
+ /// 变更时间
+ /// </summary>
+ [DisplayName("变更时间")]
+ public DateTime CHANGE_TIME { get; set; } = DateTime.MinValue;
+ /// <summary>
+ /// 变更人
+ /// </summary>
+ [DisplayName("变更人")]
+ public string CHANGE_USER { get; set; }
+ /// <summary>
+ /// 计划数量
+ /// </summary>
+ [DisplayName("计划数量")]
+ public int PLAN_QTY { get; set; }
+ /// <summary>
+ /// 投入数量
+ /// </summary>
+ [DisplayName("投入数量")]
+ public int INPUT_QTY { get; set; }
+ /// <summary>
+ /// 完工数量
+ /// </summary>
+ [DisplayName("完工数量")]
+ public int OUTPUT_QTY { get; set; }
+ /// <summary>
+ /// 报废数量
+ /// </summary>
+ [DisplayName("报废数量")]
+ public int SCRAP_QTY { get; set; }
+ /// <summary>
+ /// 入库数量
+ /// </summary>
+ [DisplayName("入库数量")]
+ public int STOCK_IN_QTY { get; set; }
+ /// <summary>
+ /// UPH
+ /// </summary>
+ [DisplayName("UPH")]
+ public double UPH { get; set; }
+ /// <summary>
+ /// UPPH
+ /// </summary>
+ [DisplayName("UPPH")]
+ public double UPPH { get; set; }
+ /// <summary>
+ /// 最后的工单历史ID
+ /// </summary>
+ [DisplayName("最后的工单历史ID")]
+ public string LAST_HIST_ID { get; set; }
+ /// <summary>
+ /// 备注
+ /// </summary>
+ [DisplayName("备注")]
+ public string REMARK { get; set; }
+ /// <summary>
+ /// 接口表记录ID
+ /// </summary>
+ [DisplayName("接口表记录ID")]
+ public string FBILLNO_ID { get; set; }
+ /// <summary>
+ /// 备料单返回信息
+ /// </summary>
+ [DisplayName("备料单返回信息")]
+ public string PREP_MSG { get; set; }
+ #endregion
- #region 铏氭嫙灞炴��
- /*渚嬪瓙
+ #region 虚拟属性
+ /*例子
[SugarColumn(IsIgnore = true)]
public string FieldName { get; set; }
*/
- #endregion
+ #endregion
- #region 澶栭敭灞炴��
- /*渚嬪瓙
- //涓�瀵逛竴澶栭敭瀵艰埅
- [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//涓�瀵逛竴 ClassAId鏄疊IZ_MES_WO绫婚噷闈㈢殑澶栭敭ID瀛楁
- public ClassA ClassA { get; set; } //娉ㄦ剰绂佹鎵嬪姩璧嬪�硷紝鍙兘鏄痭ull
- //涓�瀵瑰澶栭敭瀵艰埅
- [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_MES_WOId))]//ClassA琛ㄤ腑鐨凚IZ_MES_WOId
- public List<ClassA> ClassAList { get; set; }//娉ㄦ剰绂佹鎵嬪姩璧嬪�硷紝鍙兘鏄痭ull
- //澶氬澶氬閿鑸�
- [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_MES_WOId), nameof(MappingClass.ClassAId))]//娉ㄦ剰椤哄簭
- public List<ClassA> ClassAList { get; set; } //娉ㄦ剰绂佹鎵嬪姩璧嬪�硷紝鍙兘鏄痭ull
+ #region 外键属性
+ /*例子
+ //一对一外键导航
+ [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_MES_WO类里面的外键ID字段
+ public ClassA ClassA { get; set; } //注意禁止手动赋值，只能是null
+ //一对多外键导航
+ [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_MES_WOId))]//ClassA表中的BIZ_MES_WOId
+ public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
+ //多对多外键导航
+ [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_MES_WOId), nameof(MappingClass.ClassAId))]//注意顺序
+ public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值，只能是null
*/
- #endregion
+ #endregion
- #region 鏋氫妇鍙橀噺
- /*渚嬪瓙
+ #region 枚举变量
+ /*例子
public enum FieldNames
{
- [Description("鏋氫妇鎻忚堪0")]
+ [Description("枚举描述0")]
Enum0,
- [Description("鏋氫妇鎻忚堪1")]
+ [Description("枚举描述1")]
Enum1,
}
*/
- public enum STATUSs
- {
- [Description("鍒濆鍖�")]
- Init,
- [Description("宸插鍏�")]
- Imported,
- [Description("宸蹭笅鍙�")]
- Release,
- [Description("鐢熶骇涓�")]
- Working,
- [Description("宸叉殏鍋�")]
- Paused,
- [Description("宸插叧闂�")]
- Closed,
- }
- /// <summary>
- /// 鏋氫妇锛氬伐鑹虹姸鎬�(0WaitSet寰呴厤缃畖1Finish宸查厤缃畖2Cancel鍙栨秷|3Close鍏抽棴)
- /// </summary>
- public enum ROUTE_STATUSs
- {
- [Description("寰呴厤缃�")]
- WaitSet,
- [Description("宸查厤缃�")]
- Finish,
- [Description("鍙栨秷")]
- Cancel,
- [Description("宸插叧闂�")]
- Closed,
- }
+ /// <summary>
+ /// 枚举：工单类型(0Plan计划|1Standard标准|2Rework返工|3Restructuring在库改制|5委外Outsourcing|6RD研发|7Forecast预测|8Disassemble拆卸)
+ /// </summary>
+ public enum ORDER_TYPEs
+ {
+ [Description("计划")]
+ Plan = 0,
+ [Description("标准")]
+ Standard = 1,
+ [Description("返工")]
+ Rework = 2,
+ [Description("在库改制")]
+ Restructuring = 3,
+ [Description("Outsourcing")]
+ Outsourcing = 5委外,
+ [Description("研发")]
+ RD = 6,
+ [Description("预测")]
+ Forecast = 7,
+ [Description("拆卸")]
+ Disassemble = 8,
+ }
- /// <summary>
- /// 宸ュ崟绫诲瀷鏋氫妇
- /// </summary>
- public enum ORDER_TYPEs {
- [Description("璁″垝")]
- Plan=0,
- [Description("鏍囧噯")]
- Standard=1,
- [Description("杩斿伐")]
- Rework=2,
- [Description("鍦ㄥ簱鏀瑰埗")]
- Restructuring=3,
- [Description("濮斿")]
- Outsourcing = 5,
- [Description("鐮斿彂")]
- RD = 6,
- [Description("棰勬祴")]
- Forecast = 7,
- [Description("鎷嗗嵏")]
- Disassemble = 8,
- }
- #endregion
+ /// <summary>
+ /// 枚举：状态(0Init初始化|1Imported已导入|2Release已下发|3Working生产中|4Paused已暂停|5Closed已关闭)
+ /// </summary>
+ public enum STATUSs
+ {
+ [Description("初始化")]
+ Init = 0,
+ [Description("已导入")]
+ Imported = 1,
+ [Description("已下发")]
+ Release = 2,
+ [Description("生产中")]
+ Working = 3,
+ [Description("已暂停")]
+ Paused = 4,
+ [Description("已关闭")]
+ Closed = 5,
+ }
- #region 鍏叡鏂规硶
+ /// <summary>
+ /// 枚举：工艺状态(0WaitSet待配置|1Finish已配置|2Cancel取消|3Close关闭)
+ /// </summary>
+ public enum ROUTE_STATUSs
+ {
+ [Description("待配置")]
+ WaitSet = 0,
+ [Description("已配置")]
+ Finish = 1,
+ [Description("取消")]
+ Cancel = 2,
+ [Description("关闭")]
+ Close = 3,
+ }
+ #endregion
- #endregion
+ #region 公共方法
- }//endClass
+ #endregion
+
+ }//endClass
}
\ No newline at end of file
--
Gitblit v1.9.3