Site1.Master.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
namespace 在线考试
{
    public partial class Site1 : System.Web.UI.MasterPage
    {
        SQLHelper db = new SQLHelper();
        protected void Page_Load(object sender, EventArgs e)
        {
            //
            if (!IsPostBack)
            {
                if (Session["zh"] == null)
                {
                    this.Panel1.Visible = true;
                    this.Panel2.Visible = false;
                }
                else
                {
                        this.Panel1.Visible = false;
                        this.Panel2.Visible =true;
                        this.lb_session.Text = Session["zh"].ToString();     
                }
            }
            //
        }

        protected void bt_login_Click(object sender, EventArgs e)
        {
            string zh = this.txt_zh.Text.ToString();
            string password = this.txt_mima.Text.ToString();
             string sql = "select * from hy where username='" + zh + "' and password='" + password + "'";
                DataTable dt = db.ExecuteQuery(sql, CommandType.Text);
                int count = dt.Rows.Count;
                if (count == 0)
                {
                    Response.Write("<script language=javascript>alert('帐号密码不正确！');</script>");
                }
                else
                {
                    Session["zh"] = dt.Rows[0]["username"].ToString();
                    Session["hy_id"] = dt.Rows[0]["hy_id"].ToString();
                    Session["depart_id"] = dt.Rows[0]["depart_id"].ToString();
                    Session["name"] = dt.Rows[0]["name"].ToString();
                    Response.Redirect("index.aspx");
                }
           
            //
        }
    }
}