treeview

MickeyAi

于 2008-09-08 11:40:00 发布

阅读量519

点赞数

文章标签： string dataset session javascript cms function

本文链接：https://blog.csdn.net/MickeyAi/article/details/2898704

版权

前台代码
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="power.aspx.cs" Inherits="admin_module_power" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>User Role Power</title>
    <script type="text/javascript" language="javascript" src="../js/Control.js"></script>
    <script type="text/javascript" language="javascript">
        window.document.attachEvent("onkeydown",Control.HidenKeyF5);
    </script>
    <script language="JavaScript">
//获取元素指定tagName的父元素
function public_GetParentByTagName(element, tagName)
{
         var parent = element.parentNode;
         var upperTagName = tagName.toUpperCase ();
         //如果这个元素还不是想要的tag就继续上溯
         while (parent && (parent.tagName.toUpperCase() != upperTagName))
         {
             parent = parent.parentNode ? parent.parentNode : parent.parentElement;
         }
         return parent;
}

//设置节点的父节点Cheched——该节点可访问，则他的父节点也必能访问
function setParentChecked(objNode)
{
         var objParentDiv = public_GetParentByTagName (objNode,"div");
         if (objParentDiv==null || objParentDiv == "undefined")
         {
             return;
         }
         var objID = objParentDiv.getAttribute ("ID");
         objID = objID.substring(0,objID.indexOf ("Nodes"));
         objID = objID+"CheckBox";
         var objParentCheckBox = document.getElementById (objID);
         if (objParentCheckBox==null || objParentCheckBox == "undefined")
         {
             return;
         }
         if (objParentCheckBox.tagName!="INPUT" && objParentCheckBox.type == "checkbox")
         return;
         objParentCheckBox.checked = true;
         setParentChecked (objParentCheckBox);
}

//设置节点的子节点uncheched——该节点不可访问，则他的子节点也不能访问
function setChildUnChecked(divID)
{
         var objchild = divID.children;
         var count = objchild.length;
         for(var i=0;i<objchild.length;i++)
         {
             var tempObj = objchild [i];
             if(tempObj.tagName=="INPUT" && tempObj.type == "checkbox")
             {
                tempObj.checked = false;
            }
             setChildUnChecked(tempObj);
         }
}

//设置节点的子节点cheched——该节点可以访问，则他的子节点也都能访问
function setChildChecked(divID)
{
         var objchild = divID.children;
         var count = objchild.length;
         for(var i=0;i<objchild.length;i++)
         {
             var tempObj = objchild [i];
             if(tempObj.tagName=="INPUT" && tempObj.type == "checkbox")
             {
                tempObj.checked = true;
              }
             setChildChecked(tempObj);
         }
}

//触发事件
function CheckEvent()
{

    var objNode = event.srcElement;

    if(objNode.tagName!="INPUT" || objNode.type!="checkbox")
    {

    return;
    }

    if(objNode.checked==true)
    {

        setParentChecked(objNode);
        var objID = objNode.getAttribute("ID");
        var objID = objID.substring(0,objID.indexOf("CheckBox"));
        var objParentDiv = document.getElementById(objID+"Nodes");
        if(objParentDiv==null || objParentDiv == "undefined")
        {

            return;
        }
        setChildChecked(objParentDiv);
    }
    else
    {

        var objID = objNode.getAttribute("ID");
        var objID = objID.substring(0,objID.indexOf("CheckBox"));
        var objParentDiv = document.getElementById(objID+"Nodes");
        if(objParentDiv==null || objParentDiv == "undefined")
        {
            return;
        }
        setChildUnChecked(objParentDiv);
    }
}

</script>
    <link href="../css/style.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
     <table border="0" cellpadding="0" cellspacing="0" class="record"
            width="100%">
            <tr>
                <th nowrap="nowrap">
                    CMS User Role Power</th>
            </tr>
            <tr>
                <td colspan="2">
                </td>
            </tr>
            <tr>
                <td colspan="2">
                     

        <asp:TreeView ID="tv_Roleview" runat="server">
        </asp:TreeView>
                </td>
            </tr>
            <tr>
                <td colspan="2">
                     

                </td>
            </tr>
            <tr>
                <td colspan="2" align="center">

                            <asp:Button ID="btnUpdate" runat="server" Text="Update" OnClick="btnUpdate_Click" CssClass="button" />
                    <asp:Button ID="btnCancel" runat="server" Text="Cancel" CssClass="button" OnClick="btnCancel_Click" />
                </td>
            </tr>
            <tr>
                <td colspan="2" style="height: 19px">
                     </td>
            </tr>
        </table>
</form>
</body>
</html>

后台代码
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;
using CMS.BLL;

