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

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

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

        [Column("warehouse_id")]
        [DisplayName(" ")]
        public int? WarehouseId { get; set; }

        [Column("warehouse_name")]
        [DisplayName(" ")]
        public string WarehouseName { get; set; }

        [Column("zone_id")]
        [DisplayName(" ")]
        public int? ZoneId { get; set; }

        [Column("zone_name")]
        [DisplayName(" ")]
        public string ZoneName { get; set; }

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

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

        [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("carton_no")]
        [DisplayName(" ")]
        public string CartonNo { get; set; }

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

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

        [Column("sn_status")]
        [DisplayName(" ")]
        public string SnStatus { get; set; }

        [Column("trans_status")]
        [DisplayName(" ")]
        public int TransStatus { get; set; }

        [Column("fact_qty")]
        [DisplayName(" ")]
        public decimal? FactQty { get; set; }

        [Column("dest_warehouse_id")]
        [DisplayName(" ")]
        public int? DestWarehouseId { get; set; }

        [Column("dest_warehouse_name")]
        [DisplayName(" ")]
        public string DestWarehouseName { get; set; }

        [Column("dest_zone_id")]
        [DisplayName(" ")]
        public int? DestZoneId { get; set; }

        [Column("dest_zone_name")]
        [DisplayName(" ")]
        public string DestZoneName { get; set; }

        [Column("dest_locate_id")]
        [DisplayName(" ")]
        public int? DestLocateId { get; set; }

        [Column("dest_locate_name")]
        [DisplayName(" ")]
        public string DestLocateName { get; set; }

        [Column("up_trans_status")]
        [DisplayName(" ")]
        public int UpTransStatus { get; set; }

        [Column("up_fact_qty")]
        [DisplayName(" ")]
        public decimal? UpFactQty { get; set; }

        [Column("up_dest_warehouse_id")]
        [DisplayName(" ")]
        public int? UpDestWarehouseId { get; set; }

        [Column("up_dest_warehouse_name")]
        [DisplayName(" ")]
        public string UpDestWarehouseName { get; set; }

        [Column("up_dest_zone_id")]
        [DisplayName(" ")]
        public int? UpDestZoneId { get; set; }

        [Column("up_dest_zone_name")]
        [DisplayName(" ")]
        public string UpDestZoneName { get; set; }

        [Column("up_dest_locate_id")]
        [DisplayName(" ")]
        public int? UpDestLocateId { get; set; }

        [Column("up_dest_locate_name")]
        [DisplayName(" ")]
        public string UpDestLocateName { get; set; }

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

        [Column("rack_no")]
        [DisplayName(" ")]
        public string RackNo { get; set; }

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

        [NotMapped]
        [Column("trans_status_desc")]
        [DisplayName(" ")]
        public string TransStatusDesc { get; set; }

        [NotMapped]
        [Column("up_trans_status_desc")]
        [DisplayName(" ")]
        public string UpTransStatusDesc { get; set; }

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

        [Column("dest_erp_warehouse")]
        [DisplayName(" ")]
        public string DestErpWarehouse { get; set; }

        [Column("locate_type")]
        [DisplayName(" ")]
        public int? LocateType { get; set; }
        #endregion
    }
}