```
@RequestMapping("queryProductAdjustChannelOnOffSaleLogPages")
public APIMsgBean<Pages<ResponseProductAdjustChannelOnOffSaleLog>> queryCallZgLogBeanPages(String token, RequestProductAdjustChannelOnOffSaleLog requestBean, HttpServletResponse response) {
APIMsgBean<Pages<ResponseProductAdjustChannelOnOffSaleLog>> apiMsgBean = new APIMsgBean<>
();
try {
Pages<ResponseProductAdjustChannelOnOffSaleLog> returnPagesBean = productAdjustChannelOnOffSaleLogService
.queryProductAdjustChannelOnOffSaleLogPages(requestBean);
apiMsgBean
.setSoaStateBean(ResponseCode
.buildEnumSuccessSOAStateBean("查询上下架日志表信息成功"));
apiMsgBean
.setData(returnPagesBean);
return apiMsgBean;
} catch (Exception e) {
logger
.error(Thread
.currentThread
().getStackTrace
()[1]
.getMethodName
(), e);
toResponseFunction(ResultCodeConstants
.ERROR, ResultCodeConstants
.FAIL_MSG, null, response);
}
apiMsgBean
.setSoaStateBean(ResponseCode
.buildEnumErrorSOAStateBean("查询失败"));
return apiMsgBean;
}
@Override
public Pages<ResultProductPricegroupMateriaBean> queryByConditions(ParaProductPricegroupMateriaBean queryParam) {
// 1
. 创建分页结果对象
Pages<ResultProductPricegroupMateriaBean> pages = new Pages<>
();
List<ResultProductPricegroupMateriaBean> resultList = new ArrayList<>
();
// 2
. 构建查询条件
ProductPricegroupMateriaBeanExample example = new ProductPricegroupMateriaBeanExample
();
ProductPricegroupMateriaBeanExample
.Criteria criteria = example
.createCriteria
();
// 保留原有条件构建逻辑
if (queryParam
.getCategoryId
() != null) {
criteria
.andCategoryIdEqualTo(queryParam
.getCategoryId
());
}
if (
StringUtils.hasText(queryParam
.getMaterialName
())) {
criteria
.andMaterialNameLike("%" + queryParam
.getMaterialName
() + "%");
}
if (
StringUtils.hasText(queryParam
.getPriceGroup
())) {
criteria
.andPriceGroupEqualTo(queryParam
.getPriceGroup
());
}
// 保留状态过滤
criteria
.andStatusNotEqualTo((short)-1);
// 3
. 获取总记录数
long totalCount = materiaMapper
.countByExample(example);
// 4
. 分页处理
if (totalCount > 0) {
// 设置分页参数（假设queryParam包含currentPage和pageSize）
pages
.paging(queryParam
.getCurrentPage
(), pages
.getPageSize
(), totalCount);
// 设置分页范围
example
.limit(pages
.getStartPosition
(), pages
.getPageSize
());
// 保留原有排序逻辑
example
.setOrderByClause("sort ASC");
// 5
. 执行分页查询
List<ProductPricegroupMateriaBean> poList = materiaMapper
.selectByExample(example);
// 6
. PO转DTO
resultList = convertToResultDTOList(poList);
}
// 7
. 设置分页结果
pages
.setList(resultList);
return pages;
}
// DTO转换方法不变
private List<ResultProductPricegroupMateriaBean> convertToResultDTOList(List<ProductPricegroupMateriaBean> poList) {
List<ResultProductPricegroupMateriaBean> resultList = new ArrayList<>
();
for (ProductPricegroupMateriaBean po : poList) {
ResultProductPricegroupMateriaBean dto = new ResultProductPricegroupMateriaBean
();
BeanUtils
.copyProperties(po, dto);
// 特殊字段处理示例：
// dto
.setStatusDesc(StatusEnum
.getDesc(po
.getStatus
()));
resultList
.add(dto);
}
return resultList;
}
}```仿照所给代码给public Pages<ResultProductPricegroupMateriaBean> queryByConditions(ParaProductPricegroupMateriaBean queryParam)写一个controller层的方法
扫一扫
6389
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
