using HH.WCS.ZhongCeJinTan.util;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Reflection.Emit;
using System.Text;
using System.Threading.Tasks;

namespace HH.WCS.ZhongCeJinTan.wms
{

    //---------------------------------------仓库信息---------------------------------------
    public class BaseModel
    {
        [SugarColumn(IsPrimaryKey = true)]
        public string S_ID { get; set; } = Guid.NewGuid().ToString("D");
        public string S_CREATOR_ID { get; set; } = "sa";
        public string S_CREATOR_NAME { get; set; } = "超级用户";
        public DateTime T_CREATE { get; set; } = DateTime.Now;
        public DateTime T_MODIFY { get; set; } = DateTime.Now;


    }


    [ST("作业流程表")]
    public class WorkFlow : BaseModel
    {
        /// <summary>
        /// 流程编号
        /// </summary>
        public string FLOWCODE { get; set; }
        /// <summary>
        /// 流程名称
        /// </summary>
        public string FLOWNAME { get; set; }
        /// <summary>
        /// 出入库
        /// </summary>
        public string INOROUT { get; set; }
        /// <summary>
        /// 是否通知立库
        /// </summary>
        /// </summary>
        public string INFORMWCS { get; set; }
        /// <summary>
        /// 是否下达给立库
        /// </summary>
        public string SENDWCS { get; set; }
        /// <summary>
        /// 接驳位库区
        /// </summary>
        public string CONNECTION { get; set; }
        /// <summary>
        /// 起点库区
        /// </summary>
        public string STARTAREA { get; set; }
        /// <summary>
        /// 终点库区
        /// </summary>
        public string ENDAREA { get; set; }
        /// <summary>
        /// 异常库区
        /// </summary>
        public string ERRORAREA { get; set; }
        /// <summary>
        /// 工装类型
        /// </summary>
        public string TOOLSTYPE { get; set; }
        /// <summary>
        /// 巷道 1-2-3 形式
        /// </summary>
        public string ROADWAY { get; set; }

        /// <summary>
        /// 逻辑库区编码
        /// </summary>
        public string ZONECODE { get; set; }
    }

    [ST("货位表")]
    public class Location : BaseModel
    {
        /// <summary>
        /// 货位编码
        /// </summary>
        public string S_CODE { get; set; }

        /// <summary>
        /// 货位名称
        /// </summary>
        public string S_NAME { get; set; }

        /// <summary>
        /// 仓库编码
        /// </summary>
        public string S_WH_CODE { get; set; }

        /// <summary>
        /// 库区编码
        /// </summary>
        public string S_AREA_CODE { get; set; }

        /// <summary>
        /// 库区中文名称
        /// </summary>
        public string S_AREA_Name { get; set; }

        /// <summary>
        /// 巷道
        /// </summary>
        public int N_ROADWAY { get; set; }

        /// <summary>
        /// 排号
        /// </summary>
        public int N_ROW { get; set; }

        /// <summary>
        /// 列号
        /// </summary>
        public int N_COL { get; set; }

        /// <summary>
        /// 层
        /// </summary>
        public int N_LAYER { get; set; }

        /// <summary>
        /// 容量
        /// </summary>
        public int N_CAPACITY { get; set; }

        /// <summary>
        /// 当前数量
        /// </summary>
        public int N_CURRENT_NUM { get; set; }

        /// <summary>
        /// AGV站点
        /// </summary>
        public string S_AGV_SITE { get; set; }

        /// <summary>
        /// AGV站点层数
        /// </summary>
        public int N_AGV_SITE_LAYER { get; set; }

        /// <summary>
        /// 锁定状态
        /// </summary>
        public string S_LOCK_STATE { get; set; }

        /// <summary>
        /// 锁定状态值 1入库锁 2出库锁 0无锁
        /// </summary>
        public int N_LOCK_STATE { get; set; }


        /// <summary>
        /// 启用
        /// </summary>
        public string C_ENABLE { get; set; }


        /// <summary>
        /// 接驳位对应巷道
        /// </summary>
        public int CONNEC_ROADWAY { get; set; }

        /// <summary>
        /// 深度
        /// </summary>
        public string N_DEEP { get; set; }

        [SugarColumn(IsIgnore = true)]
        [Navigate(NavigateType.OneToOne, nameof(S_CODE))]
        public LocCntrRel LocCntrRel { get; set; }
    }



    [ST("货位容器表")]
    public class LocCntrRel : BaseModel
    {
        /// <summary>
        /// 货位编码
        /// </summary>
        [SugarColumn(IsPrimaryKey = true)]
        public string S_LOC_CODE { get; set; }


       

        /// <summary>
        /// 容器编码
        /// </summary>
        public string S_CNTR_CODE { get; set; }

        /// <summary>
        /// 动作类型
        /// </summary>
        //public string S_ACTION_TYPE { get; set; }

