/**
*
* CREATE TRIGGER no_price ON book_table
* FOR INSERT
* AS
* IF(
* (
* SELECT COUNT(*) FROM inserted
* WHERE inserted.price<0
*
* )>0
*
* )
*
* raiserror('价格不能小于0',16,11)
* rollback TRANSACTION;
**/
protected void insert_book_Click(object sender, EventArgs e)//添加书籍信息
{
book_tableTableAdapter adprbook = new book_tableTableAdapter();
int id = Int32.Parse(TextBox_bookid.Text);
string name = TextBox_bookname.Text;
string writer = TextBox_writer.Text;
string publisher = TextBox_publisher.Text;
int left = Int32.Parse(TextBox_left.Text);
float price = float.Parse(TextBox_price.Text);
int floor = Int32.Parse(TextBox_floor.Text);
int shelve = Int32.Parse(TextBox_shelve.Text);
try
{
locationTableAdapter locationadpr = new locationTableAdapter();
adprbook.InsertQuery(id, name, writer, publisher, left, price);
locationadpr.InsertQuery(id, floor, shelve);
bookGridView.DataBind();
}
catch (Exception exp)
{
bookinsertMsg.Text = exp.Message;
//bookinsertMsg.Text = "输入数据错误";
bookinsertMsg.Visible = true;
//return;
}
}
protected void delete_book(object sender, EventArgs e)//删除单个书籍记录
{
Button btn = (Button)sender;
string id = btn.CommandArgument;
int bookid = Int32.Parse(id);
book_tableTableAdapter bookadpr = new book_tableTableAdapter();
locationTableAdapter locationadpr = new locationTableAdapter();
try
{
locationadpr.DeleteQuery(bookid);
bookadpr.DeleteQuery(bookid);
bookGridView.DataBind();
}
catch
{
Label_delete_book.Text = "不能删除有借阅记录的书";
Label_delete_book.Visible = true;
}
}
