using Admin.NET.Application; using iWareCommon.Utils; using iWareModel.Entity.AGV; using iWareModel.EnumType.EDevice.AGV; using iWareSql.DBModel; using System; using System.Collections.Generic; using System.Linq; namespace iWareSql.DataAccess { public class TaskHandler { /// /// 验证 是否存在某个UPI的未结束的的任务 /// /// /// public static bool ValidateIssueTaskForNoFinishTaskByUpi(WmsDBModel.WmsDBModel wmsDB, string UPI, bool isNeedAutoFinishTak) { var isExist = wmsDB.wms_rbline_task.Where(x => x.TaskStatus != (int)TaskStatusEnum.已完成 && x.TaskStatus != (int)TaskStatusEnum.已取消 && x.Upi == UPI ).ToList(); if (isExist?.Count() > 0) { if (isNeedAutoFinishTak) { using (WmsDBModel.WmsDBModel new_wmsDB = new WmsDBModel.WmsDBModel()) { var updateTask = new_wmsDB.wms_rbline_task.Where(x => x.Id == isExist.First().Id).FirstOrDefault(); if (updateTask != null) { updateTask.TaskStatus = (int)TaskStatusEnum.已完成; updateTask.TaskMsg = "任务被系统在合包工位自动完成(1)"; new_wmsDB.SaveChanges(); } } } return false; } return true; } /// /// 验证 机器人缓存岛是否存在已下发的任务 /// /// /// public static bool ValidateIssueTaskForRobotBuffer(WmsDBModel.WmsDBModel wmsDB, string UPI) { var isExist = wmsDB.wms_rbline_task.Where(x => x.TaskStatus == (int)TaskStatusEnum.已下发 && ( x.RbTaskType == (int)RbTaskTypeEnum.入库任务 || (x.RbTaskType == (int)RbTaskTypeEnum.齐包出库任务 || x.RbTaskType == (int)RbTaskTypeEnum.强制出库任务) ) && x.Upi == UPI ).ToList(); if (isExist?.Count() > 0) { return false; } return true; } /// /// 验证 机器人缓存岛是否存在已下发的任务 /// /// /// public static bool ValidateIssueOutTaskForRobotBuffer(WmsDBModel.WmsDBModel wmsDB) { var isExist = wmsDB.wms_rbline_task.Where(x => x.TaskStatus == (int)TaskStatusEnum.已下发 && ( x.RbTaskType == (int)RbTaskTypeEnum.入库任务 || (x.RbTaskType == (int)RbTaskTypeEnum.齐包出库任务 || x.RbTaskType == (int)RbTaskTypeEnum.强制出库任务) ) ).ToList(); if (isExist?.Count() > 0) { return false; } return true; } /// /// 验证 是否存在未结束的 出库 任务 /// /// /// public static bool ValidateIssueTaskForNoFinishTaskByOutStore(WmsDBModel.WmsDBModel wmsDB) { var isExist = wmsDB.wms_rbline_task.Where(x => x.TaskStatus != (int)TaskStatusEnum.已完成 && x.TaskStatus != (int)TaskStatusEnum.已取消 && ( (x.RbTaskType == (int)RbTaskTypeEnum.齐包出库任务 || x.RbTaskType == (int)RbTaskTypeEnum.强制出库任务) ) ).ToList(); if (isExist?.Count() > 0) { return false; } return true; } /// /// 验证 码板是否有执行中任务 /// /// /// public static bool ValidateIssueTaskForBZ12(WmsDBModel.WmsDBModel wmsDB, string UPI) { var isExist = wmsDB.wms_rbline_task.Where(x => x.TaskStatus == (int)TaskStatusEnum.已下发 && x.RbTaskType == (int)RbTaskTypeEnum.码板任务 && x.Upi == UPI).ToList(); if (isExist?.Count() > 0) { return false; } return true; } public static bool ValidateIssueTaskForBZ21(WmsDBModel.WmsDBModel wmsDB, string str) { var isExist = wmsDB.wms_rbline_task.Where(x => x.TaskStatus == (int)TaskStatusEnum.已下发 && x.RbTaskType == (int)RbTaskTypeEnum.合包任务 && x.Upi == str).ToList(); if (isExist?.Count() > 0) { return false; } return true; } /// /// 验证 机器人缓存岛是否存在 未结束 的出库任务 /// /// /// true:不存在 false:存在 public static bool ValidateNoFinishOutTaskForRobotBuffer(WmsDBModel.WmsDBModel wmsDB) { var isExist = wmsDB.wms_rbline_task.Where(x => x.TaskStatus != (int)TaskStatusEnum.已完成 && x.TaskStatus != (int)TaskStatusEnum.已取消 && ( (x.RbTaskType == (int)RbTaskTypeEnum.齐包出库任务 || x.RbTaskType == (int)RbTaskTypeEnum.强制出库任务) ) ).ToList(); if (isExist?.Count() > 0) { return false; } return true; } /// /// 验证 码板任务是否存在 未结束 的任务 /// /// /// true:不存在 false:存在 public static bool ValidateNoFinishOutTaskFor码板任务(WmsDBModel.WmsDBModel wmsDB) { var isExist = wmsDB.wms_rbline_task.Where(x => x.TaskStatus != (int)TaskStatusEnum.已完成 && x.TaskStatus != (int)TaskStatusEnum.已取消 && x.RbTaskType == (int)RbTaskTypeEnum.码板任务 ).ToList(); if (isExist?.Count() > 0) { return false; } return true; } } }