        /// <summary>
        /// 动作源
        /// </summary>
        public string S_ACTION_SRC { get; set; }

        /// <summary>
        /// 动作类型值
        /// </summary>
       // public int N_ACTION_TYPE { get; set; }

        /// <summary>
        /// 绑定方式
        /// </summary>
        public string S_BINDING_METHOD { get; set; }

        /// <summary>
        /// 绑定方式值
        /// </summary>
        public int N_BINDING_METHOD { get; set; }

        /// <summary>
        /// 深位
        /// </summary>
        //public int N_DEEP { get; set; }

        [SugarColumn(IsIgnore = true)]
        [Navigate(NavigateType.OneToOne, nameof(S_CNTR_CODE))]
        public CntrItemRel CntrItemRel { get; set; }
        [SugarColumn(IsIgnore = true)]
        [Navigate(NavigateType.OneToOne, nameof(S_CNTR_CODE))]
        public Container Container { get; set; }
    }

    

    [ST("容器物料表")]
    public class CntrItemRel : BaseModel
    {
        /// <summary>
        /// 容器编码
        /// </summary>
        [SugarColumn(IsPrimaryKey = true)]
        public string S_CNTR_CODE { get; set; }

        /// <summary>
        /// 货品编码
        /// </summary>
        public string S_ITEM_CODE { get; set; }

        /// <summary>
        /// 货品名称
        /// </summary>
        public string S_ITEM_NAME { get; set; }

        /// <summary>
        /// 批次号
        /// </summary>
        public string S_BATCH_NO { get; set; }

        /// <summary>
        /// 数量
        /// </summary>
        public decimal F_QTY { get; set; }

        /// <summary>
        /// 质检状态
        /// </summary>
        public string S_ITEM_STATE { get; set; }

        /// <summary>
        /// 周转卡号
        /// </summary>
        public string TurnCardNum { get; set; }
        /// <summary>
        /// 物料特征  zc中 用来存工艺编号
        /// </summary>
        public string itemFeature { get; set; }
        /// <summary>
        /// 规格型号
        /// </summary>
        public string itemModel { get; set; }

        /// <summary>
        /// 失效时间
        /// </summary>
        public DateTime expireTime { get; set; }

        /// <summary>
        /// 生效时间
        /// </summary>
        public DateTime takeEffectTime { get; set; }

        /// <summary>
        /// 生产时间
        /// </summary>
        public DateTime PRODUCTIONDATE { get; set; }

        /// <summary>
        /// 制品类型
        /// </summary>
        public string Level { get; set; }

        /// <summary>
        /// 规格
        /// </summary>
        public string S_ITEM_SPEC { get; set; }

        /// <summary>
        /// 总重量
        /// </summary>
        public decimal F_SUM_QTY { get; set; }

        /// <summary>
        /// 入库时间
        /// </summary>
        public DateTime T_INSTOCK { get; set; }

        /// <summary>
        /// 工厂
        /// </summary>
        public string facnm { get; set; }

        /// <summary>
        /// 胶号
        /// </summary>
        public string cdrub { get; set; }
        /// <summary>
        /// 机台
        /// </summary>
        public string mchid { get; set; }
        /// <summary>
        /// 作业日期
        /// </summary>
        public string wdate { get; set; }
        /// <summary>
        /// 班次
        /// </summary>
        public string wsht { get; set; }
        /// <summary>
        /// 开始车次
        /// </summary>
        public string strbat { get; set; }
        /// <summary>
        /// 结束车次
        /// </summary>
        public string endbat { get; set; }

        /// <summary>
        /// 生产计划编号
        /// </summary>
        public string planno { get; set; }

        /// <summary>
        /// 胶料段
        /// </summary>
        public string stage { get; set; }
        /// <summary>
        /// 检验结果
        /// </summary>
        public string grd { get; set; }
        /// <summary>
        /// 工装重量
        /// </summary>
        //public decimal F_AVG_QTY { get; set; }

        /// <summary>
        /// 供应商编码
        /// </summary>
        //public string S_SUPPLIER_N0 { get; set; }
        /// <summary>
        /// 供应商名称
        /// </summary>
        //public string S_SUPPLIER { get; set; }

        /// <summary>
        /// 订单号
        /// </summary>
        //public string S_Order_Number { get; set; }

        /// <summary>
        /// 班次
        /// </summary>
        // public string S_Classes { get; set; }

        /// <summary>
        /// 机台号
        /// </summary>
        //public int S_Drilling_Crew { get; set; }

        /// <summary>
        /// 车号
        /// </summary>
        //public int S_Car_Num { get; set; }

        /// <summary>
        /// 第几个料
        /// </summary>
        //public string S_Srequency { get; set; }

        /// <summary>
        /// 时间
        /// </summary>
        //public string S_TIME { get; set; }
        //public string applyProdSpecList { get; set; }
    }

