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
{
    [SugarTable(nameof(Dt_WheelsStock_Old), "旧库库存信息")]

    public class Dt_WheelsStock_Old
    {
        /// <summary>
        /// 主键
        /// </summary>
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "主键")]
        public int Wheels_ID { get; set; }

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


        /// <summary>
        /// 轮对号
        /// </summary>
        [ImporterHeader(Name = "轮对号")]
        [ExporterHeader(DisplayName = "轮对号")]
        [SugarColumn(IsNullable = false, ColumnName = "feedbackno", Length = 50, ColumnDescription = "轮对号")]
        public string feedbackno { get; set; }

        /// <summary>
        /// 车组号
        /// </summary>
        [ImporterHeader(Name = "车组号")]
        [ExporterHeader(DisplayName = "车组号")]
        [SugarColumn(IsNullable = false, ColumnName = "axes_code", Length = 20, ColumnDescription = "车组号")]
        public string axes_code { get; set; }

        /// <summary>
        /// 新/旧
        /// </summary>
        [ImporterHeader(Name = "新/旧")]
        [ExporterHeader(DisplayName = "新/旧")]
        [SugarColumn(IsNullable = false, ColumnName = "repair_item", Length = 20, ColumnDescription = "新/旧")]
        public string repair_item { get; set; }

        /// <summary>
        /// 车轮类别(M/T)
        /// </summary>
        [ImporterHeader(Name = "车轮类别(M/T)")]
        [ExporterHeader(DisplayName = "车轮类别(M/T)")]
        [SugarColumn(IsNullable = false, ColumnName = "dqtz_state", Length = 20, ColumnDescription = "车轮类别(M/T)")]
        public string dqtz_state { get; set; }

        /// <summary>
        /// 车轮型号
        /// </summary>
        [ImporterHeader(Name = "车轮型号")]
        [ExporterHeader(DisplayName = "车轮型号")]
        [SugarColumn(IsNullable = false, ColumnName = "axes_type", Length = 50, ColumnDescription = "车轮型号")]
        public string axes_type { get; set; }

        /// <summary>
        /// 毂孔等级
        /// </summary>
        [ImporterHeader(Name = "毂孔等级")]
        [ExporterHeader(DisplayName = "毂孔等级")]
        [SugarColumn(IsNullable = false, ColumnName = "venderno", Length = 50, ColumnDescription = "毂孔等级")]
        public string venderno { get; set; }

        /// <summary>
        /// 轮/盘类型
        /// </summary>
        [ImporterHeader(Name = "轮/盘类型")]
        [ExporterHeader(DisplayName = "轮/盘类型")]
        [SugarColumn(IsNullable = false, ColumnName = "bearing_type", Length = 20, ColumnDescription = "轮/盘类型")]
        public string bearing_type { get; set; }

        /// <summary>
        /// 制动盘材质
        /// </summary>
        [ImporterHeader(Name = "制动盘材质")]
        [ExporterHeader(DisplayName = "制动盘材质")]
        [SugarColumn(IsNullable = false, ColumnName = "matertextrue", Length = 50, ColumnDescription = "制动盘材质")]
        public string matertextrue { get; set; }

        /// <summary>
        /// 车型
        /// </summary>
        [ImporterHeader(Name = "车型")]
        [ExporterHeader(DisplayName = "车型")]
        [SugarColumn(IsNullable = false, ColumnName = "model", Length = 20, ColumnDescription = "车型")]
        public string model { get; set; }

        /// <summary>
        /// 制造厂
        /// </summary>
        [ImporterHeader(Name = "制造厂")]
        [ExporterHeader(DisplayName = "制造厂")]
        [SugarColumn(IsNullable = false, ColumnName = "wheel_from", Length = 50, ColumnDescription = "制造厂")]
        public string wheel_from { get; set; }

        /// <summary>
        /// 配属局
        /// </summary>
        [ImporterHeader(Name = "配属局")]
        [ExporterHeader(DisplayName = "配属局")]
        [SugarColumn(IsNullable = false, ColumnName = "wheel_pan", Length = 20, ColumnDescription = "配属局")]
        public string wheel_pan { get; set; }

        /// <summary>
        /// 轮毂孔直径
        /// </summary>
        [ImporterHeader(Name = "轮毂孔直径")]
        [ExporterHeader(DisplayName = "轮毂孔直径")]
        [SugarColumn(IsNullable = false, ColumnName = "zjj", Length = 20, ColumnDescription = "轮毂孔直径")]
        public string zjj { get; set; }

        /// <summary>
        /// 预估镟修后轮径值
        /// </summary>
        [ImporterHeader(Name = "预估镟修后轮径值")]
        [ExporterHeader(DisplayName = "预估镟修后轮径值")]
        [SugarColumn(IsNullable = false, ColumnName = "zszj", Length = 20, ColumnDescription = "预估镟修后轮径值")]
        public string zszj { get; set; }

        /// <summary>
        /// 轮缘厚
        /// </summary>
        [ImporterHeader(Name = "轮缘厚")]
        [ExporterHeader(DisplayName = "轮缘厚")]
        [SugarColumn(IsNullable = false, ColumnName = "zcd", Length = 50, ColumnDescription = "轮缘厚")]
        public string zcd { get; set; }

        /// <summary>
        /// 轴装/轮装制动盘剩余磨耗
        /// </summary>
        [ImporterHeader(Name = "轴装/轮装制动盘剩余磨耗")]
        [ExporterHeader(DisplayName = "轴装/轮装制动盘剩余磨耗")]
        [SugarColumn(IsNullable = false, ColumnName = "m_zdpzzj", Length = 20, ColumnDescription = "轴装/轮装制动盘剩余磨耗")]
        public string m_zdpzzj { get; set; }
        /// <summary>
        /// 备注
        /// </summary>
        [ImporterHeader(Name = "备注")]
        [ExporterHeader(DisplayName = "备注")]
        [SugarColumn(IsNullable = false, ColumnName = "remarks", Length = 100, ColumnDescription = "备注")]
        public string remarks { get; set; }
        /// <summary>
        /// 保养周期提醒
        /// </summary>
        [ImporterHeader(Name = "保养周期提醒")]
        [ExporterHeader(DisplayName = "保养周期提醒")]

        [SugarColumn(IsNullable = false, ColumnName = "mqtz_state", Length = 20, ColumnDescription = "保养周期提醒")]
        public string mqtz_state { get; set; }

        /// <summary>
        /// 上次保养时间
        /// </summary>
        [ImporterHeader(Name = "上次保养时间")]
        [ExporterHeader(DisplayName = "上次保养时间")]
        [SugarColumn(IsNullable = false, ColumnName = "dt_bearing_dx", Length = 50, ColumnDescription = "上次保养时间")]
        public string dt_bearing_dx { get; set; }

        /// <summary>
        /// 下次保养时间
        /// </summary>
        [ImporterHeader(Name = "下次保养时间")]
        [ExporterHeader(DisplayName = "下次保养时间")]
        [SugarColumn(IsNullable = false, ColumnName = "dt_rtn", Length = 50, ColumnDescription = "下次保养时间")]
        public string dt_rtn { get; set; }

        /// <summary>
        /// 预估轮径值
        /// </summary>

        [ImporterHeader(Name = "预估轮径值")]
        [ExporterHeader(DisplayName = "预估轮径值")]
        [SugarColumn(IsNullable = false, ColumnName = "Wheels_ygljz", Length = 50, ColumnDescription = "预估轮径值")]
        public string Wheels_ygljz { get; set; }

        /// <summary>
        /// 入库日期
        /// </summary>
        [ImporterHeader(Name = "入库日期")]
        [ExporterHeader(DisplayName = "入库日期")]
        [SugarColumn(IsNullable = false, ColumnName = "dt_ins", Length = 50, ColumnDescription = "入库日期")]
        public string dt_ins { get; set; }

        /// <summary>
        /// 交检日期
        /// </summary>
        [ImporterHeader(Name = "交检日期")]
        [ExporterHeader(DisplayName = "交检日期")]
        [SugarColumn(IsNullable = false, ColumnName = "dt_detect", Length = 20, ColumnDescription = "交检日期")]
        public string dt_detect { get; set; }

        /// <summary>
        /// 交检人
        /// </summary>
        [ImporterHeader(Name = "交检人")]
        [ExporterHeader(DisplayName = "交检人")]
        [SugarColumn(IsNullable = false, ColumnName = "wheel_type", Length = 20, ColumnDescription = "交检人")]
        public string wheel_type { get; set; }

        /// <summary>
        /// 入库人
        /// </summary>
        [ImporterHeader(Name = "入库人")]
        [ExporterHeader(DisplayName = "入库人")]
        [SugarColumn(IsNullable = false, ColumnName = "dept_code", Length = 20, ColumnDescription = "入库人")]
        public string dept_code { get; set; }

        /// <summary>
        /// 备用状态1
        /// </summary>
        [ImporterHeader(Name = "备用状态1")]
        [ExporterHeader(DisplayName = "备用状态1")]
        [SugarColumn(IsNullable = false, ColumnName = "spare_state1", Length = 20, ColumnDescription = "备用状态1")]
        public string spare_state1 { get; set; }

        /// <summary>
        /// 货位号
        /// </summary>
        [ImporterHeader(Name = "货位号")]
        [ExporterHeader(DisplayName = "货位号")]
        [SugarColumn(IsNullable = false, ColumnName = "Locate", Length = 20, ColumnDescription = "货位号")]
        public string Locate { get; set; }

        /// <summary>
        /// 状态  0-创建 1-在库  2-已选配 3-预选配 4-指定出库
        /// </summary>
        [ImporterHeader(Name = "状态")]
        [ExporterHeader(DisplayName = "状态")]
        [SugarColumn(IsNullable = false, ColumnName = "Wheels_CurrentStatue", Length = 50, ColumnDescription = "状态")]
        public int? Wheels_CurrentStatue { get; set; } = 1;


    }
}