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(VV_StockInfo), "库存信息")]
    public class VV_StockInfo
    {
        /// <summary>
        /// 主键
        /// </summary>
        [ImporterHeader(Name = "主键")]
        [ExporterHeader(DisplayName = "主键")]
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "主键")]
        public int Id { get; set; }

        /// <summary>
        /// 所属巷道
        /// </summary>
        [ImporterHeader(Name = "所属巷道")]
        [ExporterHeader(DisplayName = "所属巷道")]
        [SugarColumn(IsNullable = true, Length = 20, ColumnDescription = "所属巷道")]
        public string RoadwayNo { get; set; }

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

        /// <summary>
        /// 车身ID
        /// </summary>
        [ImporterHeader(Name = "车身ID")]
        [ExporterHeader(DisplayName = "车身ID")]
        [SugarColumn(IsNullable = true, Length = 20, ColumnDescription = "车身ID")]
        public int carBodyID { get; set; }
        /// <summary>
        /// PVI码
        /// </summary>
        [ImporterHeader(Name = "PVI码")]
        [ExporterHeader(DisplayName = "PVI码")]
        [SugarColumn(IsNullable = true, ColumnDescription = "PVI码")]
        public string PVI { get; set; }

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

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

        /// <summary> 
        /// 车身类型  1-白 2-彩 3-空滑橇 
        /// </summary>
        [ImporterHeader(Name = "车身类型")]
        [ExporterHeader(DisplayName = "车身类型")]
        [SugarColumn(IsNullable = true, ColumnDescription = "车身类型")]
        public int CarType { get; set; }

        /// <summary>
        /// 订单类型
        /// </summary>
        [ImporterHeader(Name = "订单类型")]
        [ExporterHeader(DisplayName = "订单类型")]
        [SugarColumn(IsNullable = true, Length = 20, ColumnDescription = "订单类型")]
        public string workOrderType { get; set; }

        /// <summary>
        /// 天窗特征
        /// </summary>
        [ImporterHeader(Name = "天窗特征")]
        [ExporterHeader(DisplayName = "天窗特征")]
        [SugarColumn(IsNullable = true, Length = 40, ColumnDescription = "天窗特征")]
        public string skylightCharacteristic { get; set; }

        /// <summary>
        /// 车身颜色
        /// </summary>
        [ImporterHeader(Name = "车身颜色")]
        [ExporterHeader(DisplayName = "车身颜色")]
        [SugarColumn(IsNullable = true, Length = 20, ColumnDescription = "车身颜色")]
        public string carBodyCharacteristic { get; set; }

        /// <summary>
        /// 白车身物料号
        /// </summary>
        [ImporterHeader(Name = "白车身物料号")]
        [ExporterHeader(DisplayName = "白车身物料号")]
        [SugarColumn(IsNullable = true, Length = 40, ColumnDescription = "白车身物料号")]
        public string biwMaterialCode { get; set; }

        /// <summary>
        /// 彩车身物料号
        /// </summary>
        [ImporterHeader(Name = "彩车身物料号")]
        [ExporterHeader(DisplayName = "彩车身物料号")]
        [SugarColumn(IsNullable = true, Length = 40, ColumnDescription = "彩车身物料号")]
        public string pbMaterial { get; set; }

        /// <summary>
        /// 焊装上线时间
        /// </summary>
        [ImporterHeader(Name = "焊装上线时间")]
        [ExporterHeader(DisplayName = "焊装上线时间")]
        [SugarColumn(IsNullable = true, Length = 40, ColumnDescription = "焊装上线时间")]
        public DateTime? biwInPassTime { get; set; }

        /// <summary>
        /// 锁定状态   0-未锁定 1-锁定
        /// </summary>
        [ImporterHeader(Name = "锁定状态")]
        [ExporterHeader(DisplayName = "锁定状态")]
        [SugarColumn(IsNullable = true, ColumnDescription = "锁定状态")]
        public int StockStatus { get; set; }

        /// <summary>
        /// 拉动锁定  0-未拉动 1-拉动
        /// </summary>
        [ImporterHeader(Name = "拉动锁定")]
        [ExporterHeader(DisplayName = "拉动锁定")]
        [SugarColumn(IsNullable = true, ColumnDescription = "拉动锁定")]
        public int LockOrder { get; set; }

        /// <summary>
        /// 任务状态 0-无任务 1-任务中
        /// </summary>
        [ImporterHeader(Name = "任务状态")]
        [ExporterHeader(DisplayName = "任务状态")]
        [SugarColumn(IsNullable = true, ColumnDescription = "任务状态")]
        public int TaskStatus { get; set; }

        /// <summary>
        /// 保留状态
        /// </summary>
        [ImporterHeader(Name = "保留状态")]
        [ExporterHeader(DisplayName = "保留状态")]
        [SugarColumn(IsNullable = true, ColumnDescription = "保留状态")]
        public int StayStatus { get; set; }

        /// <summary>
        /// 所属工单(预绑定)
        /// </summary>
        //[ImporterHeader(Name = "所属工单")]
        //[ExporterHeader(DisplayName = "所属工单")]
        //[SugarColumn(IsNullable = true, Length = 20, ColumnDescription = "所属工单")]
        //public string OrderID { get; set; }

        /// <summary>
        /// 创建者
        /// </summary>
        [ImporterHeader(Name = "创建者")]
        [ExporterHeader(DisplayName = "创建者")]
        [SugarColumn(IsNullable = false, IsOnlyIgnoreUpdate = true, ColumnDescription = "创建者")]
        public string Creater { get; set; } = "Systeam";

        /// <summary>
        /// 创建时间
        /// </summary>
        [ImporterHeader(Name = "创建时间")]
        [ExporterHeader(DisplayName = "创建时间")]
        [SugarColumn(IsNullable = false, IsOnlyIgnoreUpdate = true, ColumnDescription = "创建时间")]
        public DateTime CreateDate { get; set; }   //= DateTime.Now;

    }
}