private string GetFlowRecord(string formInstId, string formCodeId) { string url = "https://yunzhijia.com/gateway/workflow/form/thirdpart/getFlowRecord?accessToken=" + CallExternal.GetAccessToken(); JObject param = new JObject(); param.Add("formInstId", formInstId); param.Add("formCodeId", formCodeId); string response = CallExternal.PostUrl(url, param.ToString(), "application/json"); return(response); }
public string GetInstance(string formInstId, string formCodeId, string accessToken) { string url = "https://yunzhijia.com/gateway/workflow/form/thirdpart/viewFormInst?accessToken=" + accessToken; JObject param = new JObject(); param.Add("formInstId", formInstId); param.Add("formCodeId", formCodeId); string response = CallExternal.PostUrl(url, param.ToString(), "application/json"); return(response); }
private List <PushLogs> GetExternalLog( string accessToken, long startTime, long endTime, string pageId, string pageType) { string url = "https://yunzhijia.com/gateway/workflow/form/thirdpart/getPushLog?accessToken=" + accessToken; //页码信息 JObject pageable = new JObject(); pageable.Add("id", pageId); pageable.Add("pageSize", 100); pageable.Add("type", pageType); //请求参数 JObject postParam = new JObject(); postParam.Add("pageable", pageable); postParam.Add("devType", "user"); postParam.Add("startTime", startTime); postParam.Add("endTime", endTime); postParam.Add("pushType", "failed"); string jsonRequest = CallExternal.PostUrl(url, postParam.ToString(), "application/json"); JObject json = JObject.Parse(jsonRequest.ToString()); List <PushLogs> pushlogs = GetPushLogs(json["data"]["pushLogs"].ToString()); if (pushlogs.Count() == 100) { pageId = pushlogs.Last().Id; pageType = "next"; var logs = GetExternalLog(accessToken, startTime, endTime, pageId, pageType); pushlogs.AddRange(logs); } return(pushlogs); }
//[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(); } } }