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