/** * 返回null表示修改成功 * * @param cell * @return */ @SuppressWarnings("unused") private BatchExceptionData modifyUserAccountProject(Cell[] cell) { String message = ""; try { String projectName = cell[0].getContents().trim(); int projectId = Integer.parseInt(cell[1].getContents().trim()); String realName = cell[3].getContents().trim(); String userName = cell[4].getContents().trim(); CompanyProject project = companyProjectServices.findCompanyProjectById(projectId); if (project == null || !projectName.equals(project.getProjectName())) { message = "项目名称与id不一致"; throw new Exception(); } UserAccount user = userAccountServices.findUserAccountByUserNameIncludeDelete(userName); if (user == null || !realName.equals(user.getRealName())) { message = "用户的姓名与账号不一致"; throw new Exception(); } user.setProjectId(projectId); user.setModId(SessionUser.getUserId()); user.setModTime(new Date()); userAccountServices.updateUserAccount(user); } catch (Exception e) { if (CommonUtils.isStrEmpty(message)) { message = "数据格式不合法"; } } if (CommonUtils.isStrEmpty(message)) { // 表示修改成功 return null; } BatchExceptionData retPojo = new BatchExceptionData(); retPojo.setProjectName(cell[0].getContents()); retPojo.setProjectId(cell[1].getContents()); retPojo.setJobNumber(cell[2].getContents()); retPojo.setRealName(cell[3].getContents()); retPojo.setUserName(cell[4].getContents()); retPojo.setExceptionData(message); return retPojo; }