public ExpressionClip SubString(int start, int length)
{
ExpressionClip expr = ExpressionFactory.CreateCloneExpression(this);
expr.Sql = ColumnFormatter.SubString(this.Sql, start, length);
return(expr);
}
public ExpressionClip Avg()
{
ExpressionClip expr = ExpressionFactory.CreateCloneExpression(this);
expr.Sql = ColumnFormatter.Avg(this.Sql);
return(expr);
}
public static ExpressionClip GetCurrentDate()
{
ExpressionClip expr = new ExpressionClip();
expr.Sql = ColumnFormatter.GetCurrentDate();
expr.dbType = DbType.DateTime;
return(expr);
}
public ExpressionClip Count(bool isDistinct)
{
ExpressionClip expr = ExpressionFactory.CreateCloneExpression(this);
expr.Sql = ColumnFormatter.Count(this.Sql, isDistinct);
expr.dbType = DbType.Int32;
return(expr);
}
public ExpressionClip GetDay()
{
ExpressionClip expr = ExpressionFactory.CreateCloneExpression(this);
expr.Sql = ColumnFormatter.DatePart(this.Sql, ColumnFormatter.DatePartType.Day);
expr.dbType = DbType.Int32;
return(expr);
}