    //[ST("物料表")]
    //public class Item : BaseModel
    //{
    //    /// <summary>
    //    /// 物料类型
    //    /// </summary>
    //    public string S_ITEM_TYPE { get; set; }

    //    /// <summary>
    //    /// 物料编码
    //    /// </summary>
    //    public string S_ITEM_CODE { get; set; }

    //    /// <summary>
    //    /// 物料名称
    //    /// </summary>
    //    public string S_ITEM_NAME { get; set; }

    //    /// <summary>
    //    /// 重量
    //    /// </summary>
    //    public float F_WEIGHT { get; set; }
    //}
    [ST("作业表")]
    public class WmsWork : BaseModel
    {
        /// <summary>
        /// 业务状态（0：等待，1：执行，2：完成，3：错误，4：启动失败，5：暂停启动，6：任务未创建、7：任务取消）
        /// </summary>
        public string S_B_STATE { get; set; } = "等待";

        /// <summary>
        /// 业务状态（0：等待，1：执行，2：完成，3：错误，4：启动失败，5：暂停启动，6：任务未创建、7：任务取消）
        /// </summary>
        public int N_B_STATE { get; set; } = 0;

        /// <summary>
        /// 接驳位，如果有二段任务需要当作业的中转货位，一段任务的终点，二段任务的起点
        /// </summary>
        public string CONNECTION { get; set; }


        /// <summary>
        /// 作业工装类型
        /// </summary>
        public string TOOLSTYPE { get; set; }

        /// <summary>
        /// 作业编码
        /// </summary>
        public string S_CODE { get; set; }

        /// <summary>
        /// 起点货位
        /// </summary>
        public string S_START_LOC { get; set; }

     
        /// <summary>
        /// 终点货位
        /// </summary>
        public string S_END_LOC { get; set; }

        /// <summary>
        /// 作业类型
        /// </summary>
        public string S_TYPE { get; set; }

        /// <summary>
        /// 作业类型
        /// </summary>
        public int N_TYPE { get; set; }

        /// <summary>
        /// 作业定义名称
        /// </summary>
        public string S_OP_DEF_NAME { get; set; }

        /// <summary>
        /// 开始时间
        /// </summary>
        public DateTime? T_START_TIME { get; set; } = null;

        /// <summary>
        /// 结束时间
        /// </summary>
        public DateTime? T_END_TIME { get; set; } = null;

        /// <summary>
        /// 容器编码
        /// </summary>
        public string S_CNTR_CODE { get; set; }

       

        /// <summary>
        /// mobox脚本自动运行启动开关
        /// </summary>
        public string C_AUTO_START { get; set; } = "N";

        /// <summary>
        /// 起点仓库
        /// </summary>
        public string S_START_WH { get; set; } = "ZCCK";

        /// <summary>
        /// 起点库区
        /// </summary>
        public string S_START_AREA { get; set; }

        /// <summary>
        /// 终点仓库
        /// </summary>
        public string S_END_WH { get; set; } = "ZCCK";

        /// <summary>
        /// 终点库区
        /// </summary>
        public string S_END_AREA { get; set; }


        /// <summary>
        /// 起点库区名称
        /// </summary>
        public string S_START_AREA_NAME { get; set; }
        /// <summary>
        /// 终点库区名称
        /// </summary>
        public string S_END_AREA_NAME { get; set; }
        /// <summary>
        /// 接驳位库区名称
        /// </summary>
        public string CONNECTION_AREA { get; set; }

        /// <summary>
        /// 作业优先级
        /// </summary>
        public int N_PRIORITY { get; set; }

        


        /// <summary>
        /// 0 等待/1 执行/2 完成/3 错误/4 启劢失败 /5 暂停启劢
        /// </summary>
        /// <returns></returns>
        internal static string GetStateStr(int state)
        {
            var status = "";
            switch (state)
            {
                case 0: status = "等待"; break;
                case 1: status = "执行"; break;
                case 2: status = "完成"; break;
                case 3: status = "错误"; break;
                case 4: status = "启动失败"; break;
                case 5: status = "暂停失败"; break;
                case 6: status = "任务未创建"; break;
                case 7: status = "任务取消"; break;
            }
            return status;
        }

        /// <summary>
        /// 根据传递数字判断任务类型
        /// 1：常规入库、2：常规出库、3：盘点入库、4：盘点出库、5：退库任务
        /// </summary>
        /// <param name="v"></param>
        /// <returns></returns>
        internal static string GetTypeStr(int v)
        {
            var str = "";
            switch (v)
            {
                case 1: str = "常规入库"; break;
                case 2: str = "常规出库"; break;
                case 3: str = "点到点任务"; break;
                case 4: str = "盘点出库"; break;
                case 5: str = "特殊任务"; break;
            }
            return str;
        }

