/// <summary> /// Union 联合查询 /// </summary> /// <typeparam name="K"></typeparam> /// <param name="helper"></param> /// <returns></returns> public TQueryHelper <T> Union <K>(TQueryHelper <K> helper) where K : class { this.helperItem.Union <K>(helper); return(this); }
/// <summary> /// Where Field In 子查询语句 /// </summary> /// <typeparam name="K"></typeparam> /// <typeparam name="P"></typeparam> /// <param name="lambda">Lambda 表达式,例:(p, y)=> y.ID</param> /// <param name="helper"></param> /// <returns></returns> public TQueryHelper <T> WhereIn <K, P>(Expression <Func <K, P, object> > lambda, TQueryHelper <K> helper) where K : class where P : class { this.helperItem.WhereIn <K, P>(lambda, "in", helper); return(this); }
/// <summary> /// Where Field In 子查询语句 /// </summary> /// <typeparam name="K"></typeparam> /// <param name="fieldName">字段名</param> /// <param name="helper"></param> /// <param name="directUseFieldName">是否直接使用 fieldName</param> /// <returns></returns> public TQueryHelper <T> WhereIn <K>(string fieldName, TQueryHelper <K> helper, bool directUseFieldName = false) where K : class { this.helperItem.WhereIn <K>(fieldName, "in", helper, directUseFieldName); return(this); }
/// <summary> /// NotExists 子查询语句 /// </summary> /// <typeparam name="K"></typeparam> /// <param name="helper"></param> /// <returns></returns> public TQueryHelper <T> NotExists <K>(TQueryHelper <K> helper) where K : class { this.helperItem.Exists <K>(helper); return(this); }
/// <summary> /// From In 子查询语句 /// </summary> /// <typeparam name="K"></typeparam> /// <param name="helper"></param> /// <returns></returns> public TQueryHelper <T> FromIn <K>(TQueryHelper <K> helper, string newTableName = null) where K : class { this.helperItem.FromIn <K>(helper, newTableName); return(this); }
/// <summary> /// 查询字段 /// </summary> /// <param name="helper"></param> /// <param name="newFieldName">新的字段名称</param> /// <returns></returns> public TQueryHelper <T> Select <K>(TQueryHelper <K> helper, string newFieldName = null) where K : class { this.helperItem.Select <K>(helper, newFieldName); return(this); }