private void SaveButton_Click(object sender, RoutedEventArgs e)
{
try
{
context.SaveChanges();
StudentDataGrid.ClearValue(ItemsControl.ItemsSourceProperty);
List <Student> students = context.Students.Include(c => c.Course).Include(g => g.Group).ToList();
StudentDataGrid.ItemsSource = students;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//Student st = new Student();
//st.GetStudent();
//string namelist="";
//foreach(Student s in Student.list)
//{
// namelist += s.Name + "</br>";
//}
////GetStudentList.Controls.Add(namelist);
StudentDataGrid.DataSource = Student.GetDataList();
StudentDataGrid.DataBind();
}
private void CheckMyStudents_Shown(object sender, EventArgs e)
{
if (CurrentUser.UserGroup.IsBusManager)
{
SchoolBusObject busObject = new SchoolBusObject();
DBQueryStatus resultX = DataBaseOperation.QueryMultipleData <SchoolBusObject>(new DBQuery().WhereEqualTo("TeacherObjectID", CurrentUser.ObjectId), out List <SchoolBusObject> result);
switch (resultX)
{
case DBQueryStatus.NO_RESULTS:
MessageBox.Show("没有找到你管理的校车");
return;
case DBQueryStatus.ONE_RESULT:
break;
case DBQueryStatus.MORE_RESULTS:
MessageBox.Show("找到了多个和你绑定的校车(这不可能……)，目前只会显示其中第一项");
break;
default: { MessageBox.Show("出现内部错误：" + resultX.ToString()); return; }
}
busObject = result[0];
myID.Text = busObject.ObjectId;
myDirection.Text = busObject.BusName;
LeavingChecked.Text = busObject.LSChecked.ToString();
ExpNumber.Text = "尚未加载";
BackNumber.Text = "尚未加载";
ExDescription.Text = "加载完成";
Application.DoEvents();
StudentDataGrid.AutoResizeColumns();
}
else if (CurrentUser.UserGroup.IsAdmin)
{
MessageBox.Show("管理员用户请到管理页面进行查询和修改记录", "管理员通知", MessageBoxButtons.OK);
}
else
{
MessageBox.Show("你不是校车老师，只有校车老师和管理员能编辑数据", "只读模式", MessageBoxButtons.OK);
Close();
}
}
private void LoadAll_Click(object sender, EventArgs e)
{
studentDataObjectBindingSource.Clear();
DBQuery query = new DBQuery();
query.WhereEqualTo("BusID", myID.Text);
DBQueryStatus resultX = DataBaseOperation.QueryMultipleData <StudentObject>(query, out List <StudentObject> result);
if (resultX >= 0)
{
foreach (StudentObject item in result)
{
studentDataObjectBindingSource.Add(item);
}
ExpNumber.Text = result.Count.ToString();
LeaveNumber.Text = CountTicks(4).ToString();
LeavingChecked.Text = CountTicks(5).ToString();
BackNumber.Text = CountTicks(6).ToString();
}
StudentDataGrid.AutoResizeColumns();
}
private void AddButton_Click(object sender, RoutedEventArgs e)
{
try
{
StudentController studentController = new StudentController();
Student student = new Student(txtName.Text, txtSurname.Text, txtGroup.Text, int.Parse(txtCourse.Text));
if (studentController.AddStudent(student))
{
MessageBox.Show("Студент успешно добавлен.");
StudentDataGrid.ClearValue(ItemsControl.ItemsSourceProperty);
List <Student> students = context.Students.ToList();
StudentDataGrid.ItemsSource = students;
}
else
{
MessageBox.Show("Этот студент уже добавлен или введенные данные имеют неверный формат.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
