| | |
|---|
| | | 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,creditCode,enterpriseName,representative," + |
|---|
| | | "registeredCapital,organizationCode,registrationNumber,identificationNumber,enterprises," + |
|---|
| | | "address,business,region,registration,industry,type,permitime,deptid,ptype,representativecell,contacts,contactscell,jurisdiction,cardid)" + |
|---|
| | | "address,business,region,registration,industry,type,permitime,deptid,ptype,representativecell,contacts,contactscell,jurisdiction,cardid,overtime)" + |
|---|
| | | "values(" + "'" + permit.getId() + "'" + "," + "'" + permit.getCreditcode() + "'" + "," + "'" + permit.getEnterprisename() + "'" + "," + "'" |
|---|
| | | + permit.getRepresentative() + "'" + "," + "'" + permit.getRegisteredcapital() + "'" + "," + "'" |
|---|
| | | + permit.getOrganizationcode() + "'" + "," + "'" + permit.getRegistrationnumber() + "'" + "," + |
|---|
| | |
|---|
| | | "'" + pertime + "'" + "," + "'" + permit.getDeptid() + "'" + "," + "'" + permit.getPtype() + "'" + "," + |
|---|
| | | "'" + permit.getRepresentativecell() + "'" + "," + "'" + permit.getContacts() + "'" + "," + "'" |
|---|
| | | + permit.getContactscell() + "'" + "," + "'" + permit.getJurisdiction() + "'" + |
|---|
| | | "," + "'" + permit.getCardid() + "'" + ")"; |
|---|
| | | "," + "'" + permit.getCardid() + "'"+ "," + "'" + overtime+ "'" + ")"; |
|---|
| | | FtpUtil.sqlFileUpload(s); |
|---|
| | | return R.success("许可提交成功"); |
|---|
| | | } |
|---|
