login.aspx.cs

来自「邮件发送系统」· CS 代码 · 共 44 行

using System;
using System.Data;
using System.Data.SqlClient;
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;

public partial class Login : System.Web.UI.Page
{
    SqlConnection sqlconn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    //========================判断用户登录=====================================
    protected void btnLogin_Click(object sender, EventArgs e)
    {
        sqlconn.Open();
        SqlCommand sqlcom = new SqlCommand("proUserLogin", sqlconn);
        sqlcom.CommandType = CommandType.StoredProcedure;
        sqlcom.Parameters.Add("@UserName", SqlDbType.VarChar, 50).Value = txtAName.Text.Trim();
        sqlcom.Parameters.Add("@UserPwd", SqlDbType.VarChar, 50).Value = txtPwd.Text.Trim();
        SqlDataReader reader = sqlcom.ExecuteReader();
        if (reader.Read())
        {
            Session["UserName"] = txtAName.Text.Trim();
            Page.Response.Redirect("SendMail.aspx");
        }
        else
        {
            Response.Write("<script lanuage=javascript>alert('用户名或密码有误！');location='Login.aspx'</script>");
        }
        sqlconn.Close();
    }
    protected void btnExit_Click(object sender, EventArgs e)
    {
        Response.Write("<script lanuage=javascript>window.close()</script>");
    }
}