初次上台,一时想不起该发啥东东!就来个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>");
        }