Form2

?using System;
using System.Collections.Generic;
using https://www.360docs.net/doc/bb10003653.html,ponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace N04
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}

private void Form2_Load(object sender, EventArgs e)
{
Bind();

cboGrade.DisplayMember = "GradeName";
cboGrade.ValueMember = "GradeID";
cboGrade.DataSource = N04DAL.GradeService.GetAllGrade();
}

private void Bind()
{
dataGridView1.DataSource = N04DAL.TeacherService.GetAllTeacher();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
int gradeId = Convert.ToInt32(dataGridView1.Rows[i].Cells["Column4"].Value);
N04Models.Grade g = N04DAL.GradeService.GetGradeById(gradeId);
dataGridView1.Rows[i].Cells["Column5"].Value = g.GradeName;
}
}

private void btnAdd_Click(object sender, EventArgs e)
{
N04Models.Teacher t = new N04Models.Teacher();
t.age = Convert.ToInt32(txtAge.Text);
t.gradeId = Convert.ToInt32(cboGrade.SelectedValue);
https://www.360docs.net/doc/bb10003653.html, = Convert.ToString(txtName.Text);
t.teachYear = Convert.ToInt32(txtTeachYear.Text);

if (btnAdd.Text == "添加")
{
int result = N04DAL.TeacherService.Add(t);
if (result > 0)
{
MessageBox.Show("添加成功");
Bind();
}
else
{
MessageBox.Show("添加失败");
}
}
else
{
t.id = Convert.ToInt32(dataGridView1.Rows[0].Cells["Column6"].Value);
int result = N04DAL.TeacherService.Update(t);
if (result > 0)
{
MessageBox.Show("修改成功");
Bind();
}
else
{
MessageBox.Show("修改失败");
}
}
}

private void button1_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count > 0)
{
int id = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["Column6"].Value);
int result = N04DAL.TeacherService.Delete(id);
if (result > 0)
{
MessageBox.Show("删除成功");
Bind();
}
else
{
MessageBox.Show("删除失败");
}
}
}

private void dataGridVi

ew1_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count > 0)
{
int id = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["Column6"].Value);
N04Models.Teacher t = N04DAL.TeacherService.GetTeacherById(id);
txtAge.Text = t.age.ToString();
txtName.Text = https://www.360docs.net/doc/bb10003653.html,;
txtTeachYear.Text = t.teachYear.ToString();
cboGrade.SelectedValue = t.gradeId;
btnAdd.Text = "修改";

}
}
}
}