public decimal updateLiveAibo()
{
DataTable dt = AiboHtml.GetTableOutHtml();
//using (SoccerScoreCompact match = new SoccerScoreCompact(cnn))
//{
var ll = Conn.match.Live_Aibo.Where(e => e.Live_Aibo_id > 0);
Conn.match.Live_Aibo.DeleteAllOnSubmit(ll);//更新后删除
Conn.match.SubmitChanges();
foreach (DataRow aa in dt.Rows)
{
if (HtmlTextToStr(aa[3].ToString()) != null) // && HtmlTextToStr(aa[11].ToString()) == null
{
Live_Aibo lo = new Live_Aibo();
lo.Value = HtmlTextToStr(aa[1].ToString());
lo.LeagueName = HtmlTextToStr(aa[2].ToString());
lo.Match_time = HtmlTextToStr(aa[3].ToString());
lo.MatchOrder1_HomeName = AiboTeamName(aa[5].ToString());
lo.MatchOrder1_HandicapNumber = HtmlTextToStr(aa[6].ToString());
lo.MatchOrder1_AwayName = AiboTeamName(aa[7].ToString());
Conn.match.Live_Aibo.InsertOnSubmit(lo);
}
}
Conn.match.SubmitChanges();
return Conn.match.Live_Aibo.Max(e => e.Live_Aibo_id);
//}
}
public decimal updateLiveAibo()
{
DataTable dt = AiboHtml.GetTableOutHtml();
using (DataClassesMatchDataContext match = new DataClassesMatchDataContext(Conn.conn))
{
var ll = match.Live_Aibo.Where(e => e.Live_Aibo_id > 0);
match.Live_Aibo.DeleteAllOnSubmit(ll);//更新后删除
match.SubmitChanges();
foreach (DataRow aa in dt.Rows)
{
if (HtmlTextToStr(aa[3].ToString()) != null) // && HtmlTextToStr(aa[11].ToString()) == null
{
Live_Aibo lo = new Live_Aibo();
lo.KeyValue = HtmlTextToStr(aa[1].ToString());
lo.LeagueName = HtmlTextToStr(aa[2].ToString());
lo.Match_time = HtmlTextToStr(aa[3].ToString());
lo.MatchOrder1_HomeName = AiboTeamName(aa[5].ToString());
lo.MatchOrder1_HandicapNumber = HtmlTextToStr(aa[6].ToString());
lo.MatchOrder1_AwayName = AiboTeamName(aa[7].ToString());
match.Live_Aibo.InsertOnSubmit(lo);
}
}
match.SubmitChanges();
return match.Live_Aibo.Max(e => e.Live_Aibo_id);
}
}
partial void DeleteLive_Aibo(Live_Aibo instance);
partial void UpdateLive_Aibo(Live_Aibo instance);
partial void InsertLive_Aibo(Live_Aibo instance);