| | |
| | | return select(sql.toString(), paramts, new BaseWarehouse()); |
| | | } |
| | | |
| | | /** |
| | | * 根据机构id查询默认仓库 |
| | | * |
| | | * @param agencyId |
| | | * @return |
| | | */ |
| | | @Override |
| | | public BaseWarehouse getDefaultWarehouseByAgencyId(Long agencyId) { |
| | | StringBuilder sql = |
| | | new StringBuilder("SELECT * FROM base_warehouse WHERE IS_DEFAULT = 1 and AGENCY_ID =:agencyId "); |
| | | Map<String, Object> param = new HashMap<>(); |
| | | param.put("agencyId", agencyId); |
| | | List<BaseWarehouse> select = select(sql.toString(), param, new BaseWarehouse()); |
| | | BaseWarehouse baseWarehouse = select.stream().findFirst().orElse(null); |
| | | return baseWarehouse; |
| | | } |
| | | |
| | | @Override |
| | | public BaseWarehouse getWarehouseByAgencyId(Long agencyId, String warehouseName) { |
| | | StringBuilder sql = new StringBuilder("SELECT * FROM base_warehouse WHERE STATES= 1"); |