Estsh-Yiri/Estsh.Core.Model/Models/SysLocate.cs

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

namespace Estsh.Core.Models
{
    /// <summary>
    /// ，数据实体对象
    /// </summary>
    [Table("sys_locate")]
    [Serializable]
    public class SysLocate : BaseEntity
    {
        [Column("locate_id")]
        [DisplayName("库位编号")]
        public int LocateId { get; set; }

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

        [Column("locate_desc")]
        [DisplayName("库位描述")]
        public string LocateDesc { get; set; }

        [Column("locate_type")]
        [DisplayName("库位类型")]
        public int LocateType { get; set; }

        [Column("locate_capacity")]
        [DisplayName("库位容量")]
        public decimal? LocateCapacity { get; set; }

        [Column("max_locate_qty")]
        [DisplayName(" ")]
        public decimal? MaxLocateQty { get; set; }

        [Column("min_locate_qty")]
        [DisplayName(" ")]
        public decimal? MinLocateQty { get; set; }

        [Column("locate_size")]
        [DisplayName("库位大小（尺寸）")]
        public string LocateSize { get; set; }

        [Column("locate_empty")]
        [DisplayName("是否空库位")]
        public string LocateEmpty { get; set; }

        [Column("locate_distance")]
        [DisplayName("相对距离")]
        public decimal? LocateDistance { get; set; }

        [Column("wip_min_qty")]
        [DisplayName(" ")]
        public decimal? WipMinQty { 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; }

        #region 扩展字段

        [NotMapped]
        [Column("warehouse_desc")]
        [DisplayName(" ")]
        public string WarehouseDesc { get; set; }

        [NotMapped]
        [Column("zone_desc")]
        [DisplayName(" ")]
        public string ZoneDesc { get; set; }

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

        [NotMapped]
        [Column("locate_typeDesc")]
        [DisplayName(" ")]
        public string LocateTypeDesc { get; set; }

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

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

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

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

        [Column("carton_num")]
        [DisplayName(" ")]
        public int cartonNum { get; set; }

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

        [Column("pdline_code")]
        [DisplayName(" ")]
        public string PdlineCode { get; set; }

        [Column("src_warehouse_id")]
        [DisplayName(" ")]
        public int SrcWarehouseId { get; set; }

        [Column("src_warehouse_name")]
        [DisplayName(" ")]
        public int SrcWarehouseName { get; set; }

        [Column("src_zone_id")]
        [DisplayName(" ")]
        public int SrcZoneId { get; set; }

        [Column("src_zone_name")]
        [DisplayName(" ")]
        public int SrcZoneName { get; set; }

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

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