using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Security.Cryptography.Xml;
|
using System.Text;
|
using System.Threading.Tasks;
|
using WIDESEA_Comm;
|
using WIDESEA_Comm.LogInfo;
|
using WIDESEA_Comm.TaskNo;
|
using WIDESEA_Core.EFDbContext;
|
using WIDESEA_Core.Extensions;
|
using WIDESEA_Entity.DomainModels;
|
using WIDESEA_WCS.IRepositories;
|
using WIDESEA_WCS.Repositories;
|
using WIDESEA_WMS.IRepositories;
|
using WIDESEA_WMS.Repositories;
|
using static FreeSql.Internal.GlobalFilter;
|
using static System.Collections.Specialized.BitVector32;
|
|
namespace WIDESEA_WCS.JobsPart.Common
|
{
|
public class OutboundTask
|
{
|
/// <summary>
|
/// 创建出库任务
|
/// </summary>
|
public static void CreateOutboundTask()
|
{
|
try
|
{
|
VOLContext context = new VOLContext();
|
Idt_stationinfoRepository stationinfoRepository = new dt_stationinfoRepository(context);
|
Idt_mes_headRepository mes_HeadRepository = new dt_mes_headRepository(context);
|
Idt_mes_detailRepository mes_DetailRepository = new dt_mes_detailRepository(context);
|
Idt_inventoryRepository inventoryRepository = new dt_inventoryRepository(context);
|
Idt_agvtaskRepository agvtaskRepository = new dt_agvtaskRepository(context);
|
|
var mes_heads = mes_HeadRepository.Find(x => x.processCode == "28").OrderBy(x => x.expectedStartTime).ToList();
|
//var mes_heads = mes_HeadRepository.Find(x => x.processCode == "28").OrderByDescending(x => x.CreateTime).ToList();
|
foreach (var mes_head in mes_heads)
|
{
|
#region 根据库存入库时间最晚查询
|
var inventory = inventoryRepository.Find(x => x.FigureNumber == mes_head.drawingNo).OrderByDescending(x => x.OnlineTime).FirstOrDefault();
|
if (inventory != null)
|
{
|
var Station = stationinfoRepository.Find(x => x.stationCode == inventory.stationCode).FirstOrDefault();
|
if (Station != null)
|
{
|
#region 存在入库任务不能出库
|
var InTask = stationinfoRepository.Find(x => x.line == Station.line && x.area == Station.area && x.location_state == LocationStateEnum.InBusy.ToString()).Any();
|
if (InTask) continue;
|
#endregion
|
var stationinfo = stationinfoRepository.Find(x => x.line == Station.line && x.area == Station.area && x.enable && x.location_state == LocationStateEnum.Stroge.ToString()).OrderByDescending(x => x.column).FirstOrDefault();
|
if (stationinfo != null)
|
{
|
if (string.IsNullOrEmpty(stationinfo.bindSN))
|
{
|
stationinfo.remark = "车轮SN号信息异常";
|
stationinfo.location_state = "Abnormal";
|
stationinfoRepository.Update(stationinfo, true);
|
continue;
|
//throw new Exception(stationinfo.stationCode + "车轮SN号信息异常!");
|
}
|
if (agvtaskRepository.Find(x => x.agv_fromaddress == stationinfo.stationCode).Any())
|
continue;
|
List<string> lists = new List<string>();
|
var SNS = stationinfo.bindSN.Split(",");
|
foreach (var SN in SNS)
|
{
|
if (!string.IsNullOrEmpty(SN))
|
lists.Add(SN);
|
}
|
foreach (var item in lists)
|
{
|
//var a = mes_DetailRepository.Find(x => x.jobID == mes_head.jobID /*&& x.SN == item*/).ToList();
|
//var b = a.Where(x => x.SN == item).FirstOrDefault();
|
|
if (mes_DetailRepository.Find(x => x.jobID == mes_head.jobID && x.SN == item).Any())
|
{
|
dt_agvtask agvtask = new dt_agvtask()
|
{
|
agv_fromaddress = stationinfo.stationCode,
|
agv_id = Guid.NewGuid(),
|
agv_tasknum = IdenxManager.GetTaskNo("KH-", "WMS"),
|
agv_grade = 2,
|
agv_createtime = DateTime.Now,
|
agv_taskstate = "Queue",
|
agv_materielid = stationinfo.stationType,
|
agv_qty = stationinfo.quantity,
|
agv_tasktype = "TaskType_Outbound",
|
agv_toaddress = "",
|
agv_userid = "系统",
|
bindSN = stationinfo.bindSN,
|
jobID = mes_head.jobID,
|
agv_worktype = Convert.ToInt32(mes_head.processCode),
|
agv_materbarcode = mes_head.materialCode,
|
agv_Traytype = stationinfo.tray_type,
|
agv_TrayStatus = stationinfo.tray_status
|
};
|
stationinfo.location_state = LocationStateEnum.OutBusy.ToString();
|
stationinfoRepository.Update(stationinfo, true);
|
agvtaskRepository.Add(agvtask, true);
|
WriteDBLog.Success("创建出库任务", $"任务编号：{agvtask.agv_tasknum}", "PCS");
|
return;
|
}
|
}
|
}
|
var stationinfos = stationinfoRepository.Find(x => x.stationType == mes_head.drawingNo && x.line != Station.line && x.area == Station.area && x.location_state == "Stroge").OrderBy(x => x.line).ThenByDescending(x => x.column).ToList();
|
foreach (var item in stationinfos)
|
{
|
if (item != null && stationinfo.enable)
|
{
|
if (item.bindSN == null)
|
{
|
stationinfo.remark = "车轮SN号信息异常";
|
stationinfo.location_state = "Abnormal";
|
stationinfoRepository.Update(stationinfo, true);
|
continue;
|
}
|
if (agvtaskRepository.Find(x => x.agv_fromaddress == stationinfo.stationCode).Any())
|
continue;
|
List<string> lists = new List<string>();
|
var SNS = stationinfo.bindSN.Split(",");
|
foreach (var SN in SNS)
|
{
|
if (!string.IsNullOrEmpty(SN))
|
lists.Add(SN);
|
}
|
foreach (var list in lists)
|
{
|
if (mes_DetailRepository.Find(x => x.jobID == mes_head.jobID && x.SN == list).Any())
|
{
|
dt_agvtask agvtask = new dt_agvtask()
|
{
|
agv_fromaddress = stationinfo.stationCode,
|
agv_id = Guid.NewGuid(),
|
agv_tasknum = IdenxManager.GetTaskNo("KH-", "WMS"),
|
agv_grade = 1,
|
agv_createtime = DateTime.Now,
|
agv_taskstate = "Queue",
|
agv_materielid = stationinfo.stationType,
|
agv_qty = stationinfo.quantity,
|
jobID = mes_head.jobID,
|
agv_tasktype = "TaskType_Outbound",
|
agv_toaddress = "",
|
agv_userid = "系统",
|
bindSN = stationinfo.bindSN,
|
agv_worktype = Convert.ToInt32(mes_head.processCode),
|
agv_materbarcode = mes_head.materialCode,
|
agv_Traytype = stationinfo.tray_type,
|
agv_TrayStatus = stationinfo.tray_status
|
};
|
WriteDBLog.Success("创建出库任务", $"任务编号：{agvtask.agv_tasknum}", "PCS");
|
agvtaskRepository.Add(agvtask, true);
|
return;
|
}
|
}
|
}
|
}
|
|
#region MyRegion
|
//if (stationinfo != null && stationinfo.enable)
|
//{
|
// if (stationinfo.bindSN == null)
|
// throw new Exception(stationinfo.stationCode + "车轮SN号信息异常!");
|
// List<string> lists = new List<string>();
|
// var SNS = stationinfo.bindSN.Split(",");
|
// foreach (var SN in SNS)
|
// {
|
// if (!string.IsNullOrEmpty(SN))
|
// lists.Add(SN);
|
// }
|
// foreach (var item in lists)
|
// {
|
// if (freeDB.Select<dt_mes_detail>().Where(x => x.jobID == mes_head.jobID && x.SN == item).Any())
|
// {
|
// dt_agvtask agvtask = new dt_agvtask()
|
// {
|
// agv_fromaddress = stationinfo.stationCode,
|
// agv_id = Guid.NewGuid(),
|
// agv_tasknum = IdenxManager.GetTaskNo("KH-", "WMS"),
|
// agv_grade = 1,
|
// agv_createtime = DateTime.Now,
|
// agv_taskstate = "Queue",
|
// agv_materielid = stationinfo.stationType,
|
// agv_qty = stationinfo.quantity,
|
// agv_tasktype = "TaskType_Outbound",
|
// agv_toaddress = "",
|
// agv_userid = "系统",
|
// bindSN = stationinfo.bindSN,
|
// agv_worktype = Convert.ToInt32(mes_head.processCode),
|
// agv_materbarcode = mes_head.materialCode,
|
// agv_Traytype = stationinfo.tray_type,
|
// agv_TrayStatus = stationinfo.tray_status
|
// };
|
// dt_stationinfo TargetLocation = GetEmptyLocation(stationinfoRepository);
|
// if (TargetLocation != null)
|
// {
|
// agvtask.agv_taskstate = "Create";
|
// agvtask.agv_toaddress = TargetLocation.stationCode;
|
// TargetLocation.location_state = LocationStateEnum.Busy.ToString();
|
// freeDB.Update(TargetLocation);
|
// }
|
// freeDB.Add(agvtask);
|
// return;
|
// }
|
// }
|
//}
|
#endregion
|
}
|
}
|
#endregion
|
|
#region MyRegion
|
//var station = stationinfoRepository.Find(x => x.stationType == mes_head.drawingNo && x.line != x.line).OrderBy(x => x.line).ThenByDescending(x => x.column).FirstOrDefault();
|
//bool ok = false;
|
//List<string> list = new List<string>();
|
//if (station != null && station.location_state == LocationStateEnum.Stroge.ToString() && station.enable)
|
//{
|
// var SNS = station.bindSN.Split(",");
|
// foreach (var SN in SNS)
|
// {
|
// if (!string.IsNullOrEmpty(SN))
|
// list.Add(SN);
|
// }
|
//}
|
//foreach (var SN in list)
|
//{
|
// if (ok = freeDB.Select<dt_mes_detail>().Where(x => x.jobID == mes_head.jobID && x.SN == SN).Any()) continue;
|
//}
|
//if (ok)
|
//{
|
// dt_agvtask agvtask = new dt_agvtask()
|
// {
|
// agv_fromaddress = station.stationCode,
|
// agv_id = Guid.NewGuid(),
|
// agv_tasknum = IdenxManager.GetTaskNo("KH-", "WMS"),
|
// agv_grade = 1,
|
// agv_createtime = DateTime.Now,
|
// agv_taskstate = "Queue",
|
// agv_materielid = station.stationType,
|
// agv_qty = station.quantity,
|
// agv_tasktype = "TaskType_Outbound",
|
// agv_toaddress = "",
|
// agv_userid = "系统",
|
// bindSN = station.bindSN,
|
// agv_worktype = Convert.ToInt32(mes_head.processCode),
|
// agv_materbarcode = mes_head.materialCode,
|
// agv_barcode = station.tray_type
|
// };
|
// dt_stationinfo TargetLocation = GetEmptyLocation(stationinfoRepository);
|
// if (TargetLocation != null)
|
// {
|
// agvtask.agv_taskstate = "Create";
|
// agvtask.agv_toaddress = TargetLocation.stationCode;
|
// TargetLocation.location_state = LocationStateEnum.Busy.ToString();
|
// freeDB.Update(TargetLocation);
|
// }
|
// freeDB.Add(agvtask);
|
//}
|
#endregion
|
|
}
|
}
|
catch (Exception ex)
|
{
|
WriteDBLog.Error("创建出库任务", $"错误信息：{ex.Message}", "PCS");
|
}
|
}
|
|
}
|
}
|
