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 static int KiemTraDangNhap(string username, string password)
{
string sql = "KTDangNhap";
SqlParameter kq = new SqlParameter("@kq", SqlDbType.Int);
kq.Direction = ParameterDirection.Output;
XL_DULIEU.ThucThi(CommandType.StoredProcedure, sql,
new SqlParameter {
ParameterName = "@username", Value = username
},
new SqlParameter {
ParameterName = "@passwword", Value = password
}, kq);
return((int)kq.Value);//trả ra kq 1 và 0 theo stored
}
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";
}
}
}
public void LoadDuLieu()
{
gridLoaiPhieuIn.DataSource = XL_DULIEU.LayDuLieuTuBang("LoaiPhieuIn");
}
public void LoadComboVaiTro()
{
cbVaiTro.DataSource = XL_DULIEU.LayDuLieuTuBang("VAITRO");
cbVaiTro.DisplayMember = "TenVaiTro";
cbVaiTro.ValueMember = "MaVaiTro";
}
