C#权限管理实现

1、 winform权限管理实现【转】 Posted on 2010-04-29 17:05 Happy Coding 阅读(876) 评论(1) 编辑 收藏 winform权限管理实现 效果图： 技术实现： using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace HHLInfoManage public p

2、artial class frmQuanXGL : Form public frmQuanXGL() InitializeComponent(); /设置权限树展开 this.QuanXtreeView.ExpandAll(); /绑定角色 Common.AccessDataOperation Data = new HHLInfoManage.Common.AccessDataOperation(); DataTable table = Data.GetDataTable(select distinct Role from QuanX); this.RoletreeView.Nodes0.No

3、des.Clear(); for (int n = 0; n table.Rows.Count; n+) this.RoletreeView.Nodes0.Nodes.Add(table.Rowsn0.ToString(); this.RoletreeView.ExpandAll(); private void ExitbuttonX_Click(object sender, EventArgs e) /关闭窗体 this.Close(); private void 删除ToolStripMenuItem_Click(object sender, EventArgs e) /删除角色 if (

4、this.RoletreeView.SelectedNode != null & this.RoletreeView.SelectedNode.Text!=所有角色) if (MessageBox.Show(你确实要删除该角色吗？, 提示, MessageBoxButtons.YesNo) = DialogResult.Yes) Common.AccessDataOperation Data = new HHLInfoManage.Common.AccessDataOperation(); /删除角色 string comText = delete from QuanX where Role=

5、+this.RoletreeView.SelectedNode.Text+; Data.ExecSql(comText); MessageBox.Show(删除成功！,提示); /重新绑定角色 DataTable table = Data.GetDataTable(select distinct Role from QuanX); this.RoletreeView.Nodes0.Nodes.Clear(); for (int n = 0; n table.Rows.Count; n+) this.RoletreeView.Nodes0.Nodes.Add(table.Ro wsn0.ToSt

6、ring(); this.RoletreeView.ExpandAll(); else MessageBox.Show(请选择角色！, 提示, MessageBoxButtons.OK, MessageBoxIcon.Information); void AllTreeView(TreeNodeCollection node, bool check) /*递归，为选中的父节点选中子节点*/ foreach (System.Windows.Forms.TreeNode node1 in node) if (node1.Nodes.Count != 0) node1.Checked = check

7、; this.AllTreeView(node1.Nodes, node1.Checked); else node1.Checked = check; private void QuanXtreeView_BeforeCheck(object sender, TreeViewCancelEventArgs e) /*为选中的父节点选中子节点*/ this.AllTreeView(e.Node.Nodes, !(e.Node.Checked); private void SavebuttonX_Click(object sender, EventArgs e) /保存数据 if (this.Ad

8、dRoletextBoxX.Text.Trim().Length = 0) MessageBox.Show(角色名称不能为空！,提示); return; string Role=this.AddRoletextBoxX.Text.Trim(); /验证权限 List List=new List(); foreach (TreeNode Node1 in this.QuanXtreeView.Nodes0.Nodes) if (Node1.Checked) List.Add(Node1.Tag.ToString(); foreach (TreeNode Node2 in Node1.Nodes)

9、 if (Node2.Checked) List.Add(Node2.Tag.ToString(); if (List.Count = 0) MessageBox.Show(请选择权限！, 提示); return; Common.AccessDataOperation DataOperation = new HHLInfoManage.Common.AccessDataOperation(); string comText = ; comText = delete from QuanX where Role=+Role+; DataOperation.ExecSql(comText); for

10、 (int n = 0; n List.Count; n+) comText = insert into QuanX(Role,QuanX) values (+Role+,+Listn+); DataOperation.ExecSql(comText); MessageBox.Show(保存成功！,提示); /重新绑定数据 DataTable table = DataOperation.GetDataTable(select distinct Role from QuanX); this.RoletreeView.Nodes0.Nodes.Clear(); for (int n = 0; n

11、table.Rows.Count; n+) this.RoletreeView.Nodes0.Nodes.Add(table.Rowsn0.ToString(); this.RoletreeView.ExpandAll(); private void RoletreeView_AfterSelect(object sender, TreeViewEventArgs e) /给角色赋权 Common.AccessDataOperation Data=new HHLInfoManage.Common.AccessDataOperation(); DataTable table = Data.Get

12、DataTable(select QuanX from QuanX where Role= + this.RoletreeView.SelectedNode.Text + ); foreach (TreeNode Node1 in this.QuanXtreeView.Nodes0.Nodes) Node1.Checked = false; foreach (TreeNode Node2 in Node1.Nodes) Node2.Checked = false; for (int n = 0; n table.Rows.Count; n+) foreach (TreeNode Node1 i

13、n this.QuanXtreeView.Nodes0.Nodes) if (table.Rowsn0.Equals(Node1.Tag) Node1.Checked = true; foreach (TreeNode Node2 in Node1.Nodes) if (table.Rowsn0.Equals(Node2.Tag) Node2.Checked = true; 调用： /进行权限设置 public void SetQuanX() ToolStripMenuItem items = new ToolStripMenuItem mnuMemberMamang,mnuMemberReg

14、ister,mnuMemberRevise,mnuMemberSelect,mnuMemberReviseNext,mnuMemberLogout,mnuSelectRoster, mnuCourse,mnuCoursePlan,mnuCourseChoice,mnuCourseAdjust,mnuCheckIn, mnuPrint,mnuMemberInfoPrint,mnuCheckInPrint,mnuRosterPrint, mnuUserManage,mnuAddUser,mnuReviseUser,mnuChangeUser,mnuLog,QuanX ; Common.AccessDataOperation Data=new HHLInfoManage.Common.AccessDataOperation(); DataTable table = Data.GetDataTable(select QuanX from QuanX where Role= + frmLogin.str_UserRig