Newer
Older
GHFX_REFACTOR / Form_RK / FrmPipelineModelDataBase.cs
wxn on 2 Nov 2016 35 KB 提交
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);
            }
        }
    }
}