图书管理页面代码.docVIP

管理页面的代码 protected void gvBook_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { LinkButton lbDelete = e.Row.Cells[0].Controls[0] as LinkButton; if (lbDelete != null) { lbDelete.OnClientClick = return confirm(确实要删除《 +e.Row .Cells [2].Text + 》么); } } } protected void btnSeek_Click(object sender, EventArgs e) { SqlDataSourceBook .SelectCommand =string.Format(select * from v_book where BookName like %{0}%, txbBookName.Text); // select *　from v_book where BookName like %+txbBookName .Text +% gvBook.DataBind(); } protected void gvBook_RowDeleteing(object sender, GridViewDeleteEventArgs e) { string bookid = gvBook.Rows[e.RowIndex].Cells[1].Text; string cmdtext= string .Format (select count(* ) from t_orderDetail where bookid={0},bookid) ; if (SqlHelper.ReturnValue(cmdtext).ToString() != 0) { e.Cancel = true; Response.Write(scriptalert(该图书不允许删除)/script); } else { cmdtext = string.Format(select bookimage from t_book where bookid={0}, bookid); string imagefilename= SqlHelper.ReturnValue(cmdtext).ToString (); string imagefilename1 = @~/bookimage/ + imagefilename; if(System .IO .File .Exists (Server .MapPath ( imagefilename1) )) { if(imagefilename1 .ToLower ()!= @~/bookimage/no.jpg) System .IO.File .Delete (Server .MapPath (imagefilename1 )); } } } protected void btnSeek_Click(object sender, EventArgs e) { string cmdtext = string.Format( select count(*) from t_book where Bookisbn ={0}, txbBookISBN.Text); if (SqlHelper.ReturnValue(cmdtext).ToString() == 0) { PanelAddBook.Visible = true; PanelAddQuantity.Visible = false; }