public PageResult <ChangeClassListResponse> GetChangeClassList([FromQuery] ChangeClassListSearchRequest searcher)
{
var service = new ChangeClassService(base.SchoolId);
var result = service.GetChangeClassList(searcher);
return(result);
}
/// <summary>
/// 描述：获取转班明细列表
/// <para>作 者：瞿琦</para>
/// <para>创建时间：2019-3-6</para>
/// </summary>
/// <param name="searcher">列表筛选条件</param>
/// <returns>转班明细分页列表</returns>
public PageResult <ChangeClassListResponse> GetChangeClassList(ChangeClassListSearchRequest searcher)
{
var viewChangeClassRepository = new ViewTimChangeClassRepository();
//获取转班明细列表信息
var timChangeClassList = viewChangeClassRepository.GetTimeChangeClassList(this._schoolId, searcher);
var timChangeClassQuery = AutoMapper.Mapper.Map <List <ChangeClassListResponse> >(timChangeClassList.Data);
var classIdList = new List <long>();
classIdList.AddRange(timChangeClassQuery.Select(x => x.OutClassId)); //将转出班级Id集合添加到集合
classIdList.AddRange(timChangeClassQuery.Select(x => x.InClassId)); //将转入班级Id集合添加到集合
//获取所有的学期类型
var termTypeService = new TermTypeService();
var allTermTypeList = termTypeService.GetAll();
//获取班级信息集合
var classList = DefaultClassService.GetClassByClassIdAsync(classIdList).Result;
//获取所有的课程信息
var courseList = CourseService.GetAllAsync().Result;
//获取所有的人员
var userList = EmployeeService.GetAllBySchoolId(_schoolId);
foreach (var item in timChangeClassQuery)
{
//学期类型信息
var termModel = allTermTypeList.FirstOrDefault(x => x.TermTypeId == item.TermTypeId);
//转出班级信息
var outClassModel = classList.FirstOrDefault(x => x.ClassId == item.OutClassId);
//获取转出班级的课程信息
var outCourseModel = courseList.FirstOrDefault(x => x.CourseId == outClassModel.CourseId);
//获取转出班级教师
var outTeacherModel = userList.FirstOrDefault(x => x.EmployeeId == outClassModel.TeacherId);
//转入班级信息
var inClassModel = classList.FirstOrDefault(x => x.ClassId == item.InClassId);
//获取转入班级的课程信息
var inCourseModel = courseList.FirstOrDefault(x => x.CourseId == inClassModel.CourseId);
//获取转入班级老师
var inTeacherModel = userList.FirstOrDefault(x => x.EmployeeId == inClassModel.TeacherId);
item.TermTypeName = termModel == null ? "" : termModel.TermTypeName; //学期类型
item.OutClassName = outCourseModel == null?"": outCourseModel.ClassCnName;
item.OutClassNo = outClassModel == null ? "" : outClassModel.ClassNo;
item.OutClassTeacher = outTeacherModel == null?"": outTeacherModel.EmployeeName;
item.InClassName = inCourseModel == null?"": inCourseModel.ClassCnName;
item.InClassNo = inClassModel == null?"": inClassModel.ClassNo;
item.InClassTeacher = inTeacherModel == null?"": inTeacherModel.EmployeeName;
}
var result = new PageResult <ChangeClassListResponse>
{
Data = timChangeClassQuery,
CurrentPage = timChangeClassList.CurrentPage,
PageSize = timChangeClassList.PageSize,
TotalData = timChangeClassList.TotalData,
};
return(result);
}
/// <summary>
/// 描述：获取转班明细列表
/// <para>作者：瞿琦</para>
/// <para>创建时间：2019-3-6</para>
/// </summary>
/// <returns>转班明细列表分页</returns>
public PageResult <ViewTimChangeClass> GetTimeChangeClassList(string schoolId, ChangeClassListSearchRequest searcher)
{
var querySql = $@"select a.SchoolId,
a.StudentId,
b.StudentNo,
b.StudentName,
d.CreateTime as EnrollTime,
d.TotalTradeAmount,
c.ClassTimes as EnrollClassTimes,
c.Year,
c.TermTypeId,
a.OutClassId,
a.OutDate,
a.CreateTime as ChangeClassSubmitTime,
a.ClassTimes as ChangeClassTimes,
a.InClassId,
a.InDate
from (select * from [TblTimChangeClass] where SchoolId=@SchoolId ) as a
left join [TblCstStudent] as b on a.StudentId=b.StudentId
left join [dbo].[TblOdrEnrollOrderItem] as c on c.EnrollOrderItemId=a.EnrollOrderItemId
left join [dbo].[TblOdrEnrollOrder] as d on c.EnrollOrderId =d.EnrollOrderId
where 1=1 ";
if (searcher.Year > 0) //年度
{
querySql += " and c.Year= " + searcher.Year;
}
if (searcher.TermTypeId > 0) //学期类型
{
querySql += " and c.TermTypeId= " + searcher.TermTypeId;
}
if (searcher.ChangeClassTimeStart.HasValue) //转班日期开始时间
{
querySql += " and a.CreateTime >= '" + searcher.ChangeClassTimeStart + "'";
}
if (searcher.ChangeClassTimeEnd.HasValue) //转班日期结束时间
{
querySql += " and a.CreateTime <= '" + searcher.ChangeClassTimeEnd + "'";
}
if (!string.IsNullOrWhiteSpace(searcher.StudentName))
{
querySql += " and b.StudentName like '%" + searcher.StudentName + "%'";
}
var timChangeClassList = base.CurrentContext.ViewTimChangeClass.FromSql(querySql, new object[] {
new SqlParameter("@SchoolId", schoolId.Trim())
});
var leaveSchoolQuery = timChangeClassList
//.WhereIf(searcher.Year > 0, x => x.Year == searcher.Year) //年度
//.WhereIf(searcher.TermTypeId > 0, x => x.TermTypeId == searcher.TermTypeId) //学期类型
//.WhereIf(searcher.ChangeClassTimeStart.HasValue, x => searcher.ChangeClassTimeStart <= x.ChangeClassSubmitTime) //转班日期开始时间
//.WhereIf(searcher.ChangeClassTimeEnd.HasValue, x => x.ChangeClassSubmitTime <= searcher.ChangeClassTimeEnd.Value.AddDays(1)) //转班日期结束时间
//.WhereIf(!string.IsNullOrWhiteSpace(searcher.StudentName), x => x.StudentName.Contains(searcher.StudentName))
.OrderByDescending(x => x.ChangeClassSubmitTime)
.ToPagerSource(searcher.PageIndex, searcher.PageSize);
return(leaveSchoolQuery);
}
