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