using HH.WCS.JingyuNongfu.util;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace HH.WCS.JingyuNongfu.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 ItemInfo : BaseModel
    {
        [SugarColumn(IsPrimaryKey = true)]
        public string S_ITEM_CODE { get; set; }
        public string S_ITEM_NAME { get; set; }
        public int S_ITEM_LAYER { get; set; }
        public int S_ITEM_LAYER1 { get; set; }
        public String S_ITEM_MODEL { get; set; }
        public string S_ITEM_TYPE { get; set; }
        public String S_TRAY_TYPE { get; set; }

        public int N_MaxLayer { get; set; }
    }
   
    [ST("货位表")]
    public class Location : BaseModel
    {
        public string S_LOC_CODE { get; set; }
        public string S_AREA_CODE { get; set; }
        public string S_WH_CODE { get; set; }
        public int N_CAPACITY { get; set; }
        public string S_AGV_SITE { get; set; }
        /// <summary>
        /// 需要注意
        /// </summary>
        //[SugarColumn(IsIgnore = true)]
        public int N_AGV_CODE { get; set; }


        public int N_CURRENT_NUM { get; set; }
        public string S_TYPE { get; set; }
        public DateTime T_FULL_TIME { get; set; }
        public int N_ROADWAY { get; set; }
        public int N_ROW { get; set; }
        public int N_COL { get; set; }
        public int N_LAYER { get; set; }
        /// <summary>
        /// 无/入库锁/出库锁/其它锁
        /// </summary>
        public string S_LOCK_STATE { get; set; }
        //public string S_DEEP { get; set; }


        [SugarColumn(IsIgnore = true)]
        [Navigate(NavigateType.OneToOne, nameof(S_LOC_CODE))]
        public LocCntrRel LocCntrRel { get; set; }
        public string C_ENABLE { get; set; }
    }
    
    [ST("货位容器表")]
    public class LocCntrRel : BaseModel
    {
        /// <summary>
        /// 注意，mapper方式不需要
        /// </summary>
        [SugarColumn(IsPrimaryKey = true)]
        public string S_LOC_CODE { get; set; }
        public string S_CNTR_CODE { 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; }
       // public int N_BIND_ORDER { get; set; }
    }
   
    [ST("容器货品表")]
    public class CntrItemRel : BaseModel
    {
        [SugarColumn(IsPrimaryKey = true)]
        public string S_CNTR_CODE { 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 F_QTY { get; set; }
        public string S_ITEM_STATE { get; set; } = "无";
        public string workOrder { get; set; }
        public string S_ITEM_MODEL { get; set; }
        public string S_TRAY_TYPE { get; set; }
    }
   
    [ST("容器表")]
    public class Container : BaseModel
    {
        [SugarColumn(IsPrimaryKey = true)]
        /// <summary>
        /// 容器编码
        /// </summary>
        public string S_CNTR_CODE { get; set; }
        /// <summary>
        /// 铁托盘、塑料托盘
        /// </summary>
        public string S_TYPE { get; set; }
        /// <summary>
        /// 规格
        /// </summary>
        public string S_SPEC { get; set; }
        /// <summary>
        /// 容器用途
        /// </summary>
        public string N_PURPOSE { get; set; }
        /// <summary>
        /// 容器来源
        /// </summary>
        public string S_SRC { get; set; }
        /// <summary>
        /// 容器目的地
        /// </summary>
        public string S_DEST { get; set; }
        /// <summary>
        /// 容器状态(空-已清洁-无-转运-待生产)
        /// </summary>
        public string S_CNTR_STATE { get; set; }
        //public string N_DETAIL_COUNT { get; set; }

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

    }

    [ST("排锁表")]
    public class RowLock : BaseModel
    {
        /// <summary>
        /// 库区编码
        /// </summary>
        public string S_AREA_CODE { get; set; }
        /// <summary>
        /// 排号
        /// </summary>
        public string N_ROW { get; set; }
        /// <summary>
        /// 锁定状态--默认：无
        /// </summary>
        public string S_LOCK_STATE { get; set; }
      
    }

    [ST("任务表")]
    public class WMSTask : BaseModel
    {

        public string S_TASK_NO { get; set; }
        public string S_START_LAREA { get; set; }
        public string S_END_LAREA { get; set; }
        public string S_START_LOC { get; set; }
        public string S_END_LOC { get; set; }
        public string S_TYPE { get; set; }
        public string S_NOTE { get; set; }
        public string S_SRC_SYS { get; set; }
        public string S_SRC_NO { get; set; }
        /// <summary>
        /// agv/人工/输送线
        /// </summary>
        public string S_WORK_MODE { get; set; }
        public DateTime? T_START_TIME { get; set; }
        public DateTime? T_END_TIME { get; set; }
        /// <summary>
        /// 任务状态
        /// </summary>
        public string S_B_STATE { get; set; }
        public int N_PRIORITY { get; set; }
        /// <summary>
        /// 搬运的托盘号，多个用英文逗号分开
        /// </summary>
        public string S_CNTRS { get; set; }
        /// <summary>
        /// 起点层
        /// </summary>
        public int N_START_LAYER { get; set; }
        /// <summary>
        /// 终点层
        /// </summary>
        public int N_END_LAYER { get; set; }
        /// <summary>
        /// 搬运的托盘数量
        /// </summary>
        public int N_CNTR_COUNT { get; set; }

        public string S_EQ_NO { get; set; }
      //  public string S_TYPE_CODE { get; set; }
    }

   
    [ST("任务动作表")]
    public class WmsTaskAction : BaseModel
    {
        public string S_TASK_NO { get; set; }
        public string S_ACTION_CODE { get; set; }
        /// <summary>
        /// 设备号
        /// </summary>
        public string S_EQ_NO { get; set; }
        /// <summary>
        /// 设备类型
        /// </summary>
        public string S_EQ_TYPE { get; set; }
        /// <summary>
        /// 其它数据
        /// </summary>
        public string S_DATA { get; set; }

    }

   
    [ST("货位扩展表")]
    public class LocationExt : BaseModel
    {
        /// <summary>
        /// 货位
        /// </summary>
        public string S_LOC_CODE { get; set; }
        /// <summary>
        /// agv站点
        /// </summary>
        public string S_AGV_SITE { get; set; }
        /// <summary>
        /// 标识
        /// </summary>
        public string S_PICKUP_POINT { get; set; }

    }

    [ST("自由线段表")]
    public class FreeLineInfo : BaseModel
    {
        public string S_AREA_CODE { get; set; }
        public int N_ROW { get; set; }
        public int S_START_COL { get; set; }
        public int S_END_COL { get; set; }
        public int S_First_Bit { get; set; }
        public int S_Second_Bit { get; set; }
        public int S_Three_Bit { get; set; }
    }
}