public static SortedDictionary <string, int> GetTableKeyItems(string tableName, string columnName, bool addNullItem = true) { DataTable tab = TableManager.GetTable(tableName); bool isFk = TableKeys.CheckColumnKeyType(tableName, columnName, TableKeys.KeyType.ForeignKey); var result = new SortedDictionary <string, int>(); if (isFk) { var keysList = GetUniqueSet(tab, columnName); foreach (var key in keysList) { var value = GetValueByKey(tableName, columnName, key, true); if (result.ContainsKey(value) == false) { result.Add(value, (int)key); } } if (result.ContainsKey("") == false && addNullItem) { result.Add("", -1); } } return(result); }
public static SortedSet <string> GetTableItems(string tableName, string columnName) { DataTable tab = TableManager.GetTable(tableName); bool isFk = TableKeys.CheckColumnKeyType(tableName, columnName, TableKeys.KeyType.ForeignKey); var keysList = GetUniqueSet(tab, columnName); var valuesList = new SortedSet <string>(); foreach (var value in keysList) { if (isFk) { valuesList.Add(GetValueByKey(tableName, columnName, value, true)); } else { valuesList.Add(value.ToString()); } } if (valuesList.Contains("") == false) { valuesList.Add(""); } return(valuesList); }