public List<Teacher> GetTeachers(string TeacherName,string StudentName)
{
//所有班主任的信息列表
//根据班主任老师姓名或者班主任所带班级里面的学生姓名查询班主任
var list = db.Queryable<Teacher, Student>((t, s) => new object[] {
JoinType.Left,t.PkId,t.PkId == s.ChargeTeaId,
})
.WhereIF(!string.IsNullOrWhiteSpace(TeacherName) , t => t.Name.Contains(TeacherName))
.WhereIF(!string.IsNullOrWhiteSpace(StudentName) ,(t,s)=> s.Name.Contains(StudentName))
.PartitionBy(t => new { t.PkId }).Take(1)
.ToList();
return list;
}
Sqlsugar根据班主任老师姓名或者班主任所带班级里面的学生姓名查询班主任
最新推荐文章于 2022-10-26 19:48:02 发布