From 9ce6731460179c71f0f2c636b2a1598324d5194e Mon Sep 17 00:00:00 2001 From: wangxinhui <wangxinhui@hnkhzn.com> Date: 星期六, 20 九月 2025 15:16:48 +0800 Subject: [PATCH] 最新代码更新 --- 项目代码/WMS/WMSServices/WIDESEA_StockService/StockInfoService.cs | 158 ++++++++++++++++++++++++++-------------------------- 1 files changed, 80 insertions(+), 78 deletions(-) diff --git "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WMSServices/WIDESEA_StockService/StockInfoService.cs" "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WMSServices/WIDESEA_StockService/StockInfoService.cs" index ca9e52c..b4cc9c5 100644 --- "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WMSServices/WIDESEA_StockService/StockInfoService.cs" +++ "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WMSServices/WIDESEA_StockService/StockInfoService.cs" @@ -9,9 +9,11 @@ using System.Threading.Tasks; using WIDESEA_Common.StockEnum; using WIDESEA_Core; +using WIDESEA_Core.BaseRepository; using WIDESEA_Core.BaseServices; using WIDESEA_Core.Enums; using WIDESEA_Core.Helper; +using WIDESEA_DTO.Basic; using WIDESEA_DTO.Stock; using WIDESEA_IBasicRepository; using WIDESEA_IRecordRepository; @@ -27,13 +29,14 @@ { private readonly IMapper _mapper; private readonly IBasicRepository _basicRepository; - + private readonly IUnitOfWorkManage _unitOfWorkManage; public IStockInfoRepository Repository => BaseDal; - public StockInfoService(IStockInfoRepository BaseDal, IMapper mapper, IBasicRepository basicRepository) : base(BaseDal) + public StockInfoService(IStockInfoRepository BaseDal, IMapper mapper, IBasicRepository basicRepository, IUnitOfWorkManage unitOfWorkManage) : base(BaseDal) { _mapper = mapper; _basicRepository = basicRepository; + _unitOfWorkManage = unitOfWorkManage; } @@ -45,7 +48,7 @@ { var barcode = saveModel.MainData["barcode"].ToString(); var warehouseId = saveModel.MainData["warehouseId"].ObjToInt(); - Dt_StockInfo stockInfo = BaseDal.Db.Queryable<Dt_StockInfo>().Where(x => x.PalletCode == barcode && x.WarehouseId == warehouseId).Includes(x => x.Details).First(); + Dt_StockInfo stockInfo = BaseDal.Db.Queryable<Dt_StockInfo>().Where(x => x.PalletCode == barcode && x.WarehouseId == warehouseId).First(); if (stockInfo == null) throw new Exception("鏈壘鍒版墭鐩樹俊鎭�"); return WebResponseContent.Instance.OK(data: stockInfo); } @@ -54,49 +57,95 @@ return WebResponseContent.Instance.Error(ex.Message); } } + + public WebResponseContent ManualMaterielGroup(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 wide = saveModel.MainData["wide"].ObjToInt(); + Dt_MaterielInfo? materielInfo = _basicRepository.MaterielInfoRepository.QueryFirst(x => x.MaterielCode == materSn); + if (materielInfo==null) + { + return content.Error("鏈壘鍒扮墿鏂欎俊鎭�"); + } + Dt_StockInfo stockInfoOld = BaseDal.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; + } + BaseDal.AddData(stockInfo); + content.OK("缁勭洏鎴愬姛"); + } + catch (Exception ex) + { + _unitOfWorkManage.RollbackTran(); + content.Error(ex.Message); + } + return content; + } + + public List<Dt_StockInfo> GetUseableStocks(int materielId,decimal width, int warehoseId) + { + List<string> locationCodes = _basicRepository.LocationInfoRepository.GetCanOutLocationCodes(warehoseId); + + return BaseDal.GetStockInfos(materielId,width, locationCodes); + } + /// <summary> - /// + /// 鍒嗛厤瀹為檯搴撳瓨 /// </summary> - /// <param name="stockInfos"></param> - /// <param name="materielCode"></param> - /// <param name="needQuantity"></param> - /// <param name="residueQuantity"></param> /// <returns></returns> - public List<Dt_StockInfo> GetOutboundStocks(List<Dt_StockInfo> stockInfos, string materielCode, float needQuantity, out float residueQuantity) + public List<Dt_StockInfo> GetOutboundStocks(List<Dt_StockInfo> stockInfos, decimal needQuantity) { List<Dt_StockInfo> outStocks = new List<Dt_StockInfo>(); - float stockTotalQuantity = stockInfos.Select(x => x.Details.Sum(v => v.StockQuantity - v.OutboundQuantity)).Sum(x => x); - //stockInfos = stockInfos.OrderBy(x => x.Id).ToList(); + //鑾峰彇搴撳瓨鍙敤鏁伴噺 + decimal stockTotalQuantity = stockInfos.Sum(x => x.StockLength-x.StockOutLength); if (stockTotalQuantity >= needQuantity)//搴撳瓨澶� { int index = 0; while (needQuantity > 0) { Dt_StockInfo stockInfo = stockInfos[index]; - float useableStockQuantity = stockInfo.Details.Where(x => x.MaterielCode == materielCode).Sum(x => x.StockQuantity - x.OutboundQuantity); - if (useableStockQuantity < needQuantity && useableStockQuantity>0) + decimal useableStockQuantity = stockInfo.StockLength-stockInfo.StockOutLength; + if (useableStockQuantity < needQuantity && useableStockQuantity > 0) { - stockInfo.Details.ForEach(x => x.OutboundQuantity = x.StockQuantity); + stockInfo.StockOutLength=stockInfo.StockLength; needQuantity -= useableStockQuantity; } else { - stockInfo.Details.ForEach(x => - { - if (x.StockQuantity > x.OutboundQuantity && x.MaterielCode == materielCode) - { - if (x.StockQuantity - x.OutboundQuantity >= needQuantity) - { - x.OutboundQuantity += needQuantity; - needQuantity = 0; - } - else - { - needQuantity -= (x.StockQuantity - x.OutboundQuantity); - x.OutboundQuantity = x.StockQuantity; - } - } - }); + stockInfo.StockOutLength += needQuantity; + needQuantity = 0; } outStocks.Add(stockInfo); index++; @@ -104,56 +153,9 @@ } else { - for (int i = 0; i < stockInfos.Count; i++) - { - Dt_StockInfo stockInfo = stockInfos[i]; - float useableStockQuantity = stockInfo.Details.Where(x => x.MaterielCode == materielCode).Sum(x => x.StockQuantity - x.OutboundQuantity); - if (useableStockQuantity < needQuantity) - { - stockInfo.Details.ForEach(x => x.OutboundQuantity = x.StockQuantity); - needQuantity -= useableStockQuantity; - } - else - { - stockInfo.Details.ForEach(x => - { - if (x.StockQuantity > x.OutboundQuantity && x.MaterielCode == materielCode) - { - if (x.StockQuantity - x.OutboundQuantity >= needQuantity) - { - x.OutboundQuantity += needQuantity; - needQuantity = 0; - } - else - { - needQuantity -= (x.StockQuantity - x.OutboundQuantity); - x.OutboundQuantity = x.StockQuantity; - } - } - }); - } - outStocks.Add(stockInfo); - } + throw new Exception("搴撳瓨涓嶈冻"); } - residueQuantity = needQuantity; return outStocks; } - - public List<Dt_StockInfo> GetUseableStocks(string materielCode, string batchNo, int warehoseId) - { - List<string> locationCodes = _basicRepository.LocationInfoRepository.GetCanOutLocationCodes(warehoseId); - - return BaseDal.GetStockInfos(materielCode, batchNo, locationCodes); - } - - public List<Dt_StockInfo> GetUseableStocks(string materielCode, string batchNo, string palletcode, int warehoseId) - { - Dt_StockInfo stockInfo = BaseDal.Db.Queryable<Dt_StockInfo>().Where(x => x.PalletCode == palletcode && x.WarehouseId == warehoseId).Includes(x => x.Details).First(); - - List<string> locationCodes = _basicRepository.LocationInfoRepository.GetCanOutLocationCodes(stockInfo.LocationCode); - - return BaseDal.GetStockInfos(materielCode, batchNo, locationCodes); - } - } } -- Gitblit v1.9.3