public decimal updateLiveOkoo()
{
DataTable dt = OkooHtml.GetTableOutHtml();
using (DataClassesMatchDataContext match = new DataClassesMatchDataContext(Conn.conn))
{
var ll = match.Live_okoo.Where(e => e.Live_okoo_id > 0);
match.Live_okoo.DeleteAllOnSubmit(ll);//更新后删除
match.SubmitChanges();
foreach (DataRow aa in dt.Rows)
{
if (HtmlTextToStr(aa[15].ToString()) != null)
{
Live_okoo lo = new Live_okoo();
lo.KeyValue = HtmlValueToInt(aa[0].ToString());
lo.LeagueName = HtmlTextToStr(aa[1].ToString());
lo.Match_time = HtmlTextToStr(aa[2].ToString());
lo.MatchOrder1_HomeName = TeamName(aa[3].ToString());
lo.MatchOrder1_HandicapNumber = HtmlTextToStr(aa[4].ToString());
lo.MatchOrder1_AwayName = TeamName(aa[5].ToString());
lo.Ok_1_0 = HtmlTextToStr(aa[6].ToString());
lo.Ok_1_1 = HtmlTextToStr(aa[7].ToString());
lo.Ok_1_2 = HtmlTextToStr(aa[8].ToString());
lo.MatchInfo = HtmlTextToStr(aa[11].ToString());
lo.Match_1_Win = HtmlTextToStr(aa[12].ToString());
lo.Match_1_Drawn = HtmlTextToStr(aa[13].ToString());
lo.Match_1_Lost = HtmlTextToStr(aa[14].ToString());
match.Live_okoo.InsertOnSubmit(lo);
match.SubmitChanges();
}
}
return match.Live_okoo.Max(e => e.Live_okoo_id);
}
}
partial void DeleteLive_okoo(Live_okoo instance);
partial void UpdateLive_okoo(Live_okoo instance);
partial void InsertLive_okoo(Live_okoo instance);