PageRenderTime 51ms CodeModel.GetById 21ms RepoModel.GetById 0ms app.codeStats 0ms

/SqlCompact/Soccer Score Forecast/Soccer Score Forecast/DAL_HtmlSql/AiboLiveToSql.cs

http://htmlconvertsql.googlecode.com/
C# | 59 lines | 49 code | 5 blank | 5 comment | 2 complexity | 8caffc5fc2d0b761c27ec08d0253ebba MD5 | raw file
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Data;
  6. using System.IO;
  7. using System.Data.Linq;
  8. using System.Data.Linq.Mapping;
  9. using System.Reflection;
  10. using System.Linq.Expressions;
  11. using System.ComponentModel;
  12. using HtmlAgilityPack;
  13. using SoccerScore.Compact.Linq;
  14. using System.Windows.Forms;
  15. namespace Soccer_Score_Forecast
  16. {
  17. class AiboLiveToSql : ElementParserFunction
  18. {
  19. private HtmlAgilityPackGeneric AiboHtml;
  20. //public AiboHtmlToSql(string _html)
  21. public AiboLiveToSql (string _html)
  22. {
  23. SqlAgilityPackTableXpath tbTag = new SqlAgilityPackTableXpath("live.aibo123.com");
  24. AiboHtml = new HtmlAgilityPackGeneric(_html, tbTag.tbTag, 0);
  25. //AiboHtml = new HtmlAgilityPackGeneric(_html, "//table[@id='TableBorder']", 0);
  26. }
  27. public decimal updateLiveAibo()
  28. {
  29. DataTable dt = AiboHtml.GetTableOutHtml();
  30. //using (SoccerScoreCompact match = new SoccerScoreCompact(cnn))
  31. //{
  32. var ll = Conn.match.Live_Aibo.Where(e => e.Live_Aibo_id > 0);
  33. Conn.match.Live_Aibo.DeleteAllOnSubmit(ll);//?????
  34. Conn.match.SubmitChanges();
  35. foreach (DataRow aa in dt.Rows)
  36. {
  37. if (HtmlTextToStr(aa[3].ToString()) != null) // && HtmlTextToStr(aa[11].ToString()) == null
  38. {
  39. Live_Aibo lo = new Live_Aibo();
  40. lo.Value = HtmlTextToStr(aa[1].ToString());
  41. lo.LeagueName = HtmlTextToStr(aa[2].ToString());
  42. lo.Match_time = HtmlTextToStr(aa[3].ToString());
  43. lo.MatchOrder1_HomeName = AiboTeamName(aa[5].ToString());
  44. lo.MatchOrder1_HandicapNumber = HtmlTextToStr(aa[6].ToString());
  45. lo.MatchOrder1_AwayName = AiboTeamName(aa[7].ToString());
  46. Conn.match.Live_Aibo.InsertOnSubmit(lo);
  47. }
  48. }
  49. Conn.match.SubmitChanges();
  50. return Conn.match.Live_Aibo.Max(e => e.Live_Aibo_id);
  51. //}
  52. }
  53. }
  54. }