/// <summary>
/// 返回所有的数据库列表
/// </summary>
/// <returns></returns>
public static List <string> AllDatabaseNames()
{
List <string> result = new List <string>();
DataTable tables = UtilMysql.SqlExecute(Sql_Databases);
string database_name;
foreach (DataRow item in tables.Rows)
{
database_name = (string)item.ItemArray[0];
result.Add(database_name);
}
return(result);
}
/// <summary>
/// 查询所有表名
/// </summary>
/// <returns></returns>
public static Dictionary <string, string> TableList()
{
Dictionary <string, string> result = new Dictionary <string, string>();
DataTable tables = UtilMysql.SqlExecute(Sql_Tables);
string tablename, key;
foreach (DataRow item in tables.Rows)
{
tablename = (string)item.ItemArray[0];
key = tablename.ToLower();
result[key] = tablename;
}
return(result);
}
/// <summary>
/// 获取所有的表信息包括表注释信息
/// </summary>
/// <returns></returns>
public static Dictionary <string, Dictionary <string, string> > TableinfoList()
{
Dictionary <string, Dictionary <string, string> > result = new Dictionary <string, Dictionary <string, string> >();
DataTable tables = UtilMysql.SqlExecute(Sql_Tables_Info);
string tablename, key;
foreach (DataRow item in tables.Rows)
{
tablename = (string)item.ItemArray[0];
Dictionary <string, string> tableInfo = new Dictionary <string, string>();
tableInfo["Name"] = tablename;
tableInfo["Comment"] = (string)item.ItemArray[item.ItemArray.Count() - 1];
key = tablename.ToLower();
result[key] = tableInfo;
}
return(result);
}
/// <summary>
/// 获取指定表所有的列信息
/// </summary>
/// <param name="table_name"></param>
/// <returns></returns>
public static Dictionary <string, Dictionary <string, string> > FieldInfoList(string table_name)
{
Dictionary <string, Dictionary <string, string> > result = new Dictionary <string, Dictionary <string, string> >();
string sql = string.Format(Sql_Table_Columns, table_name);
DataTable columns = UtilMysql.SqlExecute(sql);
string column_name, column_type_length;
foreach (DataRow item in columns.Rows)
{
Dictionary <string, string> columnInfo = new Dictionary <string, string>();
column_name = (string)item.ItemArray[0];
columnInfo["Field"] = column_name;
column_type_length = (string)item.ItemArray[1];
columnInfo["Type"] = column_type_length;
columnInfo["Type_Only"] = Column_Type_Only(column_type_length);
columnInfo["Length"] = Column_Length(column_type_length);
columnInfo["Null"] = (string)item.ItemArray[3];
string fkPk = "";
string[] tbl = table_name.Split('_');
if (column_name.ToUpper().Contains("_ID") && (column_name.ToUpper().Contains(tbl[tbl.Length - 1].ToUpper())))
{
fkPk = "PK";
}
if (column_name.ToUpper().Contains("_ID") && (!column_name.ToUpper().Contains(tbl[tbl.Length - 1].ToUpper())))
{
fkPk = "FK";
}
columnInfo["Fkpk"] = fkPk;
columnInfo["Default"] = (string.IsNullOrEmpty(item.ItemArray[5].ToString())) ? null : (string)item.ItemArray[5];
columnInfo["Comment"] = (string)item.ItemArray[item.ItemArray.Count() - 1];
result[column_name] = columnInfo;
}
return(result);
}
