using AIOWeb.Models; 
using Newtonsoft.Json; 
using Newtonsoft.Json.Linq; 
using System; 
using System.Collections.Generic; 
using System.Data; 
using System.Data.SqlClient; 
using System.Linq; 
using System.Web; 
 
namespace AIOWeb 
{ 
 /// <summary> 
 /// wxapi 的摘要说明 
 /// </summary> 
 public class wxapi : IHttpHandler 
 { 
  public void ProcessRequest(HttpContext context) 
  { 
   context.Response.ContentType = "text/plain"; 
 
   string code = ""; 
   string iv = ""; 
   string encryptedData = ""; 
   try 
   { 
    code = HttpContext.Current.Request.QueryString["code"].ToString(); 
    iv = HttpContext.Current.Request.QueryString["iv"].ToString(); 
    encryptedData = HttpContext.Current.Request.QueryString["encryptedData"].ToString(); 
   } 
   catch (Exception ex) 
   { 
    context.Response.Write(ex.ToString()); 
   } 
 
   string Appid = "wxdb2641f85b04f1b3"; 
   string Secret = "8591d8cd7197b9197e17b3275329a1e7"; 
   string grant_type = "authorization_code"; 
 
   //向微信服务端 使用登录凭证 code 获取 session_key 和 openid 
   string url = "https://api.weixin.qq.com/sns/jscode2session?appid=" + Appid + "&secret=" + Secret + "&js_code=" + code + "&grant_type=" + grant_type; 
   string type = "utf-8"; 
 
   AIOWeb.Models.GetUsersHelper GetUsersHelper = new AIOWeb.Models.GetUsersHelper(); 
   string j = GetUsersHelper.GetUrltoHtml(url, type);//获取微信服务器返回字符串 
 
   //将字符串转换为json格式 
   JObject jo = (JObject)JsonConvert.DeserializeObject(j); 
 
   result res = new result(); 
   try 
   { 
    //微信服务器验证成功 
    res.openid = jo["openid"].ToString(); 
    res.session_key = jo["session_key"].ToString(); 
   } 
   catch (Exception) 
   { 
    //微信服务器验证失败 
    res.errcode = jo["errcode"].ToString(); 
    res.errmsg = jo["errmsg"].ToString(); 
   } 
   if (!string.IsNullOrEmpty(res.openid)) 
   { 
    //用户数据解密 
    GetUsersHelper.AesIV = iv; 
    GetUsersHelper.AesKey = res.session_key; 
 
    string result = GetUsersHelper.AESDecrypt(encryptedData); 
 
 
    //存储用户数据 
    JObject _usrInfo = (JObject)JsonConvert.DeserializeObject(result); 
 
    userInfo userInfo = new userInfo(); 
    userInfo.openId = _usrInfo["openId"].ToString(); 
 
    try //部分验证返回值中没有unionId 
    { 
     userInfo.unionId = _usrInfo["unionId"].ToString(); 
    } 
    catch (Exception) 
    { 
     userInfo.unionId = "unionId"; 
    } 
     
    userInfo.nickName = _usrInfo["nickName"].ToString(); 
    userInfo.gender = _usrInfo["gender"].ToString(); 
    userInfo.city = _usrInfo["city"].ToString(); 
    userInfo.province = _usrInfo["province"].ToString(); 
    userInfo.country = _usrInfo["country"].ToString(); 
    userInfo.avatarUrl = _usrInfo["avatarUrl"].ToString(); 
 
    object watermark = _usrInfo["watermark"].ToString(); 
    object appid = _usrInfo["watermark"]["appid"].ToString(); 
    object timestamp = _usrInfo["watermark"]["timestamp"].ToString(); 
 
 
    #region 
 
 
    //创建连接池对象（与数据库服务器进行连接） 
    SqlConnection conn = new SqlConnection("server=127.0.0.1;database=Test;uid=sa;pwd=1"); 
    //打开连接池 
    conn.Open(); 
    //创建命令对象 
    string Qrystr = "SELECT * FROM WeChatUsers WHERE openId='" + userInfo.openId + "'"; 
    SqlCommand cmdQry = new SqlCommand(Qrystr, conn); 
    object obj = cmdQry.ExecuteScalar(); 
    if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value))) 
    { 
     string str = "INSERT INTO WeChatUsers ([UnionId] ,[OpenId],[NickName],[Gender],[City],[Province],[Country],[AvatarUrl],[Appid],[Timestamp],[Memo],[counts])VALUES('" + userInfo.unionId + "','" + userInfo.openId + "','" + userInfo.nickName + "','" + userInfo.gender + "','" + userInfo.city + "','" + userInfo.province + "','" + userInfo.country + "','" + userInfo.avatarUrl + "','" + appid.ToString() + "','" + timestamp.ToString() + "','来自微信小程序','1')"; 
 
     SqlCommand cmdUp = new SqlCommand(str, conn); 
     // 执行操作 
     try 
     { 
      int row = cmdUp.ExecuteNonQuery(); 
     } 
     catch (Exception ex) 
     { 
      context.Response.Write(ex.ToString()); 
     } 
    } 
    else 
    { 
     //多次访问，记录访问次数counts 更新unionId是预防最初没有，后期关联后却仍未记录 
     string str = "UPDATE dbo.WeChatUsers SET counts = counts+1，UnionId = '" + userInfo.unionId + "' WHERE OpenId='" + userInfo.openId + "'"; 
     SqlCommand cmdUp = new SqlCommand(str, conn); 
     int row = cmdUp.ExecuteNonQuery(); 
    } 
     
