www.pudn.com > WEBrsgl6.20.rar > login.ascx.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 Controls_login : System.Web.UI.UserControl 
{ 
   
    String SqlConnectionString = "database=PersonalManagement;server=(local);user id=sa"; 
    protected void Page_Load(object sender, EventArgs e) 
    { 
        if (!IsPostBack) 
        { 
            if (Request.Cookies["UserSettings"] != null) 
            { 
                if (Request.Cookies["UserSettings"]["id"] != null) 
                { 
                    Session["id"] = Request.Cookies["UserSettings"]["id"]; 
                    Session["pass"] = Request.Cookies["UserSettings"]["pass"]; 
                    Label1.Text = Session["id"].ToString(); 
                    Label2.Text = Session["pass"].ToString(); 
                }                 
            } 
        } 
 
    } 
 
    protected void Button1_Click1(object sender, EventArgs e) 
    { 
        SqlConnection sql = new SqlConnection(SqlConnectionString); 
        sql.Open(); 
        string cmd = "select EmpPassword,EmployeeId,EmpName,shengyuHolidays from Employees where EmpLogin=@EmpLogin"; 
        SqlCommand sqlcmd = new SqlCommand(cmd, sql); 
        sqlcmd.Parameters.Add("@EmpLogin", SqlDbType.VarChar, 20); 
        sqlcmd.Parameters[0].Value = txtLogin.Text; 
        SqlDataReader sqlread = sqlcmd.ExecuteReader(); 
       if (sqlread.Read()) 
        { 
 
            string a = sqlread.GetValue(0).ToString(); 
            Session["EmployeeId"] = sqlread.GetValue(1).ToString(); 
            Session["EmpName"] = sqlread.GetValue(2).ToString(); 
            Session["shengyuHolidays"] = sqlread.GetValue(3).ToString(); 
           if (txtPass.Text == sqlread.GetValue(0).ToString()) 
            {  
                int b = Convert.ToInt32(DropDownList1.Text); 
                HttpCookie myCookie = new HttpCookie("UserSettings"); 
                myCookie["id"] = txtLogin.Text; 
                myCookie["pass"] = txtPass.Text; 
                myCookie.Expires = DateTime.Now.AddDays(b); 
                Response.Cookies.Add(myCookie); 
                //传值到各个模块 
                Session["emplogin"] = txtLogin.Text; 
                Response.Redirect("Default.aspx"); 
            } 
            else 
                Label1.Text = "帐号或者密码错误！！"; 
             
        } 
        else 
            Label1.Text = "帐号或者密码错误！！"; 
 
    } 
    protected void Button2_Click(object sender, EventArgs e) 
    { 
        Label1.Text = DropDownList1.Text; 
    } 
}