Пример #1
0
        private void btn_Query_Click(object sender, EventArgs e)
        {
            if (lookUpEdit_Field.EditValue == null || lookUpEdit_Layer.EditValue == null)
            {
                XtraMessageBox.Show("请选择要查询的图层及字段!", "提示");
                return;
            }

            var layerName = lookUpEdit_Layer.EditValue.ToString();
            var fieldName = lookUpEdit_Field.EditValue.ToString();
            var dt        = WorkspaceService.Instance.GetDataset(ConfigHelper.GetConfig("StationDatasourceName"),
                                                                 layerName) as DatasetVector;
            string queryFilter = "";
            var    keyword     = txt_Keyword.Text.Trim();

            queryFilter = string.IsNullOrEmpty(keyword) ? "" : string.Format("{0} like '%{1}%'", fieldName, keyword);

            var rs            = dt.Query(queryFilter, CursorType.Static);
            var selectedLayer = (LayerInfo)lookUpEdit_Layer.GetSelectedDataRow();
            var datatable     = GISUtility.RecordsetToDataTable(rs, selectedLayer);

            rs.Close();
            rs.Dispose();
            dt.Close();
            _mainForm.ShowQueryResult();
            _mainForm.CreateQueryResultGrid(datatable, selectedLayer);
            this.Close();
        }
Пример #2
0
        private void mapCtl_Station_DoubleClick(object sender, EventArgs e)
        {
            var selections = mapCtl_Station.Map.FindSelection(true);

            if (selections.Count() > 0)
            {
                var rs = selections[0].ToRecordset();
                if (rs.RecordCount > 0)
                {
                    rs.MoveFirst();
                    var smId      = rs.GetID();
                    var layerName = rs.Dataset.Name;
                    var layerInfo = LayerService.INSTANCE.GetStationLayerInfos().First(l => l.LayerName == layerName);
                    var dt        = GISUtility.RecordsetToDataTable(rs, layerInfo);
                    if (!rs.IsClosed)
                    {
                        rs.Close();
                        rs.Dispose();
                    }
                    var selectedRow = dt.Select(string.Format("SMID = '{0}'", smId))[0];
                    var eqptInfo    = new DlgEqptInfo(smId, layerInfo, ref selectedRow);
                    eqptInfo.ShowDialog();
                }
            }
        }
Пример #3
0
        void alertControl1_AlertClick(object sender, AlertClickEventArgs e)
        {
            var expireMaintains = (List <EqptMaintain>)e.Info.Tag;
            var layerEqpts      = new Dictionary <string, List <int> >();

            foreach (var eqptMaintain in expireMaintains)
            {
                if (layerEqpts.ContainsKey(eqptMaintain.LayerName))
                {
                    layerEqpts[eqptMaintain.LayerName].Add(eqptMaintain.SmId);
                }
                else
                {
                    layerEqpts.Add(eqptMaintain.LayerName, new List <int>()
                    {
                        eqptMaintain.SmId
                    });
                }
            }

            if (layerEqpts.Count < 0)
            {
                return;
            }
            this.ShowQueryResult();
            foreach (var layerEqpt in layerEqpts)
            {
                var layerinfo = LayerService.INSTANCE.GetStationLayerInfos().Any(l => l.LayerName == layerEqpt.Key) ? LayerService.INSTANCE.GetStationLayerInfos().First(l => l.LayerName == layerEqpt.Key) : LayerService.INSTANCE.GetSiteLayerInfos().First(l => l.LayerName == layerEqpt.Key);

                if (layerinfo != null)
                {
                    var dt = WorkspaceService.Instance.GetDataset(ConfigHelper.GetConfig("StationDatasourceName"), layerEqpt.Key) as DatasetVector;
                    if (dt != null)
                    {
                        var rs        = dt.Query(layerEqpt.Value.ToArray(), CursorType.Static);
                        var datatable = GISUtility.RecordsetToDataTable(rs, layerinfo);
                        rs.Close();
                        rs.Dispose();
                        dt.Close();

                        this.CreateQueryResultGrid(datatable, layerinfo);
                    }
                }
            }
        }
Пример #4
0
        private void mapCtl_Station_GeometrySelectChanged(object sender, GeometrySelectChangedEventArgs e)
        {
            xtraTabCtl_QueryResult.TabPages.Clear();
            var selections = mapCtl_Station.Map.FindSelection(true);

            dockPanel_QueryResult.Visible = selections.Length > 0;
            foreach (var selection in selections)
            {
                var rs            = selection.ToRecordset();
                var datasetName   = rs.Dataset.Name;
                var selectedLayer = LayerService.INSTANCE.GetStationLayerInfos().First(l => l.LayerName == datasetName);
                var dt            = GISUtility.RecordsetToDataTable(rs, selectedLayer);
                rs.Close();
                rs.Dispose();

                CreateQueryResultGrid(dt, selectedLayer);
            }
        }
