SQLServerDAL/TeacherDAL.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.IDAL;
using CheckOnWork.DBHelper;
using CheckOnWork.WebConfig;

namespace CheckOnWork.SQLServerDAL
{
   public  class TeacherDAL:DBAccess,ITeacher
   {

       #region 得到某系的教师返回一个集合
       /// <summary>
       /// 得到某系的教师返回一个集合
       /// </summary>
       /// <param name="departmentId">系别</param>
       /// <returns></returns>
        public IList<Teacher> GetTeachersByDepartment(int departmentId)
        {
            
            SqlParameter param = new SqlParameter("@departmentId", departmentId);
            IList<Teacher> list =new List<Teacher>();

            using (SqlDataReader read =ExecuteReader( StoredProcedureName.teacherSelectByDepartmentId,param))
            {
                while (read.Read())
                {
                    Teacher teac = new Teacher(read.GetString(0),read.GetString(1),read.GetString(2),read.GetInt32(3),read.GetString(4),read.GetString(5),read.GetString(6));

                    list.Add(teac);
                }
            }

            return list;



        }
       #endregion

        #region  添加教师信息
        /// <summary>
       /// 添加教师信息 添加失败则返回-1
       /// </summary>
       /// <param name="teacher">teacher对象</param>
       /// <returns></returns>
        public int Insert(Teacher teacher)
        {
            SqlParameter[] param = { 
                                   new SqlParameter("@teacherID",teacher.teacherID),
                                   new SqlParameter("@teacherName",teacher.teacherName),
                                   new SqlParameter("@teacherPwd",teacher.teacherPwd),
                                   new SqlParameter("@departmentID",teacher.departmentID),