数据库操作代码

引子：

#region 获取连接字符串
  /// <summary>
  /// 获取连接字符串:从XML文件中获取
  /// </summary>
  /// <returns></returns>
  public static string GetConnectionString()
  {
   if (connectionString=="")
   {
    XmlDocument doc = new XmlDocument();
    doc.Load(BrainSoft.Common.Global.SystemConfigFile);

    //private const string _SystemConfigFile = "SystemConfig.xml";
    XmlNode nod = doc.SelectSingleNode("configuration/ConnectionString");
    connectionString = nod.Attributes["sqlvalue"].Value;
   }
   return connectionString;
  }

  #endregion

<configuration>
 <!--连接字符串 -->
 <ConnectionString sqlvalue="database=FMIS;server=.;uid=sa;pwd=sa"/>

//——————————————————————————————————————

using System;
using System.Data;
using System.Xml;
using System.Data.SqlClient;

namespace BrainSoft.Common
{
 /// <summary>
 /// 描    述:对 SQL Server 数据库执行操作 进行封装，对外提供接品操作
 /// 参数说明:
 /// 说    明:
 /// 创 建 人:thanktheworld

 /// 日    期:now

 /// </summary>
 public class Execute
 {
  #region 定义变量
  private static string connectionString="";
  #endregion

  #region 获取连接字符串
  /// <summary>
  /// 获取连接字符串
  /// </summary>
  /// <returns></returns>
  public static string GetConnectionString()
  {
   if (connectionString=="")
   {
    XmlDocument doc = new XmlDocument();
    doc.Load(BrainSoft.Common.Global.SystemConfigFile);
    XmlNode nod = doc.SelectSingleNode("configuration/ConnectionString");
    connectionString = nod.Attributes["sqlvalue"].Value;
   }
   return connectionString;
  }

  #endregion

        #region 打开连接字符串
        /// <summary>
        /// 打开连接字符串
        /// </summary>
        /// <returns></returns>
        public static SqlConnection  OpenConnection()
        {
            SqlConnection connection=new SqlConnection(GetConnectionString());
            connection.Open();
            return connection;
        }
        #endregion

  #region 执行SQL 文本命令返回 int
  /// <summary>
  /// 执行SQL 文本命令返回 int
  /// </summary>
  /// <param name="commandText">Sql语句</param>
  /// <returns>返回int</returns>
  public static int ExecuteNonQuery(string commandText)
  {
   string connectionString = GetConnectionString();
   return SqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, commandText);
  }
  #endregion

  #region 执行SQL 文本命令返回 DataSet
  /// <summary>
  /// 执行SQL 文本命令返回 DataSet
  /// </summary>
  /// <param name="commandText">Sql语句</param>
  /// <returns>返回DataSet</returns>
  public static DataSet ExecuteDataset(string commandText)
  {
   string connectionString = GetConnectionString();
   return SqlHelper.ExecuteDataset(connectionString, CommandType.Text, commandText);
  }
  #endregion

  #region 执行SQL 文本命令返回 DataTable
  /// <summary>
  /// 执行SQL 文本命令返回 DataTable
  /// </summary>
  /// <param name="commandText">Sql语句</param>
  /// <returns>返回DataTable</returns>
  public static DataTable ExecuteDataTable(string commandText)
  {
   string connectionString = GetConnectionString();
   DataSet ds=SqlHelper.ExecuteDataset(connectionString, CommandType.Text, commandText);
   return ds.Tables[0];
  }
  #endregion

