mylibrary.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_MyLibrary : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if(!IsPostBack)
        {
            if (Session["UserNo"].ToString() == "")
            {
                ShowPanelX(0);
            }
            else
            {
                if (Request.QueryString["tab"] != null)
                {
                    int num = Convert.ToInt32(Request.QueryString["tab"].ToString());
                    ShowPanelX(num);
                }
                else
                {
                    ShowPanelX(8);
                }
            }
            PanelPage.Visible = false;
        }

    }

    protected void ShowPanelX(int num)
    {
        //选择显示的版块
        switch (num)
        {
            case 0://登陆窗口
                Panel0.Visible = true;
                Panel1.Visible = false;;
                Panel2.Visible = false;
                Panel3.Visible = false;
                Panel4.Visible = false;
                Panel5.Visible = false;
                Panel6.Visible = false;
                Panel7.Visible = false;
                break;
            case 1://读者信息
                Panel0.Visible = false;
                Panel1.Visible = true;
                Panel2.Visible = false;
                Panel3.Visible = false;
                Panel4.Visible = false;
                Panel5.Visible = false;
                Panel6.Visible = false;
                Panel7.Visible = false;
                getReaderInfo();
                break;
            case 2://借阅信息
                Panel0.Visible = false;
                Panel1.Visible = false;
                Panel2.Visible = true;
                Panel3.Visible = false;
                Panel4.Visible = false;
                Panel5.Visible = false;
                Panel6.Visible = false;
                Panel7.Visible = false;
                //getBorrowInfo();
                BindToGridViewBorrow();
                break;
            case 3://借阅历史
                Panel0.Visible = false;
                Panel1.Visible = false;
                Panel2.Visible = false;
                Panel3.Visible = true;
                Panel4.Visible = false;
                Panel5.Visible = false;
                Panel6.Visible = false;
                Panel7.Visible = false;
                getBoredInfo();
                break;
            case 4://预约情况
                Panel0.Visible = false;
                Panel1.Visible = false;
                Panel2.Visible = false;
                Panel3.Visible = false;
                Panel4.Visible = true;
                Panel5.Visible = false;
                Panel6.Visible = false;
                Panel7.Visible = false;
                getBookingList();
                break;
            case 5://违章欠款
                Panel0.Visible = false;
                Panel1.Visible = false;
                Panel2.Visible = false;
                Panel3.Visible = false;
                Panel4.Visible = false;
                Panel5.Visible = true;
                Panel6.Visible = false;
                Panel7.Visible = false;
                getArrearsInfo();
                break;
            case 6://书刊遗失
                Panel0.Visible = false;
                Panel1.Visible = false;
                Panel2.Visible = false;
                Panel3.Visible = false;
                Panel4.Visible = false;
                Panel5.Visible = false;
                Panel6.Visible = true;
                Panel7.Visible = false;
                getBookLoss();
                break;
            case 7://读者挂失
                Panel0.Visible = false;
                Panel1.Visible = false;
                Panel2.Visible = false;
                Panel3.Visible = false;
                Panel4.Visible = false;
                Panel5.Visible = false;
                Panel6.Visible = false;
                Panel7.Visible = true;
                setReaderLoss();
                break;
            default:
                Panel0.Visible = false;
                Panel1.Visible = true;
                Panel2.Visible = false;
                Panel3.Visible = false;
                Panel4.Visible = false;
                Panel5.Visible = false;
                Panel6.Visible = false;
                Panel7.Visible = false;
                getReaderInfo();
                break;
        }
    }

    protected void BindToDataList(DataList dl, DataSet ds, string dsName, int PageSize, string keyField)
    {
        //绑定到DataList控件
        if (PageSize != 0)
        {
            //分页
            showPageLabel(1);

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

            ps.DataSource = ds.Tables[dsName].DefaultView;
            ps.AllowPaging = true;
            ps.PageSize = PageSize;
            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;
            }

            dl.DataSource = ps;

            dl.DataKeyField = keyField;
            dl.DataBind();

            LabelTotalPage.Text = ps.PageCount.ToString();
        }
        else
        {
            //不分页
            showPageLabel(0);

            dl.DataSource = ds.Tables[dsName].DefaultView;
            dl.DataKeyField = keyField;
            dl.DataBind();
        }
    }

    private void showPageLabel(int show)
    {
        //是否显示分页面板元素
        if (show == 1)
        {
            //显示
            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;
        }
        else
        {
            //不显示
            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;
        }
    }

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

    protected void getReaderInfo()
    {
        //获取读者个人信息
        string userID = Session["UserNo"].ToString();
        UserControl user = new UserControl();
        DataSet ds = new DataSet();
        string sRet = user.GetUserDetail(userID, ref ds, "reader");
        if (sRet == "")
        {
            BindToDataList(DLReaderInfo, ds, "reader", 0, "UserID");
        }
        else
        { }
    }

    //protected void getBorrowInfo()
    //{
    //    //获取借阅信息
    //    string userID = Session["UserNo"].ToString();
    //    UserControl user = new UserControl();
    //    DataSet ds = new DataSet();
    //    string sRet = user.GetMyBook(userID, ref ds, "borrow", "borrow");
    //    if (sRet == "")
    //    {
    //        BindToDataList(DLBorrowInfo, ds, "borrow",0, "BSID");
    //    }
    //    else
    //    {
    //    }
    //}

    protected void getBoredInfo()
    {
        //获取借阅历史信息
        string userID = Session["UserNo"].ToString();
        UserControl user = new UserControl();
        DataSet ds = new DataSet();
        string sRet = user.GetMyBook(userID, ref ds, "borHis", "all");
        if (sRet == "")
        {
            BindToDataList(DLBored, ds, "borHis", 0, "BSID");
        }
        else
        {
        }
    }

    protected void getBookingList()
    {
        //获取预约信息
        string userID = Session["UserNo"].ToString();
        UserControl user = new UserControl();
        DataSet ds = new DataSet();
        string sRet = user.GetBookingList(userID, ref ds, "booking", "all");
        if (sRet == "")
        {
            BindToDataList(DLBooking, ds, "booking", 0, "BingID");
        }
        else
        {
        }
    }

    protected void getArrearsInfo()
    {
        //获取违章欠款信息
        string userID = Session["UserNo"].ToString();
        UserControl user = new UserControl();
        DataSet ds = new DataSet();
        int count = 0;
        string sRet = user.GetArrearsInfo(userID, ref ds, "arrears", "all",ref count);
        if (sRet == "")
        {
            if (count == 0)
            {
                PanelNoArrears.Visible = true;
                PanelArrears.Visible = false;
            }
            else
            {
                PanelNoArrears.Visible = false;
                PanelArrears.Visible = true;
                BindToDataList(DLArrears, ds, "arrears", 0, "PL");
            }
        }
        else
        {
            PanelNoArrears.Visible = false;
            PanelArrears.Visible = false;
        }
    }

    protected void getBookLoss()
    {
        //获取书刊遗失记录
        string userID = Session["UserNo"].ToString();
        UserControl user = new UserControl();
        DataSet ds = new DataSet();
        string sRet = user.GetMyBook(userID, ref ds, "booklose", "loss");
        if (sRet == "")
        {
            BindToDataList(DLBookLoss, ds, "booklose", 0, "BSID");
        }
        else
        {
        }
    }

    protected void setReaderLoss()
    {
        //获取读者挂失信息
        string userID = Session["UserNo"].ToString();
        
        if (UserControl.ReaderLossCheck(userID))
        {
            PanelSetLoss.Visible = false;
            PanelLosed.Visible = true;
            LabelLoss.Text = "您的证件已经完成挂失！请等候处理！";
        }
        else
        {
            PanelLosed.Visible = false;
            PanelSetLoss.Visible = true;
        }
    }

    protected void BtnLose_Click(object sender, EventArgs e)
    {
        string userID = Session["UserNo"].ToString();
        string userPwd = LxEnCode.EnCode(TBPwd.Text.ToString());
        if (UserControl.PasswordCheck(userID, userPwd))
        {
            UserControl user = new UserControl();
            string sRet = user.setReaderLoss(userID);
            if (sRet == "")
            {
                PanelSetLoss.Visible = false;
                PanelLosed.Visible = true;
                LabelLoss.Text = "您的证件已经完成挂失！请等候处理！";
            }
            else
            {
                PanelSetLoss.Visible = false;
                PanelLosed.Visible = true;
                LabelLoss.Text = "挂失失败，请重试。。。";
            }
        }
    }

    protected void ShowAll()
    {
        getArrearsInfo();
        getBookingList();
        getBookLoss();
        getBoredInfo();
        //getBorrowInfo();
        BindToGridViewBorrow();
        getReaderInfo();
        setReaderLoss();
    }

    protected void BtnConBook_Click(object sender, EventArgs e)
    {
        //归还图书
        string userID = Session["UserNo"].ToString();
        UserControl user = new UserControl();
        int count = GridViewBorrow.Rows.Count;
        int del = 0;
        UserControl uc = new UserControl();

        for (int i = 0; i < count; i++)
        {
            bool chk = ((CheckBox)GridViewBorrow.Rows[i].FindControl("Chk_Select")).Checked;
            if (chk == true)
            {
                string bsid = GridViewBorrow.DataKeys[i].Values[0].ToString();

                string ret = uc.returnBook(bsid);

                if (ret == "")
                {
                    del++;
                }
                else
                {
                    Response.Write("<script>alert('发生错误！" + ret + "'); window.location.href('MyLibrary.aspx?tab=2');</script>");
                    break;
                }
            }
        }
        

        BindToGridViewBorrow();

    }

    private void BindToGridViewBorrow()
    {
        string userID = Session["UserNo"].ToString();
        UserControl user = new UserControl();
        DataSet ds = new DataSet();
        string sRet = user.GetMyBook(userID, ref ds, "borrow", "borrow");

        showPageLabel(0);

        GridViewBorrow.DataSource = ds.Tables["borrow"].DefaultView;
        string[] keys = { "BSID" };
        GridViewBorrow.DataKeyNames = keys;
        GridViewBorrow.DataBind();

    }
    protected void BtnModPwd_Click(object sender, EventArgs e)
    {
        Session["flag"] = "";
        Response.Redirect("UserModify.aspx?set=0");
    }
    protected void BtnModInfo_Click(object sender, EventArgs e)
    {
        Session["flag"] = 1;
        Response.Redirect("UserModify.aspx?set=1");        
    }
}