private void buttonDown_Click(object sender, EventArgs e) { ColumnsListView colList = CurrentList; if (colList == null) { return; } ColParams colParams = ColumnsLists[colList]; if (colParams == null) { return; } if (colList.SelectedRows.Count == 1) { colList.SuspendLayout(); int row = colList.SelectedRows[0].Index; if (row < colList.Rows.Count - 1) { int col = colList.Columns["OrderIndex"].Index; object a = colList[col, row].Value; object b = colList[col, row + 1].Value; colList[col, row].Value = b; colList[col, row + 1].Value = a; } colList.Sort(colList.Columns["OrderIndex"], ListSortDirection.Ascending); colList.ResumeLayout(); } UpdateButtons(colList, e); }
private void buttonResetSort_Click(object sender, EventArgs e) { ColumnsListView colList = CurrentList; if (colList == null) { return; } colList.ResetSortOrder(); }
private void ColumnsListView_Loaded(object sender, RoutedEventArgs e) { if (ReferenceEquals(e.OriginalSource, ColumnsListView)) { var scrollViewer = ColumnsListView.GetFirstDescendantBreadthFirst <ScrollViewer>(); if (scrollViewer != null) { ListBoxScrollViewer = scrollViewer; } } }
private void ShowColumns() { Cursor csr = null; ListViewItem ColumnListViewItem; Table tbl; try { csr = this.Cursor; // Save the old cursor this.Cursor = Cursors.WaitCursor; // Display the waiting cursor // Delay rendering until after list filled ColumnsListView.BeginUpdate(); // Clear the columns list ColumnsListView.Items.Clear(); // Show the current columns for the selected table if (TablesComboBox.SelectedIndex >= 0) { // Get the selected table object tbl = (Table)TablesComboBox.SelectedItem; // Iterate through all the columns to fill list foreach (Column col in tbl.Columns) { ColumnListViewItem = ColumnsListView.Items.Add(col.Name); ColumnListViewItem.SubItems.Add(col.DataType.Name); ColumnListViewItem.SubItems.Add(col.DataType. MaximumLength.ToString( System.Globalization.CultureInfo.InvariantCulture)); ColumnListViewItem.SubItems.Add( col.Nullable.ToString()); ColumnListViewItem.SubItems.Add( col.InPrimaryKey.ToString()); } } // Now we render the listview ColumnsListView.EndUpdate(); UpdateButtons(); } catch (SmoException ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } finally { this.Cursor = csr; // Restore the original cursor } }
public SettingsColumnsDialog(Style style, Folder optionFolder, Style finalStyle) { try { this.finalStyle = finalStyle; InitializeComponent(); ComponentResourceManager resources = new ComponentResourceManager(typeof(Forms.MainFormDialog)); this.Text = resources.GetObject("menuItem8.Text").ToString() + "->" + resources.GetObject("mIColumns.Text").ToString().TrimEnd('.'); this.optionFolder = optionFolder; FolderCollection savedStyles = optionFolder.GetSavedFolders(); m_style = style; if (/*style == null &&*/ savedStyles.Count > 0) { panelColumns.Controls.Remove(list); list.Visible = false; int countAvailableStyles = 0; foreach (Folder folder in savedStyles) { string name = folder.Name; ColParams colsNew = new ColParams(folder, false); if (colsNew.WasInited && colsNew.NotEmpty(true)) { ColumnsListView listNew = (ColumnsListView)list.Clone(); ColumnsLists.Add(listNew, colsNew); countAvailableStyles++; } } if (countAvailableStyles == 1) { ColumnsLists.Clear(); TheOnlyStyleToEdit(finalStyle); } else { subLayout = Environment.Layout.Folders.Add("SettingsColumns"); Closed += SettingsColumnsDialog_Closed; } } //else // TheOnlyStyleToEdit(style); } catch (Exception ex) { Environment.CmdManager.Commands["ResetColumns"].Execute(); } }
private ColumnsListView(ColumnsListView list) { ShowCellToolTips = list.ShowCellToolTips; DoubleBuffered = list.DoubleBuffered; AutoGenerateColumns = list.AutoGenerateColumns; MultiSelect = list.MultiSelect; SelectionMode = list.SelectionMode; EditMode = list.EditMode; AutoSize = list.AutoSize; AutoSizeColumnsMode = list.AutoSizeColumnsMode; AutoSizeRowsMode = list.AutoSizeRowsMode; AllowUserToResizeRows = list.AllowUserToResizeRows; AllowUserToAddRows = list.AllowUserToAddRows; AllowUserToDeleteRows = list.AllowUserToDeleteRows; Dock = list.Dock; ColumnHeadersVisible = list.ColumnHeadersVisible; RowHeadersVisible = list.RowHeadersVisible; AllowUserToResizeColumns = list.AllowUserToResizeColumns; GridColor = list.GridColor; Anchor = list.Anchor; Init(); }
private void UpdateButtons(object sender, EventArgs e) { bool up = false; bool down = false; ColumnsListView colList = sender as ColumnsListView; if (colList == null) { return; } colList.SuspendLayout(); if (colList.SelectedRows.Count == 1) { DataGridViewRow item = colList.SelectedRows[0]; if (item.Index > 0) { up = true; } if (item.Index < colList.Rows.Count - 1) { down = true; } } colList.ResumeLayout(); if (buttonUp.Enabled != up) { buttonUp.Enabled = up; } if (buttonDown.Enabled != down) { buttonDown.Enabled = down; } }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(SettingsColumnsDialog)); this.panelColumns = new System.Windows.Forms.Panel(); this.list = new Kesco.App.Win.DocView.Settings.SettingsColumnsDialog.ColumnsListView(); this.tabControl = new System.Windows.Forms.TabControl(); this.buttonUp = new System.Windows.Forms.Button(); this.buttonDown = new System.Windows.Forms.Button(); this.buttonReset = new System.Windows.Forms.Button(); this.buttonCancel = new System.Windows.Forms.Button(); this.buttonOK = new System.Windows.Forms.Button(); this.panelButtons = new System.Windows.Forms.Panel(); this.buttonResetSort = new System.Windows.Forms.Button(); this.panelColumns.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.list)).BeginInit(); this.panelButtons.SuspendLayout(); this.SuspendLayout(); // // panelColumns // resources.ApplyResources(this.panelColumns, "panelColumns"); this.panelColumns.Controls.Add(this.list); this.panelColumns.Controls.Add(this.tabControl); this.panelColumns.Controls.Add(this.buttonUp); this.panelColumns.Controls.Add(this.buttonDown); this.panelColumns.Name = "panelColumns"; // // list // this.list.AllowUserToAddRows = false; this.list.AllowUserToDeleteRows = false; this.list.AllowUserToResizeColumns = false; this.list.AllowUserToResizeRows = false; resources.ApplyResources(this.list, "list"); this.list.BackgroundColor = System.Drawing.SystemColors.Window; this.list.CellBorderStyle = System.Windows.Forms.DataGridViewCellBorderStyle.None; this.list.ColumnHeadersVisible = false; this.list.EditMode = System.Windows.Forms.DataGridViewEditMode.EditProgrammatically; this.list.MultiSelect = false; this.list.Name = "list"; this.list.RowHeadersVisible = false; this.list.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect; this.list.ShowCellToolTips = false; // // tabControl // resources.ApplyResources(this.tabControl, "tabControl"); this.tabControl.Name = "tabControl"; this.tabControl.SelectedIndex = 0; // // buttonUp // resources.ApplyResources(this.buttonUp, "buttonUp"); this.buttonUp.Name = "buttonUp"; this.buttonUp.Click += new System.EventHandler(this.buttonUp_Click); // // buttonDown // resources.ApplyResources(this.buttonDown, "buttonDown"); this.buttonDown.Name = "buttonDown"; this.buttonDown.Click += new System.EventHandler(this.buttonDown_Click); // // buttonReset // resources.ApplyResources(this.buttonReset, "buttonReset"); this.buttonReset.Name = "buttonReset"; this.buttonReset.Click += new System.EventHandler(this.buttonReset_Click); // // buttonCancel // resources.ApplyResources(this.buttonCancel, "buttonCancel"); this.buttonCancel.DialogResult = System.Windows.Forms.DialogResult.Cancel; this.buttonCancel.Name = "buttonCancel"; this.buttonCancel.Click += new System.EventHandler(this.buttonCancel_Click); // // buttonOK // resources.ApplyResources(this.buttonOK, "buttonOK"); this.buttonOK.Name = "buttonOK"; this.buttonOK.Click += new System.EventHandler(this.buttonOK_Click); // // panelButtons // this.panelButtons.Controls.Add(this.buttonResetSort); this.panelButtons.Controls.Add(this.buttonReset); this.panelButtons.Controls.Add(this.buttonCancel); this.panelButtons.Controls.Add(this.buttonOK); resources.ApplyResources(this.panelButtons, "panelButtons"); this.panelButtons.Name = "panelButtons"; // // buttonResetSort // resources.ApplyResources(this.buttonResetSort, "buttonResetSort"); this.buttonResetSort.Name = "buttonResetSort"; this.buttonResetSort.Click += new System.EventHandler(this.buttonResetSort_Click); // // SettingsColumnsDialog // this.AcceptButton = this.buttonOK; resources.ApplyResources(this, "$this"); this.CancelButton = this.buttonCancel; this.Controls.Add(this.panelColumns); this.Controls.Add(this.panelButtons); this.KeyPreview = true; this.MaximizeBox = false; this.MinimizeBox = false; this.Name = "SettingsColumnsDialog"; this.Load += new System.EventHandler(this.SettingsColumnsDialog_Load); this.panelColumns.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.list)).EndInit(); this.panelButtons.ResumeLayout(false); this.ResumeLayout(false); }
private void UiLoginMessage(DataToolsUIMsg message) { this.Dispatcher.BeginInvoke(System.Windows.Threading.DispatcherPriority.Background, new Action(() => { switch (message.type) { case "ShowTables": //显示某个数据库的数据表 if (null != message.dataSet && message.dataSet.Tables[0].Rows.Count > 0) { TablesListView.BeginInit(); //TablesListView.Items.Clear(); tableLists.Clear(); int i = 0; foreach (DataRow row in message.dataSet.Tables[0].Rows) { i++; tableLists.Add(new DataList(i.ToString(), row[0].ToString())); } TablesListView.ItemsSource = tableLists; TablesListView.EndInit(); } break; case "ShowTableColumns": //显示某个数据库的数据表的所有字段 if (null != message.dataSet && message.dataSet.Tables[0].Rows.Count > 0) { ColumnsListView.BeginInit(); columnsLists.Clear(); int i = 0; foreach (DataRow row in message.dataSet.Tables[0].Rows) { i++; columnsLists.Add(new DataList(i.ToString(), row[0].ToString(), row[1].ToString())); } ColumnsListView.ItemsSource = columnsLists; ColumnsListView.EndInit(); } break; case "ShowDataBases": //显示所有数据库 if (null != message.dataSet && message.dataSet.Tables[0].Rows.Count > 0) { DataBaseList.BeginInit(); DataBaseList.Items.Clear(); foreach (DataRow row in message.dataSet.Tables[0].Rows) { DataBaseList.Items.Add(row[0].ToString()); } DataBaseList.EndInit(); } if (DataBaseList.Items.Count > 0) { DataBaseList.SelectedIndex = 0; } break; case "ShowTableData": //显示表中数据 if (null != message.dataSet && message.dataSet.Tables[0].Rows.Count > 0) { AllTableData.BeginInit(); AllTableData.ItemsSource = message.dataSet.Tables[0].DefaultView; AllTableData.EndInit(); } else { AllTableData.BeginInit(); AllTableData.ItemsSource = null; AllTableData.EndInit(); } break; case "exception": MessageBox.Show(message.message); Status1.Content = message.message; break; } })); }