Merge remote-tracking branch 'origin/master'

zengh

2021-12-04 9ded1cc24d75fe3acd058aa1918624ff81bfcd50

Merge remote-tracking branch 'origin/master'

 src/main/java/org/springblade/modules/licetuser/controller/LicetuserController.java

@@ -71,45 +71,45 @@
        Map map = licetuserService.liceIn(licetuser.getUserid(),licetuser.getPtype());
        if (map==null){
            licetuserService.save(licetuser);
            String url = "";
            String[] split = licetuser.getLinks().split(",");
            for (int i = 0; i < split.length; i++) {
                String s = split[i].substring(26, split[i].length());
                String[] splits = split[i].split("/");
                url += FtpConstant.ip +"/zhba/upload/picture/"+ splits[6] + ",";
            }
            String substring = url.substring(0, url.length() - 1);
            licetuser.setLinks(substring);
            //数据同步
            String s1 =
                "insert into sys_licetuser(id,userid,ptype,templateid,links) " +
                    "values(" + "'" + licetuser.getId() + "'" + "," +
                    "'" + licetuser.getUserid() + "'" + "," +
                    "'" + licetuser.getPtype() + "'" + "," +
                    "'" + licetuser.getTemplateid() + "'" + "," +
                    "'" + licetuser.getLinks() + "'" + ")";
            FtpUtil.sqlFileUpload(s1);
//            String url = "";
//            String[] split = licetuser.getLinks().split(",");
//            for (int i = 0; i < split.length; i++) {
//                String s = split[i].substring(26, split[i].length());
//                String[] splits = split[i].split("/");
//                url += FtpConstant.ip +"/zhba/upload/picture/"+ splits[6] + ",";
//            }
//            String substring = url.substring(0, url.length() - 1);
//            licetuser.setLinks(substring);
//            //数据同步
//            String s1 =
//                "insert into sys_licetuser(id,userid,ptype,templateid,links) " +
//                    "values(" + "'" + licetuser.getId() + "'" + "," +
//                    "'" + licetuser.getUserid() + "'" + "," +
//                    "'" + licetuser.getPtype() + "'" + "," +
//                    "'" + licetuser.getTemplateid() + "'" + "," +
//                    "'" + licetuser.getLinks() + "'" + ")";
//            FtpUtil.sqlFileUpload(s1);
        }
        else {
            String id = map.get("id").toString();
            Integer a= Integer.parseInt(id);
            licetuser.setId(a);
            licetuserService.updateById(licetuser);
            String url = "";
            String[] split = licetuser.getLinks().split(",");
            for (int i = 0; i < split.length; i++) {
                String s = split[i].substring(26, split[i].length());
                String[] splits = split[i].split("/");
                url += FtpConstant.ip +"/zhba/upload/picture/"+ splits[6] + ",";
            }
            String substring = url.substring(0, url.length() - 1);
            licetuser.setLinks(substring);
            String s1 = "update sys_licetuser set userid = " + "'" + licetuser.getUserid() + "'" +
                ",ptype = " + "'" + licetuser.getPtype() + "'" +
                ",templateid = " + "'" + licetuser.getTemplateid() + "'" +
                ",links = " + "'" + licetuser.getLinks() + "'" +
                " " + "where id = " + "'" + licetuser.getId() + "'";
            FtpUtil.sqlFileUpload(s1);
//            String url = "";
//            String[] split = licetuser.getLinks().split(",");
//            for (int i = 0; i < split.length; i++) {
//                String s = split[i].substring(26, split[i].length());
//                String[] splits = split[i].split("/");
//                url += FtpConstant.ip +"/zhba/upload/picture/"+ splits[6] + ",";
//            }
//            String substring = url.substring(0, url.length() - 1);
//            licetuser.setLinks(substring);
//            String s1 = "update sys_licetuser set userid = " + "'" + licetuser.getUserid() + "'" +
//                ",ptype = " + "'" + licetuser.getPtype() + "'" +
//                ",templateid = " + "'" + licetuser.getTemplateid() + "'" +
//                ",links = " + "'" + licetuser.getLinks() + "'" +
//                " " + "where id = " + "'" + licetuser.getId() + "'";
//            FtpUtil.sqlFileUpload(s1);
        }
        return R.data("成功");
    }

 src/main/java/org/springblade/modules/permit/controller/PermitController.java

