private void AddQALayerToActiveView(IMap map, IFeatureClass SourceLineFeatureClass, IFeatureClass SourcePolygonFeatureClass, string layerPathFile, double metersPerUnit, bool bIsBefore1022, bool bFabricIsInGCS) { if (map == null || layerPathFile == null || !layerPathFile.EndsWith(".lyr")) { return; } // Create a new GxLayer IGxLayer gxLayer = new GxLayerClass(); IGxFile gxFile = (IGxFile)gxLayer; // Set the path for where the layerfile is located on disk gxFile.Path = layerPathFile; // Test if we have a valid layer and add it to the map if (!(gxLayer.Layer == null)) { if (!(gxLayer.Layer is ICompositeLayer)) { return; } ICompositeLayer pCompLyr = (ICompositeLayer)gxLayer.Layer; for (int i = 0; i < pCompLyr.Count; i++) { ILayer pLyr = pCompLyr.get_Layer(i); // if (pLyr is IFeatureLayer) { IFeatureLayer pFlyr = (IFeatureLayer)pLyr; //now update the definition query IFeatureLayerDefinition pFeatLyrDef = (IFeatureLayerDefinition)pFlyr; string sLyrName = pFlyr.Name; bool bExc = false; if (sLyrName.Contains("Minus")) { pFlyr.FeatureClass = SourceLineFeatureClass; bExc = false; //ILayerFields pLayerFields = pFlyr as ILayerFields; //First turn off all layers //for (int kk = 0; kk < pLayerFields.FieldCount; kk++) //{ // IFieldInfo pFieldInfo = pLayerFields.get_FieldInfo(kk); // pFieldInfo.Visible = false; //} SetLabelExpressionOnFeatureLayer(pFlyr, out bExc); if (bExc || bFabricIsInGCS) { int jj = pFlyr.FeatureClass.FindField("ComputedMinusObserved"); if (jj > -1) { string sVal = (0.1 / metersPerUnit).ToString("0.00"); string sCminusO = pFlyr.FeatureClass.Fields.get_Field(jj).Name; pFeatLyrDef.DefinitionExpression = sCminusO + " > " + sVal + " AND " + sCminusO + " < " + sVal; //IFieldInfo pFieldInfo = pLayerFields.get_Field(jj) as IFieldInfo; //pFieldInfo.Visible = true; } continue; } string s = pFeatLyrDef.DefinitionExpression; int iField = SourceLineFeatureClass.FindField("ArcLength"); if (iField > -1) { //IFieldInfo pFieldInfo = pLayerFields.get_Field(iField) as IFieldInfo; //pFieldInfo.Visible = true; string s2 = SourceLineFeatureClass.Fields.get_Field(iField).Name; pFeatLyrDef.DefinitionExpression = s.Replace("\"ArcLength\"", s2); pFeatLyrDef.DefinitionExpression = s.Replace("ArcLength", s2); } s = pFeatLyrDef.DefinitionExpression; iField = SourceLineFeatureClass.FindField("Distance"); if (iField > -1) { //IFieldInfo pFieldInfo = pLayerFields.get_Field(iField) as IFieldInfo; //pFieldInfo.Visible = true; string s2 = SourceLineFeatureClass.Fields.get_Field(iField).Name; pFeatLyrDef.DefinitionExpression = s.Replace("\"Distance\"", s2); pFeatLyrDef.DefinitionExpression = s.Replace("Distance", s2); } s = pFeatLyrDef.DefinitionExpression; pFeatLyrDef.DefinitionExpression = s.Replace("Shape_Length", SourceLineFeatureClass.LengthField.Name); } else if (sLyrName.Contains("Parcel")) { //In 10.1 start editing crashes if the definition query in these layers that use POWER function is present. //Can test if the release is 10.1 and knock out the def query, or else exclude the layers. string s = pFeatLyrDef.DefinitionExpression; int iField = SourcePolygonFeatureClass.FindField("MiscloseDistance"); string s2 = SourcePolygonFeatureClass.Fields.get_Field(iField).Name; pFeatLyrDef.DefinitionExpression = s.Replace("\"MiscloseDistance\"", s2); pFeatLyrDef.DefinitionExpression = s.Replace("MiscloseDistance", s2); s = pFeatLyrDef.DefinitionExpression; iField = SourcePolygonFeatureClass.FindField("ShapeStdErrorE"); s2 = SourcePolygonFeatureClass.Fields.get_Field(iField).Name; pFeatLyrDef.DefinitionExpression = s.Replace("\"ShapeStdErrorE\"", s2); pFeatLyrDef.DefinitionExpression = s.Replace("ShapeStdErrorE", s2); s = pFeatLyrDef.DefinitionExpression; iField = SourcePolygonFeatureClass.FindField("ShapeStdErrorN"); s2 = SourcePolygonFeatureClass.Fields.get_Field(iField).Name; pFeatLyrDef.DefinitionExpression = s.Replace("\"ShapeStdErrorN\"", s2); pFeatLyrDef.DefinitionExpression = s.Replace("ShapeStdErrorN", s2); pFlyr.FeatureClass = SourcePolygonFeatureClass; SetLabelExpressionOnFeatureLayer(pFlyr, out bExc); if (s.ToLower().Contains("power") && bIsBefore1022) {//remove the def query CR278039 pFeatLyrDef.DefinitionExpression = ""; continue; } } } } gxLayer.Layer.Name = "QA Symbology"; IMxDocument pMXDoc = ArcMap.Document; IOperationStack pOpSt = pMXDoc.OperationStack; IAddLayersOperation pAddLyrOp = new AddLayersOperationClass(); pAddLyrOp.SetDestinationInfo(0, map, null); pAddLyrOp.Name = "Add Fabric QA Layer"; pAddLyrOp.AddLayer(gxLayer.Layer); IOperation pOp = (IOperation)pAddLyrOp; pOpSt.Do(pOp); } }
private void AddQALayerToActiveView(IMap map, IFeatureClass SourceLineFeatureClass, IFeatureClass SourcePolygonFeatureClass, string layerPathFile, double metersPerUnit, bool bIsBefore1022, bool bFabricIsInGCS) { if (map == null || layerPathFile == null || !layerPathFile.EndsWith(".lyr")) { return; } // Create a new GxLayer IGxLayer gxLayer = new GxLayerClass(); IGxFile gxFile = (IGxFile)gxLayer; // Set the path for where the layerfile is located on disk gxFile.Path = layerPathFile; // Test if we have a valid layer and add it to the map if (!(gxLayer.Layer == null)) { if (!(gxLayer.Layer is ICompositeLayer)) return; ICompositeLayer pCompLyr = (ICompositeLayer)gxLayer.Layer; for (int i=0; i<pCompLyr.Count; i++) { ILayer pLyr = pCompLyr.get_Layer(i); // if (pLyr is IFeatureLayer) { IFeatureLayer pFlyr = (IFeatureLayer)pLyr; //now update the definition query IFeatureLayerDefinition pFeatLyrDef = (IFeatureLayerDefinition)pFlyr; string sLyrName = pFlyr.Name; bool bExc = false; if (sLyrName.Contains("Minus")) { pFlyr.FeatureClass = SourceLineFeatureClass; bExc = false; //ILayerFields pLayerFields = pFlyr as ILayerFields; //First turn off all layers //for (int kk = 0; kk < pLayerFields.FieldCount; kk++) //{ // IFieldInfo pFieldInfo = pLayerFields.get_FieldInfo(kk); // pFieldInfo.Visible = false; //} SetLabelExpressionOnFeatureLayer(pFlyr, out bExc); if (bExc || bFabricIsInGCS) { int jj=pFlyr.FeatureClass.FindField("ComputedMinusObserved"); if (jj>-1) { string sVal = (0.1 / metersPerUnit).ToString("0.00"); string sCminusO=pFlyr.FeatureClass.Fields.get_Field(jj).Name; pFeatLyrDef.DefinitionExpression = sCminusO + " > "+sVal+" AND " + sCminusO + " < "+sVal; //IFieldInfo pFieldInfo = pLayerFields.get_Field(jj) as IFieldInfo; //pFieldInfo.Visible = true; } continue; } string s = pFeatLyrDef.DefinitionExpression; int iField = SourceLineFeatureClass.FindField("ArcLength"); if (iField > -1) { //IFieldInfo pFieldInfo = pLayerFields.get_Field(iField) as IFieldInfo; //pFieldInfo.Visible = true; string s2 = SourceLineFeatureClass.Fields.get_Field(iField).Name; pFeatLyrDef.DefinitionExpression = s.Replace("\"ArcLength\"", s2); pFeatLyrDef.DefinitionExpression = pFeatLyrDef.DefinitionExpression.Replace("ArcLength", s2); } s = pFeatLyrDef.DefinitionExpression; iField = SourceLineFeatureClass.FindField("Distance"); if (iField > -1) { //IFieldInfo pFieldInfo = pLayerFields.get_Field(iField) as IFieldInfo; //pFieldInfo.Visible = true; string s2 = SourceLineFeatureClass.Fields.get_Field(iField).Name; pFeatLyrDef.DefinitionExpression = s.Replace("\"Distance\"", s2); pFeatLyrDef.DefinitionExpression = pFeatLyrDef.DefinitionExpression.Replace("Distance", s2); } s = pFeatLyrDef.DefinitionExpression; iField = SourceLineFeatureClass.FindField("DensifyType"); if (iField > -1) { string s2 = SourceLineFeatureClass.Fields.get_Field(iField).Name; pFeatLyrDef.DefinitionExpression = s.Replace("\"DensifyType\"", s2); pFeatLyrDef.DefinitionExpression = pFeatLyrDef.DefinitionExpression.Replace("DensifyType", s2); } s = pFeatLyrDef.DefinitionExpression; pFeatLyrDef.DefinitionExpression = s.Replace("\"Shape_Length\"", SourceLineFeatureClass.LengthField.Name); pFeatLyrDef.DefinitionExpression = pFeatLyrDef.DefinitionExpression.Replace("Shape_Length", SourceLineFeatureClass.LengthField.Name); } else if (sLyrName.Contains("Parcel")) { //In 10.1 start editing crashes if the definition query in these layers that use POWER function is present. //Can test if the release is 10.1 and knock out the def query, or else exclude the layers. string s = pFeatLyrDef.DefinitionExpression; int iField=SourcePolygonFeatureClass.FindField("MiscloseDistance"); string s2 = SourcePolygonFeatureClass.Fields.get_Field(iField).Name; pFeatLyrDef.DefinitionExpression = s.Replace("\"MiscloseDistance\"", s2); pFeatLyrDef.DefinitionExpression = pFeatLyrDef.DefinitionExpression.Replace("MiscloseDistance", s2); s = pFeatLyrDef.DefinitionExpression; iField = SourcePolygonFeatureClass.FindField("ShapeStdErrorE"); s2 = SourcePolygonFeatureClass.Fields.get_Field(iField).Name; pFeatLyrDef.DefinitionExpression = s.Replace("\"ShapeStdErrorE\"", s2); pFeatLyrDef.DefinitionExpression = pFeatLyrDef.DefinitionExpression.Replace("ShapeStdErrorE", s2); s = pFeatLyrDef.DefinitionExpression; iField = SourcePolygonFeatureClass.FindField("ShapeStdErrorN"); s2 = SourcePolygonFeatureClass.Fields.get_Field(iField).Name; pFeatLyrDef.DefinitionExpression = s.Replace("\"ShapeStdErrorN\"", s2); pFeatLyrDef.DefinitionExpression = pFeatLyrDef.DefinitionExpression.Replace("ShapeStdErrorN", s2); pFlyr.FeatureClass = SourcePolygonFeatureClass; SetLabelExpressionOnFeatureLayer(pFlyr, out bExc); if (s.ToLower().Contains("power") && bIsBefore1022) {//remove the def query CR278039 pFeatLyrDef.DefinitionExpression = ""; continue; } } } } gxLayer.Layer.Name = "QA Symbology"; IMxDocument pMXDoc = ArcMap.Document; IOperationStack pOpSt = pMXDoc.OperationStack; IAddLayersOperation pAddLyrOp = new AddLayersOperationClass(); pAddLyrOp.SetDestinationInfo(0,map,null); pAddLyrOp.Name = "Add Fabric QA Layer"; pAddLyrOp.AddLayer(gxLayer.Layer); IOperation pOp=(IOperation)pAddLyrOp; pOpSt.Do(pOp); } }
private void AddQALayerToActiveView(IMap map, IFeatureClass SourceLineFeatureClass, IFeatureClass SourcePolygonFeatureClass, string layerPathFile, double metersPerUnit, bool bIsBefore1022, bool bFabricIsInGCS) { if (map == null || layerPathFile == null || !layerPathFile.EndsWith(".lyr")) { return; } IWorkspace pWS = SourceLineFeatureClass.FeatureDataset.Workspace; bool bIsPostGres = false; if (pWS.Type != esriWorkspaceType.esriLocalDatabaseWorkspace) { IDatabaseConnectionInfo2 connectionInfo2 = (IDatabaseConnectionInfo2)(pWS); bIsPostGres = (connectionInfo2.ConnectionDBMS == esriConnectionDBMS.esriDBMS_PostgreSQL); } // Create a new GxLayer IGxLayer gxLayer = new GxLayerClass(); IGxFile gxFile = (IGxFile)gxLayer; // Set the path for where the layerfile is located on disk gxFile.Path = layerPathFile; // Test if we have a valid layer and add it to the map if (!(gxLayer.Layer == null)) { if (!(gxLayer.Layer is ICompositeLayer)) { return; } ICompositeLayer pCompLyr = (ICompositeLayer)gxLayer.Layer; for (int i = 0; i < pCompLyr.Count; i++) { ILayer pLyr = pCompLyr.get_Layer(i); // if (pLyr is IFeatureLayer) { IFeatureLayer pFlyr = (IFeatureLayer)pLyr; //now update the definition query IFeatureLayerDefinition pFeatLyrDef = (IFeatureLayerDefinition)pFlyr; string sLyrName = pFlyr.Name; bool bExc = false; if (sLyrName.Contains("Minus")) { pFlyr.FeatureClass = SourceLineFeatureClass; bExc = false; SetLabelExpressionOnFeatureLayer(pFlyr, out bExc); if (bExc || bFabricIsInGCS) { int jj = pFlyr.FeatureClass.FindField("ComputedMinusObserved"); if (jj > -1) { string sVal = (0.1 / metersPerUnit).ToString("0.00"); string sCminusO = pFlyr.FeatureClass.Fields.get_Field(jj).Name; pFeatLyrDef.DefinitionExpression = "(" + sCminusO + " > " + sVal + " OR " + sCminusO + " < -" + sVal + ") AND (" + sCminusO + " IS NOT NULL)"; if (bIsPostGres) { pFeatLyrDef.DefinitionExpression = "(((st_length(shape) - distance) > " + sVal + " OR (st_length(shape) - distance) < -" + sVal + " OR (distance - st_length(shape)) > " + sVal + " OR (distance - st_length(shape)) < -" + sVal + ") AND (radius IS NULL AND (densifytype IS NULL OR densifytype <> 3)) AND category <> 4) OR ( ( ((st_length(shape) - arclength) > " + sVal + " OR (st_length(shape) - arclength) < -" + sVal + ") OR (arclength - st_length(shape)) > " + sVal + " OR (arclength - st_length(shape)) < -" + sVal + ") AND ( NOT arclength IS NULL ) )"; //this is query for ST_Geometry as well as PG_Geometry } } continue; } string s = pFeatLyrDef.DefinitionExpression; int iField = SourceLineFeatureClass.FindField("ArcLength"); if (iField > -1) { string s2 = SourceLineFeatureClass.Fields.get_Field(iField).Name; pFeatLyrDef.DefinitionExpression = s.Replace("\"ArcLength\"", s2); pFeatLyrDef.DefinitionExpression = pFeatLyrDef.DefinitionExpression.Replace("ArcLength", s2); } s = pFeatLyrDef.DefinitionExpression; iField = SourceLineFeatureClass.FindField("Category"); if (iField > -1) { string s2 = SourceLineFeatureClass.Fields.get_Field(iField).Name; pFeatLyrDef.DefinitionExpression = s.Replace("\"Category\"", s2); pFeatLyrDef.DefinitionExpression = pFeatLyrDef.DefinitionExpression.Replace("Category", s2); } s = pFeatLyrDef.DefinitionExpression; iField = SourceLineFeatureClass.FindField("Radius"); if (iField > -1) { string s2 = SourceLineFeatureClass.Fields.get_Field(iField).Name; pFeatLyrDef.DefinitionExpression = s.Replace("\"Radius\"", s2); pFeatLyrDef.DefinitionExpression = pFeatLyrDef.DefinitionExpression.Replace("Radius", s2); } s = pFeatLyrDef.DefinitionExpression; iField = SourceLineFeatureClass.FindField("Distance"); if (iField > -1) { string s2 = SourceLineFeatureClass.Fields.get_Field(iField).Name; pFeatLyrDef.DefinitionExpression = s.Replace("\"Distance\"", s2); pFeatLyrDef.DefinitionExpression = pFeatLyrDef.DefinitionExpression.Replace("Distance", s2); } s = pFeatLyrDef.DefinitionExpression; iField = SourceLineFeatureClass.FindField("DensifyType"); if (iField > -1) { string s2 = SourceLineFeatureClass.Fields.get_Field(iField).Name; pFeatLyrDef.DefinitionExpression = s.Replace("\"DensifyType\"", s2); pFeatLyrDef.DefinitionExpression = pFeatLyrDef.DefinitionExpression.Replace("DensifyType", s2); } s = pFeatLyrDef.DefinitionExpression; pFeatLyrDef.DefinitionExpression = s.Replace("\"Shape_Length\"", SourceLineFeatureClass.LengthField.Name); pFeatLyrDef.DefinitionExpression = pFeatLyrDef.DefinitionExpression.Replace("Shape_Length", SourceLineFeatureClass.LengthField.Name); } else if (sLyrName.Contains("Parcel")) { //In 10.1 start editing crashes if the definition query in these layers that use POWER function is present. //Can test if the release is 10.1 and knock out the def query, or else exclude the layers. string s = pFeatLyrDef.DefinitionExpression; int iField = SourcePolygonFeatureClass.FindField("MiscloseDistance"); string s2 = SourcePolygonFeatureClass.Fields.get_Field(iField).Name; pFeatLyrDef.DefinitionExpression = s.Replace("\"MiscloseDistance\"", s2); pFeatLyrDef.DefinitionExpression = pFeatLyrDef.DefinitionExpression.Replace("MiscloseDistance", s2); s = pFeatLyrDef.DefinitionExpression; iField = SourcePolygonFeatureClass.FindField("ShapeStdErrorE"); s2 = SourcePolygonFeatureClass.Fields.get_Field(iField).Name; pFeatLyrDef.DefinitionExpression = s.Replace("\"ShapeStdErrorE\"", s2); pFeatLyrDef.DefinitionExpression = pFeatLyrDef.DefinitionExpression.Replace("ShapeStdErrorE", s2); s = pFeatLyrDef.DefinitionExpression; iField = SourcePolygonFeatureClass.FindField("ShapeStdErrorN"); s2 = SourcePolygonFeatureClass.Fields.get_Field(iField).Name; pFeatLyrDef.DefinitionExpression = s.Replace("\"ShapeStdErrorN\"", s2); pFeatLyrDef.DefinitionExpression = pFeatLyrDef.DefinitionExpression.Replace("ShapeStdErrorN", s2); pFlyr.FeatureClass = SourcePolygonFeatureClass; SetLabelExpressionOnFeatureLayer(pFlyr, out bExc); if (s.ToLower().Contains("power") && bIsBefore1022) {//remove the def query CR278039 pFeatLyrDef.DefinitionExpression = ""; continue; } } } } gxLayer.Layer.Name = "QA Symbology"; IMxDocument pMXDoc = ArcMap.Document; IOperationStack pOpSt = pMXDoc.OperationStack; IAddLayersOperation pAddLyrOp = new AddLayersOperationClass(); pAddLyrOp.SetDestinationInfo(0, map, null); pAddLyrOp.Name = "Add Fabric QA Layer"; pAddLyrOp.AddLayer(gxLayer.Layer); IOperation pOp = (IOperation)pAddLyrOp; pOpSt.Do(pOp); } }