oledboperhandler.cs

x2webcontrols

using System;

namespace X2Design.Data
{
	/// <summary>
	/// 本对象用与提供对OLEDB数据库的常用访问操作。
	/// </summary>
	public class OleDbOperHandler:DbOperHandler
	{
		/// <summary>
		/// 构造函数，接收一个OLEDB数据库连接对象OleDbConnection
		/// </summary>
		/// <param name="_conn"></param>
		public OleDbOperHandler(System.Data.OleDb.OleDbConnection _conn)
		{
			
			conn=_conn;
			dbType=DatabaseType.OleDb;
			conn.Open();
			cmd=conn.CreateCommand();
			da=new System.Data.OleDb.OleDbDataAdapter();


			
		}

		/// <summary>
		/// 构造函数，接收一个mdb文件
		/// </summary>
		/// <param name="path"></param>
		public OleDbOperHandler(string path)
		{
			conn=new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+path);
			dbType=DatabaseType.OleDb;
			conn.Open();
			cmd=conn.CreateCommand();
			da=new System.Data.OleDb.OleDbDataAdapter();
		}
		/// <summary>
		/// 产生OleDbCommand对象所需的查询参数。
		/// </summary>
		protected override void GenParameters()
		{
			System.Data.OleDb.OleDbCommand oleCmd=(System.Data.OleDb.OleDbCommand)cmd;
			if(this.alFieldItems.Count>0)
			{
				for(int i=0;i<alFieldItems.Count;i++)
				{
					oleCmd.Parameters.Add("@para"+i.ToString(),((DbKeyItem)alFieldItems[i]).fieldValue.ToString());
				}
			}
			
			if(this.alSqlCmdParameters.Count>0)
			{
				for(int i=0;i<this.alSqlCmdParameters.Count;i++)
				{
					oleCmd.Parameters.Add("@spara"+i.ToString(),((DbKeyItem)alSqlCmdParameters[i]).fieldValue.ToString());
				}
			}
			if(this.alConditionParameters.Count>0)
			{
				for(int i=0;i<this.alConditionParameters.Count;i++)
				{
					oleCmd.Parameters.Add("@cpara"+i.ToString(),((DbKeyItem)alConditionParameters[i]).fieldValue.ToString());
				}
			}
		}
		
	}
}