void SAPQuery_SelectedIndexChanged(object sender, EventArgs e)
{
//throw new NotImplementedException();
ComboBox comboBox = sender as ComboBox;
if (comboBox.DataSource != null)
{
QuerySelectionParameterCollection collection = (QuerySelectionParameterCollection)comboBox.DataSource;
foreach (QuerySelectionParameter item in collection)
{
if (item.DescriptionText == comboBox.Text)
{
dgvParameters.Rows[dgvParameters.CurrentCell.RowIndex].Cells["CKIND"].Value = item.Kind == Kind.SelectOption ? "SelectOption" : "Parameter";
dgvParameters.Rows[dgvParameters.CurrentCell.RowIndex].Cells["CFIELDNAME"].Value = item.FieldName;
dgvParameters.Rows[dgvParameters.CurrentCell.RowIndex].Cells["CNAME"].Value = item.Name;
}
}
}
comboBox.SelectedIndexChanged -= new EventHandler(SAPQuery_SelectedIndexChanged);
}
private void GetQueryDefinition()
{
try
{
WorkSpace area = checkStandard.Checked == true ? WorkSpace.StandardArea : WorkSpace.GlobalArea;
SAPConnection con = new SAPConnection(systemName);
q = con.CreateQuery(area, userGroup, queryName, variant);
// parameterCollection = new QuerySelectionParameterCollection();
parameterCollection = q.SelectionParameters;
dgvParameters.Rows.Clear();
DataGridViewComboBoxColumn col = (DataGridViewComboBoxColumn)dgvParameters.Columns["CSELNAME"];
col.DataSource = null;
col.DataSource = parameterCollection;
col.DisplayMember = "DescriptionText";
q = null;
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
