//添加书籍信息
private void button1_Click(object sender, EventArgs e)
{
StringBuilder binfo = new StringBuilder();
binfo.Append(book_id.Text.ToString() + ",");
binfo.Append("'" + name.Text.ToString() + "'" + ",");
binfo.Append("'" + author.Text.ToString() + "'" + ",");
binfo.Append("'" + publish.Text.ToString() + "'" + ",");
binfo.Append("'" + introduction.Text.ToString() + "'" + ",");
binfo.Append("'" + price.Text.ToString() + "'" + ",");
binfo.Append("'" + pubdate.Value.ToShortDateString() + "'" + ",");
binfo.Append(class_id.Text.ToString() + ",");
if (radioButton1.Checked)
{
binfo.Append("0，");
}
else
{
binfo.Append("1,");
}
binfo.Append(book_count.Text.ToString());
try
{
if (Bookhelp.AddBookinfo(binfo.ToString()))
{
MessageBox.Show("添加书籍信息成功");
}
}
catch (Exception ex)
{
MessageBox.Show("必须保证图书编号，名称，作者，\n出版社，价格，可借数量不为空");
}
}
private void button2_Click(object sender, EventArgs e)
{
if (Userhelp.Lend_num() > 0)
{
if (Bookhelp.Have_book(click_book))
{
if (Bookhelp.LendBook(click_book) && Userhelp.User_lend())
{
MessageBox.Show("借书成功！");
Userhelp.Record_Lend(click_book);
}
else
{
MessageBox.Show("借书失败！");
}
}
else
{
MessageBox.Show("此书余量不足！");
}
}
else
{
MessageBox.Show("可借次数不足！");
}
}
//修改图书信息
private void change_book_Click(object sender, EventArgs e)
{
string state = "";
if (radioButton1.Checked)
{
state = "0";
}
else
{
state = "1";
}
try
{
Bookhelp.UpdateBook(textBox5.Text.ToString(), textBox4.Text.ToString(), textBox3.Text.ToString(),
textBox2.Text.ToString(), introduction.Text.ToString(),
price.Text.ToString(), pubdate.Value.ToString(), class_id.Text.ToString(), state, book_count.Text.ToString());
MessageBox.Show("更新成功");
init_gridview();
ClearTextBox();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//删除所选图书
private void button3_Click(object sender, EventArgs e)
{
try
{
Bookhelp.DeleteBook(textBox5.Text.ToString());
MessageBox.Show("删除成功");
init_gridview();
ClearTextBox();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
string id = "";
string bookAuthor = "";
string bookName = "";
string press = "";
try
{
switch (comboBox1.SelectedItem.ToString())
{
case "书名":
bookName = textBox1.Text.ToString();
break;
case "图书编号":
id = textBox1.Text.ToString();
break;
case "作者":
bookAuthor = textBox1.Text.ToString();
break;
case "出版社":
press = textBox1.Text.ToString();
break;
default:
MessageBox.Show("请勿修改选项");
break;
}
}
catch (Exception ex)
{
MessageBox.Show("请勿修改选项");
}
DataTable data = Bookhelp.QueryBook(id, bookAuthor, bookName, press);
if (data.Rows.Count > 0)
{
lendbookview.DataSource = data;
}
else
{
MessageBox.Show("查无此书");
}
}
private void button1_Click(object sender, EventArgs e)
{
if (!sernum.Equals(""))
{
if (Userhelp.Back_book(sernum))
{
Userhelp.update_ustate();
bookcount = Bookhelp.BookNum(bookid);
bookcount++;
Bookhelp.UpdateBook_lend(bookid, bookcount.ToString());
MessageBox.Show("还书成功！");
init_grid();
lend_num.Text = Userhelp.Lend_num().ToString();
}
else
{
MessageBox.Show("本书已归还！请勿重复操作！");
}
}
else
{
MessageBox.Show("没有选择的书目！");
}
}
private void InitStatistic()
{
Statistic.DataSource = Bookhelp.Statistic();
}
private void InitBookTop()
{
bookTop.DataSource = Bookhelp.BookTop();
}
