paramlist.cs

来自「考试管理系统CS架构 不需更多说明」· CS 代码 · 共 139 行

using System;
using System.Collections;
using System.Data.SqlClient;
using System.Data;
namespace ExamSystem.Common.DB
{
	
	/// <summary>
	/// SqlParameter的列表
	/// </summary>
	public class ParamList
	{
		private ArrayList list;
		public ParamList()
		{
			list=new ArrayList();
		}
		
		public int Count
		{
			get
			{
				return list.Count;
			}

		}
		
		/// <summary>
		/// 创建一个新的SqlParameter并添加到列表
		/// </summary>
		/// <param name="paramName">SqlParameter要映射参数的名字</param>
		/// <param name="type">参数类型</param>
		/// <param name="paramValue">此参数的值</param>
		public void AddNew(string paramName,SqlDbType type,object paramValue)
		{
			SqlParameter newParam=new SqlParameter(paramName,type);
			newParam.Value=paramValue;
			list.Add (newParam);
		}
		
		/// <summary>
		/// 把列表里边的SqlParameter加到SqlCommand里边
		/// </summary>
		/// <param name="comm">要加进去的SqlCommand</param>
		public void Fill(SqlCommand comm)
		{
			for(int i=0;i<list.Count;i++)
			{
				comm.Parameters.Add(list[i]);
			}
		}
		
		/// <summary>
		/// 从ParamList中移除一个匹配的项
		/// </summary>
		/// <param name="param">要从ParamList中移除的项</param>
		public void Remove(SqlParameter param)
		{
			list.Remove(param);
		}

		/// <summary>
		/// 从ParamList中移除指定索引的项
		/// </summary>
		/// <param name="index">要移除项的索引</param>
		public void RemoveAt(int index)
		{
			list.RemoveAt(index);
		}

		/// <summary>
		/// 清空ParamList中的所有元素
		/// </summary>
		public void Clear()
		{
			list.Clear();
		}
		
		/// <summary>
		/// 将元素插入指定索引处
		/// </summary>
		/// <param name="index">从0开始的索引</param>
		/// <param name="param">要插入的值</param>
		public void Insert(int index,SqlParameter param)
		{
			list.Insert(index,param);
		}

		/// <summary>
		/// 为本列表添加一个SqlParameter
		/// </summary>
		/// <param name="value">SqlParameter值</param>
		/// <returns></returns>
		public int Add(SqlParameter param)
		{
			return list.Add (param);
		}
		

		public int BinarySearch(SqlParameter value)
		{
			return list.BinarySearch (value);
		}
		
		public int LastIndexOf(SqlParameter value)
		{
			return list.LastIndexOf (value);
		}
		
		public int LastIndexOf(SqlParameter value, int startIndex)
		{
			return list.LastIndexOf (value, startIndex);
		}
		
		public int LastIndexOf(SqlParameter value, int startIndex, int count)
		{
			return list.LastIndexOf (value, startIndex, count);
		}

		
		/// <summary>
		/// 获取第几个SqlParameter
		/// </summary>
		public SqlParameter this[int index]
		{
			get
			{
				return (SqlParameter)list[index];
			}
			set
			{
				list[index] = value;
			}
		}


	}
}