public JsonResult GetApproveLessons(DtoApproveLessonSearch search)
{
LessonBll bll = new LessonBll();
List <DtoLessonApprove> list = bll.GetLessonApproveByPage(search);
return(Json(AbhsTableFactory.Create(list, search.Pagination.TotalCount)));
}
/// <summary>
/// 根据查询条件获取审批分页数据
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public IList <DtoLessonApprove> GetApproveLessonByPage(DtoApproveLessonSearch search)
{
Check.IfNull(search, nameof(search));
string fields = @" course.Ycs_Id as [CourseID]
,course.Ycs_Name as [CourseName]
,course.Ycs_Grade as [Grade]
,course.Ycs_CourseType as [CourseType]
,lesson.Ycl_Id as [LessonID]
,lesson.Ycl_Index as [LessonIndex]
,lesson.Ycl_Name as [LessonName]
,lesson.Ycl_Producer as [LessonProducer]
,employee.Bem_Name as [LessonProducerName]
,lesson.Ycl_Status as [LessonStatus]
,lesson.Ycl_UpdateTime as [UpdateDate] ";
string from = $@" Yw_CourseLesson as lesson
inner join Yw_Course as course on lesson.Ycl_CourseId = course.Ycs_Id
left join Bas_Employee as employee on lesson.Ycl_Producer = employee.Bem_Id
where (lesson.Ycl_Status = {(int)LessonStatusEnum.待审批} or lesson.Ycl_Status = {(int)LessonStatusEnum.审批中}) ";
string where = from;
if (search.CourseID != 0)
{
where += " and course.Ycs_Id=@courseId ";
}
if (search.CourseType != 0)
{
where += " and course.Ycs_CourseType = @courseType ";
}
if (search.Grade != 0)
{
where += " and course.Ycs_Grade = @grade ";
}
if (search.LessonIndex != 0)
{
where += " and lesson.Ycl_Index = @index ";
}
if (!string.IsNullOrEmpty(search.LessonOrProducerName))
{
where += " and (lesson.Ycl_Name like @name or employee.Bem_Name like @name) ";
}
string orderby = " lesson.Ycl_UpdateTime desc ";
object param = new
{
courseId = search.CourseID,
courseType = search.CourseType,
grade = search.Grade,
index = search.LessonIndex,
name = $"{search.LessonOrProducerName}%"
};
return(base.QueryPaging <DtoLessonApprove>(
fields,
where,
orderby,
search.Pagination,
param).ToList());
}
/// <summary>
/// 根据条件及分页信息查询审批过程中的课时信息
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public List <DtoLessonApprove> GetLessonApproveByPage(DtoApproveLessonSearch search)
{
return(LessonServer.GetApproveLessonByPage(search).ToList());
}
