1
 @Override
2
    public ApiResult menuUpOrDown(Long menuId, Integer direct) {
3
        if (direct == NumberConstants.ONE){
4
            return moveUp(menuId);
5
        }else {
6
            return moveDown(menuId);
7
        }
8
    }
9

10
    //菜单上移
11
    private ApiResult moveUp(Long menuId) {
12
        //获取上移的那条数据的信息
13
        SysMenu upSysMenu = sysMenuMapper.selectById(menuId);
14
        Integer temp = upSysMenu.getOrderNum();
15
        //查询上一条记录
16
        SysMenu downSysMenu = sysMenuMapper.moveUp(temp,upSysMenu.getMenuId());
17
        //SysMenu ltMenu = sysMenuMapper.selectOne(Wrappers.lambdaQuery(SysMenu.class)
18
                //.lt(SysMenu::getOrderNum, orderNum)
19
                //.eq(SysMenu::getParentId, upSysMenu.getParentId()).orderByDesc(SysMenu::getOrderNum).last("limit 1"));
20
        //如果上面已经没有记录了,返回
21
        if (downSysMenu == null) {
22
            return ApiResult.fail("已经平移至最上方,无法移动!");
23
        }
24
        upSysMenu.setOrderNum(downSysMenu.getOrderNum());
25
        downSysMenu.setOrderNum(temp);
26
        sysMenuMapper.updateById(upSysMenu);
27
        sysMenuMapper.updateById(downSysMenu);
28
        return ApiResult.success();
29
    }
30

31
    //菜单下移
32
    private ApiResult moveDown(Long menuId) {
33
        SysMenu downSysMenu = sysMenuMapper.selectById(menuId);
34
        Integer temp = downSysMenu.getOrderNum();
35
        //查询下一条记录
36
        SysMenu upSysMenu = sysMenuMapper.moveDown(temp,downSysMenu.getMenuId());
37
        //SysMenu gtMenu = sysMenuMapper.selectOne(Wrappers.lambdaQuery(SysMenu.class)
38
                //.gt(SysMenu::getOrderNum, orderNum)
39
                //.eq(SysMenu::getParentId, downSysMenu.getParentId()).orderByAsc(SysMenu::getOrderNum).last("limit 1"));
40
        if (upSysMenu == null) {
41
            return ApiResult.fail("已经平移至最下方,无法移动!");
42
        }
43
        downSysMenu.setOrderNum(upSysMenu.getOrderNum());
44
        upSysMenu.setOrderNum(temp);
45
        sysMenuMapper.updateById(upSysMenu);
46
        sysMenuMapper.updateById(downSysMenu);
47
        return ApiResult.success();
48
    }

1
 /**
2
     * 查询上一条记录
3
     * @param orderNum 排序字段
4
     * @param menuId 菜单id
5
     * @return 菜单对象
6
     */
7
    SysMenu moveUp(@Param("orderNum") Integer orderNum, @Param("menuId") Long menuId);
8

9
    /**
10
     * 查询下一条记录
11
     * @param orderNum 排序字段
12
     * @param menuId 菜单id
13
     * @return 菜单对象
14
     */
15
    SysMenu moveDown(@Param("orderNum") Integer orderNum, @Param("menuId") Long menuId);