From dc06f58d8ed537555fd529551180f43a0586ec3f Mon Sep 17 00:00:00 2001 From: helongyang <647556386@qq.com> Date: 星期日, 22 六月 2025 11:44:43 +0800 Subject: [PATCH] Merge branch 'master' of http://115.159.85.185:8098/r/MeiRuiAn/HuaiAn --- 代码管理/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/MesTaskService.cs | 461 +++++++++++++++++++++++++++++++-------------------------- 1 files changed, 248 insertions(+), 213 deletions(-) diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/MesTaskService.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/MesTaskService.cs" index 519fc8e..1fad87f 100644 --- "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/MesTaskService.cs" +++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/MesTaskService.cs" @@ -29,12 +29,16 @@ using WIDESEA_DTO.Task; using WIDESEA_DTO.Stock; using SqlSugar; +using OfficeOpenXml.FormulaParsing.Excel.Functions.RefAndLookup; +using OfficeOpenXml.FormulaParsing.Excel.Functions.Math; namespace WIDESEA_TaskInfoService { public partial class TaskService { static object lock_out = new object(); + + static object solderMask_out = new object(); /// <summary> /// 娴嬭瘯鏋跺嚭浠� @@ -76,7 +80,7 @@ (x.EnableStatus == (int)EnableStatusEnum.Normal || x.EnableStatus == (int)EnableStatusEnum.OnlyOut)); if (locationInfo == null) { - return responseContent.Error($"娴嬭瘯鏋惰揣浣嶃�傘�傘�傘�傘�傘�傘�傘�傘��:{stockInfo.LocationCode}鍑哄簱鏉′欢涓嶆弧瓒�"); + return responseContent.Error($"娴嬭瘯鏋惰揣浣�:{stockInfo.LocationCode}鍑哄簱鏉′欢涓嶆弧瓒�"); } //鐢熸垚娴嬭瘯鏋跺嚭搴撲换鍔� 閿佸畾搴撳瓨 鏇存敼璐т綅鐘舵�� Dt_Task taskOut = new() @@ -94,6 +98,13 @@ PalletType = stockInfo.PalletType, WarehouseId = stockInfo.WarehouseId, }; + string MaterielCode = stockInfo.Details.Where(x => x.StockId == stockInfo.Id).FirstOrDefault()?.MaterielCode; + float Quantity = (float)stockInfo.Details.Where(x => x.StockId == stockInfo.Id).Sum(x => x.StockQuantity); + if (MaterielCode != null && Quantity != null) + { + taskOut.MaterielCode = MaterielCode; + taskOut.Quantity = Quantity; + } stockInfo.StockStatus = (int)StockStatusEmun.鍑哄簱閿佸畾; LocationStatusEnum locationStatus = (LocationStatusEnum)locationInfo.LocationStatus; locationInfo.LocationStatus = (int)LocationStatusEnum.Lock; @@ -110,6 +121,170 @@ _unitOfWorkManage.CommitTran(); //灏嗕换鍔℃帹閫佸埌WCS PushTasksToWCS(new List<Dt_Task>() { taskOut }, "AGV_CSJ"); + responseContent.OK(); + } + catch (Exception ex) + { + _unitOfWorkManage.RollbackTran(); + responseContent.Error(ex.Message); + } + return responseContent; + } + } + public MesResponseContent SolderMaskOutNotice(SolderMaskOutNotice model) + { + lock (solderMask_out) + { + MesResponseContent responseContent = new MesResponseContent(); + try + { + + Dt_Warehouse warehouse = _basicRepository.WarehouseRepository.QueryFirst(x => x.WarehouseCode == WarehouseEnum.HA154.ToString()); + //鑾峰彇搴撳瓨璁板綍 + List<Dt_StockInfo> stockInfos = _stockRepository.StockInfoRepository.Db.Queryable<Dt_StockInfo>().Where(x => + x.WarehouseId == warehouse.WarehouseId && + x.StockStatus == (int)StockStatusEmun.鍏ュ簱瀹屾垚).Includes(x => x.Details).ToList(); + Dt_StockInfo? stockInfo = stockInfos.FirstOrDefault(x => x.Details.Any(x => x.BatchNo == model.LotNo)); + if (stockInfo == null) + { + return responseContent.Error($"闃茬剨搴�:鏃爗model.LotNo}鍙敤搴撳瓨"); + } + Dt_Task exsit2 = Repository.QueryFirst(x => x.PalletCode == stockInfo.PalletCode); + if (exsit2 != null) + { + return responseContent.Error($"闃茬剨浠诲姟{stockInfo.PalletCode}宸插瓨鍦�"); + } + + Dt_LocationInfo locationInfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == stockInfo.LocationCode && + x.WarehouseId == stockInfo.WarehouseId && + x.LocationStatus == (int)LocationStatusEnum.InStock && + (x.EnableStatus == (int)EnableStatusEnum.Normal || x.EnableStatus == (int)EnableStatusEnum.OnlyOut)); + if (locationInfo == null) + { + return responseContent.Error($"闃茬剨璐т綅:{stockInfo.LocationCode}鍑哄簱鏉′欢涓嶆弧瓒�"); + } + //鐢熸垚闃茬剨鍑哄簱浠诲姟 閿佸畾搴撳瓨 鏇存敼璐т綅鐘舵�� + Dt_Task taskOut = new() + { + CurrentAddress = stockInfo.LocationCode, + Grade = 0, + PalletCode = stockInfo.PalletCode, + NextAddress = "", + Roadway = locationInfo.RoadwayNo, + SourceAddress = stockInfo.LocationCode, + TargetAddress = model.TargetAddressCode, + TaskStatus = (int)TaskStatusEnum.New, + TaskType = stockInfo.PalletType<2 ? (int)TaskTypeEnum.MaskOutNoticeSmall : (int)TaskTypeEnum.MaskOutNoticeLarge, + TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)), + PalletType = stockInfo.PalletType, + WarehouseId = stockInfo.WarehouseId, + }; + string MaterielCode = stockInfo.Details.Where(x => x.StockId == stockInfo.Id).FirstOrDefault()?.MaterielCode; + float Quantity = (float)stockInfo.Details.Where(x => x.StockId == stockInfo.Id).Sum(x => x.StockQuantity); + if (MaterielCode != null && Quantity != null) + { + taskOut.MaterielCode = MaterielCode; + taskOut.Quantity = Quantity; + } + stockInfo.StockStatus = (int)StockStatusEmun.鍑哄簱閿佸畾; + LocationStatusEnum locationStatus = (LocationStatusEnum)locationInfo.LocationStatus; + locationInfo.LocationStatus = (int)LocationStatusEnum.Lock; + //鍒ゆ柇鏄惁鏈夊嚭搴撳崟淇℃伅 + _unitOfWorkManage.BeginTran(); + //鏇存柊搴撳瓨鐘舵�� + _stockRepository.StockInfoRepository.UpdateData(stockInfo); + //鏇存柊璐т綅鐘舵�� + _basicService.LocationInfoService.UpdateLocationStatus(locationInfo, stockInfo.PalletType, LocationStatusEnum.Lock, stockInfo.WarehouseId); + //鏂板缓浠诲姟 + BaseDal.AddData(taskOut); + //鍔犲叆璐т綅鍙樺姩璁板綍 + _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfo, locationStatus, LocationStatusEnum.Lock, LocationChangeType.OutboundAssignLocation, stockInfo.Details.FirstOrDefault()?.OrderNo ?? "", taskOut.TaskNum); + _unitOfWorkManage.CommitTran(); + //灏嗕换鍔℃帹閫佸埌WCS + PushTasksToWCS(new List<Dt_Task>() { taskOut }, "AGV_ZH"); + responseContent.OK(); + } + catch (Exception ex) + { + _unitOfWorkManage.RollbackTran(); + responseContent.Error(ex.Message); + } + return responseContent; + } + } + + public MesResponseContent SolderMaskOut(SolderMaskOut model) + { + lock (solderMask_out) + { + MesResponseContent responseContent = new MesResponseContent(); + try + { + + + Dt_Warehouse warehouse = _basicRepository.WarehouseRepository.QueryFirst(x => x.WarehouseCode == WarehouseEnum.HA154.ToString()); + //鑾峰彇搴撳瓨璁板綍 + List<Dt_StockInfo> stockInfos = _stockRepository.StockInfoRepository.Db.Queryable<Dt_StockInfo>().Where(x => + x.WarehouseId == warehouse.WarehouseId && + x.StockStatus == (int)StockStatusEmun.鍏ュ簱瀹屾垚).Includes(x => x.Details).ToList(); + Dt_StockInfo? stockInfo = stockInfos.FirstOrDefault(x => x.Details.Any(x => x.BatchNo == model.LotNo)); + if (stockInfo == null) + { + return responseContent.Error($"闃茬剨搴�:鏃爗model.LotNo}鍙敤搴撳瓨"); + } + Dt_Task exsit2 = Repository.QueryFirst(x => x.PalletCode == stockInfo.PalletCode); + if (exsit2 != null) + { + return responseContent.Error($"闃茬剨浠诲姟{stockInfo.PalletCode}宸插瓨鍦�"); + } + + Dt_LocationInfo locationInfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == stockInfo.LocationCode && + x.WarehouseId == stockInfo.WarehouseId && + x.LocationStatus == (int)LocationStatusEnum.InStock && + (x.EnableStatus == (int)EnableStatusEnum.Normal || x.EnableStatus == (int)EnableStatusEnum.OnlyOut)); + if (locationInfo == null) + { + return responseContent.Error($"闃茬剨璐т綅:{stockInfo.LocationCode}鍑哄簱鏉′欢涓嶆弧瓒�"); + } + //鐢熸垚闃茬剨鍑哄簱浠诲姟 閿佸畾搴撳瓨 鏇存敼璐т綅鐘舵�� + Dt_Task taskOut = new() + { + CurrentAddress = stockInfo.LocationCode, + Grade = 0, + PalletCode = stockInfo.PalletCode, + NextAddress = "", + Roadway = locationInfo.RoadwayNo, + SourceAddress = stockInfo.LocationCode, + TargetAddress = model.TargetAddressCode, + TaskStatus = (int)TaskStatusEnum.New, + TaskType = stockInfo.PalletType < 2 ? (int)TaskTypeEnum.MaskOutSmall : (int)TaskTypeEnum.MaskOutLarge, + TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)), + PalletType = stockInfo.PalletType, + WarehouseId = stockInfo.WarehouseId, + }; + string MaterielCode = stockInfo.Details.Where(x => x.StockId == stockInfo.Id).FirstOrDefault()?.MaterielCode; + float Quantity = (float)stockInfo.Details.Where(x => x.StockId == stockInfo.Id).Sum(x => x.StockQuantity); + if (MaterielCode != null && Quantity != null) + { + taskOut.MaterielCode = MaterielCode; + taskOut.Quantity = Quantity; + } + stockInfo.StockStatus = (int)StockStatusEmun.鍑哄簱閿佸畾; + LocationStatusEnum locationStatus = (LocationStatusEnum)locationInfo.LocationStatus; + locationInfo.LocationStatus = (int)LocationStatusEnum.Lock; + //鍒ゆ柇鏄惁鏈夊嚭搴撳崟淇℃伅 + _unitOfWorkManage.BeginTran(); + //鏇存柊搴撳瓨鐘舵�� + _stockRepository.StockInfoRepository.UpdateData(stockInfo); + //鏇存柊璐т綅鐘舵�� + _basicService.LocationInfoService.UpdateLocationStatus(locationInfo, stockInfo.PalletType, LocationStatusEnum.Lock, stockInfo.WarehouseId); + //鏂板缓浠诲姟 + BaseDal.AddData(taskOut); + //鍔犲叆璐т綅鍙樺姩璁板綍 + _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfo, locationStatus, LocationStatusEnum.Lock, LocationChangeType.OutboundAssignLocation, stockInfo.Details.FirstOrDefault()?.OrderNo ?? "", taskOut.TaskNum); + _unitOfWorkManage.CommitTran(); + //灏嗕换鍔℃帹閫佸埌WCS + PushTasksToWCS(new List<Dt_Task>() { taskOut }, "AGV_ZH"); responseContent.OK(); } catch (Exception ex) @@ -156,6 +331,13 @@ PalletType = stockInfo.PalletType, WarehouseId = stockInfo.WarehouseId, }; + string MaterielCode = stockInfo.Details.Where(x => x.StockId == stockInfo.Id).FirstOrDefault()?.MaterielCode; + float Quantity = (float)stockInfo.Details.Where(x => x.StockId == stockInfo.Id).Sum(x => x.StockQuantity); + if (MaterielCode != null && Quantity != null) + { + taskIn.MaterielCode = MaterielCode; + taskIn.Quantity = Quantity; + } //鏇存敼搴撳瓨鐘舵�� stockInfo.StockStatus = StockStatusEmun.閫�搴�.ObjToInt(); BaseDal.AddData(taskIn); @@ -294,46 +476,6 @@ return content; } /// <summary> - /// WMS鍚屾鎴愬搧鍑哄簱鑷矼ES - /// </summary> - /// <param name="model"></param> - /// <returns></returns> - public WebResponseContent ShipmentOrderSync(MesShipmentOrderSync model) - { - WebResponseContent content = new WebResponseContent(); - try - { - Dt_ApiInfo apiInfo = _apiInfoRepository.QueryFirst(x => x.ApiCode == APIEnum.WMS_MES_ShipmentOrderSync.ToString()); - MESRoot<MesShipmentOrderSync> root = new MESRoot<MesShipmentOrderSync>() - { - From = "WMS", - DateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), - Content = model - }; - JsonSerializerSettings settings = new JsonSerializerSettings - { - ContractResolver = new CamelCasePropertyNamesContractResolver() - }; - string request = JsonConvert.SerializeObject(root, settings); - string response = HttpMesHelper.Post(apiInfo.ApiAddress, request); - MesResponseContent mesResponseContent = response.DeserializeObject<MesResponseContent>(); - //璋冪敤鎺ュ彛 - if (mesResponseContent.BSucc == true) - { - content.OK(mesResponseContent.StrMsg); - } - else - { - content.Error(mesResponseContent.StrMsg); - } - } - catch (Exception ex) - { - content.Error(ex.Message); - } - return content; - } - /// <summary> /// /// </summary> /// <param name="stockInfo"></param> @@ -441,6 +583,7 @@ tasks.ForEach(x => { x.TargetAddress = model.Line; + x.OrderNo = mesOutboundOrder.TaskNo; }); _unitOfWorkManage.BeginTran(); @@ -489,18 +632,25 @@ } Dt_Warehouse warehouse = _basicRepository.WarehouseRepository.QueryFirst(x => x.WarehouseId == palletTypeInfo.WarehouseId); - + //鍒ゆ柇鏄惁鎵樼洏搴撳瓨鏄惁宸插瓨鍦� + Dt_StockInfo stockInfoOld = _stockRepository.StockInfoRepository.QueryFirst(x => x.PalletCode == model.CarrierCode); + if (stockInfoOld != null) + { + return MesResponseContent.Instance.Error($"鎵樼洏鍙峰簱瀛榹model.CarrierCode}宸插瓨鍦�"); + } Dt_StockInfo_Hty stockInfo_Hty = _stockRepository.StockInfo_HtyRepository.QueryData(x => x.PalletCode == model.CarrierCode).OrderByDescending(x => x.SourceId).First(); Dt_StockInfoDetail_Hty stockInfoDetail_Hty = _stockRepository.StockInfoDetail_HtyRepository.QueryFirst(x => x.StockId == stockInfo_Hty.SourceId); + Dt_StockInfoDetail stockInfoDetail = new Dt_StockInfoDetail() { + MaterielSpec = stockInfoDetail_Hty.MaterielSpec, BatchNo = stockInfoDetail_Hty?.BatchNo ?? "", EffectiveDate = model.ExpirationDate, MaterielCode = model.MaterialCode, InboundOrderRowNo = stockInfoDetail_Hty?.InboundOrderRowNo ?? 0, - MaterielName = model.MaterialCode, + MaterielName = stockInfoDetail_Hty.MaterielName, ProductionDate = model.ProductionDate, OrderNo = stockInfoDetail_Hty?.OrderNo ?? "", OutboundQuantity = 0, @@ -653,11 +803,14 @@ //} #endregion + _unitOfWorkManage.BeginTran(); Db.InsertNav(mesOutboundOrder).Include(x => x.Details).ExecuteCommand(); + _unitOfWorkManage.CommitTran(); return MesResponseContent.Instance.OK(); } catch (Exception ex) { + _unitOfWorkManage.RollbackTran(); return MesResponseContent.Instance.Error(ex.Message); } @@ -773,6 +926,7 @@ { try { + //涓�娆″彧鍙戜竴鍗风墿鏂欏叆搴撴槑缁� foreach (var item in model.MaterialLotInfo) { //鑾峰彇鐗╂枡淇℃伅 @@ -899,8 +1053,15 @@ TaskType = TaskTypeEnum.Inbound.ObjToInt(), TaskStatus = TaskStatusEnum.New.ObjToInt(), WarehouseId = stockInfo.WarehouseId, - PalletType = stockInfo.PalletType + PalletType = stockInfo.PalletType, }; + string MaterielCode = stockInfo.Details.Where(x => x.StockId == stockInfo.Id).FirstOrDefault()?.MaterielCode; + float Quantity = (float)stockInfo.Details.Where(x => x.StockId == stockInfo.Id).Sum(x => x.StockQuantity); + if (MaterielCode != null && Quantity != null) + { + newTask.MaterielCode = MaterielCode; + newTask.Quantity = Quantity; + } LocationStatusEnum lastStatus = (LocationStatusEnum)locationInfo.LocationStatus; _unitOfWorkManage.BeginTran(); _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfo, lastStatus, LocationStatusEnum.Lock, LocationChangeType.InboundAssignLocation); @@ -961,171 +1122,8 @@ return MesResponseContent.Instance.Error(ex.Message); } } - /// <summary> - /// MES鎴愬搧鍏ュ簱鍗曟帴鏀� - /// </summary> - /// <returns></returns> - public MesResponseContent BagInfoSync(MesBagInfoModel bagInfoModel) - { - MesResponseContent content = new MesResponseContent(); - try - { - Dt_Warehouse warehouse = _basicRepository.WarehouseRepository.QueryFirst(x => x.WarehouseCode == bagInfoModel.WarehouseCode); - if (warehouse == null) - { - return content.Error("鏈壘鍒颁粨搴撲俊鎭�"); - } - //鍒ゆ柇鏄惁MES鍐呭寘淇℃伅鏄惁閲嶅 - List<Dt_MesProInOrderDetail> mesProInOrderDetails = new List<Dt_MesProInOrderDetail>(); - foreach (var item in bagInfoModel.BagDetails) - { - foreach (var child in item.BagItems) - { - Dt_MesProInOrderDetail mesProInOrderDetail = new Dt_MesProInOrderDetail() - { - BagNo = item.BagNo, - ProductCode = item.ProductCode, - ProductVersion = item.ProductVersion, - SETQty = child.SETQty, - OKPCSQTY = child.OKPCSQTY, - DateCode = item.DateCode, - XQty = child.XQty, - XSite = child.XSite, - Weight = item.Weight, - PackingDate = item.PackingDate, - LotNumber = child.LotNumber, - ERPOrder = child.ERPOrder, - SaleOrder = child.SaleOrder, - MoNumber = child.MoNumber, - }; - mesProInOrderDetails.Add(mesProInOrderDetail); - } - } - List<Dt_ProStockInfoDetail> proStockInfoDetails = new List<Dt_ProStockInfoDetail>(); - foreach (var item in mesProInOrderDetails) - { - proStockInfoDetails.Add(_mapper.Map<Dt_ProStockInfoDetail>(item)); - } - Dt_MesProInOrder mesProInOrder = new Dt_MesProInOrder() - { - WarehouseId = warehouse.WarehouseId, - BatchNo = bagInfoModel.BatchNo, - WorkCenter = bagInfoModel.WorkCenter, - MesProStatus = InOrderStatusEnum.鏈紑濮�.ObjToInt(), - UnPackStock = bagInfoModel.UnPackStock, - Details = mesProInOrderDetails - }; - Dt_ProStockInfo proStockInfo = new Dt_ProStockInfo() - { - PalletCode = bagInfoModel.BatchNo, - PalletType = 1, - WarehouseId = warehouse.WarehouseId, - StockStatus = StockStatusEmun.缁勭洏鏆傚瓨.ObjToInt(), - proStockInfoDetails = proStockInfoDetails - }; - _unitOfWorkManage.BeginTran(); - Db.InsertNav(mesProInOrder).Include(x => x.Details).ExecuteCommand(); - Db.InsertNav(proStockInfo).Include(x => x.proStockInfoDetails).ExecuteCommand(); - _unitOfWorkManage.CommitTran(); - return content.OK("鎺ユ敹鎴愬姛"); - } - catch (Exception ex) - { - _unitOfWorkManage.RollbackTran(); - content.Error(ex.Message); - } - return content; - } - public MesResponseContent BoxStockin(MesBoxInfoModel boxInfoModel) - { - MesResponseContent content = new MesResponseContent(); - try - { - Dt_Warehouse warehouse = _basicRepository.WarehouseRepository.QueryFirst(x => x.WarehouseCode == WarehouseEnum.HA101.ToString()); - //鑾峰彇MES鍐呭寘淇℃伅 - List<Dt_MesProInOrderDetail> mesProInOrderDetails = new List<Dt_MesProInOrderDetail>(); - foreach (var item in boxInfoModel.Bags) - { - foreach (var child in item.BagItems) - { - Dt_MesProInOrderDetail mesProInOrderDetail = new Dt_MesProInOrderDetail() - { - BagNo = item.BagNo, - ProductCode = item.ProductCode, - ProductVersion = item.ProductVersion, - SETQty = child.SETQty, - OKPCSQTY = child.OKPCSQTY, - DateCode = item.DateCode, - XQty = child.XQty, - XSite = child.XSite, - Weight = item.Weight, - PackingDate = item.PackingDate, - LotNumber = child.LotNumber, - ERPOrder = child.ERPOrder, - SaleOrder = child.SaleOrder, - MoNumber = child.MoNumber, - }; - mesProInOrderDetails.Add(mesProInOrderDetail); - } - } - List<Dt_ProStockInfoDetail> proStockInfoDetails = new List<Dt_ProStockInfoDetail>(); - foreach (var item in mesProInOrderDetails) - { - proStockInfoDetails.Add(_mapper.Map<Dt_ProStockInfoDetail>(item)); - } - Dt_ProStockInfo proStockInfo = new Dt_ProStockInfo() - { - PalletCode = boxInfoModel.BoxNo, - PalletType = 0, - WarehouseId = warehouse.WarehouseId, - ShipmentOrder = boxInfoModel.ShipmentOrder, - StockStatus = StockStatusEmun.鍏ュ簱瀹屾垚.ObjToInt(), - proStockInfoDetails = proStockInfoDetails - }; - _unitOfWorkManage.BeginTran(); - Db.InsertNav(proStockInfo).Include(x => x.proStockInfoDetails).ExecuteCommand(); - _unitOfWorkManage.CommitTran(); - return content.OK("澶栧寘鎺ユ敹鎴愬姛"); - } - catch (Exception ex) - { - content.Error(ex.Message); - } - return content; - } - /// <summary> - /// 鎴愬搧杩斿伐鎻愬簱 - /// </summary> - /// <param name="model"></param> - /// <returns></returns> - public MesResponseContent RworkTask(RworkTaskModel model) - { - try - { - Dt_Warehouse warehouse = _basicRepository.WarehouseRepository.QueryFirst(x => x.WarehouseCode == WarehouseEnum.HA72.ToString()); - //鑾峰彇搴撳瓨璁板綍 - List<Dt_StockInfo> stockInfos = _stockRepository.StockInfoRepository.Db.Queryable<Dt_StockInfo>().Where(x => - x.WarehouseId == warehouse.WarehouseId && - x.StockStatus == (int)StockStatusEmun.鍏ュ簱瀹屾垚).Includes(x => x.Details).ToList(); - Dt_StockInfo? stockInfo = stockInfos.FirstOrDefault(x => x.Details.Any(x => x.BatchNo == model.ProductVersion)); - if (stockInfo == null) - { - return MesResponseContent.Instance.Error($"灏炬暟浠�:{model.ProductVersion}鏃犲彲鐢ㄥ簱瀛�"); - } - Dt_Task exsit2 = Repository.QueryFirst(x => x.PalletCode == stockInfo.PalletCode); - - - } - catch (Exception ex) - { - - throw; - } - return MesResponseContent.Instance.OK(); - } - - - + + /// <summary> /// 鐢熸垚PP澶у嵎鍑哄簱浠诲姟 @@ -1618,9 +1616,46 @@ return WebResponseContent.Instance.Error(ex.Message); } } - - - - + /// <summary> + /// 鑾峰彇MES闃荤剨鎵规淇℃伅 + /// </summary> + /// <param name="model"></param> + /// <returns></returns> + public WebResponseContent GetZHMesMaterialLot(string materialLot) + { + WebResponseContent content = new WebResponseContent(); + try + { + Dt_ApiInfo apiInfo = _apiInfoRepository.QueryFirst(x => x.ApiCode == APIEnum.WMS_MES_GetProductByLot.ToString()); + object obj = new { LotNo = materialLot }; + MESRoot<object> root = new MESRoot<object>() + { + From = "WMS", + DateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), + Content = obj + }; + JsonSerializerSettings settings = new JsonSerializerSettings + { + ContractResolver = new CamelCasePropertyNamesContractResolver() + }; + string request = JsonConvert.SerializeObject(root, settings); + string response = HttpMesHelper.Post(apiInfo.ApiAddress, request); + MesResponseContent mesResponseContent = response.DeserializeObject<MesResponseContent>(); + //璋冪敤鎺ュ彛 + if (mesResponseContent.BSucc == true) + { + content.OK(mesResponseContent.StrMsg, mesResponseContent.Content); + } + else + { + content.Error(mesResponseContent.StrMsg); + } + } + catch (Exception ex) + { + content.Error(ex.Message); + } + return content; + } } } -- Gitblit v1.9.3