paramlist.cs

考试管理系统考试管理系统考试管理系统考试管理系统考试管理系统考试管理系统考试管理系统考试管理系统

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;
			}
		}


	}
}