| | |
| | | using log4net.Core; |
| | | |
| | | using log4net.Core; |
| | | using Mapster; |
| | | using Masuit.Tools; |
| | | using Masuit.Tools.Models; |
| | | using OfficeOpenXml.FormulaParsing.Excel.Functions.Math; |
| | | using SixLabors.Fonts.Tables.AdvancedTypographic; |
| | | using System.Diagnostics; |
| | | using WIDESEA_Common; |
| | | using WIDESEA_Core.Const; |
| | | using WIDESEA_DTO; |
| | | using WIDESEA_DTO.MOM; |
| | | using WIDESEA_DTO.WMS; |
| | |
| | | using WIDESEA_StoragIntegrationServices; |
| | | using WIDESEAWCS_Model.Models; |
| | | |
| | | namespace WIDESEA_StorageOutTaskServices; |
| | | namespace WIDESEA_StorageTaskServices; |
| | | |
| | | public partial class Dt_TaskService : ServiceBase<Dt_Task, IDt_TaskRepository>, IDt_TaskService |
| | | { |
| | |
| | | } |
| | | } |
| | | |
| | | // 创建一个TrayCellsStatusDto对象,并赋值 |
| | | //if (input.area != 3) |
| | | //{ |
| | | // if (input.PalletCode == null || input.PalletCode.Trim() == "") |
| | | // return content.Error("托盘条码为空"); |
| | | //} |
| | | //创建一个TrayCellsStatusDto对象,并赋值 |
| | | //TrayCellsStatusDto trayCells = new TrayCellsStatusDto() |
| | | //{ |
| | | // Software = "WMS", |
| | |
| | | // EquipmentCode = input.EquiCodeMOM |
| | | //}; |
| | | |
| | | //// 调用GetTrayCellStatusAsync方法,获取整盘电芯 |
| | | // 调用GetTrayCellStatusAsync方法,获取整盘电芯 |
| | | //content = await GetTrayCellStatusAsync(trayCells); |
| | | //// 如果状态为false,则返回content |
| | | // 如果状态为false,则返回content |
| | | //if (!content.Status) return content; |
| | | |
| | | //// 添加组盘信息 |
| | | //// 将content.Data转换为ResultTrayCellsStatus对象 |
| | | // 添加组盘信息 |
| | | // 将content.Data转换为ResultTrayCellsStatus对象 |
| | | //var result = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); |
| | | //if (result.SerialNos.Count <= 0) |
| | | // return content.Error(result.MOMMessage); |
| | |
| | | //// return content.Error("料框属性不存在"); |
| | | |
| | | //// 调用CreateBoxingInfo方法,创建组盘信息 |
| | | |
| | | //var boxing = await CreateBoxingInfo(result, input.PalletCode); |
| | | //var boxing = CreateBoxingInfo(result, input.PalletCode); |
| | | //if (boxing == null) return content.Error("组盘失败"); |
| | | |
| | | //// 调用GetProcessApplyAsync方法,获取工艺路线 |
| | |
| | | |
| | | if (stationinfo == null) throw new Exception("未知站台"); |
| | | |
| | | |
| | | if (stationinfo.stationType != 7) |
| | | { |
| | | if (input.PalletCode == null || input.PalletCode.Trim() == "") |
| | | return content.Error($"【{stationinfo.remark}】托盘条码为空"); |
| | | } |
| | | var task = await CreateNewTaskByStation(input, stationinfo); |
| | | |
| | | // 创建新任务实例 |
| | |
| | | TaskType = task.TaskType, |
| | | }; |
| | | content.OK(data: taskDTO); |
| | | |
| | | |
| | | } |
| | | else |
| | | content.Error("添加任务失败"); |
| | |
| | | case 1: |
| | | task = await CreateInTaskAsync(input, stationManager); break; |
| | | //case 2: |
| | | //case 3: //异常排出给WCS处理 |
| | | case 3: //异常排出给WCS处理 |
| | | //case 4: |
| | | case 5: |
| | | task = await CreateInToOutTaskAsync(input, stationManager); break; |
| | | |
| | | case 7: |
| | | task = await CreateEmptyOutTaskAsync(input, stationManager); break; |
| | | default: |
| | | throw new Exception("位置站台类型"); |
| | | throw new Exception("未知站台类型"); |
| | | } |
| | | return task; |
| | | } |
| | |
| | | #region 直接出库任务 |
| | | private async Task<Dt_Task> CreateInToOutTaskAsync(RequestTaskDto input, Dt_StationManager stationManager) |
| | | { |
| | | if (stationManager.stationType != 5) throw new Exception("错误的调取"); |
| | | //if (stationManager.stationType != 5) throw new Exception("错误的调取"); |
| | | |
| | | |
| | | input.EquiCodeMOM = "24MEJQ11-1006-1"; |
| | | |
| | | // 创建一个TrayCellsStatusDto对象,并赋值 |
| | | TrayCellsStatusDto trayCells = new TrayCellsStatusDto() |
| | | { |
| | | Software = "WMS", |
| | | TrayBarcode = input.PalletCode, |
| | | //EquipmentCode = "EQ_CWJZ01" |
| | | EquipmentCode = input.EquiCodeMOM |
| | | }; |
| | | |
| | | // 调用GetTrayCellStatusAsync方法,获取整盘电芯 |
| | | WebResponseContent content = await GetTrayCellStatusAsync(trayCells); |
| | | // 如果状态为false,则返回content |
| | | if (!content.Status) throw new Exception(content.Message); |
| | | |
| | | // 添加组盘信息 |
| | | // 将content.Data转换为ResultTrayCellsStatus对象 |
| | | var result = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); |
| | | if (result.SerialNos.Count <= 0) |
| | | { |
| | | ConsoleHelper.WriteErrorLine(result.MOMMessage); |
| | | if (stationManager.stationType != 3) |
| | | { |
| | | var taskNG = new Dt_Task |
| | | { |
| | | CurrentAddress = input.Position, |
| | | Grade = 1, |
| | | Roadway = input.Roadways, |
| | | TargetAddress = stationManager.stationNGLocation, |
| | | Dispatchertime = DateTime.Now, |
| | | MaterialNo = "", |
| | | NextAddress = stationManager.stationNGChildCode, |
| | | OrderNo = null, |
| | | PalletCode = input.PalletCode, |
| | | SourceAddress = stationManager.stationLocation, |
| | | TaskState = (int)TaskInStatusEnum.Line_InFinish, |
| | | TaskType = (int)TaskOutboundTypeEnum.InToOut, |
| | | TaskNum = await BaseDal.GetTaskNo(), |
| | | Creater = "Systeam" |
| | | }; |
| | | return taskNG; |
| | | } |
| | | } |
| | | |
| | | // 处理异常电芯情况 |
| | | var serialNosError = result.SerialNos.Where(x => x.SerialNoStatus != 1).ToList(); |
| | | if (serialNosError.Count > 0) |
| | | { |
| | | if (stationManager.stationType != 3) |
| | | { |
| | | var taskNG = new Dt_Task |
| | | { |
| | | CurrentAddress = input.Position, |
| | | Grade = 1, |
| | | Roadway = input.Roadways, |
| | | TargetAddress = stationManager.stationNGLocation, |
| | | Dispatchertime = DateTime.Now, |
| | | MaterialNo = "", |
| | | NextAddress = stationManager.stationNGChildCode, |
| | | OrderNo = null, |
| | | PalletCode = input.PalletCode, |
| | | SourceAddress = stationManager.stationLocation, |
| | | TaskState = (int)TaskInStatusEnum.Line_InFinish, |
| | | TaskType = (int)TaskOutboundTypeEnum.OutNG, |
| | | TaskNum = await BaseDal.GetTaskNo(), |
| | | Creater = "Systeam" |
| | | }; |
| | | return taskNG; |
| | | } |
| | | } |
| | | |
| | | var targetStation = _stationManagerRepository.QueryFirst(x => x.stationPLC == stationManager.stationPLC && x.Roadway == stationManager.Roadway && x.stationType == 2); |
| | | |
| | |
| | | { |
| | | if (stationManager.stationType != 1 && stationManager.stationType != 6) throw new Exception("错误的调取"); |
| | | |
| | | DtLocationInfo locationInfo = await RequestLocation(input); |
| | | DtLocationInfo locationInfo = null; |
| | | if (stationManager.stationType == 1 && stationManager.Roadway.Contains("FR")) |
| | | { |
| | | locationInfo = await RequestLocation(input, true); |
| | | } |
| | | else |
| | | { |
| | | locationInfo = await RequestLocation(input); |
| | | } |
| | | //DtLocationInfo locationInfo = await RequestLocation(input); |
| | | |
| | | if (locationInfo == null) throw new Exception("库位已满"); |
| | | |
| | |
| | | EquipmentCode = input.EquiCodeMOM |
| | | }; |
| | | |
| | | //// 调用GetTrayCellStatusAsync方法,获取整盘电芯 |
| | | //content = await GetTrayCellStatusAsync(trayCells); |
| | | //// 如果状态为false,则返回content |
| | | //if (!content.Status) return content; |
| | | // 调用GetTrayCellStatusAsync方法,获取整盘电芯 |
| | | WebResponseContent content = await GetTrayCellStatusAsync(trayCells); |
| | | // 如果状态为false,则返回content |
| | | if (!content.Status) throw new Exception(content.Message); |
| | | |
| | | //// 添加组盘信息 |
| | | //// 将content.Data转换为ResultTrayCellsStatus对象 |
| | | //var result = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); |
| | | //if (result.SerialNos.Count <= 0) |
| | | // return content.Error(result.MOMMessage); |
| | | // 添加组盘信息 |
| | | // 将content.Data转换为ResultTrayCellsStatus对象 |
| | | var result = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); |
| | | if (result.SerialNos.Count <= 0) |
| | | { |
| | | ConsoleHelper.WriteErrorLine(result.MOMMessage); |
| | | var taskNG = new Dt_Task |
| | | { |
| | | CurrentAddress = input.Position, |
| | | Grade = 1, |
| | | Roadway = input.Roadways, |
| | | TargetAddress = stationManager.stationNGLocation, |
| | | Dispatchertime = DateTime.Now, |
| | | MaterialNo = "", |
| | | NextAddress = stationManager.stationNGChildCode, |
| | | OrderNo = null, |
| | | PalletCode = input.PalletCode, |
| | | SourceAddress = stationManager.stationLocation, |
| | | TaskState = (int)TaskInStatusEnum.Line_InFinish, |
| | | TaskType = (int)TaskOutboundTypeEnum.InToOut, |
| | | TaskNum = await BaseDal.GetTaskNo(), |
| | | Creater = "Systeam" |
| | | }; |
| | | return taskNG; |
| | | } |
| | | |
| | | //Console.WriteLine(result); |
| | | //// TODO 获取本地料框属性与整盘电芯属性获取的值进行对比,如果一致则继续,否则返回错误信息 |
| | |
| | | //// return content.Error("料框属性不存在"); |
| | | |
| | | //// 调用CreateBoxingInfo方法,创建组盘信息 |
| | | |
| | | //var boxing = await CreateBoxingInfo(result, input.PalletCode); |
| | | //if (boxing == null) return content.Error("组盘失败"); |
| | | var boxing = CreateBoxingInfo(result, input.PalletCode); |
| | | if (boxing == null) throw new Exception("组盘失败"); |
| | | |
| | | //// 调用GetProcessApplyAsync方法,获取工艺路线 |
| | | //ProcessApplyDto process = await GetProcessApplyAsync(input, result); |
| | |
| | | |
| | | ////// 调用GetProcessResponseAsync方法,获取工艺响应 |
| | | ////var processResponse = await GetProcessResponseAsync(process, input.Position); |
| | | var isBox = await _boxingInfoRepository.AddDataNavAsync(boxing); |
| | | } |
| | | |
| | | var task = new Dt_Task |
| | |
| | | TaskNum = await BaseDal.GetTaskNo(), |
| | | Creater = "Systeam" |
| | | }; |
| | | |
| | | ConsoleHelper.WriteSuccessLine($"修改前:" + locationInfo.LocationStatus.ToString()); |
| | | locationInfo.LocationStatus = (int)LocationEnum.FreeDisable; |
| | | ConsoleHelper.WriteSuccessLine($"修改后:" + locationInfo.LocationStatus.ToString()); |
| | | await UpdateLocationAsync(locationInfo); |
| | | |
| | | return task; |
| | |
| | | /// </summary> |
| | | /// <param name="requestTask">请求参数</param> |
| | | /// <returns></returns> |
| | | private async Task<DtLocationInfo> RequestLocation(RequestTaskDto requestTask) |
| | | private async Task<DtLocationInfo> RequestLocation(RequestTaskDto requestTask, bool isCheckRequest = false) |
| | | { |
| | | #region 获取货位 |
| | | try |
| | | { |
| | | List<DtLocationInfo> locations; |
| | | if (requestTask.Roadways.Contains("FR")) |
| | | if (isCheckRequest) |
| | | { |
| | | locations = await _locationRepository.QueryDataAsync(x => x.LocationStatus == (int)LocationEnum.Free && x.RoadwayNo == requestTask.Roadways && x.EnalbeStatus == 1 && x.LocationType == 2 && x.Remark == "1"); |
| | | } |
| | | else |
| | | { |
| | | locations = await _locationRepository.QueryDataAsync(x => x.LocationStatus == (int)LocationEnum.Free && x.RoadwayNo == requestTask.Roadways && x.EnalbeStatus == 1 && x.LocationType == 1); |
| | | locations = await _locationRepository.QueryDataAsync(x => x.LocationStatus == (int)LocationEnum.Distribute && x.RoadwayNo == requestTask.Roadways && x.EnalbeStatus == 1 && x.LocationType == 1); |
| | | } |
| | | |
| | | if (locations == null) |
| | |
| | | return null; |
| | | } |
| | | #endregion 获取货位 |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | // 获取工艺申请 |
| | |
| | | }; |
| | | } |
| | | |
| | | #endregion 请求任务入库 |
| | | #endregion 请求空框出库 |
| | | |
| | | public async Task<Dt_Task> CreateEmptyOutTaskAsync(RequestTaskDto input, Dt_StationManager stationManager) |
| | | { |
| | | try |
| | | { |
| | | if (stationManager.stationType != 7) throw new Exception("错误的调取"); |
| | | |
| | | var stockinfo = await _stockInfoRepository.Db.Queryable<DtStockInfo>() |
| | | .Includes(x => x.LocationInfo) |
| | | //.Includes(x=>x.StockInfoDetails) |
| | | .Where(x => !x.IsFull && x.LocationInfo.RoadwayNo == stationManager.Roadway) |
| | | .OrderBy(x => x.CreateDate) |
| | | .FirstAsync(); |
| | | |
| | | if (stockinfo == null) return null; |
| | | |
| | | var task = new Dt_Task |
| | | { |
| | | CurrentAddress = input.Position, |
| | | Grade = 1, |
| | | Roadway = input.Roadways, |
| | | TargetAddress = stationManager.stationLocation, |
| | | Dispatchertime = DateTime.Now, |
| | | MaterialNo = "", |
| | | NextAddress = input.Roadways, |
| | | OrderNo = null, |
| | | PalletCode = stockinfo.PalletCode, |
| | | SourceAddress = stockinfo.LocationCode, |
| | | TaskState = (int)TaskOutStatusEnum.OutNew, |
| | | TaskType = (int)TaskOutboundTypeEnum.OutTray, |
| | | TaskNum = await BaseDal.GetTaskNo(), |
| | | Creater = "Systeam" |
| | | }; |
| | | |
| | | return task; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | |
| | | throw new Exception(ex.Message); |
| | | } |
| | | } |
| | | |
| | | |
| | | #region 直接出库任务完成 |
| | | public async Task<WebResponseContent> CompleteInToOutTaskAsync(Dt_Task task) |
| | | { |
| | | WebResponseContent content = new WebResponseContent(); |
| | |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return content.Error (ex.Message); |
| | | return content.Error(ex.Message); |
| | | } |
| | | |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region 检测高温库是否有可出库库存 |
| | | |
| | | public WebResponseContent StockCheckingAsync() |
| | | { |
| | | |
| | | WebResponseContent webResponseContent = new WebResponseContent(); |
| | | try |
| | | { |
| | | Task.Run(async () => |
| | | { |
| | | while (true) |
| | | { |
| | | try |
| | | { |
| | | Thread.Sleep(10000); |
| | | var area = await _areaInfoRepository.QueryFirstAsync(x => x.AreaCode == "GWSC1"); |
| | | |
| | | var stockInfo = await _stockInfoRepository.Db.Queryable<DtStockInfo>() |
| | | .Includes(x => x.LocationInfo) // 预加载LocationInfo |
| | | .Includes(x => x.StockInfoDetails) // 预加载StockInfoDetails |
| | | .Where(x => x.AreaCode == area.AreaCode && x.OutboundTime < DateTime.Now && x.IsFull == true) // 过滤条件 |
| | | .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && x.LocationInfo.AreaId == area.AreaID) // 过滤条件 |
| | | .OrderBy(x => x.OutboundTime) // 排序 |
| | | .ToListAsync(); // 获取第一个元素 |
| | | |
| | | if (stockInfo.Count <= 0) continue; |
| | | foreach (var item in stockInfo) |
| | | { |
| | | |
| | | var hasTask = BaseDal.QueryFirst(x => x.PalletCode == item.PalletCode); |
| | | if (hasTask != null) |
| | | { |
| | | Console.WriteLine("已存在出库任务"); |
| | | continue; |
| | | } |
| | | |
| | | string position = string.Empty; |
| | | if (item.LocationInfo.RoadwayNo == "GWSC1") |
| | | position = "1059"; |
| | | else |
| | | position = "1065"; |
| | | |
| | | var task = CreateTask(item, position, (int)TaskOutboundTypeEnum.Outbound); |
| | | task.NextAddress = "002-000-002"; |
| | | // 创建任务DTO |
| | | WMSTaskDTO taskDTO = CreateTaskDTO(task); |
| | | |
| | | |
| | | var configs = _configService.GetConfigsByCategory(CateGoryConst.CONFIG_SYS_IPAddress); |
| | | var wmsBase = configs.FirstOrDefault(x => x.ConfigKey == SysConfigConst.WCSIPAddress)?.ConfigValue; |
| | | var ipAddress = configs.FirstOrDefault(x => x.ConfigKey == SysConfigConst.ReceiveTask)?.ConfigValue; |
| | | if (wmsBase == null || ipAddress == null) |
| | | { |
| | | throw new InvalidOperationException("WMS IP 未配置"); |
| | | } |
| | | var wmsIpAddress = wmsBase + ipAddress; |
| | | |
| | | var result = HttpHelper.PostAsync(wmsIpAddress, taskDTO.ToJsonString()).Result; |
| | | var content = JsonConvert.DeserializeObject<WebResponseContent>(result); |
| | | if (content.Status) |
| | | { |
| | | await BaseDal.AddDataAsync(task); |
| | | // 更新库存位置状态为不可用 |
| | | item.LocationInfo.LocationStatus = (int)LocationEnum.InStockDisable; |
| | | await _locationRepository.UpdateDataAsync(item.LocationInfo); |
| | | } |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | Console.WriteLine(ex.Message); |
| | | } |
| | | } |
| | | }); |
| | | return webResponseContent.OK(); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | Console.WriteLine(ex.Message.ToString()); |
| | | return webResponseContent.Error(ex.Message); |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #region 常温补空托盘至分容 |
| | | |
| | | public async Task<WebResponseContent> GetFROutTrayToCW(RequestTaskDto taskDTO) |
| | | { |
| | | WebResponseContent content = new WebResponseContent(); |
| | | try |
| | | { |
| | | var station = _stationManagerRepository.QueryFirst(x => x.stationChildCode == taskDTO.Position); |
| | | var locations = _locationRepository.QueryData(x => x.RoadwayNo == station.Roadway && x.LocationStatus == (int)LocationEnum.Free && x.LocationType == 1); |
| | | |
| | | if (locations.Count > 10) |
| | | { |
| | | ConsoleHelper.WriteColorLine(locations.Count.ToString(), ConsoleColor.Blue); |
| | | |
| | | var location = locations.OrderBy(x => x.Layer).ThenBy(x => x.Column).ThenBy(x => x.Row).FirstOrDefault(); |
| | | |
| | | var stockInfo = await QueryStockInfoForEmptyTrayAsync("CWSC1", new List<string>()); |
| | | |
| | | if (stockInfo != null) |
| | | { |
| | | var task = CreateTask(stockInfo, taskDTO.Position, (int)TaskOutboundTypeEnum.OutTray); |
| | | |
| | | // 创建任务DTO |
| | | WMSTaskDTO wmsTask = CreateTaskDTO(task); |
| | | |
| | | // 更新库存位置状态为不可用 |
| | | stockInfo.LocationInfo.LocationStatus = (int)LocationEnum.InStockDisable; |
| | | location.LocationStatus = (int)LocationEnum.Distribute; |
| | | await _unitOfWorkManage.UseTranAsync(async () => |
| | | { |
| | | await BaseDal.AddDataAsync(task); |
| | | await _locationRepository.UpdateDataAsync(stockInfo.LocationInfo); |
| | | await _locationRepository.UpdateDataAsync(location); |
| | | }); |
| | | |
| | | // 返回成功响应 |
| | | return content.OK(data: wmsTask); |
| | | } |
| | | else |
| | | content.Error("常温空托盘数量不足"); |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | content.Error(ex.Message); |
| | | } |
| | | return content; |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | } |