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