Exemple #1
0
        /// <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));
        }