public void Test_PostSearch() { string key = "ggg+odu"; string[] keys = key.Split('+'); string[] columns = new string[] { "Title", "TitleENG", "HtmlContent", "HtmlContentENG", "HtmlContent2", "HtmlContent2ENG" }; StringBuilder sbHql = new StringBuilder(); //sbHql.Append("WHERE ParentPost.PostId = 4 "); sbHql.Append(string.Format(@"WHERE Flag = {0} AND ShowDate <= '{1}' AND CloseDate >= '{1}' AND ParentPost.ParentPost.ParentPost.PostId = {2} AND {3} ORDER BY SortNo " , 1, DateTime.Today.ToShortDateString(), 4 , ConvertUtil.ConvetSqlLikeStr(keys, columns, "OR"))); //, ConvertUtil.ConvetSqlLikeStr(keys, columns, "OR") //"Title like '%odu%' " IList <PostVO> postList = m_PostService.SearchPostByWhere(sbHql.ToString()); Console.Write("postList count =" + postList.Count); }