arcgis engine 考试

1、查询 public partial class SQLSelecFrm : Form private IMapControl2 pAxMapControl; public SQLSelecFrm(IMapControl2 lAxMapControl) InitializeComponent(); this.pAxMapControl = lAxMapControl; for (int i = 0; i < pAxMapControl.LayerCount; i+) comboBoxLayer.Items.Add(pAxMapControl.get_Layer(i).Name); comb

2、oBoxLayer.SelectedIndex = 0; /设置comboBoxMethod的选择项并置默认值为第台一项 comboBoxMethod.Items.Add("新建选择集"); comboBoxMethod.Items.Add("添加进已有的选择集"); comboBoxMethod.Items.Add("从当前选择集中清除"); comboBoxMethod.Items.Add("从当前选择集中再次筛选"); comboBoxMethod.SelectedIndex = 0; private voi

3、d button5_Click(object sender, EventArgs e) textBox_WhereClause.Text += " =" private void button6_Click(object sender, EventArgs e) textBox_WhereClause.Text += " <>" private void button8_Click(object sender, EventArgs e) textBox_WhereClause.Text += " >" private

4、 void button9_Click(object sender, EventArgs e) textBox_WhereClause.Text += " >=" private void button11_Click(object sender, EventArgs e) textBox_WhereClause.Text += " <" private void button12_Click(object sender, EventArgs e) textBox_WhereClause.Text += " <="

5、private void button15_Click(object sender, EventArgs e) textBox_WhereClause.Text += " ()" private void button7_Click(object sender, EventArgs e) textBox_WhereClause.Text += " LIKE" private void button10_Click(object sender, EventArgs e) textBox_WhereClause.Text += " AND"

6、; private void button13_Click(object sender, EventArgs e) textBox_WhereClause.Text += " OR" private void button16_Click(object sender, EventArgs e) textBox_WhereClause.Text += " NOT" private void button14_Click(object sender, EventArgs e) textBox_WhereClause.Text += " IS&quo

7、t; private void button2_Click(object sender, EventArgs e) textBox_WhereClause.Text = "" private void button17_Click(object sender, EventArgs e) textBox_WhereClause.Text += " ?" private void button18_Click(object sender, EventArgs e) textBox_WhereClause.Text += " *" priv

8、ate void comboBoxLayer_SelectedIndexChanged(object sender, EventArgs e) /如果没有图层被选择，将不能添加字段 if (comboBoxLayer.Text != null) /清listBox_Field listBox_Field.Items.Clear(); /获取要素 IFeatureLayer lFeatureLayer = (IFeatureLayer)pAxMapControl.Map.get_Layer(comboBoxLayer.SelectedIndex); IFeatureCursor lFeature

9、Cursor = lFeatureLayer.Search(null, true); IFeature lFeature = lFeatureCursor.NextFeature(); /循环添加所属图层的字段名进入listBox_Field中 /对于sriFieldTypeGeometry类型的自动则不予以添加 for (int i = 0; i < lFeature.Fields.FieldCount; i+) if (lFeature.Fields.get_Field(i).Type != esriFieldType.esriFieldTypeGeometry) listBox_F

10、ield.Items.Add(lFeature.Fields.get_Field(i).Name); /设置当前选择字段为第一个 listBox_Field.SelectedIndex = 0; /将描述信息修改 label_Description.Text = "SELECT * FROM " + comboBoxLayer.Text + " WHERE:" private void listBox_Field_DoubleClick(object sender, EventArgs e) IFeatureLayer lFeatureLayer = (

11、IFeatureLayer)pAxMapControl.Map.get_Layer(comboBoxLayer.SelectedIndex); if (lFeatureLayer.DataSourceType = "Shapefile Feature Class")/shapefile文 textBox_WhereClause.Text += """ + listBox_Field.Text + """ else textBox_WhereClause.Text += " " + listBox

12、_Field.Text + " " private void listBox_Value_DoubleClick(object sender, EventArgs e) textBox_WhereClause.Text += " " + listBox_Value.Text; private void listBox_Field_SelectedIndexChanged(object sender, EventArgs e) button_GetValue.Enabled = true; private void button_GetValue_Clic

