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(DtStockInfo), "库存信息")]
    public class DtStockInfo : 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 = "货位ID")]
        [ExporterHeader(DisplayName = "货位ID")]
        [SugarColumn(IsNullable = true, ColumnDescription = "货位ID")]
        public int LocationId { 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 = false, ColumnDescription = "是否满盘", DefaultValue = "0")]
        public bool IsFull { get; set; }

        /// <summary>
        /// 备注 (静制\陈化时间)
        /// </summary>
        [ImporterHeader(Name = "电芯数量")]
        [ExporterHeader(DisplayName = "电芯数量")]
        [SugarColumn(IsNullable = true, ColumnDescription = "电芯数量")]
        public string Remark { get; set; }

        /// <summary>
        /// 关联工序返回时间（注液\静置时长）
        /// </summary>
        [ImporterHeader(Name = "工序返回时间")]
        [ExporterHeader(DisplayName = "工序返回时间")]
        public string LinedProcessFeedbackTime { get; set; }

        /// <summary>
        /// 特征参数返回(静置时长)
        /// </summary>
        [ImporterHeader(Name = "静置时长")]
        [ExporterHeader(DisplayName = "静置时长")]
        public string SpecialParameterDuration { get; set; }

        /// <summary>
        /// 生产产线
        /// </summary>
        [ImporterHeader(Name = "生产产线")]
        [ExporterHeader(DisplayName = "生产产线")]
        [SugarColumn(IsNullable = true, ColumnDescription = "生产产线")]
        public string ProductionLine { 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 DateTime? OutboundTime { get; set; }

        /// <summary>
        /// 参数信息
        /// </summary>
        [ImporterHeader(Name = "参数信息")]
        [ExporterHeader(DisplayName = "参数信息")]
        [SugarColumn(IsNullable = true, ColumnDescription = "参数信息")]
        public string ParameterInfos {  get; set; }

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

        /// <summary>
        /// 当前工序
        /// </summary>
        [ImporterHeader(Name = "当前工序")]
        [ExporterHeader(DisplayName = "当前工序")]
        [SugarColumn(IsNullable = true, ColumnDescription = "当前工序")]
        public string ProcessCode { get; set; }

        /// <summary>
        /// 下一工序
        /// </summary>
        [ImporterHeader(Name = "下一工序")]
        [ExporterHeader(DisplayName = "下一工序")]
        [SugarColumn(IsNullable = true, ColumnDescription = "下一工序")]
        public string NextProcessCode { 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(LocationId), nameof(DtLocationInfo.Id))]
        public DtLocationInfo? LocationInfo { get; set; }
    }
}