From 5d1d54e83546ba9fc85c69b32287883d04f4a475 Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期五, 01 十一月 2024 18:56:13 +0800
Subject: [PATCH] 代码提交
---
smartor/src/main/java/com/smartor/service/impl/PatArchiveImportServiceImpl.java | 18 +++++++++---------
1 files changed, 9 insertions(+), 9 deletions(-)
diff --git a/smartor/src/main/java/com/smartor/service/impl/PatArchiveImportServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/PatArchiveImportServiceImpl.java
index dbe3da2..1a3a169 100644
--- a/smartor/src/main/java/com/smartor/service/impl/PatArchiveImportServiceImpl.java
+++ b/smartor/src/main/java/com/smartor/service/impl/PatArchiveImportServiceImpl.java
@@ -115,18 +115,18 @@
PatArchiveImport patArchiveImport = new PatArchiveImport();
Row row = sheet.getRow(i);
//濡傛灉琛屼负绌猴紝杩涜涓嬩竴娆″惊鐜�
- if (ObjectUtils.isEmpty(row.getCell(0)) && ObjectUtils.isEmpty(row.getCell(1)) && ObjectUtils.isEmpty(row.getCell(2))) {
+ if (ObjectUtils.isEmpty(row.getCell(0)) && StringUtils.isNotEmpty(row.getCell(0) + "") && ObjectUtils.isEmpty(row.getCell(1)) && StringUtils.isNotEmpty(row.getCell(1) + "") && ObjectUtils.isEmpty(row.getCell(2)) && StringUtils.isNotEmpty(row.getCell(2) + "")) {
continue;
}
//鍒ゆ柇鏁版嵁鏄惁鏈夐棶棰�
- if (ObjectUtils.isNotEmpty(row.getCell(0))) {
+ if (ObjectUtils.isNotEmpty(row.getCell(0)) && StringUtils.isNotEmpty(row.getCell(0) + "")) {
patArchiveImport.setName(row.getCell(0).toString());
} else {
continue;
}
- if (ObjectUtils.isNotEmpty(row.getCell(1))) {
+ if (ObjectUtils.isNotEmpty(row.getCell(1)) && StringUtils.isNotEmpty(row.getCell(1) + "")) {
Cell cell = row.getCell(1);
if (row.getCell(1).toString().contains("X") || row.getCell(1).toString().contains("x")) {
patArchiveImport.setIdcardno(row.getCell(1).toString());
@@ -147,27 +147,27 @@
if (contains) continue;
}
- if (ObjectUtils.isNotEmpty(row.getCell(2))) {
+ if (ObjectUtils.isNotEmpty(row.getCell(2)) && StringUtils.isNotEmpty(row.getCell(2) + "")) {
Cell cell = row.getCell(2);
double numericCellValue = cell.getNumericCellValue();
DecimalFormat decimalFormat = new DecimalFormat("#");
String formattedValue = decimalFormat.format(numericCellValue);
patArchiveImport.setTelcode(formattedValue);
}
- if (ObjectUtils.isNotEmpty(row.getCell(3))) {
+ if (ObjectUtils.isNotEmpty(row.getCell(3)) && StringUtils.isNotEmpty(row.getCell(3) + "")) {
patArchiveImport.setBatchName(row.getCell(3).toString());
}
- if (ObjectUtils.isNotEmpty(row.getCell(4))) {
+ if (ObjectUtils.isNotEmpty(row.getCell(4)) && StringUtils.isNotEmpty(row.getCell(4) + "")) {
patArchiveImport.setPatientno(row.getCell(4).toString());
}
- if (ObjectUtils.isNotEmpty(row.getCell(5))) {
+ if (ObjectUtils.isNotEmpty(row.getCell(5)) && StringUtils.isNotEmpty(row.getCell(5) + "")) {
patArchiveImport.setPattype(row.getCell(5).toString());
}
- if (ObjectUtils.isNotEmpty(row.getCell(6))) {
+ if (ObjectUtils.isNotEmpty(row.getCell(6)) && StringUtils.isNotEmpty(row.getCell(6) + "")) {
patArchiveImport.setSex(Long.valueOf(row.getCell(6).toString()));
}
- if (ObjectUtils.isNotEmpty(row.getCell(7))) {
+ if (ObjectUtils.isNotEmpty(row.getCell(7)) && StringUtils.isNotEmpty(row.getCell(7) + "")) {
patArchiveImport.setAge(Long.valueOf(row.getCell(7).toString()));
}
--
Gitblit v1.9.3