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 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);
}
public int DeleteStudent(StuInfoTable stuTalbe)
{
StudentsInfoDBEntities stuDB = new StudentsInfoDBEntities();
int result = 0;
try
{
//List<StuInfoTable> stuEnu = stuDB.StuInfoTable.Where(item => item.ID == stuTalbe.ID).ToList<StuInfoTable>();
//StuInfoTable stu = stuEnu[0];
stuDB.StuInfoTable.Attach(stuTalbe);
stuDB.StuInfoTable.Remove(stuTalbe);
result= stuDB.SaveChanges();
}
catch (Exception e)
{
MessageBox.Show("删除出现错误:" + e.Message);
}
finally
{
stuDB.Dispose();
}
return result;
}
