Example #1
0
 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);
         }
     }
 }
Example #2
0
        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);
         }
     }
 }