Exemplo n.º 1
0
        /// <summary>
        /// Gets the SQL filter compatible with the SQL database engine.
        /// </summary>
        /// <param name="UseParameters">Replaces strings entered with parameters (Use GetParameters() to get the filled parameters)</param>
        /// <returns>The SQL filter string</returns>
        public SQLDATA GetSQLFilter(bool UseParameters)
        {
            _useParams = UseParameters;
            _params = new Dictionary<string, string>();
            _groupClauseStack = new Stack<string>();

            StringBuilder sqlQuery = new StringBuilder();
            BuildSQL(sqlQuery, _head);

            SQLDATA ret = new SQLDATA();
            ret.Filters = sqlQuery.ToString();

            // Make a copy so the internal reference isnt tainted
            if (_useParams)
                ret.Parameters = new Dictionary<string, string>(_params);
        
            return ret;
        }
Exemplo n.º 2
0
 public string GetSQLFilter()
 {
     SQLDATA ret = GetSQLFilter(false);
     return ret.Filters;
 }