//功能 窗口构造函数
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);
}
