private void cbox_Layers_SelectedIndexChanged(object sender, EventArgs e) { if (cbox_Layers.SelectedItem == null) { return; } GSOLayer m_layer = globeControl1.Globe.Layers.GetLayerByCaption(cbox_Layers.SelectedItem.ToString().Trim());//获取当前选择的layer图层 if (m_layer == null) { return; } listBox_Field.Items.Clear(); GSOFeatureLayer flayer = m_layer as GSOFeatureLayer; if (flayer == null) { return; } sourcefDataset = m_layer.Dataset as GSOFeatureDataset; if (sourcefDataset == null) { return; } sourcefDataset.Open(); for (int j = 0; j < sourcefDataset.FieldCount; j++) { GSOFieldAttr fieldef = sourcefDataset.GetField(j); listBox_Field.Items.Add(fieldef.Name); } //设置当前选择字段为第一个 listBox_Field.SelectedIndex = 0; //将描述信息修改 label3.Text = "SELECT * FROM " + m_layer.Caption + " WHERE:"; }
private GSOFeatureDataset CreateDBFeatureDataset(string name) { if (comboBoxShpLayerList.SelectedItem == null) { MessageBox.Show("请选择一个Shp图层!", "提示"); return(null); } GSOLayer layer = globeControl1.Globe.Layers.GetLayerByCaption(comboBoxShpLayerList.SelectedItem.ToString().Trim()); if (layer == null) { MessageBox.Show("Shp图层为空!", "提示"); return(null); } GSOFeatures features = layer.GetAllFeatures(); if (features.Length == 0) { MessageBox.Show("图层要素个数为0!", "提示"); return(null); } GSOFeatureDataset featureDataset = layer.Dataset as GSOFeatureDataset; if (featureDataset == null) { MessageBox.Show("Shp图层不是矢量图层!", "提示"); return(null); } if (comboBoxDataSourceList.SelectedItem == null) { MessageBox.Show("请选择一个目标数据源!", "提示"); return(null); } GSODataSource ds = Utility.getDataSourceByFullName(globeControl1, comboBoxDataSourceList.SelectedItem.ToString().Trim()); if (ds == null) { MessageBox.Show("选择的目标数据源为空!", "提示"); return(null); } GSOFeatureDataset newFeatureDataset = ds.CreateFeatureDataset(name); if (newFeatureDataset != null) { for (int i = 0; i < featureDataset.FieldCount; i++) { GeoScene.Data.GSOFieldAttr fielddef = featureDataset.GetField(i); GSOFieldAttr field = new GSOFieldAttr(); field.Name = fielddef.Name; field.Type = fielddef.Type; field.Width = fielddef.Width; field.Precision = fielddef.Precision; bool res = newFeatureDataset.AddField(field); } newFeatureDataset.Save(); } return(newFeatureDataset); }
private void buttonAddAttribute_Click(object sender, EventArgs e) { if (MessageBox.Show("确定要添加该属性字段?", "提示!", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { GSOFeatureLayer pFeatureLayer = geoLayer as GSOFeatureLayer; if (pFeatureLayer == null) { return; } GSOFeatures feats = pFeatureLayer.GetAllFeatures(); GSOFeatureDataset dateset = pFeatureLayer.Dataset as GSOFeatureDataset; GSOFieldAttr fieldattr = new GSOFieldAttr(); fieldattr.Name = textBoxAddAttributeName.Text; switch (comboBoxAddAttributeType.SelectedIndex) { case 0: fieldattr.Type = EnumFieldType.Text; fieldattr.Width = 2000; break; case 1: fieldattr.Type = EnumFieldType.Double; break; case 2: //fieldattr.Type = EnumFieldType.INT16; //fieldattr.Type = EnumFieldType.INT32; fieldattr.Type = EnumFieldType.INT64; break; case 3: fieldattr.Type = EnumFieldType.Date; break; } dateset.AddField(fieldattr); dateset.Save(); listBoxAttribute.Items.Add(fieldattr.Name); MessageBox.Show("添加属性字段成功!", "提示!"); if (m_globeControl != null) { m_globeControl.Refresh(); } } 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 buttonAddAttribute_Click(object sender, EventArgs e) { if (MessageBox.Show("确定要添加该属性字段?", "提示!", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { GSOFeatureLayer pFeatureLayer = geoLayer as GSOFeatureLayer; if (pFeatureLayer == null) return; GSOFeatures feats = pFeatureLayer.GetAllFeatures(); GSOFeatureDataset dateset = pFeatureLayer.Dataset as GSOFeatureDataset; GSOFieldAttr fieldattr=new GSOFieldAttr (); fieldattr.Name = textBoxAddAttributeName.Text; switch (comboBoxAddAttributeType.SelectedIndex) { case 0: fieldattr.Type = EnumFieldType.Text; fieldattr.Width = 2000; break; case 1: fieldattr.Type = EnumFieldType.Double; break; case 2: //fieldattr.Type = EnumFieldType.INT16; //fieldattr.Type = EnumFieldType.INT32; fieldattr.Type = EnumFieldType.INT64; break; case 3: fieldattr.Type = EnumFieldType.Date; break; } dateset.AddField(fieldattr); dateset.Save(); listBoxAttribute.Items.Add(fieldattr.Name); MessageBox.Show("添加属性字段成功!", "提示!"); if (m_globeControl != null) { m_globeControl.Refresh(); } } catch (System.Exception exp) { Log.PublishTxt(exp); } } }
private void listBoxAttribute_SelectedIndexChanged(object sender, EventArgs e) { if (listBoxAttribute.SelectedItem != null) { GSOFeatureLayer gsoFeatureLayer = geoLayer as GSOFeatureLayer; if (gsoFeatureLayer == null) { MessageBox.Show("该数据不是属性数据,属性值为空!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } GSOFeatureDataset flayer = gsoFeatureLayer.Dataset as GSOFeatureDataset; GSOFieldAttr field = flayer.GetField(listBoxAttribute.SelectedItem.ToString()); labelAttributeType.Text = "图层属性类型为:" + field.Type.ToString() + " 类型"; } }
private void Frm_EditorAttributes_Load(object sender, EventArgs e) { GSOFeatureLayer gsoFeatureLayer = geoLayer as GSOFeatureLayer; if (gsoFeatureLayer == null) { MessageBox.Show("该数据不是属性数据,属性值为空!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } GSOFeatureDataset flayer = gsoFeatureLayer.Dataset as GSOFeatureDataset; for (int i = 0; i < flayer.FieldCount; i++) { GSOFieldAttr field = flayer.GetField(i); listBoxAttribute.Items.Add(field.Name); //labelAttributeType.Text = "图层属性类型为:" + field.Type.ToString() + "类型"; } }
private void btn_GetValue_Click(object sender, EventArgs e) { if (connectParams == null) { return; } try { listBox_Value.Items.Clear(); for (int j = 0; j < sourcefDataset.FieldCount; j++) { GSOFieldAttr fieldef = sourcefDataset.GetField(j); if (listBox_Field.SelectedItem.ToString() == fieldef.Name && fieldef.Type == EnumFieldType.Text) { str1 = "'"; str2 = "'"; } } string sqltype = "select distinct " + listBox_Field.SelectedItem.ToString() + " from " + sourcefDataset.Name + " order by " + listBox_Field.SelectedItem.ToString() + ""; DataTable table = OledbHelper.QueryTable(sqltype, connectParams); for (int i = 0; i < table.Rows.Count; i++) { DataRow dr = table.Rows[i]; string colString1 = dr[0].ToString(); if (colString1 == null || colString1.Trim() == "") { continue; } string col = str1 + colString1 + str2; listBox_Value.Items.Add(col); } str1 = ""; str2 = ""; } catch (Exception ex) { Log.PublishTxt(ex); MessageBox.Show(ex.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 bool isSameType(GSOFeatureDataset sourceDataset, string fieldSourceName, GSOFeatureDataset targetDataset, string fieldTargetName) { if (sourceDataset == null || targetDataset == null) { return(false); } GSOFieldAttr sourceField = sourceDataset.GetField(fieldSourceName); GSOFieldAttr targetField = targetDataset.GetField(fieldTargetName); if (sourceField == null || targetField == null) { return(false); } if (sourceField.Type == targetField.Type) { return(true); } else { return(false); } }
private void cbox_Layers_SelectedIndexChanged(object sender, EventArgs e) { GSOLayer m_layer = globeControl1.Globe.Layers.GetLayerByCaption(cbox_Layers.SelectedItem.ToString().Trim());//获取当前选择的layer图层 if (m_layer == null || m_layer.Dataset == null || m_layer.Dataset.DataSource == null) { return; } connectParams = Utility.getConnectParamsByDatasourceName(globeControl1, m_layer.Dataset.DataSource.Name); if (connectParams == null) { return; } listBox_Field.Items.Clear(); GSOFeatureLayer flayer = m_layer as GSOFeatureLayer; sourcefDataset = m_layer.Dataset as GSOFeatureDataset; if (sourcefDataset != null) { sourcefDataset.Open(); for (int j = 0; j < sourcefDataset.FieldCount; j++) { GSOFieldAttr fieldef = sourcefDataset.GetField(j); listBox_Field.Items.Add(fieldef.Name); } //设置当前选择字段为第一个 if (listBox_Field.Items.Count > 0) { listBox_Field.SelectedIndex = 0; } //将描述信息修改 label3.Text = "SELECT * FROM " + sourcefDataset.Name + " WHERE:"; } }
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 bool valiPipeData() { if (comboBoxShpLayerList.SelectedItem == null) { MessageBox.Show("请选择一个shp图层!"); return(false); } GSOLayer sourceLayer = globeControl1.Globe.Layers.GetLayerByCaption(comboBoxShpLayerList.SelectedItem.ToString().Trim()); if (sourceLayer == null) { MessageBox.Show("选择的图层为空!"); return(false); } GSOFeatures features = sourceLayer.GetAllFeatures(true); GSOFeatureDataset featDataSet = sourceLayer.Dataset as GSOFeatureDataset; if (featDataSet == null) { MessageBox.Show("选择的图层不是矢量图层!"); return(false); } if (featDataSet.FieldCount <= 0) { MessageBox.Show("图层中字段数必须大于0"); return(false); } GSOFieldAttr fieldDeep1 = featDataSet.GetField("Deep1"); if (fieldDeep1 == null) { MessageBox.Show("Deep1字段不存在", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); } if (fieldDeep1.Type != EnumFieldType.Double && fieldDeep1.Type != EnumFieldType.Float && fieldDeep1.Type != EnumFieldType.INT16 && fieldDeep1.Type != EnumFieldType.INT32) { MessageBox.Show("Deep1必须为数值类型", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); } GSOFieldAttr fieldDeep2 = featDataSet.GetField("Deep2"); if (fieldDeep2 == null) { MessageBox.Show("Deep2字段不存在", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); } if (fieldDeep2.Type != EnumFieldType.Double && fieldDeep2.Type != EnumFieldType.Float && fieldDeep2.Type != EnumFieldType.INT16 && fieldDeep2.Type != EnumFieldType.INT32) { MessageBox.Show("Deep2必须为数值类型", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); } List <string> lst = new List <string>(); for (int j = 0; j < features.Length; j++) { if (!lst.Contains(features[j].GetFieldAsString("Handle"))) { lst.Add(features[j].GetFieldAsString("Handle")); } else { MessageBox.Show("Handle字段必须唯一!!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); } } return(true); }
private void buttonOK_Click(object sender, EventArgs e) { string fieldName = textBoxFieldName.Text.Trim(); if (fieldName == "") { MessageBox.Show("字段名不能为空!", "提示"); return; } int firstChar = 0; if (int.TryParse(fieldName.Substring(0, 1), out firstChar)) { MessageBox.Show("字段名不能以数字开头!", "提示"); return; } //if (isContainChinese(fieldName)) //{ // MessageBox.Show("字段名不能包含中文!", "提示"); // return; //} if (fieldName.Length > 10) { MessageBox.Show("字段名长度不能大于10!", "提示"); return; } EnumFieldType fieldType = EnumFieldType.None; int fieldWidth = 0; string type = comboBoxFieldType.Text.Trim(); if (type == "") { MessageBox.Show("字段类型不能为空!", "提示"); return; } else { switch (type) { case "Date": fieldType = EnumFieldType.Date; fieldWidth = 10; break; case "Double": fieldType = EnumFieldType.Double; fieldWidth = 8; break; case "INT32": fieldType = EnumFieldType.INT32; fieldWidth = 4; break; case "Text": fieldType = EnumFieldType.Text; fieldWidth = 8000; break; } } if (layer != null && layer.GetAllFeatures().Length > 0) { //GSOFieldDefn field = new GSOFieldDefn(); //field.Name = fieldName; //field.Type = fieldType; //field.Width = fieldWidth; //for (int i = 0; i < layer.GetAllFeatures().Length; i++) //{ // GSOFeature feature = layer.GetAt(i); // feature.AddField(field); //} //dataGridView1.Columns.Add(fieldName, fieldName); GSOFieldAttr field = new GSOFieldAttr(); field.Name = fieldName; field.Type = fieldType; field.Width = fieldWidth; GSOFeatureDataset dataset = layer.Dataset as GSOFeatureDataset; if (dataset != null) { dataset.AddField(field); dataGridView1.Columns.Add(fieldName, fieldName); } } this.Close(); }
//查询 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 buttonOK_Click(object sender, EventArgs e) { string fieldName = textBoxFieldName.Text.Trim(); if (fieldName == "") { MessageBox.Show("字段名不能为空!","提示"); return; } int firstChar = 0; if (int.TryParse(fieldName.Substring(0,1),out firstChar)) { MessageBox.Show("字段名不能以数字开头!", "提示"); return; } //if (isContainChinese(fieldName)) //{ // MessageBox.Show("字段名不能包含中文!", "提示"); // return; //} if (fieldName.Length > 10) { MessageBox.Show("字段名长度不能大于10!", "提示"); return; } EnumFieldType fieldType = EnumFieldType.None; int fieldWidth = 0; string type = comboBoxFieldType.Text.Trim(); if (type == "") { MessageBox.Show("字段类型不能为空!", "提示"); return; } else { switch (type) { case "Date": fieldType = EnumFieldType.Date; fieldWidth = 10; break; case "Double": fieldType = EnumFieldType.Double; fieldWidth = 8; break; case "INT32": fieldType = EnumFieldType.INT32; fieldWidth = 4; break; case "Text": fieldType = EnumFieldType.Text; fieldWidth = 8000; break; } } if (layer != null && layer.GetAllFeatures().Length > 0) { //GSOFieldDefn field = new GSOFieldDefn(); //field.Name = fieldName; //field.Type = fieldType; //field.Width = fieldWidth; //for (int i = 0; i < layer.GetAllFeatures().Length; i++) //{ // GSOFeature feature = layer.GetAt(i); // feature.AddField(field); //} //dataGridView1.Columns.Add(fieldName, fieldName); GSOFieldAttr field = new GSOFieldAttr(); field.Name = fieldName; field.Type = fieldType; field.Width = fieldWidth; GSOFeatureDataset dataset = layer.Dataset as GSOFeatureDataset; if (dataset != null) { dataset.AddField(field); dataGridView1.Columns.Add(fieldName, fieldName); } } this.Close(); }
//导入数据库 /* private void button3_Click(object sender, EventArgs e) * { * if (txtFolder.Text == "") * return; * * if (txtPath.Text == "") * return; * * * 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); * 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; * } * * //model.FilePath = txtFolder.Text + "\\" + files[index]; * //model.Position = new GSOPoint3d(result.X, result.Y, z); * * //model.Rotate(0, 0-rotateAngle*180/Math.PI + 90,0); //旋转的轴,yz 调换了, 有bug * * //model.Align = EnumEntityAlign.TopCenter; //接口已修复作用 * //model.AltitudeMode = EnumAltitudeMode.RelativeToGround; * * GSOGeoPoint3D pt = new GSOGeoPoint3D(result.X, result.Y, z); * * //model.FilePath = Path.GetDirectoryName(Application.ExecutablePath) + "/Resource/model/tank.3ds"; * feature.Geometry = pt; * * 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]); * * featdataset.AddFeature(feature); * * line = tr.ReadLine(); * } * featdataset.Save(); * this.Close(); * } */ private GSOFeatureDataset CreateDBFeatureDataset(string name) { //GSOFeatureDataset featDs = ds.CreateFeatureDataset(name); //GSOFieldAttr field = new GSOFieldAttr(); //field.Name = "编号"; //field.Type = EnumFieldType.Text; //field.Width = 30; //featDs.AddField(field); //field = new GSOFieldAttr(); //field.Name = "井深"; //field.Type = EnumFieldType.Double; //field.Width = 8; //featDs.AddField(field); //field = new GSOFieldAttr(); //field.Name = "图片编码"; //field.Type = EnumFieldType.Text; //field.Width = 150; //featDs.AddField(field); //field = new GSOFieldAttr(); //field.Name = "建设年代"; //field.Type = EnumFieldType.Text; //field.Width = 30; //featDs.AddField(field); //field = new GSOFieldAttr(); //field.Name = "建设单位"; //field.Type = EnumFieldType.Text; //field.Width = 60; //featDs.AddField(field); //field = new GSOFieldAttr(); //field.Name = "权属单位"; //field.Type = EnumFieldType.Text; //field.Width = 30; //featDs.AddField(field); //field = new GSOFieldAttr(); //field.Name = "备注"; //field.Type = EnumFieldType.Text; //field.Width = 30; //featDs.AddField(field); //field = new GSOFieldAttr(); //field.Name = "旋转角度"; //field.Type = EnumFieldType.Double; //field.Width = 8; //featDs.AddField(field); //field = new GSOFieldAttr(); //field.Name = "模型路径"; //field.Type = EnumFieldType.Text; //field.Width = 150; //featDs.AddField(field); GSOLayer layer = globeControl1.Globe.Layers[cmbLayer.SelectedIndex]; GSOFeatures features = layer.GetAllFeatures(); if (features.Length == 0) { MessageBox.Show("图层要素个数为0!", "提示"); return(null); } GSOFeatureDataset featDs = ds.CreateFeatureDataset(name); 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; GSOFieldAttr field = new GSOFieldAttr(); field.Name = fielddef.Name; //en_cns[fielddef.Name].ToString(); switch (fielddef.Type) { case EnumFieldType.Text: field.Type = EnumFieldType.Text; field.Width = 100; 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); //featDs.Save(); //return featDs; }
private void btnCreateModel_Click(object sender, EventArgs e) { if (comboBoxDataSourceList.SelectedItem == null) { MessageBox.Show("请选择要复制的数据的源!"); return; } if (commBoxModelLayerList.SelectedItem == null) { MessageBox.Show("请选择数据集模板!"); return; } if (comboBoxTargetDataSource.SelectedItem == null) { MessageBox.Show("请选择目标数据源!"); return; } string layerName = textBoxNewLayerName.Text.Trim(); if (layerName == "") { MessageBox.Show("请输入数据集名称!"); return; } int num = -1; bool bl = int.TryParse(layerName.Substring(0, 1), out num); if (!bl) { GSODataSource dsTarget = Utility.getDataSourceByFullName(globeControl1, comboBoxTargetDataSource.SelectedItem.ToString().Trim()); if (dsTarget != null) { GSODataset datasetInTargetDs = dsTarget.GetDatasetByName(layerName); if (datasetInTargetDs != null) { MessageBox.Show("目标数据源中该数据集名称已存在!", "提示"); return; } else { GSODataSource ds = Utility.getDataSourceByFullName(globeControl1, comboBoxDataSourceList.SelectedItem.ToString().Trim()); if (ds != null) { GSODataset datasetInDs = ds.GetDatasetByName(commBoxModelLayerList.SelectedItem.ToString()); GSOFeatureDataset featureDatasetInDs = datasetInDs as GSOFeatureDataset; if (featureDatasetInDs == null) { MessageBox.Show("选中的模板图层不符合要求!", "提示"); return; } featureDatasetInDs.Open(); GSOFeatureDataset featureDatasetTargetDs = dsTarget.CreateFeatureDataset(layerName); if (featureDatasetTargetDs == null) { MessageBox.Show("输入的新数据集名称不符合要求!", "提示"); return; } featureDatasetTargetDs.Open(); for (int i = 0; i < featureDatasetInDs.FieldCount; i++) { GSOFieldAttr fieldFromSource = featureDatasetInDs.GetField(i); GSOFieldAttr fieldInTargetDataSource = new GSOFieldAttr(); fieldInTargetDataSource.Name = fieldFromSource.Name; fieldInTargetDataSource.Type = fieldFromSource.Type; fieldInTargetDataSource.Width = fieldFromSource.Width; fieldInTargetDataSource.Precision = fieldFromSource.Precision; bool res = featureDatasetTargetDs.AddField(fieldInTargetDataSource); } featureDatasetTargetDs.Save(); featureDatasetTargetDs.Close(); featureDatasetInDs.Close(); MessageBox.Show("复制成功!", "提示"); this.Close(); } } } } else { MessageBox.Show("数据集名称不能以数字开头!", "提示"); } }
private void Set() { if (listBoxCopyLayerList.SelectedItems.Count <= 0) { MessageBox.Show("请选择要复制的数据集!", "提示"); return; } if (comboBoxTargetDataSource.SelectedItem == null) { MessageBox.Show("请选择目标数据源!", "提示"); return; } if (checkBoxCopyOne.Checked == true && textboxNewLayerName.Text.Trim() == "") { MessageBox.Show("请给要复制的数据集命名!", "提示"); return; } if (checkBoxCopyOne.Checked == true) { GSODataSource dsTarget = Utility.getDataSourceByFullName(globeControl1, comboBoxTargetDataSource.SelectedItem.ToString().Trim()); if (dsTarget != null) { GSODataset newDataset = dsTarget.GetDatasetByName(textboxNewLayerName.Text.Trim()); if (newDataset != null) { MessageBox.Show("输入的新的数据集的名称已存在目标数据源中!", "提示"); return; } GSOFeatureDataset newFeatureDataset = dsTarget.CreateFeatureDataset(textboxNewLayerName.Text.Trim()); if (newFeatureDataset == null) { MessageBox.Show("输入的新数据集的名称不符合要求!", "提示"); return; } GSODataSource ds = Utility.getDataSourceByFullName(globeControl1, comboBoxDataSourceList.SelectedItem.ToString().Trim()); if (ds != null) { GSODataset dataset = ds.GetDatasetByName(listBoxCopyLayerList.SelectedItem.ToString().Trim()); GSOFeatureDataset featureDataset = dataset as GSOFeatureDataset; if (featureDataset != null) { try { featureDataset.Open(); } catch (Exception ex) { MessageBox.Show(ex.Message, "提示"); if (featureDataset.IsOpened == true) { featureDataset.Close(); } return; } //向新数据集写入字段 for (int i = 0; i < featureDataset.FieldCount; i++) { GSOFieldAttr fieldFromDs = featureDataset.GetField(i); newFeatureDataset.AddField(fieldFromDs); } //向新的要素集写入数据 for (int i = 0; i < featureDataset.GetAllFeatures().Length; i++) { GSOFeature featureInDs = featureDataset.GetFeatureAt(i); GSOFeature featureInTargetDs = featureInDs.Clone(); featureInDs.Dispose(); newFeatureDataset.AddFeature(featureInTargetDs); } newFeatureDataset.Save(); featureDataset.Close(); MessageBox.Show("复制成功!", "提示"); } } } } else if (checkBoxCopyMult.Checked == true) { GSODataSource dsTarget = Utility.getDataSourceByFullName(globeControl1, comboBoxTargetDataSource.SelectedItem.ToString().Trim()); if (dsTarget != null) { string datasetNames = ""; for (int i = 0; i < listBoxCopyLayerList.SelectedItems.Count; i++) { GSODataset datasetInTargetDs = dsTarget.GetDatasetByName(listBoxCopyLayerList.SelectedItems[i].ToString().Trim()); if (datasetInTargetDs != null) { datasetNames += "\"" + listBoxCopyLayerList.SelectedItems[i].ToString().Trim() + "\" "; } } if (datasetNames != "") { MessageBox.Show("数据集名称" + datasetNames + "在目标数据源中已存在", "提示"); return; } GSODataSource ds = Utility.getDataSourceByFullName(globeControl1, comboBoxDataSourceList.SelectedItem.ToString().Trim()); if (ds != null) { progressBar1.Visible = true; progressBar1.Maximum = listBoxCopyLayerList.SelectedItems.Count - 1; progressBar1.Minimum = 0; for (int j = 0; j < listBoxCopyLayerList.SelectedItems.Count; j++) { //获取要复制的要素集 GSODataset datasetInDs = ds.GetDatasetByName(listBoxCopyLayerList.SelectedItems[j].ToString().Trim()); GSOFeatureDataset featureDatasetInDs = datasetInDs as GSOFeatureDataset; if (featureDatasetInDs == null) { continue; } featureDatasetInDs.Open(); //创建新的数据库要素集 GSOFeatureDataset featureDatasetInTargetDs = dsTarget.CreateFeatureDataset(listBoxCopyLayerList.SelectedItems[j].ToString().Trim()); if (featureDatasetInTargetDs == null) { continue; } featureDatasetInTargetDs.Open(); for (int i = 0; i < featureDatasetInDs.FieldCount; i++) { GSOFieldAttr fieldInDs = featureDatasetInDs.GetField(i); featureDatasetInTargetDs.AddField(fieldInDs); } //(2)向新的要素集写入数据 for (int i = 0; i < featureDatasetInDs.GetAllFeatures().Length; i++) { GSOFeature featureInDs = featureDatasetInDs.GetFeatureAt(i); GSOFeature featureInTargetDs = featureInDs.Clone(); featureInDs.Dispose(); featureDatasetInTargetDs.AddFeature(featureInTargetDs); } featureDatasetInTargetDs.Save(); featureDatasetInTargetDs.Close(); featureDatasetInDs.Close(); progressBar1.Value = j; } progressBar1.Visible = false; MessageBox.Show("数据复制成功!", "提示"); } } } }
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 button3_Click(object sender, EventArgs e) * { * if (txtFolder.Text == "") * return; * * if (txtPath.Text == "") * return; * * * 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); * 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; * } * * //model.FilePath = txtFolder.Text + "\\" + files[index]; * //model.Position = new GSOPoint3d(result.X, result.Y, z); * * //model.Rotate(0, 0-rotateAngle*180/Math.PI + 90,0); //旋转的轴,yz 调换了, 有bug * * //model.Align = EnumEntityAlign.TopCenter; //接口已修复作用 * //model.AltitudeMode = EnumAltitudeMode.RelativeToGround; * * GSOGeoPoint3D pt = new GSOGeoPoint3D(result.X, result.Y, z); * * //model.FilePath = Path.GetDirectoryName(Application.ExecutablePath) + "/Resource/model/tank.3ds"; * feature.Geometry = pt; * * 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]); * * featdataset.AddFeature(feature); * * line = tr.ReadLine(); * } * featdataset.Save(); * this.Close(); * } */ private GSOFeatureDataset CreateDBFeatureDataset(string name) { //GSOFeatureDataset featDs = ds.CreateFeatureDataset(name); //GSOFieldAttr field = new GSOFieldAttr(); //ICollection ic = en_cns.Keys; //IDictionaryEnumerator ie = en_cns.GetEnumerator(); //while (ie.MoveNext()) //{ // object en_name = ie.Key; // object ch_name = ie.Value; // object field_type = fields_types[en_name]; // field.Name = ch_name.ToString(); // switch (field_type.ToString()) // { // case "string": // field.Type = EnumFieldType.Text; // field.Width = 100; // break; // case "int": // field.Type = EnumFieldType.INT32; // field.Width = 4; // break; // case "double": // field.Type = EnumFieldType.Double; // field.Width = 8; // break; // case "date": // field.Type = EnumFieldType.Date; // field.Width = 10; // break; // } // bool res = featDs.AddField(field); //} //featDs.Save(); //return featDs; GSOLayer layer = globeControl1.Globe.Layers[cmbLayer.SelectedIndex]; GSOFeatures features = layer.GetAllFeatures(); if (features.Length == 0) { MessageBox.Show("图层要素个数为0!", "提示"); return(null); } GSOFeatureDataset featDs = ds.CreateFeatureDataset(name); 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; } GSOFieldAttr field = new GSOFieldAttr(); field.Name = en_cns[fielddef.Name].ToString(); switch (fields_types[fielddef.Name].ToString()) { case "string": field.Type = EnumFieldType.Text; field.Width = 8000; break; case "int": field.Type = EnumFieldType.INT32; field.Width = 4; break; case "double": field.Type = EnumFieldType.Double; field.Width = 8; break; case "date": field.Type = EnumFieldType.Date; field.Width = 10; break; } bool res = featDs.AddField(field); } featDs.Save(); return(featDs); }
private void btn_Union_Click(object sender, EventArgs e) { if (comboBoxTargetDataSource.SelectedItem == null) { MessageBox.Show("请选择目标数据源!", "提示"); return; } string newLayerName = textBoxUnionLayerName.Text.Trim(); if (newLayerName == "") { MessageBox.Show("请输入目标数据集名称!", "提示"); return; } if (comboBoxDataSourceList1.SelectedItem == null) { MessageBox.Show("请选择要合并的数据源1!", "提示"); return; } if (comboBoxUnionLayerList1.SelectedItem == null) { MessageBox.Show("请选择要合并的要素集1!", "提示"); return; } if (comboBoxDataSourceList2.SelectedItem == null) { MessageBox.Show("请选择要合并的数据源2!", "提示"); return; } if (comboBoxUnionLayerList2.SelectedItem == null) { MessageBox.Show("请选择要合并的要素集2!", "提示"); return; } GSODataSource dsTarget = Utility.getDataSourceByFullName(globeControl1, comboBoxTargetDataSource.SelectedItem.ToString().Trim()); if (dsTarget != null) { GSODataset dataset = dsTarget.GetDatasetByName(newLayerName); if (dataset != null) { MessageBox.Show("目标数据集名称已存在目标数据源中!", "提示"); return; } GSOFeatureDataset featureDatasetInTargetDs = dsTarget.CreateFeatureDataset(newLayerName); if (featureDatasetInTargetDs == null) { MessageBox.Show("目标数据集名称不符合要求!", "提示"); return; } GSODataSource dsUnion1 = Utility.getDataSourceByFullName(globeControl1, comboBoxDataSourceList1.SelectedItem.ToString().Trim()); GSODataSource dsUnion2 = Utility.getDataSourceByFullName(globeControl1, comboBoxDataSourceList2.SelectedItem.ToString().Trim()); if (dsUnion1 != null && dsUnion2 != null) { GSOFeatureDataset datasetInUnionDs1 = dsUnion1.GetDatasetByName(comboBoxUnionLayerList1.SelectedItem.ToString().Trim()) as GSOFeatureDataset; GSOFeatureDataset datasetInUnionDs2 = dsUnion1.GetDatasetByName(comboBoxUnionLayerList2.SelectedItem.ToString().Trim()) as GSOFeatureDataset; if (datasetInUnionDs1 != null && datasetInUnionDs2 != null) { //判断要合并的数据集结构是否相同 datasetInUnionDs1.Open(); datasetInUnionDs2.Open(); if (datasetInUnionDs1.FieldCount != datasetInUnionDs2.FieldCount) { MessageBox.Show("要合并的数据集结构不相同,无法合并!", "错误"); return; } for (int i = 0; i < datasetInUnionDs1.FieldCount; i++) { if (datasetInUnionDs1.GetField(i).Equals(datasetInUnionDs2.GetField(i)) == false) { MessageBox.Show("要合并的数据集结构不相同,无法合并!", "错误"); return; } } featureDatasetInTargetDs.Open(); for (int i = 0; i < datasetInUnionDs1.FieldCount; i++) { GSOFieldAttr fieldInUnionDs = datasetInUnionDs1.GetField(i); featureDatasetInTargetDs.AddField(fieldInUnionDs); } //向新的数据集写入数据 for (int i = 0; i < datasetInUnionDs1.GetAllFeatures().Length; i++) //循环添加第一个要素集的所有feature到新数据集中 { GSOFeature featureInUnionDs1 = datasetInUnionDs1.GetFeatureAt(i); GSOFeature featureInTargetDs = featureInUnionDs1.Clone(); featureDatasetInTargetDs.AddFeature(featureInTargetDs); } for (int i = 0; i < datasetInUnionDs2.GetAllFeatures().Length; i++) //循环添加第一个要素集的所有feature到新数据集中 { GSOFeature featureInUnionDs2 = datasetInUnionDs2.GetFeatureAt(i); GSOFeature featureInTargetDs = featureInUnionDs2.Clone(); featureDatasetInTargetDs.AddFeature(featureInTargetDs); } featureDatasetInTargetDs.Save(); featureDatasetInTargetDs.Close(); datasetInUnionDs1.Close(); datasetInUnionDs2.Close(); MessageBox.Show("数据集合并成功!", "提示"); this.Close(); } } } }
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 button3_Click(object sender, EventArgs e) { if (txtFolder.Text == "") return; if (txtPath.Text == "") return; 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); 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; } //model.FilePath = txtFolder.Text + "\\" + files[index]; //model.Position = new GSOPoint3d(result.X, result.Y, z); //model.Rotate(0, 0-rotateAngle*180/Math.PI + 90,0); //旋转的轴,yz 调换了, 有bug //model.Align = EnumEntityAlign.TopCenter; //接口已修复作用 //model.AltitudeMode = EnumAltitudeMode.RelativeToGround; GSOGeoPoint3D pt = new GSOGeoPoint3D(result.X, result.Y, z); //model.FilePath = Path.GetDirectoryName(Application.ExecutablePath) + "/Resource/model/tank.3ds"; feature.Geometry = pt; 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]); featdataset.AddFeature(feature); line = tr.ReadLine(); } featdataset.Save(); this.Close(); } */ private GSOFeatureDataset CreateDBFeatureDataset(string name) { //GSOFeatureDataset featDs = ds.CreateFeatureDataset(name); //GSOFieldAttr field = new GSOFieldAttr(); //field.Name = "编号"; //field.Type = EnumFieldType.Text; //field.Width = 30; //featDs.AddField(field); //field = new GSOFieldAttr(); //field.Name = "井深"; //field.Type = EnumFieldType.Double; //field.Width = 8; //featDs.AddField(field); //field = new GSOFieldAttr(); //field.Name = "图片编码"; //field.Type = EnumFieldType.Text; //field.Width = 150; //featDs.AddField(field); //field = new GSOFieldAttr(); //field.Name = "建设年代"; //field.Type = EnumFieldType.Text; //field.Width = 30; //featDs.AddField(field); //field = new GSOFieldAttr(); //field.Name = "建设单位"; //field.Type = EnumFieldType.Text; //field.Width = 60; //featDs.AddField(field); //field = new GSOFieldAttr(); //field.Name = "权属单位"; //field.Type = EnumFieldType.Text; //field.Width = 30; //featDs.AddField(field); //field = new GSOFieldAttr(); //field.Name = "备注"; //field.Type = EnumFieldType.Text; //field.Width = 30; //featDs.AddField(field); //field = new GSOFieldAttr(); //field.Name = "旋转角度"; //field.Type = EnumFieldType.Double; //field.Width = 8; //featDs.AddField(field); //field = new GSOFieldAttr(); //field.Name = "模型路径"; //field.Type = EnumFieldType.Text; //field.Width = 150; //featDs.AddField(field); GSOLayer layer = globeControl1.Globe.Layers[cmbLayer.SelectedIndex]; GSOFeatures features = layer.GetAllFeatures(); if (features.Length == 0) { MessageBox.Show("图层要素个数为0!", "提示"); return null; } GSOFeatureDataset featDs = ds.CreateFeatureDataset(name); 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; GSOFieldAttr field = new GSOFieldAttr(); field.Name = fielddef.Name; //en_cns[fielddef.Name].ToString(); switch (fielddef.Type) { case EnumFieldType.Text: field.Type = EnumFieldType.Text; field.Width = 100; 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; //featDs.Save(); //return featDs; }
//导入数据库 /* private void button3_Click(object sender, EventArgs e) { if (txtFolder.Text == "") return; if (txtPath.Text == "") return; 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); 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; } //model.FilePath = txtFolder.Text + "\\" + files[index]; //model.Position = new GSOPoint3d(result.X, result.Y, z); //model.Rotate(0, 0-rotateAngle*180/Math.PI + 90,0); //旋转的轴,yz 调换了, 有bug //model.Align = EnumEntityAlign.TopCenter; //接口已修复作用 //model.AltitudeMode = EnumAltitudeMode.RelativeToGround; GSOGeoPoint3D pt = new GSOGeoPoint3D(result.X, result.Y, z); //model.FilePath = Path.GetDirectoryName(Application.ExecutablePath) + "/Resource/model/tank.3ds"; feature.Geometry = pt; 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]); featdataset.AddFeature(feature); line = tr.ReadLine(); } featdataset.Save(); this.Close(); } */ private GSOFeatureDataset CreateDBFeatureDataset(string name) { //GSOFeatureDataset featDs = ds.CreateFeatureDataset(name); //GSOFieldAttr field = new GSOFieldAttr(); //ICollection ic = en_cns.Keys; //IDictionaryEnumerator ie = en_cns.GetEnumerator(); //while (ie.MoveNext()) //{ // object en_name = ie.Key; // object ch_name = ie.Value; // object field_type = fields_types[en_name]; // field.Name = ch_name.ToString(); // switch (field_type.ToString()) // { // case "string": // field.Type = EnumFieldType.Text; // field.Width = 100; // break; // case "int": // field.Type = EnumFieldType.INT32; // field.Width = 4; // break; // case "double": // field.Type = EnumFieldType.Double; // field.Width = 8; // break; // case "date": // field.Type = EnumFieldType.Date; // field.Width = 10; // break; // } // bool res = featDs.AddField(field); //} //featDs.Save(); //return featDs; GSOLayer layer = globeControl1.Globe.Layers[cmbLayer.SelectedIndex]; GSOFeatures features = layer.GetAllFeatures(); if (features.Length == 0) { MessageBox.Show("图层要素个数为0!", "提示"); return null; } GSOFeatureDataset featDs = ds.CreateFeatureDataset(name); 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; GSOFieldAttr field = new GSOFieldAttr(); field.Name = en_cns[fielddef.Name].ToString(); switch (fields_types[fielddef.Name].ToString()) { case "string": field.Type = EnumFieldType.Text; field.Width = 8000; break; case "int": field.Type = EnumFieldType.INT32; field.Width = 4; break; case "double": field.Type = EnumFieldType.Double; field.Width = 8; break; case "date": field.Type = EnumFieldType.Date; field.Width = 10; break; } bool res = featDs.AddField(field); } featDs.Save(); return featDs; }
private GSOFeatureDataset CreateDBFeatureDataset(string name) { if (comboBoxShpLayerList.SelectedItem == null) { MessageBox.Show("请选择一个Shp图层!", "提示"); return null; } GSOLayer layer = globeControl1.Globe.Layers.GetLayerByCaption(comboBoxShpLayerList.SelectedItem.ToString().Trim()); if (layer == null) { MessageBox.Show("Shp图层为空!", "提示"); return null; } GSOFeatures features = layer.GetAllFeatures(); if (features.Length == 0) { MessageBox.Show("图层要素个数为0!", "提示"); return null; } GSOFeatureDataset featureDataset = layer.Dataset as GSOFeatureDataset; if (featureDataset == null) { MessageBox.Show("Shp图层不是矢量图层!", "提示"); return null; } if (comboBoxDataSourceList.SelectedItem == null) { MessageBox.Show("请选择一个目标数据源!", "提示"); return null; } GSODataSource ds = Utility.getDataSourceByFullName(globeControl1, comboBoxDataSourceList.SelectedItem.ToString().Trim()); if (ds == null) { MessageBox.Show("选择的目标数据源为空!", "提示"); return null; } GSOFeatureDataset newFeatureDataset = ds.CreateFeatureDataset(name); if (newFeatureDataset == null) { MessageBox.Show("输入的图层名称不符合要求!", "提示"); return null; } for (int i = 0; i < featureDataset.FieldCount; i++) { GeoScene.Data.GSOFieldAttr fielddef = featureDataset.GetField(i); if (!fm_cns.ContainsKey(fielddef.Name)) continue; GSOFieldAttr field = new GSOFieldAttr(); field.Name = fm_cns.ContainsKey(fielddef.Name) == true ? fm_cns[fielddef.Name].ToString() : fielddef.Name; field.Type = fielddef.Type; field.Width = fielddef.Width; field.Precision = fielddef.Precision; bool res = newFeatureDataset.AddField(field); } newFeatureDataset.Save(); return newFeatureDataset; }
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 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 newLayerName = textboxNewLayerName.Text.Trim(); if (newLayerName == "") { MessageBox.Show("新建图层的名称不能为空!", "提示"); return; } GSOFeatureDataset newFeatureDataset = ds.CreateFeatureDataset(newLayerName); if (newFeatureDataset == null) { MessageBox.Show("新建图层的名称不符合要求!", "提示"); return; } if (radioButtonUseTemplate.Checked == true) { string shpLayerName = comboBoxShpLayerList.Text; GSOLayer shpLayer = globeControl1.Globe.Layers.GetLayerByCaption(shpLayerName); if (shpLayer == null) { MessageBox.Show("您选择的图层模板不存在!", "提示"); return; } if (shpLayer.Dataset != null && shpLayer.Dataset is GSOFeatureDataset) { GSOFeatureDataset shpFeatureDataset = shpLayer.Dataset as GSOFeatureDataset; for (int i = 0; i < shpFeatureDataset.FieldCount; i++) { GSOFieldAttr fielddef = shpFeatureDataset.GetField(i); GSOFieldAttr field = new GSOFieldAttr(); field.Name = fielddef.Name; field.Type = fielddef.Type; field.Width = fielddef.Width; field.Precision = fielddef.Precision; bool res = newFeatureDataset.AddField(field); } newFeatureDataset.Save(); MessageBox.Show("图层创建成功!", "提示"); } else { MessageBox.Show("您选择的图层模板不是矢量图层!", "提示"); return; } } else if (radioButtonUseCustom.Checked == true) { int rowCount = dataGridView1.Rows.Count; for (int i = 0; i < rowCount; i++) { string fieldName = dataGridView1.Rows[i].Cells[0].Value.ToString(); string fieldType = dataGridView1.Rows[i].Cells[1].Value.ToString(); string fieldWidth = dataGridView1.Rows[i].Cells[2].Value.ToString(); string fieldPrecision = dataGridView1.Rows[i].Cells[3].Value.ToString(); EnumFieldType enumFieldType = EnumFieldType.Text; int intFieldWidth = 2000; int intFieldPrecision = 0; if (fieldType == "Double") { enumFieldType = EnumFieldType.Double; intFieldWidth = 8; if (int.TryParse(fieldPrecision, out intFieldPrecision) == false) { intFieldPrecision = 2; } } else if (fieldType == "Int32") { enumFieldType = EnumFieldType.INT32; intFieldWidth = 4; } else if (fieldType == "Date") { enumFieldType = EnumFieldType.Date; intFieldWidth = 7; } else { int.TryParse(fieldWidth, out intFieldWidth); } GSOFieldAttr field = new GSOFieldAttr(); field.Name = fieldName; field.Type = enumFieldType; field.Width = intFieldWidth; if (field.Type == EnumFieldType.Double) { field.Precision = intFieldPrecision; } bool res = newFeatureDataset.AddField(field); } newFeatureDataset.Save(); MessageBox.Show("图层创建成功!", "提示"); } }
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 newLayerName = textboxNewLayerName.Text.Trim(); if (newLayerName == "") { MessageBox.Show("新建图层的名称不能为空!","提示"); return; } GSOFeatureDataset newFeatureDataset = ds.CreateFeatureDataset(newLayerName); if (newFeatureDataset == null) { MessageBox.Show("新建图层的名称不符合要求!", "提示"); return; } if (radioButtonUseTemplate.Checked == true) { string shpLayerName = comboBoxShpLayerList.Text; GSOLayer shpLayer = globeControl1.Globe.Layers.GetLayerByCaption(shpLayerName); if (shpLayer == null) { MessageBox.Show("您选择的图层模板不存在!", "提示"); return; } if (shpLayer.Dataset != null && shpLayer.Dataset is GSOFeatureDataset) { GSOFeatureDataset shpFeatureDataset = shpLayer.Dataset as GSOFeatureDataset; for (int i = 0; i < shpFeatureDataset.FieldCount; i++) { GSOFieldAttr fielddef = shpFeatureDataset.GetField(i); GSOFieldAttr field = new GSOFieldAttr(); field.Name = fielddef.Name; field.Type = fielddef.Type; field.Width = fielddef.Width; field.Precision = fielddef.Precision; bool res = newFeatureDataset.AddField(field); } newFeatureDataset.Save(); MessageBox.Show("图层创建成功!", "提示"); } else { MessageBox.Show("您选择的图层模板不是矢量图层!", "提示"); return; } } else if (radioButtonUseCustom.Checked == true) { int rowCount = dataGridView1.Rows.Count; for (int i = 0; i < rowCount; i++) { string fieldName = dataGridView1.Rows[i].Cells[0].Value.ToString(); string fieldType = dataGridView1.Rows[i].Cells[1].Value.ToString(); string fieldWidth = dataGridView1.Rows[i].Cells[2].Value.ToString(); string fieldPrecision = dataGridView1.Rows[i].Cells[3].Value.ToString(); EnumFieldType enumFieldType = EnumFieldType.Text; int intFieldWidth = 2000; int intFieldPrecision = 0; if (fieldType == "Double") { enumFieldType = EnumFieldType.Double; intFieldWidth = 8; if (int.TryParse(fieldPrecision, out intFieldPrecision) == false) { intFieldPrecision = 2; } } else if (fieldType == "Int32") { enumFieldType = EnumFieldType.INT32; intFieldWidth = 4; } else if (fieldType == "Date") { enumFieldType = EnumFieldType.Date; intFieldWidth = 7; } else { int.TryParse(fieldWidth, out intFieldWidth); } GSOFieldAttr field = new GSOFieldAttr(); field.Name = fieldName; field.Type = enumFieldType; field.Width = intFieldWidth; if (field.Type == EnumFieldType.Double) { field.Precision = intFieldPrecision; } bool res = newFeatureDataset.AddField(field); } newFeatureDataset.Save(); MessageBox.Show("图层创建成功!", "提示"); } }
private void btnCreateModel_Click(object sender, EventArgs e) { if (comboBoxDataSourceList.SelectedItem == null) { MessageBox.Show("请选择要复制的数据的源!"); return; } if (commBoxModelLayerList.SelectedItem == null) { MessageBox.Show("请选择数据集模板!"); return; } if (comboBoxTargetDataSource.SelectedItem == null) { MessageBox.Show("请选择目标数据源!"); return; } string layerName = textBoxNewLayerName.Text.Trim(); if (layerName == "") { MessageBox.Show("请输入数据集名称!"); return; } int num = -1; bool bl = int.TryParse(layerName.Substring(0,1),out num); if (!bl) { GSODataSource dsTarget = Utility.getDataSourceByFullName(globeControl1, comboBoxTargetDataSource.SelectedItem.ToString().Trim()); if (dsTarget != null) { GSODataset datasetInTargetDs = dsTarget.GetDatasetByName(layerName); if (datasetInTargetDs != null) { MessageBox.Show("目标数据源中该数据集名称已存在!", "提示"); return; } else { GSODataSource ds = Utility.getDataSourceByFullName(globeControl1, comboBoxDataSourceList.SelectedItem.ToString().Trim()); if (ds != null) { GSODataset datasetInDs = ds.GetDatasetByName(commBoxModelLayerList.SelectedItem.ToString()); GSOFeatureDataset featureDatasetInDs = datasetInDs as GSOFeatureDataset; if (featureDatasetInDs == null) { MessageBox.Show("选中的模板图层不符合要求!", "提示"); return; } featureDatasetInDs.Open(); GSOFeatureDataset featureDatasetTargetDs = dsTarget.CreateFeatureDataset(layerName); if (featureDatasetTargetDs == null) { MessageBox.Show("输入的新数据集名称不符合要求!", "提示"); return; } featureDatasetTargetDs.Open(); for (int i = 0; i < featureDatasetInDs.FieldCount; i++) { GSOFieldAttr fieldFromSource = featureDatasetInDs.GetField(i); GSOFieldAttr fieldInTargetDataSource = new GSOFieldAttr(); fieldInTargetDataSource.Name = fieldFromSource.Name; fieldInTargetDataSource.Type = fieldFromSource.Type; fieldInTargetDataSource.Width = fieldFromSource.Width; fieldInTargetDataSource.Precision = fieldFromSource.Precision; bool res = featureDatasetTargetDs.AddField(fieldInTargetDataSource); } featureDatasetTargetDs.Save(); featureDatasetTargetDs.Close(); featureDatasetInDs.Close(); MessageBox.Show("复制成功!", "提示"); this.Close(); } } } } else { MessageBox.Show("数据集名称不能以数字开头!", "提示"); } }