  #region 执行存储过程返回 int
  /// <summary>
  /// 执行存储过程返回 int
  /// </summary>
  /// <param name="commandProcedureName">Sql语句</param>
  /// <param name="commandParameters">存储过程参数</param>
  /// <returns>返回int</returns>
  public static int ExecuteProcNonQuery(string commandProcedureName, ref SqlParameter[] commandParameters)
  {
   string connectionString = GetConnectionString();
   return SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, commandProcedureName, commandParameters);
  }
  #endregion

  #region 执行存储过程返回 DataSet
  /// <summary>
  /// 执行存储过程返回 DataSet
  /// </summary>
  /// <param name="commandProcedureName">Sql语句</param>
  /// <param name="commandParameters">存储过程参数</param>
  /// <returns>返回DataSet</returns>
  public static DataSet ExecuteProcDataset(string commandProcedureName, ref SqlParameter[] commandParameters)
  {
   string connectionString = GetConnectionString();
   return SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, commandProcedureName, commandParameters);
  }
  #endregion

  #region 执行存储过程返回 DataTable
  /// <summary>
  /// 执行存储过程返回 DataTable
  /// </summary>
  /// <param name="commandProcedureName">Sql语句</param>
  /// <param name="commandParameters">存储过程参数</param>
  /// <returns>返回DataSet</returns>
  public static DataTable ExecuteProcDataTable(string commandProcedureName, ref SqlParameter[] commandParameters)
  {
   string connectionString = GetConnectionString();
   DataSet ds=SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, commandProcedureName, commandParameters);
   return ds.Tables[0];
  }
  #endregion

        #region 执行SQL 文本命令返回(带事务) int
        /// <summary>
        /// 执行SQL 文本命令返回(带事务) int
        /// </summary>
        /// <param name="commandText">Sql语句</param>
        /// <returns>返回int</returns>
        public static int ExecuteNonQuery(SqlTransaction transaction,string commandText)
        {
            return SqlHelper.ExecuteNonQuery(transaction, CommandType.Text, commandText);
        }
        #endregion

        #region 执行SQL 文本命令返回(带事务) DataSet
        /// <summary>
        /// 执行SQL 文本命令返回(带事务) DataSet
        /// </summary>
        /// <param name="commandText">Sql语句</param>
        /// <returns>返回DataSet</returns>
        public static DataSet ExecuteDataset(SqlTransaction transaction,string commandText)
        {
            return SqlHelper.ExecuteDataset(transaction, CommandType.Text, commandText);
        }
        #endregion

        #region 执行SQL 文本命令返回(带事务) DataTable
        /// <summary>
        /// 执行SQL 文本命令返回(带事务) DataTable
        /// </summary>
        /// <param name="commandText">Sql语句</param>
        /// <returns>返回DataTable</returns>
        public static DataTable ExecuteDataTable(SqlTransaction transaction,string commandText)
        {
            DataSet ds=SqlHelper.ExecuteDataset(transaction, CommandType.Text, commandText);
            return ds.Tables[0];
        }
        #endregion

        #region 执行存储过程返回(带事务) int
        /// <summary>
        /// 执行存储过程返回(带事务) int
        /// </summary>
        /// <param name="commandProcedureName">Sql语句</param>
        /// <param name="commandParameters">存储过程参数</param>
        /// <returns>返回int</returns>
        public static int ExecuteProcNonQuery(SqlTransaction transaction,string commandProcedureName, ref SqlParameter[] commandParameters)
        {
            return SqlHelper.ExecuteNonQuery(transaction, CommandType.StoredProcedure, commandProcedureName, commandParameters);
        }
        #endregion

        #region 执行存储过程返回(带事务) DataSet
        /// <summary>
        /// 执行存储过程返回(带事务) DataSet
        /// </summary>
        /// <param name="commandProcedureName">Sql语句</param>
        /// <param name="commandParameters">存储过程参数</param>
        /// <returns>返回DataSet</returns>
        public static DataSet ExecuteProcDataset(SqlTransaction transaction,string commandProcedureName, ref SqlParameter[] commandParameters)
        {
            return SqlHelper.ExecuteDataset(transaction, CommandType.StoredProcedure, commandProcedureName, commandParameters);
        }
        #endregion

        #region 执行存储过程返回(带事务) DataTable
        /// <summary>
        /// 执行存储过程返回(带事务) DataTable
        /// </summary>
        /// <param name="commandProcedureName">Sql语句</param>
        /// <param name="commandParameters">存储过程参数</param>
        /// <returns>返回DataSet</returns>
        public static DataTable ExecuteProcDataTable(SqlTransaction transaction,string commandProcedureName, ref SqlParameter[] commandParameters)
        {
            DataSet ds=SqlHelper.ExecuteDataset(transaction, CommandType.StoredProcedure, commandProcedureName, commandParameters);
            return ds.Tables[0];
        }
        #endregion

 }
}