using System;
|
using SqlSugar;
|
using System.Linq;
|
using System.ComponentModel;
|
using System.Collections.Generic;
|
|
namespace Tiger.Model
|
{
|
/// <summary>
|
/// 实体：物品基础信息
|
/// </summary>
|
[Description("Primary:ID")]
|
[DisplayName("物品基础信息")]
|
[Serializable]
|
[SugarTable("BAS_ITEM")]
|
public class BAS_ITEM : DbEntityWithAuth
|
{
|
#region 构造函数
|
/// <summary>
|
/// 实体：物品基础信息
|
/// </summary>
|
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>
|
[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 DEFAULT_WH { get; set; }
|
/// <summary>
|
/// 默认储区
|
/// </summary>
|
[DisplayName("默认储区")]
|
public string DEFAULT_REGION { get; set; }
|
/// <summary>
|
/// 默认货架/料车
|
/// </summary>
|
[DisplayName("默认货架/料车")]
|
public string DEFAULT_SHELF { get; set; }
|
/// <summary>
|
/// 默认储位
|
/// </summary>
|
[DisplayName("默认储位")]
|
public string DEFAULT_LOCATION { get; set; }
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[DisplayName("备注")]
|
public string REMARK { get; set; }
|
#endregion
|
|
#region 虚拟属性
|
/*例子
|
[SugarColumn(IsIgnore = true)]
|
public string FieldName { get; set; }
|
*/
|
/// <summary>
|
/// 预存天数
|
/// </summary>
|
[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<ClassA> ClassAList { get; set; }//注意禁止手动赋值，只能是null
|
//多对多外键导航
|
[Navigate(typeof(MappingClass), nameof(MappingClass.BAS_ITEMId), nameof(MappingClass.ClassAId))]//注意顺序
|
public List<ClassA> 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,
|
}
|
*/
|
|
/// <summary>
|
/// 枚举：发料管控(0ByDemand按需发料|1ByMinPackage最小包装发料)
|
/// </summary>
|
public enum DLVY_TYPEs
|
{
|
[Description("按需发料")]
|
ByDemand = 0,
|
[Description("最小包装发料")]
|
ByMinPackage = 1,
|
}
|
#endregion
|
|
#region 公共方法
|
|
#endregion
|
|
}//endClass
|
}
|
