using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; namespace Tiger.Model { /// /// 实体:备料库存池 /// [Description("Primary:ID")] [DisplayName("备料库存池")] [Serializable] [SugarTable("WMS_ITEM_POOL")] public class WMS_ITEM_POOL : DbEntityNoGhostWithAuth { #region 构造函数 /// /// 实体:备料库存池 /// public WMS_ITEM_POOL() {} #endregion #region 公共属性 /// /// 事务ID /// [DisplayName("事务ID")] public string TRANS_ID { get; set; } /// /// 业务单据编码 /// [DisplayName("业务单据编码")] public string TRANS_CODE { get; set; } /// /// 业务单据号码 /// [DisplayName("业务单据号码")] public string TRANS_NO { get; set; } /// /// 业务单据行号 /// [DisplayName("业务单据行号")] public string TRANS_LINE { get; set; } /// /// 来源单据编码 /// [DisplayName("来源单据编码")] public string SOURCE_CODE { get; set; } /// /// 来源单据号码 /// [DisplayName("来源单据号码")] public string SOURCE_ORDER { get; set; } /// /// 来源单据行号 /// [DisplayName("来源单据行号")] public string SOURCE_LINE { get; set; } /// /// 备料策略(位标志枚举)(0None不启用|1FIFO先进先出|2FSFO/尾数优先) /// [DisplayName("备料策略(位标志枚举)(0None不启用|1FIFO先进先出|2FSFO/尾数优先)")] public int STRATEGY { get; set; } /// /// 发料方式(0Supply正常发料|1First首套发料) /// [DisplayName("发料方式(0Supply正常发料|1First首套发料)")] public int DLVY_MODE { get; set; } /// /// 是否被锁定(Y/N),锁定则不允许其他事务分配当前物料 /// [DisplayName("是否被锁定(Y/N),锁定则不允许其他事务分配当前物料")] public string IS_LOCKED { get; set; } /// /// 物料编码 /// [DisplayName("物料编码")] public string ITEM_CODE { get; set; } /// /// 物料条码 /// [DisplayName("物料条码")] public string SN { get; set; } /// /// 物料数量 /// [DisplayName("物料数量")] public double QTY { get; set; } /// /// 已分配数量 /// [DisplayName("已分配数量")] public double ALLOC_QTY { get; set; } /// /// 生产日期 /// [DisplayName("生产日期")] public DateTime PROD_DATE { get; set; } = DateTime.MinValue; /// /// 仓库ID /// [DisplayName("仓库ID")] public string WH_ID { get; set; } /// /// 储区ID /// [DisplayName("储区ID")] public string REGION_ID { get; set; } /// /// 货架/料车ID /// [DisplayName("货架/料车ID")] public string SHELF_ID { get; set; } /// /// 储位ID /// [DisplayName("储位ID")] public string LOCATION_ID { get; set; } /// /// 是否首套料(Y/N) /// [DisplayName("是否首套料(Y/N)")] public string IS_FIRST { get; set; } /// /// 分配状态(0AllAllocated全部分配|1PartialAllocate部分分配) /// [DisplayName("分配状态(0AllAllocated全部分配|1PartialAllocate部分分配)")] public int ALLOC_MODE { get; set; } /// /// 状态(0WaitPick待捡料|1Picking捡料中|2WaitSend待发料|3Sended已发料|4Close已关闭|5Cancel作废) /// [DisplayName("状态(0WaitPick待捡料|1Picking捡料中|2WaitSend待发料|3Sended已发料|4Close已关闭|5Cancel作废)")] public int STATUS { get; set; } /// /// 加工段 /// [DisplayName("加工段")] public string SEGMENT { get; set; } /// /// 目标产线编码 /// [DisplayName("目标产线编码")] public string LINE_CODE { get; set; } /// /// 备注 /// [DisplayName("备注")] 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 枚举变量 /*例子 public enum FieldNames { [Description("枚举描述0")] Enum0, [Description("枚举描述1")] Enum1, } */ /// /// 枚举:备料策略(位标志枚举)(0None不启用|1FIFO先进先出|2FSFO/尾数优先) /// public enum STRATEGYs { [Description("不启用")] None = 0, [Description("先进先出")] FIFO = 1, [Description("尾数优先")] FSFO = 2, } /// /// 枚举:发料方式(0Supply正常发料|1First首套发料) /// public enum DLVY_MODEs { [Description("正常发料")] Supply = 0, [Description("首套发料")] First = 1, } /// /// 枚举:分配状态(0AllAllocated全部分配|1PartialAllocate部分分配) /// public enum ALLOC_MODEs { [Description("全部分配")] AllAllocated = 0, [Description("部分分配")] PartialAllocate = 1, } /// /// 枚举:状态(0WaitPick待捡料|1Picking捡料中|2WaitSend待发料|3Sended已发料|4Close已关闭|5Cancel作废) /// public enum STATUSs { [Description("待捡料")] WaitPick = 0, [Description("捡料中")] Picking = 1, [Description("待发料")] WaitSend = 2, [Description("已发料")] Sended = 3, [Description("已关闭")] Close = 4, [Description("作废")] Cancel = 5, } #endregion #region 公共方法 #endregion }//endClass }