private void Vpn_PageData()
{
log.Info($"Entered Vpn_PageData.");
log.Info($" Currently on page {current_page}/{total_pages}.");
#region write in sql table
/// 取得gvList
HTMLDocument d = (HTMLDocument)m.vpnweb.Document;
IHTMLElement gvDownLoad = d.getElementById(DOM_FOR_ACTUAL_DATA);
log.Info($"[{DOM_FOR_ACTUAL_DATA}] is read.");
/// 讀取
/// 20200503 我發現Html Agility Pack不能click
/// 只好第一層是ihtmlelement
IHTMLElementCollection trs_ = gvDownLoad.all;
IHTMLElementCollection trs = trs_.tags("tr");
DateTime current_time = DateTime.Now;
// 使用item這個方法可以將集合中的元素取出
// 第一個參數代表的是順序,但是在msdn中標示為name
// 第二個參數msdn中標示為index,但經過測試後,指的並不是順序,所以目前無法確定他的用途
// 如果有知道的朋友,也請跟我說一下
// current_line = 0 是標題行
/// 20200503 我發現Html Agility Pack不能click
/// 只好第一層是ihtmlelement
VPN_files.Clear();
for (current_line = 1; current_line < trs.length; current_line++)
{
IHTMLElement tr = trs.item(current_line, null);
HtmlDocument h_ = new HtmlDocument();
h_.LoadHtml(tr.innerHTML);
HtmlNodeCollection tds = h_.DocumentNode.SelectNodes("//td");
tbl_download result = _td_parcer(tds);
using (NHIDataContext dc = new NHIDataContext())
{
var q = from p in dc.tbl_download
where (p.f_name == result.f_name) && (p.SDATE == result.SDATE)
select p;
if (q.Count() == 0)
{
result.QDATE = current_time;
dc.tbl_download.InsertOnSubmit(result);
dc.SubmitChanges();
log.Info($" [{result.f_name}] added to SQL server");
}
}
}
#endregion write in sql table
#region download files
// making queue_files
foreach (KeyValuePair <int, string> v in VPN_files)
{
if (!Local_files.Contains(v.Value))
{
queue_files.Enqueue(v.Key);
log.Info($" {v.Key}: {v.Value} enqueued.");
}
}
if ((queue_files.Count == 0) && (current_page == total_pages))
{
// 這頁讀完, 且所有頁都讀完了.
m.Refresh_Table();
tb.ShowBalloonTip("結束", "完成所有頁面讀取", BalloonIcon.Info);
}
else if (queue_files.Count == 0)
{
log.Info($" Nothing enqueued on page {current_page}/{total_pages}");
Goto_next_page();
}
else
{
// 有東西才需要執行
tb.ShowBalloonTip("計時器開始", $"一共{queue_files.Count}個檔案要下載", BalloonIcon.Info);
// initialization
current_line = 0;
current_line = queue_files.Dequeue();
// execution
this._timer1 = new System.Timers.Timer
{
Interval = 6000
};
this._timer1.Elapsed += new System.Timers.ElapsedEventHandler(TimersTimer_Elapsed);
log.Info($" _timer1 started.");
this._timer1.Start();
}
#endregion download files
log.Info("Exited Vpn_PageData.");
}
private tbl_download Clinic_TD_Parcer(HtmlNodeCollection tds)
{
log.Info(" Enter Clinic_TD_Parcer");
short order_n = 0;
tbl_download newNHI = new tbl_download();
foreach (HtmlNode td in tds)
{
try
{
switch (order_n)
{
case 0: //檔案名稱
newNHI.f_name = td.InnerText;
break;
case 1: //檔案說明
newNHI.f_remark = td.InnerText;
break;
case 2: //下載備註
newNHI.remark = td.InnerText;
break;
case 3: //提供下載日期
if (td.InnerText != string.Empty)
{
HtmlNode div = td.ChildNodes[1]; // 怪,第一個member竟然是/r/n
string[] temp_s = div.InnerHtml.Replace("<br>", "|").Split('|');
string[] temp_d = temp_s[0].Split('/');
newNHI.SDATE = DateTime.Parse($"{int.Parse(temp_d[0]) + 1911}/{temp_d[1]}/{temp_d[2]} {temp_s[1]}");
}
break;
case 4: //檔案下載
switch (td.SelectNodes("//a").Count)
{
case 2:
newNHI.download = true;
break;
case 1:
newNHI.download = false;
break;
default:
break;
}
break;
default:
break;
}
order_n++;
}
catch (Exception ex)
{
log.Error($"[{order_n}], error:{ex.Message}");
}
}
if ((bool)newNHI.download)
{
VPN_files.Add(current_line, newNHI.f_name);
log.Info($" {current_line}, {newNHI.f_name} added to VPN_files.");
}
log.Info(" Exit Clinic_TD_Parcer");
return(newNHI);
}
private tbl_download Special_TD_Parcer(HtmlNodeCollection tds)
{
log.Info(" Enter Special_TD_Parcer");
short order_n = 0;
tbl_download newNHI = new tbl_download();
foreach (HtmlNode td in tds)
{
try
{
switch (order_n)
{
case 1: //檔案名稱
//newNHI.f_name = td.InnerText;
// 20210720: 修正—改正為-
newNHI.f_name = td.InnerText.Replace('—', '-');
break;
case 2: //檔案說明
// 20210720: 修正—改正為-
//newNHI.f_remark = td.InnerText;
newNHI.f_remark = td.InnerText.Replace('—', '-');
break;
case 3: //提供下載日期
if (td.InnerText != string.Empty)
{
// 20200522, 原來要Trim掉頭尾的空白,這樣就正確了
string[] temp_s = td.InnerText.Trim().Split(' ');
string[] temp_d = temp_s[0].Split('/');
newNHI.SDATE = DateTime.Parse($"{int.Parse(temp_d[0]) + 1911}/{temp_d[1]}/{temp_d[2]} {temp_s[1]}");
}
break;
case 4: //檔案下載
switch (td.SelectNodes("//a").Count)
{
case 2:
newNHI.download = true;
break;
case 1:
newNHI.download = false;
break;
default:
break;
}
break;
default:
break;
}
order_n++;
}
catch (Exception ex)
{
log.Error($"[{order_n}], error:{ex.Message}");
}
}
if ((bool)newNHI.download)
{
VPN_files.Add(current_line, newNHI.f_name);
log.Info($" {current_line}, {newNHI.f_name} added to VPN_files.");
}
log.Info(" Exit Special_TD_Parcer");
return(newNHI);
}