/// <summary>
/// 得到所有学生信息
/// </summary>
/// <returns>返回所有学生记录</returns>
public List <Student> GetAllStuInfo()
{
try
{
using (StuInfo_Entities context = new StuInfo_Entities())
{
var stu = from s in context.TStudent.Where(ss => ss.DelFlag != 1)
select new Student
{
StuId = s.StuId,
ClassId = s.ClassId,
StuName = s.StuName,
LoginName = s.LoginName,
Password = s.Password,
UpDateTime = (DateTime)s.UpdateTime,
Remark = s.Remark
};
return(stu.ToList());
}
}
catch
{
return(null);
}
}
/// <summary>
/// 添加学生记录
/// </summary>
/// <param name="student">学生信息</param>
/// <returns>添加成功返回布尔值true，反之false</returns>
public bool AddStuInfo(Student student)
{
try
{
using (StuInfo_Entities context = new StuInfo_Entities())
{
TStudent stu = new TStudent
{
ClassId = student.ClassId,
StuName = student.StuName,
LoginName = student.LoginName,
Password = student.Password,
UpdateTime = student.UpDateTime,
Remark = student.Remark
};
context.TStudent.Add(stu);
context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
/// <summary>
/// 据班级ID查询班级
/// </summary>
/// <param name="stuClass">班级信息</param>
/// <returns>查询成功返回布尔值true，反之false</returns>
public bool SelectByPK(StuClass stuClass)
{
try
{
using (StuInfo_Entities context = new StuInfo_Entities())
{
var query = context.TClass.Single(c => c.ClassId == stuClass.ClassId && c.DelFlag != 1);
return(true);
}
}
catch
{
return(false);
}
}
/// <summary>
/// 学生登陆查询
/// </summary>
/// <param name="student">学生信息</param>
/// <returns>返回布尔值，查询成功返回true,否则返回false</returns>
public bool SelectByLoginName_Passwod(Student student)
{
try
{
using (StuInfo_Entities context = new StuInfo_Entities())
{
var query = context.TStudent.Single(s => s.LoginName == student.LoginName && s.Password == student.Password && s.DelFlag != 1);
return(true);
}
}
catch
{
return(false);
}
}
/// <summary>
/// 据学生ID查询学生记录
/// </summary>
/// <param name="student">学生信息</param>
/// <returns>查询有此条记录则返回一个布尔值true，反之返回false</returns>
public bool SelectStuInfoByPK(Student student)
{
try
{
using (StuInfo_Entities context = new StuInfo_Entities())
{
var query = context.TStudent.Single(s => s.StuId == student.StuId & s.DelFlag != 1);
return(true);
}
}
catch
{
return(false);
}
}
/// <summary>
/// 据学生ID移除该条记录
/// </summary>
/// <param name="student">学生信息</param>
/// <returns>移除成功返回布尔值true,反之false</returns>
public bool RemoveStuInfoByPK(Student student)
{
try
{
using (StuInfo_Entities context = new StuInfo_Entities())
{
var query = context.TStudent.Single(s => s.StuId == student.StuId);
query.DelFlag = 1;
context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
/// <summary>
/// 删除班级记录
/// </summary>
/// <param name="stuClass">班级信息</param>
/// <returns>插入成功返回布尔值true，反之false</returns>
public bool DeleteByPK(StuClass stuClass)
{
try
{
using (StuInfo_Entities context = new StuInfo_Entities())
{
var query = context.TClass.Single(c => c.ClassId == stuClass.ClassId);
query.DelFlag = 1;
context.SaveChanges();
return(true);
}
}
catch
{
throw;
}
}
/// <summary>
/// 得到所有班级信息
/// </summary>
/// <param name="stuClass">班级信息</param>
/// <returns></returns>
public List <StuClass> GetAllClass()
{
try
{
using (StuInfo_Entities context = new StuInfo_Entities())
{
var stuc = from c in context.TClass.Where(c => c.DelFlag != 1)
select new StuClass
{
ClassId = c.ClassId,
ClassName = c.ClassName,
UpdateTime = (DateTime)c.UpdateTime,
Remark = c.Remark
};
return(stuc.ToList());
}
}
catch
{
return(null);
}
}
/// <summary>
/// 修改班级信息
/// </summary>
/// <param name="stuClass">班级信息</param>
/// <returns>修改成功返回布尔值true，反之false</returns>
public bool UpData(StuClass stuClass)
{
try
{
using (StuInfo_Entities context = new StuInfo_Entities())
{
var query = context.TClass.Single(c => c.ClassId == stuClass.ClassId);
query.ClassId = stuClass.ClassId;
query.ClassName = stuClass.ClassName;
query.UpdateTime = stuClass.UpdateTime;
query.Remark = stuClass.Remark;
context.SaveChanges();
return(true);
}
}
catch
{
throw;
}
}
/// <summary>
/// 插入班级记录
/// </summary>
/// <param name="stuClass">班级信息</param>
/// <returns>插入成功返回布尔值true，反之false</returns>
public bool Insert(StuClass stuClass)
{
try
{
using (StuInfo_Entities context = new StuInfo_Entities())
{
TClass stuc = new TClass
{
ClassName = stuClass.ClassName,
UpdateTime = (DateTime)stuClass.UpdateTime,
Remark = stuClass.Remark
};
context.TClass.Add(stuc);
context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}