From 8fb9a2be4ca2b581b1f6b6b02be61b1a96e1b73b Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Tue, 14 Jun 2022 16:30:29 +0800
Subject: [PATCH] 保安员证编号推送
---
src/main/java/org/springblade/modules/securitypaper/service/impl/SecurityPaperServiceImpl.java | 27 +++++++++++++++++++++++++++
1 files changed, 27 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 b445218..aecc8ba 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
@@ -4,9 +4,15 @@
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.AllArgsConstructor;
import org.springblade.modules.securitypaper.entity.SecurityPaper;
+import org.springblade.modules.securitypaper.excel.SecurityPaperExcel;
import org.springblade.modules.securitypaper.mapper.SecurityPaperMapper;
import org.springblade.modules.securitypaper.service.SecurityPaperService;
+import org.springblade.modules.system.service.MyAsyncService;
import org.springframework.stereotype.Service;
+
+import java.text.SimpleDateFormat;
+import java.util.Date;
+import java.util.List;
/**
* 保安员证管理服务实现类
@@ -17,4 +23,25 @@
@AllArgsConstructor
public class SecurityPaperServiceImpl extends ServiceImpl<SecurityPaperMapper, SecurityPaper> implements SecurityPaperService {
+ private final MyAsyncService myAsyncService;
+
+ /**
+ * 导入保安员证数据
+ * @param data
+ * @param isCovered
+ * @param deptId
+ */
+ @Override
+ public void importSecurityPaper(List<SecurityPaperExcel> data, Boolean isCovered, String deptId) {
+ data.forEach(securityPaperExcel -> {
+ String sql = "insert into sys_security_paper(number,create_time,people_name,id_card_no,source) " +
+ "values(" + "'" + securityPaperExcel.getSecuritynumber() + "'" + "," +
+ "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + "'" + "," +
+ "," + "'" + securityPaperExcel.getRealName() + "'" +
+ "," + "'" + securityPaperExcel.getCardid() + "'" +
+ "," + "'" + 3 + "'"
+ + ")";
+ myAsyncService.FTP(sql);
+ });
+ }
}
--
Gitblit v1.9.3