@@ -146,19 +146,19 @@
        permit.setStorage("1");
        permit.setPermitime(new Date());
        permitService.save(permit);
        String pertime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(permit.getPermitime());
        String overtime = new SimpleDateFormat("yyyy-MM-dd").format(permit.getOvertime());
        String s = "insert into sys_permit(id,enterpriseName,representative," +
            "address,business,region,registration,industry,type,permitime,ptype,representativecell,contacts,contactscell,jurisdiction,cardid,overtime)" +
            "values(" + "'" + permit.getId() + "'" + ","+ "'" + permit.getEnterprisename() + "'" + "," + "'"
            + permit.getRepresentative() + "'" + "," + "'" +
            permit.getAddress() + "'" + "," + "'" + permit.getBusiness() + "'" + "," + "'" +
            permit.getRegion() + "'" + "," + "'" + permit.getRegistration() + "'" + "," + "'" + permit.getIndustry() + "'" + "," + "'"
            + permit.getType() + "'" + "," + "'" + pertime + "'" + "," + "'" + permit.getPtype() + "'" + "," +
            "'" + permit.getRepresentativecell() + "'" + "," + "'" + permit.getContacts() + "'" + "," + "'"
            + permit.getContactscell() + "'" + "," + "'" + permit.getJurisdiction() + "'" +
            "," + "'" + permit.getCardid() + "'"+ "," + "'" + overtime+ "'" + ")";
        FtpUtil.sqlFileUpload(s);
//        String pertime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(permit.getPermitime());
//        String overtime = new SimpleDateFormat("yyyy-MM-dd").format(permit.getOvertime());
//        String s = "insert into sys_permit(id,enterpriseName,representative," +
//            "address,business,region,registration,industry,type,permitime,ptype,representativecell,contacts,contactscell,jurisdiction,cardid,overtime)" +
//            "values(" + "'" + permit.getId() + "'" + ","+ "'" + permit.getEnterprisename() + "'" + "," + "'"
//            + permit.getRepresentative() + "'" + "," + "'" +
//            permit.getAddress() + "'" + "," + "'" + permit.getBusiness() + "'" + "," + "'" +
//            permit.getRegion() + "'" + "," + "'" + permit.getRegistration() + "'" + "," + "'" + permit.getIndustry() + "'" + "," + "'"
//            + permit.getType() + "'" + "," + "'" + pertime + "'" + "," + "'" + permit.getPtype() + "'" + "," +
//            "'" + permit.getRepresentativecell() + "'" + "," + "'" + permit.getContacts() + "'" + "," + "'"
//            + permit.getContactscell() + "'" + "," + "'" + permit.getJurisdiction() + "'" +
//            "," + "'" + permit.getCardid() + "'"+ "," + "'" + overtime+ "'" + ")";
//        FtpUtil.sqlFileUpload(s);
        return R.success("新增成功");
    }


 src/main/java/org/springblade/modules/record/controller/RecordController.java

@@ -123,20 +123,20 @@
        record.setType("2");
        record.setPermitime(new Date());
        recordService.save(record);
        String offtime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(record.getOfficetime());
        String pertime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(record.getPermitime());
        String s = "insert into sys_record(id,enterpriseName,representative," +
            "address,business,registration,industry,type,permitime,ptype,representativecell,contacts,contactscell,perid,offices,officetime,jurisdiction,cardid,storage,overtime)" +
            "values(" + "'" + record.getId() + "'"+ "," + "'" + record.getEnterprisename() + "'" + "," +
            "'" + record.getRepresentative() + "'"+ "," + "'" +
            record.getAddress() + "'" + "," + "'" + record.getBusiness() + "'" + "," + "'" + record.getRegistration() + "'" + "," + "'" + record.getIndustry() + "'" + "," + "'" + record.getType() + "'" + "," + "'" + pertime + "'" + "," + "'" + record.getPtype() + "'" + "," +
            "'" + record.getRepresentativecell() + "'" + "," + "'" + record.getContacts() + "'" + "," + "'" + record.getContactscell() + "'" + "," +"'" + record.getPerid() + "'" + "," + "'" + record.getOffices() + "'" + "," +
            "'" + offtime + "'" + "," + "'" + record.getJurisdiction() + "'" +
            "," + "'" + record.getCardid() + "'"+
            "," + "'" + record.getStorage() + "'"+
            "," + "'" + new SimpleDateFormat("yyyy-MM-dd").format(record.getOvertime()) + "'"
            + ")";
        FtpUtil.sqlFileUpload(s);
