browser.cs

输入网址及资料编号

using System;
using System.IO;
using System.Text;
using System.Threading;
using System.Windows.Forms;
using Alfa;

namespace WebPick
{
    public partial class Browser : Form
    {
		System.Windows.Forms.Timer myTimer = new System.Windows.Forms.Timer();
		System.Windows.Forms.Timer myTimer_close = new System.Windows.Forms.Timer();
		public BrowsPick myBP = new BrowsPick();
        public Int32 counter, counterMax;

        public string sql_table;             //資料表名稱
        public string[,] search_key;         //搜尋的關鍵字
        public string[,] sql_table_colume;   //資料表欄位結構
        public string[] str_replace_prifix;  //取回的資料處理前先取代。例如有同名稱的關鍵值abc：abc 123<br>abc 456<br>，取代為：d0 123<br>d1 456<br>
        public string[,] str_replace_subfix; //取回的資料過瀘及替換
        public string str_url_prifix;             //要流覽的網址
        public string str_tbl_start;       //流覽的開始編號
        public string str_tbl_end;         //流覽的結束編號
        public string str_url_subfix;         //要流覽的網址的後端加入的字串
		public string sql_file;            //資料表檔名
		public bool finish = false;            //資料表檔名
		public Browser()
        {
            InitializeComponent();
        }
        private void Browser_Load(object sender, EventArgs e)
        {
            //////////////////////////////////////////
            myBP.sql_table = sql_table;
            myBP.search_key = search_key;
            myBP.sql_table_colume = sql_table_colume;
            myBP.str_replace_prifix = str_replace_prifix;
            myBP.str_replace_subfix = str_replace_subfix;
            myBP.str_url_prifix = str_url_prifix;
            myBP.str_tbl_start = str_tbl_start;
            myBP.str_tbl_end = str_tbl_end;
            myBP.str_url_subfix = str_url_subfix;
            myBP.sql_file = sql_file;
            //////////////////////////////////////////
            this.richTextBox_show.Text = "";
            this.textBox_url_prifix.Text = str_url_prifix;
            this.label_url_run.Text = str_tbl_start;
            this.textBox_url_subfix.Text = str_url_subfix;

            this.textBox_table.Text = sql_table;
            this.textBox_file.Text = sql_file;

            this.textBox_start.Text = str_tbl_start;
            this.textBox_end.Text = str_tbl_end;
			this.richTextBox_show.Text = "";
			//////////////////////////////////////////
            myBP.runEnable = true;
            myBP.finish = false;
            myBP.sql_content = "SET NAMES 'utf8';\n";
            counter = Convert.ToInt32(myBP.str_tbl_start);
            counterMax = Convert.ToInt32(myBP.str_tbl_end);
            //////////////////////////////////////////
			myTimer.Tick += new EventHandler(myTimer_Tick);
            myTimer.Interval = 50;
            myTimer.Start();
			//////////////////////////////////////////
			myTimer_close.Tick += new EventHandler(myTimer_close_Tick);
			myTimer_close.Interval = 10 * 1000;
		}
        private void Browser_Closing(object sender, System.ComponentModel.CancelEventArgs e)
        {
            //myTimer.Stop();
            this.Text = "關閉中...";
            myBP.runEnable = false;
        }
		private void myTimer_close_Tick(object sender, System.EventArgs e)
		{
			this.Close();
		}
		private void myTimer_Tick(object sender, System.EventArgs e)
        {
            string str;
            if(myBP.runEnable)
            {
                if (myBP.finish)
                {
                    this.Text = "完成";
					finish = true;
                    myBP.finish = false;
                    myBP.runEnable = false;
                    if (myBP.sql_content != "")
                    {
                        StreamWriter objWriter = new StreamWriter(@"data\" + myBP.sql_file, false, Encoding.UTF8, 2048);
                        objWriter.Write(myBP.sql_content);
                        objWriter.Close();
                    }
					myTimer_close.Start();
				}
                else
                {
                    if (counter <= counterMax)
                    {
                        str = myBP.RunOnceCow(counter++);
						this.label_url_run.Text = myBP.sql_table_colume[0, 1];
						this.Text = "(" + myBP.sql_table_colume[0, 1] + ")";
						if(str != "")
                        {
                            myBP.sql_content += str;
                            richTextBox_show.AppendText(str);
                            richTextBox_show.SelectionStart = richTextBox_show.TextLength;
                            richTextBox_show.ScrollToCaret();
                            //my_richTextBox_show.Focus();
                        }
                    }
                    else
                    {
                        myBP.finish = true;
                    }
					Thread.Sleep(200);
                }
            }
        }

		private void Brower_Closing(object sender, FormClosingEventArgs e)
		{

		}
    }
}