login.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 Mylibrary : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void LoginBt_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            DataControl.ConnectionControl conn = new DataControl.ConnectionControl();
            conn.DataConnetion();
            SqlCommand cmd = conn.DataCmd("UserLogin");
            // cmd.CommandText = "UserLogin";//存储过程身份验证
            //cmd.Connection = conn;
            cmd.CommandType = CommandType.StoredProcedure;
            SqlParameter ParaUserID = new SqlParameter("@UserID", SqlDbType.Char, 10);//command的参数
            ParaUserID.Value = this.tbUserID.Text.Trim();
            cmd.Parameters.Add(ParaUserID);

            SqlParameter ParaPassword = new SqlParameter("@Password", SqlDbType.VarChar, 20);
            ParaPassword.Value = this.tbPassword.Text.ToString().Trim();
            cmd.Parameters.Add(ParaPassword);

            SqlParameter ParaRoleID = new SqlParameter("@RoleID", SqlDbType.Int);
            ParaRoleID.Value = Request["Role"].ToString();
            cmd.Parameters.Add(ParaRoleID);

            SqlDataReader dr;
            try
            {
                // conn.Open();
                dr = cmd.ExecuteReader();
                if (dr.Read())
                {

                    Session.Add("UserID", tbUserID.Text);//Session加入两个字段。
                    Session.Add("BookID", "");
                    if (dr[6].ToString() == "1")
                        Response.Redirect("StuManage.aspx");//进入学生 页面
                    else
                        if (dr[6].ToString() == "2")
                            Response.Redirect("AdmManage.aspx");//进入管理员页面

                }
                else
                {
                    Message.Text = "ID或密码错误！";
                }
            }
            catch (Exception e2)
            {
                Response.Write(e2.Message.ToString());
            }
            finally
            {
                conn.Close();
            }


        }
    }
    
    protected void CancleBt_Click(object sender, EventArgs e)
    {
        tbUserID.Text = "";
        tbPassword.Text = "";
    }
    
}