//修改
private void btnUpdate_Click_1(object sender, EventArgs e)
{
Teacher t = TeacherManageAction0.QueryTeacherInfo(tbWorkerNo.Text);
InputTeacherForm asf = new InputTeacherForm(t);
asf.MdiParent = this.MdiParent;
asf.Show();
TeacherManageAction0.loadAllTeacher(lvWorkerList, "", "", "");
}
//查询
private void btSearch_Click_1(object sender, EventArgs e)
{
string tNo = tbWorkerNo.Text;
string tName = tbWorkerName.Text;
string deptId = cbFaculty.Text;
lvWorkerList.Items.Clear();
TeacherManageAction0.loadAllTeacher(lvWorkerList, tName, tNo, deptId);
}
private void lvWorkerList_SelectedIndexChanged_1(object sender, EventArgs e)
{
if (lvWorkerList.SelectedItems.Count == 0)
{
return; //未选中任何一行
}
string tno = lvWorkerList.SelectedItems[0].Text; //取选中行中的第一行的第一列文本
tbWorkerNo.Text = tno;
tbWorkerName.Text = lvWorkerList.SelectedItems[0].SubItems[1].Text;
cbFaculty.Text = lvWorkerList.SelectedItems[0].SubItems[3].Text;
TeacherManageAction0.loadSelectedCourse(lvCourse, tno); //与课本不同，多一个参数
}
//删除一条教师记录
private void btnDelete_Click_1(object sender, EventArgs e)
{
if (tbWorkerNo.Text == "")
{
return;
}
if (MessageBox.Show("Are you sure?", "", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
int i = TeacherManageAction0.delTeacher(tbWorkerNo.Text.Trim());
MessageBox.Show(i + " row(s) affected");
}
TeacherManageAction0.loadAllTeacher(lvWorkerList, "", "", "");
}
//增加
private void btAdd_Click_1(object sender, EventArgs e)
{
string deptId = (string)htDeptName[cbDept.Text];
int i = 0;
if (tbWorkerNo.Text.Trim().Equals(""))
{
MessageBox.Show("工号不能为空", "提示");
tbWorkerName.Focus();
return;
}
Teacher teacher = new Teacher(tbWorkerNo.Text, tbWorkerName.Text, cbSex.Text, deptId);
TeacherManageAction0 tma = new TeacherManageAction0();
tma.setTeacher(teacher);
if (isUpdate == false)
{
i = tma.addTeacher();
if (i > 0)
{
MessageBox.Show(string.Format("增加了{0}条记录", i));
foreach (Control ctrl in groupBox1.Controls)
{
if (!(ctrl is Label))
{
ctrl.Text = "";
}
}
}
else
{
MessageBox.Show("添加不成功");
}
}
else
{
i = tma.updateTeacher();
if (i > 0)
{
MessageBox.Show(string.Format("更新了{0}条记录", i));
this.Close();
}
else
{
MessageBox.Show("更新不成功");
}
}
}
private void btnReUpdate_Click(object sender, EventArgs e)
{
TeacherManageAction0.loadAllTeacher(lvWorkerList, "", "", "");
}
public void loadSelectCourse(ListView lv)
{
TeacherManageAction0.loadSelectedCourse(lv, workerNo);
}
