protected string keywords(string keyWord)
    {
        if (keyWord != null & keyWord != "")
        {
            string strKeyword = keyWord.Replace("'", "''");
            string strTemp = "";
            string strSubQuery = " and";
            string[] KeywordArray;
            KeywordArray = strKeyword.Split(null);

            if (KeywordArray.Length < 2)
            {
                strSubQuery += " ProductName like '%" + strKeyword + "%'";
            }
            else
            {
                strTemp = "";
                for (int i = 0; i < KeywordArray.Length; i++)
                {
                    strTemp += " ProductName like '%" + KeywordArray[i] + "%' or";
                }
                strTemp = strTemp.TrimEnd(new char[] ...{ 'o', 'r' });a
                strSubQuery += strTemp;
            }
            return strSubQuery;
        }
        return null;
    } 搜索关键字生成模糊查询条件 以空格分隔2个关键字