DAL/ScoreDAL.cs

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

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

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


namespace DAL
{
   public  class ScoreDAL
    {
       #region//获取选课学生信息
       public DataTable GetStuInfo(string pnode)
       {
           string strClass = "SELECT  dbo.Class_Course.curNo, dbo.Class.cName, dbo.Class.cNo" +
                                       " FROM  dbo.Class INNER JOIN dbo.Class_Course ON dbo.Class.cNo = dbo.Class_Course.cNo" +
                                      " WHERE(dbo.Class_Course.curNo = '" + pnode + "')";
           try
           {
               SqlConnection conn = DBHelper.Connection;
               if (DBHelper.GetTable(strClass).Rows.Count > 0)
               {
                   return DBHelper.GetTable(strClass);
               }
               else
                   return null;

           }
           catch (Exception ex)
           {
               throw ex;
           }

       }
       #endregion
        #region//获取学生成绩信息
       public DataTable GetStuSco(Score score)
       {
           string strStuScore = "SELECT     dbo.Student.sName, dbo.Score.sNo, dbo.Score.curNo, dbo.Score.cNo, dbo.Score.grade" +
                              " FROM dbo.Score INNER JOIN dbo.Student ON dbo.Score.sNo = dbo.Student.sNo" +
                              " WHERE (dbo.Score.curNo = '" + score .CurNo  + "') AND (dbo.Score.cNo ='" + score .CNo  + "')";

          try
          {
              SqlConnection conn = DBHelper.Connection;
              if (DBHelper.GetTable(strStuScore).Rows.Count > 0)
              {
                  return DBHelper.GetTable(strStuScore);
              }
              else
                  return null;

          }
          catch (Exception ex)
          {
              throw ex;
          }
       }