/*
  * @see com.beike.dao.background.guest.GuestDao#queryGuestCountByConditions(com.beike.form.background.guest.GuestForm)
  */
 public int queryGuestCountByConditions(GuestForm guestForm) throws Exception {
   int totalRows = 0;
   StringBuilder sql = new StringBuilder();
   sql.append(
       "SELECT COUNT(1) FROM beiker_guest_info c LEFT JOIN beiker_brand b ON b.brand_id = c.brand_id  WHERE 1=1 ");
   if (guestForm.getGuestId() > 0) {
     sql.append(" AND c.guest_id = ").append(guestForm.getGuestId());
   }
   if (StringUtils.validNull(guestForm.getGuestCnName())) {
     sql.append(" AND c.guest_cn_name LIKE ")
         .append("'%" + guestForm.getGuestCnName().trim() + "%'");
   }
   if (StringUtils.validNull(guestForm.getBrandName())) {
     sql.append(" AND b.brand_name LIKE ").append("'%" + guestForm.getBrandName().trim() + "%'");
   }
   if (StringUtils.validNull(guestForm.getGuestAddress())) {
     sql.append(" AND c.guest_address LIKE ")
         .append("'%" + guestForm.getGuestAddress().trim() + "%'");
   }
   if (guestForm.getBrandId() > 0) {
     sql.append(" AND c.brand_id = ").append(guestForm.getBrandId());
   }
   totalRows = this.getJdbcTemplate().queryForInt(sql.toString());
   return totalRows;
 }
 /*
  * @see com.beike.dao.background.guest.GuestDao#queryGuestByConditions(com.beike.form.background.guest.GuestForm, int, int)
  */
 @SuppressWarnings("unchecked")
 public List<Guest> queryGuestByConditions(GuestForm guestForm, int startRow, int pageSize)
     throws Exception {
   List tempList = null;
   List<Guest> guestList = new ArrayList<Guest>();
   StringBuilder sql = new StringBuilder();
   sql.append(
       "SELECT c.guest_id guest_id,c.guest_cn_name guest_cn_name,b.brand_name brand_name,c.guest_address guest_address,c.guest_status guest_status,c.brand_id brand_id FROM beiker_guest_info c ");
   sql.append("LEFT JOIN beiker_brand b ON b.brand_id = c.brand_id  WHERE 1=1 ");
   if (guestForm.getGuestId() > 0) {
     sql.append(" AND c.guest_id = ").append(guestForm.getGuestId());
   }
   if (StringUtils.validNull(guestForm.getGuestCnName())) {
     sql.append(" AND c.guest_cn_name LIKE ")
         .append("'%" + guestForm.getGuestCnName().trim() + "%'");
   }
   if (StringUtils.validNull(guestForm.getBrandName())) {
     sql.append(" AND b.brand_name LIKE ").append("'%" + guestForm.getBrandName().trim() + "%'");
   }
   if (StringUtils.validNull(guestForm.getGuestAddress())) {
     sql.append(" AND c.guest_address LIKE ")
         .append("'%" + guestForm.getGuestAddress().trim() + "%'");
   }
   if (guestForm.getBrandId() > 0) {
     sql.append(" AND c.brand_id = ").append(guestForm.getBrandId());
   }
   sql.append(" ORDER BY guest_id DESC LIMIT ?,? ");
   Object[] params = new Object[] {startRow, pageSize};
   int[] types = new int[] {Types.INTEGER, Types.INTEGER};
   tempList = this.getJdbcTemplate().queryForList(sql.toString(), params, types);
   if (null != tempList && tempList.size() > 0) {
     guestList = this.convertResultToObjectList(tempList);
   }
   return guestList;
 }