学步园

XML权限菜单文件

<?xml version="1.0" encoding="utf-8" ?><br /> <Menus><br /> <MenuFunction><br /> <menuCode>10</menuCode><br /> <menuName>系统管理</menuName><br /> <parentMenuCode>-1</parentMenuCode><br /> <url /><br /> <level>1</level><br /> <menuType>1</menuType><br /> <isVisible>1</isVisible><br /> <toRoot>10,-1</toRoot><br /> <title>成员管理</title><br /> <imgSrc>User.gif</imgSrc><br /> <isLeaf>0</isLeaf><br /> </MenuFunction><br /> <MenuFunction><br /> <menuCode>20</menuCode><br /> <menuName>项目管理</menuName><br /> <parentMenuCode>-1</parentMenuCode><br /> <url /><br /> <level>1</level><br /> <menuType>1</menuType><br /> <isVisible>1</isVisible><br /> <toRoot>20,-1</toRoot><br /> <title>项目管理</title><br /> <imgSrc></imgSrc><br /> <isLeaf>0</isLeaf><br /> </MenuFunction><br /> <MenuFunction><br /> <menuCode>1010</menuCode><br /> <menuName>用户管理</menuName><br /> <parentMenuCode>10</parentMenuCode><br /> <url>UserList</url><br /> <level>2</level><br /> <menuType>1</menuType><br /> <isVisible>1</isVisible><br /> <toRoot>1010,10,-1</toRoot><br /> <title>用户管理</title><br /> <imgSrc>Member.gif</imgSrc><br /> <isLeaf>0</isLeaf><br /> </MenuFunction></p> <p> <MenuFunction><br /> <menuCode>101010</menuCode><br /> <menuName>添加</menuName><br /> <parentMenuCode>1010</parentMenuCode><br /> <url>Add</url><br /> <level>3</level><br /> <menuType>3</menuType><br /> <isVisible>1</isVisible><br /> <toRoot>101010,1010,10,-1</toRoot><br /> <title>添加</title><br /> <imgSrc /><br /> <isLeaf>1</isLeaf><br /> </MenuFunction></p> <p> <MenuFunction><br /> <menuCode>101020</menuCode><br /> <menuName>分配角色</menuName><br /> <parentMenuCode>1010</parentMenuCode><br /> <url></url><br /> <level>3</level><br /> <menuType>3</menuType><br /> <isVisible>0</isVisible><br /> <toRoot>101020,1010,10,-1</toRoot><br /> <title>分配角色</title><br /> <imgSrc /><br /> <isLeaf>1</isLeaf><br /> </MenuFunction></p> <p> <MenuFunction><br /> <menuCode>1020</menuCode><br /> <menuName>角色管理</menuName><br /> <parentMenuCode>10</parentMenuCode><br /> <url>RoleList</url><br /> <level>2</level><br /> <menuType>1</menuType><br /> <isVisible>1</isVisible><br /> <toRoot>1020,10,-1</toRoot><br /> <title>角色管理</title><br /> <imgSrc>Role.gif</imgSrc><br /> <isLeaf>0</isLeaf><br /> </MenuFunction></p> <p> <MenuFunction><br /> <menuCode>102010</menuCode><br /> <menuName>设置权限</menuName><br /> <parentMenuCode>1020</parentMenuCode><br /> <url></url><br /> <level>3</level><br /> <menuType>3</menuType><br /> <isVisible>0</isVisible><br /> <toRoot>102010,1020,10,-1</toRoot><br /> <title>设置权限</title><br /> <imgSrc>key.png</imgSrc><br /> <isLeaf>1</isLeaf><br /> </MenuFunction><br /> <MenuFunction><br /> <menuCode>102020</menuCode><br /> <menuName>添加角色</menuName><br /> <parentMenuCode>1020</parentMenuCode><br /> <url>AddRole</url><br /> <level>3</level><br /> <menuType>3</menuType><br /> <isVisible>1</isVisible><br /> <toRoot>102020,1020,10,-1</toRoot><br /> <title>添加角色</title><br /> <imgSrc></imgSrc><br /> <isLeaf>1</isLeaf><br /> </MenuFunction><br /> </Menus>

