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;
}

}
}