导入模板，存在excel表格中有分隔符

最新推荐文章于 2024-05-07 09:51:51 发布
最新推荐文章于 2024-05-07 09:51:51 发布
阅读量320 收藏
点赞数
分类专栏： java 文章标签： 导入
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/chenlin_lin/article/details/102825419
版权

public Object excelImportTechResourceTmp(MultipartFile file) throws IOException {
LoginResult loginResult = this.getLoginUser();
if (file.getSize() == 0) {
return “excel表格异常”;
}
// 正式表
List techResourceList = new ArrayList<>();
// 临时表
List techResourceTmpList = new ArrayList<>();
// 需要待插入的大类
List techResourceUndertakeAddList = new ArrayList<>();
List techResourceCooperationAddList = new ArrayList<>();
List techResourceAppropriationLevelAddList = new ArrayList<>();
String fileName = file.getOriginalFilename();
String suffix = fileName.substring(fileName.lastIndexOf("."));
if (suffix.equals(".xls")) {
// 建立Excel对象
HSSFWorkbook workbook = new HSSFWorkbook(new POIFSFileSystem(file.getInputStream()));
// 获取Excel中的sheet数量
int numberOfSheets = workbook.getNumberOfSheets();
for (int i = 0; i < numberOfSheets; i++) {
// 获取excel sheet
HSSFSheet sheet = workbook.getSheetAt(i);
// 获取行的数量
int physicalNumberOfRows = sheet.getPhysicalNumberOfRows();
if (physicalNumberOfRows <= 1) {
workbook.close();
return “excel表格异常”;
}
// 查询业务处室 承担单位 主要协作单位 放到map 里面
SysOrgInfoQueryParam sysOrgInfoQueryParam = new SysOrgInfoQueryParam();
sysOrgInfoQueryParam.setPid(2);
sysOrgInfoQueryParam.setOrgTypes(“2,7”);
// 包含shortName简称和orgName只要有一个符合 就正确 需要进行判断
List orgList = sysOrgInfoMapper.selectQuery(sysOrgInfoQueryParam);
// orgName 的hashMap
HashMap<String, SysOrgInfo> orgNameHashMap = new HashMap<>();
// shortName 的hashMap
HashMap<String, SysOrgInfo> shortNameHashMap = new HashMap<>();
for (SysOrgInfo orgInfo : orgList) {
orgNameHashMap.put(orgInfo.getOrgName(), orgInfo);
shortNameHashMap.put(orgInfo.getShortName(), orgInfo);
}
// 查询拨款级放到map 里面
MasterCodeBQueryParam masterCodeBParam = new MasterCodeBQueryParam();
masterCodeBParam.setClassa(“TAL”);
masterCodeBParam.setPs(Integer.MAX_VALUE);
List appropriationLevelList = masterCodeBMapper.listQuery(masterCodeBParam);

			// 拨款级的map
			HashMap<String, MasterCodeB> appropriationLevelHashMap = new HashMap<>();
			for (MasterCodeB masterCodeB : appropriationLevelList) {
				appropriationLevelHashMap.put(masterCodeB.getName(), masterCodeB);
			}

			for (int j = 0; j < physicalNumberOfRows; j++) {
				// 如果有标题则第一列不进行加载
				if (j == 0) {
					continue;// 标题行
				} else {
					// 获取该行的数据信息
					HSSFRow row = sheet.getRow(j);

					// 需要对每一行的数据进行一下非空处理
					// 项目编号不能为空
					if (row != null && row.getCell(1) != null && row.getCell(1).getStringCellValue().length() > 0) {
						TechResourceTmp techResourceTmp = new TechResourceTmp();
						if (row.getCell(1).getStringCellValue() != null) {
							techResourceTmp.setProjectNumber(row.getCell(1).getStringCellValue());
						}
						// 资源类型
						techResourceTmp.setResourceType("6");
						// 计划类别
						if (row.getCell(2) != null && row.getCell(2).getStringCellValue() != null) {
							MasterCodeBQueryParam masterCodeBQueryParam = new MasterCodeBQueryParam();
							masterCodeBQueryParam.setClassa("TPT");
							masterCodeBQueryParam.setName(row.getCell(2).getStringCellValue());
							masterCodeBQueryParam.setPs(Integer.MAX_VALUE);
							List<MasterCodeB> listQuery = masterCodeBMapper.listQuery(masterCodeBQueryParam);
							if (listQuery.size() > 0) {
								for (MasterCodeB masterCodeB : listQuery) {
									if (masterCodeB.getName().equals(row.getCell(2).getStringCellValue())) {
										techResourceTmp.setProjectType(masterCodeB.getClassb());
										techResourceTmp.setProjectTypeQualified(1);
										techResourceTmp.setIsQualified(1);
									} else {
										techResourceTmp.setProjectType(row.getCell(2).getStringCellValue());
										techResourceTmp.setProjectTypeQualified(0);
										techResourceTmp.setIsQualified(0);
									}
								}
							} else {
								techResourceTmp.setProjectType(row.getCell(2).getStringCellValue());
								techResourceTmp.setProjectTypeQualified(0);
								techResourceTmp.setIsQualified(0);
							}
						}
						// 项目名称
						if (row.getCell(3) != null && row.getCell(3).getStringCellValue() != null) {
							techResourceTmp.setProjectName(row.getCell(3).getStringCellValue());
						}
						// 承担单位
						if (row.getCell(4) != null && row.getCell(4).getStringCellValue() != null) {
							// 两种情况 如果导入的数据包含、 要进行切割验证
							if (row.getCell(4).getStringCellValue().contains("、")) {
								String rowValue = row.getCell(4).getStringCellValue().replaceAll("\r|\n", "");
								// 多条的情况
								String[] undertakeUnitArray = rowValue.split("、");
								int length = undertakeUnitArray.length;
								int count = 0;
								for (String str : undertakeUnitArray) {
									if (orgNameHashMap.containsKey(str) || shortNameHashMap.containsKey(str)) {
										count++;
									}
								}
								if (length != count) {
									techResourceTmp.setUndertakeUnitName(row.getCell(4).getStringCellValue());
									techResourceTmp.setUndertakeUnitQualified(0);
									techResourceTmp.setIsQualified(0);
								} else {
									SysOrgInfo sysOrginfo = new SysOrgInfo();
									techResourceTmp.setTechResourceUndertakeList(new ArrayList<>());
									String undertakeUnitName = "";
									for (String str : undertakeUnitArray) {
										TechResourceUndertakeUnitR techResourceUndertakeUnitR = new TechResourceUndertakeUnitR();
										if (orgNameHashMap.containsKey(str)) {
											sysOrginfo = orgNameHashMap.get(str);
											// techResourceTmp.setUndertakeUnitId(sysOrginfo.getId());
											undertakeUnitName += sysOrginfo.getOrgName() + "、";
											techResourceTmp.setUndertakeUnitName(
													undertakeUnitName.substring(0, undertakeUnitName.length() - 1));
											techResourceTmp.setUndertakeUnitQualified(1);
											techResourceTmp.setIsQualified(1);
											techResourceUndertakeUnitR.setUndertakeUnitId(sysOrginfo.getId());
											techResourceUndertakeUnitR
													.setUndertakeUnitName(sysOrginfo.getOrgName());
											techResourceTmp.getTechResourceUndertakeList()
													.add(techResourceUndertakeUnitR);
										} else if (shortNameHashMap.containsKey(str)) {
											sysOrginfo = shortNameHashMap.get(str);
											// techResourceTmp.setUndertakeUnitId(sysOrginfo.getId());
											undertakeUnitName += sysOrginfo.getShortName() + "、";
											techResourceTmp.setUndertakeUnitName(
													undertakeUnitName.substring(0, undertakeUnitName.length() - 1));
											techResourceTmp.setUndertakeUnitQualified(1);
											techResourceTmp.setIsQualified(1);
											techResourceUndertakeUnitR.setUndertakeUnitId(sysOrginfo.getId());
											techResourceUndertakeUnitR
													.setUndertakeUnitName(sysOrginfo.getShortName());
											techResourceTmp.getTechResourceUndertakeList()
													.add(techResourceUndertakeUnitR);
										}
										// techResourceUndertakeAddList.add(techResourceUndertakeUnitR);
									}
								}
							} else {
								// 如果没有顿号分割，只有一条的情况
								SysOrgInfo sysOrginfo = new SysOrgInfo();
								techResourceTmp.setTechResourceUndertakeList(new ArrayList<>());
								TechResourceUndertakeUnitR techResourceUndertakeUnitR = new TechResourceUndertakeUnitR();
								if (orgNameHashMap.containsKey(row.getCell(4).getStringCellValue())) {
									sysOrginfo = orgNameHashMap.get(row.getCell(4).getStringCellValue());
									// techResourceTmp.setUndertakeUnitId(sysOrginfo.getId());
									techResourceTmp.setUndertakeUnitName(sysOrginfo.getOrgName());
									techResourceTmp.setUndertakeUnitQualified(1);
									techResourceTmp.setIsQualified(1);
									techResourceUndertakeUnitR.setUndertakeUnitId(sysOrginfo.getId());
									techResourceUndertakeUnitR.setUndertakeUnitName(sysOrginfo.getOrgName());
									techResourceTmp.getTechResourceUndertakeList().add(techResourceUndertakeUnitR);
								} else if (shortNameHashMap.containsKey(row.getCell(4).getStringCellValue())) {
									sysOrginfo = shortNameHashMap.get(row.getCell(4).getStringCellValue());
									// techResourceTmp.setUndertakeUnitId(sysOrginfo.getId());
									techResourceTmp.setUndertakeUnitName(sysOrginfo.getShortName());
									techResourceTmp.setUndertakeUnitQualified(1);
									techResourceTmp.setIsQualified(1);
									techResourceUndertakeUnitR.setUndertakeUnitId(sysOrginfo.getId());
									techResourceUndertakeUnitR.setUndertakeUnitName(sysOrginfo.getShortName());
									techResourceTmp.getTechResourceUndertakeList().add(techResourceUndertakeUnitR);
								} else {
									techResourceTmp.setUndertakeUnitName(row.getCell(4).getStringCellValue());
									techResourceTmp.setUndertakeUnitQualified(0);
									techResourceTmp.setIsQualified(0);
								}
								// techResourceUndertakeAddList.add(techResourceUndertakeUnitR);
							}
						}
						// 主要协作单位
						if (row.getCell(5) != null && row.getCell(5).getStringCellValue() != null
								&& !"".equals(row.getCell(5).getStringCellValue())) {
							if (row.getCell(5).getStringCellValue().contains("、")) {
								String rowValue = row.getCell(4).getStringCellValue().replaceAll("\r|\n", "");
								String[] cooperationUnitArray = rowValue.split("、");
								int length = cooperationUnitArray.length;
								int count = 0;
								for (String str : cooperationUnitArray) {
									if (orgNameHashMap.containsKey(str) || shortNameHashMap.containsKey(str)) {
										count++;
									}
								}
								if (length != count) {
									techResourceTmp.setCooperationUnitName(row.getCell(5).getStringCellValue());
									techResourceTmp.setCooperationUnitQualified(0);
									techResourceTmp.setIsQualified(0);
								} else {
									SysOrgInfo sysOrginfo = new SysOrgInfo();
									techResourceTmp.setTechResourceCooperationList(new ArrayList<>());
									String cooperationUnitName = "";
									for (String str : cooperationUnitArray) {
										TechResourceCooperationUnitR techResourceCooperationUnitR = new TechResourceCooperationUnitR();
										if (orgNameHashMap.containsKey(str)) {
											sysOrginfo = orgNameHashMap.get(str);
											cooperationUnitName += sysOrginfo.getOrgName() + "、";
											// techResourceTmp.setCooperationUnitId(sysOrginfo.getId());
											techResourceTmp.setCooperationUnitName(cooperationUnitName.substring(0,
													cooperationUnitName.length() - 1));
											techResourceTmp.setCooperationUnitQualified(1);
											techResourceTmp.setIsQualified(1);
											techResourceCooperationUnitR.setCooperationUnitId(sysOrginfo.getId());
											techResourceCooperationUnitR
													.setCooperationUnitName(sysOrginfo.getOrgName());
											techResourceTmp.getTechResourceCooperationList()
													.add(techResourceCooperationUnitR);
										} else if (shortNameHashMap.containsKey(str)) {
											sysOrginfo = shortNameHashMap.get(str);
											// techResourceTmp.setCooperationUnitId(sysOrginfo.getId());
											cooperationUnitName += sysOrginfo.getOrgName() + "、";
											techResourceTmp.setCooperationUnitName(cooperationUnitName.substring(0,
													cooperationUnitName.length() - 1));
											techResourceTmp.setCooperationUnitQualified(1);
											techResourceTmp.setIsQualified(1);
											techResourceCooperationUnitR.setCooperationUnitId(sysOrginfo.getId());
											techResourceCooperationUnitR
													.setCooperationUnitName(sysOrginfo.getShortName());
											techResourceTmp.getTechResourceCooperationList()
													.add(techResourceCooperationUnitR);
										}
										// techResourceCooperationAddList.add(techResourceCooperationUnitR);
									}
								}
							} else {
								// 进行模糊匹配修正
								// 如果没有顿号分割
								SysOrgInfo sysOrginfo = new SysOrgInfo();
								techResourceTmp.setTechResourceCooperationList(new ArrayList<>());
								TechResourceCooperationUnitR techResourceCooperationUnitR = new TechResourceCooperationUnitR();
								if (orgNameHashMap.containsKey(row.getCell(5).getStringCellValue())) {
									sysOrginfo = orgNameHashMap.get(row.getCell(5).getStringCellValue());
									// techResourceTmp.setCooperationUnitId(sysOrginfo.getId());
									techResourceTmp.setCooperationUnitName(sysOrginfo.getOrgName());
									techResourceTmp.setCooperationUnitQualified(1);
									techResourceTmp.setIsQualified(1);
									techResourceCooperationUnitR.setCooperationUnitId(sysOrginfo.getId());
									techResourceCooperationUnitR.setCooperationUnitName(sysOrginfo.getOrgName());
									techResourceTmp.getTechResourceCooperationList()
											.add(techResourceCooperationUnitR);
								} else if (shortNameHashMap.containsKey(row.getCell(5).getStringCellValue())) {
									sysOrginfo = shortNameHashMap.get(row.getCell(5).getStringCellValue());
									// techResourceTmp.setCooperationUnitId(sysOrginfo.getId());
									techResourceTmp.setCooperationUnitName(sysOrginfo.getShortName());
									techResourceTmp.setCooperationUnitQualified(1);
									techResourceTmp.setIsQualified(1);
									techResourceCooperationUnitR.setCooperationUnitId(sysOrginfo.getId());
									techResourceCooperationUnitR.setCooperationUnitName(sysOrginfo.getShortName());
									techResourceTmp.getTechResourceCooperationList()
											.add(techResourceCooperationUnitR);
								} else {
									// techResourceTmp.setCooperationUnitName(row.getCell(5).getStringCellValue());
									techResourceTmp.setCooperationUnitQualified(0);
									techResourceTmp.setIsQualified(0);
								}
								// techResourceCooperationAddList.add(techResourceCooperationUnitR);
							}
						} else {
							techResourceTmp.setCooperationUnitQualified(1);
							techResourceTmp.setIsQualified(1);
						}
						// 起止时间
						if (row.getCell(6) != null && row.getCell(6).getStringCellValue() != null) {
							String startEndTime = row.getCell(6).getStringCellValue();
							String[] newStartEnd = startEndTime.split("-");
							String startDate = newStartEnd[0];
							String endDate = newStartEnd[1];
							try {
								techResourceTmp.setStartDate(
										new Timestamp(new SimpleDateFormat("yyyy").parse(startDate).getTime()));
								techResourceTmp.setEndDate(
										new Timestamp(new SimpleDateFormat("yyyy").parse(endDate).getTime()));
							} catch (ParseException e) { // TODO Auto-generated catch block
								e.printStackTrace();
							}
						}
						// 总投资
						if (row.getCell(7) != null) {
							HSSFCell cells = row.getCell(7);
							// 设置单元格类型
							cells.setCellType(CellType.STRING);
							if (row.getCell(7).getStringCellValue() != null) {
								techResourceTmp
										.setTotalInvestment(new BigDecimal(row.getCell(7).getStringCellValue()));
							}

						}
						// 市级拨款
						if (row.getCell(8) != null) {
							HSSFCell cella = row.getCell(8);
							// 设置单元格类型
							cella.setCellType(CellType.STRING);
							if (row.getCell(8).getStringCellValue() != null) {
								techResourceTmp
										.setCityAppropriation(new BigDecimal(row.getCell(8).getStringCellValue()));
							}
						}
						// 区市配套
						if (row.getCell(9) != null) {
							HSSFCell cellb = row.getCell(9);
							// 设置单元格类型
							cellb.setCellType(CellType.STRING);
							if (row.getCell(9).getStringCellValue() != null
									&& row.getCell(9).getStringCellValue().trim().length() > 0) {
								techResourceTmp.setCountyAppropriation(
										new BigDecimal(row.getCell(9).getStringCellValue()));
							}

						}
						// 自筹
						if (row.getCell(10) != null) {
							HSSFCell cellc = row.getCell(10);
							// 设置单元格类型
							cellc.setCellType(CellType.STRING);
							if (row.getCell(10).getStringCellValue() != null
									&& row.getCell(10).getStringCellValue().trim().length() > 0) {
								techResourceTmp.setIndependentlyAppropriation(
										new BigDecimal(row.getCell(10).getStringCellValue()));
							}
						}
						// 拨款年度
						if (row.getCell(11) != null) {
							HSSFCell celle = row.getCell(11);
							celle.setCellType(CellType.STRING);
							techResourceTmp.setAppropriationYear(row.getCell(11).getStringCellValue());
						}

						// 当年度拨款
						if (row.getCell(12) != null) {
							HSSFCell celld = row.getCell(12);
							// 设置单元格类型
							celld.setCellType(CellType.STRING);
							if (row.getCell(12).getStringCellValue() != null
									&& row.getCell(12).getStringCellValue().trim().length() > 0) {
								techResourceTmp.setAppropriationNumber(
										new BigDecimal(row.getCell(12).getStringCellValue()));
							}
						}
						// 拨款批次
						if (row.getCell(13) != null) {
							// 设置单元格类型
							HSSFCell celle = row.getCell(13);
							celle.setCellType(CellType.STRING);
							if (row.getCell(13).getStringCellValue() != null
									&& row.getCell(13).getStringCellValue().trim().length() > 0) {
								techResourceTmp.setAppropriationBatch(
										Integer.valueOf(row.getCell(13).getStringCellValue()));
							}
						}

						// 拨款级
						if (row.getCell(14) != null && row.getCell(14).getStringCellValue() != null) {
							if (row.getCell(14).getStringCellValue().contains("\n")) {
								String[] appropriationLevelArray = row.getCell(14).getStringCellValue().split("\n");
								int length = appropriationLevelArray.length;
								int count = 0;
								for (String str : appropriationLevelArray) {
									if (appropriationLevelHashMap.containsKey(str)) {
										count++;
									}
								}
								if (length != count) {
									techResourceTmp.setAppropriationLevel(row.getCell(5).getStringCellValue());
									techResourceTmp.setAppropriationLevelQualified(0);
									techResourceTmp.setIsQualified(0);
								} else {
									String appappropriationLevel = "";
									MasterCodeB masterCodeB = new MasterCodeB();
									TechResourceAppropriationLevelR techResourceAppropriationLevelR = new TechResourceAppropriationLevelR();
									techResourceTmp.setTechResourceAppropriationLevelList(new ArrayList<>());
									for (String str : appropriationLevelArray) {
										if (appropriationLevelHashMap.containsKey(str)) {
											techResourceAppropriationLevelR = new TechResourceAppropriationLevelR();
											masterCodeB = appropriationLevelHashMap.get(str);
											appappropriationLevel += masterCodeB.getName() + "\n";
											techResourceTmp.setAppropriationLevel(appappropriationLevel.substring(0,
													appappropriationLevel.length() - 1));
											techResourceTmp.setAppropriationLevelQualified(1);
											techResourceTmp.setIsQualified(1);
											techResourceAppropriationLevelR
													.setAppropriationLevel(masterCodeB.getClassb());
											techResourceTmp.getTechResourceAppropriationLevelList()
													.add(techResourceAppropriationLevelR);
										}
									//	techResourceAppropriationLevelAddList.add(techResourceAppropriationLevelR);
									}
								}
							} else if (row.getCell(14).getStringCellValue().contains(" ")) {
								String[] appropriationLevelArray = row.getCell(14).getStringCellValue().split(" ");
								int length = appropriationLevelArray.length;
								int count = 0;
								for (String str : appropriationLevelArray) {
									if (appropriationLevelHashMap.containsKey(str)) {
										count++;
									}
								}
								if (length != count) {
									techResourceTmp.setAppropriationLevel(row.getCell(14).getStringCellValue());
									techResourceTmp.setAppropriationLevelQualified(0);
									techResourceTmp.setIsQualified(0);
								} else {
									MasterCodeB masterCodeB = new MasterCodeB();
									TechResourceAppropriationLevelR techResourceAppropriationLevelR = new TechResourceAppropriationLevelR();
									techResourceTmp.setTechResourceAppropriationLevelList(new ArrayList<>());
									String appappropriationLevel = "";
									for (String str : appropriationLevelArray) {
										if (appropriationLevelHashMap.containsKey(str)) {
											techResourceAppropriationLevelR = new TechResourceAppropriationLevelR();
											masterCodeB = appropriationLevelHashMap.get(str);
											appappropriationLevel += masterCodeB.getName() + "\n";
											techResourceTmp.setAppropriationLevel(appappropriationLevel.substring(0,
													appappropriationLevel.length() - 1));
											techResourceTmp.setAppropriationLevelQualified(1);
											techResourceTmp.setIsQualified(1);
											techResourceAppropriationLevelR
													.setAppropriationLevel(masterCodeB.getClassb());
											techResourceTmp.getTechResourceAppropriationLevelList()
													.add(techResourceAppropriationLevelR);
										}
										// techResourceAppropriationLevelAddList.add(techResourceAppropriationLevelR);
									}
								}
							} else {
								MasterCodeB masterCodeB = new MasterCodeB();
								TechResourceAppropriationLevelR techResourceAppropriationLevelR = new TechResourceAppropriationLevelR();
								techResourceTmp.setTechResourceAppropriationLevelList(new ArrayList<>());
								if (appropriationLevelHashMap.containsKey(row.getCell(14).getStringCellValue())) {
									masterCodeB = appropriationLevelHashMap
											.get(row.getCell(14).getStringCellValue());
									techResourceTmp.setAppropriationLevelQualified(1);
									techResourceTmp.setIsQualified(1);
									techResourceTmp.setAppropriationLevel(masterCodeB.getClassb());
									techResourceAppropriationLevelR.setAppropriationLevel(masterCodeB.getClassb());
									techResourceTmp.getTechResourceAppropriationLevelList()
											.add(techResourceAppropriationLevelR);
								} else {
									techResourceTmp.setAppropriationLevelQualified(0);
									techResourceTmp.setIsQualified(0);
									techResourceTmp.setAppropriationLevel(row.getCell(14).getStringCellValue());
								}

							// 	techResourceAppropriationLevelAddList.add(techResourceAppropriationLevelR);
							}
						}
						// 业务处室
						if (row.getCell(15) != null && row.getCell(15).getStringCellValue() != null) {
							SysOrgInfo sysOrginfo = new SysOrgInfo();
							if (orgNameHashMap.containsKey(row.getCell(15).getStringCellValue())) {
								sysOrginfo = orgNameHashMap.get(row.getCell(15).getStringCellValue());
								techResourceTmp.setOwnerOrgId(sysOrginfo.getId());
								techResourceTmp.setOwnerOrgName(sysOrginfo.getOrgName());
								techResourceTmp.setOwnerOrgQualified(1);
								techResourceTmp.setIsQualified(1);
							} else if (shortNameHashMap.containsKey(row.getCell(15).getStringCellValue())) {
								sysOrginfo = shortNameHashMap.get(row.getCell(15).getStringCellValue());
								techResourceTmp.setOwnerOrgId(sysOrginfo.getId());
								techResourceTmp.setOwnerOrgName(sysOrginfo.getShortName());
								techResourceTmp.setOwnerOrgQualified(1);
								techResourceTmp.setIsQualified(1);
							} else {
								techResourceTmp.setUndertakeUnitName(row.getCell(15).getStringCellValue());
								techResourceTmp.setOwnerOrgQualified(0);
								techResourceTmp.setIsQualified(0);
							}
						}
						// 验收年度
						if (row.getCell(16) != null) {
							HSSFCell celle = row.getCell(16);
							celle.setCellType(CellType.STRING);
							techResourceTmp.setAcceptanceYear(row.getCell(16).getStringCellValue());
						}
						// 验收结论
						if (row.getCell(17) != null && row.getCell(17).getStringCellValue() != null) {
							techResourceTmp.setAcceptanceResult(row.getCell(17).getStringCellValue());
						}
						// 二次验收结论
						if (row.getCell(18) != null && row.getCell(18).getStringCellValue() != null) {
							techResourceTmp.setAcceptanceTwoResult(row.getCell(18).getStringCellValue());
						}
						// 计划大本备注（人才姓名）
						if (row.getCell(19) != null && row.getCell(19).getStringCellValue() != null) {
							techResourceTmp.setProjectMemo(row.getCell(19).getStringCellValue());
						}
						// 修改备注
						if (row.getCell(20) != null && row.getCell(20).getStringCellValue() != null) {
							techResourceTmp.setEditionMemo(row.getCell(20).getStringCellValue());
						}
						if (loginResult != null) {
							techResourceTmp.setCreateOrgId(loginResult.getUser().getOrgId());
							techResourceTmp.setCreateTime(new Timestamp(System.currentTimeMillis()));
							techResourceTmp.setCreateUserId(loginResult.getUser().getId());
							techResourceTmp.setCreateUserName(loginResult.getUser().getShortName());
							techResourceTmp.setUpdateTime(new Timestamp(System.currentTimeMillis()));
							techResourceTmp.setUpdateUserName(loginResult.getUser().getUserName());
						}
						techResourceTmpList.add(techResourceTmp);
					} else {
						return "项目名称为空！";
					}
				}
			}
			workbook.close();
		}
	}
	if (suffix.equals(".xlsx")) {
		// 建立Excel对象
		XSSFWorkbook workbook = new XSSFWorkbook(file.getInputStream());
		// 获取Excel中的sheet数量
		int numberOfSheets = workbook.getNumberOfSheets();
		// 最后一个sheet放枚举 不进行加载
		for (int i = 0; i < numberOfSheets; i++) {
			// 获取excel sheet
			XSSFSheet sheet = workbook.getSheetAt(i);
			// 获取行的数量
			int physicalNumberOfRows = sheet.getPhysicalNumberOfRows();
			if (physicalNumberOfRows <= 1) {
				workbook.close();
				return "excel表格异常";
			}

			// 查询业务处室 承担单位 主要协作单位 放到map 里面
			SysOrgInfoQueryParam sysOrgInfoQueryParam = new SysOrgInfoQueryParam();
			sysOrgInfoQueryParam.setPid(2);
			sysOrgInfoQueryParam.setOrgTypes("2,7");
			// 包含shortName简称和orgName只要有一个符合 就正确 需要进行判断
			List<SysOrgInfo> orgList = sysOrgInfoMapper.selectQuery(sysOrgInfoQueryParam);
			// orgName 的hashMap
			HashMap<String, SysOrgInfo> orgNameHashMap = new HashMap<>();
			// shortName 的hashMap
			HashMap<String, SysOrgInfo> shortNameHashMap = new HashMap<>();
			for (SysOrgInfo orgInfo : orgList) {
				orgNameHashMap.put(orgInfo.getOrgName(), orgInfo);
				shortNameHashMap.put(orgInfo.getShortName(), orgInfo);
			}
			// 查询拨款级放到map 里面
			MasterCodeBQueryParam masterCodeBParam = new MasterCodeBQueryParam();
			masterCodeBParam.setClassa("TAL");
			masterCodeBParam.setPs(Integer.MAX_VALUE);
			List<MasterCodeB> appropriationLevelList = masterCodeBMapper.listQuery(masterCodeBParam);

			// 拨款级的map
			HashMap<String, MasterCodeB> appropriationLevelHashMap = new HashMap<>();
			for (MasterCodeB masterCodeB : appropriationLevelList) {
				appropriationLevelHashMap.put(masterCodeB.getName(), masterCodeB);
			}

			for (int j = 0; j < physicalNumberOfRows; j++) {
				// 如果有标题则第一列不进行加载
				if (j == 0) {
					continue;// 标题行
				} else {
					// 获取该行的数据信息
					XSSFRow row = sheet.getRow(j);
					// 需要对每一行的数据进行一下非空处理
					// 项目编号不能为空
					if (row != null && row.getCell(1) != null && row.getCell(1).getStringCellValue().length() > 0) {
						TechResourceTmp techResourceTmp = new TechResourceTmp();
						if (row.getCell(1).getStringCellValue() != null) {
							techResourceTmp.setProjectNumber(row.getCell(1).getStringCellValue());
						}
						// 资源类型
						techResourceTmp.setResourceType("6");
						// 计划类别
						if (row.getCell(2) != null && row.getCell(2).getStringCellValue() != null) {
							MasterCodeBQueryParam masterCodeBQueryParam = new MasterCodeBQueryParam();
							masterCodeBQueryParam.setClassa("TPT");
							masterCodeBQueryParam.setName(row.getCell(2).getStringCellValue());
							masterCodeBQueryParam.setPs(Integer.MAX_VALUE);
							List<MasterCodeB> listQuery = masterCodeBMapper.listQuery(masterCodeBQueryParam);
							if (listQuery.size() > 0) {
								for (MasterCodeB masterCodeB : listQuery) {
									if (masterCodeB.getName().equals(row.getCell(2).getStringCellValue())) {
										techResourceTmp.setProjectType(masterCodeB.getClassb());
										techResourceTmp.setProjectTypeQualified(1);
										techResourceTmp.setIsQualified(1);
									} else {
										techResourceTmp.setProjectType(row.getCell(2).getStringCellValue());
										techResourceTmp.setProjectTypeQualified(0);
										techResourceTmp.setIsQualified(0);
									}
								}
							} else {
								techResourceTmp.setProjectType(row.getCell(2).getStringCellValue());
								techResourceTmp.setProjectTypeQualified(0);
								techResourceTmp.setIsQualified(0);
							}
						}
						// 项目名称
						if (row.getCell(3) != null && row.getCell(3).getStringCellValue() != null) {
							techResourceTmp.setProjectName(row.getCell(3).getStringCellValue());
						}
						// 承担单位
						if (row.getCell(4) != null && row.getCell(4).getStringCellValue() != null) {
							// 两种情况 如果导入的数据包含、 要进行切割验证
							if (row.getCell(4).getStringCellValue().contains("、")) {
								String rowValue = row.getCell(4).getStringCellValue().replaceAll("\r|\n", "");
								// 多条的情况
								String[] undertakeUnitArray = rowValue.split("、");
								int length = undertakeUnitArray.length;
								int count = 0;
								for (String str : undertakeUnitArray) {
									if (orgNameHashMap.containsKey(str) || shortNameHashMap.containsKey(str)) {
										count++;
									}
								}
								if (length != count) {
									techResourceTmp.setUndertakeUnitName(row.getCell(4).getStringCellValue());
									techResourceTmp.setUndertakeUnitQualified(0);
									techResourceTmp.setIsQualified(0);
								} else {
									SysOrgInfo sysOrginfo = new SysOrgInfo();
									techResourceTmp.setTechResourceUndertakeList(new ArrayList<>());
									String undertakeUnitName = "";
									for (String str : undertakeUnitArray) {
										TechResourceUndertakeUnitR techResourceUndertakeUnitR = new TechResourceUndertakeUnitR();
										if (orgNameHashMap.containsKey(str)) {
											sysOrginfo = orgNameHashMap.get(str);
											// techResourceTmp.setUndertakeUnitId(sysOrginfo.getId());
											undertakeUnitName += sysOrginfo.getOrgName() + "、";
											techResourceTmp.setUndertakeUnitName(
													undertakeUnitName.substring(0, undertakeUnitName.length() - 1));
											techResourceTmp.setUndertakeUnitQualified(1);
											techResourceTmp.setIsQualified(1);
											techResourceUndertakeUnitR.setUndertakeUnitId(sysOrginfo.getId());
											techResourceUndertakeUnitR
													.setUndertakeUnitName(sysOrginfo.getOrgName());
											techResourceTmp.getTechResourceUndertakeList()
													.add(techResourceUndertakeUnitR);
										} else if (shortNameHashMap.containsKey(str)) {
											sysOrginfo = shortNameHashMap.get(str);
											// techResourceTmp.setUndertakeUnitId(sysOrginfo.getId());
											undertakeUnitName += sysOrginfo.getShortName() + "、";
											techResourceTmp.setUndertakeUnitName(
													undertakeUnitName.substring(0, undertakeUnitName.length() - 1));
											techResourceTmp.setUndertakeUnitQualified(1);
											techResourceTmp.setIsQualified(1);
											techResourceUndertakeUnitR.setUndertakeUnitId(sysOrginfo.getId());
											techResourceUndertakeUnitR
													.setUndertakeUnitName(sysOrginfo.getShortName());
											techResourceTmp.getTechResourceUndertakeList()
													.add(techResourceUndertakeUnitR);
										}
										// techResourceUndertakeAddList.add(techResourceUndertakeUnitR);
									}
								}
							} else {
								// 如果没有顿号分割，只有一条的情况
								SysOrgInfo sysOrginfo = new SysOrgInfo();
								techResourceTmp.setTechResourceUndertakeList(new ArrayList<>());
								TechResourceUndertakeUnitR techResourceUndertakeUnitR = new TechResourceUndertakeUnitR();
								if (orgNameHashMap.containsKey(row.getCell(4).getStringCellValue())) {
									sysOrginfo = orgNameHashMap.get(row.getCell(4).getStringCellValue());
									// techResourceTmp.setUndertakeUnitId(sysOrginfo.getId());
									techResourceTmp.setUndertakeUnitName(sysOrginfo.getOrgName());
									techResourceTmp.setUndertakeUnitQualified(1);
									techResourceTmp.setIsQualified(1);
									techResourceUndertakeUnitR.setUndertakeUnitId(sysOrginfo.getId());
									techResourceUndertakeUnitR.setUndertakeUnitName(sysOrginfo.getOrgName());
									techResourceTmp.getTechResourceUndertakeList().add(techResourceUndertakeUnitR);
								} else if (shortNameHashMap.containsKey(row.getCell(4).getStringCellValue())) {
									sysOrginfo = shortNameHashMap.get(row.getCell(4).getStringCellValue());

									// techResourceTmp.setUndertakeUnitId(sysOrginfo.getId());
									techResourceTmp.setUndertakeUnitName(sysOrginfo.getShortName());
									techResourceTmp.setUndertakeUnitQualified(1);
									techResourceTmp.setIsQualified(1);
									techResourceUndertakeUnitR.setUndertakeUnitId(sysOrginfo.getId());
									techResourceUndertakeUnitR.setUndertakeUnitName(sysOrginfo.getShortName());
									techResourceTmp.getTechResourceUndertakeList().add(techResourceUndertakeUnitR);
								} else {
									techResourceTmp.setUndertakeUnitName(row.getCell(4).getStringCellValue());
									techResourceTmp.setUndertakeUnitQualified(0);
									techResourceTmp.setIsQualified(0);
								}
								// techResourceUndertakeAddList.add(techResourceUndertakeUnitR);
							}
						}
						// 主要协作单位
						if (row.getCell(5) != null && row.getCell(5).getStringCellValue() != null) {
							if (row.getCell(5).getStringCellValue().contains("、")) {
								String rowValue = row.getCell(5).getStringCellValue().replaceAll("\r|\n", "");
								String[] cooperationUnitArray = rowValue.split("、");
								int length = cooperationUnitArray.length;
								int count = 0;
								for (String str : cooperationUnitArray) {
									if (orgNameHashMap.containsKey(str) || shortNameHashMap.containsKey(str)) {
										count++;
									}
								}
								if (length != count) {
									techResourceTmp.setCooperationUnitName(row.getCell(5).getStringCellValue());
									techResourceTmp.setCooperationUnitQualified(0);
									techResourceTmp.setIsQualified(0);
								} else {
									SysOrgInfo sysOrginfo = new SysOrgInfo();
									String cooperationUnitName = "";
									techResourceTmp.setTechResourceCooperationList(new ArrayList<>());
									for (String str : cooperationUnitArray) {
										TechResourceCooperationUnitR techResourceCooperationUnitR = new TechResourceCooperationUnitR();
										if (orgNameHashMap.containsKey(str)) {
											sysOrginfo = orgNameHashMap.get(str);
											// techResourceTmp.setCooperationUnitId(sysOrginfo.getId());
											cooperationUnitName += sysOrginfo.getOrgName() + "、";
											techResourceTmp.setCooperationUnitName(cooperationUnitName.substring(0,
													cooperationUnitName.length() - 1));
											techResourceTmp.setCooperationUnitQualified(1);
											techResourceTmp.setIsQualified(1);
											techResourceCooperationUnitR.setCooperationUnitId(sysOrginfo.getId());
											techResourceCooperationUnitR
													.setCooperationUnitName(sysOrginfo.getOrgName());
											techResourceTmp.getTechResourceCooperationList()
													.add(techResourceCooperationUnitR);
										} else if (shortNameHashMap.containsKey(str)) {
											sysOrginfo = shortNameHashMap.get(str);
											// techResourceTmp.setCooperationUnitId(sysOrginfo.getId());
											cooperationUnitName += sysOrginfo.getShortName() + "、";
											techResourceTmp.setCooperationUnitName(cooperationUnitName.substring(0,
													cooperationUnitName.length() - 1));
											techResourceTmp.setCooperationUnitQualified(1);
											techResourceTmp.setIsQualified(1);
											techResourceCooperationUnitR.setCooperationUnitId(sysOrginfo.getId());
											techResourceCooperationUnitR
													.setCooperationUnitName(sysOrginfo.getShortName());
											techResourceTmp.getTechResourceCooperationList()
													.add(techResourceCooperationUnitR);
										}
									//	techResourceCooperationAddList.add(techResourceCooperationUnitR);
									}
								}
							} else {
								// 进行模糊匹配修正
								// 如果没有顿号分割
								SysOrgInfo sysOrginfo = new SysOrgInfo();
								techResourceTmp.setTechResourceCooperationList(new ArrayList<>());
								TechResourceCooperationUnitR techResourceCooperationUnitR = new TechResourceCooperationUnitR();
								if (orgNameHashMap.containsKey(row.getCell(5).getStringCellValue())) {
									sysOrginfo = orgNameHashMap.get(row.getCell(5).getStringCellValue());
									techResourceTmp.setCooperationUnitId(sysOrginfo.getId());
									techResourceTmp.setCooperationUnitName(sysOrginfo.getOrgName());

									techResourceTmp.setCooperationUnitQualified(1);
									techResourceTmp.setIsQualified(1);
									techResourceCooperationUnitR.setCooperationUnitId(sysOrginfo.getId());
									techResourceCooperationUnitR.setCooperationUnitName(sysOrginfo.getOrgName());
									techResourceTmp.getTechResourceCooperationList()
											.add(techResourceCooperationUnitR);
								} else if (shortNameHashMap.containsKey(row.getCell(5).getStringCellValue())) {
									sysOrginfo = shortNameHashMap.get(row.getCell(5).getStringCellValue());

									// techResourceTmp.setCooperationUnitId(sysOrginfo.getId());
									techResourceTmp.setCooperationUnitName(sysOrginfo.getShortName());
									techResourceTmp.setCooperationUnitQualified(1);
									techResourceTmp.setIsQualified(1);
									techResourceCooperationUnitR.setCooperationUnitId(sysOrginfo.getId());
									techResourceCooperationUnitR.setCooperationUnitName(sysOrginfo.getShortName());
									techResourceTmp.getTechResourceCooperationList()
											.add(techResourceCooperationUnitR);
								} else {
									techResourceTmp.setCooperationUnitName(row.getCell(5).getStringCellValue());
									techResourceTmp.setCooperationUnitQualified(0);
									techResourceTmp.setIsQualified(0);
								}
							// 	techResourceCooperationAddList.add(techResourceCooperationUnitR);
							}
						} else {
							techResourceTmp.setCooperationUnitQualified(1);
							techResourceTmp.setIsQualified(1);
						}
						// 起止时间
						if (row.getCell(6) != null && row.getCell(6).getStringCellValue() != null) {
							String startEndTime = row.getCell(6).getStringCellValue();
							String[] newStartEnd = startEndTime.split("-");
							String startDate = newStartEnd[0];
							String endDate = newStartEnd[1];
							try {
								techResourceTmp.setStartDate(
										new Timestamp(new SimpleDateFormat("yyyy").parse(startDate).getTime()));
								techResourceTmp.setEndDate(
										new Timestamp(new SimpleDateFormat("yyyy").parse(endDate).getTime()));
							} catch (ParseException e) { // TODO Auto-generated catch block
								e.printStackTrace();
							}
						}
						// 总投资
						if (row.getCell(7) != null) {
							XSSFCell cells = row.getCell(7);
							// 设置单元格类型
							cells.setCellType(CellType.STRING);
							if (row.getCell(7).getStringCellValue() != null) {
								techResourceTmp
										.setTotalInvestment(new BigDecimal(row.getCell(7).getStringCellValue()));
							}

						}
						// 市级拨款
						if (row.getCell(8) != null) {
							XSSFCell cella = row.getCell(8);
							// 设置单元格类型
							cella.setCellType(CellType.STRING);
							if (row.getCell(8).getStringCellValue() != null) {
								techResourceTmp
										.setCityAppropriation(new BigDecimal(row.getCell(8).getStringCellValue()));
							}
						}
						// 区市配套
						if (row.getCell(9) != null) {
							XSSFCell cellb = row.getCell(9);
							// 设置单元格类型
							cellb.setCellType(CellType.STRING);
							if (row.getCell(9).getStringCellValue() != null
									&& row.getCell(9).getStringCellValue().trim().length() > 0) {
								techResourceTmp.setCountyAppropriation(
										new BigDecimal(row.getCell(9).getStringCellValue()));
							}

						}
						// 自筹
						if (row.getCell(10) != null) {
							XSSFCell cellc = row.getCell(10);
							// 设置单元格类型
							cellc.setCellType(CellType.STRING);
							if (row.getCell(10).getStringCellValue() != null
									&& row.getCell(10).getStringCellValue().trim().length() > 0) {
								techResourceTmp.setIndependentlyAppropriation(
										new BigDecimal(row.getCell(10).getStringCellValue()));
							}
						}
						// 拨款年度
						if (row.getCell(11) != null) {
							XSSFCell celle = row.getCell(11);
							celle.setCellType(CellType.STRING);
							techResourceTmp.setAppropriationYear(row.getCell(11).getStringCellValue());
						}

						// 当年度拨款
						if (row.getCell(12) != null) {
							XSSFCell celld = row.getCell(12);
							// 设置单元格类型
							celld.setCellType(CellType.STRING);
							if (row.getCell(12).getStringCellValue() != null
									&& row.getCell(12).getStringCellValue().trim().length() > 0) {
								techResourceTmp.setAppropriationNumber(
										new BigDecimal(row.getCell(12).getStringCellValue()));
							}
						}
						// 拨款批次
						if (row.getCell(13) != null) {
							// 设置单元格类型
							XSSFCell celle = row.getCell(13);
							celle.setCellType(CellType.STRING);
							if (row.getCell(13).getStringCellValue() != null
									&& row.getCell(13).getStringCellValue().trim().length() > 0) {
								techResourceTmp.setAppropriationBatch(
										Integer.valueOf(row.getCell(13).getStringCellValue()));
							}
						}

						// 拨款级
						if (row.getCell(14) != null && row.getCell(14).getStringCellValue() != null) {
							if (row.getCell(14).getStringCellValue().contains("\n")) {
								String[] appropriationLevelArray = row.getCell(14).getStringCellValue().split("\n");
								int length = appropriationLevelArray.length;
								int count = 0;
								for (String str : appropriationLevelArray) {
									if (appropriationLevelHashMap.containsKey(str)) {
										count++;
									}
								}
								if (length != count) {
									techResourceTmp.setAppropriationLevel(row.getCell(14).getStringCellValue());
									techResourceTmp.setAppropriationLevelQualified(0);
									techResourceTmp.setIsQualified(0);
								} else {
									MasterCodeB masterCodeB = new MasterCodeB();
									TechResourceAppropriationLevelR techResourceAppropriationLevelR = new TechResourceAppropriationLevelR();
									techResourceTmp.setTechResourceAppropriationLevelList(new ArrayList<>());
									String appappropriationLevel = "";
									for (String str : appropriationLevelArray) {
										if (appropriationLevelHashMap.containsKey(str)) {
											techResourceAppropriationLevelR = new TechResourceAppropriationLevelR();
											masterCodeB = appropriationLevelHashMap.get(str);
											appappropriationLevel += masterCodeB.getName() + "\n";
											techResourceTmp.setAppropriationLevel(appappropriationLevel.substring(0,
													appappropriationLevel.length() - 1));
											techResourceTmp.setAppropriationLevelQualified(1);
											techResourceTmp.setIsQualified(1);
											techResourceAppropriationLevelR
													.setAppropriationLevel(masterCodeB.getClassb());
											techResourceTmp.getTechResourceAppropriationLevelList()
													.add(techResourceAppropriationLevelR);
										}
										techResourceAppropriationLevelAddList.add(techResourceAppropriationLevelR);
									}
								}
							} else if (row.getCell(14).getStringCellValue().contains(" ")) {
								String[] appropriationLevelArray = row.getCell(14).getStringCellValue().split(" ");
								int length = appropriationLevelArray.length;
								int count = 0;
								for (String str : appropriationLevelArray) {
									if (appropriationLevelHashMap.containsKey(str)) {
										count++;
									}
								}
								if (length != count) {
									techResourceTmp.setAppropriationLevel(row.getCell(14).getStringCellValue());
									techResourceTmp.setAppropriationLevelQualified(0);
									techResourceTmp.setIsQualified(0);
								} else {
									MasterCodeB masterCodeB = new MasterCodeB();
									TechResourceAppropriationLevelR techResourceAppropriationLevelR = new TechResourceAppropriationLevelR();
									techResourceTmp.setTechResourceAppropriationLevelList(new ArrayList<>());
									String appappropriationLevel = "";
									for (String str : appropriationLevelArray) {
										if (appropriationLevelHashMap.containsKey(str)) {
											techResourceAppropriationLevelR = new TechResourceAppropriationLevelR();
											masterCodeB = appropriationLevelHashMap.get(str);
											appappropriationLevel += masterCodeB.getName() + "\n";
											techResourceTmp.setAppropriationLevel(appappropriationLevel.substring(0,
													appappropriationLevel.length() - 1));
											techResourceTmp.setAppropriationLevelQualified(1);
											techResourceTmp.setIsQualified(1);
											techResourceAppropriationLevelR
													.setAppropriationLevel(masterCodeB.getClassb());
											techResourceTmp.getTechResourceAppropriationLevelList()
													.add(techResourceAppropriationLevelR);
										}
										techResourceAppropriationLevelAddList.add(techResourceAppropriationLevelR);
									}
								}
							} else {
								MasterCodeB masterCodeB = new MasterCodeB();
								TechResourceAppropriationLevelR techResourceAppropriationLevelR = new TechResourceAppropriationLevelR();
								techResourceTmp.setTechResourceAppropriationLevelList(new ArrayList<>());
								if (appropriationLevelHashMap.containsKey(row.getCell(14).getStringCellValue())) {
									masterCodeB = appropriationLevelHashMap
											.get(row.getCell(14).getStringCellValue());
									techResourceTmp.setAppropriationLevelQualified(1);
									techResourceTmp.setIsQualified(1);
									techResourceTmp.setAppropriationLevel(masterCodeB.getClassb());
									techResourceAppropriationLevelR.setAppropriationLevel(masterCodeB.getClassb());
									techResourceTmp.getTechResourceAppropriationLevelList()
											.add(techResourceAppropriationLevelR);
								} else {
									techResourceTmp.setAppropriationLevelQualified(0);
									techResourceTmp.setIsQualified(0);
									techResourceTmp.setAppropriationLevel(row.getCell(14).getStringCellValue());
								}

								techResourceAppropriationLevelAddList.add(techResourceAppropriationLevelR);
							}
						}
						// 业务处室
						if (row.getCell(15) != null && row.getCell(15).getStringCellValue() != null) {
							SysOrgInfo sysOrginfo = new SysOrgInfo();
							if (orgNameHashMap.containsKey(row.getCell(15).getStringCellValue())) {
								sysOrginfo = orgNameHashMap.get(row.getCell(15).getStringCellValue());
								techResourceTmp.setOwnerOrgId(sysOrginfo.getId());
								techResourceTmp.setOwnerOrgName(sysOrginfo.getOrgName());
								techResourceTmp.setOwnerOrgQualified(1);
								techResourceTmp.setIsQualified(1);
							} else if (shortNameHashMap.containsKey(row.getCell(15).getStringCellValue())) {
								sysOrginfo = shortNameHashMap.get(row.getCell(15).getStringCellValue());
								techResourceTmp.setOwnerOrgId(sysOrginfo.getId());
								techResourceTmp.setOwnerOrgName(sysOrginfo.getShortName());
								techResourceTmp.setOwnerOrgQualified(1);
								techResourceTmp.setIsQualified(1);
							} else {
								techResourceTmp.setUndertakeUnitName(row.getCell(15).getStringCellValue());
								techResourceTmp.setOwnerOrgQualified(0);
								techResourceTmp.setIsQualified(0);
							}
						}
						// 验收年度
						if (row.getCell(16) != null) {
							XSSFCell celle = row.getCell(16);
							celle.setCellType(CellType.STRING);
							techResourceTmp.setAcceptanceYear(row.getCell(16).getStringCellValue());
						}
						// 验收结论
						if (row.getCell(17) != null && row.getCell(17).getStringCellValue() != null) {
							techResourceTmp.setAcceptanceResult(row.getCell(17).getStringCellValue());
						}
						// 二次验收结论
						if (row.getCell(18) != null && row.getCell(18).getStringCellValue() != null) {
							techResourceTmp.setAcceptanceTwoResult(row.getCell(18).getStringCellValue());
						}
						// 计划大本备注（人才姓名）
						if (row.getCell(19) != null && row.getCell(19).getStringCellValue() != null) {
							techResourceTmp.setProjectMemo(row.getCell(19).getStringCellValue());
						}
						// 修改备注
						if (row.getCell(20) != null && row.getCell(20).getStringCellValue() != null) {
							techResourceTmp.setEditionMemo(row.getCell(20).getStringCellValue());
						}
						if (loginResult != null) {
							techResourceTmp.setCreateOrgId(loginResult.getUser().getOrgId());
							techResourceTmp.setCreateTime(new Timestamp(System.currentTimeMillis()));
							techResourceTmp.setCreateUserId(loginResult.getUser().getId());
							techResourceTmp.setCreateUserName(loginResult.getUser().getShortName());
							techResourceTmp.setUpdateTime(new Timestamp(System.currentTimeMillis()));
							techResourceTmp.setUpdateUserName(loginResult.getUser().getUserName());
						}
						// 临时表的list
						techResourceTmpList.add(techResourceTmp);
					}
				}
			}
			workbook.close();
		}
	}

	// techResourceAppropriationLevelList.add(techResourceAppropriationLevelR);
	List<TechResourceTmp> techResourceTmpListNew = new ArrayList<>();
	List<TechResourceTmp> listQuery = new ArrayList<>();
	if (!techResourceTmpList.isEmpty()) {
		for (TechResourceTmp techResourceTmp : techResourceTmpList) {
			TechResource techResource = new TechResource();
			if (techResourceTmp.getProjectTypeQualified().equals(1)
					&& techResourceTmp.getUndertakeUnitQualified().equals(1)
					&& techResourceTmp.getCooperationUnitQualified().equals(1)
					&& techResourceTmp.getAppropriationLevelQualified().equals(1)
					&& techResourceTmp.getOwnerOrgQualified().equals(1)) {
				if (techResourceTmp.getIsQualified().toString().equals("1")) {
					BeanUtils.copyProperties(techResourceTmp, techResource);
					techResourceList.add(techResource);
				} else {
					techResourceTmpListNew.add(techResourceTmp);
				}
			} else {
				techResourceTmpListNew.add(techResourceTmp);
			}

		}
	}

	Page<TechResource> page = new Page<>();
	TechResourceTmpQueryParam techResourcTmpeQueryParam = new TechResourceTmpQueryParam();
	PageInfo pageInfo = new PageInfo();
	/*
	 * pageInfo.setCurrentPage(queryParam.getPn());
	 * pageInfo.setPageSize(queryParam.getPs());
	 */
	if (!techResourceList.isEmpty()) {
		// 插入正式表
		int count = techResourceMapper.insertBatch(techResourceList);
		// 判断并循环相关list是否为空 循环正式表list，判断值是否相等 相等把主键id放进去
		for (TechResource techResource : techResourceList) {
			if (techResource.getTechResourceUndertakeList() != null
					&& techResource.getTechResourceUndertakeList().size() > 0) {
				String name = "";
				for (TechResourceUndertakeUnitR techResourceUndertakeR : techResource
						.getTechResourceUndertakeList()) {
					techResourceUndertakeR.setTechResourceId(techResource.getId());
					techResourceUndertakeAddList.add(techResourceUndertakeR);
					name += techResourceUndertakeR.getUndertakeUnitName() + "、";
				}
				techResource.setUndertakeUnitName(name.substring(0, name.length() - 1));
			}

			if (techResource.getTechResourceCooperationList() != null
					&& techResource.getTechResourceCooperationList().size() > 0) {
				String name = "";
				for (TechResourceCooperationUnitR techResourceCooperationR : techResource
						.getTechResourceCooperationList()) {
					techResourceCooperationR.setTechResourceId(techResource.getId());
					techResourceCooperationAddList.add(techResourceCooperationR);
					name += techResourceCooperationR.getCooperationUnitName() + "、";
				}

				techResource.setCooperationUnitName(name.substring(0, name.length() - 1));
			}
			
			if (techResource.getTechResourceAppropriationLevelList() != null
					&& techResource.getTechResourceAppropriationLevelList().size() > 0) {
				String name = "";
				for (TechResourceAppropriationLevelR techResourceAppropriationLevelR : techResource
						.getTechResourceAppropriationLevelList()) {
					techResourceAppropriationLevelR.setTechResourceId(techResource.getId());
					techResourceAppropriationLevelAddList.add(techResourceAppropriationLevelR);
					name += techResourceAppropriationLevelR.getAppropriationLevel() + "\r|\n";
				}
				techResource.setAppropriationLevelName(name.substring(0, name.length() - 1));
			}
			// techResourceMapper.update(techResource);
		}

		if (techResourceUndertakeAddList != null && techResourceUndertakeAddList.size() > 0) {
			List<TechResourceUndertakeUnitR> list = techResourceUndertakeAddList.stream().distinct().collect(Collectors.toList());
			techResourceUndertakeUnitRMapper.insertBatch(list);
		}
		if (techResourceCooperationAddList != null && techResourceCooperationAddList.size() > 0) {
			List<TechResourceCooperationUnitR> list = techResourceCooperationAddList.stream().distinct().collect(Collectors.toList());
			techResourceCooperationUnitRMapper.insertBatch(list);
		}
		if (techResourceAppropriationLevelAddList != null && techResourceAppropriationLevelAddList.size() > 0) {
			List<TechResourceAppropriationLevelR> list = techResourceAppropriationLevelAddList.stream().distinct().collect(Collectors.toList());
			techResourceAppropriationLevelRMapper.insertBatch(list	);
		}
		if (!techResourceTmpListNew.isEmpty()) {
			// 插入临时表
			techResourceTmpMapper.insertBatch(techResourceTmpListNew);
			// TechResourceTmpQueryParam techResourcTmpeQueryParam = new
			// TechResourceTmpQueryParam();
			techResourcTmpeQueryParam.setPs(Integer.MAX_VALUE);
			listQuery = techResourceTmpMapper.listQuery(techResourcTmpeQueryParam);
		}
		if (count > 0) {
			return listQuery;
		}

	} else {
		// 插入临时表
		techResourceTmpMapper.insertBatch(techResourceTmpListNew);
		// TechResourceTmpQueryParam techResourcTmpeQueryParam = new
		// TechResourceTmpQueryParam();
		techResourcTmpeQueryParam.setPs(Integer.MAX_VALUE);
		listQuery = techResourceTmpMapper.listQuery(techResourcTmpeQueryParam);
		return listQuery;
	}

	return listQuery;

	/*
	 * if (!techResourceList.isEmpty()) { int count =
	 * techResourceMapper.insertBatch(techResourceList); if (count > 0) { return
	 * "导入成功"; } } else { techResourceTmpMapper.insertBatch(techResourceTmpList);
	 * return "文件为空"; }
	 * 
	 * return "导入成功";
	 */
}
chenlin_lin
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
R如何导入带有分隔符号的文件
Ray_zhu的博客
12-03 1584
read.table(file,options) Tables Are Cool col 3 is right-aligned $1600 col 2 is centered $12 zebra stripes are neat $1 options 描述 header 文件第一行是否表明了变量名的逻辑值 sep 文件中分开数据值的分
labview电子表格的写入
粟米茶
04-07 5295
将波形写入excel表格
EXCEL——分列
最新发布
龙皮皮的博客
05-07 1287
EXCEL——分列，快速将在一个单元格是数据进行分割
关于批量导入大量本地帐户的方法
weixin_33948416的博客
05-30 271
近日部署一套应用系统需要在2003下添加上百个本地帐户，于是在网上搜了搜，和现在的实际情况结合了一下，总结了1个方法。首先需要写一个csv文件，第一列是帐户名，第二列是中文全名，第三列是密码然后用命令：for/f"tokens=1,2,3delims=,"%ain(user.csv)donetuser%a%c/add/...
labview—电子表格文件读写
热门推荐
观则明的博客
06-01 1万+
labview—电子表格文件读写，利用读取带分隔符电子表格 VI 和写入带分隔符电子表格 VI
MVC3.0 实现Html表格导入到Excel中
10-12
在IT行业中，将HTML表格的数据导入到Excel是常见的数据处理需求，尤其是在Web应用程序中。MVC3.0（Model-View-Controller）是Microsoft ASP.NET框架的一个版本，它提供了强大的结构化开发方式来构建Web应用。本文将...
导入模板20170730.rar
10-22
4. 数据格式：导入模板通常会规定数据的格式，如日期格式（YYYY-MM-DD）、数字格式（带有千位分隔符或不带）、文本格式等，以保持一致性并减少错误。 5. 数据验证：在导入数据之前，模板可能已经设置了一些验证规则...
Excel财务行政专项模板--货币换算
11-24
- **单元格格式**：在Excel中，你可以通过“单元格格式”对话框设置货币样式，包括货币符号、小数位数、千位分隔符等。 - **自动调整格式**：当输入数值并选中货币格式后，Excel会自动根据系统区域设置显示相应的...
Excel模板报价单.zip
04-13
Excel提供了丰富的单元格格式选项，包括货币符号、小数位数、千位分隔符等。 3. **公式与函数**：Excel的强大之处在于其计算能力。在报价单中，可以使用公式自动计算总价、折扣、税额等。例如，总价可以通过"数量...
Excel数据批量导入与Excel文件的导出
10-08
2. **Excel模板导入**：如果你有固定的模板格式，可以创建一个Excel模板，然后使用VBA（Visual Basic for Applications）编写宏，批量读取外部数据并填充到模板中。这样可以实现自动化数据更新，提高效率。 3. **...
LabVIEW将表格写入excel表
qq_44981039的博客
04-01 9608
函数介绍 写入带分隔符电子表格VI 使字符串、带符号整数或双精度数的二维或一维数组转换为文本字符串，写入字符串至新的字节流文件或添加字符串至现有文件。 通过连线数据至二维数据或一维数据输入端可确定要使用的多态实例，也可手动选择实例。使用该VI可转置或分隔数据。 1.格式指定如何将数字转化为字符。 如格式为%s（默认），VI将复制输入字符串。 如格式为%.3f，VI将创建包含数字的字符串，小数点后有三位数字。 如格式为%d，VI将把数据转换为整数，使用尽可能多的字符包含整个数字。 使用格式字符串语法。 2.
LabVIEW-电子表格字符串中的分隔符
菜鸟Neo
03-28 1万+
原字符串： '\'代码显示（右键鼠标即可显示） 其中的\s代表空格，即space 对于： 如果默认分隔符则分隔符为Tab，即\t 但是此文本数与数之间的分隔符是\s, 所有要在分隔符里面键入一次空格。才能完成正常的转化。
LabVIEW学习分享（5）
weixin_43221346的博客
07-15 1624
LabVIEW实用总结–多格式存储数据 小树不修不直溜，人不学习哏揪揪！这天又开始烘烤模式了，虽然说很想请个大假，找个清凉之处爽一下，可是悲伤的是本小学生紫外线过敏，即使是三伏天也只能穿长衣长裤，出行只能早晨5点左右不能超过7点，晚上8点天大黑以后，这点苦难都不是让我最悲伤的，这可是最艳丽的夏天啊，能少穿就少穿，到处都是风景，而我只能尴尬的对着办公室的屏幕(┬＿┬)，默默忍受着烘烤与煎熬。我师父经...
Oracle设置指定分隔符对数据进行导入与导出
weixin_41675512的博客
07-31 3637
oracle导出数据： sqlplus -s zhangsan/123456@12.34.56.78/scott<<EOF set echo off; set wrap off; set feedback off; set heading off; set pagesize 0; set linesize 4096; set numwidth 50; set verify off; set term off; set trimspool on; spool /home/user/12
String类中的split()等其他方法的详解(源码分析)
码农小默
09-03 1946
一、背景 1.今天主要介绍的是String类中的split()方法，主要从源码的角度去分析这个方法底层到底做了些什么，下面我们就开始吧。 2.其实看源码也能学到很多东西的，希望坚持下去。 二、源码解析split(String regex) 1.首先我们写一个str1.split(",")其中str1定义为"i,am,a,student"，下面我们就开始跳进我们的源码，开始分析。 1.第一...
LabVIEW学习分享（6）
weixin_43221346的博客
08-05 2659
LabVIEW实用总结–数据文件读取 小树不修不直溜，人不学习哏揪揪！又到了出门就是被“烧烤”的时节，生存愈加艰辛。此处感谢拯救了全人类的英俊帅气的空调之父Willis Carrier，给了我们生存的机会。本小学生鉴于前些时分享的数据多格式存储的设计思路，对应设计读取文件的程序，同时感谢许多大神与小伙伴们给予我的指点φ(≧ω≦*)♪，特总结此文，以留纪念，望大神指点！ 本文中鉴于LabVIEW学习...
EXCEL表格实现万位分隔符效果！
banglun5623的博客
09-09 1145
单击单元格右键 选择自定义单元格格式 选择数字标签 选择自定义 在输入框中输入：###","#### 单击确定即可！ 格式刷可以对其他单元格实行同样效果！ 转载于:https://www.cnblogs.com/TENOKAWA/p/5858242.html...
2.3.2 从带分隔符的文本文件导入数据(read.table())
Python大家一起学
05-19 4165
2.3.2 从带分隔符的文本文件导入数据(read.table()) 你可以使用read.table()从带分隔符的文本文件中导入数据。此函数可读入一个表格格式的文件并将其保存为一个数据框。表格的每一行分别出现在文件中每一行。其语法如下： mydataframe <- read.table(file,options) 其中，file是一个带分隔符的ASCII文本文件，options是控制如...
JAVApoi导出excel时如何插入分隔符
06-10
在使用JAVApoi导出Excel时，可以通过设置单元格的数据格式来插入分隔符。具体步骤如下： 1. 创建一个样式对象，并设置数据格式为文本格式，同时设置数据格式的格式化字符串，例如设置为"#,##0.00"。 ``` CellStyle style = workbook.createCellStyle(); style.setDataFormat(workbook.createDataFormat().getFormat("#,##0.00")); ``` 2. 在需要插入分隔符的单元格中设置该样式。 ``` Cell cell = row.createCell(0); cell.setCellValue(123456789.123); cell.setCellStyle(style); ``` 这样，在Excel中就会显示为：123,456,789.12。其中逗号为分隔符，小数点后保留两位。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值