YG-OPP-WCS-Client/WCS_Client/Models/WCS_TASK.cs

using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using static WCS_Client.Utility.CurrentHelper;

namespace WCS_Client.Models
{
    public class WCS_TASK
    {
        /// <summary>
        /// WCS任务号
        /// </summary>
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
        public int TASK_NO { get; set; }
        /// <summary>
        /// WMS任务号
        /// </summary>
        public string TASK_WMSNO { get; set; }

        /// <summary>
        /// 任务类型
        /// </summary>
        public int TASK_COMTYPE { get; set; }

        [SugarColumn(IsIgnore = true)]
        public ComTypeEnum TASK_COMTYPECh
        {
            get
            {
                return (ComTypeEnum)TASK_COMTYPE;
            }
        }
        public string TASK_SYSTYPE { get; set; }
        public string TASK_POSIDFROM { get; set; }
        public string TASK_POSIDCUR { get; set; }
        public string TASK_POSIDNEXT { get; set; }
        public string TASK_POSIDTO { get; set; }
        public string TASK_POSIDMOVE { get; set; }
        public int TASK_PRIORITY { get; set; }
        public int TASK_WKSTATUS { get; set; }
        public string TASK_WHID { get; set; }
        public string TASK_ADDUSERNO { get; set; }
        public DateTime TASK_ADDDATETIME { get; set; }
        public string TASK_EDITUSERNO { get; set; }
        public DateTime TASK_EDITDATETIME { get; set; }
        public string TASK_NOTES { get; set; }
        public string TASK_SRMNO { get; set; }
        /// <summary>
        /// rgv编号
        /// </summary>
        public string TASK_RGVNO { get; set; }
        public int TASK_ORDERTYPE { get; set; }
        public string TASK_BOXBARCODE { get; set; }
        /// <summary>
        /// 起始巷道号
        /// </summary>
        public string TASK_FromTunnelNum { get; set; }
        /// <summary>
        /// 目标巷道号
        /// </summary>
        public string TASK_EndTunnelNum { get; set; }
        /// <summary>
        /// 熟化类型(0=不需熟化、1=熟化房熟化、2=小烘房熟化)
        /// </summary>
        public int TASK_MatureType { get; set; }
        /// <summary>
        /// 熟化时间(小时：10,16)
        /// </summary>
        public decimal TASK_MatureDate { get; set; }
        /// <summary>
        /// 熟化温度(小数)
        /// </summary>
        public decimal TASK_MatureTemperat { get; set; }
        /// <summary>
        /// 进入熟化房时间
        /// </summary>
        public DateTime TASK_InMatureRoomDate { get; set; }
        /// <summary>
        /// 离开熟化房时间
        /// </summary>
        public DateTime TASK_OutMatureRoomDate { get; set; }
        /// <summary>
        /// 机械手：子托盘的尺寸编码
        /// </summary>
        public string PalletizingSonTraySize { get; set; }
        /// <summary>
        /// 机械手：码垛的箱子尺寸编码
        /// </summary>
        public string PalletizingBoxSize { get; set; }
        /// <summary>
        /// 预分配堆垛机出口输送线编号
        /// </summary>
        //public string TASK_SRMOUTCONVNO { get; set; }
        public string TASK_ITEM1 { get; set; }
        public string TASK_ITEM2 { get; set; }
        public string TASK_ITEM3 { get; set; }
        public string TASK_ITEM4 { get; set; }
        public string TASK_ITEM5 { get; set; }
        public string TASK_ITEM6 { get; set; }
        public string TASK_ITEM7 { get; set; }
        public string TASK_ITEM8 { get; set; }
        public string TASK_ITEM9 { get; set; }
        public string TASK_ITEM10 { get; set; }

        [SugarColumn(IsIgnore = true)]
        public List<string> FromLocation
        {
            get
            {
                return TASK_POSIDFROM.Split('-').ToList();
            }
        }
        [SugarColumn(IsIgnore = true)]
        public int FromRow
        {
            get
            {
                return Convert.ToInt32(FromLocation[1]);
            }
        }
        [SugarColumn(IsIgnore = true)]
        public int FromCol
        {
            get
            {
                return Convert.ToInt32(FromLocation[2]);
            }
        }
        [SugarColumn(IsIgnore = true)]
        public int FromLayer
        {
            get
            {
                return Convert.ToInt32(FromLocation[3]);
            }
        }
        [SugarColumn(IsIgnore = true)]
        public int FromDepth
        {
            get
            {
                return Convert.ToInt32(FromLocation[4]);
            }
        }
        [SugarColumn(IsIgnore = true)]
        public int FromSingleDepthRow
        {
            get
            {
                return 1;
            }
        }

        [SugarColumn(IsIgnore = true)]
        public List<string> ToLocation
        {
            get
            {
                return TASK_POSIDTO.Split('-').ToList();
            }
        }
        [SugarColumn(IsIgnore = true)]
        public int ToRow
        {
            get
            {
                return Convert.ToInt32(ToLocation[1]);
            }
        }
        [SugarColumn(IsIgnore = true)]
        public int ToCol
        {
            get
            {
                return Convert.ToInt32(ToLocation[2]);
            }
        }
        [SugarColumn(IsIgnore = true)]
        public int ToLayer
        {
            get
            {
                return Convert.ToInt32(ToLocation[3]);
            }
        }
        [SugarColumn(IsIgnore = true)]
        public int ToDepth
        {
            get
            {
                return Convert.ToInt32(ToLocation[4]);
            }
        }
    }
    public class WCS_TASK_DTL
    {
        [SugarColumn(IsPrimaryKey = true, IsIdentity = false)]
        public string ID { get; set; }
        public int PARENTID { get; set; }
        public string TASKNO { get; set; }
        public string POSIDCUR { get; set; }
        public string POSIDNEXT { get; set; }
        public string DESCRIPTION { get; set; }
        public string NOTES { get; set; }
        public DateTime EXECUTEDATE { get; set; }
    }
    public class WCS_EQUIPMENTLOCK
    {
        [SugarColumn(IsPrimaryKey = true, IsIdentity = false)]
        public string EQUIPMENTNO { get; set; }
        public bool ISLOCK { get; set; }
        public DateTime UPDATETIME { get; set; }
        public string ISENABLEI_IN { get; set; }
        public string ISENABLE_OUT { get; set; }
        public string EQUTYPE { get; set; }
    }
}