public decimal InsertLastHtmlTableToDB()
{
DataTable dt = SevenmResult.GetHtmlTable();
//SoccerScoreCompact match = new SoccerScoreCompact(cnn);
foreach (DataRow aa in dt.Rows)
{
if (HtmlTextToStr(aa[3].ToString()) != null)
{
Result_tb rt = new Result_tb();
rt.Html_position = aa[0].ToString();
rt.Match_type = HtmlTextToStr(aa[1].ToString());
rt.S_time = HtmlTextToStr(aa[2].ToString());
rt.Home_team = HtmlTextToStr(aa[3].ToString());
rt.Full_time_score = HtmlTextToStr(aa[4].ToString());
rt.Away_team = HtmlTextToStr(aa[5].ToString());
rt.Half_time_score = HtmlTextToStr(aa[6].ToString());
rt.Odds = HtmlTextToStr(aa[7].ToString());
rt.Win_loss_big = HtmlTextToStr(aa[8].ToString());
rt.S_date = HtmlDateToStrResult(aa[2].ToString());
rt.Home_team_big = HtmlHrefToStr(aa[3].ToString());
rt.Away_team_big = HtmlHrefToStr(aa[5].ToString());
Conn.match.Result_tb.InsertOnSubmit(rt);
Conn.match.SubmitChanges();
}
}
return Conn.match.Result_tb.Select(e => e.Result_tb_id).Max();
}
partial void UpdateResult_tb(Result_tb instance);
partial void DeleteResult_tb(Result_tb instance);
partial void InsertResult_tb(Result_tb instance);
