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;
DataGridView dataGridViewX1;
ToolStripStatusLabel toolStripNumbers;
GSOGlobeControl globeControl1;
PanelEx panel;
//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(GSOGeoPolygon3D polygon, MainFrm.DataGridViewDelegate InitDataGridViewX1, GSOGlobeControl ctl)
{
InitializeComponent();
globeControl1 = ctl;
m_InitDataGridViewX1 = InitDataGridViewX1;
map = getAccsMap(polygon);
}
private void FrmAllPipelineStatis_Load(object sender, EventArgs e)
{
drawChart();
}
public 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)
{
//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)
{
return;
}
//从图层获取datatable数据,不涉及数据库操作，速度会快一些
//string [] fieldNames = GSOFeatureUtils.getFields(layername, globeControl1);
//DataTable dt = GSOFeatureUtils.convertGSOFeatures2DataTable(fs,fieldNames);
//if (dt.Rows.Count > 0)
//{
// dataGridViewX1.DataSource = dt;
// panel.Visible = true;
// toolStripNumbers.Text = " 井盖类型：" + pipetype + "||共有：" + Convert.ToString(dt.Rows.Count) + "条记录";
//}
//else
//{
// panel.Visible = false;
// dataGridViewX1.DataSource = null;
// dataGridViewX1.Refresh();
// toolStripNumbers.Text = "类型：";
//}
//数据库获取数据
if (fs.Length > 0)
{
sql = "select " + getpipeLineFields.getFields(layername, globeControl1) + " from " + layer.Name;
sql += " where ";
for (int i = 0; i < fs.Length; i++)
{
if (i == 0)
{
if (fs[i].GetFieldDefn("编号") != null)
{
sql += " 编号='" + fs[i].GetValue("编号").ToString() + "'";
}
}
else
{
if (fs[i].GetFieldDefn("编号") != null)
{
sql += " or 编号 = '" + fs[i].GetValue("编号").ToString() + "'";
}
}
}
DataTable dt = OledbHelper.QueryTable(sql);
if (dt.Rows.Count > 0)
{
dataGridViewX1.DataSource = dt;
panel.Visible = true;
string strLable = toolStripNumbers.Text = " 井盖类型：" + pipetype + "||共有：" + Convert.ToString(dt.Rows.Count) + "条记录";
//m_InitDataGridViewX1(dt, strLable, "", true);
}
else
{
panel.Visible = false;
dataGridViewX1.DataSource = null;
dataGridViewX1.Refresh();
toolStripNumbers.Text = "类型：";
}
}
}
}
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;
}
}
}
//m_InitDataGridViewX1(null,"","" , false);
globeControl1.Globe.MemoryLayer.RemoveAllFeature();
}
private void 导出统计专题图ToolStripMenuItem_Click(object sender, EventArgs e)
{
PATM_Forms.F_PATMTitle frm = new PATM_Forms.F_PATMTitle("S", chartAllAreaPipeline);
frm.Show();
}
//获取指定layer类型的附属物名称列表
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>
/// <param name="accNameContains">要查找的附属物名称数组、如井、孔、蓖</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;
FeatureStatisticsService service = new FeatureStatisticsService();
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 = service.Intersect_PointLayerByType(polygon, layer, accNames[j]);
if (features == null) continue;
map.Add(listpt[i] + accNames[j], features);
}
}
}
return map;
}
}
}
