Files
zhougf 8606f7abcb 重写了 出库任务生成盒下发流程
修改了部分页面的查询条件
2024-05-16 02:38:16 +08:00

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;
}
}
}