using Magicodes.ExporterAndImporter.Core;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WIDESEA_Core.DB.Models;

namespace WIDESEA_Model.Models
{
    [SugarTable(nameof(VV_PalletStockInfo), "库存信息")]
    public class VV_PalletStockInfo : BaseEntity
    {
        /// <summary>
        /// 主键
        /// </summary>
        [ImporterHeader(Name = "主键")]
        [ExporterHeader(DisplayName = "主键")]
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "主键")]
        public int Id { get; set; }

        /// <summary>
        /// 托盘编号
        /// </summary>
        [ImporterHeader(Name = "托盘编号")]
        [ExporterHeader(DisplayName = "托盘编号")]
        [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "托盘编号")]
        public string PalletCode { get; set; }

        /// <summary>
        /// 货位编号
        /// </summary>
        [ImporterHeader(Name = "货位编号")]
        [ExporterHeader(DisplayName = "货位编号")]
        [SugarColumn(IsNullable = true, Length = 20, ColumnDescription = "货位编号")]
        public string LocationCode { get; set; }

        /// <summary>
        /// 区域编码
        /// </summary>
        [ImporterHeader(Name = "区域编码")]
        [ExporterHeader(DisplayName = "区域编码")]
        [SugarColumn(IsNullable = true, ColumnDescription = "区域编码")]
        public string AreaCode { get; set; }

        /// <summary>
        /// 库存状态
        /// </summary>
        [ImporterHeader(Name = "库存状态")]
        [ExporterHeader(DisplayName = "库存状态")]
        [SugarColumn(IsNullable = true, ColumnDescription = "库存状态")]
        public int StockStatus { get; set; }

        ///// <summary>
        ///// 库存明细
        ///// </summary>
        //[SugarColumn(ColumnName = "StockInfoDetails")]
        //[Navigate(NavigateType.OneToMany, nameof(Dt_PalletStockInfoDetail.StockId))]
        //public List<Dt_PalletStockInfoDetail>? StockInfoDetails { get; set; }

        /// <summary>
        /// 库存信息主键
        /// </summary>
        [SugarColumn(IsNullable = false, ColumnDescription = "库存信息主键")]
        public int StockId { get; set; }

        /// <summary>
        /// 物料编号
        /// </summary>
        [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "物料编号")]
        public string MaterielCode { get; set; }

        /// <summary>
        /// 物料名称
        /// </summary>
        [SugarColumn(IsNullable = false, Length = 200, ColumnDescription = "物料名称")]
        public string MaterielName { get; set; }

        /// <summary>
        /// 库存数量
        /// </summary>
        [SugarColumn(IsNullable = false, DecimalDigits = 2, ColumnDescription = "库存数量")]
        public decimal Quantity { get; set; }
    }
}