public List <ProvinceResponse> List(ProvinceQueryRequest request) { List <ProvinceResponse> list = new List <ProvinceResponse>(); try { StringBuilder join = new StringBuilder(); if (request.Name.IsNotEmpty()) { request.Name = $"%{request.Name}%"; join.Append(" and name like @Name"); } if (request.IsInter != null) { join.Append(" and IsInter=@IsInter "); } var sql = $@"select * from t_sys_province where isdelete=0 {join.ToString()} order by createtime desc"; int totalCount = 0; list = _dbContext.Page <ProvinceResponse>(sql, out totalCount, request.PageIndex, request.PageSize, request); request.Records = totalCount; } catch (Exception ex) { LogUtils.LogError("ProvinceService.List", ex); } return(list); }
public ContentResult listprovince(ProvinceQueryRequest request) { var data = _provinceService.List(request); var res = new ResultDto <ProvinceResponse> { page = request.PageIndex, total = request.Total, records = request.Records, rows = data }; return(Content(res.Serialize())); }