public int InsertLiveHtmlTableToDB() { DataTable dt = SevenmLive.GetHtmlTable(); DataClassesMatchDataContext match = new DataClassesMatchDataContext(Conn.conn); if (!Conn.CreateTable(typeof(Live_Table))) { return 0; } //var result = match.Live_Table.Where(r => r.Live_table_id > 0); //match.Live_Table.DeleteAllOnSubmit(result); //match.SubmitChanges(); string ddate = null; string ndate = null; //修改当天完场的问题 2011.6.11 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 { todayDate.Dequeue();//删除第1条 2011.6.11 ndate = todayDate.Peek();//取第1个元素 2011.6.11 ddate = ndate; } } 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.Max(e => e.Live_table_id); }
public decimal InsertLiveHtmlTableToDB() { DataTable dt = SevenmLive.GetHtmlTable(); //SoccerScoreCompact match = new SoccerScoreCompact(cnn); var result = Conn.match.Live_Table.Where(r => r.Live_table_id > 0); Conn.match.Live_Table.DeleteAllOnSubmit(result); //Conn.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()); Conn.match.Live_Table.InsertOnSubmit(lt); } Conn.match.SubmitChanges(); } return Conn.match.Live_Table.Select(e => e.Live_table_id).Max(); }
partial void DeleteLive_Table(Live_Table instance);
partial void UpdateLive_Table(Live_Table instance);
partial void InsertLive_Table(Live_Table instance);