using Estsh.Core.Base;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations.Schema;

namespace Estsh.Core.Models
{
    /// <summary>
    /// ，数据实体对象
    /// </summary>
    [Table("sys_part")]
    [Serializable]
    public class SysPart : BaseEntity
    {
        [Column("part_id")]
        [DisplayName("零件编号")]
        public int PartId { get; set; }

        [Column("part_no")]
        [DisplayName("零件号")]
        public string PartNo { get; set; }

        [Column("part_spec")]
        [DisplayName("零件描述")]
        public string PartSpec { get; set; }

        [Column("part_spec2")]
        [DisplayName(" ")]
        public string PartSpec2 { get; set; }

        [Column("part_location")]
        [DisplayName("零件位置")]
        public string PartLocation { get; set; }

        [Column("part_type")]
        [DisplayName("零件类型")]
        public string PartType { get; set; }

        [Column("part_class")]
        [DisplayName(" ")]
        public string PartClass { get; set; }

        [Column("model_id")]
        [DisplayName("车型编号")]
        public int? ModelId { get; set; }

        [Column("label_file")]
        [DisplayName("标签文件的文件名")]
        public string LabelFile { get; set; }

        [Column("label_type")]
        [DisplayName("标签类型")]
        public string LabelType { get; set; }

        [Column("label_qty")]
        [DisplayName("条码打印的份数")]
        public int? LabelQty { get; set; }

        [Column("rule_set")]
        [DisplayName("条码规则（目前为生成条码的存储过程名）")]
        public string RuleSet { get; set; }

        [Column("unit")]
        [DisplayName("单位")]
        public string Unit { get; set; }

        [Column("route_id")]
        [DisplayName("流程编号")]
        public int? RouteId { get; set; }

        [Column("upc_code")]
        [DisplayName("UPC 代码")]
        public string UpcCode { get; set; }

        [Column("ucc_code")]
        [DisplayName("UCC 代码")]
        public string UccCode { get; set; }

        [Column("ean_code")]
        [DisplayName("EAN 代码")]
        public string EanCode { get; set; }

        [Column("burnin_time")]
        [DisplayName("烧机时间")]
        public int? BurninTime { get; set; }

        [Column("version")]
        [DisplayName("版本")]
        public string Version { get; set; }

        [Column("mfger_id")]
        [DisplayName("制造商编号")]
        public int? MfgerId { get; set; }

        [Column("subboard_qty")]
        [DisplayName("连板数量")]
        public int? SubboardQty { get; set; }

        [Column("split_flag")]
        [DisplayName("是否允许拆分")]
        public string SplitFlag { get; set; }

        [Column("batch_control")]
        [DisplayName("是否批次管控")]
        public string BatchControl { get; set; }

        [Column("min_pack_qty")]
        [DisplayName("最小包装数量")]
        public decimal? MinPackQty { get; set; }

        [Column("min_stock_qty")]
        [DisplayName("最低库存数量")]
        public decimal? MinStockQty { get; set; }

        [Column("max_stock_qty")]
        [DisplayName("最高库存数量")]
        public decimal? MaxStockQty { get; set; }

        [Column("wip_min_stock_qty")]
        [DisplayName(" ")]
        public decimal? WipMinStockQty { get; set; }

        [Column("indate_flag")]
        [DisplayName("是否管控有效期")]
        public string IndateFlag { get; set; }

        [Column("indate")]
        [DisplayName("有效期（天）")]
        public int? Indate { get; set; }

        [Column("sampling_plan_id")]
        [DisplayName("质检抽样计划编号")]
        public int? SamplingPlanId { get; set; }

        [Column("over_request")]
        [DisplayName("是否允许超领")]
        public string OverRequest { get; set; }

        [Column("default_box_qty")]
        [DisplayName("默认的每箱数量")]
        public decimal? DefaultBoxQty { get; set; }

        [Column("default_reel_qty")]
        [DisplayName("默认的每卷数量")]
        public decimal? DefaultReelQty { get; set; }

        [Column("default_set_qty")]
        [DisplayName("默认的每批数量")]
        public decimal? DefaultSetQty { get; set; }

        [Column("supply_type")]
        [DisplayName(" ")]
        public int? SupplyType { get; set; }

        [Column("settle_type")]
        [DisplayName(" ")]
        public int? SettleType { get; set; }

        [Column("recheck_cycle")]
        [DisplayName(" ")]
        public int? RecheckCycle { get; set; }

        [Column("instock_type")]
        [DisplayName(" ")]
        public string InstockType { get; set; }

