public List <CityResponse> List(CityQueryRequest request)
{
List <CityResponse> list = new List <CityResponse>();
try
{
StringBuilder join = new StringBuilder();
if (request.Name.IsNotEmpty())
{
request.Name = $"%{request.Name}%";
join.Append(" and a.name like @Name");
}
if (request.ProvinceId != null && request.ProvinceId > 0)
{
join.Append(" and a.provinceId=@ProvinceId ");
}
var sql = $@"select a.*,b.name ProvinceName from t_sys_city a left join t_sys_province b on a.provinceId=b.Id where isdelete=0 {join.ToString()}";
int totalCount = 0;
list = _dbContext.Page <CityResponse>(sql, out totalCount, request.PageIndex, request.PageSize, request);
request.Records = totalCount;
}
catch (Exception ex)
{
LogUtils.LogError("CityService.List", ex);
}
return(list);
}
public ContentResult listcity(CityQueryRequest request)
{
var data = _cityService.List(request);
var res = new ResultDto <CityResponse>
{
page = request.PageIndex,
total = request.Total,
records = request.Records,
rows = data
};
return(Content(res.Serialize()));
}
