智慧保安后台管理-外网
Administrator
2021-09-27 345d17cf82e1bbc1fbfbeec10193c2bed59cd674
src/main/java/org/springblade/modules/equipage/controller/EquipageController.java
@@ -82,7 +82,7 @@
         //数据推送
         String s1 =
            "insert into sys_equipage(id,name,number,specifications,mode,dept_id,brand,date_for_production,jurisdiction,user_id,num) " +
            "insert into sys_equipage(id,name,number,specifications,mode,dept_id,brand,date_for_production,jurisdiction,person_in_charge,num) " +
               "values(" + "'" + equipage.getId() + "'" + "," +
               "'" + equipage.getName() + "'" + "," +
               "'" + equipage.getNumber() + "'" + "," +
@@ -92,7 +92,7 @@
               "'" + equipage.getBrand() + "'" + "," +
               "'" + new SimpleDateFormat("yyyy-MM-dd").format(equipage.getDateForProduction()) + "'" + "," +
               "'" + equipage.getJurisdiction() + "'" + "," +
               "'" + equipage.getUserId() + "'" + "," +
               "'" + equipage.getPersonInCharge() + "'" + "," +
               "'" +equipage.getNum() + "'" + ")";
         FtpUtil.sqlFileUpload(s1);
      }else {
@@ -108,8 +108,8 @@
               ",brand = " + "'" + equipage.getBrand() + "'" +
               ",date_for_production = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(equipage.getDateForProduction()) + "'" +
               ",jurisdiction = " + "'" + equipage.getJurisdiction() + "'" +
               ",user_id = " + "'" + equipage.getUserId() + "'" +
               ",num = " + "'" + equipage.getNum() + "'" +
               ",person_in_charge = " + "'" + equipage.getPersonInCharge() + "'" +
               " " +"where id = " + "'" + equipage.getId() + "'";
         FtpUtil.sqlFileUpload(s1);
      }
@@ -161,7 +161,7 @@
    */
   @GetMapping("export-template")
   @ApiOperation(value = "导出模板")
   public void exportUser(HttpServletResponse response) {
   public void exportEquipage(HttpServletResponse response) {
      List<EquipageExcel> list = new ArrayList<>();
      EquipageExcel equipage = new EquipageExcel();
      equipage.setDeptName("***保安公司");