        [Column("package_size")]
        [DisplayName(" ")]
        public string PackageSize { get; set; }

        [Column("part_abc")]
        [DisplayName(" ")]
        public string PartAbc { get; set; }

        [Column("part_group")]
        [DisplayName(" ")]
        public string PartGroup { get; set; }

        [Column("uom1")]
        [DisplayName(" ")]
        public string Uom1 { get; set; }

        [Column("coefficient1")]
        [DisplayName(" ")]
        public decimal? Coefficient1 { get; set; }

        [Column("uom2")]
        [DisplayName(" ")]
        public string Uom2 { get; set; }

        [Column("coefficient2")]
        [DisplayName(" ")]
        public decimal? Coefficient2 { get; set; }

        [Column("uom3")]
        [DisplayName(" ")]
        public string Uom3 { get; set; }

        [Column("coefficient3")]
        [DisplayName(" ")]
        public decimal? Coefficient3 { get; set; }

        [Column("mc_code")]
        [DisplayName(" ")]
        public string McCode { get; set; }

        [Column("is_sort")]
        [DisplayName(" ")]
        public int? IsSort { get; set; }

        [Column("sort_qty")]
        [DisplayName(" ")]
        public int? SortQty { get; set; }

        [Column("sort_type")]
        [DisplayName(" ")]
        public string SortType { get; set; }

        [Column("sort_seq")]
        [DisplayName(" ")]
        public int? SortSeq { get; set; }

        [Column("option1")]
        [DisplayName("预留字段")]
        public string Option1 { get; set; }

        [Column("option2")]
        [DisplayName("预留字段")]
        public string Option2 { get; set; }

        [Column("option3")]
        [DisplayName("预留字段")]
        public string Option3 { get; set; }

        [Column("option4")]
        [DisplayName("预留字段")]
        public string Option4 { get; set; }

        [Column("option5")]
        [DisplayName("预留字段")]
        public string Option5 { get; set; }

        [Column("option6")]
        [DisplayName("预留字段")]
        public string Option6 { get; set; }

        [Column("option7")]
        [DisplayName("预留字段")]
        public string Option7 { get; set; }

        [Column("option8")]
        [DisplayName("预留字段")]
        public string Option8 { get; set; }

        [Column("option9")]
        [DisplayName("预留字段")]
        public string Option9 { get; set; }

        [Column("option10")]
        [DisplayName("预留字段")]
        public string Option10 { get; set; }

        [Column("option11")]
        [DisplayName("预留字段")]
        public string Option11 { get; set; }

        [Column("option12")]
        [DisplayName("预留字段")]
        public string Option12 { get; set; }

        [Column("option13")]
        [DisplayName("预留字段")]
        public string Option13 { get; set; }

        [Column("option14")]
        [DisplayName("预留字段")]
        public string Option14 { get; set; }

        [Column("option15")]
        [DisplayName("预留字段")]
        public string Option15 { get; set; }

        [Column("BKLAS")]
        [DisplayName(" ")]
        public string Bklas { get; set; }

        [Column("remark")]
        [DisplayName(" ")]
        public string Remark { get; set; }

        [Column("is_exemption")]
        [DisplayName("是否免检")]
        public string IsExemption { get; set; }

        

        #region 扩展字段

        [NotMapped]
        [Column("vendor_id")]
        [DisplayName("供应商编号")]
        public int? VendorId { get; set; }

        [NotMapped]
        [Column("model_name")]
        [DisplayName(" ")]
        public string ModelName { get; set; }

        [NotMapped]
        [Column("route_name")]
        [DisplayName(" ")]
        public string RouteName { get; set; }

        [NotMapped]
        [Column("locate_id")]
        [DisplayName("库位编号")]
        public int? LocateId { get; set; }

        [NotMapped]
        [Column("locate_name")]
        [DisplayName(" ")]
        public string LocateName { get; set; }

        [NotMapped]
        [Column("enum_desc")]
        [DisplayName(" ")]
        public string EnumDesc { get; set; }

        [NotMapped]
        [Column("emp_name")]
        [DisplayName(" ")]
        public string EmpName { get; set; }

        [NotMapped]
        [Column("create_name")]
        [DisplayName(" ")]
        public string CreateName { get; set; }

        [NotMapped]
        [Column("qty")]
        [DisplayName(" ")]
        public string Qty { get; set; }

        [NotMapped]
        [Column("serial_number")]
        [DisplayName(" ")]
        public string SerialNumber { get; set; }
        #endregion

    }
}