/// <summary>
/// IN操作
/// </summary>
/// <param name="right"></param>
/// <returns></returns>
public Formula NotIn(ISqlStringable right)
{
return(new Formula(this, "NOT IN", right)
{
IsComplicated = true
});
}
/// <summary>
/// 对象实例化
/// </summary>
/// <param name="left"></param>
/// <param name="opt"></param>
/// <param name="right"></param>
public Formula(ISqlStringable left, string opt, ISqlStringable right)
{
_left = left;
_operator = opt;
_right = right;
this.IsComplicated = false;
}
/// <summary>
/// 对象实例化
/// </summary>
/// <param name="obj"></param>
public Avg(ISqlStringable obj) : base("AVG")
{
_object = obj;
}
/// <summary>
/// 对象实例化
/// </summary>
/// <param name="obj"></param>
public Min(ISqlStringable obj) : base("MIN")
{
_object = obj;
}
/// <summary>
/// IN操作
/// </summary>
/// <param name="right"></param>
/// <returns></returns>
public Formula NotIn(ISqlStringable right)
{
return(new Formula(this, "NOT IN", right));
}
/// <summary>
/// 对象实例化
/// </summary>
/// <param name="obj"></param>
public Max(ISqlStringable obj) : base("MAX")
{
_object = obj;
}
/// <summary>
/// 对象实例化
/// </summary>
/// <param name="obj"></param>
public Count(ISqlStringable obj) : base("COUNT")
{
_object = obj;
}
/// <summary>
/// 对象实例化
/// </summary>
/// <param name="obj"></param>
/// <param name="name"></param>
public As(ISqlStringable obj, string name)
{
_object = obj;
_name = name;
}
/// <summary>
/// 对象实例化
/// </summary>
/// <param name="obj"></param>
public Sum(ISqlStringable obj) : base("SUM")
{
_object = obj;
}
/// <summary>
/// 对象实例化
/// </summary>
/// <param name="obj"></param>
/// <param name="sort"></param>
public SelectOrder(ISqlStringable obj, string sort)
{
_object = obj;
_sort = sort;
}
/// <summary>
/// 设置升序条件
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public Select Asc(ISqlStringable obj)
{
_order.Add(new SqlUnits.SelectOrder(obj, "ASC"));
return(this);
}
