login.aspx.cs

asp.net 的某物流管理系统 MIS 系统

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.OleDb;
using System.Text;

////该源码首发自www.51aspx.com(５1aｓｐｘ．ｃｏｍ)

public partial class liuyan_Login : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    public OleDbDataReader Loginusername(string sName)
    {
        string myConnectionString = ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING1"].ConnectionString + Server.MapPath("~") + ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING3"].ConnectionString;
        OleDbConnection myConnection = new OleDbConnection(myConnectionString);
        string cmdText = "SELECT * FROM Myuser WHERE Myusername='" + sName + "'";
        OleDbCommand myCommand = new OleDbCommand(cmdText, myConnection);
        OleDbDataReader dr = null;
        try
        {
            myConnection.Open();
            dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
        }
        catch (OleDbException ex)
        {
            throw new Exception(ex.Message, ex);
        }
        return dr;
    }
    public string Myencode(string spass)
    {
        Encoding utfstr = Encoding.UTF7;
        byte[] utfstrByte = utfstr.GetBytes(spass.Trim());
        string mima = BitConverter.ToString(utfstrByte);
        return mima;
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        string myname = txtUsername.Text.ToString().Trim();
        string mypass = Myencode(txtPassword.Text.ToString().Trim());
        //非空验证
        if ((myname.Length < 1)||(mypass.Length<1))
        {
            return;
        }
        OleDbDataReader dr = Loginusername(myname);
        string strtemp = "";
        //登陆
        if (dr.Read())
        {
            strtemp = dr["Mypassword"].ToString();
        }
        //设置登陆标志
        if (strtemp==mypass)
        {
            Session["Leaveword"] = "pass";   
            dr.Close();
            Response.Redirect("Viewleavwords.aspx");
        }
        else
        {
            lblNote.Text = "用户名和密码错误";
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        if (Panel1.Visible)
        {
            Panel1.Visible = false;
        }
        else
        {
            Panel1.Visible = true;
        }
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        string myname = txtName.Text.ToString().Trim();
        string mypass = Myencode(txtPass.Text.ToString().Trim());
        //非空
        if ((myname.Length < 1) || (mypass.Length < 1))
        {
            return;
        }

        OleDbDataReader dr = Loginusername(myname);
        string strtemp = "";
        //登陆
        if (dr.Read())
        {
            strtemp = dr["Mypassword"].ToString();
        }
        //设置登陆标志
        if (strtemp == mypass)
        {
            dr.Close();
            if (txtPass1.Text.Trim() == txtPass2.Text.Trim())
            {
                string sRemima = Myencode(txtPass1.Text.ToString().Trim());
                Updatemima(myname, sRemima);
                lblNote1.Text = "修改成功！";
            }
            else
            {
                lblNote1.Text = "两次输入的新密码不一致";
                return;
            }
        }
        else
        {
            lblNote.Text = "用户名和密码错误";
        }
    }
    //修改密码
    private void Updatemima(string sName,string sMima)
    {
        string myConnectionString = ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING1"].ConnectionString + Server.MapPath("~") + ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING3"].ConnectionString;
        OleDbConnection myConnection = new OleDbConnection(myConnectionString);
        string cmdText = "UPDATE Myuser SET Mypassword='" + sMima + "' WHERE Myusername='"+sName+"'";
        OleDbCommand myCommand = new OleDbCommand(cmdText, myConnection);
        try
        {
            myConnection.Open();
            myCommand.ExecuteNonQuery();
        }
        catch (OleDbException ex)
        {
            throw new Exception(ex.Message, ex);
        }
        finally
        {
            myConnection.Close();
        }
    }
}