DAL块代码
public static string connString = ConfigurationManager.ConnectionStrings["Register"].ConnectionString;
//当需要读取数据时调用此方法
public static SqlDataReader ExectudeReader(string sql, CommandType type = CommandType.Text, params SqlParameter[] pams)
{
//声明数据库连接
SqlConnection con = new SqlConnection(connString);
//声明命令
using (SqlCommand cmd = new SqlCommand(sql, con))
{
if (pams != null && pams.Length > 0)
{
cmd.Parameters.AddRange(pams);
}
//打开数据库
if (con.State == ConnectionState.Closed)
{
con.Open();
}
//执行存储过程
cmd.CommandType = type;
//执行命令
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
}
//增删改调用此方法
public static int ExecuteNonQuery(string sql, params SqlParameter[] pams)
{
//声明数据库连接
SqlConnection con = new SqlConnection(connString);
//声明命令
using (SqlCommand cmd = new SqlCommand(sql, con))
{
if (pams != null && pams.Length > 0)
{
cmd.Parameters.AddRange(pams);
}
//打开数据库
if (con.State == ConnectionState.Closed)
{
con.Open();
}
//执行存储过程
//执行命令
return cmd.ExecuteNonQuery();
}
}