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