/// <summary>
/// 按学号删除学生
/// </summary>
/// <param name="value"></param>
public void Delete(string value)
{
SchoolrollMethod roll = new SchoolrollMethod();
using (var dbcontext = new srContext())
{
var student = dbcontext.Student.FirstOrDefault(u => u.Sno == value);
var schoolroll = dbcontext.Schoolroll.FirstOrDefault(u => u.Sno == value);
var cerlist = new List <Certificate>();
var cetlists = new List <Cet>();
var scorelist = new List <Score>();
foreach (var infor in dbcontext.Certificate)
{
if (infor.Sno == value)
{
cerlist.Add(infor);
}
}
foreach (var infor in dbcontext.Cet)
{
if (infor.Sno == value)
{
cetlists.Add(infor);
}
}
foreach (var infor in dbcontext.Score)
{
if (infor.Sno == value)
{
scorelist.Add(infor);
}
}
if (cerlist != null)
{
foreach (var infor in cerlist)
{
dbcontext.Certificate.Remove(infor);
}
}
if (cetlists != null)
{
foreach (var infor in cetlists)
{
dbcontext.Cet.Remove(infor);
}
}
if (scorelist != null)
{
foreach (var infor in scorelist)
{
dbcontext.Score.Remove(infor);
}
}
dbcontext.Schoolroll.Remove(schoolroll);
dbcontext.Student.Remove(student);
dbcontext.SaveChanges();
}
}
/// <summary>
/// 获取一个学生信息
/// </summary>
/// <param name="no"></param>
/// <returns></returns>
public Student FindStudent(string no)
{
var student = new Student();
using (var dbcontext = new srContext())
{
student = dbcontext.Student.FirstOrDefault(u => u.Sno == no);
}
var schoolroll = new Schoolroll();
var function = new SchoolrollMethod();
schoolroll = function.GetRoll(no);
student.Schoolroll = schoolroll;
return(student);
}
/// <summary>
/// 获取所有学生信息
/// </summary>
/// <returns></returns>
public List <Student> ReadDB()
{
List <Student> students = new List <Student>();
var schoolroll = new Schoolroll();
var function = new SchoolrollMethod();
using (var dbcontext = new srContext())
{
foreach (var value in dbcontext.Student)
{
schoolroll = function.GetRoll(value.Sno);
value.Schoolroll = schoolroll;
students.Add(value);
}
}
return(students);
}