public List <WFSelectValue> getValues(DatabaseConnection DBConn, DBFilter filter, CultureInfo ci)
{
string sql = "SELECT ";
if (distinct)
{
sql += "DISTINCT ";
}
for (int i = 0; i != fields.Length; i++)
{
if (i > 0)
{
sql += ",";
}
sql += fields[i];
}
sql += " FROM " + tableName;
if (terms.Count > 0)
{
if (filter == null)
{
filter = new DBFilter();
}
foreach (DBTerm t in terms)
{
filter.add(t);
}
}
if (!string.IsNullOrEmpty(sortField))
{
if (filter == null)
{
filter = new DBFilter();
}
filter.add(sortField, true);
}
IDbCommand command = DBConn.CreateSelectCommand(sql, filter);
DataTable table = DBConn.ExecuteToDataTable(command);
List <WFSelectValue> list = new List <WFSelectValue>();
IDataReader reader = DBConn.ExecuteReader(command);
while (reader.Read())
{
string name = GetText(reader);
string val = GetKey(reader);
WFSelectValue sv = new WFSelectValue(val, name);
list.Add(sv);
}
reader.Close();
return(list);
}
public List <WFSelectValue> getValues(DatabaseConnection DBConn, DBFilter filter, CultureInfo ci)
{
List <WFSelectValue> list = new List <WFSelectValue>();
ResourceManager rm = DBUtils.getResourceManager();
for (int i = 0; i != values.Length; i++)
{
string s = rm.GetString(display[i], ci);
if (s == null)
{
s = display[i];
}
WFSelectValue sv = new WFSelectValue(values[i], s);
list.Add(sv);
}
return(list);
}
public List <WFSelectValue> getValues(DatabaseConnection DBConn, DBFilter filter, CultureInfo ci)
{
if (terms.Count > 0)
{
if (filter == null)
{
filter = new DBFilter();
}
foreach (DBTerm t in terms)
{
filter.add(t);
}
}
if (!string.IsNullOrEmpty(sortField))
{
if (filter == null)
{
filter = new DBFilter();
}
filter.add(sortField, true);
}
IDbCommand command = DBConn.CreateSelectCommand("SELECT DISTINCT " + keyField + " K, " + nameField + " V," + sortField + " FROM " + tableName, filter);
DataTable table = DBConn.ExecuteToDataTable(command);
List <WFSelectValue> list = new List <WFSelectValue>();
foreach (DataRow row in table.Rows)
{
string name = row["V"].ToString().Trim();
string val = row["K"].ToString().Trim();
WFSelectValue sv = new WFSelectValue(val, name);
list.Add(sv);
}
return(list);
}
