/// <summary>
/// 学生管理列表
/// <para>作 者: Huang GaoLiang</para>
/// <para>创建时间: 2018-10-29</para>
/// </summary>
/// <param name="req">查询条件</param>
/// <param name="schoolId">校区编号</param>
/// <param name="pageIndex">当前页</param>
/// <param name="pageSize">每页大小</param>
/// <returns>返回学生分页数据</returns>
public PageResult <ViewStudent> GetViewStudentList(StudentListSearchRequest req, string schoolId, int pageIndex, int pageSize)
{
var querySql = $@"SELECT s.StudentId,
s.StudentNo,
s.StudentName,
s.Sex,
s.Birthday,
s.LinkMobile,
s.HeadFaceUrl,
s.ContactPersonMobile,
c.SchoolId,
c.StudyStatus,
c.RemindClassTimes,
s.CreateTime
FROM dbo.TblCstStudent s
INNER JOIN dbo.TblCstSchoolStudent c
ON c.StudentId = s.StudentId
WHERE c.SchoolId =@SchoolId";
var student = base.CurrentContext.ViewStudent.FromSql(querySql, new object[]
{
new SqlParameter("@SchoolId", schoolId)
});
var query = student.WhereIf(req.StudySatus > 0, x => x.StudyStatus == req.StudySatus)
.WhereIf(req.LessonCount > 0, x => x.RemindClassTimes < req.LessonCount)
.WhereIf(!string.IsNullOrWhiteSpace(req.KeyWord), x => x.StudentName.Contains(req.KeyWord) || x.ContactPersonMobile.StartsWith(req.KeyWord)) //关键字（学生姓名/手机号）
.OrderBy(m => m.RemindClassTimes)
.ThenBy(m => m.StudentNo)
.ToPagerSource(pageIndex, pageSize);
return(query);
}
/// <summary>
/// 根据查询条件获取学生管理列表
/// <para>作 者:Huang GaoLiang </para>
/// <para>创建时间: 2019-11-06 </para>
/// </summary>
/// <param name="req">查询学生查询条件</param>
/// <param name="pageIndex">当前页</param>
/// <param name="pageSize">每页大小</param>
/// <returns>返回学生分页数据</returns>
public PageResult <StudentListResponse> GetStudentPageList(StudentListSearchRequest req, int pageIndex, int pageSize)
{
PageResult <ViewStudent> studentList = new ViewStudentRepository().GetViewStudentList(req, _schoolId, pageIndex, pageSize);
PageResult <StudentListResponse> list = Mapper.Map <PageResult <ViewStudent>, PageResult <StudentListResponse> >(studentList);
foreach (var item in list.Data)
{
item.ContactPersonMobile = string.IsNullOrEmpty(item.ContactPersonMobile) ? "" : Regex.Replace(item.ContactPersonMobile, "(\\d{3})\\d{4}(\\d{4})", "$1****$2");
item.Age = Age.GetAgeByBirthday(item.Birthday);
}
return(list);
}
public PageResult <StudentListResponse> GetStudentList([FromQuery] StudentListSearchRequest req, int pageIndex, int pageSize)
{
return(new StudentService(base.SchoolId).GetStudentPageList(req, pageIndex, pageSize));
}
