public async Task <object> TakeMissingLog([FromBody] ParamInput input)
{
try
{
using (var db = new TestContext())
{
//获取AccessToken
string accessToken = CallExternal.GetAccessToken();
//获取外部接口日志
long startTime = input.StartTime; //开始时间
long endTime = input.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();
int totalCount = insList.Count();
//获取实例
pushLogs.ForEach(p =>
{
string ins = GetInstance(p.FormInstId, p.FormCodeId, accessToken);
JObject jObject = JObject.Parse(ins);
if (jObject["success"].ToString() == "True")
{
//解析数据存入数据库
//获取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();
}
});
}
return(new ReturnMessage {
Success = true, Data = "ok"
});
}
catch (Exception e)
{
return(new ReturnMessage {
Success = false, Data = e.Message
});
}
}
/// <summary>
/// 获取审批痕迹
/// </summary>
/// <param name="accessToken"></param>
/// <param name="formInstId"></param>
/// <param name="formCodeId"></param>
/// <returns></returns>
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);
}
