/// <summary>
/// 组合 子查询
/// </summary>
/// <param name="field"></param>
/// <param name="from"></param>
/// <param name="oper"></param>
/// <returns></returns>
private WhereClip subQuery(Field field, LambdaQueryHelper from, QueryOperator oper)
{
return(subQuery(field, from, DataUtils.ToString(oper)));
}
/// <summary>
/// 子查询
/// </summary>
/// <param name="field"></param>
/// <param name="join"></param>
/// <param name="values"></param>
/// <returns></returns>
private WhereClip selectInOrNotIn <T>(Field field, string join, params T[] values)
{
return(selectInOrNotIn <T>(field, join, true, values));
}
/// <summary>
/// 判断字段是否为Null
/// </summary>
/// <param name="field">字段实体</param>
/// <returns></returns>
public Field IsNull(Field field)
{
return(new Field(string.Concat("isnull(", this.TableFieldName, ",", field.TableFieldName, ")")).As(this));
}
/// <summary>
/// ~
/// </summary>
/// <param name="rightField"></param>
/// <returns></returns>
public Field BitwiseNOT(Field rightField)
{
return(createField(this, rightField, QueryOperator.BitwiseNOT).As(this));
}
/// <summary>
/// AS
/// </summary>
/// <param name="field"></param>
/// <returns></returns>
public Field As(Field field)
{
return(As(field.Name));
}
