using Furion.DependencyInjection; using SqlSugar; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using YBDevice.Core; using YBDevice.Entity; namespace YBDevice.Application.WXConfig { public class WXConfigService : IWXConfigService, ITransient { private readonly ISqlSugarRepository repository; private readonly SqlSugarClient dbClient; private readonly ILoggerService _loggerService; public WXConfigService(ISqlSugarRepository sqlSugarRepository, ILoggerService loggerService) { repository = sqlSugarRepository; dbClient = repository.Context; _loggerService = loggerService; } /// /// 获取openticket /// /// /// public async Task GetOpenTicketAsync(string componentAppId) { var component = await dbClient.Queryable().Where(x => x.ComponentAppId == componentAppId).FirstAsync(); return component?.OpenTicket; } /// /// 获取公众号的刷新token /// /// 公众号appid /// 开放平台appid /// public async Task GetRefreshToken(string authorizerId, string componentAppId) { try { var data = await repository.Change().Context.Queryable().FirstAsync(x => x.authorizer_appid == authorizerId && x.componentappid == componentAppId); if (data != null) { return data.authorizer_refresh_token; } return ""; } catch (Exception ex) { var errmsg = $"authorizerid={authorizerId},componentAppid={componentAppId}"; _loggerService.AddErrorLogger(ex, errmsg, "获取公众号的刷新token"); return ""; } } } }