DAL/StuDAL.cs

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

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

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


namespace DAL
{
   public  class StuDAL
   {

       #region//获取系别
       public DataTable  GetDept(string dept)
       {
           string strdeptstu = "SELECT dbo.Student.sNo, dbo.Student.sName, dbo.Student.sSex, dbo.Student.sbirthday, dbo.Student.sPolitical, dbo.Student.sNation, dbo.Class.cName, dbo.Class.cNo" +
                              " FROM dbo.Class INNER JOIN dbo.Department ON dbo.Class.cdeptNo = dbo.Department.cdeptNo INNER JOIN" +
                       " dbo.Student ON dbo.Class.cNo = dbo.Student.cNo where(dbo.Department.cdeptNo='" + dept  + "')";
           try
           {
               SqlConnection conn = DBHelper.Connection;
               if (DBHelper.GetTable(strdeptstu)!=null)
               {
                   return DBHelper.GetTable(strdeptstu);
               }
               else
                   return null;
           }
           catch (Exception e)
           {

               throw e;
           }
       }
       #endregion
       #region//获取班级
       public DataTable GetClass(string clas)
       {
           string strclsstu = "SELECT  dbo.Student.sNo, dbo.Student.sName, dbo.Student.sSex, dbo.Student.sbirthday, dbo.Student.sPolitical, dbo.Student.sNation, dbo.Class.cName, dbo.Class.cNo" +
                            " FROM dbo.Class INNER JOIN dbo.Student ON dbo.Class.cNo = dbo.Student.cNo WHERE(dbo.Class.cNo = '" + clas  + "')";
           try
           {
               SqlConnection conn = DBHelper.Connection;
               if (DBHelper.GetTable(strclsstu)!=null)
               {
                   return DBHelper.GetTable(strclsstu);
               }
               else
                   return null;
           }
           catch (Exception e)
           {

               throw e;
           }
       }
       #endregion
       #region//获取民族