private void wheres_SelectedIndexChanged(object sender, EventArgs e)
{
if (wheres.SelectedItems.Count == 1)
{
_whereColumn = ((WhereColumnListViewItem)wheres.SelectedItems[0]).WhereColumn;
}
}
public WhereForm(SelectStatement selectStatement, WhereColumn whereColumn)
{
_selectStatement = selectStatement;
_whereColumn = whereColumn;
InitializeComponent();
columns.ValueMember = "Alias";
columns.DisplayMember = "Alias";
columns.DataSource = _selectStatement.SelectColumns.Where(item => (item.ColumnType & ColumnType.Where) == ColumnType.Where).ToList();
if (whereColumn != null)
{
columns.Enabled = false;
columns.SelectedValue = _selectStatement.SelectColumns.Single(item => item.Alias == whereColumn.ColumnDef.Name);
operators.SelectedItem = whereColumn.Operator;
SelectColumn selectColumn = (SelectColumn)columns.SelectedItem;
if (selectColumn != null)
{
if (selectColumn.OptionsSelectStatement != null)
{
options.SelectedValue = whereColumn.Value1;
}
else
{
value1.Text = whereColumn.Value1;
value2.Text = whereColumn.Value2;
}
}
}
}
private void RefreshData()
{
if (_displaying)
{
return;
}
if (_selectStatement == null)
{
statement.Text = "";
data.DataSource = null;
}
else
{
WhereColumn whereColumn = null;
UserDetails userDetails = GetUserDetails();
_selectStatement.IsPaged = isPaged.Checked;
if (selectStatements.SelectedItems[0].Text == "Accounts" && userDetails.CompanyTypeCode != "Exc")
{
_selectStatement.Where("a.CompanyId", Operator.IsEqualTo, userDetails.CompanyId.ToString(), null);
whereColumn = _selectStatement.WhereColumns.Last();
}
else if (selectStatements.SelectedItems[0].Text == "RequestWarrants" && requestId.Text != "")
{
_selectStatement.Where("r.RequestId", Operator.IsEqualTo, requestId.Text, null);
whereColumn = _selectStatement.WhereColumns.Last();
}
statement.Text = _selectStatement.Statement;
try
{
DataSet dataSet = _selectStatement.Execute();
data.AutoGenerateColumns = true;
data.DataSource = null;
data.DataSource = dataSet.Tables[0];
if (isPaged.Checked)
{
pageNo.Text = (dataSet.Tables[1].Rows[0].Field <int>("PageIndex") + 1).ToString();
noRows.Text = dataSet.Tables[1].Rows[0].Field <int>("Total").ToString();
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
data.DataSource = null;
}
if (whereColumn != null)
{
_selectStatement.WhereColumns.Remove(whereColumn);
}
}
}
public WhereColumnListViewItem(string text, WhereColumn whereColumn)
{
WhereColumn = whereColumn;
Text = text;
SubItems.Add("");
SubItems.Add("");
SubItems.Add("");
RefreshText();
}
public void TableActionFieldBinding()
{
RowSelectorPanelInit();
WhereColumn.Init(mAct.GetOrCreateInputParam(ActUIElement.Fields.WhereColSelector, mAct.GetInputParamValue(ActUIElement.Fields.WhereColSelector)), typeof(ActUIElement.eTableElementRunColSelectorValue), isVENeeded: false, UCselectionChange: WhereColumn_SelectionChanged);
WhereColumnTitle.Init(mAct.GetOrCreateInputParam(ActUIElement.Fields.WhereColumnTitle, mAct.GetInputParamValue(ActUIElement.Fields.WhereColumnTitle)), isVENeeded: true, UCselectionChange: WhereColumnTitle_SelectionChanged, context: Context.GetAsContext(mAct.Context));
WhereProperty.Init(mAct.GetOrCreateInputParam(ActUIElement.Fields.WhereProperty, mAct.GetInputParamValue(ActUIElement.Fields.WhereProperty)), typeof(ActUIElement.eTableElementRunColPropertyValue), isVENeeded: false, UCselectionChange: WhereProperty_SelectionChanged);
WhereOperator.Init(mAct.GetOrCreateInputParam(ActUIElement.Fields.WhereOperator, mAct.GetInputParamValue(ActUIElement.Fields.WhereOperator)), typeof(ActUIElement.eTableElementRunColOperator), isVENeeded: false, UCselectionChange: WhereOperator_SelectionChanged);
WhereColumnValue.Init(Context.GetAsContext(mAct.Context), mAct.GetOrCreateInputParam(ActUIElement.Fields.WhereColumnValue, mAct.GetInputParamValue(ActUIElement.Fields.WhereColumnValue)));
RowSelectorValue.Init(mAct.GetOrCreateInputParam(ActUIElement.Fields.LocateRowValue), isVENeeded: true, UCselectionChange: RowSelectorValue_SelectionChanged, context: Context.GetAsContext(mAct.Context));
}
private void RefreshWeres()
{
wheres.Items.Clear();
_whereColumn = null;
if (_selectStatement != null)
{
foreach (WhereColumn whereColumn in _selectStatement.WhereColumns)
{
//ToDo : need to show alias not columnDef.Name
wheres.Items.Add(new WhereColumnListViewItem(whereColumn.ColumnDef.Name, whereColumn));
}
}
}
