| | |
| | | /** |
| | | * 测量 |
| | | */ |
| | | private static String measurement = "测量(ESV)"; |
| | | private static final String MEASUREMENT = "测量(ESV)"; |
| | | /** |
| | | * 调查 |
| | | */ |
| | | private static String toInvestigate = "勘察(EGE)"; |
| | | private static final String TOINVESTIGATE = "勘察(EGE)"; |
| | | /** |
| | | * 地灾 |
| | | */ |
| | | private static String disaster = "地灾(EGD)"; |
| | | private static final String DISASTER = "地灾(EGD)"; |
| | | /** |
| | | * 地下结构洞库 |
| | | */ |
| | | private static String undergroundStructure = "洞库(EGD)"; |
| | | private static final String UNDERGROUNDSTRUCTURE = "洞库(EGD)"; |
| | | |
| | | /** |
| | | * 项目类别conut |
| | |
| | | List<OneMapEntity> resList = new ArrayList<>(); |
| | | List<OneMapEntity> resInfo = aMapOfPipelineMapper.selectProjectType1(); |
| | | for (OneMapEntity oneMapEntity : resInfo) { |
| | | if (measurement.equals(oneMapEntity.getValue())) { |
| | | if (MEASUREMENT.equals(oneMapEntity.getValue())) { |
| | | resList.addAll(queryDirectory(oneMapEntity)); |
| | | } else if (toInvestigate.equals(oneMapEntity.getValue())) { |
| | | } else if (TOINVESTIGATE.equals(oneMapEntity.getValue())) { |
| | | resList.addAll(queryDirectory(oneMapEntity)); |
| | | } else if (disaster.equals(oneMapEntity.getValue())) { |
| | | } else if (DISASTER.equals(oneMapEntity.getValue())) { |
| | | resList.addAll(queryDirectory(oneMapEntity)); |
| | | } else if (undergroundStructure.equals(oneMapEntity.getValue())) { |
| | | } else if (UNDERGROUNDSTRUCTURE.equals(oneMapEntity.getValue())) { |
| | | resList.addAll(queryDirectory(oneMapEntity)); |
| | | } |
| | | } |
| | |
| | | String valueStr = oneMapEntity.getKey(); |
| | | System.out.println(oneMapEntity.getValue() + " == value == " + valueStr); |
| | | String endSql = null; |
| | | String sqlQur = ""; |
| | | String sqlQur; |
| | | if (valueStr.length() > 0) { |
| | | String[] arrStr = valueStr.split(","); |
| | | StringBuilder one = new StringBuilder(); |
| | |
| | | System.out.println("arrStr = " + arrStr.length); |
| | | } |
| | | for (String s : arrStr) { |
| | | sqlQur = "\'" + s + "%\' " + "or dircode like"; |
| | | sqlQur = "'" + s + "%' " + "or dircode like"; |
| | | one.append(sqlQur); |
| | | } |
| | | endSql = " where dircode like " + one.substring(0, one.toString().length() - 15); |