/// <summary> /// 从SqlDataReader中读取数据,返回RecomBook对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> private RecomBook LoadRecomBook(SqlDataReader reader) { Book book = new BookService().GetBookById(reader.GetInt32(1)); UserInfo user = new UserService().GetUserInfoById(reader.GetInt32(2)); RecomBook recomBook = new RecomBook(reader.GetInt32(0), book, user); return(recomBook); }
/// <summary> /// 根据Id获得RecomBook对象 /// </summary> /// <param name="id"></param> /// <returns></returns> public RecomBook GetRecomBookById(int id) { RecomBook recomBook = null; string sql = "select Id,BookId,UserId from RecomBooks where Id = @Id"; SqlDataReader reader = DBHelper.ExecuteReader(sql, CommandType.Text, new SqlParameter("@Id", id)); if (reader.HasRows) { if (reader.Read()) { recomBook = LoadRecomBook(reader); } } reader.Close(); return(recomBook); }