DB类

namespace PlasticDAL { public class DBHelper { //定义数据库链接属性 private static SqlConnection objSqlConnection; /// summary /// 获得数据库连接状态 /// /summary public static SqlConnection ObjSqlConnection { get { string DBConnectionStri

namespace plasticdal
{
  
    public class dbhelper
    {

        //定义数据库链接属性
        private static SqlConnection objSqlConnection;

        ///

        /// 获得数据库连接状态
        ///

        public static SqlConnection ObjSqlConnection
        {
            get
            {
                string DBConnectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
                if (objSqlConnection == null)
                {
                    objSqlConnection = new SqlConnection(DBConnectionString);
                    objSqlConnection.Open();
                }
                else if (objSqlConnection.State == System.Data.ConnectionState.Closed)
                {
                    objSqlConnection.Open();
                }
                else if (objSqlConnection.State == System.Data.ConnectionState.Broken)
                {
                    objSqlConnection.Close();
                    objSqlConnection.Open();
                }
                return objSqlConnection;
            }
        }

        public static void CloseConn()
        {
            if (objSqlConnection.State==ConnectionState.Open)
            {
                objSqlConnection.Close();
            }
        }
         public static int ExecuteNonQueryBySql(string sql)
        {
            SqlCommand objSqlCommand = new SqlCommand(sql, ObjSqlConnection);
          
            return objSqlCommand.ExecuteNonQuery();
        }

         public static SqlDataReader GetReaderBySql(string sql)
        {

            SqlCommand cmd = new SqlCommand(sql, ObjSqlConnection);
            SqlDataReader reader = cmd.ExecuteReader();
            return reader;
        }

             
 
    }
}