//        String offtime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(record.getOfficetime());
//        String pertime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(record.getPermitime());
//        String s = "insert into sys_record(id,enterpriseName,representative," +
//            "address,business,registration,industry,type,permitime,ptype,representativecell,contacts,contactscell,perid,offices,officetime,jurisdiction,cardid,storage,overtime)" +
//            "values(" + "'" + record.getId() + "'"+ "," + "'" + record.getEnterprisename() + "'" + "," +
//            "'" + record.getRepresentative() + "'"+ "," + "'" +
//            record.getAddress() + "'" + "," + "'" + record.getBusiness() + "'" + "," + "'" + record.getRegistration() + "'" + "," + "'" + record.getIndustry() + "'" + "," + "'" + record.getType() + "'" + "," + "'" + pertime + "'" + "," + "'" + record.getPtype() + "'" + "," +
//            "'" + record.getRepresentativecell() + "'" + "," + "'" + record.getContacts() + "'" + "," + "'" + record.getContactscell() + "'" + "," +"'" + record.getPerid() + "'" + "," + "'" + record.getOffices() + "'" + "," +
//            "'" + offtime + "'" + "," + "'" + record.getJurisdiction() + "'" +
//            "," + "'" + record.getCardid() + "'"+
//            "," + "'" + record.getStorage() + "'"+
//            "," + "'" + new SimpleDateFormat("yyyy-MM-dd").format(record.getOvertime()) + "'"
//            + ")";
//        FtpUtil.sqlFileUpload(s);
        return R.success("成功");
    }

@@ -172,7 +172,7 @@
    public R update(@Valid @RequestBody Record record) {
        //审核通过
        if (record.getType().equals("0")) {
            //新增组织机构和单位信息
        /*    //新增组织机构和单位信息
            Information information =new Information();
            information.setCreditcode(record.getCreditcode());
            information.setEnterprisename(record.getEnterprisename());
@@ -231,18 +231,18 @@
                ",sopinion = " + "'" + record.getSopinion() + "'"+
                ",xopinion = " + "'" + record.getXopinion() + "'"+
                " " +"where id = " + "'" + record.getId() + "'";
            FtpUtil.sqlFileUpload(s1);
            FtpUtil.sqlFileUpload(s1);*/
        }
        else {
            String s1 = "update sys_record set type = " + "'" + record.getType() + "'" +
                ",papprove = " + "'" + record.getPapprove() + "'"+
                ",xapprove = " + "'" + record.getXapprove() + "'"+
                ",sapprove = " + "'" + record.getSapprove() + "'"+
                ",popinion = " + "'" + record.getPopinion() + "'"+
                ",sopinion = " + "'" + record.getSopinion() + "'"+
                ",xopinion = " + "'" + record.getXopinion() + "'"+
                " " +"where id = " + "'" + record.getId() + "'";
            FtpUtil.sqlFileUpload(s1);
//            String s1 = "update sys_record set type = " + "'" + record.getType() + "'" +
//                ",papprove = " + "'" + record.getPapprove() + "'"+
//                ",xapprove = " + "'" + record.getXapprove() + "'"+
//                ",sapprove = " + "'" + record.getSapprove() + "'"+
//                ",popinion = " + "'" + record.getPopinion() + "'"+
//                ",sopinion = " + "'" + record.getSopinion() + "'"+
//                ",xopinion = " + "'" + record.getXopinion() + "'"+
//                " " +"where id = " + "'" + record.getId() + "'";
//            FtpUtil.sqlFileUpload(s1);
        }
        return R.status(recordService.saveOrUpdate(record));
    }

 src/main/java/org/springblade/modules/recordk/controller/RecordkController.java

