//修改 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); }