KB-API/Wms.Screen.SqlSugar/ZhongTian/SX/WCSTaskOld.cs

using System; 
using System.Collections.Generic;
using SqlSugar;
using Wms.Screen.Dto.ZhongTian;
using Wms.Screen.SqlSugar;

namespace  wms.sqlsugar.model.sx
{    
	[Tenant("sx")] 
    [SugarTable(nameof(WCS_TaskOld) + "_{year}{month}{day}", "任务表")]
    [SplitTable(SplitType.Month)]//按年分表 （自带分表支持 年、季、月、周、日）
    public  class WCS_TaskOld : BaseEntityModel
    {
        /// <summary>
        /// ID
        /// </summary>
        [SugarColumn(IsPrimaryKey = true, ColumnDescription = "ID")]
        public int ID { get; set; }
        /// <summary> 
        /// 生产编码
        /// </summary> 
        [SugarColumn(ColumnDataType ="varchar" , Length = 50  , IsNullable = false  , ColumnDescription ="生产编码")]
        public string BarCode { get; set; }

        /// <summary> 
        /// 任务类型
        /// </summary> 
        [SugarColumn(ColumnDataType ="int" , IsNullable = false  , ColumnDescription ="任务类型")]
        public TaskType Type { get; set; }

        /// <summary> 
        /// 任务状态
        /// </summary> 
        [SugarColumn(ColumnDataType ="int" , IsNullable = false  , ColumnDescription ="任务状态")]
        public int Status { get; set; }

        /// <summary> 
        /// 起始地址
        /// </summary> 
        [SugarColumn(ColumnDataType ="varchar" , Length = 20  , IsNullable = false  , ColumnDescription ="起始地址")]
        public string AddrFrom { get; set; }

        /// <summary> 
        /// 目标地址
        /// </summary> 
        [SugarColumn(ColumnDataType ="varchar" , Length = 20  , IsNullable = false  , ColumnDescription ="目标地址")]
        public string AddrTo { get; set; }

        /// <summary> 
        /// 下一个地址
        /// </summary> 
        [SugarColumn(ColumnDataType ="varchar" , Length = 20  , IsNullable = true  , ColumnDescription ="下一个地址")]
        public string AddrNext { get; set; }

        /// <summary> 
        /// 巷道
        /// </summary> 
        [SugarColumn(ColumnDataType ="varchar" , Length = 10  , IsNullable = true  , ColumnDescription ="巷道")]
        public string Tunnel { get; set; }

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

        /// <summary> 
        /// 设备
        /// </summary> 
        [SugarColumn(ColumnDataType ="varchar" , Length = 20  , IsNullable = true  , ColumnDescription ="设备")]
        public string Device { get; set; }

        /// <summary> 
        /// 最后一个交互点
        /// </summary> 
        [SugarColumn(ColumnDataType ="varchar" , Length = 20  , IsNullable = true  , ColumnDescription ="最后一个交互点")]
        public string LastInteractionPoint { get; set; }

        /// <summary> 
        /// 堆垛机放货站台
        /// </summary> 
        [SugarColumn(ColumnDataType ="varchar" , Length = 20  , IsNullable = true  , ColumnDescription ="堆垛机放货站台")]
        public string SrmStation { get; set; }

        /// <summary> 
        /// 客户现场的机台/产线编号
        /// </summary> 
        [SugarColumn(ColumnDataType ="varchar" , Length = 255  , IsNullable = true  , ColumnDescription ="客户现场的机台/产线编号")]
        public string WorkBench { get; set; }

        /// <summary> 
        /// 仓库编号
        /// </summary> 
        [SugarColumn(ColumnDataType ="varchar" , Length = 255  , IsNullable = true  , ColumnDescription ="仓库编号")]
        public string WarehouseCode { get; set; }

        /// <summary> 
        /// WMS任务号
        /// </summary> 
        [SugarColumn(ColumnDataType ="int" , IsNullable = false  , ColumnDescription ="WMS任务号")]
        public int WmsTask { get; set; }

        /// <summary> 
        /// 任务组ID
        /// </summary> 
        [SugarColumn(ColumnDataType ="varchar" , Length = 255  , IsNullable = true  , ColumnDescription ="任务组ID")]
        public string TaskGroupKey { get; set; }

        /// <summary> 
        /// 单号
        /// </summary> 
        [SugarColumn(ColumnDataType ="int" , IsNullable = true  , ColumnDescription ="单号")]
        public int? DocId { get; set; }

        /// <summary> 
        /// 生产单号
        /// </summary> 
        [SugarColumn(ColumnDataType ="varchar" , Length = 255  , IsNullable = true  , ColumnDescription ="生产单号")]
        public string WorkOrder { get; set; }

        /// <summary> 
        /// 托盘类型
        /// </summary> 
        [SugarColumn(ColumnDataType ="smallint" , IsNullable = true  , ColumnDescription ="托盘类型")]
        public int? PalletType { get; set; }

        /// <summary> 
        /// 码垛工位
        /// </summary> 
        [SugarColumn(ColumnDataType ="smallint" , IsNullable = true  , ColumnDescription ="码垛工位")]
        public int? ProdLine { get; set; }

        /// <summary> 
        /// 满盘数量
        /// </summary> 
        [SugarColumn(ColumnDataType ="smallint" , IsNullable = true  , ColumnDescription ="满盘数量")]
        public int? FullQty { get; set; }

        /// <summary> 
        /// 高度
        /// </summary> 
        [SugarColumn(ColumnDataType ="smallint" , IsNullable = true  , ColumnDescription ="高度")]
        public int? Height { get; set; }