@@ -105,20 +105,20 @@
        recordk.setType("2");
        recordk.setPermitime(new Date());
        recordkService.save(recordk);
        String offtime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(recordk.getOfficetime());
        String pertime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(recordk.getPermitime());
        String s = "insert into sys_recordk(id,creditCode,enterpriseName,representative," +
            "registeredCapital,organizationCode,registrationNumber,identificationNumber,enterprises," +
            "address,business,region,registration,industry,type,permitime,deptid,ptype,representativecell,contacts,contactscell,perid,offices,officetime,cardid,overtime)" +
            "values(" + "'" + recordk.getId() + "'" + "," + "'" + recordk.getCreditcode() + "'" + "," + "'" + recordk.getEnterprisename() + "'" + "," + "'"
            + recordk.getRepresentative() + "'" + "," +"'" + recordk.getRegisteredcapital() + "'" + "," + "'"
            + recordk.getOrganizationcode() + "'" + "," + "'" + recordk.getRegistrationnumber() + "'" + "," +
            "'" + recordk.getIdentificationnumber() + "'" + "," + "'" + recordk.getEnterprises() + "'" + "," + "'" +
            recordk.getAddress() + "'" + "," + "'" + recordk.getBusiness() + "'" + "," + "'" +
            recordk.getRegion() + "'" + "," + "'" + recordk.getRegistration() + "'" + "," + "'" + recordk.getIndustry() + "'" + "," + "'" + recordk.getType() + "'" + "," + "'" + pertime + "'" + "," + "'" + recordk.getDeptid() + "'" + "," + "'" + recordk.getPtype() + "'" + "," +
            "'" + recordk.getRepresentativecell() + "'" + "," + "'" + recordk.getContacts() + "'" + "," + "'" + recordk.getContactscell() + "'" + "," +
            "'" + recordk.getPerid() + "'" + "," + "'" + recordk.getOffices() + "'" + "," + "'" + offtime + "'"+ "," + "'" + recordk.getCardid() + "'"+"," + "'" + new SimpleDateFormat("yyyy-MM-dd").format(recordk.getOvertime()) + "'"+")";
        FtpUtil.sqlFileUpload(s);
//        String offtime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(recordk.getOfficetime());
//        String pertime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(recordk.getPermitime());
//        String s = "insert into sys_recordk(id,creditCode,enterpriseName,representative," +
//            "registeredCapital,organizationCode,registrationNumber,identificationNumber,enterprises," +
//            "address,business,region,registration,industry,type,permitime,deptid,ptype,representativecell,contacts,contactscell,perid,offices,officetime,cardid,overtime)" +
//            "values(" + "'" + recordk.getId() + "'" + "," + "'" + recordk.getCreditcode() + "'" + "," + "'" + recordk.getEnterprisename() + "'" + "," + "'"
//            + recordk.getRepresentative() + "'" + "," +"'" + recordk.getRegisteredcapital() + "'" + "," + "'"
//            + recordk.getOrganizationcode() + "'" + "," + "'" + recordk.getRegistrationnumber() + "'" + "," +
//            "'" + recordk.getIdentificationnumber() + "'" + "," + "'" + recordk.getEnterprises() + "'" + "," + "'" +
//            recordk.getAddress() + "'" + "," + "'" + recordk.getBusiness() + "'" + "," + "'" +
//            recordk.getRegion() + "'" + "," + "'" + recordk.getRegistration() + "'" + "," + "'" + recordk.getIndustry() + "'" + "," + "'" + recordk.getType() + "'" + "," + "'" + pertime + "'" + "," + "'" + recordk.getDeptid() + "'" + "," + "'" + recordk.getPtype() + "'" + "," +
//            "'" + recordk.getRepresentativecell() + "'" + "," + "'" + recordk.getContacts() + "'" + "," + "'" + recordk.getContactscell() + "'" + "," +
//            "'" + recordk.getPerid() + "'" + "," + "'" + recordk.getOffices() + "'" + "," + "'" + offtime + "'"+ "," + "'" + recordk.getCardid() + "'"+"," + "'" + new SimpleDateFormat("yyyy-MM-dd").format(recordk.getOvertime()) + "'"+")";
//        FtpUtil.sqlFileUpload(s);
        return R.success("成功");
    }

