DAL/LesService.cs

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

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

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

namespace DAL
{
    public class LesService
    {
        //自动删除被驳回的过期申请（7天前）
        public static bool AutoDelete()
        {
            string sql = $"delete from Lessoninfo where  DATEDIFF(DAY,SubTime,GETDATE())>7 and LessonAudit='驳回'";
            return DBHelper.updateData(sql);
        }
        //从数据库获取指定教师账号
        public static teacher getTNum(string tName)
        {
            string sql = $"select TeacherNum from Teacherinfo where TeacherName='{tName}'";
            SqlDataReader dr = DBHelper.getData(sql);
            teacher obj = null;

            if (dr.Read())
            {
                obj = new teacher()
                {
                    TeacherNum = dr.GetInt32(0)
                };
            }
            dr.Close();
            return obj;
        }
        //显示我的学生
        public static List<student> SelStu(int teacherNum)
        {
            string sql = $"select * from lessonSelect ls inner join Lessoninfo lf on ls.id=lf.id inner join Studentinfo s on s.StudentName=ls.StudentName where lf.TeacherNum='{teacherNum}'";
            SqlDataReader dr = DBHelper.getData(sql);
            List<student> list = new List<student>();
            student stu = null;
            while (dr.Read())
            {
                stu = new student()
                {
                    StudentNum = int.Parse(dr["StudentNum"].ToString()),
                    StudentName = dr["StudentName"].ToString(),
                    StudentSex= dr["StudentSex"].ToString(),
                    StudentClass = dr["StudentClass"].ToString(),
                    LessonName=dr["LessonName"].ToString()
                };
                list.Add(stu);
            }
            dr.Close();
            return list;
        }
        //教师(我的审核）
        public static List<Lesson> getMyAudit(Lesson ls)
        {