/// <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));
}
