58 lines
2.0 KiB
C#
58 lines
2.0 KiB
C#
using Nirvana.Data;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Threading.Tasks;
|
|
using YBDevice.Entity;
|
|
|
|
namespace YBDevice.NApi.DBServices
|
|
{
|
|
/// <summary>
|
|
/// 微信开放平台openticket配置
|
|
/// </summary>
|
|
public partial class OpenWXConfigApp : Repository<YB_OpenWXConfig>
|
|
{
|
|
/// <summary>
|
|
/// 获取openticket
|
|
/// </summary>
|
|
/// <param name="componentAppId"></param>
|
|
/// <returns></returns>
|
|
public static async Task<string> GetOpenTicketAsync(string componentAppId)
|
|
{
|
|
using (var dbClient = ReadDbContext.GetInstance())
|
|
{
|
|
var component = await dbClient.Queryable<YB_OpenWXConfig>().Where(x => x.ComponentAppId == componentAppId).FirstAsync();
|
|
return component?.OpenTicket;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 获取公众号的刷新token
|
|
/// </summary>
|
|
/// <param name="authorizerId">公众号appid</param>
|
|
/// <param name="componentAppId">开放平台appid</param>
|
|
/// <returns></returns>
|
|
public async Task<string> GetRefreshToken(string authorizerId, string componentAppId)
|
|
{
|
|
using (var dbClient = ReadDbContext.GetInstance())
|
|
{
|
|
try
|
|
{
|
|
var data = await dbClient.Queryable<YB_OfficlaAccount>().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}";
|
|
new LoggerApp().InsertErrorLog(ex, errmsg, "获取公众号的刷新token");
|
|
return "";
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|