queryparamscollection.cs

来自「一个由VB开发的。NET实体生成器` 提高.net代码质量及开发效率」· CS 代码 · 共 69 行

using System;
using System.Data;
using System.Data.SqlClient;

namespace {namespace}.DataAS
{
    /// <summary>
    /// 检索参数集合
    /// </summary> 
    public class QueryParamsCollection : System.Collections.ArrayList
    {
        public QueryParamsCollection() { }

        /// <summary>
        /// 添加检索参数
        /// </summary>
        /// <param name="value"></param>
        /// <returns></returns>
        public int Add(QueryParameter value)
        {
            return base.Add(value);
        }

        /// <summary>
        /// 移除检索参数
        /// </summary>
        /// <param name="obj"></param>
        public void Remove(QueryParameter obj)
        {
            base.Remove(obj);
        }

        /// <summary>
        /// 获取检索参数对象
        /// </summary>
        /// <param name="index"></param>
        /// <returns></returns>
        public QueryParameter this[int index]
        {
            get
            {
                return (QueryParameter)base[index];
            }
            set
            {
                base[index] = value;
            }
        }

        /// <summary>
        /// 获得 WHERE 结果字符串
        /// </summary>
        /// <returns></returns>
        public override string ToString()
        {
            string result = "";
            if (Count > 0)
                result = " WHERE ";

            for (int i = 0; i < Count; i++)
            {
                result += this[i].ToString();
                if (i < Count - 1)
                    result += " " + this[i].Logic + " ";
            }
            return result;
        }
    }
}