11111

fxl

2023-05-04 e150655a785de36a65a26a0dc4d3d6d65fe7e9d0

 src/main/java/com/hxzkoa/services/SysSettingService.java

@@ -502,28 +502,31 @@
      }
      return tb_systemList;
   }
	
   @Transactional
   public int addVersion(String time,String BsVersion){
      String sql = null;
      Query query = null;
      sql = "INSERT INTO tb_version(BsVersion,BsTime) VALUES(:BsVersion,:time)";
      query = this.em.createNativeQuery(sql);
      query.setParameter("time", time);
      query.setParameter("BsVersion", BsVersion);
      int executeUpdate = query.executeUpdate();
      return executeUpdate;
   }
   @Transactional
   public int sysSetting_modify(tb_system setting) {
      String sql = null;
      Query query = null;
      sql = "UPDATE tb_system SET dataname=:dataname,datapass=:datapass,gui_ji=:gui_ji,bei_fen_di_zhi=:bei_fen_di_zhi,data_time=:data_time,title=:title,udpPort=:udpPort,udpAdress=:udpAdress,openudp=:openudp,"
            + "know_tag_zu=:know_tag_zu,wifi_mdel=:wifi_mdel,tagZb=:tagZb,diskaoqing=:diskaoqing,viewAnckid=:viewAnckid,viewName=:viewName,tunlDw=:tunlDw,guiji_sava=:guiji_sava,viewPower=:viewPower,"
      sql = "UPDATE tb_system SET gui_ji=:gui_ji,title=:title,"
            + "diskaoqing=:diskaoqing,viewAnckid=:viewAnckid,viewName=:viewName,tunlDw=:tunlDw,guiji_sava=:guiji_sava,viewPower=:viewPower,"
            + "viewTagid=:viewTagid,viewAnckzb=:viewAnckzb,offView=:offView,anckicon=:anckicon,gas_show=:gas_show,real_trak_time=:real_trak_time,"
            + "real_trak_color=:real_trak_color,gas_open=:gas_open,gas_port=:gas_port,gas_hz=:gas_hz,rssid=:rssid,fence_show=:fence_show,yulan_map=:yulan_map,baidu_j=:baidu_j,baidu_w=:baidu_w WHERE id= 1";
            + "real_trak_color=:real_trak_color,fence_show=:fence_show,yulan_map=:yulan_map,baidu_j=:baidu_j,baidu_w=:baidu_w WHERE id= 1";
      query = this.em.createNativeQuery(sql);
      query.setParameter("dataname", setting.getDataname());
      query.setParameter("datapass", setting.getDatapass());

      query.setParameter("gui_ji", setting.getGui_ji());
      query.setParameter("bei_fen_di_zhi", setting.getBei_fen_di_zhi());
      query.setParameter("data_time", setting.getData_time());
      query.setParameter("title", setting.getTitle());
      query.setParameter("udpPort", setting.getUdpPort());
      query.setParameter("udpAdress", setting.getUdpAdress());
      query.setParameter("openudp", setting.getOpenudp());
      query.setParameter("know_tag_zu", setting.getKnow_tag_zu());
      query.setParameter("wifi_mdel", setting.getWifi_mdel());
      query.setParameter("tagZb", setting.getTagZb());


      query.setParameter("diskaoqing", setting.getDiskaoqing());
      query.setParameter("viewAnckid", setting.getViewAnckid());
      query.setParameter("viewName", setting.getViewName());
@@ -538,10 +541,6 @@
//    query.setParameter("quiet", setting.getQuiet());
      query.setParameter("real_trak_time", setting.getReal_trak_time());
      query.setParameter("real_trak_color", setting.getReal_trak_color());
      query.setParameter("gas_open", setting.getGas_open());
      query.setParameter("gas_port", setting.getGas_port());
      query.setParameter("gas_hz", setting.getGas_hz());
      query.setParameter("rssid", setting.getRssid());
      query.setParameter("fence_show", setting.getFence_show());
      query.setParameter("yulan_map", setting.getYulan_map());
      query.setParameter("baidu_j", setting.getBaidu_j());