using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using GeoScene.Globe; using GeoScene.Data; using System.IO; using System.Windows.Forms.DataVisualization.Charting; namespace Cyberpipe { public partial class FrmAccessoriesSensor : DevComponents.DotNetBar.Office2007Form { GSOGlobeControl globeControl1; List<string> instrumenLayerNames; static FrmAccessoriesSensor frm; public static void ShowForm(GSOGlobeControl globeControl, List<string> pipeLayers, int visibleId) { if (frm == null) { frm = new FrmAccessoriesSensor(globeControl, pipeLayers, visibleId); frm.Show(globeControl.Parent); } else { if (frm.WindowState == FormWindowState.Minimized) { frm.WindowState = FormWindowState.Normal; } } } public FrmAccessoriesSensor(GSOGlobeControl globeControl, List<string> instrumentlist, int visibleId) { InitializeComponent(); globeControl1 = globeControl; instrumenLayerNames = instrumentlist; if (visibleId == 0) { buttonX9.Visible = false; buttonX8.Visible = true; buttonX8.Location = buttonX9.Location; } if (visibleId == 1) { buttonX8.Visible = false; buttonX9.Visible = true; } } /// <summary> /// 窗体初始化事件处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void FrmAccessoriesgather_Load(object sender, EventArgs e) { if (Utility.sensorMarkerLayers != null) { for (int i = 0; i < Utility.sensorMarkerLayers.Count; i++) { MarkerLayer mLayer = Utility.sensorMarkerLayers[i]; clbPipeLine.Items.Add(mLayer.layerName); } } } /// <summary> /// 绘制区域完成事件处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void globeControl1_TrackPolygonEndEvent(object sender, TrackPolygonEndEventArgs e) { if (e.Polygon != null) { GSOGeoPolygon3D polygon = e.Polygon.Clone() as GSOGeoPolygon3D; polygon.AltitudeMode = EnumAltitudeMode.RelativeToGround; GSOFeature feature = new GSOFeature(); feature.Geometry = polygon; feature.Name = "trackPolygon"; globeControl1.Globe.MemoryLayer.AddFeature(feature); globeControl1.Globe.ClearLastTrackPolygon(); globeControl1.TrackPolygonEndEvent -= new TrackPolygonEndEventHandler(globeControl1_TrackPolygonEndEvent); globeControl1.Globe.Action = EnumAction3D.ActionNull; pipeDiameterStatis(e.Polygon); } } /// <summary> /// 全选按钮事件处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void buttonX1_Click(object sender, EventArgs e) { for (int i = 0; i < clbPipeLine.Items.Count; i++) { clbPipeLine.SetItemChecked(i, true); } } /// <summary> /// 反选按钮事件处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void buttonX2_Click(object sender, EventArgs e) { for (int i = 0; i < this.clbPipeLine.Items.Count; i++) { if (clbPipeLine.GetItemChecked(i) == true) { this.clbPipeLine.SetItemChecked(i, false); } else { this.clbPipeLine.SetItemChecked(i, true); } } } /// <summary> /// 清空按钮事件处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void buttonX3_Click(object sender, EventArgs e) { for (int i = 0; i < clbPipeLine.Items.Count; i++) { clbPipeLine.SetItemChecked(i, false); } } Dictionary<string, double> dic = new Dictionary<string, double>(); private void pipeDiameterStatis(GSOGeoPolygon3D polygon) { try { dic = new Dictionary<string, double>(); dataGridViewX1.Rows.Clear(); if (clbPipeLine.CheckedItems.Count > 0) { for (int i = 0; i < clbPipeLine.CheckedItems.Count; i++) { GSOLayer layer = globeControl1.Globe.Layers.GetLayerByCaption(clbPipeLine.CheckedItems[i].ToString()); GSOFeatureLayer flayer = layer as GSOFeatureLayer; if (flayer != null) { GSOFeatures feats = new GSOFeatures(); if (polygon == null) { feats = flayer.GetAllFeatures(); } else { feats = flayer.FindFeaturesInPolygon(polygon, false); } int ncount = 0; ncount = feats.Length; DataGridViewRow row = new DataGridViewRow(); int index = dataGridViewX1.Rows.Add(row); row = dataGridViewX1.Rows[index]; row.Cells["图层名称"].Value = layer.Caption; row.Cells["数量"].Value = ncount; dic.Add(layer.Caption, ncount); } } } else { MessageBox.Show("请选择图层!"); } showPipeWidget(); } catch (Exception ex) { MessageBox.Show(ex.Message); LogError.PublishError(ex); } } private void showPipeWidget() { if (chart1.Series.Count > 0) { chart1.Series.Clear(); } if (chart1.Legends.Count > 0) { chart1.Legends.Clear(); } chart1.Series.Add("传感器"); chart1.ChartAreas["ChartArea1"].AxisX.Title = "传感器名称"; chart1.ChartAreas["ChartArea1"].AxisY.Title = "传感器数量"; chart1.ChartAreas["ChartArea1"].AxisX.Interval = 1; LabelStyle labeStyleAxisX = new LabelStyle(); labeStyleAxisX.Angle = -45; labeStyleAxisX.Enabled = true; chart1.ChartAreas["ChartArea1"].AxisX.LabelStyle = labeStyleAxisX; chart1.Series[0].ChartType = SeriesChartType.Column; chart1.Series[0]["DrawingStyle"] = "Cylinder"; chart1.Series[0].Points.DataBindXY(dic.Keys, dic.Values); for (int m = 0; m < dic.Values.Count; m++) { if (chart1.Series[0].Points[m].YValues[0].ToString() != "0") { chart1.Series[0].Points[m].Label = chart1.Series[0].Points[m].YValues[0].ToString(); } } } /// <summary> /// 全区域分类汇总事件处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void buttonX8_Click(object sender, EventArgs e) { if (clbPipeLine.CheckedItems.Count > 0) { globeControl1.Globe.Action = EnumAction3D.ActionNull; pipeDiameterStatis(null); } else { MessageBox.Show("请选择图层!"); } } /// <summary> /// 绘制区域分类汇总事件处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void buttonX9_Click(object sender, EventArgs e) { if (clbPipeLine.CheckedItems.Count > 0) { Utility.RemoveFeatureFromName(globeControl1, "trackPolygon"); globeControl1.Globe.Action = EnumAction3D.TrackPolygon; globeControl1.TrackPolygonEndEvent += new TrackPolygonEndEventHandler(globeControl1_TrackPolygonEndEvent); } else { MessageBox.Show("请选择图层!"); } } /// <summary> /// 窗体关闭事件处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void FrmAccessoriesgather_FormClosing(object sender, FormClosingEventArgs e) { frm = null; Utility.RemoveFeatureFromName(globeControl1, "trackPolygon"); globeControl1.Globe.Action = EnumAction3D.ActionNull; globeControl1.TrackPolygonEndEvent -= new TrackPolygonEndEventHandler(globeControl1_TrackPolygonEndEvent); } /// <summary> /// 导出Excel事件处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnExport_Click(object sender, EventArgs e) { if (dataGridViewX1.Rows.Count > 0) { SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "Excel files (*.xls)|*.xls"; dlg.FilterIndex = 0; dlg.RestoreDirectory = true; //dlg.CreatePrompt = true; dlg.Title = "保存为Excel文件"; dlg.FileName = DateTime.Now.ToString("yyyyMMdd") + ".xls"; if (dlg.ShowDialog() == DialogResult.OK) { Stream myStream; myStream = dlg.OpenFile(); StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0)); string columnTitle = ""; try { sw.WriteLine("日期:" + DateTime.Now.ToString("yyyy-MM-dd")); //写入列标题 for (int i = 0; i < dataGridViewX1.ColumnCount; i++) { if (i > 0) { columnTitle += "\t"; } columnTitle += dataGridViewX1.Columns[i].HeaderText; } sw.WriteLine(columnTitle); //写入列内容 for (int j = 0; j < dataGridViewX1.Rows.Count; j++) { string columnValue = ""; for (int k = 0; k < dataGridViewX1.Columns.Count; k++) { if (k > 0) { columnValue += "\t"; } if (dataGridViewX1.Rows[j].Cells[k].Value == null) columnValue += ""; else columnValue += dataGridViewX1.Rows[j].Cells[k].Value.ToString().Trim(); } sw.WriteLine(columnValue); } sw.Close(); myStream.Close(); if (MessageBox.Show("导出Excel文件成功!是否打开?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { System.Diagnostics.Process.Start(dlg.FileName); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sw.Close(); myStream.Close(); } } } else { MessageBox.Show("统计结果为空,请重新统计之后再导出Excel!", "提示"); } } } }