一个会员分红结算，以二叉树形式显示出来他的安置图，还可查看推荐图

本文链接：https://blog.csdn.net/xiaoxue1129/article/details/2775085

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class 查看会员分红 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.Panel1.Enabled=false;
        }

    }
    protected void Butnanzhi_Click(object sender, EventArgs e)
    {
        this.Panel1.Enabled = true;
        this.Label3.Text = "您要查看的安置关系如下：";
        string str = this.TextBox1.Text;

        SqlConnection con = DB.creation();
        con.Open();
        SqlCommand cmd = new SqlCommand("select Hyname from huiyuan where HyID='"+str+"'",con);
        SqlDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {
            this.TextBox2.Text = dr["Hyname"].ToString();
        }
        TreeNode tn = new TreeNode();
        tn.Text = str;
        tn=fillnode(tn);
        this.TreeView1.Nodes.Add(tn);
        this.TextBox1.Text = "";
        this.TextBox1.Focus();

    }
    public TreeNode fillnode(TreeNode tn)//递归
    {
        SqlConnection con = DB.creation();
        con.Open();

        SqlDataAdapter sda = new SqlDataAdapter("select LID,RID from huiyuan where HyID='" + tn.Text + "'", con);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        con.Close();
        if (ds.Tables[0].Rows.Count>0)
        {
            if (!Convert.IsDBNull(ds.Tables[0].Rows[0]["lid"]))
            {
                TreeNode tnl = new TreeNode();

                tnl.Text = ds.Tables[0].Rows[0]["lid"].ToString();
                tnl = fillnode(tnl);
                tn.ChildNodes.Add(tnl);
            }
            if (!Convert.IsDBNull(ds.Tables[0].Rows[0]["rid"]))
            {
                TreeNode tnr = new TreeNode();
                tnr.Text = ds.Tables[0].Rows[0]["rid"].ToString();
                tnr = fillnode(tnr);
                tn.ChildNodes.Add(tnr);
            }
        }
        return tn;

    }
    protected void Butntuijian_Click(object sender, EventArgs e)
    {
        this.Panel1.Enabled = true;
        this.Label3.Text = "您要查看的推荐关系如下：";
        string str = this.TextBox1.Text;
        SqlConnection con = DB.creation();
        con.Open();
        SqlCommand cmd = new SqlCommand("select Hyname from huiyuan where HyID='"+str+"'",con);
        SqlDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {
            this.TextBox2.Text = dr["Hyname"].ToString();
        }
        TreeNode tnh = new TreeNode();
        tnh.Text = str;
        tnh = fillnode1(tnh);
        this.TreeView1.Nodes.Add(tnh);
        this.TextBox1.Text = "";
        this.TextBox1.Focus();
    }
    public TreeNode fillnode1(TreeNode tnh )
    {
        SqlConnection con = DB.creation();
        con.Open();
        SqlCommand cmd=new SqlCommand ("select HyID from huiyuan where Hytjrid='"+tnh.Text+"'",con);
        SqlDataReader dr= cmd.ExecuteReader();
        while (dr.Read())
        {
            if (!Convert.IsDBNull(dr["hyID"]))
            {
                TreeNode tnr = new TreeNode();
                tnr.Text = dr["HyID"].ToString();

                tnh.ChildNodes.Add(tnr);
            }


        }
        return tnh;

    }
}