SQLServerDAL/StudentDAL.cs

这里只显示每个文件的开头 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.WebConfig;
using CheckOnWork.DBHelper;
using CheckOnWork.IDAL;

namespace CheckOnWork.SQLServerDAL
{
     public class StudentDAL:DBAccess,IStudent
     {
         #region 按系别得到该系学生信息IList<Student>
         /// <summary>
         /// 按系别得到该系学生信息IList
         /// </summary>
         /// <param name="departmentId">系别编号</param>
         /// <returns></returns>
         public IList<Student> GetStudentsByDepartment(int departmentId)
        {
            SqlParameter param = new SqlParameter("@departmentId", departmentId);
             IList<Student> list=new List<Student>();

            using (SqlDataReader read = ExecuteReader(StoredProcedureName.StudentSelectByDepartmentId, param))
            {
                while (read.Read())
                {
                    Student stu = new Student(read.GetString(0), read.GetString(1), read.GetString(2),read.GetInt32(3),read.GetString(4),read.GetDateTime(5),read.GetString(6));

                    list.Add(stu);
                }
            }

            return list;
        }
        #endregion

         #region 添加学生信息
         /// <summary>
         /// 添加学生信息
         /// </summary>
         /// <param name="student">Student对象</param>
         /// <returns></returns>
         public int Insert(Student student)
        {
            SqlParameter[] param = { 
                                   new SqlParameter("@studentID",student.studentID),
                                   new SqlParameter("@studentName",student.studentName),
                                   new SqlParameter("@studentPwd",student.studentPwd),
                                   new SqlParameter("@professionalID",student.professionalID),
                                   new SqlParameter("@studentSex",student.studentSex),
                                   new SqlParameter("@studentBirthday",student.studentBirthday),
                                   new SqlParameter("@studentPhone",student.studentPhone)