static void LoadHTML()
{
#region 物件
DateTime theDate = new DateTime(2014, 7, 28);
int count = 1;
// string dir = System.Environment.CurrentDirectory;
// string url = "http://www.nfd.com.tw/lottery/39-year/39-f2017.htm";
// string url = "http://www.nfd.com.tw/lottery/39-year/39-f2016.htm";
// string url = "http://www.nfd.com.tw/lottery/39-year/39-f2015.htm";
// string url = "http://www.nfd.com.tw/lottery/39-year/39-f2014.htm";
string url = "http://www.nfd.com.tw/lottery/39-year/39-f2013.htm";
int year = 2013;
HttpClient client;
HttpContent content;
HttpResponseMessage message;
HtmlDocument document = new HtmlDocument();
Models.Number numberData;
SQLOperation operation = new SQLOperation();
#endregion
using (client = new HttpClient()){
using (message = client.GetAsync(url).Result){
content = message.Content;
if (content != null)
{
document.LoadHtml(content.ReadAsStringAsync().Result);
var table = document.DocumentNode.SelectSingleNode("//table");
var trList = table.SelectNodes("//tr");//.Skip(0);
foreach (var item in trList)
{
if (count <= 1)
{
count++;
continue;
}
numberData = new Models.Number();
numberData.NumberDate = DateTime.Parse(
String.Concat(year, "/", RemoveTag(item.SelectSingleNode("td[2]").InnerText)));
numberData.num1 = int.Parse(RemoveTag(item.SelectSingleNode("td[4]").InnerText));
numberData.num2 = int.Parse(RemoveTag(item.SelectSingleNode("td[5]").InnerText));
numberData.num3 = int.Parse(RemoveTag(item.SelectSingleNode("td[6]").InnerText));
numberData.num4 = int.Parse(RemoveTag(item.SelectSingleNode("td[7]").InnerText));
numberData.num5 = int.Parse(RemoveTag(item.SelectSingleNode("td[8]").InnerText));
numberData.Periods = PaddingZero(
(year - 1911).ToString(), RemoveTag(item.SelectSingleNode("td[3]").InnerText));
Console.WriteLine(numberData.NumberDate.ToShortDateString() + " " + numberData.num1 + " " +
numberData.num2 + " " + numberData.num3 + " " + numberData.num4 + " " + numberData.num5 + " " +
numberData.Periods);
Console.WriteLine(operation.InsertHistory(numberData));
}
}
}
}
}
