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 Newtonsoft.Json;
using WIDESEA_DTO.WCSInfo;
using WIDESEAWCS_DTO.WCSInfo;
using Microsoft.AspNetCore.DataProtection.KeyManagement;
using WIDESEA_Common.TaskEnum;
using System.Collections;
namespace WIDESEA_TaskInfoService
{
public partial class TaskService
{
///
/// 库存数据转出库任务
///
///
///
public List GetTasks(List stockInfos)
{
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);
Dt_RoadwayInfo roadwayInfo = _basicService.RoadwayInfoService.Repository.QueryFirst(x => x.RoadwayNo == locationInfo.RoadwayNo);
if (roadwayInfo != null)
{
Dt_Task task = new()
{
CurrentAddress = stockInfo.LocationCode,
Grade = 0,
PalletCode = stockInfo.PalletCode,
NextAddress = roadwayInfo.OutSCStationCode,
Roadway = locationInfo.RoadwayNo,
SourceAddress = stockInfo.LocationCode,
TargetAddress = roadwayInfo.OutStationCode,
TaskState = OutTaskStatusEnum.OutNew.ObjToInt(),
TaskType = TaskTypeEnum.Outbound.ObjToInt(),
TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum))
//TaskNum = Convert.ToInt32(DateTime.Now.ToString("HHmmss")),
};
tasks.Add(task);
}
}
}
return tasks;
}
///
/// 出库任务数据处理
///
///
///
///
///
public (List?, List?, List?, List?, List?, List?, Dt_OutboundOrder?) OutboundTaskDataHandle(int[] keys)
{
List tasks = new List();
List outboundOrderDetails = _outboundService.OutboundOrderDetailService.Repository.QueryData(x => keys.Contains(x.Id));
if (outboundOrderDetails == null || outboundOrderDetails.Count == 0)
{
throw new Exception("未找到出库单明细信息");
}
if (outboundOrderDetails.FirstOrDefault(x => x.OrderDetailStatus > OrderDetailStatusEnum.New.ObjToInt()) != null)
{
throw new Exception("所选出库单明细存在出库中或已完成");
}
List? stockInfos = new List();
List? orderDetails = null;
List? outStockLockInfos = null;
List? locationInfos = null;
List? locationInfos1 = null;
Dt_OutboundOrder? outboundOrder = null;
(List?, List?, List?, List?, Dt_OutboundOrder?) result = _outboundService.OutboundOrderDetailService.AssignStockOutbound(outboundOrderDetails);
if (result.Item1 != null && result.Item1.Count > 0)
{
(List?, List?, List?) result1 = GetTasks(result.Item1, TaskTypeEnum.Outbound, result.Item4);
tasks = result1.Item1;
locationInfos1 = result1.Item2;
stockInfos.AddRange(result1.Item3);
stockInfos.AddRange(result.Item1);
orderDetails = result.Item2;
outStockLockInfos = result.Item3;
locationInfos = result.Item4;
outboundOrder = result.Item5;
}
else
{
throw new Exception("无库存");
}
return (tasks, stockInfos, orderDetails, outStockLockInfos, locationInfos, locationInfos1, outboundOrder);
}
///
/// 库存数据转出库任务
///
///
///
public (List?, List?, List?) GetTasks(List stockInfos, TaskTypeEnum taskType, List? locationInfos)
{
List tasks = new List();
List locations = new List();
List stocks = new List();
foreach (var item in stockInfos.GroupBy(x => x.LocationCode))
{
Dt_LocationInfo locationInfo = locationInfos.First(x => x.LocationCode == item.Key);
(List?, List?, List?) result = GetRelocationTask(locationInfo);
tasks.AddRange(result.Item1);//移库任务
locations.AddRange(result.Item2);//移库货位
stocks.AddRange(result.Item3);//移库库存
foreach (var stockInfo in item.OrderByDescending(x => x.SerialNumber))
{
if (!tasks.Exists(x => x.PalletCode == stockInfo.PalletCode))
{
Dt_Task task = new()
{
CurrentAddress = stockInfo.LocationCode,
Grade = 0,
PalletCode = stockInfo.PalletCode,
TargetIsPickPlace = false,
SourceIsPickPlace = locationInfo.Row == 1 ? false : stockInfo.SerialNumber == locationInfo.MaxQty,
NextAddress = "1008",
Roadway = locationInfo.RoadwayNo,
SourceAddress = stockInfo.LocationCode,
TargetAddress = "1008",
TaskState = TaskOutStatusEnum.OutNew.ObjToInt(),
TaskType = taskType.ObjToInt(),
TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum))
};
tasks.Add(task);
}
}
}
return (tasks, locations, stocks);
}
///
/// 获取移库任务
///
///
///
///
public (List?, List?, List?) GetRelocationTask(Dt_LocationInfo locationInfo)
{
List dt_Tasks = new List();
List locationInfos = new List();
List stockInfos = new List();
if (locationInfo.Row == 1)
{
var locationInfo1 = _basicService.LocationInfoService.Repository.QueryFirst(x => x.Row == 2 && x.Column == locationInfo.Column && x.Layer == locationInfo.Layer);
stockInfos = _stockService.StockInfoService.Repository.QueryData(x => locationInfo1.LocationCode == x.LocationCode).OrderByDescending(x => x.SerialNumber).ToList();
if (stockInfos == null || stockInfos.Count < 1)
{
return (dt_Tasks, locationInfos, stockInfos);
}
Dt_LocationInfo? locationInfo2 = _basicService.LocationInfoService.AssignLocation();
if (locationInfo2 == null) throw new Exception("无可移库货位");
locationInfo1.LocationStatus = LocationStatusEnum.Relocationing.ObjToInt();
locationInfo2.LocationStatus = LocationStatusEnum.Relocationing.ObjToInt();
locationInfos.Add(locationInfo1);
locationInfos.Add(locationInfo2);
int i = 1;
foreach (var item in stockInfos)
{
Dt_Task task = new()
{
CurrentAddress = item.LocationCode,
SourceIsPickPlace = item.SerialNumber == 12,
TargetIsPickPlace = i == 12 ? locationInfo2.Row != 1 : false,
Grade = 0,
PalletCode = item.PalletCode,
NextAddress = locationInfo2.LocationCode,
Roadway = locationInfo.RoadwayNo,
SourceAddress = item.LocationCode,
TargetAddress = locationInfo2.LocationCode,
TaskState = WIDESEA_Common.TaskEnum.TaskRelocationStatusEnum.RelocationNew.ObjToInt(),
TaskType = TaskRelocationTypeEnum.Relocation.ObjToInt(),
TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum))
};
if (locationInfo2.Row == 1) task.TargetIsPickPlace = false;
dt_Tasks.Add(task);
i++;
item.StockStatus = StockStatusEmun.移库中.ObjToInt();
}
}
return (dt_Tasks, locationInfos, stockInfos);
}
///
/// 出库任务数据处理/指定出库单出库
///
///
///
///
///
public (List, List?, List?, List?, List?) OutboundTaskDataHandle(int orderDetailId, List stockSelectViews)
{
List tasks = new List();
Dt_OutboundOrderDetail outboundOrderDetail = _outboundService.OutboundOrderDetailService.Repository.QueryFirst(x => x.Id == orderDetailId);
if (outboundOrderDetail == null) throw new Exception("未找到出库单明细信息");
if (outboundOrderDetail.OrderDetailStatus != OrderDetailStatusEnum.New.ObjToInt())
throw new Exception("所选出库单明细存在出库中或已完成");
Dt_OutboundOrder outboundOrder = _outboundService.OutboundOrderService.Repository.QueryFirst(x => x.Id == outboundOrderDetail.OrderId);
outboundOrder.Details = new List { outboundOrderDetail };
List? stockInfos = null;
Dt_OutboundOrderDetail? orderDetail = null;
List? outStockLockInfos = null;
List? locationInfos = null;
List? locationInfos1 = null;
(List, List, List) result = _outboundService.OutboundOrderDetailService.AssignStockOutbound(outboundOrder, stockSelectViews);
if (result.Item1 != null && result.Item1.Count > 0)
{
}
else
{
throw new Exception("无库存");
}
return (tasks, stockInfos, orderDetail == null ? null : new List { orderDetail }, outStockLockInfos, locationInfos);
}
///
/// 生成出库任务
///
///
///
///
public WebResponseContent GenerateOutboundTask(int orderDetailId, List stockSelectViews)
{
try
{
(List, List?, List?, List?, List?) result = OutboundTaskDataHandle(orderDetailId, stockSelectViews);
WebResponseContent content = GenerateOutboundTaskDataUpdate(result.Item1, result.Item2, result.Item3, result.Item4, result.Item5);
return content;
}
catch (Exception ex)
{
return WebResponseContent.Instance.Error(ex.Message);
}
}
public WebResponseContent GenerateOutboundTaskDataUpdate(List tasks, List? stockInfos = null, List? outboundOrderDetails = null, List? outStockLockInfos = null, List? locationInfos = null, List? locationInfos1 = null, Dt_OutboundOrder? order = null)
{
try
{
_unitOfWorkManage.BeginTran();
BaseDal.AddData(tasks);
if (stockInfos != null && stockInfos.Count > 0 && outboundOrderDetails != null && outboundOrderDetails.Count > 0 && outStockLockInfos != null && outStockLockInfos.Count > 0 && locationInfos != null && locationInfos.Count > 0)
{
List addOutStockLockInfos = outStockLockInfos.Where(x => x.Id == 0).ToList();
if (addOutStockLockInfos != null && addOutStockLockInfos.Any())
{
if (tasks != null)
{
addOutStockLockInfos.ForEach(x =>
{
x.TaskNum = tasks.FirstOrDefault(v => v.PalletCode == x.PalletCode)?.TaskNum;
});
}
_outboundService.OutboundStockLockInfoService.Repository.AddData(addOutStockLockInfos);
}
List updateOutStockLockInfos = outStockLockInfos.Where(x => x.Id > 0).ToList();
if (updateOutStockLockInfos != null && updateOutStockLockInfos.Any())
{
_outboundService.OutboundStockLockInfoService.Repository.UpdateData(updateOutStockLockInfos);
}
_stockService.StockInfoService.Repository.UpdateData(stockInfos);
_basicRepository.LocationInfoRepository.UpdateData(locationInfos);
_basicRepository.LocationInfoRepository.UpdateData(locationInfos1);
_outboundService.OutboundOrderService.Repository.UpdateData(order);
_outboundService.OutboundOrderDetailService.Repository.UpdateData(outboundOrderDetails);
}
else if (outboundOrderDetails != null && outboundOrderDetails.Count > 0)
{
_outboundService.OutboundOrderDetailService.Repository.UpdateData(outboundOrderDetails);
}
#region 下发任务给WCS
List wMSTaskDTOs = _mapper.Map>(tasks);
var ResultData = HttpHelper.PostAsync(WCSInterfaceAddress.ReceiveTask, wMSTaskDTOs.ToJson(), headers: new Dictionary());
if (ResultData.Result == null) throw new Exception($"向WCS下发出库任务超时");
WebResponseContent content = JsonConvert.DeserializeObject(ResultData.Result);
if (content == null) throw new Exception($"下发出库任务WCS无响应");
if (!content.Status) throw new Exception(content.Message);
#endregion
_unitOfWorkManage.CommitTran();
return WebResponseContent.Instance.OK();
}
catch (Exception ex)
{
_unitOfWorkManage.RollbackTran();
return WebResponseContent.Instance.Error(ex.Message);
}
}
///
/// 生成出库任务后数据更新到数据库
///
///
///
///
///
///
///
public WebResponseContent GenerateOutboundTaskDataUpdate(List tasks, List? stockInfos = null, List? outboundOrderDetails = null, List? outStockLockInfos = null, List? locationInfos = null)
{
try
{
_unitOfWorkManage.BeginTran();
#region 生成移库任务
List taskList = new List();
List dt_StockInfos = _stockService.StockInfoService.Repository.LocationCodesGetStockInfos(tasks.Select(x => x.SourceAddress).ToList());
List dt_stockInfos = dt_StockInfos.Where(x => x.StockStatus == StockStatusEmun.出库锁定.ObjToInt() || tasks.Select(x => x.PalletCode).ToList().Contains(x.PalletCode)).ToList();//待出库库存
dt_StockInfos = dt_StockInfos.Where(x => !dt_stockInfos.Select(x => x.Id).ToList().Contains(x.Id)).ToList();//排除待出库库存
if (dt_StockInfos.Count > 0)
{
foreach (var dt_stockInfo in dt_stockInfos)
{
foreach (var dt_StockInfo in dt_StockInfos.Where(x => x.LocationCode == dt_stockInfo.LocationCode))
{
if (dt_StockInfo.InDate > dt_stockInfo.InDate)
{
dt_StockInfo.StockStatus = StockStatusEmun.移库中.ObjToInt();
dt_stockInfo.Details.ForEach(x =>
{
x.Status = StockStatusEmun.移库中.ObjToInt();
});
}
}
}
List stockInfoDetails = dt_StockInfos.Where(x => x.StockStatus == StockStatusEmun.移库中.ObjToInt()).Select(x => x.Details).ToList().OfType().ToList();//待移库详情
foreach (var stockInfoDetail in stockInfoDetails.GroupBy(x => x.MaterielCode))
{
foreach (var item in stockInfoDetail.GroupBy(x => x.BatchNo))
{
var locationInfo = _basicService.LocationInfoService.AssignLocation(item.Count());//重新分配货位
var stockInfo = dt_StockInfos.Where(x => x.Id == item.First().StockId).First();
foreach (var infoDetail in item)
{
Dt_Task task = new Dt_Task()
{
CurrentAddress = stockInfo.LocationCode,
Grade = 2,
PalletCode = stockInfo.PalletCode,
NextAddress = locationInfo.LocationCode,
Roadway = locationInfo.RoadwayNo,
SourceAddress = stockInfo.LocationCode,
TargetAddress = locationInfo.LocationCode,
TaskState = WIDESEA_Common.TaskEnum.TaskRelocationStatusEnum.RelocationNew.ObjToInt(),
TaskType = TaskTypeEnum.Relocation.ObjToInt(),
TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)),
};
taskList.Add(task);
}
stockInfo.LocationCode = locationInfo.LocationCode;
}
}
}
tasks.AddRange(taskList);
#endregion
BaseDal.AddData(tasks);
#region 下发任务给WCS
List wMSTaskDTOs = _mapper.Map>(tasks);
var ResultData = HttpHelper.PostAsync(WCSInterfaceAddress.ReceiveTask, wMSTaskDTOs.ToJson(), headers: new Dictionary());
if (ResultData.Result == null) throw new Exception($"向WCS下发出库任务超时");
WebResponseContent content = JsonConvert.DeserializeObject(ResultData.Result);
if (content == null) throw new Exception($"下发出库任务WCS无响应");
if (!content.Status) throw new Exception(content.Message);
#endregion
if (stockInfos != null && outboundOrderDetails != null && outStockLockInfos != null && locationInfos != null)
{
content = _outboundService.OutboundOrderDetailService.LockOutboundStockDataUpdate(stockInfos, outboundOrderDetails, outStockLockInfos, locationInfos, tasks: tasks);
if (content.Status)
{
_unitOfWorkManage.CommitTran();
}
else
{
_unitOfWorkManage.RollbackTran();
}
return content;
}
else if (outboundOrderDetails != null && outboundOrderDetails.Count > 0)
{
outboundOrderDetails.ForEach(x =>
{
x.OrderDetailStatus = OrderDetailStatusEnum.Outbound.ObjToInt();
});
_outboundService.OutboundOrderDetailService.Repository.UpdateData(outboundOrderDetails);
}
_unitOfWorkManage.CommitTran();
return WebResponseContent.Instance.OK();
}
catch (Exception ex)
{
_unitOfWorkManage.RollbackTran();
return WebResponseContent.Instance.Error(ex.Message);
}
}
///
/// 生成出库任务
///
///
///
public WebResponseContent GenerateOutboundTask(int[] keys)
{
try
{
List tasks = new List();
List stockSelectViews = new List();
List stockInfos = new List();
List outboundOrderDetails = new List();
List outStockLockInfos = new List();
List locationInfos = new List();
List locationInfos1 = new List();
Dt_OutboundOrder order = new Dt_OutboundOrder();
#region 出库任务数据处理
(List?, List?, List?, List?, List?, List?, Dt_OutboundOrder?) result = OutboundTaskDataHandle(keys);
if (result.Item1 != null && result.Item1.Count > 0)
{
tasks.AddRange(result.Item1);
}
if (result.Item2 != null && result.Item2.Count > 0)
{
stockInfos.AddRange(result.Item2);
}
if (result.Item3 != null && result.Item3.Count > 0)
{
outboundOrderDetails.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.Item6 != null && result.Item6.Count > 0)
{
locationInfos1.AddRange(result.Item6);
}
if (result.Item7 != null)
{
order = result.Item7;
}
#endregion
//WebResponseContent content = GenerateOutboundTaskDataUpdate(tasks, stockInfos, outboundOrderDetails, outStockLockInfos, locationInfos);
WebResponseContent content = GenerateOutboundTaskDataUpdate(tasks, stockInfos, outboundOrderDetails, outStockLockInfos, locationInfos, locationInfos1, order);
return content;
}
catch (Exception ex)
{
_unitOfWorkManage.RollbackTran();
return WebResponseContent.Instance.Error(ex.Message);
}
}
///
/// 空托盘出库任务
///
///
///
public WebResponseContent PalletOutboundTask(string roadwayNo, string endStation)
{
try
{
Dt_StockInfo stockInfo = _stockService.StockInfoService.Repository.GetPalletStockInfo(roadwayNo);
if (stockInfo == null)
{
return WebResponseContent.Instance.Error("未找到空托盘库存");
}
Dt_LocationInfo locationInfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == stockInfo.LocationCode && x.RoadwayNo == roadwayNo);
if (locationInfo == null)
{
return WebResponseContent.Instance.Error("未找到空托盘库存对应的货位信息");
}
Dt_RoadwayInfo roadwayInfo = _basicService.RoadwayInfoService.Repository.QueryFirst(x => x.InStationCode == endStation && x.RoadwayNo == roadwayNo);
if (roadwayInfo == null)
{
return WebResponseContent.Instance.Error("未找到终点巷道信息");
}
Dt_Task task = new Dt_Task()
{
CurrentAddress = stockInfo.LocationCode,
Grade = 0,
NextAddress = endStation,
PalletCode = stockInfo.PalletCode,
Roadway = roadwayNo,
SourceAddress = stockInfo.LocationCode,
TargetAddress = endStation,
TaskState = OutTaskStatusEnum.OutNew.ObjToInt(),
TaskType = TaskTypeEnum.PalletOutbound.ObjToInt(),
};
_unitOfWorkManage.BeginTran();
stockInfo.StockStatus = StockStatusEmun.出库锁定.ObjToInt();
locationInfo.LocationStatus = LocationStatusEnum.OutLock.ObjToInt();
BaseDal.AddData(task);
_unitOfWorkManage.CommitTran();
return WebResponseContent.Instance.OK();
}
catch (Exception ex)
{
return WebResponseContent.Instance.Error(ex.Message);
}
}
}
}