//[Invoke(Begin = "2020-11-11 00:00", Interval = 1000 * 3600, SkipWhileExecuting = true)] public void DoTask() { int totalCount = 0; int count = 0; //获取AccessToken string accessToken = CallExternal.GetAccessToken(); //获取外部接口日志 DateTime time = DateTime.Today.AddDays(-13);//开始时间 using (var db = new TestContext()) { var query = db.ExternalLog.OrderByDescending(e => e.EndTime).FirstOrDefault(); if (query != null) { time = query.EndTime; } } long startTime = TimeFormat.ToUnixTimestampByMilliseconds(time.AddMinutes(-1)); //开始时间 long endTime = TimeFormat.ToUnixTimestampByMilliseconds(DateTime.Now); //结束时间 string pageId = null; //页码Id 上一页则传当前最小记录id,下一页则传当前最大id,首页或者最后页传null string pageType = "first"; //页码类型 prev=上一页,next=下一页,first=第一页,last=最后一页 var pushLogs = GetExternalLog(accessToken, startTime, endTime, pageId, pageType); List <string> insList = new List <string>(); pushLogs.ForEach(p => { string ins = GetInstance(p.FormInstId, p.FormCodeId, accessToken); insList.Add(ins); }); insList = insList.Where(i => i.Contains("true")).ToList(); totalCount = insList.Count(); //获取实例 try { insList.ForEach(p => { JObject jObject = JObject.Parse(p); if (jObject["success"].ToString() == "True") { count += 1; using (var db = new TestContext()) { //解析数据存入数据库 //获取CGSqlist ParseEntity PE = new ParseEntity(); CGSqlist cg = PE.GetCGSQlist(jObject); cg.FirstInput = false; //审批流 List <Reqlist> rlList = PE.GetReqlist(JObject.Parse(GetFlowRecord(cg.FormInstId, cg.FormCodeId)), cg.Fbillid); rlList.ForEach(r => { var list = db.Reqlist.AsNoTracking().Where(c => c.CreateTime == r.CreateTime) .Where(c => c.Fbillno == r.Fbillno).ToList(); if (list.Count() == 0) { db.Reqlist.Add(r); } }); var query = db.CGSqlist.AsNoTracking() .Where(c => c.SerialNumber.Equals(cg.SerialNumber)) .ToList(); if (query.Count == 0) { //获取CgsqListentry List <CgsqListentry> cleList = PE.GetCgsqListentry(jObject, cg.Fbillid); db.CGSqlist.Add(cg); db.CgsqListentry.AddRange(cleList); } db.SaveChanges(); } } }); using (var DbContext = new TestContext()) { ExternalLog log = new ExternalLog { StartTime = TimeFormat.ToLocalTimeTime(startTime), EndTime = TimeFormat.ToLocalTimeTime(endTime), QueryState = QueryState.成功, FailTotalNum = totalCount, TakeStatus = TakeStatus.完全同步, CatchNum = count, CreationTime = TimeFormat.ToLocalTimeTime(endTime), TakeTime = TimeFormat.ToLocalTimeTime(endTime) }; DbContext.ExternalLog.Add(log); DbContext.SaveChanges(); } } catch (Exception e) { using (var DbContext = new TestContext()) { ExternalLog log = new ExternalLog { StartTime = TimeFormat.ToLocalTimeTime(startTime), EndTime = TimeFormat.ToLocalTimeTime(endTime), QueryState = QueryState.失败, FailTotalNum = totalCount, TakeStatus = TakeStatus.部分同步, CatchNum = count, CreationTime = TimeFormat.ToLocalTimeTime(endTime), TakeTime = TimeFormat.ToLocalTimeTime(endTime) }; if (totalCount == 0 || count == 0) { log.TakeStatus = TakeStatus.未同步; } DbContext.ExternalLog.Add(log); DbContext.SaveChanges(); } } }
public void DoCheck() { int count = 0; int totalCount = 0; string accessToken = GetAccessToken(); var dbContext = new TestContext(); //查询失败的日志 var query = dbContext.ExternalLog.Where(e => e.QueryState == QueryState.失败).ToList(); //获取外部日志存入数据库 query.ForEach(q => { long startTime = TimeFormat.ToUnixTimestampByMilliseconds(q.StartTime); //开始时间 long endTime = TimeFormat.ToUnixTimestampByMilliseconds(q.EndTime); //结束时间 string pageId = null; //页码Id 上一页则传当前最小记录id,下一页则传当前最大id,首页或者最后页传null string pageType = "first"; //页码类型 prev=上一页,next=下一页,first=第一页,last=最后一页 var pushLogs = GetExternalLog(accessToken, startTime, endTime, pageId, pageType); List <string> insList = new List <string>(); pushLogs.ForEach(p => { string ins = GetInstance(p.FormInstId, p.FormCodeId, accessToken); insList.Add(ins); }); insList = insList.Where(i => i.Contains("true")).ToList(); totalCount = insList.Count(); //获取实例 try { insList.ForEach(p => { JObject jObject = JObject.Parse(p); if (jObject["success"].ToString() == "True") { count += 1; using (var db = new TestContext()) { //解析数据存入数据库 //获取CGSqlist ParseEntity PE = new ParseEntity(); CGSqlist cg = PE.GetCGSQlist(jObject); cg.FirstInput = false; //审批流 List <Reqlist> rlList = PE.GetReqlist(JObject.Parse(GetFlowRecord(cg.FormInstId, cg.FormCodeId)), cg.Fbillid); rlList.ForEach(r => { var list = db.Reqlist.AsNoTracking().Where(c => c.CreateTime == r.CreateTime) .Where(c => c.Fbillno == r.Fbillno).ToList(); if (list.Count() == 0) { db.Reqlist.Add(r); } }); var query = db.CGSqlist.AsNoTracking() .Where(c => c.SerialNumber.Equals(cg.SerialNumber)) .ToList(); if (query.Count == 0) { //获取CgsqListentry List <CgsqListentry> cleList = PE.GetCgsqListentry(jObject, cg.Fbillid); db.CGSqlist.Add(cg); db.CgsqListentry.AddRange(cleList); } db.SaveChanges(); } } }); q.CatchNum = count; q.TakeStatus = TakeStatus.完全同步; q.QueryState = QueryState.成功; q.TakeTime = DateTime.Now; dbContext.Update(q); dbContext.SaveChanges(); } catch (Exception e) { string content = startTime + "——" + endTime + "云之家外部日志接口同步失败"; //发送邮件 SendMail mailService = new SendMail(); bool fmailback = mailService.Send("*****@*****.**", "*****@*****.**", "云之家外部日志接口问题", content, "*****@*****.**", "naduohua", "smtp.163.com", "", ""); } }); }