using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; namespace Tiger.Model { /// /// 实体:工单路线节点 /// [Description("Primary:ID")] [DisplayName("工单路线节点")] [Serializable] [SugarTable("MES_WO_NODE")] public class MES_WO_NODE : DbEntityWithAuth { #region 构造函数 /// /// 实体:工单路线节点 /// public MES_WO_NODE() {} #endregion #region 公共属性 /// /// 关联工单号 /// [DisplayName("关联工单号")] public string WORK_ORDER { get; set; } /// /// 产品编码 /// [DisplayName("产品编码")] public string PROD_CODE { get; set; } /// /// 客户编码 /// [DisplayName("客户编码")] public string CUST_CODE { get; set; } /// /// 节点名称 /// [DisplayName("节点名称")] public string NODE_NAME { get; set; } /// /// 工艺路线ID /// [DisplayName("工艺路线ID")] public string ROT_ID { get; set; } /// /// 工段 /// [DisplayName("工段")] public string SEGMENT { get; set; } /// /// 工序编码 /// [DisplayName("工序编码")] public string OPER_CODE { get; set; } /// /// 绘图属性:type /// [DisplayName("绘图属性:type")] public string GPH_TYPE { get; set; } /// /// 绘图属性:x /// [DisplayName("绘图属性:x")] public double GPH_X { get; set; } /// /// 绘图属性:y /// [DisplayName("绘图属性:y")] public double GPH_Y { get; set; } /// /// 绘图属性:properties /// [DisplayName("绘图属性:properties")] public string GPH_PROP { get; set; } /// /// 绘图属性:text /// [DisplayName("绘图属性:text")] public string GPH_TEXT { get; set; } /// /// 是否第一个节点(Y/N) /// [DisplayName("是否第一个节点(Y/N)")] public string IS_FIRST_NODE { get; set; } /// /// 是否启用(Y/N) /// [DisplayName("是否启用(Y/N)")] public string IS_ACTIVE { get; set; } /// /// 是否计算直通率(Y/N) /// [DisplayName("是否计算直通率(Y/N)")] public string IS_CALC_FPY { get; set; } /// /// 是否允许跳站(Y/N) /// [DisplayName("是否允许跳站(Y/N)")] public string CAN_SKIP { get; set; } /// /// 是否投入站(Y/N) /// [DisplayName("是否投入站(Y/N)")] public string IS_INPUT { get; set; } /// /// 是否产出站(Y/N) /// [DisplayName("是否产出站(Y/N)")] public string IS_OUTPUT { get; set; } /// /// 设置值1 /// [DisplayName("设置值1")] public string OPTION_1 { get; set; } /// /// 设置值2 /// [DisplayName("设置值2")] public string OPTION_2 { get; set; } /// /// 设置值3 /// [DisplayName("设置值3")] public string OPTION_3 { get; set; } /// /// 设置值4 /// [DisplayName("设置值4")] public string OPTION_4 { get; set; } /// /// 设置值5 /// [DisplayName("设置值5")] public string OPTION_5 { get; set; } /// /// 备注 /// [DisplayName("备注")] public string REMARK { get; set; } #endregion #region 虚拟属性 /*例子 [SugarColumn(IsIgnore = true)] public string FieldName { get; set; } */ [SugarColumn(IsIgnore = true)] public int Sequence { get; set; } [SugarColumn(IsIgnore = true)] public List PrepNodeIDs { get; set; } = new List(); /// /// 节点 /// [SugarColumn(IsIgnore = true)] public node node { get; set; } #endregion #region 外键属性 /*例子 //一对一外键导航 [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是MES_WO_NODE类里面的外键ID字段 public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null //一对多外键导航 [Navigate(NavigateType.OneToMany, nameof(ClassA.MES_WO_NODEId))]//ClassA表中的MES_WO_NODEId public List ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.MES_WO_NODEId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ [Navigate(NavigateType.OneToOne, nameof(OPER_CODE), nameof(MES_OPERATION.OPER_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是MES_WIP_DATA类里面的外键ID字段 public MES_OPERATION Operation { get; set; } //注意禁止手动赋值,只能是null #endregion #region 枚举变量 /*例子 public enum FieldNames { [Description("枚举描述0")] Enum0, [Description("枚举描述1")] Enum1, } */ #endregion #region 公共方法 #endregion }//endClass }