private string IsExistAccess_Token()
{
var dt = BaseClass.GetDataTable("select top(1) AccessToken from [t_WxConfig] WHERE [OverTime]>GetDate() and AppID='" + APPID + "'");
if (dt != null && dt.Rows.Count > 0)
{
return(dt.Rows[0]["AccessToken"].ToString());
}
else
{
string url = "https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=" + APPID + "&secret=" + APPSECRET;
var jsonStr = Get(url);
var reObj = Newtonsoft.Json.JsonConvert.DeserializeObject <dynamic>(jsonStr);
BaseClass.ExecuteNonQuerySQL("update [t_WxConfig] set AccessToken='" + reObj.access_token + "',[OverTime]=DATEADD(hour,2, getdate()) where AppID='" + APPID + "'");
return(reObj.access_token);
}
}
