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 Microsoft.AspNetCore.Http;
|
using System.Reflection.Metadata;
|
using OfficeOpenXml.FormulaParsing.Excel.Functions.RefAndLookup;
|
using System.Diagnostics;
|
using Newtonsoft.Json;
|
using System.Security.Policy;
|
using static WIDESEA_ITaskInfoService.ITaskService;
|
using MailKit.Search;
|
using WIDESEA_Common.Log;
|
using OfficeOpenXml.FormulaParsing.Excel.Functions.DateTime;
|
using WIDESEA_Common;
|
using WIDESEA_DTO.Outbound;
|
using WIDESEA_Core.Utilities;
|
using System.Transactions;
|
using Microsoft.Data.SqlClient;
|
using WIDESEA_Model.Models.Outbound;
|
using WIDESEA_Common.OrderEnum;
|
using WIDESEA_Core.CodeConfigEnum;
|
|
namespace WIDESEA_TaskInfoService
|
{
|
public partial class TaskService
|
{
|
public string ReceiveTask = WIDESEA_Core.Helper.AppSettings.Configuration["ReceiveTask"];
|
/// <summary>
|
/// 库存数据转出库任务
|
/// </summary>
|
/// <param name="stockInfos"></param>
|
/// <returns></returns>
|
public List<Dt_Task> GetTasks(List<Dt_StockInfo> stockInfos, TaskTypeEnum taskType)
|
{
|
List<Dt_Task> tasks = new List<Dt_Task>();
|
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_Task dt_Task = BaseDal.QueryFirst(x => x.SourceAddress == locationInfo.LocationCode || x.TargetAddress == locationInfo.LocationCode);
|
if (dt_Task != null)
|
{
|
throw new Exception("该货位已存在起点任务或终点任务");
|
}
|
Dt_Task dt_Task1 = BaseDal.QueryFirst(x => x.PalletCode == stockInfo.PalletCode);
|
if (dt_Task1 != null)
|
{
|
throw new Exception("该托盘已存在任务");
|
}
|
Dt_RoadwayInfo roadwayInfo = _basicService.RoadwayInfoService.Repository.QueryFirst(x => x.RoadwayNo == locationInfo.RoadwayNo);
|
Dt_StockInfoDetail stockInfoDetail = _stockService.StockInfoDetailService.Repository.QueryFirst(x => x.StockId == stockInfo.Id);
|
if (roadwayInfo != null)
|
{
|
Dt_Task task = new()
|
{
|
PalletType = stockInfo.PalletType,
|
OrderNo = stockInfoDetail.OrderNo,
|
CurrentAddress = locationInfo.LocationCode,
|
Grade = 0,
|
Creater = "WMS",
|
PalletCode = stockInfo.PalletCode,
|
NextAddress = roadwayInfo.OutSCStationCode,
|
Roadway = locationInfo.RoadwayNo,
|
SourceAddress = locationInfo.LocationCode,
|
TargetAddress = "",
|
TaskStatus = OutTaskStatusEnum.OutNew.ObjToInt(),
|
TaskType = taskType.ObjToInt(),
|
Depth = locationInfo.Depth,
|
WarehouseId = stockInfo.WarehouseId,
|
TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum))
|
};
|
if (taskType != TaskTypeEnum.OutEmpty)
|
{
|
task.MaterielCode = stockInfo.Details?.Where(x => x.StockId == stockInfo.Id).FirstOrDefault()?.MaterielCode;
|
task.Quantity = (float)stockInfo.Details?.Where(x => x.StockId == stockInfo.Id).Sum(x => x.StockQuantity);
|
}
|
tasks.Add(task);
|
}
|
}
|
|
}
|
return tasks;
|
}
|
|
|
|
/// <summary>
|
/// 出库任务数据处理
|
/// </summary>
|
/// <param name="orderDetailId"></param>
|
/// <param name="stockSelectViews"></param>
|
/// <returns></returns>
|
/// <exception cref="Exception"></exception>
|
public (List<Dt_Task>, List<Dt_StockInfo>?, List<Dt_OutboundOrderDetail>?, List<Dt_OutStockLockInfo>?, List<Dt_LocationInfo>?) OutboundTaskDataHandle(int[] keys)
|
{
|
List<Dt_Task> tasks = new List<Dt_Task>();
|
List<Dt_OutboundOrderDetail> 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() && x.OrderDetailStatus != OrderDetailStatusEnum.AssignOverPartial.ObjToInt()) != null)
|
{
|
throw new Exception("所选出库单明细存在出库中或已完成");
|
}
|
List<Dt_StockInfo>? stockInfos = null;
|
List<Dt_OutboundOrderDetail>? orderDetails = null;
|
List<Dt_OutStockLockInfo>? outStockLockInfos = null;
|
List<Dt_LocationInfo>? locationInfos = null;
|
//if (outboundOrderDetail.OrderDetailStatus == OrderDetailStatusEnum.New.ObjToInt())
|
{
|
(List<Dt_StockInfo>, List<Dt_OutboundOrderDetail>, List<Dt_OutStockLockInfo>, List<Dt_LocationInfo>) result = _outboundService.OutboundOrderDetailService.AssignStockOutbound(outboundOrderDetails);
|
if (result.Item1 != null && result.Item1.Count > 0)
|
{
|
Dt_OutboundOrder outboundOrder = _outboundService.OutboundOrderService.Repository.QueryFirst(x => x.Id == outboundOrderDetails.FirstOrDefault().OrderId);
|
TaskTypeEnum typeEnum = outboundOrder.OrderType switch
|
{
|
(int)OrderTypeEnum.生产出库单 => TaskTypeEnum.Outbound,
|
(int)OrderTypeEnum.调拨出库单 => TaskTypeEnum.OutAllocate,
|
(int)OrderTypeEnum.反拣出库单 => TaskTypeEnum.ReverseOut,
|
_ => new TaskTypeEnum()
|
};
|
tasks = GetTasks(result.Item1,typeEnum);
|
tasks.ForEach(x =>
|
{
|
x.OrderNo = outboundOrder.OrderNo;
|
});
|
result.Item2.ForEach(x =>
|
{
|
x.OrderDetailStatus = OrderDetailStatusEnum.Outbound.ObjToInt();
|
});
|
result.Item3.ForEach(x =>
|
{
|
|
x.Status = OutStockStatus.出库中.ObjToInt();
|
});
|
|
stockInfos = result.Item1;
|
orderDetails = result.Item2;
|
outStockLockInfos = result.Item3;
|
locationInfos = result.Item4;
|
}
|
else
|
{
|
throw new Exception("无库存");
|
}
|
}
|
//else
|
//{
|
// List<Dt_OutStockLockInfo> stockLockInfos = _outboundService.OutboundStockLockInfoService.GetByOrderDetailId(outboundOrderDetail.OrderId, OutLockStockStatusEnum.已分配);
|
// if (stockLockInfos != null && stockLockInfos.Count > 0)
|
// {
|
// List<Dt_StockInfo> stocks = _stockService.StockInfoService.Repository.GetStockInfosByPalletCodes(stockLockInfos.Select(x => x.PalletCode).Distinct().ToList());
|
// tasks = GetTasks(stocks);
|
// }
|
//}
|
|
return (tasks, stockInfos, orderDetails, outStockLockInfos, locationInfos);
|
}
|
|
|
/// <summary>
|
/// 出库任务数据处理
|
/// </summary>
|
/// <param name="orderDetailId"></param>
|
/// <param name="stockSelectViews"></param>
|
/// <returns></returns>
|
/// <exception cref="Exception"></exception>
|
public (List<Dt_Task>, List<Dt_StockInfo>?, List<Dt_OutboundOrderDetail>?, List<Dt_OutStockLockInfo>?, List<Dt_LocationInfo>?) OutboundTaskDataHandle(int orderDetailId, List<StockSelectViewDTO> stockSelectViews)
|
{
|
List<Dt_Task> tasks = new List<Dt_Task>();
|
Dt_OutboundOrderDetail outboundOrderDetail = _outboundService.OutboundOrderDetailService.Repository.QueryFirst(x => x.OrderId == orderDetailId);
|
|
if (outboundOrderDetail == null)
|
{
|
throw new Exception("未找到出库单明细信息");
|
}
|
|
if (stockSelectViews.Sum(x => x.UseableQuantity) > outboundOrderDetail.OrderQuantity - outboundOrderDetail.LockQuantity)
|
{
|
throw new Exception("选择数量超出单据数量");
|
}
|
List<Dt_StockInfo>? stockInfos = null;
|
Dt_OutboundOrderDetail? orderDetail = null;
|
List<Dt_OutStockLockInfo>? outStockLockInfos = null;
|
List<Dt_LocationInfo>? locationInfos = null;
|
if (outboundOrderDetail.OrderDetailStatus == OrderDetailStatusEnum.New.ObjToInt())
|
{
|
(List<Dt_StockInfo>, Dt_OutboundOrderDetail, List<Dt_OutStockLockInfo>, List<Dt_LocationInfo>) result = _outboundService.OutboundOrderDetailService.AssignStockOutbound(outboundOrderDetail, stockSelectViews);
|
if (result.Item1 != null && result.Item1.Count > 0)
|
{
|
Dt_OutboundOrder outboundOrder = _outboundService.OutboundOrderService.Repository.QueryFirst(x => x.Id == outboundOrderDetail.OrderId);
|
TaskTypeEnum typeEnum = outboundOrder.OrderType switch
|
{
|
(int)OrderTypeEnum.生产出库单 => TaskTypeEnum.Outbound,
|
(int)OrderTypeEnum.调拨出库单 => TaskTypeEnum.OutAllocate,
|
(int)OrderTypeEnum.反拣回库单 => TaskTypeEnum.ReverseIn,
|
_ => new TaskTypeEnum()
|
};
|
tasks = GetTasks(result.Item1, typeEnum);
|
result.Item2.OrderDetailStatus = OrderDetailStatusEnum.Outbound.ObjToInt();
|
result.Item3.ForEach(x =>
|
{
|
x.Status = OutStockStatus.出库中.ObjToInt();
|
});
|
stockInfos = result.Item1;
|
orderDetail = result.Item2;
|
outStockLockInfos = result.Item3;
|
locationInfos = result.Item4;
|
}
|
else
|
{
|
throw new Exception("无库存");
|
}
|
}
|
else
|
{
|
List<Dt_OutStockLockInfo> stockLockInfos = _outboundService.OutboundStockLockInfoService.GetByOrderDetailId(outboundOrderDetail.OrderId);
|
if (stockLockInfos != null && stockLockInfos.Count > 0)
|
{
|
List<Dt_StockInfo> stocks = _stockService.StockInfoService.Repository.GetStockInfosByPalletCodes(stockLockInfos.Select(x => x.PalletCode).Distinct().ToList());
|
tasks = GetTasks(stocks, TaskTypeEnum.Outbound);
|
}
|
}
|
|
return (tasks, stockInfos, orderDetail == null ? null : new List<Dt_OutboundOrderDetail> { orderDetail }, outStockLockInfos, locationInfos);
|
}
|
|
|
/// <summary>
|
/// 立库出库指令上传，出库任务下发
|
/// </summary>
|
/// <param name="orderAddDTO"></param>
|
/// <returns></returns>
|
public WebResponseContent AddOutboundOrders(Houseounbound orderAddDTO)
|
{
|
WebResponseContent content = new();
|
try
|
{
|
|
Dt_Warehouse warehouse = _basicService.WarehouseService.Repository.QueryFirst(x => x.WarehouseCode == orderAddDTO.OutWareHouse);
|
if (warehouse == null)
|
{
|
return WebResponseContent.Instance.Error($"未找到该仓库信息");
|
}
|
Dt_OutboundOrder oldOuboundOrder = BaseDal.Db.Queryable<Dt_OutboundOrder>().Where(x => x.UpperOrderNo == orderAddDTO.No).Includes(x => x.Details).First();
|
Dt_Production production = new Dt_Production();
|
if (oldOuboundOrder != null)
|
{
|
if (oldOuboundOrder.OutWareHouse != warehouse.WarehouseCode)
|
{
|
return WebResponseContent.Instance.Error($"仓库不一致");
|
}
|
else
|
{
|
OutboundOrderAddDTO orderAddDTO1 = new OutboundOrderAddDTO();
|
orderAddDTO1.Details = orderAddDTO.DetailList.DicToIEnumerable<OutboundOrderDetailAddDTO>();
|
var details = orderAddDTO1.Details.FirstOrDefault();
|
Dt_OutboundOrderDetail outboundOrderDetail = new Dt_OutboundOrderDetail()
|
{
|
LPNNo = details.LPNNo,
|
BatchNo = details.BatchNo,
|
MaterielCode = details.MaterielCode,
|
MaterielName = details.MaterielName,
|
MaterieSpec = details.MaterieSpec,
|
OrderDetailStatus = OrderDetailStatusEnum.New.ObjToInt(),
|
OrderQuantity = details.OrderQuantity,
|
LinId = details.LinId,
|
OrderId = oldOuboundOrder.Id,
|
Creater = "WMS",
|
CreateDate = DateTime.Now,
|
Remark = details.Remark,
|
SupplierBatch = details.SupplierBatch
|
};
|
_outboundOrderDetailRepository.AddData(outboundOrderDetail);
|
foreach (var item in orderAddDTO1.Details)
|
{
|
if (string.IsNullOrWhiteSpace(item.Remark))
|
{
|
continue;
|
}
|
string[] remarkEntries = item.Remark.Split(
|
new[] { ';' },
|
StringSplitOptions.RemoveEmptyEntries
|
);
|
|
foreach (var entry in remarkEntries)
|
{
|
string[] keyValuePairs = entry.Split(
|
new[] { ',' },
|
StringSplitOptions.RemoveEmptyEntries
|
);
|
|
foreach (var kvp in keyValuePairs)
|
{
|
int colonIndex = kvp.IndexOf(':');
|
if (colonIndex <= 0 || colonIndex >= kvp.Length - 1)
|
{
|
continue;
|
}
|
|
string key = kvp.Substring(0, colonIndex).Trim();
|
string value = kvp.Substring(colonIndex + 1).Trim();
|
|
switch (key)
|
{
|
case "制造单号":
|
production.ProductionNo = value;
|
break;
|
case "制造部件":
|
production.ManufacturingCo = value;
|
break;
|
case "出库数量":
|
if (decimal.TryParse(value, out decimal outQuantity))
|
{
|
production.OutQuantity = outQuantity;
|
}
|
else
|
{
|
Console.WriteLine($"出库数量格式错误：{value}（应为数值，如14.0000）");
|
}
|
break;
|
default:
|
Console.WriteLine($"未知键名：{key}（对应值：{value}，跳过该键值对）");
|
break;
|
}
|
|
}
|
production.Creater = "WMS";
|
production.OrderId = outboundOrderDetail.Id;
|
_productionRepository.AddData(production);
|
}
|
}
|
}
|
}
|
else
|
{
|
OutboundOrderAddDTO orderAddDTO1 = new OutboundOrderAddDTO();
|
orderAddDTO1.OrderNo = orderAddDTO.No;
|
orderAddDTO1.UpperOrderNo = orderAddDTO.No;
|
orderAddDTO1.OutWareHouse = orderAddDTO.OutWareHouse;
|
orderAddDTO1.TransactionCode = orderAddDTO.TransactionCode?? "工单发料";
|
orderAddDTO1.InoutType = orderAddDTO.OrderType ?? InoutTypeEnum.WorkFeed.ToString();
|
orderAddDTO1.OrderType = orderAddDTO.InoutType;
|
orderAddDTO1.System = orderAddDTO.System;
|
IEnumerable<int> inOrderTypes = Enum.GetValues<OrderTypeEmun>().Cast<int>();
|
orderAddDTO1.Details = orderAddDTO.DetailList.DicToIEnumerable<OutboundOrderDetailAddDTO>();
|
#region 验证数据
|
(bool, string, object?) result = CheckOutboundOrderAddData(orderAddDTO1);
|
if (!result.Item1) return content = WebResponseContent.Instance.Error(result.Item2);
|
#endregion
|
Dt_OutboundOrder inboundOrder = _mapper.Map<Dt_OutboundOrder>(orderAddDTO1);
|
inboundOrder.OrderStatus = InboundStatusEnum.未开始.ObjToInt();
|
inboundOrder.Creater = "WMS";
|
inboundOrder.CreateDate = DateTime.Now;
|
inboundOrder.CreateType = CreateType.UpperSystemPush.ObjToInt();
|
_unitOfWorkManage.BeginTran();
|
bool a = BaseDal.Db.InsertNav(inboundOrder).Include(x => x.Details).ExecuteCommand();
|
|
foreach (var item in orderAddDTO1.Details)
|
{
|
if (string.IsNullOrWhiteSpace(item.Remark))
|
{
|
continue;
|
}
|
string[] remarkEntries = item.Remark.Split(
|
new[] { ';' },
|
StringSplitOptions.RemoveEmptyEntries
|
);
|
|
foreach (var entry in remarkEntries)
|
{
|
string[] keyValuePairs = entry.Split(
|
new[] { ',' },
|
StringSplitOptions.RemoveEmptyEntries
|
);
|
|
foreach (var kvp in keyValuePairs)
|
{
|
int colonIndex = kvp.IndexOf(':');
|
if (colonIndex <= 0 || colonIndex >= kvp.Length - 1)
|
{
|
continue;
|
}
|
|
string key = kvp.Substring(0, colonIndex).Trim();
|
string value = kvp.Substring(colonIndex + 1).Trim();
|
|
switch (key)
|
{
|
case "制造单号":
|
production.ProductionNo = value;
|
break;
|
case "制造部件":
|
production.ManufacturingCo = value;
|
break;
|
case "出库数量":
|
if (decimal.TryParse(value, out decimal outQuantity))
|
{
|
production.OutQuantity = outQuantity;
|
}
|
else
|
{
|
Console.WriteLine($"出库数量格式错误：{value}（应为数值，如14.0000）");
|
}
|
break;
|
default:
|
Console.WriteLine($"未知键名：{key}（对应值：{value}，跳过该键值对）");
|
break;
|
}
|
|
}
|
production.Creater = "WMS";
|
production.OrderId = inboundOrder.Details.FirstOrDefault().Id;
|
_productionRepository.AddData(production);
|
}
|
}
|
_unitOfWorkManage.CommitTran();
|
}
|
|
|
content = WebResponseContent.Instance.OK();
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
content = WebResponseContent.Instance.Error(ex.Message);
|
}
|
return content;
|
}
|
/// <summary>
|
/// 盘点任务上传立库
|
/// </summary>
|
/// <returns></returns>
|
public WebResponseContent InventoryOut(HouseCancelOut houseInventoryOut)
|
{
|
WebResponseContent content = new();
|
try
|
{
|
OutboundOrderAddDTO orderAddDTO1 = new OutboundOrderAddDTO();
|
orderAddDTO1.OrderNo = houseInventoryOut.No;
|
orderAddDTO1.UpperOrderNo = houseInventoryOut.No;
|
orderAddDTO1.Details = houseInventoryOut.DetailList.DicToIEnumerable<OutboundOrderDetailAddDTO>();
|
#region 验证数据
|
(bool, string, object?) result = CheckOutboundOrderAddData(orderAddDTO1);
|
if (!result.Item1) return content = WebResponseContent.Instance.Error(result.Item2);
|
#endregion
|
|
Dt_OutboundOrder inboundOrder = _mapper.Map<Dt_OutboundOrder>(orderAddDTO1);
|
inboundOrder.OrderStatus = InboundStatusEnum.未开始.ObjToInt();
|
inboundOrder.OrderType = OutOrderTypeEnum.OutInventory.ObjToInt();
|
inboundOrder.Creater = "WMS";
|
inboundOrder.CreateDate = DateTime.Now;
|
|
Dt_OutboundOrder oldOutboundOrder = BaseDal.Db.Queryable<Dt_OutboundOrder>().Where(x => x.OrderNo == orderAddDTO1.OrderNo).Includes(x => x.Details).First();
|
Dt_OutboundOrderDetail outboundOrderDetail = _outboundService.OutboundOrderDetailService.Repository.QueryFirst(x => x.OrderId == oldOutboundOrder.Id);
|
List<StockSelectViewDTO> stockSelectViews = new List<StockSelectViewDTO>();
|
StockSelectViewDTO stockSelectViewDTO = new()
|
{
|
OrderNo = orderAddDTO1.OrderNo,
|
MaterielCode = outboundOrderDetail.MaterielCode,
|
MaterielName = outboundOrderDetail.MaterielName,
|
UseableQuantity = outboundOrderDetail.OrderQuantity,
|
BatchNo = outboundOrderDetail.BatchNo,
|
LinId = outboundOrderDetail.LinId,
|
};
|
_unitOfWorkManage.BeginTran();
|
bool a = BaseDal.Db.InsertNav(inboundOrder).Include(x => x.Details).ExecuteCommand();
|
stockSelectViews.Add(stockSelectViewDTO);
|
GenerateOutboundTasks(oldOutboundOrder.Id, stockSelectViews);
|
_unitOfWorkManage.CommitTran();
|
content = WebResponseContent.Instance.OK();
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
content = WebResponseContent.Instance.Error(ex.Message);
|
}
|
finally
|
{
|
|
}
|
return content;
|
}
|
private (bool, string, object?) CheckOutboundOrderAddData(OutboundOrderAddDTO outboundOrderAddDTO)
|
{
|
(bool, string, object?) result1 = ModelValidate.ValidateModelData(outboundOrderAddDTO);
|
if (!result1.Item1) return result1;
|
|
(bool, string, object?) result2 = ModelValidate.ValidateModelData(outboundOrderAddDTO.Details);
|
if (!result2.Item1) return result2;
|
|
IEnumerable<int> inOrderTypes = Enum.GetValues<OutOrderTypeEnum>().Cast<int>();
|
if (!inOrderTypes.Contains(outboundOrderAddDTO.OrderType))
|
{
|
return (false, "未找到该单据类型", outboundOrderAddDTO);
|
}
|
|
//List<string> materielCodes = outboundOrderAddDTO.Details.Select(x => x.MaterielCode).ToList();
|
//if (!_materielInfoService.ExsitMateriels(materielCodes))
|
//{
|
// return (false, "有物料信息未录入，请录入物料信息", outboundOrderAddDTO);
|
//}
|
Dt_OutboundOrder dt_OutboundOrder = _outboundService.OutboundOrderService.Repository.QueryFirst(x => x.UpperOrderNo == outboundOrderAddDTO.UpperOrderNo && !string.IsNullOrEmpty(x.UpperOrderNo));
|
if (dt_OutboundOrder != null)
|
{
|
return (false, "单据已存在", outboundOrderAddDTO);
|
}
|
return (true, "成功", outboundOrderAddDTO);
|
}
|
|
public WebResponseContent GenerateOutboundTask(int orderDetailId, List<StockSelectViewDTO> stockSelectViews)
|
{
|
try
|
{
|
(List<Dt_Task>, List<Dt_StockInfo>?, List<Dt_OutboundOrderDetail>?, List<Dt_OutStockLockInfo>?, List<Dt_LocationInfo>?) 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);
|
}
|
}
|
/// <summary>
|
/// 生成出库任务
|
/// </summary>
|
/// <param name="orderDetailId"></param>
|
/// <param name="stockSelectViews"></param>
|
/// <returns></returns>
|
public WebResponseContent GenerateOutboundTasks(int orderDetailId, List<StockSelectViewDTO> stockSelectViews)
|
{
|
try
|
{
|
(List<Dt_Task>, List<Dt_StockInfo>?, List<Dt_OutboundOrderDetail>?, List<Dt_OutStockLockInfo>?, List<Dt_LocationInfo>?) result = OutboundTaskDataHandle(orderDetailId, stockSelectViews);
|
|
WebResponseContent content = GenerateOutboundTaskDataUpdate(result.Item1, result.Item2, result.Item3, result.Item4, result.Item5);
|
|
return content;
|
}
|
catch (Exception ex)
|
{
|
throw new Exception(ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 生成出库任务后数据更新到数据库
|
/// </summary>
|
/// <param name="tasks"></param>
|
/// <param name="stockInfos"></param>
|
/// <param name="outboundOrderDetails"></param>
|
/// <param name="outStockLockInfos"></param>
|
/// <param name="locationInfos"></param>
|
/// <returns></returns>
|
public WebResponseContent GenerateOutboundTaskDataUpdate(List<Dt_Task> tasks, List<Dt_StockInfo>? stockInfos = null, List<Dt_OutboundOrderDetail>? outboundOrderDetails = null, List<Dt_OutStockLockInfo>? outStockLockInfos = null, List<Dt_LocationInfo>? locationInfos = null)
|
{
|
try
|
{
|
WebResponseContent content = new WebResponseContent();
|
_unitOfWorkManage.BeginTran();
|
|
BaseDal.AddData(tasks);
|
//判断移库
|
//content = RelocationTasks(tasks.OrderBy(x => x.Depth).ToList());
|
//if (content.Status)
|
//{
|
// _unitOfWorkManage.CommitTran();
|
//}
|
//else
|
//{
|
// _unitOfWorkManage.RollbackTran();
|
// return content;
|
//}
|
//BaseDal.AddData(tasks);
|
|
if (stockInfos != null && outboundOrderDetails != null && outStockLockInfos != null && locationInfos != null)
|
{
|
Dt_OutboundOrder outboundOrder = _outboundService.OutboundOrderService.Repository.QueryFirst(x => x.Id == outboundOrderDetails.FirstOrDefault().OrderId);
|
outboundOrder.OrderStatus = OutboundStatusEnum.出库中.ObjToInt();
|
_outboundService.OutboundOrderService.Repository.UpdateData(outboundOrder);
|
content = _outboundService.OutboundOrderDetailService.LockOutboundStockDataUpdate(stockInfos, outboundOrderDetails, outStockLockInfos, locationInfos, tasks: tasks);
|
|
if (!content.Status)
|
{
|
_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();
|
//将任务推送到WCS
|
PushTasksToWCS(tasks);
|
return WebResponseContent.Instance.OK();
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
return WebResponseContent.Instance.Error(ex.Message);
|
}
|
|
}
|
|
/// <summary>
|
/// 判断巷道内移库
|
/// </summary>
|
/// <param name="TaskNum"></param>
|
/// <param name="SourceAddress"></param>
|
/// <returns></returns>
|
public WebResponseContent IsRelocations(int TaskNum, string SourceAddress)
|
{
|
try
|
{
|
WebResponseContent content = new WebResponseContent();
|
List<Dt_LocationInfo> loca = new List<Dt_LocationInfo>();
|
Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == TaskNum);
|
if (task == null)
|
{
|
return content = WebResponseContent.Instance.Error($"未找到该任务信息，任务号：{TaskNum}");
|
}
|
else
|
{
|
//判断是否需要移库
|
string[] targetCodes = SourceAddress.Split("-");
|
if (targetCodes[1] == "001")
|
{
|
targetCodes[1] = "002";
|
|
}
|
else if (targetCodes[1] == "004")
|
{
|
targetCodes[1] = "003";
|
}
|
else
|
{
|
return content = WebResponseContent.Instance.Error($"货位解析失败，货位编号：{SourceAddress}");
|
}
|
targetCodes[4] = "01";
|
string LocationCode = string.Join("-", targetCodes); //组装浅库位地址
|
Dt_LocationInfo locationInfos = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == LocationCode && (x.LocationStatus == (int)LocationStatusEnum.Free || x.LocationStatus == (int)LocationStatusEnum.InStock));
|
if (locationInfos == null)
|
{
|
return content = WebResponseContent.Instance.Error($"未找到该货位信息,货位编号:{locationInfos}");
|
}
|
else
|
{
|
if (locationInfos.LocationStatus == (int)LocationStatusEnum.Free) //判断浅货位是否有货
|
{
|
return content = WebResponseContent.Instance.OK();
|
}
|
else
|
{
|
Dt_StockInfo dt_StockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.LocationCode == LocationCode && x.StockStatus == (int)StockStatusEmun.已入库);
|
if (dt_StockInfo == null)
|
{
|
return content = WebResponseContent.Instance.Error($"未找到该货位的库存信息,货位编号:{LocationCode}");
|
}
|
else
|
{
|
Dt_LocationInfo newLocation;
|
//查走货位，进行生成移库任务
|
int Locationtype = 9; //默认为9
|
if (dt_StockInfo.MaterialType == (int)InventoryMaterialType.成品)
|
{
|
Locationtype = 11;
|
}
|
else if (dt_StockInfo.MaterialType == (int)InventoryMaterialType.原材料)
|
{
|
Locationtype = 10;
|
}
|
newLocation = _basicService.LocationInfoService.GetLocation(locationInfos.RoadwayNo, Locationtype); //拿到了移库后的货位
|
if (dt_StockInfo.MaterialType == (int)InventoryMaterialType.成品)
|
{
|
string[] targetCodesst = dt_StockInfo.PalletCode.Split("*");
|
//Dt_InboundOrder dt_Inbound = _inboundService.InbounOrderService.Repository.QueryFirst(x => x.OrderName == targetCodesst[0]);
|
//if (dt_Inbound.Startingcolumn != 0 || dt_Inbound.Terminationcolumn != 0)
|
//{
|
// newLocation = _basicService.LocationInfoService.GetLocation2(locationInfos.RoadwayNo, Locationtype, dt_Inbound.Startingcolumn, dt_Inbound.Terminationcolumn);
|
//}
|
//else
|
//{
|
// newLocation = _basicService.LocationInfoService.GetLocation(locationInfos.RoadwayNo, Locationtype);
|
//}
|
|
}
|
else
|
{
|
newLocation = _basicService.LocationInfoService.GetLocation(locationInfos.RoadwayNo, Locationtype);
|
}
|
|
|
if (newLocation != null)
|
{
|
Dt_Task dt_Task = new()
|
{
|
PalletCode = dt_StockInfo.PalletCode,
|
Roadway = locationInfos.RoadwayNo,
|
//TaskType = TaskTypeEnum.RelocationIn.ObjToInt(),
|
TaskStatus = OutTaskStatusEnum.OutNew.ObjToInt(),
|
SourceAddress = locationInfos.LocationCode,
|
TargetAddress = newLocation.LocationCode,
|
CurrentAddress = locationInfos.LocationCode,
|
NextAddress = newLocation.LocationCode,
|
Grade = 2,
|
Creater = "WMS",
|
CreateDate = DateTime.Now,
|
TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)),
|
MaterialType = dt_StockInfo.MaterialType
|
};
|
_unitOfWorkManage.BeginTran();
|
if (locationInfos.LocationStatus == LocationStatusEnum.InStock.ObjToInt())
|
{
|
locationInfos.LocationStatus = LocationStatusEnum.Lock.ObjToInt();
|
newLocation.LocationStatus = LocationStatusEnum.Lock.ObjToInt();
|
|
}
|
else if (locationInfos.LocationStatus == LocationStatusEnum.Pallet.ObjToInt())
|
{
|
locationInfos.LocationStatus = LocationStatusEnum.PalletLock.ObjToInt();
|
newLocation.LocationStatus = LocationStatusEnum.PalletLock.ObjToInt();
|
}
|
loca.Add(newLocation);
|
loca.Add(locationInfos);
|
_basicService.LocationInfoService.UpdateData(loca);
|
_unitOfWorkManage.CommitTran();
|
return content = WebResponseContent.Instance.OK(data: dt_Task);
|
}
|
else
|
{
|
return content = WebResponseContent.Instance.Error($"未找到巷道内可移库的货位");
|
}
|
|
}
|
}
|
}
|
}
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
throw;
|
}
|
}
|
|
|
public string ReceiveWMSTask = WIDESEA_Core.Helper.AppSettings.Configuration["ReceiveWMSTask"];
|
|
/// <summary>
|
/// 生成出库任务
|
/// </summary>
|
/// <param name="keys"></param>
|
/// <returns></returns>
|
public WebResponseContent WMSGenerateOutboundTask(int[] keys)
|
{
|
try
|
{
|
List<Dt_Task> tasks = new List<Dt_Task>();
|
List<StockSelectViewDTO> stockSelectViews = new List<StockSelectViewDTO>();
|
List<Dt_StockInfo> stockInfos = new List<Dt_StockInfo>();
|
List<Dt_OutboundOrderDetail> outboundOrderDetails = new List<Dt_OutboundOrderDetail>();
|
List<Dt_OutStockLockInfo> outStockLockInfos = new List<Dt_OutStockLockInfo>();
|
List<Dt_LocationInfo> locationInfos = new List<Dt_LocationInfo>();
|
foreach (int key in keys)
|
{
|
|
(List<Dt_Task>, List<Dt_StockInfo>?, List<Dt_OutboundOrderDetail>?, List<Dt_OutStockLockInfo>?, List<Dt_LocationInfo>?) result = OutboundTaskDataHandle(keys);
|
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.Item1 != null && result.Item1.Count > 0)
|
{
|
tasks.AddRange(result.Item1);
|
}
|
|
|
}
|
|
WebResponseContent content = GenerateOutboundTaskDataUpdate(tasks, stockInfos, outboundOrderDetails, outStockLockInfos, locationInfos);
|
return content;
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
return WebResponseContent.Instance.Error(ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 任务取消
|
/// </summary>
|
/// <param name="saveModel"></param>
|
/// <returns></returns>
|
public WebResponseContent Cancelinventory(int taskNum)
|
{
|
WebResponseContent content = new WebResponseContent();
|
Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum);
|
if (task != null)
|
{
|
if (task.TaskType == (int)TaskTypeEnum.Outbound || task.TaskType == (int)TaskTypeEnum.EmptyProductBack)
|
{
|
//处理出库的逻辑
|
Dt_LocationInfo locationinfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.SourceAddress);
|
if (locationinfo.LocationStatus == LocationStatusEnum.Lock.ObjToInt())
|
{
|
locationinfo.LocationStatus = LocationStatusEnum.InStock.ObjToInt();
|
}
|
if (locationinfo.LocationStatus == LocationStatusEnum.PalletLock.ObjToInt())
|
{
|
locationinfo.LocationStatus = LocationStatusEnum.Pallet.ObjToInt();
|
}
|
_basicService.LocationInfoService.Repository.UpdateData(locationinfo);
|
Dt_StockInfo stockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == task.PalletCode);
|
stockInfo.StockStatus = (int)StockStatusEmun.已入库;
|
_stockService.StockInfoService.Repository.UpdateData(stockInfo);
|
Dt_StockInfoDetail stocktdetail = _stockService.StockInfoDetailService.Repository.QueryFirst(x => x.StockId == stockInfo.Id);
|
if (stocktdetail != null)
|
{
|
stocktdetail.Status = (int)StockStatusEmun.已入库;
|
_stockService.StockInfoDetailService.Repository.UpdateData(stocktdetail);
|
}
|
BaseDal.DeleteData(task);
|
BaseDal.DeleteAndMoveIntoHty(task, OperateType.人工删除);
|
WriteLog.GetLog("任务日志").Write($"出库任务取消成功，托盘条码：{task.PalletCode}", $"任务取消");
|
return content = WebResponseContent.Instance.Error($"出库任务取消成功");
|
|
}
|
else if (task.TaskType == (int)TaskTypeEnum.Inbound || task.TaskType == (int)TaskTypeEnum.Inbound)
|
{
|
//处理出库的逻辑
|
Dt_LocationInfo locationinfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.TargetAddress);
|
if (locationinfo.LocationStatus == LocationStatusEnum.Lock.ObjToInt() || locationinfo.LocationStatus == LocationStatusEnum.PalletLock.ObjToInt())
|
{
|
locationinfo.LocationStatus = LocationStatusEnum.Free.ObjToInt();
|
}
|
_basicService.LocationInfoService.Repository.UpdateData(locationinfo);
|
Dt_StockInfo stockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == task.PalletCode);
|
_stockService.StockInfoService.Repository.DeleteData(stockInfo);
|
Dt_StockInfoDetail stocktdetail = _stockService.StockInfoDetailService.Repository.QueryFirst(x => x.StockId == stockInfo.Id);
|
if (stocktdetail != null)
|
{
|
_stockService.StockInfoDetailService.Repository.DeleteData(stocktdetail);
|
}
|
BaseDal.DeleteData(task);
|
BaseDal.DeleteAndMoveIntoHty(task, OperateType.人工删除);
|
WriteLog.GetLog("任务日志").Write($"入库任务取消成功，托盘条码：{task.PalletCode}", $"任务取消");
|
return content = WebResponseContent.Instance.Error($"入库任务取消成功");
|
}
|
else
|
{
|
return content = WebResponseContent.Instance.Error($"该任务的任务类型异常，取消失败");
|
}
|
}
|
else
|
{
|
return content = WebResponseContent.Instance.Error($"未找到任务号");
|
}
|
}
|
|
/// <summary>
|
/// 选定库存生成盘点单出库
|
/// </summary>
|
/// <param name="id"></param>
|
/// <returns></returns>
|
public WebResponseContent TakeOutbound(List<StockViewDTO> stockViews)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
if (stockViews.Select(x => x.WarehouseId).Distinct().Count() >= 2)
|
{
|
return content.Error($"请选择同一仓库库存进行盘点");
|
}
|
List<int> ids = stockViews.Select(x => x.StockId).ToList();
|
//获取库存
|
List<Dt_StockInfo> stockInfos = _stockRepository.StockInfoRepository.Db.Queryable<Dt_StockInfo>().Where(x => ids.Contains(x.Id)).Includes(x => x.Details).ToList();
|
if (stockInfos.Count != stockViews.Count)
|
{
|
StockViewDTO? stockViewDTO = stockViews.FirstOrDefault(x => !stockInfos.Select(x => x.PalletCode).ToList().Contains(x.PalletCode));
|
return content.Error($"未找到{stockViewDTO?.PalletCode}库存");
|
}
|
//获取货位
|
List<string> locStrs = stockInfos.Select(x => x.LocationCode).ToList();
|
List<Dt_LocationInfo> locationInfos = _basicRepository.LocationInfoRepository.QueryData(x => locStrs.Contains(x.LocationCode));
|
if (stockInfos.Count != locationInfos.Count)
|
{
|
string? locStr = locStrs.FirstOrDefault(x => !locationInfos.Select(x => x.LocationCode).ToList().Contains(x));
|
return content.Error($"未找到{locStr}货位数据");
|
}
|
Dt_TakeStockOrder takeStockOrder = new Dt_TakeStockOrder()
|
{
|
WarehouseId = stockInfos.FirstOrDefault().WarehouseId,
|
TakeStockStatus = TakeStockStatusEnum.盘点中.ObjToInt(),
|
OrderNo = _outboundService.OutboundOrderService.CreateCodeByRule(nameof(RuleCode.PDCodeRule)),
|
Details = new List<Dt_TakeStockOrderDetail>()
|
};
|
foreach (var item in stockInfos)
|
{
|
if (item.Details.Count <= 0)
|
{
|
return content.Error($"未找到{item.PalletCode}库存明细数据");
|
}
|
Dt_LocationInfo? locationInfo = locationInfos.FirstOrDefault(x => x.LocationCode == item.LocationCode);
|
if (locationInfo != null && (locationInfo.EnableStatus == EnableStatusEnum.OnlyOut.ObjToInt() || locationInfo.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && locationInfo.LocationStatus == LocationStatusEnum.InStock.ObjToInt() && item.StockStatus == StockStatusEmun.入库完成.ObjToInt())
|
{
|
//创建明细
|
Dt_TakeStockOrderDetail takeStockOrderDetail = new Dt_TakeStockOrderDetail()
|
{
|
MaterielCode = item.Details.FirstOrDefault().MaterielCode,
|
MaterielName = item.Details.FirstOrDefault().MaterielName ?? "无物料名称",
|
BatchNo = item.Details.FirstOrDefault().BatchNo,
|
MaterielSpec = item.Details.FirstOrDefault().MaterieSpec ?? "无物料规格",
|
LocationCode = item.LocationCode,
|
TakePalletCode = item.PalletCode,
|
TakeDetalStatus = TakeStockDetailStatusEnum.盘点出库中.ObjToInt(),
|
SysQty = item.Details.Sum(x => x.StockQuantity),
|
Qty = 0
|
};
|
takeStockOrder.Details.Add(takeStockOrderDetail);
|
}
|
else
|
{
|
content.Error($"货位或库存状态不满足出库条件");
|
}
|
}
|
List<Dt_Task> tasks = GetTasks(stockInfos, TaskTypeEnum.OutInventory);
|
if (tasks == null || tasks.Count <= 0)
|
{
|
return content.Error($"生成任务失败");
|
}
|
stockInfos.ForEach(x =>
|
{
|
x.StockStatus = StockStatusEmun.出库锁定.ObjToInt();
|
});
|
tasks.ForEach(x =>
|
{
|
x.OrderNo = takeStockOrder.OrderNo;
|
});
|
LocationStatusEnum locationStatus = LocationStatusEnum.Lock;
|
_unitOfWorkManage.BeginTran();
|
//更新库存状态
|
_stockRepository.StockInfoRepository.UpdateData(stockInfos);
|
BaseDal.Db.InsertNav(takeStockOrder).Include(x => x.Details).ExecuteCommand();
|
//新建任务
|
BaseDal.AddData(tasks);
|
_basicService.LocationInfoService.Repository.UpdateLocationStatus(locationInfos, locationStatus);
|
_unitOfWorkManage.CommitTran();
|
PushTasksToWCS(tasks);
|
content.OK();
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
}
|
}
|
