java/zhihuishenqu.git

			@@ -45,6 +45,10 @@
			@Resource
			private GuideRepairOrderMapper guideRepairOrderMapper;


			@Resource
			private AutomessagePolicyDocumentsMapper automessagePolicyDocumentsMapper;

			@Override
			public TransactionEvent selectConfigData(String Id, SysUser sysUser) {
			TransactionEvent transactionEvent = baseMapper.selectConfigData(Id);
			@@ -157,6 +161,8 @@
			}
			queryResults.setTransactionEventList(searchesAssociate);
			queryResults.setKeywordEntityList(keywordMapper.selectByName(keyWord));
			queryResults.setAutomessagePolicyDocuments(automessagePolicyDocumentsMapper.selectConfigList(keyWord,"2",null,null));
			queryResults.setRegulations(automessagePolicyDocumentsMapper.selectConfigList(keyWord,"1",null,null));
			return queryResults;
			}

			@@ -190,6 +196,8 @@
			}
			recommendResult.setKeywordEntityList(keywordEntityList);
			List<OrganizationChartEntity> organizationChartEntities = organizationChartMapper.selectByKeyWord(keyWord);
			recommendResult.setAutomessagePolicyDocuments(automessagePolicyDocumentsMapper.selectConfigList(keyWord,"2",null,null));
			recommendResult.setRegulations(automessagePolicyDocumentsMapper.selectConfigList(keyWord,"1",null,null));
			recommendResult.setOrganizationChartEntityList(organizationChartEntities);
			return recommendResult;
			}
			@@ -315,14 +323,15 @@
			String applicationMaterial = "<p>";
			while (true) {
			Row row = sheetAt.getRow(i);
			if (row.getCell(0).getStringCellValue().equals("办理途径、条件和注意事项")) {
			if (new DataFormatter().formatCellValue(row.getCell(0)).equals("办理途径、条件和注意事项")) {
			i = i + 2;
			break;
			}
			applicationMaterial = applicationMaterial + "办理区域：" + new DataFormatter().formatCellValue(row.getCell(0)) + "<br />"
			+ "咨询电话：" + new DataFormatter().formatCellValue(row.getCell(1)) + "<br />"
			+ "办公地址：" + new DataFormatter().formatCellValue(row.getCell(2)) + "<br />"
			+ "办公时间：" + new DataFormatter().formatCellValue(row.getCell(3)) + "<br />";
			+ "部门名称：" + new DataFormatter().formatCellValue(row.getCell(1)) + "<br />"
			+ "咨询电话：" + new DataFormatter().formatCellValue(row.getCell(2)) + "<br />"
			+ "办公地址：" + new DataFormatter().formatCellValue(row.getCell(3)) + "<br />"
			+ "办公时间：" + new DataFormatter().formatCellValue(row.getCell(4)) + "<br />";
			applicationMaterial = applicationMaterial + "<br />";
			i++;
			}
			@@ -331,13 +340,15 @@
			String acceptConditions = "<p>";
			while (true) {
			Row row = sheetAt.getRow(i);
			if (row.getCell(0).getStringCellValue().equals("（二）网上申报")) {
			if (new DataFormatter().formatCellValue(row.getCell(0)).equals("（二）网上申报")) {
			i = i + 1;
			break;
			}
			acceptConditions = acceptConditions + new DataFormatter().formatCellValue(row.getCell(0)) + "  "
			+new DataFormatter().formatCellValue( row.getCell(1)) + "  "
			+ new DataFormatter().formatCellValue(row.getCell(2)) + "  ";
			+ new DataFormatter().formatCellValue(row.getCell(2)) + "  "
			+new DataFormatter().formatCellValue( row.getCell(3)) + "  "
			+ new DataFormatter().formatCellValue(row.getCell(4)) + "  ";
			acceptConditions = acceptConditions + "<br />";
			i++;
			}
			@@ -346,13 +357,15 @@
			String rates = "<p>";
			while (true) {
			Row row = sheetAt.getRow(i);
			if (row.getCell(0).getStringCellValue().equals("（三）手机移动申报")) {
			if (new DataFormatter().formatCellValue(row.getCell(0)).equals("（三）手机移动申报")) {
			i = i + 1;
			break;
			}
			rates = rates + new DataFormatter().formatCellValue(row.getCell(0)) + "  "
			+ new DataFormatter().formatCellValue(row.getCell(1)) + "  "
			+ new DataFormatter().formatCellValue(row.getCell(2)) + "  ";
			+ new DataFormatter().formatCellValue(row.getCell(2)) + "  "
			+new DataFormatter().formatCellValue( row.getCell(3)) + "  "
			+ new DataFormatter().formatCellValue(row.getCell(4)) + "  ";
			rates = rates + "<br />";
			i++;
			}
			@@ -361,13 +374,15 @@
			String transactionArea = "<p>";
			while (true) {
			Row row = sheetAt.getRow(i);
			if (row.getCell(0).getStringCellValue().equals("（四）经营许可（备案）事项程序运行图谱（附电子版）")) {
			if (new DataFormatter().formatCellValue(row.getCell(0)).equals("（四）经营许可（备案）事项程序运行图谱（附电子版）")) {
			i = i + 1;
			break;
			}
			transactionArea = transactionArea + new DataFormatter().formatCellValue(row.getCell(0)) + "  "
			+ new DataFormatter().formatCellValue(row.getCell(1)) + "  "
			+ new DataFormatter().formatCellValue(row.getCell(2)) + "  ";
			+ new DataFormatter().formatCellValue(row.getCell(2)) + "  "
			+new DataFormatter().formatCellValue( row.getCell(3)) + "  "
			+ new DataFormatter().formatCellValue(row.getCell(4)) + "  ";
			transactionArea = transactionArea + "<br />";
			i++;
			}
			@@ -376,13 +391,15 @@
			String handlingProcedures = "<p>";
			while (true) {
			Row row = sheetAt.getRow(i);
			if (row.getCell(0).getStringCellValue().equals("（五）经营许可（备案）事项实施内容一览表（附电子版）")) {
			if (new DataFormatter().formatCellValue(row.getCell(0)).equals("（五）经营许可（备案）事项实施内容一览表（附电子版）")) {
			i = i + 1;
			break;
			}
			handlingProcedures = handlingProcedures + new DataFormatter().formatCellValue(row.getCell(0)) + "  "
			+ new DataFormatter().formatCellValue(row.getCell(1)) + "  "
			+ new DataFormatter().formatCellValue(row.getCell(2)) + "  ";
			+ new DataFormatter().formatCellValue(row.getCell(2)) + "  "
			+new DataFormatter().formatCellValue( row.getCell(3)) + "  "
			+ new DataFormatter().formatCellValue(row.getCell(4)) + "  ";
			handlingProcedures = handlingProcedures + "<br />";
			i++;
			}