专家坐堂-内部函数Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

Dim e As RequestEventArgs = args(0)

Static UserTable As DataTable \'定义一个变量,用于存储用户随机身份ID,以及最后一次活动时间.

Static ClearTime As Date

If UserTable Is Nothing Then \'创建用于记录登录信息的临时表

ClearTime = Date.Now()

Dim dtb As New DataTableBuilder("UserInfos")

dtb.AddDef("UserName", Gettype(String), 255)

dtb.AddDef("UserID",Gettype(String),16)

dtb.AddDef("ActiveTime",Gettype(Date))

UserTable = dtb.Build(True)

End If

If (Date.Now - ClearTime).TotalMinutes >= 30 Then \'清除超过30分钟没有操作的登录信息

UserTable.DeleteFor("ActiveTime < #" & Date.Now.AddMinutes(-30) & "#")

ClearTime = Date.Now()

End If

Dim wb As New weui

\'身份验证

Dim UserName As String

Dim Password As String

Dim UserID As String

If e.Path = "logon.htm" \'验证用户名和密码

If e.PostValues.ContainsKey("username") AndAlso e.PostValues.ContainsKey("password") Then

Dim Verified As Boolean \'用于标记用户是否通过了身份验证

UserName = e.PostValues("username")

Password = e.PostValues("password")

Dim dr1 As DataRow \'数据库对比用户代码

dr1 = DataTables("users").sqlFind("Name = \'" & UserName & "\'")

If dr1 IsNot Nothing AndAlso dr1("password").contains(password) Then

Verified = True

End If

If Verified Then

UserID = Rand.NextString(16) \'生成随机用户ID

UserName = EncryptText(UserName,"123","123") \'将用户名加密.

Dim dr As DataRow = UserTable.Find("UserName = \'" & UserName & "\'")

If dr IsNot Nothing Then \'如果是重复登录,删除以前的登录信息

dr.Delete()

End If

dr = UserTable.AddNew()

dr("UserName") = UserName

dr("UserID") = UserId

dr("ActiveTime") = Date.Now \'记录登录时间

wb.AppendCookie("username",UserName) \'将用户名和密码写入cookie

wb.AppendCookie("userid",UserID)

wb.InsertHTML("<meta http-equiv=\'Refresh\' c>") \'直接跳转到首页

e.WriteString(wb.Build) \'生成网页

Return"" \'必须的

End If

Else \'其它页面从Cookie提取登录信息进行验证

UserName = e.Cookies("username") \'从cookie中获取用户名

UserID = e.Cookies("userid") \'从cookie中获取随机ID

Dim dr As DataRow = UserTable.Find("UserName = \'" & UserName & "\'")

If dr IsNot Nothing AndAlso dr("UserID") = UserID Then \'如果通过验证,更新活动时候,继续访问其它页面.

dr("ActiveTime") = Date.Now \'更新活动时间

Else \'如果验证失败

wb.InsertHTML("<meta http-equiv=\'Refresh\' c>") \'那么直接跳转到登录页面

e.WriteString(wb.Build) \'生成网页

Return"" \'必须的

End If

\'开始生成网页

Select Case e.path

Case "logon.htm" \'登录页面

wb.AddPageTitle("","pageheader","管理系统","")

If e.PostValues.ContainsKey("username") AndAlso e.PostValues.ContainsKey("password") Then \'判断是否是验证失败后的重新登录

wb.AddTopTips("","toptip1","用户名或密码错误!").msec = 2000 \'如果用户通过登录按钮访问,则给用户一个2秒的提示.

End If

wb.AddForm("","form1","logon.htm")

With wb.AddInputGroup("form1","ipg1")

.AddInput("username","户名","text")

.AddInput("password","密码","password")

End With

With wb.AddButtonGroup("form1","btg1",True)

.Add("btn1", "登录", "submit")

End With

Case "exit.htm" \'退出登录

wb.DeleteCookie("username") \'清除cookie中原来的用户名和密码

wb.DeleteCookie("password")

wb.InsertHTML("<meta http-equiv=\'Refresh\' c>") \'然后直接跳转到登录页面

Case "", "default.htm" \'首页

wb.AddPageTitle("","pageheader","管理系统","")

With wb.AddGrid("","g1")

.Add("c1","测试", "./images/png-1549.png").Attribute = ""

.Add("c2","暂未开通", "./images/png-1550.png").Attribute = ""

.Add("c3","暂未开通", "./images/png-1551.png").Attribute = ""

.Add("c4","暂未开通", "./images/png-1552.png").Attribute = ""

.Add("c5","暂未开通", "./images/png-1553.png").Attribute = ""

.Add("c6","暂未开通", "./images/png-1554.png").Attribute = ""

.Add("c7","暂未开通", "./images/png-1555.png"). Attribute = ""

.Add("c8","暂未开通", "./images/png-1556.png").Attribute = ""

.Add("c12","退出", "./images/png-0670.png", "exit.htm") \'退出登录

End With

End Select

e.WriteString(wb.Build) \'生成网页