SQLServerDAL/CourseDAL.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using System.Data;
using System.Data.SqlClient;

using CheckOnWork.Model;
using CheckOnWork.IDAL;
using CheckOnWork.DBHelper;
using CheckOnWork.WebConfig;

namespace CheckOnWork.SQLServerDAL
{
    class CourseDAL:DBAccess,ICourse
    {
        #region 得到某系的课程信息
        /// <summary>
        /// 得到某系的课程信息
        /// </summary>
        /// <param name="departmentId"></param>
        /// <returns></returns>
        public IList<Course> GetCourseByDepartment(int departmentId)
        {
           IList<Course> list =new List<Course>();
           SqlParameter param = new SqlParameter("@departmentID", departmentId);

           using (SqlDataReader read = ExecuteReader(StoredProcedureName.courseSelectByDepartmentId, param))
           {
               while (read.Read())
               {
                   Course course = new Course(read.GetInt32(0), read.GetString(1), read.GetInt32(2), read.GetInt32(3), read.GetInt32(4), read.GetString(5), read.GetInt32(6), read.GetInt32(7));

                   list.Add(course);
               }

               return list;
           }
        }
        #endregion

        #region 添加课程信息
        /// <summary>
        /// 添加课程信息
        /// </summary>
        /// <param name="course"></param>
        /// <returns></returns>
        public int Insert(Course course)
        {
            SqlParameter[] param = { 
                                   new SqlParameter("@courseName",course.courseName),
                                   new SqlParameter("@departmentID",course.departmentID),
                                   new SqlParameter("@annualID",course.annualID),
                                   new SqlParameter("@courseTotalPeriod",course.courseTotalPeriod),
                                   new SqlParameter("@courseType",course.courseType),
                                   new SqlParameter("@courseTuitionPeriod",course.courseTuitionPeriod),
                                   new SqlParameter("@courseEXPPeriod",course.courseEXPPeriod)
                         
                                   };