/*
 *代码由框架生成,任何更改都可能导致被代码生成器覆盖
 *如果数据库字段发生变化，请在代码生器重新生成此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 = "VV_ContainerInfo")]
    public class VV_ContainerInfo : BaseEntity
    {
        /// <summary>
        ///主键ID
        /// </summary>
        [Key]
        [Display(Name = "主键ID")]
        [Column(TypeName = "uniqueidentifier")]
        [Required(AllowEmptyStrings = false)]
        public Guid containerdtl_id { get; set; }

        /// <summary>
        ///容器头id
        /// </summary>
        [Display(Name = "容器头id")]
        [Column(TypeName = "uniqueidentifier")]
        [Required(AllowEmptyStrings = false)]
        public Guid containerhead_id { get; set; }

        /// <summary>
        ///库区/区域ID
        /// </summary>
        [Display(Name = "库区/区域ID")]
        [MaxLength(80)]
        [Column(TypeName = "nvarchar(80)")]
        public string containerhead_areaid { get; set; }

        /// <summary>
        ///托盘号
        /// </summary>
        [Display(Name = "托盘号")]
        [MaxLength(100)]
        [Column(TypeName = "nvarchar(100)")]
        [Required(AllowEmptyStrings = false)]
        public string containerhead_barcode { get; set; }

        /// <summary>
        ///物料名称
        /// </summary>
        [Display(Name = "物料名称")]
        [MaxLength(400)]
        [Column(TypeName = "nvarchar(400)")]
        [Required(AllowEmptyStrings = false)]
        public string materiel_name { get; set; }

        /// <summary>
        ///物料id
        /// </summary>
        [Display(Name = "物料id")]
        [MaxLength(200)]
        [Column(TypeName = "nvarchar(200)")]
        [Required(AllowEmptyStrings = false)]
        public string materiel_id { get; set; }

        /// <summary>
        ///物料类型
        /// </summary>
        [Display(Name = "物料类型")]
        [MaxLength(40)]
        [Column(TypeName = "nvarchar(40)")]
        public string materiel_type { get; set; }

        /// <summary>
        ///计量单位
        /// </summary>
        [Display(Name = "计量单位")]
        [MaxLength(20)]
        [Column(TypeName = "nvarchar(20)")]
        public string materiel_unit { get; set; }

        /// <summary>
        ///货位id
        /// </summary>
        [Display(Name = "货位id")]
        [MaxLength(510)]
        [Column(TypeName = "nvarchar(510)")]
        public string location_id { get; set; }

        /// <summary>
        ///货位状态
        /// </summary>
        [Display(Name = "货位状态")]
        [MaxLength(510)]
        [Column(TypeName = "nvarchar(510)")]
        public string location_state { get; set; }

        /// <summary>
        ///货位是否锁定
        /// </summary>
        [Display(Name = "货位是否锁定")]
        [Column(TypeName = "bit")]
        [Required(AllowEmptyStrings = false)]
        public bool location_islocked { get; set; }

        /// <summary>
        ///行
        /// </summary>
        [Display(Name = "行")]
        [Column(TypeName = "int")]
        [Required(AllowEmptyStrings = false)]
        public int location_line { get; set; }

        /// <summary>
        ///列
        /// </summary>
        [Display(Name = "列")]
        [Column(TypeName = "int")]
        [Required(AllowEmptyStrings = false)]
        public int location_column { get; set; }

        /// <summary>
        ///层
        /// </summary>
        [Display(Name = "层")]
        [Column(TypeName = "int")]
        [Required(AllowEmptyStrings = false)]
        public int location_layer { get; set; }

        /// <summary>
        ///创建者
        /// </summary>
        [Display(Name = "创建者")]
        [MaxLength(255)]
        [Column(TypeName = "varchar(255)")]
        public string containerdtl_creator { get; set; }

        /// <summary>
        ///创建时间
        /// </summary>
        [Display(Name = "创建时间")]
        [Column(TypeName = "datetime")]
        public DateTime? containerdtl_createtime { get; set; }

        /// <summary>
        ///预留1
        /// </summary>
        [Display(Name = "预留1")]
        [MaxLength(100)]
        [Column(TypeName = "nvarchar(100)")]
        public string containerdtl_text1 { get; set; }

        /// <summary>
        ///预留2
        /// </summary>
        [Display(Name = "预留2")]
        [MaxLength(100)]
        [Column(TypeName = "nvarchar(100)")]
        public string containerdtl_text2 { get; set; }

        /// <summary>
        ///预留3
        /// </summary>
        [Display(Name = "预留3")]
        [MaxLength(100)]
        [Column(TypeName = "nvarchar(100)")]
        public string containerdtl_text3 { get; set; }

        /// <summary>
        ///后挡内径合格否
        /// </summary>
        [Display(Name = "后挡内径合格否")]
        [MaxLength(40)]
        [Column(TypeName = "nvarchar(40)")]
        public string csize_four_result { get; set; }

        /// <summary>
        ///油档测量结果
        /// </summary>
        [Display(Name = "油档测量结果")]
        [MaxLength(40)]
        [Column(TypeName = "nvarchar(40)")]
        public string csize_three_result { get; set; }

        /// <summary>
        ///轴承外径结果
        /// </summary>
        [Display(Name = "轴承外径结果")]
        [MaxLength(40)]
        [Column(TypeName = "nvarchar(40)")]
        public string csize_out_value { get; set; }

        /// <summary>
        ///
        /// </summary>
        [Display(Name = "containerhead_requstkey")]
        [MaxLength(200)]
        [Column(TypeName = "nvarchar(200)")]
        public string containerhead_requstkey { get; set; }

        /// <summary>
        ///深度
        /// </summary>
        [Display(Name = "深度")]
        [Column(TypeName = "int")]
        public int? location_deep { get; set; }

        /// <summary>
        ///物料ID
        /// </summary>
        [Display(Name = "物料ID")]
        [MaxLength(80)]
        [Column(TypeName = "nvarchar(80)")]
        [Required(AllowEmptyStrings = false)]
        public string containerdtl_materielid { get; set; }

        /// <summary>
        ///
        /// </summary>
        [Display(Name = "containerdtl_requstkey")]
        [MaxLength(80)]
        [Column(TypeName = "nvarchar(80)")]
        public string containerdtl_requstkey { get; set; }

        /// <summary>
        ///操作者
        /// </summary>
        [Display(Name = "操作者")]
        [MaxLength(20)]
        [Column(TypeName = "nvarchar(20)")]
        public string containerdtl_operator { get; set; }

        /// <summary>
        ///轴承识别号
        /// </summary>
        [Display(Name = "轴承识别号")]
        [MaxLength(100)]
        [Column(TypeName = "nvarchar(100)")]
        public string containerdtl_identifierNo { get; set; }

        /// <summary>
        ///收入单位
        /// </summary>
        [Display(Name = "收入单位")]
        [MaxLength(100)]
        [Column(TypeName = "nvarchar(100)")]
        public string containerdtl_inboundUnit { get; set; }

        /// <summary>
        ///测量标准
        /// </summary>
        [Display(Name = "测量标准")]
        [MaxLength(100)]
        [Column(TypeName = "nvarchar(100)")]
        public string containerdtl_standard { get; set; }

        /// <summary>
        ///车型
        /// </summary>
        [Display(Name = "车型")]
        [Column(TypeName = "nvarchar(100)")]
        public string containerdtl_carType { get; set; }

        /// <summary>
        ///轴承型号
        /// </summary>
        [Display(Name = "轴承型号")]
        [Column(TypeName = "nvarchar(100)")]
        public string containerdtl_type { get; set; }

        /// <summary>
        ///托盘条码
        /// </summary>
        [Display(Name = "托盘条码")]
        [MaxLength(80)]
        [Column(TypeName = "nvarchar(80)")]
        public string containerdtl_barcode { get; set; }

        /// <summary>
        ///制造单位
        /// </summary>
        [Display(Name = "制造单位")]
        [MaxLength(40)]
        [Column(TypeName = "nvarchar(40)")]
        public string containerdtl_madeUnit { get; set; }

        /// <summary>
        ///制造日期
        /// </summary>
        [Display(Name = "制造日期")]
        [Column(TypeName = "datetime")]
        public DateTime? containerdtl_madeDate { get; set; }

        /// <summary>
        ///轴承编号
        /// </summary>
        [Display(Name = "轴承编号")]
        [MaxLength(100)]
        [Column(TypeName = "nvarchar(100)")]
        public string containerdtl_number { get; set; }

        /// <summary>
        ///轴承条码
        /// </summary>
        [Display(Name = "轴承条码")]
        [MaxLength(510)]
        [Column(TypeName = "nvarchar(510)")]
        public string containerdtl_goodsCode { get; set; }

        /// <summary>
        ///
        /// </summary>
        [Display(Name = "csize_container_detail_id")]
        [MaxLength(200)]
        [Column(TypeName = "nvarchar(200)")]
        [Required(AllowEmptyStrings = false)]
        public string csize_container_detail_id { get; set; }

        /// <summary>
        ///
        /// </summary>
        [Display(Name = "csize_barcode")]
        [MaxLength(100)]
        [Column(TypeName = "nvarchar(100)")]
        public string csize_barcode { get; set; }

        /// <summary>
        ///轴承内径值
        /// </summary>
        [Display(Name = "轴承内径值")]
        [MaxLength(40)]
        [Column(TypeName = "nvarchar(40)")]
        public string csize_in_value { get; set; }

        /// <summary>
        ///轴承内径结果
        /// </summary>
        [Display(Name = "轴承内径结果")]
        [MaxLength(40)]
        [Column(TypeName = "nvarchar(40)")]
        public string csize_in_result { get; set; }

        /// <summary>
        ///挡油内径平均值
        /// </summary>
        [Display(Name = "挡油内径平均值")]
        [MaxLength(40)]
        [Column(TypeName = "nvarchar(40)")]
        public string csize_three_3 { get; set; }

        /// <summary>
        ///后挡内径平均值
        /// </summary>
        [Display(Name = "后挡内径平均值")]
        [MaxLength(40)]
        [Column(TypeName = "nvarchar(40)")]
        public string csize_four_3 { get; set; }

        /// <summary>
        ///轴承外径结果
        /// </summary>
        [Display(Name = "轴承外径结果")]
        [MaxLength(40)]
        [Column(TypeName = "nvarchar(40)")]
        public string csize_out_result { get; set; }

        /// <summary>
        ///入库时间
        /// </summary>
        [Display(Name = "入库时间")]
        [Column(TypeName = "datetime")]
        [Required(AllowEmptyStrings = false)]
        public DateTime containerhead_createtime { get; set; }

        /// <summary>
        ///空托重量
        /// </summary>
        [Display(Name = "空托重量")]
        [MaxLength(50)]
        [Column(TypeName = "nvarchar(50)")]
        public string containerhead_palletweight { get; set; }

        /// <summary>
        ///实托重量
        /// </summary>
        [Display(Name = "实托重量")]
        [MaxLength(255)]
        [Column(TypeName = "nvarchar(255)")]
        public string containerdtl_goodsWeight { get; set; }

        /// <summary>
        ///称重结果
        /// </summary>
        [Display(Name = "称重结果")]
        [DisplayFormat(DataFormatString = "18,2")]
        [Column(TypeName = "decimal")]
        [Editable(true)]
        public decimal? containerdtl_standardResult { get; set; }

        /// <summary>
        ///入库时长
        /// </summary>
        [Display(Name = "入库时长")]
        [MaxLength(255)]
        [Column(TypeName = "nvarchar(255)")]
        public string DateDiffResult { get; set; }


        /// <summary>
        /// 质检确认
        /// </summary>
        [Display(Name = "质检确认")]
        [Column(TypeName = "bit")]
        [Editable(true)]
        public bool? containerdtl_qualityCheck { get; set; }

        /// <summary>
        ///质检确认时间
        /// </summary>
        [Display(Name = "质检确认时间")]
        [Column(TypeName = "datetime")]
        public DateTime? containerdtl_qualityCheckTime { get; set; }

        /// <summary>
        ///质检确认人
        /// </summary>
        [Display(Name = "质检确认人")]
        [MaxLength(40)]
        [Column(TypeName = "nvarchar(40)")]
        public string containerdtl_qualityCheckUser { get; set; }

        /// <summary>
        /// 收货确认
        /// </summary>
        [Display(Name = "收货确认")]
        [Column(TypeName = "bit")]
        [Editable(true)]
        public bool? containerdtl_takeGoogsCheck { get; set; }

        /// <summary>
        ///收货确认时间
        /// </summary>
        [Display(Name = "收货确认时间")]
        [Column(TypeName = "datetime")]
        public DateTime? containerdtl_takeGoogsCheckTime { get; set; }

        /// <summary>
        ///收货确认人
        /// </summary>
        [Display(Name = "收货确认人")]
        [MaxLength(40)]
        [Column(TypeName = "nvarchar(40)")]
        public string containerdtl_takeGoogsCheckUser { get; set; }

        [Display(Name = "测量货位是否异常")]
        [MaxLength(50)]
        [Column(TypeName = "nvarcher(50)")]

        public string containerdtl_isError { get; set; }

        /// <summary>
        /// 批次
        /// </summary>
        [Display(Name = "批次")]
        [MaxLength(20)]
        [Column(TypeName = "varchar(20)")]
        public string containerdtl_lotNumber { get; set; }

        /// <summary>
        /// 生产日期
        /// </summary>
        [Display(Name = "生产日期")]
        [MaxLength(30)]
        [Column(TypeName = "nvarchar(30)")]
        public string containerdtl_ProductDate { get; set; }

    }
}