第三周 ---登入

实体

?public class UserModel
??? {?????
??????? public string UserName { set; get; }
??????? public string UserPassword { set; get; }
??? }

DAL

public bool UserValidate(UserModel entity)
??????? {
??????????? bool isPass = false;
??????????? string sqlText = "select count(*) from ContactUser where UserName=@u and UserPassword=@p";

??????????? int t = 0;
??????????? using (SqlConnection conn = new SqlConnection(connStr))
??????????? {
??????????????? SqlCommand cmd = new SqlCommand(sqlText, conn);

??????????????? DaoHelper.AddParameter(cmd, "@u", entity.UserName);
??????????????? DaoHelper.AddParameter(cmd, "@p", entity.UserPassword);
??????????????? conn.Open();
??????????????? t = (int)cmd.ExecuteScalar();
??????????? }
??????????? if (t > 0)
??????????? {
??????????????? isPass = true;
??????????? }
??????????? return isPass;
??????? }

页面

?

??????????????? var dal = new UserDAL();
??????????????? var model = new UserModel();???
??????????????? string u = txtUserName.Text;
?????????
??????????????? model.UserName = txtUserName.Text;
??????????????? model.UserPassword = txtUserPassword.Text;
??????????????? if (dal.UserValidate(model))
??????????????? {
??????????????????? FormsAuthentication.SetAuthCookie(u, false);
??????????????????? //Response.Write("认证通过");
??????????????????? Response.Redirect("/index.aspx");
??????????????? }
??????????????? else
??????????????? {
??????????????????? throw new Exception("用户名密码错误");
??????????????? }

?

继承控制访问

??????? 需验证页继承此类

?

??????????????? 在回发数据已加载到页服务器控件之后但在 OnLoad 事件之前，引发 PreLoad 事件。

????????? 重载PreLoad

???????? protected override void OnPreLoad(EventArgs e)
??????? {
??????????? base.OnPreLoad(e);
??????????? LoginGuard();

??????? }

?

???????? private bool _CheckLogin = true;

??????? //是否验证默认为True

????????? public bool CheckLogin
??????? {
??????????? get { return _CheckLogin; }
??????????? set { _CheckLogin = value; }

?

?

?????? //已经验证通过或不必要验证则pass

??????????????? protected virtual void LoginGuard()
??????? {
??????????? if (!User.Identity.IsAuthenticated && CheckLogin)
??????????????? Response.Redirect("/Login.aspx");
??????? }

????? 登入页不必验证则

????? public Login()
??????? {
??????????? CheckLogin = false;
??????? }

?