memberlogin.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 UserControl_MemberLogin : System.Web.UI.UserControl
{
    SqlConnection sqlconn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["MName"] != null)
            {
                Panel1.Visible = true;
                Panel2.Visible = false;
                MName.Text = Session["MName"].ToString();
            }
        }
    }
    protected void btnLogin_Click(object sender, EventArgs e)
    {
        sqlconn.Open();
        SqlCommand sqlcom = new SqlCommand("proMemberInfo", sqlconn);
        sqlcom.CommandType = CommandType.StoredProcedure;
        sqlcom.Parameters.Add("@MemberName", SqlDbType.VarChar, 20).Value = txtMName.Text.Trim();
        sqlcom.Parameters.Add("@MemberPwd", SqlDbType.VarChar, 20).Value = txtMPwd.Text.Trim();
        SqlDataReader read = sqlcom.ExecuteReader();
        if (read.Read())
        {
            Panel1.Visible = true;
            Panel2.Visible = false;
            MName.Text = txtMName.Text;
            Session["MName"] = txtMName.Text.Trim();
        }
        else
        {
            Response.Write("<script>alert('您输入的用户名或密码错误，请重新输入！');location='javascript:history.go(-1)';</script>");
        }
    }
    protected void lbtnLogout_Click(object sender, EventArgs e)
    {
        Panel1.Visible = false;
        Panel2.Visible = true;
        txtMName.Text = "";
        txtMPwd.Text = "";
        FormsAuthentication.SignOut();//清除验证信息
        HttpContext.Current.Session.Clear();//清除Session内容
        HttpContext.Current.Session.Abandon();//取消当前会话
    }
}