예제 #1
0
        private void DeleteProfessor(object sender, EventArgs e)
        {
            //删除教授子流程,弹出选框要求输入教授ID号,输入后查询并回显,询问是否删除
            InputID tempform = new InputID();

            tempform.ShowDialog();
            if (tempform.Text.Equals("no"))
            {
                return;
            }
            MySqlConnection conn = new MySqlConnection(mysqlConnectionString);

            try
            {
                conn.Open();                                                                            //连接数据库
                string          sql    = "select * from professor where id = '" + tempform.Text + "';"; //查询该ID对应的教授信息
                MySqlCommand    cmd    = new MySqlCommand(sql, conn);
                MySqlDataReader reader = cmd.ExecuteReader();                                           //reader内存储了0或1条记录

                if (reader.HasRows)
                {
                    reader.Read();

                    DialogResult result = MessageBox.Show("姓名:" + reader[1].ToString() + "\n出生日期:" + reader[2].ToString().Substring(0, 9)
                                                          + "\n职称:" + reader[4].ToString() + "\n学院:" + reader[5].ToString() + "\n是否确定删除该名教授?"
                                                          , "删除确认", MessageBoxButtons.OKCancel);

                    reader.Close();
                    if (result == DialogResult.OK)
                    {
                        sql = "delete from professor where id = '" + tempform.Text + "';";//从数据库中删除该教授信息
                        cmd = new MySqlCommand(sql, conn);
                        cmd.ExecuteNonQuery();
                        MessageBox.Show("删除成功!");
                        Show_pro_info();
                    }
                    else
                    {
                        return;
                    }
                }
                else
                {
                    MessageBox.Show("未找到对应教授!");
                    DeleteProfessor(null, null);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            conn.Close();
        }
예제 #2
0
        private void UpdateProfessor(object sender, EventArgs e)
        {
            //更新教授子流程,查询教授ID号,显示教授信息,删除原本数据,插入新数据
            InputID tempform = new InputID();

            tempform.ShowDialog();
            if (tempform.Text.Equals("no"))
            {
                return;
            }
            MySqlConnection conn = new MySqlConnection(mysqlConnectionString);

            try
            {
                conn.Open();                                                                            //连接数据库
                string          sql    = "select * from professor where id = '" + tempform.Text + "';"; //查询该ID对应的教授信息
                MySqlCommand    cmd    = new MySqlCommand(sql, conn);
                MySqlDataReader reader = cmd.ExecuteReader();                                           //此时reader储存了1条语句
                if (reader.HasRows)
                {
                    reader.Read();
                    int    status = -1, dept_name = -1;
                    string ID       = reader[0].ToString();
                    string password = reader[6].ToString();

                    if (reader[4].ToString().Equals("助教"))
                    {
                        status = 0;
                    }
                    if (reader[4].ToString().Equals("讲师"))
                    {
                        status = 1;
                    }
                    if (reader[4].ToString().Equals("副教授"))
                    {
                        status = 2;
                    }
                    if (reader[4].ToString().Equals("教授"))
                    {
                        status = 3;
                    }

                    if (reader[5].ToString().Equals("计算机科学与技术学院"))
                    {
                        dept_name = 0;
                    }
                    if (reader[5].ToString().Equals("数学学院"))
                    {
                        dept_name = 1;
                    }
                    if (reader[5].ToString().Equals("外语学院"))
                    {
                        dept_name = 2;
                    }
                    if (reader[5].ToString().Equals("马克思学院"))
                    {
                        dept_name = 3;
                    }

                    ProInfo proInfo = new ProInfo();
                    proInfo.update(reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), status, dept_name);
                    proInfo.ShowDialog();
                    reader.Close();

                    if (proInfo.Text.Equals("no"))
                    {
                        return;
                    }

                    string[] pro_info = Regex.Split(proInfo.Text, " ", RegexOptions.IgnoreCase);                                           //通过分隔符空格拆开修改窗口返回的必要信息
                    sql = String.Format("update professor set name='{0}',date_of_birth='{1}',ssn='{2}',status='{3}',dept_name='{4}'" +
                                        " where id={5};", pro_info[0], pro_info[1], pro_info[2], pro_info[3], pro_info[4], tempform.Text); //更新教授信息

                    cmd = new MySqlCommand(sql, conn);
                    int result = cmd.ExecuteNonQuery();
                    if (result == 1)
                    {
                        MessageBox.Show("教授信息修改成功!");
                        Show_pro_info();
                    }
                }
                else
                {
                    MessageBox.Show("未找到对应教授!");
                    DeleteProfessor(null, null);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            conn.Close();
        }
        private void UpdateStudent(object sender, EventArgs e)
        {
            //更新学生子流程,查询学生ID号,显示学生信息,删除原本数据,插入新数据
            InputID tempform = new InputID();

            tempform.ShowDialog();
            if (tempform.Text.Equals("no"))
            {
                return;
            }
            MySqlConnection conn = new MySqlConnection(mysqlConnectionString);

            try
            {
                conn.Open();                                                                          //连接数据库
                string          sql    = "select * from student where id = '" + tempform.Text + "';"; //查询该ID对应的学生信息
                MySqlCommand    cmd    = new MySqlCommand(sql, conn);
                MySqlDataReader reader = cmd.ExecuteReader();                                         //此时reader储存了1条语句
                if (reader.HasRows)
                {
                    reader.Read();
                    int    status = -1, graduate_date = -1;
                    string ID       = reader[0].ToString();
                    string password = reader[6].ToString();

                    if (reader[4].ToString().Equals("本科生"))
                    {
                        status = 0;
                    }
                    if (reader[4].ToString().Equals("硕士研究生"))
                    {
                        status = 1;
                    }
                    if (reader[4].ToString().Equals("博士研究生"))
                    {
                        status = 2;
                    }

                    if (reader[5].ToString().Equals("2020"))
                    {
                        graduate_date = 0;
                    }
                    if (reader[5].ToString().Equals("2021"))
                    {
                        graduate_date = 1;
                    }
                    if (reader[5].ToString().Equals("2022"))
                    {
                        graduate_date = 2;
                    }
                    if (reader[5].ToString().Equals("2023"))
                    {
                        graduate_date = 3;
                    }
                    if (reader[5].ToString().Equals("2024"))
                    {
                        graduate_date = 4;
                    }

                    StuInfo stuInfo = new StuInfo();
                    stuInfo.update(reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), status, graduate_date);
                    stuInfo.ShowDialog();
                    reader.Close();

                    if (stuInfo.Text.Equals("no"))
                    {
                        return;
                    }
                    string[] pro_info = Regex.Split(stuInfo.Text, " ", RegexOptions.IgnoreCase);                                           //通过分隔符空格拆开修改窗口返回的必要信息
                    sql = String.Format("update student set name='{0}',date_of_birth='{1}',ssn='{2}',status='{3}',graduate_date='{4}'" +
                                        " where id={5};", pro_info[0], pro_info[1], pro_info[2], pro_info[3], pro_info[4], tempform.Text); //更新教授信息


                    cmd = new MySqlCommand(sql, conn);
                    int result = cmd.ExecuteNonQuery();
                    if (result == 1)
                    {
                        MessageBox.Show("学生信息修改成功!");
                        Show_stu_info();
                    }
                }
                else
                {
                    MessageBox.Show("未找到对应学生!");
                    DeleteStudent(null, null);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            conn.Close();
        }