反馈MES工单完成

huanghongfeng

2024-07-19 bb929bd0809eefc1108dd779846ff07d997f7ef0

 ´úÂë¹ÜÀí/PCS/WCS_Server/WIDESEA_WCS/JobsPart/Common/RestockHCJ.cs

@@ -1,54 +1,168 @@
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_Core.FreeDB;
using WIDESEA_Comm.LogInfo;
using WIDESEA_Common;
using WIDESEA_Core.BaseProvider;
using WIDESEA_Core.EFDbContext;
using WIDESEA_Entity.DomainModels;
using WIDESEA_Entity.ToAGV;
using WIDESEA_WCS.IRepositories;
using WIDESEA_WCS.Repositories;
using WIDESEA_WCS.WCSClient;
using WIDESEA_WMS.IRepositories;
using WIDESEA_WMS.IServices;
using WIDESEA_WMS.Repositories;
using static FreeSql.Internal.GlobalFilter;
using static System.Collections.Specialized.BitVector32;

namespace WIDESEA_WCS.JobsPart.Common
{
    public class RestockHCJ
    {
        static FreeDB freeDB = new FreeDB();
        public static Dictionary<string, List<string>> areaForList;
        public RestockHCJ()
        {
            if (areaForList == null || areaForList.Count == 0)
            {
                areaForList = new Dictionary<string, List<string>>();
                var stationList = freeDB.Select<dt_stationinfo>().Where(x => true).ToList();
                areaForList.Add("下料区", stationList.Where(x => x.stationCode.Contains("X")).Select(x => x.stationCode).ToList());
            }
        }
        /// <summary>
        /// æ›´æ–°è¡¥ç©ºæ‰˜ä»»åŠ¡
        /// æ›´æ–°é˜Ÿåˆ—任务
        /// </summary>
        public static void HCJGetBarcode()
        {
            var tasks = freeDB.Select<dt_agvtask>().Where(x => x.agv_taskstate == "Queue").ToList();
            foreach (var task in tasks)
            try
            {
                if (task.agv_tasktype == "TaskType_EmptyPallet")//空托任务
                VOLContext Context = new VOLContext();
                Idt_agvtaskRepository agvtaskService = new dt_agvtaskRepository(Context);

                #region é˜Ÿåˆ—任务
                var agvtasks = agvtaskService.Find(x => x.agv_taskstate == AGVTaskStateEnum.Queue.ToString()).ToList();

                var AGVTaskTypes = Enum.GetNames(typeof(AGVTaskTypeEnum));
                foreach (var AGVTaskType in AGVTaskTypes)
                {
                    if (task.agv_fromaddress == "")
                    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);
                    //var tasks = agvtasks.Where(x => x.agv_tasktype == AGVTaskType).OrderByDescending(x => x.agv_grade).ThenBy(x => x.agv_createtime).ToList();
                    //foreach (var task in tasks)
                    //{
                    //    UpdateQueue(agvtaskService, task);
                    //}
                }
                #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);
            Idt_management_timeRepository timeRepository = new dt_management_timeRepository(Context);
            try
            {
                if (agvtask.agv_tasktype == AGVTaskTypeEnum.TaskType_EmptyPallet.ToString())//补空托任务
                {
                    var val = timeRepository.Find(x => x.management_name == AGVTaskTypeEnum.TaskType_EmptyPallet.ToString()).FirstOrDefault().management_numericalvalue;
                    if (string.IsNullOrEmpty(agvtask.agv_fromaddress) && agvtask.agv_toaddress.Contains("W"))
                        GetStation.EmptyPalletStation(agvtask);
                    else if (string.IsNullOrEmpty(agvtask.agv_fromaddress) && DateTime.Now - agvtask.agv_createtime >= TimeSpan.FromMinutes(val))
                    {
                        var area = task.agv_Traytype == "SmallTray" ? "11" : "10";
                        //找1库区的空托位
                        var EmptyStation = freeDB.Select<dt_stationinfo>().Where(x => x.area == area && x.stationCode.Contains("A") && x.location_state == LocationStateEnum.Stroge.ToString() && x.enable)
                            .OrderByDescending(x => x.column).OrderBy(x => x.line).First();
                        if (EmptyStation == null)
                            EmptyStation = freeDB.Select<dt_stationinfo>().Where(x => x.area == area && x.stationCode.Contains("C") && x.location_state == LocationStateEnum.Stroge.ToString() && x.enable)
                            .OrderBy(x => x.line).OrderByDescending(x => x.column).First();
                        if (EmptyStation != null)
                        if (agvtask.agv_tasknum.Contains("_"))
                        {
                            task.agv_fromaddress = EmptyStation.stationCode;
                            task.agv_taskstate = "Create";
                            freeDB.Update(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);
                    }
                }
                else if (agvtask.agv_tasktype == AGVTaskTypeEnum.TaskType_OutsourceInbound.ToString() || agvtask.agv_tasktype == AGVTaskTypeEnum.TaskType_Inbound.ToString())//外协库入库/AB库入库
                {
                    if (string.IsNullOrEmpty(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").OrderByDescending(x => x.CreateTime).FirstOrDefault();
                        var TargetLocation = agvtask.agv_tasktype == AGVTaskTypeEnum.TaskType_Inbound.ToString() ? GetLocation.GetEmptyLocation(stationinfoRepository, work, agvtask) : 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.InBusy.ToString();
                                TargetLocation.billetID = stationinfo.billetID;
                                TargetLocation.stationType = agvtask.agv_materielid;
                                TargetLocation.heatNumber = stationinfo.heatNumber;
                                TargetLocation.Number = agvtask.jobID;
                                stationinfoRepository.Update(TargetLocation, x => new { x.location_state, x.billetID, x.stationType, x.heatNumber, x.Number }, true);
                                agvtaskService.Update(agvtask, x => new { x.agv_taskstate, x.agv_toaddress }, true);
                                WriteDBLog.Success("更新入库队列任务", $"任务编号：{agvtask.agv_tasknum}", "PCS");
                            }
                        }
                        else
                        {
                            if (agvtask.agv_tasktype == AGVTaskTypeEnum.TaskType_Inbound.ToString())
                            {
                                agvtask.agv_tasktype = AGVTaskTypeEnum.TaskType_OutsourceInbound.ToString();
                                agvtaskService.Update(agvtask, x => new { x.agv_tasktype }, true);
                            }
                        }
                    }
                }
                else if (agvtask.agv_tasktype == AGVTaskTypeEnum.TaskType_OutsourceOutbound.ToString() || agvtask.agv_tasktype == AGVTaskTypeEnum.TaskType_Outbound.ToString())//外协库出库/AB库出库
                {
                    if (string.IsNullOrEmpty(agvtask.agv_toaddress))
                    {
                        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();
                        var EmptyStations = stationinfoRepository.Find(x => x.stationCode.Contains("S01001") && 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 (string.IsNullOrEmpty(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)
            {
                WriteLog.Write_Log("更新队列任务", "更新失败", "", $"错误信息：{ex.Message}");
            }
        }
    }