简写的通用数据层代码

public class SqlHelper
...{
ExecuteNonQuery的两个重载#region ExecuteNonQuery的两个重载
public static int ExecuteNonQuery(string connStr, CommandType commandType, string commStr)
...{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand comm = new SqlCommand(commStr, conn);
comm.CommandType = commandType;

conn.Open();
int rowNum = comm.ExecuteNonQuery();
comm.Dispose();
conn.Close();

return rowNum;
}
public static int ExecuteNonQuery(string connStr, CommandType commandType, string commStr, params SqlParameter[] commandParameters)
...{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand comm = new SqlCommand(commStr, conn);
comm.CommandType = commandType;

for (int i = 0; i < commandParameters.Length; i )
comm.Parameters.Add(commandParameters[i]);

conn.Open();
int rowNum = comm.ExecuteNonQuery();
comm.Dispose();
conn.Close();

return rowNum;
}
#endregion

ExecuteScalar的两个重载#region ExecuteScalar的两个重载
public static object ExecuteScalar(string connStr, CommandType commandType, string commStr)
...{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand comm = new SqlCommand(commStr, conn);
comm.CommandType = commandType;

conn.Open();
object firstObj = comm.ExecuteScalar();
comm.Dispose();
conn.Close();

return firstObj;
}

public static object ExecuteScalar(string connStr, CommandType commandType, string commStr, params SqlParameter[] commandParameters)
...{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand comm = new SqlCommand(commStr, conn);
comm.CommandType = commandType;

for (int i = 0; i < commandParameters.Length; i )
comm.Parameters.Add(commandParameters[i]);

conn.Open();
object firstObj = comm.ExecuteScalar();
comm.Dispose();
conn.Close();

return firstObj;
}
#endregion

ExecuteReader的两个重载#region ExecuteReader的两个重载
public static SqlDataReader ExecuteReader(string connStr, CommandType commandType, string commStr)
...{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand comm = new SqlCommand(commStr, conn);
comm.CommandType = commandType;

conn.Open();
SqlDataReader reader = comm.ExecuteReader(CommandBehavior.CloseConnection);

return reader;
}

public static SqlDataReader ExecuteReader(string connStr, CommandType commandType, string commStr, params SqlParameter[] commandParameters)
...{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand comm = new SqlCommand(commStr, conn);
comm.CommandType = commandType;

for (int i = 0; i < commandParameters.Length; i )
comm.Parameters.Add(commandParameters[i]);

conn.Open();
SqlDataReader reader = comm.ExecuteReader(CommandBehavior.CloseConnection);

return reader;
}
#endregion

SqlDataSetAdapter的两个重载#region SqlDataSetAdapter的两个重载
public static DataSet SqlDataSetAdapter(string connStr, CommandType commandType, string commStr, params SqlParameter[] commandParameters)
...{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand comm = new SqlCommand(commStr, conn);
comm.CommandType = commandType;

for (int i = 0; i < commandParameters.Length; i )
comm.Parameters.Add(commandParameters[i]);

SqlDataAdapter sda = new SqlDataAdapter(comm);
DataSet ds = new DataSet();

sda.Fill(ds);
return ds;
}

public static DataSet SqlDataSetAdapter(string connStr, CommandType commandType, string commStr)
...{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand comm = new SqlCommand(commStr, conn);
comm.CommandType = commandType;

SqlDataAdapter sda = new SqlDataAdapter(comm);
DataSet ds = new DataSet();

sda.Fill(ds);
return ds;
}
#endregion

}