public partial class admin_module_power : System.Web.UI.Page
{
    SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
    string selectnodesAll = "";
    string[] powers;
   ArrayList arr = new ArrayList();
    protected void Page_Load(object sender, EventArgs e)
    {
        //
        if (Session["userId"] == null || Session["userId"].ToString() == "")
        {
            Page.RegisterStartupScript("re_alert", "<script>parent.window.navigate('../login.aspx');</script>");

        }

        this.tv_Roleview.Attributes.Add("onclick", "return CheckEvent();");

        if (!Page.IsPostBack)
        {

            arr.AddRange(BindPower());

            CreateTree(tv_Roleview.Nodes, "0");


        }


    }

    public DataSet GetData()
    {

       // conn.Open();//
        string sql = "select * from cms_section where section_status=2 order by section_pos";

        SqlDataAdapter da = new SqlDataAdapter(sql, conn);
        DataSet ds = new DataSet();
        da.Fill(ds, "sections");
        return ds;
        //ds.Dispose();
        da.Dispose();

      // conn.Close();
    }

   private string[] BindPower()
    {
        conn.Open();
        string role_id = Request["role_id"].ToString();
        int roleId = int.Parse(role_id);
        string sql = "select * from cms_role where role_id = " + roleId;
        SqlCommand sc = new SqlCommand(sql, conn);
        SqlDataReader sdr = sc.ExecuteReader();
        string power_list="";
        while (sdr.Read())
        {
            power_list = sdr["role_power"].ToString();            //...
        }

      string[] power = power_list.Split(',');//","

        sc.Dispose();
        sdr.Dispose();
        conn.Close();

    return power;
    }

    private void CreateTree(TreeNodeCollection Nds, string ParentId)
    {
        DataRow[] rows = GetData().Tables["sections"].Select("section_parent='" + ParentId + "'");

        foreach (DataRow dr in rows)
        {
            TreeNode treenode = new TreeNode();
            treenode.SelectAction = TreeNodeSelectAction.None;
            treenode.Value = dr["section_id"].ToString().Trim();
            treenode.Text = dr["section_name"].ToString().Trim();
            treenode.Checked = false;
            treenode.Expanded = true;
            treenode.SelectAction = TreeNodeSelectAction.None;
            //int n = Array.BinarySearch(powers, dr["section_id"].ToString());
            if (arr.Contains(dr["section_id"].ToString().Trim()))
            {
                treenode.Checked = true;
            }



            treenode.ShowCheckBox = true;

            Nds.Add(treenode);

            int id = int.Parse(dr["section_id"].ToString().Trim());
            CreateTree(treenode.ChildNodes, treenode.Value);
        }
    }

    //Submit the role power
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        conn.Open();
        string role_id = Request["role_id"].ToString();
        int roleId = int.Parse(role_id);


        for (int i = 0; i < this.tv_Roleview.Nodes.Count; i++)
        {
            TreeNode node = this.tv_Roleview.Nodes[i];
            if (node.Checked == true)
            {
                selectnodesAll += node.Value + ",";
            }
            if (node.ChildNodes.Count > 0)
            {
                GetNodes(node);
            }

        }
        //Response.Write(selectnodesAll);    //strID

       /* if (Session["rolePower"].ToString() == "")
        {
            string insertSQL = "update into cms_role(role_power) values(@role_power) where role_id = " + roleId;
            SqlCommand cmd = new SqlCommand(insertSQL, conn);
            cmd.Parameters.Add(new SqlParameter("@role_power", SqlDbType.NText));
            cmd.Parameters["@role_power"].Value = selectnodesAll;
            try
            {
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Response.Write("Insert failed " + ex.Message.ToString());
            }
        }
        else
        {*/
            string updateSQL = "update cms_role set role_power=@role_power where role_id = " + roleId;
            SqlCommand cmd = new SqlCommand(updateSQL, conn);
            cmd.Parameters.Add(new SqlParameter("@role_power", SqlDbType.NText));
            cmd.Parameters["@role_power"].Value = selectnodesAll;
            try
            {
                cmd.ExecuteNonQuery();
                string log_date = DateTime.Now.ToString();
                int log_user = int.Parse(Session["userId"].ToString());
                cmsLog cmslog = new cmsLog();
                cmslog.InsertLog(log_date, log_user, 1, "User " + Session["userLogin"].ToString() + " Update Role Power Succeed", roleId);
                Page.RegisterStartupScript("message", "<script>alert('Update Succeed!');</script>");
            }
            catch (Exception ex)
            {
                Response.Write("Update failed " + ex.Message.ToString());
            }
     //   }
        conn.Close();


    }

    // to get tree nodes
    private void GetNodes(TreeNode selectTn)
    {
        if (selectTn == null) return;
        foreach (TreeNode tn in selectTn.ChildNodes)
        {
            if (tn.Checked == true)
            {
                selectnodesAll += tn.Value + ",";
            }
            GetNodes(tn);
        }
    }

    //return to role_list
    protected void btnCancel_Click(object sender, EventArgs e)
    {
        Response.Redirect("role.aspx");
    }

}

MickeyAi

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
treeview

前台代码 User Role Power window.document.attachEvent("onkeydown",Control.HidenKeyF5); //获取元素指定tagName的父元素function public_GetParentByTagName(element, tagName) { var parent
复制链接

扫一扫