asp.net multi-field Fuzzy query code _ Practical skills

String Strfield = "Id|classname|classadd";
String strkeywords = This.tbxKeyWords.Text.Trim ();
String strSQL = Dbexe.searchtext ("SELECT * from Class", Strfield, Strkeywords);
Multiple-field fuzzy queries are often used, and the above functions can be implemented, for example, when the Strkeywords value is "cloud-dwelling community", you can output:
SELECT * from class where ID like '% cloud habitat Community% ' or className like '% cloud habitat Community% ' or classadd like '% cloud habitat Community '
Function:
<summary>
Implement multi-field fuzzy query based on key words
</summary>
<param name= "Sqlstr" >select * from Talbe SQL statements </param>
<param name= "SQLText" > Judgment Statement Condition, is a separate string </param>
<param name= "keywords" > keywords </param>
public static string SearchText (String strSQL, string Strfield, String keywords)
{
StringBuilder sb = new StringBuilder (strSQL);
if (Strfield!= string. Empty)
{
Sb. Append ("where");
string[] Arrkey = strfield.split (' | ');
for (int i = 0; i < arrkey.length; i++)
{
Sb. Append (Arrkey[i] + "like '%" + keywords + "% ' or");
}
String str = sb. ToString ();

Remove the last "or"
if (str. IndexOf ("or") >= 0)
{
Return str. Remove (str. LastIndexOf ("or"));
}
return str;
}
return strSQL;

}