/*
 *代码由框架生成,任何更改都可能导致被代码生成器覆盖
 *如果数据库字段发生变化，请在代码生器重新生成此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)]
       [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int ID { get; set; }

       
    }
}