| | |
| | | using log4net.Core; |
| | | using Mapster; |
| | | using Masuit.Tools; |
| | | using Masuit.Tools.Models; |
| | | using WIDESEA_DTO.MOM; |
| | | using WIDESEA_DTO.WMS; |
| | | using WIDESEA_IStorageBasicRepository; |
| | |
| | | private readonly IProcessApplyService _processApplyService; //工艺路线 |
| | | private readonly IDt_AreaInfoRepository _areaInfoRepository; //区域 |
| | | private readonly IAgingInOrOutInputService _agingInOrOutInputService; //静置\陈化 |
| | | private readonly IProductionRepository _productionRepository; //生产 |
| | | |
| | | public Dt_TaskService(IDt_TaskRepository BaseDal, |
| | | IUnitOfWorkManage unitOfWorkManage, |
| | |
| | | IProcessApplyService processApplyService, |
| | | IDt_AreaInfoRepository areaInfoRepository, |
| | | IAgingInOrOutInputService agingInOrOutInputService, |
| | | IStockInfoDetailRepository stockInfoDetailRepository) : base(BaseDal) |
| | | IStockInfoDetailRepository stockInfoDetailRepository, |
| | | IProductionRepository productionRepository) : base(BaseDal) |
| | | { |
| | | _unitOfWorkManage = unitOfWorkManage; |
| | | _outOrderRepository = outOrderRepository; |
| | |
| | | _areaInfoRepository = areaInfoRepository; |
| | | _agingInOrOutInputService = agingInOrOutInputService; |
| | | _stockInfoDetailRepository = stockInfoDetailRepository; |
| | | _productionRepository = productionRepository; |
| | | } |
| | | |
| | | #region 外部接口方法 |
| | | |
| | | #region 出库任务完成 |
| | | |
| | | /// <summary> |
| | | /// 出库任务完成 |
| | | /// </summary> |
| | | /// <param name="saveModel">任务数据合集</param> |
| | | /// <returns>返回结果集</returns> |
| | | //public async Task<WebResponseContent> CompleteStackTaskAsync(Dt_Task task, DtStockInfo stock) |
| | | //{ |
| | | // WebResponseContent content = new WebResponseContent(); |
| | | // try |
| | | // { |
| | | // if (task.TaskType == (int)TaskOutboundTypeEnum.Outbound) |
| | | // { |
| | | // var process = await SqlSugarHelper.Db.Queryable<Dt_EquipmentProcess>() |
| | | // .FirstAsync(x => x.EquipmentName == task.Roadway); |
| | | // EquipmentParameterInfo info = JsonConvert.DeserializeObject<EquipmentParameterInfo>(process.ProcessValue); |
| | | // AgingOutputDto agingOutputDto = new AgingOutputDto() |
| | | // { |
| | | // OpFlag = 1, |
| | | // EquipmentCode = stock.LocationInfo.RoadwayNo, |
| | | // TrayBarcode = stock.PalletCode, |
| | | // SerialNos = stock.StockInfoDetails.Select(x => new SerialNoOutDto() |
| | | // { |
| | | // SlotNo = x.OrderNo.ToInt32(), |
| | | // SerialNo = x.SerialNumber, |
| | | // SerialNoResult = true, |
| | | // ParameterInfo = new List<ParameterInfo>() |
| | | // { |
| | | // new ParameterInfo() |
| | | // { |
| | | // LowerLomit =info.LowerControlLimit, |
| | | // UpperLimit = info.UpperControlLimit, |
| | | // ParameterResult = info.EquipmentAvailabilityFlag, |
| | | // ParameterCode = info.ParameterCode, |
| | | // ParameterDesc = info.Description, |
| | | // TargetValue = info.TargetValue, |
| | | // Value = info.TargetValue, |
| | | // DefectCode = info.UOMCode |
| | | // } |
| | | // } |
| | | // }).ToList() |
| | | // }; |
| | | // content = await _agingInOrOutInputService.GetOCVOutputAsync(agingOutputDto); |
| | | // var result = JsonConvert.DeserializeObject<BasicResult>(content.ToString()); |
| | | // if (!result.Success) |
| | | // { |
| | | // throw new Exception(result.MOMMessage); |
| | | // } |
| | | // } |
| | | // // 更新库存状态 |
| | | // var loation = _locationRepository.QueryFirst(x => x.LocationCode == task.SourceAddress); |
| | | // var detail = _stockInfoDetailRepository.QueryData(x => x.StockId == stock.Id); |
| | | |
| | | // // 设置库位状态为空闲 |
| | | // loation.LocationStatus = LocationEnum.Free.ObjToInt(); |
| | | |
| | | // // 更新任务状态 |
| | | // task.TaskState = TaskOutStatusEnum.OutFinish.ObjToInt(); |
| | | // task.CurrentAddress = task.NextAddress; |
| | | // task.NextAddress = task.TargetAddress; |
| | | |
| | | // LogFactory.GetLog("任务完成").InfoFormat(true, "堆垛机出库完成", "更新库存状态与任务状态"); |
| | | |
| | | // // 事务处理 |
| | | // // 开始事务 |
| | | // _unitOfWorkManage.BeginTran(); |
| | | // // 删除库存信息 |
| | | // var isStockUpdated = _stockInfoRepository.DeleteDataById(stock.Id); |
| | | // // 删除库存信息 |
| | | // var isStockDetailUpdated = _stockInfoDetailRepository.DeleteDataByIds(detail.Select(x => (object)x.Id).ToArray()); |
| | | // // 删除任务信息 |
| | | // var isTaskUpdated = BaseDal.DeleteDataById(task.TaskId); |
| | | |
| | | // // 如果库存信息和任务信息都更新成功 |
| | | // if (isStockUpdated && isTaskUpdated && isStockDetailUpdated) |
| | | // { |
| | | // // 记录日志 |
| | | // LogFactory.GetLog("任务完成").InfoFormat(true, "堆垛机出库完成", $"事务处理完成,库存状态更新:{isStockUpdated},任务状态更新:{isTaskUpdated}"); |
| | | // // 提交事务 |
| | | // _unitOfWorkManage.CommitTran(); |
| | | // // 返回成功结果 |
| | | // return content.OK("任务完成成功"); |
| | | // } |
| | | // else |
| | | // { |
| | | // // 记录日志 |
| | | // LogFactory.GetLog("任务完成").InfoFormat(true, "堆垛机出库完成", $"事务处理失败,库存状态更新:{isStockUpdated},任务状态更新:{isTaskUpdated}"); |
| | | // // 回滚事务 |
| | | // _unitOfWorkManage.RollbackTran(); |
| | | // // 返回失败结果 |
| | | // return content.Error("任务或库存更新失败"); |
| | | // } |
| | | // } |
| | | // catch (Exception err) |
| | | // { |
| | | // LogFactory.GetLog("任务完成").InfoFormat(true, $"系统异常,异常信息:{err.Message}", ""); |
| | | // Console.WriteLine(err.Message); |
| | | // return content.Error(err.Message); |
| | | // } |
| | | //} |
| | | |
| | | public async Task<WebResponseContent> CompleteStackTaskAsync(Dt_Task task, DtStockInfo stock) |
| | | { |
| | |
| | | { |
| | | var process = await SqlSugarHelper.Db.Queryable<Dt_EquipmentProcess>() |
| | | .FirstAsync(x => x.EquipmentName == task.Roadway); |
| | | var info = JsonConvert.DeserializeObject<EquipmentParameterInfo>(process.ProcessValue); |
| | | var info = JsonConvert.DeserializeObject<ResponseEqptRunDto>(process.ProcessValue); |
| | | |
| | | var agingOutputDto = MapToAgingOutputDto(stock, info); |
| | | content = await _agingInOrOutInputService.GetOCVOutputAsync(agingOutputDto); |
| | |
| | | await UpdateLocationAsync(loc); |
| | | await DeleteStockInfoAsync(stock.Id); |
| | | await DeleteStockInfoDetailsAsync(stock.StockInfoDetails); |
| | | await DeleteTaskAsync(task.TaskId); |
| | | //await DeleteTaskAsync(task.TaskId); |
| | | }); |
| | | |
| | | return content.OK("任务完成成功"); |
| | |
| | | } |
| | | } |
| | | |
| | | private AgingOutputDto MapToAgingOutputDto(DtStockInfo stock, EquipmentParameterInfo info) |
| | | private AgingOutputDto MapToAgingOutputDto(DtStockInfo stock, ResponseEqptRunDto info) |
| | | { |
| | | // TODO Value值根据MOM下发的静置时间到当前时间的分钟数 |
| | | return new AgingOutputDto |
| | | { |
| | | OpFlag = 1, |
| | | EquipmentCode = stock.LocationInfo.RoadwayNo, |
| | | Software = "WMS", |
| | | EquipmentCode = "ECH001-B", |
| | | TrayBarcode = stock.PalletCode, |
| | | SerialNos = stock.StockInfoDetails.Select(x => new SerialNoOutDto |
| | | { |
| | | SlotNo = x.OrderNo.ToInt32(), |
| | | SerialNo = x.SerialNumber, |
| | | SerialNoResult = true, |
| | | ParameterInfo = new List<ParameterInfo> |
| | | { |
| | | new ParameterInfo |
| | | ParameterInfo = info.ParameterInfo.Select(y => new ParameterInfo() |
| | | { |
| | | LowerLomit = info.LowerControlLimit, |
| | | UpperLimit = info.UpperControlLimit, |
| | | ParameterResult = info.EquipmentAvailabilityFlag, |
| | | ParameterCode = info.ParameterCode, |
| | | ParameterDesc = info.Description, |
| | | TargetValue = info.TargetValue, |
| | | Value = info.TargetValue, |
| | | DefectCode = info.UOMCode |
| | | } |
| | | } |
| | | LowerLomit = y.LowerControlLimit, |
| | | UpperLimit = y.UpperControlLimit, |
| | | ParameterResult = y.EquipmentAvailabilityFlag, |
| | | ParameterCode = y.ParameterCode, |
| | | ParameterDesc = y.Description, |
| | | TargetValue = y.TargetValue, |
| | | Value = (DateTime.Parse(stock.LinedProcessFeedbackTime, null, System.Globalization.DateTimeStyles.RoundtripKind).ToLocalTime() - stock.CreateDate).TotalMinutes.ToString(), |
| | | DefectCode = y.UOMCode |
| | | }).ToList() |
| | | }).ToList() |
| | | }; |
| | | } |
| | | |
| | | private void ValidateResponse(WebResponseContent content) |
| | | { |
| | | var result = JsonConvert.DeserializeObject<BasicResult>(content.ToString()); |
| | | var result = JsonConvert.DeserializeObject<BasicResult>(content.Data.ToString()); |
| | | if (!result.Success) |
| | | { |
| | | throw new Exception(result.MOMMessage); |
| | |
| | | var location = _locationRepository.QueryFirst(x => x.LocationCode == task.SourceAddress); |
| | | var details = _stockInfoDetailRepository.QueryData(x => x.StockId == stock.Id); |
| | | |
| | | location.LocationStatus = LocationEnum.Free.ObjToInt(); |
| | | task.TaskState = TaskOutStatusEnum.OutFinish.ObjToInt(); |
| | | task.CurrentAddress = task.NextAddress; |
| | | task.NextAddress = task.TargetAddress; |
| | | location.LocationStatus = (int)LocationEnum.Free; |
| | | task.TaskState = (int)TaskOutStatusEnum.OutFinish; |
| | | //task.CurrentAddress = task.NextAddress; |
| | | //task.NextAddress = task.TargetAddress; |
| | | |
| | | LogFactory.GetLog("任务完成").Info(true, "更新库存状态与任务状态"); |
| | | return (location, task); |
| | |
| | | #region 入库任务完成 |
| | | |
| | | /// <summary> |
| | | /// 入库任务完成 |
| | | /// 完成入库任务 |
| | | /// </summary> |
| | | /// <param name="task">任务数据合集</param> |
| | | /// <returns>返回结果集</returns> |
| | |
| | | { |
| | | MaterielCode = "空托盘", |
| | | Id = 0, |
| | | Status = (int)StockStateEmun.已入库 |
| | | } |
| | | } |
| | | }; |
| | |
| | | private DtStockInfo CreateFullPalletStock(Dt_Task task, DtLocationInfo locationInf, DtBoxingInfo boxing) |
| | | { |
| | | var boxDetail = boxing.BoxingInfoDetails.Adapt<List<DtStockInfoDetail>>(); |
| | | boxDetail.ForEach(x => { x.Status = (int)StockStateEmun.已入库; }); |
| | | var stock = new DtStockInfo() |
| | | { |
| | | PalletCode = task.PalletCode, |
| | |
| | | .Select(item => new SerialNoInDto { SerialNo = item.SerialNumber, PositionNo = item.OrderNo }) |
| | | .ToList(), |
| | | TrayBarcode = task.PalletCode, |
| | | OpFlag = 1 |
| | | OpFlag = 1, |
| | | EquipmentCode = "ECH001-B", |
| | | Software = "WMS" |
| | | }; |
| | | var result = _agingInOrOutInputService.GetOCVInputAsync(agingInputDto).Result; |
| | | stock.Remark = JsonConvert.DeserializeObject<ResponeAgingInputDto>(result.Data.ToString()).LinedProcessFeedbackTime; |
| | | var respone = JsonConvert.DeserializeObject<ResponeAgingInputDto>(result.Data.ToString()); |
| | | stock.LinedProcessFeedbackTime = respone.LinedProcessFeedbackTime; |
| | | stock.SpecialParameterDuration = respone.SpecialParameterDuration; |
| | | //2024年11月16日:新增字段计算应出库时间 |
| | | stock.OutboundTime = Convert.ToDateTime(respone.LinedProcessFeedbackTime).AddHours(Convert.ToDouble(respone.SpecialParameterDuration)); |
| | | |
| | | // 记录日志 |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "入库任务完成", $"货位地址:{task.TargetAddress},修改后货位数据:{locationInf}"); |
| | |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "验证任务是否存在", JsonConvert.SerializeObject(task)); |
| | | |
| | | // 验证库存是否存在 |
| | | var stock = await _stockInfoRepository.QueryFirstAsync(x => x.PalletCode == task.PalletCode); |
| | | var stock = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == task.PalletCode); |
| | | |
| | | // 根据任务类型调用相应的完成任务方法 |
| | | switch (task.TaskType) |
| | |
| | | #region 请求任务入库 |
| | | |
| | | /// <summary> |
| | | /// 请求任务 |
| | | /// 请求任务巷道 |
| | | /// </summary> |
| | | /// <param name="input">请求模型</param> |
| | | /// <returns>包含任务信息的响应内容</returns> |
| | |
| | | |
| | | try |
| | | { |
| | | |
| | | // 调用BaseDal.QueryFirstAsync方法,查询任务 |
| | | var task = await BaseDal.QueryFirstAsync(x => x.PalletCode == input.PalletCode); |
| | | if (task != null) |
| | | { |
| | | content = await UpdateExistingTask(input, task); |
| | | return content; |
| | | //if (task.TaskState == (int)TaskInStatusEnum.InNew) |
| | | { |
| | | // 创建WMS任务 |
| | | WMSTaskDTO taskDTO = new WMSTaskDTO() |
| | | { |
| | | TaskNum = task.TaskNum.Value, |
| | | Grade = 1, |
| | | PalletCode = task.PalletCode, |
| | | RoadWay = task.Roadway, |
| | | SourceAddress = task.SourceAddress, |
| | | TargetAddress = task.Roadway, |
| | | TaskState = task.TaskState.Value, |
| | | Id = 0, |
| | | TaskType = task.TaskType, |
| | | }; |
| | | return content.OK(data: taskDTO); |
| | | } |
| | | } |
| | | // 创建一个TrayCellsStatusDto对象,并赋值 |
| | | TrayCellsStatusDto trayCells = new TrayCellsStatusDto() |
| | | { |
| | | Software = "WMS", |
| | | TrayBarcode = input.PalletCode, |
| | | EquipmentCode = "ECH001-B" |
| | | //EquipmentCode = "EQ_CWJZ01" |
| | | EquipmentCode = "ECH001-B" |
| | | }; |
| | | |
| | | // 调用GetTrayCellStatusAsync方法,获取整盘电芯 |
| | |
| | | // 添加组盘信息 |
| | | // 将content.Data转换为ResultTrayCellsStatus对象 |
| | | var result = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); |
| | | if (result.SerialNos.Count <= 0) |
| | | return content.Error(result.MOMMessage); |
| | | |
| | | // TODO 获取本地料框属性与整盘电芯属性获取的值进行对比,如果一致则继续,否则返回错误信息 |
| | | //var productions = await _productionRepository.QueryDataAsync(x => result.TrayBarcodePropertys.Select(x => x.TrayBarcodeProperty).ToList().Contains(x.TrayBarcodeProperty)); |
| | | //if (productions.Count <= 0) |
| | | // return content.Error("料框属性不存在"); |
| | | |
| | | // 调用CreateBoxingInfo方法,创建组盘信息 |
| | | |
| | | var boxing = await CreateBoxingInfo(result, input.PalletCode); |
| | | if (boxing == null) return content.Error("组盘失败"); |
| | | |
| | | // 调用GetProcessApplyAsync方法,获取工艺路线 |
| | | ProcessApplyDto process = await GetProcessApplyAsync(result); |
| | |
| | | // 如果process为null,则返回content |
| | | if (process == null) return content; |
| | | |
| | | // 调用GetProcessResponseAsync方法,获取工艺响应 |
| | | var processResponse = await GetProcessResponseAsync(process, input.Position); |
| | | // 调用_processApplyService.GetProcessApplyAsync方法,获取工艺申请 |
| | | content = await _processApplyService.GetProcessApplyAsync(process); |
| | | |
| | | // 如果task不为null,则调用UpdateExistingTask方法,更新任务;否则调用CreateNewTask方法,创建新任务 |
| | | content = task != null ? await UpdateExistingTask(input, task) : await CreateNewTask(processResponse, input); |
| | | // 如果状态为false,则返回null |
| | | if (!content.Status) return content.Error("工艺申请失败"); |
| | | |
| | | //// 调用GetProcessResponseAsync方法,获取工艺响应 |
| | | //var processResponse = await GetProcessResponseAsync(process, input.Position); |
| | | |
| | | List<string> strings = input.Position == "1088" ? new List<string>() { "CHSC01" } : new List<string>() { "JZSC01" }; |
| | | // 调用CreateNewTask方法,创建新任务 |
| | | content = await CreateNewTask(input, strings); |
| | | if (content.Status) |
| | | { |
| | | var isBox = await _boxingInfoRepository.AddDataNavAsync(boxing); |
| | |
| | | |
| | | // 返回content |
| | | return content; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 更新任务货位 |
| | | /// </summary> |
| | | /// <param name="input"></param> |
| | | /// <returns></returns> |
| | | public async Task<WebResponseContent> UpdateExistingTask(RequestTaskDto input) |
| | | { |
| | | WebResponseContent content = new WebResponseContent(); |
| | | try |
| | | { |
| | | var task = await BaseDal.QueryFirstAsync(x => x.PalletCode == input.PalletCode); |
| | | if (task == null) |
| | | return content.Error($"暂未找到【{input.PalletCode}】的任务"); |
| | | |
| | | return content = await UpdateExistingTask(input, task); |
| | | |
| | | } |
| | | catch (Exception err) |
| | | { |
| | | |
| | | throw; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 空托盘入库申请 |
| | | /// </summary> |
| | | /// <param name="input"></param> |
| | | /// <returns></returns> |
| | | public async Task<WebResponseContent> RequestTrayInTaskAsync(RequestTaskDto input) |
| | | { |
| | | WebResponseContent content = new WebResponseContent(); |
| | | try |
| | | { |
| | | |
| | | // 调用BaseDal.QueryFirstAsync方法,查询任务 |
| | | var task = await BaseDal.QueryFirstAsync(x => x.PalletCode == input.PalletCode); |
| | | if (task != null && task.TaskState == (int)TaskInStatusEnum.InNew) |
| | | { |
| | | // 创建WMS任务 |
| | | WMSTaskDTO taskDTO = new WMSTaskDTO() |
| | | { |
| | | TaskNum = task.TaskNum.Value, |
| | | Grade = 1, |
| | | PalletCode = task.PalletCode, |
| | | RoadWay = task.Roadway, |
| | | SourceAddress = task.SourceAddress, |
| | | TargetAddress = task.Roadway, |
| | | TaskState = task.TaskState.Value, |
| | | Id = 0, |
| | | TaskType = task.TaskType, |
| | | }; |
| | | return content.OK(data: task); |
| | | } |
| | | |
| | | // 获取目标地址 |
| | | List<string> strings = input.Position == "1016" ? new List<string>() { "CHSC01" } : new List<string>() { "JZSC01" }; |
| | | |
| | | return await CreateNewTask(input, strings, 1); |
| | | //return await CreateNewTask(input, null, 1); |
| | | } |
| | | catch (Exception) |
| | | { |
| | | |
| | | throw; |
| | | } |
| | | } |
| | | |
| | | // 获取托盘单元格状态 |
| | |
| | | SerialNumber = serialNoObj.SerialNo, |
| | | OrderNo = serialNoObj.PositionNo.ToString(), |
| | | Status = serialNoObj.SerialNoStatus, |
| | | MaterielCode = serialNoObj.BindCode, |
| | | MaterielCode = result.BindCode, |
| | | Remark = result.TrayBarcodePropertys.ToJsonString(), |
| | | }).ToList() |
| | | }; |
| | |
| | | // 创建一个ProcessApplyDto对象,并赋值 |
| | | return new ProcessApplyDto() |
| | | { |
| | | EquipmentCode = "ECH001-B", |
| | | Software = "WMS", |
| | | EquipmentCode = "ECH001-B", |
| | | Software = "WMS", |
| | | //WipOrderNo = result.BindCode, |
| | | SerialNos = content.SerialNos.Select(item => new SerialNos |
| | | { |
| | |
| | | |
| | | #endregion 请求任务入库 |
| | | |
| | | #region 请求出库 |
| | | |
| | | //public async Task<WebResponseContent> RequestTrayTaskAsync(string position, int tag, string areaCdoe,List<string> roadways) |
| | | //{ |
| | | // WebResponseContent content = new WebResponseContent(); |
| | | // try |
| | | // { |
| | | // // 1==实盘 2 ==空盘 |
| | | // if (tag == 1) |
| | | // { |
| | | // // 查询库存信息 |
| | | // DtStockInfo? stockInfo = _stockInfoRepository.QueryData(x => x.AreaCode == areaCdoe && Convert.ToDateTime(x.Remark) < DateTime.Now && x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && roadways.Contains(x.LocationInfo.RoadwayNo)).OrderBy(x => x.CreateDate).FirstOrDefault(); |
| | | // // 创建新任务实例 |
| | | // var task = new Dt_Task() |
| | | // { |
| | | // Grade = 1, |
| | | // Roadway = stockInfo.LocationInfo.RoadwayNo, |
| | | // TargetAddress = position, |
| | | // Dispatchertime = DateTime.Now, |
| | | // MaterialNo = "", |
| | | // NextAddress = position, |
| | | // OrderNo = null, |
| | | // PalletCode = stockInfo.PalletCode, |
| | | // SourceAddress = stockInfo.LocationCode, |
| | | // TaskState = (int)TaskOutStatusEnum.OutNew, |
| | | // TaskType = (int)TaskOutboundTypeEnum.Outbound, |
| | | // TaskNum = await BaseDal.GetTaskNo(), |
| | | // Creater = "Systeam" |
| | | // }; |
| | | // var taskId = await BaseDal.AddDataAsync(task); |
| | | // bool isResult = taskId > 0; |
| | | // if (isResult) |
| | | // { |
| | | // WMSTaskDTO taskDTO = new WMSTaskDTO() |
| | | // { |
| | | // TaskNum = task.TaskNum.Value, |
| | | // Grade = 1, |
| | | // PalletCode = DateTime.Now.ToString("MMddHHmmss"), |
| | | // RoadWay = task.Roadway, |
| | | // SourceAddress = stockInfo.LocationCode, |
| | | // TargetAddress = task.Roadway, |
| | | // TaskState = (int)TaskOutStatusEnum.OutNew, |
| | | // Id = 0, |
| | | // TaskType = (int)TaskOutboundTypeEnum.OutTray |
| | | // }; |
| | | // stockInfo.LocationInfo.LocationStatus = (int)LocationEnum.InStockDisable; |
| | | // _locationRepository.UpdateData(stockInfo.LocationInfo); |
| | | // content.OK(data: taskDTO); |
| | | // } |
| | | // } |
| | | // else |
| | | // { |
| | | // var stockInfo = _stockInfoRepository.QueryData(x => x.AreaCode == areaCdoe && x.StockInfoDetails.Any(z => z.MaterielCode == "空托盘") && roadways.Contains(x.LocationInfo.RoadwayNo)).OrderBy(x => x.CreateDate).FirstOrDefault(); |
| | | // // 创建新任务实例 |
| | | // var task = new Dt_Task |
| | | // { |
| | | // CurrentAddress = stockInfo.LocationCode, |
| | | // Grade = 1, |
| | | // Roadway = stockInfo.LocationInfo.RoadwayNo, |
| | | // TargetAddress = position, |
| | | // Dispatchertime = DateTime.Now, |
| | | // MaterialNo = "", |
| | | // NextAddress = position, |
| | | // OrderNo = null, |
| | | // PalletCode = stockInfo.PalletCode, |
| | | // SourceAddress = stockInfo.LocationCode, |
| | | // TaskState = (int)TaskOutStatusEnum.OutNew, |
| | | // TaskType = (int)TaskOutboundTypeEnum.OutTray, |
| | | // TaskNum = await BaseDal.GetTaskNo(), |
| | | // Creater = "Systeam" |
| | | // }; |
| | | |
| | | // var taskId = await BaseDal.AddDataAsync(task); |
| | | // bool isResult = taskId > 0; |
| | | // if (isResult) |
| | | // { |
| | | // WMSTaskDTO taskDTO = new WMSTaskDTO() |
| | | // { |
| | | // TaskNum = task.TaskNum.Value, |
| | | // Grade = 1, |
| | | // PalletCode = DateTime.Now.ToString("MMddHHmmss"), |
| | | // RoadWay = task.Roadway, |
| | | // SourceAddress = stockInfo.LocationCode, |
| | | // TargetAddress = task.Roadway, |
| | | // TaskState = (int)TaskOutStatusEnum.OutNew, |
| | | // Id = 0, |
| | | // TaskType = (int)TaskOutboundTypeEnum.OutTray |
| | | // }; |
| | | // content.OK(data: taskDTO); |
| | | // } |
| | | // } |
| | | // } |
| | | // catch (Exception ex) |
| | | // { |
| | | // throw; |
| | | // } |
| | | // return content; |
| | | //} |
| | | #region 请求出库(实盘&空盘) |
| | | |
| | | /// <summary> |
| | | /// 请求托盘任务 |
| | |
| | | /// <param name="areaCode">区域编码</param> |
| | | /// <param name="roadways">巷道编码集合</param> |
| | | /// <returns>返回结果集</returns> |
| | | public async Task<WebResponseContent> RequestTrayTaskAsync(string position, int tag, string areaCode, List<string> roadways) |
| | | public async Task<WebResponseContent> RequestTrayOutTaskAsync(string position, int tag, string areaCode, List<string> roadways) |
| | | { |
| | | WebResponseContent content = new WebResponseContent(); |
| | | try |
| | | { |
| | | // 根据托盘类型查询库存信息 |
| | | DtStockInfo stockInfo = tag == 1 |
| | | ? QueryStockInfoForRealTray(areaCode, roadways) |
| | | : QueryStockInfoForEmptyTray(areaCode, roadways); |
| | | DtStockInfo stockInfo = tag == (int)TaskOutboundTypeEnum.Outbound |
| | | ? QueryStockInfoForRealTrayAsync(areaCode, roadways).Result |
| | | : QueryStockInfoForEmptyTrayAsync(areaCode, roadways).Result; |
| | | |
| | | if (stockInfo == null) |
| | | { |
| | | return content.Error("库存信息不存在"); |
| | | } |
| | | |
| | | // 新增重复任务校验 |
| | | var hasTask = BaseDal.QueryFirst(x => x.PalletCode == stockInfo.PalletCode); |
| | | if (hasTask != null) |
| | | { |
| | | WMSTaskDTO taskDTO1 = CreateTaskDTO(hasTask); |
| | | return content.OK("已存在空盘出库任务", data: taskDTO1); |
| | | } |
| | | |
| | | // 创建新任务实例 |
| | |
| | | |
| | | // 创建任务DTO |
| | | WMSTaskDTO taskDTO = CreateTaskDTO(task); |
| | | if (tag == 1) |
| | | //if (tag == 1) |
| | | { |
| | | // 更新库存位置状态为不可用 |
| | | stockInfo.LocationInfo.LocationStatus = (int)LocationEnum.InStockDisable; |
| | |
| | | { |
| | | // 记录异常信息并抛出 |
| | | LogFactory.GetLog("请求托盘任务").Error(true, ex); |
| | | throw; |
| | | return content.Error(ex.Message); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 查询实盘库存信息 |
| | | /// </summary> |
| | | private DtStockInfo QueryStockInfoForRealTray(string areaCode, List<string> roadways) |
| | | private async Task<DtStockInfo> QueryStockInfoForRealTrayAsync(string areaCode, List<string> roadways) |
| | | { |
| | | return _stockInfoRepository.QueryData(x => x.AreaCode == areaCode && Convert.ToDateTime(x.Remark) < DateTime.Now && x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && roadways.Contains(x.LocationInfo.RoadwayNo)) |
| | | .OrderBy(x => x.CreateDate) |
| | | .FirstOrDefault(); |
| | | // TODO时间根据MOM系统配置的出库时间来获取,暂时不知道MOM返回的时间是什么所以这里测试时候在改 |
| | | //return _stockInfoRepository.QueryFirstNavAsync(x => x.AreaCode == areaCode && Convert.ToDateTime(x.LinedProcessFeedbackTime).AddHours(Convert.ToDouble(x.SpecialParameterDuration)) < DateTime.Now |
| | | // && x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && roadways.Contains(x.LocationInfo.RoadwayNo) && x.StockInfoDetails.Any(x => x.Status == (int)StockStateEmun.已入库) && x.LocationInfo.LocationStatus == (int)LocationEnum.InStock).Result; |
| | | |
| | | var result = await _stockInfoRepository.Db.Queryable<DtStockInfo>().Where(x => |
| | | x.AreaCode == areaCode && |
| | | Convert.ToDateTime(x.LinedProcessFeedbackTime).AddHours(Convert.ToDouble(x.SpecialParameterDuration)) < DateTime.Now) |
| | | .Includes(x => x.LocationInfo) |
| | | .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && roadways.Contains(x.LocationInfo.RoadwayNo)) |
| | | .Includes(x => x.StockInfoDetails) |
| | | .Where(x => x.StockInfoDetails.Any(detail => detail.Status == (int)StockStateEmun.已入库)) |
| | | .OrderBy(x => x.CreateDate) |
| | | .FirstAsync(); |
| | | return result; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 查询空盘库存信息 |
| | | /// </summary> |
| | | private DtStockInfo QueryStockInfoForEmptyTray(string areaCode, List<string> roadways) |
| | | private async Task<DtStockInfo> QueryStockInfoForEmptyTrayAsync(string areaCode, List<string> roadways) |
| | | { |
| | | return _stockInfoRepository.QueryData(x => x.AreaCode == areaCode && x.StockInfoDetails.Any(z => z.MaterielCode == "空托盘") && roadways.Contains(x.LocationInfo.RoadwayNo)) |
| | | .OrderBy(x => x.CreateDate) |
| | | .FirstOrDefault(); |
| | | //return _stockInfoRepository.QueryFirstNavAsync(x => x.StockInfoDetails.Any(x => x.MaterielCode == "空托盘") && roadways.Contains(x.LocationInfo.RoadwayNo) && x.StockInfoDetails.Any(x => x.Status == (int)StockStateEmun.已入库) && x.LocationInfo.LocationStatus == (int)LocationEnum.InStock).Result; |
| | | var result = await _stockInfoRepository.Db.Queryable<DtStockInfo>() |
| | | .Includes(x => x.LocationInfo) |
| | | .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && roadways.Contains(x.LocationInfo.RoadwayNo)) |
| | | .Includes(x => x.StockInfoDetails) |
| | | .Where(x => x.StockInfoDetails.Any(detail => detail.Status == (int)StockStateEmun.已入库 && detail.MaterielCode == "空托盘")) |
| | | .OrderBy(x => x.CreateDate) |
| | | .FirstAsync(); |
| | | return result; |
| | | } |
| | | |
| | | /// <summary> |
| | |
| | | OrderNo = null, |
| | | PalletCode = stockInfo.PalletCode, |
| | | SourceAddress = stockInfo.LocationCode, |
| | | CurrentAddress = stockInfo.LocationCode, |
| | | TaskState = (int)TaskOutStatusEnum.OutNew, |
| | | TaskType = tag == 1 ? (int)TaskOutboundTypeEnum.Outbound : (int)TaskOutboundTypeEnum.OutTray, |
| | | TaskType = tag == (int)TaskOutboundTypeEnum.Outbound ? (int)TaskOutboundTypeEnum.Outbound : (int)TaskOutboundTypeEnum.OutTray, |
| | | TaskNum = BaseDal.GetTaskNo().Result, |
| | | Creater = "System" // 修正拼写错误 |
| | | }; |
| | |
| | | |
| | | #endregion 请求出库 |
| | | |
| | | #region 陈化请求出库 |
| | | #region 任务状态更改 |
| | | |
| | | // 陈化请求出库 |
| | | public async Task<WebResponseContent> OutTrayByCh(string position) |
| | | /// <summary> |
| | | /// 更新任务状态&出库解盘 |
| | | /// </summary> |
| | | /// <param name="taskNum"></param> |
| | | /// <param name="taskState"></param> |
| | | /// <returns></returns> |
| | | public async Task<WebResponseContent> UpdateTaskStatus(int taskNum, int taskState) |
| | | { |
| | | WebResponseContent content = new WebResponseContent(); |
| | | try |
| | | { |
| | | var area = _areaInfoRepository.QueryFirst(x => x.AreaName == "陈化区"); |
| | | var task = await BaseDal.QueryFirstAsync(x => x.TaskNum == taskNum); |
| | | if (task == null) |
| | | return content.Error("未找到任务"); |
| | | |
| | | // 查询库存信息 |
| | | var stockInfo = _stockInfoRepository.QueryData(x => x.AreaCode == area.AreaCode && Convert.ToDateTime(x.Remark) < DateTime.Now && x.LocationInfo.LocationStatus == (int)LocationEnum.InStock).OrderBy(x => x.CreateDate).FirstOrDefault(); |
| | | // 创建新任务实例 |
| | | var task = new Dt_Task() |
| | | if (taskState == (int)TaskOutStatusEnum.Line_OutFinish) |
| | | { |
| | | Grade = 1, |
| | | Roadway = stockInfo.LocationInfo.RoadwayNo, |
| | | TargetAddress = position, |
| | | Dispatchertime = DateTime.Now, |
| | | MaterialNo = "", |
| | | NextAddress = position, |
| | | OrderNo = null, |
| | | PalletCode = stockInfo.PalletCode, |
| | | SourceAddress = stockInfo.LocationCode, |
| | | TaskState = (int)TaskOutStatusEnum.OutNew, |
| | | TaskType = (int)TaskOutboundTypeEnum.OutTray, |
| | | TaskNum = await BaseDal.GetTaskNo(), |
| | | Creater = "Systeam" |
| | | }; |
| | | var taskId = await BaseDal.AddDataAsync(task); |
| | | bool isResult = taskId > 0; |
| | | if (isResult) |
| | | { |
| | | WMSTaskDTO taskDTO = new WMSTaskDTO() |
| | | var taskHty = CreateHistoricalTask(task); |
| | | await _unitOfWorkManage.UseTranAsync(async () => |
| | | { |
| | | TaskNum = task.TaskNum.Value, |
| | | Grade = 1, |
| | | PalletCode = DateTime.Now.ToString("MMddHHmmss"), |
| | | RoadWay = task.Roadway, |
| | | SourceAddress = stockInfo.LocationCode, |
| | | TargetAddress = task.Roadway, |
| | | TaskState = (int)TaskOutStatusEnum.OutNew, |
| | | Id = 0, |
| | | TaskType = (int)TaskOutboundTypeEnum.OutTray |
| | | }; |
| | | stockInfo.LocationInfo.LocationStatus = (int)LocationEnum.InStockDisable; |
| | | _locationRepository.UpdateData(stockInfo.LocationInfo); |
| | | content.OK(data: taskDTO); |
| | | var asb = await BaseDal.DeleteDataByIdAsync(task.TaskId); |
| | | var asbHty = await _task_HtyRepository.AddDataAsync(taskHty) > 0; |
| | | if (asb && asbHty) |
| | | content.OK(); |
| | | else |
| | | throw new Exception(); |
| | | }); |
| | | content.OK(); |
| | | } |
| | | else |
| | | { |
| | | task.TaskState = taskState; |
| | | var asb = await BaseDal.UpdateDataAsync(task); |
| | | if (asb) |
| | | content.OK(); |
| | | else |
| | | content.Error(); |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | throw; |
| | | content.Error(ex.Message); |
| | | } |
| | | return content; |
| | | } |
| | | |
| | | #endregion 陈化请求出库 |
| | | #endregion |
| | | |
| | | #region 出库解盘 |
| | | |
| | | /// <summary> |
| | | /// 出库解盘接口 |
| | | /// </summary> |
| | | /// <param name="taskNum"></param> |
| | | /// <returns></returns> |
| | | public async Task<WebResponseContent> OutUnblockInterface(int taskNum) |
| | | { |
| | | WebResponseContent content = new WebResponseContent(); |
| | | try |
| | | { |
| | | var task = await BaseDal.QueryFirstAsync(x => x.TaskNum == taskNum); |
| | | if (task == null) |
| | | return content.Error("未找到任务"); |
| | | task.TaskState = (int)TaskOutStatusEnum.Line_OutFinish; |
| | | var taskHty = CreateHistoricalTask(task); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | content.Error(ex.Message); |
| | | } |
| | | return content; |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #endregion 外部接口方法 |
| | | |
| | |
| | | /// <param name="areaId">区域ID</param> |
| | | /// <param name="content">响应内容</param> |
| | | /// <returns></returns> |
| | | private async Task<WebResponseContent> CreateNewTask(List<Dt_EquipmentProcess> process, RequestTaskDto input) |
| | | private async Task<WebResponseContent> CreateNewTask(RequestTaskDto input, List<string> process = null, int flag = 0) |
| | | { |
| | | WebResponseContent content = new WebResponseContent(); |
| | | List<string> strings = process.Select(x => x.EquipmentName).ToList(); |
| | | |
| | | // 获取目标地址 |
| | | string ToAddress = await GetRoadWayAsync(strings); |
| | | //string ToAddress = await GetRoadWayAsync(process); |
| | | string ToAddress = await GetRoadWayAsync(input, process); |
| | | |
| | | // 创建新任务实例 |
| | | var task = new Dt_Task |
| | |
| | | PalletCode = input.PalletCode, |
| | | SourceAddress = input.Position, |
| | | TaskState = (int)TaskInStatusEnum.InNew, |
| | | TaskType = (int)TaskTypeEnum.Inbound, |
| | | TaskType = flag == 0 ? (int)TaskInboundTypeEnum.Inbound : (int)TaskInboundTypeEnum.InTray, |
| | | TaskNum = await BaseDal.GetTaskNo(), |
| | | Creater = "Systeam" |
| | | }; |
| | |
| | | /// <param name="areaId">区域主键</param> |
| | | /// <param name="roadWay">巷道</param> |
| | | /// <returns></returns> |
| | | public async Task<DtLocationInfo> GetLocationDistributeAsync(string roadWay) |
| | | public async Task<DtLocationInfo> GetLocationDistributeAsync(string roadWay, bool IsFull = true) |
| | | { |
| | | #region 获取货位 |
| | | |
| | | try |
| | | { |
| | | var locations = await _locationRepository.QueryDataAsync(x => x.LocationStatus == (int)LocationEnum.Free && x.RoadwayNo == roadWay); |
| | | List<DtLocationInfo> locations; |
| | | if (IsFull) |
| | | { |
| | | locations = await _locationRepository.QueryDataAsync(x => x.LocationStatus == (int)LocationEnum.Free && x.RoadwayNo == roadWay); |
| | | } |
| | | else |
| | | { |
| | | locations = await _locationRepository.QueryDataAsync(x => x.LocationStatus == (int)LocationEnum.Free && x.RoadwayNo == roadWay); |
| | | } |
| | | |
| | | if (locations == null) |
| | | { |
| | | return null; |
| | |
| | | /// <param name="Direction">方向</param> |
| | | /// <param name="area">关系区域</param> |
| | | /// <returns></returns> |
| | | public async Task<string> GetRoadWayAsync(List<string> process) |
| | | public async Task<string> GetRoadWayAsync(RequestTaskDto input, List<string> process) |
| | | { |
| | | var minGroup = _locationRepository.QueryData(x => process.Contains(x.RoadwayNo) && x.LocationStatus == (int)LocationEnum.Free) |
| | | .GroupBy(x => x.RoadwayNo) |
| | | .OrderByDescending(g => g.Count()) // 根据每个组的元素数量排序 |
| | | .First(); // 取出数量最多的组 |
| | | |
| | | string minRoadwayNo = minGroup.Key; // 数量最多的组的Key |
| | | |
| | | return minRoadwayNo; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 获取巷道或站台 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | public async Task<string> GetRoadWayAsync(int areaCode) |
| | | { |
| | | var minGroup = _locationRepository.QueryData(x => x.AreaId == areaCode && x.LocationStatus == (int)LocationEnum.Free) |
| | | .GroupBy(x => x.RoadwayNo) |
| | | .OrderBy(g => g.Count()) // 根据每个组的元素数量排序 |
| | | .First(); // 取出数量最少的组 |
| | | |