Winform下的地图开发控件(GMap.NET)使用心得之三---批量解析地址经纬度坐标

         private  BackgroundWorker work  =   new  BackgroundWorker();

         public  FrmMainMap()
        {
            InitializeComponent();

            work.WorkerReportsProgress  =   true ;
            work.DoWork  +=   new  DoWorkEventHandler(work_DoWork);
            work.RunWorkerCompleted  +=   new  RunWorkerCompletedEventHandler(work_RunWorkerCompleted);
            work.ProgressChanged  +=   new  ProgressChangedEventHandler(work_ProgressChanged);
        }

         void  work_ProgressChanged( object  sender, ProgressChangedEventArgs e)
        {
             this .progressBar.Value  =  e.ProgressPercentage;
             this .tsslTips.Text  =  e.UserState.ToString();
        }

         private   void  FrmMainMap_FormClosing( object  sender, FormClosingEventArgs e)
        {
            work.DoWork  -=   new  DoWorkEventHandler(work_DoWork);
            work.RunWorkerCompleted  -=   new  RunWorkerCompletedEventHandler(work_RunWorkerCompleted);
        } 

         void  work_RunWorkerCompleted( object  sender, RunWorkerCompletedEventArgs e)
        {
             string  tips  =   string .Format( " 更新完成, 共成功更新数据 {0} 个 " , e.Result);
             this .tsslTips.Text  =  tips;
             this .progressBar.Value  =   100 ;
            MessageUtil.ShowTips(tips);
        }

         void  work_DoWork( object  sender, DoWorkEventArgs e)
        {
             string  sql  =   " select t.ID, t.company_addr from tbpark_enterprise t where t.company_addr is not null and t.latitude is null  " ;
            Database db  =  DatabaseFactory.CreateDatabase();
            DbCommand command  =  db.GetSqlStringCommand(sql);
            Dictionary < int ,  string >  addrList  =   new  Dictionary < int ,  string > ();
             using  (IDataReader dr  =  db.ExecuteReader(command))
            {
                SmartDataReader reader  =   new  SmartDataReader(dr);
                 while  (reader.Read())
                {
                     int  id  =  reader.GetInt32( " ID " );
                     string  addr  =  reader.GetString( " company_addr " );
                    work.ReportProgress( 10 ,  string .Format( " 正在处理地址[ {0} ] " , addr));

                     if  ( ! string .IsNullOrEmpty(addr))
                    {
                         int  sindex  =  addr.IndexOfAny( new   char [] {  ' （ ' ,  ' ( '  });
                         if  (sindex  >   0 )
                        {
                            addr  =  addr.Substring( 0 , sindex);
                        }

                         if  ( ! addrList.ContainsKey(id))
                        {
                            addrList.Add(id, addr);
                        }
                    }
                }
            }
            work.ReportProgress( 20 ,  string .Format( " 获取列表地址信息结束，正在获取Google地图坐标... " ));

             int  totoal  =  addrList.Count;
             double  step  =  Convert.ToDouble( 100 )  /  totoal;
             int  i  =   1 ;
             int  successCount  =   0 ;
             foreach  ( int  id  in  addrList.Keys)
            {
                 int  percent  =  Convert.ToInt32(step  *  i);
                work.ReportProgress(percent,  string .Format( " 正在获取Google地图坐标...,已成功获取 {0} 个 " , successCount));

                 try
                {
                     string  addr  =  addrList[id];
                    GeoCoderStatusCode unknow  =  GeoCoderStatusCode.Unknow;
                    PointLatLng ?  latLngFromGeocoder  =  Singleton < GMaps > .Instance.GetLatLngFromGeocoder(addr,  out  unknow);
                     if  (latLngFromGeocoder.HasValue  &&  (unknow  ==  GeoCoderStatusCode.G_GEO_SUCCESS))
                    {
                        PointLatLng latLng  =  latLngFromGeocoder.Value;

                        sql  =   string .Format( " Update tbpark_enterprise t set t.LATITUDE={0}, t.LONGITUDE={1} where t.ID={2} " ,
                            latLng.Lat, latLng.Lng, id);
                        command  =  db.GetSqlStringCommand(sql);
                         bool  success  =  db.ExecuteNonQuery(command)  >   0 ;
                         if  (success)
                        {
                            successCount ++ ;
                        }
                    }
                     else
                    {
                        LogHelper.Info(unknow.ToString());
                    }
                }
                 catch  (Exception ex)
                {
                    LogHelper.Error(ex);
                }

                i ++ ;
            }
            e.Result  =  successCount;
        }

string  addr  =  addrList[id];
                    GeoCoderStatusCode unknow  =  GeoCoderStatusCode.Unknow;
                    PointLatLng ?  latLngFromGeocoder  =  Singleton < GMaps > .Instance.GetLatLngFromGeocoder(addr,  out  unknow);
                     if  (latLngFromGeocoder.HasValue  &&  (unknow  ==  GeoCoderStatusCode.G_GEO_SUCCESS))
                    {
                        PointLatLng latLng  =  latLngFromGeocoder.Value;

                        sql  =   string .Format( " Update tbpark_enterprise t set t.LATITUDE={0}, t.LONGITUDE={1} where t.ID={2} " ,
                            latLng.Lat, latLng.Lng, id);
                        command  =  db.GetSqlStringCommand(sql);
                         bool  success  =  db.ExecuteNonQuery(command)  >   0 ;
                         if  (success)
                        {
                            successCount ++ ;
                        }
                    }