CourseDAL/TeacherService.cs

（开头部分） 8KB

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

using System;
using System.Collections.Generic;
using System.Text;
using Course.Models;
using System.Data;
using System.Data.SqlClient;

namespace Course.DAL
{
    public class TeacherService
    {
        
        /// <summary>
        /// 根据教师名字得到教师的ID
        /// </summary>
        /// <param name="teacherName">教师的名字</param>
        /// <returns></returns>
        public int GetTeacherIdByTeacherName(string teacherName)
        {
            int teacherID = 0;
            using (SqlConnection conn = new SqlConnection(DBHelper.conStr))
            {
                SqlCommand cmd = new SqlCommand("usp_GetTeacherIDByTeacherName", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@teacherName", SqlDbType.NVarChar).Value = teacherName;
                conn.Open();

                teacherID = Convert.ToInt32(cmd.ExecuteScalar());

            }
            return teacherID;
        }
        /// <summary>
        /// 添加教师
        /// </summary>
        /// <param name="teacher">Teacher teacher</param>
        /// <returns></returns>
        public string AddTeacher(Teacher teacher)
        {
            string message = string.Empty;
            using (SqlConnection conn = new SqlConnection(DBHelper.conStr))
            {
                SqlCommand cmd = new SqlCommand("usp_AddTeacher", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                SqlParameter[] par = new SqlParameter[4];
                par[0] = new SqlParameter("@teacherName", teacher.TeacherName); 
                par[1] = new SqlParameter("@direction", teacher.Direction);
                par[2] = new SqlParameter("@state", teacher.State);
                par[3] = new SqlParameter("@remark", teacher.Remark);
                cmd.Parameters.AddRange(par);
                conn.Open();
                message = cmd.ExecuteNonQuery() == 1 ? "添加成功！" : "添加失败！";
            }
            return message;
        }
        /// <summary>
        /// 得到所有教师的集合
        /// </summary>
        /// <returns></returns>
        public DataTable GetAllTeacher()
后面还有 148 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 积分/个。 规则说明

AI 解读

登录后可用，每次 10 积分，解读结果公开显示在下面。

还没有人解读过这个文件。