Newer
Older
GHFX_REFACTOR / Form_RK / FrmAddYuBiZiShp.cs
wxn on 2 Nov 2016 22 KB 提交
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Collections;
using GeoScene.Data;
using System.Text.RegularExpressions;
using GeoScene.Engine;
using GeoScene.Globe;
using System.Xml;
using DevComponents.DotNetBar;

namespace Cyberpipe.Form_RK
{
    public partial class FrmAddYuBiZiShp : Office2007Form
    {
        GeoScene.Globe.GSOGlobeControl globeControl1;
        GSODataSource ds;
        private Hashtable yb_cns = new Hashtable();
        private Hashtable yb_types = new Hashtable();
        
        string selectLayerName = "";
        public GSOLayer rukuLayer = null;
        private List<String> layernamelist = new List<string>();

        public FrmAddYuBiZiShp(GeoScene.Globe.GSOGlobeControl _globeControl1, GSODataSource _ds)
        {
            globeControl1 = _globeControl1;
            ds = _ds;
            InitializeComponent();
        }

        private string valiYBdata(GSOLayer layer)
        {
            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 (yb_types.ContainsKey(fieldName))
                    {
                        string fieldType = yb_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("编号"))
                {
                    txtMessage += "编号字段不存在!\r\n";
                }
                if (!lstField.Contains("管点编码"))
                {
                    txtMessage += "管点编码字段不存在!\r\n";
                }
                if (!lstField.Contains("符号角度"))
                {
                    txtMessage += "符号角度字段不存在!\r\n";
                }
                if (!lstField.Contains("管点特征"))
                {
                    txtMessage += "管点特征字段不存在!\r\n";
                }
                

                if (!lstField.Contains("符号角度"))
                {
                    txtMessage += "符号角度字段不存在!\r\n";
                }
                else
                {
                    GSOFieldAttr fieldZ = featDataSet.GetField("符号角度");
                    if (fieldZ.Type != EnumFieldType.Double && fieldZ.Type != EnumFieldType.Float && fieldZ.Type != EnumFieldType.INT16 && fieldZ.Type != EnumFieldType.INT32)
                    {
                        txtMessage += "\"符号角度\"字段必须为数值类型 \r\n";
                    }
                }
                 
                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 (yb_types.ContainsKey(fieldName))
                        {
                            if (f.GetValue(fieldName).ToString().Trim().Length > 8000)
                            {
                                txtMessage += "名称为" + f.Name + "的要素的字段" + fieldName + "的长度大于8000 !\r\n";
                            }
                        }
                    }
                }       
            }
            return txtMessage;
        }

        private ArrayList files =new ArrayList ();
        private ArrayList modeltypes = new ArrayList(); // 井的型号
        private ArrayList deeps = new ArrayList();

        private void button3_Click(object sender, EventArgs e)
        {
            if (comboBoxEx1.SelectedItem.ToString().Trim() == "")
            {
                MessageBox.Show("请选择一个图层文件!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }

            try
            {
                /*
                if (!Utility.isNetworkConnectionSuccess(FrmDatabaseParaSetting.dbIp))
                {
                    MessageBox.Show("网络连接失败!", "提示");
                    return;
                }
                 * */

                if (txtLayerName.Text.Trim() == "")
                {
                    MessageBox.Show("图层名称为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                //判断是数字或者存在特殊字符串
                string SuiD = txtLayerName.Text.Trim();
                Regex reg = new Regex("^[0-9]");//判断是不是数据,要不是就表示没有选择。则从隐藏域里读出来
                Match ma = reg.Match(SuiD);
                if (ma.Success)
                {
                    MessageBox.Show("图层名称不能以数字开头!", "警告");
                    return;
                }

                GSODataset dataset = ds.GetDatasetByName(txtLayerName.Text.Trim());
                GSOFeatureDataset featdataset = null;
                if (dataset != null)
                {
                    DialogResult result = MessageBox.Show("特征管点图层名称在数据库中已存在!是否向该表追加", "提示", MessageBoxButtons.YesNo);
                    if (result == DialogResult.Yes)
                    {
                        featdataset = dataset as GSOFeatureDataset;
                    }
                    else
                    {
                        return;
                    }
                }
                else
                {
                    featdataset = CreateDBFeatureDataset(txtLayerName.Text.Trim());
                }
                if (featdataset == null)
                {
                    return;
                }

                featdataset.Open();

                GSOLayer shpLayer = globeControl1.Globe.Layers.GetLayerByCaption(selectLayerName);
                if (shpLayer == null)
                    return;

                if (featdataset != null)
                {
                    GSOFeatures features = shpLayer.GetAllFeatures(true);

                    GSOFeatures layerFeatures = featdataset.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);
                        }
                    }

                    for (int j = 0; j < features.Length; j++)
                    {
                        GSOFeature f = features[j];
                        if (f != null)
                        {

                            if (listFeature.Contains(f.GetFieldAsString("编号").Trim()))
                            {
                                continue;
                            }
                            else
                            {
                                GSOGeoPoint3D shpPoint = f.Geometry as GSOGeoPoint3D;
                                double deep = f.GetFieldAsDouble(combDeep.SelectedItem.ToString());
                                string currentModelType = f.GetValue(combCode.SelectedItem.ToString()).ToString();

                                string tz = f.GetValue("管点特征").ToString();

                                GSOFeature feature = featdataset.CreateFeature();
                                GSOGeoModel model = new GSOGeoModel();
                                GSOPoint3d pt = new GSOPoint3d();
                                pt.X = shpPoint.X;
                                pt.Y = shpPoint.Y;
                                pt.Z = f.GetFieldAsDouble("z坐标");

                                model.Position = pt;
                                //model.AltitudeMode = EnumAltitudeMode.RelativeToGround;
                                model.AltitudeMode = EnumAltitudeMode.Absolute;

                                if (comboBoxEx1.SelectedItem.ToString().Contains("雨水") || comboBoxEx1.SelectedItem.ToString().Contains("污水") || comboBoxEx1.SelectedItem.ToString().Contains("雨污合流") || comboBoxEx1.SelectedItem.ToString().Contains("中水"))
                                {
                                    model.FilePath = Application.StartupPath + "\\" + "管道配件gcm\\分支点\\分支点.gcm";
                                }
                                else
                                {
                                    string filepath = "管道配件gcm" + "\\" + tz + "\\" + tz + ".gcm";
                                    model.FilePath = Application.StartupPath + "\\" + filepath;
                                }

                                model.Name = f.GetValue(combModelName.SelectedItem.ToString()).ToString();
                                feature.Name = f.GetValue(combModelName.SelectedItem.ToString()).ToString();
                                feature.Geometry = model;

                                for (int i = 0; i < feature.GetFieldCount(); i++)
                                {
                                    if (f.GetFieldCount() > i)
                                    {
                                        GeoScene.Data.GSOFieldDefn fielddef = (GeoScene.Data.GSOFieldDefn)(f.GetFieldDefn(i));
                                        if (fielddef == null)
                                            continue;

                                        object obu = f.GetValue(fielddef.Name);
                                        if (obu != null)
                                        {
                                            string fieldName = yb_cns.ContainsKey(fielddef.Name) == true ? yb_cns[fielddef.Name].ToString() : fielddef.Name;
                                            feature.SetValue(fieldName, obu);
                                        }
                                    }
                                }
                                featdataset.AddFeature(feature);
                            }
                        }
                    }
                }

                featdataset.Save();
                MessageBox.Show("入库成功!", "提示");

                ds = globeControl1.Globe.DataManager.OpenOracleDataSource(Utility.DBServer.Trim() + "/" + Utility.dbdatabase.Trim(), "",
                       "", Utility.userID, Utility.DBPassword);

                if (shpLayer == null)
                {
                    globeControl1.Globe.Layers.Remove(shpLayer);
                }
                GSOLayer layer = globeControl1.Globe.Layers.Add(featdataset);
                rukuLayer = layer;
                this.DialogResult = DialogResult.OK;
                this.Close();
            }
            catch (Exception ex)
            {
                LogError.PublishError(ex);
                MessageBox.Show(ex.Message);
            }
        } 
        
        private GSOFeatureDataset CreateDBFeatureDataset(string name)
        {
            GSOLayer layer = globeControl1.Globe.Layers.GetLayerByCaption(selectLayerName);
            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));

                GSOFieldAttr field = new GSOFieldAttr();

                field.Name = yb_cns.ContainsKey(fielddef.Name) == true ? yb_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;
        }

        private void FrmAddWellShp_Load(object sender, EventArgs e)
        {

            comboBoxEx1.Items.Clear();
            if (globeControl1 != null)
            {
                for (int i = 0; i < globeControl1.Globe.Layers.Count; i++)
                {
                    GSOLayer layer = globeControl1.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 == "TeZhengGuanDian")
                        {
                            string str1 = XmlReader["label"];
                            string str3 = XmlReader["type"];
                            string str2 = XmlReader.ReadElementString();
                            yb_cns.Add(str1, str2);
                            yb_types.Add(str1, str3);
                        }
                    }
                }
                catch (Exception ex)
                {
                    LogError.PublishError(ex);
                    MessageBox.Show(ex.Message);
                }
            }
        }

        private void cmbLayer_SelectedIndexChanged(object sender, EventArgs e)
        {
            GSOLayer layer = globeControl1.Globe.Layers.GetLayerByCaption(selectLayerName);
            GSOFeatures features = layer.GetAllFeatures();
            if (features.Length == 0)
                return;

            combCode.Items.Clear();
            combDeep.Items.Clear();
            combModelName.Items.Clear();
            //comboLoad.Items.Clear();
            for (int i = 0; i < features[0].GetFieldCount(); i++)
            {
                GeoScene.Data.GSOFieldDefn fielddef = (GeoScene.Data.GSOFieldDefn)(features[0].GetFieldDefn(i));
                combCode.Items.Add(fielddef.Name);
                combDeep.Items.Add(fielddef.Name);
                combModelName.Items.Add(fielddef.Name);
                //comboLoad.Items.Add(fielddef.Name);
            }
            combCode.SelectedItem = "附属物编码";
            combDeep.SelectedItem = "Z坐标";
            combModelName.SelectedItem = "编号";
            //comboLoad.SelectedItem = "模型路径";
        }

        private void buttonXLayerPath_Click(object sender, EventArgs e)
        {
            OpenFileDialog dlg = new OpenFileDialog();
            dlg.Filter = "*.shp|*.shp";
            dlg.Multiselect = false;
            if (dlg.ShowDialog() == DialogResult.OK)
            {
                GSOLayer layer = globeControl1.Globe.Layers.Add(dlg.FileName);
                string txtMessage = valiYBdata(layer);
                if (txtMessage != "")
                {
                    button3.Enabled = false;
                    //textBoxLayer.Text = "";
                    combCode.Items.Clear();
                    combDeep.Items.Clear();
                    combModelName.Items.Clear();
                    globeControl1.Globe.Layers.Remove(layer);
                    FrmValiDataShowErrorMessage showErrorMessage = new FrmValiDataShowErrorMessage(dlg.FileName, txtMessage);
                    showErrorMessage.ShowDialog();
                    return;
                }
                else
                {
                    button3.Enabled = true;
                    //textBoxLayer.Text = dlg.FileName;
                    selectLayerName = layer.Caption;
                    txtLayerName.Text = layer.Caption;
                    GSOFeatures features = layer.GetAllFeatures();
                    if (features.Length == 0)
                        return;

                    combCode.Items.Clear();
                    combDeep.Items.Clear();
                    combModelName.Items.Clear();
                    for (int i = 0; i < features[0].GetFieldCount(); i++)
                    {
                        GeoScene.Data.GSOFieldDefn fielddef = (GeoScene.Data.GSOFieldDefn)(features[0].GetFieldDefn(i));
                        combCode.Items.Add(fielddef.Name);
                        combDeep.Items.Add(fielddef.Name);
                        combModelName.Items.Add(fielddef.Name);
                        //comboLoad.Items.Add(fielddef.Name);
                    }
                    combCode.SelectedItem = "管点编码";
                    combDeep.SelectedItem = "Z坐标";
                    combModelName.SelectedItem = "编号";
                }
            }
        }

        private void FrmAddYuBiZiShp_FormClosing(object sender, FormClosingEventArgs e)
        {
            globeControl1.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];
                    }
                }

                GSOLayer layer = globeControl1.Globe.Layers.Add(layerCaption);
                string txtMessage = valiYBdata(layer);
                if (txtMessage != "")
                {
                    button3.Enabled = false;
                    //textBoxLayer.Text = "";
                    combCode.Items.Clear();
                    combDeep.Items.Clear();
                    combModelName.Items.Clear();
                    globeControl1.Globe.Layers.Remove(layer);
                    FrmValiDataShowErrorMessage showErrorMessage = new FrmValiDataShowErrorMessage(layerCaption, txtMessage);
                    showErrorMessage.ShowDialog();
                    return;
                }
                else
                {
                    button3.Enabled = true;
                    //textBoxLayer.Text = layerCaption;
                    selectLayerName = layer.Caption;
                    txtLayerName.Text = layer.Caption;
                    GSOFeatures features = layer.GetAllFeatures();
                    if (features.Length == 0)
                        return;

                    combCode.Items.Clear();
                    combDeep.Items.Clear();
                    combModelName.Items.Clear();
                    for (int i = 0; i < features[0].GetFieldCount(); i++)
                    {
                        GeoScene.Data.GSOFieldDefn fielddef = (GeoScene.Data.GSOFieldDefn)(features[0].GetFieldDefn(i));
                        combCode.Items.Add(fielddef.Name);
                        combDeep.Items.Add(fielddef.Name);
                        combModelName.Items.Add(fielddef.Name);
                    }
                    combCode.SelectedItem = "管点编码";
                    combDeep.SelectedItem = "Z坐标";
                    combModelName.SelectedItem = "编号";
                }
            }

        }

    }
}