SQLServerDAL/CourseDetailDAL.cs

（开头部分） 5KB

这里只显示每个文件的开头 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
{
    public class CourseDetailDAL:DBAccess,ICourseDetail
    {
        public IList<CourseDetail> CourseDetailGetByDepartment(int departmentId)
        {
            IList<CourseDetail> list = new List<CourseDetail>();
            SqlParameter param = new SqlParameter("@departmentID", departmentId);

            using (SqlDataReader read = ExecuteReader(StoredProcedureName.CourseDetailGetByDepartment, param))
            {
                while (read.Read())
                {
                    CourseDetail course = new CourseDetail(read.GetInt32(0),read.GetString(1), read.GetString(2), read.GetString(3), read.GetInt32(4), read.GetInt32(5), read.GetString(6), read.GetString(7), read.GetInt32(8), read.GetString(9), read.GetString(10), read.GetString(11), read.GetString(12));

                    list.Add(course);
                }

                return list;
            }
        }


        public int Delete(int courseDetailID)
        {
            SqlParameter param = new SqlParameter("@cdID",courseDetailID);

            return ExecuteNonQuery(StoredProcedureName.CourseDetailDelete, param);
        }

        public int Insert(CourseDetail course)
        {
            SqlParameter[] param = { 
                                   new SqlParameter("@teacherID",course.teacherID),
                                   new SqlParameter("@weekCycle",course.weekCycle),
                                   new SqlParameter("@section",course.section),
                                   new SqlParameter("@classroomID",course.classroomID),
                                   new SqlParameter("@courseID",course.courseID),
                                   new SqlParameter("@teachMethod",course.teachMethod),
                                   new SqlParameter("@professionalID",course.professionalID),
                                   new SqlParameter("@annualID",course.annualID)
                                   };

            return ExecuteNonQuery(StoredProcedureName.CourseDetailInsert, param);
        }


        public IList<CourseDetail> GetDetailByCourseAndTeacher(string teacherId, int courseID)
后面还有 70 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。