public int countPersonInfoByLower(String dep, String name, String orgId,String objectDept,String resultFields) throws com.liferay.portal.SystemException {
String finderClassName = EipPersonMain.class.getName();
String finderMethodName = "countPersonInfoByLower";
String[] finderParams = new String[] { String.class.getName(),String.class.getName(),String.class.getName(),String.class.getName(),String.class.getName()};
Object[] finderArgs = new Object[] { dep,name,orgId,objectDept,resultFields };
Object result = FinderCache.getResult(finderClassName,
finderMethodName, finderParams, finderArgs);
if (result == null) {
Session session = null;
try {
session = openSession();
String sql = " SELECT " + resultFields
+ " FROM EIP_PERSON_MAIN"
+ " WHERE rank like ('%"+orgId+"%')"
+ " AND org_id IN ("+ objectDept+")";
if(name != null && name != "") {
sql += " AND personName LIKE '%" + name + "%'";
}
if(dep != null && dep != "") {
sql += " AND orgName LIKE '%" + dep + "%'";
}
SQLQuery q = session.createSQLQuery(sql);
List list = q.list();
FinderCache.putResult(finderClassName, finderMethodName,
finderParams, finderArgs, list);
return list.size();
} catch (Exception e) {
throw HibernateUtil.processException(e);
} finally {
closeSession(session);
}
}else {
return ((List)result).size();
}
}
liferay缓存使用
最新推荐文章于 2020-05-13 17:00:18 发布