private void FrmAtrributeMapping_Load(object sender, EventArgs e)
{
this.MaximizeBox = false;
if (m_feature != null)
{
try
{
//ArrayList list = new ArrayList();
dt = new DataTable(m_feature.Name);
DataColumn dcName = new DataColumn("Name", typeof(string));
DataColumn dcValue = new DataColumn("Value", typeof(string));
dt.Columns.Add(dcName);
dt.Columns.Add(dcValue);
dt.Columns["Name"].ReadOnly = true;
for (int j = 0; j < m_feature.GetFieldCount(); j++)
{
DataRow dr = dt.NewRow();
GSOFieldDefn field = (GSOFieldDefn)m_feature.GetFieldDefn(j);
if (field != null)
{
dr["Name"] = field.Name;
object obj = m_feature.GetValue(j);
if (obj != null)
{
dr["Value"] = obj.ToString();
DateTime date = DateTime.Now.Date;
bool isDatetime = DateTime.TryParse(obj.ToString(), out date);
if (isDatetime)
{
dr["Value"] = date.ToShortDateString();
list.Add(j);
}
}
}
dt.Rows.Add(dr);
}
dataGridView1.DataSource = dt;
dataGridView1.Columns[0].HeaderText = "属性名";
dataGridView1.Columns[1].HeaderText = "属性值";
//for (int i = 0; i < list.Count; i++)
//{
// int index = int.Parse(list[i].ToString());
// dataGridView1[1,index].ReadOnly = true;
//}
}
catch (System.Exception exp)
{
Log.PublishTxt(exp);
}
}
}
private void CtrlLineFieldsValuePage_Load(object sender, EventArgs e)
{
if (m_feature != null)
{
try
{
dt = new DataTable(m_feature.Name);
DataColumn dcName = new DataColumn("属性名", typeof(string));
DataColumn dcValue = new DataColumn("属性值", typeof(string));
dt.Columns.Add(dcName);
dt.Columns.Add(dcValue);
dt.Columns["属性名"].ReadOnly = true;
if (m_feature.GetFieldCount() > 0)
{
for (int j = 0; j < m_feature.GetFieldCount(); j++)
{
DataRow dr = dt.NewRow();
GSOFieldDefn field = (GSOFieldDefn)m_feature.GetFieldDefn(j);
if (field != null)
{
dr["属性名"] = field.Name;
object obj = m_feature.GetValue(j);
if (obj != null)
{
dr["属性值"] = obj.ToString();
if (obj.GetType() == typeof(DateTime))
{
DateTime date = DateTime.Parse(obj.ToString());
dr["属性值"] = date.ToShortDateString();
}
}
}
dt.Rows.Add(dr);
}
}
dataGridView1.DataSource = dt;
dataGridView1.ReadOnly = !mlayer.Editable;
dataGridView1.Columns[0].Width = 100;
dataGridView1.Columns[1].Width = 200;
}
catch (System.Exception exp)
{
Log.PublishTxt(exp);
}
}
}
//获取字段值
private void comboBoxConditionFieldName_SelectedIndexChanged(object sender, EventArgs e)
{
if (layer == null)
{
MessageBox.Show("请先选择一个图层！");
return;
}
comboBoxConditionFieldValue.Items.Clear();
try
{
for (int i = 0; i < layer.GetAllFeatures().Length; i++)
{
GSOFeature f = layer.GetAt(i);
if (f != null)
{
object fieldValue = f.GetValue(comboBoxConditionFieldName.Text);
if (f != null && fieldValue != null && comboBoxConditionFieldValue.Items.Contains(fieldValue) == false)
{
comboBoxConditionFieldValue.Items.Add(fieldValue);
}
}
}
GSOFeatureDataset featureDataset = layer.Dataset as GSOFeatureDataset;
if (featureDataset != null)
{
GSOFieldAttr field = featureDataset.GetField(comboBoxConditionFieldName.Text);
if (field != null)
{
switch (field.Type)
{
case EnumFieldType.Text:
comboBoxCondition.Items.Clear();
comboBoxCondition.Items.Add("=");
break;
case EnumFieldType.Double:
case EnumFieldType.INT32:
case EnumFieldType.Date:
comboBoxCondition.Items.Clear();
comboBoxCondition.Items.Add("=");
comboBoxCondition.Items.Add(">=");
comboBoxCondition.Items.Add("<=");
comboBoxCondition.Items.Add(">");
comboBoxCondition.Items.Add("<");
break;
}
}
}
}
catch (Exception ex)
{
Log.PublishTxt(ex);
MessageBox.Show(ex.Message);
}
}
private void buttonGetFieldValue_Click(object sender, EventArgs e)
{
string fieldName = comboBoxFieldNames.Text.Trim();
if (fieldName == "")
{
MessageBox.Show("请选择字段名称！", "提示");
return;
}
GSOLayer layer = ctl.Globe.Layers.GetLayerByCaption(cmbLayers.Text.Trim());
if (layer == null)
{
MessageBox.Show("请选择图层", "提示");
return;
}
if (layer.Type != EnumLayerType.FeatureLayer)
{
MessageBox.Show("当前选中的图层不是模型图层！", "提示");
return;
}
GSOFeatureLayer featureLayer = layer as GSOFeatureLayer;
List <string> listValues = new List <string>();
for (int i = 0; i < featureLayer.GetAllFeatures().Length; i++)
{
GSOFeature feature = featureLayer.GetAt(i);
if (feature != null)
{
object value = feature.GetValue(fieldName);
if (value == null || value.ToString() == "")
{
continue;
}
if (listValues.Contains(value.ToString()) == false)
{
listValues.Add(value.ToString());
}
}
}
listViewFieldValues.Items.Clear();
if (listValues.Count <= 0)
{
MessageBox.Show("没有找到不为空的字段值！", "提示");
return;
}
for (int i = 0; i < listValues.Count; i++)
{
listViewFieldValues.Items.Add(listValues[i]);
}
}
private void SetFields(GSOFeature oldfeat, GSOFeature newFeature)
{
for (int i = 0; i < oldfeat.GetFieldCount(); i++)
{
GeoScene.Data.GSOFieldDefn fielddef = (GeoScene.Data.GSOFieldDefn)(oldfeat.GetFieldDefn(i));
object fieldvalue = oldfeat.GetValue(fielddef.Name);
if (fieldvalue == null)
{
continue;
}
newFeature.SetValue(fielddef.Name, fieldvalue);
}
}
//datagrid绑定数据
public void SetDataTable(GSOFeatures feats)
{
if (feats.Length == 0)
{
MessageBox.Show("查询结果为空！", "提示");
return;
}
GSOFeature feat = feats[0];
try
{
DataTable table = new DataTable();
for (int i = 0; i < feat.GetFieldCount(); i++)
{
GSOFieldDefn field = (GSOFieldDefn)feat.GetFieldDefn(i);
table.Columns.Add(field.Name);
}
for (int i = 0; i < feats.Length; i++)
{
GSOFeature f = feats[i];
DataRow row = table.NewRow();
for (int j = 0; j < feat.GetFieldCount(); j++)
{
GSOFieldDefn field = (GSOFieldDefn)feat.GetFieldDefn(j);
row[j] = f.GetValue(field.Name);
}
table.Rows.Add(row);
}
dataGridView1.DataSource = table;
for (int i = 0; i < feats.Length; i++)
{
GSOFeature f = feats[i];
if (dataGridView1.Rows.Count > i)
{
dataGridView1.Rows[i].Tag = f;
}
}
}
catch (System.Exception exp)
{
Log.PublishTxt(exp);
MessageBox.Show(exp.Message, "提示");
}
}
//获取唯一值添加到listbox_Value中
private void btn_GetValue_Click(object sender, EventArgs e)
{
if (listBox_Field.SelectedItem == null)
{
MessageBox.Show("请先选中一个字段！", "提示");
return;
}
listBox_Value.Items.Clear();
string strSepratorOfString = "";
GSOFieldAttr fieldef = sourcefDataset.GetField(listBox_Field.SelectedItem.ToString().Trim());
if (fieldef == null)
{
return;
}
if (fieldef.Type == EnumFieldType.Text)
{
strSepratorOfString = "'";
}
try
{
for (int i = 0; i < sourcefDataset.GetAllFeatures().Length; i++)
{
GSOFeature feature = sourcefDataset.GetFeatureAt(i);
if (feature != null)
{
object fieldValue = feature.GetValue(listBox_Field.SelectedItem.ToString().Trim());
if (fieldValue != null && listBox_Value.Items.Contains(strSepratorOfString + fieldValue.ToString() + strSepratorOfString) == false)
{
listBox_Value.Items.Add(strSepratorOfString + fieldValue.ToString() + strSepratorOfString);
}
}
}
}
catch (Exception ex)
{
Log.PublishTxt(ex);
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
int selectIndex = listBox1.SelectedIndex;
if (selectIndex >= 0)
{
string name = listBox1.SelectedItem.ToString();
if (features != null)
{
if (features.Length > 0)
{
for (int i = 0; i < features.Length; i++)
{
GSOFeature feature = features[i];
feature.Name = feature.GetValue(name.Trim()).ToString();
}
this.Close();
}
}
}
}
private void FrmShowValveInformation_Load(object sender, EventArgs e)
{
labelValveInformation.Text = "共匹配了" + valveCount + "个阀门！";//localhost_casic_pipe_test
if (features != null)
{
labelValveInformation.Text += "共有" + features.Length + "个阀门没有匹配！";
for (int i = 0; i < features.Length; i++)
{
GSOFeature f = features[i];
if (f != null)
{
for (int j = 0; j < f.GetFieldCount(); j++)
{
GSOFieldDefn fieldDefn = (GSOFieldDefn)f.GetFieldDefn(j);
if (fieldDefn != null)
{
dataGridView1.Columns.Add(fieldDefn.Name, fieldDefn.Name);
}
}
break;
}
}
for (int i = 0; i < features.Length; i++)
{
GSOFeature f = features[i];
if (f != null)
{
int rowIndex = dataGridView1.Rows.Add();
for (int j = 0; j < f.GetFieldCount(); j++)
{
dataGridView1.Rows[rowIndex].Cells[j].Value = f.GetValue(j);
}
}
}
}
}
private void button3_Click(object sender, EventArgs e)
{
if (comboBoxDataSourceList.SelectedItem == null)
{
MessageBox.Show("请选择一个目标数据源！", "提示");
return;
}
GSODataSource ds = Utility.getDataSourceByFullName(globeControl1, comboBoxDataSourceList.SelectedItem.ToString().Trim());
if (ds == null)
{
MessageBox.Show("选择的目标数据源为空！", "提示");
return;
}
if (textBoxModelFolder.Text == "")
{
return;
}
if (comboBoxShpLayerList.SelectedIndex < 0)
{
return;
}
try
{
Regex regNum = new Regex("^[0-9]");
DirectoryInfo theFolder = new DirectoryInfo(textBoxModelFolder.Text);
foreach (FileInfo nextFile in theFolder.GetFiles())
{
if (nextFile.Name.ToLower().IndexOf("3ds") > -1 || nextFile.Name.ToLower().IndexOf("gcm") > -1)
{
files.Add(nextFile.Name);
string temp = nextFile.Name.Substring(nextFile.Name.IndexOf("-") + 1, nextFile.Name.LastIndexOf(".") - nextFile.Name.IndexOf("-") - 1);
string modeltype = nextFile.Name.Substring(0, nextFile.Name.IndexOf("-"));
modeltypes.Add(modeltype);
double Num;
bool isNum = double.TryParse(temp, out Num);
if (isNum)
{
deeps.Add(Convert.ToDouble(temp));
}
}
}
GSODataset dataset = ds.GetDatasetByName(textBoxNewLayerName.Text.Trim());
GSOFeatureDataset featdataset;
if (dataset != null)
{
DialogResult result = MessageBox.Show("工井图层名称在数据库中已存在！是否向该表追加", "提示", MessageBoxButtons.YesNo);
if (result == DialogResult.No)
{
return;
}
else if (result == DialogResult.Yes)
{
featdataset = dataset as GSOFeatureDataset;
}
else
{
return;
}
}
else
{
featdataset = CreateDBFeatureDataset(textBoxNewLayerName.Text.Trim());
}
if (featdataset == null)
{
return;
}
featdataset.Open();
GSOLayer shpLayer = globeControl1.Globe.Layers.GetLayerByCaption(comboBoxShpLayerList.SelectedItem.ToString().Trim());
if (shpLayer == null)
{
return;
}
GSOFeatures features = shpLayer.GetAllFeatures(true);
string message = "";
for (int j = 0; j < features.Length; j++)
{
GSOFeature f = features[j];
GSOGeoPoint3D shpPoint = f.Geometry as GSOGeoPoint3D;
double x;
double y;
double rotateAngle = 0;
string currentModelType = f.GetValue(combCode.SelectedItem.ToString()).ToString();
double z = Convert.ToDouble(txtUpGround.Text);
double deep = f.GetFieldAsDouble(combDeep.SelectedItem.ToString());
int index = -1;
double diff = double.MaxValue;
for (int i = 0; i < deeps.Count; i++)
{
double tempdeep = Convert.ToDouble(deeps[i]);
string modeltype = modeltypes[i].ToString();
if (modeltype != currentModelType)
{
continue;
}
if (tempdeep > deep)
{
double chazhi = tempdeep - deep;
if (diff > chazhi)
{
diff = chazhi;
index = i;
}
}
}
if (index < 0)
{
message += "ID为" + f.ID + "的对象没有找到符合井深的工井模型\r\n";
continue;
}
GSOFeature feature = featdataset.CreateFeature();
GSOGeoModel model = new GSOGeoModel();
GSOPoint3d pt = new GSOPoint3d();
pt.X = shpPoint.X;
pt.Y = shpPoint.Y;
pt.Z = z;
model.Position = pt;
model.Align = EnumEntityAlign.TopCenter; //接口已修复作用
model.AltitudeMode = EnumAltitudeMode.RelativeToGround;
model.RotateZ = 0 - rotateAngle * 180 / Math.PI + 90;
model.FilePath = textBoxModelFolder.Text + "\\" + files[index];
model.Name = f.GetValue(combModelName.SelectedItem.ToString()).ToString();
feature.Name = f.GetValue(combModelName.SelectedItem.ToString()).ToString();
feature.Geometry = model;
for (int i = 0; i < f.GetFieldCount(); i++)
{
GeoScene.Data.GSOFieldDefn fielddef = (GeoScene.Data.GSOFieldDefn)(f.GetFieldDefn(i));
if (fielddef == null)
{
continue;
}
if (!gj_cns.ContainsKey(fielddef.Name))
{
continue;
}
object obu = f.GetValue(fielddef.Name);
if (obu != null)
{
string fieldName = gj_cns.ContainsKey(fielddef.Name) == true ? gj_cns[fielddef.Name].ToString() : fielddef.Name;
feature.SetValue(fieldName, obu);
}
}
featdataset.AddFeature(feature);
}
featdataset.Save();
featdataset.Close();
string strMessage = "shp文件中共" + features.Length + "个对象，实际入库" + featdataset.GetAllFeatures().Length + "个对象！\r\n";
if (message == "")
{
MessageBox.Show(strMessage, "提示");
}
else
{
FrmMessageShow frm = new FrmMessageShow(strMessage + message);
frm.ShowDialog();
}
this.Close();
}
catch (Exception ex)
{
Log.PublishTxt(ex);
MessageBox.Show(ex.Message);
}
}
private void button3_Click(object sender, EventArgs e)
{
if (txtFolder.Text == "")
{
return;
}
//if (txtPath.Text == "")
// return;
try
{
Regex regNum = new Regex("^[0-9]");
DirectoryInfo theFolder = new DirectoryInfo(txtFolder.Text);
foreach (FileInfo nextFile in theFolder.GetFiles())
{
if (nextFile.Name.ToLower().IndexOf("3ds") > -1 || nextFile.Name.ToLower().IndexOf("gcm") > -1)
{
files.Add(nextFile.Name);
string temp = nextFile.Name.Substring(nextFile.Name.IndexOf("-") + 1, nextFile.Name.LastIndexOf(".") - nextFile.Name.IndexOf("-") - 1);
string modeltype = nextFile.Name.Substring(0, nextFile.Name.IndexOf("-"));
modeltypes.Add(modeltype);
double Num;
bool isNum = double.TryParse(temp, out Num);
if (isNum)
{
deeps.Add(Convert.ToDouble(temp));
}
}
}
// TextReader tr = new StreamReader(txtPath.Text);
// string line = tr.ReadLine();
// GSOFeatureDataset featdataset = CreateDBFeatureDataset(txtLayerName.Text); // 创建 数据库要素集
// return;
if (string.IsNullOrEmpty(txtLayerName.Text))
{
MessageBox.Show("管线图层无效！", "提示");
return;
}
GSODataset dataset = ds.GetDatasetByName(txtLayerName.Text.Trim());
GSOFeatureDataset layer;
if (dataset != null)
{
DialogResult restult = MessageBox.Show("管线图层名称在数据库中已存在！是否向该表追加", "提示", MessageBoxButtons.YesNo);
if (restult == DialogResult.No)
{
return;
}
else if (restult == DialogResult.Yes)
{
layer = dataset as GSOFeatureDataset;
}
else
{
return;
}
}
else
{
layer = CreateDBFeatureDataset(txtLayerName.Text.Trim());
}
if (layer == null)
{
return;
}
GSOLayer sourceLayer = globeControl1.Globe.Layers[cmbLayer.SelectedIndex];
MessageBox.Show("创建成功！");
layer.Open();
lgdFilePath = txtLayerName.Text;
if (layer != null)
{
GSOFeatures features = sourceLayer.GetAllFeatures(true);
for (int j = 0; j < features.Length; j++)
{
GSOFeature f = features[j];
GSOGeoPoint3D lineeee = f.Geometry as GSOGeoPoint3D;
//double x;
//double y;
//double rotateAngle = 0;
//string currentModelType = f.GetValue("管线点编码").ToString(); // paras[6];
//double z = Convert.ToDouble(txtUpGround.Text);
//double deep = f.GetFieldAsDouble("井深");
//int index = -1;
//double diff = double.MaxValue;
//for (int i = 0; i < deeps.Count; i++)
//{
// double tempdeep = Convert.ToDouble(deeps[i]);
// string modeltype = modeltypes[i].ToString();
// if (modeltype != currentModelType)
// {
// continue;
// }
// if (tempdeep > deep)
// {
// double chazhi = tempdeep - deep;
// if (diff > chazhi)
// {
// diff = chazhi;
// index = i;
// }
// }
//}
//if (index < 0)
//{
// continue;
//}
//GSOFeature newFeature = layer.CreateFeature();
//GSOGeoModel model = new GSOGeoModel();
//GSOPoint3d pt = new GSOPoint3d();
//pt.X = lineeee.X;
//pt.Y = lineeee.Y;
//pt.Z = z;
//model.Position = pt;
//model.Align = EnumEntityAlign.TopCenter; //接口已修复作用
//model.AltitudeMode = EnumAltitudeMode.RelativeToGround;
//model.RotateZ = 0 - rotateAngle * 180 / Math.PI + 90;
//model.FilePath = txtFolder.Text + "\\" + files[index];
GSOFeature newFeature = layer.CreateFeature();
for (int i = 0; i < features[0].GetFieldCount(); i++)
{
GeoScene.Data.GSOFieldDefn fielddef = (GeoScene.Data.GSOFieldDefn)(features[0].GetFieldDefn(i));
if (!en_cns.ContainsKey(fielddef.Name))
{
continue;
}
object fieldvalue = convertFieldValue(fielddef.Name, f.GetValue(fielddef.Name));
if (fielddef == null)
{
continue;
}
newFeature.SetValue(en_cns[fielddef.Name].ToString(), fieldvalue);
}
layer.AddFeature(newFeature);
}
}
globeControl1.Refresh();
layer.Save();
layer.Caption = layer.Name;
globeControl1.Globe.Layers.Add(layer);
this.Close();
//创建
//featdataset.Open();
//while (line != null)
//{
// string[] paras = line.Split(',');
// if (paras.Length != 16)
// {
// line = tr.ReadLine();
// continue;
// }
// if (paras.Length <= 15)
// {
// line = tr.ReadLine();
// continue;
// }
// if (paras[4] == "" || paras[5] == "" || paras[6] == "")
// {
// line = tr.ReadLine();
// continue;
// }
// double x;
// double y;
// if (!double.TryParse(paras[5], out x))
// {
// line = tr.ReadLine();
// continue;
// }
// if (!double.TryParse(paras[4], out y))
// {
// line = tr.ReadLine();
// continue;
// }
// double rotateAngle = 0;
// if (!double.TryParse(paras[15], out rotateAngle))
// {
// line = tr.ReadLine();
// continue;
// }
// string currentModelType = paras[6];
// if (currentModelType.Length == 0)
// {
// line = tr.ReadLine();
// continue;
// }
// int id = GeoScene.Data.GSOProjectManager.AddProject("+proj=tmerc +lat_0=0 +lon_0=117 +k=1 +x_0=-50000 +y_0=-4210000 +ellps=krass +units=m +no_defs");
// GeoScene.Data.GSOPoint2d pt2d = new GeoScene.Data.GSOPoint2d(x, y);
// GeoScene.Data.GSOPoint2d result = GeoScene.Data.GSOProjectManager.Inverse(pt2d, id);
//double z = Convert.ToDouble(txtUpGround.Text);
//GSOFeature feature = featdataset.CreateFeature();
//double deep;
//if (!double.TryParse(paras[8], out deep))
//{
// line = tr.ReadLine();
// continue;
//}
//int index = -1;
//double diff = double.MaxValue;
//for (int i = 0; i < deeps.Count; i++)
//{
// double tempdeep = Convert.ToDouble(deeps[i]);
// string modeltype = modeltypes[i].ToString();
// if (modeltype != currentModelType)
// {
// continue;
// }
// if (tempdeep > deep)
// {
// double chazhi = tempdeep - deep;
// if (diff > chazhi)
// {
// diff = chazhi;
// index = i;
// }
// }
//}
//if (index < 0)
//{
// line = tr.ReadLine();
// continue;
//}
//GSOGeoModel model = new GSOGeoModel();
//GSOPoint3d pt = new GSOPoint3d();
//pt.X = result.X;
//pt.Y = result.Y;
//pt.Z = z;
//model.Position = pt;
//model.Align = EnumEntityAlign.TopCenter; //接口已修复作用
//model.AltitudeMode = EnumAltitudeMode.RelativeToGround;
//model.RotateZ = 0 - rotateAngle * 180 / Math.PI + 90;
//model.FilePath = txtFolder.Text + "\\" + files[index];
//model.Name = paras[0];
//feature.Name = paras[0];
//feature.Geometry = model;
// if (paras[9].Length > 0)
// feature.SetValue("图片编码", paras[9]);
// // feature.SetValue("旋转角度", 0 - rotateAngle * 180 / Math.PI + 90);
// feature.SetValue("编号", paras[0]);
// // feature.SetValue("模型路径", txtFolder.Text + "\\" + files[index]);
// feature.SetValue("建设年代",paras[10]);
// feature.SetValue("建设单位", paras[12]);
// feature.SetValue("权属单位",paras[13]);
// feature.SetValue("备注",paras[14]);
// featdataset.AddFeature(feature);
// line = tr.ReadLine();
//}
//featdataset.Save();
//this.Close();
}
catch (Exception ex)
{
Log.PublishTxt(ex);
MessageBox.Show(ex.Message);
}
}
public void SetDataTable()
{
this.Shown += new EventHandler(Frm_TableAttribute_Shown);
GSOFeatureLayer pFeatureLayer = geoLayer as GSOFeatureLayer;
GSOFeatureDataset pFeatureDataset = pFeatureLayer.Dataset as GSOFeatureDataset;
if (pFeatureLayer == null || pFeatureDataset == null)
{
MessageBox.Show("该数据不是属性数据，属性表为空！", "提示！", MessageBoxButtons.OK, MessageBoxIcon.Error);
isShow = false;
return;
}
else
{
GSOFeatures feats = m_features;// pFeatureLayer.GetAllFeatures();
GSOFeature feat = feats[0];
countLog = 0;
GetReallyFeature(feats);
try
{
dataGridView1.Columns.Clear();
dataGridView1.Rows.Clear();
for (int j = 0; j < pFeatureDataset.FieldCount; j++)
{
GSOFieldAttr field = pFeatureDataset.GetField(j);
dataGridView1.Columns.Add(field.Name, field.Name);
}
for (int i = 0; i < feats.Length; i++)
{
feat = feats[i];
if (feat == null)
{
continue;
}
int rowIndex = dataGridView1.Rows.Add();
dataGridView1.Rows[rowIndex].Tag = feat;
for (int j = 0; j < feat.GetFieldCount(); j++)
{
GSOFieldDefn field = (GSOFieldDefn)feat.GetFieldDefn(j);
object fieldValue = feat.GetValue(j);
if (fieldValue != null)
{
dataGridView1.Rows[rowIndex].Cells[j].Value = fieldValue.ToString();
}
}
}
dataGridView1.ReadOnly = !pFeatureLayer.Editable;
this.编辑ToolStripMenuItem.BackColor = geoLayer.Editable == true ? Color.Orange : Color.Transparent;
if (statusStrip1.Items.Count > 0)
{
if (dataGridView1.Rows.Count >= countLog)
{
statusStrip1.Items[0].Text = " 共有 " + dataGridView1.Rows.Count + " 条记录";
}
else
{
statusStrip1.Items[0].Text = " 共有 " + countLog + " 条记录";
}
}
}
catch (System.Exception exp)
{
Log.PublishTxt(exp);
if (statusStrip1.Items.Count > 0)
{
statusStrip1.Items[0].Text = " 共有 " + 0 + " 条记录";
}
}
}
}
//查询
private void buttonConditionSelect_Click(object sender, EventArgs e)
{
if (layer == null)
{
MessageBox.Show("请选择一个图层！");
return;
}
if (comboBoxConditionFieldName.Text == "" || comboBoxConditionFieldValue.Text == "" || comboBoxCondition.Text == "")
{
MessageBox.Show("请输入完整的查询条件！", "提示");
return;
}
GSOFeatureDataset featureDataset = layer.Dataset as GSOFeatureDataset;
EnumFieldType currentFieldType = EnumFieldType.Text;
if (featureDataset != null)
{
GSOFieldAttr field = featureDataset.GetField(comboBoxConditionFieldName.Text);
if (field != null)
{
switch (field.Type)
{
case EnumFieldType.Double:
case EnumFieldType.INT32:
currentFieldType = EnumFieldType.Double;
break;
case EnumFieldType.Date:
currentFieldType = EnumFieldType.Date;
break;
}
}
}
try
{
switch (comboBoxCondition.Text)
{
case "=":
for (int i = 0; i < layer.GetAllFeatures().Length; i++)
{
GSOFeature feature = layer.GetAt(i);
if (feature != null && feature.GetValue(comboBoxConditionFieldName.Text).ToString() == comboBoxConditionFieldValue.Text)
{
features.Add(feature);
}
}
break;
case ">=":
for (int i = 0; i < layer.GetAllFeatures().Length; i++)
{
GSOFeature feature = layer.GetAt(i);
if (currentFieldType == EnumFieldType.Double)
{
if (feature != null && Double.Parse(feature.GetFieldAsDataTime(comboBoxConditionFieldName.Text).ToString()) >= Double.Parse(comboBoxConditionFieldValue.Text))
{
features.Add(feature);
}
}
else if (currentFieldType == EnumFieldType.Date)
{
if (feature != null && DateTime.Parse(feature.GetFieldAsDataTime(comboBoxConditionFieldName.Text).ToString()) >= DateTime.Parse(comboBoxConditionFieldValue.Text))
{
features.Add(feature);
}
}
}
break;
case "<=":
for (int i = 0; i < layer.GetAllFeatures().Length; i++)
{
GSOFeature feature = layer.GetAt(i);
if (currentFieldType == EnumFieldType.Double)
{
if (feature != null && Double.Parse(feature.GetFieldAsDataTime(comboBoxConditionFieldName.Text).ToString()) <= Double.Parse(comboBoxConditionFieldValue.Text))
{
features.Add(feature);
}
}
else if (currentFieldType == EnumFieldType.Date)
{
if (feature != null && DateTime.Parse(feature.GetFieldAsDataTime(comboBoxConditionFieldName.Text).ToString()) <= DateTime.Parse(comboBoxConditionFieldValue.Text))
{
features.Add(feature);
}
}
}
break;
case ">":
for (int i = 0; i < layer.GetAllFeatures().Length; i++)
{
GSOFeature feature = layer.GetAt(i);
if (currentFieldType == EnumFieldType.Double)
{
if (feature != null && Double.Parse(feature.GetFieldAsDataTime(comboBoxConditionFieldName.Text).ToString()) > Double.Parse(comboBoxConditionFieldValue.Text))
{
features.Add(feature);
}
}
else if (currentFieldType == EnumFieldType.Date)
{
if (feature != null && DateTime.Parse(feature.GetFieldAsDataTime(comboBoxConditionFieldName.Text).ToString()) > DateTime.Parse(comboBoxConditionFieldValue.Text))
{
features.Add(feature);
}
}
}
break;
case "<":
for (int i = 0; i < layer.GetAllFeatures().Length; i++)
{
GSOFeature feature = layer.GetAt(i);
if (currentFieldType == EnumFieldType.Double)
{
if (feature != null && Double.Parse(feature.GetFieldAsDataTime(comboBoxConditionFieldName.Text).ToString()) < Double.Parse(comboBoxConditionFieldValue.Text))
{
features.Add(feature);
}
}
else if (currentFieldType == EnumFieldType.Date)
{
if (feature != null && DateTime.Parse(feature.GetFieldAsDataTime(comboBoxConditionFieldName.Text).ToString()) < DateTime.Parse(comboBoxConditionFieldValue.Text))
{
features.Add(feature);
}
}
}
break;
}
if (features == null)
{
MessageBox.Show("请重新输入查询条件！", "提示");
return;
}
if (features.Length == 0)
{
MessageBox.Show("没有找到符合查询条件的对象！", "提示");
return;
}
SetDataTable(features);
}
catch (Exception ex)
{
Log.PublishTxt(ex);
MessageBox.Show(ex.Message, "提示");
return;
}
}
private void btnCreateModel_Click(object sender, EventArgs e)
{
if (comboBoxDataSourceList.SelectedItem == null)
{
MessageBox.Show("请选择一个目标数据源！", "提示");
return;
}
GSODataSource ds = Utility.getDataSourceByFullName(globeControl1, comboBoxDataSourceList.SelectedItem.ToString().Trim());
if (ds == null)
{
MessageBox.Show("选择的目标数据源为空！", "提示");
return;
}
try
{
if (string.IsNullOrEmpty(textBoxNewLayerName.Text))
{
MessageBox.Show("管线图层名称无效！", "提示");
return;
}
if (valiPipeData())
{
GSODataset dataset = ds.GetDatasetByName(textBoxNewLayerName.Text.Trim());
GSOFeatureDataset newFeatureDataset;
if (dataset != null)
{
DialogResult result = MessageBox.Show("管线图层名称在数据库中已存在！是否向该表追加", "提示", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
newFeatureDataset = dataset as GSOFeatureDataset;
}
else
{
return;
}
}
else
{
newFeatureDataset = CreateDBFeatureDataset(textBoxNewLayerName.Text.Trim());
}
if (newFeatureDataset == null)
{
MessageBox.Show("输入的图层名称不符合要求！", "提示");
return;
}
GSOLayer sourceLayer = globeControl1.Globe.Layers.GetLayerByCaption(comboBoxShpLayerList.SelectedItem.ToString().Trim());
if (sourceLayer == null)
{
MessageBox.Show("选择的shp图层为空！", "提示");
return;
}
newFeatureDataset.Open();
GSOFeatures features = sourceLayer.GetAllFeatures(true);
string message = "";
for (int j = 0; j < features.Length; j++)
{
GSOFeature f = features[j];
GSOFeature newFeature = newFeatureDataset.CreateFeature();
string maisheFangshi = f.GetFieldAsString(cmbMaiSheFangShi.SelectedItem.ToString());
string eventid = f.GetFieldAsString(cmbID.SelectedItem.ToString());
f.Geometry.AltitudeMode = EnumAltitudeMode.RelativeToGround;
GSOGeoPolyline3D line = f.Geometry as GSOGeoPolyline3D;
if (line == null)
{
message += "ID为" + f.ID + "的管线不是一个线对象\r\n";
continue;
}
double deep1 = f.GetFieldAsDouble(cmbFrom.SelectedItem.ToString());
double deep2 = f.GetFieldAsDouble(cmbTo.SelectedItem.ToString());
if (chkDeep.Checked)
{
deep1 = 0 - deep1;
deep2 = 0 - deep2;
}
if (maisheFangshi == "直埋")
{
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)
{
radius = f.GetFieldAsDouble(cmbRadius.SelectedItem.ToString()) / 2000; // 探测数据的单位一般是毫米，需换算为米； 管径一般是 直径， 这个需要半径， 所有除以2000
}
if (radius == 0)
{
message += "ID为" + f.ID + "的管线半径为0\r\n";
continue;
}
style.Radius = radius;
style.Slice = int.Parse(txtSlice.Text);
style.CornerSliceAngle = Convert.ToDouble(textBoxCornerSliceAngle.Text);
if (cmbReference.SelectedIndex == 0) //管底
{
deep1 = deep1 + radius * 2;
deep2 = deep2 + radius * 2;
}
else if (cmbReference.SelectedIndex == 1) //管顶
{
deep1 = deep1 - radius * 2;
deep2 = deep2 - radius * 2;
}
for (int n = 0; n < line[0].Count; n++)
{
GSOPoint3d pt3d = line[0][n];
int pointcount = line[0].Count;
double fenmu = Math.Sqrt(Math.Pow(line[0][pointcount - 1].Y - line[0][0].Y, 2) + Math.Pow(line[0][pointcount - 1].X - line[0][0].X, 2));
if (fenmu == 0)
{
pt3d.Z = deep1;
}
else
{
double radio = Math.Sqrt(Math.Pow(pt3d.Y - line[0][0].Y, 2) + Math.Pow(pt3d.X - line[0][0].X, 2)) / fenmu;
pt3d.Z = deep1 + (deep2 - deep1) * radio;
}
line[0][n] = pt3d;
}
newFeature.Geometry = line; // f.Geometry;
newFeature.Geometry.Style = style;
}
else if (maisheFangshi == "沟道")
{
GSOExtendSectionLineStyle3D style = new GSOExtendSectionLineStyle3D();
style.LineColor = Color.FromArgb(Convert.ToByte(numericUpDownLineOpaque.Value), btnPipelineColor.BackColor);
double width = 0;
GSOFieldDefn field = (GSOFieldDefn)(f.GetFieldDefn(cmbWidth.SelectedItem.ToString()));
if (field.Type == EnumFieldType.Text)
{
string temp = f.GetFieldAsString(cmbWidth.SelectedItem.ToString());
double outNum = 0;
bool num = double.TryParse(temp, out outNum);
if (num)
{
width = outNum;
}
}
else if (field.Type == EnumFieldType.Double)
{
width = f.GetFieldAsDouble(cmbWidth.SelectedItem.ToString());
}
double height = 0;
field = (GSOFieldDefn)(f.GetFieldDefn(cmbHeight.SelectedItem.ToString()));
if (field.Type == EnumFieldType.Text)
{
string temp = f.GetFieldAsString(cmbHeight.SelectedItem.ToString());
double outNum = 0;
bool num = double.TryParse(temp, out outNum);
if (num)
{
height = outNum;
}
}
else if (field.Type == EnumFieldType.Double)
{
height = f.GetFieldAsDouble(cmbHeight.SelectedItem.ToString());
}
if (width == 0 || height == 0)
{
message += "ID为" + f.ID + "的沟道的宽度或高度为0\r\n";
continue;
}
GSOPoint3ds sectionpts = new GSOPoint3ds();
sectionpts.Add(new GSOPoint3d(width / -2, height / 2, 0));
sectionpts.Add(new GSOPoint3d(width / -2, height / -2, 0));
sectionpts.Add(new GSOPoint3d(width / 2, height / -2, 0));
sectionpts.Add(new GSOPoint3d(width / 2, height / 2, 0));
style.SetSectionPoints(sectionpts);
style.IsClosed = false;
style.SetAnchorByAlign(EnumAlign.BottomCenter);
for (int n = 0; n < line[0].Count; n++)
{
GSOPoint3d pt3d = line[0][n];
int pointcount = line[0].Count;
double fenmu = Math.Sqrt(Math.Pow(line[0][pointcount - 1].Y - line[0][0].Y, 2) + Math.Pow(line[0][pointcount - 1].X - line[0][0].X, 2));
if (fenmu == 0)
{
pt3d.Z = deep1;
}
else
{
double radio = Math.Sqrt(Math.Pow(pt3d.Y - line[0][0].Y, 2) + Math.Pow(pt3d.X - line[0][0].X, 2)) / fenmu;
pt3d.Z = deep1 + (deep2 - deep1) * radio;
}
line[0][n] = pt3d;
}
newFeature.Geometry = line; // f.Geometry;
newFeature.Geometry.Style = style;
}
else
{
message += "ID为" + f.ID + "的对象的埋设方式既不是直埋，也不是沟道\r\n";
continue; // 即不是 直埋，又不是 沟道，那么忽略该记录
}
for (int i = 0; i < f.GetFieldCount(); i++)
{
GeoScene.Data.GSOFieldDefn fielddef = (GeoScene.Data.GSOFieldDefn)(f.GetFieldDefn(i));
if (!en_cns.ContainsKey(fielddef.Name))
{
continue;
}
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);
}
newFeature.Name = eventid;
newFeatureDataset.AddFeature(newFeature);
}
globeControl1.Refresh();
newFeatureDataset.Save();
newFeatureDataset.Close();
newFeatureDataset.Caption = newFeatureDataset.Name;
globeControl1.Globe.Layers.Add(newFeatureDataset);
string strMessage = "shp文件中共" + features.Length + "个对象，实际入库" + newFeatureDataset.GetAllFeatures().Length + "个对象！\r\n";
if (message == "")
{
MessageBox.Show(strMessage, "提示");
}
else
{
FrmMessageShow frm = new FrmMessageShow(strMessage + message);
frm.ShowDialog();
}
this.Close();
}
}
catch (Exception ex)
{
Log.PublishTxt(ex);
MessageBox.Show(ex.Message);
}
}
private void button3_Click(object sender, EventArgs e)
{
if (txtFolder.Text == "")
{
return;
}
if (cmbLayer.SelectedIndex < 0)
{
return;
}
try
{
Regex regNum = new Regex("^[0-9]");
DirectoryInfo theFolder = new DirectoryInfo(txtFolder.Text);
foreach (FileInfo nextFile in theFolder.GetFiles())
{
if (nextFile.Name.ToLower().IndexOf("3ds") > -1 || nextFile.Name.ToLower().IndexOf("gcm") > -1)
{
files.Add(nextFile.Name);
string temp = nextFile.Name.Substring(nextFile.Name.IndexOf("-") + 1, nextFile.Name.LastIndexOf(".") - nextFile.Name.IndexOf("-") - 1);
string modeltype = nextFile.Name.Substring(0, nextFile.Name.IndexOf("-"));
modeltypes.Add(modeltype);
double Num;
bool isNum = double.TryParse(temp, out Num);
if (isNum)
{
deeps.Add(Convert.ToDouble(temp));
}
}
}
GSOFeatureDataset featdataset = CreateDBFeatureDataset(txtLayerName.Text);
featdataset.Open();
GSOLayer shpLayer = globeControl1.Globe.Layers[cmbLayer.SelectedIndex];
if (shpLayer == null)
{
return;
}
GSOFeatures features = shpLayer.GetAllFeatures(true);
for (int j = 0; j < features.Length; j++)
{
GSOFeature f = features[j];
GSOGeoPoint3D shpPoint = f.Geometry as GSOGeoPoint3D;
double x;
double y;
double rotateAngle = 0;
rotateAngle = (double)f.GetValue(combAngle.SelectedItem.ToString());
string currentModelType = f.GetValue(combCode.SelectedItem.ToString()).ToString();
double z = Convert.ToDouble(txtUpGround.Text);
double deep = f.GetFieldAsDouble(combDeep.SelectedItem.ToString());
int index = -1;
double diff = double.MaxValue;
for (int i = 0; i < deeps.Count; i++)
{
double tempdeep = Convert.ToDouble(deeps[i]);
string modeltype = modeltypes[i].ToString();
if (modeltype != currentModelType)
{
continue;
}
if (tempdeep > deep)
{
double chazhi = tempdeep - deep;
if (diff > chazhi)
{
diff = chazhi;
index = i;
}
}
}
if (index < 0)
{
continue;
}
GSOFeature feature = featdataset.CreateFeature();
GSOGeoModel model = new GSOGeoModel();
GSOPoint3d pt = new GSOPoint3d();
pt.X = shpPoint.X;
pt.Y = shpPoint.Y;
pt.Z = z;
model.Position = pt;
model.Align = EnumEntityAlign.TopCenter; //接口已修复作用
model.AltitudeMode = EnumAltitudeMode.RelativeToGround;
model.RotateZ = 0 - rotateAngle * 180 / Math.PI + 90;
model.FilePath = txtFolder.Text + "\\" + files[index];
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++)
{
GeoScene.Data.GSOFieldDefn fielddef = (GeoScene.Data.GSOFieldDefn)(f.GetFieldDefn(i));
//if (!en_cns.ContainsKey(fielddef.Name))
// continue;
// object fieldvalue = convertFieldValue(fielddef.Name, f.GetValue(fielddef.Name));
if (fielddef == null)
{
continue;
}
feature.SetValue(fielddef.Name, f.GetValue(fielddef.Name));
}
featdataset.AddFeature(feature);
}
featdataset.Save();
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private bool valiValvedata()
{
if (comboBoxShpLayerList.SelectedItem == null)
{
MessageBox.Show("请选择一个shp图层！");
return(false);
}
GSOLayer layer = globeControl1.Globe.Layers.GetLayerByCaption(comboBoxShpLayerList.SelectedItem.ToString().Trim());
if (layer == null)
{
MessageBox.Show("选择的图层为空！");
return(false);
}
if (layer != null)
{
GSOFeatureDataset featDataSet = layer.Dataset as GSOFeatureDataset;
if (featDataSet.FieldCount <= 0)
{
MessageBox.Show("图层中字段数必须大于0");
return(false);
}
GSOFieldAttr fieldID = featDataSet.GetField("编号");
if (fieldID == null)
{
MessageBox.Show("编号 字段不存在", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
GSOFieldAttr fieldModelPath = featDataSet.GetField("模型路径");
if (fieldModelPath == null)
{
MessageBox.Show("模型路径 字段不存在", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
GSOFieldAttr fieldZ = featDataSet.GetField("Z坐标");
if (fieldZ.Type != EnumFieldType.Double && fieldZ.Type != EnumFieldType.Float && fieldZ.Type != EnumFieldType.INT16 && fieldZ.Type != EnumFieldType.INT32)
{
MessageBox.Show("Z坐标 必须为数值类型", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
for (int i = 0; i < layer.GetAllFeatures().Length; i++)
{
GSOFeature f = layer.GetAt(i);
for (int j = 0; j < featDataSet.FieldCount; j++)
{
GSOFieldAttr field = featDataSet.GetField(j);
if (field.Type == EnumFieldType.Text)
{
if (f.GetValue(j).ToString().Trim().Length > 5000)
{
MessageBox.Show("ID为" + f.ID + "的要素的字段" + field.Name + "的长度大于5000 ！\r\n", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
}
}
}
return(true);
}
else
{
return(false);
}
}
private void SetFields(GSOFeature oldfeat, GSOFeature newFeature)
{
for (int i = 0; i < oldfeat.GetFieldCount(); i++)
{
GeoScene.Data.GSOFieldDefn fielddef = (GeoScene.Data.GSOFieldDefn)(oldfeat.GetFieldDefn(i));
object fieldvalue = oldfeat.GetValue(fielddef.Name);
if (fieldvalue == null)
continue;
newFeature.SetValue(fielddef.Name, fieldvalue);
}
}
private void valiGongJingdata(GSOLayer layer)
{
txtMessage.Text = "";
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 (gj_types.ContainsKey(fieldName))
{
string fieldType = gj_types[fieldName].ToString().ToUpper();
switch (featDataSet.GetField(i).Type)
{
case EnumFieldType.Text:
if (fieldType != "string".ToUpper())
{
txtMessage.Text += "" + fieldName + "数据类型不正确\r\n";
}
listFieldType_Text.Add(fieldName);
break;
case EnumFieldType.INT32:
if (fieldType != "int".ToUpper() && fieldType != "double".ToUpper())
{
txtMessage.Text += "" + fieldName + "数据类型不正确\r\n";
}
break;
case EnumFieldType.INT16:
if (fieldType != "int".ToUpper() && fieldType != "double".ToUpper())
{
txtMessage.Text += "" + fieldName + "数据类型不正确\r\n";
}
break;
case EnumFieldType.Double:
if (fieldType != "double".ToUpper())
{
txtMessage.Text += "" + fieldName + "数据类型不正确\r\n";
}
break;
case EnumFieldType.Date:
if (fieldType != "date".ToUpper())
{
txtMessage.Text += "" + fieldName + "数据类型不正确\r\n";
}
break;
}
}
else
{
txtMessage.Text += "警告：配置文件中不包含\"" + fieldName + "\"字段\r\n";
}
//if (fieldName == "井深")
//{
// if (featDataSet.GetField(i).Type != EnumFieldType.Double)
// {
// txtMessage.Text += "井深字段数据类型不正确！\r\n";
// }
//}
//if (fieldName == "管线点编码")
//{
// if (featDataSet.GetField(i).Type != EnumFieldType.Double)
// {
// txtMessage.Text += "管线点编码字段数据类型不正确！\r\n";
// }
//}
}
if (!lstField.Contains("编号"))
{
txtMessage.Text += "编号字段不存在！\r\n";
}
if (!lstField.Contains("管线点编码"))
{
txtMessage.Text += "管线点编码字段不存在！\r\n";
}
if (!lstField.Contains("井深"))
{
txtMessage.Text += "井深字段不存在！\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.Text += "\"井深\"字段必须为数值类型 \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 (gj_types.ContainsKey(fieldName))
{
if (f.GetValue(fieldName).ToString().Trim().Length > 8000)
{
txtMessage.Text += "名称为" + f.Name + "的要素的字段" + fieldName + "的长度大于8000 ！\r\n";
}
}
}
}
}
}
private void btnCreateModel_Click(object sender, EventArgs e)
{
if (comboBoxDataSourceList.SelectedItem == null)
{
MessageBox.Show("请选择一个目标数据源！", "提示");
return;
}
GSODataSource ds = Utility.getDataSourceByFullName(globeControl1, comboBoxDataSourceList.SelectedItem.ToString().Trim());
if (ds == null)
{
MessageBox.Show("选择的目标数据源为空！", "提示");
return;
}
//判断是数字或者存在特殊字符串
string SuiD = textBoxNewLayerName.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(textBoxNewLayerName.Text))
{
MessageBox.Show("管线图层名称无效！", "提示");
return;
}
GSODataset dataset = ds.GetDatasetByName(textBoxNewLayerName.Text.Trim());
GSOFeatureDataset newFeatureDataset;
if (dataset != null)
{
DialogResult result = MessageBox.Show("管线图层名称在数据库中已存在！是否向该表追加", "提示", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
newFeatureDataset = dataset as GSOFeatureDataset;
}
else
{
return;
}
}
else
{
newFeatureDataset = CreateDBFeatureDataset(textBoxNewLayerName.Text.Trim());
}
if (newFeatureDataset == null)
{
return;
}
GSOLayer sourceLayer = globeControl1.Globe.Layers.GetLayerByCaption(comboBoxShpLayerList.SelectedItem.ToString().Trim());
newFeatureDataset.Open();
GSOFeatures features = sourceLayer.GetAllFeatures(true);
string message = "";
for (int j = 0; j < features.Length; j++)
{
GSOFeature f = features[j];
GSOGeoPolyline3D lineeee = f.Geometry as GSOGeoPolyline3D;
if (lineeee == null)
{
message += "ID为" + f.ID + "的对象不是一个线对象\n";
continue;
}
double length = lineeee.GetSpaceLength(true, 6378137);
if (length == 0)
{
message += "ID为" + f.ID + "的管线长度为0\n";
continue;
}
GSOFeature newFeature = newFeatureDataset.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.INT32 || field.Type == EnumFieldType.Double)
{
radius = f.GetFieldAsDouble(cmbRadius.SelectedItem.ToString()) / 2000; // 探测数据的单位一般是毫米，需换算为米； 管径一般是 直径， 这个需要半径， 所有除以2000
}
string eventid = f.GetFieldAsString(cmbID.SelectedItem.ToString());
if (radius == 0)
{
message += "ID为" + f.ID + "的管线半径为0\n";
continue;
}
style.Radius = radius;
style.Slice = int.Parse(txtSlice.Text);
style.CornerSliceAngle = Convert.ToDouble(textBoxCornerSliceAngle.Text);
f.Geometry.AltitudeMode = EnumAltitudeMode.RelativeToGround;
GSOGeoPolyline3D line = f.Geometry as GSOGeoPolyline3D;
if (line == null)
{
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 * 2;
deep2 = deep2 + radius * 2;
}
else if (cmbReference.SelectedIndex == 1) //管顶
{
deep1 = deep1 - radius * 2;
deep2 = deep2 - radius * 2;
}
for (int n = 0; n < line[0].Count; n++)
{
GSOPoint3d pt3d = line[0][n];
int pointcount = line[0].Count;
double fenmu = Math.Sqrt(Math.Pow(line[0][pointcount - 1].Y - line[0][0].Y, 2) + Math.Pow(line[0][pointcount - 1].X - line[0][0].X, 2));
if (fenmu == 0)
{
pt3d.Z = deep1;
}
else
{
double radio = Math.Sqrt(Math.Pow(pt3d.Y - line[0][0].Y, 2) + Math.Pow(pt3d.X - line[0][0].X, 2)) / fenmu;
pt3d.Z = deep1 + (deep2 - deep1) * radio;
}
if (double.IsInfinity(pt3d.Z))
{
pt3d.Z = deep2;
}
line[0][n] = pt3d;
}
newFeature.Geometry = line; // f.Geometry;
newFeature.Geometry.Style = style;
newFeature.Name = eventid;
for (int i = 0; i < f.GetFieldCount(); i++)
{
GeoScene.Data.GSOFieldDefn fielddef = (GeoScene.Data.GSOFieldDefn)(f.GetFieldDefn(i));
if (fielddef == null)
{
continue;
}
if (!en_cns.Contains(fielddef.Name))
{
continue;
}
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);
}
newFeatureDataset.AddFeature(newFeature);
}
newFeatureDataset.Save();
newFeatureDataset.Caption = newFeatureDataset.Name;
globeControl1.Globe.Layers.Add(newFeatureDataset);
globeControl1.Refresh();
string strMessage = "shp文件中共" + features.Length + "个对象，实际入库" + newFeatureDataset.GetAllFeatures().Length + "个对象！\n";
if (message == "")
{
MessageBox.Show(strMessage, "提示");
}
else
{
FrmMessageShow frm = new FrmMessageShow(strMessage + message);
frm.ShowDialog();
}
this.Close();
}
}
catch (Exception ex)
{
Log.PublishTxt(ex);
MessageBox.Show(ex.Message);
}
}
private void valiPipedata(GSOLayer layer)
{
txtMessage.Text = "";
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.Text += "" + fieldName + "数据类型不正确\r\n";
}
listFieldType_Text.Add(fieldName);
break;
case EnumFieldType.INT32:
if (fieldType != "int".ToUpper() && fieldType != "double".ToUpper())
{
txtMessage.Text += "" + fieldName + "数据类型不正确\r\n";
}
break;
case EnumFieldType.INT16:
if (fieldType != "int".ToUpper() && fieldType != "double".ToUpper())
{
txtMessage.Text += "" + fieldName + "数据类型不正确\r\n";
}
break;
case EnumFieldType.Double:
if (fieldType != "double".ToUpper())
{
txtMessage.Text += "" + fieldName + "数据类型不正确\r\n";
}
break;
case EnumFieldType.Date:
if (fieldType != "date".ToUpper())
{
txtMessage.Text += "" + fieldName + "数据类型不正确\r\n";
}
break;
}
}
else
{
txtMessage.Text += "警告：配置文件中不包含\"" + fieldName + "\"字段\r\n";
}
}
if (!lstField.Contains("Deep1"))
{
txtMessage.Text += "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.Text += "Deep1字段必须为数值类型\r\n";
}
}
if (!lstField.Contains("Deep2"))
{
txtMessage.Text += "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.Text += "Deep2字段必须为数值类型\r\n";
}
}
if (!lstField.Contains("Diameter"))
{
txtMessage.Text += "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.Text += "Diameter字段必须为数值类型\r\n";
}
}
if (!lstField.Contains("Handle"))
{
txtMessage.Text += "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.Text += "ID为" + f.ID + "的要素的字段" + fieldName + "的长度大于8000 ！\r\n";
}
}
}
if (f.GetFieldAsFloat("Diameter") <= 0)
{
txtMessage.Text += "ID为" + f.ID + "\"Diameter\"字段中的值必须大于0 \r\n";
}
if (!lstHandle.Contains(f.GetFieldAsString("Handle")))
{
lstHandle.Add(f.GetFieldAsString("Handle"));
}
else
{
txtMessage.Text += "ID为" + f.ID + "的\"Handle\"字段中的值重复\r\n";
}
}
}
}
private void button3_Click(object sender, EventArgs e)
{
if (comboBoxDataSourceList.SelectedItem == null)
{
MessageBox.Show("请选择一个目标数据源！", "提示");
return;
}
GSODataSource ds = Utility.getDataSourceByFullName(globeControl1, comboBoxDataSourceList.SelectedItem.ToString().Trim());
if (ds == null)
{
MessageBox.Show("选择的目标数据源为空！", "提示");
return;
}
if (comboBoxShpLayerList.SelectedIndex < 0)
{
return;
}
try
{
if (valiValvedata())
{
GSOFeatureDataset featdataset = CreateDBFeatureDataset(textBoxNewLayerName.Text);
if (featdataset == null)
{
return;
}
featdataset.Open();
GSOLayer shpLayer = globeControl1.Globe.Layers[comboBoxShpLayerList.SelectedIndex];
if (shpLayer == null)
{
return;
}
GSOFeatures features = shpLayer.GetAllFeatures(true);
string message = "";
for (int j = 0; j < features.Length; j++)
{
GSOFeature f = features[j];
GSOGeoPoint3D shpPoint = f.Geometry as GSOGeoPoint3D;
double z = f.GetFieldAsDouble(combZ.SelectedItem.ToString());
double deep = f.GetFieldAsDouble(combZ.SelectedItem.ToString());
GSOFeature feature = featdataset.CreateFeature();
GSOGeoModel model = new GSOGeoModel();
GSOPoint3d pt = new GSOPoint3d();
pt.X = shpPoint.X;
pt.Y = shpPoint.Y;
pt.Z = z;
model.Position = pt;
model.AltitudeMode = EnumAltitudeMode.RelativeToGround;
string modelPath = f.GetFieldAsString(combPath.SelectedItem.ToString());
model.FilePath = Application.StartupPath + "\\" + modelPath;
model.Name = f.GetValue(combModelName.SelectedItem.ToString()).ToString();
feature.Name = f.GetValue(combModelName.SelectedItem.ToString()).ToString();
feature.Geometry = model;
for (int i = 0; i < f.GetFieldCount(); i++)
{
GeoScene.Data.GSOFieldDefn fielddef = (GeoScene.Data.GSOFieldDefn)(f.GetFieldDefn(i));
if (fielddef == null)
{
continue;
}
if (!fm_cns.ContainsKey(fielddef.Name))
{
continue;
}
object obu = f.GetValue(fielddef.Name);
if (obu != null)
{
string fieldName = fm_cns.ContainsKey(fielddef.Name) == true ? fm_cns[fielddef.Name].ToString() : fielddef.Name;
feature.SetValue(fieldName, obu);
}
}
featdataset.AddFeature(feature);
}
featdataset.Save();
string strMessage = "shp文件中共" + features.Length + "个对象，实际入库" + featdataset.GetAllFeatures().Length + "个对象！\r\n";
if (message == "")
{
MessageBox.Show(strMessage, "提示");
}
else
{
FrmMessageShow frm = new FrmMessageShow(strMessage + message);
frm.ShowDialog();
}
this.Close();
}
}
catch (Exception ex)
{
Log.PublishTxt(ex);
MessageBox.Show(ex.Message);
}
}