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