证件编号导入修改

Administrator

2022-06-14 c87fb558bc1cf1c007f2a0a8a73943889e6baa62

证件编号导入修改

 src/main/java/org/springblade/modules/securitypaper/service/impl/SecurityPaperServiceImpl.java

@@ -35,8 +35,8 @@
    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()) + "'" + "," +
                "values(" + "'" + securityPaperExcel.getSecuritynumber() + "'" +
                "," + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + "'" +
                "," + "'" + securityPaperExcel.getRealName() + "'" +
                "," + "'" + securityPaperExcel.getCardid() + "'" +
                "," + "'" + 3 + "'"