HtmlAgility 抓取網頁上的資料

 /// <summary>
    /// 財政部mca
    /// http://www.mca.gov.cn/article/sj/xzqh/1980/
    /// https://github.com/zzzprojects/html-agility-pack
    /// https://github.com/linezero/HtmlAgilityPack
    /// </summary>
    public partial class Form1 : Form
    {

        int codecell = 2;
        int namecell = 3;
        int yearnmae = 2019;
        string tableNo = "table";
        string trNo = "tr";
        string tdthNo = "th|td";
        DataTable  McaData()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("year", typeof(int)); //年份
            dt.Columns.Add("website", typeof(string)); //財政部網址
            dt.Columns.Add("codecell", typeof(int));  //行政區劃編碼在表格的第幾列
            dt.Columns.Add("namecell", typeof(int));  //行政區劃名稱在表格的第幾列
            dt.Columns.Add("tableNo", typeof(string));  //表格標識
            dt.Columns.Add("trNo", typeof(string));  //行標識
            dt.Columns.Add("tdthNo", typeof(string));  //列標識
            dt.Rows.Add(2019, "http://www.mca.gov.cn/article/sj/xzqh/1980/2019/202002281436.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2018, "http://www.mca.gov.cn/article/sj/xzqh/1980/201903/201903011447.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2017, "http://www.mca.gov.cn/article/sj/xzqh/1980/201803/201803131454.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2016, "http://www.mca.gov.cn/article/sj/xzqh/1980/201705/201705311652.html", 2, 3, "table//tbody", "tr", "th|td");//TBODY 都是大寫
            dt.Rows.Add(2015, "http://www.mca.gov.cn/article/sj/tjbz/a/2015/201706011127.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2014, "http://files2.mca.gov.cn/cws/201502/20150225163817214.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2013, "http://files2.mca.gov.cn/cws/201404/20140404125552372.htm", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2012, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201707271556.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2011, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201707271552.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2010, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220946.html", 2, 3, "table", "tr", "th|td");          
            dt.Rows.Add(2009, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220943.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2008, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220941.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2007, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220939.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2006, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220936.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2005, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220935.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2004, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220930.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2003, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220928.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2002, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220927.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2001, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220925.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2000, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220923.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1999, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220921.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1998, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220918.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1997, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220916.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1996, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220914.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1995, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220913.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1994, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220911.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1993, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708041023.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1992, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220910.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1991, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708041020.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1990, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708041018.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1989, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708041017.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1988, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220903.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1987, "http://www.mca.gov.cn/article/sj/xzqh/1980/1980/201911180950.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1986, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220859.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1985, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220858.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1984, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220856.html", 1, 2, "table", "tr", "th|td");
            dt.Rows.Add(1983, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708160821.html", 1, 2, "table", "tr", "th|td");
            dt.Rows.Add(1982, "http://www.mca.gov.cn/article/sj/xzqh/1980/1980/201911180942.html", 1, 2, "table", "tr", "th|td");
            dt.Rows.Add(1981, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708041004.html", 1, 2, "table", "tr", "th|td");
            dt.Rows.Add(1980, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708040959.html", 1, 2, "table", "tr", "th|td");
            return dt;
        }

        /// <summary>
        /// 
        /// </summary>
        public Form1()
        {
            InitializeComponent();
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Form1_Load(object sender, EventArgs e)
        {
            this.comboBox1.DataSource = McaData();
            this.comboBox1.DisplayMember = "year";
            this.comboBox1.ValueMember = "website";
        }
        /// <summary>
        /// 抓取資料
        /// Geovin Du 涂聚文
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                string website = this.comboBox1.SelectedValue.ToString();

                //codecell =(int)this.numericUpDown1.Value;
                //namecell = (int)this.numericUpDown2.Value;
                HtmlAgilityPack.HtmlWeb webClient = new HtmlAgilityPack.HtmlWeb();
                HtmlAgilityPack.HtmlDocument doc = webClient.Load(website);
                this.richTextBox1.Text = doc.Text.ToLower();
                //HtmlNodeCollection nodes = doc.DocumentNode.SelectNodes("/html[1]/body[1]/div[1]/div[2]/div[3]/div[2]/div[1]/div[1]/div[1]/div");
                //foreach (HtmlNode node in nodes)
                //{
                //    Console.WriteLine(node.InnerText.Trim());
                //}
                //nodes = null;

                yearnmae = int.Parse(this.comboBox1.Text);
                DataRow[] drsselect = McaData().Select("year="+yearnmae+"");
                for (int i = 0; i < drsselect.Length; i++)
                {

                    codecell =int.Parse(drsselect[i]["codecell"].ToString());
                    namecell= int.Parse(drsselect[i]["namecell"].ToString());
                    tableNo = drsselect[i]["tableNo"].ToString();
                    trNo = drsselect[i]["trNo"].ToString();
                    tdthNo = drsselect[i]["tdthNo"].ToString();
                }


                List<AreaInfo> list = new List<AreaInfo>();
                foreach (HtmlNode table in doc.DocumentNode.SelectNodes("//"+tableNo))
                {
                    //Console.WriteLine("Found: " + table.Id);
                    AreaInfo info = null;
                    
                    foreach (HtmlNode rows in table.SelectNodes(trNo))
                    {
                        info = new AreaInfo();
                        int cell = 1;                        
                        foreach (HtmlNode cells in rows.SelectNodes(tdthNo))
                        {                            
                            if(cell==codecell)
                            {
                                info.AreaCode = cells.InnerText.Trim().Replace(" ", "").Trim(); 
      
                            }
                            if(cell==namecell)
                            {
                                info.AreaName = cells.InnerText.Trim().Replace(" ", "").Trim();

                            }                           
                            cell++;
                        }
                        if(!string.IsNullOrEmpty(info.AreaCode))
                        { 
                           list.Add(info);
                        }
                    }
                }


                doc = null;
                webClient = null;
                this.bindingSource1.DataSource = list;
                this.bindingNavigator1.BindingSource = this.bindingSource1;
                this.dataGridView1.DataSource = this.bindingSource1;
            }
            catch(Exception ex)
            {

                ex.Message.ToString();
            }
            

        }

 /// <summary>
    /// 財政部mca
    /// http://www.mca.gov.cn/article/sj/xzqh/1980/
    /// https://github.com/zzzprojects/html-agility-pack
    /// 20200307 edit Geovin Du 涂聚文
    ///統計局 市轄區http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2019/index.html
    /// </summary>
    public partial class MacForm : Form
    {


        private  int codecell = 2;
        private  int namecell = 3;
        private  int yearnmae = 2019;
        private  string tableNo = "table";
        private  string trNo = "tr";
        private  string tdthNo = "th|td";
        static DataTable McaData()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("year", typeof(int)); //年份
            dt.Columns.Add("website", typeof(string)); //財政部網址
            dt.Columns.Add("codecell", typeof(int));  //行政區劃編碼在表格的第幾列
            dt.Columns.Add("namecell", typeof(int));  //行政區劃名稱在表格的第幾列
            dt.Columns.Add("tableNo", typeof(string));  //表格標識
            dt.Columns.Add("trNo", typeof(string));  //行標識
            dt.Columns.Add("tdthNo", typeof(string));  //列標識
            dt.Rows.Add(2019, "http://www.mca.gov.cn/article/sj/xzqh/1980/2019/202002281436.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2018, "http://www.mca.gov.cn/article/sj/xzqh/1980/201903/201903011447.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2017, "http://www.mca.gov.cn/article/sj/xzqh/1980/201803/201803131454.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2016, "http://www.mca.gov.cn/article/sj/xzqh/1980/201705/201705311652.html", 2, 3, "table//tbody", "tr", "th|td");//TBODY 都是大寫
            dt.Rows.Add(2015, "http://www.mca.gov.cn/article/sj/tjbz/a/2015/201706011127.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2014, "http://files2.mca.gov.cn/cws/201502/20150225163817214.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2013, "http://files2.mca.gov.cn/cws/201404/20140404125552372.htm", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2012, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201707271556.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2011, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201707271552.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2010, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220946.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2009, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220943.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2008, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220941.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2007, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220939.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2006, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220936.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2005, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220935.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2004, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220930.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2003, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220928.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2002, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220927.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2001, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220925.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(2000, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220923.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1999, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220921.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1998, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220918.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1997, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220916.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1996, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220914.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1995, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220913.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1994, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220911.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1993, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708041023.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1992, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220910.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1991, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708041020.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1990, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708041018.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1989, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708041017.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1988, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220903.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1987, "http://www.mca.gov.cn/article/sj/xzqh/1980/1980/201911180950.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1986, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220859.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1985, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220858.html", 2, 3, "table", "tr", "th|td");
            dt.Rows.Add(1984, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708220856.html", 1, 2, "table", "tr", "th|td");
            dt.Rows.Add(1983, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708160821.html", 1, 2, "table", "tr", "th|td");
            dt.Rows.Add(1982, "http://www.mca.gov.cn/article/sj/xzqh/1980/1980/201911180942.html", 1, 2, "table", "tr", "th|td");
            dt.Rows.Add(1981, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708041004.html", 1, 2, "table", "tr", "th|td");
            dt.Rows.Add(1980, "http://www.mca.gov.cn/article/sj/tjbz/a/201713/201708040959.html", 1, 2, "table", "tr", "th|td");
            return dt;
        }

        /// <summary>

        /// </summary>
        public MacForm()
        {
            InitializeComponent();
        }
        /// <summary>
        /// 抓取資料
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Form4_Load(object sender, EventArgs e)
        {
            this.comboBox1.DataSource = McaData();
            this.comboBox1.DisplayMember = "year";
            this.comboBox1.ValueMember = "website";
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                string website = this.comboBox1.SelectedValue.ToString();

                //codecell =(int)this.numericUpDown1.Value;
                //namecell = (int)this.numericUpDown2.Value;
                HtmlAgilityPack.HtmlWeb webClient = new HtmlAgilityPack.HtmlWeb();
                HtmlAgilityPack.HtmlDocument doc = webClient.Load(website);
                this.richTextBox1.Text = doc.Text.ToLower();
                //HtmlNodeCollection nodes = doc.DocumentNode.SelectNodes("/html[1]/body[1]/div[1]/div[2]/div[3]/div[2]/div[1]/div[1]/div[1]/div");
                //foreach (HtmlNode node in nodes)
                //{
                //    Console.WriteLine(node.InnerText.Trim());
                //}
                //nodes = null;

                yearnmae = int.Parse(this.comboBox1.Text);
                DataRow[] drsselect = McaData().Select("year=" + yearnmae + "");
                for (int i = 0; i < drsselect.Length; i++)
                {

                    codecell = int.Parse(drsselect[i]["codecell"].ToString());
                    namecell = int.Parse(drsselect[i]["namecell"].ToString());
                    tableNo = drsselect[i]["tableNo"].ToString();
                    trNo = drsselect[i]["trNo"].ToString();
                    tdthNo = drsselect[i]["tdthNo"].ToString();
                }

                int k = 1;
                List<DuAreaInfo> list = new List<DuAreaInfo>();
                foreach (HtmlNode table in doc.DocumentNode.SelectNodes("//" + tableNo))
                {
                    //Console.WriteLine("Found: " + table.Id);
                    DuAreaInfo info = null;

                    foreach (HtmlNode rows in table.SelectNodes(trNo))
                    {
                        info = new DuAreaInfo();
                        int cell = 1;
                        foreach (HtmlNode cells in rows.SelectNodes(tdthNo))
                        {
                            if (cell == codecell)
                            {
                                info.AreaCode = cells.InnerText.Trim().Replace(" ", "").Trim();

                            }
                            if (cell == namecell)
                            {
                                info.AreaName = cells.InnerText.Trim().Replace(" ", "").Trim();

                            }
                            cell++;
                        }
                        if (!string.IsNullOrEmpty(info.AreaCode))
                        {
                            if(IsNumber(info.AreaCode)) //char.IsDigit
                            {
                                info.AreaId = k;
                                list.Add(info);
                                k++;
                            }
                                
                        }
                    }
                }
                //直轄市的二級行政區劃少了，添加，便于二級目錄樹形操作
                int index = 0;

                //var query = from DuAreaInfo du in list
                //            where du.AreaName== "北京市"
                //            select du;

                index = list.FindIndex(x => x.AreaName.Trim() == "北京市");
                if(index >= 0) 
                    list.Insert(index+1,new DuAreaInfo { AreaCode = "110100", AreaName = "直轄市區" });

                index = list.FindIndex(x => x.AreaName.Trim() == "天津市");
                if (index > 0)
                    list.Insert(index + 1, new DuAreaInfo { AreaCode = "120100", AreaName = "直轄市區" });
                index = list.FindIndex(x => x.AreaName.Trim() == "上海市");
                if (index > 0)
                    list.Insert(index + 1, new DuAreaInfo { AreaCode = "310100", AreaName = "直轄市區" });
                index = list.FindIndex(x => x.AreaName.Trim() == "重慶市");
                if (index > 0)
                    list.Insert(index + 1, new DuAreaInfo { AreaCode = "500100", AreaName = "直轄市區" });
                index = list.FindIndex(x => x.AreaName.Trim() == "武隆區");
                if (index > 0)
                    list.Insert(index + 1, new DuAreaInfo { AreaCode = "500200", AreaName = "直轄市縣" });

                k = 1;
                List<DuAreaInfo> newlist = new List<DuAreaInfo>();
                //
                foreach(DuAreaInfo newinfo in list)
                {
                    newlist.Add(new DuAreaInfo { AreaId = k, AreaCode = newinfo.AreaCode, AreaName = newinfo.AreaName });
                    k++;
                }

                IEnumerable<DuAreaInfo> htmlValue = https://www.cnblogs.com/dearroy/p/GetRegValue(newlist);
                // 中國省市串列
                var areaList1 = new List();
                var unDoArray = new[] {"自治區直轄縣級行政區劃", "市轄區", "縣", "省直轄縣級行政區劃" };
                // 省份資料物件
                var province = new List<AreaInfo>();
                // 城市資料物件
                var city = new List<AreaInfo>();
                // 區縣資料物件
                var county = new List<AreaInfo>();
                var provinceModel = new AreaInfo();
                var cityModel = new AreaInfo();
                var countyModel = new AreaInfo();

                //
                List<AreaInfo> areaList = (from v in htmlValue
                                           let name = v.AreaName.Replace("自治區直轄縣級行政區劃", "縣").Replace("市轄區", "市").Replace("省直轄縣級行政區劃", "縣")
                                           .Replace("縣", "")
                                           select new AreaInfo
                                           {
                                               AreaId = v.AreaId,
                                               AreaCode = v.AreaCode.Substring(0, 6),
                                               AreaName = v.AreaName,
                                               AreaFullName = v.AreaName,
                                               ParentAreaCode = "0",
                                               ParentId = 0,
                                               CreateTime = DateTime.Now,
                                               AreaYear = yearnmae
                                           }).ToList();


                foreach (AreaInfo ali in areaList)
                {
                    string id = GetCityAreaId(ali.AreaCode);
                    //var areaModel = new AreaInfo();
                    //省
                    var areaModel = new AreaInfo
                    {
                        AreaId=ali.AreaId,
                        AreaCode = id,
                        AreaName = ali.AreaName,
                        AreaFullName = ali.AreaName,
                        ParentId = 0,
                        ParentAreaCode="0",
                        AreaYear = yearnmae,
                        AreaType="2",
                        CreateTime = DateTime.Now
                    };
                    switch (id.Length)
                    {
                        case 2://省
                            provinceModel.AreaId = ali.AreaId;
                            provinceModel.AreaCode = id;
                            provinceModel.AreaFullName = ali.AreaName;
                            provinceModel.AreaYear = yearnmae;
                            provinceModel.AreaType = "2";                            
                            provinceModel.ParentId = 0;                      
                          
                            break;
                        case 4://市
                            cityModel.AreaId = ali.AreaId;
                            cityModel.AreaCode = id;
                            cityModel.AreaName = ali.AreaName;
                            cityModel.ParentId = provinceModel.AreaId;                 
                            areaModel.AreaFullName =
                                cityModel.AreaFullName =
                                    provinceModel.AreaFullName + (unDoArray.Contains(cityModel.AreaName) ? "" : cityModel.AreaName);
                            areaModel.ParentAreaCode = cityModel.ParentAreaCode = provinceModel.AreaCode;
                            areaModel.ParentId = cityModel.ParentId;
                            areaModel.AreaYear = yearnmae;
                            areaModel.AreaType = "2";
                            break;
                        case 6://縣
                            countyModel.AreaId = ali.AreaId;
                            countyModel.AreaCode = id;
                            countyModel.AreaName = ali.AreaName;
                            countyModel.ParentId = cityModel.AreaId;                         
                            areaModel.AreaFullName = countyModel.AreaFullName = cityModel.AreaFullName + ali.AreaName;
                            areaModel.ParentAreaCode =
                                countyModel.ParentAreaCode =
                                    unDoArray.Contains(cityModel.AreaName) ? provinceModel.AreaCode : cityModel.AreaCode;
                            areaModel.AreaYear = yearnmae;
                            areaModel.ParentId = countyModel.ParentId;
                            areaModel.AreaType = "2";
                            break;
                        default:
                            throw new Exception("【例外操作】資料操作例外！");
                    }

                    if (!unDoArray.Contains(areaModel.AreaName))
                    {
                        areaList1.Add(areaModel);

                    }
                }

                doc = null;
                webClient = null;
                this.bindingSource1.DataSource = newlist;
                this.bindingNavigator1.BindingSource = this.bindingSource1;
                this.dataGridView1.DataSource = this.bindingSource1;
                this.dataGridView2.DataSource=areaList;
                this.dataGridView3.DataSource = province;
                this.dataGridView4.DataSource = city;
                this.dataGridView5.DataSource = county;
                this.dataGridView6.DataSource = areaList1;
            }
            catch (Exception ex)
            {

                ex.Message.ToString();
            }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="list"></param>
        /// <returns></returns>
        private static IEnumerable<DuAreaInfo> GetRegValue(List<DuAreaInfo> list)
        {        
           
            return (from DuAreaInfo m in list
                    select new DuAreaInfo
                    {
                        AreaId = m.AreaId,
                        AreaCode = m.AreaCode,
                        AreaName=m.AreaName
                    }).ToList();
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="strNumber"></param>
        /// <returns></returns>
        public static bool IsNumber(string strNumber)
        {
            bool isok = false;
            try
            {
                System.Text.RegularExpressions.Regex r = new System.Text.RegularExpressions.Regex(@"^[+-]?\d*[.]?\d*$");
                isok=r.IsMatch(strNumber);
            }
            catch (Exception ex)
            {
                ex.Message.ToString();
            }

            return isok;
        }

標籤：其他

上一篇：深度學習網路中的引數確定

下一篇：《深入理解 C# (第2版)》 - 學習筆記