加了,还是到这一步
If e.GetValues.ContainsKey("tjr") Then
[此贴子已经被作者于2024/6/14 17:41:23编辑过]
If e.GetValues.ContainsKey("tjr") Then 到这一步过不去,没到保存就跳过去了
dr("客户来源_KHID") = e.GetValues("tjr")
dr.Save
End If
老师我改过来了,还是走不过去?哪里不对么?
Dim sb
As New StringBuilder
sb.AppendLine("<meta
name='viewport'
c>")
If e.host = "wexin.foxtable.com" Then '授权测试
Dim UserName As String Dim OpenID
As String
If
e.GetValues.ContainsKey("code") Then '如果是通过授权链接跳转而来,就从链接重提取code来获取openid
Dim ul As String =
"https://api.weixin.qq.com/sns/oauth2/access_token?appid={0}&secret={1}&code={2}&grant_type=authorization_code"
ul = CExp(ul,"wx8acdb7df5beb68fd","dec0df8a469518df30e9bdef0758c678",e.GetValues("code"))
Dim hc As new HttpClient(ul)
Dim
jo As JObject = JObject.Parse(hc.GetData)
If jo("openid") IsNot
Nothing Then
'如果获取openid成功(成功的话,还会同时返回一个accesstiken,用于获取用户详情)
OpenID = jo("openid")
Dim dr As DataRow =
DataTables("WXUsers").Find("openid ='"
& Openid &
"'")
If dr IsNot Nothing Then
UserName = dr("nickname") Else ul = "https://api.weixin.qq.com/sns/userinfo?access_token={0}&openid={1}&lang=zh_CN
"
'根据openid和accesstoken获取用户详情,注意这里这个accesstoken不是普通accesston,只能用于网页授权
hc = New HttpClient(CExp(ul, jo("access_token"), OpenId))
jo = jo.Parse(hc.GetData)
If jo("openid") IsNot
Nothing Then
UserName = jo("nickname")
dr = DataTables("WXUsers").AddNew()
Dim nms() As String =
{"openid","nickname","sex","city","country","province","headimgurl"} '""
For Each nm As String In nms
dr(nm) = jo(nm)
Next
If e.GetValues.ContainsKey("tjr") Then 卡在这里导致不保存,直接调在下面的 的 ("你无权访问本系统")
dr("客户来源_KHID") = e.GetValues("tjr")
dr.Save
End If
Else
e.WriteString(jo.ToString) '在用户浏览器显示错误信息
Return
End If
End If
e.AppendCookie("username",UserName) '用户名和openid存储在Cookie中
e.AppendCookie("openid",OpenID)
Else
e.WriteString(jo.ToString) '在用户浏览器显示错误信息
Return
End If
Else
UserName = e.Cookies("username") '从cookie获取用户名和openid
OpenID = e.Cookies("openid")
If userName = "" OrElse OpenID = "" Then
Dim ul As String =
"https://open.weixin.qq.com/connect/oauth2/authorize?appid=wx8acdb7df5beb68fd&redirect_uri=http%3a%2f%2fwexin.foxtable.com&response_type=code&scope=snsapi_userinfo&state=123#wechat_redirect"
sb.Append("<meta
http-equiv='Refresh' c>")
'跳转到授权链接
e.WriteString(sb.ToString)
Return
End If
End If
If OpenID >
"" And UserName > ""
Then
'这里可以做进一步的权限判断
sb.AppendLine("欢迎"
& UserName &
"光临, <a
href='http://wexin.foxtable.com'>刷新页面</a>")
Else
sb.AppendLine("你无权访问本系统") 上面过不去就直接跳转这里了
End If
End If
e.WriteString(sb.ToString)
抄帮助的代码没有任何意义!!想解决问题麻烦发自己真实的代码!把敏感数据改改即可
If e.GetValues.ContainsKey("code") Then '如果是通过授权链接跳转而来,就从链接重提取code来获取openid
Dim ul As String = "https://api.weixin.qq.com/sns/oauth2/access_token?appid={0}&secret={1}&code={2}&grant_type=authorization_code"
ul = CExp(ul, "w。。。。。。。。", "f...................", e.GetValues("code"))
Dim hc As New HttpClient(ul)
Dim jo As JObject = JObject.Parse(hc.GetData)
If jo("openid") IsNot Nothing Then '如果获取openid成功(成功的话,还会同时返回一个accesstiken,用于获取用户详情)
OpenID = jo("openid")
Dim dr As DataRow = DataTables("客户").SQLFind("openid ='" & Openid & "'")
If dr IsNot Nothing Then
UserName = dr("nickname")
Else
dr = DataTables("客户").AddNew()
msgbox("增行后", 64, "提示")
Dim nms() As String = {"openid", "nickname", "headimgurl", "性别"} '"", "客户住址_县市", "country", "客户住址_省市"} '""
For Each nm As String In nms
dr(nm) = jo(nm)
msgbox("提取数据", 64, "提示")
Next
msgbox("判断tjkhid", 64, "提示") ,这个提示后就不提示推荐人和 不保存,直接到下面的,else sb.AppendLine("系统繁忙稍后访问本系统")
If e.GetValues.ContainsKey("tjr") Then
msgbox("写入推荐人", 64, "提示")
dr("客户来源_KHID") = e.GetValues("tjr")
msgbox("保存", 64, "提示")
dr.Save
End If
End If
接下面代码....
接上面代码
e.AppendCookie("username", UserName) '用户名和openid存储在Cookie中
e.AppendCookie("openid", OpenID)
msgbox("存缓存", 64, "提示")
Else
e.WriteString(jo.ToString) '在用户浏览器显示错误信息
msgbox("openid空的", 64, "提示")
Return
End If
Else
UserName = e.Cookies("username") '从cookie获取用户名和openid
OpenID = e.Cookies("openid")
Dim dr As DataRow = DataTables("客户").SQLFind("openid ='" & Openid & "'") '根据openid找出对应的行
If dr Is Nothing OrElse UserName = "" OrElse OpenId = "" Then '空
Dim url As String = e.Request.URL.ToString
MsgBox(url)
Dim ul As String = "https://open.weixin.qq.com/connect/oauth2/authorize?appid=wx................&redirect_uri=" & UrlEncode(url) & "&response_type=code&scope=snsapi_userinfo&state=123#wechat_redirect"
sb.Append("<meta http-equiv='Refresh' c>") '跳转到授权链接
e.WriteString(sb.ToString)
Return
End If
End If
msgbox("授权成功", 64, "提示")
Dim Verified As Boolean
Dim dr1 As DataRow = DataTables("客户").SQLFind("openid ='" & Openid & "'") '根据openid找出对应的行
If OpenId > "" AndAlso dr1 IsNot Nothing AndAlso dr1("permit") = False Then'授权成功
msgbox("openid>0", 64, "提示")
Verified = True
sb.AppendLine("欢迎" & UserName & "光临!,用一天。 <a href='default.htm'>刷新页面</a>")
End Select
e.WriteString(wb.Build) '生成网页
Else
sb.AppendLine("系统繁忙稍后访问本系统") 上面不保存,直接跳转这里了
End if
Else
sb.AppendLine("你无权访问本系统")
End If
e.WriteString(sb.ToString)
[此贴子已经被作者于2024/6/17 17:05:52编辑过]
调试这个位置,下面红色能不能弹出,弹出什么内容?
……
Else
UserName = e.Cookies("username") '从cookie获取用户名和openid
OpenID = e.Cookies("openid")
MsgBox("OpenID=" & OpenID & ",UserName=" & UserName)
Dim dr As DataRow = DataTables("客户").SQLFind("openid ='" & Openid & "'") '根据openid找出对应的行
MsgBox("dr = " & (dr Is Nothing))
If dr Is Nothing OrElse UserName = "" OrElse OpenId = "" Then '空
Dim url As String = e.Request.URL.ToString
MsgBox(url)
Dim ul As String = "https://open.weixin.qq.com/connect/oauth2/authorize?appid=wx................&redirect_uri=" & UrlEncode(url) & "&response_type=code&scope=snsapi_userinfo&state=123#wechat_redirect"
sb.Append("<meta http-equiv='Refresh' c>") '跳转到授权链接
e.WriteString(sb.ToString)
Return
End If
End If
……