分支自 SuZhouGuanHong/TaiYuanTaiZhong

dengjunjie
2024-05-07 46f7bf1ee45c97b688a370bbe45d149efb403cc1
´úÂë¹ÜÀí/PCS/WCS_Server/WIDESEA_WCS/JobsPart/Common/RestockHCJ.cs
@@ -1,11 +1,14 @@
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;
@@ -31,104 +34,214 @@
            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 == "" && agvtask.agv_toaddress.Contains("W"))
                        GetStation.EmptyPalletStation(agvtask);
                    else 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);
                                WriteDBLog.Success("更新空托队列任务", $"任务编号:{task.agv_tasknum}", "PCS");
                                continue;
                            }
                            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 if (task.agv_tasktype == "TaskType_OutsourceInbound" || task.agv_tasktype == "TaskType_Inbound")//外协库入库/AB库入库
                        else
                            GetStation.EmptyPalletStation(agvtask);
                    }
                    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}");
                        if (agvtask.agv_tasktype == AGVTaskTypeEnum.TaskType_Outbound.ToString())
                            if (GetStation.QueueStation(agvtask.agv_fromaddress)) return;//限制一行一次只能出一个任务
                        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 == "")
                    {
                        if (GetStation.QueueStation(agvtask.agv_fromaddress)) return;//限制一行一次只能出一个任务
                        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}");
            }
        }
    }