/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="_tb_OpenID_UserModel">tb_OpenID_User实体</param> /// <returns>新插入记录的编号</returns> public int Insert(tb_OpenID_UserEntity _tb_OpenID_UserModel) { string sqlStr = "insert into tb_OpenID_User([OpenID],[NickName],[Sex],[City],[Country],[Province],[Language],[HeadImgurl],[LoginName],[LoginPwd]) values(@OpenID,@NickName,@Sex,@City,@Country,@Province,@Language,@HeadImgurl,@LoginName,@LoginPwd) select @@identity"; int res; SqlParameter[] _param = { new SqlParameter("@OpenID", SqlDbType.VarChar), new SqlParameter("@NickName", SqlDbType.VarChar), new SqlParameter("@Sex", SqlDbType.Int), new SqlParameter("@City", SqlDbType.VarChar), new SqlParameter("@Country", SqlDbType.VarChar), new SqlParameter("@Province", SqlDbType.VarChar), new SqlParameter("@Language", SqlDbType.VarChar), new SqlParameter("@HeadImgurl", SqlDbType.VarChar), new SqlParameter("@LoginName", SqlDbType.VarChar), new SqlParameter("@LoginPwd", SqlDbType.VarChar) }; _param[0].Value = _tb_OpenID_UserModel.OpenID; _param[1].Value = _tb_OpenID_UserModel.NickName; _param[2].Value = _tb_OpenID_UserModel.Sex; _param[3].Value = _tb_OpenID_UserModel.City; _param[4].Value = _tb_OpenID_UserModel.Country; _param[5].Value = _tb_OpenID_UserModel.Province; _param[6].Value = _tb_OpenID_UserModel.Language; _param[7].Value = _tb_OpenID_UserModel.HeadImgurl; _param[8].Value = _tb_OpenID_UserModel.LoginName; _param[9].Value = _tb_OpenID_UserModel.LoginPwd; res = Convert.ToInt32(SqlHelper.ExecuteScalar(getConnectionString, CommandType.Text, sqlStr, _param)); return(res); }
/// <summary> /// 得到 tb_openid_user 数据实体 /// </summary> /// <param name="dr">dr</param> /// <returns>tb_openid_user 数据实体</returns> public tb_OpenID_UserEntity Populate_tb_OpenID_UserEntity_FromDr(IDataReader dr) { tb_OpenID_UserEntity Obj = new tb_OpenID_UserEntity(); Obj.ID = ((dr["ID"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["ID"]); Obj.OpenID = dr["OpenID"].ToString(); Obj.NickName = dr["NickName"].ToString(); Obj.Sex = ((dr["Sex"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["Sex"]); Obj.City = dr["City"].ToString(); Obj.Country = dr["Country"].ToString(); Obj.Province = dr["Province"].ToString(); Obj.Language = dr["Language"].ToString(); Obj.HeadImgurl = dr["HeadImgurl"].ToString(); Obj.LoginName = dr["LoginName"].ToString(); Obj.LoginPwd = dr["LoginPwd"].ToString(); return(Obj); }
public tb_OpenID_UserEntity GetUserInfo(string token, string openid) { tb_OpenID_UserEntity model = null; string url = "https://api.weixin.qq.com/cgi-bin/user/info?access_token=" + token + "&openid=" + openid + "&lang=zh_CN"; WebClient webClient = new WebClient(); Byte[] bytes = webClient.DownloadData(url); string json = Encoding.GetEncoding("utf-8").GetString(bytes); if (json.IndexOf("errcode") > 0) { } else { model = Jnwf.Utils.Json.JsonHelper.DeserializeJson <tb_OpenID_UserEntity>(json); } return(model); }
public tb_OpenID_UserEntity GetModelByOpenId(string openid) { tb_OpenID_UserEntity _obj = null; SqlParameter[] _param = { new SqlParameter("@openid", SqlDbType.VarChar) }; _param[0].Value = openid; string sqlStr = "select * from tb_OpenID_User with(nolock) where openid=@openid"; using (SqlDataReader dr = SqlHelper.ExecuteReader(getConnectionString, CommandType.Text, sqlStr, _param)) { while (dr.Read()) { _obj = Populate_tb_OpenID_UserEntity_FromDr(dr); } } return(_obj); }
public void SetUserData() { try { DataSet ds = GetOpenIdUser(); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { string token = ""; tb_AccessTokenEntity a = accessTokenOperation.GetModel(dr["weixincode"].ToString()); if (a != null) { if (a.AddTime.AddHours(1) <= DateTime.Now) { //tb_UserEntity user = Jnwf.BLL.tb_UserBLL.GetInstance().GetModelByWeiXin(a.WeiXinCode); token = GetAccessToken(appid, secret); a.AccessToken = token; a.AddTime = DateTime.Now; accessTokenOperation.Update(a); } else { token = a.AccessToken; } tb_OpenID_UserEntity entity = GetUserInfo(token, dr["openid"].ToString()); if (entity != null && entity.OpenID.Length > 0) { openidUser.Insert(entity); } } } } } catch (Exception ex) { //Jnwf.Utils.Log.Logger.Log4Net.Error("center.aspx,ex:" + ex.Message + "|" + ex.StackTrace); } }