| | |
| | | if (_expiredDays > 0) |
| | | { |
| | | // 1.数据库是存在 |
| | | var createTime = await RiskControlRRDb.Queryable<TopTenPartnerList>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime) |
| | | var createTime = await RiskControlRRDb.Queryable<TopTenPartnerList>().Where(a => a.CompanyName == name && a.date==date).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime) |
| | | .FirstAsync(); |
| | | if (createTime.AddDays(_expiredDays) >= DateTime.Now) |
| | | { |
| | | var list = await RiskControlRRDb.Queryable<TopTenPartnerList>().Where(a => a.CompanyName == name).ToListAsync(); |
| | | var list = await RiskControlRRDb.Queryable<TopTenPartnerList>().Where(a => a.CompanyName == name && a.date == date).ToListAsync(); |
| | | result.Data = list; |
| | | return result; |
| | | } |
| | | |
| | | // 2.不存在或过期 |
| | | await RiskControlRRDb.Deleteable<TopTenPartnerList>().Where(a => a.CompanyName == name).ExecuteCommandAsync(); |
| | | await RiskControlRRDb.Deleteable<TopTenPartnerList>().Where(a => a.CompanyName == name && a.date == date).ExecuteCommandAsync(); |
| | | } |
| | | var qccResult = _api.GetTopTenPartnerList(new TopTenPartnerListQuery() { name = name,date = date}); |
| | | if (qccResult.status == "200") |
| | |
| | | list?.ForEach(a => { |
| | | a.CreateTime = DateTime.Now; |
| | | a.CompanyName = name; |
| | | a.date = date; |
| | | }); |
| | | |
| | | if (_expiredDays > 0) await RiskControlRRDb.Insertable(list).ExecuteCommandAsync(); |
| | |
| | | if (_expiredDays > 0) |
| | | { |
| | | // 1.数据库是存在 |
| | | var createTime = await RiskControlRRDb.Queryable<TopTenCirPartnerList>().Where(a => a.CompanyName == name).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime) |
| | | var createTime = await RiskControlRRDb.Queryable<TopTenCirPartnerList>().Where(a => a.CompanyName == name && a.date == date).OrderBy(a => a.CreateTime, OrderByType.Desc).Select(a => a.CreateTime) |
| | | .FirstAsync(); |
| | | if (createTime.AddDays(_expiredDays) >= DateTime.Now) |
| | | { |
| | | var list = await RiskControlRRDb.Queryable<TopTenCirPartnerList>().Where(a => a.CompanyName == name).ToListAsync(); |
| | | var list = await RiskControlRRDb.Queryable<TopTenCirPartnerList>().Where(a => a.CompanyName == name && a.date == date).ToListAsync(); |
| | | result.Data = list; |
| | | return result; |
| | | } |
| | | |
| | | // 2.不存在或过期 |
| | | await RiskControlRRDb.Deleteable<TopTenCirPartnerList>().Where(a => a.CompanyName == name).ExecuteCommandAsync(); |
| | | await RiskControlRRDb.Deleteable<TopTenCirPartnerList>().Where(a => a.CompanyName == name && a.date == date).ExecuteCommandAsync(); |
| | | } |
| | | var qccResult = _api.GetTopTenCirPartnerList(new TopTenCirPartnerListQuery() { name = name, date = date }); |
| | | if (qccResult.status == "200") |
| | |
| | | list?.ForEach(a => { |
| | | a.CreateTime = DateTime.Now; |
| | | a.CompanyName = name; |
| | | a.date = date; |
| | | }); |
| | | |
| | | if (_expiredDays > 0) await RiskControlRRDb.Insertable(list).ExecuteCommandAsync(); |