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