| | |
| | | |
| | | private final IRecordkService recordkService; |
| | | private final IInformationService informationService; |
| | | |
| | | /** |
| | | * 详情 |
| | | */ |
| | |
| | | //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," + |
| | | "address,business,region,registration,industry,type,deptid,ptype,representativecell,contacts,contactscell,cardid,overtime,jurisdiction)" + |
| | | "values(" + "'" + recordk.getId() + "'" + "," + "'" + recordk.getCreditcode() + "'" + "," + "'" + recordk.getEnterprisename() + "'" + "," + "'" |
| | | "address,business,region,registration,industry,type,deptid,ptype,representativecell,contacts,contactscell,cardid,overtime," + |
| | | "jurisdiction," + |
| | | "ksecuritys," + |
| | | "kproject," + |
| | | "kzipcode," + |
| | | "kservicetime," + |
| | | "kaddress" + |
| | | ")" + |
| | | "values(" + "'" + recordk.getId() + "'" + "," + "'" + |
| | | recordk.getCreditcode() + "'" + "," + "'" + recordk.getEnterprisename() + "'" + "," + "'" |
| | | + recordk.getRepresentative() + "'" +"," + "'" + |
| | | recordk.getAddress() + "'" + "," + "'" + recordk.getBusiness() + "'" + "," + "'" + |
| | | recordk.getRegion() + "'" + "," + "'" + recordk.getRegistration() + "'" + "," + "'" + recordk.getIndustry() + "'" + "," + "'" + recordk.getType() + "'" +"," + "'" + recordk.getDeptid() + "'" + "," + "'" + recordk.getPtype() + "'" + "," + |
| | | "'" + recordk.getRepresentativecell() + "'" + "," + "'" + recordk.getContacts() + "'" + "," + "'" + recordk.getContactscell() + "'" +"," + "'" + recordk.getCardid() + "'"+"," + "'" + new SimpleDateFormat("yyyy-MM-dd").format(recordk.getOvertime())+ "'" +"," + "'" + recordk.getJurisdiction()+"'"+")"; |
| | | FtpUtil.sqlFileUpload(s); |
| | | recordk.getRegion() + "'" + "," + "'" + recordk.getRegistration() + "'" + "," + "'" + |
| | | recordk.getIndustry() + "'" + "," + "'" + recordk.getType() + "'" + "," + "'" + |
| | | recordk.getDeptid() + "'" + "," + "'" + recordk.getPtype() + "'" + "," + |
| | | "'" + recordk.getRepresentativecell() + "'" + "," + "'" + recordk.getContacts() + "'" + "," + "'" + |
| | | recordk.getContactscell() + "'" + "," + |
| | | "'" + recordk.getCardid() + "'" + "," + |
| | | "'" + new SimpleDateFormat("yyyy-MM-dd").format(recordk.getOvertime()) + "'" + "," + |
| | | "'" + recordk.getJurisdiction() + "'" + "," + |
| | | "'" + recordk.getKsecuritys() + "'" + "," + |
| | | "'" + recordk.getKproject() + "'" + "," + |
| | | "'" + recordk.getKzipcode() + "'" + "," + |
| | | "'" + recordk.getKservicetime() + "'" + "," + |
| | | "'" + recordk.getKaddress() + "'" + |
| | | ")"; |
| | | // System.out.println(s); |
| | | // System.out.println(recordk.getKsecuritys()); |
| | | // System.out.println(recordk.getKproject()); |
| | | // System.out.println(recordk.getKzipcode()); |
| | | // System.out.println(recordk.getKservicetime()); |
| | | // System.out.println(recordk.getKaddress()); |
| | | // System.out.println(recordk); |
| | | // FtpUtil.sqlFileUpload(s); |
| | | return R.success("成功"); |
| | | } |
| | | |
| | |
| | | if (map!=null){ |
| | | recordk.setStorage("0"); |
| | | recordkService.updateById(recordk); |
| | | } |
| | | else { |
| | | } else { |
| | | recordk.setStorage("0"); |
| | | recordk.setPermitime(new Date()); |
| | | recordkService.save(recordk); |