/// <summary> /// Programmer:liuxubang /// time:7-18 15:47 /// 通过子模块的编号获得相应的权限 /// </summary> /// <param name="moduleCode"></param> /// <returns></returns> public IList <Sys_module_right> GetModuleRightByCode(String moduleCode) { IList <Sys_module_right> list = new List <Sys_module_right>(); MySqlParameter[] param = new MySqlParameter[] { new MySqlParameter("?moduleCode", moduleCode) }; try { using (MySqlDataReader reader = MySqlHelper.ExecuteReader(SELECT_BYCODE, param)) { while (reader.Read()) { Sys_module sysModule = new Sys_module(); sysModule.Module_code = reader.GetString(1); Sys_module_operate sysModuleOperate = new Sys_module_operateService().GetModuleOperateByOperateId(reader.GetInt32(3)); //Sys_module_right sysModuleRight = new Sys_module_right(reader.GetInt32(0), sysModule, sysModuleOperate, reader.GetChar(2), reader.GetString(4)); Sys_module_right sysModuleRight = new Sys_module_right(); sysModuleRight.Module_right_id = reader.GetInt32("Module_right_id"); sysModuleRight.Module_code = reader.GetString("Module_code"); sysModuleRight.OperateID = reader.GetInt32("OperateID"); sysModuleRight.Status = reader.GetString("status"); sysModuleRight.Right_page = reader.GetString("right_page"); list.Add(sysModuleRight); } reader.Close(); } } catch (Exception e) { Console.WriteLine(e.Message); } return(list); }
///<summary> ///添加方法,返回Boolean类型,为true表示操作成功,否则操作失败 ///生成时间:2010-8-27 22:00:49 ///</summary> public Boolean AddSys_module_right(Sys_module_right sys_module_right) { MySqlParameter[] param = new MySqlParameter[] { new MySqlParameter("?Module_code", sys_module_right.Module_code), new MySqlParameter("?OperateID", sys_module_right.OperateID), new MySqlParameter("?status", sys_module_right.Status), new MySqlParameter("?right_page", sys_module_right.Right_page) }; return(MySqlHelper.ExecuteNonQuery(SQL_INSERT, param) > 0); }
///<sumary> ///修改信息 ///时间:2010-8-27 22:01:16 ///</sumary> public static Boolean UpdateSys_module_right(Sys_module_right sys_module_right) { try { return(sys_module_rightService.UpdateSys_module_right(sys_module_right)); } catch (Exception ex) { //可以记录到异常日志 return(false); } }