private void UpdateOrderClauses() { if (!this._loadingClauses) { this._tableQuery.OrderClauses.Clear(); if (this._fieldComboBox1.SelectedIndex >= 1) { SqlDataSourceOrderClause item = new SqlDataSourceOrderClause(this._tableQuery.DesignerDataConnection, this._tableQuery.DesignerDataTable, ((ColumnItem)this._fieldComboBox1.SelectedItem).DesignerDataColumn, !this._sortAscendingRadioButton1.Checked); this._tableQuery.OrderClauses.Add(item); } if (this._fieldComboBox2.SelectedIndex >= 1) { SqlDataSourceOrderClause clause2 = new SqlDataSourceOrderClause(this._tableQuery.DesignerDataConnection, this._tableQuery.DesignerDataTable, ((ColumnItem)this._fieldComboBox2.SelectedItem).DesignerDataColumn, !this._sortAscendingRadioButton2.Checked); this._tableQuery.OrderClauses.Add(clause2); } if (this._fieldComboBox3.SelectedIndex >= 1) { SqlDataSourceOrderClause clause3 = new SqlDataSourceOrderClause(this._tableQuery.DesignerDataConnection, this._tableQuery.DesignerDataTable, ((ColumnItem)this._fieldComboBox3.SelectedItem).DesignerDataColumn, !this._sortAscendingRadioButton3.Checked); this._tableQuery.OrderClauses.Add(clause3); } } }
public SqlDataSourceConfigureSortForm(SqlDataSourceDesigner sqlDataSourceDesigner, SqlDataSourceTableQuery tableQuery) : base(sqlDataSourceDesigner.Component.Site) { this._sqlDataSourceDesigner = sqlDataSourceDesigner; this._tableQuery = tableQuery.Clone(); this.InitializeComponent(); this.InitializeUI(); Cursor current = Cursor.Current; try { Cursor.Current = Cursors.WaitCursor; this._loadingClauses = true; this._fieldComboBox1.Items.Add(new ColumnItem(null)); this._fieldComboBox2.Items.Add(new ColumnItem(null)); this._fieldComboBox3.Items.Add(new ColumnItem(null)); foreach (DesignerDataColumn column in this._tableQuery.DesignerDataTable.Columns) { this._fieldComboBox1.Items.Add(new ColumnItem(column)); this._fieldComboBox2.Items.Add(new ColumnItem(column)); this._fieldComboBox3.Items.Add(new ColumnItem(column)); } this._fieldComboBox1.InvalidateDropDownWidth(); this._fieldComboBox2.InvalidateDropDownWidth(); this._fieldComboBox3.InvalidateDropDownWidth(); this._sortByGroupBox2.Enabled = false; this._sortByGroupBox3.Enabled = false; this._sortDirectionPanel1.Enabled = false; this._sortDirectionPanel2.Enabled = false; this._sortDirectionPanel3.Enabled = false; this._sortAscendingRadioButton1.Checked = true; this._sortAscendingRadioButton2.Checked = true; this._sortAscendingRadioButton3.Checked = true; if (this._tableQuery.OrderClauses.Count >= 1) { SqlDataSourceOrderClause clause = this._tableQuery.OrderClauses[0]; this.SelectFieldItem(this._fieldComboBox1, clause.DesignerDataColumn); this._sortAscendingRadioButton1.Checked = !clause.IsDescending; this._sortDescendingRadioButton1.Checked = clause.IsDescending; if (this._tableQuery.OrderClauses.Count >= 2) { SqlDataSourceOrderClause clause2 = this._tableQuery.OrderClauses[1]; this.SelectFieldItem(this._fieldComboBox2, clause2.DesignerDataColumn); this._sortAscendingRadioButton2.Checked = !clause2.IsDescending; this._sortDescendingRadioButton2.Checked = clause2.IsDescending; if (this._tableQuery.OrderClauses.Count >= 3) { SqlDataSourceOrderClause clause3 = this._tableQuery.OrderClauses[2]; this.SelectFieldItem(this._fieldComboBox3, clause3.DesignerDataColumn); this._sortAscendingRadioButton3.Checked = !clause3.IsDescending; this._sortDescendingRadioButton3.Checked = clause3.IsDescending; } } } this._loadingClauses = false; this.UpdateOrderClauses(); this.UpdatePreview(); } finally { Cursor.Current = current; } }
private void UpdateOrderClauses() { if (!this._loadingClauses) { this._tableQuery.OrderClauses.Clear(); if (this._fieldComboBox1.SelectedIndex >= 1) { SqlDataSourceOrderClause item = new SqlDataSourceOrderClause(this._tableQuery.DesignerDataConnection, this._tableQuery.DesignerDataTable, ((ColumnItem) this._fieldComboBox1.SelectedItem).DesignerDataColumn, !this._sortAscendingRadioButton1.Checked); this._tableQuery.OrderClauses.Add(item); } if (this._fieldComboBox2.SelectedIndex >= 1) { SqlDataSourceOrderClause clause2 = new SqlDataSourceOrderClause(this._tableQuery.DesignerDataConnection, this._tableQuery.DesignerDataTable, ((ColumnItem) this._fieldComboBox2.SelectedItem).DesignerDataColumn, !this._sortAscendingRadioButton2.Checked); this._tableQuery.OrderClauses.Add(clause2); } if (this._fieldComboBox3.SelectedIndex >= 1) { SqlDataSourceOrderClause clause3 = new SqlDataSourceOrderClause(this._tableQuery.DesignerDataConnection, this._tableQuery.DesignerDataTable, ((ColumnItem) this._fieldComboBox3.SelectedItem).DesignerDataColumn, !this._sortAscendingRadioButton3.Checked); this._tableQuery.OrderClauses.Add(clause3); } } }