DAL/TeacherDal.cs

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

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

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

namespace DAL
{
    public class TeacherDal
    {
        StudentDataClassesDataContext db = new StudentDataClassesDataContext();
        #region
        /// <summary>
        /// 判断教师登录时的用户名密码
        /// </summary>
        /// <param name="stuname"></param>
        /// <param name="stupwd"></param>
        /// <returns></returns>
        public bool TeacherLogion(string teaname, string teapwd)
        {
            var result = from i in db.Teacher
                         where i.teaName == teaname  && i.teaPwd == teapwd
                         select i;
            if (result.ToList().Count > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        #endregion
        /// <summary>
        /// 判断教师登录时的用户名密码
        /// </summary>
        /// <param name="stuname"></param>
        /// <param name="stupwd"></param>
        /// <returns></returns>
        public List<Teacher> TeacherLogions(string teaname, string teapwd)
        {
            var result = from i in db.Teacher
                         where i.teaName == teaname && i.teaPwd == teapwd
                         select i;
            return result.ToList();
        }
        /// <summary>
        /// 获取老师信息
        /// </summary>
        /// <returns></returns>
        public List<Model.Teacher> GetTeacherInfo()
        {
            return db.Teacher.ToList();
        }
        ///<summary>
        ///通过ID查询
        ///</summary>
        ///<param name="id"></param>
        ///<returns></returns>
        public List<Model.Teacher> GetTeacherByID(int id)