//菜单视图<br /> DataView DV;<br /> //角色视图<br /> DataView DVUser;<br /> //角色名称<br /> string RoleName = string.Empty;<br /> //角色编码<br /> public string RoleCode = string.Empty;<br /> //用户UserID<br /> string UserID = string.Empty;<br /> Business.User.RoleAction Roleaction = new Business.User.RoleAction();<br /> Business.User.UserInfo UserInfo = new Business.User.UserInfo();<br /> DataSet DS = new DataSet();<br /> ArrayList RoleCodeArray = new ArrayList();<br /> private void RoleSetRole_Load(object sender, EventArgs e)<br /> {<br /> //根据角色编码获取UserID<br /> string UserSql = string.Format(@"select UserID from UserOfRole where 1=1 {0}",<br /> RoleCode != "" ? string.Format(" and RoleCode='{0}'", RoleCode) : ""<br /> );<br /> //如果该角色分配给了用户就取出该用户的UserID<br /> if (UserInfo.GetDataTableOption(UserSql, DBType.Sql).Rows.Count > 0)<br /> {<br /> UserID = UserInfo.GetDataTableOption(UserSql, DBType.Sql).Rows[0][0] + "";<br /> }<br /> //根据角色编码获取功能节点<br /> string RoleActionSql = string.Format("select MenuCode from RoleAction where 1=1 {0}",<br /> RoleCode != "" ? string.Format(" and RoleCode='{0}'", RoleCode) : ""<br /> );<br /> //该角色对应的功能点视图<br /> DVUser = Roleaction.GetDataTableOption(RoleActionSql, DBType.Sql).DefaultView;<br /> //加载树<br /> BindTree();<br /> treeView1.ExpandAll();<br /> }<br /> //创建权限树<br /> public void BindTree()<br /> {<br /> DS.ReadXml("Menu.xml");<br /> DV = DS.Tables[0].DefaultView;<br /> foreach (DataRowView Drv in DV)<br /> {<br /> if (string.Equals(Drv["parentMenuCode"], "-1"))<br /> {<br /> TreeNode TN = new TreeNode();<br /> TN.Text = Drv["menuName"] + "";<br /> TN.Tag = Drv["menuCode"] + "";<br /> //如果该角色编码中存在该功能点就选中<br /> foreach (DataRowView RV in DVUser)<br /> {<br /> if (object.Equals(Drv["menuCode"], RV["menuCode"]))<br /> TN.Checked = true;<br /> }<br /> treeView1.Nodes.Add(TN);<br /> CreateChildNodes(TN);<br /> }<br /> }<br /> }<br /> //创建子节点<br /> public void CreateChildNodes(TreeNode ParentNode)<br /> {<br /> foreach (DataRowView Drv in DV)<br /> {<br /> if (object.Equals(Drv["parentMenuCode"], ParentNode.Tag))<br /> {<br /> TreeNode Node = new TreeNode();<br /> Node.Text = Drv["menuName"] + "";<br /> Node.Tag = Drv["menuCode"] + "";<br /> //如果该角色编码中存在该功能点就选中<br /> foreach (DataRowView RV in DVUser)<br /> {<br /> if (object.Equals(Drv["menuCode"], RV["menuCode"]))<br /> Node.Checked = true;<br /> }<br /> //父节点添加对应的子节点<br /> ParentNode.Nodes.Add(Node);<br /> CreateChildNodes(Node);<br /> }<br /> }<br /> }<br /> private void treeView1_AfterCheck(object sender, TreeViewEventArgs e)<br /> {<br /> if (e.Action != TreeViewAction.Unknown)<br /> {<br /> //选中(取消选中)父节点，选中(取消选中)该节点下面的子结点<br /> CheckAllChildNodes(e.Node, e.Node.Checked);<br /> //选中(取消选中)子节点,选中(取消选中)该节点的父结点<br /> CheckAllParentNodes(e.Node, e.Node.Checked);</p> <p> }</p> <p> }<br /> //选中(取消选中)父节点，选中(取消选中)该节点下面的子结点<br /> public void CheckAllChildNodes(TreeNode ParentNode, bool NodeChk)<br /> {<br /> foreach (TreeNode TN in ParentNode.Nodes)<br /> {<br /> TN.Checked = NodeChk;<br /> CheckAllChildNodes(TN, NodeChk);<br /> }<br /> }<br /> //选中(取消选中)子节点,选中(取消选中)该节点的父结点<br /> public void CheckAllParentNodes(TreeNode ChildNode, bool NodeChk)<br /> {<br /> if (ChildNode.Parent != null)<br /> {<br /> ChildNode.Parent.Checked = HasParentNode(ChildNode.Parent);<br /> CheckAllParentNodes(ChildNode.Parent, NodeChk);<br /> }<br /> }<br /> //根据当前子节点的状态，选中或不选中父节点<br /> public bool HasParentNode(TreeNode TN)<br /> {<br /> foreach (TreeNode ChildNode in TN.Nodes)<br /> {<br /> if (ChildNode.Checked)<br /> {<br /> return true;<br /> }<br /> HasParentNode(ChildNode);<br /> }<br /> return false;<br /> }<br /> //遍历TreeView中所有选中节点<br /> //然后将选中的RoleCode插入到ArrayList中<br /> public void GetNode(TreeNodeCollection tc)<br /> {<br /> foreach (TreeNode TNode in tc)<br /> {<br /> if (TNode.Checked)<br /> {<br /> RoleCodeArray.Add(TNode.Tag);<br /> }<br /> GetNode(TNode.Nodes);<br /> }<br /> }<br /> private void tsbSave_Click(object sender, EventArgs e)<br /> {<br /> TreeNodeCollection tc = treeView1.Nodes;<br /> GetNode(tc);<br /> ArrayList SqlArray = new ArrayList();<br /> //删除该角色之前所有功能节点<br /> string Delsql = string.Format(@"delete from RoleAction where 1=1 {0}",<br /> RoleCode != "" ? string.Format(" and RoleCode='{0}'", RoleCode) : ""<br /> );<br /> //将功能节点数组,角色编码,用户UserID插入到权限表中<br /> string AddSql = Roleaction.CreateRolePriviewSql(RoleCodeArray, RoleCode, UserID);<br /> //将删除sql,插入sql添加到ArrayList数组中<br /> SqlArray.Add(Delsql);<br /> SqlArray.Add(AddSql);<br /> //执行事务<br /> if (Roleaction.ExecTrans(SqlArray, DBType.Sql))<br /> MessageBox.Show("修改成功");<br /> else<br /> MessageBox.Show("修改失败");<br /> }