DAL/StuCourseDAO.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MODEL;
using System.Data;
using System.Data.SqlClient;

namespace DAL
{
    public class StuCourseDAO
    {
         private SQLHelper sqlhelper;
         public StuCourseDAO()
         {
             sqlhelper = new SQLHelper();
         }
         #region 查看单一学生所选全部班级
         /// <summary>
         /// 查看单一学生所选全部班级
         /// </summary>
         /// <param name="n">学生Id</param>
         /// <returns></returns>
         public DataTable SelectClassByStu(string n)
         {
             SqlParameter[] paras = new SqlParameter[]
            {
                 new SqlParameter ("@value",n ),
            };
             return sqlhelper.ExecuteQuery("SELECT teachers.name AS teacherName , classes.classId, classes.name AS className, classes.term, classes.teacherId FROM classes INNER JOIN teachers ON classes.teacherId = teachers.teacherId INNER JOIN stuCourse ON classes.classId = stuCourse.classId WHERE  stuCourse.studentId=@value", paras, CommandType.Text);
         }
         #endregion
         #region 查看单一学生单一学期所选全部班级
         /// <summary>
         /// 查看单一学生单一学期所选全部班级
         /// </summary>
         /// <param name="n">学生Id</param>
         /// <param name="m">学期</param>
         /// <returns></returns>
         public DataTable SelectClassByStuTerm(string n,string m)
         {
             SqlParameter[] paras = new SqlParameter[]
            {
                 new SqlParameter ("@studentId",n ),
                 new SqlParameter ("@term",m ),
            };
             return sqlhelper.ExecuteQuery("SELECT teachers.name AS teacherName , classes.classId, classes.name AS className, classes.teacherId FROM classes INNER JOIN teachers ON classes.teacherId = teachers.teacherId INNER JOIN stuCourse ON classes.classId = stuCourse.classId WHERE  stuCourse.studentId=@studentId AND classes.term=@term", paras, CommandType.Text);
         }
         #endregion
         #region 查看单一教师所教全部班级
         /// <summary>
         /// 查看单一教师所教全部班级
         /// </summary>
         /// <param name="n">教师Id</param>
         /// <returns></returns>
         public DataTable SelectClassByTea(string n)
         {
             SqlParameter[] paras = new SqlParameter[]
            {
                 new SqlParameter ("@value",n ),