保安员证编号推送

Administrator

2022-06-14 8fb9a2be4ca2b581b1f6b6b02be61b1a96e1b73b

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

@@ -7,8 +7,10 @@
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;

@@ -20,6 +22,9 @@
@Service
@AllArgsConstructor
public class SecurityPaperServiceImpl extends ServiceImpl<SecurityPaperMapper, SecurityPaper> implements SecurityPaperService {

   private final MyAsyncService myAsyncService;

   /**
    * 导入保安员证数据
    * @param data
@@ -29,14 +34,14 @@
   @Override
   public void importSecurityPaper(List<SecurityPaperExcel> data, Boolean isCovered, String deptId) {
      data.forEach(securityPaperExcel -> {
         SecurityPaper securityPaper = new SecurityPaper();
         securityPaper.setIdCardNo(securityPaperExcel.getCardid());
         securityPaper.setPeopleName(securityPaperExcel.getRealName());
         securityPaper.setNumber(securityPaperExcel.getSecuritynumber());
         securityPaper.setCreateTime(new Date());
         securityPaper.setSource(3);
         //新增
         this.save(securityPaper);
         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);
      });
   }
}