using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; namespace Tiger.Model { /// /// 实体:生产行为记录 /// [Description("Primary:ID")] [Serializable] [SugarTable("MES_WIP_ACT")] public class MES_WIP_ACT : DbEntityWithAuth { #region 构造函数 /// /// 实体:生产行为记录 /// public MES_WIP_ACT() {} #endregion #region 公共属性 /// /// 生产过程记录ID /// public string HIS_ID { get; set; } /// /// 过站条码 /// public string SN { get; set; } /// /// 状态(0Init初始化|1Input已投入|2OK良品过站|3NG不良过站|4Repair维修中|5Finished已完工|6Scrap已报废|7InStorage已入库|8Reject已拒收|9Shipped已出货) /// public int STATUS { get; set; } /// /// 物料编码 /// public string ITEM_CODE { get; set; } /// /// 工单号 /// public string WORK_ORDER { get; set; } /// /// 加工段 /// public string SEGMENT { get; set; } /// /// 工艺路线ID /// public string ROT_ID { get; set; } /// /// 工艺路线节点ID /// public string NODE_ID { get; set; } /// /// 工序行为ID /// public string ACT_ID { get; set; } /// /// 工厂编码 /// public string FTY_CODE { get; set; } /// /// 车间编码 /// public string WS_CODE { get; set; } /// /// 产线编码 /// public string LINE_CODE { get; set; } /// /// 岗位编码 /// public string POST_CODE { get; set; } /// /// 工序编码 /// public string OPER_CODE { get; set; } /// /// 托盘/载具条码 /// public string TRAY_SN { get; set; } /// /// 当前操作时间 /// public DateTime OPERATION_TIME { get; set; } = DateTime.MinValue; /// /// 班制编码 /// public string SFTS_CODE { get; set; } /// /// 班次编码 /// public string SFT_CODE { get; set; } /// /// 时段编码 /// public string PRD_CODE { get; set; } /// /// 行为类型(0Normal默认行为|1Scan扫码验证|2Assy组装上料|3Test产品测试|4Audit产品抽检|5Print标签打印|6Package包装规则) /// public int ACT_TYPE { get; set; } /// /// 行为扫码 /// public string ACT_SN { get; set; } /// /// 行为操作值1 /// public string ACT_VALUE_1 { get; set; } /// /// 行为操作值2 /// public string ACT_VALUE_2 { get; set; } /// /// 行为操作值3 /// public string ACT_VALUE_3 { get; set; } /// /// 行为操作值4 /// public string ACT_VALUE_4 { get; set; } /// /// 行为操作值5 /// public string ACT_VALUE_5 { get; set; } /// /// 行为是否成功(Y/N) /// public string ACT_RESULT { get; set; } /// /// 备注 /// public string REMARK { get; set; } /// /// 追溯信息 /// public string TRACE_INFO { get; set; } #endregion #region 虚拟属性 /*例子 [SugarColumn(IsIgnore = true)] public string FieldName { get; set; } */ #endregion #region 外键属性 /*例子 //一对一外键导航 [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是MES_WIP_ACT类里面的外键ID字段 public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null //一对多外键导航 [Navigate(NavigateType.OneToMany, nameof(ClassA.MES_WIP_ACTId))]//ClassA表中的MES_WIP_ACTId public List ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.MES_WIP_ACTId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ #endregion #region 枚举变量 /*例子 public enum FieldNames { [Description("枚举描述0")] Enum0, [Description("枚举描述1")] Enum1, } */ #endregion #region 公共方法 #endregion }//endClass }