    //关闭连接池 
    conn.Close(); 
    #endregion 
 
    //返回解密后的用户数据 
    context.Response.Write(result); 
   } 
   else 
   { 
    context.Response.Write(j); 
   } 
  } 
 
  public bool IsReusable 
  { 
   get 
   { 
    return false; 
   } 
  } 
 } 
} 

using System; 
using System.Collections.Generic; 
using System.IO; 
using System.Linq; 
using System.Security.Cryptography; 
using System.Text; 
using System.Threading.Tasks; 
 
namespace AIOWeb.Models 
{ 
 public class GetUsersHelper 
 { 
 
  /// <summary> 
  /// 获取链接返回数据 
  /// </summary> 
  /// <param name="Url">链接</param> 
  /// <param name="type">请求类型</param> 
  /// <returns></returns> 
  public string GetUrltoHtml(string Url, string type) 
  { 
   try 
   { 
    System.Net.WebRequest wReq = System.Net.WebRequest.Create(Url); 
    // Get the response instance. 
    System.Net.WebResponse wResp = wReq.GetResponse(); 
    System.IO.Stream respStream = wResp.GetResponseStream(); 
    // Dim reader As StreamReader = New StreamReader(respStream) 
    using (System.IO.StreamReader reader = new System.IO.StreamReader(respStream, Encoding.GetEncoding(type))) 
    { 
     return reader.ReadToEnd(); 
    } 
   } 
   catch (System.Exception ex) 
   { 
    return ex.Message; 
   } 
  } 
  #region 微信小程序用户数据解密 
 
  public static string AesKey; 
  public static string AesIV; 
 
  /// <summary> 
  /// AES解密 
  /// </summary> 
  /// <param name="inputdata">输入的数据encryptedData</param> 
  /// <param name="AesKey">key</param> 
  /// <param name="AesIV">向量128</param> 
  /// <returns name="result">解密后的字符串</returns> 
  public string AESDecrypt(string inputdata) 
  { 
   try 
   { 
    AesIV = AesIV.Replace(" ", "+"); 
    AesKey = AesKey.Replace(" ", "+"); 
    inputdata = inputdata.Replace(" ", "+"); 
    byte[] encryptedData = Convert.FromBase64String(inputdata); 
 
    RijndaelManaged rijndaelCipher = new RijndaelManaged(); 
    rijndaelCipher.Key = Convert.FromBase64String(AesKey); // Encoding.UTF8.GetBytes(AesKey); 
    rijndaelCipher.IV = Convert.FromBase64String(AesIV);// Encoding.UTF8.GetBytes(AesIV); 
    rijndaelCipher.Mode = CipherMode.CBC; 
    rijndaelCipher.Padding = PaddingMode.PKCS7; 
    ICryptoTransform transform = rijndaelCipher.CreateDecryptor(); 
    byte[] plainText = transform.TransformFinalBlock(encryptedData, 0, encryptedData.Length); 
    string result = Encoding.UTF8.GetString(plainText); 
 
    return result; 
   } 
   catch (Exception) 
   { 
    return null; 
 
   } 
  } 
  #endregion 
 } 
}