public Page<ItemVO> listForPage(int pageCurrent, int pageSize, ItemQO qo) { ItemExample example = new ItemExample(); Criteria c = example.createCriteria(); example.setOrderByClause(" id desc "); Page<Item> page = dao.listForPage(pageCurrent, pageSize, example); return PageUtil.transform(page, ItemVO.class); }
public Criteria or() { Criteria criteria = createCriteriaInternal(); oredCriteria.add(criteria); return criteria; }
@Override public Item getByItemNo(String itemNo) { ItemExample example = new ItemExample(); Criteria c = example.createCriteria(); c.andItemNoEqualTo(itemNo); List<Item> list = this.itemMapper.selectByExample(example); if (list.isEmpty()) { return null; } return list.get(0); }
@Override public Page<Item> listForPage(int pageCurrent, int pageSize, ItemExample example) { int count = this.itemMapper.countByExample(example); pageSize = PageUtil.checkPageSize(pageSize); pageCurrent = PageUtil.checkPageCurrent(count, pageSize, pageCurrent); int totalPage = PageUtil.countTotalPage(count, pageSize); example.setLimitStart(PageUtil.countOffset(pageCurrent, pageSize)); example.setPageSize(pageSize); return new Page<Item>(count, totalPage, pageCurrent, pageSize, this.itemMapper.selectByExample(example)); }
@Override public List<Item> listByItemCategoryAndItemTypeAndFacePrice(Integer ItemCategory, Integer itemType, String facePrice) { ItemExample example = new ItemExample(); Criteria c = example.createCriteria(); c.andItemCategoryEqualTo(ItemCategory); c.andItemTypeEqualTo(itemType); c.andFacePriceEqualTo(facePrice); return this.itemMapper.selectByExample(example); }
@Override public List<Item> listByItemCategoryAndItemTypeAndProvinceCodeAndCarrierTypeAndFacePrice(Integer ItemCategory, Integer itemType, String provinceCode, Integer carrierType, String facePrice) { ItemExample example = new ItemExample(); Criteria c = example.createCriteria(); c.andItemCategoryEqualTo(ItemCategory); c.andItemTypeEqualTo(itemType); c.andSalesAreaEqualTo(provinceCode); c.andCarrierTypeEqualTo(carrierType); c.andFacePriceEqualTo(facePrice); return this.itemMapper.selectByExample(example); }
public Criteria createCriteria() { Criteria criteria = createCriteriaInternal(); if (oredCriteria.size() == 0) { oredCriteria.add(criteria); } return criteria; }