using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; namespace Tiger.Model { /// /// 实体:工单批次 /// [Description("Primary:ID")] [DisplayName("工单批次")] [Serializable] [SugarTable("BIZ_MES_WO_BATCH")] public class BIZ_MES_WO_BATCH : DbEntityWithAuth { #region 构造函数 /// /// 实体:工单批次 /// public BIZ_MES_WO_BATCH() { } #endregion #region 公共属性 /// /// 工单号 /// [DisplayName("工单号")] public string ORDER_NO { get; set; } /// /// 工单批次号 /// [DisplayName("工单批次号")] public string BATCH_NO { get; set; } /// /// 状态(0Init初始化|1Imported已导入|2Release已下发|3Working生产中|4Paused已暂停|5Closed已关闭) /// [DisplayName("状态(0Init初始化|1Imported已导入|2Release已下发|3Working生产中|4Paused已暂停|5Closed已关闭)")] public int STATUS { get; set; } /// /// 是否准备完成(Y/N) /// [DisplayName("是否准备完成(Y/N)")] public string IS_READY { get; set; } /// /// 物料编码 /// [DisplayName("物料编码")] public string ITEM_CODE { get; set; } /// /// 客户编码 /// [DisplayName("客户编码")] public string CUST_CODE { get; set; } /// /// 工厂 /// [DisplayName("工厂")] public string FACTORY { get; set; } /// /// 车间编码 /// [DisplayName("车间编码")] public string WS_CODE { get; set; } /// /// 实际线体 /// [DisplayName("实际线体")] public string ACT_LINE { get; set; } /// /// 实际开始时间 /// [DisplayName("实际开始时间")] public DateTime ACT_START_TIME { get; set; } = DateTime.MinValue; /// /// 实际结束时间 /// [DisplayName("实际结束时间")] public DateTime ACT_END_TIME { get; set; } = DateTime.MinValue; /// /// 标准作业人数 /// [DisplayName("标准作业人数")] public int STD_WORKER_QTY { get; set; } /// /// 实际作业人数 /// [DisplayName("实际作业人数")] public int ACT_WORKER_QTY { get; set; } /// /// 下发时间 /// [DisplayName("下发时间")] public DateTime RELEASE_TIME { get; set; } = DateTime.MinValue; /// /// 下发人 /// [DisplayName("下发人")] public string RELEASE_USER { get; set; } /// /// 变更时间 /// [DisplayName("变更时间")] public DateTime CHANGE_TIME { get; set; } = DateTime.MinValue; /// /// 变更人 /// [DisplayName("变更人")] public string CHANGE_USER { get; set; } /// /// 计划数量 /// [DisplayName("计划数量")] public int PLAN_QTY { get; set; } /// /// 投入数量 /// [DisplayName("投入数量")] public int INPUT_QTY { get; set; } /// /// 完工数量 /// [DisplayName("完工数量")] public int OUTPUT_QTY { get; set; } /// /// 报废数量 /// [DisplayName("报废数量")] public int SCRAP_QTY { get; set; } /// /// 入库数量 /// [DisplayName("入库数量")] public int STOCK_IN_QTY { get; set; } /// /// 首件确认数量 /// [DisplayName("首件确认数量")] public int FIRST_IN_QTY { get; set; } /// /// UPH /// [DisplayName("UPH")] public double UPH { get; set; } /// /// UPPH /// [DisplayName("UPPH")] public double UPPH { get; set; } /// /// 备注 /// [DisplayName("备注")] public string REMARK { get; set; } #endregion #region 虚拟属性 /*例子 [SugarColumn(IsIgnore = true)] public string FieldName { get; set; } */ [SugarColumn(IsIgnore = true)] public string VALIDATION_TYPE { get; set; } [SugarColumn(IsIgnore = true)] public string VALIDATION_RESULT { get; set; } #endregion #region 外键属性 /*例子 //一对一外键导航 [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_MES_WO_BATCH类里面的外键ID字段 public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null //一对多外键导航 [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_MES_WO_BATCHId))]//ClassA表中的BIZ_MES_WO_BATCHId public List ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_MES_WO_BATCHId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ [Navigate(NavigateType.OneToMany, nameof(BAS_ITEM.ITEM_CODE), nameof(ITEM_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是MES_WIP_DATA类里面的外键ID字段 public List _ItemInfos { get; set; } //注意禁止手动赋值,只能是null [SugarColumn(IsIgnore = true)] public BAS_ITEM ItemInfo => _ItemInfos?.FirstOrDefault(q => q.AUTH_ORG == AUTH_ORG); [Navigate(NavigateType.OneToOne, nameof(CUST_CODE), nameof(BAS_CUSTOMER.CUST_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_MES_WO类里面的外键ID字段 public BAS_CUSTOMER Customer { get; set; } //注意禁止手动赋值,只能是null #endregion #region 枚举变量 /*例子 public enum FieldNames { [Description("枚举描述0")] Enum0, [Description("枚举描述1")] Enum1, } */ /// /// 枚举:状态(0Init初始化|1Imported已导入|2Release已下发|3Working生产中|4Paused已暂停|5Closed已关闭) /// public enum STATUSs { [Description("初始化")] Init = 0, [Description("已导入")] Imported = 1, [Description("已下发")] Release = 2, [Description("生产中")] Working = 3, [Description("已暂停")] Paused = 4, [Description("已关闭")] Closed = 5, } #endregion #region 公共方法 #endregion }//endClass }