searchbookby.aspx.cs

一个简单的图书管理系统,赋有设计的说明书。可以实现一般的管理操作。

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 System.Data.SqlClient;

public partial class SearchBookBy : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //绑定数据List           
        if (!IsPostBack)
        {
            string connstr = "server=localhost;Database=library1;User ID=sa;Password=''";
            SqlConnection conn = new SqlConnection(connstr);
            conn.Open();

            SqlDataAdapter SqlDAdpt = new SqlDataAdapter("select * from BookClass", conn);
            DataSet ds = new DataSet();
            SqlDAdpt.Fill(ds);
            if (ds.Tables[0].Rows.Count > 0)
            {
                this.BCList.DataSource = ds;//把ds绑定在TyleList上
                this.BCList.DataTextField = "ClassName";//显示Classname列
                this.BCList.DataValueField = "ClassID";///值为ClassID列
                this.BCList.DataBind();//显示
            }
            conn.Close();

        }
    }
    protected void Button1_Click(object sender, EventArgs e)//查询按钮
    {
        
        string sql = "select BookID 书号,ISBN,BookName 书名,Author 作者,PublishDate 出版日期,ClassName 分类名字 from BookInfo as a join BookClass as b on a.ClassID=b.ClassID where a.ClassID='" + BCList.SelectedValue.ToString().Trim() + "'";
        if (tbISBN.Text != "")//如果ISBN不为空,加入sql的where中
            sql += " and ISBN='" + tbISBN.Text.Trim() + "'";
        if (tbBN.Text != "")//如果BookName不为空,加入sql的where中
            sql += " and BookName='" + tbBN.Text.Trim() + "'";
        if (tbAth.Text != "")//如果Author不为空,加入sql的where中
            sql += " and Author='" + tbAth.Text.Trim() + "'";
        string connstr = "server=localhost;Database=library1;User ID=sa;Password=''";
        SqlConnection conn = new SqlConnection(connstr);
        conn.Open();
        DataSet ds = new DataSet();
        SqlDataAdapter sqlDAdpt = new SqlDataAdapter(sql, conn);
        sqlDAdpt.Fill(ds);

        if (ds.Tables[0].Rows.Count != 0)
        {
            GridView1.Visible = true;
            GridView1.DataSource = ds;
            GridView1.DataBind();
            Label3.Text = "以上是您查询的结果，请到图书馆去借书！";
        }
        else
        {
            GridView1.Visible = false;
            Label3.Text = "抱歉，没有你要找的书！";

        }
        conn.Close();

      
    }
}