/// <summary> /// Przycisk wywołujący okno z woluminami. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void VolumeButton_Click(object sender, EventArgs e) { SqlCommand Command = new SqlCommand(); Command.CommandText = "EXEC Akcesja_WoluminySygnaturyRoku @id_cza_syg, @rok; "; Command.Parameters.AddWithValue("@id_cza_syg", id_cza_syg); Command.Parameters.AddWithValue("@rok", Year); DataGridViewColumn[] Columns = new DataGridViewColumn[3]; Columns[0] = new DataGridViewColumn(new DataGridViewTextBoxCell()); Columns[0].DataPropertyName = "id_volumes"; Columns[0].Name = "id"; Columns[0].Visible = false; Columns[1] = new DataGridViewColumn(new DataGridViewTextBoxCell()); Columns[1].DataPropertyName = "volumin"; Columns[1].Name = "volumin"; Columns[1].HeaderText = _translationsDictionary.getStringFromDictionary("available_volumes", "Dostępne woluminy"); Columns[2] = new DataGridViewColumn(new DataGridViewTextBoxCell()); Columns[2].DataPropertyName = "numery"; Columns[2].Name = "numery"; Columns[2].HeaderText = _translationsDictionary.getStringFromDictionary("numbers", "Numery"); ShowForm SF = new ShowForm(Command, Columns, "", "volumes", "volumes"); if (SF.ShowDialog() == System.Windows.Forms.DialogResult.OK) { VolumeTextBox.Text = SF.DGVRow.Cells["volumin"].Value.ToString(); this.id_volumin = SF.DGVRow.Cells["id"].Value.ToString(); } }
/// <summary> /// Inicjuje i otwiera okno z wyborem departementu. /// </summary> /// <param name="Crit">Ciąg znaków, wg których ma wyszukiwać w DataGridView.</param> private void InitShowForm(string Crit) { //string Query = "SELECT kod_depart as [id], LTRIM(RTRIM(departam)) AS [Departament] FROM departam ORDER BY departam;"; SqlCommand Command = new SqlCommand(); Command.CommandText = "EXEC Akcesja_ListaDepartamentow; "; DataGridViewColumn[] Columns = new DataGridViewColumn[2]; Columns[0] = new DataGridViewColumn(new DataGridViewTextBoxCell()); Columns[0].DataPropertyName = "id"; Columns[0].Name = "id"; Columns[0].Visible = false; Columns[1] = new DataGridViewColumn(new DataGridViewTextBoxCell()); Columns[1].DataPropertyName = "departament"; Columns[1].Name = "departament"; Columns[1].HeaderText = _translationsDictionary.ContainsKey("department") ? _translationsDictionary["department"] : "Departament"; ShowForm SF = new ShowForm(Command, Columns, Crit, "departament", "departament"); if (SF.ShowDialog() == System.Windows.Forms.DialogResult.OK) { DepartmentID = Int32.Parse(SF.DGVRow.Cells["id"].Value.ToString()); DepartmentTextBox.Text = SF.DGVRow.Cells["departament"].Value.ToString(); } else { DepartmentID = -1; } DepartmentTextBox.Text = DepartmentTextBox.Text.Trim(); DepartmentTextBox.Focus(); DepartmentTextBox.Select(DepartmentTextBox.Text.Length, 0); }
/// <summary> /// Wyświetla okno wyboru czasopisma. /// </summary> /// <param name="Query">Całe zapytanie</param> /// <param name="Crit">Kryterium do podświetlenia rekordu</param> /// <param name="Mode">Tryb (this.Mode)</param> /// <param name="First">Czy jest uruchomione z poziomu okna akcesji, czy przed wyświetleniem okna (dla dopisywania i usuwania)</param> private void ShowList(SqlCommand Query, string Crit, string Mode, bool First, Form mdiParent) { DataGridViewColumn[] Columns = new DataGridViewColumn[11]; Columns[0] = new DataGridViewColumn(new DataGridViewTextBoxCell()); Columns[0].DataPropertyName = "czasop_kod"; Columns[0].Name = "czasop_kod"; Columns[0].Visible = false; Columns[1] = new DataGridViewColumn(new DataGridViewTextBoxCell()); Columns[1].DataPropertyName = "id"; Columns[1].Name = "id"; Columns[1].Visible = false; Columns[2] = new DataGridViewColumn(new DataGridViewTextBoxCell()); Columns[2].DataPropertyName = "id_kolport"; Columns[2].Name = "id_kolport"; Columns[2].Visible = false; Columns[3] = new DataGridViewColumn(new DataGridViewTextBoxCell()); Columns[3].DataPropertyName = "tytul"; Columns[3].Name = "tytul"; Columns[3].HeaderText = _translationsDictionary.ContainsKey("title") ? _translationsDictionary["title"] : "Tytuł"; Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; Columns[4] = new DataGridViewColumn(new DataGridViewTextBoxCell()); Columns[4].DataPropertyName = "id_czest"; Columns[4].Name = "id_czest"; Columns[4].Visible = false; Columns[5] = new DataGridViewColumn(new DataGridViewTextBoxCell()); Columns[5].DataPropertyName = "id_akces"; Columns[5].Name = "id_akces"; Columns[5].Visible = false; Columns[6] = new DataGridViewColumn(new DataGridViewTextBoxCell()); Columns[6].DataPropertyName = "dostawca"; Columns[6].Name = "dostawca"; Columns[6].Visible = false; Columns[7] = new DataGridViewColumn(new DataGridViewTextBoxCell()); Columns[7].DataPropertyName = "uwagi"; Columns[7].Name = "uwagi"; Columns[7].Visible = false; Columns[8] = new DataGridViewColumn(new DataGridViewTextBoxCell()); Columns[8].DataPropertyName = "nazwa_inst"; Columns[8].Name = "nazwa_inst"; Columns[8].Visible = false; Columns[9] = new DataGridViewColumn(new DataGridViewTextBoxCell()); Columns[9].DataPropertyName = "siedziba"; Columns[9].Name = "siedziba"; Columns[9].Visible = false; Columns[10] = new DataGridViewColumn(new DataGridViewTextBoxCell()); Columns[10].DataPropertyName = "sygnatury"; Columns[10].Name = "sygnatury"; Columns[10].HeaderText = _translationsDictionary.ContainsKey("signatures") ? _translationsDictionary["signatures"] : "Sygnatury"; ShowForm Magazines = new ShowForm(Query, Columns, Crit, "", Mode); DialogResult DResult = Magazines.ShowDialog(); if (DResult == System.Windows.Forms.DialogResult.OK) { LoadDataIntoControls(Magazines.DGVRow); if ((Mode == "dopisz" || Mode == "usun") && First) { TitleTextBox.Select(TitleTextBox.Text.Length, 0); this.MdiParent = mdiParent; this.Show(); } } Magazines.Close(); }