/*
|
*代码由框架生成,任何更改都可能导致被代码生成器覆盖
|
*如果数据库字段发生变化，请在代码生器重新生成此Model
|
*/
|
using System;
|
using System.Collections.Generic;
|
using System.ComponentModel.DataAnnotations;
|
using System.ComponentModel.DataAnnotations.Schema;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using WIDESEA_Entity.SystemModels;
|
|
namespace WIDESEA_Entity.DomainModels
|
{
|
[Entity(TableCnName = "物料信息",TableName = "dt_materielinfo")]
|
public partial class dt_materielinfo:BaseEntity
|
{
|
/// <summary>
|
///主键
|
/// </summary>
|
[Display(Name ="主键")]
|
[Column(TypeName="uniqueidentifier")]
|
[Editable(true)]
|
[Required(AllowEmptyStrings=false)]
|
public Guid materiel_pkid { get; set; }
|
|
/// <summary>
|
///物料id
|
/// </summary>
|
[Display(Name ="物料id")]
|
[MaxLength(100)]
|
[Column(TypeName="nvarchar(100)")]
|
[Editable(true)]
|
[Required(AllowEmptyStrings=false)]
|
public string materiel_id { get; set; }
|
|
/// <summary>
|
///所属库区
|
/// </summary>
|
[Display(Name ="所属库区")]
|
[Column(TypeName="int")]
|
[Editable(true)]
|
[Required(AllowEmptyStrings=false)]
|
public int materiel_areaid { get; set; }
|
|
/// <summary>
|
///物料名称
|
/// </summary>
|
[Display(Name ="物料名称")]
|
[MaxLength(200)]
|
[Column(TypeName="nvarchar(200)")]
|
[Editable(true)]
|
[Required(AllowEmptyStrings=false)]
|
public string materiel_name { get; set; }
|
|
/// <summary>
|
///物料信息描述
|
/// </summary>
|
[Display(Name ="物料信息描述")]
|
[MaxLength(200)]
|
[Column(TypeName="nvarchar(200)")]
|
[Editable(true)]
|
public string materiel_desc { get; set; }
|
|
/// <summary>
|
///包装规格
|
/// </summary>
|
[Display(Name ="包装规格")]
|
[MaxLength(20)]
|
[Column(TypeName="nvarchar(20)")]
|
[Editable(true)]
|
public string materiel_packspes { get; set; }
|
|
/// <summary>
|
///当前状态
|
/// </summary>
|
[Display(Name ="当前状态")]
|
[MaxLength(20)]
|
[Column(TypeName="nvarchar(20)")]
|
[Editable(true)]
|
public string materiel_state { get; set; }
|
|
/// <summary>
|
///物料类型
|
/// </summary>
|
[Display(Name ="物料类型")]
|
[MaxLength(20)]
|
[Column(TypeName="nvarchar(20)")]
|
[Editable(true)]
|
public string materiel_type { get; set; }
|
|
/// <summary>
|
///计量单位
|
/// </summary>
|
[Display(Name ="计量单位")]
|
[MaxLength(10)]
|
[Column(TypeName="nvarchar(10)")]
|
[Editable(true)]
|
public string materiel_unit { get; set; }
|
|
/// <summary>
|
///最小包装
|
/// </summary>
|
[Display(Name ="最小包装")]
|
[DisplayFormat(DataFormatString="18,2")]
|
[Column(TypeName="decimal")]
|
[Editable(true)]
|
public decimal? materiel_minpack_qty { get; set; }
|
|
/// <summary>
|
///生产商
|
/// </summary>
|
[Display(Name ="生产商")]
|
[MaxLength(40)]
|
[Column(TypeName="nvarchar(40)")]
|
[Editable(true)]
|
public string materiel_mfacturer { get; set; }
|
|
/// <summary>
|
///供应商
|
/// </summary>
|
[Display(Name ="供应商")]
|
[MaxLength(40)]
|
[Column(TypeName="nvarchar(40)")]
|
[Editable(true)]
|
public string materiel_supplier { get; set; }
|
|
/// <summary>
|
///净重
|
/// </summary>
|
[Display(Name ="净重")]
|
[DisplayFormat(DataFormatString="18,2")]
|
[Column(TypeName="decimal")]
|
[Editable(true)]
|
public decimal? materiel_netweight { get; set; }
|
|
/// <summary>
|
///毛重
|
/// </summary>
|
[Display(Name ="毛重")]
|
[DisplayFormat(DataFormatString="18,2")]
|
[Column(TypeName="decimal")]
|
[Editable(true)]
|
public decimal? materiel_grossweight { get; set; }
|
|
/// <summary>
|
///有效期
|
/// </summary>
|
[Display(Name ="有效期")]
|
[Column(TypeName="int")]
|
[Editable(true)]
|
public int? materiel_validity { get; set; }
|
|
/// <summary>
|
///安全库存
|
/// </summary>
|
[Display(Name ="安全库存")]
|
[DisplayFormat(DataFormatString="18,2")]
|
[Column(TypeName="decimal")]
|
[Editable(true)]
|
public decimal? materiel_safety { get; set; }
|
|
/// <summary>
|
///创建者
|
/// </summary>
|
[Display(Name ="创建者")]
|
[MaxLength(20)]
|
[Column(TypeName="nvarchar(20)")]
|
[Editable(true)]
|
public string materiel_creator { get; set; }
|
|
/// <summary>
|
///创建时间
|
/// </summary>
|
[Display(Name ="创建时间")]
|
[Column(TypeName="datetime")]
|
[Editable(true)]
|
public DateTime? materiel_createtime { get; set; }
|
|
/// <summary>
|
///备注
|
/// </summary>
|
[Display(Name ="备注")]
|
[MaxLength(100)]
|
[Column(TypeName="nvarchar(100)")]
|
[Editable(true)]
|
public string materiel_remark { get; set; }
|
|
/// <summary>
|
///采购类型
|
/// </summary>
|
[Display(Name ="采购类型")]
|
[MaxLength(20)]
|
[Column(TypeName="nvarchar(20)")]
|
[Editable(true)]
|
public string materiel_purchaseType { get; set; }
|
|
/// <summary>
|
///英文描述
|
/// </summary>
|
[Display(Name ="英文描述")]
|
[MaxLength(200)]
|
[Column(TypeName="nvarchar(200)")]
|
[Editable(true)]
|
public string materiel_englishdesc { get; set; }
|
|
/// <summary>
|
///物料组
|
/// </summary>
|
[Display(Name ="物料组")]
|
[MaxLength(20)]
|
[Column(TypeName="varchar(20)")]
|
[Editable(true)]
|
public string materiel_materielGroup { get; set; }
|
|
/// <summary>
|
///产品组
|
/// </summary>
|
[Display(Name ="产品组")]
|
[MaxLength(20)]
|
[Column(TypeName="varchar(20)")]
|
[Editable(true)]
|
public string materiel_productGroup { get; set; }
|
|
/// <summary>
|
///大小/量纲
|
/// </summary>
|
[Display(Name ="大小/量纲")]
|
[MaxLength(20)]
|
[Column(TypeName="nvarchar(20)")]
|
[Editable(true)]
|
public string materiel_size { get; set; }
|
|
/// <summary>
|
///MRP类型
|
/// </summary>
|
[Display(Name ="MRP类型")]
|
[MaxLength(20)]
|
[Column(TypeName="nvarchar(20)")]
|
[Editable(true)]
|
public string materiel_mrpType { get; set; }
|
|
/// <summary>
|
///追溯标识
|
/// </summary>
|
[Display(Name ="追溯标识")]
|
[MaxLength(20)]
|
[Column(TypeName="varchar(20)")]
|
[Editable(true)]
|
public string materiel_traceabilityCode { get; set; }
|
|
/// <summary>
|
///物料长
|
/// </summary>
|
[Display(Name ="物料长")]
|
[DisplayFormat(DataFormatString="18,2")]
|
[Column(TypeName="decimal")]
|
[Editable(true)]
|
public decimal? materiel_long { get; set; }
|
|
/// <summary>
|
///物料宽
|
/// </summary>
|
[Display(Name ="物料宽")]
|
[DisplayFormat(DataFormatString="18,2")]
|
[Column(TypeName="decimal")]
|
[Editable(true)]
|
public decimal? materiel_width { get; set; }
|
|
/// <summary>
|
///物料高
|
/// </summary>
|
[Display(Name ="物料高")]
|
[DisplayFormat(DataFormatString="18,2")]
|
[Column(TypeName="decimal")]
|
[Editable(true)]
|
public decimal? materiel_height { get; set; }
|
|
/// <summary>
|
///托盘长
|
/// </summary>
|
[Display(Name ="托盘长")]
|
[DisplayFormat(DataFormatString="18,2")]
|
[Column(TypeName="decimal")]
|
[Editable(true)]
|
public decimal? materiel_palletlong { get; set; }
|
|
/// <summary>
|
///托盘宽
|
/// </summary>
|
[Display(Name ="托盘宽")]
|
[DisplayFormat(DataFormatString="18,2")]
|
[Column(TypeName="decimal")]
|
[Editable(true)]
|
public decimal? materiel_palletwidth { get; set; }
|
|
/// <summary>
|
///托盘高
|
/// </summary>
|
[Display(Name ="托盘高")]
|
[DisplayFormat(DataFormatString="18,2")]
|
[Column(TypeName="decimal")]
|
[Editable(true)]
|
public decimal? materiel_palletheight { get; set; }
|
|
/// <summary>
|
///库存地点
|
/// </summary>
|
[Display(Name ="库存地点")]
|
[MaxLength(20)]
|
[Column(TypeName="nvarchar(20)")]
|
[Editable(true)]
|
public string materiel_location { get; set; }
|
|
/// <summary>
|
///
|
/// </summary>
|
[Key]
|
[Display(Name ="ID")]
|
[Column(TypeName="int")]
|
[Editable(true)]
|
[Required(AllowEmptyStrings=false)]
|
public int ID { get; set; }
|
|
|
}
|
}
|
