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
{
    /// <summary>
    /// 原料/半成品纸卷库存信息
    /// </summary>
    [SugarTable(nameof(Dt_StockInfo), "原料/半成品纸卷库存信息")]
    [SugarIndex("unique_stockinfo_stockcode", nameof(PalletCode), OrderByType.Asc, true)]
    public class Dt_StockInfo : BaseEntity
    {
        /// <summary>
        /// 主键
        /// </summary>
        [ExporterHeader(DisplayName = "主键")]
        [ImporterHeader(Name = "主键")]
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "主键")]
        public int Id { get; set; }

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

        /// <summary>
        /// RFID信息
        /// </summary>
        [ExporterHeader(DisplayName = "RFID信息")]
        [ImporterHeader(Name = "RFID信息")]
        [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "RFID信息")]
        public string RfidCode { get; set; }

        /// <summary>
        /// 托盘类型
        /// </summary>
        [ExporterHeader(DisplayName = "托盘类型")]
        [ImporterHeader(Name = "托盘类型")]
        [SugarColumn(IsNullable = false, ColumnDescription = "托盘类型")]
        public int PalletType { get; set; }

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

        /// <summary>
        /// 仓库主键
        /// </summary>
        [ExporterHeader(DisplayName = "仓库主键")]
        [ImporterHeader(Name = "仓库主键")]
        [SugarColumn(IsNullable = false, ColumnDescription = "仓库主键")]
        public int WarehouseId { get; set; }

        /// <summary>
        /// 库存组织
        /// </summary>
        [ExporterHeader(DisplayName = "库存组织")]
        [ImporterHeader(Name = "库存组织")]
        [SugarColumn(IsNullable = false, ColumnDescription = "库存组织")]
        public int MaterielInvOrgId { get; set; }

        /// <summary>
        /// 库存属性(原纸,半成...)
        /// </summary>
        [ExporterHeader(DisplayName = "库存属性")]
        [ImporterHeader(Name = "库存属性")]
        [SugarColumn(IsNullable = false, ColumnDescription = "库存属性")]
        public int StockAttribute { get; set; }

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

        /// <summary>
        /// 物料Id
        /// </summary>
        [ExporterHeader(DisplayName = "物料Id")]
        [ImporterHeader(Name = "物料Id")]
        [SugarColumn(IsNullable = true, ColumnDescription = "物料Id")]
        public int MaterielId { get; set; }

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

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

        /// <summary>
        /// 物料规格
        /// </summary>
        [ExporterHeader(DisplayName = "物料规格")]
        [ImporterHeader(Name = "物料规格")]
        [SugarColumn(IsNullable = true, Length = 200, ColumnDescription = "物料规格")]
        public string MaterielSpec { get; set; }

        /// <summary>
        /// 批次号
        /// </summary>
        [ExporterHeader(DisplayName = "批次号")]
        [ImporterHeader(Name = "批次号")]
        [SugarColumn(IsNullable = true, Length = 100, ColumnDescription = "批次号")]
        public string BatchNo { get; set; }

        /// <summary>
        /// 订单号
        /// </summary>
        [ExporterHeader(DisplayName = "订单号")]
        [ImporterHeader(Name = "订单号")]
        [SugarColumn(IsNullable = true, Length = 100, ColumnDescription = "订单号")]
        public string OrderNo { get; set; }

        /// <summary>
        /// 库存物料总长(m)
        /// </summary>
        [ExporterHeader(DisplayName = "库存物料总长")]
        [ImporterHeader(Name = "库存物料总长")]
        [SugarColumn(IsNullable = true, ColumnDescription = "库存物料总长(m)")]
        public decimal StockLength { get; set; }

        /// <summary>
        /// 物料重量
        /// </summary>
        [ExporterHeader(DisplayName = "物料重量")]
        [ImporterHeader(Name = "物料重量")]
        [SugarColumn(IsNullable = true, ColumnDescription = "物料重量")]
        public decimal? MaterielWeight { get; set; }

        /// <summary>
        /// 检测重量
        /// </summary>
        [ExporterHeader(DisplayName = "检测重量")]
        [ImporterHeader(Name = "检测重量")]
        [SugarColumn(IsNullable = true, ColumnDescription = "检测重量")]
        public decimal? CheckWeight { get; set; }

        /// <summary>
        /// 物料直径/高度
        /// </summary>
        [ExporterHeader(DisplayName = "物料直径")]
        [ImporterHeader(Name = "物料直径")]
        [SugarColumn(IsNullable = true, ColumnDescription = "物料直径/高度")]
        public decimal? MaterielThickness { get; set; }

        /// <summary>
        /// 检测直径
        /// </summary>
        [ExporterHeader(DisplayName = "检测直径")]
        [ImporterHeader(Name = "检测直径")]
        [SugarColumn(IsNullable = true, ColumnDescription = "检测直径")]
        public decimal? CheckThickness { get; set; }

        /// <summary>
        /// 物料侧面幅宽(m)
        /// </summary>
        [ExporterHeader(DisplayName = "物料侧面幅宽")]
        [ImporterHeader(Name = "物料侧面幅宽")]
        [SugarColumn(IsNullable = true, ColumnDescription = "物料侧面幅宽(m)")]
        public decimal? MaterielWide { get; set; }

        /// <summary>
        /// 检测幅宽
        /// </summary>
        [ExporterHeader(DisplayName = "检测幅宽")]
        [ImporterHeader(Name = "检测幅宽")]
        [SugarColumn(IsNullable = true, ColumnDescription = "检测幅宽")]
        public decimal? CheckWide { get; set; }

        /// <summary>
        /// 出库物料数量
        /// </summary>
        [ExporterHeader(DisplayName = "出库物料数量")]
        [ImporterHeader(Name = "出库物料数量")]
        [SugarColumn(IsNullable = false, ColumnDescription = "出库物料数量", DefaultValue = "0")]
        public decimal StockOutLength { get; set; }

        /// <summary>
        /// 整卷/残卷
        /// </summary>
        [ExporterHeader(DisplayName = "整卷/残卷")]
        [ImporterHeader(Name = "整卷/残卷")]
        [SugarColumn(IsNullable = false, ColumnDescription = "整卷/残卷", DefaultValue = "0")]
        public int IsFull { get; set; }

        /// <summary>
        /// 是否领料<br/>
        /// 0 否<br/>
        /// 1 是<br/>
        /// </summary>
        [ExporterHeader(DisplayName = "是否领料(1是0否)")]
        [ImporterHeader(Name = "是否领料(1是0否)")]
        [SugarColumn(IsNullable = false, ColumnDescription = "是否领料", DefaultValue = "0")]
        public int IsPick { get; set; }

        /// <summary>
        /// 单位
        /// </summary>
        [ExporterHeader(DisplayName = "单位")]
        [ImporterHeader(Name = "单位")]
        [SugarColumn(IsNullable = true, ColumnDescription = "单位")]
        public string Unit { get; set; }

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