Esempio n. 1
0
  /* (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);
  }
Esempio n. 2
0
  /* (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);
  }
Esempio n. 3
0
 /* (non-Javadoc)
  * @see com.jlj.service.imp.ICommandService#loadById(int)
  */
 public Command loadById(int id) {
   return commandDao.loadById(id);
 }
Esempio n. 4
0
 /* (non-Javadoc)
  * @see com.jlj.service.imp.ICommandService#getCommands()
  */
 public List<Command> getCommands() {
   return commandDao.getCommands();
 }
Esempio n. 5
0
 /* (non-Javadoc)
  * @see com.jlj.service.imp.ICommandService#update(com.jlj.model.Command)
  */
 public void update(Command command) {
   commandDao.update(command);
 }
Esempio n. 6
0
 /* (non-Javadoc)
  * @see com.jlj.service.imp.ICommandService#deleteById(int)
  */
 public void deleteById(int id) {
   commandDao.deleteById(id);
 }
Esempio n. 7
0
 /* (non-Javadoc)
  * @see com.jlj.service.imp.ICommandService#delete(com.jlj.model.Command)
  */
 public void delete(Command command) {
   commandDao.delete(command);
 }
Esempio n. 8
0
 /* (non-Javadoc)
  * @see com.jlj.service.imp.ICommandService#add(com.jlj.model.Command)
  */
 public void add(Command command) throws Exception {
   commandDao.save(command);
 }