通用的写法

xiaomangxian 2008-07-23 05:29:53

请看我的某一个文件.aspx.cs的代码

//省略USING部分
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}

public string show1()
{

string strConnection = ConfigurationSettings.AppSettings["dns"];
SqlConnection objConnection = new SqlConnection(strConnection);
objConnection.Open();
SqlCommand cmd = new SqlCommand("SQL语句1", objConnection);
SqlDataReader dr = cmd.ExecuteReader();
string strBody = null;
dr.Read();
if (条件)
{
strBody += "内容1";
}
else
{
strBody += "内容2";
}
dr.Close();
objConnection.Close();
return strBody;
}

public string show2()
{

string strConnection = ConfigurationSettings.AppSettings["dns"];
SqlConnection objConnection = new SqlConnection(strConnection);
objConnection.Open();
SqlCommand cmd = new SqlCommand("SQL语句2", objConnection);
SqlDataReader dr = cmd.ExecuteReader();
string strBody = null;
while (dr.Read())
{
strBody += "内容3";
}
dr.Close();
objConnection.Close();
return strBody;
}

public string show3()
{

string strConnection = ConfigurationSettings.AppSettings["dns"];
SqlConnection objConnection = new SqlConnection(strConnection);
objConnection.Open();
SqlCommand cmd = new SqlCommand("SQL语句3", objConnection);
SqlDataReader dr = cmd.ExecuteReader();
string strBody = null;
while (dr.Read())
{
strBody += "内容5";
}
dr.Close();
objConnection.Close();
return strBody;
}

public string show4(string getString)
{
string strConnection = ConfigurationSettings.AppSettings["dns"];
SqlConnection objConnection = new SqlConnection(strConnection);
objConnection.Open();
SqlCommand cmd = new SqlCommand("SQL语句4", objConnection);
SqlDataReader dr = cmd.ExecuteReader();
string strBody = null;
dr.Read();
strBody += "" + dr[getString] + "";
dr.Close();
objConnection.Close();
return strBody;
}

}

所有的asp.cs文件都是这样的方式写出来的，您可以看到里面的show1 - show4 有的是相同的，只是所查询的条件不一样，所有在.aspx页面中，都是通过<%=show1()%>这样的方式读出来，我想请问下，有没有什么方法让相同部分封装成.DLL文件，然后使用，该怎么使用，请指导下，谢谢

...全文