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_TakeStockOrderDetail), "盘点单明细")]
    public class Dt_TakeStockOrderDetail : BaseEntity
    {
        /// <summary>
        /// 主键
        /// </summary>
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "主键")]
        [ExporterHeader(DisplayName = "主键")]
        public int Id { get; set; }

        /// <summary>
        /// 盘点单主键
        /// </summary>
        [SugarColumn(IsNullable = false, ColumnDescription = "盘点单主键")]
        [ExporterHeader(DisplayName = "盘点单主键")]
        public int TakeStockId { get; set; }

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

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

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

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

        /// <summary>
        /// 原仓位
        /// </summary>
        [SugarColumn(IsNullable = true, Length = 50, ColumnDescription = "原仓位")]
        [ExporterHeader(DisplayName = "原仓位")]
        public string LocationCode { get; set; }

        /// <summary>
        /// 盘点托盘
        /// </summary>
        [SugarColumn(IsNullable = true, Length = 50, ColumnDescription = "盘点托盘")]
        [ExporterHeader(DisplayName = "盘点托盘")]
        public string TakePalletCode { get; set; }

        /// <summary>
        /// 盘点明细状态
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDescription = "盘点明细状态")]
        [ExporterHeader(DisplayName = "盘点明细状态")]
        public int TakeDetalStatus { get; set; }

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

        /// <summary>
        /// 账面数量
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDescription = "账面数量")]
        [ExporterHeader(DisplayName = "账面数量")]
        public decimal SysQty { get; set; }

        /// <summary>
        /// 实盘数量
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDescription = "实盘数量")]
        [ExporterHeader(DisplayName = "实盘数量")]
        public decimal Qty { get; set; }

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

        /// <summary>
        /// 条码
        /// </summary>
        [SugarColumn(IsNullable = true, Length = 50, ColumnDescription = "条码")]
        [ExporterHeader(DisplayName = "条码")]
        public string barcode { get; set; }

        /// <summary>
        /// 物料仓库
        /// </summary>
        [SugarColumn(IsNullable = true, Length = 20, ColumnDescription = "物料仓库")]
        [ExporterHeader(DisplayName = "物料仓库")]
        public string WarehouseCode { get; set; }

        /// <summary>
        /// 厂区
        /// </summary>
        [SugarColumn(IsNullable = true, Length = 10, ColumnDescription = "厂区")]
        [ExporterHeader(DisplayName = "厂区")]
        public string FactoryArea { get; set; }

        /// <summary>
        /// 供应商编号
        /// </summary>
        [SugarColumn(IsNullable = true, Length = 20, ColumnDescription = "供应商编号")]
        [ExporterHeader(DisplayName = "供应商编号")]
        public string SupplyCode { get; set; }

        /// <summary>
        /// 盘点单单据
        /// </summary>
        [SugarColumn(IsNullable = true, Length = 50, ColumnDescription = "盘点单单据")]
        [ExporterHeader(DisplayName = "盘点单单据")]
        public string TakeStockNo { get; set; }

        /// <summary>
        /// 差异数量
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDescription = "差异数量")]
        [ExporterHeader(DisplayName = "差异数量")]
        public decimal DifferenceQty { get; set; }
    }
}