From 3230906575bd87fcdda63565bf2ec849c597336f Mon Sep 17 00:00:00 2001 From: Rodney Chen <rodney.chen@hotmail.com> Date: 星期日, 23 二月 2025 23:07:05 +0800 Subject: [PATCH] 增加实体 --- Tiger.Model.Net/Entitys/MES/MES_TOOL_HIS.cs | 126 ++++++ Tiger.Model.Net/Entitys/EMS/EMS_FAULT.cs | 112 ++-- Tiger.Model.Net/Entitys/MES/MES_CLEAR_DTL.cs | 153 +++++++ Tiger.Model.Net/Entitys/MES/MES_TOOL.cs | 168 ++++++++ Tiger.Model.Net/Entitys/MES/MES_TOOL_PROP_HIS.cs | 161 ++++++++ Tiger.Model.Net/Entitys/EMS/EMS_REPAIR.cs | 108 ++-- Tiger.Model.Net/Entitys/MES/MES_TOOL_PROP.cs | 136 ++++++ Tiger.Model.Net/Entitys/MES/MES_CLEAR_REC.cs | 211 ++++++++++ 8 files changed, 1,065 insertions(+), 110 deletions(-) diff --git a/Tiger.Model.Net/Entitys/EMS/EMS_FAULT.cs b/Tiger.Model.Net/Entitys/EMS/EMS_FAULT.cs index d2bceb0..66df040 100644 --- a/Tiger.Model.Net/Entitys/EMS/EMS_FAULT.cs +++ b/Tiger.Model.Net/Entitys/EMS/EMS_FAULT.cs @@ -7,138 +7,138 @@ namespace Tiger.Model { /// <summary> - /// 实体:设备故障登记 + /// 瀹炰綋锛氳澶囨晠闅滅櫥璁� /// </summary> [Description("Primary:ID")] - [DisplayName("设备故障登记")] + [DisplayName("璁惧鏁呴殰鐧昏")] [Serializable] [SugarTable("EMS_FAULT")] public class EMS_FAULT : DbEntityWithAuth { - #region 构造函数 + #region 鏋勯�犲嚱鏁� /// <summary> - /// 实体:设备故障登记 + /// 瀹炰綋锛氳澶囨晠闅滅櫥璁� /// </summary> public EMS_FAULT() {} #endregion - #region 公共属性 + #region 鍏叡灞炴�� /// <summary> - /// 设备故障编码 + /// 璁惧鏁呴殰缂栫爜 /// </summary> - [DisplayName("设备故障编码")] + [DisplayName("璁惧鏁呴殰缂栫爜")] public string FAULT_NO { get; set; } /// <summary> - /// 设备编码 + /// 璁惧缂栫爜 /// </summary> - [DisplayName("设备编码")] + [DisplayName("璁惧缂栫爜")] public string EQM_CODE { get; set; } /// <summary> - /// 状态(0BeFound被发现|1WaitHandle待处理|2Repairing维修中|2Resolved已处理) + /// 鐘舵��(0BeFound琚彂鐜皘1WaitHandle寰呭鐞唡2Repairing缁翠慨涓瓅2Resolved宸插鐞�) /// </summary> - [DisplayName("状态(0BeFound被发现|1WaitHandle待处理|2Repairing维修中|2Resolved已处理)")] + [DisplayName("鐘舵��(0BeFound琚彂鐜皘1WaitHandle寰呭鐞唡2Repairing缁翠慨涓瓅2Resolved宸插鐞�)")] public int STATUS { get; set; } /// <summary> - /// 发生时间 + /// 鍙戠敓鏃堕棿 /// </summary> - [DisplayName("发生时间")] + [DisplayName("鍙戠敓鏃堕棿")] public DateTime OCCUR_TIME { get; set; } = DateTime.MinValue; /// <summary> - /// 发现人 + /// 鍙戠幇浜� /// </summary> - [DisplayName("发现人")] - public DateTime OCCUR_USER { get; set; } = DateTime.MinValue; + [DisplayName("鍙戠幇浜�")] + public string OCCUR_USER { get; set; } /// <summary> - /// 故障现象 + /// 鏁呴殰鐜拌薄 /// </summary> - [DisplayName("故障现象")] + [DisplayName("鏁呴殰鐜拌薄")] public string PROBLEM { get; set; } /// <summary> - /// 故障原因 + /// 鏁呴殰鍘熷洜 /// </summary> - [DisplayName("故障原因")] + [DisplayName("鏁呴殰鍘熷洜")] public string REASON { get; set; } /// <summary> - /// 异常工时 + /// 寮傚父宸ユ椂 /// </summary> - [DisplayName("异常工时")] + [DisplayName("寮傚父宸ユ椂")] public double OFF_HOURS { get; set; } /// <summary> - /// 是否需要维修 + /// 鏄惁闇�瑕佺淮淇� /// </summary> - [DisplayName("是否需要维修")] + [DisplayName("鏄惁闇�瑕佺淮淇�")] public string NEED_REPAIR { get; set; } /// <summary> - /// 处理人 + /// 澶勭悊浜� /// </summary> - [DisplayName("处理人")] - public DateTime HANDLE_USER { get; set; } = DateTime.MinValue; + [DisplayName("澶勭悊浜�")] + public string HANDLE_USER { get; set; } /// <summary> - /// 处理措施 + /// 澶勭悊鎺柦 /// </summary> - [DisplayName("处理措施")] + [DisplayName("澶勭悊鎺柦")] public string MEASURE { get; set; } /// <summary> - /// 处理结果 + /// 澶勭悊缁撴灉 /// </summary> - [DisplayName("处理结果")] + [DisplayName("澶勭悊缁撴灉")] public string RESULT { get; set; } /// <summary> - /// 备注 + /// 澶囨敞 /// </summary> - [DisplayName("备注")] + [DisplayName("澶囨敞")] public string REMARK { get; set; } #endregion - #region 虚拟属性 - /*例子 + #region 铏氭嫙灞炴�� + /*渚嬪瓙 [SugarColumn(IsIgnore = true)] public string FieldName { get; set; } */ #endregion - #region 外键属性 - /*例子 - //一对一外键导航 - [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是EMS_FAULT类里面的外键ID字段 - public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null - //一对多外键导航 - [Navigate(NavigateType.OneToMany, nameof(ClassA.EMS_FAULTId))]//ClassA表中的EMS_FAULTId - public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值,只能是null - //多对多外键导航 - [Navigate(typeof(MappingClass), nameof(MappingClass.EMS_FAULTId), nameof(MappingClass.ClassAId))]//注意顺序 - public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null + #region 澶栭敭灞炴�� + /*渚嬪瓙 + //涓�瀵逛竴澶栭敭瀵艰埅 + [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//涓�瀵逛竴 ClassAId鏄疎MS_FAULT绫婚噷闈㈢殑澶栭敭ID瀛楁 + public ClassA ClassA { get; set; } //娉ㄦ剰绂佹鎵嬪姩璧嬪�硷紝鍙兘鏄痭ull + //涓�瀵瑰澶栭敭瀵艰埅 + [Navigate(NavigateType.OneToMany, nameof(ClassA.EMS_FAULTId))]//ClassA琛ㄤ腑鐨凟MS_FAULTId + public List<ClassA> ClassAList { get; set; }//娉ㄦ剰绂佹鎵嬪姩璧嬪�硷紝鍙兘鏄痭ull + //澶氬澶氬閿鑸� + [Navigate(typeof(MappingClass), nameof(MappingClass.EMS_FAULTId), nameof(MappingClass.ClassAId))]//娉ㄦ剰椤哄簭 + public List<ClassA> ClassAList { get; set; } //娉ㄦ剰绂佹鎵嬪姩璧嬪�硷紝鍙兘鏄痭ull */ #endregion - #region 枚举变量 - /*例子 + #region 鏋氫妇鍙橀噺 + /*渚嬪瓙 public enum FieldNames { - [Description("枚举描述0")] + [Description("鏋氫妇鎻忚堪0")] Enum0, - [Description("枚举描述1")] + [Description("鏋氫妇鎻忚堪1")] Enum1, } */ /// <summary> - /// 枚举:状态(0BeFound被发现|1WaitHandle待处理|2Repairing维修中|2Resolved已处理) + /// 鏋氫妇锛氱姸鎬�(0BeFound琚彂鐜皘1WaitHandle寰呭鐞唡2Repairing缁翠慨涓瓅2Resolved宸插鐞�) /// </summary> public enum STATUSs { - [Description("被发现")] + [Description("琚彂鐜�")] BeFound = 0, - [Description("待处理")] + [Description("寰呭鐞�")] WaitHandle = 1, - [Description("维修中")] + [Description("缁翠慨涓�")] Repairing = 2, - [Description("已处理")] + [Description("宸插鐞�")] Resolved = 2, } #endregion - #region 公共方法 + #region 鍏叡鏂规硶 #endregion diff --git a/Tiger.Model.Net/Entitys/EMS/EMS_REPAIR.cs b/Tiger.Model.Net/Entitys/EMS/EMS_REPAIR.cs index ea8785c..b5d61cf 100644 --- a/Tiger.Model.Net/Entitys/EMS/EMS_REPAIR.cs +++ b/Tiger.Model.Net/Entitys/EMS/EMS_REPAIR.cs @@ -7,136 +7,136 @@ namespace Tiger.Model { /// <summary> - /// 实体:设备维修记录 + /// 瀹炰綋锛氳澶囩淮淇褰� /// </summary> [Description("Primary:ID")] - [DisplayName("设备维修记录")] + [DisplayName("璁惧缁翠慨璁板綍")] [Serializable] [SugarTable("EMS_REPAIR")] public class EMS_REPAIR : DbEntityWithAuth { - #region 构造函数 + #region 鏋勯�犲嚱鏁� /// <summary> - /// 实体:设备维修记录 + /// 瀹炰綋锛氳澶囩淮淇褰� /// </summary> public EMS_REPAIR() {} #endregion - #region 公共属性 + #region 鍏叡灞炴�� /// <summary> - /// 设备维修编码 + /// 璁惧缁翠慨缂栫爜 /// </summary> - [DisplayName("设备维修编码")] + [DisplayName("璁惧缁翠慨缂栫爜")] public string REPAIR_NO { get; set; } /// <summary> - /// 设备编码 + /// 璁惧缂栫爜 /// </summary> - [DisplayName("设备编码")] + [DisplayName("璁惧缂栫爜")] public string EQM_CODE { get; set; } /// <summary> - /// 状态(0Waiting待维修|1Repairing维修中|2Repaired维修完) + /// 鐘舵��(0Waiting寰呯淮淇畖1Repairing缁翠慨涓瓅2Repaired缁翠慨瀹�) /// </summary> - [DisplayName("状态(0Waiting待维修|1Repairing维修中|2Repaired维修完)")] + [DisplayName("鐘舵��(0Waiting寰呯淮淇畖1Repairing缁翠慨涓瓅2Repaired缁翠慨瀹�)")] public int STATUS { get; set; } /// <summary> - /// 故障原因 + /// 鏁呴殰鍘熷洜 /// </summary> - [DisplayName("故障原因")] + [DisplayName("鏁呴殰鍘熷洜")] public string REASON { get; set; } /// <summary> - /// 维修人 + /// 缁翠慨浜� /// </summary> - [DisplayName("维修人")] - public DateTime REPAIR_USER { get; set; } = DateTime.MinValue; + [DisplayName("缁翠慨浜�")] + public string REPAIR_USER { get; set; } /// <summary> - /// 维修开始时间 + /// 缁翠慨寮�濮嬫椂闂� /// </summary> - [DisplayName("维修开始时间")] + [DisplayName("缁翠慨寮�濮嬫椂闂�")] public DateTime BEGIN_TIME { get; set; } = DateTime.MinValue; /// <summary> - /// 维修结束时间 + /// 缁翠慨缁撴潫鏃堕棿 /// </summary> - [DisplayName("维修结束时间")] + [DisplayName("缁翠慨缁撴潫鏃堕棿")] public DateTime END_TIME { get; set; } = DateTime.MinValue; /// <summary> - /// 维修详情 + /// 缁翠慨璇︽儏 /// </summary> - [DisplayName("维修详情")] + [DisplayName("缁翠慨璇︽儏")] public string DETAILS { get; set; } /// <summary> - /// 维修费用 + /// 缁翠慨璐圭敤 /// </summary> - [DisplayName("维修费用")] + [DisplayName("缁翠慨璐圭敤")] public double COSTS { get; set; } /// <summary> - /// 异常工时 + /// 寮傚父宸ユ椂 /// </summary> - [DisplayName("异常工时")] + [DisplayName("寮傚父宸ユ椂")] public double HOURS { get; set; } /// <summary> - /// 处理措施 + /// 澶勭悊鎺柦 /// </summary> - [DisplayName("处理措施")] + [DisplayName("澶勭悊鎺柦")] public string MEASURE { get; set; } /// <summary> - /// 处理结果 + /// 澶勭悊缁撴灉 /// </summary> - [DisplayName("处理结果")] + [DisplayName("澶勭悊缁撴灉")] public string RESULT { get; set; } /// <summary> - /// 备注 + /// 澶囨敞 /// </summary> - [DisplayName("备注")] + [DisplayName("澶囨敞")] public string REMARK { get; set; } #endregion - #region 虚拟属性 - /*例子 + #region 铏氭嫙灞炴�� + /*渚嬪瓙 [SugarColumn(IsIgnore = true)] public string FieldName { get; set; } */ #endregion - #region 外键属性 - /*例子 - //一对一外键导航 - [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是EMS_REPAIR类里面的外键ID字段 - public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null - //一对多外键导航 - [Navigate(NavigateType.OneToMany, nameof(ClassA.EMS_REPAIRId))]//ClassA表中的EMS_REPAIRId - public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值,只能是null - //多对多外键导航 - [Navigate(typeof(MappingClass), nameof(MappingClass.EMS_REPAIRId), nameof(MappingClass.ClassAId))]//注意顺序 - public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null + #region 澶栭敭灞炴�� + /*渚嬪瓙 + //涓�瀵逛竴澶栭敭瀵艰埅 + [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//涓�瀵逛竴 ClassAId鏄疎MS_REPAIR绫婚噷闈㈢殑澶栭敭ID瀛楁 + public ClassA ClassA { get; set; } //娉ㄦ剰绂佹鎵嬪姩璧嬪�硷紝鍙兘鏄痭ull + //涓�瀵瑰澶栭敭瀵艰埅 + [Navigate(NavigateType.OneToMany, nameof(ClassA.EMS_REPAIRId))]//ClassA琛ㄤ腑鐨凟MS_REPAIRId + public List<ClassA> ClassAList { get; set; }//娉ㄦ剰绂佹鎵嬪姩璧嬪�硷紝鍙兘鏄痭ull + //澶氬澶氬閿鑸� + [Navigate(typeof(MappingClass), nameof(MappingClass.EMS_REPAIRId), nameof(MappingClass.ClassAId))]//娉ㄦ剰椤哄簭 + public List<ClassA> ClassAList { get; set; } //娉ㄦ剰绂佹鎵嬪姩璧嬪�硷紝鍙兘鏄痭ull */ #endregion - #region 枚举变量 - /*例子 + #region 鏋氫妇鍙橀噺 + /*渚嬪瓙 public enum FieldNames { - [Description("枚举描述0")] + [Description("鏋氫妇鎻忚堪0")] Enum0, - [Description("枚举描述1")] + [Description("鏋氫妇鎻忚堪1")] Enum1, } */ /// <summary> - /// 枚举:状态(0Waiting待维修|1Repairing维修中|2Repaired维修完) + /// 鏋氫妇锛氱姸鎬�(0Waiting寰呯淮淇畖1Repairing缁翠慨涓瓅2Repaired缁翠慨瀹�) /// </summary> public enum STATUSs { - [Description("待维修")] + [Description("寰呯淮淇�")] Waiting = 0, - [Description("维修中")] + [Description("缁翠慨涓�")] Repairing = 1, - [Description("维修完")] + [Description("缁翠慨瀹�")] Repaired = 2, } #endregion - #region 公共方法 + #region 鍏叡鏂规硶 #endregion diff --git a/Tiger.Model.Net/Entitys/MES/MES_CLEAR_DTL.cs b/Tiger.Model.Net/Entitys/MES/MES_CLEAR_DTL.cs new file mode 100644 index 0000000..79c1e2a --- /dev/null +++ b/Tiger.Model.Net/Entitys/MES/MES_CLEAR_DTL.cs @@ -0,0 +1,153 @@ +using System; +using SqlSugar; +using System.Linq; +using System.ComponentModel; +using System.Collections.Generic; + +namespace Tiger.Model +{ + /// <summary> + /// 实体:生产清场记录明细 + /// </summary> + [Description("Primary:ID")] + [DisplayName("生产清场记录明细")] + [Serializable] + [SugarTable("MES_CLEAR_DTL")] + public class MES_CLEAR_DTL : DbEntityWithAuth + { + #region 构造函数 + /// <summary> + /// 实体:生产清场记录明细 + /// </summary> + public MES_CLEAR_DTL() {} + #endregion + + #region 公共属性 + /// <summary> + /// 记录单号 + /// </summary> + [DisplayName("记录单号")] + public string REC_ORDER { get; set; } + /// <summary> + /// 工单号 + /// </summary> + [DisplayName("工单号")] + public string WORK_ORDER { get; set; } + /// <summary> + /// 对象编码 + /// </summary> + [DisplayName("对象编码")] + public string OBJ_CODE { get; set; } + /// <summary> + /// 对象名称 + /// </summary> + [DisplayName("对象名称")] + public string OBJ_NAME { get; set; } + /// <summary> + /// 对象类型(0清洁剂|1消毒剂|2文件|3环境|4清洁工具|5物料) + /// </summary> + [DisplayName("对象类型(0清洁剂|1消毒剂|2文件|3环境|4清洁工具|5物料)")] + public int OBJ_TYPE { get; set; } + /// <summary> + /// 对象值 + /// </summary> + [DisplayName("对象值")] + public string VALUE { get; set; } + /// <summary> + /// 0:未完成/不通过/次品,1:已完成/通过/合格品 + /// </summary> + [DisplayName("0:未完成/不通过/次品,1:已完成/通过/合格品")] + public int RESULT { get; set; } + /// <summary> + /// 物料编码 + /// </summary> + [DisplayName("物料编码")] + public string ITEM_CODE { get; set; } + /// <summary> + /// 数量 + /// </summary> + [DisplayName("数量")] + public int QTY { get; set; } + /// <summary> + /// 单据号码 + /// </summary> + [DisplayName("单据号码")] + public string ORDER { get; set; } + /// <summary> + /// 设置值1 + /// </summary> + [DisplayName("设置值1")] + public string OPTION_1 { get; set; } + /// <summary> + /// 设置值2 + /// </summary> + [DisplayName("设置值2")] + public string OPTION_2 { get; set; } + /// <summary> + /// 设置值3 + /// </summary> + [DisplayName("设置值3")] + public string OPTION_3 { get; set; } + /// <summary> + /// 设置值4 + /// </summary> + [DisplayName("设置值4")] + public string OPTION_4 { get; set; } + /// <summary> + /// 设置值5 + /// </summary> + [DisplayName("设置值5")] + public string OPTION_5 { get; set; } + /// <summary> + /// 备注 + /// </summary> + [DisplayName("备注")] + public string REMARK { get; set; } + #endregion + + #region 虚拟属性 + /*例子 + [SugarColumn(IsIgnore = true)] + public string FieldName { get; set; } + */ + #endregion + + #region 外键属性 + /*例子 + //一对一外键导航 + [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是MES_CLEAR_DTL类里面的外键ID字段 + public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null + //一对多外键导航 + [Navigate(NavigateType.OneToMany, nameof(ClassA.MES_CLEAR_DTLId))]//ClassA表中的MES_CLEAR_DTLId + public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值,只能是null + //多对多外键导航 + [Navigate(typeof(MappingClass), nameof(MappingClass.MES_CLEAR_DTLId), nameof(MappingClass.ClassAId))]//注意顺序 + public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null + */ + #endregion + + #region 枚举变量 + /*例子 + public enum FieldNames + { + [Description("枚举描述0")] + Enum0, + [Description("枚举描述1")] + Enum1, + } + */ + + /// <summary> + /// 枚举:对象类型(0清洁剂|1消毒剂|2文件|3环境|4清洁工具|5物料) + /// </summary> + public enum OBJ_TYPEs + { + } + #endregion + + #region 公共方法 + + #endregion + + }//endClass +} \ No newline at end of file diff --git a/Tiger.Model.Net/Entitys/MES/MES_CLEAR_REC.cs b/Tiger.Model.Net/Entitys/MES/MES_CLEAR_REC.cs new file mode 100644 index 0000000..8b2d020 --- /dev/null +++ b/Tiger.Model.Net/Entitys/MES/MES_CLEAR_REC.cs @@ -0,0 +1,211 @@ +using System; +using SqlSugar; +using System.Linq; +using System.ComponentModel; +using System.Collections.Generic; + +namespace Tiger.Model +{ + /// <summary> + /// 实体:生产清场记录 + /// </summary> + [Description("Primary:ID")] + [DisplayName("生产清场记录")] + [Serializable] + [SugarTable("MES_CLEAR_REC")] + public class MES_CLEAR_REC : DbEntityWithAuth + { + #region 构造函数 + /// <summary> + /// 实体:生产清场记录 + /// </summary> + public MES_CLEAR_REC() {} + #endregion + + #region 公共属性 + /// <summary> + /// 记录单号 + /// </summary> + [DisplayName("记录单号")] + public string REC_ORDER { get; set; } + /// <summary> + /// 工单号 + /// </summary> + [DisplayName("工单号")] + public string WORK_ORDER { get; set; } + /// <summary> + /// 工单批次号 + /// </summary> + [DisplayName("工单批次号")] + public string BATCH_NO { get; set; } + /// <summary> + /// 物料编码 + /// </summary> + [DisplayName("物料编码")] + public string ITEM_CODE { get; set; } + /// <summary> + /// 物料名称 + /// </summary> + [DisplayName("物料名称")] + public string ITEM_NAME { get; set; } + /// <summary> + /// 物料规格 + /// </summary> + [DisplayName("物料规格")] + public string ITEM_SPEC { get; set; } + /// <summary> + /// 生产时间开始 + /// </summary> + [DisplayName("生产时间开始")] + public DateTime PROD_FROM { get; set; } = DateTime.MinValue; + /// <summary> + /// 生产时间结束 + /// </summary> + [DisplayName("生产时间结束")] + public DateTime PROD_TO { get; set; } = DateTime.MinValue; + /// <summary> + /// 工厂编码 + /// </summary> + [DisplayName("工厂编码")] + public string FTY_CODE { get; set; } + /// <summary> + /// 工厂名称 + /// </summary> + [DisplayName("工厂名称")] + public string FTY_NAME { get; set; } + /// <summary> + /// 车间编码 + /// </summary> + [DisplayName("车间编码")] + public string WS_CODE { get; set; } + /// <summary> + /// 车间名称 + /// </summary> + [DisplayName("车间名称")] + public string WS_NAME { get; set; } + /// <summary> + /// 产线编码 + /// </summary> + [DisplayName("产线编码")] + public string LINE_CODE { get; set; } + /// <summary> + /// 产线名称 + /// </summary> + [DisplayName("产线名称")] + public string LINE_NAME { get; set; } + /// <summary> + /// 岗位编码 + /// </summary> + [DisplayName("岗位编码")] + public string POST_CODE { get; set; } + /// <summary> + /// 岗位名称 + /// </summary> + [DisplayName("岗位名称")] + public string POST_NAME { get; set; } + /// <summary> + /// 清场种类(0AfterProduce每个生产阶段结束后|1ChangeBatch更换产品批号|2ChangeCategory更换产品种类|3Others其他) + /// </summary> + [DisplayName("清场种类(0AfterProduce每个生产阶段结束后|1ChangeBatch更换产品批号|2ChangeCategory更换产品种类|3Others其他)")] + public int CLEAR_TYPE { get; set; } + /// <summary> + /// 记录人 + /// </summary> + [DisplayName("记录人")] + public string REC_USER { get; set; } + /// <summary> + /// 记录时间 + /// </summary> + [DisplayName("记录时间")] + public DateTime REC_TIME { get; set; } = DateTime.MinValue; + /// <summary> + /// 记录人 + /// </summary> + [DisplayName("记录人")] + public string CHECK_USER { get; set; } + /// <summary> + /// 记录时间 + /// </summary> + [DisplayName("记录时间")] + public DateTime CHECK_TIME { get; set; } = DateTime.MinValue; + /// <summary> + /// 0:不通过,1:通过 + /// </summary> + [DisplayName("0:不通过,1:通过")] + public int CHECK_RESULT { get; set; } + /// <summary> + /// 记录人 + /// </summary> + [DisplayName("记录人")] + public string QC_USER { get; set; } + /// <summary> + /// 记录时间 + /// </summary> + [DisplayName("记录时间")] + public DateTime QC_TIME { get; set; } = DateTime.MinValue; + /// <summary> + /// 0:不通过,1:通过 + /// </summary> + [DisplayName("0:不通过,1:通过")] + public int QC_RESULT { get; set; } + /// <summary> + /// 备注 + /// </summary> + [DisplayName("备注")] + public string REMARK { get; set; } + #endregion + + #region 虚拟属性 + /*例子 + [SugarColumn(IsIgnore = true)] + public string FieldName { get; set; } + */ + #endregion + + #region 外键属性 + /*例子 + //一对一外键导航 + [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是MES_CLEAR_REC类里面的外键ID字段 + public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null + //一对多外键导航 + [Navigate(NavigateType.OneToMany, nameof(ClassA.MES_CLEAR_RECId))]//ClassA表中的MES_CLEAR_RECId + public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值,只能是null + //多对多外键导航 + [Navigate(typeof(MappingClass), nameof(MappingClass.MES_CLEAR_RECId), nameof(MappingClass.ClassAId))]//注意顺序 + public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null + */ + #endregion + + #region 枚举变量 + /*例子 + public enum FieldNames + { + [Description("枚举描述0")] + Enum0, + [Description("枚举描述1")] + Enum1, + } + */ + + /// <summary> + /// 枚举:清场种类(0AfterProduce每个生产阶段结束后|1ChangeBatch更换产品批号|2ChangeCategory更换产品种类|3Others其他) + /// </summary> + public enum CLEAR_TYPEs + { + [Description("每个生产阶段结束后")] + AfterProduce = 0, + [Description("更换产品批号")] + ChangeBatch = 1, + [Description("更换产品种类")] + ChangeCategory = 2, + [Description("其他")] + Others = 3, + } + #endregion + + #region 公共方法 + + #endregion + + }//endClass +} \ No newline at end of file diff --git a/Tiger.Model.Net/Entitys/MES/MES_TOOL.cs b/Tiger.Model.Net/Entitys/MES/MES_TOOL.cs new file mode 100644 index 0000000..0aeceb9 --- /dev/null +++ b/Tiger.Model.Net/Entitys/MES/MES_TOOL.cs @@ -0,0 +1,168 @@ +using System; +using SqlSugar; +using System.Linq; +using System.ComponentModel; +using System.Collections.Generic; + +namespace Tiger.Model +{ + /// <summary> + /// 实体:生产工具信息 + /// </summary> + [Description("Primary:ID")] + [DisplayName("生产工具信息")] + [Serializable] + [SugarTable("MES_TOOL")] + public class MES_TOOL : DbEntityWithAuth + { + #region 构造函数 + /// <summary> + /// 实体:生产工具信息 + /// </summary> + public MES_TOOL() {} + #endregion + + #region 公共属性 + /// <summary> + /// 工具编码 + /// </summary> + [DisplayName("工具编码")] + public string TOOL_CODE { get; set; } + /// <summary> + /// 工具型号 + /// </summary> + [DisplayName("工具型号")] + public string TOOL_MODEL { get; set; } + /// <summary> + /// 工具规格 + /// </summary> + [DisplayName("工具规格")] + public string TOOL_SPEC { get; set; } + /// <summary> + /// 工具类型 + /// </summary> + [DisplayName("工具类型")] + public string TOOL_TYPE { get; set; } + /// <summary> + /// 设备状态(0Idle闲置|1InUse使用|2Faulty故障|3Maintain保养维修|4Scrapped报废) + /// </summary> + [DisplayName("设备状态(0Idle闲置|1InUse使用|2Faulty故障|3Maintain保养维修|4Scrapped报废)")] + public int STATUS { get; set; } + /// <summary> + /// 生产厂家 + /// </summary> + [DisplayName("生产厂家")] + public string MFT_NAME { get; set; } + /// <summary> + /// 生产日期 + /// </summary> + [DisplayName("生产日期")] + public DateTime MFT_DATE { get; set; } = DateTime.MinValue; + /// <summary> + /// 使用部门 + /// </summary> + [DisplayName("使用部门")] + public string USE_DEPT { get; set; } + /// <summary> + /// 工厂编码 + /// </summary> + [DisplayName("工厂编码")] + public string FTY_CODE { get; set; } + /// <summary> + /// 车间编码 + /// </summary> + [DisplayName("车间编码")] + public string WS_CODE { get; set; } + /// <summary> + /// 产线编码 + /// </summary> + [DisplayName("产线编码")] + public string LINE_CODE { get; set; } + /// <summary> + /// 使用地点 + /// </summary> + [DisplayName("使用地点")] + public string LOCATION { get; set; } + /// <summary> + /// 使用次数上限 + /// </summary> + [DisplayName("使用次数上限")] + public int USE_LIMIT { get; set; } + /// <summary> + /// 保养预警次数 + /// </summary> + [DisplayName("保养预警次数")] + public int MT_ALARM_NO { get; set; } + /// <summary> + /// 报废预警次数 + /// </summary> + [DisplayName("报废预警次数")] + public int SCRAP_ALARM_NO { get; set; } + /// <summary> + /// 使用次数 + /// </summary> + [DisplayName("使用次数")] + public int USE_COUNT { get; set; } + /// <summary> + /// 备注 + /// </summary> + [DisplayName("备注")] + public string REMARK { get; set; } + #endregion + + #region 虚拟属性 + /*例子 + [SugarColumn(IsIgnore = true)] + public string FieldName { get; set; } + */ + #endregion + + #region 外键属性 + /*例子 + //一对一外键导航 + [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是MES_TOOL类里面的外键ID字段 + public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null + //一对多外键导航 + [Navigate(NavigateType.OneToMany, nameof(ClassA.MES_TOOLId))]//ClassA表中的MES_TOOLId + public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值,只能是null + //多对多外键导航 + [Navigate(typeof(MappingClass), nameof(MappingClass.MES_TOOLId), nameof(MappingClass.ClassAId))]//注意顺序 + public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null + */ + #endregion + + #region 枚举变量 + /*例子 + public enum FieldNames + { + [Description("枚举描述0")] + Enum0, + [Description("枚举描述1")] + Enum1, + } + */ + + /// <summary> + /// 枚举:设备状态(0Idle闲置|1InUse使用|2Faulty故障|3Maintain保养维修|4Scrapped报废) + /// </summary> + public enum STATUSs + { + [Description("闲置")] + Idle = 0, + [Description("使用")] + InUse = 1, + [Description("故障")] + Faulty = 2, + [Description("保养维修")] + Maintain = 3, + [Description("报废")] + Scrapped = 4, + } + #endregion + + #region 公共方法 + + #endregion + + }//endClass +} \ No newline at end of file diff --git a/Tiger.Model.Net/Entitys/MES/MES_TOOL_HIS.cs b/Tiger.Model.Net/Entitys/MES/MES_TOOL_HIS.cs new file mode 100644 index 0000000..1c88c02 --- /dev/null +++ b/Tiger.Model.Net/Entitys/MES/MES_TOOL_HIS.cs @@ -0,0 +1,126 @@ +using System; +using SqlSugar; +using System.Linq; +using System.ComponentModel; +using System.Collections.Generic; + +namespace Tiger.Model +{ + /// <summary> + /// 实体:生产工具使用历史 + /// </summary> + [Description("Primary:ID")] + [DisplayName("生产工具使用历史")] + [Serializable] + [SugarTable("MES_TOOL_HIS")] + public class MES_TOOL_HIS : DbEntityWithAuth + { + #region 构造函数 + /// <summary> + /// 实体:生产工具使用历史 + /// </summary> + public MES_TOOL_HIS() {} + #endregion + + #region 公共属性 + /// <summary> + /// 工具编码 + /// </summary> + [DisplayName("工具编码")] + public string TOOL_CODE { get; set; } + /// <summary> + /// 工单号 + /// </summary> + [DisplayName("工单号")] + public string WORK_ORDER { get; set; } + /// <summary> + /// 工单批次号 + /// </summary> + [DisplayName("工单批次号")] + public string BATCH_NO { get; set; } + /// <summary> + /// 工艺路线编码 + /// </summary> + [DisplayName("工艺路线编码")] + public string ROT_CODE { get; set; } + /// <summary> + /// 工艺路线节点ID + /// </summary> + [DisplayName("工艺路线节点ID")] + public string NODE_ID { get; set; } + /// <summary> + /// 工艺路线节点名称 + /// </summary> + [DisplayName("工艺路线节点名称")] + public string NODE_NAME { get; set; } + /// <summary> + /// 工厂编码 + /// </summary> + [DisplayName("工厂编码")] + public string FTY_CODE { get; set; } + /// <summary> + /// 车间编码 + /// </summary> + [DisplayName("车间编码")] + public string WS_CODE { get; set; } + /// <summary> + /// 产线编码 + /// </summary> + [DisplayName("产线编码")] + public string LINE_CODE { get; set; } + /// <summary> + /// 岗位编码 + /// </summary> + [DisplayName("岗位编码")] + public string POST_CODE { get; set; } + /// <summary> + /// 工序编码 + /// </summary> + [DisplayName("工序编码")] + public string OPER_CODE { get; set; } + /// <summary> + /// 备注 + /// </summary> + [DisplayName("备注")] + public string REMARK { get; set; } + #endregion + + #region 虚拟属性 + /*例子 + [SugarColumn(IsIgnore = true)] + public string FieldName { get; set; } + */ + #endregion + + #region 外键属性 + /*例子 + //一对一外键导航 + [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是MES_TOOL_HIS类里面的外键ID字段 + public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null + //一对多外键导航 + [Navigate(NavigateType.OneToMany, nameof(ClassA.MES_TOOL_HISId))]//ClassA表中的MES_TOOL_HISId + public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值,只能是null + //多对多外键导航 + [Navigate(typeof(MappingClass), nameof(MappingClass.MES_TOOL_HISId), nameof(MappingClass.ClassAId))]//注意顺序 + public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null + */ + #endregion + + #region 枚举变量 + /*例子 + public enum FieldNames + { + [Description("枚举描述0")] + Enum0, + [Description("枚举描述1")] + Enum1, + } + */ + #endregion + + #region 公共方法 + + #endregion + + }//endClass +} \ No newline at end of file diff --git a/Tiger.Model.Net/Entitys/MES/MES_TOOL_PROP.cs b/Tiger.Model.Net/Entitys/MES/MES_TOOL_PROP.cs new file mode 100644 index 0000000..d5d7b47 --- /dev/null +++ b/Tiger.Model.Net/Entitys/MES/MES_TOOL_PROP.cs @@ -0,0 +1,136 @@ +using System; +using SqlSugar; +using System.Linq; +using System.ComponentModel; +using System.Collections.Generic; + +namespace Tiger.Model +{ + /// <summary> + /// 实体:生产工具属性 + /// </summary> + [Description("Primary:ID")] + [DisplayName("生产工具属性")] + [Serializable] + [SugarTable("MES_TOOL_PROP")] + public class MES_TOOL_PROP : DbEntityWithAuth + { + #region 构造函数 + /// <summary> + /// 实体:生产工具属性 + /// </summary> + public MES_TOOL_PROP() {} + #endregion + + #region 公共属性 + /// <summary> + /// 点检项目名称 + /// </summary> + [DisplayName("点检项目名称")] + public string PROP_NAME { get; set; } + /// <summary> + /// 变量的控件 + /// </summary> + [DisplayName("变量的控件")] + public string PROP_CONTROL { get; set; } + /// <summary> + /// 变量值类型(0String字符串|1Integer整形|2Float浮点型|3DateTime日期时间) + /// </summary> + [DisplayName("变量值类型(0String字符串|1Integer整形|2Float浮点型|3DateTime日期时间)")] + public int VALUE_TYPE { get; set; } + /// <summary> + /// 是否只读(Y/N) + /// </summary> + [DisplayName("是否只读(Y/N)")] + public string READONLY { get; set; } + /// <summary> + /// 是否显示(Y/N) + /// </summary> + [DisplayName("是否显示(Y/N)")] + public string VISIABLE { get; set; } + /// <summary> + /// 是否必填(Y/N) + /// </summary> + [DisplayName("是否必填(Y/N)")] + public string NECESSARY { get; set; } + /// <summary> + /// 默认值 + /// </summary> + [DisplayName("默认值")] + public string DEFAULT { get; set; } + /// <summary> + /// 最大值 + /// </summary> + [DisplayName("最大值")] + public double MAX { get; set; } + /// <summary> + /// 最小值 + /// </summary> + [DisplayName("最小值")] + public double MIN { get; set; } + /// <summary> + /// 选项,用“|”分隔 + /// </summary> + [DisplayName("选项,用“|”分隔")] + public string OPTIONS { get; set; } + /// <summary> + /// 备注 + /// </summary> + [DisplayName("备注")] + public string REMARK { get; set; } + #endregion + + #region 虚拟属性 + /*例子 + [SugarColumn(IsIgnore = true)] + public string FieldName { get; set; } + */ + #endregion + + #region 外键属性 + /*例子 + //一对一外键导航 + [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是MES_TOOL_PROP类里面的外键ID字段 + public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null + //一对多外键导航 + [Navigate(NavigateType.OneToMany, nameof(ClassA.MES_TOOL_PROPId))]//ClassA表中的MES_TOOL_PROPId + public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值,只能是null + //多对多外键导航 + [Navigate(typeof(MappingClass), nameof(MappingClass.MES_TOOL_PROPId), nameof(MappingClass.ClassAId))]//注意顺序 + public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null + */ + #endregion + + #region 枚举变量 + /*例子 + public enum FieldNames + { + [Description("枚举描述0")] + Enum0, + [Description("枚举描述1")] + Enum1, + } + */ + + /// <summary> + /// 枚举:变量值类型(0String字符串|1Integer整形|2Float浮点型|3DateTime日期时间) + /// </summary> + public enum VALUE_TYPEs + { + [Description("字符串")] + String = 0, + [Description("整形")] + Integer = 1, + [Description("浮点型")] + Float = 2, + [Description("日期时间")] + DateTime = 3, + } + #endregion + + #region 公共方法 + + #endregion + + }//endClass +} \ No newline at end of file diff --git a/Tiger.Model.Net/Entitys/MES/MES_TOOL_PROP_HIS.cs b/Tiger.Model.Net/Entitys/MES/MES_TOOL_PROP_HIS.cs new file mode 100644 index 0000000..623428b --- /dev/null +++ b/Tiger.Model.Net/Entitys/MES/MES_TOOL_PROP_HIS.cs @@ -0,0 +1,161 @@ +using System; +using SqlSugar; +using System.Linq; +using System.ComponentModel; +using System.Collections.Generic; + +namespace Tiger.Model +{ + /// <summary> + /// 实体:生产工具属性历史 + /// </summary> + [Description("Primary:ID")] + [DisplayName("生产工具属性历史")] + [Serializable] + [SugarTable("MES_TOOL_PROP_HIS")] + public class MES_TOOL_PROP_HIS : DbEntityWithAuth + { + #region 构造函数 + /// <summary> + /// 实体:生产工具属性历史 + /// </summary> + public MES_TOOL_PROP_HIS() {} + #endregion + + #region 公共属性 + /// <summary> + /// 使用历史ID + /// </summary> + [DisplayName("使用历史ID")] + public string HIS_ID { get; set; } + /// <summary> + /// 工具编码 + /// </summary> + [DisplayName("工具编码")] + public string TOOL_CODE { get; set; } + /// <summary> + /// 工单号 + /// </summary> + [DisplayName("工单号")] + public string WORK_ORDER { get; set; } + /// <summary> + /// 工单批次号 + /// </summary> + [DisplayName("工单批次号")] + public string BATCH_NO { get; set; } + /// <summary> + /// 工艺路线编码 + /// </summary> + [DisplayName("工艺路线编码")] + public string ROT_CODE { get; set; } + /// <summary> + /// 工艺路线节点ID + /// </summary> + [DisplayName("工艺路线节点ID")] + public string NODE_ID { get; set; } + /// <summary> + /// 工艺路线节点名称 + /// </summary> + [DisplayName("工艺路线节点名称")] + public string NODE_NAME { get; set; } + /// <summary> + /// 工厂编码 + /// </summary> + [DisplayName("工厂编码")] + public string FTY_CODE { get; set; } + /// <summary> + /// 车间编码 + /// </summary> + [DisplayName("车间编码")] + public string WS_CODE { get; set; } + /// <summary> + /// 产线编码 + /// </summary> + [DisplayName("产线编码")] + public string LINE_CODE { get; set; } + /// <summary> + /// 岗位编码 + /// </summary> + [DisplayName("岗位编码")] + public string POST_CODE { get; set; } + /// <summary> + /// 工序编码 + /// </summary> + [DisplayName("工序编码")] + public string OPER_CODE { get; set; } + /// <summary> + /// 点检项目名称 + /// </summary> + [DisplayName("点检项目名称")] + public string PROP_NAME { get; set; } + /// <summary> + /// 变量值类型(0String字符串|1Integer整形|2Float浮点型|3DateTime日期时间) + /// </summary> + [DisplayName("变量值类型(0String字符串|1Integer整形|2Float浮点型|3DateTime日期时间)")] + public int VALUE_TYPE { get; set; } + /// <summary> + /// 默认值 + /// </summary> + [DisplayName("默认值")] + public string VALUE { get; set; } + /// <summary> + /// 备注 + /// </summary> + [DisplayName("备注")] + public string REMARK { get; set; } + #endregion + + #region 虚拟属性 + /*例子 + [SugarColumn(IsIgnore = true)] + public string FieldName { get; set; } + */ + #endregion + + #region 外键属性 + /*例子 + //一对一外键导航 + [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是MES_TOOL_PROP_HIS类里面的外键ID字段 + public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null + //一对多外键导航 + [Navigate(NavigateType.OneToMany, nameof(ClassA.MES_TOOL_PROP_HISId))]//ClassA表中的MES_TOOL_PROP_HISId + public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值,只能是null + //多对多外键导航 + [Navigate(typeof(MappingClass), nameof(MappingClass.MES_TOOL_PROP_HISId), nameof(MappingClass.ClassAId))]//注意顺序 + public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null + */ + #endregion + + #region 枚举变量 + /*例子 + public enum FieldNames + { + [Description("枚举描述0")] + Enum0, + [Description("枚举描述1")] + Enum1, + } + */ + + /// <summary> + /// 枚举:变量值类型(0String字符串|1Integer整形|2Float浮点型|3DateTime日期时间) + /// </summary> + public enum VALUE_TYPEs + { + [Description("字符串")] + String = 0, + [Description("整形")] + Integer = 1, + [Description("浮点型")] + Float = 2, + [Description("日期时间")] + DateTime = 3, + } + #endregion + + #region 公共方法 + + #endregion + + }//endClass +} \ No newline at end of file -- Gitblit v1.9.3