java搜索分页

最新推荐文章于 2024-01-11 15:53:54 发布

c230704

最新推荐文章于 2024-01-11 15:53:54 发布

阅读量392

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/c230704/article/details/93205771

版权

java 专栏收录该内容

23 篇文章 0 订阅

订阅专栏

//查退货单
public Page<WxOrder> getReturnList(String mid,  Map<String, Object> searchParams, Page<WxOrder> page) {
	String orderId="";
	String status="";
	String startTime = "";
	String endTime ="";
	String orderType = "";
	String saleType = "";
	if (searchParams.containsKey("EQS_status")&&searchParams.get("EQS_status")!=null) {
		status=searchParams.get("EQS_status").toString();
	}
	if (searchParams.containsKey("GED_createTime")&&searchParams.get("GED_createTime")!=null) {
		startTime=searchParams.get("GED_createTime").toString();
	}
	if (searchParams.containsKey("LED_createTime")&&searchParams.get("LED_createTime")!=null) {
		endTime=searchParams.get("LED_createTime").toString();
	}

	if (searchParams.containsKey("EQS_orderType")&&searchParams.get("EQS_orderType")!=null) {
		orderType=searchParams.get("EQS_orderType").toString();
	}

	if (searchParams.containsKey("EQS_saleType")&&searchParams.get("EQS_saleType")!=null) {
		saleType=searchParams.get("EQS_saleType").toString();
	}
	StringBuffer sql = new StringBuffer();
	StringBuffer countsql = new StringBuffer();
	sql.append("select  order_id orderId ,mid ,      mobile_no mobileNo , amount amount    from wx_order where '1' =  '1'");
	countsql.append("select count(*) from wx_order  where  '1' = '1'");
	if (StringUtils.isNotEmpty(status)) {
		sql.append(" and wx.status='"+status+"'");
		countsql.append(" and status='"+status+"'");
	}
	if (StringUtils.isNotEmpty(startTime)) {
		sql.append(" and create_time >='"+startTime+" 00:00:00'");
		countsql.append(" and create_time >='"+startTime+" 00:00:00'");
	}
	if (StringUtils.isNotEmpty(endTime)) {
		sql.append(" and create_time <='"+endTime+" 23:59:59'");
		countsql.append(" and create_time <='"+endTime+" 23:59:59'");
	}
	if (StringUtils.isNotEmpty(orderType)) {
		sql.append(" and order_type ='"+orderType+"'");
		countsql.append(" and order_type ='"+orderType+"'");
	}
	if (StringUtils.isNotEmpty(saleType)) {
		sql.append(" and sale_type ='"+saleType+"'");
		countsql.append(" and sale_type ='"+saleType+"'");
	}
	sql.append(" order by create_time desc ");
	// /*TDDL\\:SLAVE*/
	System.out.println("sql=="+sql.toString());
	SQLQuery query = this.getSession().createSQLQuery(sql.toString());
	query.setMaxResults(page.getPageSize());
	query.setFirstResult((page.getPageNo()-1)*page.getPageSize());
	query.addScalar("orderId", new StringType());
	query.addScalar("mid", new StringType());
	query.addScalar("mobileNo", new StringType());
	query.addScalar("amount", new IntegerType());
	query.setResultTransformer(Transformers.aliasToBean(WxOrder.class));
	List<WxOrder> list = query.list();
	page.setResult(list);
	// /*TDDL\\:SLAVE*/
	Query q = this.getSession().createSQLQuery(countsql.toString());
	BigInteger total = (BigInteger) q.uniqueResult();
	if (total==null) {
		total= new BigInteger("0");
	}
	page.setTotalCount(Long.valueOf(total.toString()));
	return page;
}