package com.i5018.common.dao;

import java.io.Serializable;
import java.util.LinkedHashMap;

import javax.persistence.Query;

import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.repository.NoRepositoryBean;

import com.i5018.common.util.QueryResult;

/**
 * 针对spring data jpa所提供的接口{@link JpaRepository}再次扩展
 * @author lmk
 * @NoRepositoryBean是必须的
 */

@NoRepositoryBean
public interface GenericRepository<T, ID extends Serializable> extends
		JpaRepository<T, ID> {

	/**
	 * 
	 * 设置query的参数
	 * @param query
	 *            查询对象
	 * @param queryParams
	 *            参数
	 */

	public void setQueryParams(Query query, Object[] queryParams);

	/**
	 * 
	 * 组装ORDER BY 语句
	 * @param orderby
	 * @return
	 */

	public String buildOrderby(LinkedHashMap<String, String> orderby);

	/**
	 * 
	 * 获取实体名
	 * @param entityClass
	 * @return
	 */

	public String getEntityName(Class<T> entityClass);

	/**
	 * 
	 * jpql语句查询
	 * @param entityClass
	 * @param whereSql
	 * @param queryParams
	 * @param orderby
	 * @param pageable
	 * 
	 * @return
	 */

	public QueryResult<T> getScrollDataByJpql(Class<T> entityClass,
			String whereJpql, Object[] queryParams,

			LinkedHashMap<String, String> orderby, Pageable pageable);

	/**
	 * 
	 * sql语句查询
	 * @param sql
	 * @param queryParams
	 * @param pageable
	 * @return
	 */

	public QueryResult<T> getScrollDataBySql(String sql, Object[] queryParams,
			Pageable pageable);

}