SearchBook.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class SearchBook : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //判断用户是否查询，如果没有查询，而直接跳到该页的话，则返回主页
            if (Session["SearchKey"].ToString() != "")
            {
                try
                {
                    //执行此方法,用于数据源的绑定与分页功能。
                    fill();
                }
                catch
                {
                    //发生错误,则返回主页
                    Response.Redirect("Default.aspx");
                }
            }
            else Response.Redirect("Default.aspx");
        }
    }
    public void fill()
    {
        string select;
        //如果查找类型为书名
        if (Session["SearchBookType"].ToString() == "书名")
        {
            //构建查询语句。
            select = string.Format("select BookName as 书名,BookID as 图书ID,BookPrice as 价格,BookAddress as 出版社,BookPeople as 作者 from BookInfo where BookName like '%{0}%'", Session["SearchKey"].ToString());
        }
        //如果查找类型是作者
        else if (Session["SearchBookType"].ToString() == "作者")
        {
            //构建查询语句。
            select = string.Format("select BookName as 书名,BookID as 图书ID,BookPrice as 价格,BookAddress as 出版社,Bookpeople as 作者 from BookInfo where BookPeople like '%{0}%'", Session["SearchKey"].ToString());
        }
        //如果查找类型是其他的
        else
        {
            //构建查询语句。
            select = string.Format("select BookName as 书名,BookID as 图书ID,BookPrice as 价格,BookAddress as 出版社,BookPeople as 作者 from BookInfo where BookID like '%{0}%'", Session["SearchKey"].ToString());
        }
        //设置分页
        PagedDataSource ps = new PagedDataSource();
        //设置分页数据源。