Пример #5
0
        private void ViewAllAttribute()
        {
            var dt = WorkspaceService.Instance.GetDataset(ConfigHelper.GetConfig("StationDatasourceName"), _blinkLayerName) as DatasetVector;

            if (dt == null)
            {
                return;
            }

            var rs    = dt.GetRecordset(false, CursorType.Static);
            var table = GISUtility.RecordsetToDataTable(rs, _blinkLayerInfo);

            rs.Close();
            rs.Dispose();
            dt.Close();
            ShowQueryResult();
            CreateQueryResultGrid(table, _blinkLayerInfo);
        }
Пример #6
0
        private void btn_Query_Click(object sender, EventArgs e)
        {
            if (commbox_QueryType.SelectedIndex < 6)
            {
                if (txt_Keyword.Text.Trim() == "")
                {
                    XtraMessageBox.Show("请输入查询关键字!");
                    return;
                }
            }
            else
            {
                if (dateEdit_Start.DateTime > dateEdit_end.DateTime)
                {
                    XtraMessageBox.Show("起始时间不能的大于终止时间!");
                    return;
                }
            }

            var searchStr = "";

            switch (commbox_QueryType.SelectedIndex)
            {
            case 0:
                searchStr = string.Format("Name like '%{0}%'", txt_Keyword.Text);
                break;

            case 1:
                searchStr = string.Format("LayerName like '%{0}%'", txt_Keyword.Text);
                break;

            case 2:
                searchStr = string.Format("Department like '%{0}%'", txt_Keyword.Text);
                break;

            case 3:
                searchStr = string.Format("Maintainer like '%{0}%'", txt_Keyword.Text);
                break;

            case 4:
                searchStr = string.Format("EqptName like '%{0}%'", txt_Keyword.Text);
                break;

            case 5:
                searchStr = string.Format("Checker like '%{0}%'", txt_Keyword.Text);
                break;

            case 6:
                searchStr = string.Format("RecordDate between '{0}' and '{1}'", dateEdit_Start.DateTime, dateEdit_end.DateTime);
                break;

            case 7:
                searchStr = string.Format("MaintainDate between '{0}' and '{1}'", dateEdit_Start.DateTime, dateEdit_end.DateTime);
                break;

            case 8:
                searchStr = string.Format("NextMaintainDate between '{0}' and '{1}'", dateEdit_Start.DateTime, dateEdit_end.DateTime);
                break;
            }

            if (searchStr != "")
            {
                var maintainBll = new EqptMaintain();
                var maintains   = maintainBll.GetModelList(searchStr);
                var layerEqpts  = new Dictionary <string, List <int> >();
                foreach (var eqptMaintain in maintains)
                {
                    if (layerEqpts.ContainsKey(eqptMaintain.LayerName))
                    {
                        layerEqpts[eqptMaintain.LayerName].Add(eqptMaintain.SmId);
                    }
                    else
                    {
                        layerEqpts.Add(eqptMaintain.LayerName, new List <int>()
                        {
                            eqptMaintain.SmId
                        });
                    }
                }

                if (layerEqpts.Count < 0)
                {
                    return;
                }
                _mainForm.ShowQueryResult();
                foreach (var layerEqpt in layerEqpts)
                {
                    var layerinfo = LayerService.INSTANCE.GetStationLayerInfos().Any(l => l.LayerName == layerEqpt.Key) ? LayerService.INSTANCE.GetStationLayerInfos().First(l => l.LayerName == layerEqpt.Key) : LayerService.INSTANCE.GetSiteLayerInfos().First(l => l.LayerName == layerEqpt.Key);

                    if (layerinfo != null)
                    {
                        var dt = WorkspaceService.Instance.GetDataset(ConfigHelper.GetConfig("StationDatasourceName"), layerEqpt.Key) as DatasetVector;
                        if (dt != null)
                        {
                            var rs        = dt.Query(layerEqpt.Value.ToArray(), CursorType.Static);
                            var datatable = GISUtility.RecordsetToDataTable(rs, layerinfo);
                            rs.Close();
                            rs.Dispose();
                            dt.Close();

                            _mainForm.CreateQueryResultGrid(datatable, layerinfo);
                        }
                    }
                }
            }
        }