字段
int sotrnum:要更改到的位置
int id:要更改数据的ID
小转大
判断是否为当前Id,是的话直接变排序字段的值,其他中间字段-1
//小转大
wrapper.setSql("sotrnum=(case when id="+id+" then "+sotrnum+" else sotrnum-1 end)")
.eq(Department::getPid, department.getPid())
.between(Department::getSotrnum, department.getSotrnum(), sotrnum);
大转小
判断是否为当前Id,是的话直接变排序字段的值,其他中间字段+1
//大转小
wrapper.setSql("sotrnum=(case when id="+id+" then "+sotrnum+" else sotrnum+1 end)")
.eq(Department::getPid, department.getPid())
.between(Department::getSotrnum, sotrnum, department.getSotrnum());