using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; using Tiger.Model.Extensions; namespace Tiger.Model { /// /// 实体:备料任务(WMS) /// [Description("Primary:ID")] [DisplayName("备料任务(WMS)")] [Serializable] [SugarTable("BIZ_WMS_PREP")] public class BIZ_WMS_PREP : DbEntityWithAuth { #region 构造函数 /// /// 实体:备料任务(WMS) /// public BIZ_WMS_PREP() {} #endregion #region 公共属性 /// /// 备料任务号 /// [DisplayName("备料任务号")] public string ORDER_NO { get; set; } /// /// 业务类型(0Others其他备料|1Requisition领料单备料|2WorkOrder工单备料|3Outsourcing委外备料) /// [DisplayName("业务类型(0Others其他备料|1Requisition领料单备料|2WorkOrder工单备料|3Outsourcing委外备料)")] public int BIZ_TYPE { get; set; } /// /// 状态(0Init初始化|1Called已叫料|2WaitPick待捡料|3Picking捡料中|4Picked已捡完|5Sended已发料|6Close已关闭|7Cancel作废) /// [DisplayName("状态(0Init初始化|1Called已叫料|2WaitPick待捡料|3Picking捡料中|4Picked已捡完|5Sended已发料|6Close已关闭|7Cancel作废)")] public int STATUS { get; set; } /// /// 来源单据编码,多个用“,”分隔 /// [DisplayName("来源单据编码,多个用“,”分隔")] public string SOURCE_CODE { get; set; } /// /// 来源单号,多个用“,”分隔,跟编码一一对应 /// [DisplayName("来源单号,多个用“,”分隔,跟编码一一对应")] public string SOURCE_ORDER { get; set; } /// /// 备注 /// [DisplayName("备注")] public string REMARK { get; set; } #endregion #region 虚拟属性 /*例子 [SugarColumn(IsIgnore = true)] public string FieldName { get; set; } */ [SugarColumn(IsIgnore = true)] public BIZ_WMS_PREP_BTH CurBatch => Batchs?.OrderBy(q => q.CALL_TIME).FirstOrDefault(q => q.STATUS < STATUSs.Close.GetValue()); #endregion #region 外键属性 /*例子 //一对一外键导航 [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_WMS_PREP类里面的外键ID字段 public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null //一对多外键导航 [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_WMS_PREPId))]//ClassA表中的BIZ_WMS_PREPId public List ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_WMS_PREPId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ [Navigate(NavigateType.OneToMany, nameof(BIZ_WMS_PREP_SRC.ORDER_NO), nameof(ORDER_NO), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_WMS_PREP类里面的外键ID字段 public List SourceOrders { get; set; } //注意禁止手动赋值,只能是null [Navigate(NavigateType.OneToMany, nameof(BIZ_WMS_PREP_SRC_DTL.ORDER_NO), nameof(ORDER_NO), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_WMS_PREP类里面的外键ID字段 public List SourceDetails { get; set; } //注意禁止手动赋值,只能是null [Navigate(NavigateType.OneToMany, nameof(BIZ_WMS_PREP_DTL.ORDER_NO), nameof(ORDER_NO), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_WMS_PREP类里面的外键ID字段 public List Details { get; set; } //注意禁止手动赋值,只能是null [Navigate(NavigateType.OneToMany, nameof(BIZ_WMS_PREP_BTH.ORDER_NO), nameof(ORDER_NO), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_WMS_PREP类里面的外键ID字段 public List Batchs { get; set; } //注意禁止手动赋值,只能是null [Navigate(NavigateType.OneToMany, nameof(BIZ_WMS_PREP_SN.ORDER_NO), nameof(ORDER_NO), "GHOST_ROW = 0")]//一对一 ClassAId是BIZ_WMS_PREP类里面的外键ID字段 public List SnList { get; set; } //注意禁止手动赋值,只能是null #endregion #region 枚举变量 /*例子 public enum FieldNames { [Description("枚举描述0")] Enum0, [Description("枚举描述1")] Enum1, } */ /// /// 枚举:业务类型(0Others其他备料|1Requisition领料单备料|2WorkOrder工单备料|3Outsourcing委外备料) /// public enum BIZ_TYPEs { [Description("其他备料")] Others = 0, [Description("领料单备料")] Requisition = 1, [Description("工单备料")] WorkOrder = 2, [Description("委外备料")] Outsourcing = 3, } /// /// 枚举:状态(0Init初始化|1Called已叫料|2WaitPick待捡料|3Picking捡料中|4Picked已捡完|5Sended已发料|6Close已关闭|7Cancel作废) /// public enum STATUSs { [Description("初始化")] Init = 0, [Description("已叫料")] Called = 1, [Description("待捡料")] WaitPick = 2, [Description("捡料中")] Picking = 3, [Description("已捡完")] Picked = 4, [Description("已发料")] Sended = 5, [Description("已关闭")] Close = 6, [Description("作废")] Cancel = 7, } #endregion #region 公共方法 #endregion }//endClass }