Esempio n. 1
0
        private void btnSearch_Click(object sender, EventArgs e)
        {
            bool         bLinear  = rbLinearRef.Checked;
            String       strQuery = tbSearch.Text;
            FormQueryRaw form     = new FormQueryRaw(m_strAttribute, bLinear, strQuery);

            if (form.ShowDialog() == DialogResult.OK)
            {
                tbSearch.Text = form.m_strQuery;
            }
            dataAdapter.Update((DataTable)binding.DataSource);
            CreateDataGridView();
        }
Esempio n. 2
0
        private void btnAdvancedSearch_Click(object sender, EventArgs e)
        {
            dataAdapter.Update((DataTable)binding.DataSource);
            dataAdapter.Dispose();

            String       strQuery           = tbAdvancedSearch.Text;
            FormQueryRaw formAdvancedSearch = new FormQueryRaw(m_strAsset, strQuery);

            if (formAdvancedSearch.ShowDialog() == DialogResult.OK)
            {
                tbAdvancedSearch.Text = formAdvancedSearch.m_strQuery;
                m_advancedSearchText  = formAdvancedSearch.m_strQuery;
            }
            UpdateAssetGrid();
        }
Esempio n. 3
0
        private void AssetAdvancedSearch()
        {
            String strQuery = "";

            if (MainMapImage.Map.Layers.Count > 0)
            {
                strQuery = tbAdvancedSearch.Text;
                FormQueryRaw form = new FormQueryRaw(MainMapImage.Map.Layers[0].LayerName, strQuery);
                if (form.ShowDialog() == DialogResult.OK)
                {
                    tbAdvancedSearch.Text = form.m_strQuery;

                    // Find the geoms that match the where clause of the query.  Then redraw the layer with only
                    // those geoms?  Or highlight those geoms?
                    List <Geometry> listGeoms = new List <Geometry>();
                    strQuery = "SELECT GEO_ID FROM " + MainMapImage.Map.Layers[0].LayerName + " WHERE " + form.m_strQuery;
                    DataReader dr;
                    try
                    {
                        dr = new DataReader(strQuery);
                        while (dr.Read())
                        {
                            try
                            {
                                m_listGeomIDs.Add(dr["GEO_ID"].ToString());
                            }
                            catch (Exception excInner)
                            {
                                Global.WriteOutput("Warning: Point not valid." + excInner.Message + " " + dr[0].ToString());
                            }
                        }
                        dr.Close();
                    }
                    catch (Exception exc)
                    {
                        Global.WriteOutput("Error: Failed to load asset geometries." + exc.Message);
                    }

                    // Add the new selection to the combobox and dgv
                    String strSelect = "SELECT * FROM " + MainMapImage.Map.Layers[0].LayerName + " WHERE GEO_ID = '";
                    String strWhere  = "";
                    for (int i = 0; i < m_listGeomIDs.Count; i++)
                    {
                        if (i < m_listGeomIDs.Count - 1)
                        {
                            strWhere += m_listGeomIDs[i] + "' OR GEO_ID = '";
                        }
                        else
                        {
                            strWhere += m_listGeomIDs[i] + "'";
                        }
                    }
                    strSelect += strWhere;
                    try
                    {
                        DataSet             ds = DBMgr.ExecuteQuery(strSelect);
                        FormGISLayerManager formGISLayerManager;
                        if (FormManager.IsFormGISLayerManagerOpen(out formGISLayerManager))
                        {
                            formGISLayerManager.SetAdvSearchColor(Color.Cyan, m_listGeomIDs);
                            m_listGeomIDs.Clear();
                        }
                    }
                    catch (Exception exc)
                    {
                        Global.WriteOutput("Error: " + exc.Message);
                    }
                }
            }
        }