using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; namespace Tiger.Model { /// /// 实体:备料任务(WMS)物料明细 /// [Description("Primary:ID")] [DisplayName("备料任务(WMS)物料明细")] [Serializable] [SugarTable("BIZ_WMS_PREP_DTL")] public class BIZ_WMS_PREP_DTL : DbEntityWithAuth { #region 构造函数 /// /// 实体:备料任务(WMS)物料明细 /// public BIZ_WMS_PREP_DTL() {} #endregion #region 公共属性 /// /// 备料任务号 /// [DisplayName("备料任务号")] public string ORDER_NO { get; set; } /// /// 备料任务行号 /// [DisplayName("备料任务行号")] public string ORDER_LINE { get; set; } /// /// 物料编码 /// [DisplayName("物料编码")] public string ITEM_CODE { get; set; } /// /// 替代料,多个用“,”分隔 /// [DisplayName("替代料,多个用“,”分隔")] public string SUBITEM_CODE { get; set; } /// /// 单位 /// [DisplayName("单位")] public string UNIT { get; set; } /// /// 生产计划损耗比例(%) /// [DisplayName("生产计划损耗比例(%)")] public double PLAN_LOSS_RATE { get; set; } /// /// 生产计划损耗数量 /// [DisplayName("生产计划损耗数量")] public double PLAN_LOSS_QTY { get; set; } /// /// 是否计算损耗(Y/N) /// [DisplayName("是否计算损耗(Y/N)")] public string IS_CALC_LOSS { get; set; } /// /// 是否最小包装发料(Y/N) /// [DisplayName("是否最小包装发料(Y/N)")] public string IS_WHOLE { get; set; } /// /// 来源单据编码,多个用“,”分隔 /// [DisplayName("来源单据编码,多个用“,”分隔")] public string SOURCE_CODE { get; set; } /// /// 来源单号,多个用“,”分隔,跟编码一一对应 /// [DisplayName("来源单号,多个用“,”分隔,跟编码一一对应")] public string SOURCE_ORDER { get; set; } /// /// 来源单行号,多个用“,”分隔,跟编码一一对应 /// [DisplayName("来源单行号,多个用“,”分隔,跟编码一一对应")] public string SOURCE_LINE { get; set; } /// /// 状态(0UnCalc未计算|1FistrLack首套缺料|2SupplyLack补料缺料|3Enough满足需求|4NoCalc不参与备料计算|5Cancel已作废|6Finish备料完成) /// [DisplayName("状态(0UnCalc未计算|1FistrLack首套缺料|2SupplyLack补料缺料|3Enough满足需求|4NoCalc不参与备料计算|5Cancel已作废|6Finish备料完成)")] public int STATUS { get; set; } /// /// 单位用量 /// [DisplayName("单位用量")] public double QTY_UNIT { get; set; } /// /// 需求数量 /// [DisplayName("需求数量")] public double QTY_REQ { get; set; } /// /// 已备料数量 /// [DisplayName("已备料数量")] public double QTY_PREP { get; set; } /// /// 发出数量 /// [DisplayName("发出数量")] public double QTY_DLVY { get; set; } /// /// 工厂编码 /// [DisplayName("工厂编码")] public string FTY_CODE { get; set; } /// /// 车间编码 /// [DisplayName("车间编码")] public string WS_CODE { get; set; } /// /// 产线编码 /// [DisplayName("产线编码")] public string LINE_CODE { get; set; } /// /// 岗位编码 /// [DisplayName("岗位编码")] public string POST_CODE { get; set; } /// /// 工序编码 /// [DisplayName("工序编码")] public string OPER_CODE { get; set; } /// /// 加工段 /// [DisplayName("加工段")] public string SEGMENT { get; set; } /// /// 贴片机序号 /// [DisplayName("贴片机序号")] public string SMT_NO { get; set; } /// /// 站位号 /// [DisplayName("站位号")] public string STATION_NO { get; set; } /// /// 飞达号 /// [DisplayName("飞达号")] public string FEEDER_NO { get; set; } /// /// 料枪类型 /// [DisplayName("料枪类型")] public string FEEDER_TYPE { get; set; } /// /// 备注 /// [DisplayName("备注")] public string REMARK { get; set; } /// /// 计算字段无需更新和显示 /// [DisplayName("计算字段无需更新和显示")] public double TEMP_QTY { get; set; } #endregion #region 虚拟属性 /*例子 [SugarColumn(IsIgnore = true)] public string FieldName { get; set; } */ [SugarColumn(IsIgnore = true)] public List Suggests { get; set; } #endregion #region 外键属性 /*例子 //一对一外键导航 [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BIZ_WMS_PREP_DTL类里面的外键ID字段 public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null //一对多外键导航 [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_WMS_PREP_DTLId))]//ClassA表中的BIZ_WMS_PREP_DTLId public List ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_WMS_PREP_DTLId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ #endregion #region 枚举变量 /*例子 public enum FieldNames { [Description("枚举描述0")] Enum0, [Description("枚举描述1")] Enum1, } */ /// /// 枚举:状态(0UnCalc未计算|1FistrLack首套缺料|2SupplyLack补料缺料|3Enough满足需求|4NoCalc不参与备料计算|5Cancel已作废|6Finish备料完成) /// public enum STATUSs { [Description("未计算")] UnCalc = 0, [Description("首套缺料")] FistrLack = 1, [Description("补料缺料")] SupplyLack = 2, [Description("满足需求")] Enough = 3, [Description("不参与备料计算")] NoCalc = 4, [Description("已作废")] Cancel = 5, [Description("备料完成")] Finish = 6, } #endregion #region 公共方法 #endregion }//endClass }