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>
        [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 = false, ColumnDescription = "托盘类型")]
        public int PalletType { get; set; }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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