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); }