/// <summary> /// 根据角色ID取得角色信息 /// </summary> /// <param name="RoleId"></param> /// <returns></returns> public RoleInfo GetRoleById(string RoleId) { RoleInfo info = new RoleInfo(); using (DbDataReader reader = DataBaseManage.ExecuteReader(_SelectSql + " where roleid='" + RoleId + "'")) { if (reader.Read()) { info = BuilderEntity(reader); } } return info; }
/// <summary> /// /// </summary> /// <param name="role"></param> /// <returns></returns> public bool ModifyRole(RoleInfo role) { return _role.ModifyRole(role); }
/// <summary> /// /// </summary> /// <param name="role"></param> /// <returns></returns> public bool CreateRole(RoleInfo role) { return _role.CreateRole(role); }
private RoleInfo BuilderEntity(DbDataReader reader) { RoleInfo info = new RoleInfo(); info.RoleId = (reader.IsDBNull(reader.GetOrdinal("roleid"))) ? int.Parse("0") : int.Parse(reader["roleid"].ToString()); info.RoleName = (reader.IsDBNull(reader.GetOrdinal("rolename"))) ? "" : reader["rolename"].ToString(); info.Remark = (reader.IsDBNull(reader.GetOrdinal("remark"))) ? "" : reader["remark"].ToString(); return info; }
/// <summary> /// /// </summary> /// <param name="role"></param> /// <returns></returns> public bool ModifyRole(RoleInfo role) { string Sql = string.Format("Update roleinfo Set rolename = '{0}',remark = '{1}' Where roleid = '{2}'", role.RoleName,role.Remark, role.RoleId); return DataBaseManage.ExecuteSql(Sql) > 0; }
/// <summary> /// /// </summary> /// <param name="role"></param> /// <returns></returns> public bool CreateRole(RoleInfo role) { string Sql = string.Format("Insert Into roleinfo(rolename,remark)Values('{0}','{1}')", role.RoleName,role.Remark); return DataBaseManage.ExecuteSql(Sql) > 0; }