智慧保安后台管理-外网-验收版本
tangzy
2021-12-06 cc057177b2fb17aee9a173a6adbabdc578fd74c7
src/main/java/org/springblade/modules/equipage/controller/CarController.java
@@ -80,7 +80,7 @@
         //数据同步
         String s1 =
            "insert into sys_car(id,car_number,number_type,car_type,dept_id," +
               "person_in_charge,brand,date_for_production,umweltsatz,mode,jurisdiction) " +
               "person_in_charge,brand,date_for_production,umweltsatz,mode,jurisdiction,picture,driving_conditions) " +
               "values(" + "'" + car.getId() + "'" + "," +
               "'" + car.getCarNumber() + "'" + "," +
               "'" + car.getNumberType() + "'" + "," +
@@ -91,7 +91,9 @@
               "'" + new SimpleDateFormat("yyyy-MM-dd").format(car.getDateForProduction()) + "'" + "," +
               "'" + car.getUmweltsatz() + "'" + "," +
               "'" + car.getMode() + "'" + "," +
               "'" +car.getJurisdiction() + "'" + ")";
               "'" + car.getJurisdiction() + "'" + "," +
               "'" + car.getPicture() + "'" + "," +
               "'" +car.getDrivingConditions() + "'" + ")";
         FtpUtil.sqlFileUpload(s1);
      }else {
         //修改
@@ -108,6 +110,8 @@
               ",umweltsatz = " + "'" + car.getUmweltsatz() + "'" +
               ",mode = " + "'" + car.getMode() + "'" +
               ",jurisdiction = " + "'" + car.getJurisdiction() + "'" +
               ",picture = " + "'" + car.getPicture() + "'" +
               ",driving_conditions = " + "'" + car.getDrivingConditions() + "'" +
               " " +"where id = " + "'" + car.getId() + "'";
         FtpUtil.sqlFileUpload(s1);
      }