1.许可

tangzy

2021-12-06 cc057177b2fb17aee9a173a6adbabdc578fd74c7

 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,user_id,num,purchase_time,type) " +
               "values(" + "'" + equipage.getId() + "'" + "," +
               "'" + equipage.getName() + "'" + "," +
               "'" + equipage.getNumber() + "'" + "," +
@@ -93,7 +93,9 @@
               "'" + new SimpleDateFormat("yyyy-MM-dd").format(equipage.getDateForProduction()) + "'" + "," +
               "'" + equipage.getJurisdiction() + "'" + "," +
               "'" + equipage.getUserId() + "'" + "," +
               "'" +equipage.getNum() + "'" + ")";
               "'" + equipage.getNum() + "'" + "," +
               "'" + new SimpleDateFormat("yyyy-MM-dd").format(equipage.getPurchaseTime()) + "'" + "," +
               "'" +equipage.getType() + "'" + ")";
         FtpUtil.sqlFileUpload(s1);
      }else {
         //修改
@@ -110,6 +112,8 @@
               ",jurisdiction = " + "'" + equipage.getJurisdiction() + "'" +
               ",user_id = " + "'" + equipage.getUserId() + "'" +
               ",num = " + "'" + equipage.getNum() + "'" +
               ",purchase_time = " + "'" + equipage.getPurchaseTime() + "'" +
               ",type = " + "'" + equipage.getType() + "'" +
               " " +"where id = " + "'" + equipage.getId() + "'";
         FtpUtil.sqlFileUpload(s1);
      }
@@ -161,7 +165,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("***保安公司");