using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Windows.Forms.DataVisualization.Charting; using GeoScene.Data; using GeoScene.Globe; using DevComponents.DotNetBar; using System.Collections; namespace Cyberpipe { public partial class FrmAllWorkWellStatis : DevComponents.DotNetBar.Office2007Form { private MainFrm.DataGridViewDelegate m_InitDataGridViewX1; private Dictionary<string, GSOFeatures> map = null; private GSOGlobeControl globeControl1; private GSOGeoPolygon3D polygon; //TODOLIST:用晓伟的代理进行操作,功能拆分细化 //public FrmAllWorkWellStatis(GSOGeoPolygon3D polygon, DataGridView dataGridViewX11, ToolStripStatusLabel toolStripNumbers1, GSOGlobeControl ctl, PanelEx p) //{ // InitializeComponent(); // panel = p; // dataGridViewX1 = dataGridViewX11; // toolStripNumbers = toolStripNumbers1; // globeControl1 = ctl; // map = getAccsMap(polygon); //} public FrmAllWorkWellStatis(GSOGlobeControl ctl,GSOGeoPolygon3D polygon, MainFrm.DataGridViewDelegate InitDataGridViewX1) { InitializeComponent(); globeControl1 = ctl; m_InitDataGridViewX1 = InitDataGridViewX1; this.polygon = polygon; } private void FrmAllPipelineStatis_Load(object sender, EventArgs e) { map = getAccsMap(polygon); drawChart(); } private void drawChart() { try { // Set axis title chartAllAreaPipeline.Series.Add("井盖"); chartAllAreaPipeline.ChartAreas["ChartArea1"].AxisX.Title = "井盖类型"; chartAllAreaPipeline.ChartAreas["ChartArea1"].AxisY.Title = "井盖个数"; chartAllAreaPipeline.ChartAreas["ChartArea1"].AxisX.Interval = 1; LabelStyle labeStyleAxisX = new LabelStyle(); labeStyleAxisX.Angle = -45; labeStyleAxisX.Enabled = true; chartAllAreaPipeline.ChartAreas["ChartArea1"].AxisX.LabelStyle = labeStyleAxisX; chartAllAreaPipeline.Series["井盖"].ChartType = SeriesChartType.Column;//"井盖" chartAllAreaPipeline.Series["井盖"]["DrawingStyle"] = "Cylinder"; //chartAllAreaPipeline.Series[0].IsValueShownAsLabel = true; Dictionary<string, int> workWellLengthAndType = new Dictionary<string, int>(); foreach (KeyValuePair<string, GSOFeatures> kv in map) { workWellLengthAndType.Add(kv.Key, kv.Value.Length); } chartAllAreaPipeline.Series["井盖"].Points.DataBindXY(workWellLengthAndType.Keys, workWellLengthAndType.Values); for (int m = 0; m < workWellLengthAndType.Values.Count; m++) { if (chartAllAreaPipeline.Series["井盖"].Points[m].YValues[0].ToString().Trim() != "0") { chartAllAreaPipeline.Series["井盖"].Points[m].Label = chartAllAreaPipeline.Series[0].Points[m].YValues[0].ToString(); } } } catch (Exception ex) { //LogError.PublishError(ex); } } private void chartAllAreaPipeline_MouseClick(object sender, MouseEventArgs e) { HitTestResult result = chartAllAreaPipeline.HitTest(e.X, e.Y, true); int indexHit = result.PointIndex; if (indexHit < 0) return; //GSOFeatures fs = list[indexHit]; string sql = ""; string pipetype = chartAllAreaPipeline.Series["井盖"].Points[indexHit].AxisLabel; GSOFeatures fs = map[pipetype]; string layername = ""; if (pipetype.EndsWith("窖井") || pipetype.EndsWith("表井") || (pipetype.EndsWith("窨井")) || pipetype.EndsWith("孔") || pipetype.EndsWith("篦")) { layername = pipetype.Substring(0, pipetype.Length - 2) + "管线附属物"; } else { layername = pipetype.Substring(0, pipetype.Length - 3) + "管线附属物"; } //MainFrm.m_CurrentQueryLayer = layername; GSOLayer layer = globeControl1.Globe.Layers.GetLayerByCaption(layername); if (layer == null || fs.Length <= 0) { return; } sql = "select " + getpipeLineFields.getFields(layername, globeControl1) + " from " + layer.Name; sql += " where 1>2 "; for (int i = 0; i < fs.Length && fs[i].GetFieldDefn("编号") != null; i++) { sql += " or 编号 = '" + fs[i].GetValue("编号").ToString() + "'"; } DataTable dt = OledbHelper.QueryTable(sql); string strLable = " 井盖类型:" + pipetype + "||共有:" + Convert.ToString(dt.Rows.Count) + "条记录"; m_InitDataGridViewX1(dt, strLable, "", true); } private void chartAllAreaPipeline_MouseMove(object sender, MouseEventArgs e) { HitTestResult result = chartAllAreaPipeline.HitTest(e.X, e.Y, true); //Cursor cr = this.Cursor; if (result.PointIndex >= 0) { this.Cursor = Cursors.Hand; } else { this.Cursor = Cursors.Default; } } private void FrmAllPipelineStatis_FormClosing(object sender, FormClosingEventArgs e) { globeControl1.Globe.ClearAnalysis(); //layerTemp.RemoveAllFeature(); //panel.Visible = false; //dataGridViewX1.DataSource = null; //dataGridViewX1.Refresh(); //toolStripNumbers.Text = "类型:"; for (int i = 0; i < globeControl1.Globe.Layers.Count; i++) { GSOLayer layer = globeControl1.Globe.Layers[i]; if (layer is GSOFeatureLayer) { GSOFeatures feats = layer.GetAllFeatures(); for (int j = 0; j < feats.Length; j++) { GSOFeature feat = feats[j]; feat.HighLight = false; } } } globeControl1.Globe.MemoryLayer.RemoveAllFeature(); m_InitDataGridViewX1(null, "", "", false); } private void 导出统计专题图ToolStripMenuItem_Click(object sender, EventArgs e) { PATM_Forms.F_PATMTitle frm = new PATM_Forms.F_PATMTitle("S", chartAllAreaPipeline); frm.Show(); } /// <summary> /// 获取指定layer类型的附属物名称列表 /// </summary> /// <param name="layerType"></param> /// <returns></returns> public string[] getLayerAccNames(string layerType) { GSOLayer layer = globeControl1.Globe.Layers.GetLayerByCaption(layerType + "管线附属物"); if (layer == null) return null; string sql = "select 附属物名称 from " + layerType + "管线附属物 group by 附属物名称"; DataSet dataset = OledbHelper.getDataSet(sql, layerType + "管线附属物"); if (dataset == null) return null; int count = dataset.Tables[0].Rows.Count; string[] result = new string[count]; for (int i = 0; i < count; i++) { result[i] = dataset.Tables[0].Rows[i][0].ToString(); } return result; } /// <summary> /// 获取区域内各图层的井、孔、蓖的map /// </summary> /// <param name="polygon">区域</param> /// <returns>返回值为:图层+附属物名称,附属物列表</returns> public Dictionary<string, GSOFeatures> getAccsMap(GSOGeoPolygon3D polygon) { //List<GSOFeatures> list = new List<GSOFeatures>(); Dictionary<string, GSOFeatures> map = new Dictionary<string, GSOFeatures>(); ArrayList listpt = Utility.LayerNamesList; if (listpt == null || listpt.Count == 0) return null; for (int i = 0; i < listpt.Count; i++) { GSOLayer layer = globeControl1.Globe.Layers.GetLayerByCaption(listpt[i] + "管线附属物"); string[] accNames = getLayerAccNames(listpt[i] as string); if (accNames == null || accNames.Length == 0) continue;//排除不合法的值 for (int j = 0; j < accNames.Length; j++) { if (accNames[j].Contains("井") || accNames[j].Contains("孔") || accNames[j].Contains("篦")) { GSOFeatures features = FeatureStatisticsService.Intersect_PointLayerByType(polygon, layer, accNames[j]); if (features == null) continue; map.Add(listpt[i] + accNames[j], features); } } } return map; } } }