DAL/Class_CourseDAL.cs

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

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

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



namespace DAL
{
   public  class Class_CourseDAL
    {
       #region//显示班级已经选课的情况
       public DataTable GetClaCur()
       {
           string strClaCurSql = "SELECT  dbo.Class_Course.ID, dbo.Class.cNo, dbo.Class.cName, dbo.Class_Course.curNo, dbo.Course.curName" +
                                   " FROM  dbo.Class INNER JOIN   dbo.Class_Course ON dbo.Class.cNo = dbo.Class_Course.cNo INNER JOIN" +
                                   " dbo.Course ON dbo.Class_Course.curNo = dbo.Course.curNo";
           try
           {
               SqlConnection conn = DBHelper.Connection;
               if (DBHelper.GetTable(strClaCurSql).Rows.Count > 0)
               {
                   return DBHelper.GetTable(strClaCurSql);
               }
               else
                   return null;

           }
           catch (Exception ex)
           {
               throw ex;
           }

       }
       #endregion
       #region//添加选课
       public bool ClaCurAdd(Class_Course clacur, DataTable clastu)
       {
           SqlConnection conn = DBHelper.Connection;
           Class_Course cc = new Class_Course();
           DataTable dtClaStu = clastu;
           if (dtClaStu.Rows.Count > 0)
           {
               for (int i = 0; i <= dtClaStu.Rows.Count - 1; i++)
               {//添加学生
                   string sNo = dtClaStu.Rows[i]["sNo"].ToString();
                   string strInserStu = "insert into score (sNo,curNo,cNo) values('" + sNo + "','" + clacur.CurNo + "','" + clacur.CNo + "')";
                   DBHelper.GetTable(strInserStu);
               }
              //添加选课
               string insertSql = "insert into Class_Course(cNo,curNo) values('" + clacur.CNo + "','" + clacur.CurNo + "')";
               if (DBHelper.GetTable(insertSql).Rows.Count > 0)
               {
                   return true;
               }
               else
               {