| | |
| | | return "导入完毕" ; |
| | | } |
| | | |
| | | /** |
| | | * 总进度 |
| | | * @return |
| | | */ |
| | | @Override |
| | | public Hole selectHoleTotalProcess() { |
| | | return holeMapper.selectHoleTotalProcess(); |
| | | } |
| | | |
| | | /** |
| | | * 场地进度 |
| | | * @return |
| | | */ |
| | | @Override |
| | | public List<Hole> selectHoleProjectProcess() { |
| | | return holeMapper.selectHoleProjectProcess(); |
| | | } |
| | | |
| | | |
| | | private String saveExcel(MultipartFile file) { |
| | | String fileSaveDir2 = Global.getProfile() + "\\template\\" ; |
| | | |
| | | String filename = file.getOriginalFilename(); |
| | | File dir = new File(fileSaveDir); |
| | | File dir = new File(fileSaveDir2); |
| | | if (!dir.exists()) { |
| | | dir.mkdir(); |
| | | } |
| | | String addr = fileSaveDir + filename; |
| | | String addr = fileSaveDir2 + filename; |
| | | try { |
| | | File dest = new File(addr); |
| | | file.transferTo(dest); |
| | |
| | | private List<Hole> readData(String filepath) { |
| | | ExcelReader reader = ExcelUtil.getReader(filepath, 0); |
| | | reader.addHeaderAlias("钻孔编号", "code"); |
| | | reader.addHeaderAlias("钻孔类型", "type"); |
| | | reader.addHeaderAlias("孔口高程(m)", "elevation"); |
| | | reader.addHeaderAlias("设计孔深(m)", "depth"); |
| | | reader.addHeaderAlias("钻孔状态", "status"); |
| | | reader.addHeaderAlias("钻孔经度", "longitude"); |
| | | reader.addHeaderAlias("钻孔纬度", "latitude"); |
| | | reader.addHeaderAlias("总进尺(m)", "footage"); |