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