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 SkiaSharp;
using System.Collections;
using Newtonsoft.Json;
using WIDESEA_Core.Log;
using System.Linq.Expressions;
using WIDESEA_DTO.Inbound;
using WIDESEA_DTO.Task;
using OfficeOpenXml.FormulaParsing.Excel.Functions.Text;
using System.Drawing.Printing;
using WIDESEA_Core.DB;
using System.Drawing;
using WIDESEA_ITaskInfoService;
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 = 3,
PalletCode = stockInfo.PalletCode,
NextAddress = roadwayInfo.OutStationCode,
Roadway = locationInfo.RoadwayNo,
SourceAddress = stockInfo.LocationCode,
TargetAddress = roadwayInfo.OutStationCode,
TaskStatus = OutTaskStatusEnum.OutNew.ObjToInt(),
TaskType = TaskTypeEnum.Outbound.ObjToInt(),
Depth = locationInfo.Depth,
TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum))
};
tasks.Add(task);
}
}
}
return tasks;
}
///
/// 出库任务数据处理
///
///
///
///
///
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 (stockSelectViews.Sum(x => x.UseableQuantity) > outboundOrderDetail.OrderQuantity - outboundOrderDetail.LockQuantity)
{
throw new Exception("选择数量超出单据数量!");
}
List? stockInfos = null;
Dt_OutboundOrderDetail? orderDetail = null;
List? outStockLockInfos = null;
List? locationInfos = null;
if (outboundOrderDetail.OrderDetailStatus == OrderDetailStatusEnum.New.ObjToInt())
{
(List, Dt_OutboundOrderDetail, List, List) result = _outboundService.OutboundOrderDetailService.AssignStockOutbound(outboundOrderDetail, stockSelectViews);
if (result.Item1 != null && result.Item1.Count > 0)
{
tasks = GetTasks(result.Item1);
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 stockLockInfos = _outboundService.OutboundStockLockInfoService.GetByOrderDetailId(outboundOrderDetail.OrderId);
if (stockLockInfos != null && stockLockInfos.Count > 0)
{
List stocks = _stockService.StockInfoService.Repository.GetStockInfosByPalletCodes(stockLockInfos.Select(x => x.PalletCode).Distinct().ToList());
tasks = GetTasks(stocks);
}
}
return (tasks, stockInfos, orderDetail == null ? null : new List { orderDetail }, outStockLockInfos, locationInfos);
}
///
/// 生成出库任务后数据更新到数据库
///
///
///
///
///
///
///
public WebResponseContent GenerateOutboundTaskDataUpdate(List tasks, List? stockInfos = null, List? outboundOrderDetails = null, List? outStockLockInfos = null, List? locationInfos = null)
{
WebResponseContent content = new WebResponseContent();
try
{
_unitOfWorkManage.BeginTran();
(List?, List?) result = RelocationTasks(tasks.OrderBy(x => x.Depth).ToList());
if (result.Item1 != null && result.Item1.Count > 0)
{
AddData(result.Item1);
var response = HttpHelper.Post(url + "ReceiveTask/", result.Item1, "出库任务下发");
if (!response.Status)
{
_unitOfWorkManage.RollbackTran();
return content = WebResponseContent.Instance.Error($"{response.Message}");
}
}
if (result.Item2 != null && result.Item2.Count > 0)
{
for (int i = 0; i < result.Item2.Count; i++)
{
Dt_LocationInfo location = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == result.Item2[i].SourceAddress && x.RoadwayNo == result.Item2[i].Roadway);
if (location.Depth == 2)
{
_basicService.LocationInfoService.UpdateLocationLock(location, result.Item2[i].TaskNum, StockChangeType.Outbound.ObjToInt(), false);
}
}
AddData(result.Item2);
var response = HttpHelper.Post(url + "ReceiveTask/", result.Item2, "出库任务下发");
if (!response.Status)
{
_unitOfWorkManage.RollbackTran();
return content = WebResponseContent.Instance.Error($"{response.Message}");
}
}
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();
}
}
else if (outboundOrderDetails != null && outboundOrderDetails.Count > 0)
{
outboundOrderDetails.ForEach(x =>
{
x.OrderDetailStatus = OrderDetailStatusEnum.Outbound.ObjToInt();
});
_outboundService.OutboundOrderDetailService.Repository.UpdateData(outboundOrderDetails);
}
if (outboundOrderDetails != null && outboundOrderDetails.Count() > 0)
{
for (int i = 0; i < outboundOrderDetails.Count(); i++)
{
_outboundService.OutboundOrderDetailService.Repository.DeleteAndMoveIntoHty(outboundOrderDetails[i], App.User.UserId == 0 ? OperateType.自动完成 : OperateType.人工完成);
Dt_OutboundOrder outboundOrder = _outboundService.OutboundOrderService.Repository.QueryFirst(x => x.Id == outboundOrderDetails[i].OrderId);
List outboundOrderDetail = _outboundService.OutboundOrderDetailService.Repository.QueryData(x => x.OrderId == outboundOrder.Id && x.OrderDetailStatus == OrderDetailStatusEnum.New.ObjToInt()).ToList();
if (outboundOrderDetail.Count <= 0)
{
outboundOrder.OrderStatus = OutboundStatusEnum.出库完成.ObjToInt();
_outboundService.OutboundOrderService.Repository.DeleteAndMoveIntoHty(outboundOrder, App.User.UserId == 0 ? OperateType.自动完成 : OperateType.人工完成);
}
else
{
outboundOrder.OrderStatus = OutboundStatusEnum.出库中.ObjToInt();
_outboundService.OutboundOrderService.Repository.UpdateData(outboundOrder);
}
}
}
_unitOfWorkManage.CommitTran();
return WebResponseContent.Instance.OK();
}
catch (Exception ex)
{
_unitOfWorkManage.RollbackTran();
return WebResponseContent.Instance.Error(ex.Message);
}
finally
{
WriteLog.GetLog("出库任务下发").Write(JsonConvert.SerializeObject(content), "出库任务下发");
}
}
public (List?, List?) RelocationTasks(List task)
{
WebResponseContent content = new WebResponseContent();
try
{
List tasks = new List();
List relocationList = new List();
if (task.Count > 0)
{
for (int i = 0; i < task.Count; i++)
{
Dt_LocationInfo location = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task[i].SourceAddress && x.RoadwayNo == task[i].Roadway);
int befoStatus = location.LocationStatus.ObjToInt();
if (location != null)
{
Dt_LocationInfo result = _basicService.LocationInfoService.isDepth(location);
if (result != null && result.LocationStatus != LocationStatusEnum.Lock.ObjToInt() && result.LocationStatus != StatusEnum.PalletLock.ObjToInt() && result.LocationStatus != LocationStatusEnum.Free.ObjToInt())
{
int sum = 0;
for (int j = 0; j < task.Count; j++)
{
if (result.LocationCode == task[j].SourceAddress)
{
sum++;
}
}
if (sum == 0)
{
Dt_Task relocariontask = RelocationTask(result);
task[i].Grade = 2;
relocationList.Add(relocariontask);
relocationList.Add(task[i]);
}
else
{
tasks.Add(task[i]);
content = WebResponseContent.Instance.OK();
}
}
else if (result == null)
{
tasks.Add(task[i]);
content = WebResponseContent.Instance.OK();
}
else if (result != null && result.LocationStatus == LocationStatusEnum.Free.ObjToInt())
{
tasks.Add(task[i]);
content = WebResponseContent.Instance.OK();
}
else if (result != null && (result.LocationStatus == LocationStatusEnum.Lock.ObjToInt() || result.LocationStatus == StatusEnum.PalletLock.ObjToInt()))
{
Dt_Task TaskInfo = BaseDal.QueryFirst(x => x.SourceAddress == result.LocationCode);
if (TaskInfo == null)
{
content = WebResponseContent.Instance.Error("货位被锁定不可出库");
break;
}
else
{
tasks.Add(task[i]);
content = WebResponseContent.Instance.OK();
}
}
}
else
{
content = WebResponseContent.Instance.Error("任务异常");
break;
}
}
return (relocationList, tasks);
}
else
{
throw new Exception($"生成移库任务失败");
}
}
catch (Exception ex)
{
return (null, null);
}
}
///
/// 移库任务
///
///
///
public Dt_Task RelocationTask(Dt_LocationInfo location)
{
WebResponseContent content = new WebResponseContent();
try
{
Dt_StockInfo stockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.LocationCode == location.LocationCode);
if (stockInfo != null)
{
Dt_LocationInfo? locationInfos = _basicService.LocationInfoService.AssignLocation(location.RoadwayNo);
if (locationInfos != null)
{
Dt_Task tasks = new()
{
CurrentAddress = location.LocationCode,
Grade = 0,
PalletCode = stockInfo.PalletCode,
NextAddress = locationInfos.LocationCode,
Roadway = location.RoadwayNo,
SourceAddress = location.LocationCode,
TargetAddress = locationInfos.LocationCode,
TaskStatus = InTaskStatusEnum.RelocationNew.ObjToInt(),
//TaskType = TaskTypeEnum.Relocation.ObjToInt(),
Depth = location.Depth,
TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum))
};
_basicService.LocationInfoService.RelocationLock(location, locationInfos, tasks.TaskNum);
stockInfo.StockStatus = StockStatusEmun.移库锁定.ObjToInt();
_stockService.StockInfoService.Repository.UpdateData(stockInfo);
return tasks;
}
else
{
throw new Exception($"生成移库任务失败");
}
}
else
{
throw new Exception("未找到库存信息");
}
}
catch (Exception ex)
{
throw new Exception($"生成移库任务失败"); ;
}
}
///
/// 出库任务查询
///
///
///
public WebResponseContent OutboundTask(TaskDTO taskDTO)
{
WebResponseContent content = new WebResponseContent();
try
{
Expression> expressionOrder = x => true;
//if (!string.IsNullOrEmpty(taskDTO.TaskNum))
//{
// expressionOrder = x => x.OrderNo.Contains(inboundOrderGetDTO.OrderNo);
//}
int count = BaseDal.QueryData(x => x.TaskStatus == OutboundStatusEnum.未开始.ObjToInt() && x.TaskType == TaskTypeEnum.Outbound.ObjToInt()).ToList().Count();
int maxPage = Convert.ToInt32(Math.Ceiling(count / 10.0));
if (taskDTO.pageNo <= maxPage)
{
var inboundOrder = BaseDal.Db.Queryable().Where(expressionOrder).Where(x => x.TaskType == TaskTypeEnum.Outbound.ObjToInt()).OrderByDescending(x => x.CreateDate).Select(x => new Dt_Task { TaskNum = x.TaskNum, TaskId = x.TaskId, CreateDate = x.CreateDate, Creater = x.Creater, Materialtype = x.Materialtype }).ToList();
content = WebResponseContent.Instance.OK(data: inboundOrder);
}
else
{
content = WebResponseContent.Instance.OK(data: null, message: "已到最后一页");
}
}
catch (Exception ex)
{
content = WebResponseContent.Instance.Error($"查询入库单据错误,错误信息:{ex.Message}");
}
return content;
}
///
/// 确认出库任务
///
///
///
public WebResponseContent RequestInbound(SaveModel saveModel)
{
WebResponseContent content = new WebResponseContent();
try
{
string stationcode = saveModel.MainData["stationcode"].ToString();
//string PalletCode = saveModel.MainData["PalletCode"].ToString();
Dt_Task task = BaseDal.QueryFirst(x => x.SourceAddress == stationcode); //&& x.Materialtype == PalletCode
if (task != null)
{
task.TaskStatus = AGVTaskStatusEnum.AGV_New.ObjToInt();
BaseDal.UpdateData(task);
content = WebResponseContent.Instance.OK();
}
else
{
return content = WebResponseContent.Instance.Error("未找到此任务或物料类型不匹配");
}
}
catch (Exception ex)
{
content = WebResponseContent.Instance.Error($"任务起点异常,错误信息:{ex.Message}");
}
return content;
}
private static readonly object text = new object();
///
/// 出库任务
///
///
///
public WebResponseContent OutboundTasks(SaveModel saveModel)
{
lock (text)
{
WebResponseContent content = new WebResponseContent();
try
{
string stationcode = saveModel.MainData["stationcode"].ToString();
string PalletCode = saveModel.MainData["PalletCode"].ToString();
if (stationcode == "" || PalletCode == "")//异常返回。。。。。。
{
return content = WebResponseContent.Instance.Error($"添加任务异常,错误信息:扫码信息不能为空");
}
Dt_CachePoint endCachePoint = _basicService.CachePointService.Repository.QueryFirst(x => x.PointCode.Contains("原材料库") && x.PointStatus == LocationStatusEnum.Free.ObjToInt() && x.EnableStatus == EnableStatusEnum.Normal.ObjToInt().ObjToInt());//&& x.PointStatus == LocationStatusEnum.Free.ObjToInt()
if (endCachePoint == null)
{
return content = WebResponseContent.Instance.Error($"添加任务异常,错误信息:{"未找到原材料库可用缓存位"}");
}
Dt_CachePoint points = _basicService.CachePointService.Repository.QueryFirst(x => x.PointCode == stationcode && x.PointStatus == LocationStatusEnum.Free.ObjToInt() && x.EnableStatus == EnableStatusEnum.Normal.ObjToInt().ObjToInt());
if (points == null)
{
return content = WebResponseContent.Instance.Error($"添加任务异常,错误信息:{"扫码数据异常,此缓存点已被锁定或已禁用"}");
}
Dt_Task taskcode = BaseDal.QueryFirst(x => x.SourceAddress == stationcode || x.TargetAddress == stationcode);
if (taskcode != null)
{
return content = WebResponseContent.Instance.Error($"添加任务异常,错误信息:该站点已存在任务");
}
var pointname = _basicService.CachePointService.Repository.QueryData(x => x.Remark == points.Remark).ToList();
foreach (var item in pointname)
{
var a = points.Depth.ObjToInt();
var b = item.Depth.ObjToInt();
if (a > b)
{
Dt_CachePoint c = _basicService.CachePointService.Repository.QueryFirst(x => x.PointCode == item.PointCode && x.PointStatus == 0);
if (c != null)
{
return content = WebResponseContent.Instance.Error($"添加任务异常,错误信息:{"请按从里到外缓存点顺序请求任务"}");
}
}
}
List tasks = new List();
Dt_Task task = new Dt_Task()
{
CurrentAddress = "1",
Grade = 1,
NextAddress = "1",
PalletCode = "",
Roadway = "1",
SourceAddress = endCachePoint.PointCode,
TargetAddress = stationcode,
TaskStatus = AGVTaskStatusEnum.AGV_Query.ObjToInt(),
TaskType = TaskTypeEnum.Outbound.ObjToInt(),
Materialtype = PalletCode,
Depth = 1,
TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum))
};
tasks.Add(task);
Repository.AddData(tasks);
HCJLock(task);
//Main();
content = WebResponseContent.Instance.OK();
}
catch (Exception ex)
{
content = WebResponseContent.Instance.Error($"添加任务异常,错误信息:{ex.Message}");
}
return content;
}
}
}
}