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);
}