myoledbparamcollection.cs

来自「该项目中对 SQLHelper 类进行了简单封装」· CS 代码 · 共 146 行

/* 
 * MyOleDbParamCollection.cs @Microsoft Visual Studio 2005 <.NET Framework 2.0>
 * AfritXia
 * 2007-07-05
 * 
 * Copyright(c) http://www.AfritXia.NET/
 * 
 */

using System;
using System.Data;
using System.Data.OleDb;

using NET.AfritXia.DBUtility;

namespace NET.AfritXia.MyHome.DBTask.Access2000
{
	/// <summary>
	/// 自定义 SQL 参数集合
	/// </summary>
	public sealed class MyOleDbParamCollection
	{
		// 参数集合
		DbParamCollection<OleDbParameter, OleDbType> m_parameters = new DbParamCollection<OleDbParameter,OleDbType>();

		#region 类 MyOleDbParamCollection 构造器
		/// <summary>
		/// 类 MyOleDbParamCollection 默认构造器
		/// </summary>
		public MyOleDbParamCollection()
			: base()
		{
		}
		#endregion

		/// <summary>
		/// 添加新的查询参数到集合中
		/// </summary>
		/// <param name="sqlParam">OleDb 查询参数对象</param>
		public void Add(OleDbParameter parameter)
		{
			this.m_parameters.Add(parameter);
		}

		/// <summary>
		/// 添加新的查询参数到集合
		/// </summary>
		/// <param name="paramName">参数名称</param>
		/// <param name="dbType">数据类型</param>
		/// <param name="size">大小</param>
		/// <param name="direction">参数方向</param>
		/// <returns>OleDbParameter 对象实例</returns>
		public OleDbParameter Add(string paramName, OleDbType dbType, int size, ParameterDirection direction)
		{
			// 建立参数对象
			OleDbParameter param = new OleDbParameter(paramName, dbType, size);
			// 设置参数方向
			param.Direction = direction;

			// 添加参数到集合
			this.m_parameters.Add(param);

			return param;
		}

		/// <summary>
		/// 添加新的查询参数到集合
		/// </summary>
		/// <param name="paramName">参数名称</param>
		/// <param name="dbType">数据类型</param>
		/// <param name="size">大小</param>
		/// <returns>OleDbParameter 对象实例</returns>
		public OleDbParameter Add(string paramName, OleDbType dbType, int size)
		{
			OleDbParameter param = new OleDbParameter(paramName, dbType, size);

			// 添加参数到集合
			this.m_parameters.Add(param);

			return param;
		}

		/// <summary>
		/// 添加新的查询参数到集合
		/// </summary>
		/// <param name="paramName">参数名称</param>
		/// <param name="dbType">数据类型</param>
		/// <returns>OleDbParameter 对象实例</returns>
		public OleDbParameter Add(string paramName, OleDbType dbType)
		{
			OleDbParameter param = new OleDbParameter(paramName, dbType);

			// 添加参数到集合
			this.m_parameters.Add(param);

			return param;
		}

		/// <summary>
		/// 添加新的查询参数到集合
		/// </summary>
		/// <param name="paramName">参数名称</param>
		/// <param name="value">参数值</param>
		/// <returns>OleDbParameter 对象实例</returns>
		public OleDbParameter Add(string paramName, object value)
		{
			OleDbParameter param = new OleDbParameter(paramName, value);

			// 添加参数到集合
			this.m_parameters.Add(param);

			return param;
		}

		/// <summary>
		/// 通过索引器获取查询参数
		/// </summary>
		public OleDbParameter this[int index]
		{
			get
			{
				return this.m_parameters[index];
			}
		}

		/// <summary>
		/// 通过索引器获取查询参数
		/// </summary>
		public OleDbParameter this[string parameterName]
		{
			get
			{
				return this.m_parameters[parameterName];
			}
		}

		/// <summary>
		/// 将集合转换成数组
		/// </summary>
		/// <returns>OleDbParameter 数组</returns>
		public OleDbParameter[] ToArray()
		{
			return this.m_parameters.ToArray();
		}
	}
}