public decimal InsertLiveHtmlTableToDB()
{
DataTable dt = SevenmLive.GetHtmlTable();
DataClassesMatchDataContext match = new DataClassesMatchDataContext();
var result = match.live_Table.Where(r => r.live_table_id > 0);
match.live_Table.DeleteAllOnSubmit(result);
match.SubmitChanges();
string ddate = null;
Queue<string> todayDate = new Queue<string>();
foreach (DataRow aa in dt.Rows)
{
if (HtmlDateToStrLive(aa[1].ToString()) != null)
{
if (HtmlDateToStrLive(aa[1].ToString()).IndexOf("最新賽果") == -1)
{
ddate = HtmlDateToStrLive(aa[1].ToString());
ddate = ddate.Replace("年", "-").Replace("月", "-").Replace("日", " ");
todayDate.Enqueue(ddate);
}
else
{
ddate = todayDate.Dequeue();
}
}
if (HtmlTextToStr(aa[3].ToString()) != null)
{
live_Table lt = new live_Table();
lt.html_position = aa[0].ToString();
lt.match_type = HtmlTextToStr(aa[2].ToString());
lt.s_time = HtmlTextToStr(aa[3].ToString());
lt.home_team = HtmlTextToStr(aa[5].ToString());
lt.full_time_score = HtmlTextToStr(aa[6].ToString());
lt.away_team = HtmlTextToStr(aa[7].ToString());
lt.half_time_score = HtmlTextToStr(aa[8].ToString());
lt.s_date = ddate;
lt.home_team_big = HtmlHrefToStr(aa[5].ToString());
lt.away_team_big = HtmlHrefToStr(aa[7].ToString());
match.live_Table.InsertOnSubmit(lt);
match.SubmitChanges();
}
}
return match.live_Table.Select(e => e.live_table_id).Max();
}
partial void Updatelive_Table(live_Table instance);
partial void Deletelive_Table(live_Table instance);
partial void Insertlive_Table(live_Table instance);
