public ContentResult listschool(SchoolQueryRequest request)
{
var data = _schoolService.List(request);
var res = new ResultDto <SchoolResponse>
{
page = request.PageIndex,
total = request.Total,
records = request.Records,
rows = data
};
return(Content(res.Serialize()));
}
//学校列表
public List <SchoolResponse> List(SchoolQueryRequest request)
{
List <SchoolResponse> list = new List <SchoolResponse>();
try
{
StringBuilder join = new StringBuilder();
if (request.EnglishName.IsNotEmpty())
{
request.EnglishName = $"%{request.EnglishName}%";
join.Append(" and englishname like @EnglishName");
}
if (request.ChinessName.IsNotEmpty())
{
request.ChinessName = $"%{request.ChinessName}%";
join.Append(" and chinessname like @ChinessName");
}
if (request.ProvinceId.HasValue && request.ProvinceId > 0)
{
join.Append(" and provinceId = @ProvinceId");
}
if (request.CityId.HasValue && request.CityId > 0)
{
join.Append(" and cityId = @CityId");
}
var sql = $@"select a.*,b.name as ProvinceName,c.name as CityName from t_sys_school a
left join t_sys_province b on a.provinceId=b.id
left join t_sys_city c on a.cityId=c.id
where isdelete=0 {join.ToString()} order by a.createtime desc ";
int totalCount = 0;
list = _dbContext.Page <SchoolResponse>(sql, out totalCount, request.PageIndex, request.PageSize, request);
request.Records = totalCount;
}
catch (Exception ex)
{
LogUtils.LogError("SchoolService.List", ex);
}
return(list);
}
