mp 1.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. ### AccountService
  2. /**
  3. * 带分页查询帐号信息
  4. * @param map
  5. * @return
  6. */
  7. PageBean<Account> queryAccountByPage(Map<String, Object> map);
  8. ### AccountServiceImpl
  9. /**
  10. * QueryAccountByPage
  11. * 实现按页查询的功能
  12. */
  13. @Override
  14. public PageBean<Account> queryAccountByPage(Map<String, Object> map) {
  15. int page = (Integer) map.get("page");
  16. int limit = (Integer) map.get("limit");
  17. Page<Account> p = new Page<>(page, limit);
  18. p.setRecords(accountMapper.queryAccountByPage(p, map));
  19. return p;
  20. }
  21. ###AccountMapper
  22. List<Account> queryAccountByPage(Page<Account> page, Map<String, Object> map);
  23. ###action
  24. /**
  25. * 分页查询
  26. * @return
  27. */
  28. @RequestMapping(value = "/query", method = RequestMethod.GET)
  29. @ResponseBody
  30. public LayPageResult querySysArea(@RequestParam Map<String,Object> map) {
  31. PageBean<SysArea> pageInfo = sysAreaService.queryAreaByPage(map);
  32. return layPageResult(pageInfo);
  33. }
  34. #### 表名变更
  35. sys_risk => ent_risk
  36. ent_risk_record
  37. s_position 管控岗位
  38. ent_risk_ctrl_level 管控层级
  39. ### 删除redis 缓存
  40. SELECT GROUP_CONCAT(s_group_id,"_curGroup" SEPARATOR ' ') from s_group WHERE company_id='f031d15e-4b50-4e60-a287-a9742837411c';