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

namespace Estsh.Core.Models
{
    /// <summary>
    /// ，数据实体对象
    /// </summary>
    [Table("sys_stock_trans")]
    [Serializable]
    public class SysStockTrans : BaseEntity
    {
        [Column("trans_code")]
        [DisplayName(" ")]
        public string TransCode { get; set; }

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

        [Column("src_locate_name")]
        [DisplayName(" ")]
        public string SrcLocateName { get; set; }

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

        [Column("desc_locate_name")]
        [DisplayName(" ")]
        public string DescLocateName { get; set; }

        [Column("old_qty")]
        [DisplayName(" ")]
        public decimal OldQty { get; set; }

        [Column("new_qty")]
        [DisplayName(" ")]
        public decimal NewQty { get; set; }

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

        [Column("old_status")]
        [DisplayName(" ")]
        public string OldStatus { get; set; }

        [Column("new_status")]
        [DisplayName(" ")]
        public string NewStatus { get; set; }

        [Column("old_qms_status")]
        [DisplayName(" ")]
        public string OldQmsStatus { get; set; }

        [Column("new_qms_status")]
        [DisplayName(" ")]
        public string NewQmsStatus { get; set; }

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

        [Column("src_erp_warehouse")]
        [DisplayName(" ")]
        public string SrcErpWarehouse { get; set; }

        [Column("desc_erp_warehouse")]
        [DisplayName(" ")]
        public string DescErpWarehouse { get; set; }

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

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

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

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

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

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

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

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

        [Column("update_time")]
        [DisplayName(" ")]
        public string UpdateTime { get; set; }

        [Column("create_time")]
        [DisplayName(" ")]
        public string CreateTime { get; set; }
         
        [Column("order_type")]
        [DisplayName(" ")]
        public string OrderType { get; set; }

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

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

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

        [NotMapped]
        [Column("Sumold_qty")]
        [DisplayName(" ")]
        public int SumoldQty { get; set; }

        [NotMapped]
        [Column("Sumnew_qty")]
        [DisplayName(" ")]
        public int SumnewQty { get; set; }

        [NotMapped]
        [Column("sum_trans_qty")]
        [DisplayName(" ")]
        public int SumTransQty { get; set; }

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

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

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

        [NotMapped]
        [Column("total_bzqty")]
        [DisplayName(" ")]
        public int TotalBzqty { get; set; }

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

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

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

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

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

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

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

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

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

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

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

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

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