保安员证编号推送

Administrator

2022-06-14 8fb9a2be4ca2b581b1f6b6b02be61b1a96e1b73b

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
 
package org.springblade.modules.securitypaper.service.impl;
 
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;
 
/**
 * 保安员证管理服务实现类
 * @author zhongrj
 * @since 2021-12-25
 */
@Service
@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);
        });
    }
}