Package com.iisigroup.cap.dao.utils

Examples of com.iisigroup.cap.dao.utils.ISearch


@Repository
public class DivRlItmDaoImpl extends GenericDao<DivRlItm> implements DivRlItmDao {

  @Override
  public DivRlItm findByDivRlNo(String divRlNo) {
    ISearch search = createSearchTemplete();
    search.addSearchModeParameters(SearchMode.EQUALS, "divRlNo", divRlNo);
    return findUniqueOrNone(search);
  }
View Full Code Here


    return findUniqueOrNone(search);
  }

  @Override
  public DivRlItm findByDivRlNoAndInputFlg(String divRlNo, String inputFlag) {
    ISearch search = createSearchTemplete();
    search.addSearchModeParameters(SearchMode.EQUALS, "divRlNo", divRlNo);
    search.addSearchModeParameters(SearchMode.EQUALS, "inputFlag", inputFlag);
    search.setFirstResult(0).setMaxResults(Integer.MAX_VALUE);
    return findUniqueOrNone(search);
  }
View Full Code Here

    return findUniqueOrNone(search);
  }

  @Override
  public List<DivRlItm> findByDivRlNo(String[] divRlNos) {
    ISearch search = createSearchTemplete();
    search.addSearchModeParameters(SearchMode.EQUALS, "divRlNo", divRlNos);
    search.setFirstResult(0).setMaxResults(Integer.MAX_VALUE);
    search.addOrderBy("codeOrder");
    return find(search);
  }
View Full Code Here

  }

  @Override
  public List<DivRlItm> findByDivRlNoAndInputFlg(String[] divRlNos,
      String inputFlag) {
    ISearch search = createSearchTemplete();
    search.addSearchModeParameters(SearchMode.EQUALS, "divRlNo", divRlNos);
    search.addSearchModeParameters(SearchMode.EQUALS, "inputFlag", inputFlag);
    return find(search);
  }
View Full Code Here

        return getNamedJdbcTemplate().update("userRole_deleteUserRole", param);
    }

    @Override
    public UserRole findByUserCodeAndRoleCode(String userCode, String roleCode) {
        ISearch search = createSearchTemplete();
        search.addSearchModeParameters(SearchMode.EQUALS, "userCode", userCode);
        search.addSearchModeParameters(SearchMode.EQUALS, "roleCode", roleCode);
        return findUniqueOrNone(search);
    }
View Full Code Here

        return findUniqueOrNone(search);
    }

    @Override
    public void deleteByUserCode(String userCode) {
        ISearch search = createSearchTemplete();
        search.addSearchModeParameters(SearchMode.EQUALS, "userCode", userCode);
        delete(find(search));
    }
View Full Code Here

public class UserDaoImpl extends GenericDao<User> implements IUserDao<User>,
        UserDao {

    @Override
    public User getUserByLoginId(String loginId, String depCode) {
        ISearch search = createSearchTemplete();
        search.addSearchModeParameters(SearchMode.EQUALS, "code", loginId);
        return findUniqueOrNone(search);
    }
View Full Code Here

        return query.getResultList();
    }

    @Override
    public User findByCode(String code) {
        ISearch search = createSearchTemplete();
        search.addSearchModeParameters(SearchMode.EQUALS, "code", code);
        return findUniqueOrNone(search);
    }// ;
View Full Code Here

    }// ;

    @Override
    public Page<Map<String, Object>> findPage(String code, String name,
            String[] roleCodes, String[] status, int maxResults, int firstResult) {
        ISearch search = createSearchTemplete();
        search.setFirstResult(firstResult);
        search.setMaxResults(maxResults);
        search.addOrderBy("code");
        if (!StringUtils.isBlank(code)) {
            search.addSearchModeParameters(SearchMode.LIKE, "u.code", "%"
                    + code + "%");
        }
        if (!StringUtils.isBlank(name)) {
            search.addSearchModeParameters(SearchMode.LIKE, "u.name", "%"
                    + name + "%");
        }
        if (roleCodes != null && roleCodes.length > 0) {
            search.addSearchModeParameters(SearchMode.IS_NOT_NULL,
                    "ur.usercode", null);
            search.addSearchModeParameters(SearchMode.IN, "ur.rolecode",
                    roleCodes);
        }
        if (status != null && status.length > 0) {
            search.addSearchModeParameters(SearchMode.IN, "u.status", status);
        } else {
            search.addSearchModeParameters(SearchMode.NOT_EQUALS, "u.status",
                    "9");
        }
        return getNamedJdbcTemplate().queryForPage("user_find", search);
    }// ;
View Full Code Here

public class DepartmentDaoImpl extends GenericDao<Department> implements
        DepartmentDao {

    @Override
    public List<Department> findByAllDepartment() {
        ISearch search = createSearchTemplete();
        search.setFirstResult(0).setMaxResults(Integer.MAX_VALUE);
        search.addOrderBy("code");
        return find(search);
    }
View Full Code Here

TOP

Related Classes of com.iisigroup.cap.dao.utils.ISearch

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.