private void SearchByGradesMethon(object parameter)
{
IDataAccess idata = new DataServerse();
List<StuInfoTable> resultList = idata.Search(stu => stu.Grades==SSModel.SGrades);
SSModel.StuCollection = new ObservableCollection<StuInfoTable>(resultList);
}
public void AddStudent(StuInfoTable stuTable)
{
StudentsInfoDBEntities StuDB = new StudentsInfoDBEntities();
try
{
IDataAccess idata = new DataServerse();
int getId = idata.Search((StuInfoTable stu) => stu.ID == stuTable.ID).Take(1).Count();
if (getId != 1)
{
StuDB.StuInfoTable.Add(stuTable);
StuDB.SaveChanges();
MessageBox.Show("成功添加1条信息!");
}
else
MessageBox.Show("学号已存在！");
}
catch (Exception e)
{
MessageBox.Show("添加数据发生异常:" + e.Message);
}
finally
{
StuDB.Dispose();
}
}
private void DeleteDataMethod(object parameter)
{
DataGrid dg = parameter as DataGrid;
IDataAccess idata = new DataServerse();
StuInfoTable select = dg.SelectedItem as StuInfoTable;
if (select != null)
{
int result = idata.DeleteStudent(select);
if (result != 0)
SSModel.StuCollection.Remove(select);
}
}
private void AddStuMethod(object parameter)
{
IDataAccess iData = new DataServerse();
StuInfoTable stuTable = new StuInfoTable()
{
ID = StudentModel.ID,
Name = StudentModel.Name,
Age = StudentModel.Age,
Sex = StudentModel.Sex,
Birthday = StudentModel.Birthday,
PhoneNumber = StudentModel.PhoneNumber,
Address = StudentModel.Address,
Grades = StudentModel.Grades
};
iData.AddStudent(stuTable);
}
