754 lines
44 KiB
C#
754 lines
44 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.ComponentModel;
|
|
using System.ComponentModel.DataAnnotations;
|
|
using System.Linq;
|
|
using System.Threading.Tasks;
|
|
using HHWMS.Web.Models;
|
|
using Humanizer;
|
|
using Microsoft.EntityFrameworkCore;
|
|
using Newtonsoft.Json;
|
|
using Quartz;
|
|
using WalkingTec.Mvvm.Core;
|
|
using WalkingTec.Mvvm.Core.Support.Quartz;
|
|
using static HHWMS.Web.Controllers.ReceiptInOperationController;
|
|
|
|
namespace HHWMS.Web
|
|
{
|
|
//[QuartzRepeat(10,10, true, 30)]
|
|
//出库单据分解,为每个出库物料创建出库明细,状态为新建,通过唯一码绑定任务与库存
|
|
[PersistJobDataAfterExecution]
|
|
[DisallowConcurrentExecution]
|
|
public class SendWmsJob : WtmJob
|
|
{
|
|
public override Task Execute(IJobExecutionContext context)
|
|
{
|
|
try
|
|
{
|
|
var _unitwork = new UnitWork(Wtm);
|
|
|
|
var Shipments = _unitwork.Find<ShipmentHeader>(x => x.FirstStatus == ShipStatusEnum.分配中)
|
|
.Include(x => x.ShipmentDetails)
|
|
.Take(5)
|
|
.ToList();
|
|
|
|
List<Inventory> shiInventorys = new List<Inventory>();
|
|
using (var tran = Wtm.DC.Database.BeginTransaction())
|
|
{
|
|
try
|
|
{
|
|
foreach (var shipment in Shipments)
|
|
{
|
|
var shipmentDetails = shipment.ShipmentDetails
|
|
.Where(x => x.Status.Equals(ShipStatusEnum.新建)).ToList();
|
|
foreach (var shipmentDetail in shipmentDetails)
|
|
{
|
|
var inventorys = _unitwork.Find<Inventory>(x =>
|
|
x.UniqueCode == shipmentDetail.UniqueCode
|
|
&& x.TaskStatus == InventoryTaskStatus.无任务
|
|
&& x.ZoneCode != ZoneCodeEnum.货架库).ToList();
|
|
if (inventorys.Count <= 0)
|
|
{
|
|
continue;
|
|
}
|
|
|
|
foreach (var inventory in inventorys)
|
|
{
|
|
inventory.SourceCode = shipmentDetail.ShipmentHeader.Code;
|
|
inventory.TaskStatus = InventoryTaskStatus.任务中;
|
|
inventory.UpdateBy = "wmsjob";
|
|
inventory.UpdateTime = DateTime.Now;
|
|
|
|
_unitwork.Update(inventory);
|
|
shiInventorys.Add(inventory);
|
|
|
|
shipmentDetail.Status = ShipStatusEnum.分配完成;
|
|
}
|
|
|
|
shipmentDetail.UpdateTime = DateTime.Now;
|
|
shipmentDetail.UpdateBy = "wmsjob";
|
|
}
|
|
|
|
if (!shipment.ShipmentDetails.Any(x => x.Status < ShipStatusEnum.分配完成))
|
|
{
|
|
shipment.FirstStatus = ShipStatusEnum.分配完成;
|
|
}
|
|
else
|
|
{
|
|
shipment.FirstStatus = ShipStatusEnum.分配中;
|
|
}
|
|
|
|
shipment.UpdateBy = "wmsjob";
|
|
shipment.UpdateTime = DateTime.Now;
|
|
_unitwork.Update(shipment);
|
|
}
|
|
|
|
var inTaskContainerList = _unitwork.Find<TaskHeader>(x => x.TaskType == TaskTypeEnum.盘料盒入库
|
|
|| x.TaskType == TaskTypeEnum.盘料入库
|
|
|| x.TaskType == TaskTypeEnum.散料盒入库)
|
|
.Select(x => x.ContainerCode)
|
|
.ToList();
|
|
//出库库存通过托盘号分组
|
|
var lockInvs = _unitwork.Find<Inventory>(x => x.TaskStatus == InventoryTaskStatus.任务中
|
|
&& !"L01,L02".Contains(x.LocationCode)
|
|
&& !inTaskContainerList.Contains(x.LocationCode))
|
|
.ToList();
|
|
shiInventorys.AddRange(lockInvs);
|
|
//已生成任务的库存不再生成任务
|
|
var taskUniques = _unitwork.Find<TaskDetail>(x => x.Status >= TaskStatusEnum.新建)
|
|
.Select(x => x.UniqueCode).ToList();
|
|
var taskInvs = _unitwork.Find<Inventory>(x => taskUniques.Contains(x.UniqueCode)).ToList();
|
|
var newList = shiInventorys.Except(taskInvs).ToList();
|
|
newList = newList.DistinctBy(x => x.UniqueCode).ToList();
|
|
var inventoryList = newList.GroupBy(x => x.ContainerCode)
|
|
.ToList();
|
|
|
|
// 堆垛机工位点
|
|
var gLocDict = new Dictionary<int, dynamic>();
|
|
gLocDict.Add(1, new { Row = 1, GLoc = "L01-01-34-02", TLoc = "L01-02" });
|
|
gLocDict.Add(2, new { Row = 3, GLoc = "L01-02-34-02", TLoc = "L01-01" });
|
|
|
|
//散料库
|
|
if (inventoryList.Any(x => x.Key.Contains("C")))
|
|
{
|
|
foreach (var item in inventoryList.Where(x => x.Key.Contains("C")))
|
|
{
|
|
//出库托盘
|
|
Location location = _unitwork
|
|
.Find<Location>(x => x.Code == item.Key && x.Status != LocationStatus.任务锁)
|
|
.FirstOrDefault();
|
|
if (location == null)
|
|
{
|
|
continue;
|
|
}
|
|
|
|
// 查询目的地站台是否可用
|
|
var station = _unitwork.Find<Location>(x =>
|
|
x.Row == location.Row && x.Type == LocationTypeEnum.散料库站台 &&
|
|
string.IsNullOrWhiteSpace(x.ContainerCode)).FirstOrDefault();
|
|
if (station == null)
|
|
{
|
|
continue;
|
|
}
|
|
else
|
|
{
|
|
//判断是否已经有目的站台的出库任务
|
|
TaskHeader taskHeader = _unitwork.Find<TaskHeader>(x =>
|
|
x.ToLocation == station.Code && x.TaskType == TaskTypeEnum.散料盒出库)
|
|
.FirstOrDefault();
|
|
if (taskHeader != null)
|
|
{
|
|
continue;
|
|
}
|
|
|
|
// 创建任务
|
|
var task = new TaskHeader
|
|
{
|
|
ZoneCode = ZoneCodeEnum.散料库,
|
|
TaskNo = _unitwork.GetSerialNumber("SOut"),
|
|
TaskType = TaskTypeEnum.散料盒出库,
|
|
ContainerCode = item.Key,
|
|
FromLocation = location.ContainerCode,
|
|
ToLocation = station.Code,
|
|
Status = TaskStatusEnum.待下发,
|
|
Priority = 0,
|
|
CreateTime = DateTime.Now,
|
|
CreateBy = "wmsjob"
|
|
};
|
|
_unitwork.Add(task);
|
|
//更新库位状态
|
|
location.Status = LocationStatus.任务锁;
|
|
_unitwork.Update(location);
|
|
}
|
|
}
|
|
}
|
|
|
|
//盘料库
|
|
if (inventoryList.Any(x => x.Key.Contains("L")))
|
|
{
|
|
foreach (var item in inventoryList.Where(x => x.Key.Contains("L")))
|
|
{
|
|
#region new task flow
|
|
|
|
//判断是否存在此托盘入库任务
|
|
// 存在 跳过
|
|
if (_unitwork.IsExit<TaskHeader>(x =>
|
|
x.ContainerCode.Equals(item.Key)
|
|
&& (x.TaskType == TaskTypeEnum.盘料入库
|
|
|| x.TaskType == TaskTypeEnum.盘料盒入库)))
|
|
{
|
|
continue;
|
|
}
|
|
// 不用判断是否存在出库任务,可创建多个相同容器的盘料出库任务,存在盘料盒出库也无所谓
|
|
|
|
// 根据库存的库位信息,查找盘料出库的起点站台 堆垛机工位
|
|
var invLoc = _unitwork.FindSingle<Location>(x => x.Code == item.Key);
|
|
|
|
var taskHeader = new TaskHeader();
|
|
taskHeader.TaskDetails = new List<TaskDetail>();
|
|
|
|
taskHeader.ZoneCode = ZoneCodeEnum.盘料库;
|
|
taskHeader.TaskNo = _unitwork.GetSerialNumber("pout", 4);
|
|
taskHeader.TaskType = TaskTypeEnum.盘料出库;
|
|
taskHeader.Status = TaskStatusEnum.新建;
|
|
taskHeader.ContainerCode = item.Key;
|
|
taskHeader.Priority = 100;
|
|
taskHeader.FromLocation = gLocDict.First(x => x.Value.Row == invLoc.Row).Value.TLoc;
|
|
taskHeader.ToLocation = item.First().Flag == 8 ? "L01" : "L02";
|
|
taskHeader.CreateTime = DateTime.Now;
|
|
taskHeader.CreateBy = "wmsjob";
|
|
|
|
// 创建任务明细
|
|
foreach (var inventory in item)
|
|
{
|
|
if (!taskHeader.TaskDetails.Any(x => x.UniqueCode.Equals(inventory.UniqueCode)))
|
|
taskHeader.TaskDetails.Add(new TaskDetail
|
|
{
|
|
UniqueCode = inventory.UniqueCode,
|
|
Lot = $"{Convert.ToInt32(invLoc.Length)}-{taskHeader.ToLocation}",
|
|
FromLocation = inventory.Lot,
|
|
ToLocation = "",
|
|
Status = TaskStatusEnum.新建,
|
|
ContainerCode = inventory.ContainerCode,
|
|
CreateTime = DateTime.Now
|
|
});
|
|
}
|
|
|
|
_unitwork.Add(taskHeader);
|
|
|
|
#endregion
|
|
}
|
|
}
|
|
|
|
// 根据盘料出库,生成盘料盒出库任务,并更新盘料出库明细的 出库库位
|
|
var plcTaskList = _unitwork.Find<TaskHeader>(x =>
|
|
x.TaskType == TaskTypeEnum.盘料出库
|
|
&& x.Status == TaskStatusEnum.新建)
|
|
.Include(x => x.TaskDetails)
|
|
.ToList();
|
|
|
|
// 查询当前工位的状态
|
|
var workLocList = _unitwork.Find<Location>(x =>
|
|
"L01,L02,L01-01-34-02,L01-02-34-02".Contains(x.Code)
|
|
).ToList();
|
|
|
|
|
|
foreach (var plcTask in plcTaskList)
|
|
{
|
|
|
|
var lLoc = workLocList.First(x => x.Code.Equals(plcTask.ToLocation));
|
|
var container = _unitwork.FindSingle<Location>(x => x.Code.Equals(plcTask.ContainerCode));
|
|
|
|
// 判断是否已存在盘料盒出库任务,或者盘料盒已在堆垛机工位 L01-34-02/L02-34-02
|
|
var isOut = workLocList.Any(x => x.ContainerCode.Equals(plcTask.ContainerCode));
|
|
string toLocCode = gLocDict.First(x => x.Value.Row == container.Row).Value.GLoc;
|
|
|
|
// 存在去相同工位点的 盘料盒出库任务 跳过(保持一个工位只有一条盘料盒出库任务)
|
|
// 工位有货 也跳过
|
|
var c1 = _unitwork.IsExit<TaskHeader>(x =>
|
|
x.TaskType == TaskTypeEnum.盘料盒出库
|
|
&& x.ContainerCode != plcTask.ContainerCode
|
|
&& x.ToLocation == toLocCode);
|
|
var c2 = workLocList.Any(x => x.Code == toLocCode
|
|
&& !string.IsNullOrWhiteSpace(x.ContainerCode)
|
|
&& !x.ContainerCode.Equals(plcTask.ContainerCode));
|
|
if(c1 || c2)
|
|
continue;
|
|
|
|
if (!plcTask.TaskDetails.Any(x =>
|
|
x.Status == TaskStatusEnum.新建 && string.IsNullOrWhiteSpace(x.ToLocation))) continue;
|
|
|
|
if (_unitwork.IsExit<TaskHeader>(x =>
|
|
x.ContainerCode.Equals(plcTask.ContainerCode)
|
|
&& x.TaskType == TaskTypeEnum.盘料盒出库)
|
|
||
|
|
isOut
|
|
)
|
|
{
|
|
// 更新任务明细的 location ,status一般在盘料盒出库完成后更新为 待下发
|
|
// 1. 计算周转箱可用层数
|
|
var canUse = CalCanUse(Convert.ToInt32(lLoc.Length), plcTask.ToLocation, _unitwork);
|
|
foreach (var detail in plcTask.TaskDetails.Where(x => x.Status == TaskStatusEnum.新建
|
|
&& string.IsNullOrWhiteSpace(x.ToLocation)))
|
|
{
|
|
if (canUse.Length > 0)
|
|
{
|
|
// 2.更新目标库位
|
|
detail.ToLocation = canUse.First().ToString();
|
|
detail.UpdateTime = DateTime.Now;
|
|
|
|
canUse = canUse.Where(x => x != canUse.First()).ToArray();
|
|
}
|
|
else
|
|
{
|
|
break;
|
|
}
|
|
}
|
|
|
|
_unitwork.Update(plcTask);
|
|
}
|
|
else if (!isOut && !_unitwork.IsExit<TaskHeader>(x =>
|
|
x.ToLocation.Equals(toLocCode)))
|
|
{
|
|
// 不存在盘料盒出库任务,创建盘料盒出库任务
|
|
// 判断堆垛机工位是否有货,并且没有其他去该工位的盘料盒出库
|
|
|
|
var pTask = new TaskHeader
|
|
{
|
|
ZoneCode = ZoneCodeEnum.盘料库,
|
|
TaskNo = _unitwork.GetSerialNumber("Out"),
|
|
TaskType = TaskTypeEnum.盘料盒出库,
|
|
ContainerCode = plcTask.ContainerCode,
|
|
FromLocation = plcTask.ContainerCode,
|
|
ToLocation = toLocCode,
|
|
Station = "1",
|
|
Status = TaskStatusEnum.待下发,
|
|
Priority = 0,
|
|
CreateTime = DateTime.Now,
|
|
CreateBy = "wmsjob"
|
|
};
|
|
_unitwork.Add(pTask);
|
|
|
|
}
|
|
|
|
}
|
|
/*
|
|
var task = new TaskHeader();
|
|
task.TaskDetails = new List<TaskDetail>();
|
|
var inv = item.FirstOrDefault();
|
|
var location = _unitwork.Find<Location>(x => x.ContainerCode == item.Key
|
|
&& x.Status != LocationStatus.空仓位).FirstOrDefault();
|
|
//查询仓位表是否符合
|
|
if (location != null)
|
|
{
|
|
var row = 1;
|
|
if (inv.Flag == 8)
|
|
{
|
|
row = 3;
|
|
}
|
|
else if (inv.Flag == 24 || inv.Flag == 16 || inv.Flag == 10)
|
|
{
|
|
row = 1;
|
|
}
|
|
// 查找工位 G1
|
|
var gLoc = _unitwork.Find<Location>(x => x.ContainerCode == item.Key
|
|
&& x.Row == location.Row
|
|
&& x.Type.Equals(LocationTypeEnum.堆垛机工位)).FirstOrDefault();
|
|
var cTask = _unitwork.Find<TaskHeader>(x =>
|
|
x.ContainerCode.Equals(item.Key)
|
|
&& x.TaskType == TaskTypeEnum.盘料盒出库
|
|
).FirstOrDefault();
|
|
//查找料塔工位 T
|
|
var tLoc = _unitwork.Find<Location>(x => x.Row == row
|
|
&& x.Type.Equals(LocationTypeEnum.料塔))
|
|
.FirstOrDefault();
|
|
if(_unitwork.IsExit<TaskHeader>(x => x.FromLocation.Equals(tLoc.Code)))
|
|
{
|
|
continue;
|
|
}
|
|
//if (gLoc != null || cTask != null)
|
|
//{
|
|
// //盘料箱已在堆垛机工位,或者有此料箱的出库任务,直接生成盘料出库任务
|
|
//}
|
|
if (gLoc == null && cTask == null)
|
|
{
|
|
// 盘料箱在库内,工位为空,先生成料盘箱出库任务
|
|
|
|
gLoc = _unitwork.Find<Location>(x => string.IsNullOrEmpty(x.ContainerCode)
|
|
&& x.Row == location.Row
|
|
&& x.Type.Equals(LocationTypeEnum.堆垛机工位)).FirstOrDefault();
|
|
|
|
if (gLoc != null)
|
|
{
|
|
// 工位为空,先判断是否有去此工位的任务
|
|
var gTask = _unitwork.FindSingle<TaskHeader>(x => x.ToLocation.Equals(gLoc.Code));
|
|
if (gTask != null)
|
|
{
|
|
continue;
|
|
}
|
|
var pTask = new TaskHeader
|
|
{
|
|
ZoneCode = ZoneCodeEnum.盘料库,
|
|
TaskNo = _unitwork.GetSerialNumber("Out"),
|
|
TaskType = TaskTypeEnum.盘料盒出库,
|
|
ContainerCode = item.Key,
|
|
FromLocation = location.ContainerCode,
|
|
ToLocation = gLoc.Code,
|
|
Station = "1",
|
|
Status = TaskStatusEnum.待下发,
|
|
Priority = 0,
|
|
CreateTime = DateTime.Now,
|
|
CreateBy = "wmsjob"
|
|
};
|
|
_unitwork.Add(pTask);
|
|
}
|
|
}
|
|
|
|
if (gLoc != null || cTask != null)
|
|
{
|
|
//判断是否存在此托盘的出库任务
|
|
var containerTask = _unitwork.Find<TaskHeader>(x => x.Status < TaskStatusEnum.已下发
|
|
&& x.ContainerCode == item.Key
|
|
&& x.TaskType == TaskTypeEnum.盘料出库)
|
|
.Include(x => x.TaskDetails)
|
|
.FirstOrDefault();
|
|
if (containerTask != null)
|
|
{
|
|
tLoc = _unitwork.Find<Location>(x => x.Code == containerTask.ToLocation
|
|
&& x.Type.Equals(LocationTypeEnum.料塔))
|
|
.FirstOrDefault();
|
|
var canUse = CalCanUse(Convert.ToInt32(tLoc.Length), containerTask.ToLocation,_unitwork);
|
|
foreach (var inventory in item)
|
|
{
|
|
if (canUse.Length > 0)
|
|
{
|
|
// 库存不在已建任务明细中,新增任务明细
|
|
if (!containerTask.TaskDetails.Any(x => x.UniqueCode.Equals(inventory.UniqueCode)))
|
|
{
|
|
containerTask.TaskDetails.Add(new TaskDetail
|
|
{
|
|
UniqueCode = inventory.UniqueCode,
|
|
Lot = $"{Convert.ToInt32(location.Length)}-{tLoc.Code}",
|
|
FromLocation = inventory.Lot,
|
|
ToLocation = canUse.First().ToString(),
|
|
Status = TaskStatusEnum.待下发,
|
|
ContainerCode = inventory.ContainerCode,
|
|
CreateTime = DateTime.Now
|
|
});
|
|
canUse = canUse.Where(x => x != canUse.First()).ToArray();
|
|
}
|
|
//存在
|
|
else
|
|
{
|
|
var i = containerTask.TaskDetails.Where(x => x.UniqueCode == inventory.UniqueCode)
|
|
.FirstOrDefault();
|
|
if (string.IsNullOrEmpty(i.ToLocation))
|
|
{
|
|
i.Lot = $"{Convert.ToInt32(location.Length)}-{tLoc.Code}";
|
|
i.ToLocation = canUse.First().ToString();
|
|
i.Status = TaskStatusEnum.待下发;
|
|
canUse = canUse.Where(x => x != canUse.First()).ToArray();
|
|
}
|
|
}
|
|
}
|
|
else
|
|
{
|
|
// 库存不在已建任务明细中,新增任务明细
|
|
if (!containerTask.TaskDetails.Any(x => x.UniqueCode.Equals(inventory.UniqueCode)))
|
|
{
|
|
containerTask.TaskDetails.Add(new TaskDetail
|
|
{
|
|
UniqueCode = inventory.UniqueCode,
|
|
FromLocation = inventory.Lot,
|
|
Status = TaskStatusEnum.新建,
|
|
ContainerCode = inventory.ContainerCode,
|
|
CreateTime = DateTime.Now
|
|
});
|
|
}
|
|
}
|
|
}
|
|
containerTask.Status = TaskStatusEnum.待下发;
|
|
tLoc.ContainerCode = tLoc.Code;
|
|
_unitwork.Update(tLoc);
|
|
_unitwork.Update(containerTask);
|
|
}
|
|
else
|
|
{
|
|
// 新建盘料出库之前,判断此托盘是否存在此料盒的入库任务,如果有,不再新建盘料出库任务
|
|
var isExit = _unitwork.Find<TaskHeader>(x =>
|
|
x.TaskType == TaskTypeEnum.盘料盒入库
|
|
&& x.ContainerCode.Equals(task.ContainerCode)).Any();
|
|
if (isExit)
|
|
{
|
|
continue;
|
|
}
|
|
task.ZoneCode = ZoneCodeEnum.盘料库;
|
|
task.TaskNo = _unitwork.GetSerialNumber("pout", 4);
|
|
task.TaskType = TaskTypeEnum.盘料出库;
|
|
task.Status = TaskStatusEnum.待下发;
|
|
task.ContainerCode = item.Key;
|
|
task.Priority = 100;
|
|
task.FromLocation = _unitwork
|
|
.FindSingle<Location>(x => x.ContiguousCode == gLoc.Code)?.Code;
|
|
task.ToLocation = tLoc.Code;
|
|
task.CreateTime = DateTime.Now;
|
|
task.CreateBy = "wmsjob";
|
|
var canUse = CalCanUse(Convert.ToInt32(tLoc.Length), tLoc.Code, _unitwork);
|
|
foreach (var inventory in item)
|
|
{
|
|
if (canUse.Length > 0)
|
|
{
|
|
var detail = new TaskDetail
|
|
{
|
|
UniqueCode = inventory.UniqueCode,
|
|
Lot = $"{Convert.ToInt32(location.Length)}-{tLoc.Code}",
|
|
FromLocation = inventory.Lot,
|
|
ToLocation = canUse.First().ToString(),
|
|
Status = TaskStatusEnum.新建,
|
|
ContainerCode = inventory.ContainerCode,
|
|
CreateTime = DateTime.Now
|
|
};
|
|
task.TaskDetails.Add(detail);
|
|
canUse = canUse.Where(x => x != canUse.First()).ToArray();
|
|
}
|
|
else
|
|
{
|
|
task.TaskDetails.Add(new TaskDetail
|
|
{
|
|
UniqueCode = inventory.UniqueCode,
|
|
FromLocation = inventory.Lot,
|
|
Status = TaskStatusEnum.新建,
|
|
ContainerCode = inventory.ContainerCode,
|
|
CreateTime = DateTime.Now
|
|
});
|
|
}
|
|
}
|
|
_unitwork.Add(task);
|
|
//更新库位状态
|
|
var container = _unitwork.Find<Location>(x => x.ContainerCode == item.Key)
|
|
.FirstOrDefault();
|
|
if (container != null)
|
|
{
|
|
container.Status = LocationStatus.任务锁;
|
|
container.UpdateTime = DateTime.Now;
|
|
container.UpdateBy = "wmsjob";
|
|
_unitwork.Update(container);
|
|
}
|
|
|
|
tLoc.ContainerCode = tLoc.Code;
|
|
tLoc.UpdateBy = "wmsjob";
|
|
tLoc.UpdateTime = DateTime.Now;
|
|
_unitwork.Update(tLoc);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
*/
|
|
tran.Commit();
|
|
}
|
|
catch
|
|
{
|
|
tran.Rollback();
|
|
}
|
|
}
|
|
|
|
#region 更新时间
|
|
|
|
var job = _unitwork.FindSingle<SysJob>(x => x.JobName == context.JobDetail.Key.Name);
|
|
if (job != null)
|
|
{
|
|
job.LastFireTime =
|
|
TimeZoneInfo.ConvertTimeFromUtc(context.FireTimeUtc.DateTime, TimeZoneInfo.Local);
|
|
// 只执行一次 没有下次执行时间
|
|
if (context.NextFireTimeUtc != null)
|
|
{
|
|
job.NextFireTime = TimeZoneInfo.ConvertTimeFromUtc(context.NextFireTimeUtc.Value.DateTime,
|
|
TimeZoneInfo.Local);
|
|
}
|
|
|
|
_unitwork.Update<SysJob>(job);
|
|
}
|
|
|
|
Wtm.DoLog("出库分解", ActionLogTypesEnum.Job, "SendWmsJob");
|
|
|
|
#endregion 更新时间
|
|
}
|
|
catch(Exception ex)
|
|
{
|
|
Wtm.DoLog("出库分解", ActionLogTypesEnum.Job, "SendWmsJob", result:ex.Message);
|
|
}
|
|
return Task.CompletedTask;
|
|
}
|
|
|
|
// 根据库存明细,生成盘料出库任务
|
|
public void GenPlcTask(List<Inventory> invs, UnitWork _unitwork)
|
|
{
|
|
// 按盘料箱分组
|
|
var inventoryList = invs.GroupBy(x => x.ContainerCode)
|
|
.ToList();
|
|
foreach (var item in inventoryList)
|
|
{
|
|
var task = new TaskHeader();
|
|
task.TaskDetails = new List<TaskDetail>();
|
|
var inv = item.FirstOrDefault();
|
|
var location = _unitwork.Find<Location>(x => x.ContainerCode == item.Key
|
|
&& x.Status != LocationStatus.空仓位
|
|
&& x.Status != LocationStatus.空容器).FirstOrDefault();
|
|
//查询仓位表是否符合
|
|
if (location != null)
|
|
{
|
|
var row = 1;
|
|
if (inv.Flag == 8)
|
|
{
|
|
row = 3;
|
|
}
|
|
else if (inv.Flag == 24 || inv.Flag == 16 || inv.Flag == 10)
|
|
{
|
|
row = 1;
|
|
}
|
|
// 查找工位 G1
|
|
var gLoc = _unitwork.Find<Location>(x => x.ContainerCode == item.Key
|
|
&& x.Row == location.Row
|
|
&& x.Type.Equals(LocationTypeEnum.堆垛机工位))
|
|
.FirstOrDefault();
|
|
|
|
// gLoc != null 盘料箱已在堆垛机工位,直接生成盘料出库任务
|
|
|
|
if (gLoc == null)
|
|
{
|
|
// 盘料箱不在工位,先生成料盘箱出库任务
|
|
|
|
gLoc = _unitwork.Find<Location>(x => string.IsNullOrEmpty(x.ContainerCode)
|
|
&& x.Row == location.Row
|
|
&& x.Type.Equals(LocationTypeEnum.堆垛机工位))
|
|
.FirstOrDefault();
|
|
if (gLoc != null)
|
|
{
|
|
var pTask = new TaskHeader
|
|
{
|
|
ZoneCode = ZoneCodeEnum.盘料库,
|
|
TaskNo = _unitwork.GetSerialNumber("Out"),
|
|
TaskType = TaskTypeEnum.盘料盒出库,
|
|
ContainerCode = item.Key,
|
|
FromLocation = location.ContainerCode,
|
|
ToLocation = gLoc.Code,
|
|
Status = TaskStatusEnum.待下发,
|
|
Priority = 0,
|
|
CreateTime = DateTime.Now,
|
|
CreateBy = "wmsjob"
|
|
};
|
|
_unitwork.Add(pTask);
|
|
}
|
|
else
|
|
{
|
|
// 找不到工位,直接跳出
|
|
return;
|
|
}
|
|
}
|
|
// 新建盘料盒出库任务
|
|
if (gLoc != null)
|
|
{
|
|
//查找料塔工位 T
|
|
var tLoc = _unitwork.Find<Location>(x => string.IsNullOrEmpty(x.ContainerCode)
|
|
&& x.Row == row
|
|
&& x.Type.Equals(LocationTypeEnum.料塔))
|
|
.FirstOrDefault();
|
|
|
|
//查询料塔是否为空
|
|
if (tLoc == null)
|
|
{
|
|
//判断是否存在此托盘的出库任务
|
|
var containerTask = _unitwork.Find<TaskHeader>(x => x.Status < TaskStatusEnum.已下发
|
|
&& x.ContainerCode == item.Key
|
|
&& x.TaskType == TaskTypeEnum.盘料出库)
|
|
.Include(x => x.TaskDetails)
|
|
.FirstOrDefault();
|
|
if (containerTask != null)
|
|
{
|
|
tLoc = _unitwork.Find<Location>(x => x.Code == containerTask.ToLocation
|
|
&& x.Type.Equals(LocationTypeEnum.料塔))
|
|
.FirstOrDefault();
|
|
foreach (var inventory in item)
|
|
{
|
|
if (tLoc.Height < tLoc.Length)
|
|
{
|
|
var detail = new TaskDetail
|
|
{
|
|
UniqueCode = inventory.UniqueCode,
|
|
Lot = $"{Convert.ToInt32(location.Length)}-{tLoc.Code}",
|
|
FromLocation = inventory.Lot,
|
|
ToLocation = (Convert.ToInt32(tLoc.Height) + 1).ToString(),
|
|
Status = TaskStatusEnum.新建,
|
|
ContainerCode = inventory.ContainerCode,
|
|
CreateTime = DateTime.Now
|
|
};
|
|
tLoc.Height += 1;
|
|
containerTask.Status = TaskStatusEnum.待下发;
|
|
containerTask.TaskDetails.Add(detail);
|
|
}
|
|
else
|
|
{
|
|
break;
|
|
}
|
|
}
|
|
_unitwork.Update(tLoc);
|
|
_unitwork.Update(containerTask);
|
|
}
|
|
else
|
|
{
|
|
continue;
|
|
}
|
|
}
|
|
else if (tLoc != null)
|
|
{
|
|
task.ZoneCode = ZoneCodeEnum.盘料库;
|
|
task.TaskNo = _unitwork.GetSerialNumber("pout", 4);
|
|
task.TaskType = TaskTypeEnum.盘料出库;
|
|
task.Status = TaskStatusEnum.待下发;
|
|
task.ContainerCode = item.Key;
|
|
task.Priority = 100;
|
|
task.FromLocation = _unitwork
|
|
.FindSingle<Location>(x => x.ContiguousCode == gLoc.Code)?.Code;
|
|
task.ToLocation = tLoc.Code;
|
|
task.CreateTime = DateTime.Now;
|
|
task.CreateBy = "wmsjob";
|
|
foreach (var inventory in item)
|
|
{
|
|
if (tLoc.Height < tLoc.Length)
|
|
{
|
|
var detail = new TaskDetail
|
|
{
|
|
UniqueCode = inventory.UniqueCode,
|
|
Lot = $"{Convert.ToInt32(location.Length)}-{tLoc.Code}",
|
|
FromLocation = inventory.Lot,
|
|
ToLocation = (Convert.ToInt32(tLoc.Height) + 1).ToString(),
|
|
Status = TaskStatusEnum.新建,
|
|
ContainerCode = inventory.ContainerCode,
|
|
CreateTime = DateTime.Now
|
|
};
|
|
task.TaskDetails.Add(detail);
|
|
tLoc.Height += 1;
|
|
}
|
|
else
|
|
{
|
|
break;
|
|
}
|
|
}
|
|
_unitwork.Add(task);
|
|
//更新库位状态
|
|
var container = _unitwork.Find<Location>(x => x.ContainerCode == item.Key)
|
|
.FirstOrDefault();
|
|
if (container != null)
|
|
{
|
|
container.Status = LocationStatus.任务锁;
|
|
container.UpdateTime = DateTime.Now;
|
|
container.UpdateBy = "wmsjob";
|
|
_unitwork.Update(container);
|
|
}
|
|
|
|
tLoc.ContainerCode = tLoc.Code;
|
|
tLoc.UpdateBy = "wmsjob";
|
|
tLoc.UpdateTime = DateTime.Now;
|
|
_unitwork.Update(tLoc);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
public int[] CalCanUse(int length, string code, UnitWork _unitwork)
|
|
{
|
|
var used1 = _unitwork.Find<Inventory>(x => x.LocationCode.Equals(code))
|
|
.Select(x => int.Parse(x.Lot)).ToArray();
|
|
var used2 = _unitwork.Find<TaskDetail>(x => x.Lot.Contains(code)
|
|
&& !string.IsNullOrWhiteSpace(x.ToLocation))
|
|
.Select(x => int.Parse(x.ToLocation)).ToArray();
|
|
var used = used1.Union(used2);
|
|
var caseList = Enumerable.Range(1, length).ToArray();
|
|
var canUse = caseList.Except(used).ToArray<int>();
|
|
return canUse;
|
|
}
|
|
}
|
|
}
|