| | |
| | | record.setType("2"); |
| | | record.setPermitime(new Date()); |
| | | recordService.save(record); |
| | | String formatStr = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(record.getEstablishtime()); |
| | | 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,creditCode,enterpriseName,representative,establishtime," + |
| | | "registeredCapital,organizationCode,registrationNumber,identificationNumber,enterprises," + |
| | | "address,business,region,registration,industry,type,permitime,deptid,ptype,representativecell,contacts,contactscell,perid,offices,officetime,jurisdiction,cardid)" + |
| | | "values(" + "'" + record.getId() + "'" + "," + "'" + record.getCreditcode() + "'" + "," + "'" + record.getEnterprisename() + "'" + "," + "'"+ record.getRepresentative() + "'" + "," + |
| | | "'" + formatStr + "'" + "," + "'" + record.getRegisteredcapital() + "'" + "," + "'" |
| | | "values(" + "'" + record.getId() + "'" + "," + "'" + record.getCreditcode() + "'" + "," + "'" + record.getEnterprisename() + "'" + "," + "'"+ record.getRepresentative() + "'" + "," + "'" + record.getRegisteredcapital() + "'" + "," + "'" |
| | | + record.getOrganizationcode() + "'" + "," + "'" + record.getRegistrationnumber() + "'" + "," + |
| | | "'" + record.getIdentificationnumber() + "'" + "," + "'" + record.getEnterprises() + "'" + "," + "'" + |
| | | record.getAddress() + "'" + "," + "'" + record.getBusiness() + "'" + "," + "'" + |