readerbookadvancedsearch.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_ReaderBookAdvancedSearch : 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类的AdvancedSearch方法查询书刊信息
        GridView1.DataBind();
    }
}