public int InsertLiveHtmlTableToDB(string _html) { SqlAgilityPackTableXpath tbTag = new SqlAgilityPackTableXpath("live.win.7m.cn"); HtmlAgilityPackGeneric SevenmLivesg = new HtmlAgilityPackGeneric(_html, tbTag.tbTag, 0);//容易出错,主要路径的转换 DataTable dt = SevenmLivesg.GetTableOutHtml(); //容易出错,注意方法的转换 DataClassesMatchDataContext match = new DataClassesMatchDataContext(Conn.conn); //if (!Conn.CreateTable(typeof(Live_Single))) { return 0; } foreach (DataRow aa in dt.Rows) { if (aa[8] != null) if (aa[8].ToString() != "") if (aa[8].ToString().Trim() != "") { status = HtmlTextToStr(aa[8].ToString()).Trim(); //北京单场 if (status != "让球") { if (status.Length >= 1 && status.Length <= 2) { Live_Single ls = new Live_Single(); status = HtmlTextToStr(aa[9].ToString()).Trim(); ls.Html_position = GetNumber(HtmlTextToStr(aa[0].ToString())); ls.Home_team_big = GetNumber(HtmlHrefToStr(aa[4].ToString())); ls.Away_team_big = GetNumber(HtmlHrefToStr(aa[6].ToString())); ls.Status = status; match.Live_Single.InsertOnSubmit(ls); } } //竞猜 if (status.IndexOf(".") != -1) { Live_Single ls = new Live_Single(); ls.Html_position = GetNumber(HtmlTextToStr(aa[0].ToString())); ls.Home_team_big = GetNumber(HtmlHrefToStr(aa[4].ToString())); ls.Away_team_big = GetNumber(HtmlHrefToStr(aa[6].ToString())); ls.Status = status; match.Live_Single.InsertOnSubmit(ls); } } } match.SubmitChanges(); return match.Live_Single.Max(e => e.Live_Single_id); }
public SevenmResultToSql(string _html) { SqlAgilityPackTableXpath tbTag = new SqlAgilityPackTableXpath("data2.7m.cn"); SevenmResult = new HtmlAgilityPackGeneric(_html, tbTag.tbTag, 1); //SevenmResult = new HtmlAgilityPackGeneric(_html, "//table[@id='result_tb']", 1); }
private void button34_Click(object sender, EventArgs e) { HtmlAgilityPackGeneric t = new HtmlAgilityPackGeneric(webBrowser2.Document.Body.InnerHtml, textBox4.Text, Int32.Parse(textBox5.Text)); dataGridView4.DataSource = t.GetTableInnerText(); }
public OkooHtmlToSql(string _html) { SqlAgilityPackTableXpath tbTag = new SqlAgilityPackTableXpath("buy.okooo.com"); OkooHtml = new HtmlAgilityPackGeneric(_html, tbTag.tbTag, 0); //OkooHtml = new HtmlAgilityPackGeneric(_html, "//table[@id='TableBorder']", 0); }
public SevenmLiveToSql(string _html) { SqlAgilityPackTableXpath tbTag = new SqlAgilityPackTableXpath("live2.7m.cn"); SevenmLive = new HtmlAgilityPackGeneric(_html, tbTag.tbTag, 0); //SevenmLive = new HtmlAgilityPackGeneric(_html, "//table[@id='live_Table']", 0); }
//public AiboHtmlToSql(string _html) public AiboLiveToSql (string _html) { SqlAgilityPackTableXpath tbTag = new SqlAgilityPackTableXpath("live.aibo123.com"); AiboHtml = new HtmlAgilityPackGeneric(_html, tbTag.tbTag, 0); //AiboHtml = new HtmlAgilityPackGeneric(_html, "//table[@id='TableBorder']", 0); }
public MacauslotToSql(string _html) { SqlAgilityPackTableXpath tbTag = new SqlAgilityPackTableXpath("web.macauslot.com"); MacauslotHtml = new HtmlAgilityPackGeneric(_html, tbTag.macauTag, 0); }