| | |
|---|
| | | @RequestMapping("/permit") |
|---|
| | | @Api(value = "", tags = "接口") |
|---|
| | | public class PermitController extends BladeController { |
|---|
| | | //ftp服务器IP地址 |
|---|
| | | private static String ftpHost = "192.168.0.105"; |
|---|
| | | //ftp服务器端口 |
|---|
| | | private static int ftpPort = 21; |
|---|
| | | //ftp服务器用户名 |
|---|
| | | private static String ftpUserName = "yly"; |
|---|
| | | //ftp服务器密码 |
|---|
| | | private static String ftpPassword = "Yly@123"; |
|---|
| | | //ftp服务器路径 |
|---|
| | | private static String ftpPath = ""; |
|---|
| | | //本地路径 |
|---|
| | | private static String localPath = "D:\\anbao"; |
|---|
| | | //文件名 |
|---|
| | | private static String fileName = "sql.json"; |
|---|
| | | |
|---|
| | | private final IPermitService permitService; |
|---|
| | | private final IDeptService iDeptService; |
|---|
| | | private final IInformationService informationService; |
|---|
| | |
|---|
| | | permit.setStorage("1"); |
|---|
| | | permit.setPermitime(new Date()); |
|---|
| | | permitService.save(permit); |
|---|
| | | String formatStr = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(permit.getEstablishtime()); |
|---|
| | | String pertime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(permit.getPermitime()); |
|---|
| | | String s = "insert into sys_permit(id,creditCode,enterpriseName,representative,establishTime," + |
|---|
| | | 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)" + |
|---|
| | | "values(" + "'" + permit.getId() + "'" + "," + "'" + permit.getCreditcode() + "'" + "," + "'" + permit.getEnterprisename() + "'" + "," + "'" |
|---|
| | | + permit.getRepresentative() + "'" + "," + |
|---|
| | | "'" + formatStr + "'" + "," + "'" + permit.getRegisteredcapital() + "'" + "," + "'" |
|---|
| | | + permit.getRepresentative() + "'" + "," +"'" + permit.getRegisteredcapital() + "'" + "," + "'" |
|---|
| | | + permit.getOrganizationcode() + "'" + "," + "'" + permit.getRegistrationnumber() + "'" + "," + |
|---|
| | | "'" + permit.getIdentificationnumber() + "'" + "," + "'" + permit.getEnterprises() + "'" + "," + "'" + |
|---|
| | | permit.getAddress() + "'" + "," + "'" + permit.getBusiness() + "'" + "," + "'" + |
|---|
