DAL/TeacherDAL.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Model;
using System.Data.SqlClient;
using System.Configuration;

namespace DAL
{
    public class TeacherDAL
    {
        public bool InsertOneRecord(Teacher teacher)
        {
            // 1. 创建连接
            SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["XDF"].ConnectionString);

            // 2. 打开连接
            connection.Open();

            // 2.1 创建命令对象
            SqlCommand command = new SqlCommand("INSERT INTO Teacher(TeaID, TeaName, Password, Sex,  TeachGrade,  Email, Phone,BaseID,TeachSubject,Degree,DOB,Address,Introduce) VALUES(@TeaID, @TeaName, @Password, @Sex, @TeachGrade,  @Email, @Phone,@BaseID,@TeachSubject,@Degree,@DOB,@Address,@Introduce)", connection);
            command.Parameters.AddWithValue("@TeaID", teacher.TeaID);
            command.Parameters.AddWithValue("@TeaName", teacher.TeaName);
            command.Parameters.AddWithValue("@Password", teacher.Password);
            command.Parameters.AddWithValue("@Sex", teacher.Sex);
            command.Parameters.AddWithValue("@DOB", teacher.DOB);
            command.Parameters.AddWithValue("@Degree", teacher.Degree);
            command.Parameters.AddWithValue("@TeachSubject", teacher.TeachSubject);
            command.Parameters.AddWithValue("@TeachGrade", teacher.TeachGrade);
            command.Parameters.AddWithValue("@BaseID", teacher.BaseID);
            command.Parameters.AddWithValue("@Email", teacher.Email);
            command.Parameters.AddWithValue("@Phone", teacher.Phone);
            command.Parameters.AddWithValue("@Address", teacher.Address);
            command.Parameters.AddWithValue("@Introduce", teacher.Introduce);

            // 2.2 执行命令对象
            int result = command.ExecuteNonQuery();

            // 3. 关闭连接
            connection.Close();

            return (result == 1);
        }
        public bool ModifyState(Teacher teacher)
        {
            // 1. 创建连接
            SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["XDF"].ConnectionString);

            // 2. 打开连接
            connection.Open();

            // 2.1 创建命令对象
            SqlCommand command = new SqlCommand("UPDATE Teacher SET State=@State WHERE TeaID=@TeaID", connection);
            command.Parameters.AddWithValue("@TeaID", teacher.TeaID);
            command.Parameters.AddWithValue("@State", teacher.State);
            

            // 2.2 执行命令对象
            int result = command.ExecuteNonQuery();