/**
* 查询后台需要属性展示的菜单表数据 注意:该数据转换成json对象, 是不符合easyUI的tree主键展现的json格式
*
* @param map
* @param pageBean
* @return
* @throws Exception
*/
public List<Map<String, Object>> menuList(Map<String, String[]> map, PageBean bean) throws Exception {
String sql = "select * from t_easyui_menu where true";
String menuid = JsonUtils.getParmeterVal(map, "Menuid");
if (menuid != null && menuid != "") {
sql += " and parentid=" + menuid;
} else {
sql += " and parentid=-1";
}
return super.executeQuery(sql, bean);
}

/**
* 查出来的数据不能战术,转换为可展示的数据
*
* @param map
* @param treeNode
* @throws Exception
*/
private void mapToTreeNode(Map<String, Object> map, TreeNode treeNode) throws Exception {
treeNode.setId(map.get("Menuid").toString());
treeNode.setText(map.get("Menuname").toString());
treeNode.setAttributes(map);
Map<String, String[]> paramMap = new HashMap<>();
// 把当前节点id当作父id,查出所有的子节点
paramMap.put("Menuid", new String[] { treeNode.getId() });
List<Map<String, Object>> menuList = this.menuList(paramMap, null);
List<TreeNode> TreeNodelist = new ArrayList<>();
//再次遍历
mapListToTreeNodeList(menuList, TreeNodelist);
treeNode.setChildren(TreeNodelist);
}

/**
*
* @Title: mapListToTreeNodeList
* @Description:遍历数据库中查询的数据
* @param list
* @param treeNodeslist
* @throws Exception
* @return void
*/
private void mapListToTreeNodeList(List<Map<String, Object>> list, List<TreeNode> treeNodeslist) throws Exception {
TreeNode treeNode = null;
for (Map<String, Object> map : list) {
treeNode = new TreeNode();
mapToTreeNode(map, treeNode);
treeNodeslist.add(treeNode);
}
}

/**
* 这个方法的返回值,才是符合easyui的tree组件需要的
*
* @param map
* @param pageBean
* @return
* @throws Exception
*/
public List<TreeNode> menuTreeList(Map<String, String[]> map, PageBean pageBean) throws Exception {
List<Map<String, Object>> menuList = this.menuList(map, pageBean);
List<TreeNode> TreeNodelist = new ArrayList<>();
mapListToTreeNodeList(menuList, TreeNodelist);
return TreeNodelist;
}