using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Configuration;using System.Data.SqlClient;using System.Data;namespace test{    /// <summary>    /// 封装对数据库的操作    /// </summary>    public sealed class SQLServerDALHelper    {        private static string sqlConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;        ///<summary>        ///执行sql语句        ///</summary>        ///<param name="sql">sql语句</param>        public static void ExecuteSQLNonQurey(string sql)        {            SqlConnection connection = new SqlConnection(sqlConnectionString);            connection.Open();            SqlCommand command = new SqlCommand(sql,connection);            command.ExecuteNonQuery();            connection.Close();        }        ///<summary>        ///执行sql语句返回的DataReader        ///</summary>        ///<param name="sql">sql语句</param>        ///<returns>datareader</returns>        public static SqlDataReader ExecteSQlReader( string sql)        {            SqlConnection connection = new SqlConnection(sqlConnectionString);            connection.Open();            SqlCommand command = new SqlCommand(sql,connection);            SqlDataReader sqlReader = command.ExecuteReader();            return sqlReader;        }        ///<summary>        ///执行存储过程        ///</summary>        ///<param name="storedProcedureName">存储过程名称</param>        ///<param name="parameters">无返回值类型</param>        public static void ExecuteProcedureNonQuery(string storedProcedureName, IDataParameter[] parameters)        {            SqlConnection connection = new SqlConnection(sqlConnectionString);            connection.Open();            SqlCommand command = new SqlCommand(storedProcedureName,connection);            command.CommandType =CommandType.StoredProcedure;            //command.Connection = connection;            if (parameters != null)            {                foreach (SqlParameter parameter in parameters)                {                    command.Parameters.Add(parameter);                }            }            command.ExecuteNonQuery();            connection.Close();        }        ///<summary>        ///执行存储过程        ///</summary>        ///<param name="storedProcedureName">存储过程名</param>        ///<param name="parametes">参数</param>        ///<returns>sqldatareader</returns>        public static SqlDataReader ExecuteProcedureReader(string storedProcedureName,IDataParameter[] parameters)        {            SqlConnection connection = new SqlConnection(sqlConnectionString);            connection.Open();            SqlCommand command = new SqlCommand(storedProcedureName,connection);            command.CommandType = CommandType.StoredProcedure;            if (parameters != null)            {                foreach (SqlParameter parameter in parameters)                {                    command.Parameters.Add(parameters);                }            }            SqlDataReader sqlReader = command.ExecuteReader();            return sqlReader;        }    }}