public List <DbTableInfo> GetTablesWithPage(string tablename, string fieldNameToSort, bool isDescending, PagerInfo info) { List <DbTableInfo> list = new List <DbTableInfo>(); if (dbType == DatabaseType.SqlServer) { MssqlExtractor mssqlExtractor = new MssqlExtractor(); list = mssqlExtractor.GetAllTables(tablename, fieldNameToSort, isDescending, info); } else if (dbType == DatabaseType.MySql) { MySqlExtractor mysqlExtractor = new MySqlExtractor(); list = mysqlExtractor.GetAllTables(this.dbName, tablename, fieldNameToSort, isDescending, info); } return(list); }
/// <summary> /// 获取数据所有表信息 /// </summary> /// <param name="tablelist">数据库表名称</param> /// <returns></returns> public List <DbTableInfo> GetWhereTables(string tablelist = null) { List <DbTableInfo> list = new List <DbTableInfo>(); if (dbType == DatabaseType.SqlServer) { MssqlExtractor mssqlExtractor = new MssqlExtractor(); list = mssqlExtractor.GetAllTables(tablelist); } else if (dbType == DatabaseType.MySql) { MySqlExtractor mssqlExtractor = new MySqlExtractor(); list = mssqlExtractor.GetAllTables(this.dbName, tablelist); } return(list); }
/// <summary> /// /// </summary> /// <returns></returns> public List <DataBaseInfo> GetAllDataBases() { List <DataBaseInfo> list = new List <DataBaseInfo>(); if (dbType == DatabaseType.SqlServer) { MssqlExtractor mssqlExtractor = new MssqlExtractor(); list = mssqlExtractor.GetAllDataBases(); } else if (dbType == DatabaseType.MySql) { MySqlExtractor mssqlExtractor = new MySqlExtractor(); list = mssqlExtractor.GetAllDataBases(); } return(list); }
/// <summary> /// 获取表的所有字段名及字段类型 /// </summary> /// <param name="tableName">数据表的名称</param> /// <returns></returns> public List <DbFieldInfo> GetAllColumns(string tableName) { List <DbFieldInfo> list = new List <DbFieldInfo>(); if (dbType == DatabaseType.SqlServer) { MssqlExtractor mssqlExtractor = new MssqlExtractor(); list = mssqlExtractor.GetAllColumns(tableName); } else if (dbType == DatabaseType.MySql) { MySqlExtractor mysqlExtractor = new MySqlExtractor(); list = mysqlExtractor.GetAllColumns(this.dbName, tableName); } return(list); }
public DbExtractor() { MssqlExtractor mssqlExtractor = new MssqlExtractor(); mssqlExtractor.OpenSharedConnection(); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); string dbTypeCache = yuebonCacheHelper.Get("CodeGeneratorDbType").ToString(); if (dbTypeCache != null) { dbType = (DatabaseType)Enum.Parse(typeof(DatabaseType), dbTypeCache); } object odbn = yuebonCacheHelper.Get("CodeGeneratorDbName"); if (odbn != null) { dbName = odbn.ToString(); } }