CourseDAL/ChapterService.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Course.Models;

namespace Course.DAL
{
    public class ChapterService
    {
        /// <summary>
        /// 根据 BookId 获取得 Chapter集合
        /// </summary>
        /// <param name="bookId">书的ID</param>
        /// <returns></returns>
        public List<Chapter> GetChaptersByBookId(int bookId)
        {
            List<Chapter> chapterList = new List<Chapter>();
            using (SqlConnection conn = new SqlConnection(DBHelper.conStr))
            {
                SqlCommand cmd = new SqlCommand("usp_GetChapterByBookID", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@bookID", SqlDbType.Int).Value = bookId;
                conn.Open();
                using (SqlDataReader objReader = cmd.ExecuteReader())
                {
                    Chapter chapter = null;
                    while (objReader.Read())
                    {
                        chapter = new Chapter();
                        chapter = this.GetChapterBySqlDataReader(objReader);
                        chapterList.Add(chapter);
                    }
                    objReader.Close();
                }
            }
            return chapterList;
        }

        /// <summary>
        /// 根据 SqlDataReader 返回 Chapter 对象
        /// </summary>
        /// <param name="reader">SqlDataReader reader</param>
        /// <returns></returns>
        public Chapter GetChapterBySqlDataReader(SqlDataReader reader)
        {
            Chapter chapter = new Chapter();
            chapter.ChapterId = Convert.ToInt32(reader["chapterID"].ToString());
            chapter.ChapterName = reader["chapterName"].ToString();
            chapter.Hours = Convert.ToInt32(reader["hours"].ToString());
            chapter.BookId = Convert.ToInt32(reader["bookID"].ToString());
            return chapter;
        }
    }
}