CourseDAL/ClassService.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

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

namespace Course.DAL
{
    public class ClassService
    {
        SourceService sourceService = new SourceService();
        TeacherService teacherService = new TeacherService();
        
        /// <summary>
        /// 根据班级名称得到此班级当前的章节名称
        /// </summary>
        /// <param name="className"></param>
        /// <returns></returns>
        public string GetChapterNameByClassName(string className)
        {
            string chapterName = string.Empty;
            using (SqlConnection conn = new SqlConnection(DBHelper.conStr))
            {
                SqlCommand cmd = new SqlCommand("usp_selectChapterNameByClassName", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@className", SqlDbType.NVarChar).Value = className;
                conn.Open();
                using (SqlDataReader objReader = cmd.ExecuteReader())
                {
                    if (objReader.Read())
                    {
                        chapterName = objReader[0].ToString();
                    }
                }
                
            }
            return chapterName;
        }
        /// <summary>
        /// 根据班级名称得到此班级以后的章节名称
        /// </summary>
        /// <param name="className">班级名称</param>
        /// <param name="number">多少课时之后</param>
        /// <returns></returns>
        public string GetChapterNameByClassName(string className, int number)
        {
            string chapterName = string.Empty;
            using (SqlConnection conn = new SqlConnection(DBHelper.conStr))
            {
                SqlCommand cmd = new SqlCommand("usp_SelectNextChapterNameByClassName", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@className", SqlDbType.NVarChar).Value = className;
                cmd.Parameters.Add("@hours", SqlDbType.Int).Value = number;
                conn.Open();
                using (SqlDataReader objReader = cmd.ExecuteReader())
                {
                    if (objReader.Read())
                    {
                        chapterName = objReader[0].ToString();