From 00b820d4401096e5afc28c0f62107270ea312d11 Mon Sep 17 00:00:00 2001
From: fengjin <1435304038@qq.com>
Date: 星期三, 09 十一月 2022 14:13:26 +0800
Subject: [PATCH] 修改bug

---
 flower_city/src/main/java/com/dg/core/service/impl/TransactionEventImpl.java |   33 +++++++++++++++++++++------------
 1 files changed, 21 insertions(+), 12 deletions(-)

diff --git a/flower_city/src/main/java/com/dg/core/service/impl/TransactionEventImpl.java b/flower_city/src/main/java/com/dg/core/service/impl/TransactionEventImpl.java
index 9976d5d..75123c2 100644
--- a/flower_city/src/main/java/com/dg/core/service/impl/TransactionEventImpl.java
+++ b/flower_city/src/main/java/com/dg/core/service/impl/TransactionEventImpl.java
@@ -315,14 +315,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 +332,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)) + "&nbsp; "
                         +new DataFormatter().formatCellValue( row.getCell(1)) + "&nbsp; "
-                        + new DataFormatter().formatCellValue(row.getCell(2)) + "&nbsp; ";
+                        + new DataFormatter().formatCellValue(row.getCell(2)) + "&nbsp; "
+                         +new DataFormatter().formatCellValue( row.getCell(3)) + "&nbsp; "
+                        + new DataFormatter().formatCellValue(row.getCell(4)) + "&nbsp; ";
                 acceptConditions = acceptConditions + "<br />";
                 i++;
             }
@@ -346,13 +349,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)) + "&nbsp; "
                         + new DataFormatter().formatCellValue(row.getCell(1)) + "&nbsp; "
-                        + new DataFormatter().formatCellValue(row.getCell(2)) + "&nbsp; ";
+                        + new DataFormatter().formatCellValue(row.getCell(2)) + "&nbsp; "
+                        +new DataFormatter().formatCellValue( row.getCell(3)) + "&nbsp; "
+                        + new DataFormatter().formatCellValue(row.getCell(4)) + "&nbsp; ";
                 rates = rates + "<br />";
                 i++;
             }
@@ -361,13 +366,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)) + "&nbsp; "
                         + new DataFormatter().formatCellValue(row.getCell(1)) + "&nbsp; "
-                        + new DataFormatter().formatCellValue(row.getCell(2)) + "&nbsp; ";
+                        + new DataFormatter().formatCellValue(row.getCell(2)) + "&nbsp; "
+                        +new DataFormatter().formatCellValue( row.getCell(3)) + "&nbsp; "
+                        + new DataFormatter().formatCellValue(row.getCell(4)) + "&nbsp; ";
                 transactionArea = transactionArea + "<br />";
                 i++;
             }
@@ -376,13 +383,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)) + "&nbsp; "
                         + new DataFormatter().formatCellValue(row.getCell(1)) + "&nbsp; "
-                        + new DataFormatter().formatCellValue(row.getCell(2)) + "&nbsp; ";
+                        + new DataFormatter().formatCellValue(row.getCell(2)) + "&nbsp; "
+                        +new DataFormatter().formatCellValue( row.getCell(3)) + "&nbsp; "
+                        + new DataFormatter().formatCellValue(row.getCell(4)) + "&nbsp; ";
                 handlingProcedures = handlingProcedures + "<br />";
                 i++;
             }

--
Gitblit v1.7.1