internal override string CreateSqlString(CommandFactory factory, bool isFullName, CreateSqlState state)
 {
     if (state.UseFieldAlias)
     {
         return(factory.CreateDataFieldSql(_aggregateName));
     }
     else
     {
         return(_fieldInfo.CreateSqlString(factory, isFullName, state));
     }
 }
        internal override string CreateSqlString(CommandFactory factory, bool isFullName, CreateSqlState state)
        {
            var sql = state.GetDataSql(this, isFullName);

            if (sql != null)
            {
                return(sql);
            }

            var tableName   = factory.CreateDataTableMappingSql(TableMapping, state);
            var selectField = _selectField.CreateSqlString(factory, true, state);

            var field = _field.CreateSqlString(factory, isFullName, state);

            string query = null;

            if (_expression != null)
            {
                query = _expression.CreateSqlString(factory, true, state);
            }

            sql = factory.CreateSubQuerySql(field, _predicate, selectField, tableName, query);

            state.SetDataSql(this, isFullName, sql);
            return(sql);
        }
示例#3
0
        public string CreateAliasDataFieldSql(CommandFactory factory, bool isFullName, CreateSqlState state)
        {
            string fieldSql = _fieldInfo.CreateSqlString(factory, isFullName, state);
            string sql      = factory.CreateAliasFieldSql(fieldSql, FieldName);

            return(sql);
        }
示例#4
0
        internal override string CreateSqlString(CommandFactory factory, bool isFullName, CreateSqlState state)
        {
            string sql = state.GetDataSql(this, isFullName);

            if (sql != null)
            {
                return(sql);
            }

            string tableName   = factory.CreateDataTableMappingSql(TableMapping, state);
            string selectField = _selectField.CreateSqlString(factory, true, state);

            string field = _field.CreateSqlString(factory, isFullName, state);

            string query = null;

            if (_expression != null)
            {
                query = _expression.CreateSqlString(factory, true, state);
            }
            QueryCollectionPredicate op = _isTrue ? QueryCollectionPredicate.In : QueryCollectionPredicate.NotIn;

            sql = factory.CreateSubQuerySql(field, op, selectField, tableName, query);

            state.SetDataSql(this, isFullName, sql);
            return(sql);
        }
示例#5
0
        /// <summary>
        /// Creates the sql string.
        /// </summary>
        /// <returns>The sql string.</returns>
        /// <param name="factory">Factory.</param>
        /// <param name="isFullName">If set to <c>true</c> is full name.</param>
        /// <param name="state">State.</param>
        internal override string CreateSqlString(CommandFactory factory, bool isFullName, CreateSqlState state)
        {
            var leftFieldSql  = leftField.CreateSqlString(factory, true, state);
            var rightFieldSql = rightField.CreateSqlString(factory, true, state);
            var sql           = factory.CreateJoinOnMatchSql(leftFieldSql, predicate, rightFieldSql);

            return(sql);
        }
        internal override string CreateSqlString(CommandFactory factory, bool isFullName, CreateSqlState state)
        {
            string sql = state.GetDataSql(this, isFullName);

            if (sql != null)
            {
                return(sql);
            }

            string field = _baseFieldInfo.CreateSqlString(factory, isFullName, state);

            switch (_part)
            {
            case DatePart.Year:
                sql = factory.CreateYearSql(field);
                break;

            case DatePart.Month:
                sql = factory.CreateMonthSql(field);
                break;

            case DatePart.Day:
                sql = factory.CreateDaySql(field);
                break;

            case DatePart.Hour:
                sql = factory.CreateHourSql(field);
                break;

            case DatePart.Minute:
                sql = factory.CreateMinuteSql(field);
                break;

            case DatePart.Second:
                sql = factory.CreateSecondSql(field);
                break;

            case DatePart.Week:
                sql = factory.CreateWeekSql(field);
                break;

            case DatePart.DayOfWeek:
                sql = factory.CreateWeekDaySql(field);
                break;

            case DatePart.DayOfYear:
                sql = factory.CreateYearDaySql(field);
                break;
            }

            state.SetDataSql(this, isFullName, sql);
            return(sql);
        }
        internal override string CreateSqlString(CommandFactory factory, bool isFullName, CreateSqlState state)
        {
            string sql = state.GetDataSql(this, isFullName);

            if (sql != null)
            {
                return(sql);
            }

            sql = _baseFieldInfo.CreateSqlString(factory, isFullName, state);
            sql = factory.CreateNotSql(sql);

            state.SetDataSql(this, isFullName, sql);
            return(sql);
        }
        internal override string CreateSqlString(CommandFactory factory, bool isFullName, CreateSqlState state)
        {
            var sql = state.GetDataSql(this, isFullName);

            if (sql != null)
            {
                return(sql);
            }
            object obj = _baseFieldInfo.CreateSqlString(factory, isFullName, state);

            sql = factory.CreateNullQuerySql(obj, _isNull);

            state.SetDataSql(this, isFullName, sql);
            return(sql);
        }
示例#9
0
        internal override string CreateSqlString(CommandFactory factory, bool isFullName, CreateSqlState state)
        {
            var sql = state.GetDataSql(this, isFullName);

            if (sql != null)
            {
                return(sql);
            }

            var field = _baseFieldInfo.CreateSqlString(factory, isFullName, state);

            sql = factory.CreateDateTimeFormatSql(field, _format);
            state.SetDataSql(this, isFullName, sql);
            return(sql);
        }
        internal override string CreateSqlString(CommandFactory factory, bool isFullName, CreateSqlState state)
        {
            var sql = state.GetDataSql(this, isFullName);

            if (sql != null)
            {
                return(sql);
            }

            var field = _baseFieldInfo.CreateSqlString(factory, isFullName, state);

            switch (_type)
            {
            case AggregateType.COUNT:
                sql = factory.CreateCountSql(field, _distinct);
                break;

            case AggregateType.SUM:
                sql = factory.CreateSumSql(field, _distinct);
                break;

            case AggregateType.AVG:
                sql = factory.CreateAvgSql(field, _distinct);
                break;

            case AggregateType.MAX:
                sql = factory.CreateMaxSql(field);
                break;

            case AggregateType.MIN:
                sql = factory.CreateMinSql(field);
                break;
            }

            state.SetDataSql(this, isFullName, sql);
            return(sql);
        }
        internal override string CreateSqlString(CommandFactory factory, bool isFullName, CreateSqlState state)
        {
            var fieldSql = _fieldInfo.CreateSqlString(factory, isFullName, state);

            return(factory.CreateOrderBySql(fieldSql, _orderType));
        }