using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; namespace Tiger.Model { /// /// 实体:备料库存池 /// [Description("Primary:ID")] [Serializable] [SugarTable("WMS_ITEM_POOL")] public class WMS_ITEM_POOL : DbEntityNoGhostWithAuth { #region 构造函数 /// /// 实体:备料库存池 /// public WMS_ITEM_POOL() {} #endregion #region 公共属性 /// /// 业务单据编码 /// public string TRANS_CODE { get; set; } /// /// 业务单据号码 /// public string TRANS_NO { get; set; } /// /// 业务单据行号 /// public string TRANS_LINE { get; set; } /// /// 来源单据编码 /// public string SOURCE_CODE { get; set; } /// /// 来源单据号码 /// public string SOURCE_ORDER { get; set; } /// /// 来源单据行号 /// public string SOURCE_LINE { get; set; } /// /// 物料编码 /// public string ITEM_CODE { get; set; } /// /// 物料条码 /// public string SN { get; set; } /// /// 物料数量 /// public double QTY { get; set; } /// /// 已分配数量 /// public double ALLOC_QTY { get; set; } /// /// 生产日期 /// public DateTime PROD_DATE { get; set; } = DateTime.MinValue; /// /// 储位ID /// public string LOCATION_ID { get; set; } /// /// 是否首套料(Y/N) /// public string IS_FIRST { get; set; } /// /// 分配状态(0AllAllocated全部分配|1PartialAllocate部分分配) /// public int ALLOC_MODE { get; set; } /// /// 状态(0WaitPick待捡料|1Picking捡料中|2WaitSend待发料|3Sended已发料|4Close已关闭|5Cancel作废) /// public int STATUS { get; set; } /// /// 加工段 /// public string SEGMENT { get; set; } /// /// 目标产线代码 /// public string LINE_CODE { get; set; } /// /// 备注 /// public string REMARK { get; set; } #endregion #region 虚拟属性 /*例子 [SugarColumn(IsIgnore = true)] public string FieldName { get; set; } */ #endregion #region 外键属性 /*例子 //一对一外键导航 [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是WMS_ITEM_POOL类里面的外键ID字段 public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null //一对多外键导航 [Navigate(NavigateType.OneToMany, nameof(ClassA.WMS_ITEM_POOLId))]//ClassA表中的WMS_ITEM_POOLId public List ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.WMS_ITEM_POOLId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ #endregion #region 枚举变量 /// /// 分配状态(0AllAllocated全部分配|1PartialAllocate部分分配) /// public enum ALLOC_MODEs { [Description("全部分配")] AllAllocated, [Description("部分分配")] PartialAllocate, } /// /// 状态(0WaitPick待捡料|1Picking捡料中|2WaitSend待发料|3Sended已发料|4Close已关闭|5Cancel作废) /// public enum STATUSs { [Description("待捡料")] WaitPick, [Description("捡料中")] Picking, [Description("待发料")] WaitSend, [Description("已发料")] Sended, [Description("已关闭")] Close, [Description("作废")] Cancel, } #endregion #region 公共方法 #endregion }//endClass }