using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using GeoScene.Globe; using GeoScene.Engine; using GeoScene.Data; using System.IO; using System.Collections; using System.Xml; using System.Text.RegularExpressions; using DevComponents.DotNetBar; namespace Cyberpipe.Form_RK { public partial class FrmPipelineModelDB : Office2007Form { private GeoScene.Globe.GSOGlobeControl ctl; GSODataSource ds; private Hashtable en_cns = new Hashtable(); private Hashtable fields_types = new Hashtable(); //private ArrayList layernamelist = new ArrayList(); private List<String> layernamelist = new List<string>(); string selectLayerName = ""; public GSOLayer rukuLayer = null; public FrmPipelineModelDB(GSOGlobeControl _ctl, GSODataSource _ds) { ctl = _ctl; ds = _ds; InitializeComponent(); } /// <summary> /// 单击选择shp格式文件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnBrowseModel_Click(object sender, EventArgs e) { saveFileDialog1.Filter = "*.lgd|*.lgd"; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { txtModelLayer.Text = saveFileDialog1.FileName; } } /// <summary> /// 窗体初始化事件处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void FrmPipelineModel_Load(object sender, EventArgs e) { string pipelinetype = Utility.pipelinetype; string[] pipelinetypes = pipelinetype.Split(','); for (int i = 0; i < pipelinetypes.Length; i++) { pipelineTypeCbo.Items.Add(pipelinetypes[i]); } //////////////////////////////////////////// if (ctl != null) { for (int i = 0; i < ctl.Globe.Layers.Count; i++) { GSOLayer layer = ctl.Globe.Layers[i]; if (layer != null && layer.Name.ToLower().EndsWith(".shp")) { string str = Path.GetFileName(layer.Name); comboBoxEx1.Items.Add(str); layernamelist.Add(layer.Name.Trim()); } } } string filename = Application.StartupPath + "\\FormText.xml"; if (File.Exists(filename)) { XmlTextReader XmlReader = new XmlTextReader(filename); try { while (XmlReader.Read()) { if (XmlReader.Name == "Field") { string str1 = XmlReader["label"]; string str3 = XmlReader["type"]; string str2 = XmlReader.ReadElementString(); en_cns.Add(str1, str2); fields_types.Add(str1, str3); } } } catch (Exception ex) { LogError.PublishError(ex); MessageBox.Show(ex.Message); } } } private object convertFieldValue(string fieldname, object obj) { if (obj == null) return null; try { string type = fields_types[fieldname].ToString(); switch (type) { case "string": return obj.ToString(); case "int": //return 101; int intResult; if (int.TryParse(obj.ToString(), out intResult)) return intResult; else return null; case "double": //return 202.5; double doubleResult; if (double.TryParse(obj.ToString(), out doubleResult)) return doubleResult; else return null; case "date": DateTime dtResult; if (DateTime.TryParse(obj.ToString(), out dtResult)) return dtResult; else return null; } return null; } catch (Exception ex) { LogError.PublishError(ex); return null; } } public string lgdFilePath = ""; /// <summary> /// 选择管线颜色 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnPipelineColor_Click(object sender, EventArgs e) { colorDialog1.Color = btnPipelineColor.BackColor; if (colorDialog1.ShowDialog() == DialogResult.OK) { btnPipelineColor.BackColor = colorDialog1.Color; } } /// <summary> /// 建模按钮事件处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnCreateModel_Click(object sender, EventArgs e) //建模 { if (ds == null) { MessageBox.Show("未连接数据库,请先连接数据库!", "提示"); return; } /* if (!Utility.isNetworkConnectionSuccess(FrmDatabaseParaSetting.dbIp)) { MessageBox.Show("网络连接失败!", "提示"); return; } * */ if (textBoxLayer.Text.Trim() == "") { MessageBox.Show("请选择一个图层文件!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (txtModelLayer.Text.Trim().Length>=20) { MessageBox.Show("请修改图层名称为20个字符以下","提示"); return; } //判断是数字或者存在特殊字符串 string SuiD = txtModelLayer.Text.ToString().Trim(); Regex reg = new Regex("^[0-9]");//判断是不是数据,要不是就表示没有选择。则从隐藏域里读出来 Match ma = reg.Match(SuiD); if (ma.Success) { MessageBox.Show("图层名称不能以数字开头!", "警告"); return; } try { //if (valiPipeData()) { if (string.IsNullOrEmpty(txtModelLayer.Text)) { MessageBox.Show("管线图层名称无效!", "提示"); return; } GSODataset dataset = ds.GetDatasetByName(txtModelLayer.Text.Trim()); GSOFeatureDataset layer;//= CreateDBFeatureDataset(txtModelLayer.Text.Trim()); if (dataset != null) { DialogResult result = MessageBox.Show("管线图层名称在数据库中已存在!是否向该表追加", "提示", MessageBoxButtons.YesNo); if (result == DialogResult.No) return; else if (result == DialogResult.Yes) { layer = dataset as GSOFeatureDataset; } else return; } else layer = CreateDBFeatureDataset(txtModelLayer.Text.Trim()); if (layer == null) return; GSOLayer sourceLayer = ctl.Globe.Layers.GetLayerByCaption(selectLayerName); layer.Open(); lgdFilePath = txtModelLayer.Text; if (layer != null) { GSOFeatures features = sourceLayer.GetAllFeatures(true); GSOFeatures layerFeatures = layer.GetAllFeatures(); List<string> listFeature = new List<string>(); if (layerFeatures.Length != 0) { for (int m = 0; m < layerFeatures.Length; m++) { GSOFeature ff = layerFeatures[m]; listFeature.Add(ff.Name); } } /* if (dataset != null) { //根据编号删除数据库图层中已经存在的记录即要素 string sql = "delete from " + txtModelLayer.Text.Trim() + " where 编号 in ("; for (int j = 0; j < features.Length; j++) { GSOFeature f = features[j]; if (f != null) { if (f.IsFieldValueNull("Handle") == false) { string fieldID = f.GetFieldAsString("Handle").Trim(); if (fieldID != "") { sql += "'" + fieldID + "',"; } } } } sql = sql.Substring(0, sql.Length - 1); sql += ")"; OledbHelper.sqlExecuteNonQuery(sql); } layer.Close(); layer.Open(); **/ for (int j = 0; j < features.Length; j++) { GSOFeature f = features[j]; if (f != null) { if (listFeature.Contains(f.GetFieldAsString("Handle").Trim())) { continue; } else { GSOGeoPolyline3D lineeee = f.Geometry as GSOGeoPolyline3D; if (lineeee == null) { continue; } double length = lineeee.GetSpaceLength(true, 6378137); if (length == 0) { continue; } GSOFeature newFeature = layer.CreateFeature(); GSOPipeLineStyle3D style = new GSOPipeLineStyle3D(); style.LineColor = Color.FromArgb(Convert.ToByte(numericUpDownLineOpaque.Value), btnPipelineColor.BackColor); double radius = 0; GSOFieldDefn field = (GSOFieldDefn)(f.GetFieldDefn(cmbRadius.SelectedItem.ToString())); if (field.Type == EnumFieldType.Text) { string temp = f.GetFieldAsString(cmbRadius.SelectedItem.ToString()); double outNum = 0; bool num = double.TryParse(temp, out outNum); if (num) radius = outNum / 2000; } else if (field.Type == EnumFieldType.Double || field.Type == EnumFieldType.INT32) radius = f.GetFieldAsDouble(cmbRadius.SelectedItem.ToString()) / 2000; // 探测数据的单位一般是毫米,需换算为米; 管径一般是 直径, 这个需要半径, 所有除以2000 string eventid = f.GetFieldAsString(cmbID.SelectedItem.ToString()); if (radius == 0) continue; style.Radius = radius; style.Slice = int.Parse(txtSlice.Text); style.CornerSliceAngle = Convert.ToDouble(textBoxCornerSliceAngle.Text); f.Geometry.AltitudeMode = EnumAltitudeMode.Absolute; GSOGeoPolyline3D line = f.Geometry as GSOGeoPolyline3D; if (line == null || line.PartCount != 1 || line[0].Count != 2) return; double deep1 = f.GetFieldAsDouble(cmbFrom.SelectedItem.ToString()); double deep2 = f.GetFieldAsDouble(cmbTo.SelectedItem.ToString()); //if (chkDeep.Checked) //{ // deep1 = 0 - deep1; // deep2 = 0 - deep2; //} if (cmbReference.SelectedIndex == 0) //管底 { deep1 = deep1 + radius; deep2 = deep2 + radius; } else if (cmbReference.SelectedIndex == 1) //管顶 { deep1 = deep1 - radius; deep2 = deep2 - radius; } ///////////////////////////////////////////////////// GSOPoint3ds part = line[0]; GSOPoint3d pt3d = part[0]; GSOPoint3d pt3dEnd = part[1]; pt3d.Z = deep1; pt3dEnd.Z = deep2; part[0] = pt3d; part[1] = pt3dEnd; line[0] = part; newFeature.Geometry = line; // f.Geometry; newFeature.Geometry.Style = style; newFeature.Name = eventid; for (int i = 0; i < newFeature.GetFieldCount(); i++) { if (f.GetFieldCount() > i) { GeoScene.Data.GSOFieldDefn fielddef = (GeoScene.Data.GSOFieldDefn)(f.GetFieldDefn(i)); object fieldvalue = f.GetValue(fielddef.Name);// convertFieldValue(fielddef.Name, f.GetValue(fielddef.Name)); if (fieldvalue == null) continue; string fieldName = en_cns.ContainsKey(fielddef.Name) == true ? en_cns[fielddef.Name].ToString() : fielddef.Name; newFeature.SetValue(fieldName, fieldvalue); } } layer.AddFeature(newFeature); } } } } ctl.Refresh(); layer.Save(); MessageBox.Show("入库成功!", "提示"); ds = ctl.Globe.DataManager.OpenOracleDataSource(Utility.DBServer.Trim() + "/" + Utility.dbdatabase.Trim(), "", "", Utility.userID, Utility.DBPassword); if (sourceLayer != null) { ctl.Globe.Layers.Remove(sourceLayer); } layer.Caption = layer.Name; GSOLayer layerRuku = ctl.Globe.Layers.Add(layer); rukuLayer = layerRuku; //定位到该管线起点位置 if (layerRuku.GetAllFeatures().Length > 0) { int num = layerRuku.GetAllFeatures().Length / 2; GSOFeature feature = layerRuku.GetAt(num); if (feature != null && feature.Geometry != null) { ctl.Globe.JumpToFeature(feature, 100); } else { ctl.Globe.FlyToFeature(feature); } } this.DialogResult = DialogResult.OK; this.Close(); } } catch (Exception ex) { LogError.PublishError(ex); MessageBox.Show(ex.Message); } } /// <summary> /// 验证shp格式文件 /// </summary> /// <param name="layer"></param> /// <returns></returns> private string valiPipeData(GSOLayer layer) //验证shp格式文件 { string txtMessage = ""; if (layer != null) { GSOFeatureDataset featDataSet = layer.Dataset as GSOFeatureDataset; List<string> lstField = new List<string>(); List<string> listFieldType_Text = new List<string>(); for (int i = 0; i < featDataSet.FieldCount; i++) { string fieldName = featDataSet.GetField(i).Name; lstField.Add(fieldName); if (fields_types.ContainsKey(fieldName)) { string fieldType = fields_types[fieldName].ToString().ToUpper(); switch (featDataSet.GetField(i).Type) { case EnumFieldType.Text: if (fieldType != "string".ToUpper()) { txtMessage += "" + fieldName + "数据类型不正确\r\n"; } listFieldType_Text.Add(fieldName); break; case EnumFieldType.INT32: if (fieldType != "int".ToUpper() && fieldType != "double".ToUpper()) { txtMessage += "" + fieldName + "数据类型不正确\r\n"; } break; case EnumFieldType.INT16: if (fieldType != "int".ToUpper() && fieldType != "double".ToUpper()) { txtMessage += "" + fieldName + "数据类型不正确\r\n"; } break; case EnumFieldType.Double: if (fieldType != "double".ToUpper()) { txtMessage += "" + fieldName + "数据类型不正确\r\n"; } break; case EnumFieldType.Date: if (fieldType != "date".ToUpper()) { txtMessage += "" + fieldName + "数据类型不正确\r\n"; } break; } } } if (!lstField.Contains("Deep1")) { txtMessage += "Deep1字段不存在!\r\n"; } else { GSOFieldAttr fieldDeep1 = featDataSet.GetField("Deep1"); if (fieldDeep1.Type != EnumFieldType.Double && fieldDeep1.Type != EnumFieldType.Float && fieldDeep1.Type != EnumFieldType.INT16 && fieldDeep1.Type != EnumFieldType.INT32) { txtMessage += "Deep1字段必须为数值类型\r\n"; } } if (!lstField.Contains("Deep2")) { txtMessage += "Deep2字段不存在!\r\n"; } else { GSOFieldAttr fieldDeep1 = featDataSet.GetField("Deep2"); if (fieldDeep1.Type != EnumFieldType.Double && fieldDeep1.Type != EnumFieldType.Float && fieldDeep1.Type != EnumFieldType.INT16 && fieldDeep1.Type != EnumFieldType.INT32) { txtMessage += "Deep2字段必须为数值类型\r\n"; } } if (!lstField.Contains("Diameter")) { txtMessage += "Diameter字段不存在!\r\n"; } else { GSOFieldAttr fieldDeep1 = featDataSet.GetField("Diameter"); if (fieldDeep1.Type != EnumFieldType.Double && fieldDeep1.Type != EnumFieldType.Float && fieldDeep1.Type != EnumFieldType.INT16 && fieldDeep1.Type != EnumFieldType.INT32) { txtMessage += "Diameter字段必须为数值类型\r\n"; } } if (!lstField.Contains("Handle")) { txtMessage += "Handle字段不存在!\r\n"; } List<string> lstHandle = new List<string>(); for (int i = 0; i < layer.GetAllFeatures().Length; i++) { GSOFeature f = layer.GetAt(i); for (int j = 0; j < listFieldType_Text.Count; j++) { string fieldName = listFieldType_Text[j]; if (fields_types.ContainsKey(fieldName)) { if (f.GetValue(fieldName).ToString().Trim().Length > 8000) { txtMessage += "ID为" + f.ID + "的要素的字段" + fieldName + "的长度大于8000 !\r\n"; } } } if (f.GetFieldAsFloat("Diameter") <= 0) { txtMessage += "ID为" + f.ID + "\"Diameter\"字段中的值必须大于0 \r\n"; } if (!lstHandle.Contains(f.GetFieldAsString("Handle"))) { lstHandle.Add(f.GetFieldAsString("Handle")); } else { txtMessage += "ID为" + f.ID + "的\"Handle\"字段中的值重复\r\n"; } } } return txtMessage; } /// <summary> /// 创建数据库表对象 /// </summary> /// <param name="name"></param> /// <returns></returns> private GSOFeatureDataset CreateDBFeatureDataset(string name) { GSOLayer layer = ctl.Globe.Layers.GetLayerByCaption(selectLayerName); if (layer == null) { return null; } GSOFeatures features = layer.GetAllFeatures(); if (features.Length == 0) { MessageBox.Show("图层要素个数为0!", "提示"); return null; } GSOFeatureDataset featDs = ds.CreateFeatureDataset(name); if (featDs == null) { MessageBox.Show("图层名称不符合要求!", "提示"); return null; } for (int i = 0; i < features[0].GetFieldCount(); i++) { GeoScene.Data.GSOFieldDefn fielddef = (GeoScene.Data.GSOFieldDefn)(features[0].GetFieldDefn(i)); if (fielddef == null) { continue; } GSOFieldAttr field = new GSOFieldAttr(); field.Name = en_cns.ContainsKey(fielddef.Name) == true ? en_cns[fielddef.Name].ToString() : fielddef.Name; switch (fielddef.Type) { case EnumFieldType.Text: field.Type = EnumFieldType.Text; field.Width = 8000; break; case EnumFieldType.INT32: field.Type = EnumFieldType.INT32; field.Width = 4; break; case EnumFieldType.Double: field.Type = EnumFieldType.Double; field.Width = 8; break; case EnumFieldType.Date: field.Type = EnumFieldType.Date; field.Width = 10; break; } bool res = featDs.AddField(field); } featDs.Save(); return featDs; } /// <summary> /// 关闭按钮事件处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnClose_Click(object sender, EventArgs e)// 关闭 { this.Close(); } private void cmbLayer_SelectedIndexChanged(object sender, EventArgs e) //选择图层 { GSOLayer layer = ctl.Globe.Layers.GetLayerByCaption(selectLayerName); GSOFeatures features = layer.GetAllFeatures(); if (features.Length == 0) return; cmbFrom.Items.Clear(); cmbTo.Items.Clear(); cmbRadius.Items.Clear(); cmbID.Items.Clear(); for (int i = 0; i < features[0].GetFieldCount(); i++) { GeoScene.Data.GSOFieldDefn fielddef = (GeoScene.Data.GSOFieldDefn)(features[0].GetFieldDefn(i)); cmbFrom.Items.Add(fielddef.Name); cmbTo.Items.Add(fielddef.Name); cmbRadius.Items.Add(fielddef.Name); cmbID.Items.Add(fielddef.Name); } cmbFrom.SelectedItem = "H1"; cmbTo.SelectedItem = "H2"; cmbRadius.SelectedItem = "Diameter"; cmbID.SelectedItem = "Handle"; } private void buttonXLayerPath_Click(object sender, EventArgs e)//单击 选择shp格式的文件 { OpenFileDialog dlg = new OpenFileDialog(); dlg.Filter = "*.shp|*.shp"; dlg.Multiselect = false; if (dlg.ShowDialog() == DialogResult.OK) { MessageBox.Show(dlg.FileName); GSOLayer layer = ctl.Globe.Layers.Add(dlg.FileName); string txtMessage = valiPipeData(layer); if (txtMessage != "") { btnCreateModel.Enabled = false; textBoxLayer.Text = ""; cmbFrom.Items.Clear(); cmbTo.Items.Clear(); cmbRadius.Items.Clear(); cmbID.Items.Clear(); ctl.Globe.Layers.Remove(layer); FrmValiDataShowErrorMessage showErrorMessage = new FrmValiDataShowErrorMessage(dlg.FileName, txtMessage); showErrorMessage.ShowDialog(); return; } else { btnCreateModel.Enabled = true; textBoxLayer.Text = dlg.FileName; selectLayerName = layer.Caption; txtModelLayer.Text = layer.Caption; GSOFeatures features = layer.GetAllFeatures(); if (features.Length == 0) return; cmbFrom.Items.Clear(); cmbTo.Items.Clear(); cmbRadius.Items.Clear(); cmbID.Items.Clear(); for (int i = 0; i < features[0].GetFieldCount(); i++) { GeoScene.Data.GSOFieldDefn fielddef = (GeoScene.Data.GSOFieldDefn)(features[0].GetFieldDefn(i)); cmbFrom.Items.Add(fielddef.Name); cmbTo.Items.Add(fielddef.Name); cmbRadius.Items.Add(fielddef.Name); cmbID.Items.Add(fielddef.Name); } cmbFrom.SelectedItem = "H1"; cmbTo.SelectedItem = "H2"; cmbRadius.SelectedItem = "Diameter"; cmbID.SelectedItem = "Handle"; } } } /// <summary> /// 窗体关闭事件处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void FrmPipelineModelDB_FormClosing(object sender, FormClosingEventArgs e) { ctl.Globe.Refresh(); } private void comboBoxEx1_SelectedIndexChanged(object sender, EventArgs e) { if (comboBoxEx1.SelectedIndex != -1) { string layerCaption = null; for (int i = 0; i < layernamelist.Count; i++) { if (Path.GetFileName(layernamelist[i]) == comboBoxEx1.SelectedItem.ToString().Trim()) { layerCaption = layernamelist[i]; } } //string layerCaption = comboBoxEx1.SelectedItem.ToString().Trim(); //layerCaption = "D:\\ghfx71\\问题数据\\污水管线new.shp"; GSOLayer layer = ctl.Globe.Layers.Add(layerCaption); string txtMessage = valiPipeData(layer); if (txtMessage != "") { btnCreateModel.Enabled = false; textBoxLayer.Text = ""; cmbFrom.Items.Clear(); cmbTo.Items.Clear(); cmbRadius.Items.Clear(); cmbID.Items.Clear(); ctl.Globe.Layers.Remove(layer); FrmValiDataShowErrorMessage showErrorMessage = new FrmValiDataShowErrorMessage(layerCaption, txtMessage); showErrorMessage.ShowDialog(); return; } else { btnCreateModel.Enabled = true; textBoxLayer.Text = layerCaption; selectLayerName = layer.Caption; txtModelLayer.Text = layer.Caption; GSOFeatures features = layer.GetAllFeatures(); if (features.Length == 0) return; cmbFrom.Items.Clear(); cmbTo.Items.Clear(); cmbRadius.Items.Clear(); cmbID.Items.Clear(); for (int i = 0; i < features[0].GetFieldCount(); i++) { GeoScene.Data.GSOFieldDefn fielddef = (GeoScene.Data.GSOFieldDefn)(features[0].GetFieldDefn(i)); cmbFrom.Items.Add(fielddef.Name); cmbTo.Items.Add(fielddef.Name); cmbRadius.Items.Add(fielddef.Name); cmbID.Items.Add(fielddef.Name); } cmbFrom.SelectedItem = "H1"; cmbTo.SelectedItem = "H2"; cmbRadius.SelectedItem = "Diameter"; cmbID.SelectedItem = "Handle"; } //} } } private void pipelineTypeCbo_SelectedIndexChanged(object sender, EventArgs e) { if ((pipelineTypeCbo.Text != "给水") && (pipelineTypeCbo.Text != "天然气") && (pipelineTypeCbo.Text != "燃气") && (pipelineTypeCbo.Text != "中水")) { cmbReference.Text = "管底"; } else { cmbReference.Text = "管顶"; } if (pipelineTypeCbo.Text == "给水") { btnPipelineColor.BackColor = Color.FromArgb(0, 0, 255); } else if (pipelineTypeCbo.Text == "供电") { btnPipelineColor.BackColor = Color.FromArgb(255, 100, 150); } else if (pipelineTypeCbo.Text == "雨水") { btnPipelineColor.BackColor = Color.FromArgb(230, 120, 0); } else if (pipelineTypeCbo.Text == "污水") { btnPipelineColor.BackColor = Color.FromArgb(128, 64, 0); } else if (pipelineTypeCbo.Text == "天然气") { btnPipelineColor.BackColor = Color.FromArgb(215, 0, 64); } else if (pipelineTypeCbo.Text == "共通") { btnPipelineColor.BackColor = Color.FromArgb(0, 255, 0); } else if (pipelineTypeCbo.Text == "电通") { btnPipelineColor.BackColor = Color.FromArgb(0, 255, 0); } else if (pipelineTypeCbo.Text == "有线电视") { btnPipelineColor.BackColor = Color.FromArgb(0, 255, 0); } else if (pipelineTypeCbo.Text == "监控") { btnPipelineColor.BackColor = Color.FromArgb(0, 255, 0); } else if (pipelineTypeCbo.Text == "交通信号") { btnPipelineColor.BackColor = Color.FromArgb(0, 255, 0); } else if (pipelineTypeCbo.Text == "路灯") { btnPipelineColor.BackColor = Color.FromArgb(255, 0, 150); } else if (pipelineTypeCbo.Text == "通讯") { btnPipelineColor.BackColor = Color.FromArgb(0, 255, 0); } else { btnPipelineColor.BackColor = Color.FromArgb(0, 0, 0); } } } }