public ManageClass() { InitializeComponent(); WindowStartupLocation = WindowStartupLocation.CenterScreen; //建立定时器,时间间隔为1s,并启动定时器 timer.Tick += new EventHandler(timer_Tick); timer.Interval = new TimeSpan(0, 0, 1); timer.Start(); Before = null; //UserNameTea为主界面输入的用户名 string n = MainWindow.UserCode; string UserNameTea = n.ToString(); ClassStu Stu = new ClassStu(); #region 数据库连接 SqlConnection myConnection; string connStr = "Server ='" + IPAddress.ip + "'; database =测试数据库; uid =sa; pwd=1738010002"; //string connStr = @"Server = LAPTOP-25MJ4H0M\SQLEXPRESS; database =教学系统; Trusted_Connection=SSPI"; myConnection = new SqlConnection(connStr); try { myConnection.Open(); } catch (Exception) { MessageBox.Show("连接失败"); } #endregion //查询该教师管理的班级 SqlCommand cmd2 = new SqlCommand("select 管理班级 from jsb where 职工号 = '" + UserNameTea + "'", myConnection); SqlDataReader sdr2 = cmd2.ExecuteReader(); sdr2.Read(); //TeaClass为管理的班级 string TeaClass = sdr2[0].ToString(); sdr2.Close(); //查询该班级所有的学生信息 SqlCommand cmd = new SqlCommand("select 学号,姓名,性别,班级,邮箱 from xsb where 班级 = '" + TeaClass + "'", myConnection); SqlDataReader sdr = cmd.ExecuteReader(); //循环读取学生信息并加入学生列表 while (sdr.Read()) { Stu.UserCode = sdr[0].ToString(); Stu.UserName = sdr[1].ToString(); Stu.UserSex = sdr[2].ToString(); Stu.UserClass = sdr[3].ToString(); Stu.UserEmail = sdr[4].ToString(); infoList.Add(Stu); } //绑定界面数据源为学生列表 DG3.AutoGenerateColumns = false; DG3.ItemsSource = infoList; }
/// <summary> /// 查询所有教师的信息并显示在界面上 /// </summary> public AdminTea() { InitializeComponent(); WindowStartupLocation = WindowStartupLocation.CenterScreen; //建立定时器,时间间隔为1s,并启动定时器 timer.Tick += new EventHandler(timer_Tick); timer.Interval = new TimeSpan(0, 0, 1); timer.Start(); //string n = MainWindow.UserCode; //string UserNameTea = n.ToString(); //Stu为单个教师的信息集合 ClassStu Stu = new ClassStu(); #region 数据库连接 SqlConnection myConnection; string connStr = "Server ='" + IPAddress.ip + "'; database =测试数据库; uid =sa; pwd=1738010002"; //string connStr = @"Server = LAPTOP-25MJ4H0M\SQLEXPRESS; database =教学系统; Trusted_Connection=SSPI"; myConnection = new SqlConnection(connStr); try { myConnection.Open(); } catch (Exception) { MessageBox.Show("连接失败"); } #endregion //SqlCommand cmd2 = new SqlCommand("select 管理班级 from jsb where 职工号 = '" + UserNameTea + "'", myConnection); //SqlDataReader sdr2 = cmd2.ExecuteReader(); //sdr2.Read(); //string TeaClass = sdr2[0].ToString(); //查询所有教师的信息 //sdr2.Close(); SqlCommand cmd = new SqlCommand("select 职工号,姓名,性别,管理班级,邮箱 from jsb", myConnection); SqlDataReader sdr = cmd.ExecuteReader(); //遍历教师信息并将其加入教师列表infoList while (sdr.Read()) { Stu.UserCode = sdr[0].ToString(); Stu.UserName = sdr[1].ToString(); Stu.UserSex = sdr[2].ToString(); Stu.UserClass = sdr[3].ToString(); Stu.UserEmail = sdr[4].ToString(); infoList.Add(Stu); } //绑定datagrid的数据源为教师列表 DG10.AutoGenerateColumns = false; DG10.ItemsSource = infoList; }
/// <summary> /// 点击刷新学生列表 /// </summary> private void RefreshStu_Click(object sender, RoutedEventArgs e) { //UserNameTea为教师的账户名 string n = MainWindow.UserCode; string UserNameTea = n.ToString(); ClassStu Stu = new ClassStu(); //清空学生列表 infoList.Clear(); #region 数据库连接 SqlConnection myConnection; string connStr = "Server ='" + IPAddress.ip + "'; database =测试数据库; uid =sa; pwd=1738010002"; //string connStr = @"Server = LAPTOP-25MJ4H0M\SQLEXPRESS; database =教学系统; Trusted_Connection=SSPI"; myConnection = new SqlConnection(connStr); try { myConnection.Open(); } catch (Exception) { MessageBox.Show("连接失败"); } #endregion //通过查询班级来读取该班级所有学生的信息 SqlCommand cmd2 = new SqlCommand("select 管理班级 from jsb where 职工号 = '" + UserNameTea + "'", myConnection); SqlDataReader sdr2 = cmd2.ExecuteReader(); sdr2.Read(); string TeaClass = sdr2[0].ToString(); sdr2.Close(); SqlCommand cmd = new SqlCommand("select 学号,姓名,性别,班级,邮箱 from xsb where 班级 = '" + TeaClass + "'", myConnection); SqlDataReader sdr = cmd.ExecuteReader(); //循环读取查询到的信息 while (sdr.Read()) { Stu.UserCode = sdr[0].ToString(); Stu.UserName = sdr[1].ToString(); Stu.UserSex = sdr[2].ToString(); Stu.UserClass = sdr[3].ToString(); Stu.UserEmail = sdr[4].ToString(); infoList.Add(Stu); } Before = null; //重新绑定数据源 DG3.AutoGenerateColumns = false; DG3.ItemsSource = null; DG3.ItemsSource = infoList; myConnection.Close(); myConnection.Dispose(); }
/// <summary> /// 刷新教师信息 /// </summary> private void RefreshStu_Click(object sender, RoutedEventArgs e) { Before = null; //string n = MainWindow.UserCode; //string UserNameTea = n.ToString(); //Stu为单个教师的信息集合 ClassStu Stu = new ClassStu(); //清空教师列表 infoList.Clear(); #region 数据库连接 SqlConnection myConnection; string connStr = "Server ='" + IPAddress.ip + "'; database =测试数据库; uid =sa; pwd=1738010002"; //string connStr = @"Server = LAPTOP-25MJ4H0M\SQLEXPRESS; database =教学系统; Trusted_Connection=SSPI"; myConnection = new SqlConnection(connStr); try { myConnection.Open(); } catch (Exception) { MessageBox.Show("连接失败"); } #endregion //SqlCommand cmd2 = new SqlCommand("select 管理班级 from jsb where 职工号 = '" + UserNameTea + "'", myConnection); //SqlDataReader sdr2 = cmd2.ExecuteReader(); //sdr2.Read(); //string TeaClass = sdr2[0].ToString(); //sdr2.Close(); //查询所有的教师信息 SqlCommand cmd = new SqlCommand("select 职工号,姓名,性别,管理班级,邮箱 from jsb", myConnection); SqlDataReader sdr = cmd.ExecuteReader(); //遍历读取教师信息并加入到教师列表 while (sdr.Read()) { Stu.UserCode = sdr[0].ToString(); Stu.UserName = sdr[1].ToString(); Stu.UserSex = sdr[2].ToString(); Stu.UserClass = sdr[3].ToString(); Stu.UserEmail = sdr[4].ToString(); infoList.Add(Stu); } //重新绑定datagrid的数据源为infoList DG10.AutoGenerateColumns = false; DG10.ItemsSource = null; DG10.ItemsSource = infoList; }
//定时刷新 void timer_Tick(object sender, EventArgs e) { #region 数据库连接 SqlConnection myConnection; string connStr = "Server ='" + IPAddress.ip + "'; database =测试数据库; uid =sa; pwd=1738010002"; //string connStr = @"Server = LAPTOP-25MJ4H0M\SQLEXPRESS; database =教学系统; Trusted_Connection=SSPI"; myConnection = new SqlConnection(connStr); try { myConnection.Open(); } catch (Exception) { MessageBox.Show("连接失败"); } #endregion //循环读取是否被选中 for (int i = 0; i < this.DG9.Items.Count; i++) { var cntr = DG9.ItemContainerGenerator.ContainerFromIndex(i); DataGridRow ObjROw = (DataGridRow)cntr; if (ObjROw != null) { FrameworkElement objElement = DG9.Columns[5].GetCellContent(ObjROw); if (objElement != null) { System.Windows.Controls.CheckBox objChk = (System.Windows.Controls.CheckBox)objElement; if (objChk.IsChecked == true) { if (Before != infoList[i].UserCode) { Before = infoList[i].UserCode; break; } } } } } //string n = MainWindow.UserCode; //string UserNameTea = n.ToString(); //Stu为单个学生的信息集合 ClassStu Stu = new ClassStu(); //清空教师列表 infoList.Clear(); //SqlCommand cmd2 = new SqlCommand("select 管理班级 from jsb where 职工号 = '" + UserNameTea + "'", myConnection); //SqlDataReader sdr2 = cmd2.ExecuteReader(); //sdr2.Read(); //string TeaClass = sdr2[0].ToString(); //sdr2.Close(); //查询所有的学生信息 SqlCommand cmd = new SqlCommand("select 学号,姓名,性别,班级,邮箱 from xsb", myConnection); SqlDataReader sdr = cmd.ExecuteReader(); //遍历读取学生信息并加入到学生列表 while (sdr.Read()) { Stu.UserCode = sdr[0].ToString(); if (Before == null) { Stu.UserSelect = false; } else if (Stu.UserCode == Before) { Stu.UserSelect = true; } else { Stu.UserSelect = false; } Stu.UserName = sdr[1].ToString(); Stu.UserSex = sdr[2].ToString(); Stu.UserClass = sdr[3].ToString(); Stu.UserEmail = sdr[4].ToString(); infoList.Add(Stu); } //重新绑定datagrid的数据源为infoList DG9.AutoGenerateColumns = false; DG9.ItemsSource = null; DG9.ItemsSource = infoList; }