|
|
namespace WIDESEA_StorageOutTaskServices;
|
|
public class Dt_TaskService : ServiceBase<Dt_Task, IDt_TaskRepository>, IDt_TaskService
|
{
|
private readonly LogFactory LogFactory = new LogFactory();
|
private readonly IUnitOfWorkManage _unitOfWorkManage;
|
private readonly IDt_OutOrderRepository _outOrderRepository;
|
private readonly IDt_BillGroupStockRepository _billGroupStockRepository;
|
private readonly IDt_Task_HtyRepository _task_HtyRepository;
|
private readonly IDt_OutOrderAndStockRepository _outOrderAndStockRepository;
|
private readonly IDt_OutOrderAndStock_HtyRepository _outOrderAndStock_HtyRepository;
|
private readonly IMapper _mapper;
|
private readonly IDt_MaterielInfoRepository _materielInfoRepository;
|
private readonly IDt_LocationRepository _locationRepository;
|
|
public Dt_TaskService(IDt_TaskRepository BaseDal,
|
IUnitOfWorkManage unitOfWorkManage,
|
IDt_OutOrderRepository outOrderRepository,
|
IDt_BillGroupStockRepository billGroupStockRepository,
|
IDt_OutOrderAndStockRepository dt_OutOrderAndStockRepository,
|
IDt_OutOrderAndStock_HtyRepository dt_OutOrderAndStock_HtyRepository,
|
IDt_Task_HtyRepository task_HtyRepository,
|
IMapper mapper,
|
IDt_MaterielInfoRepository materielInfoRepository,
|
IDt_LocationRepository locationRepository) : base(BaseDal)
|
{
|
_unitOfWorkManage = unitOfWorkManage;
|
_outOrderRepository = outOrderRepository;
|
_billGroupStockRepository = billGroupStockRepository;
|
_outOrderAndStockRepository = dt_OutOrderAndStockRepository;
|
_outOrderAndStock_HtyRepository = dt_OutOrderAndStock_HtyRepository;
|
_task_HtyRepository = task_HtyRepository;
|
_mapper = mapper;
|
_materielInfoRepository = materielInfoRepository;
|
_locationRepository = locationRepository;
|
}
|
|
#region 外部接口方法
|
|
/// <summary>
|
/// 堆垛机任务完成
|
/// </summary>
|
/// <param name="saveModel">任务数据合集</param>
|
/// <returns>返回结果集</returns>
|
public async Task<WebResponseContent> CompleteStackTaskAsync(Dt_Task task, Dt_BillGroupStock stock)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
// 更新库存状态
|
stock.LocationCode = null;
|
stock.LocationInfo.Status = LocationEnum.Free.ObjToInt();
|
stock.OrderType = 2;
|
|
// 更新任务状态
|
task.TaskState = OutTaskStatusEnum.SC_OutFinish.ObjToInt();
|
task.CurrentAddress = task.NextAddress;
|
task.NextAddress = task.TargetAddress;
|
|
LogFactory.GetLog("任务完成").InfoFormat(true, "堆垛机出库完成", "更新库存状态与任务状态");
|
|
// 事务处理
|
_unitOfWorkManage.BeginTran();
|
var isStockUpdated = _billGroupStockRepository.UpdateNavStock(stock);
|
var isTaskUpdated = await Update(task);
|
|
if (isStockUpdated && isTaskUpdated)
|
{
|
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);
|
}
|
}
|
|
/// <summary>
|
/// 出库任务完成
|
/// </summary>
|
/// <param name="saveModel">任务数据合集</param>
|
/// <returns>返回结果集</returns>
|
public async Task<WebResponseContent> CompleteTaskAsync(Dt_Task task, Dt_BillGroupStock stock)
|
{
|
WebResponseContent content = new WebResponseContent();
|
|
try
|
{
|
// 更新出库订单和库存货位信息
|
var orderStock = await UpdateOrderAndStockAsync(stock, task.PalletCode);
|
LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成", $"更新出库订单和库存货位信息:{JsonConvert.SerializeObject(orderStock)}");
|
|
|
// 检查订单是否完成并处理后续操作
|
if (IsOrderComplete(orderStock))
|
{
|
LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成", $"订单出库完成");
|
// 处理已完成订单
|
await ProcessCompletedOrderAsync(orderStock, task);
|
}
|
else
|
{
|
LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成", $"订单暂未出库完成");
|
// 处理未完成订单
|
await ProcessUpdateOrderAsync(orderStock, task);
|
}
|
|
content.OK("任务完成");
|
}
|
catch (Exception err)
|
{
|
// 记录异常信息
|
Console.WriteLine(err.Message.ToString());
|
content.Error("任务完成失败");
|
}
|
|
return content;
|
}
|
|
/// <summary>
|
/// 移库任务完成
|
/// </summary>
|
/// <param name="saveModel">任务数据合集</param>
|
/// <returns>返回结果集</returns>
|
public async Task<WebResponseContent> CompleteTransferTaskAsync(Dt_Task task, Dt_BillGroupStock stock)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
// 更新货位和库存信息
|
(Dt_BillGroupStock updateStock, Dt_LocationInfo locationInf) = UpdateStockLocation(stock, task.NextAddress);
|
var taskHty = CreateHistoricalTask(task);
|
LogFactory.GetLog("任务完成").InfoFormat(true, "移库任务完成", $"修改后库存数据：{JsonConvert.SerializeObject(updateStock)}，原先货位数据：{locationInf}");
|
|
|
// 执行数据库事务
|
bool isResult = await ExecuteTransaction(updateStock, taskHty, locationInf, task.TaskId);
|
if (isResult)
|
content.OK("移库任务完成成功");
|
else
|
content.Error("移库任务完成失败");
|
}
|
catch (Exception err)
|
{
|
Console.WriteLine(err.Message.ToString());
|
}
|
return content;
|
}
|
|
/// <summary>
|
/// 任务完成
|
/// </summary>
|
/// <param name="taskNum">任务号</param>
|
/// <returns></returns>
|
public async Task<WebResponseContent> CompleteAsync(int taskNum)
|
{
|
WebResponseContent content = new WebResponseContent();
|
// 提取任务数据
|
LogFactory.GetLog("任务完成").InfoFormat(true, "提取任务数据", $"任务号：{taskNum}");
|
|
// 验证任务是否存在
|
var task = await GetByTaskNum(taskNum);
|
if (task == null)
|
{
|
return content.Error("任务不存在");
|
}
|
LogFactory.GetLog("任务完成").InfoFormat(true, "验证任务是否存在", JsonConvert.SerializeObject(task));
|
|
// 验证库存是否存在
|
var stock = await _billGroupStockRepository.GetStocksAsync(palletCode: task.PalletCode);
|
if (stock == null)
|
{
|
return content.Error("库存不存在");
|
}
|
LogFactory.GetLog("任务完成").InfoFormat(true, "验证库存是否存在", JsonConvert.SerializeObject(stock));
|
|
if (task.TaskType == (int)TaskTypeEnum.Outbound)
|
{
|
LogFactory.GetLog("任务完成").InfoFormat(true, "出库任务", "");
|
if (task.TaskState == OutTaskStatusEnum.SC_OutExecuting.ObjToInt())
|
{
|
LogFactory.GetLog("任务完成").InfoFormat(true, "堆垛机出库完成", "");
|
return await CompleteStackTaskAsync(task, stock);
|
}
|
else
|
{
|
LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成", "");
|
return await CompleteTaskAsync(task, stock);
|
}
|
}
|
else if (task.TaskType == (int)TaskTypeEnum.RelocationIn)
|
{
|
LogFactory.GetLog("任务完成").InfoFormat(true, "移库任务完成", "");
|
return await CompleteTransferTaskAsync(task, stock);
|
}
|
else
|
{
|
LogFactory.GetLog("任务完成").InfoFormat(true, $"任务状态异常", "无参数");
|
return content.Error("任务状态异常");
|
}
|
}
|
|
/// <summary>
|
/// 获取所有可出库库存，分配出库。
|
/// </summary>
|
/// <returns>出库库存列表</returns>
|
|
|
#endregion 外部接口方法
|
|
#region 内部调用方法
|
|
/// <summary>
|
/// 创建一个新的任务
|
/// </summary>
|
/// <param name="model">任务模型</param>
|
/// <returns>创建的任务</returns>
|
public async Task<Dt_Task> Create(Dt_Task model)
|
{
|
return await BaseDal.Create(model);
|
}
|
|
/// <summary>
|
/// 批量创建任务
|
/// </summary>
|
/// <param name="models">任务模型列表</param>
|
/// <returns>是否创建成功</returns>
|
public async Task<bool> Create(List<Dt_Task> models)
|
{
|
return await BaseDal.Create(models);
|
}
|
|
/// <summary>
|
/// 删除一个任务
|
/// </summary>
|
/// <param name="id">任务ID</param>
|
/// <returns>是否删除成功</returns>
|
public async Task<bool> Delete(int id)
|
{
|
return await BaseDal.Delete(id);
|
}
|
|
/// <summary>
|
/// 批量删除任务
|
/// </summary>
|
/// <param name="ids">任务ID列表</param>
|
/// <returns>是否删除成功</returns>
|
public async Task<bool> Delete(List<int> ids)
|
{
|
return await BaseDal.Delete(ids);
|
}
|
|
/// <summary>
|
/// 通过ID获取任务
|
/// </summary>
|
/// <param name="id">任务ID</param>
|
/// <returns>任务模型</returns>
|
public async Task<Dt_Task> GetById(int id)
|
{
|
return await BaseDal.GetById(id);
|
}
|
|
/// <summary>
|
/// 获取所有任务列表
|
/// </summary>
|
/// <returns>任务模型列表</returns>
|
public async Task<List<Dt_Task>> GetList()
|
{
|
return await BaseDal.GetList();
|
}
|
|
/// <summary>
|
/// 根据出库订单ID获取任务列表
|
/// </summary>
|
/// <param name="outOrderId">出库订单ID</param>
|
/// <returns>任务模型列表</returns>
|
public async Task<List<Dt_Task>> GetListByOutOrder(int outOrderId)
|
{
|
return await BaseDal.GetListByOutOrder(outOrderId);
|
}
|
|
/// <summary>
|
/// 根据出库订单ID和状态获取任务列表
|
/// </summary>
|
/// <param name="outOrderId">出库订单ID</param>
|
/// <param name="status">任务状态</param>
|
/// <returns>任务模型列表</returns>
|
public async Task<List<Dt_Task>> GetListByOutOrderAndStatus(int outOrderId, int status)
|
{
|
return await BaseDal.GetListByOutOrderAndStatus(outOrderId, status);
|
}
|
|
/// <summary>
|
/// 根据状态获取任务列表
|
/// </summary>
|
/// <param name="status">任务状态</param>
|
/// <returns>任务模型列表</returns>
|
public async Task<List<Dt_Task>> GetListByStatus(int status)
|
{
|
return await BaseDal.GetListByStatus(status);
|
}
|
|
/// <summary>
|
/// 更新一个任务
|
/// </summary>
|
/// <param name="model">任务模型</param>
|
/// <returns>是否更新成功</returns>
|
public async Task<bool> Update(Dt_Task model)
|
{
|
return await BaseDal.Update(model);
|
}
|
|
/// <summary>
|
/// 批量更新任务
|
/// </summary>
|
/// <param name="models">任务模型列表</param>
|
/// <returns>是否更新成功</returns>
|
public async Task<bool> Update(List<Dt_Task> models)
|
{
|
return await BaseDal.Update(models);
|
}
|
|
/// <summary>
|
/// 检查任务是否存在
|
/// </summary>
|
/// <param name="palletCode">托盘编码</param>
|
/// <returns>任务是否存在</returns>
|
public bool IsExist(string palletCode)
|
{
|
return Db.Queryable<Dt_Task>().Any(x => x.PalletCode == palletCode);
|
}
|
|
/// <summary>
|
/// 根据货位ID获取任务
|
/// </summary>
|
/// <param name="locationID"></param>
|
/// <returns></returns>
|
public async Task<Dt_Task> GetByLocation(string locationID)
|
{
|
return await Db.Queryable<Dt_Task>().Where(x => x.SourceAddress == locationID).FirstAsync();
|
}
|
|
/// <summary>
|
/// 根据任务号获取任务
|
/// </summary>
|
/// <param name="taskNum"></param>
|
/// <returns></returns>
|
public async Task<Dt_Task> GetByTaskNum(int taskNum)
|
{
|
return await Db.Queryable<Dt_Task>().Where(x => x.TaskNum == taskNum).FirstAsync();
|
}
|
|
#endregion 内部调用方法
|
|
#region private 内部方法
|
|
/// <summary>
|
/// 更新出库订单和库存信息
|
/// </summary>
|
/// <param name="stock">库存实例</param>
|
/// <param name="barCode">条码</param>
|
/// <returns>更新后的订单和库存信息</returns>
|
private async Task<Dt_OutOrderAndStock> UpdateOrderAndStockAsync(Dt_BillGroupStock stock, string barCode)
|
{
|
var orderStock = await _outOrderAndStockRepository.GetOrderAndStock(palletCode: barCode);
|
|
orderStock.CompletedQuantity += stock.Dt_BillGroupStockDetailList.Sum(x => x.PalletQuantity).Value;
|
|
orderStock.OrderList.OrderDetailList.CompletedQuantity += stock.Dt_BillGroupStockDetailList.Sum(x => x.PalletQuantity).Value;
|
|
return orderStock;
|
}
|
|
/// <summary>
|
/// 判断订单是否完成
|
/// </summary>
|
/// <param name="orderStock">订单和库存信息</param>
|
/// <returns>是否完成</returns>
|
private bool IsOrderComplete(Dt_OutOrderAndStock orderStock)
|
{
|
return orderStock.CompletedQuantity == orderStock.OutboundQuantity;
|
}
|
|
/// <summary>
|
/// 处理已完成的订单
|
/// </summary>
|
/// <param name="orderStock">订单和库存信息</param>
|
/// <param name="task">任务数据</param>
|
/// <returns>异步任务</returns>
|
private async Task ProcessCompletedOrderAsync(Dt_OutOrderAndStock orderStock, Dt_Task task)
|
{
|
// 创建历史订单记录
|
var stockHty = CreateHistoricalOrder(orderStock);
|
LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成,订单已完成", $"创建历史订单记录：{JsonConvert.SerializeObject(stockHty)}");
|
|
// 创建获取历史任务
|
var taskHty = CreateHistoricalTask(task);
|
LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成,订单已完成", $"创建历史任务记录：{JsonConvert.SerializeObject(taskHty)}");
|
|
_unitOfWorkManage.BeginTran();
|
|
try
|
{
|
// 添加历史任务
|
var isTaskHtyAdd = await _task_HtyRepository.AddDataAsync(taskHty) > 0;
|
|
// 删除任务数据
|
var isTaskDelete = await Delete(task.TaskId);
|
|
// 插入历史订单
|
var isStockInsert = _outOrderAndStock_HtyRepository.InsertNav(stockHty);
|
|
// 删除原订单
|
var isOrderStockDelete = _outOrderAndStockRepository.DeleteNavOrderStock(orderStock);
|
|
if (isStockInsert && isOrderStockDelete && isTaskHtyAdd && isTaskDelete)
|
{
|
LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成,订单已完成", $"事务处理完成,提交事务。添加历史任务：{isTaskHtyAdd},删除任务数据：{isTaskDelete},插入历史订单：{isStockInsert},删除原订单:{isOrderStockDelete}");
|
_unitOfWorkManage.CommitTran();
|
}
|
else
|
{
|
LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成,订单已完成", $"添加数据库失败,请检查数据是否正确,数据回滚。添加历史任务：{isTaskHtyAdd},删除任务数据：{isTaskDelete},插入历史订单：{isStockInsert},删除原订单:{isOrderStockDelete}");
|
_unitOfWorkManage.RollbackTran();
|
}
|
}
|
catch (Exception ex)
|
{
|
LogFactory.GetLog("任务完成").InfoFormat(true, $"总任务出库完成,订单已完成,系统异常，异常信息：{ex.Message}", "无参数");
|
_unitOfWorkManage.RollbackTran();
|
throw; // 重新抛出异常以供外部捕获
|
}
|
}
|
|
/// <summary>
|
/// 处理未完成订单
|
/// </summary>
|
/// <param name="orderStock">订单和库存信息</param>
|
/// <param name="task">任务数据</param>
|
/// <returns>异步任务</returns>
|
private async Task ProcessUpdateOrderAsync(Dt_OutOrderAndStock orderStock, Dt_Task task)
|
{
|
// 创建获取历史任务
|
var taskHty = CreateHistoricalTask(task);
|
|
_unitOfWorkManage.BeginTran();
|
try
|
{
|
// 添加历史任务
|
var isTaskHtyAdd = await _task_HtyRepository.AddDataAsync(taskHty) > 0;
|
|
// 删除任务数据
|
var isTaskDelete = await Delete(task.TaskId);
|
|
// 更新订单与库存
|
var isOrderUpdated = _outOrderAndStockRepository.UpdateNavOrderStock(orderStock);
|
if (isTaskDelete && isTaskHtyAdd && isOrderUpdated)
|
{
|
LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成,订单暂未完成", $"事务处理完成,提交事务。添加历史任务：{isTaskHtyAdd},删除任务数据：{isTaskDelete},更新订单与库存：{isOrderUpdated}");
|
_unitOfWorkManage.CommitTran();
|
}
|
else
|
{
|
LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成,订单暂未完成", $"添加数据库失败,请检查数据是否正确,数据回滚。添加历史任务：{isTaskHtyAdd},删除任务数据：{isTaskDelete},更新订单与库存：{isOrderUpdated}");
|
_unitOfWorkManage.RollbackTran();
|
}
|
}
|
catch (Exception err)
|
{
|
LogFactory.GetLog("任务完成").InfoFormat(true, $"总任务出库完成,订单暂未完成,系统异常，异常信息：{err.Message}", "无参数");
|
Console.WriteLine(err.Message.ToString());
|
_unitOfWorkManage.RollbackTran();
|
throw; // 重新抛出异常以供外部捕获
|
}
|
}
|
|
/// <summary>
|
/// 创建历史订单记录
|
/// </summary>
|
/// <param name="orderStock">订单和库存信息</param>
|
/// <returns>历史订单记录</returns>
|
private Dt_OutOrderAndStock_Hty CreateHistoricalOrder(Dt_OutOrderAndStock orderStock)
|
{
|
var stockHty = _mapper.Map<Dt_OutOrderAndStock_Hty>(orderStock);
|
|
stockHty.StockList.FinishTime = DateTime.Now;
|
stockHty.StockList.OperateType = (int)OperateTypeEnum.自动完成;
|
stockHty.StockList.SourceId = orderStock.StockList.GroupId;
|
stockHty.StockList.GroupId = 0;
|
|
stockHty.StockList.StockDetailList.ForEach(x =>
|
{
|
x.FinishTime = DateTime.Now;
|
x.OperateType = (int)OperateTypeEnum.自动完成;
|
x.GroupId = 0;
|
});
|
|
stockHty.OrderList.FinishTime = DateTime.Now;
|
stockHty.OrderList.OperateType = (int)OperateTypeEnum.自动完成;
|
stockHty.OrderList.SourceId = orderStock.OrderList.Id;
|
stockHty.OrderList.Id = 0;
|
|
stockHty.OrderList.orderDetailList.FinishTime = DateTime.Now;
|
stockHty.OrderList.orderDetailList.OperateType = (int)OperateTypeEnum.自动完成;
|
stockHty.OrderList.orderDetailList.Id = 0;
|
|
return stockHty;
|
}
|
|
private Dt_Task_Hty CreateHistoricalTask(Dt_Task task)
|
{
|
// 更新任务状态
|
task.TaskState = OutTaskStatusEnum.OutFinish.ObjToInt();
|
task.CurrentAddress = task.NextAddress;
|
|
// 创建历史任务
|
var taskHty = _mapper.Map<Dt_Task_Hty>(task);
|
taskHty.FinishTime = DateTime.Now;
|
taskHty.TaskId = 0;
|
taskHty.OperateType = (int)OperateTypeEnum.自动完成;
|
taskHty.SourceId = task.TaskId;
|
taskHty.TaskState = OutTaskStatusEnum.OutFinish.ObjToInt();
|
return taskHty;
|
}
|
|
/// <summary>
|
/// 更新库存位置
|
/// </summary>
|
/// <param name="stock">库存对象</param>
|
/// <param name="toLocation">目标位置</param>
|
private (Dt_BillGroupStock, Dt_LocationInfo) UpdateStockLocation(Dt_BillGroupStock stock, string toLocation)
|
{
|
var locationInfo = _locationRepository.QueryFirst(x => x.LocationCode == stock.LocationCode);
|
locationInfo.Status = LocationEnum.InStock.ObjToInt();
|
|
stock.LocationCode = toLocation;
|
stock.LocationInfo.Status = LocationEnum.InStock.ObjToInt();
|
|
return (stock, locationInfo);
|
}
|
|
/// <summary>
|
/// 执行数据库事务
|
/// </summary>
|
/// <param name="stock">库存对象</param>
|
/// <param name="taskHty">历史任务对象</param>
|
/// <param name="taskId">任务ID</param>
|
/// <returns></returns>
|
private async Task<bool> ExecuteTransaction(Dt_BillGroupStock stock, Dt_Task_Hty taskHty, Dt_LocationInfo locationInfo, int taskId)
|
{
|
_unitOfWorkManage.BeginTran();
|
try
|
{
|
// 更新库存
|
var isUpdateStock = _billGroupStockRepository.UpdateNavStock(stock);
|
|
// 添加历史任务
|
var isTaskHtyAdd = await _task_HtyRepository.AddDataAsync(taskHty) > 0;
|
|
// 修改移库前货位状态
|
var isUpdateLoc = _locationRepository.UpdateData(locationInfo);
|
|
// 删除任务数据
|
var isTaskDelete = await Delete(taskId);
|
|
// 提交或回滚事务
|
if (isUpdateStock && isTaskHtyAdd && isTaskDelete && isUpdateLoc)
|
{
|
LogFactory.GetLog("任务完成").InfoFormat(true, "移库任务完成", $"事务处理完成,提交事务。添加历史任务：{isTaskHtyAdd},删除任务数据：{isTaskDelete},更新库存：{isUpdateStock},修改移库前货位状态：{isUpdateLoc}");
|
_unitOfWorkManage.CommitTran();
|
return true;
|
}
|
else
|
{
|
LogFactory.GetLog("任务完成").InfoFormat(true, "移库任务完成", $"数据处理失败,请检查数据是否正确,数据回滚。添加历史任务：{isTaskHtyAdd},删除任务数据：{isTaskDelete},更新库存：{isUpdateStock},修改移库前货位状态：{isUpdateLoc}");
|
_unitOfWorkManage.RollbackTran();
|
return false;
|
}
|
}
|
catch (Exception err)
|
{
|
LogFactory.GetLog("任务完成").InfoFormat(true, $"移库任务完成,系统异常，异常信息：{err.Message}", "无参数");
|
_unitOfWorkManage.RollbackTran();
|
throw; // 抛出异常以便外部捕获
|
}
|
}
|
|
|
|
#endregion private 内部方法
|
}
|
