using Magicodes.ExporterAndImporter.Core;
using Masuit.Tools.Core.Validator;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WIDESEA_Core.DB.Models;

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

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

        /// <summary>
        /// 货位编码
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDescription = "货位编码")]
        public string LocationCode { get; set; }

        /// <summary>
        /// 是否整出
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDescription = "是否整出")]
        public bool IsFullExit { get; set; } = true;

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

        /// <summary>
        /// 单据编号
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDescription = "单据编号")]
        public string OrderNo { get; set; }

        /// <summary>
        /// 单据类型
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDescription = "单据类型")]
        public string OrderType { get; set; }

        /// <summary>
        /// 备注
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDescription = "备注")]
        public string Remark { get; set; }

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

        /// <summary>
        /// 货位数据
        /// </summary>
        [SugarColumn(ColumnName = "LocationInfo")]
        [Navigate(NavigateType.OneToOne, nameof(LocationCode), nameof(DtLocationInfo.LocationCode))]
        public DtLocationInfo? LocationInfo { get; set; }
    }
}