13、k(object sender, EventArgs e) /获取要素图层与要素类将其作为参数传入GetUniqueValue()函数 IFeatureLayer lFeatureLayer = (IFeatureLayer)pAxMapControl.get_Layer(comboBoxLayer.SelectedIndex); IFeatureClass lFeatureClass = lFeatureLayer.FeatureClass; /将返回的所有值存入allValue数组中并进行排序 string allValue = GetUniqueValue(lFeatureClass,

14、listBox_Field.Text); Array.Sort(allValue); /获取字段对象用于在将其值添加进listbox_value中时判断字段类型 IFeatureCursor lFeatureCursor = lFeatureLayer.Search(null, true); IFeature lFeature = lFeatureCursor.NextFeature(); IField lField = new FieldClass(); for (int j = 0; j < lFeature.Fields.FieldCount; j+) if (listBox_Fi

15、eld.Text = lFeature.Fields.get_Field(j).Name) lField = lFeature.Fields.get_Field(j); /将之前listBox_Value中值清空然后加此次选中字段的所有数据 listBox_Value.Items.Clear(); for (int i = 0; i < allValue.Length; i+) if (lField.Type = esriFieldType.esriFieldTypeString) allValuei = "'" + allValuei + "

16、9;" listBox_Value.Items.Add(allValuei); else listBox_Value.Items.Add(allValuei); listBox_Value.Visible = true; button_GetValue.Enabled = false; / <summary> / 得到要素类某字段的唯一值 / </summary> / <param name="pFeatureClass">要素类</param> / <param name="strFld"

17、>指定要得到唯一值的字段</param> / <returns>唯一值字符数据</returns> public string GetUniqueValue(IFeatureClass pFeatureClass, string strFld) /得到IFeatureCursor括 IFeatureCursor pCursor = pFeatureClass.Search(null, false); /IDataStatistics对象实例 IDataStatistics pData = new DataStatisticsClass(); pData

18、.Field = strFld; pData.Cursor = pCursor as ICursor; /枚举唯一值 IEnumerator pEnumVar = pData.UniqueValues; /记录总数 int RecordCount = pData.UniqueValueCount; /字?符?数簓组哩7 string strValue = new stringRecordCount; pEnumVar.Reset(); int i = 0; while (pEnumVar.MoveNext() strValuei+ = pEnumVar.Current.ToString();

19、return strValue; public IFeatureSelection GetFeatureSelect(IFeatureLayer pFeatureLayer,string strQuery) IFeatureSelection lFeatureSelection = (IFeatureSelection)pFeatureLayer; IQueryFilter2 lQueryFilter = new QueryFilterClass(); lQueryFilter.WhereClause = strQuery; lFeatureSelection.SelectFeatures(l

20、QueryFilter, esriSelectionResultEnum.esriSelectionResultNew, false); pAxMapControl.ActiveView.Refresh(); return lFeatureSelection; private void button3_Click(object sender, EventArgs e) if (textBox_WhereClause.Text != "") try IFeatureLayer lFeatureLayer = (IFeatureLayer)pAxMapControl.get_L

21、ayer(comboBoxLayer.SelectedIndex); IFeatureSelection lFeatureSelection = (IFeatureSelection)lFeatureLayer; /判D断?选?择?的?SQL方?法8的?类8型í esriSelectionResultEnum lesriSREnum = esriSelectionResultEnum.esriSelectionResultNew; switch (comboBoxMethod.SelectedIndex) case 0: lesriSREnum = esriSelectionResu

22、ltEnum.esriSelectionResultNew; break; case 1: lesriSREnum = esriSelectionResultEnum.esriSelectionResultAdd; break; case 2: lesriSREnum = esriSelectionResultEnum.esriSelectionResultSubtract; break; case 3: lesriSREnum = esriSelectionResultEnum.esriSelectionResultAnd; break; default: MessageBox.Show(&

23、quot;请?选?择?一?种?查é询方?法?); break; /创洹9建¨查é询的?条?件t IQueryFilter2 lQueryFilter = new QueryFilterClass(); lQueryFilter.WhereClause = textBox_WhereClause.Text; /根ù据Y查é询添9加ó进?行D选?择?，?并刷新?屏á幕? lFeatureSelection.SelectFeatures(lQueryFilter, lesriSREnum, false); pAxMapControl.ActiveView.Refresh(); catch (Exception) MessageBox.Show