public List <ModuleQuyen> CheckQuyen(int id_nguoidung)
{
DAC kn = new DAC();
List <ModuleQuyen> quyen_col = new List <ModuleQuyen>();
SqlParameter pm = new SqlParameter("@id_user", id_nguoidung);
SqlParameter[] param = new SqlParameter[1] {
pm
};
DataTable tb = kn.get_by_procedure("proc_Check_Quyen", param);
if (tb != null)
{
foreach (DataRow row in tb.Rows)
{
ModuleQuyen module_quyen = new ModuleQuyen();
module_quyen.ID_Nguoi_Dung = Convert.ToInt16(row["ID_NguoiDung"]);
module_quyen.Module = row["Module"].ToString();
module_quyen.Ten_Quyen = row["TenQuyen"].ToString();
module_quyen.ID_Quyen = Convert.ToInt16(row["ID_Quyen"]);
quyen_col.Add(module_quyen);
}
}
return(quyen_col);
}
public List <ModuleQuyen> LayDanhSachModuleQuyen(int action, int id_module_quyen, int id_nguoidung, string module, int id_quyen)
{
DAC kn = new DAC();
List <ModuleQuyen> quyen_col = new List <ModuleQuyen>();
SqlParameter pm = new SqlParameter("@action", action);
SqlParameter pm2 = new SqlParameter("@id", id_module_quyen);
SqlParameter pm3 = new SqlParameter("@id_nguoidung", id_nguoidung);
SqlParameter pm4 = new SqlParameter("@module", module);
SqlParameter pm5 = new SqlParameter("@id_quyen", id_quyen);
SqlParameter[] param = new SqlParameter[5] {
pm, pm2, pm3, pm4, pm5
};
DataTable tb = kn.get_by_procedure("proc_Action_ModuleQuyen", param);
if (tb != null)
{
foreach (DataRow row in tb.Rows)
{
ModuleQuyen module_quyen = new ModuleQuyen();
module_quyen.ID_Module_Quyen = Convert.ToInt16(row["ID"]);
module_quyen.Ten_Nguoi_Dung = row["TenHienThi"].ToString();
module_quyen.Module = row["Module"].ToString();
module_quyen.Ten_Quyen = row["TenQuyen"].ToString();
quyen_col.Add(module_quyen);
}
}
return(quyen_col);
}
