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

namespace Estsh.Core.Models
{
    /// <summary>
    /// ，数据实体对象
    /// </summary>
    [Table("g_sn_status")]
    [Serializable]
    public class GSnStatus : BaseEntity
    {
        [Column("ruid")]
        [DisplayName(" ")]
        public int Ruid { get; set; }

        [Column("seq")]
        [DisplayName(" ")]
        public int? Seq { get; set; }

        [Column("workorder")]
        [DisplayName("工单号码")]
        public string Workorder { get; set; }

        [Column("wo_detail_id")]
        [DisplayName(" ")]
        public int WoDetailId { get; set; }

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

        [Column("csn")]
        [DisplayName(" ")]
        public string Csn { get; set; }

        [Column("part_id")]
        [DisplayName(" ")]
        public int? PartId { get; set; }

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

        [Column("pdline_id")]
        [DisplayName(" ")]
        public int? PdlineId { get; set; }

        [Column("stage_id")]
        [DisplayName(" ")]
        public int? StageId { get; set; }

        [Column("process_id")]
        [DisplayName(" ")]
        public int? ProcessId { get; set; }

        [Column("terminal_id")]
        [DisplayName(" ")]
        public int? TerminalId { get; set; }

        [Column("next_process")]
        [DisplayName(" ")]
        public int? NextProcess { get; set; }

        [Column("wip_process")]
        [DisplayName(" ")]
        public int? WipProcess { get; set; }

        [Column("current_status")]
        [DisplayName(" ")]
        public int? CurrentStatus { get; set; }

        [Column("work_flag")]
        [DisplayName(" ")]
        public int? WorkFlag { get; set; }

        [Column("in_process_time")]
        [DisplayName(" ")]
        public DateTime? InProcessTime { get; set; }

        [Column("qc_no")]
        [DisplayName(" ")]
        public string QcNo { get; set; }

        [Column("qc_result")]
        [DisplayName(" ")]
        public string QcResult { get; set; }

        [Column("rework_no")]
        [DisplayName(" ")]
        public string ReworkNo { get; set; }

        [Column("out_process_time")]
        [DisplayName(" ")]
        public DateTime? OutProcessTime { get; set; }

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

        [Column("in_pdline_time")]
        [DisplayName(" ")]
        public DateTime? InPdlineTime { get; set; }

        [Column("out_pdline_time")]
        [DisplayName(" ")]
        public DateTime? OutPdlineTime { get; set; }

        [Column("shipping_time")]
        [DisplayName(" ")]
        public DateTime? ShippingTime { get; set; }

        [Column("car_no")]
        [DisplayName(" ")]
        public string CarNo { get; set; }

        [Column("slot_no")]
        [DisplayName(" ")]
        public int SlotNo { get; set; }

        [Column("prod_type")]
        [DisplayName(" ")]
        public string ProdType { get; set; }

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

        #region 扩展字段
        [NotMapped]
        [Column("lsn")]
        [DisplayName(" ")]
        public string Lsn { get; set; }

        [NotMapped]
        [Column("type_name")]
        [DisplayName(" ")]
        public string TypeName { get; set; }

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

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

        [NotMapped]
        [Column("part_spec")]
        [DisplayName(" ")]
        public string PartSpec { get; set; }

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

        [NotMapped]
        [Column("pdline_name")]
        [DisplayName(" ")]
        public string PdlineName { get; set; }

        [NotMapped]
        [Column("cust_part_no")]
        [DisplayName(" ")]
        public string CustPartNo { get; set; }

        [NotMapped]
        [Column("utime")]
        [DisplayName(" ")]
        public string Utime { get; set; }

        [NotMapped]
        [Column("ctime")]
        [DisplayName(" ")]
        public string Ctime { get; set; }

        [NotMapped]
        [Column("stype")]
        [DisplayName(" ")]
        public string Stype { get; set; }

        [NotMapped]
        [Column("shpCarNO")]
        [DisplayName(" ")]
        public string ShpCarNO { get; set; }

        
        #endregion
    }
}