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.");
}
public void Start()
{
m.TabControl1.SelectedItem = m.TabPage1;
#region Read local files
// everytime when I pushed download key
Local_files.Clear();
// read file data from directory
int i = 1;
foreach (string f in Directory.GetFiles(LOCAL_FILES_DIRECTORY))
{
string f_ = f.Replace($"{LOCAL_FILES_DIRECTORY}\\", "");
string ff = f_.Substring(0, f_.Length - 4);
Local_files.Add(ff);
log.Info($"{i}. {ff} added to Local_files.");
i++;
}
#endregion Read local files
#region 判斷多頁
/// 取得gvList
HTMLDocument d = (HTMLDocument)m.vpnweb.Document;
IHTMLElement gvDownLoad = d.getElementById(DOM_FOR_ACTUAL_DATA);
/// is nothing ==> == null
if (gvDownLoad == null)
{
return;
}
// 20200329: wpf 要增加reference to Microsoft.mshtml, 已經沒有winform的htmlelement了
// initialize
current_page = total_pages = 0;
/// 找到雲端藥歷有幾頁
/// 設定total_pages = ????
HtmlDocument pg = new HtmlDocument();
if (d.getElementById(DOM_FOR_PAGECLICK) == null)
{
/// 沒有ContentPlaceHolder1_pg_gvList, 表示只有ㄧ頁
total_pages = 1;
log.Info($"Only one page detected.");
}
else
{
/// 有ContentPlaceHolder1_pg_gvList, 表示有多頁
/// 舊方法 pg_N = pg.Children.Count - 5;
/// 如果多頁, 轉換loadcomplete, 呼叫pager by click
// 20200502: outerHTML的XPATH="//selection/option", innerHTML的XPATH="//option"
pg.LoadHtml(d.getElementById(DOM_FOR_PAGENUMBERS).innerHTML);
HtmlNodeCollection o = pg.DocumentNode.SelectNodes("//option");
total_pages = o.Count;
log.Info($"{total_pages} pages detected.");
}
#endregion 判斷多頁
/// 前往讀取第一頁
current_page = 1;
Vpn_PageData();
}