        /// <summary>
        /// 根据传递数字判断任务中文名称
        /// </summary>
        /// <param name="v"></param>
        /// <returns></returns>
        public static string GetOpName(int v)
        {
            var str = "";
            switch (v)
            {
                case 1: str = "码盘入库"; break;
                case 2: str = "FTP出库"; break;
                case 20: str = "点到点任务"; break;
                case 4: str = "盘点出库"; break;
                case 5: str = "特殊任务"; break;
            }
            return str;
        }
    }

        [ST("任务表")]
    public class WMSTask : BaseModel
    {
        /// <summary>
        /// 作业工装类型
        /// </summary>
        public string TOOLSTYPE { get; set; }


        /// <summary>
        /// 任务编码
        /// </summary>
        public string S_CODE { get; set; }

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

        /// <summary>
        /// 任务类型
        /// </summary>
        public string S_TYPE { get; set; }

        /// <summary>
        /// 任务状态值
        /// </summary>
        public int N_B_STATE { get; set; }

        /// <summary>
        /// 任务状态
        /// </summary>
        public string S_B_STATE { get; set; }

    
        /// <summary>
        /// 作业编码
        /// </summary>
        public string S_OP_CODE { get; set; }

        /// <summary>
        /// 设备编号
        /// </summary>
        public string S_EQ_NO { get; set; }

        /// <summary>
        /// 开始时间
        /// </summary>
        public DateTime? T_START_TIME { get; set; } = null;

        /// <summary>
        /// 结束时间
        /// </summary>
        public DateTime? T_END_TIME { get; set; } = null;

        /// <summary>
        /// 调度类型值
        /// </summary>
        public int N_SCHEDULE_TYPE { get; set; }

        /// <summary>
        /// 调度类型
        /// </summary>
        public string S_SCHEDULE_TYPE { get; set; }

        /// <summary>
        /// 优先级
        /// </summary>
        public int N_PRIORITY { get; set; }

        /// <summary>
        /// 设备任务号
        /// </summary>
        public string S_EQ_TASK_CODE { get; set; }

        /// <summary>
        /// 起始仓库
        /// </summary>
        public string S_START_WH { get; set; }

        /// <summary>
        /// 起始库区编号
        /// </summary>
        public string S_START_AREA { get; set; }

        /// <summary>
        /// 起始库区编号
        /// </summary>
        public string S_START_AREA_NAME { get; set; }

        /// <summary>
        /// 目的库区编号
        /// </summary>
        public string S_END_AREA_NAME { get; set; }

        /// <summary>
        /// 起点
        /// </summary>
        public string S_START_LOC { get; set; }

        /// <summary>
        /// 起始货位站点
        /// </summary>
        public string S_START_SITE { get; set; }

        /// <summary>
        /// 起点层
        /// </summary>
        public int S_START_SITE_LAYER { get; set; }

        /// <summary>
        /// 目的仓库
        /// </summary>
        public string S_END_WH { get; set; }

        /// <summary>
        /// 目的库区编号
        /// </summary>
        public string S_END_AREA { get; set; }

        /// <summary>
        /// 终点
        /// </summary>
        public string S_END_LOC { get; set; }

        /// <summary>
        /// 目的货位站点
        /// </summary>
        public string S_END_SITE { get; set; }

        /// <summary>
        /// 终点层
        /// </summary>
        public int S_END_SITE_LAYER { get; set; }

        /// <summary>
        /// 备注
        /// </summary>
        public string S_NOTE { get; set; }

        /// <summary>
        /// 错误信息
        /// </summary>
        public string S_ERR { get; set; }

        /// <summary>
        /// 错误码
        /// </summary>
        public int N_ERR { get; set; }

        /// <summary>
        /// 容器编码
        /// </summary>
        public string S_CNTR_CODE { get; set; }

        /// <summary>
        /// 搬运的托盘数量
        /// </summary>
        public int N_CNTR_COUNT { get; set; }


        /// <summary>
        /// 车间编码
        /// </summary>
        public string S_WORKSHOP_NO { get; set; }


        /// <summary>
        /// 车间名称
        /// </summary>
        public string S_WORKSHOP_NAME { get; set; }

      

        internal static string GetStateStr(int state)
        {
            //0等待	  1已推送	    2执行    3完成    4错误
            var status = "";
            switch (state)
            {
                case 0:
                    status = "等待";
                    break;
                case 1:
                    status = "已推送";
                    break;
                case 2:
                    status = "执行";
                    break;
                case 3:
                    status = "完成";
                    break;
                case 4:
                    status = "错误";
                    break;
                case 5:
                    status = "取消";
                    break;
            }

            return status;
        }
    }


    [ST("任务动作表")]
    public class WmsTaskAction : BaseModel
    {
        /// <summary>
        /// 设备类型
        /// </summary>
        public string S_EQ_TYPE { get; set; }

        /// <summary>
        /// 动作
        /// </summary>
        public string S_ACTION { get; set; }

