主子导入功能Controller
/**
* 导入
*
* @param file
* @param ifFlag
* @return
* @throws Exception
*/
@RequestMapping("/importSheet")
@ResponseBody
public Object importSheet(@RequestPart("file") MultipartFile file, int ifFlag) {
try {
Map<String, JSONArray> stringJSONArrayMap = ImportExeclUtil.readFileManySheet(file);
return this.buildSuccess(hrrgComEvaService.importSheet(stringJSONArrayMap, ifFlag));
} catch (Exception e) {
logger.error("Excel导入失败", e);
return this.buildFaild(e.getMessage());
}
/*catch (RuntimeException e){
return this.buildFaild(e.getMessage());
}catch (Exception e){
logger.error("Excel导入失败", e);
return this.buildFaild("导入失败请检查导入文件");
}*/
}
service
@Transactional(rollbackFor = Exception.class)
public Object importSheet(Map<String, JSONArray> hrrgComEvaModels, int ifFlag) throws Exception {
String timeRegex1 = "(([0-9]{3}[1-9]|[0-9]{2}[1-9][0-9]{1}|[0-9]{1}[1-9][0-9]{2}|[1-9][0-9]{3})-(((0[13578]|1[02])-(0[1-9]|[12][0-9]|3[01]))|" +
"((0[469]|11)-(0[1-9]|[12][0-9]|30))|(02-(0[1-9]|[1][0-9]|2[0-8]))))|((([0-9]{2})(0[48]|[2468][048]|[13579][26])|" +
"((0[48]|[2468][048]|[3579][26])00))-02-29)$";
List<HrrgComEva> hrrgComEvas = ImportExeclUtil.getBeanList(hrrgComEvaModels.get("胜任力测评记录"), HrrgComEva.class);
List<HrrgEvaDimInfo> hrrgEvaDimInfos = ImportExeclUtil.getBeanList(hrrgComEvaModels.get("维度信息"), HrrgEvaDimInfo.class);
AtomicInteger com = new AtomicInteger();
AtomicInteger eva = new AtomicInteger();
//主表userCode集合
List<String> ids = new ArrayList<>();