protected void Page_Load(object sender, EventArgs e)
{
try
{
string url = Request.Url.ToString();
var urlTmp = WebTools.BuildUrl(url, "code", "");
Response.Write(urlTmp);
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
dt1.Columns.Add("Id");
dt1.Columns.Add("UserId");
dt1.Columns.Add("Content");
dt1.Columns.Add("Image");
dt1.Columns.Add("CreateOn");
dt1.Columns.Add("name");
dt1.Columns.Add("phone");
dt1.Columns.Add("remark");
MySqlHelper helper = new MySqlHelper(DbConn.WeiXin);
string sql = $@"select * from feedback";
dt = helper.ExecuteDataTable(sql);
var row = dt.Select("CreateOn>'2017-08-14 09:37:36'");
row.CopyToDataTable(dt1, LoadOption.OverwriteChanges);
DataRow row1 = row[0];
dt1.Rows.Add(row1.ItemArray);
dt1.Rows.Add(row1.ItemArray);
var tmp = dt1;
}
catch (Exception ex)
{
}
}
protected override void OnInit(EventArgs e)
{
//启用微信打开控制
var openIdCookie = HttpContext.Current.Request.Cookies[BaseClass.OpenId_Cookie];
var openId = openIdCookie == null ? "" : openIdCookie.Value;
var uIdCookie = HttpContext.Current.Request.Cookies[BaseClass.Uid_Cookie];
uId = uIdCookie == null ? 0: BitAuto.Utils.ConvertHelper.GetInteger(uIdCookie.Value);
LogHandler.Info("uid:" + uId);
//if (string.IsNullOrEmpty(openId))
if (uId == 0)
{
if (BaseClass.IsNeedWeiXin)
{
string returnurl = "/";
returnurl = Request.Url?.ToString();
string code = RequestHelper.GetQueryString("code");
string state = RequestHelper.GetQueryString("state");
string redirect_uri = RequestHelper.GetQueryString("redirect_uri");
#region MyRegion
//021QRK2o05U3Lr1f2tZn0Tdt2o0QRK26
//http://sfl.sanfengli.cn/home/votelist.aspx?vote_id=8&code=021QRK2o05U3Lr1f2tZn0Tdt2o0QRK26&state=http:%2F%2Fsfl.sanfengli.cn%2Fhome%2Fvotelist.aspx%3Fvote_id%3D8&from=groupmessage&isappinstalled=0,api
//https://open.weixin.qq.com/connect/oauth2/authorize?appid=wx6c4c8bb521e45019&redirect_uri=http%3A%2F%2Fsfl.sanfengli.cn%2Fhome%2Fvotelist.aspx%3Fvote_id%3D8%26from%3Dgroupmessage&response_type=code&scope=snsapi_userinfo&state=http%3A%2F%2Fsfl.sanfengli.cn%2Fhome%2Fvotelist.aspx%3Fvote_id%3D8%26from%3Dgroupmessage&connect_redirect=1#wechat_redirect
//http://sfl.sanfengli.cn/home/votelist.aspx?vote_id=8&code=021QRK2o05U3Lr1f2tZn0Tdt2o0QRK26&state=http:%2F%2Fsfl.sanfengli.cn%2Fhome%2Fvotelist.aspx%3Fvote_id%3D8&from=groupmessage&isappinstalled=0,code=021QRK2o05U3Lr1f2tZn0Tdt2o0QRK26,state=http://sfl.sanfengli.cn/home/votelist.aspx?vote_id=8
//string from = RequestHelper.GetQueryString("from");
//if (!string.IsNullOrEmpty(code)&&string.Equals(code, "021QRK2o05U3Lr1f2tZn0Tdt2o0QRK26", StringComparison.InvariantCultureIgnoreCase) && !string.IsNullOrEmpty(state))
//{
// OAuthScope scope;
// if (IsNeedUserInfo)
// {
// scope = OAuthScope.snsapi_userinfo;
// }
// else
// {
// scope = OAuthScope.snsapi_base;
// }
// string oauthUrl = Weixin.OauthUrl(state, state, scope);
// LogHandler.Info($"from:{from},code:{code},statue:{state},oauthUrl:{oauthUrl}" );
// Response.Redirect(oauthUrl);
//}
#endregion
if (string.IsNullOrWhiteSpace(code))
{
OAuthScope scope;
if (IsNeedUserInfo)
{
scope = OAuthScope.snsapi_userinfo;
}
else
{
scope = OAuthScope.snsapi_base;
}
string oauthUrl = Weixin.OauthUrl(Request.Url?.ToString(), "", scope);
LogHandler.Info("code为空,oauthUrl:" + oauthUrl);
Response.Redirect(oauthUrl);
}
else
{
OAuthAccessTokenResult oAuthAccessTokenResult = null;
try
{
//通过，用code换取access_token
var isSecondRequest = false;
lock (OAuthCodeCollectionLock)
{
isSecondRequest = OAuthCodeCollection.ContainsKey(code);
}
if (!isSecondRequest)
{
//第一次请求
LogHandler.Info($"第一次微信OAuth到达，code：{code}");
lock (OAuthCodeCollectionLock)
{
OAuthCodeCollection[code] = null;
}
}
else
{
//第二次请求
LogHandler.Info($"第二次微信OAuth到达，code：{code}");
lock (OAuthCodeCollectionLock)
{
oAuthAccessTokenResult = OAuthCodeCollection[code];
}
}
try
{
oAuthAccessTokenResult = oAuthAccessTokenResult ?? OAuthApi.GetAccessToken(BaseClass.AppId, BaseClass.Secret, code);
}
catch (Exception ex)
{
LogHandler.Info($"微信网页授权api信息：{ex.Message}。请求Url：{Request.Url},api参数：url={returnurl},code={code},state={state}");
}
if (oAuthAccessTokenResult != null)
{
lock (OAuthCodeCollectionLock)
{
OAuthCodeCollection[code] = oAuthAccessTokenResult;
}
}
else
{
var url = Request.Url.ToString();
url = WebTools.BuildUrl(url, "code", "");
LogHandler.Info($"code:{code} 已经使用.redirect_uri:{url}");
Response.Redirect(url);
}
//var oAuthAccessTokenResult = OAuthApi.GetAccessToken(BaseClass.AppId, BaseClass.Secret, code);
if (oAuthAccessTokenResult.errcode != 0)
{
Response.Write("您拒绝了授权");
LogHandler.Info($"您拒绝了授权,code:{code }");
}
LogHandler.Info(oAuthAccessTokenResult.access_token + oAuthAccessTokenResult.openid);
var oAuthUserInfo = OAuthApi.GetUserInfo(oAuthAccessTokenResult.access_token, oAuthAccessTokenResult.openid);
this.openId = oAuthAccessTokenResult.openid;
HttpCookie cookie = new HttpCookie(BaseClass.OpenId_Cookie);
cookie.Value = this.openId;
cookie.Expires = DateTime.Now.AddDays(1);
HttpContext.Current.Response.Cookies.Add(cookie);
var userModel = new wp_userbll().SaveUserInfo(oAuthUserInfo);
LogHandler.Info("oAuthUserInfo:" + JsonHelper.Serialize(oAuthUserInfo) + "|uid:" + userModel);
this.uId = userModel;
HttpCookie cookieUid = new HttpCookie(BaseClass.Uid_Cookie);
cookieUid.Value = this.uId.ToString();
cookieUid.Expires = DateTime.Now.AddDays(1);
HttpContext.Current.Response.Cookies.Add(cookieUid);
string token = new LoginTokenID(userModel).ToString();
WebTools.WriteCookie(WebTools.ych_weixintoken, token, 1);
//Response.Redirect("test.aspx"); //Redirect(url);
//if (!string.IsNullOrEmpty(code))
//{
OAuthCodeCollection.Remove(code);
//}
}
catch (Exception ex)
{
LogHandler.Info($"微信网页授权api信息：{ex.Message}。请求Url：{Request.Url},api参数：url={returnurl},code={code},state={state}");
//Response.Write("授权失败");
}
}
}
else
{
openId = "o_7F30X3iijkdt0zsNQrxuGpOL8U";//测试环境账号
}
}
if (this.uId > 0)
{
this.currentUser = new Bll.WeChat.wp_userbll().GetUserInfoByUId(this.uId);
this.openId = this.currentUser == null ? "" : currentUser.openid;
LogHandler.Info("currentUser:"******"uid:" + this.uId.ToString());
}
if (currentUser == null && !string.IsNullOrEmpty(this.openId))
{
this.currentUser = new Bll.WeChat.wp_userbll().GetUserInfoByOpenId(this.openId);
this.openId = this.currentUser == null ? "" : currentUser.openid;
LogHandler.Info("currentUser:"******"openId:" + this.openId.ToString());
}
base.OnInit(e);
}