        /// <summary>
        /// 任务编码
        /// </summary>
        public string S_TASK_CODE { get; set; }

        /// <summary>
        /// 设备号
        /// </summary>
        public string S_EQ_CODE { get; set; }

        /// <summary>
        /// 附加参数
        /// </summary>
        public string S_DATA { get; set; }

        /// <summary>
        /// 动作码
        /// </summary>
        public int N_ACTION_CODE { get; set; }

    }

    //[ST("小车上报状态缓存表")]
    //public class AgvState : BaseModel
    //{
    //    public int state { get; set; }
    //    public string task_no { get; set; }
    //    public string forklift_no { get; set; }
    //    public string ext_data { get; set; }
    //}


    [ST("容器表")]
    public class Container : BaseModel
    {
        /// <summary>
        /// 容器编码
        /// </summary>
        public string S_CODE { get; set; }

        /// <summary>
        /// 容器类型值
        /// </summary>
        //public string N_TYPE { get; set; }

        /// <summary>
        /// 容器类型
        /// </summary>
        public string S_TYPE{ get; set; }

        /// <summary>
        /// 规格
        /// </summary>
        //public string S_SPEC { get; set; }

        /// <summary>
        /// 自重
        /// </summary>
        //public float F_WEIGHT { get; set; }

        /// <summary>
        /// 最大重量
        /// </summary>
        //public float F_MAX_WEIGHT { get; set; }

        /// <summary>
        /// 长
        /// </summary>
        //public int N_LENGTH { get; set; }

        /// <summary>
        /// 是否可用
        /// </summary>
        public string C_ENABLE { get; set; }

        /// <summary>
        /// 宽
        /// </summary>
       // public int N_WIDTH { get; set; }

        /// <summary>
        /// 虚拟容器
        /// </summary>
        //public string C_IS_VIRTUAL { get; set; }

        /// <summary>
        /// 高
        /// </summary>
        //public string N_HEIGHT { get; set; }

        /// <summary>
        /// 明细条数
        /// </summary>
        public int N_DETAIL_COUNT { get; set; }

        /// <summary>
        /// 容器业务状态
        /// </summary>
        //public int N_B_STATE { get; set; }

        /// <summary>
        /// 锁定业务号
        /// </summary>
        //public string S_LOCK_OP_CODE { get; set; }

        /// <summary>
        /// 锁状态
        /// </summary>
        //public string S_LOCK_STATE { get; set; }

        /// <summary>
        /// 锁状态
        /// </summary>
        //public int N_LOCK_STATE { get; set; }

        /// <summary>
        /// 货品重量
        /// </summary>
        //public float F_GOOD_WEIGHT { get; set; }


        /// <summary>
        /// 最大体积
        /// </summary>
        //public float F_MAX_VOLUME { get; set; }

        /// <summary>
        /// 货品体积
        /// </summary>
        //public float F_GOOD_VOLUME { get; set; }

        /// <summary>
        /// 满框
        /// </summary>
        //public string C_FULL { get; set; }

    }

    /// <summary>
    /// MES任务记录表
    /// </summary>
    [ST("MES任务记录表")]
    public class MesTask : BaseModel
    {
        /// <summary>
        /// 任务号
        /// </summary>
        public string task_no { get; set; }
        /// <summary>
        /// 任务类型1:入库;2:出库
        /// </summary>
        public int Task_type { get; set; }
        /// <summary>
        /// 周转卡号
        /// </summary>
        public string TurnCardNum { get; set; }
        /// <summary>
        /// 标准重量
        /// </summary>
        public float standardWeight { get; set; }
        /// <summary>
        /// 工装类型 胎侧25,内衬35,胎体/帘布45,带束55,胎圈65,胎面15,纤维85，钢丝95
        /// </summary>
        public string TOOLS_TPYE { get; set; }
        /// <summary>
        /// 制品编号
        /// </summary>
        public string PROD_NO { get; set; }
        /// <summary>
        /// 工艺编号
        /// </summary>
        public string PROD_TECH { get; set; }
        /// <summary>
        /// 制品规格
        /// </summary>
        public string PROD_SPEC { get; set; }
        /// <summary>
        /// 制品类型
        /// </summary>
        public string PROD_BOM { get; set; }
        /// <summary>
        /// 制品特征值
        /// </summary>
        public string PROD_Feature { get; set; }
        /// <summary>
        /// 工装编号
        /// </summary>
        public string TOOLS_NO { get; set; }
        /// <summary>
        /// 载料数量
        /// </summary>
        public float ST_AMOUNT { get; set; }
        /// <summary>
        /// 当前数量
        /// </summary>
        public float CURRENT_AMOUNT { get; set; }
        /// <summary>
        /// 起始库位编号
        /// </summary>
        public string Location_From { get; set; }
        /// <summary>
        /// 目的库位编号
        /// </summary>
        public string Location_To { get; set; }
        /// <summary>
        /// 生产时间
        /// </summary>
        public DateTime PRODUCE_TIME { get; set; }
        /// <summary>
        /// 生效时间
        /// </summary>
        public DateTime SHELF_LIFE_TIME { get; set; }
        /// <summary>
        /// 失效时间
        /// </summary>
        public DateTime EXPIRED_TIME { get; set; }
        /// <summary>
        /// 缩短报告时间
        /// </summary>
        public float SHELF_REP { get; set; }
        /// <summary>
        /// 延长报告时间
        /// </summary>
        public float EXPIRED_REP { get; set; }
        /// <summary>
        /// 质检状态代码
        /// </summary>
        public string CHECK_CODE { get; set; }
        /// <summary>
        /// 质检状态
        /// </summary>
        public string CHECK_INFO { get; set; }
        /// <summary>
        /// 优先级0-普通：任务生成时，均为此级别;1-加急;2-紧急
        /// </summary>
        public int Priority { get; set; }
        /// <summary>
        /// 任务状态0-初始状态;1-进行中;2-完成;3-任务取消
        /// </summary>
        public int Data_status { get; set; }
        /// <summary>
        /// 业务类型
        /// </summary>
        public string BUSI_TYPE { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime CreateDate { get; set; }

        /// <summary>
        /// 返回信息mes
        /// </summary>
        public string errMsg { get; set; }

        /// <summary>
        /// 返回码mes
        /// </summary>
        public int errCode { get; set; }

    }


