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;
}
