#region Variables & Constates
//Constantes valores combo
const string ID_QUERY = “ID_Query”;
const string NOMBRE_QUERY = “Query”;
public const string TIPO_QUERY0_ID = “Q0”;
public const string TIPO_QUERY0_TEXT = “Seleccione un tipo de query…”;
public const string TIPO_QUERY1_ID = “Q1”;
public const string TIPO_QUERY1_TEXT = “Keyword Query”;
public const string TIPO_QUERY2_ID = “Q2”;
public const string TIPO_QUERY2_TEXT = “Búsqueda por Scope”;
public const string TIPO_QUERY3_ID = “Q3”;
public const string TIPO_QUERY3_TEXT = “Búsqueda por Scope y Campo”;
public const string TIPO_QUERY4_ID = “Q4”;
public const string TIPO_QUERY4_TEXT = “Búsqueda con LIKE”;
public const string TIPO_QUERY5_ID = “Q5”;
public const string TIPO_QUERY5_TEXT = “Búsqueda con CONTAINS y *”;
public const string TIPO_QUERY6_ID = “Q6”;
public const string TIPO_QUERY6_TEXT = “Búsqueda con FreeText”;
public const string TIPO_QUERY7_ID = “Q7”;
public const string TIPO_QUERY7_TEXT = “Búsqueda con FreeText y Op. Exclusión”;
//Constantes para las queries
public const string QUERY1 = “Introduzca la palabra clave a buscar…”;
public const string XML_TAG_START1 = “<QueryPacket xmlns=’urn:Microsoft.Search.Query’>”
+ “<Query><SupportedFormats><Format revision=’1′>”
+ “urn:Microsoft.Search.Response.Document:Document</Format>”
+ “</SupportedFormats><Context><QueryText language=’en-US’ type=’STRING’>”;
public const string XML_TAG_START2 = “<QueryPacket xmlns=’urn:Microsoft.Search.Query’>”
+ “<Query><SupportedFormats><Format revision=’1′>”
+ “urn:Microsoft.Search.Response.Document:Document</Format>”
+ “</SupportedFormats><Context><QueryText language=’en-US’ type=’MSSQLFT’>”;
public const string XML_TAG_END = “</QueryText></Context></Query></QueryPacket>”;
public const string QUERY2 = “SELECT Rank, Title, Author, Size, Path, Description” +
” FROM SCOPE() WHERE \”scope\”=’All Sites'”;
public const string QUERY3 = “SELECT Rank, Title, Author, Size, Path, Description” +
” FROM SCOPE() WHERE \”scope\”=’All Sites'” +
” AND Author=’LitwareInc Administrator’ ORDER BY Rank DESC”;
public const string QUERY4 = “SELECT Rank, Title, Author, Size, Path, Description” +
” FROM SCOPE() WHERE \”scope\”=’All Sites'” +
” AND TITLE LIKE ‘Bla%’ ORDER BY Rank DESC”;
public const string QUERY5 = “SELECT Rank, Title, Author, Size, Path, Description” +
” FROM SCOPE() WHERE CONTAINS (‘\”Bla*\”‘)”;
public const string QUERY6 = “SELECT Rank, Title, Author, Size, Path, Description” +
” FROM SCOPE() WHERE \”scope\”=’All Sites'” +
“AND FreeText (‘Bla%’) ORDER BY Rank DESC”;
public const string QUERY7 = “SELECT Rank, Title, Author, Size, Path, Description” +
” FROM SCOPE() WHERE \”scope\”=’All Sites'” +
“AND FreeText (‘Bla% -CRM’) ORDER BY Rank DESC”;
#endregion
|