| | |
| | | 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; |
| | |
| | | |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import javax.validation.Valid; |
| | | import java.text.SimpleDateFormat; |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | |
| | |
| | | @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); |
| | | return R.status(shareholderService.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(save); |
| | | } |
| | | |
| | | /** |
| | |
| | | @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); |
| | | } |
| | | |
| | | /** |