新增保安员证编号批量导入，保安员新增，从业记录同步sql 修改

Administrator

2022-06-30 a9943ed22bd7568924bf98c462139269d873cd8a

 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);
         }
      }
   }
}