Esempio n. 1
0
        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.");
        }
Esempio n. 2
0
        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);
        }
Esempio n. 3
0
        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);
        }