初次上台,一时想不起该发啥东东!就来个Net的无限级分类吧!
作者:魔间行者 日期:2008-01-23
void myClass()
{
SqlConnection Conn = new SqlConnection();
Conn.ConnectionString = ConnStr;
try
{
Conn.Open();
_Conn=Conn;
string sql = "select * from myClass order by fl asc";
SqlDataAdapter dAdapter = new SqlDataAdapter(sql,Conn);
DataSet ds = new DataSet();
dAdapter.Fill(ds);
DataRow[] myRow = ds.Tables[0].Select("pid=0","fl");
string myStr = "<table width='100%' bordercolor='#CCCCCC' border='0' cellpadding='0' cellspacing='0'>";
foreach(DataRow dr in myRow)
{
myStr += "<tr style='cursor:hand' onMouseOut=" + "this.style.backgroundColor=''" + " onMouseOver=" + "this.style.backgroundColor='#BFDFFF'" + ">";
myStr += "<td width='255' height='18' onclick=ChangeDis('table"+dr["id"].ToString()+"')>" + MyData.img(Convert.ToInt32(dr["id"])) + " <a href='#' onclick=AddChild('" + dr["id"] + "','" + dr["titlename"] + "','" + dr["depth"] + "');ModClass('" + dr["id"] + "','" + dr["titlename"] + "')>" + dr["titlename"] + "</a></td>";
myStr += "<td width='35'><a href='?action=Up&id="+dr["id"]+"&fl="+dr["fl"]+"&pid="+dr["pid"]+"'><b>↑</b></a></td>";
myStr += "<td width='30'><a href='?action=Down&id=" + dr["id"] + "&fl=" + dr["fl"] + "&pid=" + dr["pid"] + "'><b>↓</b></a></td>";
myStr += "<td width='30' algin='center'><a href='?action=del&id=" + dr["id"] + "' onclick='return confrim()'><b>×</b></a></td></tr>";
myStr += "<tr><td colspan='5'>" + NextClass(Convert.ToInt32(dr["id"]), ds) + "</td></tr>";
}
myStr += "</table>";
this.Addr.InnerHtml=myStr;
ds.Clear();
dAdapter.Dispose();
Conn.Close();
}
catch (Exception e)
{
Response.Write("<script>alert('"+e.Message.ToString()+"1Ji'); history.back();</script>");
}
}
public string NextClass(int pid,DataSet ds)
{
if (_Conn.State == ConnectionState.Closed)
{
_Conn.Open();
}
string myStr = "";
try
{
DataRow[] bRow = ds.Tables[0].Select("pid=" + pid, "fl");
myStr += "<table border='0' cellpadding='0' cellspacing='0' style='display:none' id='table" + pid + "'>";
foreach (DataRow dr in bRow)
{
myStr += "<tr onMouseOut=" + "this.style.backgroundColor=''" + " onMouseOver=" + "this.style.backgroundColor='#BFDFFF'" + ">";
myStr += "<td width='255' height='18'> "+Nbsp(Convert.ToInt32(dr["depth"]))+""+MyData.img(Convert.ToInt32(dr["id"])) + " <a href='#' onclick=AddChild('" + dr["id"] + "','" + dr["titlename"] + "','" + dr["depth"] + "');ModClass('" + dr["id"] + "','" + dr["titlename"] + "')>" + dr["titlename"] + "</a></td>";
myStr += "<td width='35'><a href='?action=Up&id=" + dr["id"] + "&fl=" + dr["fl"] + "&pid=" + dr["pid"] + "'><b>↑</b></a></td>";
myStr += "<td width='30'><a href='?action=Down&id=" + dr["id"] + "&fl=" + dr["fl"] + "&pid=" + dr["pid"] + "'><b>↓</b></a></td>";
myStr += "<td width='30' algin='center'><a href='?action=del&id=" + dr["id"] + "' onclick='return confrim()'><b>×</b></a></td></tr>";
myStr += "<tr><td colspan='5'>" + NextClass(Convert.ToInt32(dr["id"]), ds) + "</td></tr>";
}
myStr += "</table>";
}
catch (Exception ed)
{
Response.Write("<script>alert('" + ed.Message.ToString() + "2Ji'); history.back();</script>");
}
return myStr;
}
