//功能 窗口构造函数 public 功能(MySqlConnection connection, string name, string password) { Password1 = password; Connection1 = connection; Name1 = name; //MainWindow m1 = new MainWindow(); InitializeComponent(); 我的课程_grid1_data data2 = new 我的课程_grid1_data(); data2.Init(Connection1, Name1, this.我的课程_grid1); 我的课程_grid1_data data3 = new 我的课程_grid1_data(); data3.课_init(Connection1, this.课_grid1); 我的课程_grid1_data data4 = new 我的课程_grid1_data(); data4.Init2(Connection1, Name1, this.课_grid2); //公告 公告_announcment data5 = new 公告_announcment(); data5.Init(Connection1, 公告_grid1); //讨论 讨论_discussion data6 = new 讨论_discussion(); data6.Init(Connection1, 讨论_grid1); }
//显示已临时选择的课程 //功能-选课-grid2 public void Init2(MySqlConnection Connection, string name1, Grid grid1) { var list = new List <我的课程_grid1_data>(); //我的课程_grid1_data data = new 我的课程_grid1_data(); string str1 = "select student_course.id, name, teacher, credit, preid, notation, time from student_course natural join student_course_selected_tempary where student_course_selected_tempary.student_id='"; string str2 = "';"; MySqlCommand cmd = new MySqlCommand(str1 + name1 + str2, Connection); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { 我的课程_grid1_data data = new 我的课程_grid1_data(); data.Courseid = rdr[0].ToString(); data.Coursename = rdr[1].ToString(); data.Courseteacher = rdr[2].ToString(); data.Coursecredit = rdr[3].ToString(); data.Coursepreid = rdr[4].ToString(); data.Coursenotation = rdr[5].ToString(); data.Coursetime = rdr[6].ToString(); list.Add(data); } grid1.DataContext = list; rdr.Close(); }
//初始化选课窗口 //功能-选课-grid1 public void 课_init(MySqlConnection Connection, Grid grid1) { var list = new List <我的课程_grid1_data>(); string str1 = "select * from student_course;"; MySqlCommand cmd = new MySqlCommand(str1, Connection); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { 我的课程_grid1_data data = new 我的课程_grid1_data(); data.Courseid = rdr[0].ToString(); data.Coursename = rdr[1].ToString(); data.Courseteacher = rdr[2].ToString(); data.Coursecredit = rdr[3].ToString(); data.Coursepreid = rdr[4].ToString(); data.Coursenotation = rdr[5].ToString(); data.Coursetime = rdr[6].ToString(); data.Button1 = new Button(); data.Button1.Content = data.Courseid; list.Add(data); } grid1.DataContext = list; rdr.Close(); }
//提交讨论 public void 讨论_click1(Object sender, RoutedEventArgs e) { string id = 讨论_学号.Text; string content = 讨论_讨论内容.Text; string str1 = "insert ignore into discussion value ('"; string str2 = "', '"; string str3 = "');"; MySqlCommand cmd = new MySqlCommand(str1 + id + str2 + content + str3, Connection1); cmd.ExecuteNonQuery(); MessageBox.Show("发布成功", "发布成功", MessageBoxButton.OK); var list = new List <讨论_discussion>(); this.讨论_grid1.DataContext = list; 我的课程_grid1_data data4 = new 我的课程_grid1_data(); data4.Init2(Connection1, Name1, this.课_grid2); }
private void 课_Unchecked(Object sender, RoutedEventArgs e) { Button button1 = sender as Button; string course_id = button1.Content.ToString(); string str1 = "delete from student_course_selected_tempary where student_id ='"; string str2 = "' and id='"; string str3 = "';"; MySqlCommand cmd = new MySqlCommand(str1 + Name1 + str2 + course_id + str3, Connection1); cmd.ExecuteNonQuery(); MessageBox.Show("退课成功", "退课成功", MessageBoxButton.OK); var list = new List <我的课程_grid1_data>(); this.课_grid2.DataContext = list; 我的课程_grid1_data data4 = new 我的课程_grid1_data(); data4.Init2(Connection1, Name1, this.课_grid2); }