Files
8357WMS/HHWMS.Web/Areas/Api/IWCSController.cs
zhougf 8606f7abcb 重写了 出库任务生成盒下发流程
修改了部分页面的查询条件
2024-05-16 02:38:16 +08:00

567 lines
32 KiB
C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Security.Cryptography.X509Certificates;
using AutoMapper;
using HHWMS.Web.Models;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using Newtonsoft.Json;
using WalkingTec.Mvvm.Core;
namespace HHWMS.Web
{
/// <summary>
/// WCS接口
/// 调用方向 WCS --> WMS
/// </summary>
[Public]
[ActionDescription("HHWMS.WCSApi")]
[ApiController]
[Route("api/[controller]/[action]"), ApiExplorerSettings(GroupName = "User")]
public class IWCSController : ApiController
{
private readonly IUnitWork _unitwork;
private readonly IMapper _mapper;
public IWCSController(IUnitWork unitwork, IMapper mapper)
{
_unitwork = unitwork;
_mapper = mapper;
}
/// <summary>
/// 请求入库
/// </summary>
/// <returns></returns>
[HttpPost]
public IActionResult RequestIn(WcsRequest request)
{
var emptyLoc = _unitwork.Find<Location>(x => x.Type == LocationTypeEnum.盘料库位)
.ToList()
.GroupBy(x => Convert.ToInt32(x.Length));
var sizeEmptyNum = new List<dynamic>();
foreach (var group in emptyLoc)
{
var num = group.Sum(x => (x.Length - x.Width));
sizeEmptyNum.Add(new
{
size = group.Key,
num = Convert.ToInt32(num)
});
}
return Ok();
//var inv = _unitwork.Find<Inventory>(x => x.ID > 0).FirstOrDefault();
//var bizData = new InStore
//{
// INWMS = new INWMS
// {
// INITEMS = new INITEMS
// {
// INITEM = new List<INITEMItem>()
// {
// new INITEMItem()
// {
// ERPSN = inv.MaterialCode,
// WMSSN = inv.UniqueCode,
// QTY = ((int?)inv.Qty).ToString(),
// TYPE = "2"
// }
// }
// }
// }
//};
//var str = JsonConvert.SerializeObject(bizData);
//// 参数判断
//if (request.RoadWay == null || request.Size == null)
//{
// return ApiResultError(msg: $"传入参数不正确!");
//}
//var vm = Wtm.CreateVM<LocationVM>();
//var result = vm.GetLocation(request);
//if (string.IsNullOrEmpty(result.Data.LocationCode))
//{
// return ApiResultError(msg: $"巷道{request.RoadWay}内无空仓位!");
//}
//return ApiResult(new { Location = result.Data.LocationCode });
}
/// <summary>
/// 状态返回
/// </summary>
/// <returns></returns>
[HttpPost]
public IActionResult Test(TaskResponse response)
{
var taskno = response.TaskId.Split("-")[0];
//wcs 任务反馈
var task = _unitwork.Find<TaskHeader>(x => x.TaskNo.Equals(taskno)
&& x.Status != TaskStatusEnum.完成)
.Include(x => x.TaskDetails).FirstOrDefault();
using (var tran = Wtm.DC.Database.BeginTransaction())
{
try
{
if (task != null)
{
if (task.Status != TaskStatusEnum.完成 && response.Result == (int)TaskStatusEnum.完成)
{
var newTask = new TaskHeader
{
TaskDetails = new List<TaskDetail>()
};
var tasktolocatioin = _unitwork.FindSingle<Location>(x => x.Code.Equals(task.ToLocation));
var taskfromlocatioin = _unitwork.FindSingle<Location>(x => x.Code.Equals(task.FromLocation));
switch (task.TaskType)
{
case TaskTypeEnum.散料盒入库:
// 更新库位
// 起始库位为空
// 目标库位为有货
// 更新库存
task.Status = TaskStatusEnum.完成;
taskfromlocatioin.Status = LocationStatus.空仓位;
taskfromlocatioin.ContainerCode = "";
_unitwork.Update(taskfromlocatioin);
tasktolocatioin.Status = tasktolocatioin.Length == 1 ? LocationStatus.满货 : LocationStatus.有货;
if (!_unitwork.IsExit<Inventory>(x => x.ContainerCode == tasktolocatioin.Code))
{
tasktolocatioin.Status = LocationStatus.空容器;
}
tasktolocatioin.ContainerCode = task.ContainerCode;
_unitwork.Update(tasktolocatioin);
break;
case TaskTypeEnum.散料盒出库:
// 更新库位
// 起始库位为空
// 目标库位为有货
// 更新库存
task.Status = TaskStatusEnum.完成;
//taskfromlocatioin.Status = LocationStatus.空仓位;
//taskfromlocatioin.ContainerCode = "";
//_unitwork.Update(taskfromlocatioin);
tasktolocatioin.Status = LocationStatus.有货;
tasktolocatioin.ContainerCode = task.ContainerCode;
_unitwork.Update(tasktolocatioin);
_unitwork.BatchUpdate<Inventory>(x => x.ContainerCode.Equals(task.ContainerCode),
x => new Inventory
{
LocationCode = tasktolocatioin.Code,
UpdateTime = DateTime.Now,
UpdateBy = "wcs"
});
break;
case TaskTypeEnum.盘料盒入库:
// 更新库位
// 起始库位为空
// 目标库位为有货
// 更新库存
task.Status = TaskStatusEnum.完成;
taskfromlocatioin.ContainerCode = "";
taskfromlocatioin.Status = LocationStatus.空仓位;
_unitwork.Update(taskfromlocatioin);
var invCount = _unitwork.GetCount<Inventory>(x => x.ContainerCode == tasktolocatioin.ContainerCode);
tasktolocatioin.Width = invCount;
if (invCount == tasktolocatioin.Length)
{
tasktolocatioin.Status = LocationStatus.满货;
}
else if (invCount < tasktolocatioin.Length && invCount != 0)
{
tasktolocatioin.Status = LocationStatus.有货;
}
else if (invCount == 0)
{
tasktolocatioin.Status = LocationStatus.空容器;
}
_unitwork.Update(tasktolocatioin);
break;
case TaskTypeEnum.盘料盒出库:
// 更新库位
// 起始库位为空
// 目标库位为有货
// 更新库存
task.Status = TaskStatusEnum.完成;
tasktolocatioin.ContainerCode = task.ContainerCode;
tasktolocatioin.Status = LocationStatus.任务锁;
_unitwork.Update(tasktolocatioin);
// 料盒出库是为了入,还是为了出 1是出,2是入
if (task.Station == "1")
{
// 下发盘料出库
var plcTaskList = _unitwork.Find<TaskHeader>(x => x.TaskType.Equals(TaskTypeEnum.盘料出库)
&& x.ContainerCode.Contains(task.ContainerCode))
.Include(x => x.TaskDetails)
.ToList();
if (plcTaskList.Any())
{
foreach (var plcTask in plcTaskList)
{
var details = plcTask.TaskDetails.Where(x =>
!string.IsNullOrEmpty(x.ContainerCode)
&& x.ContainerCode.Equals(task.ContainerCode)
&& !string.IsNullOrEmpty(x.ToLocation));
foreach (var detail in details)
{
detail.Status = TaskStatusEnum.待下发;
detail.UpdateTime = DateTime.Now;
}
plcTask.Status = TaskStatusEnum.待下发;
_unitwork.Update(plcTask);
}
}
}
else if (task.Station == "2")
{
// 下发盘料入库
var plrTask = _unitwork.Find<TaskHeader>(x => x.TaskType.Equals(TaskTypeEnum.盘料入库) && !string.IsNullOrEmpty(x.ContainerCode)
&& x.ContainerCode.Contains(task.ContainerCode))
.Include(x => x.TaskDetails).FirstOrDefault();
if (plrTask != null)
{
plrTask.Status = TaskStatusEnum.待下发;
// 更新目的仓位
var to = _unitwork.FindSingle<Location>(x => x.ContiguousCode == task.ToLocation
&& x.Type.Equals(LocationTypeEnum.机械臂工位))?.Code;
plrTask.ToLocation = to;
// 更新明细为待下发
var details = plrTask.TaskDetails.Where(x => !string.IsNullOrEmpty(x.ContainerCode) && x.ContainerCode.Contains(task.ContainerCode));
foreach (var item in details)
{
item.Status = TaskStatusEnum.待下发;
item.UpdateTime = DateTime.Now;
}
_unitwork.Update(plrTask);
}
}
break;
case TaskTypeEnum.盘料入库:
var ll = response.TaskId.Split("-")[1];
//更新库存数据
var taskdetail = task.TaskDetails.First(x => x.FromLocation == ll);
var invIn = _unitwork.Find<Inventory>(n => n.UniqueCode == taskdetail.UniqueCode
&& n.ContainerCode == task.FromLocation
&& n.TaskStatus == InventoryTaskStatus.任务中).FirstOrDefault();
if (invIn != null)
{
invIn.ContainerCode = taskdetail.ContainerCode;
invIn.LocationCode = taskdetail.ContainerCode;
invIn.Lot = taskdetail.ToLocation;
_unitwork.Update(invIn);
}
task.TaskDetails.First(x => x.FromLocation == ll).Status = TaskStatusEnum.完成;
var containerCode = task.TaskDetails.First(x => x.FromLocation == ll).ContainerCode;
// 查询料塔 是否还有 此料盒 已下发,未完成的盘料入库任务 有不操作,没有 创建料盒入库任务
if (!task.TaskDetails.Any(x => x.Status < TaskStatusEnum.完成 && !string.IsNullOrEmpty(x.ContainerCode) && x.ContainerCode.Equals(containerCode)))
{
var station = _unitwork.Find<Location>(x => x.Code == task.FromLocation).FirstOrDefault();
// 创建料盒入库任务
// 查找回库的任务起点,
var fromLocation = _unitwork.FindSingle<Location>(x => x.Code.Equals(task.ToLocation)).ContiguousCode;
newTask.ZoneCode = ZoneCodeEnum.盘料库;
if (task.TaskNo.Contains("PLoop"))
{
newTask.TaskNo = _unitwork.GetSerialNumber("PLoopin", 4);
}
else
{
newTask.TaskNo = _unitwork.GetSerialNumber("in", 4);
}
newTask.TaskType = TaskTypeEnum.盘料盒入库;
newTask.ContainerCode = containerCode;
newTask.FromLocation = fromLocation;
newTask.ToLocation = containerCode;
newTask.Status = TaskStatusEnum.待下发;
newTask.CreateTime = DateTime.Now;
_unitwork.Add(newTask);
//更新料塔占用
station.ContainerCode = "";
_unitwork.Update(station);
}
// 查询料塔 是否还有已下发,未完成的盘料入库任务
if (!task.TaskDetails.Any(x => x.Status < TaskStatusEnum.完成))
{
task.Status = TaskStatusEnum.完成;
}
break;
case TaskTypeEnum.盘料出库:
var lll = response.TaskId.Split("-")[1];
var taskde = task.TaskDetails.First(x => x.FromLocation == lll);
taskde.Status = TaskStatusEnum.完成;
//更新托盘物料数量
var container = _unitwork.Find<Location>(n => n.Code == task.ContainerCode).FirstOrDefault();
container.Width -= 1;
if (container.Width < 0) container.Width = 0;
_unitwork.Update(container);
//更新物料在料塔上的位置
var tolocation = _unitwork.Find<Location>(n => n.Code == task.ToLocation).FirstOrDefault();
var inv = _unitwork.Find<Inventory>(n => n.UniqueCode == taskde.UniqueCode
&& n.ContainerCode == task.ContainerCode
&& n.TaskStatus == InventoryTaskStatus.任务中).FirstOrDefault();
if (inv != null)
{
inv.ContainerCode = tolocation.ContainerCode;
inv.LocationCode = task.ToLocation;
inv.Lot = taskde.ToLocation;
_unitwork.Update(inv);
}
// 查询工位 是否还有已下发,未完成的盘料出库任务 有不操作,没有 创建料盒入库任务
if (!task.TaskDetails.Any(x => x.Status < TaskStatusEnum.完成))
{
task.Status = TaskStatusEnum.完成;
// 查找此托盘是否存在任务 如果有两个盘料出库的任务,不新建回库任务
var sameContainerCount = _unitwork.Find<TaskHeader>(x =>
x.TaskType.Equals(TaskTypeEnum.盘料出库)
&& x.ContainerCode.Equals(task.ContainerCode)).Count();
if (sameContainerCount > 1)
{
break;
}
// 查找回库的任务起点,
var fromLocation = _unitwork.FindSingle<Location>(x => x.Code.Equals(task.FromLocation)).ContiguousCode;
// 下发盘料盒回库任务,回原位
newTask.ZoneCode = ZoneCodeEnum.盘料库;
if (task.TaskNo.Contains("PLoop"))
{
newTask.TaskNo = _unitwork.GetSerialNumber("PLoopin", 4);
}
else
{
newTask.TaskNo = _unitwork.GetSerialNumber("in", 4);
}
newTask.TaskType = TaskTypeEnum.盘料盒入库;
newTask.ContainerCode = task.ContainerCode;
newTask.FromLocation = fromLocation;
newTask.ToLocation = task.ContainerCode;
newTask.Status = TaskStatusEnum.待下发;
newTask.CreateTime = DateTime.Now;
_unitwork.Add(newTask);
}
break;
default:
break;
}
if (task.TaskType == TaskTypeEnum.盘料盒入库
|| task.TaskType == TaskTypeEnum.散料盒入库)
{
var invList = _unitwork.Find<Inventory>(x => x.ContainerCode.Equals(task.ContainerCode)
&& x.TaskStatus.Equals(InventoryTaskStatus.任务中)
&& string.IsNullOrEmpty(x.SourceCode)
)
.ToList();
var listInvtran = new List<InventoryTransaction>();
foreach (var inv in invList)
{
listInvtran.Add(new InventoryTransaction
{
BillType = "in",
ZoneCode = inv.ZoneCode,
Type = inv.UniqueCode,
MaterialCode = inv.MaterialCode,
MaterialName = inv.MaterialName,
MaterialSpec = inv.MaterialSpec,
MaterialUnit = inv.MaterialUnit,
MaterialType = inv.MaterialType,
Batch = inv.Batch,
Lot = inv.Lot,
ContainerCode = task.ContainerCode,
CompanyCode = inv.CompanyCode,
LocationCode = inv.LocationCode,
SupplierCode = inv.SupplierCode,
Qty = inv.Qty,
CreateTime = DateTime.Now
});
}
_unitwork.BatchAdd(listInvtran.ToArray());
_unitwork.BatchUpdate<Inventory>(x => x.ContainerCode.Equals(task.ContainerCode)
&& string.IsNullOrEmpty(x.SourceCode),
x => new Inventory
{
LocationCode = tasktolocatioin.Code,
TaskStatus = InventoryTaskStatus.无任务,
UpdateTime = DateTime.Now,
UpdateBy = "wcs"
});
}
_unitwork.Update(task);
if (task.Status == TaskStatusEnum.完成)
{
_unitwork.Delete(task);
}
}
}
else
{
return ApiResult();
}
tran.Commit();
}
catch(Exception ex)
{
tran.Rollback();
return JsonMore(null, 500, ex.Message);
}
}
return ApiResult();
}
/// <summary>
/// 测试
/// </summary>
/// <param name="response"></param>
/// <returns></returns>
[HttpPost]
public IActionResult Test1(TaskResponse response)
{
var taskno = response.TaskId.Split("-")[0];
//wcs 任务反馈
var task = _unitwork.Find<TaskHeader>(x => x.TaskNo.Equals(taskno) && x.Status != TaskStatusEnum.完成).Include(x => x.TaskDetails).FirstOrDefault();
if (task != null)
{
if (task.Status != TaskStatusEnum.完成 && response.Result == (int)TaskStatusEnum.完成)
{
var newTask = new TaskHeader
{
TaskDetails = new List<TaskDetail>()
};
var tasktolocatioin = _unitwork.FindSingle<Location>(x => x.Code.Equals(task.ToLocation));
var taskfromlocatioin = _unitwork.FindSingle<Location>(x => x.Code.Equals(task.FromLocation));
switch (task.TaskType)
{
case TaskTypeEnum.盘料盒入库:
// 更新库位
// 起始库位为空
// 目标库位为有货
// 更新库存
task.Status = TaskStatusEnum.完成;
// 测试 创建料盒出库任务
newTask.ZoneCode = "L";
newTask.TaskNo = _unitwork.GetSerialNumber("out", 4);
newTask.TaskType = TaskTypeEnum.盘料盒出库;
newTask.ContainerCode = task.FromLocation;
newTask.FromLocation = task.ToLocation;
newTask.ToLocation = task.FromLocation;
newTask.Status = TaskStatusEnum.待下发;
//newTask.Station = task.Station;
_unitwork.Add(newTask);
break;
case TaskTypeEnum.盘料盒出库:
// 更新库位
// 起始库位为空
// 目标库位为有货
// 更新库存
task.Status = TaskStatusEnum.完成;
// 料盒出库是为了入,还是为了出 1是出,2是入
/*if (task.Station == "1")
{
}
else if (task.Station == "2")
{
}*/
// 测试 创建盘料出库任务
var locationList = _unitwork.Find<Location>(x => x.Row == tasktolocatioin.Row && "T,G2".Contains(x.Type)).ToList();
newTask.ZoneCode = "L";
newTask.TaskNo = _unitwork.GetSerialNumber("pout", 4);
newTask.TaskType = TaskTypeEnum.盘料出库;
newTask.ContainerCode = "L02";
newTask.FromLocation = locationList.First(x => x.Type.Equals("G2")).Code;
newTask.ToLocation = "L02";
newTask.Status = TaskStatusEnum.待下发;
for (int i = 1; i <= 10; i++)
{
newTask.TaskDetails.Add(new TaskDetail
{
UniqueCode = $"{newTask.TaskNo}-{i}",
FromLocation = i.ToString(),
ToLocation = i.ToString(),
Status = TaskStatusEnum.新建
});
}
_unitwork.Add(newTask);
break;
case TaskTypeEnum.盘料入库:
var ll = response.TaskId.Split("-")[1];
task.TaskDetails.First(x => x.FromLocation == ll).Status = TaskStatusEnum.完成;
// 查询料塔 是否还有已下发,未完成的盘料入库任务 有不操作,没有 创建料盒入库任务
if (!task.TaskDetails.Any(x => x.Status < TaskStatusEnum.完成))
{
task.Status = TaskStatusEnum.完成;
// 测试 创建料盒入库任务
var fromL = _unitwork.FindSingle<Location>(x => x.Row.Equals(tasktolocatioin.Row) && x.Type == "G1");
newTask.ZoneCode = "L";
newTask.TaskNo = _unitwork.GetSerialNumber("in", 4);
newTask.TaskType = TaskTypeEnum.盘料盒入库;
newTask.ContainerCode = fromL.Code;
newTask.FromLocation = fromL.Code;
newTask.ToLocation = "L01-02-01-01";
newTask.Status = TaskStatusEnum.待下发;
//newTask.Station = task.Station;
_unitwork.Add(newTask);
}
break;
case TaskTypeEnum.盘料出库:
var lll = response.TaskId.Split("-")[1];
task.TaskDetails.First(x => x.FromLocation == lll).Status = TaskStatusEnum.完成;
// 查询工位 是否还有已下发,未完成的盘料出库任务 有不操作,没有 创建料盒入库任务
if (!task.TaskDetails.Any(x => x.Status < TaskStatusEnum.完成))
{
task.Status = TaskStatusEnum.完成;
// 测试 创建盘料入库任务
var locationList1 = _unitwork.Find<Location>(x => x.Row == tasktolocatioin.Row && "T,G2".Contains(x.Type)).ToList();
newTask.ZoneCode = "L";
newTask.TaskNo = _unitwork.GetSerialNumber("pin", 4);
newTask.TaskType = TaskTypeEnum.盘料入库;
newTask.ContainerCode = locationList1.First(x => x.Type.Equals("T")).Code;
newTask.FromLocation = tasktolocatioin.Code;
newTask.ToLocation = taskfromlocatioin.Code;
newTask.Status = TaskStatusEnum.待下发;
for (int i = 1; i <= 10; i++)
{
newTask.TaskDetails.Add(new TaskDetail
{
UniqueCode = $"{newTask.TaskNo}-{i}",
FromLocation = i.ToString(),
ToLocation = i.ToString(),
Status = TaskStatusEnum.新建
});
}
_unitwork.Add(newTask);
}
break;
default:
break;
}
_unitwork.Update(task);
}
}
return ApiResult();
}
}
}