/// <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); } }