using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WIDESEA_Core.Enums;
using WIDESEA_Core;
using WIDESEA_DTO.Stock;
using WIDESEA_Model.Models;
using WIDESEA_Core.Helper;
using WIDESEA_Common.OtherEnum;
using WIDESEA_Common.TaskEnum;
using WIDESEA_Common.OrderEnum;
using WIDESEA_Common.StockEnum;
using WIDESEA_Common.CommonEnum;
using WIDESEA_Common.LocationEnum;
using MailKit.Search;
using WIDESEA_External.Model;
using WIDESEA_Core.CodeConfigEnum;
using Microsoft.AspNetCore.Mvc;
using WIDESEA_DTO.ERP;
using WIDESEA_Common.MaterielEnum;
using WIDESEA_Common.WareHouseEnum;
using WIDESEA_DTO.MES;
using WIDESEA_DTO.Outbound;
using Microsoft.IdentityModel.Tokens;
using OfficeOpenXml.FormulaParsing.Excel.Functions.RefAndLookup;
namespace WIDESEA_TaskInfoService
{
public partial class TaskService
{
///
/// 选择库存生成出库任务
///
///
///
public WebResponseContent Outbound(List ids)
{
WebResponseContent content = new WebResponseContent();
try
{
//获取选定库存
List stockInfos = _stockRepository.StockInfoRepository.Db.Queryable().Where(x => ids.Contains(x.Id) && x.StockStatus == StockStatusEmun.入库完成.ObjToInt() && x.MaterielInvOrgId == MaterielInvOrgEnum.老厂.ObjToInt()).ToList();
if (stockInfos == null || stockInfos.Count != ids.Count)
{
return content.Error($"未找到库存");
}
//获取库存货位
List locationInfos = _basicRepository.LocationInfoRepository.QueryData(x =>x.WarehouseId == WarehouseEnum.LLDYL.ObjToInt() && stockInfos.Select(x=>x.LocationCode).Contains(x.LocationCode) && x.LocationStatus == LocationStatusEnum.InStock.ObjToInt() && x.EnableStatus == EnableStatusEnum.Normal.ObjToInt());
if (locationInfos == null || locationInfos.Count != stockInfos.Count)
{
return content.Error($"货位出库条件不满足");
}
//任务生成
List tasks = GetTasks(stockInfos, TaskTypeEnum.OldYLOutbound);
if (tasks == null || tasks.Count <= 0)
{
return content.Error($"生成任务失败");
}
tasks.ForEach(x =>
{
x.Grade = 99;
});
stockInfos.ForEach(x =>
{
x.StockStatus = StockStatusEmun.出库锁定.ObjToInt();
});
_unitOfWorkManage.BeginTran();
//更新库存状态
_stockRepository.StockInfoRepository.UpdateData(stockInfos);
//更新货位状态
_basicRepository.LocationInfoRepository.UpdateLocationStatus(locationInfos, LocationStatusEnum.Lock);
//加入货位变动记录
_recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfos, LocationStatusEnum.Lock, LocationChangeType.OutboundAssignLocation, taskNums: tasks.Select(x => x.TaskNum).ToList());
//新建任务
BaseDal.AddData(tasks);
_unitOfWorkManage.CommitTran();
PushTasksToWCS(tasks);
content.OK();
}
catch (Exception ex)
{
content.Error(ex.Message);
}
return content;
}
///
/// 向WMS申请出库AGV终点
///
/// 任务号
///
public WebResponseContent AssignOutTargetAddress(int taskNum)
{
WebResponseContent content = new WebResponseContent();
try
{
Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum);
if (task == null)
{
return WebResponseContent.Instance.Error($"未找到该入库任务");
}
if (_basicRepository.AGVStationInfoRepository.QueryFirst(x => x.AGVStationCode == task.TargetAddress) != null)
{
return WebResponseContent.Instance.OK(data: task.TargetAddress);
}
Dt_AGVStationInfo? aGVStationInfo = _basicRepository.AGVStationInfoRepository.QueryData(x => x.StationArea == nameof(StationAreaEnum.一楼月台码头) && x.IsOccupied == WhetherEnum.False.ObjToInt()).OrderByDescending(x => x.Depth).FirstOrDefault();
if (aGVStationInfo==null)
{
return content.Error("未找到可分配的出库站点");
}
aGVStationInfo.IsOccupied = WhetherEnum.True.ObjToInt();
_basicRepository.AGVStationInfoRepository.UpdateData(aGVStationInfo);
content.OK("成功",data: aGVStationInfo.AGVStationCode);
}
catch (Exception ex)
{
content.Error(ex.Message);
}
return content;
}
///
/// 出库任务完成
///
public WebResponseContent OutboundTaskCompleted(Dt_Task task)
{
WebResponseContent content = new WebResponseContent();
try
{
Dt_Warehouse warehouse = _basicRepository.WarehouseRepository.QueryFirst(x => x.WarehouseId == task.WarehouseId);
if (warehouse.WarehouseCode == WarehouseEnum.LLDCP.ToString() || warehouse.WarehouseCode == WarehouseEnum.LLDFL.ToString()) //成品完成
{
Dt_LocationInfo locationInfoStart = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.SourceAddress);
if (locationInfoStart == null)
{
return content.Error($"未找到对应的起点货位信息");
}
Dt_ProStockInfo proStockInfo = _stockRepository.ProStockInfoRepository.Db.Queryable().Where(x => x.PalletCode == task.PalletCode).Includes(x=>x.proStockInfoDetails).First();
if (proStockInfo != null && proStockInfo.StockStatus==StockStatusEmun.出库锁定.ObjToInt())
{
task.TaskStatus = TaskStatusEnum.Finish.ObjToInt();
//获取所有出库详情数据
List? outStockLockInfos = _outboundRepository.OutStockLockInfoRepository.QueryData(x => x.TaskNum == task.TaskNum);
_unitOfWorkManage.BeginTran();
proStockInfo.StockStatus = StockStatusEmun.出库完成.ObjToInt();
_stockRepository.ProStockInfoRepository.DeleteAndMoveIntoHty(proStockInfo,App.User.UserId > 0 ? OperateTypeEnum.人工完成 : OperateTypeEnum.自动完成);
if (proStockInfo.proStockInfoDetails!=null && proStockInfo.proStockInfoDetails.Count>0)
{
_stockRepository.ProStockInfoDetailRepository.DeleteAndMoveIntoHty(proStockInfo.proStockInfoDetails, App.User.UserId > 0 ? OperateTypeEnum.人工完成 : OperateTypeEnum.自动完成);
}
if (outStockLockInfos != null && outStockLockInfos.Count > 0)
{
outStockLockInfos.ForEach(x =>
{
x.Status = OutLockStockStatusEnum.出库完成.ObjToInt();
});
List outStockLockInfosMES = outStockLockInfos.Where(x => x.OrderType == OutOrderTypeEnum.OutMESPick.ObjToInt()).ToList();
if (outStockLockInfosMES != null && outStockLockInfosMES.Count() > 0)
{
Dt_AGVStationInfo aGVStationInfo = _basicRepository.AGVStationInfoRepository.QueryFirst(x => x.AGVStationCode == task.TargetAddress);
MESDeliveryModel mESDeliveryModel = MESDeliveryUp(outStockLockInfosMES, aGVStationInfo.MESPointCode);
MESResponse response = _invokeMESService.MESDelivery(mESDeliveryModel).DeserializeObject() ?? throw new Exception("未获取到返回信息");
if (!response.Result)
{
throw new Exception($"MES配送出发接口调用报错,MES返回信息{DecodeUnicode(response.Msg)}");
}
}
}
_basicService.LocationInfoService.UpdateLocationStatus(locationInfoStart, proStockInfo.PalletType, LocationStatusEnum.Free, proStockInfo.WarehouseId);
BaseDal.DeleteAndMoveIntoHty(task, App.User.UserId > 0 ? OperateTypeEnum.人工完成 : OperateTypeEnum.自动完成);
_unitOfWorkManage.CommitTran();
}
else
{
return content.Error($"未找到对应库存信息");
}
}
else//原料库完成
{
Dt_LocationInfo locationInfoStart = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.SourceAddress);
if (locationInfoStart == null)
{
return content.Error($"未找到对应的起点货位信息");
}
if (locationInfoStart.LocationStatus!=LocationStatusEnum.Lock.ObjToInt())
{
return content.Error($"货位状态不正确");
}
Dt_StockInfo stockInfo = _stockRepository.StockInfoRepository.QueryFirst(x => x.PalletCode == task.PalletCode);
int wareId=stockInfo.WarehouseId;
if (stockInfo != null && stockInfo.StockStatus == StockStatusEmun.出库锁定.ObjToInt())
{
task.TaskStatus = TaskStatusEnum.Finish.ObjToInt();
//获取所有出库详情数据
List? outStockLockInfos = _outboundRepository.OutStockLockInfoRepository.QueryData(x=>x.TaskNum==task.TaskNum);
_unitOfWorkManage.BeginTran();
//处理库存数据
if (task.TaskType == TaskTypeEnum.OldYLOutbound.ObjToInt())
{
stockInfo.StockStatus = StockStatusEmun.出库完成.ObjToInt();
stockInfo.WarehouseId = WarehouseEnum.LLDOldCache.ObjToInt();
stockInfo.LocationCode = "";
_stockRepository.StockInfoRepository.UpdateData(stockInfo);
}
else
{
stockInfo.StockStatus = StockStatusEmun.出库完成.ObjToInt();
_stockRepository.StockInfoRepository.DeleteAndMoveIntoHty(stockInfo, App.User.UserId > 0 ? OperateTypeEnum.人工完成 : OperateTypeEnum.自动完成);
}
if (outStockLockInfos!=null && outStockLockInfos.Count>0)
{
outStockLockInfos.ForEach(x =>
{
x.Status=OutLockStockStatusEnum.出库完成.ObjToInt();
});
_outboundRepository.OutStockLockInfoRepository.UpdateData(outStockLockInfos);
List outStockLockInfosSG = outStockLockInfos.Where(x => x.OrderType == OutOrderTypeEnum.OutSGPick.ObjToInt()).ToList();
List outStockLockInfosMES = outStockLockInfos.Where(x => x.OrderType == OutOrderTypeEnum.OutMESPick.ObjToInt()).ToList();
if (outStockLockInfosSG !=null && outStockLockInfosSG.Count()>0)
{
_outboundService.OutLineViewService.SaveLineView(outStockLockInfosSG);
}
if (outStockLockInfosMES != null && outStockLockInfosMES.Count() > 0)
{
Dt_AGVStationInfo aGVStationInfo = _basicRepository.AGVStationInfoRepository.QueryFirst(x=>x.AGVStationCode==task.TargetAddress);
MESDeliveryModel mESDeliveryModel = MESDeliveryUp(outStockLockInfosMES, aGVStationInfo.MESPointCode);
MESResponse response = _invokeMESService.MESDelivery(mESDeliveryModel).DeserializeObject() ?? throw new Exception("未获取到返回信息");
if (!response.Result)
{
throw new Exception($"MES配送出发接口调用报错,MES返回信息{DecodeUnicode(response.Msg)}");
}
}
}
_basicService.LocationInfoService.UpdateLocationStatus(locationInfoStart, stockInfo.PalletType, LocationStatusEnum.Free, wareId);
BaseDal.DeleteAndMoveIntoHty(task, App.User.UserId > 0 ? OperateTypeEnum.人工完成 : OperateTypeEnum.自动完成);
_unitOfWorkManage.CommitTran();
}
else
{
return content.Error($"未找到对应库存信息");
}
}
return content.OK();
}
catch (Exception ex)
{
_unitOfWorkManage.RollbackTran();
return content.Error(ex.Message);
}
}
///
/// 配送送达信息
///
///
public MESDeliveryModel MESDeliveryUp(List outStockLockInfos,string address)
{
MESDeliveryModel mESDeliveryModel = new MESDeliveryModel()
{
PRO_DispatchPlanMaterialsInfoNew= new List()
};
foreach (var item in outStockLockInfos)
{
MESDeliveryInfo mESDeliveryInfo = new MESDeliveryInfo()
{
InvItemCode=item.MaterielCode,
DispatchPlanMaterialId=item.OrderDetailId,
UnitCode=item.Unit,
GradeCode="001",
MainQuantity=item.OriginalQuantity,
AssistUnitCode=item.AssistUnit,
LocationCode= address,
LotNumber=item.BatchNo,
MaterialBarCode=item.PalletCode
};
mESDeliveryModel.PRO_DispatchPlanMaterialsInfoNew.Add(mESDeliveryInfo);
}
return mESDeliveryModel;
}
///
/// 库存数据转出库任务(原料/半成品)
///
///
///
public List GetTasks(List stockInfos, TaskTypeEnum taskType)
{
List tasks = new List();
for (int i = 0; i < stockInfos.Count; i++)
{
Dt_StockInfo stockInfo = stockInfos[i];
if (stockInfo != null)
{
Dt_LocationInfo locationInfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == stockInfo.LocationCode);
if (!tasks.Exists(x => x.PalletCode == stockInfo.PalletCode))
{
Dt_Task task = new()
{
CurrentAddress = stockInfo.LocationCode,
Grade = 0,
PalletCode = stockInfo.PalletCode,
NextAddress = "",
Roadway = locationInfo.RoadwayNo,
SourceAddress = stockInfo.LocationCode,
TargetAddress = "",
TaskStatus = TaskStatusEnum.New.ObjToInt(),
TaskType = taskType.ObjToInt(),
TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)),
PalletType = stockInfo.PalletType,
WarehouseId = stockInfo.WarehouseId,
MaterielCode = stockInfo.MaterielCode,
RfidCode = stockInfo.RfidCode,
Quantity = stockInfo.StockLength,
};
if (stockInfo.MaterielWide>0)
{
task.TaskLength = (int)stockInfo.MaterielWide;
}
tasks.Add(task);
}
}
}
return tasks;
}
///
/// 库存数据转出库任务(MES工单成品)
///
///
///
public List GetTasks(List stockInfos, List outStockLockInfos, TaskTypeEnum taskType = new TaskTypeEnum())
{
List tasks = new List();
for (int i = 0; i < stockInfos.Count; i++)
{
Dt_ProStockInfo stockInfo = stockInfos[i];
if (stockInfo != null)
{
Dt_LocationInfo locationInfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == stockInfo.LocationCode);
if (!tasks.Exists(x => x.PalletCode == stockInfo.PalletCode))
{
Dt_OutStockLockInfo outStockLockInfo = outStockLockInfos.FirstOrDefault(x => x.PalletCode == stockInfo.PalletCode);
taskType = outStockLockInfo.MachineName.ObjToInt() switch
{
(int)StationAreaEnum.二楼纸袋 or
(int)StationAreaEnum.二楼无纺布袋 or
(int)StationAreaEnum.二楼纸杯 => TaskTypeEnum.OutCarton,
(int)StationAreaEnum.一楼无纺织布 => TaskTypeEnum.OutWFB,
_ => throw new Exception($"未找到加工中心任务类型分配")
};
Dt_Task task = new()
{
CurrentAddress = stockInfo.LocationCode,
Grade = 0,
PalletCode = stockInfo.PalletCode,
NextAddress = "",
Roadway = locationInfo.RoadwayNo,
SourceAddress = stockInfo.LocationCode,
TargetAddress = "",
TaskStatus = TaskStatusEnum.CallPending.ObjToInt(),
TaskType = taskType.ObjToInt(),
TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)),
PalletType = stockInfo.PalletType,
WarehouseId = stockInfo.WarehouseId,
MaterielCode = stockInfo.proStockInfoDetails?.FirstOrDefault().ProductCode ??"",
Quantity = stockInfo.proStockInfoDetails?.Sum(x=>x.StockQty) ?? 0,
OrderNo = outStockLockInfo.OrderNo,
DispatchPlanId = outStockLockInfo.OrderDetailId,
WorkCentreCode = outStockLockInfo.MakeCode
};
tasks.Add(task);
}
}
}
return tasks;
}
///
/// 库存数据转出库任务(MES工单原料)
///
///
///
public List GetTasks(List stockInfos,List outStockLockInfos, TaskTypeEnum taskType=new TaskTypeEnum())
{
List tasks = new List();
for (int i = 0; i < stockInfos.Count; i++)
{
Dt_StockInfo stockInfo = stockInfos[i];
if (stockInfo != null)
{
Dt_LocationInfo locationInfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == stockInfo.LocationCode);
if (!tasks.Exists(x => x.PalletCode == stockInfo.PalletCode))
{
Dt_OutStockLockInfo outStockLockInfo = outStockLockInfos.FirstOrDefault(x => x.PalletCode == stockInfo.PalletCode);
taskType = outStockLockInfo.MachineName.ObjToInt() switch
{
(int)StationAreaEnum.二楼纸袋 => TaskTypeEnum.PaperYLOutZDGL,
(int)StationAreaEnum.一楼印刷 => TaskTypeEnum.PrintYLOutbound,
(int)StationAreaEnum.一楼分切 => TaskTypeEnum.OutFenQie,
_ => throw new Exception($"未找到加工中心任务类型分配")
};
Dt_Task task = new()
{
CurrentAddress = stockInfo.LocationCode,
Grade = 0,
PalletCode = stockInfo.PalletCode,
NextAddress = "",
Roadway = locationInfo.RoadwayNo,
SourceAddress = stockInfo.LocationCode,
TargetAddress = "",
TaskStatus = TaskStatusEnum.CallPending.ObjToInt(),
TaskType = taskType.ObjToInt(),
TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)),
PalletType = stockInfo.PalletType,
WarehouseId = stockInfo.WarehouseId,
MaterielCode = stockInfo.MaterielCode,
RfidCode = stockInfo.RfidCode,
Quantity = stockInfo.StockLength,
OrderNo= outStockLockInfo.OrderNo,
DispatchPlanId=outStockLockInfo.OrderDetailId,
WorkCentreCode=outStockLockInfo.MakeCode
};
if (stockInfo.MaterielWide > 0)
{
task.TaskLength = (int)stockInfo.MaterielWide;
}
tasks.Add(task);
}
}
}
return tasks;
}
///
/// 库存数据转出库任务(辅料/成品)
///
public List GetTasks(List stockInfos, TaskTypeEnum taskType,List locationInfos)
{
List tasks = new List();
for (int i = 0; i < stockInfos.Count; i++)
{
Dt_ProStockInfo stockInfo = stockInfos[i];
if (stockInfo != null)
{
Dt_LocationInfo locationInfo = locationInfos.FirstOrDefault(x => x.LocationCode == stockInfo.LocationCode);
if (!tasks.Exists(x => x.PalletCode == stockInfo.PalletCode))
{
Dt_Task task = new ()
{
CurrentAddress = stockInfo.LocationCode,
Grade = 0,
PalletCode = stockInfo.PalletCode,
NextAddress = "",
Roadway = locationInfo.RoadwayNo,
SourceAddress = stockInfo.LocationCode,
TargetAddress = "",
TaskStatus = TaskStatusEnum.New.ObjToInt(),
TaskType = taskType.ObjToInt(),
TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)),
PalletType = stockInfo.PalletType,
WarehouseId = stockInfo.WarehouseId,
MaterielCode= stockInfo.proStockInfoDetails?.FirstOrDefault().ProductCode ?? "" ,
Quantity = stockInfo.proStockInfoDetails?.Sum(x=>x.StockQty) ?? 0,
};
tasks.Add(task);
}
}
}
return tasks;
}
///
/// 成品出库
///
///
public WebResponseContent RequestCPWMSTaskOut(string materialCode,int Count, string targetId)
{
WebResponseContent content = new WebResponseContent();
try
{
List aGVStationInfos = _basicRepository.AGVStationInfoRepository.QueryData(x=>x.StationArea == targetId && x.IsOccupied==WhetherEnum.False.ObjToInt());
int useCount=aGVStationInfos.Count;
if (targetId == nameof(StationAreaEnum.一楼月台码头))
{
//获取所有月台出库任务
List _TasksOut = BaseDal.QueryData(x => x.TaskType == TaskTypeEnum.OutProduct.ObjToInt() && x.TargetAddress == nameof(StationAreaEnum.一楼月台码头));
if (_TasksOut.Count>0)
{
useCount -= _TasksOut.Count;
}
}
if (useCount < Count)
{
return content.Error($"可用缓存数不足");
}
//获取货位
List locationInfos = _basicRepository.LocationInfoRepository.QueryData(x => x.WarehouseId == WarehouseEnum.LLDCP.ObjToInt() && x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.LocationStatus == LocationStatusEnum.InStock.ObjToInt());
List stockInfos = new List();
if (materialCode=="1")
{
stockInfos = BaseDal.Db.Queryable().Where(x => locationInfos.Select(x => x.LocationCode).Contains(x.LocationCode) && x.StockStatus == StockStatusEmun.入库完成.ObjToInt() && x.ProStockAttribute==ProStockAttributeEnum.空托.ObjToInt()).Take(Count).OrderBy(x => x.CreateDate).ToList();
}
else
{
stockInfos = BaseDal.Db.Queryable().Where(x => locationInfos.Select(x => x.LocationCode).Contains(x.LocationCode) && x.StockStatus == StockStatusEmun.入库完成.ObjToInt()).Includes(x => x.proStockInfoDetails)
.Where(x => x.proStockInfoDetails
.Any(v =>
v.ProductCode == materialCode)
).Take(Count).OrderBy(x=>x.CreateDate).ToList();
}
if (stockInfos.Count!=Count)
{
return content.Error($"库存{materialCode}数量不足");
}
List AssignLocations = new List();
foreach (var item in stockInfos)
{
Dt_LocationInfo? locationInfo = locationInfos.FirstOrDefault(x => x.LocationCode == item.LocationCode);
if (locationInfo != null)
{
AssignLocations.Add(locationInfo);
item.StockStatus = StockStatusEmun.出库锁定.ObjToInt();
}
}
TaskTypeEnum typeEnum = targetId switch
{
nameof(StationAreaEnum.一楼月台码头) => TaskTypeEnum.OutProduct,
nameof(StationAreaEnum.一楼无纺织布) => TaskTypeEnum.OutWFB,
nameof(StationAreaEnum.一楼无纺淋膜) => TaskTypeEnum.OutWFBLM,
nameof(StationAreaEnum.一楼纸张淋膜) => TaskTypeEnum.OutPaperLM,
nameof(StationAreaEnum.一楼分切) => TaskTypeEnum.OutFenQie,
nameof(StationAreaEnum.一楼模切) => TaskTypeEnum.OutMoQie,
nameof(StationAreaEnum.一楼冲切) => TaskTypeEnum.OutChongQie,
nameof(StationAreaEnum.一楼成品) => TaskTypeEnum.OutProduct,
nameof(StationAreaEnum.二楼纸袋) or
nameof(StationAreaEnum.二楼无纺布袋) or
nameof(StationAreaEnum.二楼纸杯) => TaskTypeEnum.OutCarton,
_ => throw new Exception("未找到对应任务")
};
if (materialCode == "1" && typeEnum!= TaskTypeEnum.OutCarton)
{
typeEnum = TaskTypeEnum.OutEmpty;
}
List tasks = GetTasks(stockInfos, typeEnum, AssignLocations);
if (tasks == null || tasks.Count <= 0)
{
return content.Error($"生成任务失败");
}
//月台任务不直接分配终点
if (targetId != nameof(StationAreaEnum.一楼月台码头))
{
for (int i = 0; i < tasks.Count; i++)
{
aGVStationInfos[i].IsOccupied = WhetherEnum.True.ObjToInt();
tasks[i].TargetAddress = aGVStationInfos[i].AGVStationCode;
}
}
else
{
for (int i = 0; i < tasks.Count; i++)
{
tasks[i].TargetAddress = nameof(StationAreaEnum.一楼月台码头);
}
}
//判断是否有出库单信息
_unitOfWorkManage.BeginTran();
//更新库存状态
_stockRepository.ProStockInfoRepository.UpdateData(stockInfos);
_basicRepository.AGVStationInfoRepository.UpdateData(aGVStationInfos);
//更新货位状态
_basicRepository.LocationInfoRepository.UpdateLocationStatus(AssignLocations, LocationStatusEnum.Lock);
//加入货位变动记录
_recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(AssignLocations, LocationStatusEnum.Lock, LocationChangeType.OutboundAssignLocation, taskNums: tasks.Select(x => x.TaskNum).ToList());
//新建任务
BaseDal.AddData(tasks);
_unitOfWorkManage.CommitTran();
PushTasksToWCS(tasks);
content.OK();
}
catch (Exception ex)
{
content.Error(ex.Message);
}
return content;
}
///
/// 原料出库任务
///
/// 物料代码
/// 物料幅宽
/// 卷数
///
public WebResponseContent RequestYLWMSTaskOut(YLWMSTaskOutDTO yLWMSTaskOutDTO)
{
WebResponseContent content = new WebResponseContent();
try
{
if (yLWMSTaskOutDTO==null)
{
return content.Error("请填入出库信息");
}
//获取货位
List locationInfos = _basicRepository.LocationInfoRepository.QueryData(x => x.WarehouseId == WarehouseEnum.LLDYL.ObjToInt() && x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.LocationStatus == LocationStatusEnum.InStock.ObjToInt());
//获取对应库存
List stockInfos = _stockRepository.StockInfoRepository.QueryData(x => locationInfos.Select(x => x.LocationCode).Contains(x.LocationCode) && x.MaterielCode == yLWMSTaskOutDTO.MaterialCode && x.MaterielWide == yLWMSTaskOutDTO.Wide && x.StockStatus == StockStatusEmun.入库完成.ObjToInt() && x.MaterielInvOrgId == MaterielInvOrgEnum.新厂.ObjToInt()).OrderByDescending(x => x.CreateDate).Take(yLWMSTaskOutDTO.Count).ToList();
if (stockInfos.Count< yLWMSTaskOutDTO.Count)
{
return content.Error($"库存{yLWMSTaskOutDTO.MaterialCode}数量不足");
}
List AssignLocations =new List();
foreach (var item in stockInfos)
{
Dt_LocationInfo? locationInfo = locationInfos.FirstOrDefault(x=>x.LocationCode==item.LocationCode);
if (locationInfo!=null)
{
AssignLocations.Add(locationInfo);
item.StockStatus = StockStatusEmun.出库锁定.ObjToInt();
}
}
List tasks = GetTasks(stockInfos, TaskTypeEnum.PrintYLOutbound);
if (tasks == null || tasks.Count <= 0)
{
return content.Error($"生成任务失败");
}
if (!string.IsNullOrEmpty(yLWMSTaskOutDTO.Address))
{
if (yLWMSTaskOutDTO.Address=="1")
{
tasks.ForEach(x =>
{
x.TargetAddress = "PNT_1_363";
});
}
else
{
tasks.ForEach(x =>
{
x.TargetAddress = yLWMSTaskOutDTO.Address;
});
}
}
else
{
return content.Error("地址信息不能为空");
}
//判断是否有出库单信息
_unitOfWorkManage.BeginTran();
//更新库存状态
_stockRepository.StockInfoRepository.UpdateData(stockInfos);
//更新货位状态
_basicRepository.LocationInfoRepository.UpdateLocationStatus(AssignLocations, LocationStatusEnum.Lock);
//加入货位变动记录
_recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(AssignLocations, LocationStatusEnum.Lock, LocationChangeType.OutboundAssignLocation,taskNums:tasks.Select(x=>x.TaskNum).ToList());
//新建任务
BaseDal.AddData(tasks);
_unitOfWorkManage.CommitTran();
PushTasksToWCS(tasks);
content.OK();
}
catch (Exception ex)
{
content.Error(ex.Message);
}
return content;
}
///
/// 创建原纸生管排程出库任务
///
///
///
public WebResponseContent CreateSGOutboundTasks(int[] keys)
{
WebResponseContent content = new WebResponseContent();
try
{
List tasks = new List();
List stockInfos = new List();
List outSGOrderDetails = new List();
List outStockLockInfos = new List();
List locationInfos = new List();
//生成任务、库存等信息
(List, List?, List?, List?, List?,string) result = OutSGTaskDataHandle(keys);
if (result.Item2 != null && result.Item2.Count > 0)
{
stockInfos.AddRange(result.Item2);
}
if (result.Item3 != null && result.Item3.Count > 0)
{
outSGOrderDetails.AddRange(result.Item3);
}
if (result.Item4 != null && result.Item4.Count > 0)
{
outStockLockInfos.AddRange(result.Item4);
}
if (result.Item5 != null && result.Item5.Count > 0)
{
locationInfos.AddRange(result.Item5);
}
if (result.Item1 != null && result.Item1.Count > 0)
{
tasks.AddRange(result.Item1);
}
content.Message = result.Item6;
//处理出库数据
return GenerateOutboundTaskDataUpdate(tasks, stockInfos, outSGOrderDetails, outStockLockInfos, locationInfos);
}
catch (Exception ex)
{
_unitOfWorkManage.RollbackTran();
content.Error(ex.Message);
}
return content;
}
///
/// 出库任务数据处理
///
///
///
///
///
public (List, List?, List?, List?, List?,string) OutSGTaskDataHandle(int[] keys)
{
List tasks = new List();
List outSGOrderDetails = _outboundRepository.OutSGOrderDetailRepository.QueryData(x => keys.Contains(x.Id));
if (outSGOrderDetails == null || outSGOrderDetails.Count == 0)
{
throw new Exception("未找到出库单明细信息");
}
Dt_OutSGOrderDetail? outBSTOrderDetail = outSGOrderDetails.FirstOrDefault(x => x.OutSGOrderDetailStatus != OutOrderStatusEnum.未开始.ObjToInt());
if (outBSTOrderDetail != null)
{
throw new Exception($"出库明细{nameof(Dt_OutSGOrderDetail.BoardMpsDetailId)}{outBSTOrderDetail.BoardMpsDetailId}物料{outBSTOrderDetail.MaterialNo},出库中或已完成");
}
List? stockInfos = null;
List? orderDetails = null;
List? outStockLockInfos = null;
List? locationInfos = null;
//分配库存
(List, List, List, List,string) result = _outboundService.OutSGOrderDetailService.AssignStockOutbound(outSGOrderDetails);
if (result.Item1 != null && result.Item1.Count > 0)
{
//获取任务
tasks = GetTasks(result.Item1.Where(x=> !x.LocationCode.IsNullOrEmpty()).ToList(), TaskTypeEnum.OldYLOutbound);
result.Item2.ForEach(x =>
{
if (result.Item3.FirstOrDefault(t=>t.OrderDetailId==x.Id)!=null)
{
x.OutSGOrderDetailStatus = OutOrderStatusEnum.出库中.ObjToInt();
}
});
result.Item3.ForEach(x =>
{
if (x.LocationCode== "老厂缓存区")
{
x.Status = OutLockStockStatusEnum.出库完成.ObjToInt();
}
else
{
x.Status = OutLockStockStatusEnum.出库中.ObjToInt();
}
});
stockInfos = result.Item1;
orderDetails = result.Item2;
outStockLockInfos = result.Item3;
locationInfos = result.Item4;
}
else
{
throw new Exception("无库存");
}
return (tasks, stockInfos, orderDetails, outStockLockInfos, locationInfos, result.Item5);
}
///
/// 处理出库数据
///
///
public WebResponseContent GenerateOutboundTaskDataUpdate(List tasks, List? stockInfos = null, List? outboundOrderDetails = null, List? outStockLockInfos = null, List? locationInfos = null)
{
try
{
_unitOfWorkManage.BeginTran();
if (outStockLockInfos != null && outStockLockInfos.Any())
{
tasks.ForEach(x =>
{
string orderNos = string.Join(",", outStockLockInfos.Where(t => t.PalletCode == x.PalletCode).Select(x => x.OrderNo).Distinct());
x.OrderNo = orderNos;
});
}
BaseDal.AddData(tasks);
if (stockInfos != null && stockInfos.Count > 0 && outboundOrderDetails != null && outboundOrderDetails.Count > 0 && outStockLockInfos != null && outStockLockInfos.Count > 0 && locationInfos != null && locationInfos.Count > 0)
{
stockInfos.ForEach(x =>
{
x.StockStatus = StockStatusEmun.出库锁定.ObjToInt();
});
List outSGOrders = _outboundRepository.OutSGOrderRepository.QueryData(x => outStockLockInfos.Select(x=>x.OrderNo).Distinct().Contains(x.OrderId));
if (outSGOrders.Count<=0)
{
throw new Exception("未找到单据信息");
}
outSGOrders.ForEach(x =>
{
x.OutSGOrderStatus = OutOrderStatusEnum.出库中.ObjToInt();
});
_outboundRepository.OutSGOrderRepository.UpdateData(outSGOrders);
WebResponseContent content = _outboundService.OutSGOrderDetailService.LockOutboundStockDataUpdate(stockInfos, outboundOrderDetails, outStockLockInfos, locationInfos, tasks: tasks);
if (!content.Status)
{
_unitOfWorkManage.RollbackTran();
return content;
}
}
_unitOfWorkManage.CommitTran();
PushTasksToWCS(tasks);
return WebResponseContent.Instance.OK();
}
catch (Exception ex)
{
_unitOfWorkManage.RollbackTran();
return WebResponseContent.Instance.Error(ex.Message);
}
}
///
/// BST领料信息同步
///
///
///
public WebResponseContent ReceivePicking(List bSTPickInfoDTOs)
{
WebResponseContent content = new WebResponseContent();
try
{
//获取领料条码及库存
List lockCodes = bSTPickInfoDTOs.SelectMany(x => x.PaperMattakeDetails).Select(x=>x.Barcode).Distinct().ToList();
List stockInfos = _stockRepository.StockInfoRepository.QueryData(x => lockCodes.Contains(x.PalletCode) && x.WarehouseId == WarehouseEnum.LLDOldCache.ObjToInt());
List ExistNoCodes = lockCodes.Where(x => !stockInfos.Select(x=>x.PalletCode).Contains(x)).ToList();
//获取待领料的出库详情
List outStockLockInfos = _outboundRepository.OutStockLockInfoRepository.QueryData(x => x.OrderType == OutOrderTypeEnum.OutSGPick.ObjToInt() && x.Status==OutLockStockStatusEnum.出库完成.ObjToInt() && lockCodes.Distinct().ToList().Contains(x.PalletCode));
//出库详情状态更新
if (outStockLockInfos.Count > 0)
{
outStockLockInfos.ForEach(x =>
{
x.Status = OutLockStockStatusEnum.关闭.ObjToInt();
});
}
List BSTPickDetailsId = outStockLockInfos.Select(x => x.OrderDetailId).Distinct().ToList();
//获取对应排程
List outSGOrders = BaseDal.Db.Queryable().Where(x => x.OutSGOrderStatus < OutOrderStatusEnum.出库完成.ObjToInt()).Includes(x => x.Details)
.Where(x => x.Details
.Any(v =>
BSTPickDetailsId.Contains(v.Id))
).OrderBy(x => x.CreateDate).ToList();
List orderDetails = new List();
//处理排程
if (outSGOrders.Count>0)
{
orderDetails = outSGOrders.SelectMany(x=>x.Details).Where(x=> BSTPickDetailsId.Contains(x.Id)).ToList();
orderDetails.ForEach(x =>
{
x.OutSGOrderDetailStatus = OutOrderStatusEnum.出库完成.ObjToInt();
});
foreach (var item in outSGOrders)
{
int overCount = item.Details.Where(x=>x.OutSGOrderDetailStatus==OutLockStockStatusEnum.出库完成.ObjToInt()).Count();
int thisCount = orderDetails.Where(x => x.OutSGOrderId == item.Id).Count();
if ((overCount + thisCount) == item.Details.Count)
{
item.OutSGOrderStatus = OutOrderStatusEnum.出库完成.ObjToInt();
}
}
}
//获取所有待领料的库存
#region 领料逻辑
foreach (var item in stockInfos)
{
if (item.StockStatus==StockStatusEmun.出库完成.ObjToInt())
{
item.StockLength = 0;
item.MaterielWeight = 0;
item.MaterielThickness = 0;
item.MaterielWide = 0;
item.StockOutLength = 0;
item.IsFull = WhetherEnum.True.ObjToInt();
item.IsPick = WhetherEnum.True.ObjToInt();
}
}
#endregion
List outLineViewsDel = _outboundRepository.OutLineViewRepository.QueryData(x => stockInfos.Select(x=>x.PalletCode).Contains(x.PalletCode));
_unitOfWorkManage.BeginTran();
_stockRepository.StockInfoRepository.UpdateData(stockInfos);
_outboundRepository.OutStockLockInfoRepository.UpdateData(outStockLockInfos);
_outboundRepository.OutSGOrderRepository.UpdateData(outSGOrders);
_outboundRepository.OutSGOrderDetailRepository.UpdateData(orderDetails);
_outboundRepository.OutLineViewRepository.DeleteData(outLineViewsDel);
_unitOfWorkManage.CommitTran();
content.OK(ExistNoCodes.Count>0 ? string.Join(",", ExistNoCodes)+"老厂可扣库存不存在" : "");
}
catch (Exception ex)
{
_unitOfWorkManage.RollbackTran();
content.Error(ex.Message);
}
return content;
}
///
/// 创建生管手动出库
///
///
///
public WebResponseContent CreateSGManualTasks(List ids)
{
WebResponseContent content=new WebResponseContent();
try
{
//获取所有明细
List outSGOrders = BaseDal.Db.Queryable().Where(x=>ids.Contains(x.Id)).Includes(x=>x.Details).ToList();
List outSGOrderDetails = outSGOrders.SelectMany(x=>x.Details.Where(t=>t.OutSGOrderDetailStatus==OutOrderStatusEnum.未开始.ObjToInt())).ToList();
List ints = outSGOrderDetails.Select(x => x.Id).ToList();
int[] reseponse = new int[ints.Count];
for (int i = 0; i < ints.Count; i++)
{
reseponse[i] = ints[i];
}
content = CreateSGOutboundTasks(reseponse);
}
catch (Exception ex)
{
_unitOfWorkManage.RollbackTran();
content.Error(ex.Message);
}
return content;
}
List GradeCodes = new List
{
"001"
};
///
/// 接收MES领料计划
///
///
public WebResponseContent ReceiveOutBound(List outMESOrderDTOs)
{
WebResponseContent content = new WebResponseContent();
string ErrorMsg = "";
try
{
if (outMESOrderDTOs == null || outMESOrderDTOs.Count <= 0)
{
return content.Error("领料计划传入信息为空");
}
List warehouses = _basicRepository.WarehouseRepository.QueryData();
OutMESOrderDTO? CheckGradeCode = outMESOrderDTOs.FirstOrDefault(x => !GradeCodes.Contains(x.GradeCode));
if (CheckGradeCode != null)
{
return content.Error($"领料计划等级{nameof(OutMESOrderDTO.GradeCode)}:{CheckGradeCode.GradeCode}不存在");
}
OutMESOrderDTO? CheckOutDetailId = outMESOrderDTOs.FirstOrDefault(x => x.OutDetailId <= 0);
if (CheckOutDetailId != null)
{
return content.Error($"领料计划ID:{CheckOutDetailId.OutDetailId}需大于0");
}
OutMESOrderDTO? CheckReqQuantity = outMESOrderDTOs.FirstOrDefault(x => x.ReqQuantity <= 0);
if (CheckReqQuantity != null)
{
return content.Error($"领料计划ID:{CheckReqQuantity.OutDetailId},{CheckReqQuantity.ProductOrderNo}物料需求需要大于0");
}
//获取所有物料信息
List materielInfos = _basicRepository.MaterielInfoRepository.QueryData(x => x.MaterielInvOrgId == MaterielInvOrgEnum.新厂.ObjToInt());
//获取所有领料计划
List outMESOrders = _outboundRepository.OutMESOrderRepository.QueryData();
//获取所有加工中心
List makeCenterInfos = _basicRepository.MakeCenterInfoRepository.QueryData();
//OutMESOrderDTO? CheckMaterialCode = outMESOrderDTOs.FirstOrDefault(x => !materielInfos.Select(x => x.MaterielCode).Contains(x.MaterialCode));
//if (CheckMaterialCode != null)
//{
// return content.Error($"物料编码{nameof(OutMESOrderDTO.MaterialCode)}:{CheckMaterialCode.MaterialCode}信息不存在");
//}
OutMESOrderDTO? CheckMakeCenterCode = outMESOrderDTOs.FirstOrDefault(x => !makeCenterInfos.Select(x => x.MakeCode).Contains(x.MakeCode));
if (CheckMakeCenterCode!=null)
{
return content.Error($"加工中心{nameof(OutMESOrderDTO.MakeCode)}:{CheckMakeCenterCode.MakeCode}信息不存在");
}
Dt_OutMESOrder? OldoutMESOrder = outMESOrders.FirstOrDefault(x => outMESOrderDTOs.Select(x => x.OutDetailId).Contains(x.OutDetailId));
if (OldoutMESOrder != null)
{
return content.Error($"领料计划{nameof(OutMESOrderDTO.OutDetailId)}:{OldoutMESOrder.OutDetailId}信息已存在");
}
List AddoutMESOrders = new List();
foreach (var item in outMESOrderDTOs)
{
Dt_MaterielInfo? materielInfo = materielInfos.FirstOrDefault(x => x.MaterielCode == item.MaterialCode);
if (materielInfo==null)
{
ErrorMsg += $"物料编码:{item.MaterialCode}信息不存在;";
continue;
}
Dt_MakeCenterInfo makeCenterInfo = makeCenterInfos.FirstOrDefault(x => x.MakeCode == item.MakeCode);
Dt_OutMESOrder outMESOrder = _mapper.Map(item);
outMESOrder.MakeArea = makeCenterInfo.MakeArea;
outMESOrder.WarehouseId = materielInfo.WarehouseId;
outMESOrder.MaterielUnit = materielInfo.MaterielUnit;
outMESOrder.AssistUnitCode = materielInfo.AssistUnitCode;
AddoutMESOrders.Add(outMESOrder);
}
_unitOfWorkManage.BeginTran();
//操作数据,并分配需求库存
_outboundRepository.OutMESOrderRepository.AddData(AddoutMESOrders);
//List mESOrders = _outboundRepository.OutMESOrderRepository.QueryData(x => AddoutMESOrders.Select(x => x.OutDetailId).Contains(x.OutDetailId));
//{
// List tasks = new List();
// List? stockInfos = null;
// List? Orders = null;
// List? outStockLockInfos = null;
// List? locationInfos = null;
// {
// if (mESOrders.Where(x => x.WarehouseId == WarehouseEnum.LLDFL.ObjToInt()).ToList().Count>0)
// {
// //分配库存
// (List, List, List, List) result = _outboundService.OutMESOrderService.AssignProStockOutbound(mESOrders.Where(x => x.WarehouseId == WarehouseEnum.LLDFL.ObjToInt()).ToList());
// if (result.Item1 != null && result.Item1.Count > 0)
// {
// //创建任务
// tasks = GetTasks(result.Item1, result.Item3);
// result.Item3.ForEach(x =>
// {
// x.Status = OutLockStockStatusEnum.出库中.ObjToInt();
// });
// stockInfos = result.Item1;
// Orders = result.Item2;
// outStockLockInfos = result.Item3;
// locationInfos = result.Item4;
// }
// }
// }
// if (stockInfos != null && stockInfos.Count > 0 && outStockLockInfos != null && outStockLockInfos.Count > 0 && locationInfos != null && locationInfos.Count > 0 && tasks.Count>0)
// {
// BaseDal.AddData(tasks);
// stockInfos.ForEach(x =>
// {
// x.StockStatus = StockStatusEmun.出库锁定.ObjToInt();
// });
// WebResponseContent contentResponse = _outboundService.OutMESOrderService.LockOutboundStockDataUpdate(stockInfos, Orders, outStockLockInfos, locationInfos, tasks: tasks);
// if (!contentResponse.Status)
// {
// _unitOfWorkManage.RollbackTran();
// return content.Error(contentResponse.Message);
// }
// }
//}
//{
// List tasks = new List();
// List? stockInfos = null;
// List? Orders = null;
// List? outStockLockInfos = null;
// List? locationInfos = null;
// {
// if (mESOrders.Where(x => x.WarehouseId == WarehouseEnum.LLDYL.ObjToInt()).ToList().Count > 0)
// {
// //分配库存
// (List, List, List, List) result = _outboundService.OutMESOrderService.AssignStockOutbound(mESOrders.Where(x => x.WarehouseId == WarehouseEnum.LLDYL.ObjToInt()).ToList());
// if (result.Item1 != null && result.Item1.Count > 0)
// {
// //创建任务
// tasks = GetTasks(result.Item1, result.Item3);
// result.Item3.ForEach(x =>
// {
// x.Status = OutLockStockStatusEnum.出库中.ObjToInt();
// });
// stockInfos = result.Item1;
// Orders = result.Item2;
// outStockLockInfos = result.Item3;
// locationInfos = result.Item4;
// }
// }
// }
// if (stockInfos != null && stockInfos.Count > 0 && outStockLockInfos != null && outStockLockInfos.Count > 0 && locationInfos != null && locationInfos.Count > 0 && tasks.Count>0)
// {
// BaseDal.AddData(tasks);
// stockInfos.ForEach(x =>
// {
// x.StockStatus = StockStatusEmun.出库锁定.ObjToInt();
// });
// WebResponseContent contentResponse = _outboundService.OutMESOrderService.LockOutboundStockDataUpdate(stockInfos, Orders, outStockLockInfos, locationInfos, tasks: tasks);
// if (!contentResponse.Status)
// {
// _unitOfWorkManage.RollbackTran();
// return content.Error(contentResponse.Message);
// }
// }
//}
_unitOfWorkManage.CommitTran();
return content.OK(ErrorMsg.IsNullOrEmpty()? "接收成功" : $"信息:{ErrorMsg}");
}
catch (Exception ex)
{
_unitOfWorkManage.RollbackTran();
content.Error(ex.Message);
}
return content;
}
///
/// 空托叠盘出库
///
///
public WebResponseContent PlateOutbound(string stationCode)
{
WebResponseContent content = new WebResponseContent();
try
{
//获取所有月台出库任务
Dt_Task TasksOut = BaseDal.QueryFirst(x => x.TaskType == TaskTypeEnum.OutEmptyPlate.ObjToInt());
if (TasksOut != null)
throw new Exception($"任务已存在");
//获取货位
List locationInfos = _basicRepository.LocationInfoRepository.QueryData(x => x.WarehouseId == WarehouseEnum.LLDCP.ObjToInt() && x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.LocationStatus == LocationStatusEnum.InStock.ObjToInt());
Dt_ProStockInfo? stockInfo = BaseDal.Db.Queryable().Where(x => locationInfos.Select(x => x.LocationCode).Contains(x.LocationCode) && x.StockStatus == StockStatusEmun.入库完成.ObjToInt() && x.ProStockAttribute == ProStockAttributeEnum.空托.ObjToInt()).OrderBy(x => x.CreateDate).ToList().FirstOrDefault() ?? throw new Exception($"库存空托数量不足");
Dt_LocationInfo locationInfo = locationInfos.FirstOrDefault(x => x.LocationCode == stockInfo.LocationCode);
stockInfo.StockStatus = StockStatusEmun.出库锁定.ObjToInt();
TaskTypeEnum typeEnum = TaskTypeEnum.OutEmptyPlate;
List tasks = GetTasks(new List() { stockInfo }, typeEnum, new List() { locationInfo });
if (tasks == null || tasks.Count <= 0)
{
return content.Error($"生成任务失败");
}
tasks.ForEach(x =>
{
x.TargetAddress = stationCode;
});
//判断是否有出库单信息
_unitOfWorkManage.BeginTran();
//更新库存状态
_stockRepository.ProStockInfoRepository.UpdateData(stockInfo);
//更新货位状态
_basicRepository.LocationInfoRepository.UpdateLocationStatus(new List() { locationInfo }, LocationStatusEnum.Lock);
//加入货位变动记录
_recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(new List() { locationInfo }, LocationStatusEnum.Lock, LocationChangeType.OutboundAssignLocation, taskNums: tasks.Select(x => x.TaskNum).ToList());
//新建任务
BaseDal.AddData(tasks);
_unitOfWorkManage.CommitTran();
PushTasksToWCS(tasks);
content.OK();
}
catch (Exception ex)
{
content.Error(ex.Message);
}
return content;
}
}
}