智慧保安后台管理-外网-验收版本
Administrator
2021-09-13 0d99d26f39e055ee17fdbf2c5cbd1daf695c4310
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);
      }