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 login : System.Web.UI.Page
{

    
   
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
          
            //获取用户端的Cookie值，查看是否以前访问过。
            HttpCookie objGetCookie = Request.Cookies["BlueHill"];

            String strLoginName = "";

            if (objGetCookie != null)
            {

                //如果以前访问过，则获取以前保存的用户名。
                strLoginName = objGetCookie.Values["LoginName"];
                txtLoginName.Text = strLoginName;
            }

        }

    }
    protected void cmdLogin_Click(object sender, EventArgs e)
    {

        string zhangh = "";
        zhangh = txtLoginName.Text.ToString();

        //SqlConnection conn = db.ljsjk();
        //conn.Open();
        //SqlCommand comm = new SqlCommand("select * from denglubiao where zhanghao='" + zhh + "'", conn);//查询密码用于比较
        //SqlDataReader dr = comm.ExecuteReader();
        //dr.Read();

        SqlConnection conn = db.mysqll();
        conn.Open();
        SqlCommand comm = new SqlCommand("select * from 员工表 where 员工登录名='" + zhangh + "'", conn);//查询密码用于比较
        SqlDataReader dr = comm.ExecuteReader();
        dr.Read();





        if (dr.HasRows == true)
        {
            string logonpw=txtPassword.Text.Trim();
            string pw= dr["员工密码"].ToString();
            if (logonpw == pw)
            {
                Session["LogonName"] = txtLoginName.Text;

                string strLoginName = txtLoginName.Text;
               

                

                //新建一个客户端的Cookie 值。
                HttpCookie objNewCookie = new HttpCookie("BlueHill");

                //设定 Cookie 的有效日期
                objNewCookie.Expires = DateTime.Now.AddDays(30);

                //添加 Cookie 子项。
                objNewCookie.Values.Add("LoginName", strLoginName);

                //将 Cookie 值写入客户端
                Response.Cookies.Add(objNewCookie);

                //从数据库中获取该登录名所对应的员工编号。

                string iEmpID = dr["员工编号"].ToString();

                //在会话间保存该编号信息。
                Session["EmployeeID"] = iEmpID.ToString();

                string sID = iEmpID.ToString();
                
                if (FormsAuthentication.GetRedirectUrl(sID, false).IndexOf("default.aspx") == -1)
                {
                    //如果用户试图访问其他网页，则跳转到该网页。
                    FormsAuthentication.RedirectFromLoginPage(sID, false);
                }
                else
                {
                    //如果用户访问的是登录网页，则跳转到“显示员工信息”网页。
                    FormsAuthentication.SetAuthCookie(sID, false);
                    Response.Redirect("EmployeeInfo/ShowEmpInfo.aspx");
                }

              
            }
            else
            {
                lblInfo.Text = "密码错误，请重试！";
            }
        }
        else
        {
            lblInfo.Text = "用户不存在，请重试！";   
        }
        dr.Close();
       
    }       
    
}