public ContentResult listcountry(CountryQueryRequest request)
{
var data = _countryService.List(request);
var res = new ResultDto <CountryResponse>
{
page = request.PageIndex,
total = request.Total,
records = request.Records,
rows = data
};
return(Content(res.Serialize()));
}
public CountryQueryResponse GetCountries(CountryQueryRequest request)
{
var response = new CountryQueryResponse();
try
{
var countries = _locationRepository.GetCountries();
response.Countries = Mapper.Map <IList <Country>, IList <CountryDto> >(countries);
}
catch (Exception exception)
{
response.Failed = true;
_logger.Log(exception);
}
return(response);
}
public List <CountryResponse> List(CountryQueryRequest request)
{
List <CountryResponse> list = new List <CountryResponse>();
try
{
StringBuilder join = new StringBuilder();
if (request.Name.IsNotEmpty())
{
request.Name = $"%{request.Name}%";
join.Append(" and name like @Name");
}
var sql = $@"select * from t_sys_country where isdelete=0 {join.ToString()} order by createtime desc";
int totalCount = 0;
list = _dbContext.Page <CountryResponse>(sql, out totalCount, request.PageIndex, request.PageSize, request);
request.Records = totalCount;
}
catch (Exception ex)
{
LogUtils.LogError("CountryService.List", ex);
}
return(list);
}
