public static FindRankingOfDatabaseItem ( string displayText ) : int | ||
displayText | string | |
Résultat | int |
/// <summary> /// returns the list of databases /// </summary> public static List <CompletionItem> GetDbList() { if (_dataBases.Count <= 0) { return(new List <CompletionItem>()); } return(_dataBases.Select(@base => new CompletionItem { DisplayText = @base.LogicalName, Type = CompletionType.Database, FromParser = false, Ranking = AutoComplete.FindRankingOfDatabaseItem(@base.LogicalName), Flag = 0 }).ToList()); }
/// <summary> /// Returns the list of tables for a given database /// </summary> /// <param name="dataBase"></param> /// <returns></returns> public static List <CompletionItem> GetTablesList(ParsedDataBase dataBase) { var output = new List <CompletionItem>(); if (dataBase == null || dataBase.Tables == null || dataBase.Tables.Count == 0) { return(output); } output.AddRange(dataBase.Tables.Select(table => new CompletionItem { DisplayText = table.Name, SubString = dataBase.LogicalName, Type = CompletionType.Table, FromParser = false, Ranking = AutoComplete.FindRankingOfDatabaseItem(table.Name), Flag = 0 }).ToList()); return(output); }
/// <summary> /// Returns the list of fields for a given table (it can also be a temp table!) /// </summary> /// <param name="table"></param> /// <returns></returns> public static List <CompletionItem> GetFieldsList(ParsedTable table) { var output = new List <CompletionItem>(); if (table == null) { return(output); } output.AddRange(table.Fields.Select(field => new CompletionItem { DisplayText = field.Name, Type = (field.Flag.HasFlag(ParsedFieldFlag.Primary)) ? CompletionType.FieldPk : CompletionType.Field, FromParser = false, SubString = field.Type.ToString(), Ranking = AutoComplete.FindRankingOfDatabaseItem(field.Name), Flag = (field.Flag.HasFlag(ParsedFieldFlag.Mandatory) ? ParseFlag.Mandatory : 0) | (field.Flag.HasFlag(ParsedFieldFlag.Index) ? ParseFlag.Index : 0) | (field.Flag.HasFlag(ParsedFieldFlag.Extent) ? ParseFlag.Extent : 0), ParsedItem = table })); return(output); }