public ActionResult GetSchool(DtoSchoolSearch search)
{
var list = schoolBll.GetSchoolList(search);
var table = AbhsTableFactory.Create(list, search.Pagination.TotalCount);
return(Json(table, JsonRequestBehavior.AllowGet));
}
public DtoSchool GetSchoolDto(int schoolId)
{
DtoSchoolSearch search = new DtoSchoolSearch();
search.SchoolId = schoolId;
return(SchoolRepository.GetSchoolList(search).FirstOrDefault());
}
public List <DtoSchool> GetSchoolList(DtoSchoolSearch search)
{
if (search == null)
{
return(null);
}
var strWhere = new StringBuilder();
var fields = "s.*,sl.Bhl_Name AS LevelName,sl.Bhl_DividePercent,r.Reg_FullName AS RegionName ,st.Yoh_Phone AS LoginPhone ";
var orderBy = "s.Bsl_Id DESC ";
var parameters = new DynamicParameters();
strWhere.Append($@"dbo.Bas_School s
INNER JOIN dbo.Bas_SchoolLevel sl ON s.Bsl_Level=sl.Bhl_Id AND sl.Bhl_Status = {(int)StatusEnum.有效}
INNER JOIN dbo.Bas_Region r ON s.Bsl_County = r.Reg_ID
LEFT JOIN dbo.Yw_SchoolTeacher st ON s.Bsl_SchoolMasterId=st.Yoh_Id AND st.Yoh_Status = {(int)StatusEnum.有效}
WHERE 1=1");
if (search.SchoolId > 0)
{
strWhere.Append(" AND s.Bsl_Id=@Bsl_Id ");
parameters.Add("Bsl_Id", search.SchoolId);
}
else
{
if (search.Status > 0)
{
strWhere.Append(" AND s.Bsl_Status=@Bsl_Status ");
parameters.Add("Bsl_Status", search.Status);
}
if (search.CountyId > 0)
{
strWhere.Append(" AND s.Bsl_County=@CountyId ");
parameters.Add("CountyId", search.CountyId);
}
else if (search.CityId > 0)
{
strWhere.Append(" AND s.Bsl_City=@CityId ");
parameters.Add("CityId", search.CityId);
}
else if (search.ProvId > 0)
{
strWhere.Append(" AND s.Bsl_Province=@ProvId ");
parameters.Add("ProvId", search.ProvId);
}
if (search.SearchStr.HasValue())
{
strWhere.Append(" AND (s.Bsl_MasterName LIKE @Bsl_MasterName OR s.Bsl_MasterPhone LIKE @Bsl_MasterPhone OR s.Bsl_SchoolName=@Bsl_SchoolName) ");
parameters.Add("Bsl_MasterName", $"%{search.SearchStr}%");
parameters.Add("Bsl_MasterPhone", $"%{search.SearchStr}%");
parameters.Add("Bsl_SchoolName", $"%{search.SearchStr}%");
}
}
return(base.QueryPaging <DtoSchool>(fields, strWhere._ToString(), orderBy, search.Pagination, parameters).ToList());
}
// GET: School
#region school
public ActionResult Index()
{
DtoSchoolSearch search = new DtoSchoolSearch();
return(View(search));
}
/// <summary>
/// 学校列表
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public List <DtoSchool> GetSchoolList(DtoSchoolSearch search)
{
return(SchoolRepository.GetSchoolList(search));
}
