//设置学生表格数据
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());
}
