public List<SysOrderDto> queryOrderList(PageInfo pageInfo, SysOrderDto dto) {
Map<String, Object> paraMap = new HashMap<String, Object>();
try {
paraMap.put("fromOrderDate", dto.getFromOrderDate());
paraMap.put("toOrderDate", dto.getToOrderDate());
paraMap.put("fromPayDate", dto.getFromPayDate());
paraMap.put("toPayDate", dto.getToPayDate());
paraMap.put("status", dto.getStatus());
paraMap.put("payDate", dto.getPayDate());
paraMap.put("serviceCode", dto.getServiceCode());
paraMap.put("inOrderName", dto.getInOrderName());
paraMap.put("inOrderName", dto.getInOrderName());
paraMap.put("inOrderName", dto.getInOrderName());
paraMap.put("inOrderName", dto.getInOrderName());
paraMap.put("serviceName", dto.getServiceName());
paraMap.put("itemCode", dto.getItemCode());
paraMap.put("inOrder", dto.getInOrder());
paraMap.put("endDate", dto.getEndDate());
paraMap.put("service1Remains", dto.getService1Remains());
paraMap.put("service2Remains", dto.getService2Remains());
paraMap.put("service3Remains", dto.getService3Remains());
paraMap.put("isNew", dto.getIsNew());
} catch (Exception e) {
logger.error(e);
}
return PagingDataListUtil.getPagingData(pageInfo, "queryOrderCount", "queryOrderList", paraMap);
}
@SuppressWarnings("unchecked")
public List<SysOrderDto> queryEffectiveOrderList(SysOrderDto dto) {
Map<String, Object> paraMap = new HashMap<String, Object>();
try {
paraMap.put("fromOrderDate", dto.getFromOrderDate());
paraMap.put("toOrderDate", dto.getToOrderDate());
paraMap.put("fromPayDate", dto.getFromPayDate());
paraMap.put("toPayDate", dto.getToPayDate());
paraMap.put("status", dto.getStatus());
paraMap.put("payDate", dto.getPayDate());
paraMap.put("serviceCode", dto.getServiceCode());
paraMap.put("inOrderName", dto.getInOrderName());
paraMap.put("inOrderName", dto.getInOrderName());
paraMap.put("inOrderName", dto.getInOrderName());
paraMap.put("inOrderName", dto.getInOrderName());
paraMap.put("serviceName", dto.getServiceName());
paraMap.put("itemCode", dto.getItemCode());
paraMap.put("inOrder", dto.getInOrder());
paraMap.put("endDate", dto.getEndDate());
paraMap.put("service1Remains", dto.getService1Remains());
paraMap.put("service2Remains", dto.getService2Remains());
paraMap.put("service3Remains", dto.getService3Remains());
} catch (Exception e) {
logger.error(e);
}
return sqlMapClientTemplate.queryForList("queryEffectiveOrderList", paraMap);
}
public int getOrdersCount(SysOrderDto dto) {
Map<String, Object> paraMap = new HashMap<String, Object>();
try {
paraMap.put("fromOrderDate", dto.getFromOrderDate());
paraMap.put("toOrderDate", dto.getToOrderDate());
paraMap.put("fromPayDate", dto.getFromPayDate());
paraMap.put("toPayDate", dto.getToPayDate());
paraMap.put("status", dto.getStatus());
paraMap.put("payDate", dto.getPayDate());
paraMap.put("serviceCode", dto.getServiceCode());
paraMap.put("inOrderName", dto.getInOrderName());
paraMap.put("itemCode", dto.getItemCode());
paraMap.put("inOrder", dto.getInOrder());
paraMap.put("endDate", dto.getEndDate());
paraMap.put("service1Remains", dto.getService1Remains());
paraMap.put("service2Remains", dto.getService2Remains());
paraMap.put("service3Remains", dto.getService3Remains());
} catch (Exception e) {
logger.error(e);
}
Object obj = sqlMapClientTemplate.queryForObject("queryOrderCount", paraMap);
return obj != null ? Integer.valueOf(obj.toString()) : 0;
}