loging.aspx.cs

程序学生信息管理系统(SQL2000+ASP.NET+c#+)

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Drawing;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using SMS;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
SMS.OPDataBase OP = new OPDataBase();
protected void Page_Load(object sender, EventArgs e)
{
    this.Label1.Visible = false; 
}
protected void Button1_Click(object sender, EventArgs e)
{
    string userID = this.TextBox1.Text.Trim();
    string  password = this.TextBox2.Text.Trim();
    //获得用户名和密码
    string sqlstr = " Select * from Users where UserID= '"+userID +"' and  Password ='" +password +"'";
    SqlDataReader dr;

     dr = OP.getDataReader(sqlstr);
    //验证用户
         if (IsValid == true)
         {
             if (dr.Read())
             {
                 Session["UserID"] = dr["UserID"];
                 Session["Power"] = dr["Power"];

             //判断权限
                 switch ((int)  Session["Power"])
                 { 
                     case 0:
                      Response.Redirect("Index.aspx");
                      Response.Write("0");
                         break;
                     case 1:
                         Response.Redirect("Index.aspx");
                         Response.Write("1");
                         break ;
                     case  2:
                         Response.Redirect("Index.aspx");
                         Response.Write("2");
                         break;

                 
                 }

             }
             else
             {
                 this.Label1.Text = "用户名和密码不正确";
             }
         }
         else
         {
             this.Label1.Text = "请输入用户名和密码！";
             this.Label1.Style ["Color"] ="red" ;

         }
         this.Label1.Visible = true;

    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        this.TextBox1.Text = "";
        this .TextBox2 .Text ="";
        this .Label1 .Text ="";
    }
}