Example #1
0
        protected override void StartButtonClicked(object parameters)
        {
            if (!PBS.Util.Utility.IsValidFilename(Output))
            {
                MessageBox.Show(App.Current.FindResource("msgOutputPathError").ToString(), App.Current.FindResource("msgError").ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            if (File.Exists(Output))
            {
                if (MessageBox.Show(App.Current.FindResource("msgOverwrite").ToString(), App.Current.FindResource("msgWarning").ToString(), MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
                {
                    return;
                }
                else
                {
                    try
                    {
                        File.Delete(Output);
                    }
                    catch (Exception e)
                    {
                        MessageBox.Show(e.Message, App.Current.FindResource("msgError").ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
                        return;
                    }
                }
            }
            try
            {
                string version = null;
                if (SelectedDatasourceType == "BaiduSate" || SelectedDatasourceType == "BaiduBase")
                {
                    version = "009";
                }
                else if (SelectedDatasourceType == "BaiduPanoMark")
                {
                    version = BaiDuMapManager.inst.streetudt;
                }
                else
                {
                    version = BaiDuMapManager.inst.cp.getLastVersion();
                }
                Datasource = new DataSourceBaiduOnlineMap(SelectedDatasourceType)
                {
                    OutputFileName = Output, Version = version, autoCorrectCoord = true
                };

                (Datasource as DataSourceBaiduOnlineMap).ConvertCompleted += (s, a) =>
                {
                    if (a.Successful)
                    {
                        if (!AutoConfirm)
                        {
                            string str = App.Current.FindResource("msgConvertComplete").ToString();
                            if (DoCompact)
                            {
                                str += "\r\n" + App.Current.FindResource("msgCompactResult").ToString() + (Datasource.ConvertingStatus.SizeBeforeCompact / 1024).ToString("N0") + "KB --> " + (Datasource.ConvertingStatus.SizeAfterCompact / 1024).ToString("N0") + "KB";
                            }
                            MessageBox.Show(str, "", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }


                        DataSourceAdjustCoord transferSource = new DataSourceAdjustCoord(Output);
                        Datasource = transferSource;
                        (transferSource as DataSourceAdjustCoord).ConvertCompleted += (s1, a1) =>
                        {
                            string str1 = App.Current.FindResource("msgAdjustComplete").ToString();
                            MessageBox.Show(str1, "", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        };
                        transferSource.ConvertToMBTiles(Output, "", "", "", Levels, null, false);
                    }
                };
                Datasource.ConvertCancelled += (s, a) =>
                {
                };
                BackgroundWorker bw = new BackgroundWorker();
                bw.DoWork += (s, a) =>
                {
                    IsIdle = false;
                    App.Current.Dispatcher.Invoke(new Action(() =>
                    {
                        (CMDClickStartButton as DelegateCommand).RaiseCanExecuteChanged();
                    }));
                    ESRI.ArcGIS.Client.Geometry.Envelope extent = (ESRI.ArcGIS.Client.Geometry.Envelope)_webMercator.FromGeographic(DownloadExtent);
                    try
                    {
                        PBS.Util.Geometry g = _downloadPolygon == null ? (PBS.Util.Geometry) new PBS.Util.Envelope(DownloadExtent.XMin, DownloadExtent.YMin, DownloadExtent.XMax, DownloadExtent.YMax) : _downloadPolygon;
                        if (_downloadPolygon != null)
                        {
                            MessageBox.Show(App.Current.FindResource("msgDownloadByPolygonIntro").ToString(), "", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        }
                        Datasource.ConvertToMBTiles(Output, Name, Description, Attribution, Levels, g, DoCompact);
                    }
                    catch (Exception e)
                    {
                        MessageBox.Show(e.Message, App.Current.FindResource("msgError").ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                    IsIdle = true;
                    App.Current.Dispatcher.Invoke(new Action(() =>
                    {
                        (CMDClickStartButton as DelegateCommand).RaiseCanExecuteChanged();
                    }));
                };
                bw.RunWorkerAsync();
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
        }
Example #2
0
        private void StartButtonClicked(object parameters)
        {
            string param = parameters.ToString();

            if (param == "START")
            {
                DataSourceAdjustCoord transferSource = new DataSourceAdjustCoord(DateToFetch, FileToCorrect);
                Datasource       = transferSource;
                ConvertingStatus = transferSource.ConvertingStatus;
                NotifyPropertyChanged(p => p.ConvertingStatus);
                (transferSource as DataSourceAdjustCoord).ConvertCompleted += (s1, a1) =>
                {
                    string str1 = App.Current.FindResource("msgAdjustComplete").ToString();
                    MessageBox.Show(str1, "", MessageBoxButtons.OK, MessageBoxIcon.Information);
                };

                BackgroundWorker bw = new BackgroundWorker();
                bw.DoWork += (s, a) =>
                {
                    transferSource.ConvertToMBTiles(FileToCorrect, "", "", "", new int[] { 18, 19 }, null, false);
                };
                bw.RunWorkerAsync();
            }
            else if (param == "MERGE")
            {
                IsMergeButtonEnable = false;
                BackgroundWorker bw = new BackgroundWorker();
                bw.RunWorkerCompleted += (s, a) =>
                {
                    MessageBox.Show("转换完成", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
                };
                bw.DoWork += (s, a) =>
                {
                    Datasource       = new MockDataSource();
                    ConvertingStatus = new ConvertStatus();
                    ((MockDataSource)Datasource).ConvertingStatus = ConvertingStatus;
                    NotifyPropertyChanged(p => p.ConvertingStatus);

                    List <int>       levels = new List <int>();
                    int              recordCount = 0;
                    int              totalCount = 0;
                    string           boundA = "", boundB = "";
                    SQLiteConnection _outputconn = new SQLiteConnection("Data source = " + FileToCorrect);
                    _outputconn.Open();
                    SQLiteConnection _inputconn = new SQLiteConnection("Data source = " + DateToFetch);
                    _inputconn.Open();
                    ConvertingStatus.IsInProgress = true;
                    using (SQLiteTransaction writeTran = _outputconn.BeginTransaction())
                    {
                        SQLiteCommand readCommand  = new SQLiteCommand(_inputconn);
                        SQLiteCommand writeCommand = new SQLiteCommand(_outputconn);
                        readCommand.CommandText = "select value from metadata where name = 'bounds'";
                        SQLiteDataReader reader = readCommand.ExecuteReader();
                        if (reader.Read())
                        {
                            boundA = reader.GetString(0);
                        }
                        reader.Close();

                        writeCommand.CommandText = "select value from metadata where name = 'bounds'";
                        reader = writeCommand.ExecuteReader();
                        if (reader.Read())
                        {
                            boundB = reader.GetString(0);
                        }
                        reader.Close();



                        readCommand.CommandText = "select count(*) from tiles";
                        reader = readCommand.ExecuteReader();
                        if (reader.Read())
                        {
                            totalCount = reader.GetInt32(0);
                        }
                        ConvertingStatus.TotalCount = totalCount;
                        reader.Close();
                        readCommand.CommandText = "select distinct(zoom_level) from tiles order by zoom_level";
                        reader = readCommand.ExecuteReader();
                        while (reader.Read())
                        {
                            levels.Add(reader.GetInt32(0));
                        }
                        reader.Close();


                        foreach (int level in levels)
                        {
                            readCommand.CommandText = "select count(*) from tiles where zoom_level = " + level;
                            reader = readCommand.ExecuteReader();
                            reader.Read();
                            int levelCount     = reader.GetInt32(0);
                            int levelCompleted = 0;
                            ConvertingStatus.Level              = level;
                            ConvertingStatus.LevelTotalCount    = levelCount;
                            ConvertingStatus.LevelCompleteCount = ConvertingStatus.LevelErrorCount = 0;
                            reader.Close();
                            readCommand.CommandText = "select zoom_level, tile_column, tile_row, tile_data from tiles where zoom_level = " + level;
                            reader = readCommand.ExecuteReader();
                            while (reader.Read())
                            {
                                int    col  = reader.GetInt32(1);
                                int    row  = reader.GetInt32(2);
                                byte[] data = (byte[])reader.GetValue(3);
                                try
                                {
                                    WriteTilesToSqlite(level, col, row, data, writeCommand);
                                }
                                catch (Exception e)
                                {
                                }
                                finally
                                {
                                    levelCompleted++;
                                    recordCount++;
                                    ConvertingStatus.LevelCompleteCount = levelCompleted;
                                    ConvertingStatus.CompleteCount      = recordCount;
                                    TotalPercent = ConvertingStatus.CompletePercent;
                                }
                            }
                            reader.Close();
                        }
                        writeCommand.CommandText = "update metadata set value = @bound where name = 'bounds'";
                        writeCommand.Parameters.AddWithValue("bound", mergeBounds(boundA, boundB));
                        writeCommand.ExecuteNonQuery();

                        writeTran.Commit();
                        writeTran.Dispose();
                    }
                    ConvertingStatus.IsInProgress = false;
                    _inputconn.Close();
                    _inputconn.Dispose();
                    _outputconn.Close();
                    _outputconn.Dispose();
                };
                bw.RunWorkerAsync();
            }
        }