验证函数：
Dim e As RequestEventArgs = args(0)
Dim path As RequestEventArgs = args(1)
Dim UserId As String
Dim sb As New StringBuilder
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
If UserId > "" then'授权成功
e.AppendCookie("userid",UserId) '将userid和username存储在Cookie中
Return UserId
ElseIf e.GetValues.ContainsKey("code") = False Then '如果授权失败,且不是通过授权链接跳转而来,那么就跳转到授权链接
Dim ul1 As String = "https://open.weixin.qq.com/connect/oauth2/authorize?appid={0}&redirect_uri={1}&response_type=code&scope=snsapi_base&state={2}#wechat_redirect"
Dim ul2 As String = UrlEncode("http://wx.tt.com.cn/" & path)
ul1 = CExp(ul1,"wxc47938dd3fd523d4",ul2,"123")
sb.Append("<meta http-equiv='Refresh' c>") '跳转到授权链接
e.WriteString(sb.ToString)
Return ""
End If
kq函数：
Dim e As RequestEventArgs = args(0)
Dim wb As New weui
Dim cmd As New SQLCommand
Dim dt As DataTable
cmd.C
cmd.CommandText = "SELECT * From {wxkq}"
dt = cmd.ExecuteReader
Dim userid = Functions.Execute("order",e,"kq.htm")
If userid > "" Then
With wb.AddTable("","Table1")
'按日期顺序列出考勤明细
.CreateFromDataTable(dt,False,"userid ='" & UserId & "'","日期","姓名","日期","星期","t1","t2")
End With
e.WriteString(wb.Build)
End If
加好友 
发短信
Post By：2017/11/30 16:09:00 [显示全部帖子]