@@ -150,15 +150,15 @@
    @ApiOperationSupport(order = 5)
    @ApiOperation(value = "修改", notes = "传入recordk")
    public R update(@Valid @RequestBody Recordk recordk) {
        String s1 = "update sys_recordk set type = " + "'" + recordk.getType() + "'" +
            ",papprove = " + "'" + recordk.getPapprove() + "'"+
            ",xapprove = " + "'" + recordk.getXapprove() + "'"+
            ",sapprove = " + "'" + recordk.getSapprove() + "'"+
            ",popinion = " + "'" + recordk.getPopinion() + "'"+
            ",sopinion = " + "'" + recordk.getSopinion() + "'"+
            ",xopinion = " + "'" + recordk.getXopinion() + "'"+
            " " +"where id = " + "'" + recordk.getId() + "'";
        FtpUtil.sqlFileUpload(s1);
//        String s1 = "update sys_recordk set type = " + "'" + recordk.getType() + "'" +
//            ",papprove = " + "'" + recordk.getPapprove() + "'"+
//            ",xapprove = " + "'" + recordk.getXapprove() + "'"+
//            ",sapprove = " + "'" + recordk.getSapprove() + "'"+
//            ",popinion = " + "'" + recordk.getPopinion() + "'"+
//            ",sopinion = " + "'" + recordk.getSopinion() + "'"+
//            ",xopinion = " + "'" + recordk.getXopinion() + "'"+
//            " " +"where id = " + "'" + recordk.getId() + "'";
//        FtpUtil.sqlFileUpload(s1);
        return R.status(recordkService.updateById(recordk));
    }


 src/main/java/org/springblade/modules/recordk/entity/Recordk.java

@@ -171,6 +171,7 @@
    private String xopinion;
    //市意见
    private String sopinion;
    private String jurisdiction;

    @ApiModelProperty(value = "审批时间")
    @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8")

 src/main/java/org/springblade/modules/resource/endpoint/OssEndpoint.java

@@ -620,58 +620,11 @@
            attach.setNoticeId(noticeId);
        }
        attachService.save(attach);
        String[] split = bladeFile.getName().split("/");
        String ip = FtpConstant.ip+"/zhba/upload/picture/";
        String imgurl = ip + split[2];
        FtpUtil.uploadFile(ftpHost_dev, ftpPort, ftpUserName, ftpPassword, ftpPath, "/", split[2], in);
        //数据同步
        String s1 =
            "insert into blade_attach(id,tenant_id,link,domain,name,original_name,extension,attach_size,create_user,deptid," +
                "create_time,update_user,update_time,status,is_deleted,type,cardid";
        if (noticeId != null) {
            s1 += ",notice_id"+")" +"values(" + "'" + attach.getId() + "'" + "," +
                "'" + attach.getTenantId() + "'" + "," +
                "'" + imgurl + "'" + "," +
                "'" + ip + "'" + "," +
                "'" + split[2] + "'" + "," +
                "'" + attach.getOriginalName() + "'" + "," +
                "'" + attach.getExtension() + "'" + "," +
                "'" + attach.getAttachSize() + "'" + "," +
                "'" + attach.getCreateUser() + "'" + "," +
                "'" + attach.getDeptid() + "'" + "," +
                "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + "'" + "," +
                "'" + attach.getUpdateUser() + "'" + "," +
                "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + "'" + "," +
                "'" + attach.getStatus() + "'" + "," +
                "'" + attach.getIsDeleted() + "'" + "," +
                "'" + attach.getType() + "'" + "," +
                "'" + cardid + "'";
        } else {
            s1 += ") " +
                "values(" + "'" + attach.getId() + "'" + "," +
                "'" + attach.getTenantId() + "'" + "," +
                "'" + imgurl + "'" + "," +
                "'" + ip + "'" + "," +
                "'" + split[2] + "'" + "," +
                "'" + attach.getOriginalName() + "'" + "," +
                "'" + attach.getExtension() + "'" + "," +
                "'" + attach.getAttachSize() + "'" + "," +
                "'" + attach.getCreateUser() + "'" + "," +
                "'" + attach.getDeptid() + "'" + "," +
                "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + "'" + "," +
                "'" + attach.getUpdateUser() + "'" + "," +
                "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()) + "'" + "," +
                "'" + attach.getStatus() + "'" + "," +
                "'" + attach.getIsDeleted() + "'" + "," +
                "'" + attach.getType() + "'" + "," +
                "'" + cardid + "'";
        }
        if (noticeId != null) {
            s1 += ","+"'" + noticeId + "'" + ")";
        } else {
            s1 += ")";
        }
        FtpUtil.sqlFileUpload(s1);
        //String[] split = bladeFile.getName().split("/");
        //String ip = FtpConstant.ip+"/zhba/upload/picture/";
        //String imgurl = ip + split[2];
        //FtpUtil.uploadFile(ftpHost_dev, ftpPort, ftpUserName, ftpPassword, ftpPath, "/", split[2], in);
        //FtpUtil.sqlFileUpload(s1);
        return attach.getId();
    }


 src/main/java/org/springblade/modules/revoke/controller/RevokeController.java

