public ActionResult GetClassList(DtoSchoolClassSearch search)
{
var list = schoolClassBll.GetSchoolClassList(search);
var table = AbhsTableFactory.Create(list, search.Pagination.TotalCount);
return(Json(table, JsonRequestBehavior.AllowGet));
}
// GET: SchoolClass
public ActionResult Index()
{
DtoSchoolClassSearch search = new DtoSchoolClassSearch();
search.SchoolId = CurrentUser.Teacher.Yoh_SchoolId;
return(View(search));
}
/// <summary>
/// 获取班级列表
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public List <DtoSchoolClass> GetSchoolClassList(DtoSchoolClassSearch search)
{
var list = SchoolClassRepository.GetSchoolClassList(search);
SetSchoolClassSchedule(list);
return(list);
}
public List <DtoSchoolClass> GetSchoolClassList(DtoSchoolClassSearch search)
{
if (search == null)
{
return(null);
}
var strWhere = new StringBuilder();
var fields = "sc.*, st.Yoh_Name AS ClassMasterName ,c.Ycs_Name AS CourseName";
var orderBy = "sc.Ycc_Id DESC ";
var parameters = new DynamicParameters();
strWhere.Append($@"dbo.Yw_SchoolClass sc
JOIN dbo.Yw_SchoolTeacher st ON sc.Ycc_ClassMaster=st.Yoh_Id
JOIN dbo.Yw_Course c ON sc.Ycc_CourseId=c.Ycs_Id
WHERE 1=1");
if (search.SchoolId > 0)
{
strWhere.Append(" AND sc.Ycc_SchoolId=@Ycc_SchoolId ");
parameters.Add("Ycc_SchoolId", search.SchoolId);
}
if (search.ClassId > 0)
{
strWhere.Append(" AND sc.Ycc_Id=@Ycc_Id");
parameters.Add("Ycc_Id", search.ClassId);
}
else
{
if (search.CourseType > 0)
{
strWhere.Append(" AND sc.Ycc_CourseType=@Ycc_CourseType");
parameters.Add("Ycc_CourseType", search.CourseType);
}
if (search.Status > 0)
{
strWhere.Append(" AND sc.Ycc_Status=@Ycc_Status");
parameters.Add("Ycc_Status", search.Status);
}
if (search.Grade > 0)
{
strWhere.Append(" AND sc.Ycc_Grade=@Ycc_Grade");
parameters.Add("Ycc_Grade", search.Grade);
}
if (search.SearchStr.HasValue())
{
strWhere.Append(" AND (sc.Ycc_Name LIKE @Ycc_Name OR c.Ycs_Name LIKE @Ycs_Name OR st.Yoh_Name LIKE @Yoh_Name ) ");
parameters.Add("Ycc_Name", $"%{search.SearchStr}%");
parameters.Add("Ycs_Name", $"%{search.SearchStr}%");
parameters.Add("Yoh_Name", $"%{search.SearchStr}%");
}
}
var list = base.QueryPaging <DtoSchoolClass>(fields, strWhere._ToString(), orderBy, search.Pagination, parameters).ToList();
return(list);
}
