DB类

来源：互联网发布：淘宝网卖家登录编辑：程序博客网时间：2024/05/29 15:26

namespace PlasticDAL
{

    public class DBHelper
    {

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

        /// <summary>
        /// 获得数据库连接状态
        /// </summary>
        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;
        }

}
}