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

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

        [Column("order_no")]
        [DisplayName(" ")]
        public string OrderNo { get; set; }

        [Column("weekly_order_no")]
        [DisplayName(" ")]
        public string WeeklyOrderNo { get; set; }

        [Column("type_id")]
        [DisplayName(" ")]
        public int? TypeId { get; set; }

        [Column("buy_no")]
        [DisplayName(" ")]
        public string BuyNo { get; set; }

        [Column("buy_item")]
        [DisplayName(" ")]
        public int? BuyItem { get; set; }

        [Column("gr_type")]
        [DisplayName(" ")]
        public string GrType { get; set; }

        [Column("buy_type")]
        [DisplayName(" ")]
        public string BuyType { get; set; }

        [Column("buy_version")]
        [DisplayName(" ")]
        public string BuyVersion { get; set; }

        [Column("vendor_id")]
        [DisplayName(" ")]
        public int? VendorId { get; set; }

        [Column("se_date")]
        [DisplayName(" ")]
        public string SeDate { get; set; }

        [Column("se_time")]
        [DisplayName(" ")]
        public string SeTime { get; set; }

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

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

        [Column("carton_no")]
        [DisplayName(" ")]
        public string CartonNo { get; set; }

        [Column("lot_no")]
        [DisplayName(" ")]
        public string LotNo { get; set; }

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

        [Column("snp_qty")]
        [DisplayName(" ")]
        public decimal SnpQty { get; set; }

        [Column("plan_qty")]
        [DisplayName(" ")]
        public decimal PlanQty { get; set; }

        [Column("trans_qty")]
        [DisplayName(" ")]
        public decimal TransQty { get; set; }

        [Column("status")]
        [DisplayName(" ")]
        public string Status { get; set; }

        [Column("iss_seq")]
        [DisplayName(" ")]
        public string IssSeq { get; set; }

        [Column("group_no")]
        [DisplayName(" ")]
        public string GroupNo { get; set; }

        [Column("locate_id")]
        [DisplayName(" ")]
        public int? LocateId { get; set; }

        [Column("erp_warehouse")]
        [DisplayName(" ")]
        public string ErpWarehouse { get; set; }

        [Column("date_code")]
        [DisplayName(" ")]
        public string DateCode { get; set; }

        [Column("type")]
        [DisplayName(" ")]
        public string Type { get; set; }

        [Column("prd_lot_no")]
        [DisplayName(" ")]
        public string PrdLotNo { get; set; }

        [Column("ship_no")]
        [DisplayName(" ")]
        public string ShipNo { get; set; }

        [Column("version_no")]
        [DisplayName(" ")]
        public string VersionNo { get; set; }

        [Column("pick_no")]
        [DisplayName(" ")]
        public string PickNo { get; set; }

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

        [Column("dock")]
        [DisplayName(" ")]
        public string Dock { get; set; }

        [Column("sta_order_no")]
        [DisplayName(" ")]
        public string StaOrderNo { get; set; }

        [Column("create_time")]
        [DisplayName(" ")]
        public DateTime? CreateTime { get; set; }

        #region 扩展字段
        [NotMapped]
        [Column("vendor_code")]
        [DisplayName(" ")]
        public string VendorCode { get; set; }
        [NotMapped]
        [Column("vendor_name")]
        [DisplayName(" ")]
        public string VendorName { get; set; }

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

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

        [NotMapped]
        [Column("locate_desc")]
        [DisplayName(" ")]
        public string LocateDesc { get; set; }

        [NotMapped]
        [Column("factory_name")]
        [DisplayName(" ")]
        public string FactoryName { get; set; }

        [NotMapped]
        [Column("emp_no")]
        [DisplayName(" ")]
        public string EmpNo { get; set; }

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

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