oracleprovider.cs

此项目是用asp.net开发的航班查询系统

using System;
using System.Collections;
using System.Data;
using System.Data.OracleClient;
namespace OceanSoft.Data
{
	/// <summary>
	/// 通用数据访问接口的 Oracle 实现类
	/// </summary>
	internal class OracleProvider:DefaultProvider
	{
        /// <summary>
        /// Oracle实现的构造函数
        /// </summary>
        /// <param name="ConnString">连接字符串</param>
        public OracleProvider(string ConnString)
		{
			this.Conn=new OracleConnection(ConnString);
		}

        /// <summary>
        /// 得到空数据适配对象
        /// </summary>
        /// <returns>基于Oracle的适配器对象</returns>
        public override IDbDataAdapter GetNullDataAdapter()
		{
			return new OracleDataAdapter();
		}

        protected override void FillTable(IDbDataAdapter da, DataTable mDataTable)
        {
            ((OracleDataAdapter)da).Fill(mDataTable);
        }

        protected override int GetReturnValue()
        {
            return (int)((OracleCommand)this.Cmd).Parameters["returnValue"].Value;
        }

        protected override void SetParams()
		{
            this.Cmd.Parameters.Clear();
			IDictionaryEnumerator pParams=this.CommandParams.GetEnumerator();

			while(pParams.MoveNext())
				((OracleCommand)this.Cmd).Parameters.Add(pParams.Key.ToString(),pParams.Value);

            OracleParameter par = new OracleParameter();
            par.ParameterName = "returnValue";
            par.Direction = ParameterDirection.ReturnValue;
            ((OracleCommand)this.Cmd).Parameters.Add(par);
        }
	}
}