Пример #1
0
        public ExpressionClip SubString(int start, int length)
        {
            ExpressionClip expr = (ExpressionClip)this.Clone();

            expr.Sql = ColumnFormatter.SubString(expr.Sql, start, length);
            return(expr);
        }
Пример #2
0
        public ExpressionClip Avg()
        {
            ExpressionClip expr = (ExpressionClip)this.Clone();

            expr.Sql = ColumnFormatter.Avg(expr.Sql);

            return(expr);
        }
Пример #3
0
        public static ExpressionClip GetCurrentUtcDate()
        {
            ExpressionClip expr = new ExpressionClip();

            expr.Sql    = ColumnFormatter.GetCurrentUtcDate();
            expr.dbType = DbType.DateTime;
            return(expr);
        }
Пример #4
0
        public ExpressionClip ToNumber()
        {
            ExpressionClip expr = (ExpressionClip)this.Clone();

            expr.Sql = ColumnFormatter.ToNumber(expr.Sql);

            return(expr);
        }
Пример #5
0
        public ExpressionClip Count(bool isDistinct)
        {
            ExpressionClip expr = (ExpressionClip)this.Clone();

            expr.Sql    = ColumnFormatter.Count(expr.Sql, isDistinct);
            expr.dbType = DbType.Int32;

            return(expr);
        }
Пример #6
0
        public ExpressionClip GetDay()
        {
            ExpressionClip expr = (ExpressionClip)this.Clone();

            expr.Sql    = ColumnFormatter.DatePart(expr.Sql, ColumnFormatter.DatePartType.Day);
            expr.dbType = DbType.Int32;

            return(expr);
        }