@@ -104,23 +104,23 @@
        revoke.setType("2");
        revoke.setPermitime(new Date());
        revokeService.save(revoke);
        String formatStr = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(revoke.getEstablishtime());
        String pertime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(revoke.getPermitime());
        String s = "insert into sys_revoke(id,creditCode,enterpriseName,representative,establishTime," +
            "registeredCapital,organizationCode,registrationNumber,identificationNumber,enterprises," +
            "address,business,region,registration,industry,type,permitime,deptid,ptype,representativecell,contacts,contactscell,reason,jurisdiction,cardid)" +
            "values(" + "'" + revoke.getId() + "'" + "," + "'" + revoke.getCreditcode() + "'" + "," + "'" + revoke.getEnterprisename() + "'" + "," + "'"
            + revoke.getRepresentative() + "'" + "," +
            "'" + formatStr + "'" + "," + "'" + revoke.getRegisteredcapital() + "'" + "," + "'"
            + revoke.getOrganizationcode() + "'" + "," + "'" + revoke.getRegistrationnumber() + "'" + "," +
            "'" + revoke.getIdentificationnumber() + "'" + "," + "'" + revoke.getEnterprises() + "'" + "," + "'" +
            revoke.getAddress() + "'" + "," + "'" + revoke.getBusiness() + "'" + "," + "'" +
            revoke.getRegion() + "'" + "," + "'" + revoke.getRegistration() + "'" + "," + "'" + revoke.getIndustry() + "'" + "," + "'"
            + revoke.getType() + "'" + "," +
            "'" + pertime + "'" + "," + "'" + revoke.getDeptid() + "'" + "," + "'" + revoke.getPtype() + "'" + "," +
            "'" + revoke.getRepresentativecell() + "'" + "," + "'" + revoke.getContacts() + "'" + "," + "'" + revoke.getContactscell() + "'" + "," +
            "'" + revoke.getReason() + "'" + "," + "'" + revoke.getJurisdiction() + "'" +"," + "'" + revoke.getCardid() + "'"+ ")";
        FtpUtil.sqlFileUpload(s);
//        String formatStr = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(revoke.getEstablishtime());
//        String pertime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(revoke.getPermitime());
//        String s = "insert into sys_revoke(id,creditCode,enterpriseName,representative,establishTime," +
//            "registeredCapital,organizationCode,registrationNumber,identificationNumber,enterprises," +
//            "address,business,region,registration,industry,type,permitime,deptid,ptype,representativecell,contacts,contactscell,reason,jurisdiction,cardid)" +
//            "values(" + "'" + revoke.getId() + "'" + "," + "'" + revoke.getCreditcode() + "'" + "," + "'" + revoke.getEnterprisename() + "'" + "," + "'"
//            + revoke.getRepresentative() + "'" + "," +
//            "'" + formatStr + "'" + "," + "'" + revoke.getRegisteredcapital() + "'" + "," + "'"
//            + revoke.getOrganizationcode() + "'" + "," + "'" + revoke.getRegistrationnumber() + "'" + "," +
//            "'" + revoke.getIdentificationnumber() + "'" + "," + "'" + revoke.getEnterprises() + "'" + "," + "'" +
//            revoke.getAddress() + "'" + "," + "'" + revoke.getBusiness() + "'" + "," + "'" +
//            revoke.getRegion() + "'" + "," + "'" + revoke.getRegistration() + "'" + "," + "'" + revoke.getIndustry() + "'" + "," + "'"
//            + revoke.getType() + "'" + "," +
//            "'" + pertime + "'" + "," + "'" + revoke.getDeptid() + "'" + "," + "'" + revoke.getPtype() + "'" + "," +
//            "'" + revoke.getRepresentativecell() + "'" + "," + "'" + revoke.getContacts() + "'" + "," + "'" + revoke.getContactscell() + "'" + "," +
//            "'" + revoke.getReason() + "'" + "," + "'" + revoke.getJurisdiction() + "'" +"," + "'" + revoke.getCardid() + "'"+ ")";
//        FtpUtil.sqlFileUpload(s);
        return R.success("成功");
    }