DAL/StuDal.cs

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

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

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


namespace DAL
{
    public class StuDal
    {
        StudentDataClassesDataContext db = new StudentDataClassesDataContext();
        #region
        /// <summary>
        /// 判断學生登录时的用户名密码
        /// </summary>
        /// <param name="stuname"></param>
        /// <param name="stupwd"></param>
        /// <returns></returns>
        public bool StudentLogion(string stuname,string stupwd)
        {
            var result = from i in db.StuInfo
                     where i.stuName == stuname && i.stuPwd == stupwd
                     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<StuInfo> StudentLogions(string stuname, string stupwd)
        {
            var result = from i in db.StuInfo
                         where i.stuName == stuname && i.stuPwd == stupwd
                         select i;
            return result.ToList();
        }
        /// <summary>
        /// 获取学生信息
        /// </summary>
        /// <returns></returns>
        public List<Model.StuInfo> GetStuInfo()
        {
            return db.StuInfo.ToList();
        }
        /// <summary>
        /// 根据ID获取学生信息
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>