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_MaterialCodeInfo), "物料码信息")]
    public class Dt_MaterialCodeInfo : BaseEntity
    {
        /// <summary>
        /// 主键
        /// </summary>
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "主键")]
        public int Id { get; set; }

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

        /// <summary>
        /// 物料名称
        /// </summary>
        [SugarColumn(IsNullable = true, Length = 255, ColumnDescription = "物料名称")]
        public string? MaterialName { get; set; }

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

        /// <summary>
        /// 采购单号
        /// </summary>
        [SugarColumn(IsNullable = true, Length = 50, ColumnDescription = "采购单号")]
        public string? PruchaseOrderNo { get; set; }

        /// <summary>
        /// 物料规格
        /// </summary>
        [SugarColumn(IsNullable = true, Length = 500, ColumnDescription = "物料规格")]
        public string? MaterialSpec { get; set; }

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

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

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

        /// <summary>
        /// 新条码
        /// </summary>
        [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "新条码")]
        public string NewBarcode { get; set; }

        /// <summary>
        /// 原条码
        /// </summary>
        [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "原条码")]
        public string OldBarcode {  get; set; }

        /// <summary>
        /// 原数量
        /// </summary>
        [SugarColumn(IsNullable = false, ColumnDescription = "原数量")]
        public decimal OriginalQuantity {  get; set; }

        /// <summary>
        /// 新数量
        /// </summary>
        [SugarColumn(IsNullable = false, ColumnDescription = "新数量")]
        public decimal AfterQuantity {  get; set; }

        /// <summary>
        /// 单位
        /// </summary>

        [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "单位")]
        public string Unit {  get; set; }

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