Changes between Version 70 and Version 71 of SandBoxPac

Timestamp:

06/04/09 17:07:32 (16 years ago)

Author:

pacitu

Comment:

--

SandBoxPac

@@ -95 +95 @@
 
 
+{{{
+#!C
+   [WebMethod]
+    public List<City> SearchStates(string userName, string password, string name)
+    {
+        IWorkspace workspace = Connect(userName, password);
+
+        List<City> resCities = new List<City>();
+        IFeatureClass statesClass = (workspace as IFeatureWorkspace).OpenFeatureClass("States");
+        IFeatureClass capitalsClass = (workspace as IFeatureWorkspace).OpenFeatureClass("Capitals");
+        int nameIndex = capitalsClass.FindField("CITY_NAME");
+
+        IQueryFilter sfs = new QueryFilterClass();
+        sfs.WhereClause = "STATE_ABBR = '" + name + "'";
+        IFeatureCursor resCursor = statesClass.Search(sfs, true);
+
+        IFeature state = resCursor.NextFeature();
+        while (state != null)
+        {
+            
+            ISpatialFilter sfc = new SpatialFilterClass();
+            IGeometry buffer = state.Shape;
+            sfc.Geometry = buffer;
+            sfc.SpatialRel = esriSpatialRelEnum.esriSpatialRelEnvelopeIntersects;
+
+            IFeatureCursor resCursorCy = capitalsClass.Search(sfc, true);
+            IFeature capital = resCursorCy.NextFeature();
+
+            while (capital != null)
+            {
+                resCities.Add(new City(capital.get_Value(nameIndex) as string, 0, 0));
+                capital = resCursorCy.NextFeature();
+            }
+
+            Marshal.ReleaseComObject(resCursorCy);
+            state = resCursor.NextFeature();
+        }
+
+        Marshal.ReleaseComObject(resCursor);
+        return resCities;
+    }
+}}}