コード例 #1
0
  /** Updates a Study event */
  public EntityBean update(EntityBean eb) {
    // update discrepancy_note set
    // description =?,
    // discrepancy_note_type_id =? ,
    // resolution_status_id =? ,
    // detailed_notes =?
    // where discrepancy_note_id=?
    DiscrepancyNoteBean dnb = (DiscrepancyNoteBean) eb;
    dnb.setActive(false);

    HashMap variables = new HashMap();

    variables.put(new Integer(1), dnb.getDescription());
    variables.put(new Integer(2), new Integer(dnb.getDiscrepancyNoteTypeId()));
    variables.put(new Integer(3), new Integer(dnb.getResolutionStatusId()));
    variables.put(new Integer(4), dnb.getDetailedNotes());
    variables.put(new Integer(5), new Integer(dnb.getId()));
    this.execute(digester.getQuery("update"), variables);

    if (isQuerySuccessful()) {
      dnb.setActive(true);
    }

    return dnb;
  }
コード例 #2
0
  /** Creates a new discrepancy note */
  public EntityBean create(EntityBean eb) {
    DiscrepancyNoteBean sb = (DiscrepancyNoteBean) eb;
    HashMap variables = new HashMap();
    HashMap nullVars = new HashMap();
    // INSERT INTO discrepancy_note
    // (description, discrepancy_note_type_id ,
    // resolution_status_id , detailed_notes , date_created,
    // owner_id, parent_dn_id)
    // VALUES (?,?,?,?,now(),?,?)
    variables.put(new Integer(1), sb.getDescription());
    variables.put(new Integer(2), new Integer(sb.getDiscrepancyNoteTypeId()));
    variables.put(new Integer(3), new Integer(sb.getResolutionStatusId()));
    variables.put(new Integer(4), sb.getDetailedNotes());

    variables.put(new Integer(5), new Integer(sb.getOwner().getId()));
    if (sb.getParentDnId() == 0) {
      nullVars.put(new Integer(6), new Integer(Types.INTEGER));
      variables.put(new Integer(6), null);
    } else {
      variables.put(new Integer(6), new Integer(sb.getParentDnId()));
    }
    variables.put(new Integer(7), sb.getEntityType());
    variables.put(new Integer(8), new Integer(sb.getStudyId()));

    this.executeWithPK(digester.getQuery("create"), variables, nullVars);
    if (isQuerySuccessful()) {
      sb.setId(getLatestPK());
    }

    return sb;
  }