public decimal updateLiveAibo() { DataTable dt = AiboHtml.GetTableOutHtml(); using (SoccerScoreSqlite match = new SoccerScoreSqlite(Conn.cnn)) { var ll = match.LiveAibo.Where(e => e.LiveAiboID> 0); match.LiveAibo.DeleteAllOnSubmit(ll);//更新后删除 match.SubmitChanges(); foreach (DataRow aa in dt.Rows) { if (HtmlTextToStr(aa[3].ToString()) != null) // && HtmlTextToStr(aa[11].ToString()) == null { LiveAibo lo = new LiveAibo(); lo.Value = HtmlTextToStr(aa[1].ToString()); lo.LeagueName = HtmlTextToStr(aa[2].ToString()); lo.MatchTime = HtmlTextToStr(aa[3].ToString()); lo.MatchOrder1hOmeName = AiboTeamName(aa[5].ToString()); lo.MatchOrder1hAndicapNumber= HtmlTextToStr(aa[6].ToString()); lo.MatchOrder1aWayName = AiboTeamName(aa[7].ToString()); match.LiveAibo.InsertOnSubmit(lo); } } match.SubmitChanges(); return match.LiveAibo.Select(e => e.LiveAiboID).Max(); } }
public decimal updateLiveOkoo() { DataTable dt = OkooHtml.GetTableOutHtml(); using (SoccerScoreSqlite match = new SoccerScoreSqlite(Conn.cnn)) //using (DataClassesMatchDataContext match = new DataClassesMatchDataContext()) { var ll = match.LiveOkOO.Where(e => e.LiveOkOOID > 0); match.LiveOkOO.DeleteAllOnSubmit(ll);//更新后删除 match.SubmitChanges(); foreach (DataRow aa in dt.Rows) { if (HtmlTextToStr(aa[15].ToString()) != null) { LiveOkOO lo = new LiveOkOO(); lo.Value = HtmlValueToInt(aa[0].ToString()); lo.LeagueName = HtmlTextToStr(aa[1].ToString()); lo.MatchTime = HtmlTextToStr(aa[2].ToString()); lo.MatchOrder1hOmeName = TeamName(aa[3].ToString()); lo.MatchOrder1hAndicapNumber = HtmlTextToStr(aa[4].ToString()); lo.MatchOrder1aWayName = TeamName(aa[5].ToString()); lo.Ok10 = HtmlTextToStr(aa[6].ToString()); lo.Ok11 = HtmlTextToStr(aa[7].ToString()); lo.Ok12 = HtmlTextToStr(aa[8].ToString()); lo.MatchInfo = HtmlTextToStr(aa[11].ToString()); lo.Match1wIn = HtmlTextToStr(aa[12].ToString()); lo.Match1dRawn = HtmlTextToStr(aa[13].ToString()); lo.Match1lOst = HtmlTextToStr(aa[14].ToString()); match.LiveOkOO.InsertOnSubmit(lo); match.SubmitChanges(); } } return match.LiveOkOO.Select(e => e.LiveOkOOID).Max(); } }
public void top20Algorithm() { using ( SoccerScoreSqlite matches = new SoccerScoreSqlite(Conn.cnn)) { int i = 0; foreach (var id in idExc) { i++; ProgressBarDelegate.DoSendPMessage(i); Application.DoEvents(); RowNumberLimit r = new RowNumberLimit(id); // match_analysis_result mar = new match_analysis_result(); MatchAnalysisResult mar = new MatchAnalysisResult(); mar.LiveTableLibID= r.id; mar.PreAlgorithm = "top20"; mar.PreMatchCount = r.Top20Count; mar.HomeGoals =(float) r.HomeGoals; mar.AwayGoals = (float)r.AwayGoals; mar.HomeW = r.hWin; mar.HomeD = r.hDraw; mar.HomeL = r.hLose; mar.FitWinLoss = (float)r.CureFitWinLoss; mar.FitGoals = (float) r.CureFitGoals; mar.FitOddEven = (float)r.CureFitOddEven; matches.MatchAnalysisResult.InsertOnSubmit(mar); } matches.SubmitChanges(); } }
public decimal InsertLastHtmlTableToDB() { DataTable dt = SevenmResult.GetHtmlTable(); //DataClassesMatchDataContext match = new DataClassesMatchDataContext(); SoccerScoreSqlite match = new SoccerScoreSqlite(Conn.cnn); foreach (DataRow aa in dt.Rows) { if (HtmlTextToStr(aa[3].ToString()) != null) { ResultTB rt = new ResultTB(); rt.HTMLPosition = aa[0].ToString(); rt.MatchType = HtmlTextToStr(aa[1].ToString()); rt.STime= HtmlTextToStr(aa[2].ToString()); rt.HomeTeam = HtmlTextToStr(aa[3].ToString()); rt.FullTimeScore = HtmlTextToStr(aa[4].ToString()); rt.AwayTeam = HtmlTextToStr(aa[5].ToString()); rt.HalfTimeScore = HtmlTextToStr(aa[6].ToString()); rt.Odds = HtmlTextToStr(aa[7].ToString()); rt.WinLossBig = HtmlTextToStr(aa[8].ToString()); rt.SDate = HtmlDateToStrResult(aa[2].ToString()); rt.HomeTeamBig = HtmlHrefToStr(aa[3].ToString()); rt.AwayTeamBig = HtmlHrefToStr(aa[5].ToString()); match.ResultTB.InsertOnSubmit(rt); match.SubmitChanges(); } } return match.ResultTB.Select(e => e.ResultTBID).Max(); }
private void button9_Click_1(object sender, EventArgs c) { Uri uri = new Uri(textBox3.Text); string host = uri.Host; using (SoccerScoreSqlite match = new SoccerScoreSqlite(Conn.cnn)) { var eUri = match.MatchTableXPath.Where(e => e.UriHost == host).FirstOrDefault(); if (eUri == null) { MatchTableXPath nUri = new MatchTableXPath(); nUri.UriHost = host.ToString(); nUri.MaXTableXPath = textBox4.Text; nUri.SecondTableXPath = textBox6.Text; nUri.MaXTableIDValue = textBox7.Text; nUri.SecondTableIDValue = textBox8.Text; match.MatchTableXPath.InsertOnSubmit(nUri); } else { eUri.UriHost = host.ToString(); eUri.MaXTableXPath = textBox4.Text; eUri.SecondTableXPath = textBox6.Text; eUri.SecondTableIDValue = textBox7.Text; eUri.SecondTableIDValue = textBox8.Text; //match.match_table_xpath.InsertOnSubmit(eUri); } match.SubmitChanges(); } MessageBox.Show("OK"); }
public void UpdateLastMatch() { int i = 0; // DataClassesMatchDataContext matches = new DataClassesMatchDataContext(); SoccerScoreSqlite matches = new SoccerScoreSqlite(Conn.cnn); IEnumerable<ResultTB> rt = matches.ResultTB.OrderBy(o => o.SDate).ThenBy(p => p.STime);//用lambda表达式简洁 //取临时变量监视 DateTime lib_max_match_time = matches.ResultTBLib.Select(p => p.MatchTime).Max().Value.AddDays(-2); foreach (var m in rt) { i++; ProgressBarDelegate.DoSendPMessage(i); Application.DoEvents(); if (m.HomeTeamBig != null) { ResultTBLib rtl = new ResultTBLib(); rtl.HTMLPosition = Int32.Parse(m.HTMLPosition); rtl.HomeTeamBig= Int32.Parse(GetNumber(m.HomeTeamBig)); rtl.AwayTeamBig = Int32.Parse(GetNumber(m.AwayTeamBig)); rtl.MatchType= m.MatchType.Trim(); last_line = m.STime.LastIndexOf("\n"); temp_time=m.STime.Substring(last_line,m.STime.Length-last_line-1); rtl.MatchTime = DateTime.Parse(m.SDate.Substring(0, 10) + " " + temp_time); rtl.Odds= m.Odds.Trim(); rtl.WinLossBig = m.WinLossBig.Trim(); rtl.HomeTeam = m.HomeTeam.Trim(); rtl.AwayTeam= m.AwayTeam.Trim(); rtl.HomeRedCard= StringCount(m.HomeTeam, " ", 0); rtl.AwayRedCard = StringCount(m.AwayTeam, " ", 0); string bf = m.FullTimeScore.Replace(" ", "").Replace(" ", ""); if (m.FullTimeScore.IndexOf("-") > 0) { rtl.FullHomeGoals= Int32.Parse(bf.Substring(0, bf.IndexOf("-"))); rtl.FullAwayGoals= Int32.Parse(bf.Substring(bf.IndexOf("-") + 1, bf.Length - bf.IndexOf("-") - 1)); } if (m.HalfTimeScore.IndexOf("-") > 0) { rtl.HalfHomeGoals= Int32.Parse(m.HalfTimeScore.Substring(0, m.HalfTimeScore.IndexOf("-"))); rtl.HalfAwayGoals = Int32.Parse(m.HalfTimeScore.Substring(m.HalfTimeScore.IndexOf("-") + 1, m.HalfTimeScore.Length - m.HalfTimeScore.IndexOf("-") - 1)); } //如果库中文件的日期太小,直接删除 if (rtl.MatchTime > lib_max_match_time) { //数据分区,层次化查询 IEnumerable<ResultTBLib> rtExist = from p in matches.ResultTBLib where p.MatchTime== rtl.MatchTime where p.HomeTeamBig== rtl.HomeTeamBig where p.AwayTeamBig== rtl.AwayTeamBig select p; //库中没有记录直接插入 if (!rtExist.Any()) { matches.ResultTBLib.InsertOnSubmit(rtl); matches.SubmitChanges(); } } //更新后删除 matches.ResultTB.DeleteOnSubmit(m); matches.SubmitChanges(); } } MessageBox.Show("OK"); //dataGridView1.DataSource = matches.result_tb_lib; }