private static bool InsertAccessToken(string appid, AccessTokenResult accessToken)
{
string sqlStr = "insert into [wx_AccessToken]([appid] ,[accessToken] ,[createtime] ) VALUES(@appid,@accessToken,@createtime) ";
SqlParameter[] parameters = { new SqlParameter("@appid", appid), new SqlParameter("@accessToken", accessToken.access_token), new SqlParameter("@createtime", DateTime.Now.AddSeconds(accessToken.expires_in - 60)) };
if (SQLServerHepler.ExecuteNonQuery(SQLServerHepler.GetConnectionStringByConfig(), System.Data.CommandType.Text, sqlStr, parameters) > 0)
{
return(true);
}
else
{
return(false);
}
}
private static bool UpdateAccessToken(string appid, AccessTokenResult accessToken)
{
string sqlStr = "update wx_AccessToken set accessToken=@accessToken,createtime=@createtime where appid=@appid";
SqlParameter[] parameters = { new SqlParameter("@accessToken", accessToken.access_token), new SqlParameter("@createtime", DateTime.Now.AddSeconds(accessToken.expires_in - 60000)), new SqlParameter("@appid", appid) };
if (SQLServerHepler.ExecuteNonQuery(SQLServerHepler.GetConnectionStringByConfig(), System.Data.CommandType.Text, sqlStr, parameters) > 0)
{
return(true);
}
else
{
return(false);
}
}