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