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

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 + "," + GradeId + ")";
            SqlCommand cmd = new SqlCommand(sql, con);
            con.Open();
            int count = cmd.ExecuteNonQuery();
            con.Close();
            if (count > 0)
            {
                flag = true;
            }

            return flag;
        }

        //年级
        //年级
        public DataTable GradeName()
        {
            string strcon = "Data Source=.;Initial Catalog=MySchool;Integrated Security=True";
            SqlConnection con = new SqlConnection(strcon);
            con.Open();
            string sql = "select gradeid,gradename from grade";
            SqlDataAdapter da = new SqlDataAdapter(sql, con);
            DataSet ds = new DataSet();
            da.Fill(ds, ("info"));

            return ds.Tables["info"];
        }


        //删除
        public int delect(int id)
        {
            bool flag = false;
            SqlConnection con=new SqlConnection(str);
            string sql = "delete from Teacher where Id=" + id;
            SqlCommand cmd = new SqlCommand(sql, con);
            con.Open();
            int i = cmd.ExecuteNonQuery();

            if (i > 0)
            {
                flag = true;
            }

               return i;
        }
    }
}
    

teacherbll

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using TeacherDAL;
using TeacherModel;

namespace TeacherBLL
{
   public class teacherBLL
    {
teacherDAL dal=new teacherDAL();

       public DataTable teacher()
       {
           return dal.teacher();
       }

       public bool Add(string Name, int Age, int TeacherYear, int GradeId)
       {
           return dal.Add(Name, Age, TeacherYear, GradeId);
       }

       //年级
       public DataTable GradeName()
        {
            return dal.GradeName();
       }

       public int delect(int id)
       {
           return dal.delect(id);
       }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace TeacherModel
{
   public class teacherModel
    {

        public string Name { get; set; }

        public int  Age { get; set; }

        public int TeacherYear { get; set; }

        public int GradeId { get; set; }
    }
}

UI

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using TeacherBLL;
using TeacherModel;

namespace TeacherUI
{
    public partial class FrmMain : Form
    {
        public FrmMain()
        {
            InitializeComponent();
        }
        teacherBLL bll=new teacherBLL();
        teacherModel model = new teacherModel();
        private void FrmMain_Load(object sender, EventArgs e)
        { 
            DataTable dt = bll.teacher();
            dgvList.DataSource = dt;
        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            Add add=new Add();
            add.Show();
        }

        private void btndelece_Click(object sender, EventArgs e)
        {
            foreach (DataGridViewRow row in dgvList.Rows)
            {
                DataGridViewCheckBoxCell cell=(DataGridViewCheckBoxCell)row.Cells[0];
                bool flag = Convert.ToBoolean(cell.Value);
                if (flag)
                {
                    int id = Convert.ToInt32(cell.OwningRow.Cells[1].Value);
                    int i = bll.delect(id);
                    if (i > 0)
                    {
                        MessageBox.Show("删除成功");
                   
                    }
                    else
                    {
                        MessageBox.Show("删除失败");
                    }

                }
              
            }
        }
    }
}

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using TeacherBLL;
using TeacherModel;

namespace TeacherUI
{
    public partial class Add : Form
    {
        public Add()
        {
            InitializeComponent();
        }
        teacherBLL bll=new teacherBLL();
        teacherModel model=new teacherModel();
        private void button1_Click(object sender, EventArgs e)
        {
            string Name = textBox1.Text;
            int Age = Convert.ToInt32(textBox2.Text);
            int TeacherYear = Convert.ToInt32(textBox3.Text);
             int GradeId = Convert.ToInt32(comboBox1.SelectedValue);
             bool flag = bll.Add(Name, Age, TeacherYear, GradeId);
            if (flag)
            {
                MessageBox.Show("添加成功");
                this.Hide();
            }
            else
            {
                MessageBox.Show("添加失败");
            }
        }

        private void Add_Load(object sender, EventArgs e)
        {
            comboBox1.DisplayMember = "gradename";
            comboBox1.ValueMember = "gradeid";
            comboBox1.DataSource = bll.GradeName();

        }
    }
}