[求助] arcgisserver9.3外部数据关联表后原有的单值专题图不显示了？

楼主^#

更多发布于：2012-10-31 09:36

目地是做外部数据关联专题图，做图层表和数据库中一表进行关联后，原有的图层信息都查不到了原有的单位专题图也没有了跟踪调试发现是两表联合后原图层表的列名变了
原因是：area的列变成了 "图层名.area" 请问各位有什么办法？代码如下： DataTable dt0 = this.MyConvertITable(primaryClass as ITable);//查看图层信息
 //读取文件数据 //IWorkspaceFactory pFact = (IWorkspaceFactory)serverContext.CreateObject("esriDataSourcesOleDB.TextFileWorkspaceFactory"); //IFeatureWorkspace pFeatws = pFact.OpenFromFile("D:\\test", 0) as IFeatureWorkspace; //ITable pTable = pFeatws.OpenTable("9.txt");
 //DataTable dt3 = hys.MyConvertITable(pTable);
 //进行关联 IMemoryRelationshipClassFactory memoryRelClassFactory = pServerContext.CreateObject("esriGeodatabase.MemoryRelationshipClassFactory") as IMemoryRelationshipClassFactory; //如果是从文件读取 //IRelationshipClass relationshipClass = memoryRelClassFactory.Open("test", (IObjectClass)primaryClass, "OBJECTID", (IObjectClass)pTable, "OBJECTID", "forward", "backward", esriRelCardinality.esriRelCardinalityOneToOne); //如果是从sql server读取 IRelationshipClass relationshipClass = memoryRelClassFactory.Open("test", (IObjectClass)primaryClass, "farm_code", (IObjectClass)ittemp, "farm_code", "forward", "backward", ESRI.ArcGIS.Geodatabase.esriRelCardinality.esriRelCardinalityOneToOne); //IRelationshipClass relationshipClass = memoryRelClassFactory.Open("test", (IObjectClass)ittemp, "farm_code", (IObjectClass)primaryClass, "farm_code", "forward", "backward", ESRI.ArcGIS.Geodatabase.esriRelCardinality.esriRelCardinalityOneToMany);
 //得到关联表 IRelQueryTableFactory iRelQryTabFactory = pServerContext.CreateObject("esriGeodatabase.RelQueryTableFactory") as IRelQueryTableFactory;
 ITable iRelQueryTable = iRelQryTabFactory.Open(relationshipClass, true, null, null, "a", true, true) as ITable;
 
 
 DataTable dt2 = this.MyConvertITable(iRelQueryTable);这块的原图层列名变成了“图层名.列名”导致原图层查不到信息原有的专题图也没了
 featureLyer.FeatureClass = (IFeatureClass)iRelQueryTable;
 
 
后来我又试了在原图层表上加列的办法代码如下：但红字地方出错不知为何？
 IGeoFeatureLayer pGeoFeatureLyer = layer as IGeoFeatureLayer; #region 添加字段
 bool havefield = false;
 IFields Ifields = pGeoFeatureLyer.FeatureClass.Fields as IFields; IFieldsEdit fieldsEdit = (IFieldsEdit)Ifields;
 for (int col = 0; col < fields.Length; col++)//遍历要添加的字段是否与现在的字段重复 {
 for (int j = 0; j < Ifields.FieldCount; j++) {
 if (fields[col] == Ifields.get_Field(j).Name)
 havefield = true;
 }
 if (!havefield) {
 IField oField = (IField)pServerContext.CreateObject("esriGeodatabase.Field");
 IFieldEdit oFieldEdit = oField as IFieldEdit;
 oFieldEdit.Name_2 = fields[col];
 oFieldEdit.Type_2 = ESRI.ArcGIS.Geodatabase.esriFieldType.esriFieldTypeDouble; 
 // pGeoFeatureLyer.FeatureClass.AddField(oField); fieldsEdit.AddField(oField);
 
 }
 havefield = false;
 }
 #endregion #region 设置数值
 ESRI.ArcGIS.Geodatabase.IQueryFilter2 queryFilter = new ESRI.ArcGIS.Geodatabase.QueryFilterClass();
 //queryFilter.WhereClause = "PID in (" + sitePID + ")";
 for (int i = 0; i < pGeoFeatureLyer.FeatureClass.FeatureCount(queryFilter); i++) {
 IFeature ifeature = pGeoFeatureLyer.FeatureClass.GetFeature(i);
 int pidindex = ifeature.Fields.FindField("farm_code");
 for (int col = 0; col < fields.Length; col++) {
 pidindex = ifeature.Fields.FindField(fields[col]);
 // DataRow dr = dt.Select(" Station='" + siteen.Station + "' and Field='" + fields[col] + "'")[0];
 ifeature.set_Value(pidindex, null);
 ifeature.Store();出错了不知为什么 
 }
 
 }

喜欢0 评分0

举报回复

发帖回复

« 返回列表

您需要登录后才可以回帖，登录或者注册

返回顶部

[求助] arcgisserver9.3外部数据关联表后原有的单值专题图不显示了？

最新喜欢：