Partial Class _Default Inherits System.Web.UI.Page Private Shared ReadOnly cs As String =

最新推荐文章于 2020-02-15 14:19:29 发布

「已注销」

最新推荐文章于 2020-02-15 14:19:29 发布

阅读量217

点赞数

本文链接：https://blog.csdn.net/eds124/article/details/87829582

版权


Partial Class _Default
    Inherits System.Web.UI.Page

    Private Shared ReadOnly cs As String = "Data Source=.;Initial Catalog=master;User ID=sa;Password=Abcdefg1"
    Private Shared ReadOnly sql As String = "select count(*) from t_user where username = @username and userpass = @userpass"

    Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init
        If Request.Cookies("username") Is Nothing Or Request.Cookies("userpass") Is Nothing Then
            Return
        End If
        Dim username As String = HttpUtility.HtmlDecode(Request.Cookies("username").Value)
        Dim userpass As String = HttpUtility.HtmlDecode(Request.Cookies("userpass").Value)
        Using sds As SqlDataSource = New SqlDataSource(_Default.cs, _Default.sql)
            sds.SelectParameters.Add("username", username)
            sds.SelectParameters.Add("userpass", userpass)
            Dim i As Integer = DirectCast(sds.Select(DataSourceSelectArguments.Empty), System.Data.DataView)(0)(0)
            If i = 0 Then
                Return
            End If
        End Using
        Response.Redirect("~/Index.aspx")
    End Sub

    Protected Sub Login1_Authenticate(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.AuthenticateEventArgs) Handles Login1.Authenticate
        Dim username As String = Me.Login1.UserName.Trim().ToLower()
        Dim userpass As String = Me.Login1.Password.Trim().ToLower()
        Dim b As Boolean = Me.Login1.RememberMeSet
        Using sds As SqlDataSource = New SqlDataSource(_Default.cs, _Default.sql)
            sds.SelectParameters.Add("username", username)
            sds.SelectParameters.Add("userpass", userpass)
            Dim i As Integer = DirectCast(sds.Select(DataSourceSelectArguments.Empty), System.Data.DataView)(0)(0)
            If i = 0 Then
                Return
            End If
        End Using
        Response.Cookies("username").Value = HttpUtility.UrlEncode(username)
        Response.Cookies("userpass").Value = HttpUtility.UrlEncode(userpass)
        If b Then
            Response.Cookies("username").Expires = DateTime.Now.AddDays(7) '设置cookie超时时间为7天
            Response.Cookies("userpass").Expires = DateTime.Now.AddDays(7)
        End If
        Response.Redirect("~/Index.aspx") '登录成功跳转
    End Sub
End Class