Query/QueryBuilder.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
 * Author: Kishore Reddy
 * Url: http://commonlibrarynet.codeplex.com/
 * Title: CommonLibrary.NET
 * Copyright: � 2009 Kishore Reddy
 * License: LGPL License
 * LicenseUrl: http://commonlibrarynet.codeplex.com/license
 * Description: A C# based .NET 3.5 Open-Source collection of reusable components.
 * Usage: Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ComLib.Data
{
    /// <summary>
    /// This class implements a query builder
    /// that can generate Sql output.
    /// </summary>
    public class QueryBuilderSql : IQueryBuilder
    {
        /// <summary>
        /// True to surround fields with surround chars.
        /// </summary>
        protected bool _surroundFields;


        /// <summary>
        /// Left surround char.
        /// </summary>
        protected string _surroundFieldLeftChar = "[";


        /// <summary>
        /// Right surround char.
        /// </summary>
        protected string _surroundFieldRightChar = "]";

        private IQuery _criteria;
        private static IDictionary<string, bool> _reservedWords = new Dictionary<string, bool>();


        /// <summary>
        /// Static initializer.
        /// </summary>
        static QueryBuilderSql()
        {
            _reservedWords["name"] = true;
            _reservedWords["group"] = true;
            _reservedWords["year"] = true;
            _reservedWords["month"] = true;
            _reservedWords["key"] = true;
        }