MeiRuiAn/HuaiAn.git

			@@ -20,6 +20,7 @@
			using WIDESEA_IStockRepository;
			using WIDESEA_IStockService;
			using WIDESEA_Model.Models;
			using WIDESEA_StockRepository;

			namespace WIDESEA_StockService
			{
			@@ -54,7 +55,7 @@
			throw new Exception($"鏈壘鍒板嚭搴撳崟淇℃伅");
			}

			List<string> locationCodes = _basicRepository.LocationInfoRepository.GetCanOutLocationCodes(outboundOrder.WarehouseId);
			List<string> locationCodes = _basicRepository.LocationInfoRepository.PPGetCanOutLocationCodes(outboundOrder.WarehouseId);

			return BaseDal.QueryTabs<Dt_StockInfo, Dt_StockInfoDetail, StockSelectViewDTO>((a, b) => a.Id == b.StockId, (a, b) => new StockSelectViewDTO
			{
			@@ -114,6 +115,92 @@
			return null;
			}
			}
			/// <summary>
			/// 鏌ヨ璁㈠崟PP绔嬪簱搴撳瓨瑙嗗浘
			/// </summary>
			/// <param name="orderId"></param>
			/// <param name="materielCode"></param>
			/// <returns></returns>
			public List<PPStockSelectViewDTO> PPGetStockSelectViews(int orderId, string materielCode)
			{
			try
			{
			Dt_MesPPCutOutboundOrder mesPPCutOutboundOrder = _outboundRepository.MesPPCutOutboundOrderRepository.QueryFirst(x => x.Id == orderId);
			if (mesPPCutOutboundOrder == null)
			{
			throw new Exception($"鏈壘鍒板嚭搴撳崟淇℃伅");
			}
			List<string> locationCodes = _basicRepository.LocationInfoRepository.PPGetCanOutLocationCodes(mesPPCutOutboundOrder.WarehouseId);

			return BaseDal.QueryTabs<Dt_StockInfo, Dt_StockInfoDetail, PPStockSelectViewDTO>((a, b) => a.Id == b.StockId, (a, b) => new PPStockSelectViewDTO
			{
			LocationCode = a.LocationCode,
			MaterielCode = b.MaterielCode,
			MaterielName = b.MaterielName,
			PalletCode = a.PalletCode,
			Unit = b.Unit,
			CutedWidth = b.CutedWidth,
			UseableQuantity = b.StockQuantity - b.OutboundQuantity
			}, a => locationCodes.Contains(a.LocationCode), b => b.StockQuantity > b.OutboundQuantity && b.MaterielCode == materielCode, x => true).GroupBy(x => x.PalletCode).Select(x => new PPStockSelectViewDTO
			{
			LocationCode = x.FirstOrDefault()?.LocationCode ?? "",
			MaterielCode = x.FirstOrDefault()?.MaterielCode ?? "",
			MaterielName = x.FirstOrDefault()?.MaterielName ?? "",
			Unit = x.FirstOrDefault()?.Unit ?? "",
			CutedWidth = x.Sum(x => x.CutedWidth),
			PalletCode = x.Key,
			UseableQuantity = x.Sum(x => x.UseableQuantity)
			}).ToList();
			}
			catch (Exception ex)
			{

			return null;
			}
			}

			/// <summary>
			/// 鏌ヨ璁㈠崟PP骞冲簱搴撳瓨瑙嗗浘
			/// </summary>
			/// <param name="orderId"></param>
			/// <param name="materielCode"></param>
			/// <returns></returns>
			public List<PPStockSelectViewDTO> PPGetPKStockSelectViews(int orderId, string materielCode)
			{
			try
			{
			Dt_MesPPCutOutboundOrder outboundOrder = _outboundRepository.MesPPCutOutboundOrderRepository.QueryFirst(x => x.Id == orderId);
			if (outboundOrder == null)
			{
			throw new Exception($"鏈壘鍒板嚭搴撳崟淇℃伅");
			}
			return BaseDal.QueryTabs<Dt_StockInfo, Dt_StockInfoDetail, PPStockSelectViewDTO>((a, b) => a.Id == b.StockId && a.WarehouseId == outboundOrder.WarehouseId, (a, b) => new PPStockSelectViewDTO
			{
			LocationCode = a.LocationCode,
			MaterielCode = b.MaterielCode,
			MaterielName = b.MaterielName,
			PalletCode = a.PalletCode,
			Unit = b.Unit,
			CutedWidth = b.CutedWidth,
			UseableQuantity = b.StockQuantity - b.OutboundQuantity
			}, a => a.LocationCode.Contains("AGV_PP"), b => b.StockQuantity > b.OutboundQuantity && b.MaterielCode == materielCode, x => true).GroupBy(x => x.PalletCode).Select(x => new PPStockSelectViewDTO
			{
			LocationCode = x.FirstOrDefault()?.LocationCode ?? "",
			MaterielCode = x.FirstOrDefault()?.MaterielCode ?? "",
			MaterielName = x.FirstOrDefault()?.MaterielName ?? "",
			Unit = x.FirstOrDefault()?.Unit ?? "",
			CutedWidth = x.Sum(x => x.CutedWidth),
			PalletCode = x.Key,
			UseableQuantity = x.Sum(x => x.UseableQuantity)
			}).ToList();
			}
			catch (Exception ex)
			{
			return null;
			}
			}



			public WebResponseContent StockQueryData(SaveModel saveModel)
			{
			@@ -150,7 +237,7 @@
			{
			Dt_StockInfo stockInfo = stockInfos[index];
			float useableStockQuantity = stockInfo.Details.Where(x => x.MaterielCode == materielCode).Sum(x => x.StockQuantity - x.OutboundQuantity);
			if (useableStockQuantity < needQuantity)
			if (useableStockQuantity < needQuantity && useableStockQuantity>0)
			{
			stockInfo.Details.ForEach(x => x.OutboundQuantity = x.StockQuantity);
			needQuantity -= useableStockQuantity;
			@@ -180,36 +267,7 @@
			}
			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;
			@@ -221,5 +279,15 @@

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

			}
			}