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);
}