DBHerpler.cs

using System;
using System.Data;
using System.Data.Common;
using System.Configuration;

       public class DbHelper
        {
               private static string dbProviderName= ConfigurationManager.AppSettings["DbHelperProvider"];
               private static string dbConnectionString= ConfigurationManager.AppSettings["DbHelperConnectionString"];

               private DbConnection connection;
               public DbHelper()
                {
                   this.connection= CreateConnection(DbHelper.dbConnectionString);
                }
               public DbHelper(string connectionString)
                {
                   this.connection= CreateConnection(connectionString);
                }
               public static DbConnection CreateConnection()
                {
                    DbProviderFactory dbfactory= DbProviderFactories.GetFactory(DbHelper.dbProviderName);
                    DbConnection dbconn= dbfactory.CreateConnection();
                    dbconn.ConnectionString= DbHelper.dbConnectionString;
                   return dbconn;
                }
               public static DbConnection CreateConnection(string connectionString)
                {
                    DbProviderFactory dbfactory= DbProviderFactories.GetFactory(DbHelper.dbProviderName);
                    DbConnection dbconn= dbfactory.CreateConnection();
                    dbconn.ConnectionString= connectionString;
                   return dbconn;
                }
               /// <summary>
               /// 执行的存储过程
                /// </summary>
               /// <param name="storedProcedure"></param>
               /// <returns></returns>
               public DbCommand GetStoredProcCommond(string storedProcedure)
                {
                    DbCommand dbCommand= connection.CreateCommand();
                    dbCommand.CommandText= storedProcedure;
                    dbCommand.CommandType= CommandType.StoredProcedure;
                   return dbCommand;
                }
               /// <summary>
               /// 执行的sql语句
                /// </summary>
               /// <param name="sqlQuery"></param>
               /// <returns></returns>
               public DbCommand GetSqlStringCommond(string sqlQuery)
                {
                    DbCommand dbCommand= connection.CreateCommand();
                    dbCommand.CommandText= sqlQuery;
                    dbCommand.CommandType= CommandType.Text;
                   return dbCommand;
                }

               //增加参数#region 增加参数
                public void AddParameterCollection(DbCommand cmd, DbParameterCollection dbParameterCollection)
                {
                   foreach (DbParameter dbParameterin dbParameterCollection)
                    {
                        cmd.Parameters.Add(dbParameter);
                    }
                }
               /// <summary>
               /// 增加输出参数 适用于存储过程
                /// </summary>
               /// <param name="cmd">cmd对象</param>
               /// <param name="parameterName">参数名</param>
               /// <param name="dbType">参数类型</param>
               /// <param name="size">参数大小</param>
               public void AddOutParameter(DbCommand cmd,string parameterName, DbType dbType,int size)
                {
                    DbParameter dbParameter= cmd.CreateParameter();
                    dbParameter.DbType= dbType;
                    dbParameter.ParameterName= parameterName;
                    dbParameter.Size= size;
                    dbParameter.Direction= ParameterDirection.Output;
                    cmd.Parameters.Add(dbParameter);
                }
               /// <summary>
               /// 增加参数列表
                /// </summary>
               /// <param name="cmd">CMD对象</param>
               /// <param name="parameterName">参数名</param>
               /// <param name="dbType">参数类型</param>
               /// <param name="value">参数值</param>
               public void AddInParameter(DbCommand cmd,string parameterName, DbType dbType,object value)
                {
                    DbParameter dbParameter= cmd.CreateParameter();
                    dbParameter.DbType= dbType;
                    dbParameter.ParameterName= parameterName;
                    dbParameter.Value= value;
                    dbParameter.Direction= ParameterDirection.Input;
                    cmd.Parameters.Add(dbParameter);
                }
               /// <summary>
               /// 增加返回参数 适用于存储过程
                /// </summary>
               /// <param name="cmd"></param>
               /// <param name="parameterName"></param>
               /// <param name="dbType"></param>
               public void AddReturnParameter(DbCommand cmd,string parameterName, DbType dbType)
                {
                    DbParameter dbParameter= cmd.CreateParameter();
                    dbParameter.DbType= dbType;
                    dbParameter.ParameterName= parameterName;
                    dbParameter.Direction= ParameterDirection.ReturnValue;
                    cmd.Parameters.Add(dbParameter);
                }
               public DbParameter GetParameter(DbCommand cmd,string parameterName)
                {
                   return cmd.Parameters[parameterName];
                }

   
        }