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;
    }
}