DAL/TeacherService.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 TeacherService
    {
        //查重
        public static teacher getName(int TeacherNum)
        {
            string sql = $"select * from Teacherinfo where TeacherNum='{TeacherNum}'";
            SqlDataReader dr = DBHelper.getData(sql);
            teacher tc = null;
            while (dr.Read())
            {
                tc = new teacher()
                {
                    TeacherID = dr.GetInt32(0),
                    TeacherNum = dr.GetInt32(1),
                    TeacherName = dr.GetString(2),
                    TeacherPwd= dr.GetString(3),
                    TeacherSex = dr.GetString(4),
                };
            }
            dr.Close();
            return tc;
        }
        //添加
        public static bool Insert(teacher tc)
        {
            string sql = string.Format("INSERT INTO [dbo].[Teacherinfo]([TeacherNum] ,[TeacherName],[TeacherSex],[TeacherPwd]) VALUES('{0}', '{1}','{2}','{3}')", tc.TeacherNum, tc.TeacherName, tc.TeacherSex,tc.TeacherPwd);
            return DBHelper.updateData(sql);
        }
        //更新
        public static bool updata(teacher tc)
        {
            string sql = $"UPDATE [dbo].[Teacherinfo] SET [TeacherNum] = '{tc.TeacherNum}',[TeacherName] ='{tc.TeacherName}',[TeacherSex] ='{tc.TeacherSex}' where TeacherID='{tc.TeacherID}'";
            return DBHelper.updateData(sql);
        }
        //删除
        public static bool Delete(int id)
        {
            string sql = $"DELETE FROM [dbo].[Teacherinfo] WHERE TeacherID='{id}'";
            return DBHelper.updateData(sql);
        }
        
        //条件查询-姓名
        public static List<teacher> getList2(teacher tc)
        {
            string sql = $"select * from Teacherinfo where TeacherName like '%{tc.TeacherName}%'";
            SqlDataReader dr = DBHelper.getData(sql);

            List<teacher> list = new List<teacher>();
            teacher obj = null;
            while (dr.Read())