public GroupField(AvailableField availableField)
{
AvailableField = availableField;
AvailableFieldName = availableField.AvailableFieldName;
ColumnAlias = availableField.AvailableFieldName;
}
internal List<AvailableField> GetAvailableFields(string reportWizardDataSourceName)
{
List<AvailableField> availableFields = new List<AvailableField>();
using (MySqlConnection connection = new MySqlConnection(GetConnectionString()))
{
MySqlDataReader dr = null;
MySqlCommand cmd = new MySqlCommand("usp_GetAvailableFieldsByReportWizardDataSourceName", connection);
cmd.CommandType = CommandType.StoredProcedure;
AddSqlParameter(cmd, "iReportWizardDataSourceName", MySqlDbType.String, reportWizardDataSourceName);
connection.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
AvailableField availableField = new AvailableField();
availableField.AvailableFieldName = dr["AvailableFieldName"].ToString();
availableFields.Add(availableField);
}
cmd.Dispose();
}
return availableFields;
}
public SelectedField(AvailableField availableField)
{
AvailableField = availableField;
AvailableFieldName = availableField.AvailableFieldName;
ColumnAlias = availableField.AvailableFieldName;
}
