/// <summary> /// 获取数据库中的所有表和字段 /// </summary> /// <returns></returns> public List <Dictionary <string, object> > GetDatabaseAllTable() { string sql = @"select TABLE_NAME+' [表]' name,TABLE_NAME id,null pId from INFORMATION_SCHEMA.TABLES union all select case when CHARACTER_MAXIMUM_LENGTH is null then COLUMN_NAME+' [字段类型:'+DATA_TYPE+']' when CHARACTER_MAXIMUM_LENGTH is not null then COLUMN_NAME+' [字段类型:'+DATA_TYPE+'('+CONVERT(varchar(10),CHARACTER_MAXIMUM_LENGTH)+')]' end name,TABLE_NAME+'$~'+COLUMN_NAME id,TABLE_NAME from INFORMATION_SCHEMA.COLUMNS"; return(db.FindToList(sql)); }
/// <summary> /// 获取菜单和功能树 /// </summary> /// <returns></returns> public List <Dictionary <string, object> > GetMenuAndFunctionTree(string RoleID = "") { //菜单功能查询 string sql = @"SELECT (cMenu_Name+'('+cMenu_Number+')') name,uMenu_ID id,uMenu_ParentID pId,cMenu_Number num,cMenu_Url ur,'false' checked,null tag FROM T_Menu ORDER BY cMenu_Number" ; if (!Tools.getGuid(RoleID).Equals(Guid.Empty)) { //角色功能查询 sql = @"SELECT (cMenu_Name+'('+cMenu_Number+')') name,uMenu_ID id,uMenu_ParentID pId,cMenu_Number num,cMenu_Url ur,'false' checked,null tag FROM T_Menu LEFT JOIN T_RoleMenuFunction A ON tab.uMenu_ID=A.uRoleMenuFunction_MenuID WHERE 1=1 AND uRoleMenuFunction_RoleID='" + Tools.getGuid(RoleID) + @"' ORDER BY cMenu_Number" ; } return(db.FindToList(sql)); }