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;
Statistics.Columns[9].HeaderText = "Стеллаж";
Statistics.Columns[9].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.GetViolators();
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 = 70;
Statistics.Columns[2].HeaderText = "Фамилия";
Statistics.Columns[2].Width = 120;
Statistics.Columns[3].HeaderText = "Имя";
Statistics.Columns[3].Width = 120;
Statistics.Columns[4].HeaderText = "Отчество";
Statistics.Columns[4].Width = 120;
Statistics.Columns[5].Visible = false;
Statistics.Columns[6].HeaderText = "Дата последней отправки email";
Statistics.Columns[6].Width = 150;
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.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;
}
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.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;
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 = 40;
Statistics.Columns[1].HeaderText = "����� ������ ������� ������";
Statistics.Columns[1].Width = 70;
Statistics.Columns[2].HeaderText = "�������";
Statistics.Columns[2].Width = 120;
Statistics.Columns[3].HeaderText = "���";
Statistics.Columns[3].Width = 120;
Statistics.Columns[4].HeaderText = "��������";
Statistics.Columns[4].Width = 120;
Statistics.Columns[5].Visible = false;
Statistics.Columns[6].HeaderText = "���� ��������� �������� email";
Statistics.Columns[6].Width = 150;
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.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;
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;
}