" order by m.sort", new Parameter(Menu.DEL_FLAG_NORMAL, userId));
}
public List<Menu> findAllActivitiList(String userId) {
return find("select distinct m from Menu m, Role r, User u where m in elements (r.menuList) and r in elements (u.roleList)" +
" and m.delFlag=:p1 and r.delFlag=:p1 and u.delFlag=:p1 and m.isActiviti=:p2 and u.id=:p3 order by m.sort",
new Parameter(Menu.DEL_FLAG_NORMAL, Menu.YES,userId));
}