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); }