RiskControl_RR_Fast.git

			@@ -1,6 +1,7 @@
			using System;
			using System.Collections.Generic;
			using System.Configuration;
			using System.Diagnostics;
			using System.Linq;
			using System.Threading.Tasks;
			using CommonHelper;
			@@ -19,6 +20,7 @@
			{
			private TianYanChaApi _api = new TianYanChaApi();
			private int _expiredDays;
			private int _expiredDays2;
			private int _expiredDaysSeniorExecutive = 30;//天眼查获取董监高默认30天
			private int _expiredDaysSlow = 180;//天眼查获取其他信息180天

			@@ -27,6 +29,7 @@
			//if (!int.TryParse(ConfigurationManager.AppSettings["TianyanchaExpiredDays"], out _expiredDays))
			// _expiredDays = 10;
			int.TryParse(ConfigurationManager.AppSettings["TianyanchaExpiredDays"], out _expiredDays);
			int.TryParse(ConfigurationManager.AppSettings["TianyanchaExpiredDays2"], out _expiredDays2);
			}

			/// <summary>
			@@ -513,7 +516,7 @@
			.FirstAsync();
			if (createTime.AddDays(_expiredDaysSlow) >= DateTime.Now)
			{
			var dbmodel = await RiskControlRRDb.Queryable<TycShareStructure>().Where(a => a.CompanyName == name).OrderBy(a=>a.PubDate).ToListAsync();
			var dbmodel = await RiskControlRRDb.Queryable<TycShareStructure>().Where(a => a.CompanyName == name).OrderBy(a=>a.PubDate, OrderByType.Desc).ToListAsync();
			result.Data = dbmodel;
			return result;
			}
			@@ -551,7 +554,7 @@

			if (_expiredDaysSlow > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();

			result.Data = addList;
			result.Data = addList.OrderByDescending(a => a.PubDate).ToList(); ;
			return result;
			}
			else
			@@ -1635,7 +1638,7 @@


			/// <summary>
			/// 历史主要人员
			/// 企业基本信息
			/// </summary>
			/// <returns></returns>
			public async Task<QccMsgData> GetBaseinfoV3(string name)
			@@ -1739,6 +1742,2207 @@
			return result;
			}
			}
			/// <summary>
			/// 送达公告
			/// </summary>
			/// <returns></returns>
			public async Task<QccMsgData> GetSendAnnouncement(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycSendAnnouncementReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycSendAnnouncementReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycSendAnnouncementReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycSendAnnouncementReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycSendAnnouncementReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycSendAnnouncementReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetSendAnnouncement(new TycSendAnnouncementQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycSendAnnouncementReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			/// <summary>
			/// 立案信息
			/// </summary>
			/// <returns></returns>
			public async Task<QccMsgData> GetCourtRegister(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycCourtRegisterReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycCourtRegisterReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycCourtRegisterReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycCourtRegisterReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycCourtRegisterReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycCourtRegisterReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetCourtRegister(new TycCourtRegisterQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycCourtRegisterReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			/// <summary>
			/// 开庭公告
			/// </summary>
			/// <returns></returns>
			public async Task<QccMsgData> GetKtannouncement(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycKtannouncementReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycKtannouncementReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycKtannouncementReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycKtannouncementReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycKtannouncementReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycKtannouncementReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetKtannouncement(new TycKtannouncementQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycKtannouncementReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			/// <summary>
			/// 历史开庭公告
			/// </summary>
			/// <returns></returns>
			public async Task<QccMsgData> GetAnnouncement(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycAnnouncementReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycAnnouncementReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycAnnouncementReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycAnnouncementReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycAnnouncementReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycAnnouncementReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetAnnouncement(new TycAnnouncementQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycAnnouncementReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			/// <summary>
			/// 法院公告
			/// </summary>
			/// <returns></returns>
			public async Task<QccMsgData> GetCourtAnnouncement(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycCourtAnnouncementReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycCourtAnnouncementReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycCourtAnnouncementReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycCourtAnnouncementReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycCourtAnnouncementReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycCourtAnnouncementReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetCourtAnnouncement(new TycCourtAnnouncementQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycCourtAnnouncementReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			/// <summary>
			/// 历史法院公告
			/// </summary>
			/// <returns></returns>
			public async Task<QccMsgData> GetHiCourt(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycHiCourtReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycHiCourtReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycHiCourtReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycHiCourtReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycHiCourtReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycHiCourtReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetHiCourt(new TycHiCourtQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycHiCourtReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			/// <summary>
			/// 法律诉讼
			/// </summary>
			/// <returns></returns>
			public async Task<QccMsgData> GetJrLawSuit(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycJrLawSuitReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycJrLawSuitReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycJrLawSuitReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycJrLawSuitReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycJrLawSuitReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycJrLawSuitReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetJrLawSuit(new TycJrLawSuitQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycJrLawSuitReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetJrLawSuitDetail(string uuid)
			{
			var result = new QccMsgData();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycJrLawSuitDetailReturn>().Where(a => a.uuid == uuid).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime)
			.FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var dbmodel = await RiskControlRRDb.Queryable<TycJrLawSuitDetailReturn>().Where(a => a.uuid == uuid).FirstAsync();
			result.Data = dbmodel;
			return result;
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycJrLawSuitDetailReturn>().Where(a => a.uuid == uuid).ExecuteCommandAsync();
			}
			var qccResult = _api.GetJrLawSuitDetail(new TycJrLawSuitDetailQuery() { uuid = uuid });
			if (qccResult.Error_code == "0")
			{
			var dblist = qccResult.Result;
			dblist.CreateTime = DateTime.Now;
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(dblist).ExecuteCommandAsync();
			result.Data = dblist;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetHiJudicialDetail(string businessId)
			{
			var result = new QccMsgData();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycHiJudicialDetailReturn>().Where(a => a.businessId == businessId).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime)
			.FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var dbmodel = await RiskControlRRDb.Queryable<TycHiJudicialDetailReturn>().Where(a => a.businessId == businessId).FirstAsync();
			result.Data = dbmodel;
			return result;
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycHiJudicialDetailReturn>().Where(a => a.businessId == businessId).ExecuteCommandAsync();
			}
			var qccResult = _api.GetHiJudicialDetail(new TycHiJudicialDetailQuery() { businessId = businessId });
			if (qccResult.Error_code == "0")
			{
			var dblist = qccResult.Result;
			dblist.CreateTime = DateTime.Now;
			dblist.businessId = businessId;
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(dblist).ExecuteCommandAsync();
			result.Data = dblist;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			/// <summary>
			/// 历史法律诉讼
			/// </summary>
			/// <returns></returns>
			public async Task<QccMsgData> GetHiLawSuit(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycHiLawSuitReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycHiLawSuitReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycHiLawSuitReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycHiLawSuitReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycHiLawSuitReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycHiLawSuitReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetHiLawSuit(new TycHiLawSuitQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycHiLawSuitReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetJudicial(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycJudicialReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycJudicialReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycJudicialReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycJudicialReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycJudicialReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycJudicialReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetJudicial(new TycJudicialQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycJudicialReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetHiJudicial(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycHiJudicialReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycHiJudicialReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycHiJudicialReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycHiJudicialReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycHiJudicialReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycHiJudicialReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetHiJudicial(new TycHiJudicialQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycHiJudicialReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetJrBankruptcy(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycJrBankruptcyReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycJrBankruptcyReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycJrBankruptcyReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycJrBankruptcyReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycJrBankruptcyReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycJrBankruptcyReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetJrBankruptcy(new TycJrBankruptcyQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycJrBankruptcyReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			item.gid = qccResult.Result.gid;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetJrBankruptcyDetail(string gid,string uuid)
			{
			var result = new QccMsgData();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycJrBankruptcyDetailReturn>().Where(a => a.gid == gid && a.uuid == uuid).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime)
			.FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var dbmodel = await RiskControlRRDb.Queryable<TycJrBankruptcyDetailReturn>().Where(a => a.gid == gid && a.uuid == uuid).FirstAsync();
			result.Data = dbmodel;
			return result;
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycJrBankruptcyDetailReturn>().Where(a => a.gid == gid && a.uuid == uuid).ExecuteCommandAsync();
			}
			var qccResult = _api.GetJrBankruptcyDetail(new TycJrBankruptcyDetailQuery() { gid = gid,uuid = uuid});
			if (qccResult.Error_code == "0")
			{
			var dblist = qccResult.Result;
			dblist.CreateTime = DateTime.Now;
			dblist.gid = gid;
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(dblist).ExecuteCommandAsync();
			result.Data = dblist;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetTycJrZhixinginfo(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycJrZhixinginfoReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycJrZhixinginfoReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycJrZhixinginfoReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycJrZhixinginfoReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycJrZhixinginfoReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycJrZhixinginfoReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetJrZhixinginfo(new TycJrZhixinginfoQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycJrZhixinginfoReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetJrDishonest(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycJrDishonestReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycJrDishonestReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycJrDishonestReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycJrDishonestReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycJrDishonestReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycJrDishonestReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetJrDishonest(new TycJrDishonestQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycJrDishonestReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetJrJudicialCase(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycJrJudicialCaseReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycJrJudicialCaseReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycJrJudicialCaseReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycJrJudicialCaseReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycJrJudicialCaseReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycJrJudicialCaseReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetJrJudicialCase(new TycJrJudicialCaseQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycJrJudicialCaseReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetIcChangeinfo(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycIcChangeinfoReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycIcChangeinfoReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycIcChangeinfoReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycIcChangeinfoReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycIcChangeinfoReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycIcChangeinfoReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetIcChangeinfo(new TycIcChangeinfoQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycIcChangeinfoReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}

			public async Task<QccMsgData> GetInverst(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycInverstReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycInverstReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycInverstReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycInverstReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycInverstReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycInverstReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetInverst(new TycInverstQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycInverstReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetBranch(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycBranchReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycBranchReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycBranchReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycBranchReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycBranchReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycBranchReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetBranch(new TycBranchQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycBranchReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetHumanCompanyholding(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycHumanCompanyholdingReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycHumanCompanyholdingReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycHumanCompanyholdingReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycHumanCompanyholdingReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycHumanCompanyholdingReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycHumanCompanyholdingReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetHumanCompanyholding(new TycHumanCompanyholdingQuery() { name = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycHumanCompanyholdingReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetParentCompany(string name)
			{
			var result = new QccMsgData();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycParentCompanyReturn>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime)
			.FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var dbmodel = await RiskControlRRDb.Queryable<TycParentCompanyReturn>().Where(a => a.CompanyName == name).ToListAsync();
			result.Data = dbmodel;
			return result;
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycParentCompanyReturn>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetParentCompany(new TycParentCompanyQuery() { keyword = name });
			if (qccResult.Error_code == "0")
			{
			var r = qccResult.Result;
			r.CreateTime = DateTime.Now;
			r.CompanyName = name;
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(r).ExecuteCommandAsync();
			result.Data = r;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetActualControl(string name)
			{
			var result = new QccMsgData();
			if (_expiredDays2 > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycActualControlReturn>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime)
			.FirstAsync();
			if (createTime.AddDays(_expiredDays2) >= DateTime.Now)
			{
			var dbmodel = await RiskControlRRDb.Queryable<TycActualControlReturn>().Where(a => a.CompanyName == name).ToListAsync();
			result.Data = dbmodel;
			return result;
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycActualControlReturn>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetActualControl(new TycActualControlQuery() { keyword = name });
			if (qccResult.Error_code == "0")
			{
			var r = qccResult;
			r.CreateTime = DateTime.Now;
			r.CompanyName = name;
			if (_expiredDays2 > 0) await RiskControlRRDb.Insertable((TycActualControlReturn)r).ExecuteCommandAsync();
			result.Data = r;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetBids(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycBidsReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycBidsReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycBidsReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycBidsReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycBidsReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycBidsReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetBids(new TycBidsQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycBidsReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}

			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetPsNews(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycPsNewsReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycPsNewsReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycPsNewsReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycPsNewsReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycPsNewsReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycPsNewsReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetPsNews(new TycPsNewsQuery() { name = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycPsNewsReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetStockList(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycStockListReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycStockListReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycStockListReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycStockListReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycStockListReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycStockListReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetStockList(new TycStockListQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycStockListReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetCustomer(string name, int pageIndex = 1, int pageSize = 10,string year = "")
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycCustomerReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycCustomerReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycCustomerReturnItem>()
			.Where(a => a.CompanyName == name)
			.Where(a=>a.year == year)
			.Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycCustomerReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycCustomerReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList.Where(b => b.client_name != "合计").ToList();
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycCustomerReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetCustomer(new TycCustomerQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycCustomerReturnItem>();
			for (var i = 0; i < qccResult.Result.pageBean.result.Count; i++)
			{
			var item = qccResult.Result.pageBean.result[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.pageBean.total;
			item.clientsYear = qccResult.Result.clientsYear;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.pageBean.total;
			resultPage.Items = addList.Where(b => b.client_name != "合计").ToList();
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetSupply(string name, int pageIndex = 1, int pageSize = 10, string year = "")
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycSupplyReturnItem>();
			if (_expiredDays > 0)
			{
			// 1.数据库是存在
			var createTime = await RiskControlRRDb.Queryable<TycSupplyReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycSupplyReturnItem>()
			.Where(a => a.CompanyName == name)
			.Where(a => a.year == year)
			.Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycSupplyReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			// 如果条数相同，则取数据库的。如果条数不同，则重新请求
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycSupplyReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			// 如果请求页 > 总条数,说明没有数据了
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			// 2.不存在或过期
			await RiskControlRRDb.Deleteable<TycSupplyReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetSupply(new TycSupplyQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycSupplyReturnItem>();
			for (var i = 0; i < qccResult.Result.pageBean.result.Count; i++)
			{
			var item = qccResult.Result.pageBean.result[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.pageBean.total;
			item.suppliesYear = qccResult.Result.suppliesYear;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.pageBean.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}

			public async Task<QccMsgData> GetSecurity(string name)
			{
			var result = new QccMsgData();
			if (_expiredDays > 0)
			{
			var createTime = await RiskControlRRDb.Queryable<TycSecurityReturn>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime)
			.FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var dbmodel = await RiskControlRRDb.Queryable<TycSecurityReturn>().Where(a => a.CompanyName == name).FirstAsync();
			result.Data = dbmodel;
			return result;
			}
			await RiskControlRRDb.Deleteable<TycSecurityReturn>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetSecurity(new TycSecurityQuery() { keyword = name });
			if (qccResult.Error_code == "0")
			{
			var dblist = qccResult.Result;
			dblist.CreateTime = DateTime.Now;
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(dblist).ExecuteCommandAsync();
			result.Data = dblist;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}

			public async Task<QccMsgData> GetGuarantees(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycGuaranteesReturnItem>();
			if (_expiredDays > 0)
			{
			var createTime = await RiskControlRRDb.Queryable<TycGuaranteesReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycGuaranteesReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycGuaranteesReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycGuaranteesReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			await RiskControlRRDb.Deleteable<TycGuaranteesReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetGuarantees(new TycGuaranteesQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycGuaranteesReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}

			public async Task<QccMsgData> GetStockIllegal(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycStockIllegalReturnItem>();
			if (_expiredDays > 0)
			{
			var createTime = await RiskControlRRDb.Queryable<TycStockIllegalReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycStockIllegalReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycStockIllegalReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycStockIllegalReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			await RiskControlRRDb.Deleteable<TycStockIllegalReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetStockIllegal(new TycStockIllegalQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycStockIllegalReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}


			public async Task<QccMsgData> GetJudicialSale(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycJudicialSaleReturnItem>();
			if (_expiredDays > 0)
			{
			var createTime = await RiskControlRRDb.Queryable<TycJudicialSaleReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycJudicialSaleReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycJudicialSaleReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycJudicialSaleReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			await RiskControlRRDb.Deleteable<TycJudicialSaleReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetJudicialSale(new TycJudicialSaleQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycJudicialSaleReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}

			public async Task<QccMsgData> GetInquiryEvaluation(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycInquiryEvaluationReturnItem>();
			if (_expiredDays > 0)
			{
			var createTime = await RiskControlRRDb.Queryable<TycInquiryEvaluationReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycInquiryEvaluationReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycInquiryEvaluationReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycInquiryEvaluationReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			await RiskControlRRDb.Deleteable<TycInquiryEvaluationReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetInquiryEvaluation(new TycInquiryEvaluationQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycInquiryEvaluationReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}

			public async Task<QccMsgData> GetImportAndExport(string name)
			{
			var result = new QccMsgData();
			if (_expiredDays > 0)
			{
			var createTime = await RiskControlRRDb.Queryable<TycImportAndExportReturn>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime)
			.FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var dbmodel = await RiskControlRRDb.Queryable<TycImportAndExportReturn>().Where(a => a.CompanyName == name).FirstAsync();
			result.Data = dbmodel;
			return result;
			}
			await RiskControlRRDb.Deleteable<TycImportAndExportReturn>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetImportAndExport(new TycImportAndExportQuery() { keyword = name });
			if (qccResult.Error_code == "0")
			{
			var dblist = qccResult.Result;
			dblist.CompanyName = name;
			dblist.CreateTime = DateTime.Now;
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(dblist).ExecuteCommandAsync();
			result.Data = dblist;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetPatents(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycPatentsReturnItem>();
			if (_expiredDays > 0)
			{
			var createTime = await RiskControlRRDb.Queryable<TycPatentsReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.DbCreateTime, OrderByType.Desc).Select(a => a.DbCreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycPatentsReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycPatentsReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.DbCreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycPatentsReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			await RiskControlRRDb.Deleteable<TycPatentsReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetPatents(new TycPatentsQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycPatentsReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.DbCreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetIprTm(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycIprTmReturnItem>();
			if (_expiredDays > 0)
			{
			var createTime = await RiskControlRRDb.Queryable<TycIprTmReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycIprTmReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycIprTmReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycIprTmReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			await RiskControlRRDb.Deleteable<TycIprTmReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetIprTm(new TycIprTmQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycIprTmReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetIprTmDetail(string regNo,string intCls)
			{
			var result = new QccMsgData();
			if (_expiredDays > 0)
			{
			var createTime = await RiskControlRRDb.Queryable<TycIprTmDetailReturn>().Where(a => a.RegNo == regNo && a.IntCls == intCls).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime)
			.FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var dbmodel = await RiskControlRRDb.Queryable<TycIprTmDetailReturn>().Where(a => a.RegNo == regNo && a.IntCls == intCls).FirstAsync();
			result.Data = dbmodel;
			return result;
			}
			await RiskControlRRDb.Deleteable<TycIprTmDetailReturn>().Where(a => a.RegNo == regNo && a.IntCls == intCls).ExecuteCommandAsync();
			}
			var qccResult = _api.GetIprTmDetail(new TycIprTmDetailQuery() { regNo = regNo,intCls = intCls });
			if (qccResult.Error_code == "0")
			{
			var dblist = qccResult.Result;
			dblist.CreateTime = DateTime.Now;
			dblist.RegNo = regNo;
			dblist.IntCls = intCls;
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(dblist).ExecuteCommandAsync();
			result.Data = dblist;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}
			public async Task<QccMsgData> GetEmployments(string name, int pageIndex = 1, int pageSize = 10)
			{
			var result = new QccMsgData();
			var resultPage = new Page<TycEmploymentsReturnItem>();
			if (_expiredDays > 0)
			{
			var createTime = await RiskControlRRDb.Queryable<TycEmploymentsReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime).FirstAsync();
			if (createTime.AddDays(_expiredDays) >= DateTime.Now)
			{
			var query = RiskControlRRDb.Queryable<TycEmploymentsReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize);
			var dbcount = await query.CountAsync();
			var totalcount = await RiskControlRRDb.Queryable<TycEmploymentsReturnItem>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.TotalItems).FirstAsync();
			if (dbcount == pageSize \|\| dbcount == totalcount \|\| dbcount == totalcount - pageSize * (pageIndex - 1))
			{
			var dbList = await RiskControlRRDb.Queryable<TycEmploymentsReturnItem>().Where(a => a.CompanyName == name).Where(a => a.ItemIndex > (pageIndex - 1) * pageSize && a.ItemIndex <= pageIndex * pageSize).OrderBy(a => a.ItemIndex).ToListAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = totalcount;
			resultPage.Items = dbList;
			result.Data = resultPage;
			return result;
			}
			var dbTotalPages = totalcount != 0
			? (totalcount % pageSize) == 0 ? (totalcount / pageSize) : (totalcount / pageSize) + 1
			: 0;
			if (dbTotalPages < pageIndex)
			{
			result.Message = "查询无结果";
			return result;
			}
			}
			await RiskControlRRDb.Deleteable<TycEmploymentsReturnItem>().Where(a => a.CompanyName == name).ExecuteCommandAsync();
			}
			var qccResult = _api.GetEmployments(new TycEmploymentsQuery() { keyword = name, pageNum = pageIndex, pageSize = pageSize });
			if (qccResult.Error_code == "0")
			{
			var addList = new List<TycEmploymentsReturnItem>();
			for (var i = 0; i < qccResult.Result.items.Count; i++)
			{
			var item = qccResult.Result.items[i];
			item.CreateTime = DateTime.Now;
			item.CompanyName = name;
			item.ItemIndex = (pageIndex - 1) * pageSize + i + 1;
			item.TotalItems = qccResult.Result.total;
			addList.Add(item);
			}
			if (_expiredDays > 0) await RiskControlRRDb.Insertable(addList).ExecuteCommandAsync();
			resultPage.CurrentPage = pageIndex;
			resultPage.PageSize = pageSize;
			resultPage.TotalItems = qccResult.Result.total;
			resultPage.Items = addList;
			result.Data = resultPage;
			return result;
			}
			else
			{
			result.Message = qccResult.Reason;
			return result;
			}
			}



			}
			}