/// <summary>
/// 查询全部年级信息
/// </summary>
/// <returns></returns>
public List <Grade> SelectAllGrade()
{
SchoolEntities entity = new SchoolEntities();
List <Grade> list = new List <Grade>();
list = entity.Grade.ToList();
return(list);
}
/// <summary>
/// 添加学生的方法
/// </summary>
/// <param name="stu"></param>
/// <returns></returns>
public int InsertStudent(Student stu)
{
SchoolEntities entity = new SchoolEntities();
entity.Student.Add(stu);
int count = entity.SaveChanges();
return(count);
}
/// <summary>
/// 根据学号查询1个学生的信息的方法
/// </summary>
/// <param name="studentNo"></param>
/// <returns></returns>
public Student SelectOneStudent(string studentNo)
{
SchoolEntities entity = new SchoolEntities();
Student stu = new Student();
stu = entity.Student.Where(m => m.StudentNo == studentNo)
.FirstOrDefault();
return(stu);
}
/// <summary>
/// 分页查询学生表数据
/// </summary>
/// <param name="pageSize">每页数据条数</param>
/// <param name="pageIndex">当前页码</param>
/// <param name="total">总数据条数</param>
/// <returns></returns>
public List <Student> SelectPageList(int pageSize, int pageIndex, ref int total)
{
List <Student> list = new List <Student>();
SchoolEntities entity = new SchoolEntities();
total = entity.Student.Count();
list = (from a in entity.Student
orderby a.StudentNo
select a).Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList();
return(list);
}
/// <summary>
/// 验证手机号码是否重复
/// </summary>
/// <param name="phone">手机号码</param>
/// <param name="studentNo">学号，若添加时验证请传空</param>
/// <returns>结果大于0验证失败，手机号码重复</returns>
public int validatePhone(string phone, string studentNo)
{
SchoolEntities entity = new SchoolEntities();
int count = 0;
if (string.IsNullOrEmpty(studentNo))
{//添加时验证
count = entity.Student.Where(m => m.Phone == phone).Count();
}
else
{//修改时验证
count = entity.Student.Where(m => m.Phone == phone &&
m.StudentNo != studentNo).Count();
}
return(count);
}
/// <summary>
/// 删除学生
/// </summary>
/// <param name="studentNo"></param>
/// <returns></returns>
public int DeleteStudent(string studentNo)
{
int count = 0;
SchoolEntities entity = new SchoolEntities();
Student deleteStudent = (from a in entity.Student
where a.StudentNo == studentNo
select a).FirstOrDefault();
//判断该学生是否有关联的成绩数据
if (deleteStudent.Result.Count() > 0)
{
count = -1;
}
else
{
entity.Student.Remove(deleteStudent);
count = entity.SaveChanges();
}
return(count);
}
/// <summary>
/// 修改学生的方法
/// </summary>
/// <param name="stu"></param>
/// <returns></returns>
public int UpdateStudent(Student stu)
{
SchoolEntities entity = new SchoolEntities();
Student upStu = (from a in entity.Student
where a.StudentNo == stu.StudentNo
select a).FirstOrDefault();
int count = 0;
if (upStu != null)
{
upStu.StudentName = stu.StudentName;
upStu.Address = stu.Address;
upStu.BornDate = stu.BornDate;
upStu.Email = stu.Email;
upStu.GradeId = stu.GradeId;
upStu.LoginPwd = stu.LoginPwd;
upStu.Phone = stu.Phone;
upStu.Sex = stu.Sex;
count = entity.SaveChanges();
}
return(count);
}
