usingSystem;
usingSystem.Data;
usingSystem.Data.SqlClient;
usingSystem.Configuration;
namespaceDb
{
///
///Base的摘要说明。
/// publicclassBase
{
publicBase()
{
//
//TODO:在此处添加构造函数逻辑
//
}
protectedstaticSqlConnectionconn=newSqlConnection(ConfigurationSettings.AppSettings["dsn"]);
protectedstaticSqlCommandcmd=newSqlCommand(strSp,conn);
protectedstaticSqlDataAdapterda=newSqlDataAdapter();
protectedstaticDataSetds=newDataSet();
protectedstaticDataViewdv=newDataView();
protectedstaticSqlDataReaderdr;
protectedstaticSqlParameter[]prams;
protectedstaticstringstrSp;
protectedstaticSqlDataReaderdrSelectAll(stringstrSp)
{
cmd.CommandType=CommandType.StoredProcedure;
conn.Open();
dr=cmd.ExecuteReader(CommandBehavior.CloseConnection);
returndr;
}//返回一个SqlDataReader
protectedstaticDataSetdsSelectAll(stringstrSp)
{
da.SelectCommand=newSqlCommand(strSp,conn);
da.SelectCommand.CommandType=CommandType.StoredProcedure;
da.Fill(ds);
conn.Open();
try
{
da.SelectCommand.ExecuteNonQuery();
returnds;
}
catch(Exceptionex)
{
thrownewException(ex.Message);
}
finally
{
conn.Dispose();
conn.Close();
}
}//返回一个SqlDataSet
protectedstaticDataViewdvSelectAll(stringstrSp)
{
cmd.CommandType=CommandType.StoredProcedure;
da.SelectCommand=newSqlCommand(strSp,conn);
da.Fill(ds);
conn.Open();
try