webusercontrolusertree.ascx.cs

网博Fms在线直播系统 本程序基于fms2.0为核心的实时直播系统

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;

public partial class admin_WebUserControlUserTree : Sp.baseAdminControl
{
    public DataTable dt = new DataTable();
    protected override void Page_Load(object sender, EventArgs e)
    {
        base.Page_Load(sender, e);

    }
    public void Node_Populate(object sender, System.Web.UI.WebControls.TreeNodeEventArgs e)
    {
        if (e.Node.ChildNodes.Count == 0)//判断是否当前为第一级节点
        {
            switch (e.Node.Depth)//获取节点的深度
            {
                case 0:
                    Fill_Fathers(e.Node);//促发事件，并传递引发事件的节点！
                    break;
                case 1:
                    Fill_Childs(e.Node);
                    break;
                case 2:
                    Fill_Childs(e.Node);
                    break;
                case 3:
                    Fill_Childs(e.Node);
                    break;
            }
        }
    }


    void Fill_Fathers(TreeNode node)//列出父节点
    {  //创建数据库连接并把数据缓存到dataset Tree_father表中
        dt = Sp.Base.ExecuteSql4Ds("SELECT id,username,ParentId,username,Rank,zhuangtai,truemoney from sp_user order by id desc").Tables[0];//获取所有节点

        DataRow[] rows = dt.Select("ParentId='" + 0 + "'", "id aSC");
        foreach (DataRow row in rows)//循环列出父节点
        {
            string xingzhi = "内部代理";//row["Rank"].ToString() == "1" ? "代理商" : "普通会员";
            string zhuangtai = row["zhuangtai"].ToString() == "True" ? "正常" : "停止";
            string modetext = "《" + row["username"].ToString() + "》《" + xingzhi + "》《" + zhuangtai + "》《";

            modetext += row["truemoney"].ToString() + "》";

            TreeNode newNode = new TreeNode(modetext, row["id"].ToString());

            newNode.PopulateOnDemand = true;
            newNode.SelectAction = TreeNodeSelectAction.Expand;
            newNode.NavigateUrl = "user_update.aspx?Uid=" + row["ID"].ToString();
            newNode.Target = "cen";
            node.ChildNodes.Add(newNode);
        }
    }


    void Fill_Childs(TreeNode node)
    {
        string id = node.Value.ToString();
        DataRow[] rows = dt.Select("ParentId='" + id + "'", "id aSC");

        foreach (DataRow row in rows)
        {
            string xingzhi = row["Rank"].ToString() == "1" ? "代理商" : "普通会员";
            string zhuangtai = row["zhuangtai"].ToString() == "True" ? "正常" : "停止";
            string modetext = "《" + row["username"].ToString() + "》《" + xingzhi + "》《" + zhuangtai + "》《";

            modetext += row["truemoney"].ToString() + "》";

            TreeNode newNode = new TreeNode(modetext, row["id"].ToString());
            newNode.PopulateOnDemand = true;
            newNode.NavigateUrl = "user_update.aspx?Uid=" + row["ID"].ToString();
            newNode.Target = "cen";
            node.ChildNodes.Add(newNode);
        }
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        TreeNodeCollection checkedNodes = this.TreeView1.CheckedNodes;

        //MessageBox.Show(this.Page, checkedNodes[0].Value);
    }
    protected void Button1_Click1(object sender, EventArgs e)
    {
        TreeNodeCollection checkedNodes = this.TreeView1.CheckedNodes;
        // MessageBox.Show(this.Page, TreeView1.CheckedNodes.Count.ToString());
        //  MessageBox.Show(this.Page, checkedNodes.Count.ToString()+"/");
        // string s = "";
        for (int i = 0; i < TreeView1.CheckedNodes.Count; i++)
        {
            Dell(checkedNodes[i].Value);
        }
        MessageBox.ShowAndRedirect(this.Page, "删除成功！", "user_list.aspx");
    }
    void Dell(string uid)
    {
        string sql = "DELETE FROM  Sp_User where id=" + uid;
        Sp.Base.ExecuteSql(sql);

    }
}