protected void addOrders( StringBuilder qlString, List<com.hongqiang.shop.common.utils.Order> orderList, List<Object> params) { if (orderList != null && orderList.size() > 0) { if (qlString.indexOf("order by") == -1) { qlString.append("order by "); } else { qlString.append(" , "); } Iterator<com.hongqiang.shop.common.utils.Order> localIterator = orderList.iterator(); while (localIterator.hasNext()) { com.hongqiang.shop.common.utils.Order localOrder = (com.hongqiang.shop.common.utils.Order) localIterator.next(); if (localOrder.getDirection() == com.hongqiang.shop.common.utils.Order.Direction.asc) { qlString.append(localOrder.getProperty() + " ASC,"); } else { if (localOrder.getDirection() != com.hongqiang.shop.common.utils.Order.Direction.desc) continue; qlString.append(localOrder.getProperty() + " DESC,"); } } if (qlString.charAt(qlString.length() - 1) == ',') { qlString.deleteCharAt(qlString.length() - 1); } } }
protected void addOrders(StringBuilder qlString, Pageable pageable, List<Object> params) { int tag = 0; if ((StringUtils.isNotEmpty(pageable.getOrderProperty())) && (pageable.getOrderDirection() != null)) { tag = 1; if (qlString.indexOf("order by") == -1) { qlString.append("order by "); } else { qlString.append(" , "); } if (pageable.getOrderDirection() == com.hongqiang.shop.common.utils.Order.Direction.asc) { qlString.append(" " + pageable.getOrderProperty() + " ASC "); } else if (pageable.getOrderDirection() == com.hongqiang.shop.common.utils.Order.Direction.desc) { qlString.append(" " + pageable.getOrderProperty() + " DESC "); } } if (pageable.getOrders() != null && pageable.getOrders().size() > 0) { if (tag == 0) { qlString.append("order by "); } else { qlString.append(" , "); } Iterator<com.hongqiang.shop.common.utils.Order> localIterator = pageable.getOrders().iterator(); while (localIterator.hasNext()) { com.hongqiang.shop.common.utils.Order localOrder = (com.hongqiang.shop.common.utils.Order) localIterator.next(); if (localOrder.getDirection() == com.hongqiang.shop.common.utils.Order.Direction.asc) { qlString.append(" " + localOrder.getProperty() + " ASC,"); } else { if (localOrder.getDirection() != com.hongqiang.shop.common.utils.Order.Direction.desc) continue; qlString.append(" " + localOrder.getProperty() + " DESC,"); } } if (qlString.charAt(qlString.length() - 1) == ',') { qlString.deleteCharAt(qlString.length() - 1); } } }