| | |
| | | |
| | | @Resource |
| | | private OpeUseFlowService opeUseFlowService; |
| | | @Resource |
| | | private OpeWarehouseReserveService opeWarehouseReserveService; |
| | | |
| | | @Resource(name="baseMetaDao") |
| | | private BaseMetaDao baseMetaDao; |
| | |
| | | |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public List<OpeWarehouseReserve> getOpeWarehouseReserveListByName(String reagentId, String supplierId, Integer first, |
| | | Integer pageSize,String productSn) { |
| | | Integer pageSize,String productSn,String warehouseName) { |
| | | try { |
| | | Map<String, Object> params = new HashMap<String, Object>(); |
| | | params.put("reagentName", reagentId); |
| | |
| | | params.put("first", first); |
| | | params.put("pageSize", pageSize); |
| | | params.put("productSn", productSn); |
| | | params.put("warehouseName", warehouseName); |
| | | return this.opeWarehouseReserveDao.getOpeWarehouseReserveList(params); |
| | | } catch (DataAccessException e) { |
| | | logger.error(e.getMessage(), e); |
| | |
| | | } |
| | | |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public int getOpeWarehouseReserveTotalCountByName(String reagentId, String supplierId,String productSn) { |
| | | public int getOpeWarehouseReserveTotalCountByName(String reagentId, String supplierId,String productSn,String warehouseName) { |
| | | try { |
| | | Map<String, Object> params = new HashMap<String, Object>(); |
| | | params.put("reagentName", reagentId); |
| | | params.put("supplierId", supplierId); |
| | | params.put("productSn", productSn); |
| | | params.put("warehouseName", warehouseName); |
| | | return this.opeWarehouseReserveDao.getOpeWarehouseReserveTotalCount(params); |
| | | } catch (DataAccessException e) { |
| | | logger.error(e.getMessage(), e); |
| | |
| | | @Transactional |
| | | public void insertOpeWarehouseReserve2(OpeApplyReserve opeApplyReserve, OpeOrder oo) { |
| | | |
| | | OpeWarehouseReserve ope = this.opeWarehouseReserveService |
| | | .getOpeWarehouseReserve2(opeApplyReserve.getReagent().getId(), opeApplyReserve.getArticleNumber(),opeApplyReserve.getHouseId()); |
| | | OpeWarehouseReserve ope = this.getOpeWarehouseReserve2(opeApplyReserve.getReagent().getId(), opeApplyReserve.getArticleNumber(),opeApplyReserve.getHouseId()); |
| | | if (ope == null) { |
| | | |
| | | ope = new OpeWarehouseReserve(); |
| | |
| | | opeWarehouseReserveDao.insertOpeWarehouseReserve2(ope); |
| | | }else { |
| | | ope.setReserve(ope.getReserve() + opeApplyReserve.getArrivalNum()); |
| | | this.opeWarehouseReserveService.updateOpeWarehouseReserve(ope); |
| | | this.updateOpeWarehouseReserve(ope); |
| | | } |
| | | |
| | | |
| | |
| | | List<OpeWarehouseReserve> cacheUpdateList = oar.getCacheUpdateList(); |
| | | for (OpeWarehouseReserve owr : cacheUpdateList) { |
| | | //1.根据仓库id和试剂id搜索不同批号的试剂库存 |
| | | List<OpeWarehouseReserve> reserveList = opeWarehouseReserveService |
| | | List<OpeWarehouseReserve> reserveList = this |
| | | .selectWarehouseByRidAndArticleNumberAndWarehouse(reagentId, owr.getArticleNumber(), owr.getWarehouseId()); |
| | | Integer numLeave = owr.getUseNum(); |
| | | |
| | |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | | //更新库存 |
| | | opeWarehouseReserveService.updateBtReserve(warehouseReserve.getId(),usedNum); |
| | | this.updateBtReserve(warehouseReserve.getId(),usedNum); |
| | | if (numLeave < 1) { |
| | | break; |
| | | } |
| | |
| | | |
| | | |
| | | // 仓库库存update |
| | | opeWarehouseReserve = this.opeWarehouseReserveService.getOpeWarehouseReserve2(opeApply.getReagent().getId(), opeApply.getArticleNumber(),opeApply.getHouseId()); |
| | | opeWarehouseReserve = this.getOpeWarehouseReserve2(opeApply.getReagent().getId(), opeApply.getArticleNumber(),opeApply.getHouseId()); |
| | | if (opeWarehouseReserve == null) { |
| | | opeWarehouseReserve = new OpeWarehouseReserve(); |
| | | opeWarehouseReserve.setReagentId(opeApply.getReagent().getId()); |
| | |
| | | } |
| | | opeWarehouseReserve.setReserve(opeWarehouseReserve.getReserve() + opeApply.getArrivalNum()); |
| | | if (StringUtils.isBlank(opeWarehouseReserve.getId())) { |
| | | this.opeWarehouseReserveService.insertOpeWarehouseReserve(opeWarehouseReserve); |
| | | this.insertOpeWarehouseReserve(opeWarehouseReserve); |
| | | } else { |
| | | this.opeWarehouseReserveService.updateOpeWarehouseReserve(opeWarehouseReserve); |
| | | this.updateOpeWarehouseReserve(opeWarehouseReserve); |
| | | } |
| | | } |
| | | } |