/// <summary> /// Setzt und prüft ob in eine MetroTextBox ein gültiges Feldtrennzeichen (gibt TRUE bei korrektem Zeichen zurück) /// </summary> public bool Set_Seperator(IWin32Window owner, ref AdvancedComboBox aComboBox) { bool correct = false; if (aComboBox.Text.Length != 0) { if (aComboBox.Text == "{Leerzeichen}") { Separator = ' '; correct = true; } else if (aComboBox.Text == "{Tabulator}") { Separator = '\t'; correct = true; } else { if (aComboBox.Text.Length == 1) { Separator = Convert.ToChar(aComboBox.Text); correct = true; } else { aComboBox.Text = aComboBox.Text.Substring(0, 1); Separator = Convert.ToChar(aComboBox.Text); correct = true; } } } return(correct); }
/// <summary> /// Füllt die ComboBoxen Autor, Verlag und Genre /// </summary> public void FillComboBoxes(ref AdvancedComboBox cbAuthor, ref AdvancedComboBox cbPublisher, ref AdvancedComboBox cbGenre) { authorHelper.FillCombobox(ref cbAuthor, -1); publisherHelper.FillCombobox(ref cbPublisher, -1); genreHelper.FillCombobox(ref cbGenre, -1); if (cbAuthor.Text == "") { cbAuthor.Text = "Autor"; } if (cbPublisher.Text == "") { cbPublisher.Text = "Verlag"; } if (cbGenre.Text == "") { cbGenre.Text = "Genre"; } }
/// <summary> /// fills a combobox with all the condition data /// </summary> /// <param name="cb"></param> /// <param name="value"></param> public void FillCombobox(ref AdvancedComboBox cb, object value) { c.FillCombobox(ref cb, value, ref table); }
private void BackgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { try { BeginInvoke((Action) delegate() { groupMain.Enabled = false; groupList.Enabled = false; spinnerGridView.Visible = true; spinnerAttributes.Visible = true; cbAuthor.DataSource = null; this.cbGenre.DataSource = null; cbPublisher.DataSource = null; gridOverview.Visible = false; if (cbAuthor.AutoCompleteSource != AutoCompleteSource.None) { cbAuthor.AutoCompleteSource = AutoCompleteSource.None; } if (cbPublisher.AutoCompleteSource != AutoCompleteSource.None) { cbPublisher.AutoCompleteSource = AutoCompleteSource.None; } if (this.cbGenre.AutoCompleteSource != AutoCompleteSource.None) { this.cbGenre.AutoCompleteSource = AutoCompleteSource.None; } cbAuthor.Visible = false; this.cbGenre.Visible = false; cbPublisher.Visible = false; }); MetroGrid mgBuSu = new MetroGrid(); AdvancedComboBox cbAutor = new AdvancedComboBox(); AdvancedComboBox cbVerlag = new AdvancedComboBox(); AdvancedComboBox cbGenre = new AdvancedComboBox(); List <int> RedBlack = new List <int>(); List <int> YellowBlack = new List <int>(); List <int> LimeBlack = new List <int>(); List <int> BlackWhite = new List <int>(); overviewHelper = new OverviewHelper(); overviewHelper.FillComboBoxes(ref cbAutor, ref cbVerlag, ref cbGenre); overviewHelper.FillGrid(ref mgBuSu); var dtBuSu = mgBuSu.DataSource; while (loaded == false) { } BeginInvoke((Action) delegate { gridOverview.DataSource = null; gridOverview.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None; gridOverview.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.DisableResizing; gridOverview.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing; gridOverview.AllowUserToResizeColumns = true; gridOverview.RowHeadersVisible = false; gridOverview.DataSource = dtBuSu; gridOverview.Columns["Kunden ID"].Visible = false; gridOverview.Columns["Leihnummer"].Visible = false; gridOverview.Columns["Kunden ID"].Visible = false; gridOverview.Columns["Vorname"].Visible = false; gridOverview.Columns["Nachname"].Visible = false; gridOverview.Columns["Klasse"].Visible = false; searchActivated = false; cbAuthor.DataSource = cbAutor.DataSource; cbAuthor.ValueMember = "au_id"; cbAuthor.DisplayMember = "au_autor"; cbAuthor.SelectedIndex = -1; cbPublisher.DataSource = cbVerlag.DataSource; cbPublisher.ValueMember = "ver_id"; cbPublisher.DisplayMember = "ver_name"; cbPublisher.SelectedIndex = -1; this.cbGenre.DataSource = cbGenre.DataSource; this.cbGenre.ValueMember = "ger_id"; this.cbGenre.DisplayMember = "ger_name"; this.cbGenre.SelectedIndex = -1; if (cbAuthor.Text == "") { cbAuthor.Text = "Autor"; } if (cbPublisher.Text == "") { cbPublisher.Text = "Verlag"; } if (this.cbGenre.Text == "") { this.cbGenre.Text = "Genre"; } string rawFilter = string.Format("Convert([ExemplarID], System.String) LIKE '{0}%' AND ISBN LIKE '{1}%' AND Titel LIKE '%{2}%' AND Verlag LIKE '%{3}%' AND Genre LIKE '%{4}%' AND Autor LIKE '%{5}%'", "", "", "", "", "", ""); (gridOverview.DataSource as DataTable).DefaultView.RowFilter = rawFilter; addRowFilter(); gridOverview.Refresh(); searchActivated = true; ShowKundeDetails(); spinnerGridView.Visible = false; spinnerAttributes.Visible = false; gridOverview.Visible = true; cbAuthor.Visible = true; this.cbGenre.Visible = true; cbPublisher.Visible = true; groupMain.Enabled = true; groupList.Enabled = true; }); } catch { try { BeginInvoke((Action) delegate { spinnerGridView.Visible = false; spinnerAttributes.Visible = false; gridOverview.Visible = true; cbAuthor.Visible = true; cbGenre.Visible = true; cbPublisher.Visible = true; MetroFramework.MetroMessageBox.Show(this, "Fehler beim Laden der Daten.", "Fehler", MessageBoxButtons.OK, MessageBoxIcon.Error); }); } catch { } } }