public List<OperationTag> getOperationTagsWithValue(string value)
{
List<OperationTag> operationTags = new List<OperationTag>();
string sqlFindGUIDS = @"select ea_guid from t_operationtag opt
where opt.[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)
{
OperationTag operationTag = this.getOperationTagByGUID(guidNode.InnerText);
if (operationTag != null)
{
operationTags.Add(operationTag);
}
}
return operationTags;
}