using System; using SqlSugar; using System.Linq; using System.ComponentModel; using System.Collections.Generic; namespace Tiger.Model { /// /// 实体:物品基础信息 /// [Description("Primary:ID")] [DisplayName("物品基础信息")] [Serializable] [SugarTable("BAS_ITEM")] public class BAS_ITEM : DbEntityWithAuth { #region 构造函数 /// /// 实体:物品基础信息 /// public BAS_ITEM() { } #endregion #region 公共属性 /// /// 物料编码 /// [DisplayName("物料编码")] public string ITEM_CODE { get; set; } /// /// 物料名称 /// [DisplayName("物料名称")] public string ITEM_NAME { get; set; } /// /// 物料描述 /// [DisplayName("物料描述")] public string ITEM_DESC { get; set; } /// /// 物品分类编码 /// [DisplayName("物品分类编码")] public string ITEM_TYPE { get; set; } /// /// 物料版本 /// [DisplayName("物料版本")] public string ITEM_VER { get; set; } /// /// 规格 /// [DisplayName("规格")] public string SPEC { get; set; } /// /// 储位规格(SmallReel卷装小盘|BigReel卷装大盘) /// [DisplayName("储位规格(SmallReel卷装小盘|BigReel卷装大盘)")] public string SPEC_WH { get; set; } /// /// 颜色 /// [DisplayName("颜色")] public string COLOR { get; set; } /// /// 单位 /// [DisplayName("单位")] public string UNIT { get; set; } /// /// 是否成品(Y/N) /// [DisplayName("是否成品(Y/N)")] public string IS_PROD { get; set; } /// /// 产品类型 /// [DisplayName("产品类型")] public string PROD_TYPE { get; set; } /// /// 客户产品编码 /// [DisplayName("客户产品编码")] public string CUST_PROD_CODE { get; set; } /// /// 是否启用(Y/N) /// [DisplayName("是否启用(Y/N)")] public string IS_ACTIVE { get; set; } /// /// 管控方式(Batch批次管控/Single单件管控) /// [DisplayName("管控方式(Batch批次管控/Single单件管控)")] public string CTRL_MODE { get; set; } /// /// 发布时间 /// [DisplayName("发布时间")] public DateTime RELEASE_TIME { get; set; } = DateTime.MinValue; /// /// 生效时间 /// [DisplayName("生效时间")] public DateTime EFFECTIVE_TIME { get; set; } = DateTime.MinValue; /// /// 有效天数 /// [DisplayName("有效天数")] public double VALIDITY_DAYS { get; set; } /// /// 发料管控(0ByDemand按需发料|1ByMinPackage最小包装发料) /// [DisplayName("发料管控(0ByDemand按需发料|1ByMinPackage最小包装发料)")] public int DLVY_TYPE { get; set; } /// /// 是否启用先进先出(Y/N) /// [DisplayName("是否启用先进先出(Y/N)")] public string ENABLE_FIFO { get; set; } /// /// 条码规则编码 /// [DisplayName("条码规则编码")] public string RULE_CODE { get; set; } /// /// 备注 /// [DisplayName("备注")] public string REMARK { get; set; } #endregion #region 虚拟属性 /*例子 [SugarColumn(IsIgnore = true)] public string FieldName { get; set; } */ /// /// 预存天数 /// [SugarColumn(IsIgnore = true)] public double DepositDays { get; set; } #endregion 虚拟属性 #region 外键属性 /*例子 //一对一外键导航 [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是BAS_ITEM类里面的外键ID字段 public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null //一对多外键导航 [Navigate(NavigateType.OneToMany, nameof(ClassA.BAS_ITEMId))]//ClassA表中的BAS_ITEMId public List ClassAList { get; set; }//注意禁止手动赋值,只能是null //多对多外键导航 [Navigate(typeof(MappingClass), nameof(MappingClass.BAS_ITEMId), nameof(MappingClass.ClassAId))]//注意顺序 public List ClassAList { get; set; } //注意禁止手动赋值,只能是null */ [Navigate(NavigateType.OneToOne, nameof(ID), nameof(BAS_ITEM_EXT.ITEM_ID), "GHOST_ROW = 0")]//一对一 ClassAId是BAS_ITEM_EXT类里面的外键ID字段 public BAS_ITEM_EXT ExtInfo { get; set; } //注意禁止手动赋值,只能是null #endregion #region 枚举变量 /*例子 public enum FieldNames { [Description("枚举描述0")] Enum0, [Description("枚举描述1")] Enum1, } */ /// /// 枚举:发料管控(0ByDemand按需发料|1ByMinPackage最小包装发料) /// public enum DLVY_TYPEs { [Description("按需发料")] ByDemand = 0, [Description("最小包装发料")] ByMinPackage = 1, } #endregion #region 公共方法 #endregion }//endClass }