/**
* 根据输入内容匹配查询function
*/
@SuppressWarnings({ "deprecation", "unchecked", "rawtypes" })
public List<Function> getFunctionDataAll(Page page,String searchAll) {
int firstIndex = page.getFirst() - 1;
StringBuffer sql=new StringBuffer("select function_code as functionCode,sum(weight) as weight,sum(cost) as cost from libraryfunction ");
sql.append(" or function_code like '%"+searchAll+"%'")
.append(" group by function_code order by function_code desc")
.append(" limit "+firstIndex+","+page.getPageSize());
List<Function> functionList = createSQLQuery(sql.toString().replaceFirst("or","where"))
.addScalar("functionCode", Hibernate.STRING)
.addScalar("weight",Hibernate.DOUBLE)
.addScalar("cost",Hibernate.DOUBLE)
.setResultTransformer(Transformers.aliasToBean(Function.class)).list();
return functionList;
}