请懂C#的同学们帮我翻译一下这个类的意思,好吗?
public interface IShequ
{
//公共函数
SqlDataReader SqlGetinfo(string sCmd); DataSet DsGetinfo(string sCmd);
int Executeinfo(string sCmd);
}
public class Shequ:IShequ
{
SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString);
public Shequ()
{
//
//TODO: 在此处添加构造函数逻辑
//
}
public SqlDataReader SqlGetinfo(string sCmd)
{
string cmdText = sCmd;
SqlDataReader dr = null;
SqlCommand myCommand = new SqlCommand(cmdText, myConnection);
try
{
myConnection.Open();
dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (SqlException ex)
{
throw new Exception(ex.Message, ex);
}
return dr;
}
public DataSet DsGetinfo(string sCmd)
{
string cmdText = sCmd;
SqlDataAdapter da = new SqlDataAdapter(cmdText, myConnection);
DataSet ds = new DataSet();
try
{
myConnection.Open();
da.Fill(ds, "aa");
}
catch (SqlException ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
myConnection.Close();
}
return ds;
}
public int Executeinfo(string sCmd)
{
int nResult = -1;
string cmdText = sCmd;
SqlCommand myCommand = new SqlCommand(cmdText, myConnection);
try
{
myConnection.Open();
nResult = myCommand.ExecuteNonQuery();
}
catch (SqlException ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
myConnection.Close();
}
return nResult;
}