protected void btnborrow_Click(object sender, EventArgs e)//借阅书籍按钮
{
borrowMsg.Visible = false;
Label1.Visible = false;
Button btn = (Button)sender;
//int row = ((GridViewRow)((Button)sender).NamingContainer).RowIndex;
string id = btn.CommandArgument;
Session["id"] = id; //获取书籍id
int bookid = Int32.Parse(id);
int nameid = Int32.Parse(Session["txtname"].ToString());
string time = DateTime.Now.ToString();
int days = 90;
string return_time = DateTime.Now.AddDays(days).ToString();
borrowTableAdapter adprbook = new borrowTableAdapter();
book_tableTableAdapter adpr = new book_tableTableAdapter();
usersTableAdapter adpruser = new usersTableAdapter();
var data = adpr.GetDataBy(bookid);//获取剩余书本量
var singledata = data.Single();
int left = singledata.left;
var userdata = adpruser.GetDataBy(nameid);//获取余额
var singleuserdate = userdata.Single();
double wallet = singleuserdate.wallet;
double cost = days * 0.01;
if (left == 0)// 书籍剩余量为0，借阅失败
{
Label1.Text = "剩余量为0，无法借阅";
Label1.Visible = true;
}
else
{
if (wallet < cost) //余额不足 借阅失败
{
Label1.Text = "余额不足";
Label1.Visible = true;
}
else
{
try
{
adprbook.InsertQuery(bookid, nameid, time, 90, return_time);
GridView3.Visible = true;
left = left - 1;
adpr.Updateleft(left, bookid);
GridView3.DataBind(); //刷新借阅信息
GridView1.DataBind(); //刷新书籍信息
wallet = wallet - cost;
adpruser.walletupdate(wallet, nameid);
GridView2.DataBind(); //刷新个人信息
}
catch //已经借阅了此书，借阅失败
{
Label1.Text = "已经借阅了此书，不能重复借阅";
Label1.Visible = true;
GridView3.Visible = true;
}
}
}
}
