/// <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);
}
}
