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