模拟考试修改

Administrator

2022-06-16 8b375fe00a241b3a769b82fe3dac8d1c9dce8a02

 src/main/java/org/springblade/modules/information/controller/InformationController.java

@@ -325,34 +325,54 @@
         } else {
            licences = "";
         }

         if (information.getEstablishtime() != null && !"".equals(information.getEstablishtime())) {
            format = new SimpleDateFormat("yyyy-MM-dd").format(information.getEstablishtime());
            //内网同步
            String s1 = "update sys_information set creditCode = " + "'" + information.getCreditcode() + "'" +
               ",enterpriseName = " + "'" + information.getEnterprisename() + "'" +
               ",representative = " + "'" + information.getRepresentative() + "'" +
               ",establishTime = " + "'" + format + "'" +
               ",registeredCapital = " + "'" + information.getRegisteredcapital() + "'" +
               ",jurisdiction = " + "'" + information.getJurisdiction() + "'" +
               ",enterprises = " + "'" + information.getEnterprises() + "'" +
               ",address = " + "'" + information.getAddress() + "'" +
               ",business = " + "'" + information.getBusiness() + "'" +
               ",region = " + "'" + information.getRegion() + "'" +
               ",registration = " + "'" + information.getRegistration() + "'" +
               ",industry = " + "'" + information.getIndustry() + "'" +
               ",departmentid = " + "'" + information.getDepartmentid() + "'" +
               ",stats = " + "'" + information.getStats() + "'" +
               ",representativecell = " + "'" + information.getRepresentativecell() + "'" +
               ",contacts = " + "'" + information.getContacts() + "'" +
               ",contactscell = " + "'" + information.getContactscell() + "'" +
               ",business_License = " + "'" + businessLicenses + "'" +
               ",licence = " + "'" + licences + "'" +
               " " + "where id = " + "'" + information.getId() + "'";
         }else {
            //内网同步
            String s1 = "update sys_information set creditCode = " + "'" + information.getCreditcode() + "'" +
               ",enterpriseName = " + "'" + information.getEnterprisename() + "'" +
               ",representative = " + "'" + information.getRepresentative() + "'" +
               ",registeredCapital = " + "'" + information.getRegisteredcapital() + "'" +
               ",jurisdiction = " + "'" + information.getJurisdiction() + "'" +
               ",enterprises = " + "'" + information.getEnterprises() + "'" +
               ",address = " + "'" + information.getAddress() + "'" +
               ",business = " + "'" + information.getBusiness() + "'" +
               ",region = " + "'" + information.getRegion() + "'" +
               ",registration = " + "'" + information.getRegistration() + "'" +
               ",industry = " + "'" + information.getIndustry() + "'" +
               ",departmentid = " + "'" + information.getDepartmentid() + "'" +
               ",stats = " + "'" + information.getStats() + "'" +
               ",representativecell = " + "'" + information.getRepresentativecell() + "'" +
               ",contacts = " + "'" + information.getContacts() + "'" +
               ",contactscell = " + "'" + information.getContactscell() + "'" +
               ",business_License = " + "'" + businessLicenses + "'" +
               ",licence = " + "'" + licences + "'" +
               " " + "where id = " + "'" + information.getId() + "'";
            //FtpUtil.sqlFileUpload(s1);
            myAsyncService.FTP(s1);
         }


         //内网同步
         String s1 = "update sys_information set creditCode = " + "'" + information.getCreditcode() + "'" +
            ",enterpriseName = " + "'" + information.getEnterprisename() + "'" +
            ",representative = " + "'" + information.getRepresentative() + "'" +
            ",establishTime = " + "'" + format + "'" +
            ",registeredCapital = " + "'" + information.getRegisteredcapital() + "'" +
            ",jurisdiction = " + "'" + information.getJurisdiction() + "'" +
            ",enterprises = " + "'" + information.getEnterprises() + "'" +
            ",address = " + "'" + information.getAddress() + "'" +
            ",business = " + "'" + information.getBusiness() + "'" +
            ",region = " + "'" + information.getRegion() + "'" +
            ",registration = " + "'" + information.getRegistration() + "'" +
            ",industry = " + "'" + information.getIndustry() + "'" +
            ",departmentid = " + "'" + information.getDepartmentid() + "'" +
            ",stats = " + "'" + information.getStats() + "'" +
            ",representativecell = " + "'" + information.getRepresentativecell() + "'" +
            ",contacts = " + "'" + information.getContacts() + "'" +
            ",contactscell = " + "'" + information.getContactscell() + "'" +
            ",business_License = " + "'" + businessLicenses + "'" +
            ",licence = " + "'" + licences + "'" +
            " " + "where id = " + "'" + information.getId() + "'";
         //FtpUtil.sqlFileUpload(s1);
         myAsyncService.FTP(s1);
      }
      return R.success("修改成功");
   }