以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- 网页授权接口 异步函数 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=124199) |
-- 作者:133198609 -- 发布时间:2018/9/1 15:55:00 -- 网页授权接口 异步函数 3、Foxtable端的HttpRequst事件代码为: If e.host = "wexin.foxtable.com" Then \'需要授权才能访问的域名 Dim UserId As String Dim UserName As String Dim sb As New StringBuilder sb.AppendLine("<meta name=\'viewport\' c>") If e.GetValues.ContainsKey("code") Then \'如果通过授权链接跳转而来,就根据传递过来的code参数调用接口,获取用户的UserId Dim ul As String = "https://qyapi.weixin.qq.com/cgi-bin/user/getuserinfo?access_token={0}&code={1}" ul = CExp(ul,Functions.Execute("GetQYAccessToken"),e.GetValues("code")) Dim hc As new HttpClient(ul) Dim jo As JObject = JObject.Parse(hc.GetData) If jo("UserId") IsNot Nothing Then UserId = jo("UserId") End If Else UserId = e.Cookies("userid") \'否则从cookie中提取userid和username End If Dim Verified As Boolean Dim dr As DataRow = DataTables("Users").Find("userid =\'" & UserId & "\'") \'根据openid找出对应的行 If UserId > "" AndAlso dr IsNot Nothing AndAlso dr("permit") = True \'授权成功 Verified = True UserName = dr("name") e.AppendCookie("userid",UserId) \'将userid和username存储在Cookie中 ElseIf e.GetValues.ContainsKey("code") = False Then \'如果授权失败,且不是通过授权链接跳转而来,那么就跳转到授权链接 Dim ul As String = "https://open.weixin.qq.com/connect/oauth2/authorize?appid=wxa31aba4cd83af57e&redirect_uri=http%3a%2f%2fwexin.foxtable.com&response_type=code&scope=snsapi_base&state=123#wechat_redirect" sb.Append("<meta http-equiv=\'Refresh\' c>") \'跳转到授权链接 e.WriteString(sb.ToString) Return End If If Verified = False Then sb.AppendLine("你无权访问本系统") Else sb.AppendLine("欢迎" & UserName & " , <a href=\'http://wexin.foxtable.com\'>刷新页面</a>") End If e.WriteString(sb.ToString) End If 像这种网页授权的服务器,可以用异步函数么? 按帮助这种直接放HttpRequst事件里面,同时访问的用户数多的情况服务器会不会卡死?
|
-- 作者:有点蓝 -- 发布时间:2018/9/1 16:04:00 -- 可以,DataTables("Users").Find改为使用sqlcommand查询 |