| | |
| | | import org.springblade.modules.equipage.excel.GunImporter; |
| | | import org.springblade.modules.equipage.service.GunService; |
| | | import org.springblade.modules.equipage.vo.GunVo; |
| | | import org.springblade.modules.system.service.MyAsyncService; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import org.springframework.web.multipart.MultipartFile; |
| | | |
| | |
| | | public class GunController { |
| | | |
| | | private final GunService gunService; |
| | | private final MyAsyncService myAsyncService; |
| | | |
| | | /** |
| | | * 自定义分页 |
| | | * |
| | | * @param query page,size |
| | | * @param gun 枪支信息对象 |
| | | */ |
| | |
| | | |
| | | /** |
| | | * 新增 |
| | | * |
| | | * @param gun 枪支信息对象 |
| | | */ |
| | | @PostMapping("/save") |
| | |
| | | |
| | | /** |
| | | * 修改 |
| | | * |
| | | * @param gun 枪支信息对象 |
| | | */ |
| | | @PostMapping("/update") |
| | |
| | | |
| | | /** |
| | | * 新增或修改 |
| | | * |
| | | * @param gun 枪支信息对象 |
| | | */ |
| | | @PostMapping("/submit") |
| | |
| | | if (null==gun.getId()) { |
| | | //新增 |
| | | status = gunService.save(gun); |
| | | |
| | | if (status) { |
| | | //数据同步 |
| | | String s1 = |
| | | "insert into sys_gun(id,issue_unit,card_number,gun_mode," + |
| | |
| | | "'" + new SimpleDateFormat("yyyy-MM-dd").format(gun.getValidTime()) + "'" + "," + |
| | | "'" +gun.getCardNo() + "'" + "," + |
| | | "'" +gun.getJurisdiction() + "'" + ")"; |
| | | FtpUtil.sqlFileUpload(s1); |
| | | //FtpUtil.sqlFileUpload(s1); |
| | | myAsyncService.FTP(s1); |
| | | } |
| | | }else { |
| | | //修改 |
| | | status = gunService.updateById(gun); |
| | | if (status) { |
| | | //内网同步 |
| | | String s1 = |
| | | "update sys_gun set issue_unit = " + "'" + gun.getIssueUnit() + "'" + |
| | |
| | | ",jurisdiction = " + "'" + gun.getJurisdiction() + "'" + |
| | | ",card_no = " + "'" + gun.getCardNo() + "'" + |
| | | " " +"where id = " + "'" + gun.getId() + "'"; |
| | | FtpUtil.sqlFileUpload(s1); |
| | | //FtpUtil.sqlFileUpload(s1); |
| | | myAsyncService.FTP(s1); |
| | | } |
| | | } |
| | | return R.status(status); |
| | | } |
| | | |
| | | /** |
| | | * 删除 |
| | | * |
| | | * @param ids 枪支信息ids 数组 |
| | | */ |
| | | @PostMapping("/remove") |
| | |
| | | list.forEach(id ->{ |
| | | //内网同步 |
| | | String s1 = "delete from sys_gun where id = " + "'" + id + "'"; |
| | | FtpUtil.sqlFileUpload(s1); |
| | | //FtpUtil.sqlFileUpload(s1); |
| | | myAsyncService.FTP(s1); |
| | | }); |
| | | return R.status(gunService.removeByIds(Func.toLongList(ids))); |
| | | } |
| | | |
| | | /** |
| | | * 详情 |
| | | * |
| | | * @param gun 枪支信息对象 |
| | | */ |
| | | @GetMapping("/detail") |