    /// <summary>
    /// 空托出缓存表
    /// </summary>
    [ST("空托出缓存表")]
    public class MesKtTask : BaseModel
    {
        /// <summary>
        /// 工装类型 胎侧25,内衬35,胎体/帘布45,带束55,胎圈65,胎面15,纤维85，钢丝95
        /// </summary>
        public string TOOLS_TPYE { get; set; }
    
        /// <summary>
        /// 起始库区编号
        /// </summary>
        public string Location_From_Area { get; set; }
        /// <summary>
        /// 目的库位编号
        /// </summary>
        public string Location_To { get; set; }
      
        /// <summary>
        /// 优先级0-普通：任务生成时，均为此级别;1-加急;2-紧急
        /// </summary>
        public int Priority { get; set; }
       
        /// <summary>
        /// 业务类型
        /// </summary>
        public string BUSI_TYPE { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime CreateDate { get; set; }

        /// <summary>
        /// 空托任务是否创建  Y/N   默认N
        /// </summary>
        public string Status { get; set; }


        /// <summary>
        /// 任务号
        /// </summary>
        public string task_no { get; set; }
    }


    /// <summary>
    /// 上下架表
    /// </summary>
    [ST("上下架记录")]
        public class RecordUpAndDown : BaseModel
        {

        
            /// <summary>
            /// 上架下架
            /// </summary>
            public string S_ACTION { get; set; }


            /// <summary>
            /// 终点货位
            /// </summary>
            public string S_END_LOC { get; set; }

            /// <summary>
            /// 起点货位
            /// </summary>
            public string S_LOC_CODE { get; set; }

            /// <summary>
            /// 出入库时间
            /// </summary>
            public DateTime T_INBOUND_TIME { get; set; }

            /// <summary>
            /// 任务号
            /// </summary>
            public string S_OPTASK { get; set; }

            /// <summary>
            /// 托盘码
            /// </summary>
            public string S_CNTR_CODE { get; set; }

            /// <summary>
            /// 货品编码
            /// </summary>
            public string S_ITEM_CODE { get; set; }

            /// <summary>
            /// 生产时间
            /// </summary>
            public DateTime D_PRD_DATE { get; set; }

            /// <summary>
            /// 批次号
            /// </summary>
            public string S_BATCH_NO { get; set; }


            /// <summary>
            /// 托盘类型
            /// </summary>
            public string S_TRAY_TYPE { get; set; }

            /// <summary>
            /// 货品名称
            /// </summary>
            public string S_ITEM_NAME { get; set; }

            /// <summary>
            /// 数量
            /// </summary>
            public decimal F_QTY { get; set; }

            /// <summary>
            /// 质检状态
            /// </summary>
            public string S_ITEM_STATE { get; set; }

            /// <summary>
            /// 周转卡号
            /// </summary>
            public string TurnCardNum { get; set; }
            /// <summary>
            /// 物料特征  zc中 用来存工艺编号
            /// </summary>
            public string itemFeature { get; set; }
            /// <summary>
            /// 规格型号
            /// </summary>
            public string itemModel { get; set; }

            /// <summary>
            /// 失效时间
            /// </summary>
            public DateTime expireTime { get; set; }

            /// <summary>
            /// 生效时间
            /// </summary>
            public DateTime takeEffectTime { get; set; }

            /// <summary>
            /// 制品类型
            /// </summary>
            public string Level { get; set; }

