/// <summary> /// 查询菜单树 /// </summary> /// <param name="RoleId"></param> /// <returns></returns> public static DataSet GetMenu(long RoleId) { string sql = "SELECT a.ROLE_ID,a.Description, c.* FROM role a ,ROLE_MENU b,menu c WHERE a.ROLE_ID = " + RoleId + "and a.ROLE_ID = b.ROLE_ID and b.NODEID = c.NODEID Order By PARENTID,c.ORDERID"; DataService.DataService dService = new Jin.DataService.DataService(); return(dService.GetOleDataset(sql)); }