/// <summary>
/// 根据彩种并且开奖时间降序最新信息
/// </summary>
/// <returns></returns>
public normal_lotterydetail GetNowIssuNo(string LotteryCode)
{
using (var db = BaseFactory.GetDbContext())
{
normal_lotterydetail issue = db.Queryable <normal_lotterydetail>().Where(n => n.LotteryCode == LotteryCode).OrderBy(n => n.OpenTime, OrderByType.Desc).First();
return(issue);
}
}
public async Task <int> AddLotteryDetal(List <lotterydetail> lotterydetails, string gameCode)
{
using (var db = BaseFactory.GetDbContext())
{
int count = 0;
int insertCount = 0;
var LotteryCode = db.Queryable <sys_lottery>().Where(x => x.LotteryCode == gameCode).First();
//normal_lotterydetail nld = GetNowIssuNo(gameCode);
foreach (var item in lotterydetails)
{
//if (nld != null && gameCode != "sfc" && gameCode != "jq4" && gameCode != "zc6")
//{
// if (nld.IssueNo == item.expect)
// {
// break;
// }
//}
var strlotterydetail = GetCodelotterydetail(gameCode, item.expect);
if (strlotterydetail != null)
{
DateTime date = DateTime.Now.AddDays(-10);
if (NeedReGet(strlotterydetail.CurrentSales) && Convert.ToDateTime(strlotterydetail.OpenTime) > date)
{
strlotterydetail.LotteryDataDetail = item.teams.Count == 0 ? (item.NumberType != null ? item.openCode + "|" + item.NumberType : item.openCode) : JsonConvert.SerializeObject(item.teams);
strlotterydetail.LotteryResultDetail = item.dltLists.Count == 0 ? gameCode != "ttcx4" ? JsonConvert.SerializeObject(item.openLotteryDetails) : JsonConvert.SerializeObject(item.ttcx4Details) : JsonConvert.SerializeObject(item.dltLists);
strlotterydetail.UpdateTime = DateTime.Now;
strlotterydetail.PrizePool = item.PoolRolling;
strlotterydetail.CurrentSales = item.SalesVolume;
count = db.Updateable(strlotterydetail).ExecuteCommand();
log.Info(LotteryCode.LotteryName + "彩种" + strlotterydetail.IssueNo + "期期号更新完毕");
}
}
else
{
normal_lotterydetail lotterydetail = new normal_lotterydetail();
lotterydetail.IssueNo = item.expect;
lotterydetail.LotteryId = LotteryCode.Lottery_Id;
lotterydetail.LotteryCode = LotteryCode.LotteryCode;
lotterydetail.OpenTime = item.openTime;
lotterydetail.AwardDeadlineTime = item.endTime;
lotterydetail.LotteryDataDetail = item.teams.Count == 0 ? (item.NumberType != null ? item.openCode + "|" + item.NumberType : item.openCode) : JsonConvert.SerializeObject(item.teams);
lotterydetail.CurrentSales = item.SalesVolume;
lotterydetail.PrizePool = item.PoolRolling;
lotterydetail.Sys_IssueId = item.Sys_IssueId;
lotterydetail.LotteryResultDetail = item.dltLists.Count == 0 ? gameCode != "ttcx4" ? JsonConvert.SerializeObject(item.openLotteryDetails) : JsonConvert.SerializeObject(item.ttcx4Details) : JsonConvert.SerializeObject(item.dltLists);
lotterydetail.CreateTime = DateTime.Now;
lotterydetail.Url_Type = item.Url_Type;
count = db.Insertable(lotterydetail).ExecuteCommand();
log.Info(LotteryCode.LotteryName + "彩种" + item.expect + "期采集详情完毕");
insertCount += count;
}
}
return(await Task.FromResult(insertCount));
}
}
public void Addnormal_lotterydetail(List <fc3D> ModelList)
{
try
{
var LotteryCode = db.Queryable <sys_lottery>().Where(x => x.LotteryCode == "sd").First();
if (LotteryCode == null)
{
return;
}
List <normal_lotterydetail> result = new List <normal_lotterydetail>();
string Issue = string.Empty;
ModelList.ForEach((a) =>
{
bool b = db.Queryable <normal_lotterydetail>().Where(x => x.LotteryCode == LotteryCode.LotteryCode && x.IssueNo == a.expect).Count() > 0 ? true : false;
if (!b)
{
normal_lotterydetail _Lotterydetail = new normal_lotterydetail
{
LotteryId = LotteryCode.Lottery_Id,
LotteryCode = LotteryCode.LotteryCode,
IssueNo = a.expect,
LotteryDataDetail = a.opencode + "+" + a.TestNumber + "|" + a.numberType,
LotteryResultDetail = JsonConvert.SerializeObject(a.SubItemList),
OpenTime = a.LotteryDate,
AwardDeadlineTime = a.AwardDeadline,
CurrentSales = a.SalesVolume,
CreateTime = DateTime.Now,
Url_Type = (int)CollectionUrlEnum.url_500kaijiang
};
db.Insertable(_Lotterydetail).ExecuteCommand();
if (string.IsNullOrEmpty(Issue))
{
Issue = a.expect;
}
}
});
Console.WriteLine($"FC3D奖期{Issue}成功新增数据");
}
catch (Exception ex)
{
throw new Exception(ex.StackTrace);
}
}
