protected void Button1_Click(object sender, EventArgs e)
{
string s_id = l_id.Text;
SqlServerHelper Sql = new SqlServerHelper();
var con = Sql.CreateCon();
con.Open();
var trans = con.BeginTransaction();
string sql = string.Format("update tushu set zhuangtai=N'已借阅' where id={0}", s_id);
con.ExecuteSql(sql, trans);
sql = string.Format("insert into jieshu(tushu_id,zhanghao) values({0},'{1}')", s_id, Session["账号"]);
con.ExecuteSql(sql, trans);
trans.Commit();
Response.Write("<script>alert('借阅图书成功');window.location.href='jieshu.aspx';</script>");
}
protected void Button1_Click(object sender, EventArgs e)
{
string s_id = l_id.Text;
SqlServerHelper Sql = new SqlServerHelper();
var con = Sql.CreateCon();
con.Open();
var trans = con.BeginTransaction();
string sql = string.Format("update tushu set zhuangtai=null where id={0}", s_id);
con.ExecuteSql(sql, trans);
sql = string.Format("update jieshu set hsrq=getdate() where tushu_id={0} and hsrq is null", s_id);
con.ExecuteSql(sql, trans);
trans.Commit();
Response.Write("<script>alert('归还图书成功');window.location.href='huanshu.aspx';</script>");
}