| | |
| | | { |
| | | try |
| | | { |
| | | List<Dt_OutStockLockInfo> outStockLockInfos = _outboundLockInfoService.Repository.QueryData(x => x.PalletCode == palletCode && x.OrderNo == orderNo); |
| | | return WebResponseContent.Instance.OK(data: outStockLockInfos); |
| | | Dt_StockInfo stockInfo = _stockInfoRepository.Db.Queryable<Dt_StockInfo>().Where(x => x.PalletCode == palletCode).Includes(x => x.Details).First(); |
| | | bool isMatMixed = false; |
| | | if (stockInfo != null) |
| | | { |
| | | isMatMixed = stockInfo.Details.GroupBy(x => new |
| | | { |
| | | x.MaterielCode, |
| | | x.MaterielName, |
| | | x.BatchNo, |
| | | x.SupplyCode, |
| | | x.WarehouseCode |
| | | }).Count() > 1; |
| | | } |
| | | |
| | | |
| | | List<Dt_OutStockLockInfo> outStockLockInfos = _outboundLockInfoRepository.QueryData(x => x.PalletCode == palletCode && x.OrderNo == orderNo); |
| | | return WebResponseContent.Instance.OK(data: new { outStockLockInfos, stockInfo, isMatMixed }); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | |
| | | try |
| | | { |
| | | // 鏋勫缓鏌ヨ鏉′欢 |
| | | var query = _stockChangeService.Repository.Db |
| | | var query = _stockChangeRepository.Db |
| | | .Queryable<Dt_StockQuantityChangeRecord>() |
| | | .LeftJoin<Dt_OutboundOrder>((r, o) => r.OrderNo == o.OrderNo) |
| | | .Where((r, o) => r.ChangeType == (int)StockChangeTypeEnum.Outbound) |