- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Web;
- using System.Web.UI.WebControls;
- using System.Text;
- /// <summary>
- /// Summary description for Utility
- /// </summary>
- public class Utility
- {
- public Utility()
- {
- //
- // TODO: Add constructor logic here
- //
- }
- public static string SplitStringToKeyword( string inputString)
- {
- char [] splitchars = new char [] { ' ' , ',' , '.' , ';' , ':' , '\t' };
- inputString = inputString.Trim().Replace( '-' , ' ' );
- var words = from word in inputString.Split(splitchars)
- select word;
- bool isprima= false ;
- StringBuilder sb = new StringBuilder();
- foreach (var v in words)
- {
- if (isprima== false ){
- if ((v.Trim()) != "" )
- {
- sb.Append(v);
- isprima = true ;
- }
- }
- else {
- if ((v.Trim()) != "" )
- {
- sb.Append( "," );
- sb.Append(v);
- }
- }
- }
- return sb.ToString();
- }
- public static void LoadSearchTypes( ref DropDownList ddl)
- {
- ddl.Items.Add( new ListItem( "CONTAINS" , "CONTAINS" ));
- ddl.Items.Add( new ListItem( "FREETEXT" , "FREETEXT" ));
- }
- public static string ConvertToContainsTSQL( string inputString)
- {
- char [] splitchars = new char [] { ' ' , ',' , '.' , ';' , ':' , '-' , '\t' };
- inputString = inputString.Trim();
- var words = from word in inputString.Split(splitchars)
- select word;
- bool isprima = false ;
- StringBuilder sb = new StringBuilder();
- bool previousIsAndorOr = false ;
- foreach (var v in words)
- {
- if (isprima == false )
- {
- if ( (v.Trim() != "" ) && (v.ToLower() != "and" ) && (v.ToLower() != "or" ) )
- {
- sb.Append( "\"" );
- sb.Append(v);
- sb.Append( "\"" );
- isprima = true ;
- }
- }
- else
- {
- if ((v.Trim()) != "" )
- {
- if (v.ToLower() == "and" || v.ToLower() == "or" )
- {
- sb.Append( " " );
- sb.Append(v);
- previousIsAndorOr = true ;
- }
- else
- {
- if (previousIsAndorOr == true )
- previousIsAndorOr = false ;
- else
- sb.Append( " or " );
- sb.Append( "\"" );
- sb.Append(v);
- sb.Append( "\"" );
- }
- }
- }
- }
- return sb.ToString();
- }
- }