readerman.aspx.cs

这是一个很好的图书管理系统 数据库SQL2005

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 ReaderMan : System.Web.UI.Page
{
    BLL.T_Reader read = new BLL.T_Reader();

    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            //验证Session对象，判断用户是否登陆
            if (Session["UserID"].ToString() == "" || Session["UserID"].ToString() == null || Session["Level"].ToString() != "1")
            {
                Response.Redirect("Login.aspx");
                return;
            }
        }
        //Session对象未初始化，跳转登陆页面。
        catch (NullReferenceException)
        {
            Response.Redirect("Login.aspx");
        }
        lbl_UserName.Text = Session["UserName"].ToString();
        if (!IsPostBack)
        {
            GridView1.DataSource = read.SelectReader();
            GridView1.DataBind();
        }
    }

    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        DataBind();
    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        DataBind();
    }

    new private void DataBind()
    {
        //查询读者信息，绑定到GridView
        GridView1.DataSource = read.SelectReader(txtkey.Text);
        GridView1.DataBind();
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        PublicClass.ReaderModel reader = new PublicClass.ReaderModel();
        //获取读者ID
        reader.ReaderID = int.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString());
        read.Reader = reader;
        int re = read.DeleteReader();
        switch (re)
        {
            case 1:
                this.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('删除成功')</script>");
                DataBind();
                break;
            case 0:
                this.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('删除失败')</script>");
                break;
        }
    }
}