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