| | |
| | | var weight = saveModel.MainData["weight"].ObjToInt(); |
| | | //å¹
宽 |
| | | var wide = saveModel.MainData["wide"].ObjToInt(); |
| | | Dt_MaterielInfo? materielInfo = _basicRepository.MaterielInfoRepository.QueryFirst(x=>x.MaterielCode== materSn); |
| | | Dt_MaterielInfo? materielInfo = _basicRepository.MaterielInfoRepository.QueryFirst(x => x.MaterielCode == materSn); |
| | | if (materielInfo==null) |
| | | { |
| | | return content.Error("æªæ¾å°ç©æä¿¡æ¯"); |
| | |
| | | PalletType = 1, |
| | | WarehouseId=warehouseId, |
| | | StockAttribute= materielInfo.MaterielSourceType, |
| | | StockStatus=StockStatusEmun.æå¨ç»çæå.ObjToInt(), |
| | | StockStatus= StockStatusEmun.æå¨ç»çæå.ObjToInt(), |
| | | MaterielSpec=materielInfo.MaterielSpec, |
| | | Unit=materielInfo.MaterielUnit, |
| | | MaterielThickness=thickness, |
| | |
| | | return content; |
| | | } |
| | | |
| | | public List<Dt_StockInfo> GetUseableStocks(string materielCode, string batchNo, int warehoseId) |
| | | public List<Dt_StockInfo> GetUseableStocks(int materielId,decimal width, int warehoseId) |
| | | { |
| | | List<string> locationCodes = _basicRepository.LocationInfoRepository.GetCanOutLocationCodes(warehoseId); |
| | | |
| | | return BaseDal.GetStockInfos(materielCode, batchNo, locationCodes); |
| | | return BaseDal.GetStockInfos(materielId,width, locationCodes); |
| | | } |
| | | |
| | | public List<Dt_StockInfo> GetUseableStocks(string materielCode, string batchNo, string palletcode, int warehoseId) |
| | | /// <summary> |
| | | /// åé
å®é
åºå |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | public List<Dt_StockInfo> GetOutboundStocks(List<Dt_StockInfo> stockInfos, decimal needQuantity) |
| | | { |
| | | Dt_StockInfo stockInfo = BaseDal.Db.Queryable<Dt_StockInfo>().Where(x => x.PalletCode == palletcode && x.WarehouseId == warehoseId).First(); |
| | | |
| | | List<string> locationCodes = _basicRepository.LocationInfoRepository.GetCanOutLocationCodes(stockInfo.LocationCode); |
| | | |
| | | return BaseDal.GetStockInfos(materielCode, batchNo, locationCodes); |
| | | List<Dt_StockInfo> outStocks = new List<Dt_StockInfo>(); |
| | | //è·ååºåå¯ç¨æ°é |
| | | decimal stockTotalQuantity = stockInfos.Sum(x => x.StockLength-x.StockOutLength); |
| | | if (stockTotalQuantity >= needQuantity)//åºåå¤ |
| | | { |
| | | int index = 0; |
| | | while (needQuantity > 0) |
| | | { |
| | | Dt_StockInfo stockInfo = stockInfos[index]; |
| | | decimal useableStockQuantity = stockInfo.StockLength-stockInfo.StockOutLength; |
| | | if (useableStockQuantity < needQuantity && useableStockQuantity > 0) |
| | | { |
| | | stockInfo.StockOutLength=stockInfo.StockLength; |
| | | needQuantity -= useableStockQuantity; |
| | | } |
| | | else |
| | | { |
| | | stockInfo.StockOutLength += needQuantity; |
| | | needQuantity = 0; |
| | | } |
| | | outStocks.Add(stockInfo); |
| | | index++; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | throw new Exception("åºåä¸è¶³"); |
| | | } |
| | | return outStocks; |
| | | } |
| | | |
| | | } |
| | | } |