证件编号导入修改

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 + "'"