//设置学生表格数据 private void selectStuData() { student student = new student(); DataSet dataSet = DAO_Student.SelectStuData(student); dgv_stuInfo.DataSource = dataSet.Tables["student"]; }
public void addStudent(int kurs, int student) { DAO_Kurs dao = new DAO_Kurs(); List <Kurs> list = dao.getKursy(); List <string> ls = list[kurs].students; bool check = false; for (int i = 0; i < ls.Count; i++) { string[] enteries = ls[i].Split(','); if (enteries[0] == student.ToString()) { check = true; } } DAO_Student dao_s = new DAO_Student(); List <Student> studenci = dao_s.getStudenci(); for (int i = 0; i < studenci.Count; i++) { if (studenci[i].id == student) { if (!check) { ls.Add(studenci[i].id.ToString() + "," + studenci[i].imie.ToString() + "," + studenci[i].nazwisko.ToString() + "," + studenci[i].indeks.ToString()); } } } list[kurs].students = ls; dao.setKursy(list); }
public UpdateStuInfo(string id) { InitializeComponent(); setMajorData(); student stu = new student(); stu.StuId = id; DataSet ds = DAO_Student.SelectStuData(stu); DataTable dataTable = ds.Tables["student"]; tb_stuId.Text = id; tb_stuName.Text = dataTable.Rows[0][1].ToString(); cb_stuGrade.Text = dataTable.Rows[0][3].ToString(); cb_stuMajor.Text = dataTable.Rows[0][4].ToString(); tb_stuHome.Text = dataTable.Rows[0][6].ToString(); tb_stuClass.Text = dataTable.Rows[0][5].ToString(); if (dataTable.Rows[0][2].ToString() == "女") { this.sex_gird.Checked = true; } else { this.sex_boy.Checked = true; } }
private void bt_ok_Click(object sender, EventArgs e) { string sign = cb_qx.SelectedItem.ToString(); string id = tb_Id.Text; string name = tb_name.Text; string passwd = tb_passwd.Text; if (sign.Equals("学生")) { bool result = DAO_Student.UpdataStudentPasswd(name, passwd); if (result) { MessageBox.Show("修改成功"); } else { MessageBox.Show("修改失败,请重试"); } } else { string teaSex = ""; string teaDuties = ""; string teaTelephone = ""; bool result = DAO_Teacher.UpdataTeaInfo(id, name, teaSex, teaDuties, teaTelephone, passwd); if (result) { MessageBox.Show("修改成功"); } else { MessageBox.Show("修改失败,请重试"); } } }
public void addStudent(string imie, string nazwisko, string indeks) { DAO_Student dao = new DAO_Student(); List <Student> list = dao.getStudenci(); int index = list.Last().id; Student nstud = new Student(index + 1, imie, nazwisko, indeks); list.Add(nstud); dao.setStudenci(list); }
//设置选择班级下拉框数据 private void setClassData() { student student = new student(); DataSet ds = DAO_Student.SelectStuData(student); DataTable dtGroup = ds.Tables["student"]; cb_className.DataSource = dtGroup; cb_className.DisplayMember = "stuClassName"; cb_className.ValueMember = "stuClassName"; }
//修改学生按钮点击事件 private void bt_change_Click(object sender, EventArgs e) { student stu = new student(); string id = dgv_stuInfo.SelectedRows[0].Cells[0].Value.ToString(); UpdateStuInfo changeStuInfo = new UpdateStuInfo(id); changeStuInfo.ShowDialog(); DataSet ds = DAO_Student.SelectStuData(stu); DataTable dtGroup = ds.Tables["student"]; dgv_stuInfo.DataSource = dtGroup; }
//删除学生按钮点击事件 private void bt_delete_Click(object sender, EventArgs e) { string stuId = dgv_stuInfo.SelectedRows[0].Cells[0].Value.ToString(); bool result = DAO_Student.DeleteStudent(stuId); if (result) { MessageBox.Show("删除成功"); selectStuData(); } else { MessageBox.Show("删除失败"); } }
private void button1_Click(object sender, EventArgs e) { string id = tb_Id.Text; string passwd = tb_passwd.Text; string qx = cb_qx.SelectedItem.ToString(); if (qx.Equals("学生")) { student stu = new student(); stu.StuId = id; stu.Passwd = passwd; DataSet dataSet = DAO_Student.SelectStuDataForLogin(stu); int count = dataSet.Tables["student"].Rows.Count; if (count > 0) { StuForm stuForm = new StuForm(); stuForm.Show(); this.Hide(); } } else if (qx.Equals("教师")) { string teaName = ""; DataSet dataSet = DAO_Teacher.getTeacherDataForLogin(id, qx, passwd); int count = dataSet.Tables["teacher"].Rows.Count; if (count > 0) { AdminForm adminForm = new AdminForm(false); adminForm.Show(); this.Hide(); } } else if (qx.Equals("管理员")) { string teaName = ""; DataSet dataSet = DAO_Teacher.getTeacherDataForLogin(id, qx, passwd); int count = dataSet.Tables["teacher"].Rows.Count; if (count > 0) { AdminForm adminForm = new AdminForm(true); adminForm.Show(); this.Hide(); } } }
private void change_button_Click(object sender, EventArgs e) { student stu = new student(); stu.StuMajor = cb_stuMajor.Text; stu.StuGrade = cb_stuGrade.Text; stu.StuSex = sex_boy.Checked ? "男" : "女"; stu.StuId = tb_stuId.Text; stu.StuName = tb_stuName.Text; stu.StuClassName = tb_stuClass.Text; stu.StuHome = tb_stuHome.Text; bool result = DAO_Student.UpdataStudent(stu); if (result) { MessageBox.Show("修改成功"); } }
public void editStudent(int index, string imie, string nazwisko, string indeks) { if (index != 0) { DAO_Student dao = new DAO_Student(); List <Student> list = dao.getStudenci(); foreach (var k in list) { if (k.id == index) { k.imie = imie; k.nazwisko = nazwisko; k.indeks = indeks; } } dao.setStudenci(list); } }
public void deleteStudent(int index) { DAO_Student dao = new DAO_Student(); List <Student> list = dao.getStudenci(); Student to_delete = null; foreach (var k in list) { if (k.id == index) { to_delete = k; } } if (to_delete != null) { list.Remove(to_delete); } dao.setStudenci(list); }
//查询按钮点击事件 private void bt_select_Click(object sender, EventArgs e) { student stu = new student(); if (tb_stuId.Text.Trim().Length != 0) { stu.StuId = tb_stuId.Text; } if (tb_stuName.Text.Trim().Length != 0) { stu.StuName = tb_stuName.Text; } if (cb_stuSex.SelectedIndex != -1) { stu.StuSex = cb_stuSex.SelectedItem.ToString(); } stu.StuMajor = cb_major.SelectedValue.ToString(); stu.StuClassName = cb_className.SelectedValue.ToString(); DataSet ds = DAO_Student.SelectStuData(stu); DataTable dtGroup = ds.Tables["student"]; dgv_stuInfo.DataSource = dtGroup; }
public List <string> getAllStudenci() { DAO_Student dao = new DAO_Student(); return(dao.getStudenciString()); }