adminbookadvancedsearch.aspx.cs

一个使用ASP。net和SQLServer2005开发的图书管理系统

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MyLibrary.DataAccessHelper;
using MyLibrary.DataAccessLayer;
using MyLibrary.BusinessLogicLayer;

public partial class BookManage_AdminBookAdvancedSearch : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        GridViewBind();
    }

    private void GridViewBind()
    {
        Hashtable ht = new Hashtable();
        if (txtBookID.Text.Trim() != "")
        {
            ht.Add("BookID", int.Parse(txtBookID.Text.Trim()));
        }
        if (txtBookName.Text.Trim() != "")
        {
            ht.Add("BookName", txtBookName.Text.Trim());
        }
        if (txtBookISBN.Text.Trim() != "")
        {
            ht.Add("BookISBN",txtBookISBN.Text.Trim());
        }
        if (txtBookAuthor.Text.Trim() != "")
        {
            ht.Add("BookAuthor", txtBookAuthor.Text.Trim());
        }
        if (txtBookPublish.Text.Trim() != "")
        {
            ht.Add("BookPublish", txtBookPublish.Text.Trim());
        }
        if (txtBookSubject.Text.Trim() != "")
        {
            ht.Add("BookSubject", txtBookSubject.Text.Trim());
        }

        DataBase db = new DataBase(); 		//实例化一个Database类
        GridView1.DataSource = db.AdvancedSearch("[Book]", ht);	//利用Database类的GetDataRow方法查询用户数据
        GridView1.DataBind();
    }

    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int bookID = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); //取出要删除记录的主键值
        Book book = new Book();
        if (book.DeleteByProc(bookID))
        {
            Response.Write("<script language=javascript>alert('删除成功!')</script>");
        }
        else
        {
            Response.Write("<script language=javascript>alert('删除失败!')</script>");
        }
        GridView1.EditIndex = -1;
        GridViewBind();
    }
}