viewbook.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;

public partial class WebPages_ViewBook : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request.QueryString["aim"] != null)
            {
                if (Request.QueryString["aim"].ToString() == "book")
                {
                    if (Request.QueryString["book"] != null)
                    {
                        BindToDLBook();
                    }
                }
                else if (Request.QueryString["aim"].ToString() == "kind")
                {
                    BindToDLBookList();
                }
            }
        }
        if (Session["UserNo"].ToString() == "")
        {
            BtnBooking.Visible = false;
            BtnBorrow.Visible = false;
        }
        else
        {
            BtnBooking.Visible = true;
            BtnBorrow.Visible = true;
        }
    }

    private void BindToDLBook()
    {
        DataSet ds = new DataSet();
        string blid = Request.QueryString["book"].ToString();
        InfoOperate dp = new InfoOperate();
        string sRet = dp.getBookList(ref ds, "bl", 0, "", "", "BLID", blid);
        PanelKind.Visible = false;
        PanelBook.Visible = true;
        if (sRet == "")
        {
            BookDetail.DataSource = ds.Tables["bl"].DefaultView;
            BookDetail.DataBind();
        }
        
    }
    protected void BtnBorrow_Click(object sender, EventArgs e)
    {
        //借阅
        string blid = Request.QueryString["book"].ToString();
        string userid = Session["UserNo"].ToString();
        UserControl uc = new UserControl();
        string sRet = uc.bookOP(userid, blid, "borrow");
        if (sRet == "")
        {
            Response.Write("<script>alert('借阅成功！');location.replace('MyLibrary.aspx');</script>");
        }
    }
    protected void BtnBooking_Click(object sender, EventArgs e)
    {
        //预约
        string blid = Request.QueryString["book"].ToString();
        string userid = Session["UserNo"].ToString();
        UserControl uc = new UserControl();
        string sRet = uc.bookOP(userid, blid, "booking");
        if (sRet == "")
        {
            Response.Write("<script>alert('预约成功！');location.replace('MyLibrary.aspx');</script>");
        }
    }

    private void BindToDLBookList()
    {
        int PageSize = 15;
        string dsName = "book";
        DataSet ds = new DataSet();
        getResult(ref ds);
        if (ds!=null)
        {
            if (PageSize != 0)
            {
                //分页
                PanelPages.Visible = true;
                LBFinalPage.Visible = true;
                LBFirstPage.Visible = true;
                LBPrePage.Visible = true;
                LBNextPage.Visible = true;
                LabelTotalPage.Visible = true;
                LabelPageNo.Visible = true;
                Label1.Visible = true;
                Label2.Visible = true;
                Label3.Visible = true;
                Label4.Visible = true;


                PagedDataSource ps = new PagedDataSource();
                int PageNo = Convert.ToInt32(LabelPageNo.Text.ToString());

                ps.DataSource = ds.Tables[dsName].DefaultView;
                ps.AllowPaging = true;
                ps.PageSize = 6;
                ps.CurrentPageIndex = PageNo - 1;

                LBFinalPage.Enabled = true;
                LBFirstPage.Enabled = true;
                LBNextPage.Enabled = true;
                LBPrePage.Enabled = true;

                if (ps.IsFirstPage)
                {
                    //判断是否为首页
                    LBFirstPage.Enabled = false;
                    LBPrePage.Enabled = false;
                    if (ps.PageCount == 1)
                    {
                        LBFinalPage.Enabled = false;
                        LBNextPage.Enabled = false;
                    }
                }
                if (ps.IsLastPage)
                {
                    //判断是否为末页
                    LBFinalPage.Enabled = false;
                    LBNextPage.Enabled = false;
                }

                DLBookList.DataSource = ps;

                DLBookList.DataKeyField = "BLID";
                DLBookList.DataBind();

                LabelTotalPage.Text = ps.PageCount.ToString();
            }
            else
            {
                //不分页
                PanelPages.Visible = false;
                LBFinalPage.Visible = false;
                LBFirstPage.Visible = false;
                LBPrePage.Visible = false;
                LBNextPage.Visible = false;
                LabelTotalPage.Visible = false;
                LabelPageNo.Visible = false;
                Label1.Visible = false;
                Label2.Visible = false;
                Label3.Visible = false;
                Label4.Visible = false;

                DLBookList.DataSource = ds.Tables[dsName].DefaultView;
                DLBookList.DataKeyField = "BLID";
                DLBookList.DataBind();
            }
        }
        PanelKind.Visible = true;
        PanelBook.Visible = false;
    }

    protected void LBFirstPage_Click(object sender, EventArgs e)
    {
        //显示首页
        LabelPageNo.Text = "1";
        BindToDLBookList();
    }
    protected void LBPrePage_Click(object sender, EventArgs e)
    {
        //显示上一页
        LabelPageNo.Text = Convert.ToString(Convert.ToInt32(LabelPageNo.Text.ToString()) - 1);
        BindToDLBookList();
    }
    protected void LBNextPage_Click(object sender, EventArgs e)
    {
        //显示下一页
        LabelPageNo.Text = Convert.ToString(Convert.ToInt32(LabelPageNo.Text.ToString()) + 1);
        BindToDLBookList();
    }
    protected void LBFinalPage_Click(object sender, EventArgs e)
    {
        //显示末页
        LabelPageNo.Text = LabelTotalPage.Text;
        BindToDLBookList();
    }

    private void getResult(ref DataSet ds)
    {
        InfoOperate dp = new InfoOperate();
        string bkid = Request.QueryString["kind"].ToString();
        string sRet = dp.getBookList(ref ds, "book", 0, "order", "", "BookKind.BKID", bkid);
        if (sRet == "")
        {
            showSearch("kind");
        }
        else
        {
            showSearch("search");
        }
    }

    private void showSearch(string mode)
    {
        switch (mode)
        {
            case "book":
                PanelBook.Visible = true;
                PanelKind.Visible = false;
                PanelPages.Visible = false;
                break;
            case "kind":
                PanelBook.Visible = false;
                PanelKind.Visible = true;
                PanelPages.Visible = true;
                break;
            default:
                PanelBook.Visible = false;
                PanelKind.Visible = false;
                PanelPages.Visible = false;
                break;
        }
    }
}