using System;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading.Tasks;
using WIDESEA_Core.Enums;
using WIDESEA_Core;
using WIDESEA_Model.Models;
using WIDESEA_Core.Helper;
using Microsoft.Extensions.Logging;
using MailKit.Search;
using System.Reflection.Metadata;
using static WIDESEA_ITaskInfoService.ITaskService;
using static WIDESEA_Common.HouseInventoryIn;
using WIDESEA_Common;
using Parameter = WIDESEA_Common.Parameter;
using WIDESEA_Core.LogHelper;
using WIDESEA_DTO.Task;
using WIDESEA_Core.TaskEnum;
namespace WIDESEA_TaskInfoService
{
public partial class TaskService
{
///
/// 立库入库指令上传
///
/// 起始地址
/// 托盘编号
/// 返回处理结果
public WebResponseContent InboundRequest(string stationCode, string roadwayNo, string palletCode)
{
// 输入验证
if (string.IsNullOrWhiteSpace(palletCode))
return WebResponseContent.Instance.Error("请输入正确托盘号");
try
{
Dt_Task task = Repository.QueryFirst(x => x.PalletCode == palletCode);
if (task != null)
{
PushTasksToWCS(new List { task });
return WebResponseContent.Instance.OK($"该托盘已生成任务", _mapper.Map(task));
}
// 获取入库单明细
var inboundOrderDet = GetInboundOrderDetail(palletCode);
if (inboundOrderDet == null)
return WebResponseContent.Instance.Error($"未找到托盘号 {palletCode} 对应的入库单明细");
// 获取入库单
var inboundOrder = GetInboundOrder(inboundOrderDet.OrderId);
if (inboundOrder == null)
return WebResponseContent.Instance.Error($"未找到入库单信息");
// 验证入库单明细
if (inboundOrder.Details == null || inboundOrder.Details.Count == 0)
return WebResponseContent.Instance.Error($"入库单 {inboundOrder.OrderNo} 没有明细信息");
// 获取仓库和巷道信息
var warehouse = GetWarehouse(inboundOrder.WarehouseId);
var roadwayInfo = GetRoadwayInfo(warehouse.WarehouseCode);
// 处理库存信息
//var stockInfo = GetOrCreateStockInfo(palletCode, inboundOrder, inboundOrderDet, warehouse);
var dt_StockInfoDetail = new Dt_StockInfoDetail
{
//StockId = stockInfo.Id,
MaterielCode = inboundOrderDet.MaterielCode,
MaterielName = inboundOrderDet.MaterielName,
OrderNo = inboundOrder.OrderNo,
BatchNo = inboundOrderDet.BatchNo,
LinId = inboundOrderDet.LinId,
StockQuantity = inboundOrderDet.OrderQuantity,
Status = (int)StockStatusEmun.组盘暂存,
Creater = "WMS",
CreateDate = DateTime.Now,
Id = inboundOrderDet.LinId.ObjToInt(),
};
var dt_Stock = new Dt_StockInfo
{
BatchNo = inboundOrderDet.BatchNo,
PalletCode = palletCode,
PalletType = GetPalletType(warehouse, palletCode),
IsFull = true,
StockStatus = (int)StockStatusEmun.组盘暂存,
Creater = "WMS",
CreateDate = DateTime.Now,
MaterialType = (int)InventoryMaterialType.成品,
Materialweight = 0,
Wlstatus = (int)InventoryMaterialStatus.合格,
Mgeneratetime = DateTime.Now,
WarehouseId = warehouse.WarehouseId,
Details = new List { dt_StockInfoDetail }
};
// 检查入库请求
var checkResult = CheckRequestInbound(roadwayInfo.InSCStationCode, palletCode, true, dt_Stock);
if (!checkResult.Item1)
return WebResponseContent.Instance.Error(checkResult.Item2);
// 分配库位并更新数据
Dt_LocationInfo? locationInfo = _basicService.LocationInfoService.AssignLocation(roadwayNo, dt_Stock.PalletType, dt_Stock.WarehouseId);
//Dt_LocationInfo? locationInfo = _basicService.LocationInfoService.AssignLocation(stationCode, TaskTypeEnum.Inbound.ObjToInt());
if (locationInfo == null)
{
return WebResponseContent.Instance.Error($"货位分配失败,未找到可分配货位");
}
Dt_Task newTask = new Dt_Task()
{
CurrentAddress = stationCode,
Grade = 0,
NextAddress = locationInfo.LocationCode,
PalletCode = palletCode,
Roadway = roadwayNo,
SourceAddress = stationCode,
TargetAddress = locationInfo.LocationCode,
TaskType = TaskTypeEnum.Inbound.ObjToInt(),
TaskStatus = TaskStatusEnum.New.ObjToInt(),
WarehouseId = dt_Stock.WarehouseId,
PalletType = dt_Stock.PalletType,
Creater = "WMS",
CreateDate = DateTime.Now,
};
LocationStatusEnum lastStatus = (LocationStatusEnum)locationInfo.LocationStatus;
_unitOfWorkManage.BeginTran();
Db.InsertNav(dt_Stock).Include(x => x.Details).ExecuteCommand();
_recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfo, lastStatus.ObjToInt(), LocationStatusEnum.Lock.ObjToInt(), LocationChangeType.InboundAssignLocation.ObjToInt());
//_basicService.LocationInfoService.UpdateLocationStatus(locationInfo, newTask.PalletType, LocationStatusEnum.Lock, newTask.WarehouseId);
int taskId = BaseDal.AddData(newTask);
newTask.TaskId = taskId;
_stockRepository.StockInfoRepository.UpdateData(dt_Stock);
_unitOfWorkManage.CommitTran();
WMSTaskDTO wMSTaskDTO = _mapper.Map(newTask);
PushTasksToWCS(new List { newTask });
if (newTask.WarehouseId == 5) PutFinish(stationCode);
return WebResponseContent.Instance.OK(data: wMSTaskDTO);
}
catch (Exception ex)
{
_unitOfWorkManage.RollbackTran();
return WebResponseContent.Instance.Error(ex.Message);
}
}
private Dt_InboundOrderDetail GetInboundOrderDetail(string palletCode)
{
return BaseDal.Db.Queryable()
.Where(x => x.LPNNo == palletCode)
.First();
}
private Dt_InboundOrder GetInboundOrder(int orderId)
{
return BaseDal.Db.Queryable()
.Where(x => x.Id == orderId)
.Includes(x => x.Details)
.First();
}
private Dt_Warehouse GetWarehouse(int warehouseId)
{
return _basicService.WarehouseService.Repository
.QueryFirst(x => x.WarehouseId == warehouseId);
}
private Dt_RoadwayInfo GetRoadwayInfo(string warehouseCode)
{
return _basicService.RoadwayInfoService.Repository
.QueryFirst(x => x.RoadwayNo == warehouseCode);
}
private Dt_StockInfo GetOrCreateStockInfo(string palletCode, Dt_InboundOrder inboundOrder, Dt_InboundOrderDetail inboundOrderDet, Dt_Warehouse warehouse)
{
var stockInfo = BaseDal.Db.Queryable()
.Where(x => x.PalletCode == palletCode)
.Includes(x => x.Details)
.First();
decimal beforeQuantity = 0;
if (stockInfo == null)
{
stockInfo = CreateNewStockInfo(palletCode, inboundOrder, inboundOrderDet, warehouse);
//CreateStockInfoDetail(stockInfo, inboundOrder, inboundOrderDet);
}
else
{
if (stockInfo.StockStatus != StockStatusEmun.组盘暂存.ObjToInt())
{
return null;
}
beforeQuantity = stockInfo.Details.Sum(x => x.StockQuantity);
}
return stockInfo;
}
private Dt_StockInfo CreateNewStockInfo(string palletCode, Dt_InboundOrder inboundOrder, Dt_InboundOrderDetail inboundOrderDet, Dt_Warehouse warehouse)
{
var dt_StockInfoDetail = new Dt_StockInfoDetail
{
//StockId = stockInfo.Id,
MaterielCode = inboundOrderDet.MaterielCode,
MaterielName = inboundOrderDet.MaterielName,
OrderNo = inboundOrder.OrderNo,
BatchNo = inboundOrderDet.BatchNo,
LinId = inboundOrderDet.LinId,
StockQuantity = inboundOrderDet.OrderQuantity,
Status = (int)StockStatusEmun.组盘暂存,
Creater = "WMS",
CreateDate = DateTime.Now,
Id = inboundOrderDet.LinId.ObjToInt(),
};
var dt_Stock = new Dt_StockInfo
{
BatchNo = inboundOrderDet.BatchNo,
PalletCode = palletCode,
PalletType = GetPalletType(warehouse, palletCode),
IsFull = true,
StockStatus = (int)StockStatusEmun.组盘暂存,
Creater = "WMS",
CreateDate = DateTime.Now,
MaterialType = (int)InventoryMaterialType.成品,
Materialweight = 0,
Wlstatus = (int)InventoryMaterialStatus.合格,
Mgeneratetime = DateTime.Now,
WarehouseId = warehouse.WarehouseId,
Details = new List { dt_StockInfoDetail }
};
//_stockService.StockInfoService.Repository.AddData(dt_Stock);
Db.InsertNav(dt_Stock).Include(x => x.Details).ExecuteCommand();
return _stockService.StockInfoService.Repository.GetStockInfo(palletCode);
}
private void CreateStockInfoDetail(Dt_StockInfo stockInfo, Dt_InboundOrder inboundOrder, Dt_InboundOrderDetail inboundOrderDet)
{
var dt_StockInfoDetail = new Dt_StockInfoDetail
{
StockId = stockInfo.Id,
MaterielCode = inboundOrderDet.MaterielCode,
MaterielName = inboundOrderDet.MaterielName,
OrderNo = inboundOrder.OrderNo,
BatchNo = inboundOrderDet.BatchNo,
LinId = inboundOrderDet.LinId,
StockQuantity = inboundOrderDet.OrderQuantity,
Status = (int)StockStatusEmun.组盘暂存,
Creater = "WMS",
CreateDate = DateTime.Now,
Id = inboundOrderDet.LinId.ObjToInt(),
};
_stockService.StockInfoDetailService.Repository.AddData(dt_StockInfoDetail);
}
//查询仓库托盘货物类型
public int GetPalletType(Dt_Warehouse warehouse, string palletCode)
{
if (warehouse.WarehouseCode == WarehouseEnum.SC01_BC.ToString())
{
if (palletCode.Substring(0, 1) == "6")
{
return PalletTypeEnum.MediumPallet.ObjToInt();
}
else
{
return PalletTypeEnum.LargestPallet.ObjToInt();
}
}
else if (warehouse.WarehouseCode == WarehouseEnum.SC01_BC.ObjToString())
{
Dt_PalletTypeInfo palletTypeInfo = _palletTypeInfoRepository.QueryFirst(x => x.CodeStartStr == palletCode.Substring(0, 1));
if (palletTypeInfo == null)
{
throw new Exception($"托盘号错误");
}
return palletTypeInfo.PalletType;
}
//else if (warehouse.WarehouseCode == WarehouseEnum.HA152.ObjToString())
//{
// Dt_PalletTypeInfo palletTypeInfo = _palletTypeInfoRepository.QueryFirst(x => x.CodeStartStr == palletCode.Substring(0, 2));
// if (palletTypeInfo == null)
// {
// throw new Exception($"托盘号错误");
// }
// return palletTypeInfo.PalletType;
//}
//else if (warehouse.WarehouseCode == WarehouseEnum.HA57.ObjToString())
//{
// Dt_PalletTypeInfo palletTypeInfo = _palletTypeInfoRepository.QueryFirst(x => x.CodeStartStr == palletCode.Substring(0, 3));
// if (palletTypeInfo == null)
// {
// throw new Exception($"托盘号错误");
// }
// return palletTypeInfo.PalletType;
//}
return -1;
}
#region
//public WebResponseContent InboundRequest(SaveModel saveModel)
//{
// string palletCode = saveModel.palletCode;
// if (saveModel.palletCode == null) return WebResponseContent.Instance.Error($"请输入正确托盘号");
// WebResponseContent content = new WebResponseContent();
// try
// {
// Dt_InboundOrderDetail inboundOrderDet = BaseDal.Db.Queryable().Where(x => x.LPNNo == palletCode).First();
// Dt_InboundOrder inboundOrder = BaseDal.Db.Queryable().Where(x => x.Id == inboundOrderDet.OrderId).Includes(x => x.Details).First();
// if (inboundOrder == null)
// {
// return WebResponseContent.Instance.Error($"未找到入库单信息");
// }
// Dt_Warehouse warehouse = _basicService.WarehouseService.Repository.QueryFirst(x => x.WarehouseId == inboundOrder.WarehouseId);
// Dt_RoadwayInfo roadwayInfo = _basicService.RoadwayInfoService.Repository.QueryFirst(x => x.RoadwayNo == warehouse.WarehouseCode);
// if (roadwayInfo != null) { }
// if (inboundOrder.Details == null || inboundOrder.Details.Count <= 0)
// {
// return WebResponseContent.Instance.Error($"未找到入库单明细信息");
// }
// Dt_StockInfo stockInfo1 = BaseDal.Db.Queryable().Where(x => x.PalletCode == palletCode).Includes(x => x.Details).First();
// if (stockInfo1 == null)
// {
// Dt_StockInfo dt_Stock = new()
// {
// BatchNo = inboundOrderDet.BatchNo,
// PalletCode = palletCode,
// IsFull = true,
// StockStatus = (int)StockStatusEmun.组盘暂存,
// Creater = "WMS",
// CreateDate = DateTime.Now,
// MaterialType = (int)InventoryMaterialType.成品,
// Materialweight = 0,
// Wlstatus = (int)InventoryMaterialStatus.合格,
// Mgeneratetime = DateTime.Now,
// };
// _stockService.StockInfoService.Repository.AddData(dt_Stock);
// Dt_StockInfo dt_StockInfo = _stockService.StockInfoService.Repository.GetStockInfo(palletCode);
// Dt_StockInfoDetail dt_StockInfoDetail = new()
// {
// StockId = dt_StockInfo.Id,
// MaterielCode = inboundOrderDet.MaterielCode, //物料号
// MaterielName = inboundOrderDet.MaterielName, //物料名称
// OrderNo = inboundOrder.OrderNo, //物料详情
// BatchNo = inboundOrderDet.BatchNo, //物料批次
// LinId = inboundOrderDet.LinId, //SerialNumber = targetCodes[2].ToString(), //包号
// //BatchNoName = dt_Int.OrderNo,
// StockQuantity = inboundOrderDet.OrderQuantity, //重量
// //OutboundQuantity = 1, //序列号
// Status = (int)StockStatusEmun.组盘暂存,
// Creater = "WMS",
// CreateDate = DateTime.Now,
// Id = inboundOrderDet.LinId.ObjToInt(),
// };
// _stockService.StockInfoDetailService.Repository.AddData(dt_StockInfoDetail);
// }
// Dt_StockInfo stockInfo = BaseDal.Db.Queryable().Where(x => x.PalletCode == palletCode).Includes(x => x.Details).First();
// (bool, string) result = CheckRequestInbound(roadwayInfo.InSCStationCode, palletCode, true, stockInfo);
// if (!result.Item1) return content = WebResponseContent.Instance.Error(result.Item2);
// content = AssignLocUpdateData(roadwayInfo.InSCStationCode, TaskTypeEnum.Inbound.ObjToInt(), palletCode, true, stockInfo, inboundOrder.OrderNo);
// }
// catch (Exception ex)
// {
// content = WebResponseContent.Instance.Error(ex.Message);
// }
// return content;
//}
#endregion
public string ReceiveWMSInventoryIn = WIDESEA_Core.Helper.AppSettings.Configuration["ReceiveWMSInventoryIn"];
///
/// 盘点差异数量回传
///
///
public WebResponseContent InventoryIn(string name, int qty)
{
WebResponseContent content = new();
try
{
Dt_StockInfo stockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == name);
Dt_StockInfoDetail stockInfoDetail = _stockService.StockInfoDetailService.Repository.QueryFirst(x => x.StockId == stockInfo.Id);
Dt_OutboundOrderDetail outboundOrderDetail = _outboundService.OutboundOrderDetailService.Repository.QueryFirst(x => x.LPNNo == stockInfo.PalletCode);
Dt_OutboundOrder outboundOrder = _outboundService.OutboundOrderService.Repository.QueryFirst(x => x.Id == outboundOrderDetail.OrderId);
HouseInventoryIn houseInboundPassBack = new HouseInventoryIn();
houseInboundPassBack.ApiType = "StockCountController";
houseInboundPassBack.Method = "AsrsFinishedStockCount";
data data = new data();
data.InventoryIn data1 = new data.InventoryIn();
data1.No = outboundOrder.OrderNo;
data.InventoryIn.Inbound inbound = new data.InventoryIn.Inbound();
inbound.LinId = outboundOrderDetail.LinId;
inbound.LPN_No = outboundOrderDetail.LPNNo;
inbound.MaterielCode = outboundOrderDetail.MaterielCode;
inbound.OrderQuantity = outboundOrderDetail.OrderQuantity;
inbound.BatchNo = outboundOrderDetail.BatchNo;
inbound.FinishQty = qty;
inbound.WarehouseCode = outboundOrderDetail.WarehouseCode;
inbound.StorageAreaCode = outboundOrderDetail.StorageAreaCode;
inbound.StorageLocationCode = outboundOrderDetail.StorageLocationCode;
data1.DetailList.Add(inbound);
data.Value.Add(data1);
houseInboundPassBack.Parameters.Add(data);
Authentication authentication = new Authentication()
{
ApiType = "AuthenticationController",
Parameters = new List
{
new Parameter { Value = "LKAdmin"},
new Parameter { Value = "LKAdmin"},
},
Method = "Login",
};
var responses1 = HttpHelper.Post(ReceiveWMSTaskAUT, authentication, "登录WMS账号");
var Ticket = responses1.Context["Ticket"].ToString();
var InvOrgId = responses1.Context["InvOrgId"].ToString();
if (Ticket != null)
{
houseInboundPassBack.Context = new Dictionary();
houseInboundPassBack.Context.Add("Ticket", Ticket);
houseInboundPassBack.Context.Add("InvOrgId", InvOrgId);
var responses = HttpHelper.Post(ReceiveWMSInventoryIn, houseInboundPassBack, "立库入库数量回传WMS");
}
content = WebResponseContent.Instance.OK();
}
catch (Exception ex)
{
content = WebResponseContent.Instance.Error(ex.Message);
}
finally
{
}
return content;
}
///
/// 入库分配货位及处理数据
///
/// 起始地址
/// 任务类型
/// 托盘编号
/// 是否更新组盘信息--区分物料入库和空托入库
/// 组盘信息--可空
/// 订单号--可空
/// 返回处理结果
private WebResponseContent AssignLocUpdateData(string stationCode, int taskType, string palletCode, bool isUpdateStock = true, Dt_StockInfo? stockInfo = null,
string orderNo = "")
{
WebResponseContent content = new WebResponseContent();
try
{
Dt_InboundOrder dt_Int = _inboundService.InbounOrderService.Repository.QueryFirst(x => x.OrderNo == orderNo);
Dt_LocationInfo? locationInfo = _basicService.LocationInfoService.AssignLocation(stationCode, taskType);
//Dt_LocationInfo dt_LocationInfo = null;
if (locationInfo != null)
{
Dt_Task task = new()
{
CurrentAddress = "0",
Grade = 0,
PalletCode = palletCode,
NextAddress = "0",
Roadway = locationInfo.RoadwayNo,
SourceAddress = stationCode,
TargetAddress = locationInfo.LocationCode,
TaskStatus = InTaskStatusEnum.InNew.ObjToInt(),
TaskType = taskType,
OrderNo = orderNo,
CreateDate = DateTime.Now,
Creater = "WMS"
};
BaseDal.AddData(task);
int beforeStatus = locationInfo.LocationStatus;
if (isUpdateStock)
{
locationInfo.LocationStatus = LocationStatusEnum.Lock.ObjToInt();
_basicService.LocationInfoService.UpdateLocationLock(locationInfo, task.TaskNum, StockChangeType.Inbound.ObjToInt(), false);
if (stockInfo != null && stockInfo.Details != null && stockInfo.Details.Count > 0)
{
orderNo = stockInfo.Details.FirstOrDefault()?.OrderNo ?? "";
stockInfo.StockStatus = StockStatusEmun.入库确认.ObjToInt();
//stockInfo.LocationCode = task.TargetAddress;
_stockService.StockInfoService.Repository.UpdateData(stockInfo);
}
else
{
return content = WebResponseContent.Instance.Error("未找到库存信息");
}
}
else
{
locationInfo.LocationStatus = LocationStatusEnum.Lock.ObjToInt();
_basicService.LocationInfoService.UpdateLocationLock(locationInfo, task.TaskNum, StockChangeType.Inbound.ObjToInt(), false);
}
//下发入库任务至WCS
//var responses = HttpHelper.Post(ReceiveWMSTask, task, "下发任务入库");
dt_Int.OrderStatus = InboundStatusEnum.入库中.ObjToInt();
_inboundService.InbounOrderService.Repository.UpdateData(dt_Int);
_basicService.LocationInfoService.Repository.UpdateData(locationInfo);
_recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfo, beforeStatus, StockChangeType.Inbound.ObjToInt(), orderNo, task.TaskNum);
return content = WebResponseContent.Instance.OK(data: task);
}
return content = WebResponseContent.Instance.Error("未找到可分配货位");
}
catch (Exception ex)
{
content = WebResponseContent.Instance.Error(ex.Message);
}
return content;
}
///
/// 验证数据
///
/// 起始地址
/// 托盘编号
/// 是否检查组盘信息--区分物料入库和空托入库
/// 组盘信息--可空
/// 返回处理结果
private (bool, string) CheckRequestInbound(string stationCode, string palletCode, bool isCheckStock = true, Dt_StockInfo? stockInfo = null)
{
if (BaseDal.QueryFirst(x => x.PalletCode == palletCode) != null)
{
return (false, "该托盘号已有任务");
}
if (BaseDal.QueryFirst(x => (x.SourceAddress == stationCode || x.CurrentAddress == stationCode) && x.TaskStatus == InTaskStatusEnum.InNew.ObjToInt()) != null)
{
return (false, "当前入库站台已有一条新建任务");
}
if (isCheckStock)
{
if (stockInfo == null)
{
return (false, "未找到组盘信息");
}
if (stockInfo.StockStatus != StockStatusEmun.组盘暂存.ObjToInt())
{
return (false, "该组盘状态不可入库");
}
if (!string.IsNullOrEmpty(stockInfo.LocationCode))
{
return (false, "该托盘已绑定货位");
}
if (stockInfo.Details == null || stockInfo.Details.Count == 0)
{
return (false, "没有库存明细信息");
}
}
else
{
if (_stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == palletCode) != null)
{
return (false, "该托盘已存在库内");
}
}
return (true, "成功");
}
///
/// 根据托盘条码,起点位置,生成入库信息
///
///
///
//public WebResponseContent GenerateInventoryInformation(GenerateInv generate)
//{
// WebResponseContent content = new WebResponseContent();
// try
// {
// Dt_Task task = BaseDal.QueryFirst(x => x.PalletCode == generate.PalletCode);
// if (task != null)
// {
// return content = WebResponseContent.Instance.Error($"已有该托盘的入库任务,托盘号:{task.PalletCode}");
// }
// else
// {
// //if ((generate.SourceAddress == "R01-003-041-011-01" || generate.SourceAddress == "R01-002-043-001-01" || generate.SourceAddress == "R02-003-027-011-01"))
// //{
// Dt_StockInfo dt_StockInfo2 = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
// if (dt_StockInfo2 == null)
// {
// Dt_StockInfo dt_Stock = new()
// {
// PalletCode = generate.PalletCode,
// IsFull = true,
// StockStatus = (int)StockStatusEmun.组盘暂存,
// Creater = "WMS",
// CreateDate = DateTime.Now,
// MaterialType = (int)InventoryMaterialType.空托,
// Materialweight = 0,
// Wlstatus = (int)InventoryMaterialStatus.空托,
// Mgeneratetime = DateTime.Now,
// };
// _stockService.StockInfoService.Repository.AddData(dt_Stock);
// }
// //}
// Dt_StockInfo dt_StockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode && x.StockStatus == (int)StockStatusEmun.组盘暂存);
// if (dt_StockInfo != null)
// {
// Dt_LocationInfo newLocation;
// Dt_LocationInfo newSourceAddress;
// newSourceAddress = _basicService.LocationInfoService.GetLocationplatform(generate.SourceAddress);
// int Locationtype = 1; //默认为9
// if (dt_StockInfo.MaterialType == (int)InventoryMaterialType.成品 || (generate.SourceAddress == "R01-003-041-001-01" && dt_StockInfo.MaterialType == (int)InventoryMaterialType.原材料))
// {
// Locationtype = 11;
// }
// else if (dt_StockInfo.MaterialType == (int)InventoryMaterialType.原材料)
// {
// Locationtype = 10;
// }
// if (dt_StockInfo.MaterialType == (int)InventoryMaterialType.成品)
// {
// string[] targetCodes = dt_StockInfo.PalletCode.Split("*");
// Dt_InboundOrder dt_Inbound = _inboundService.InbounOrderService.Repository.QueryFirst(x => x.OrderName == targetCodes[0]);
// if (dt_Inbound.Startingcolumn != 0 || dt_Inbound.Terminationcolumn != 0)
// {
// newLocation = _basicService.LocationInfoService.GetLocation2(newSourceAddress.RoadwayNo, Locationtype, dt_Inbound.Startingcolumn, dt_Inbound.Terminationcolumn);
// }
// else
// {
// newLocation = _basicService.LocationInfoService.GetLocation(newSourceAddress.RoadwayNo, Locationtype);
// }
// }
// else
// {
// newLocation = _basicService.LocationInfoService.GetLocation(newSourceAddress.RoadwayNo, Locationtype);
// }
// //string[] Pallet = PalletCode.Split("-");
// if (newLocation != null && newSourceAddress != null)
// {
// //生成入库任务
// Dt_Task dt_Task = new()
// {
// PalletCode = generate.PalletCode,
// TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)),
// Roadway = newLocation.RoadwayNo,
// TaskType = TaskTypeEnum.Inbound.ObjToInt(),
// TaskStatus = InTaskStatusEnum.InNew.ObjToInt(),
// SourceAddress = newSourceAddress.LocationCode,
// TargetAddress = newLocation.LocationCode,
// CurrentAddress = newSourceAddress.LocationCode,
// NextAddress = newLocation.LocationCode,
// Grade = 1,
// Creater = "WMS",
// Depth = newLocation.Depth,
// CreateDate = DateTime.Now,
// MaterialType = dt_StockInfo.MaterialType
// };
// _unitOfWorkManage.BeginTran();
// if (newLocation.LocationStatus == LocationStatusEnum.Free.ObjToInt())
// {
// newLocation.LocationStatus = newSourceAddress.LocationType == (int)LocationTypeEnum.EmptyOut ? LocationStatusEnum.PalletLock.ObjToInt() : LocationStatusEnum.Lock.ObjToInt();
// }
// BaseDal.AddData(dt_Task);
// _basicService.LocationInfoService.UpdateData(newLocation);
// _unitOfWorkManage.CommitTran();
// return content = WebResponseContent.Instance.OK(data: dt_Task);
// }
// else
// {
// return content = WebResponseContent.Instance.Error($"未找到对应的起点:{generate.SourceAddress},或终点{newSourceAddress.RoadwayNo},信息");
// }
// }
// else
// {
// //Queryinventory(generate.PalletCode);
// return content = WebResponseContent.Instance.Error($"组盘,请核对托盘号:{generate.PalletCode}");
// }
// }
// }
// catch (Exception ex)
// {
// return content = WebResponseContent.Instance.Error($"生成入库任务出错,出错信息:{ex.Message}");
// throw;
// }
//}
/////
///// 查询1巷道库存,是否运行进行入库 //带后续重新拼接
/////
/////
//public WebResponseContent Queryinventory3(GenerateInv generate)
//{
// try
// {
// WebResponseContent content = new WebResponseContent();
// string result = generate.PalletCode.Substring(0, 2);
// Dt_InboundOrder dt_Inbound = _inboundService.InbounOrderService.Repository.QueryFirst(x => x.UpperOrderNo == result);
// Dt_StockInfo dt_StockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
// if (dt_Inbound != null)
// {
// if (dt_StockInfo == null)
// {
// Dt_StockInfo dt_Stock = new()
// {
// PalletCode = generate.PalletCode,
// IsFull = true,
// StockStatus = (int)StockStatusEmun.组盘暂存,
// Creater = "WMS",
// CreateDate = DateTime.Now,
// MaterialType = (int)InventoryMaterialType.原材料,
// Materialweight = 0,
// };
// _unitOfWorkManage.BeginTran();
// _stockService.StockInfoService.Repository.AddData(dt_Stock);
// string part2 = generate.PalletCode.Substring(2, 8);
// string part3 = generate.PalletCode.Split('#')[1];
// Dt_StockInfo dt_StockInfo2 = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
// Dt_StockInfoDetail dt_StockInfoDetail = new()
// {
// StockId = dt_StockInfo2.Id,
// MaterielCode = result, //物料编号
// MaterielName = dt_Inbound.OrderNo, //材质
// OrderNo = generate.PalletCode, //单据(托盘条码)
// BatchNo = part2, //批次号
// SerialNumber = part3, //序列号
// StockQuantity = 1, //序列号
// OutboundQuantity = 1, //序列号
// Status = (int)StockStatusEmun.组盘暂存,
// Creater = "WMS",
// CreateDate = DateTime.Now,
// };
// _stockService.StockInfoDetailService.AddData(dt_StockInfoDetail);
// _unitOfWorkManage.CommitTran();
// return content = WebResponseContent.Instance.OK();
// }
// else
// {
// return content = WebResponseContent.Instance.OK();
// }
// }
// else
// {
// return content = WebResponseContent.Instance.Error("未找到该类型的解析");
// }
// }
// catch (Exception ex)
// {
// throw;
// }
//}
/////
///// 解析库存
/////
/////
//public WebResponseContent Queryinventory(GenerateInv generate)
//{
// WebResponseContent content = new WebResponseContent();
// try
// {
// string[] targetCodes = generate.PalletCode.Split("*");
// if (targetCodes.Length == 4)
// {
// Dt_InboundOrder dt_Inbound = _inboundService.InbounOrderService.Repository.QueryFirst(x => x.OrderName == targetCodes[0]);
// if (dt_Inbound != null)
// {
// Dt_StockInfo dt_StockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
// if (dt_Inbound.OrderType == (int)InventoryMaterialType.原材料) //0为原材料编码
// {
// List locationInfos = _basicService.LocationInfoService.Repository.QueryData(x => x.RoadwayNo == "2" && x.LocationStatus == (int)LocationStatusEnum.Free && x.Depth == 1 && x.EnableStatus == (int)EnableStatusEnum.Normal && x.LocationType == (int)LocationTypeEnum.MaterialsCube);
// if (dt_StockInfo == null)
// {
// Dt_StockInfo dt_Stock = new()
// {
// PalletCode = generate.PalletCode,
// IsFull = true,
// StockStatus = (int)StockStatusEmun.组盘暂存,
// Creater = "WMS",
// CreateDate = DateTime.Now,
// MaterialType = (int)InventoryMaterialType.原材料,
// Materialweight = decimal.Parse(targetCodes[3]),
// Wlstatus = (int)InventoryMaterialStatus.待检,
// Mgeneratetime = DateTime.Now,
// };
// _unitOfWorkManage.BeginTran();
// _stockService.StockInfoService.Repository.AddData(dt_Stock);
// Dt_StockInfo dt_StockInfo2 = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
// string part2 = targetCodes[1].Substring(0, 2); //解析物料批次找详情
// Dt_InboundOrder dt_Int = _inboundService.InbounOrderService.Repository.QueryFirst(x => x.UpperOrderNo == part2);
// Dt_StockInfoDetail dt_StockInfoDetail = new()
// {
// StockId = dt_StockInfo2.Id,
// MaterielCode = dt_Inbound.OrderName, //物料号
// MaterielName = dt_Inbound.UpperOrderNo, //物料名称
// OrderNo = dt_Inbound.OrderNo, //物料详情
// BatchNo = targetCodes[1].ToString(), //物料批次
// SerialNumber = targetCodes[2].ToString(), //包号
// BatchNoName = dt_Int.OrderNo,
// //StockQuantity = decimal.Parse(targetCodes[3].ToString()), //重量
// OutboundQuantity = 1, //序列号
// Status = (int)StockStatusEmun.组盘暂存,
// Creater = "WMS",
// CreateDate = DateTime.Now,
// };
// _stockService.StockInfoDetailService.AddData(dt_StockInfoDetail);
// _unitOfWorkManage.CommitTran();
// if (locationInfos.Count < 50)
// {
// return content = WebResponseContent.Instance.OK(data: 1);
// }
// else
// {
// return content = WebResponseContent.Instance.OK(data: 3);
// }
// }
// else
// {
// if (dt_StockInfo.StockStatus == (int)StockStatusEmun.组盘暂存)
// {
// if (locationInfos.Count < 50)
// {
// return content = WebResponseContent.Instance.OK(data: 1);
// }
// else
// {
// return content = WebResponseContent.Instance.OK(data: 3);
// }
// }
// else
// {
// return content = WebResponseContent.Instance.Error($"库存已有该条码,条码信息:{generate.PalletCode}");
// }
// }
// }
// else if (dt_Inbound.OrderType == (int)InventoryMaterialType.成品)
// {
// if (dt_StockInfo == null)
// {
// Dt_StockInfo dt_Stock = new()
// {
// PalletCode = generate.PalletCode,
// IsFull = true,
// StockStatus = (int)StockStatusEmun.组盘暂存,
// Creater = "WMS",
// CreateDate = DateTime.Now,
// MaterialType = (int)InventoryMaterialType.成品,
// Materialweight = decimal.Parse(targetCodes[3]),
// Wlstatus = (int)InventoryMaterialStatus.待检,
// Mgeneratetime = DateTime.Now,
// };
// _unitOfWorkManage.BeginTran();
// _stockService.StockInfoService.Repository.AddData(dt_Stock);
// Dt_StockInfo dt_StockInfo2 = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
// Dt_StockInfoDetail dt_StockInfoDetail = new()
// {
// StockId = dt_StockInfo2.Id,
// MaterielCode = dt_Inbound.OrderName, //物料号
// MaterielName = dt_Inbound.UpperOrderNo, //物料名称
// OrderNo = dt_Inbound.OrderNo, //物料详情
// BatchNo = targetCodes[1].ToString(), //物料批次
// BatchNoName = "",
// SerialNumber = targetCodes[2], //包号
// //StockQuantity = decimal.Parse(targetCodes[3]), //重量
// OutboundQuantity = 1, //序列号
// Status = (int)StockStatusEmun.组盘暂存,
// Creater = "WMS",
// CreateDate = DateTime.Now,
// };
// _stockService.StockInfoDetailService.AddData(dt_StockInfoDetail);
// _unitOfWorkManage.CommitTran();
// return content = WebResponseContent.Instance.OK(data: 1);
// }
// else
// {
// if (dt_StockInfo.StockStatus == (int)StockStatusEmun.组盘暂存)
// {
// return content = WebResponseContent.Instance.OK(data: 1);
// }
// else
// {
// return content = WebResponseContent.Instance.Error($"库存已有该条码,条码信息:{generate.PalletCode}");
// }
// }
// }
// else
// {
// return content = WebResponseContent.Instance.Error($"未找到条码解析,条码信息:{generate.PalletCode}");
// }
// }
// else
// {
// return content = WebResponseContent.Instance.Error($"未找到入库单,条码信息:{generate.PalletCode}");
// }
// }
// else
// {
// return content = WebResponseContent.Instance.Error($"解析的托盘条码长度不足4,条码信息:{generate.PalletCode}");
// }
// }
// catch (Exception ex)
// {
// return content = WebResponseContent.Instance.Error($"系统巷道入库接口解析错误:错误:{ex.Message}");
// throw;
// }
//}
//public WebResponseContent Queryinventory2(GenerateInv generate)
//{
// try
// {
// WebResponseContent content = new WebResponseContent();
// string result = generate.PalletCode.Substring(0, 2);
// if (result == "B-")
// {
// Dt_StockInfo dt_StockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
// if (dt_StockInfo == null)
// {
// Dt_StockInfo dt_Stock = new()
// {
// PalletCode = generate.PalletCode,
// IsFull = true,
// StockStatus = (int)StockStatusEmun.组盘暂存,
// Creater = "WMS",
// CreateDate = DateTime.Now,
// MaterialType = (int)InventoryMaterialType.成品,
// Materialweight = 0,
// };
// _unitOfWorkManage.BeginTran();
// _stockService.StockInfoService.Repository.AddData(dt_Stock);
// //string part2 = generate.PalletCode.Substring(2, 8);
// //string part3 = generate.PalletCode.Split('#')[1];
// Dt_StockInfo dt_StockInfo2 = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
// Dt_StockInfoDetail dt_StockInfoDetail = new()
// {
// StockId = dt_StockInfo2.Id,
// MaterielCode = dt_StockInfo2.PalletCode, //物料编号
// MaterielName = dt_StockInfo2.PalletCode, //材质
// OrderNo = dt_StockInfo2.PalletCode, //单据(托盘条码)
// BatchNo = dt_StockInfo2.PalletCode, //批次号
// SerialNumber = dt_StockInfo2.PalletCode, //序列号
// StockQuantity = 1, //序列号
// OutboundQuantity = 1, //序列号
// Status = (int)StockStatusEmun.组盘暂存,
// Creater = "WMS",
// CreateDate = DateTime.Now,
// };
// _stockService.StockInfoDetailService.AddData(dt_StockInfoDetail);
// _unitOfWorkManage.CommitTran();
// return content = WebResponseContent.Instance.OK(data: 1);
// }
// else
// {
// if (dt_StockInfo.StockStatus == (int)StockStatusEmun.组盘暂存)
// {
// return content = WebResponseContent.Instance.OK(data: 1);
// }
// else
// {
// return content = WebResponseContent.Instance.Error($"库存已有该条码,条码信息:{generate.PalletCode}");
// }
// }
// }
// else
// {
// Dt_InboundOrder dt_Inbound = _inboundService.InbounOrderService.Repository.QueryFirst(x => x.UpperOrderNo == result);
// Dt_StockInfo dt_StockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
// List locationinfoData = _basicService.LocationInfoService.Repository.QueryData(x => x.RoadwayNo == "2" && x.LocationStatus == LocationStatusEnum.Free.ObjToInt()
// && x.LocationType == (int)LocationTypeEnum.MaterialsCube);
// if (dt_Inbound != null)
// {
// if (dt_StockInfo == null)
// {
// Dt_StockInfo dt_Stock = new()
// {
// PalletCode = generate.PalletCode,
// IsFull = true,
// StockStatus = (int)StockStatusEmun.组盘暂存,
// Creater = "WMS",
// CreateDate = DateTime.Now,
// MaterialType = (int)InventoryMaterialType.原材料,
// Materialweight = 0,
// };
// _unitOfWorkManage.BeginTran();
// _stockService.StockInfoService.Repository.AddData(dt_Stock);
// string part2 = generate.PalletCode.Substring(2, 8);
// string part3 = generate.PalletCode.Split('#')[1];
// Dt_StockInfo dt_StockInfo2 = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
// Dt_StockInfoDetail dt_StockInfoDetail = new()
// {
// StockId = dt_StockInfo2.Id,
// MaterielCode = result, //物料编号
// MaterielName = dt_Inbound.OrderNo, //材质
// OrderNo = generate.PalletCode, //单据(托盘条码)
// BatchNo = part2, //批次号
// SerialNumber = part3, //序列号
// StockQuantity = 1, //序列号
// OutboundQuantity = 1, //序列号
// Status = (int)StockStatusEmun.组盘暂存,
// Creater = "WMS",
// CreateDate = DateTime.Now,
// };
// _stockService.StockInfoDetailService.AddData(dt_StockInfoDetail);
// _unitOfWorkManage.CommitTran();
// if (locationinfoData.Count > 40)
// {
// return content = WebResponseContent.Instance.OK(data: 3);
// }
// else
// {
// return content = WebResponseContent.Instance.OK(data: 1);
// }
// }
// else
// {
// if (dt_StockInfo.StockStatus == (int)StockStatusEmun.组盘暂存)
// {
// if (locationinfoData.Count > 40)
// {
// return content = WebResponseContent.Instance.OK(data: 3);
// }
// else
// {
// return content = WebResponseContent.Instance.OK(data: 1);
// }
// }
// else
// {
// return content = WebResponseContent.Instance.Error($"库存已有该条码,条码信息:{generate.PalletCode}");
// }
// }
// }
// else
// {
// return content = WebResponseContent.Instance.Error("未找到该类型的解析");
// }
// }
// }
// catch (Exception ex)
// {
// throw;
// }
//}
}
}