            /// <summary>
            /// 规格
            /// </summary>
            public string S_ITEM_SPEC { get; set; }

            /// <summary>
            /// 总重量
            /// </summary>
            public decimal F_SUM_QTY { get; set; }
        }







    /// <summary>
    /// AGV状态信息表
    /// </summary>
    [ST("AGV状态信息表")]
    public class S_AGV_CONDITIONEntitys : BaseModel
    {
        /// <summary>
        /// 车号
        /// </summary>
        [SugarColumn(IsPrimaryKey = true)]
        public string forkliftNo { get; set; }

        #region 电池信息
        /// <summary>
        /// 电池电量
        /// </summary>
        public string Battery_Soc { get; set; }
        /// <summary>
        /// 电池电压
        /// </summary>
        public string Battery_V { get; set; }

        /// <summary>
        /// 电池电流
        /// </summary>
        public string Battery_Amp { get; set; }

        /// <summary>
        /// 电池温度
        /// </summary>
        public string Battery_Temp { get; set; }
        /// <summary>
        /// 电池属性
        /// </summary>
        public string Battery_Prop { get; set; }
        #endregion

        #region 电机信息
        /// <summary>
        /// 电机电流
        /// </summary>
        public string Motor_Amp { get; set; }
        /// <summary>
        /// 电机温度
        /// </summary>
        public string Motor_Temp { get; set; }

        /// <summary>
        /// 油泵电机起升时电流
        /// </summary>
        public string Motor_Y_Amp { get; set; }
        /// <summary>
        /// 油泵电机实时温度
        /// </summary>
        public string Motor_Y_Temp { get; set; }
        #endregion
        #region 交通管制信息
        /// <summary>
        /// 布局位置点
        /// </summary>
        public string Traffic_Pt { get; set; }
        /// <summary>
        /// 布局位置段
        /// </summary>
        public string Traffic_Sec { get; set; }
        /// <summary>
        /// 堵塞逻辑线
        /// </summary>
        public string Traffic_Wire { get; set; }
        /// <summary>
        /// 堵塞单位编号
        /// </summary>
        public string Traffic_Unit { get; set; }
        /// <summary>
        /// 堵塞IO,ID
        /// </summary>
        public string Traffic_Io { get; set; }
        #endregion
        #region 开机时间
        /// <summary>
        /// 累计开机时间，单位（天）
        /// </summary>
        public string Time_D { get; set; }
        /// <summary>
        /// 累计开机时间，单位（h）
        /// </summary>
        public string time_H { get; set; }
        #endregion
        #region 里程
        /// <summary>
        /// 累计里程，单位（km）
        /// </summary>
        public string Mileage_Km { get; set; }
        /// <summary>
        /// 累计里程，单位（m）
        /// </summary>
        public string Mileage_m { get; set; }
        #endregion
        #region 举升次数
        /// <summary>
        /// 累计货叉举升次数，单位:1000次
        /// </summary>
        public string Lifts_Kc { get; set; }
        /// <summary>
        ///累计货叉举升次数，单位:次
        /// </summary>
        public string Lifts_c { get; set; }
        #endregion

        #region 其他信息
        /// <summary>
        /// 车辆X坐标(cm)
        /// </summary>
        public string Pos_X { get; set; }
        /// <summary>
        /// 车辆Y坐标(cm)
        /// </summary>
        public string Pos_Y { get; set; }
        /// <summary>
        /// 车辆z坐标(起升高度)(mm)
        /// </summary>
        public string Pos_Z { get; set; }
        #endregion
        #region 转向角度
        /// <summary>
        /// 转向角度，单位:°
        /// </summary>
        public string Angle_Deg { get; set; }
        #endregion
        #region agv状态
        public string Agvstate_s { get; set; }
        #endregion
    }

    /// <summary>
    /// AGV报警对照表
    /// </summary>
    [ST("AGV报警对照表")]
    public class S_AGV_TYPEEntitys : BaseModel
    {
        /// <summary>
        /// 错误类型
        /// </summary>
        public string S_AGV_TYPE { get; set; }
        /// <summary>
        /// AGV错误代码
        /// </summary>
        public string S_AGV_ERRCODE { get; set; }
        /// <summary>
        /// 1的位置
        /// </summary>
        public int N_CODE_1 { get; set; }
        /// <summary>
        /// 含义
        /// </summary>
        public string S_AGV_NOTE { get; set; }
        /// <summary>
        /// 开关
        /// </summary>
        public string S_IS_OPEN { get; set; }
    }

    /// <summary>
    /// AGV报警信息表
    /// </summary>
    [ST("AGV报警信息表")]
    public class AgvErrorReportEntitys : BaseModel
    {
        /// <summary>
        /// 车号
        /// </summary>
        public string AgvLicense { get; set; }
        /// <summary>
        /// 错误信息
        /// </summary>
        public string AgvErrorMsg { get; set; }
    }

