| | |
|---|
| | | recordk.setType("2"); |
|---|
| | | recordk.setPermitime(new Date()); |
|---|
| | | recordkService.save(recordk); |
|---|
| | | String formatStr = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(recordk.getEstablishtime()); |
|---|
| | | 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_record(id,creditCode,enterpriseName,representative,establishtime," + |
|---|
| | | 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)" + |
|---|
| | | "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() + "'" + "," + |
|---|
| | | "'" + formatStr + "'" + "," + "'" + recordk.getRegisteredcapital() + "'" + "," + "'" |
|---|
| | | + 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() + "'"+")"; |
|---|
| | | "'" + recordk.getPerid() + "'" + "," + "'" + recordk.getOffices() + "'" + "," + "'" + offtime + "'"+ "," + "'" + recordk.getCardid() + "'"+"," + "'" + new SimpleDateFormat("yyyy-MM-dd").format(recordk.getOvertime()) + "'"+")"; |
|---|
| | | FtpUtil.sqlFileUpload(s); |
|---|
| | | return R.success("成功"); |
|---|
| | | } |
|---|
