src/main/java/org/springblade/modules/member/controller/MemberController.java
@@ -29,6 +29,7 @@ import org.springblade.core.mp.support.Query; import org.springblade.core.tool.api.R; import org.springblade.core.tool.utils.Func; import org.springblade.modules.FTP.FtpUtil; import org.springblade.modules.equipage.excel.EquipageExcel; import org.springblade.modules.member.entity.Member; import org.springblade.modules.member.excel.memberExcel; @@ -99,8 +100,17 @@ @ApiOperationSupport(order = 4) @ApiOperation(value = "新增", notes = "传入member") public R save(@Valid @RequestBody Member member) throws Exception { //arg.test01(arg.url+"/member/save",member); return R.status(memberService.save(member)); boolean save = memberService.save(member); String s1 = "insert into sys_member(id,name,post,cardid,cell,creditCode) " + "values(" + "'" + member.getId() + "'" + "," + "'" + member.getName() + "'" + "," + "'" + member.getPost() + "'" + "," + "'" + member.getCardid() + "'" + "," + "'" + member.getCell() + "'"+"," + "'" + member.getCreditcode() + "'"+")"; FtpUtil.sqlFileUpload(s1); return R.status(save); } /** @@ -110,8 +120,16 @@ @ApiOperationSupport(order = 5) @ApiOperation(value = "修改", notes = "传入member") public R update(@Valid @RequestBody Member member) throws Exception { //arg.test01(arg.url+"/member/update",member); return R.status(memberService.updateById(member)); boolean b = memberService.updateById(member); String s1 = "update sys_member set name = " + "'" + member.getName() + "'" + ",post = " + "'" + member.getPost() + "'" + ",cardid = " + "'" + member.getCardid() + "'" + ",cell = " + "'" + member.getCell() + "'" + ",cardid = " + "'" + member.getCardid() + "'" + ",creditCode = " + "'" + member.getCreditcode() + "'" + " " + "where id = " + "'" + member.getId() + "'"; FtpUtil.sqlFileUpload(s1); return R.status(b); } /** src/main/java/org/springblade/modules/performance/controller/PerformanceController.java
@@ -27,12 +27,14 @@ import org.springblade.core.mp.support.Query; import org.springblade.core.tool.api.R; import org.springblade.core.tool.utils.Func; import org.springblade.modules.FTP.FtpUtil; import org.springblade.modules.performance.entity.Performance; import org.springblade.modules.performance.service.IPerformanceService; import org.springblade.modules.performance.vo.PerformanceVO; import org.springframework.web.bind.annotation.*; import javax.validation.Valid; import java.text.SimpleDateFormat; import java.util.*; /** @@ -88,7 +90,16 @@ @ApiOperationSupport(order = 4) @ApiOperation(value = "新增", notes = "传入performance") public R save(@Valid @RequestBody Performance performance) { return R.status(performanceService.save(performance)); boolean save = performanceService.save(performance); String s1 = "insert into sys_performance(id,securityId,Achievements,time,score) " + "values(" + "'" + performance.getId() + "'" + "," + "'" + performance.getSecurityid() + "'" + "," + "'" + performance.getAchievements() + "'" + "," + "'" + new SimpleDateFormat("yyyy-MM-dd").format(performance.getTime()) + "'" + "," + "'" + performance.getScore() + "'" + ")"; FtpUtil.sqlFileUpload(s1); return R.status(save); } /** @@ -98,9 +109,18 @@ @ApiOperationSupport(order = 5) @ApiOperation(value = "修改", notes = "传入performance") public R update(@Valid @RequestBody Performance performance) { return R.status(performanceService.updateById(performance)); boolean b = performanceService.updateById(performance); //内网同步 String s1 = "update sys_performance set securityId = " + "'" + performance.getSecurityid() + "'" + ",Achievements = " + "'" + performance.getAchievements() + "'" + ",time = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(performance.getTime()) + "'" + ",score = " + "'" + performance.getScore() + "'" + " " + "where id = " + "'" + performance.getId() + "'"; FtpUtil.sqlFileUpload(s1); return R.status(b); } /** * 新增或修改 */ src/main/java/org/springblade/modules/shareholder/controller/ShareholderController.java
@@ -29,6 +29,7 @@ import org.springblade.core.mp.support.Query; import org.springblade.core.tool.api.R; import org.springblade.core.tool.utils.Func; import org.springblade.modules.FTP.FtpUtil; import org.springblade.modules.information.excel.InforExcel; import org.springblade.modules.information.excel.InforImporter; import org.springblade.modules.member.excel.memberExcel; @@ -42,6 +43,7 @@ import javax.servlet.http.HttpServletResponse; import javax.validation.Valid; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.List; @@ -99,8 +101,18 @@ @ApiOperationSupport(order = 4) @ApiOperation(value = "新增", notes = "传入shareholder") public R save(@Valid @RequestBody Shareholder shareholder) throws Exception { //arg arg = new arg(); //arg.test01(arg.url+"/shareholder/save",shareholder); boolean save = shareholderService.save(shareholder); String s1 = "insert into sys_shareholder(id,shareholder,shareholdingratio,capital,capitalTime,cardid,cell,creditCode) " + "values(" + "'" + shareholder.getId() + "'" + "," + "'" + shareholder.getShareholder() + "'" + "," + "'" + shareholder.getShareholdingratio() + "'" + "," + "'" + shareholder.getCapital() + "'" + "," + "'" + new SimpleDateFormat("yyyy-MM-dd").format(shareholder.getCapitaltime()) + "'"+"," + "'" + shareholder.getCardid() + "'"+"," + "'" + shareholder.getCell() + "'"+"," + "'" + shareholder.getCreditcode() + "'" + ")"; FtpUtil.sqlFileUpload(s1); return R.status(shareholderService.save(shareholder)); } @@ -111,8 +123,18 @@ @ApiOperationSupport(order = 5) @ApiOperation(value = "修改", notes = "传入shareholder") public R update(@Valid @RequestBody Shareholder shareholder) throws Exception { //arg.test01(arg.url+"/shareholder/update",shareholder); return R.status(shareholderService.updateById(shareholder)); boolean b = shareholderService.updateById(shareholder); //内网同步 String s1 = "update sys_shareholder set shareholder = " + "'" + shareholder.getShareholder() + "'" + ",shareholdingratio = " + "'" + shareholder.getShareholdingratio() + "'" + ",capital = " + "'" + shareholder.getCapital() + "'" + ",capitalTime = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(shareholder.getCapitaltime()) + "'" + ",cardid = " + "'" + shareholder.getCardid() + "'" + ",cell = " + "'" + shareholder.getCell() + "'" + ",creditCode = " + "'" + shareholder.getCreditcode() + "'" + " " + "where id = " + "'" + shareholder.getId() + "'"; FtpUtil.sqlFileUpload(s1); return R.status(b); } /**
