| | |
| | | using System; |
| | | using OfficeOpenXml.FormulaParsing.Excel.Functions.Text; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using System.Reflection; |
| | | using System.Text; |
| | | using System.Threading.Tasks; |
| | | using System.Xml.Linq; |
| | | using WIDESEA_Comm; |
| | | using WIDESEA_Comm.LogInfo; |
| | | using WIDESEA_Common; |
| | | using WIDESEA_Core.BaseProvider; |
| | | using WIDESEA_Core.EFDbContext; |
| | | using WIDESEA_Entity.DomainModels; |
| | |
| | | try |
| | | { |
| | | VOLContext Context = new VOLContext(); |
| | | Idt_stationinfoRepository stationinfoRepository = new dt_stationinfoRepository(Context); |
| | | IVV_Mes_WorkinfoRepository workinfoRepository = new VV_Mes_WorkinfoRepository(Context); |
| | | Idt_agvtaskRepository agvtaskService = new dt_agvtaskRepository(Context); |
| | | var tasks = agvtaskService.Find(x => x.agv_taskstate == "Queue").OrderByDescending(x => x.agv_grade).ThenBy(x => x.agv_createtime).ToList(); |
| | | foreach (var task in tasks) |
| | | |
| | | #region éåä»»å¡ |
| | | var agvtasks = agvtaskService.Find(x => x.agv_taskstate == AGVTaskStateEnum.Queue.ToString()).ToList(); |
| | | |
| | | var AGVTaskTypes = Enum.GetNames(typeof(AGVTaskTypeEnum)); |
| | | foreach (var AGVTaskType in AGVTaskTypes) |
| | | { |
| | | try |
| | | var agvtask = agvtasks.Where(x => x.agv_tasktype == AGVTaskType).OrderByDescending(x => x.agv_grade).ThenBy(x => x.agv_createtime).FirstOrDefault(); |
| | | if (agvtask != null) UpdateQueue(agvtaskService, agvtask); |
| | | } |
| | | #endregion |
| | | |
| | | #region MyRegion |
| | | //var tasks = agvtaskService.Find(x => x.agv_taskstate == "Queue").OrderByDescending(x => x.agv_grade).ThenBy(x => x.agv_createtime).ToList(); |
| | | //foreach (var task in tasks) |
| | | //{ |
| | | // try |
| | | // { |
| | | // if (task.agv_tasktype == "TaskType_EmptyPallet")//空æä»»å¡ |
| | | // { |
| | | // if (task.agv_fromaddress == "" && DateTime.Now - task.agv_createtime >= TimeSpan.FromMinutes(2)) |
| | | // { |
| | | // if (task.agv_tasknum.Contains("_")) |
| | | // { |
| | | // string mainTaskNum = task.agv_tasknum.Split('_')[0]; |
| | | // if (agvtaskService.Find(x => x.agv_tasknum == mainTaskNum && task.agv_taskstate != "Executing" && task.agv_taskstate != "Create").Any() || !agvtaskService.Find(x => x.agv_tasknum == mainTaskNum).Any()) |
| | | // GetStation.EmptyPalletStation(task); |
| | | // } |
| | | // else |
| | | // GetStation.EmptyPalletStation(task); |
| | | |
| | | // WriteDBLog.Success("æ´æ°ç©ºæéåä»»å¡", $"ä»»å¡ç¼å·ï¼{task.agv_tasknum}", "PCS"); |
| | | // continue; |
| | | // } |
| | | // } |
| | | // else if (task.agv_tasktype == "TaskType_OutsourceInbound" || task.agv_tasktype == "TaskType_Inbound")//å¤ååºå
¥åº/ABåºå
¥åº |
| | | // { |
| | | // if (task.agv_toaddress == "") |
| | | // { |
| | | // var stationinfo = stationinfoRepository.Find(x => x.stationCode == task.agv_fromaddress).FirstOrDefault(); |
| | | // var work = workinfoRepository.Find(x => x.workOrder == stationinfo.Number && x.drawingNo == stationinfo.stationType && x.heatID == stationinfo.heatNumber && x.processCode == "17").FirstOrDefault(); |
| | | // var TargetLocation = task.agv_tasktype == "TaskType_Inbound" ? GetLocation.GetEmptyLocation(stationinfoRepository, work, task) : StationTask.GetEmptyLocation(stationinfoRepository); |
| | | // if (TargetLocation != null) |
| | | // { |
| | | // if (agvtaskService.Find(x => x.agv_toaddress == TargetLocation.stationCode).Any()) continue; |
| | | // task.agv_taskstate = "Create"; |
| | | // task.agv_toaddress = TargetLocation.stationCode; |
| | | // TargetLocation.location_state = LocationStateEnum.InBusy.ToString(); |
| | | // TargetLocation.billetID = stationinfo.billetID; |
| | | // TargetLocation.stationType = task.agv_materielid; |
| | | // TargetLocation.heatNumber = stationinfo.heatNumber; |
| | | // TargetLocation.Number = task.jobID; |
| | | // stationinfoRepository.Update(TargetLocation, true); |
| | | // agvtaskService.Update(task, true); |
| | | // WriteDBLog.Success("æ´æ°å
¥åºéåä»»å¡", $"ä»»å¡ç¼å·ï¼{task.agv_tasknum}", "PCS"); |
| | | // continue; |
| | | // } |
| | | // } |
| | | // } |
| | | // else if (task.agv_tasktype == "TaskType_OutsourceOutbound" || task.agv_tasktype == "TaskType_Outbound")//å¤ååºåºåº/ABåºåºåº |
| | | // { |
| | | // if (task.agv_toaddress == "") |
| | | // { |
| | | // var EmptyStations = stationinfoRepository.Find(x => x.stationCode.Contains("S01001") && (x.tray_status == "EmptyTray" || x.location_state == "Empty") && x.enable).ToList(); |
| | | // foreach (var EmptyStation in EmptyStations) |
| | | // { |
| | | // if (agvtaskService.Find(x => x.agv_toaddress == EmptyStation.stationCode).Any()) continue; |
| | | // task.agv_taskstate = "Create"; |
| | | // task.agv_toaddress = EmptyStation.stationCode; |
| | | // EmptyStation.location_state = LocationStateEnum.Busy.ToString(); |
| | | // stationinfoRepository.Update(EmptyStation, true); |
| | | // agvtaskService.Update(task, true); |
| | | // WriteDBLog.Success("æ´æ°åºåºéåä»»å¡", $"ä»»å¡ç¼å·ï¼{task.agv_tasknum}", "PCS"); |
| | | // return; |
| | | // } |
| | | // } |
| | | // } |
| | | // else if (task.agv_tasktype == "TaskType_OutsourceCarry")//ç§»åºå¤å |
| | | // { |
| | | // if (task.agv_toaddress == "") |
| | | // { |
| | | // var TargetLocation = StationTask.GetEmptyLocation(stationinfoRepository); |
| | | // if (TargetLocation != null) |
| | | // { |
| | | // if (agvtaskService.Find(x => x.agv_toaddress == TargetLocation.stationCode).Any()) continue; |
| | | |
| | | // task.agv_taskstate = "Create"; |
| | | // task.agv_toaddress = TargetLocation.stationCode; |
| | | // TargetLocation.location_state = LocationStateEnum.OutBusy.ToString(); |
| | | // TargetLocation.stationType = task.agv_materielid; |
| | | // stationinfoRepository.Update(TargetLocation, true); |
| | | // agvtaskService.Update(task, true); |
| | | // WriteDBLog.Success("æ´æ°ç§»åºå¤åéåä»»å¡", $"ä»»å¡ç¼å·ï¼{task.agv_tasknum}", "PCS"); |
| | | // continue; |
| | | // } |
| | | // } |
| | | // } |
| | | // } |
| | | // catch (Exception ex) |
| | | // { |
| | | // //WriteDBLog.Error("æ´æ°éåä»»å¡", $"é误信æ¯ï¼{ex.Message}", "PCS"); |
| | | // WriteLog.Write_Log("æ´æ°éåä»»å¡", "æ´æ°å¤±è´¥", "", $"é误信æ¯ï¼{ex.Message}"); |
| | | // } |
| | | //} |
| | | #endregion |
| | | |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | WriteDBLog.Error("æ´æ°éåä»»å¡", $"é误信æ¯ï¼{ex.Message}", "PCS"); |
| | | } |
| | | } |
| | | |
| | | public static void UpdateQueue(Idt_agvtaskRepository agvtaskService, dt_agvtask agvtask) |
| | | { |
| | | VOLContext Context = new VOLContext(); |
| | | Idt_stationinfoRepository stationinfoRepository = new dt_stationinfoRepository(Context); |
| | | IVV_Mes_WorkinfoRepository workinfoRepository = new VV_Mes_WorkinfoRepository(Context); |
| | | try |
| | | { |
| | | if (agvtask.agv_tasktype == AGVTaskTypeEnum.TaskType_EmptyPallet.ToString())//空æä»»å¡ |
| | | { |
| | | if (agvtask.agv_fromaddress == "" && DateTime.Now - agvtask.agv_createtime >= TimeSpan.FromMinutes(2)) |
| | | { |
| | | if (task.agv_tasktype == "TaskType_EmptyPallet")//空æä»»å¡ |
| | | if (agvtask.agv_tasknum.Contains("_")) |
| | | { |
| | | if (task.agv_fromaddress == "" && DateTime.Now - task.agv_createtime >= TimeSpan.FromMinutes(2)) |
| | | { |
| | | if (task.agv_tasknum.Contains("_")) |
| | | { |
| | | string mainTaskNum = task.agv_tasknum.Split('_')[0]; |
| | | if (agvtaskService.Find(x => x.agv_tasknum == mainTaskNum && task.agv_taskstate != "Executing" && task.agv_taskstate != "Create").Any() || !agvtaskService.Find(x => x.agv_tasknum == mainTaskNum).Any()) |
| | | GetStation.EmptyPalletStation(task); |
| | | } |
| | | else |
| | | GetStation.EmptyPalletStation(task); |
| | | string mainTaskNum = agvtask.agv_tasknum.Split('_')[0]; |
| | | if (agvtaskService.Find(x => x.agv_tasknum == mainTaskNum && agvtask.agv_taskstate != AGVTaskStateEnum.Executing.ToString() && agvtask.agv_taskstate != AGVTaskStateEnum.Create.ToString()).Any() || !agvtaskService.Find(x => x.agv_tasknum == mainTaskNum).Any()) |
| | | GetStation.EmptyPalletStation(agvtask); |
| | | } |
| | | else |
| | | GetStation.EmptyPalletStation(agvtask); |
| | | |
| | | WriteDBLog.Success("æ´æ°ç©ºæéåä»»å¡", $"ä»»å¡ç¼å·ï¼{task.agv_tasknum}", "PCS"); |
| | | continue; |
| | | } |
| | | } |
| | | else if (task.agv_tasktype == "TaskType_OutsourceInbound" || task.agv_tasktype == "TaskType_Inbound")//å¤ååºå
¥åº/ABåºå
¥åº |
| | | WriteDBLog.Success("æ´æ°ç©ºæéåä»»å¡", $"ä»»å¡ç¼å·ï¼{agvtask.agv_tasknum}", "PCS"); |
| | | } |
| | | } |
| | | else if (agvtask.agv_tasktype == AGVTaskTypeEnum.TaskType_OutsourceInbound.ToString() || agvtask.agv_tasktype == AGVTaskTypeEnum.TaskType_Inbound.ToString())//å¤ååºå
¥åº/ABåºå
¥åº |
| | | { |
| | | if (agvtask.agv_toaddress == "") |
| | | { |
| | | var stationinfo = stationinfoRepository.Find(x => x.stationCode == agvtask.agv_fromaddress).FirstOrDefault(); |
| | | var work = workinfoRepository.Find(x => x.workOrder == stationinfo.Number && x.drawingNo == stationinfo.stationType && x.heatID == stationinfo.heatNumber && x.processCode == "17").FirstOrDefault(); |
| | | var TargetLocation = agvtask.agv_tasktype == AGVTaskTypeEnum.TaskType_Inbound.ToString() ? GetLocation.GetEmptyLocation(stationinfoRepository, work, agvtask) : StationTask.GetEmptyLocation(stationinfoRepository); |
| | | if (TargetLocation != null) |
| | | { |
| | | if (task.agv_toaddress == "") |
| | | if (!agvtaskService.Find(x => x.agv_toaddress == TargetLocation.stationCode).Any()) |
| | | { |
| | | var stationinfo = stationinfoRepository.Find(x => x.stationCode == task.agv_fromaddress).FirstOrDefault(); |
| | | var work = workinfoRepository.Find(x => x.workOrder == stationinfo.Number && x.drawingNo == stationinfo.stationType && x.heatID == stationinfo.heatNumber && x.processCode == "17").FirstOrDefault(); |
| | | var TargetLocation = task.agv_tasktype == "TaskType_Inbound" ? GetLocation.GetEmptyLocation(stationinfoRepository, work, task) : StationTask.GetEmptyLocation(stationinfoRepository); |
| | | if (TargetLocation != null) |
| | | { |
| | | if (agvtaskService.Find(x => x.agv_toaddress == TargetLocation.stationCode).Any()) continue; |
| | | task.agv_taskstate = "Create"; |
| | | task.agv_toaddress = TargetLocation.stationCode; |
| | | TargetLocation.location_state = LocationStateEnum.InBusy.ToString(); |
| | | TargetLocation.billetID = stationinfo.billetID; |
| | | TargetLocation.stationType = task.agv_materielid; |
| | | TargetLocation.heatNumber = stationinfo.heatNumber; |
| | | TargetLocation.Number = task.jobID; |
| | | stationinfoRepository.Update(TargetLocation, true); |
| | | agvtaskService.Update(task, true); |
| | | WriteDBLog.Success("æ´æ°å
¥åºéåä»»å¡", $"ä»»å¡ç¼å·ï¼{task.agv_tasknum}", "PCS"); |
| | | continue; |
| | | } |
| | | } |
| | | } |
| | | else if (task.agv_tasktype == "TaskType_OutsourceOutbound" || task.agv_tasktype == "TaskType_Outbound")//å¤ååºåºåº/ABåºåºåº |
| | | { |
| | | if (task.agv_toaddress == "") |
| | | { |
| | | var EmptyStations = stationinfoRepository.Find(x => x.stationCode.Contains("S01001") && (x.tray_status == "EmptyTray" || x.location_state == "Empty") && x.enable).ToList(); |
| | | foreach (var EmptyStation in EmptyStations) |
| | | { |
| | | if (agvtaskService.Find(x => x.agv_toaddress == EmptyStation.stationCode).Any()) continue; |
| | | task.agv_taskstate = "Create"; |
| | | task.agv_toaddress = EmptyStation.stationCode; |
| | | EmptyStation.location_state = LocationStateEnum.Busy.ToString(); |
| | | stationinfoRepository.Update(EmptyStation, true); |
| | | agvtaskService.Update(task, true); |
| | | WriteDBLog.Success("æ´æ°åºåºéåä»»å¡", $"ä»»å¡ç¼å·ï¼{task.agv_tasknum}", "PCS"); |
| | | return; |
| | | } |
| | | } |
| | | } |
| | | else if (task.agv_tasktype == "TaskType_OutsourceCarry")//ç§»åºå¤å |
| | | { |
| | | if (task.agv_toaddress == "") |
| | | { |
| | | var TargetLocation = StationTask.GetEmptyLocation(stationinfoRepository); |
| | | if (TargetLocation != null) |
| | | { |
| | | if (agvtaskService.Find(x => x.agv_toaddress == TargetLocation.stationCode).Any()) continue; |
| | | |
| | | task.agv_taskstate = "Create"; |
| | | task.agv_toaddress = TargetLocation.stationCode; |
| | | TargetLocation.location_state = LocationStateEnum.OutBusy.ToString(); |
| | | TargetLocation.stationType = task.agv_materielid; |
| | | stationinfoRepository.Update(TargetLocation, true); |
| | | agvtaskService.Update(task, true); |
| | | WriteDBLog.Success("æ´æ°ç§»åºå¤åéåä»»å¡", $"ä»»å¡ç¼å·ï¼{task.agv_tasknum}", "PCS"); |
| | | continue; |
| | | } |
| | | agvtask.agv_taskstate = AGVTaskStateEnum.Create.ToString(); |
| | | agvtask.agv_toaddress = TargetLocation.stationCode; |
| | | TargetLocation.location_state = LocationStateEnum.InBusy.ToString(); |
| | | TargetLocation.billetID = stationinfo.billetID; |
| | | TargetLocation.stationType = agvtask.agv_materielid; |
| | | TargetLocation.heatNumber = stationinfo.heatNumber; |
| | | TargetLocation.Number = agvtask.jobID; |
| | | stationinfoRepository.Update(TargetLocation, true); |
| | | agvtaskService.Update(agvtask, true); |
| | | WriteDBLog.Success("æ´æ°å
¥åºéåä»»å¡", $"ä»»å¡ç¼å·ï¼{agvtask.agv_tasknum}", "PCS"); |
| | | } |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | } |
| | | else if (agvtask.agv_tasktype == AGVTaskTypeEnum.TaskType_OutsourceOutbound.ToString() || agvtask.agv_tasktype == AGVTaskTypeEnum.TaskType_Outbound.ToString())//å¤ååºåºåº/ABåºåºåº |
| | | { |
| | | if (agvtask.agv_toaddress == "") |
| | | { |
| | | //WriteDBLog.Error("æ´æ°éåä»»å¡", $"é误信æ¯ï¼{ex.Message}", "PCS"); |
| | | WriteLog.Write_Log("æ´æ°éåä»»å¡","æ´æ°å¤±è´¥", "", $"é误信æ¯ï¼{ex.Message}"); |
| | | var EmptyStations = stationinfoRepository.Find(x => x.stationCode.Contains("S01001") && (x.tray_status == TrayStateEnum.EmptyTray.ToString() || x.location_state == LocationStateEnum.Empty.ToString()) && x.enable).ToList(); |
| | | foreach (var EmptyStation in EmptyStations) |
| | | { |
| | | if (agvtaskService.Find(x => x.agv_toaddress == EmptyStation.stationCode).Any()) continue; |
| | | agvtask.agv_taskstate = AGVTaskStateEnum.Create.ToString(); |
| | | agvtask.agv_toaddress = EmptyStation.stationCode; |
| | | EmptyStation.location_state = LocationStateEnum.Busy.ToString(); |
| | | stationinfoRepository.Update(EmptyStation, true); |
| | | agvtaskService.Update(agvtask, true); |
| | | WriteDBLog.Success("æ´æ°åºåºéåä»»å¡", $"ä»»å¡ç¼å·ï¼{agvtask.agv_tasknum}", "PCS"); |
| | | return; |
| | | } |
| | | } |
| | | } |
| | | else if (agvtask.agv_tasktype == AGVTaskTypeEnum.TaskType_OutsourceCarry.ToString())//ç§»åºå¤å |
| | | { |
| | | if (agvtask.agv_toaddress == "") |
| | | { |
| | | var TargetLocation = StationTask.GetEmptyLocation(stationinfoRepository); |
| | | if (TargetLocation != null) |
| | | { |
| | | if (!agvtaskService.Find(x => x.agv_toaddress == TargetLocation.stationCode).Any()) |
| | | { |
| | | agvtask.agv_taskstate = AGVTaskStateEnum.Create.ToString(); |
| | | agvtask.agv_toaddress = TargetLocation.stationCode; |
| | | TargetLocation.location_state = LocationStateEnum.OutBusy.ToString(); |
| | | TargetLocation.stationType = agvtask.agv_materielid; |
| | | stationinfoRepository.Update(TargetLocation, true); |
| | | agvtaskService.Update(agvtask, true); |
| | | WriteDBLog.Success("æ´æ°ç§»åºå¤åéåä»»å¡", $"ä»»å¡ç¼å·ï¼{agvtask.agv_tasknum}", "PCS"); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | WriteDBLog.Error("æ´æ°éåä»»å¡", $"é误信æ¯ï¼{ex.Message}", "PCS"); |
| | | WriteLog.Write_Log("æ´æ°éåä»»å¡", "æ´æ°å¤±è´¥", "", $"é误信æ¯ï¼{ex.Message}"); |
| | | } |
| | | } |
| | | } |