using HH.WCS.Mobox3.RiDong.generalMethod;
using SqlSugar;
using DateTime = System.DateTime;

namespace HH.WCS.Mobox3.RiDong.models;

/// <summary>
/// 作业表
/// </summary>
[SugarTable("TN_Operation")]
public class Operation : 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; }

    /// <summary>
    /// 当前任务状态（各个设备交互点，进度：根据项目自定义）
    /// </summary>
    public string S_TASK_STATE { get; set; }

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

    /// <summary>
    /// 起点货位
    /// </summary>
    public string S_START_LOC { get; set; }
    
    /// <summary>
    /// 扩展字段（用来当作中转货位）
    /// </summary>
    public string S_EXT_ATTR1 { get; set; }
    
    /// <summary>
    /// 扩展字段（任务组）
    /// </summary>
    public int S_EXT_ATTR2 { get; set; }

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

    /// <summary>
    /// 作业类型（1：常规入库，2：常规出库，3：盘点入库，4：盘点出库，5：指引出库，6：紧急出库）
    /// </summary>
    public string S_TYPE { get; set; }

    /// <summary>
    /// 作业类型（1：常规入库，2：常规出库，3：盘点入库，4：盘点出库，5：指引出库，6：紧急出库）
    /// </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; }

    /// <summary>
    /// 任务结束时间
    /// </summary>
    public DateTime T_END_TIME { get; set; }

    /// <summary>
    /// 容器编码
    /// </summary>
    public string S_CNTR_CODE { get; set; }
    
    /// <summary>
    /// 托盘类型（新增字段）(0：子拖，1：母拖)
    /// </summary>
    public int N_CNTR_TYPE { get; set; } = 1;

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

    /// <summary>
    /// 起点仓库
    /// </summary>
    public string S_START_WH { get; set; } = "RDCK";
        
    /// <summary>
    /// 起点库区
    /// </summary>
    public string S_START_AREA { get; set; } = "RDKQ";
    
    /// <summary>
    /// 终点仓库
    /// </summary>
    public string S_END_WH { get; set; } = "RDCK";
        
    /// <summary>
    /// 终点库区
    /// </summary>
    public string S_END_AREA { get; set; } = "RDKQ";

    /// <summary>
    /// 配盘单号
    /// </summary>
    public string S_DC_NO { get; set; }
        
    /// <summary>
    /// 盘点单号
    /// </summary>
    public string S_COUNT_NO { get; set; }

    /// <summary>
    /// 出库方向
    /// </summary>
    public string S_OUT_TARGET { get; set; }
    
    /// <summary>
    /// 巷道
    /// </summary>
    public int N_ROADWAY { 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;
            case 6: str = "紧急出库"; break;
            case 7: str = "空托出库"; break;
        }
        return str;
    }
    
    /// <summary>
    /// 根据传递数字判断任务类型
    /// 1：常规入库、2：常规出库、3：盘点入库、4：盘点出库、5：退库任务
    /// </summary>
    /// <param name="v"></param>
    /// <returns></returns>
    internal static int GetGroup(int v) {
        var str = 0;
        switch (v) {
            case 0: str = 0; break;
            case 1: str = 1; break;
            case 2: str = 1; break;
            case 3: str = 2; break;
            case 4: str = 2; break;
            case 5: str = 3; break;
        }
        return str;
    }

    /// <summary>
    /// 根据传递货位，找到对应的立库区
    /// </summary>
    /// <param name="loc"></param>
    /// <returns></returns>
    public static string GetArea(string loc)
    {
        var location = AdoSqlMethod<Location>.QueryFirst(p=>p.S_CODE == loc);

        return location.S_AREA_CODE;
    }
}