public DefinitionFilterItem(MapMember mapMember, DefinitionQuery definitionQuery) { //if (definitionFilter == null) return; _mapMember = mapMember; _queryExpression = definitionQuery?.WhereClause; _expressionName = definitionQuery?.Name; _definitionFilter = definitionQuery; var queryBuilderControlProps = new QueryBuilderControlProperties { Expression = CurrentDefinitionQuery?.WhereClause, EditClauseMode = true, MapMember = ItemMapMember, AutoValidate = true }; ControlProperties = queryBuilderControlProps; _isActiveFilter = IsDefinitionFilterActive(); }
/// <summary> /// Boundingbox of dataset /// </summary> /// <returns>boundingbox</returns> public BoundingBox GetExtents() { using (SqlConnection conn = new SqlConnection(_ConnectionString)) { string strSQL = string.Format("SELECT ST.AsBinary(ST.EnvelopeQueryWhere('{0}', '{1}', '{2}'))", Table, GeometryColumn, DefinitionQuery.Replace("'", "''")); using (SqlCommand command = new SqlCommand(strSQL, conn)) { conn.Open(); object result = command.ExecuteScalar(); conn.Close(); if (result == DBNull.Value) { return(null); } BoundingBox bbox = GeometryFromWKB.Parse((byte[])result).GetBoundingBox(); return(bbox); } } }