/// <summary> /// 得到 tb_accesstoken 数据实体 /// </summary> /// <param name="dr">dr</param> /// <returns>tb_accesstoken 数据实体</returns> public tb_AccessTokenEntity Populate_tb_AccessTokenEntity_FromDr(IDataReader dr) { tb_AccessTokenEntity Obj = new tb_AccessTokenEntity(); Obj.ID = ((dr["ID"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["ID"]); Obj.UserID = dr["UserID"].ToString(); Obj.WeiXinCode = dr["WeiXinCode"].ToString(); Obj.AccessToken = dr["AccessToken"].ToString(); Obj.AddTime = ((dr["AddTime"]) == DBNull.Value) ? Convert.ToDateTime("1900-1-1") : Convert.ToDateTime(dr["AddTime"]); return(Obj); }
/// <summary> /// 向数据表tb_AccessToken更新一条记录。 /// </summary> /// <param name="_tb_AccessTokenModel">_tb_AccessTokenModel</param> /// <returns>影响的行数</returns> public int Update(tb_AccessTokenEntity _tb_AccessTokenModel) { string sqlStr = "update tb_AccessToken set [UserID]=@UserID,[WeiXinCode]=@WeiXinCode,[AccessToken]=@AccessToken,[AddTime]=@AddTime where ID=@ID"; SqlParameter[] _param = { new SqlParameter("@ID", SqlDbType.Int), new SqlParameter("@UserID", SqlDbType.VarChar), new SqlParameter("@WeiXinCode", SqlDbType.VarChar), new SqlParameter("@AccessToken", SqlDbType.VarChar), new SqlParameter("@AddTime", SqlDbType.DateTime) }; _param[0].Value = _tb_AccessTokenModel.ID; _param[1].Value = _tb_AccessTokenModel.UserID; _param[2].Value = _tb_AccessTokenModel.WeiXinCode; _param[3].Value = _tb_AccessTokenModel.AccessToken; _param[4].Value = _tb_AccessTokenModel.AddTime; return(SqlHelper.ExecuteNonQuery(getConnectionString, CommandType.Text, sqlStr, _param)); }
public tb_AccessTokenEntity GetModel(string weixincode) { tb_AccessTokenEntity _obj = null; SqlParameter[] _param = { new SqlParameter("@weixincode", SqlDbType.VarChar, 50) }; _param[0].Value = weixincode; string sqlStr = "select * from tb_AccessToken with(nolock) where WeiXinCode=@weixincode"; using (SqlDataReader dr = SqlHelper.ExecuteReader(getConnectionString, CommandType.Text, sqlStr, _param)) { while (dr.Read()) { _obj = Populate_tb_AccessTokenEntity_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); } }