using Autofac.Core;
|
using Microsoft.IdentityModel.Tokens;
|
using Newtonsoft.Json;
|
using OfficeOpenXml.FormulaParsing.Excel.Functions.RefAndLookup;
|
using SqlSugar;
|
using System;
|
using System.Collections;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Reflection.Metadata;
|
using System.Text;
|
using System.Text.RegularExpressions;
|
using System.Threading.Tasks;
|
using WIDESEA_Common.CommonEnum;
|
using WIDESEA_Common.LocationEnum;
|
using WIDESEA_Common.MaterielEnum;
|
using WIDESEA_Common.OrderEnum;
|
using WIDESEA_Common.StockEnum;
|
using WIDESEA_Common.TaskEnum;
|
using WIDESEA_Common.WareHouseEnum;
|
using WIDESEA_Core;
|
using WIDESEA_Core.Helper;
|
using WIDESEA_DTO;
|
using WIDESEA_DTO.Basic;
|
using WIDESEA_DTO.ERP;
|
using WIDESEA_DTO.MES;
|
using WIDESEA_DTO.Task;
|
using WIDESEA_External.Model;
|
using WIDESEA_Model.Models;
|
using WIDESEA_TaskInfoRepository;
|
|
namespace WIDESEA_TaskInfoService
|
{
|
public partial class TaskService
|
{
|
/// <summary>
|
/// 仅申请任务，让WCS根据路由确定下一地址
|
/// </summary>
|
/// <param name="stationCode"></param>
|
/// <param name="palletCode"></param>
|
/// <returns></returns>
|
public WebResponseContent DeviceRequestInboundTaskSimple(string stationCode, string palletCode)
|
{
|
try
|
{
|
Dt_Task task = Repository.QueryFirst(x => x.PalletCode == palletCode);
|
if (task != null)
|
{
|
PushTasksToWCS(new List<Dt_Task> { task });
|
return WebResponseContent.Instance.OK($"该托盘已生成任务", _mapper.Map<WMSTaskDTO>(task));
|
}
|
|
if (Repository.QueryFirst(x => x.SourceAddress == stationCode && x.TaskStatus == TaskStatusEnum.New.ObjToInt()) != null)
|
{
|
return WebResponseContent.Instance.Error($"该站点已有未执行的任务");
|
}
|
|
Dt_StockInfo stockInfo = _stockRepository.StockInfoRepository.QueryFirst(x => x.PalletCode == palletCode);
|
if (stockInfo == null)
|
{
|
return WebResponseContent.Instance.Error($"未找到组盘信息");
|
}
|
if (stockInfo.StockStatus != StockStatusEmun.MES余料退库.ObjToInt() && stockInfo.StockStatus != StockStatusEmun.MES空托退库.ObjToInt())
|
{
|
return WebResponseContent.Instance.Error($"该托盘状态不正确,不可申请入库");
|
}
|
if (!string.IsNullOrEmpty(stockInfo.LocationCode))
|
{
|
return WebResponseContent.Instance.Error($"该托盘已绑定货位");
|
}
|
|
Dt_Task newTask = new Dt_Task()
|
{
|
CurrentAddress = stationCode,
|
Grade = 0,
|
NextAddress = "",
|
PalletCode = palletCode,
|
Roadway = "",
|
SourceAddress = stationCode,
|
TargetAddress = "",
|
TaskType = TaskTypeEnum.Inbound.ObjToInt(),
|
TaskStatus = TaskStatusEnum.New.ObjToInt(),
|
WarehouseId = stockInfo.WarehouseId,
|
PalletType = stockInfo.PalletType,
|
};
|
|
|
if (stockInfo.StockStatus == StockStatusEmun.手动组盘暂存.ObjToInt())
|
{
|
stockInfo.StockStatus = StockStatusEmun.手动组盘入库确认.ObjToInt();
|
}
|
else
|
{
|
stockInfo.StockStatus = StockStatusEmun.入库确认.ObjToInt();
|
}
|
|
_unitOfWorkManage.BeginTran();
|
int taskId = BaseDal.AddData(newTask);
|
newTask.TaskId = taskId;
|
_stockRepository.StockInfoRepository.UpdateData(stockInfo);
|
_unitOfWorkManage.CommitTran();
|
WMSTaskDTO wMSTaskDTO = _mapper.Map<WMSTaskDTO>(newTask);
|
|
PushTasksToWCS(new List<Dt_Task> { newTask });
|
if (newTask.WarehouseId == 5) PutFinish(stationCode, newTask.PalletCode, newTask.TaskNum.ToString());
|
return WebResponseContent.Instance.OK(data: wMSTaskDTO);
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
return WebResponseContent.Instance.Error(ex.Message);
|
}
|
}
|
/// <summary>
|
/// 原料申请入库
|
/// </summary>
|
/// <param name="stationCode">起始站点</param>
|
/// <param name="palletCode">托盘</param>
|
/// <returns></returns>
|
public WebResponseContent RequestYLWMSTaskSimple(string stationCode, string palletCode)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
Dt_StockInfo stockInfo = _stockRepository.StockInfoRepository.QueryFirst(x => x.RfidCode == palletCode);
|
if (stockInfo == null)
|
{
|
return content.Error($"未找到组盘信息");
|
}
|
Dt_Task task = Repository.QueryFirst(x => x.PalletCode == stockInfo.PalletCode);
|
if (task != null)
|
{
|
PushTasksToWCS(new List<Dt_Task> { task });
|
return content.OK($"该托盘已生成任务", _mapper.Map<WMSTaskDTO>(task));
|
}
|
|
if (Repository.QueryFirst(x => x.SourceAddress == stationCode && x.TaskStatus == TaskStatusEnum.New.ObjToInt()) != null)
|
{
|
return content.Error($"该站点已有未执行的任务");
|
}
|
if (stockInfo.StockStatus != StockStatusEmun.手动组盘暂存.ObjToInt() && stockInfo.StockStatus != StockStatusEmun.组盘暂存.ObjToInt() && stockInfo.StockStatus != StockStatusEmun.老厂退库.ObjToInt() && stockInfo.StockStatus != StockStatusEmun.博思通组盘暂存.ObjToInt())
|
{
|
return content.Error($"该托盘状态不正确,不可申请入库");
|
}
|
//分配巷道
|
string rowWay = AssignYLRoadwayNo(stockInfo.PalletCode);
|
if (string.IsNullOrEmpty(rowWay))
|
{
|
return content.Error($"未找到可分配巷道");
|
}
|
//生成任务
|
Dt_Task newTask = new Dt_Task()
|
{
|
CurrentAddress = stationCode,
|
Grade = 0,
|
NextAddress = "",
|
PalletCode = stockInfo.PalletCode,
|
RfidCode=stockInfo.RfidCode,
|
Roadway = rowWay,
|
SourceAddress = stationCode,
|
TargetAddress = "",
|
TaskType = stationCode=="307" ? TaskTypeEnum.PaperOldYLBackInbound.ObjToInt() : TaskTypeEnum.Inbound.ObjToInt(),
|
TaskStatus = TaskStatusEnum.New.ObjToInt(),
|
WarehouseId = stockInfo.WarehouseId,
|
PalletType = stockInfo.PalletType,
|
TaskLength = (int)stockInfo.MaterielWide
|
};
|
//更新状态
|
if (stockInfo.StockStatus == StockStatusEmun.手动组盘暂存.ObjToInt())
|
{
|
stockInfo.StockStatus = StockStatusEmun.手动组盘入库确认.ObjToInt();
|
}
|
else
|
{
|
stockInfo.StockStatus = StockStatusEmun.入库确认.ObjToInt();
|
}
|
//数据更新
|
_unitOfWorkManage.BeginTran();
|
int taskId = BaseDal.AddData(newTask);
|
newTask.TaskId = taskId;
|
_stockRepository.StockInfoRepository.UpdateData(stockInfo);
|
_unitOfWorkManage.CommitTran();
|
PushTasksToWCS(new List<Dt_Task> { newTask });
|
WMSTaskDTO wMSTaskDTO = _mapper.Map<WMSTaskDTO>(newTask);
|
return content.OK(data: wMSTaskDTO);
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
private readonly static object lockerYLBoxing = new object();
|
/// <summary>
|
/// 原料请求
|
/// </summary>
|
/// <param name="palletCode">RFID信息</param>
|
/// <returns></returns>
|
public WebResponseContent YLPurchaseBoxing(string palletCode, decimal weight = 0, decimal thickness = 0, decimal wide = 0)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
lock (lockerYLBoxing)
|
{
|
Dt_StockInfo stockInfoOld = _stockRepository.StockInfoRepository.QueryFirst(x => x.RfidCode == palletCode);
|
if (stockInfoOld != null && stockInfoOld.StockStatus == StockStatusEmun.手动组盘暂存.ObjToInt())
|
{
|
UpdateStock(stockInfoOld, weight, thickness, wide);
|
return content.OK($"临时入库{stockInfoOld.RfidCode}");
|
}
|
else if (stockInfoOld != null && stockInfoOld.MaterielInvOrgId == MaterielInvOrgEnum.老厂.ObjToInt() && stockInfoOld.StockStatus == StockStatusEmun.老厂退库.ObjToInt())
|
{
|
UpdateStock(stockInfoOld, weight, thickness, wide);
|
return content.OK($"老厂退库{stockInfoOld.RfidCode}");
|
}
|
else if (stockInfoOld != null)
|
{
|
return content.Error("RFID信息已存在");
|
}
|
#region 处理采购绑定RFID逻辑
|
Dt_YLInboundCache? yLInboundCache = _inboundRepository.YLInboundCacheRepository.QueryData(x => x.InvOrg == MaterielInvOrgEnum.老厂.ToString()).FirstOrDefault();
|
if (yLInboundCache == null)
|
{
|
return content.Error("未找到原料缓存条码信息");
|
}
|
if (yLInboundCache.BindStatus == WhetherEnum.True.ObjToInt())
|
{
|
return content.Error($"原料缓存条码{yLInboundCache.BarCode}已绑定RFID{yLInboundCache.RfidCode}");
|
}
|
else
|
{
|
Dt_StockInfo ExistStockInfo = _stockRepository.StockInfoRepository.QueryFirst(x => x.PalletCode == yLInboundCache.BarCode);
|
if (ExistStockInfo != null && ExistStockInfo.MaterielInvOrgId == MaterielInvOrgEnum.老厂.ObjToInt() && ExistStockInfo.StockStatus == StockStatusEmun.博思通组盘暂存.ObjToInt())
|
{
|
yLInboundCache.RfidCode = palletCode;
|
yLInboundCache.BindStatus = WhetherEnum.True.ObjToInt();
|
ExistStockInfo.RfidCode = palletCode;
|
_unitOfWorkManage.BeginTran();
|
//更新组盘信息
|
UpdateStock(ExistStockInfo, weight, thickness, wide);
|
_inboundRepository.YLInboundCacheRepository.UpdateData(yLInboundCache);
|
_unitOfWorkManage.CommitTran();
|
return content.OK($"博思通库存转存{ExistStockInfo.RfidCode}");
|
}
|
else
|
{
|
//获取采购信息
|
Dt_PurchaseBSTOrderDetail purchaseBSTOrderDetail = _purchaseBSTOrderDetailRepository.QueryFirst(x => x.Barcode == yLInboundCache.BarCode);
|
if (purchaseBSTOrderDetail == null)
|
{
|
return content.Error($"未找到条码{yLInboundCache.BarCode}采购信息");
|
}
|
if (purchaseBSTOrderDetail.PurchaseBSTOrderDetailStatus != InOrderStatusEnum.未开始.ObjToInt())
|
{
|
return content.Error($"采购{purchaseBSTOrderDetail.Barcode}信息已入库或入库中");
|
}
|
else
|
{
|
purchaseBSTOrderDetail.PurchaseBSTOrderDetailStatus = InOrderStatusEnum.入库中.ObjToInt();
|
purchaseBSTOrderDetail.RfidCode = palletCode;
|
}
|
//获取采购主单
|
Dt_PurchaseBSTOrder purchaseBSTOrder = _purchaseBSTOrderRepository.QueryFirst(x => x.Id == purchaseBSTOrderDetail.PurchaseBSTOrderId);
|
//获取物料
|
Dt_MaterielInfo materielInfo = _basicRepository.MaterielInfoRepository.QueryFirst(x => x.MaterialSourceId == purchaseBSTOrderDetail.MaterialId);
|
//生成库存组盘信息
|
Dt_StockInfo stockInfo = new Dt_StockInfo()
|
{
|
MaterielInvOrgId = materielInfo.MaterielInvOrgId,
|
PalletCode = purchaseBSTOrderDetail.Barcode,
|
RfidCode = palletCode,
|
LocationCode = "",
|
PalletType = 1,
|
WarehouseId = materielInfo.WarehouseId,
|
StockAttribute = materielInfo.MaterielSourceType,
|
StockStatus = StockStatusEmun.组盘暂存.ObjToInt(),
|
MaterielSpec = materielInfo.MaterielSpec,
|
Unit = materielInfo.MaterielUnit,
|
MaterielThickness = purchaseBSTOrderDetail.MaterialThick,
|
MaterielWide = purchaseBSTOrderDetail.MaterialWide,
|
MaterielWeight = purchaseBSTOrderDetail.DeliveryQty,
|
CheckWeight=weight,
|
CheckThickness=thickness,
|
CheckWide=wide,
|
MaterielCode = materielInfo.MaterielCode,
|
MaterielName = materielInfo.MaterielName,
|
StockLength = purchaseBSTOrderDetail.ProcurementLength,
|
MaterielId = purchaseBSTOrderDetail.MaterialId
|
};
|
if (purchaseBSTOrderDetail.MaterialWide > 1200)
|
{
|
stockInfo.PalletType = 2;
|
}
|
yLInboundCache.RfidCode = palletCode;
|
yLInboundCache.BindStatus = WhetherEnum.True.ObjToInt();
|
_unitOfWorkManage.BeginTran();
|
//新增组盘信息
|
_stockRepository.StockInfoRepository.AddData(stockInfo);
|
if (purchaseBSTOrder.PurchaseOrderStatus == InOrderStatusEnum.未开始.ObjToInt())
|
{
|
purchaseBSTOrder.PurchaseOrderStatus = InOrderStatusEnum.入库中.ObjToInt();
|
_purchaseBSTOrderRepository.UpdateData(purchaseBSTOrder);
|
}
|
_inboundRepository.YLInboundCacheRepository.UpdateData(yLInboundCache);
|
_purchaseBSTOrderDetailRepository.UpdateData(purchaseBSTOrderDetail);
|
_unitOfWorkManage.CommitTran();
|
}
|
}
|
#endregion
|
content.OK("绑定成功");
|
}
|
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
public void UpdateStock(Dt_StockInfo stockInfo, decimal weight = 0, decimal thickness = 0, decimal wide = 0)
|
{
|
stockInfo.CheckWeight = weight;
|
stockInfo.CheckThickness = thickness;
|
stockInfo.CheckWide = wide;
|
_stockRepository.StockInfoRepository.UpdateData(stockInfo);
|
}
|
/// <summary>
|
/// 原料采购绑定RFID
|
/// </summary>
|
/// <param name="palletCode">纸卷条码</param>
|
/// <param name="rfidCode">纸卷RIFD</param>
|
/// <returns></returns>
|
public WebResponseContent PurchaseBoxing(string palletCode)
|
{
|
WebResponseContent content=new WebResponseContent();
|
try
|
{
|
if (string.IsNullOrEmpty(palletCode))
|
{
|
return content.Error("条码不能为空");
|
}
|
Dt_StockInfo stockInfoOld = _stockRepository.StockInfoRepository.QueryFirst(x => x.PalletCode == palletCode);
|
if (stockInfoOld != null)
|
{
|
return content.Error("条码信息库存中已存在");
|
}
|
//获取采购信息
|
Dt_PurchaseBSTOrderDetail purchaseBSTOrderDetail = _purchaseBSTOrderDetailRepository.QueryFirst(x => x.Barcode == palletCode);
|
if (purchaseBSTOrderDetail == null)
|
{
|
BSTResponse<BSTStockInfoDTO> bSTResponse = _invokeERPService.BSTStockAsync(palletCode).DeserializeObject<BSTResponse<BSTStockInfoDTO>>();
|
if (bSTResponse.Code == 500)
|
{
|
return content.Error($"未找到条码{palletCode}采购信息并一期ERP库存也不存在");
|
}
|
BSTStockInfoDTO bSTStockInfoDTO=bSTResponse.Data;
|
if (bSTStockInfoDTO==null)
|
{
|
return content.Error($"一期ERP未返回{palletCode}的库存信息");
|
}
|
Dt_MaterielInfo materielInfo = _basicRepository.MaterielInfoRepository.QueryFirst(x => x.MaterialSourceId == bSTStockInfoDTO.MaterialId);
|
if (materielInfo==null)
|
{
|
return content.Error($"未找到条码{palletCode}物料信息{bSTStockInfoDTO.MaterialNo}");
|
}
|
//生成库存组盘信息
|
Dt_StockInfo stockInfo = new Dt_StockInfo()
|
{
|
MaterielInvOrgId = materielInfo.MaterielInvOrgId,
|
PalletCode = palletCode,
|
RfidCode = "",
|
LocationCode = "",
|
PalletType = 1,
|
WarehouseId = materielInfo.WarehouseId,
|
StockAttribute = materielInfo.MaterielSourceType,
|
StockStatus = StockStatusEmun.博思通组盘暂存.ObjToInt(),
|
MaterielSpec = materielInfo.MaterielSpec,
|
Unit = materielInfo.MaterielUnit,
|
MaterielThickness = bSTStockInfoDTO.Thick,
|
MaterielWide = bSTStockInfoDTO.W,
|
MaterielWeight = bSTStockInfoDTO.Qty,
|
MaterielCode = materielInfo.MaterielCode,
|
MaterielName = materielInfo.MaterielName,
|
StockLength = bSTStockInfoDTO.StockMeter,
|
MaterielId = materielInfo.MaterialSourceId
|
};
|
if (bSTStockInfoDTO.W > 1200)
|
{
|
stockInfo.PalletType = 2;
|
}
|
Dt_YLInboundCache? yLInboundCache = _inboundRepository.YLInboundCacheRepository.QueryData(x => x.InvOrg == MaterielInvOrgEnum.老厂.ToString()).FirstOrDefault();
|
if (yLInboundCache == null)
|
{
|
return content.Error("未找到原料条码缓存信息");
|
}
|
int Id = yLInboundCache.Id;
|
if (yLInboundCache.BarCode == palletCode)
|
{
|
return content.Error($"条码{palletCode}已扫码");
|
}
|
else if (yLInboundCache.BarCode != palletCode && yLInboundCache.BindStatus == WhetherEnum.True.ObjToInt())
|
{
|
yLInboundCache = _mapper.Map<Dt_YLInboundCache>(stockInfo);
|
yLInboundCache.Id = Id;
|
_unitOfWorkManage.BeginTran();
|
//新增组盘信息
|
_stockRepository.StockInfoRepository.AddData(stockInfo);
|
_inboundRepository.YLInboundCacheRepository.UpdateData(yLInboundCache);
|
WebResponseContent webResponse = YLPurchasePush();
|
if (!webResponse.Status)
|
{
|
throw new Exception(webResponse.Message);
|
}
|
_unitOfWorkManage.CommitTran();
|
return content.OK("成功", yLInboundCache);
|
}
|
else
|
{
|
return content.Error($"上卷条码{yLInboundCache.BarCode}还未进行绑定");
|
}
|
|
}
|
else
|
{
|
if (purchaseBSTOrderDetail.PurchaseBSTOrderDetailStatus != InOrderStatusEnum.未开始.ObjToInt())
|
{
|
return content.Error($"条码{palletCode}采购信息已入库或入库中");
|
}
|
Dt_YLInboundCache? yLInboundCache = _inboundRepository.YLInboundCacheRepository.QueryData(x => x.InvOrg == MaterielInvOrgEnum.老厂.ToString()).FirstOrDefault();
|
if (yLInboundCache == null)
|
{
|
return content.Error("未找到原料条码缓存信息");
|
}
|
int Id = yLInboundCache.Id;
|
if (yLInboundCache.BarCode == palletCode)
|
{
|
return content.Error($"条码{palletCode}已扫码");
|
}
|
else if (yLInboundCache.BarCode != palletCode && yLInboundCache.BindStatus == WhetherEnum.True.ObjToInt())
|
{
|
yLInboundCache = _mapper.Map<Dt_YLInboundCache>(purchaseBSTOrderDetail);
|
yLInboundCache.Id = Id;
|
_unitOfWorkManage.BeginTran();
|
_inboundRepository.YLInboundCacheRepository.UpdateData(yLInboundCache);
|
WebResponseContent webResponse = YLPurchasePush();
|
if (!webResponse.Status)
|
{
|
throw new Exception(webResponse.Message);
|
}
|
_unitOfWorkManage.CommitTran();
|
return content.OK("成功", yLInboundCache);
|
}
|
else
|
{
|
return content.Error($"上卷条码{yLInboundCache.BarCode}还未进行绑定");
|
}
|
}
|
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
content.Error(ex.Message);
|
}
|
return content;
|
|
}
|
/// <summary>
|
/// 推送至WCS原料线体启动
|
/// </summary>
|
/// <returns></returns>
|
public WebResponseContent YLPurchasePush()
|
{
|
try
|
{
|
string url = AppSettings.Get("WCS");
|
if (string.IsNullOrEmpty(url))
|
{
|
throw new Exception($"未找到WCSAApi地址,请检查配置文件");
|
}
|
string response = HttpHelper.Post($"{url}/api/Task/YLPurchasePush?code=406");
|
|
return JsonConvert.DeserializeObject<WebResponseContent>(response) ?? WebResponseContent.Instance.Error("返回错误");
|
}
|
catch (Exception ex)
|
{
|
return WebResponseContent.Instance.Error(ex.Message);
|
}
|
}
|
/// <summary>
|
/// 原料分配巷道
|
/// </summary>
|
/// <param name="palletCode">条码号</param>
|
/// <returns></returns>
|
/// <exception cref="Exception"></exception>
|
public string AssignYLRoadwayNo(string palletCode)
|
{
|
try
|
{
|
Dt_StockInfo stockInfo = _stockRepository.StockInfoRepository.QueryFirst(x => x.PalletCode == palletCode);
|
if (stockInfo==null)
|
{
|
throw new Exception($"组盘库存不存在");
|
}
|
Dt_Warehouse warehouse = _basicRepository.WarehouseRepository.QueryFirst(x => x.WarehouseId == stockInfo.WarehouseId);
|
|
if (warehouse == null)
|
{
|
throw new Exception($"未找到巷道对应仓库信息");
|
}
|
|
string roadwayNo = "";
|
|
if (stockInfo.MaterielInvOrgId==MaterielInvOrgEnum.新厂.ObjToInt())
|
{
|
//限制直径
|
if (stockInfo.MaterielThickness >= 300 && stockInfo.MaterielThickness <= 1300 && stockInfo.MaterielWide >= 700 && stockInfo.MaterielWide <= 2700)
|
{
|
//获取分配
|
List<LocationCount> locationCounts = Db.Queryable<Dt_LocationInfo>().Where(x => x.WarehouseId == warehouse.WarehouseId && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && x.RoadwayNo.Contains("YLDual") && (stockInfo.PalletType == LocationTypeEnum.MediumPallet.ObjToInt() ? x.LocationType == LocationTypeEnum.MediumPallet.ObjToInt(): x.LocationType == LocationTypeEnum.SmallPallet.ObjToInt())).GroupBy(x => x.RoadwayNo).Select(x => new LocationCount { RoadwayNo = x.RoadwayNo, Count = SqlFunc.AggregateCount(x) }).ToList();
|
|
roadwayNo = HandleRoadway(locationCounts, warehouse);
|
}
|
}
|
else
|
{
|
//限制
|
if (stockInfo.MaterielThickness >= 800 && stockInfo.MaterielThickness <= 1500 && stockInfo.MaterielWide >= 700 && stockInfo.MaterielWide <= 2500)
|
{
|
bool LayerLimit = false;
|
if (stockInfo.MaterielThickness>1300)
|
{
|
LayerLimit = true;
|
}
|
//获取分配
|
List<LocationCount> locationCounts = Db.Queryable<Dt_LocationInfo>().Where(x => x.WarehouseId == warehouse.WarehouseId && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && x.RoadwayNo.Contains("YL") && !x.RoadwayNo.Contains("YLDual") && (LayerLimit ? x.Columns>=56 : x.Columns<=55)).GroupBy(x => x.RoadwayNo).Select(x => new LocationCount { RoadwayNo = x.RoadwayNo, Count = SqlFunc.AggregateCount(x) }).ToList();
|
if (stockInfo.MaterielWide > 2200)
|
{
|
locationCounts = Db.Queryable<Dt_LocationInfo>().Where(x => x.WarehouseId == warehouse.WarehouseId && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && x.RoadwayNo == "SC02_YL" && (LayerLimit ? x.Columns >= 56 : x.Columns <= 55)).GroupBy(x => x.RoadwayNo).Select(x => new LocationCount { RoadwayNo = x.RoadwayNo, Count = SqlFunc.AggregateCount(x) }).ToList();
|
}
|
|
roadwayNo = HandleRoadway(locationCounts, warehouse);
|
}
|
}
|
|
return !string.IsNullOrEmpty(roadwayNo) ? (roadwayNo) : throw new Exception("未找到可分配巷道");
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
throw new Exception(ex.Message);
|
}
|
}
|
//处理分配巷道 任务数量
|
public string HandleRoadway(List<LocationCount> locationCounts, Dt_Warehouse warehouse)
|
{
|
//巷道任务分配数量
|
List<LocationCount> useLocationCounts = Db.Queryable<Dt_Task>().Where(x => x.WarehouseId == warehouse.WarehouseId
|
&& locationCounts.Select(j => j.RoadwayNo).Distinct().Contains(x.Roadway)
|
&& TaskInboundTypes.Contains(x.TaskType)).GroupBy(x => x.Roadway).Select(x => new LocationCount { RoadwayNo = x.Roadway, Count = SqlFunc.AggregateCount(x) }).ToList();
|
foreach (var item in locationCounts)
|
{
|
LocationCount? count = useLocationCounts.FirstOrDefault(x => x.RoadwayNo == item.RoadwayNo);
|
if (count != null)
|
{
|
item.Count -= count.Count;
|
}
|
}
|
return locationCounts.Where(x => x.Count > 0).OrderByDescending(x => x.Count).FirstOrDefault()?.RoadwayNo ?? "";
|
}
|
/// <summary>
|
/// 入库完成
|
/// </summary>
|
public WebResponseContent InboundTaskCompleted(Dt_Task task)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
Dt_Warehouse warehouse = _basicRepository.WarehouseRepository.QueryFirst(x => x.WarehouseId == task.WarehouseId);
|
if (warehouse.WarehouseCode == WarehouseEnum.LLDCP.ToString() || warehouse.WarehouseCode == WarehouseEnum.LLDFL.ToString()) //成品/辅料完成
|
{
|
Dt_LocationInfo locationInfoEnd = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.TargetAddress);
|
if (locationInfoEnd == null)
|
{
|
return content.Error($"未找到对应的终点货位信息");
|
}
|
Dt_AGVStationInfo agvstation = _agvStationInfoRepository.QueryFirst(x => x.AGVStationCode == task.SourceAddress && ( x.StationArea == nameof(AGVStationAreaEnum.一楼月台码头) || x.StationArea == nameof(AGVStationAreaEnum.一楼无纺织布) || x.StationArea == nameof(AGVStationAreaEnum.一楼无纺淋膜) || x.StationArea == nameof(AGVStationAreaEnum.一楼无纺淋膜)));
|
if (agvstation != null)
|
{
|
agvstation.IsOccupied = WhetherEnum.False.ObjToInt();
|
}
|
Dt_ProStockInfo proStockInfo = _stockRepository.ProStockInfoRepository.Db.Queryable<Dt_ProStockInfo>().Where(x => x.PalletCode == task.PalletCode).Includes(x=>x.proStockInfoDetails).First();
|
if (proStockInfo != null && proStockInfo.StockStatus == StockStatusEmun.MES空托退库.ObjToInt())
|
{
|
task.TaskStatus = TaskStatusEnum.Finish.ObjToInt();
|
_unitOfWorkManage.BeginTran();
|
if (agvstation != null)
|
{
|
_agvStationInfoRepository.UpdateData(agvstation);
|
}
|
proStockInfo.LocationCode = locationInfoEnd.LocationCode;
|
proStockInfo.StockStatus = StockStatusEmun.入库完成.ObjToInt();
|
_stockRepository.ProStockInfoRepository.UpdateData(proStockInfo);
|
_basicService.LocationInfoService.UpdateLocationStatus(locationInfoEnd, proStockInfo.PalletType, LocationStatusEnum.InStock, proStockInfo.WarehouseId);
|
BaseDal.DeleteAndMoveIntoHty(task, App.User.UserId > 0 ? WIDESEA_Core.Enums.OperateTypeEnum.人工完成 : WIDESEA_Core.Enums.OperateTypeEnum.自动完成);
|
_unitOfWorkManage.CommitTran();
|
}
|
else if (proStockInfo != null && proStockInfo.StockStatus == StockStatusEmun.手动组盘入库确认.ObjToInt())
|
{
|
task.TaskStatus = TaskStatusEnum.Finish.ObjToInt();
|
proStockInfo.proStockInfoDetails.ForEach(x =>
|
{
|
x.ProStockDetailStatus = StockStatusEmun.入库完成.ObjToInt();
|
});
|
_unitOfWorkManage.BeginTran();
|
if (agvstation != null)
|
{
|
_agvStationInfoRepository.UpdateData(agvstation);
|
}
|
proStockInfo.LocationCode = locationInfoEnd.LocationCode;
|
proStockInfo.StockStatus = StockStatusEmun.入库完成.ObjToInt();
|
_stockRepository.ProStockInfoRepository.UpdateData(proStockInfo);
|
_stockRepository.ProStockInfoDetailRepository.UpdateData(proStockInfo.proStockInfoDetails);
|
_basicService.LocationInfoService.UpdateLocationStatus(locationInfoEnd, proStockInfo.PalletType, LocationStatusEnum.InStock, proStockInfo.WarehouseId);
|
BaseDal.DeleteAndMoveIntoHty(task, App.User.UserId > 0 ? WIDESEA_Core.Enums.OperateTypeEnum.人工完成 : WIDESEA_Core.Enums.OperateTypeEnum.自动完成);
|
_unitOfWorkManage.CommitTran();
|
}
|
else
|
{
|
return content.Error($"未找到对应库存信息");
|
}
|
}
|
else//原料库完成
|
{
|
//获取库存
|
Dt_StockInfo stockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == task.PalletCode);
|
if (stockInfo == null)
|
{
|
return content.Error($"未找到对应库存信息");
|
}
|
//获取货位信息
|
Dt_LocationInfo locationInfoEnd = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.TargetAddress);
|
if (locationInfoEnd == null)
|
{
|
return content.Error($"未找到对应的终点货位信息");
|
}
|
//更新状态
|
task.TaskStatus = TaskStatusEnum.Finish.ObjToInt();
|
_unitOfWorkManage.BeginTran();
|
if (task.TaskType == TaskTypeEnum.InPick.ObjToInt())
|
{
|
Dt_LocationInfo locationInfoStart = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.SourceAddress);
|
_basicService.LocationInfoService.UpdateLocationStatus(locationInfoStart, stockInfo.PalletType, LocationStatusEnum.Free, stockInfo.WarehouseId);
|
}
|
stockInfo.LocationCode = locationInfoEnd.LocationCode;
|
stockInfo.StockStatus = StockStatusEmun.入库完成.ObjToInt();
|
if (task.TaskType!=TaskTypeEnum.Inbound.ObjToInt())
|
{
|
stockInfo.IsFull = WhetherEnum.True.ObjToInt();
|
}
|
_stockService.StockInfoService.Repository.UpdateData(stockInfo);
|
_basicService.LocationInfoService.UpdateLocationStatus(locationInfoEnd, stockInfo.PalletType, LocationStatusEnum.InStock, stockInfo.WarehouseId);
|
BaseDal.DeleteAndMoveIntoHty(task, App.User.UserId > 0 ? WIDESEA_Core.Enums.OperateTypeEnum.人工完成 : WIDESEA_Core.Enums.OperateTypeEnum.自动完成);
|
//上报老厂ERP
|
if (stockInfo.MaterielInvOrgId == MaterielInvOrgEnum.老厂.ObjToInt())
|
{
|
int Qty = Convert.ToInt32(stockInfo.MaterielWeight);
|
BSTPurchaseUpModel bSTPurchaseUpModel = new BSTPurchaseUpModel()
|
{
|
Barcode = stockInfo.PalletCode,
|
BarcodeQty = Qty,
|
Rfid = stockInfo.RfidCode,
|
RfidUpdateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
|
};
|
BSTResponse<object> bSTResponse = _invokeERPService.BSTPurchaseUp(bSTPurchaseUpModel).DeserializeObject<BSTResponse<object>>();
|
if (bSTResponse.Code == 500)
|
{
|
throw new Exception($"BST一期ERP同步入库信息失败,错误信息：{bSTResponse.Msg}");
|
}
|
content.Message = bSTResponse.Msg;
|
}
|
_unitOfWorkManage.CommitTran();
|
}
|
return content.OK();
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
/// <summary>
|
/// 分配成品巷道
|
/// </summary>
|
/// <returns></returns>
|
public string AssignCPRoadwayNo()
|
{
|
try
|
{
|
string roadwayNo = "";
|
//获取巷道可分配的货位数量
|
List<LocationCount> locationCounts = Db.Queryable<Dt_LocationInfo>().Where(x => x.WarehouseId == WarehouseEnum.LLDCP.ObjToInt() && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && x.RoadwayNo.Contains("CP")).GroupBy(x => x.RoadwayNo).Select(x => new LocationCount { RoadwayNo = x.RoadwayNo, Count = SqlFunc.AggregateCount(x) }).ToList();
|
//筛选当前入库任务中已分配巷道任务数量
|
List<LocationCount> useLocationCounts = Db.Queryable<Dt_Task>().Where(x => (x.WarehouseId == WarehouseEnum.LLDCP.ObjToInt()|| x.WarehouseId == WarehouseEnum.LLDFL.ObjToInt())
|
&& locationCounts.Select(j=>j.RoadwayNo).Distinct().Contains(x.Roadway)
|
&& TaskInboundTypes.Contains(x.TaskType)).GroupBy(x => x.Roadway).Select(x => new LocationCount { RoadwayNo = x.Roadway, Count = SqlFunc.AggregateCount(x) }).ToList();
|
foreach (var item in locationCounts)
|
{
|
LocationCount? count = useLocationCounts.FirstOrDefault(x => x.RoadwayNo == item.RoadwayNo);
|
if (count!=null)
|
{
|
item.Count -= count.Count;
|
}
|
}
|
//通过可用货位数量排序，最多的优先分配
|
roadwayNo = locationCounts.Where(x=>x.Count>0).OrderByDescending(x => x.Count).FirstOrDefault()?.RoadwayNo ?? "";
|
return !string.IsNullOrEmpty(roadwayNo) ? (roadwayNo) : throw new Exception("未找到可分配巷道");
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
throw new Exception(ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 入库任务申请分配货位
|
/// </summary>
|
/// <param name="taskNum">任务号</param>
|
/// <param name="roadwayNo">巷道号</param>
|
/// <returns></returns>
|
public WebResponseContent AssignInboundTaskLocation(int taskNum, string roadwayNo)
|
{
|
try
|
{
|
Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum);
|
if (task == null)
|
{
|
return WebResponseContent.Instance.Error($"未找到该入库任务");
|
}
|
|
if (_basicRepository.LocationInfoRepository.QueryFirst(x => x.LocationCode == task.TargetAddress) != null)
|
{
|
return WebResponseContent.Instance.OK(data: task.TargetAddress);
|
}
|
Dt_StockInfo? stockInfo = null;
|
if (roadwayNo.Contains("YL"))
|
{
|
stockInfo = _stockRepository.StockInfoRepository.QueryFirst(x=>x.PalletCode==task.PalletCode);
|
}
|
//分配货位
|
Dt_LocationInfo? locationInfo = _basicService.LocationInfoService.AssignLocation(roadwayNo, task.PalletType, task.WarehouseId, stockInfo);
|
if (locationInfo == null)
|
{
|
return WebResponseContent.Instance.Error($"货位分配失败,未找到可分配货位");
|
}
|
|
task.Roadway = roadwayNo;
|
task.TargetAddress = locationInfo.LocationCode;
|
if (task.Roadway.Contains("AGV"))
|
{
|
task.TaskStatus = TaskStatusEnum.AGV_Execute.ObjToInt();
|
}
|
else
|
{
|
task.TaskStatus = TaskStatusEnum.SC_Execute.ObjToInt();
|
}
|
|
LocationStatusEnum lastStatus = (LocationStatusEnum)locationInfo.LocationStatus;
|
//更新锁定货位
|
_unitOfWorkManage.BeginTran();
|
_recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfo, lastStatus, LocationStatusEnum.Lock, LocationChangeType.InboundAssignLocation);
|
_basicService.LocationInfoService.UpdateLocationStatus(locationInfo, task.PalletType, LocationStatusEnum.Lock, task.WarehouseId);
|
BaseDal.UpdateData(task);
|
_unitOfWorkManage.CommitTran();
|
return WebResponseContent.Instance.OK(data: locationInfo.LocationCode);
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
return WebResponseContent.Instance.Error(ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 空框回库
|
/// </summary>
|
public WebResponseContent EmptyBackTask(string barCode, string startPoint)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
//string palletCode = @"^C\d{5}$"; // 正则表达式
|
//bool isValid = Regex.IsMatch(barCode, palletCode);
|
//if (!isValid)
|
//{
|
// return content.Error($"框码格式错误{barCode}");
|
//}
|
Dt_AGVStationInfo agvstation = _agvStationInfoRepository.QueryFirst(x=>x.AGVStationCode==startPoint);
|
if (agvstation==null)
|
{
|
return content.Error($"起点错误{startPoint}");
|
}
|
//判断当前点位是否重复
|
Dt_Task taskOldPoint = BaseDal.QueryFirst(x => x.SourceAddress == startPoint &&( x.TaskStatus == TaskStatusEnum.New.ObjToInt() || x.TaskStatus==TaskStatusEnum.AGV_Executing.ObjToInt()));
|
if (taskOldPoint != null)
|
{
|
return content.Error($"站点{startPoint}已存在任务");
|
}
|
Dt_Task taskOld = BaseDal.QueryFirst(x => x.PalletCode == barCode);
|
if (taskOld != null)
|
{
|
return content.Error($"托盘{barCode}任务已存在");
|
}
|
Dt_ProStockInfo proStockInfoOld = _stockRepository.ProStockInfoRepository.QueryFirst(x => x.PalletCode == barCode);
|
if (proStockInfoOld!=null)
|
{
|
return content.Error($"托盘{barCode}已存在");
|
}
|
//分配巷道
|
string roadWay=AssignCPRoadwayNo();
|
|
Dt_ProStockInfo proStockInfo = new Dt_ProStockInfo()
|
{
|
PalletCode=barCode,
|
ProStockAttribute=ProStockAttributeEnum.空托.ObjToInt(),
|
PalletType=1,
|
LocationCode="",
|
WarehouseId= WarehouseEnum.LLDFL.ObjToInt(),
|
StockStatus=StockStatusEmun.MES空托退库.ObjToInt()
|
};
|
|
Dt_Task newTask = new Dt_Task()
|
{
|
CurrentAddress = startPoint,
|
Grade = 0,
|
NextAddress = "",
|
PalletCode = barCode,
|
Roadway = roadWay,
|
SourceAddress = startPoint,
|
TargetAddress = "",
|
TaskType = TaskTypeEnum.EmptyProductBack.ObjToInt(),
|
TaskStatus = TaskStatusEnum.New.ObjToInt(),
|
WarehouseId = WarehouseEnum.LLDFL.ObjToInt(),
|
PalletType = 1
|
};
|
_unitOfWorkManage.BeginTran();
|
int taskId = BaseDal.AddData(newTask);
|
_stockRepository.ProStockInfoRepository.AddData(proStockInfo);
|
newTask.TaskId = taskId;
|
_unitOfWorkManage.CommitTran();
|
//推送任务
|
PushTasksToWCS(new List<Dt_Task> { newTask },"AGV");
|
content.OK("发送成功");
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
private readonly static object _lockerFLorCP = new object();
|
/// <summary>
|
/// 辅料/成品临时入库
|
/// </summary>
|
/// <returns></returns>
|
public WebResponseContent InboundFLOrCPTask(string barCode, string startPoint,string matCode,int matCount, int oneCount)
|
{
|
lock (_lockerFLorCP)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
if (matCount<1 || oneCount < 1)
|
{
|
return content.Error("物料总数或单个数量不能小于1");
|
}
|
//string palletCode = @"^C\d{5}$"; // 正则表达式
|
//bool isValid = Regex.IsMatch(barCode, palletCode);
|
//if (!isValid)
|
//{
|
// return content.Error($"框码格式错误{barCode}");
|
//}
|
//获取物料
|
Dt_MaterielInfo materielInfo = _basicRepository.MaterielInfoRepository.QueryFirst(x => x.MaterielCode == matCode && x.MaterielInvOrgId == MaterielInvOrgEnum.新厂.ObjToInt() && (x.WarehouseId==WarehouseEnum.LLDCP.ObjToInt() || x.WarehouseId == WarehouseEnum.LLDFL.ObjToInt()));
|
if (materielInfo == null)
|
{
|
return content.Error($"未找到物料信息{matCode}");
|
}
|
Dt_AGVStationInfo agvstation = _agvStationInfoRepository.QueryFirst(x => x.AGVStationCode == startPoint);
|
if (agvstation == null)
|
{
|
return content.Error($"起点错误{startPoint}");
|
}
|
//判断当前点位是否重复
|
Dt_Task taskOldPoint = BaseDal.QueryFirst(x => x.SourceAddress == startPoint && (x.TaskStatus == TaskStatusEnum.New.ObjToInt() || x.TaskStatus == TaskStatusEnum.AGV_Executing.ObjToInt()));
|
if (taskOldPoint != null)
|
{
|
return content.Error($"站点{startPoint}已存在任务");
|
}
|
Dt_Task taskOld = BaseDal.QueryFirst(x => x.PalletCode == barCode);
|
if (taskOld != null)
|
{
|
return content.Error($"托盘{barCode}任务已存在");
|
}
|
Dt_ProStockInfo proStockInfoOld = _stockRepository.ProStockInfoRepository.QueryFirst(x => x.PalletCode == barCode);
|
if (proStockInfoOld != null)
|
{
|
return content.Error($"托盘{barCode}已存在");
|
}
|
//分配巷道
|
string roadWay = AssignCPRoadwayNo();
|
|
//获取成品库
|
WarehouseEnum warehouseEnum = materielInfo.MaterielSourceType == MaterielTypeEnum.成品.ObjToInt() ? WarehouseEnum.LLDCP : WarehouseEnum.LLDFL;
|
List<Dt_ProStockInfoDetail> proStockInfoDetails = new List<Dt_ProStockInfoDetail>();
|
for (int i = 0; i < matCount; i++)
|
{
|
Dt_ProStockInfoDetail proStockInfoDetail = new Dt_ProStockInfoDetail()
|
{
|
ProductCode = materielInfo.MaterielCode,
|
ProductName = materielInfo.MaterielName,
|
ProductSpec = materielInfo.MaterielSpec,
|
ProductUnit = materielInfo.MaterielUnit,
|
StockQty = oneCount,
|
ProStockDetailStatus = StockStatusEmun.手动组盘入库确认.ObjToInt()
|
};
|
proStockInfoDetails.Add(proStockInfoDetail);
|
}
|
|
Dt_ProStockInfo proStockInfo = new Dt_ProStockInfo()
|
{
|
PalletCode = barCode,
|
ProStockAttribute = materielInfo.MaterielSourceType,
|
PalletType = 1,
|
LocationCode = "",
|
WarehouseId = warehouseEnum.ObjToInt(),
|
StockStatus = StockStatusEmun.手动组盘入库确认.ObjToInt(),
|
proStockInfoDetails = proStockInfoDetails
|
};
|
|
Dt_Task newTask = new Dt_Task()
|
{
|
CurrentAddress = startPoint,
|
Grade = 0,
|
NextAddress = "",
|
PalletCode = barCode,
|
Roadway = roadWay,
|
SourceAddress = startPoint,
|
TargetAddress = "",
|
TaskType = TaskTypeEnum.Inbound.ObjToInt(),
|
TaskStatus = TaskStatusEnum.New.ObjToInt(),
|
WarehouseId = warehouseEnum.ObjToInt(),
|
PalletType = 1
|
};
|
_unitOfWorkManage.BeginTran();
|
int taskId = BaseDal.AddData(newTask);
|
BaseDal.Db.InsertNav(proStockInfo).Include(x => x.proStockInfoDetails).ExecuteCommand();
|
newTask.TaskId = taskId;
|
_unitOfWorkManage.CommitTran();
|
//推送任务
|
PushTasksToWCS(new List<Dt_Task> { newTask }, "AGV");
|
content.OK("发送成功");
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
}
|
/// <summary>
|
/// 印刷余料退料任务
|
/// </summary>
|
public WebResponseContent PrintBackInbound(SaveModel saveModel)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
var barcode = saveModel.MainData["palletCode"].ToString();
|
var warehouseId = saveModel.MainData["warehouseId"].ObjToInt();
|
var materSn = saveModel.MainData["materSn"];
|
//直径
|
var thickness = saveModel.MainData["thickness"].ObjToInt();
|
var weight = saveModel.MainData["weight"].ObjToInt();
|
var address = saveModel.MainData["address"].ToString();
|
//幅宽
|
var wide = saveModel.MainData["wide"].ObjToInt();
|
Dt_MaterielInfo? materielInfo = _basicRepository.MaterielInfoRepository.QueryFirst(x => x.MaterielCode == materSn);
|
if (materielInfo == null)
|
{
|
return content.Error("未找到物料信息");
|
}
|
if (materielInfo.MaterielSourceType != MaterielTypeEnum.原材料.ObjToInt())
|
{
|
return content.Error($"物料信息不符合{MaterielTypeEnum.原材料}");
|
}
|
Dt_StockInfo stockInfoOld = _stockRepository.StockInfoRepository.QueryFirst(x => x.PalletCode == barcode);
|
if (stockInfoOld != null)
|
{
|
return content.Error("托盘信息已存在");
|
}
|
//生成库存组盘信息
|
Dt_StockInfo stockInfo = new Dt_StockInfo()
|
{
|
MaterielInvOrgId = materielInfo.MaterielInvOrgId,
|
PalletCode = barcode,
|
LocationCode = "",
|
PalletType = 1,
|
WarehouseId = warehouseId,
|
StockAttribute = materielInfo.MaterielSourceType,
|
StockStatus = StockStatusEmun.手动组盘入库确认.ObjToInt(),
|
MaterielSpec = materielInfo.MaterielSpec,
|
Unit = materielInfo.MaterielUnit,
|
MaterielThickness = thickness,
|
MaterielWide = wide,
|
MaterielWeight = weight,
|
MaterielCode = materielInfo.MaterielCode,
|
MaterielName = materielInfo.MaterielName,
|
};
|
if (wide > 1200)
|
{
|
stockInfo.PalletType = 2;
|
}
|
|
//生成印刷余料退料任务
|
Dt_Task newTask = new Dt_Task()
|
{
|
CurrentAddress = address,
|
Grade = 0,
|
NextAddress = "",
|
PalletCode = barcode,
|
Roadway = "",
|
SourceAddress = address,
|
TargetAddress = "",
|
TaskType = TaskTypeEnum.PrintYLBackInbound.ObjToInt(),
|
TaskStatus = TaskStatusEnum.New.ObjToInt(),
|
WarehouseId = warehouseId,
|
PalletType = stockInfo.PalletType,
|
TaskLength= wide
|
};
|
_unitOfWorkManage.BeginTran();
|
int taskId = BaseDal.AddData(newTask);
|
_stockRepository.StockInfoRepository.AddData(stockInfo);
|
newTask.TaskId = taskId;
|
_unitOfWorkManage.CommitTran();
|
//推送任务
|
PushTasksToWCS(new List<Dt_Task> { newTask });
|
content.OK("发送成功");
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
/// <summary>
|
/// 印刷下料任务
|
/// </summary>
|
public WebResponseContent PrintInbound(SaveModel saveModel)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
var barcode = saveModel.MainData["palletCode"].ToString();
|
var warehouseId = saveModel.MainData["warehouseId"].ObjToInt();
|
var materSn = saveModel.MainData["materSn"];
|
//直径
|
var thickness = saveModel.MainData["thickness"].ObjToInt();
|
var weight = saveModel.MainData["weight"].ObjToInt();
|
var address = saveModel.MainData["address"].ToString();
|
//幅宽
|
var wide = saveModel.MainData["wide"].ObjToInt();
|
Dt_MaterielInfo? materielInfo = _basicRepository.MaterielInfoRepository.QueryFirst(x => x.MaterielCode == materSn);
|
if (materielInfo == null)
|
{
|
return content.Error("未找到物料信息");
|
}
|
if (materielInfo.MaterielSourceType!=MaterielTypeEnum.半成品.ObjToInt())
|
{
|
return content.Error($"未找到物料{materielInfo.MaterielCode}半成品信息");
|
}
|
Dt_StockInfo stockInfoOld = _stockRepository.StockInfoRepository.QueryFirst(x => x.PalletCode == barcode);
|
if (stockInfoOld != null)
|
{
|
return content.Error("托盘信息已存在");
|
}
|
//生成库存组盘信息
|
Dt_StockInfo stockInfo = new Dt_StockInfo()
|
{
|
MaterielInvOrgId = materielInfo.MaterielInvOrgId,
|
PalletCode = barcode,
|
LocationCode = "",
|
PalletType = 1,
|
WarehouseId = warehouseId,
|
StockAttribute = materielInfo.MaterielSourceType,
|
StockStatus = StockStatusEmun.手动组盘入库确认.ObjToInt(),
|
MaterielSpec = materielInfo.MaterielSpec,
|
Unit = materielInfo.MaterielUnit,
|
MaterielThickness = thickness,
|
MaterielWide = wide,
|
MaterielWeight = weight,
|
MaterielCode = materielInfo.MaterielCode,
|
MaterielName = materielInfo.MaterielName,
|
};
|
if (wide > 1200)
|
{
|
stockInfo.PalletType = 2;
|
}
|
|
//生成印刷半成品入库任务
|
Dt_Task newTask = new Dt_Task()
|
{
|
CurrentAddress = address,
|
Grade = 0,
|
NextAddress = "",
|
PalletCode = barcode,
|
Roadway = "",
|
SourceAddress = address,
|
TargetAddress = "",
|
TaskType = TaskTypeEnum.PrintYLInbound.ObjToInt(),
|
TaskStatus = TaskStatusEnum.New.ObjToInt(),
|
WarehouseId = warehouseId,
|
PalletType = stockInfo.PalletType,
|
TaskLength = wide
|
};
|
_unitOfWorkManage.BeginTran();
|
int taskId = BaseDal.AddData(newTask);
|
_stockRepository.StockInfoRepository.AddData(stockInfo);
|
newTask.TaskId = taskId;
|
_unitOfWorkManage.CommitTran();
|
//推送任务
|
PushTasksToWCS(new List<Dt_Task> { newTask });
|
content.OK("发送成功");
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
/// <summary>
|
/// 成品/半成品信息同步接口
|
/// </summary>
|
public WebResponseContent ReceiveProCodeInfo(List<MESProInDTO> proInDTOs)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
if (proInDTOs == null || proInDTOs.Count <= 0)
|
{
|
return content.Error("传入信息为空");
|
}
|
//获取所有成品，半成品信息
|
List<Dt_MESProInOrderInfo> proInOrderInfos = _inboundRepository.MESProInOrderInfoRepository.QueryData();
|
//获取所有物料信息
|
List<Dt_MaterielInfo> materielInfos = _basicRepository.MaterielInfoRepository.QueryData(x => x.MaterielInvOrgId == MaterielInvOrgEnum.新厂.ObjToInt());
|
|
MESProInDTO? CheckMaterialCode = proInDTOs.FirstOrDefault(x => !materielInfos.Select(x => x.MaterielCode).Contains(x.MaterialCode));
|
if (CheckMaterialCode != null)
|
{
|
return content.Error($"物料编码{nameof(MESProInDTO.MaterialCode)}:{CheckMaterialCode.MaterialCode}信息不存在");
|
}
|
//获取所有AGV点位
|
List<Dt_AGVStationInfo> aGVStationInfos = _agvStationInfoRepository.QueryData(x => !string.IsNullOrEmpty(x.MESPointCode));
|
|
//判断是否存在重复
|
MESProInDTO? proInDTO = proInDTOs.FirstOrDefault(x => x.IsMantissa == false && proInOrderInfos.Select(x => x.BarCode).Contains(x.BarCode));
|
if (proInDTO != null)
|
{
|
return content.Error($"{proInDTO.ProductOrderNo}生产工单{proInDTO.BarCode}条码已存在");
|
}
|
Dt_MESProInOrderInfo? proInOrderInfo = proInOrderInfos.FirstOrDefault(x => x.MESProInStatus == InOrderStatusEnum.关闭.ObjToInt() && proInDTOs.Select(x => x.ProductOrderNo).Distinct().Contains(x.ProductOrderNo));
|
if (proInOrderInfo != null)
|
{
|
return content.Error($"{proInOrderInfo.ProductOrderNo}生产工单已关闭");
|
}
|
List<Dt_MESProInOrderInfo> AddMESProInOrders = new List<Dt_MESProInOrderInfo>();
|
foreach (var item in proInDTOs)
|
{
|
Dt_MaterielInfo materielInfo = materielInfos.FirstOrDefault(x => x.MaterielCode == item.MaterialCode);
|
if (materielInfo.MaterielSourceType != MaterielTypeEnum.成品.ObjToInt())
|
{
|
Dt_AGVStationInfo? CheckPointCode = aGVStationInfos.FirstOrDefault(x => x.MESPointCode == item?.PointCode);
|
if (CheckPointCode == null)
|
{
|
return content.Error($"周转位{nameof(MESReturnIssueDTO.PointCode)}{item?.PointCode}不存在,仅成品物料可不传");
|
}
|
}
|
Dt_MESProInOrderInfo AddproInOrderInfo = _mapper.Map<Dt_MESProInOrderInfo>(item);
|
AddproInOrderInfo.WarehouseId = materielInfo.WarehouseId;
|
AddproInOrderInfo.MESProOrderType = materielInfo.MaterielSourceType;
|
AddMESProInOrders.Add(AddproInOrderInfo);
|
}
|
List<Dt_Task> tasks = new List<Dt_Task>();
|
_unitOfWorkManage.BeginTran();
|
_inboundRepository.MESProInOrderInfoRepository.AddData(AddMESProInOrders);
|
if (AddMESProInOrders.Where(x => x.MESProOrderType == MaterielTypeEnum.半成品.ObjToInt()).Count() > 0)
|
{
|
//生成半成品入库
|
WebResponseContent webResponse = PrintInbound(AddMESProInOrders.Where(x => x.MESProOrderType == MaterielTypeEnum.半成品.ObjToInt()).ToList());
|
if (!webResponse.Status)
|
{
|
throw new Exception(webResponse.Message);
|
}
|
tasks = webResponse.Data as List<Dt_Task>;
|
WebResponseContent taskResponse = PushTasksToWCS(tasks);
|
if (taskResponse.Status)
|
{
|
throw new Exception(taskResponse.Message);
|
}
|
}
|
_unitOfWorkManage.CommitTran();
|
content.OK("接收成功");
|
|
}
|
catch (Exception ex)
|
{
|
_unitOfWorkManage.RollbackTran();
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
/// <summary>
|
/// 印刷下料MES任务
|
/// </summary>
|
public WebResponseContent PrintInbound(List<Dt_MESProInOrderInfo> mESProInOrderInfos)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
if (mESProInOrderInfos.Count <= 0)
|
{
|
return content.Error("传入信息为空");
|
}
|
|
List<Dt_MaterielInfo> materielInfos = _basicRepository.MaterielInfoRepository.QueryData();
|
List<Dt_StockInfo> stockInfos = new List<Dt_StockInfo>();
|
List<Dt_Task> tasks = new List<Dt_Task>();
|
//获取所有AGV点位
|
List<Dt_AGVStationInfo> aGVStationInfos = _agvStationInfoRepository.QueryData(x => !string.IsNullOrEmpty(x.MESPointCode));
|
//根据半成品信息呼叫对应任务
|
foreach (var item in mESProInOrderInfos)
|
{
|
Dt_AGVStationInfo? CheckPointCode = aGVStationInfos.FirstOrDefault(x => x.MESPointCode == item?.PointCode);
|
Dt_MaterielInfo? materielInfo = materielInfos.FirstOrDefault(x => x.MaterielCode == item.MaterialCode);
|
if (materielInfo == null)
|
{
|
return content.Error("未找到物料信息");
|
}
|
if (materielInfo.MaterielSourceType != MaterielTypeEnum.半成品.ObjToInt())
|
{
|
return content.Error($"未找到物料{materielInfo.MaterielCode}半成品信息");
|
}
|
Dt_StockInfo stockInfoOld = _stockRepository.StockInfoRepository.QueryFirst(x => x.PalletCode == item.BarCode);
|
if (stockInfoOld != null)
|
{
|
return content.Error("托盘信息已存在");
|
}
|
//生成库存组盘信息
|
Dt_StockInfo stockInfo = new Dt_StockInfo()
|
{
|
MaterielInvOrgId = materielInfo.MaterielInvOrgId,
|
PalletCode = item.BarCode,
|
LocationCode = "",
|
PalletType = 1,
|
WarehouseId = materielInfo.WarehouseId,
|
StockAttribute = materielInfo.MaterielSourceType,
|
StockStatus = StockStatusEmun.入库确认.ObjToInt(),
|
MaterielSpec = materielInfo.MaterielSpec,
|
Unit = materielInfo.MaterielUnit,
|
MaterielThickness = item.Thickness,
|
MaterielWide = item.Wide,
|
MaterielWeight = item.Weight,
|
MaterielCode = materielInfo.MaterielCode,
|
MaterielName = materielInfo.MaterielName,
|
StockLength=item.ProQuantity
|
};
|
if (item.Wide > 1200)
|
{
|
stockInfo.PalletType = 2;
|
}
|
|
//半成品入库任务
|
Dt_Task newTask = new Dt_Task()
|
{
|
CurrentAddress = CheckPointCode.AGVStationCode,
|
Grade = 0,
|
NextAddress = "",
|
PalletCode = item.BarCode,
|
Roadway = "",
|
SourceAddress = CheckPointCode.AGVStationCode,
|
TargetAddress = "",
|
TaskType = 0,
|
TaskStatus = TaskStatusEnum.New.ObjToInt(),
|
WarehouseId = materielInfo.WarehouseId,
|
PalletType = stockInfo.PalletType,
|
TaskLength = (int)item.Wide
|
};
|
TaskTypeEnum taskTypeEnum = CheckPointCode.StationArea switch
|
{
|
nameof(AGVStationAreaEnum.一楼印刷) => TaskTypeEnum.PrintYLInbound,
|
_ => throw new Exception("未找到对应任务")
|
};
|
newTask.TaskType = taskTypeEnum.ObjToInt();
|
stockInfos.Add(stockInfo);
|
tasks.Add(newTask);
|
}
|
//操作入库数据
|
BaseDal.AddData(tasks);
|
_stockRepository.StockInfoRepository.AddData(stockInfos);
|
//推送任务
|
content.OK("发送成功",data:tasks);
|
}
|
catch (Exception ex)
|
{
|
content.Error(ex.Message);
|
}
|
return content;
|
}
|
}
|
}
|
