public static List <FieldInfo> GetTableColumns(string connStr, DataTypes?dataType, string dataBase, string tableName) { var sql = string.Empty; switch (dataType) { case DataTypes.MYSQL: case DataTypes.ORACLE: sql = string.Format(Consts.Fields.OracleFieldsInfo, "USER_TAB_COLS.COLUMN_NAME AS ColumnName, USER_TAB_COLS.DATA_TYPE AS DataType," + "USER_TAB_COLS.DATA_LENGTH AS StringLength,USER_TAB_COLS.COLUMN_ID AS OrderNo", tableName); break; case DataTypes.SQLSERVER: sql = string.Format(Consts.Fields.SqlServerFieldsInfo, "COLUMN_NAME AS ColumnName,DATA_TYPE AS DataType,CHARACTER_MAXIMUM_LENGTH As StringLength,ORDINAL_POSITION AS OrderNo", dataBase, tableName); return(BaseUnity.GetTableColunmSql(connStr, tableName)); break; default: return(null); } return(BaseUnity.QueryForList <FieldInfo>(connStr, dataType, sql, null)); }
private static List <string> GetDataBaseInfoSqlServer(string connStr) { return(BaseUnity.QueryForListStr(connStr, DataTypes.SQLSERVER, Consts.DataBase.SqlServer, null)); }
private static List <string> GetTablesInfoMysql(string connStr, string dataBase) { var sql = string.Format(Consts.Tables.MysqlAllTables, dataBase); return(BaseUnity.QueryForListStr(connStr, DataTypes.MYSQL, sql, null)); }
private static List <string> GetTablesInfoOracle(string connStr, string dataBase) { var sql = string.Format(Consts.Tables.OracleAllTables, dataBase); return(BaseUnity.QueryForListStr(connStr, DataTypes.ORACLE, sql, null)); }
private static List <string> GetTablesInfoSqlServer(string connStr, string dataBase) { var sql = string.Format(Consts.Tables.SqlServerAllTables, dataBase); return(BaseUnity.QueryForListStr(connStr, DataTypes.SQLSERVER, sql, null)); }