void choosecolumnspage_DeleteInputOutputColumns(object sender, SetInputOutputColumnsArgs args) { Debug.Assert(args.VirtualColumn != null, "Invalid arguments passed from the UI"); this.ClearErrors(); try { IDTSInput100 input = this.ComponentMetadata.InputCollection[0]; IDTSVirtualInputColumn100 virtualInputColumn = args.VirtualColumn.Tag as IDTSVirtualInputColumn100; if (virtualInputColumn == null) { throw new InvalidOperationException("The UI is in an inconsistent state: Passed argument is not valid."); } int lineageID = virtualInputColumn.LineageID; this.DesigntimeComponent.SetUsageType(input.ID, this.VirtualInput, lineageID, DTSUsageType.UT_IGNORED); } catch (Exception ex) { this.ReportErrors(ex); args.CancelAction = true; } }
private void SetColumns(SetInputOutputColumnsArgs args) { if (this.SetInputOutputColumns != null) { this.SetInputOutputColumns(this, args); if (!args.CancelAction) { this.dataGridViewSelectedColumns.Rows.Add(); this.SetSelectedColumnsRow(args.GeneratedColumns, this.dataGridViewSelectedColumns.Rows[this.dataGridViewSelectedColumns.Rows.Count - 1]); } } }
private void DeleteColumns(SetInputOutputColumnsArgs args) { if (this.DeleteInputOutputColumns != null) { this.DeleteInputOutputColumns(this, args); } if (!args.CancelAction) { foreach (DataGridViewRow row in this.dataGridViewSelectedColumns.Rows) { //look for the row if (row.Cells[this.gridTextBoxInputColumn.Index].Value.ToString() == args.VirtualColumn.ToString()) { //romove it this.dataGridViewSelectedColumns.Rows.Remove(row); break; } } } }
private void dataGridViewAvailableColumns_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (this.isLoading) { return; } if (e.ColumnIndex == this.gridCheckBoxAvailableColumns.Index && e.RowIndex >= 0) { DataGridViewCheckBoxCell checkBoxCell = this.dataGridViewAvailableColumns.CurrentCell as DataGridViewCheckBoxCell; DataGridViewCell columnCell = this.dataGridViewAvailableColumns.Rows[e.RowIndex].Cells[this.gridTextBoxAvailableColumns.Index]; SetInputOutputColumnsArgs args = new SetInputOutputColumnsArgs(); args.VirtualColumn = new DataFlowElement(columnCell.Value.ToString(), columnCell.Tag); bool bAddColumn = (bool)checkBoxCell.Value; // If we're using the select all button, override the value // with the current state of the box. if (bSelectAllClicked) { bAddColumn = bSelectAllState; } if (bAddColumn) { this.SetColumns(args); } else { this.DeleteColumns(args); } // Mark the select all check box as indeterminate if (!bSelectAllClicked) { chkSelectAll.CheckState = CheckState.Indeterminate; } } }
void choosecolumnspage_DeleteInputOutputColumns(object sender, SetInputOutputColumnsArgs args) { Debug.Assert(args.VirtualColumn != null, "Invalid arguments passed from the UI"); this.ClearErrors(); try { IDTSInput100 input = this.ComponentMetadata.InputCollection[0]; IDTSVirtualInputColumn100 virtualInputColumn = args.VirtualColumn.Tag as IDTSVirtualInputColumn100; if (virtualInputColumn == null) { throw new InvalidOperationException("The UI is in an inconsistent state: Passed argument is not valid."); } int lineageID = virtualInputColumn.LineageID; this.DesigntimeComponent.SetUsageType(input.ID, this.VirtualInput, lineageID, DTSUsageType.UT_IGNORED); } catch (Exception ex) { this.ReportErrors(ex); args.CancelAction = true; } }
private void SetColumns(SetInputOutputColumnsArgs args) { if (this.SetInputOutputColumns != null) { this.SetInputOutputColumns(this, args); if (!args.CancelAction) { this.dataGridViewSelectedColumns.Rows.Add(); this.SetSelectedColumnsRow(args.GeneratedColumns, this.dataGridViewSelectedColumns.Rows[this.dataGridViewSelectedColumns.Rows.Count - 1]); } } }
private void dataGridViewAvailableColumns_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (this.isLoading) { return; } if (e.ColumnIndex == this.gridCheckBoxAvailableColumns.Index && e.RowIndex >= 0) { DataGridViewCheckBoxCell checkBoxCell = this.dataGridViewAvailableColumns.CurrentCell as DataGridViewCheckBoxCell; DataGridViewCell columnCell = this.dataGridViewAvailableColumns.Rows[e.RowIndex].Cells[this.gridTextBoxAvailableColumns.Index]; SetInputOutputColumnsArgs args = new SetInputOutputColumnsArgs(); args.VirtualColumn = new DataFlowElement(columnCell.Value.ToString(), columnCell.Tag); bool bAddColumn = (bool)checkBoxCell.Value; // If we're using the select all button, override the value // with the current state of the box. if (bSelectAllClicked) { bAddColumn = bSelectAllState; } if (bAddColumn) { this.SetColumns(args); } else { this.DeleteColumns(args); } // Mark the select all check box as indeterminate if (!bSelectAllClicked) { chkSelectAll.CheckState = CheckState.Indeterminate; } } }
private void DeleteColumns(SetInputOutputColumnsArgs args) { if (this.DeleteInputOutputColumns != null) { this.DeleteInputOutputColumns(this, args); } if (!args.CancelAction) { foreach (DataGridViewRow row in this.dataGridViewSelectedColumns.Rows) { //look for the row if (row.Cells[this.gridTextBoxInputColumn.Index].Value.ToString() == args.VirtualColumn.ToString()) { //romove it this.dataGridViewSelectedColumns.Rows.Remove(row); break; } } } }