Esempio n. 1
0
        public ISQLinqResult ToSQL(int existingParameterCount = 0, string parameterNamePrefix = SqlExpressionCompiler.DefaultParameterNamePrefix)
        {
            var paramCount = existingParameterCount;

            var result = new SQLinqIfResult
            {
                Operator = this.Operator
            };

            if (this.If is string)
            {
                result.If = this.If as string;
            }
            else
            {
                var ifResult = ((ISQLinq)this.If).ToSQL(paramCount, parameterNamePrefix);
                result.If = ifResult.ToQuery();

                foreach (var p in ifResult.Parameters)
                {
                    result.Parameters.Add(p);
                }

                paramCount = existingParameterCount + result.Parameters.Count;
            }

            if (this.Then != null)
            {
                var thenResult = this.Then.ToSQL(paramCount, parameterNamePrefix);
                result.Then = thenResult.ToQuery();

                foreach (var p in thenResult.Parameters)
                {
                    result.Parameters.Add(p);

                }
                paramCount = existingParameterCount + result.Parameters.Count;
            }

            if (this.Else != null)
            {
                var elseResult = this.Else.ToSQL(paramCount, parameterNamePrefix);
                result.Else = elseResult.ToQuery();

                foreach (var p in elseResult.Parameters)
                {
                    result.Parameters.Add(p);
                }
            }

            return result;
        }
Esempio n. 2
0
        public ISQLinqResult ToSQL(int existingParameterCount = 0, string parameterNamePrefix = SqlExpressionCompiler.DefaultParameterNamePrefix)
        {
            var paramCount = existingParameterCount;

            var result = new SQLinqIfResult
            {
                Operator = this.Operator
            };

            if (this.If is string)
            {
                result.If = this.If as string;
            }
            else
            {
                var ifResult = ((ISQLinq)this.If).ToSQL(paramCount, parameterNamePrefix);
                result.If = ifResult.ToQuery();

                foreach (var p in ifResult.Parameters)
                {
                    result.Parameters.Add(p);
                }

                paramCount = existingParameterCount + result.Parameters.Count;
            }

            if (this.Then != null)
            {
                var thenResult = this.Then.ToSQL(paramCount, parameterNamePrefix);
                result.Then = thenResult.ToQuery();

                foreach (var p in thenResult.Parameters)
                {
                    result.Parameters.Add(p);
                }
                paramCount = existingParameterCount + result.Parameters.Count;
            }

            if (this.Else != null)
            {
                var elseResult = this.Else.ToSQL(paramCount, parameterNamePrefix);
                result.Else = elseResult.ToQuery();

                foreach (var p in elseResult.Parameters)
                {
                    result.Parameters.Add(p);
                }
            }

            return(result);
        }