        /// <summary> 
        /// 重量
        /// </summary> 
        [SugarColumn(ColumnDataType ="float" , IsNullable = true  , ColumnDescription ="重量")]
        public double? Weight { get; set; }

        /// <summary> 
        /// 产品长度
        /// </summary> 
        [SugarColumn(ColumnDataType ="decimal" , Length = 18  , IsNullable = true  , ColumnDescription ="产品长度")]
        public decimal? Length { get; set; }

        /// <summary> 
        /// 开始时间
        /// </summary> 
        [SugarColumn(ColumnDataType ="datetime" , IsNullable = true  , ColumnDescription ="开始时间")]
        public DateTime? StartTime { get; set; }

        /// <summary> 
        /// 结束时间
        /// </summary> 
        [SugarColumn(ColumnDataType ="datetime" , IsNullable = true  , ColumnDescription ="结束时间")]
        public DateTime? EndTime { get; set; }

        /// <summary> 
        /// 物料编码
        /// </summary> 
        [SugarColumn(ColumnDataType ="nvarchar" , Length = 50  , IsNullable = true  , ColumnDescription ="物料编码")]
        public string MatCode { get; set; }

        /// <summary> 
        /// 创建时间
        /// </summary> 
        [SugarColumn(ColumnDataType = "datetime", IsNullable = false, ColumnDescription = "创建时间")]
        [SplitField]
        public DateTime AddTime { get; set; }
        /// <summary> 
        /// 创建用户
        /// </summary> 
        [SugarColumn(ColumnDataType = "varchar", Length = 50, IsNullable = false, ColumnDescription = "创建用户")]
        public string AddWho { get; set; }

        /// <summary> 
        /// 更新用户
        /// </summary> 
        [SugarColumn(ColumnDataType = "varchar", Length = 50, IsNullable = true, ColumnDescription = "更新用户")]
        public string EditWho { get; set; }

        /// <summary> 
        /// 更新时间
        /// </summary> 
        [SugarColumn(ColumnDataType = "datetime", IsNullable = true, ColumnDescription = "更新时间")]
        public DateTime EditTime { get; set; }
        /// <summary> 
        /// 材料号
        /// </summary> 
        [SugarColumn(ColumnDataType ="nvarchar" , Length = 50  , IsNullable = true  , ColumnDescription ="材料号")]
        public string InvBarCode { get; set; }

        /// <summary> 
        /// 是否快投
        /// </summary> 
        [SugarColumn(ColumnDataType ="bit" , IsNullable = true  , ColumnDescription ="是否快投")]
        public bool? IsFast { get; set; }

        /// <summary> 
        /// 等级
        /// </summary> 
        [SugarColumn(ColumnDataType ="nvarchar" , Length = 50  , IsNullable = true  , ColumnDescription ="等级")]
        public string Grade { get; set; }

        /// <summary> 
        /// 是否改手盘
        /// </summary> 
        [SugarColumn(ColumnDataType ="bit" , IsNullable = true  , ColumnDescription ="是否改手盘")]
        public bool? IsSurplus { get; set; }

        /// <summary> 
        /// 是否返空
        /// </summary> 
        [SugarColumn(ColumnDataType ="bit" , IsNullable = true  , ColumnDescription ="是否返空")]
        public bool? IsRework { get; set; }

        /// <summary> 
        /// 更新状态
        /// </summary> 
        [SugarColumn(ColumnDataType ="int" , IsNullable = false  , ColumnDescription ="更新状态")]
        public int Uploaded { get; set; }

        /// <summary> 
        /// AGV任务号
        /// </summary> 
        [SugarColumn(ColumnDataType ="int" , IsNullable = true  , ColumnDescription ="AGV任务号")]
        public int? AgvTaskID { get; set; }

        /// <summary> 
        /// 优先级
        /// </summary> 
        [SugarColumn(ColumnDataType ="int" , IsNullable = false  , ColumnDescription ="优先级")]
        public int Priority { get; set; }

        /// <summary> 
        /// 手动处理备注
        /// </summary> 
        [SugarColumn(ColumnDataType ="varchar" , Length = 255  , IsNullable = true  , ColumnDescription ="手动处理备注")]
        public string ManualRemarks { get; set; }

        /// <summary> 
        /// 出库任务类型
        /// </summary> 
        [SugarColumn(ColumnDataType ="int" , IsNullable = true  , ColumnDescription ="出库任务类型")]
        public int? OutType { get; set; }

        /// <summary> 
        /// 产品编码
        /// </summary> 
        [SugarColumn(ColumnDataType ="varchar" , Length = 255  , IsNullable = true  , ColumnDescription ="产品编码")]
        public string MaterialCode { get; set; }

        /// <summary> 
        /// 是否可用
        /// </summary> 
        [SugarColumn(ColumnDataType ="bit" , IsNullable = false  , ColumnDescription ="是否可用")]
        public bool Enabled { get; set; }

        /// <summary> 
        /// 业务类型
        /// </summary> 
        [SugarColumn(ColumnDataType ="varchar" , Length = 255  , IsNullable = true  , ColumnDescription ="业务类型")]
        public string BusType { get; set; }

        /// <summary> 
        /// 货位类型
        /// </summary> 
        [SugarColumn(ColumnDataType ="int" , IsNullable = true  , ColumnDescription ="货位类型")]
        public int? GoodsType { get; set; }

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

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

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

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

        /// <summary> 
        /// Robot
        /// </summary> 
        [SugarColumn(ColumnDataType = "varchar", Length = 255, IsNullable = true)]
        public string Robot { get; set; }
    }
}