/* (non-Javadoc) * @see com.jlj.service.imp.ICommandService#getTotalCount(int, java.lang.String) */ public int getTotalCount(int con, String convalue, User user) { String queryString = "select count(*) from Command mo where 1=1 "; Object[] p = null; if (con != 0 && convalue != null && !convalue.equals("")) { // 命令名称 if (con == 1) { queryString += "and mo.name like ? "; } p = new Object[] {'%' + convalue + '%'}; } switch (user.getLimits()) { case 0: // 系统管理员 queryString += " order by mo.project.id desc "; break; case 1: // 高级管理员 queryString += "and mo.project.id=" + user.getProject().getId(); break; case 2: // 普通管理员 queryString += "and mo.project.id=" + user.getProject().getId(); break; default: break; } return commandDao.getUniqueResult(queryString, p); }
/* (non-Javadoc) * @see com.jlj.service.imp.ICommandService#queryList(int, java.lang.String, int, int) */ public List<Command> queryList(int con, String convalue, User user, int page, int size) { String queryString = "from Command mo where 1=1 "; Object[] p = null; if (con != 0 && convalue != null && !convalue.equals("")) { // 线路名称 if (con == 1) { queryString += "and mo.name like ? "; } p = new Object[] {'%' + convalue + '%'}; } switch (user.getLimits()) { case 0: // 系统管理员 queryString += " order by mo.project.id desc "; break; case 1: // 高级管理员 queryString += "and mo.project.id=" + user.getProject().getId(); break; case 2: // 普通管理员 queryString += "and mo.project.id=" + user.getProject().getId(); break; default: break; } return commandDao.pageList(queryString, p, page, size); }