| | |
| | | |
| | | namespace Tiger.Model |
| | | { |
| | | /// <summary> |
| | | /// 实体:生产不良记录 |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [DisplayName("生产不良记录")] |
| | | [Serializable] |
| | | [SugarTable("MES_WIP_DFT")] |
| | | public class MES_WIP_DFT : DbEntityWithAuth |
| | | { |
| | | #region 构造函数 |
| | | /// <summary> |
| | | /// 实体:生产不良记录 |
| | | /// </summary> |
| | | public MES_WIP_DFT() {} |
| | | #endregion |
| | | /// <summary> |
| | | /// 实体:生产不良记录 |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [DisplayName("生产不良记录")] |
| | | [Serializable] |
| | | [SugarTable("MES_WIP_DFT")] |
| | | public class MES_WIP_DFT : DbEntityWithAuth |
| | | { |
| | | #region 构造函数 |
| | | /// <summary> |
| | | /// 实体:生产不良记录 |
| | | /// </summary> |
| | | public MES_WIP_DFT() { } |
| | | #endregion |
| | | |
| | | #region 公共属性 |
| | | /// <summary> |
| | | /// 过站条码 |
| | | /// </summary> |
| | | [DisplayName("过站条码")] |
| | | public string SN { get; set; } |
| | | /// <summary> |
| | | /// 状态(0WaitHandle待处理|1Repairing维修中|2Resolved已处理) |
| | | /// </summary> |
| | | [DisplayName("状态(0WaitHandle待处理|1Repairing维修中|2Resolved已处理)")] |
| | | public int STATUS { get; set; } |
| | | /// <summary> |
| | | /// 物料编码 |
| | | /// </summary> |
| | | [DisplayName("物料编码")] |
| | | public string ITEM_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 SEGMENT { get; set; } |
| | | /// <summary> |
| | | /// 是否不良 |
| | | /// </summary> |
| | | [DisplayName("是否不良")] |
| | | public string DFT_FLAG { get; set; } |
| | | /// <summary> |
| | | /// 不良计数 |
| | | /// </summary> |
| | | [DisplayName("不良计数")] |
| | | public int DFT_COUNT { get; set; } |
| | | /// <summary> |
| | | /// 不良代码编码 |
| | | /// </summary> |
| | | [DisplayName("不良代码编码")] |
| | | public string DFT_CODE { get; set; } |
| | | /// <summary> |
| | | /// 不良代码名称 |
| | | /// </summary> |
| | | [DisplayName("不良代码名称")] |
| | | public string DFT_NAME { get; set; } |
| | | /// <summary> |
| | | /// 缺陷等级(0MI轻微缺陷|1MA严重缺陷|2CR致命缺陷) |
| | | /// </summary> |
| | | [DisplayName("缺陷等级(0MI轻微缺陷|1MA严重缺陷|2CR致命缺陷)")] |
| | | public int DFT_LEVEL { get; set; } |
| | | /// <summary> |
| | | /// 托盘/载具条码 |
| | | /// </summary> |
| | | [DisplayName("托盘/载具条码")] |
| | | public string TRAY_SN { get; set; } |
| | | /// <summary> |
| | | /// 容器/内包装条码 |
| | | /// </summary> |
| | | [DisplayName("容器/内包装条码")] |
| | | public string CONTAINER_SN { get; set; } |
| | | /// <summary> |
| | | /// 外箱条码 |
| | | /// </summary> |
| | | [DisplayName("外箱条码")] |
| | | public string CARTON_SN { get; set; } |
| | | /// <summary> |
| | | /// 栈板条码 |
| | | /// </summary> |
| | | [DisplayName("栈板条码")] |
| | | public string PALLET_SN { get; set; } |
| | | /// <summary> |
| | | /// 是否入库 |
| | | /// </summary> |
| | | [DisplayName("是否入库")] |
| | | public string INV_FLAG { get; set; } |
| | | /// <summary> |
| | | /// 当前操作时间 |
| | | /// </summary> |
| | | [DisplayName("当前操作时间")] |
| | | public DateTime OPERATION_TIME { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// 班制编码 |
| | | /// </summary> |
| | | [DisplayName("班制编码")] |
| | | public string SFTS_CODE { get; set; } |
| | | /// <summary> |
| | | /// 班次编码 |
| | | /// </summary> |
| | | [DisplayName("班次编码")] |
| | | public string SFT_CODE { get; set; } |
| | | /// <summary> |
| | | /// 时段编码 |
| | | /// </summary> |
| | | [DisplayName("时段编码")] |
| | | public string PRD_CODE { get; set; } |
| | | /// <summary> |
| | | /// 抽检批次号 |
| | | /// </summary> |
| | | [DisplayName("抽检批次号")] |
| | | public string OBA_BATCH { get; set; } |
| | | /// <summary> |
| | | /// 锁定批次号 |
| | | /// </summary> |
| | | [DisplayName("锁定批次号")] |
| | | public string LOCK_BATCH { get; set; } |
| | | /// <summary> |
| | | /// 不良原因编码 |
| | | /// </summary> |
| | | [DisplayName("不良原因编码")] |
| | | public string RSN_CODE { get; set; } |
| | | /// <summary> |
| | | /// 不良原因名称 |
| | | /// </summary> |
| | | [DisplayName("不良原因名称")] |
| | | public string RSN_NAME { get; set; } |
| | | /// <summary> |
| | | /// 是否必须更换零件(Y/N) |
| | | /// </summary> |
| | | [DisplayName("是否必须更换零件(Y/N)")] |
| | | public string NEED_REPLACE { get; set; } |
| | | /// <summary> |
| | | /// 不良责任编码 |
| | | /// </summary> |
| | | [DisplayName("不良责任编码")] |
| | | public string DUTY_CODE { get; set; } |
| | | /// <summary> |
| | | /// 不良责任名称 |
| | | /// </summary> |
| | | [DisplayName("不良责任名称")] |
| | | public string DUTY_NAME { get; set; } |
| | | /// <summary> |
| | | /// 缺陷位置编码 |
| | | /// </summary> |
| | | [DisplayName("缺陷位置编码")] |
| | | public string LOC_CODE { get; set; } |
| | | /// <summary> |
| | | /// 缺陷位置名称 |
| | | /// </summary> |
| | | [DisplayName("缺陷位置名称")] |
| | | public string LOC_NAME { get; set; } |
| | | /// <summary> |
| | | /// 不良解决方案编码 |
| | | /// </summary> |
| | | [DisplayName("不良解决方案编码")] |
| | | public string SOL_CODE { get; set; } |
| | | /// <summary> |
| | | /// 不良解决方案名称 |
| | | /// </summary> |
| | | [DisplayName("不良解决方案名称")] |
| | | public string SOL_NAME { get; set; } |
| | | /// <summary> |
| | | /// 备注 |
| | | /// </summary> |
| | | [DisplayName("备注")] |
| | | public string REMARK { get; set; } |
| | | /// <summary> |
| | | /// 追溯信息 |
| | | /// </summary> |
| | | [DisplayName("追溯信息")] |
| | | public string TRACE_INFO { get; set; } |
| | | #endregion |
| | | #region 公共属性 |
| | | /// <summary> |
| | | /// 在制品ID |
| | | /// </summary> |
| | | [DisplayName("在制品ID")] |
| | | public string WIP_ID { get; set; } |
| | | /// <summary> |
| | | /// 过站条码 |
| | | /// </summary> |
| | | [DisplayName("过站条码")] |
| | | public string SN { get; set; } |
| | | /// <summary> |
| | | /// 状态(0WaitHandle待处理|1Repairing维修中|2Resolved已处理) |
| | | /// </summary> |
| | | [DisplayName("状态(0WaitHandle待处理|1Repairing维修中|2Resolved已处理)")] |
| | | public int STATUS { get; set; } |
| | | /// <summary> |
| | | /// 物料编码 |
| | | /// </summary> |
| | | [DisplayName("物料编码")] |
| | | public string ITEM_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 SEGMENT { get; set; } |
| | | /// <summary> |
| | | /// 不良代码编码 |
| | | /// </summary> |
| | | [DisplayName("不良代码编码")] |
| | | public string DFT_CODE { get; set; } |
| | | /// <summary> |
| | | /// 不良代码名称 |
| | | /// </summary> |
| | | [DisplayName("不良代码名称")] |
| | | public string DFT_NAME { get; set; } |
| | | /// <summary> |
| | | /// 缺陷等级(0MI轻微缺陷|1MA严重缺陷|2CR致命缺陷) |
| | | /// </summary> |
| | | [DisplayName("缺陷等级(0MI轻微缺陷|1MA严重缺陷|2CR致命缺陷)")] |
| | | public int DFT_LEVEL { get; set; } |
| | | /// <summary> |
| | | /// 厂内流转条码 |
| | | /// </summary> |
| | | [DisplayName("厂内流转条码")] |
| | | public string FLOW_SN { get; set; } |
| | | /// <summary> |
| | | /// 托盘/载具条码 |
| | | /// </summary> |
| | | [DisplayName("托盘/载具条码")] |
| | | public string TRAY_SN { get; set; } |
| | | /// <summary> |
| | | /// 内包装条码 |
| | | /// </summary> |
| | | [DisplayName("内包装条码")] |
| | | public string INNER_SN { get; set; } |
| | | /// <summary> |
| | | /// 外箱条码 |
| | | /// </summary> |
| | | [DisplayName("外箱条码")] |
| | | public string CARTON_SN { get; set; } |
| | | /// <summary> |
| | | /// 栈板条码 |
| | | /// </summary> |
| | | [DisplayName("栈板条码")] |
| | | public string PALLET_SN { get; set; } |
| | | /// <summary> |
| | | /// 是否入库 |
| | | /// </summary> |
| | | [DisplayName("是否入库")] |
| | | public string INV_FLAG { get; set; } |
| | | /// <summary> |
| | | /// 当前操作时间 |
| | | /// </summary> |
| | | [DisplayName("当前操作时间")] |
| | | public DateTime OPERATION_TIME { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// 班制编码 |
| | | /// </summary> |
| | | [DisplayName("班制编码")] |
| | | public string SFTS_CODE { get; set; } |
| | | /// <summary> |
| | | /// 班次编码 |
| | | /// </summary> |
| | | [DisplayName("班次编码")] |
| | | public string SFT_CODE { get; set; } |
| | | /// <summary> |
| | | /// 时段编码 |
| | | /// </summary> |
| | | [DisplayName("时段编码")] |
| | | public string PRD_CODE { get; set; } |
| | | /// <summary> |
| | | /// 抽检批次号 |
| | | /// </summary> |
| | | [DisplayName("抽检批次号")] |
| | | public string OBA_BATCH { get; set; } |
| | | /// <summary> |
| | | /// 锁定批次号 |
| | | /// </summary> |
| | | [DisplayName("锁定批次号")] |
| | | public string LOCK_BATCH { get; set; } |
| | | /// <summary> |
| | | /// 不良原因编码 |
| | | /// </summary> |
| | | [DisplayName("不良原因编码")] |
| | | public string RSN_CODE { get; set; } |
| | | /// <summary> |
| | | /// 不良原因名称 |
| | | /// </summary> |
| | | [DisplayName("不良原因名称")] |
| | | public string RSN_NAME { get; set; } |
| | | /// <summary> |
| | | /// 是否必须更换零件(Y/N) |
| | | /// </summary> |
| | | [DisplayName("是否必须更换零件(Y/N)")] |
| | | public string NEED_REPLACE { get; set; } |
| | | /// <summary> |
| | | /// 不良责任编码 |
| | | /// </summary> |
| | | [DisplayName("不良责任编码")] |
| | | public string DUTY_CODE { get; set; } |
| | | /// <summary> |
| | | /// 不良责任名称 |
| | | /// </summary> |
| | | [DisplayName("不良责任名称")] |
| | | public string DUTY_NAME { get; set; } |
| | | /// <summary> |
| | | /// 缺陷位置编码 |
| | | /// </summary> |
| | | [DisplayName("缺陷位置编码")] |
| | | public string LOC_CODE { get; set; } |
| | | /// <summary> |
| | | /// 缺陷位置名称 |
| | | /// </summary> |
| | | [DisplayName("缺陷位置名称")] |
| | | public string LOC_NAME { get; set; } |
| | | /// <summary> |
| | | /// 不良解决方案编码 |
| | | /// </summary> |
| | | [DisplayName("不良解决方案编码")] |
| | | public string SOL_CODE { get; set; } |
| | | /// <summary> |
| | | /// 不良解决方案名称 |
| | | /// </summary> |
| | | [DisplayName("不良解决方案名称")] |
| | | public string SOL_NAME { get; set; } |
| | | /// <summary> |
| | | /// 备注 |
| | | /// </summary> |
| | | [DisplayName("备注")] |
| | | public string REMARK { get; set; } |
| | | /// <summary> |
| | | /// 追溯信息 |
| | | /// </summary> |
| | | [DisplayName("追溯信息")] |
| | | public string TRACE_INFO { get; set; } |
| | | #endregion |
| | | |
| | | #region 虚拟属性 |
| | | /*例子 |
| | | #region 虚拟属性 |
| | | /*例子 |
| | | [SugarColumn(IsIgnore = true)] |
| | | public string FieldName { get; set; } |
| | | */ |
| | | #endregion |
| | | #endregion |
| | | |
| | | #region 外键属性 |
| | | /*例子 |
| | | //一对一外键导航 |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是MES_WIP_DFT类里面的外键ID字段 |
| | | public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null |
| | | //一对多外键导航 |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.MES_WIP_DFTId))]//ClassA表中的MES_WIP_DFTId |
| | | public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值,只能是null |
| | | //多对多外键导航 |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.MES_WIP_DFTId), nameof(MappingClass.ClassAId))]//注意顺序 |
| | | public List<ClassA> ClassAList { get; set; } //注意禁止手动赋值,只能是null |
| | | #region 外键属性 |
| | | /*例子 |
| | | //一对一外键导航 |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是MES_WIP_DFT类里面的外键ID字段 |
| | | public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null |
| | | //一对多外键导航 |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.MES_WIP_DFTId))]//ClassA表中的MES_WIP_DFTId |
| | | public List<ClassA> ClassAList { get; set; }//注意禁止手动赋值,只能是null |
| | | //多对多外键导航 |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.MES_WIP_DFTId), 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, |
| | | } |
| | | */ |
| | | |
| | | /// <summary> |
| | | /// 枚举:状态(0WaitHandle待处理|1Repairing维修中|2Resolved已处理) |
| | | /// </summary> |
| | | public enum STATUSs |
| | | { |
| | | [Description("待处理")] |
| | | WaitHandle = 0, |
| | | [Description("维修中")] |
| | | Repairing = 1, |
| | | [Description("已处理")] |
| | | Resolved = 2, |
| | | } |
| | | /// <summary> |
| | | /// 枚举:状态(0WaitHandle待处理|1Repairing维修中|2Resolved已处理) |
| | | /// </summary> |
| | | public enum STATUSs |
| | | { |
| | | [Description("待处理")] |
| | | WaitHandle = 0, |
| | | [Description("维修中")] |
| | | Repairing = 1, |
| | | [Description("已处理")] |
| | | Resolved = 2, |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 枚举:缺陷等级(0MI轻微缺陷|1MA严重缺陷|2CR致命缺陷) |
| | | /// </summary> |
| | | public enum DFT_LEVELs |
| | | { |
| | | [Description("轻微缺陷")] |
| | | MI = 0, |
| | | [Description("严重缺陷")] |
| | | MA = 1, |
| | | [Description("致命缺陷")] |
| | | CR = 2, |
| | | } |
| | | #endregion |
| | | /// <summary> |
| | | /// 枚举:缺陷等级(0MI轻微缺陷|1MA严重缺陷|2CR致命缺陷) |
| | | /// </summary> |
| | | public enum DFT_LEVELs |
| | | { |
| | | [Description("轻微缺陷")] |
| | | MI = 0, |
| | | [Description("严重缺陷")] |
| | | MA = 1, |
| | | [Description("致命缺陷")] |
| | | CR = 2, |
| | | } |
| | | #endregion |
| | | |
| | | #region 公共方法 |
| | | #region 公共方法 |
| | | |
| | | #endregion |
| | | #endregion |
| | | |
| | | }//endClass |
| | | }//endClass |
| | | } |