private void btnIssuance_Click(object sender, EventArgs e) { int libCard, book; DateTime begin, end; string status = "Выдано"; begin = dtpB.Value; end = dtpE.Value; if (begin > end) { MessageBox.Show("Дата выбрана неверно!", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { libCard = Convert.ToInt32(cbReader.SelectedValue); book = Convert.ToInt32(cbBook.SelectedValue); string qCount = "select Count from booksInfo where id_booksInfo=" + book; int c = Queries.ExecuteReader(qCount, 0); if (c > 0) { string qIss = "insert into issuanceBooks values (" + libCard + ", " + book + ", '" + begin + "', '" + end + "', '" + status + "')"; string qInst = "update booksInfo set Count = Count-1 where id_booksInfo=" + book; Queries.ExecuteNonQuery(qIss); Queries.ExecuteNonQuery(qInst); Filler.LoadDgv(dgvIssuance); MessageBox.Show("Операция произведена успешно", "", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Книги нет в наличии или она удалена из библиофонда!", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }
public MainForm() { InitializeComponent(); Filler.FillReaders(cbReader); Filler.FillBooks(cbBook); Filler.LoadDgv(dgvIssuance); DataGridViewButtonColumn dgvbc = new DataGridViewButtonColumn(); dgvbc.Name = "dgvbc"; dgvbc.HeaderText = "Изменить"; dgvbc.Text = "Выбрать"; dgvbc.UseColumnTextForButtonValue = true; dgvbc.DefaultCellStyle.SelectionBackColor = Properties.Settings.Default.ButtonBlue; dgvbc.DefaultCellStyle.BackColor = Properties.Settings.Default.ButtonGreen; dgvIssuance.Columns.Add(dgvbc); }
private void button1_Click(object sender, EventArgs e) { Filler.LoadDgv(dgvIssuance); Filler.FillBooks(cbBook); Filler.FillReaders(cbReader); }