Пример #1
0
 public IWhere Contains(IFullTextSearchCondition searchcondition, string language, params string[] columnlist)
 {
     if (!string.IsNullOrEmpty(language))
     {
         this.sql.AppendFormat(" CONTAINS({0},{1},LANGUAGE N'{2}')", Utility.GetListAsString<string>(columnlist.ToList(), ","), searchcondition.ToString(), language);
     }
     else
     {
         this.sql.AppendFormat(" CONTAINS({0},{1})", Utility.GetListAsString<string>(columnlist.ToList(), ","), searchcondition.ToString());
     }
     return this;
 }
Пример #2
0
 public IFrom ContainsTable(string tableName, IFullTextSearchCondition searchcondition, string language, int top_n_byrank, params string[] columnList)
 {
     this.sql.AppendFormat(" CONTAINSTABLE({0},{1},'{2}', LANGUAGE N'{3}',{4})", tableName, Utility.GetListAsString<string>(columnList.ToList(), ","), searchcondition.ToString(), language, top_n_byrank);
     return this;
 }
Пример #3
0
 public IFrom ContainsTable(string tableName, IFullTextSearchCondition searchcondition, params string[] columnList)
 {
     this.sql.AppendFormat(" CONTAINSTABLE({0},{1},{2})", tableName, Utility.GetListAsString<string>(columnList.ToList(), ","), searchcondition.ToString());
     return this;
 }
Пример #4
0
 public string Contains(IFullTextSearchCondition searchcondition, string language, params string[] columnlist)
 {
     return string.Format(" CONTAINS({0},{1},LANGUAGE N'{2}')", Utility.GetListAsString<string>(columnlist.ToList(), ","), searchcondition.ToString(), language);
 }
Пример #5
0
 public IWhere FreeText(IFullTextSearchCondition searchterm, params string[] columnlist)
 {
     this.sql.AppendFormat(" FREETEXT({0},'{1}')", Utility.GetListAsString<string>(columnlist.ToList(), ","), searchterm.ToString());
     return this;
 }