public History(ReaderVO reader) { InitializeComponent(); label2.Text = reader.FIO; DBReference dbref = new DBReference(); dataGridView1.DataSource = dbref.GetReaderHistory(reader); dataGridView1.Columns["DATE_ISSUE"].HeaderText = "Дата выдачи"; dataGridView1.Columns["DATE_RETURN"].HeaderText = "Дата возврата"; dataGridView1.Columns["inv"].HeaderText = "Инвентарный номер"; dataGridView1.Columns["tit"].HeaderText = "Заглавие"; dataGridView1.Columns["avt"].HeaderText = "Автор"; dataGridView1.Columns["ID"].HeaderText = "№№"; dataGridView1.Columns["ID"].Width = 40; int i = 0; foreach (DataGridViewRow row in dataGridView1.Rows) { row.Cells["ID"].Value = (++i).ToString(); } dataGridView1.Columns["tit"].Width = 300; dataGridView1.Columns["tit"].DefaultCellStyle.WrapMode = DataGridViewTriState.True; }
private void выданныеКнигиНаТекущийМоментToolStripMenuItem_Click(object sender, EventArgs e) { Statistics.Columns.Clear(); //Statistics.Columns.Add("NN", "№ п/п"); Statistics.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; Statistics.RowTemplate.DefaultCellStyle.WrapMode = System.Windows.Forms.DataGridViewTriState.True; Statistics.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; //DatePeriod f3 = new DatePeriod(); //f3.ShowDialog(); label19.Text = "Список выданных документов на текущий момент "; label18.Text = ""; DBReference dbref = new DBReference(); Statistics.DataSource = dbref.GetAllIssuedBook(); if (this.Statistics.Rows.Count == 0) { this.Statistics.Columns.Clear(); MessageBox.Show("Нет выданных книг!"); return; } autoinc(Statistics); Statistics.Columns[0].Width = 40; Statistics.Columns[0].HeaderText = "№№"; Statistics.Columns[1].HeaderText = "Заглавие"; Statistics.Columns[1].Width = 270; Statistics.Columns[2].HeaderText = "Автор"; Statistics.Columns[2].Width = 140; Statistics.Columns[3].HeaderText = "Номер читате льского билета"; Statistics.Columns[3].Width = 70; Statistics.Columns[4].HeaderText = "Фамилия"; Statistics.Columns[4].Width = 100; Statistics.Columns[5].HeaderText = "Имя"; Statistics.Columns[5].Width = 90; Statistics.Columns[6].HeaderText = "Отчество"; Statistics.Columns[6].Width = 100; Statistics.Columns[7].HeaderText = "Штрихкод"; Statistics.Columns[7].Width = 80; Statistics.Columns[8].HeaderText = "Дата выдачи"; Statistics.Columns[8].ValueType = typeof(DateTime); Statistics.Columns[8].DefaultCellStyle.Format = "dd.MM.yyyy"; Statistics.Columns[8].Width = 85; Statistics.Columns[9].HeaderText = "Предпо лагаемая дата возврата"; Statistics.Columns[9].DefaultCellStyle.Format = "dd.MM.yyyy"; Statistics.Columns[9].Width = 85; Statistics.Columns[10].Visible = false; Statistics.Columns[11].HeaderText = "Расстановочный шифр"; Statistics.Columns[11].Width = 100; Statistics.Columns[12].HeaderText = "Фонд"; Statistics.Columns[12].Width = 50; Statistics.Columns[13].HeaderText = "Тип выдачи"; Statistics.Columns[13].Width = 50; button12.Enabled = true; }
private void списокНарушителейСроковПользованияToolStripMenuItem_Click(object sender, EventArgs e) { Statistics.Columns.Clear(); //Statistics.Columns.Add("NN", "№ п/п"); Statistics.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; Statistics.RowTemplate.DefaultCellStyle.WrapMode = System.Windows.Forms.DataGridViewTriState.True; Statistics.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; //DatePeriod f3 = new DatePeriod(); //f3.ShowDialog(); label19.Text = "Список нарушителей сроков пользования "; label18.Text = ""; DBReference dbref = new DBReference(); Statistics.DataSource = dbref.GetViolators(); if (this.Statistics.Rows.Count == 0) { this.Statistics.Columns.Clear(); MessageBox.Show("Нет выданных книг!"); return; } autoinc(Statistics); Statistics.Columns[0].HeaderText = "№№"; Statistics.Columns[0].Width = 30; Statistics.Columns[1].HeaderText = "ФИО"; Statistics.Columns[1].Width = 100; Statistics.Columns[2].HeaderText = "Номер читателя"; Statistics.Columns[2].Width = 100; Statistics.Columns[3].HeaderText = "Права читателя"; Statistics.Columns[3].Width = 100; Statistics.Columns[4].HeaderText = "Инв номер/ шкод"; Statistics.Columns[4].Width = 100; Statistics.Columns[5].HeaderText = "Телефон"; Statistics.Columns[5].Width = 100; Statistics.Columns[6].HeaderText = "Email"; Statistics.Columns[6].Width = 100; Statistics.Columns[7].HeaderText = "Адрес"; Statistics.Columns[7].Width = 100; Statistics.Columns[8].HeaderText = "Дата выдачи"; Statistics.Columns[8].Width = 90; Statistics.Columns[9].HeaderText = "Дата возврата"; Statistics.Columns[9].Width = 90; Statistics.Columns[10].HeaderText = "Дней просрочено"; Statistics.Columns[10].Width = 90; button12.Enabled = true; //foreach (DataGridViewRow r in Statistics.Rows) //{ // object value = r.Cells[5].Value; // if (Convert.ToBoolean(value) == true) // { // r.DefaultCellStyle.BackColor = Color.Yellow; // } //} }
private void списокКнигСКоторыхСнятаОтветственностьToolStripMenuItem_Click(object sender, EventArgs e) { Statistics.Columns.Clear(); //Statistics.Columns.Add("NN", "№ п/п"); Statistics.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; Statistics.RowTemplate.DefaultCellStyle.WrapMode = System.Windows.Forms.DataGridViewTriState.True; Statistics.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; //DatePeriod f3 = new DatePeriod(); //f3.ShowDialog(); label19.Text = "Обращаемость документов СКЦ "; label18.Text = ""; DBReference dbref = new DBReference(); Statistics.DataSource = dbref.GetBooksWithRemovedResponsibility(); if (this.Statistics.Rows.Count == 0) { this.Statistics.Columns.Clear(); MessageBox.Show("Нет выданных книг!"); return; } autoinc(Statistics); Statistics.Columns[0].HeaderText = "№№"; Statistics.Columns[0].Width = 40; Statistics.Columns[1].HeaderText = "Заглавие"; Statistics.Columns[1].Width = 250; Statistics.Columns[2].HeaderText = "Автор"; Statistics.Columns[2].Width = 130; Statistics.Columns[3].HeaderText = "Номер читате льского билета"; Statistics.Columns[3].Width = 70; Statistics.Columns[4].HeaderText = "Фамилия"; Statistics.Columns[4].Width = 100; Statistics.Columns[5].HeaderText = "Имя"; Statistics.Columns[5].Width = 80; Statistics.Columns[6].HeaderText = "Отчество"; Statistics.Columns[6].Width = 80; Statistics.Columns[7].HeaderText = "Штрихкод"; Statistics.Columns[7].Width = 80; Statistics.Columns[8].HeaderText = "Дата выдачи"; Statistics.Columns[8].ValueType = typeof(DateTime); Statistics.Columns[8].DefaultCellStyle.Format = "dd.MM.yyyy"; Statistics.Columns[8].Width = 85; Statistics.Columns[9].HeaderText = "Дата снятия ответственности"; Statistics.Columns[9].DefaultCellStyle.Format = "dd.MM.yyyy"; Statistics.Columns[9].Width = 85; Statistics.Columns[10].HeaderText = "Фонд"; Statistics.Columns[10].Width = 80; button12.Enabled = true; }
private void всеКнигиЦентраАмериканскойКультурыToolStripMenuItem_Click(object sender, EventArgs e) { Statistics.Columns.Clear(); //Statistics.Columns.Add("NN", "№ п/п"); Statistics.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; Statistics.RowTemplate.DefaultCellStyle.WrapMode = System.Windows.Forms.DataGridViewTriState.True; Statistics.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; //DatePeriod f3 = new DatePeriod(); //f3.ShowDialog(); label19.Text = "Список всех документов СКЦ + ОФ"; label18.Text = ""; DBReference dbref = new DBReference(); Statistics.DataSource = dbref.GetAllBooks(); if (this.Statistics.Rows.Count == 0) { this.Statistics.Columns.Clear(); MessageBox.Show("Нет книг!"); return; } autoinc(Statistics); Statistics.Columns[0].Width = 70; Statistics.Columns[0].HeaderText = "№№"; Statistics.Columns[1].HeaderText = "Заглавие"; Statistics.Columns[1].Width = 500; Statistics.Columns[2].HeaderText = "Автор"; Statistics.Columns[2].Width = 200; Statistics.Columns[3].HeaderText = "Штрихкод"; Statistics.Columns[3].Width = 100; Statistics.Columns[4].HeaderText = "База"; Statistics.Columns[4].Width = 150; Statistics.Columns[5].HeaderText = "Инв. номер"; Statistics.Columns[5].Width = 150; Statistics.Columns[6].HeaderText = "Тематика"; Statistics.Columns[6].Width = 150; Statistics.Columns[7].HeaderText = "Язык"; Statistics.Columns[7].Width = 150; Statistics.Columns[8].HeaderText = "Наименование фонда или коллекции"; Statistics.Columns[8].Width = 150; button12.Enabled = true; }
private void обращаемостьКнигToolStripMenuItem_Click(object sender, EventArgs e) { Statistics.Columns.Clear(); //Statistics.Columns.Add("NN", "№ п/п"); Statistics.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; Statistics.RowTemplate.DefaultCellStyle.WrapMode = System.Windows.Forms.DataGridViewTriState.True; Statistics.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; //DatePeriod f3 = new DatePeriod(); //f3.ShowDialog(); label19.Text = "Обращаемость документов СКЦ "; label18.Text = ""; DBReference dbref = new DBReference(); Statistics.DataSource = dbref.GetBookNegotiability(); if (this.Statistics.Rows.Count == 0) { this.Statistics.Columns.Clear(); MessageBox.Show("Нет выданных книг!"); return; } autoinc(Statistics); Statistics.Columns[0].Width = 70; Statistics.Columns[0].HeaderText = "№№"; Statistics.Columns[1].HeaderText = "Заглавие"; Statistics.Columns[1].Width = 500; Statistics.Columns[2].HeaderText = "Автор"; Statistics.Columns[2].Width = 200; Statistics.Columns[3].HeaderText = "Штрихкод"; Statistics.Columns[3].Width = 100; Statistics.Columns[4].HeaderText = "Обращаемость"; Statistics.Columns[4].Width = 100; Statistics.Columns[5].HeaderText = "Фонд"; Statistics.Columns[5].Width = 70; button12.Enabled = true; }
private void просроченныеКнигиToolStripMenuItem_Click(object sender, EventArgs e) { Statistics.Columns.Clear(); //Statistics.Columns.Add("NN", "№ п/п"); Statistics.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; Statistics.RowTemplate.DefaultCellStyle.WrapMode = System.Windows.Forms.DataGridViewTriState.True; Statistics.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; //DatePeriod f3 = new DatePeriod(); //f3.ShowDialog(); label19.Text = "Список просроченных документов на текущий момент"; label18.Text = ""; DBReference dbref = new DBReference(); Statistics.DataSource = dbref.GetAllOverdueBook(); if (this.Statistics.Rows.Count == 0) { this.Statistics.Columns.Clear(); MessageBox.Show("Просроченных выдач нет!"); return; } autoinc(Statistics); Statistics.Columns[0].HeaderText = "№№"; Statistics.Columns[0].Width = 40; Statistics.Columns[1].HeaderText = "Заглавие"; Statistics.Columns[1].Width = 220; Statistics.Columns[2].HeaderText = "Автор"; Statistics.Columns[2].Width = 100; Statistics.Columns[3].HeaderText = "Номер читате льского билета"; Statistics.Columns[3].Width = 70; Statistics.Columns[4].HeaderText = "Фамилия"; Statistics.Columns[4].Width = 100; Statistics.Columns[5].HeaderText = "Имя"; Statistics.Columns[5].Width = 80; Statistics.Columns[6].HeaderText = "Отчество"; Statistics.Columns[6].Width = 80; Statistics.Columns[7].HeaderText = "Штрихкод"; Statistics.Columns[7].Width = 75; Statistics.Columns[8].HeaderText = "Дата выдачи"; Statistics.Columns[8].ValueType = typeof(DateTime); Statistics.Columns[8].DefaultCellStyle.Format = "dd.MM.yyyy"; Statistics.Columns[8].Width = 85; Statistics.Columns[9].HeaderText = "Предпо лагаемая дата возврата"; Statistics.Columns[9].DefaultCellStyle.Format = "dd.MM.yyyy"; Statistics.Columns[9].Width = 85; Statistics.Columns[10].Visible = false; Statistics.Columns[10].ValueType = typeof(bool); Statistics.Columns[11].HeaderText = "Дата последней отправки email"; Statistics.Columns[11].DefaultCellStyle.Format = "dd.MM.yyyy"; Statistics.Columns[11].Width = 85; Statistics.Columns[12].HeaderText = "Расстановочный шифр"; Statistics.Columns[12].Width = 85; Statistics.Columns[13].HeaderText = "Фонд"; Statistics.Columns[13].Width = 50; foreach (DataGridViewRow r in Statistics.Rows) { object value = r.Cells[10].Value; if (Convert.ToBoolean(value) == true) { r.DefaultCellStyle.BackColor = Color.Yellow; } } button12.Enabled = true; }