WB 例子审核登录

前台HTML代码：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DengLu.aspx.cs" Inherits="DengLu" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
    <style>
    .dl {
        margin:0px auto;
        padding:0px;
        left:400px;
        304px ;
        height:358px;
    }

</style>
</head>
<body>
    <form id="form1" runat="server">
    <div  class="dl">
    <h2>      </h2>
        <h2>      登录界面</h2>
        <p> </p>
        <p> 
            <asp:Label ID="Label1" runat="server" Text="用户名:"></asp:Label>
             
            <asp:TextBox ID="txtUserName" runat="server"></asp:TextBox>
        </p>
        <p> </p>
        <p>  
            <asp:Label ID="Label2" runat="server" Text="密码:"></asp:Label>
             
            <asp:TextBox ID="txtPassWork" runat="server"></asp:TextBox>
             </p>
        <p>      </p>
        <p>        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="登录" />
            <asp:Literal ID="Literal1" runat="server"></asp:Literal>
        </p>
    </div>
        
    </form>
</body>
</html>

　　后台C#代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

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

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        TestDataContext context = new TestDataContext();
        //取值
        string uid = txtUserName.Text;
        string pwd = txtPassWork.Text;
        //查数据库  查询这两条数据是否跟数据库匹配
        var query = context.Users.Where(p => p.UserName == uid && p.PassWord == pwd);
        //判断集合里面数据的条数
        if (query.Count() > 0)
        {
            //如果用户名和密码正确 再看一下状态
            //取出这条数据
            int state = query.First().State;
            if (state == 0)
            {
                Literal1.Text = "<script type='text/javascript'>alert('用户名未审核');</script>";
            }
            else if (state == 1)
            {
                //再session里面存上用户名
                Session["uid"] = uid;
                Response.Redirect("Main.aspx");
            }
            else
            {
                Literal1.Text = "<script type='text/javascript'>alert('用户名审核失败');</script>";
            }



            //再session里面存上用户名
            //Session["uid"] = uid;
            //Response.Redirect("Main.aspx");
        }
        else
        {
            Literal1.Text = "<script type='text/javascript'>alert('用户名或密码错误');</script>";
        }
    }
}

　　网页显示：

WB 例子 审核 登录

WB 例子审核登录