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