From a9943ed22bd7568924bf98c462139269d873cd8a Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Thu, 30 Jun 2022 17:40:45 +0800
Subject: [PATCH] 新增保安员证编号批量导入，保安员新增，从业记录同步sql 修改
---
src/main/java/org/springblade/modules/securitypaper/service/impl/SecurityPaperServiceImpl.java | 23 +++++++++++++++++++++++
1 files changed, 23 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/securitypaper/service/impl/SecurityPaperServiceImpl.java b/src/main/java/org/springblade/modules/securitypaper/service/impl/SecurityPaperServiceImpl.java
index d360e30..2d53887 100644
--- a/src/main/java/org/springblade/modules/securitypaper/service/impl/SecurityPaperServiceImpl.java
+++ b/src/main/java/org/springblade/modules/securitypaper/service/impl/SecurityPaperServiceImpl.java
@@ -12,6 +12,7 @@
import org.springblade.modules.FTP.Result;
import org.springblade.modules.exam.entity.ExamScore;
import org.springblade.modules.securitypaper.entity.SecurityPaper;
+import org.springblade.modules.securitypaper.excel.PaperExcel;
import org.springblade.modules.securitypaper.excel.SecurityPaperExcel;
import org.springblade.modules.securitypaper.mapper.SecurityPaperMapper;
import org.springblade.modules.securitypaper.service.SecurityPaperService;
@@ -176,4 +177,26 @@
}
}
}
+
+ /**
+ * 批量导入证件数据
+ * @param data
+ * @param isCovered
+ */
+ @Override
+ public void importPaper(List<PaperExcel> data, Boolean isCovered) {
+ if (data.size()>0){
+ for (PaperExcel paperExcel : data) {
+ //设置信息
+ String sql = "insert into sys_security_paper(number,create_time,people_name,id_card_no,source) " +
+ "values(" + "'" + paperExcel.getNumber() + "'" + "," +
+ "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + "'" + "," +
+ "'" + paperExcel.getRealName() + "'" + "," +
+ "'" + paperExcel.getCardid() + "'" + ",3)";
+ System.out.println(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + "保安员证编号导入sql = " + sql);
+ //数据推送
+ myAsyncService.FTP(sql);
+ }
+ }
+ }
}
--
Gitblit v1.9.3