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; width: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>"; } } }
网页显示: