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