From ca90224ae08ff40b78daad37175639cae71c0855 Mon Sep 17 00:00:00 2001 From: “djh” <“3298565835@qq.com”> Date: 星期四, 20 二月 2025 14:16:59 +0800 Subject: [PATCH] 煤矿缴费修改 --- exam-system/src/main/java/com/gkhy/exam/pay/service/impl/CoalPayStudentServiceImpl.java | 31 +++++++++++++++++++++---------- 1 files changed, 21 insertions(+), 10 deletions(-) diff --git a/exam-system/src/main/java/com/gkhy/exam/pay/service/impl/CoalPayStudentServiceImpl.java b/exam-system/src/main/java/com/gkhy/exam/pay/service/impl/CoalPayStudentServiceImpl.java index cbf03bc..90039df 100644 --- a/exam-system/src/main/java/com/gkhy/exam/pay/service/impl/CoalPayStudentServiceImpl.java +++ b/exam-system/src/main/java/com/gkhy/exam/pay/service/impl/CoalPayStudentServiceImpl.java @@ -10,10 +10,8 @@ import com.ruoyi.common.core.domain.model.LoginUser; import com.ruoyi.common.exception.BusinessException; import com.ruoyi.common.utils.SecurityUtils; -import org.apache.poi.ss.usermodel.Row; -import org.apache.poi.ss.usermodel.Sheet; -import org.apache.poi.ss.usermodel.Workbook; -import org.apache.poi.ss.usermodel.WorkbookFactory; +import com.ruoyi.common.utils.StringUtils; +import org.apache.poi.ss.usermodel.*; import org.aspectj.weaver.loadtime.Aj; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; @@ -94,13 +92,26 @@ coalPayStudent.setCoalPayId(coalPayId); if (row!=null){ coalPayStudent.setName(row.getCell(0).getStringCellValue()); - coalPayStudent.setIdCard(row.getCell(1).getStringCellValue()); + String idCard = row.getCell(1).getStringCellValue(); + coalPayStudent.setIdCard(idCard); coalPayStudent.setPhone(row.getCell(2).getStringCellValue()); - String stringCellValue = row.getCell(3).getStringCellValue(); - if (stringCellValue.equals("男")){ - coalPayStudent.setSex(0L); - }else if (stringCellValue.equals("女")){ - coalPayStudent.setSex(1L); + Cell cell = row.getCell(3); + if (cell!=null){ + if (StringUtils.isEmpty(cell.getStringCellValue())){ + coalPayStudent.setTrain("-"); + }else{ + coalPayStudent.setTrain(cell.getStringCellValue()); + } + } + + char c = idCard.charAt(idCard.length() - 1); + if (Character.isDigit(c)){ + int genderDigit = Character.getNumericValue(c); + if (genderDigit % 2 == 1) { + coalPayStudent.setSex(0L); + } else { + coalPayStudent.setSex(1L); + } } coalPayStudent.setPayStatus(0L); coalPayStudent.setCreateBy(loginUser.getUsername()); -- Gitblit v1.9.2