    /// <summary>
    /// 任务拦截表
    /// </summary>
    [ST("任务拦截表")]
    public class ManualTaskSwitch : BaseModel
    {
      
        /// <summary>
        /// 任务拦截开关  Y/N   Y表示拦截任务推送
        /// </summary>
        public string State { get; set; }
    }




    /// <summary>
    /// 逻辑库区货位关联表
    /// </summary>
    [ST("逻辑库区货位关联表")]
    public class ZoneLoc : BaseModel
    {
        //货位编码
        [SugarColumn(IsPrimaryKey = true)]
        public string S_LOC_CODE { get; set; }
        //逻辑库区编码
        public string S_ZONE_CODE { get; set; }

        [SugarColumn(IsIgnore = true)]
        [Navigate(NavigateType.OneToOne, nameof(S_LOC_CODE), nameof(Location.S_CODE))]
        public Location Loc { get; set; }
    }


    /// <summary>
    /// 逻辑编码相关逻辑库区关联
    /// </summary>
    [ST("逻辑编码关联表")]
    public class Zone : BaseModel
    {
        public string S_NAME { get; set; }
        public string S_NOTE { get; set; }
        public string S_WH_CODE { get; set; }
        public int N_EMPTY_MIN { get; set; }
        public int N_EMPTY_MAX { get; set; }
        [SugarColumn(IsPrimaryKey = true)]
        public string S_CODE { get; set; }
        public string S_AREA_CODE { get; set; }
        public string S_LOC_RULE { get; set; }
        public string S_ZONE_CLS_CODE { get; set; }
        public int N_AVAILABLE_IN { get; set; }
        public int N_TYPE { get; set; }
        public string S_TYPE { get; set; }
        public string S_ITEM_CODE { get; set; }
        public string S_ITEM_NAME { get; set; }
        public string S_BATCH_NO { get; set; }
        public string S_ITEM_CATEGORY { get; set; }
        public string S_OWNER_CODE { get; set; }
        public string S_SUPPLIER_CODE { get; set; }
        public int N_CONNECT_TYPE { get; set; }
        public string S_CONNECT_TYPE { get; set; }
        public int N_LOCK_STATE { get; set; }
        public string S_LOCK_STATE { get; set; }
        public string S_OWNER_NAME { get; set; }
        public string S_SUPPLIER_NAME { get; set; }
        public int N_STORE_MAX { get; set; }
        public string S_STATE_PRE { get; set; }

        public string C_IS_AREA { get; set; }
        public string S_GROUP { get; set; }

        [SugarColumn(IsIgnore = true)]
        [Navigate(NavigateType.OneToMany, nameof(S_CODE), nameof(ZoneLoc.S_LOC_CODE))]
        public List<ZoneLoc> ZoneLocs { get; set; }
    }

    /// <summary>
    /// 出库终点无限制表
    /// </summary>
    [ST("出库终点无限制表")]
    public class UnlimitedLoc : BaseModel {
        public string Loc { get; set; }

        /// <summary>
        /// 启用 Y/N
        /// </summary>
        public string Enable { get; set; }
    }

    /// <summary>
    /// 入库优先级表
    /// </summary>
    [ST("入库优先级表")]
    public class InPri : BaseModel
    {
        /// <summary>
        /// 出库类型 0空托出 1满托出   满托出找空托入  空托出找满托入
        /// </summary>
        public string Type  { get; set; }

        /// <summary>
        /// 出库任务终点
        /// </summary>
        public string OutEndLoc { get; set; }

        /// <summary>
        /// 入库任务起点
        /// </summary>
        public string InStartLoc { get; set; }

        /// <summary>
        /// 提高优先级
        /// </summary>
        public int Pri { get; set; }

        /// <summary>
        /// 启用 Y/N
        /// </summary>
        public string Enable { get; set; }
    }

    /// <summary>
    /// 小车动作缓存表
    /// </summary>
    [ST("小车动作缓存表")]
    public class AgvActionState : BaseModel
    {
        /// <summary>
        /// 动作码
        /// </summary>
        public int state { get; set; }
        /// <summary>
        /// 任务号
        /// </summary>
        public string task_no { get; set; }
        /// <summary>
        /// 车号
        /// </summary>
        public string forklift_no { get; set; }
        public string ext_data { get; set; }
    }

    [ST("出库任务提高优先级表")]
    public class OutMinutePriority : BaseModel
    {
        //时间 分钟
        public int Minute { get; set; }

        //提高优先级 到Minute+Priority
        public int Priority { get; set; }

        /// <summary>
        /// 启用 Y/N
        /// </summary>
        public string Enable { get; set; }
    }

    [ST("库区表")]
    public class Area : BaseModel
    {
        //库区编码
        public string S_CODE { get; set; }

        /// <summary>
        /// 库区名称
        /// </summary>
        public string S_NAME { get; set; }
    }
}