From d8626e7445a7a9d9cf08aa51a5dc864b8482721e Mon Sep 17 00:00:00 2001
From: tangzy <tangzy123456>
Date: Thu, 02 Dec 2021 16:41:16 +0800
Subject: [PATCH] 1.附件
---
src/main/java/org/springblade/modules/record/controller/RecordController.java | 37 +++++++++++++++++++++++++------------
1 files changed, 25 insertions(+), 12 deletions(-)
diff --git a/src/main/java/org/springblade/modules/record/controller/RecordController.java b/src/main/java/org/springblade/modules/record/controller/RecordController.java
index 85ab88b..39eb4ef 100644
--- a/src/main/java/org/springblade/modules/record/controller/RecordController.java
+++ b/src/main/java/org/springblade/modules/record/controller/RecordController.java
@@ -125,16 +125,17 @@
recordService.save(record);
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() + "'" + "," + "'" + record.getRegisteredcapital() + "'" + "," + "'"
- + record.getOrganizationcode() + "'" + "," + "'" + record.getRegistrationnumber() + "'" + "," +
- "'" + record.getIdentificationnumber() + "'" + "," + "'" + record.getEnterprises() + "'" + "," + "'" +
- record.getAddress() + "'" + "," + "'" + record.getBusiness() + "'" + "," + "'" +
- record.getRegion() + "'" + "," + "'" + record.getRegistration() + "'" + "," + "'" + record.getIndustry() + "'" + "," + "'" + record.getType() + "'" + "," + "'" + pertime + "'" + "," + "'" + record.getDeptid() + "'" + "," + "'" + record.getPtype() + "'" + "," +
+ String s = "insert into sys_record(id,enterpriseName,representative," +
+ "address,business,registration,industry,type,permitime,ptype,representativecell,contacts,contactscell,perid,offices,officetime,jurisdiction,cardid,storage,overtime)" +
+ "values(" + "'" + record.getId() + "'"+ "," + "'" + record.getEnterprisename() + "'" + "," +
+ "'" + record.getRepresentative() + "'"+ "," + "'" +
+ record.getAddress() + "'" + "," + "'" + record.getBusiness() + "'" + "," + "'" + record.getRegistration() + "'" + "," + "'" + record.getIndustry() + "'" + "," + "'" + record.getType() + "'" + "," + "'" + pertime + "'" + "," + "'" + record.getPtype() + "'" + "," +
"'" + record.getRepresentativecell() + "'" + "," + "'" + record.getContacts() + "'" + "," + "'" + record.getContactscell() + "'" + "," +"'" + record.getPerid() + "'" + "," + "'" + record.getOffices() + "'" + "," +
- "'" + offtime + "'" + "," + "'" + record.getJurisdiction() + "'" + "," + "'" + record.getCardid() + "'"+ ")";
+ "'" + offtime + "'" + "," + "'" + record.getJurisdiction() + "'" +
+ "," + "'" + record.getCardid() + "'"+
+ "," + "'" + record.getStorage() + "'"+
+ "," + "'" + new SimpleDateFormat("yyyy-MM-dd").format(record.getOvertime()) + "'"
+ + ")";
FtpUtil.sqlFileUpload(s);
return R.success("成功");
}
@@ -222,16 +223,28 @@
userService.saveOrUpdate(user);
//把附件添加单位id
attachService.updat(information.getDepartmentid(),record.getCardid());
- String s1 = "update sys_permit set type = " + "'" + 0 + "'" +",approve = " + "'" + record.getApprove() + "'"+
+ String s1 = "update sys_record set type = " + "'" + record.getType() + "'" +
+ ",papprove = " + "'" + record.getPapprove() + "'"+
+ ",xapprove = " + "'" + record.getXapprove() + "'"+
+ ",sapprove = " + "'" + record.getSapprove() + "'"+
+ ",popinion = " + "'" + record.getPopinion() + "'"+
+ ",sopinion = " + "'" + record.getSopinion() + "'"+
+ ",xopinion = " + "'" + record.getXopinion() + "'"+
" " +"where id = " + "'" + record.getId() + "'";
FtpUtil.sqlFileUpload(s1);
}
else {
- String s1 = "update sys_permit set type = " + "'" + 1 + "'" +",approve = " + "'" + record.getApprove() + "'"+
+ String s1 = "update sys_record set type = " + "'" + record.getType() + "'" +
+ ",papprove = " + "'" + record.getPapprove() + "'"+
+ ",xapprove = " + "'" + record.getXapprove() + "'"+
+ ",sapprove = " + "'" + record.getSapprove() + "'"+
+ ",popinion = " + "'" + record.getPopinion() + "'"+
+ ",sopinion = " + "'" + record.getSopinion() + "'"+
+ ",xopinion = " + "'" + record.getXopinion() + "'"+
" " +"where id = " + "'" + record.getId() + "'";
FtpUtil.sqlFileUpload(s1);
}
- return R.status(recordService.updateById(record));
+ return R.status(recordService.saveOrUpdate(record));
}
/**
--
Gitblit v1.9.3