1.自定义查询的数据,可能like啥的,这种字段改了不写死
QueryWrapper<StockLocation> queryWrapper = new QueryWrapper<>();
queryWrapper.lambda().eq(StockLocation::getWarehouseId,inventoryRequest.getWarehouseId());
if (CollUtil.isNotEmpty(inventoryRequest.getGoodsNos())){
queryWrapper.lambda().in(StockLocation::getGoodsNo,inventoryRequest.getGoodsNos());
}
if (StrUtil.isNotBlank(inventoryRequest.getQualityStatus())){
queryWrapper.lambda().eq(StockLocation::getQualityStatus,inventoryRequest.getQualityStatus());
}
List<StockLocation> list = stockLocationMapper.selectList(queryWrapper);
网友评论