private void tvChucNang_AfterSelect(object sender, TreeViewEventArgs e) { TreeNode curNode = tvChucNang.SelectedNode; if (curNode.Tag == "2") { string sql1 = "select nd.TenNguoiDung,vt.TenVaiTro from VAITRO vt,NGUOIDUNG nd where vt.MaVaiTro=nd.MaVaiTro and nd.TenNguoiDung=N'" + curNode.Text + "'"; gridVaiTroChucNang.DataSource = XL_DULIEU.LayDuLieu(sql1); string sql2 = "select cn.TenChucNang,th.TatCa,th.TruyCap,th.Them,th.Xoa,th.Sua,th.InAn,th.Nhap,th.Xuat from VAITRO_CHUCNANG th,CHUCNANG cn,NGUOIDUNG nd where cn.ID=th.MaChucNang and nd.MaVaiTro = th.MaVaiTro and nd.TenNguoiDung = '" + curNode.Text + "'"; gridChucNang.DataSource = XL_DULIEU.LayDuLieu(sql2); } }
public void hienthiTreeView() { tvChucNang.Nodes.Clear(); DataTable root = new DataTable(); DataTable child = new DataTable(); DataTable id = new DataTable(); id = XL_DULIEU.LayDuLieu("select MaVaiTro from VAITRO"); root = XL_DULIEU.LayDuLieu("select TenVaiTro from VAITRO"); for (int i = 0; i < root.Rows.Count; i++) { tvChucNang.Nodes.Add(root.Rows[i][0].ToString()); tvChucNang.Tag = "1"; child = XL_DULIEU.LayDuLieu("select TenNguoiDung from NGUOIDUNG where MaVaiTro = N'" + id.Rows[i][0] + "'"); for (int j = 0; j < child.Rows.Count; j++) { tvChucNang.Nodes[i].Nodes.Add(child.Rows[j][0].ToString()); tvChucNang.Nodes[i].Nodes[j].Tag = "2"; } } }