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