/// <summary>
/// 增加一条数据
/// </summary>
public void AddMatch(SeoWebSite.Model.OddsLiveMatch model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into oddslive_match(");
strSql.Append("id,name,urlparams,time)");
strSql.Append(" values (");
strSql.Append("@id,@name,@urlparams,@time)");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.VarChar),
new SqlParameter("@name", SqlDbType.NVarChar),
new SqlParameter("@urlparams", SqlDbType.VarChar),
new SqlParameter("@time", SqlDbType.DateTime)
};
parameters[0].Value = model.id;
parameters[1].Value = model.name;
parameters[2].Value = model.urlparams;
parameters[3].Value = model.time;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 获得列表
/// </summary>
/// <returns></returns>
public List<OddsLiveMatch> GetScrollMatchList()
{
List<OddsLiveMatch> liveMatchList = new List<OddsLiveMatch>();
try
{
HttpHelper h = new HttpHelper();
Cookie lng = new Cookie("lng", "2");
lng.Domain = domain;
h.CookieContainer.Add(lng);
string zoudi = h.GetHtml("https://" +domain+ "/default.aspx"+ zoudiUrl);
if (!string.IsNullOrEmpty(zoudi))
{
#region 分析网页html节点
Lexer lexer = new Lexer(zoudi);
Parser parser = new Parser(lexer);
NodeList bodyNodes = parser.Parse(new TagNameFilter("HTML"))[0].Children.ExtractAllNodesThatMatch(new TagNameFilter("BODY"))[0].Children;
ITag divNode = bodyNodes.ExtractAllNodesThatMatch(new TagNameFilter("FORM"))[0].Children.ExtractAllNodesThatMatch(new TagNameFilter("DIV"))[0] as ITag;
if (divNode.Attributes["ID"].Equals("PageBody"))
{
NodeList dataDivList = divNode.Children.SearchFor(typeof(Winista.Text.HtmlParser.Tags.Div));
if (dataDivList[0].ToPlainTextString() == "走地盤")
{
if (dataDivList[2].ToPlainTextString() == "全場賽果")
{
return liveMatchList;
}
for (int i = 0; i < dataDivList.Count; i++)
{
ITag div = dataDivList[i] as ITag;
if (div.Attributes["CLASS"] != null && div.Attributes["CLASS"].Equals("menuRow"))
{
OddsLiveMatch oddsLive = new OddsLiveMatch();
oddsLive.urlparams = (div.FirstChild as ITag).Attributes["HREF"].ToString();
oddsLive.id = oddsLive.urlparams.Split('&')[0].Substring(4);
oddsLive.time = DateTime.Now;
oddsLive.name = div.ToPlainTextString();
liveMatchList.Add(oddsLive);
}
}
}
}
#endregion 分析网页html节点
}
}
catch (Exception)
{
}
return liveMatchList;
}
public void AddLiveMatch(OddsLiveMatch model)
{
dal.AddMatch(model);
}
