Exemple #1
0
        /// <summary>
        /// Click event handler of the addMSSQLSpatialLayerToolStripMenuItem control.
        /// </summary>
        /// <param name="sender">The source object of this event.</param>
        /// <param name="e">The event parameters.</param>
        private void addMSSQLSpatialLayerToolStripMenuItem_Click(object sender, EventArgs e)
        {
            TreeNode source = CurrentTree.SelectedNode;
            if (source != null && source.Tag != null)
                RaiseItemSelect((MapObjectHolder)source.Tag);

            int numlayers = map.numlayers;

            SqlConnectionDialog form = new SqlConnectionDialog();
            if (form.ShowDialog(this) == DialogResult.OK)
            {
                layerObj layer = null;
                try
                {
                    // trying to open the layer
                    MapUtils.TestMSSQLConnection(form.GetConnectionString(), form.GetDataString());

                    layer = CreateNewLayer();
                    layer.connectiontype = MS_CONNECTION_TYPE.MS_PLUGIN;
                    layer.plugin_library = layer.plugin_library_original = "msplugin_mssql2008.dll";

                    layer.connection = form.GetConnectionString();
                    layer.data = form.GetDataString();

                    switch (form.GeometryType)
                    {
                        case "Point":
                        case "MultiPoint":
                            layer.type = MS_LAYER_TYPE.MS_LAYER_POINT;
                            break;
                        case "LineString":
                        case "MultiLineString":
                            layer.type = MS_LAYER_TYPE.MS_LAYER_LINE;
                            break;
                        case "Polygon":
                        case "MultiPolygon":
                            layer.type = MS_LAYER_TYPE.MS_LAYER_POLYGON;
                            break;
                        default:
                            layer.type = MS_LAYER_TYPE.MS_LAYER_LINE;
                            break;
                    }

                    MapUtils.CreateRandomClass(layer);
                    MapUtils.InitializeDefaultLabel(layer);

                    layer.name = MapUtils.GetUniqueLayerName(map, form.TableName, 0);
                    string projName;
                    string proj4text;
                    int epsg;

                    if (form.GetProj4Text() != null)
                    {
                        projName = MapUtils.FindProjection(form.GetProj4Text(), out proj4text, out epsg);
                        layer.setProjection(form.GetProj4Text());
                        layer.setMetaData("coordsys_name", projName);
                    }
                    else if (form.GetSRText() != null && form.GetSRText() != "")
                    {
                        SpatialReference srs = new SpatialReference(form.GetSRText());
                        string proj4;
                        srs.ExportToProj4(out proj4);
                        if (proj4 != null || proj4 != "")
                        {
                            projName = MapUtils.FindProjection(proj4, out proj4text, out epsg);
                            //Steph: looks like there was a copy and paste error, I have replaced form.GetProj4Text() with proj4text
                            layer.setProjection(proj4text);
                            layer.setMetaData("coordsys_name", projName);
                        }
                    }
                    else
                        layer.setProjection("AUTO");

                    layer.status = mapscript.MS_ON;

                    // setting up the selected layer
                    selected = new MapObjectHolder(layer, target.GetParent());
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Unable to open layer, " + ex.Message, "MapManager", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    if (layer != null)
                    {
                        if (layer.map != null)
                            layer.map.removeLayer(layer.index);
                        layer = null;
                    }
                    return;
                }

                // if this is the first layer or the map projection hasn't been set zoom to this extent
                if (map.numlayers == 1 || map.getProjection().Trim().Length == 0)
                {
                    ZoomToLayerExtent(layer);
                    if (InitialExtentSet != null)
                        InitialExtentSet(this, null);

                    // setting the projection of the map according to the layer projection
                    string proj = layer.getProjection().Trim();
                    if (proj.Length > 0 && proj != "+AUTO")
                    {
                        map.setProjection(proj);
                        // setting up the default unit
                        if (proj.Contains("+proj=longlat"))
                            map.units = MS_UNITS.MS_DD;
                        else
                            map.units = MS_UNITS.MS_METERS;
                    }
                }

                if (target != null)
                    target.RaisePropertyChanged(this);
                RefreshView();

                TreeNode src = CurrentTree.SelectedNode;
                if (src != null && src.Tag != null)
                    RaiseItemSelect((MapObjectHolder)src.Tag);
                UpdateToolbar();
            }
        }
        /// <summary>
        /// Click event handler of the buttonData control.
        /// </summary>
        /// <param name="sender">The source object of this event.</param>
        /// <param name="e">The event parameters.</param>
        private void buttonData_Click(object sender, EventArgs e)
        {
            if (comboBoxPlugin.SelectedItem != null &&
                comboBoxPlugin.SelectedItem.ToString() == "msplugin_mssql2008.dll")
            {
                SqlConnectionDialog cd = new SqlConnectionDialog();
                if (textBoxConnection.Text.Trim() != "")
                    cd.SetConnectionString(textBoxConnection.Text.Trim());
                if (textBoxData.Text.Trim() != "")
                    cd.SetDataString(textBoxData.Text.Trim());
                if (cd.ShowDialog(this) == DialogResult.OK)
                {
                    try
                    {
                        MapUtils.TestMSSQLConnection(cd.GetConnectionString(), cd.GetDataString());

                        textBoxConnection.Text = cd.GetConnectionString();
                        string data = cd.GetDataString();
                        if (data != null)
                            textBoxData.Text = data;

                        SetDirty(true);
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("Unable to open layer, " + ex.Message, "MapManager", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                }
                return;
            }

            if (layer.map != null)
                openFileDialog.InitialDirectory = layer.map.shapepath;
            openFileDialog.Filter = null;
            if (openFileDialog.ShowDialog(this) == DialogResult.OK)
            {
                textBoxData.Text = openFileDialog.FileName;
                SetDirty(true);
            }
        }