using SqlSugar;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WIDESEAWCS_Core.DB.Models;

namespace WIDESEAWCS_Model.Models
{
    /// <summary>
    /// 库存表（货位信息）
    /// </summary>
    [SugarTable(nameof(Dt_Inventory), "库存表")]
    public class Dt_Inventory : BaseEntity
    {
        /// <summary>
        /// 主键
        /// </summary>
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "主键")]
        public int Id { get; set; }

        /// <summary>
        /// 货位id
        /// </summary>
        [SugarColumn(Length = 510, ColumnDescription = "货位id")]
        public string? location_id { get; set; }

        /// <summary>
        /// 库区/区域id
        /// </summary>
        [SugarColumn(Length = 510, ColumnDescription = "库区/区域id")]
        public string? location_areaid { get; set; }

        /// <summary>
        /// 货位状态
        /// </summary>
        [SugarColumn(Length = 510, ColumnDescription = "货位状态")]
        public string? location_state { get; set; }

        /// <summary>
        /// 行
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDescription = "行")]
        public int? location_line { get; set; }

        /// <summary>
        /// 列
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDescription = "列")]
        public int? location_column { get; set; }

        /// <summary>
        /// 层
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDescription = "层")]
        public int? location_layer { get; set; }

        /// <summary>
        /// 是否被锁定
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDescription = "是否被锁定")]
        public bool? location_islocked { get; set; }

        /// <summary>
        /// 备用字段1
        /// </summary>
        [SugarColumn(IsNullable = true, Length = 255, ColumnDataType = "nvarchar", ColumnDescription = "备用字段1")]
        public string? location_bak_1 { get; set; }

        /// <summary>
        /// 备用字段2
        /// </summary>
        [SugarColumn(IsNullable = true, Length = 255, ColumnDataType = "nvarchar", ColumnDescription = "备用字段2")]
        public string? location_bak_2 { get; set; }

        /// <summary>
        /// 备用字段3
        /// </summary>
        [SugarColumn(IsNullable = true, Length = 255, ColumnDataType = "nvarchar", ColumnDescription = "备用字段3")]
        public string? location_bak_3 { get; set; }

        /// <summary>
        /// 货位深度
        /// </summary>
        [SugarColumn(IsNullable = true, ColumnDescription = "货位深度")]
        public int? location_deep { get; set; }
    }
}