public List<RelationTag> getRelationTagsWithValue(string value)
{
List<RelationTag> relationTags = new List<RelationTag>();
string sqlFindGUIDS = @"select ea_guid from t_connectortag ct
where ct.[VALUE] like '"+ value + "'";
// get the nodes with the name "ea_guid"
XmlDocument xmlTagGUIDs = this.SQLQuery(sqlFindGUIDS);
XmlNodeList tagGUIDNodes = xmlTagGUIDs.SelectNodes(formatXPath("//ea_guid"));
foreach (XmlNode guidNode in tagGUIDNodes)
{
RelationTag relationTag = this.getRelationTagByGUID(guidNode.InnerText);
if (relationTag != null)
{
relationTags.Add(relationTag);
}
}
return relationTags;
}