C#分层第六章教师管理系统

最新推荐文章于 2024-07-20 00:09:35 发布

_苏小白

最新推荐文章于 2024-07-20 00:09:35 发布

阅读量1.2k

点赞数 1

本文链接：https://blog.csdn.net/qq_36074043/article/details/69569056

版权

本文详细介绍了使用C#进行教师管理系统分层设计的实现，重点讲解了业务逻辑层(BLL)的设计与应用。

摘要由CSDN通过智能技术生成

TeacherDAL

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Teacher.DAL;
using TeacherModel;

namespace TeacherDAL
{
    public class teacherDAL
    {
        private string str = "Data Source=.;Initial Catalog=MySchool;Integrated Security=True";
        //显示所有信息
        public DataTable teacher()
        {


            SqlConnection con = new SqlConnection(str);
            string sql = "select * from teacher,grade where grade.gradeid=teacher.gradeid";
            con.Open();
            SqlDataAdapter da = new SqlDataAdapter(sql, con);
            DataSet ds = new DataSet();
            da.Fill(ds, ("info"));

            return ds.Tables["info"];
        }

        //添加新老师

        public bool Add(string Name, int Age, int TeacherYear, int GradeId)
        {

            bool flag = false;
            string str = "Data Source=.;Initial Catalog=MySchool;Integrated Security=True";
            SqlConnection con = new SqlConnection(str);
            string sql = @"INSERT INTO [Teacher]
                       (
      [Name]
      ,[Age]
      ,[TeacherYear]
      ,[GradeId])
                         VALUES
                       ('" + Name + "'," + Age + "," + TeacherYear + "," + GradeI