//private IDictionary<Type, object> repositories;
public UnitOfWork()
{
//这里传入连接配置，解决了：由于EF（OnConfiguring）未配置结束，而调用dbContext产生的bug （必须再配合ajax同步执行）
var dco = new DbContextOptionsBuilder <PinkOneMngSysContext>().UseSqlServer("Server=212.64.49.60;Database=PinkOneMngSys;user id=admin;password=Pinkone_2019;MultipleActiveResultSets=true;").Options;
#if RELEASE
dco = new DbContextOptionsBuilder <PinkOneMngSysContext>().UseSqlServer("Server=.;Database=PinkOneMngSys;user id=admin;password=Pinkone_2019;MultipleActiveResultSets=true;").Options;
#endif
_dbContext = new PinkOneMngSysContext(dco);
//repositories = new Dictionary<Type, object>();
}
private int UpdateWxToken()
{
var sleep = 1000 * 60 * 30;//30min
try
{
var dbContext = new PinkOneMngSysContext();
var wxPubInfos = dbContext.Wx_PublicInfo.Where(x => true).ToList();
foreach (var wpi in wxPubInfos)
{
ModelWxToken token = WXOAuthApiHelper.GetWxToken(wpi.AppId, wpi.AppSecret);
if (null != token && token.access_token != null)
{
ModelWxJsTicket ticket = WXOAuthApiHelper.GetWxJsTicket(token);
if (null != ticket)
{
string sql = "update Wx_PublicInfo set UpdateTime='{0}', AccessToken='{1}', JsApiTicket='{2}' where ID=" + wpi.ID;
sql = string.Format(sql, DateTime.Now, token.access_token, ticket.ticket);
var isOK = adoHelper.ExecuteNonQueryCmd(sql);
if (isOK > 0)
{
Console.WriteLine("UpdateWxToken：" + DateTime.Now + " " + wpi.AppName + "Token更新成功");
}
}
//sleep = token.expires_in * 60;
}
else
{
Console.WriteLine("UpdateWxToken：" + DateTime.Now + " " + wpi.AppName + "Token更新失败，原因->" + token.errmsg);
}
}
}
catch (Exception e)
{
Console.WriteLine("UpdateWxToken：" + DateTime.Now + " " + "出现错误，" + e.Message);
//LogHelper.Error(e.Message);
}
return(sleep);
}
public Repository(PinkOneMngSysContext dbc)
{
_dbContext = dbc;
}
