/// <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();
}
