public string GetTicket(int customerId, string appid, string appsecret)
{
string accessToken = "", ticket;
WxAccessTokenTicket model = UserService.Instance.GetToken(customerId);
if (model != null)
{
if (model.gettime.AddMinutes(90) > DateTime.Now)
{
accessToken = model.value;
model = UserService.Instance.GetTicket(customerId);
if (model != null)
{
if (model.gettime.AddMinutes(90) > DateTime.Now)
{
return(model.value);
}
}
else
{
ticket = BuildTicket(accessToken);
UserService.Instance.updateTicket(customerId, ticket);
return(ticket);
}
}
}
accessToken = BuildAccessToken(appid, appsecret, customerId);
ticket = BuildTicket(accessToken);
UserService.Instance.UpdateToken(customerId, accessToken);
UserService.Instance.updateTicket(customerId, ticket);
return(ticket);
}
public WxAccessTokenTicket GetTicket(int customerid)
{
string sql = "select id,ticket as value,gettime from Hot_WxTicket where customerid=@customerid";
SqlParameter[] parameters =
{
new SqlParameter("@customerid", customerid)
};
WxAccessTokenTicket model = new WxAccessTokenTicket();
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(sql, parameters))
{
model = DbHelperSQL.GetEntity <WxAccessTokenTicket>(dr);
}
return(model);
}
