Exemplo n.º 1
0
  /**
   * <br>
   * [機 能] アドレス帳の削除を行う <br>
   * [解 説] <br>
   * [備 考]
   *
   * @param con コネクション
   * @param paramMdl Adr020ParamModel
   * @param sessionUserSid セッションユーザSID
   * @throws Exception 実行例外
   */
  public void deleteAddress(Connection con, Adr020ParamModel paramMdl, int sessionUserSid)
      throws Exception {
    int adrSid = paramMdl.getAdr010EditAdrSid();

    // アドレス帳情報の削除
    AdrAddressDao addressDao = new AdrAddressDao(con);
    addressDao.delete(adrSid);

    // 担当者情報を削除する
    AdrPersonchargeDao adrPersonDao = new AdrPersonchargeDao(con);
    adrPersonDao.deleteToAddress(adrSid);

    // ラベル付与情報を削除する
    AdrBelongLabelDao belongLabelDao = new AdrBelongLabelDao(con);
    belongLabelDao.deleteToAddress(adrSid);

    // バイナリー情報を論理削除する
    AddressDao adrDao = new AddressDao(con);
    adrDao.deleteBinData(adrSid);

    // コンタクト履歴添付情報を削除する
    adrDao.deleteContactBinToAddress(adrSid);

    // コンタクト履歴情報を削除する
    AdrContactDao contactDao = new AdrContactDao(con);
    contactDao.deleteToAddress(adrSid);
  }
Exemplo n.º 2
0
  /**
   * <br>
   * [機 能] 指定された会社情報をDBから読み込み、パラメータに設定する <br>
   * [解 説] <br>
   * [備 考]
   *
   * @param con コネクション
   * @param paramMdl Adr020ParamModel
   * @throws SQLException SQL実行時例外
   */
  protected void _setAddressData(Connection con, Adr020ParamModel paramMdl) throws SQLException {
    AdrAddressDao addressDao = new AdrAddressDao(con);
    // アドレス帳状報の設定
    int adrSid = paramMdl.getAdr010EditAdrSid();
    AdrAddressModel addressMdl = addressDao.select(adrSid);
    if (addressMdl == null) {
      return;
    }
    paramMdl.setAdr020unameSei(addressMdl.getAdrSei());
    paramMdl.setAdr020unameMei(addressMdl.getAdrMei());
    paramMdl.setAdr020unameSeiKn(addressMdl.getAdrSeiKn());
    paramMdl.setAdr020unameMeiKn(addressMdl.getAdrMeiKn());
    paramMdl.setAdr020selectCompany(String.valueOf(addressMdl.getAcoSid()));
    paramMdl.setAdr020selectCompanyBase(String.valueOf(addressMdl.getAbaSid()));
    paramMdl.setAdr020syozoku(addressMdl.getAdrSyozoku());
    paramMdl.setAdr020position(addressMdl.getApsSid());
    paramMdl.setAdr020mail1(addressMdl.getAdrMail1());
    paramMdl.setAdr020mail1Comment(addressMdl.getAdrMailCmt1());
    paramMdl.setAdr020mail2(addressMdl.getAdrMail2());
    paramMdl.setAdr020mail2Comment(addressMdl.getAdrMailCmt2());
    paramMdl.setAdr020mail3(addressMdl.getAdrMail3());
    paramMdl.setAdr020mail3Comment(addressMdl.getAdrMailCmt3());

    paramMdl.setAdr020postno1(addressMdl.getAdrPostno1());
    paramMdl.setAdr020postno2(addressMdl.getAdrPostno2());
    paramMdl.setAdr020tdfk(addressMdl.getTdfSid());
    paramMdl.setAdr020address1(addressMdl.getAdrAddr1());
    paramMdl.setAdr020address2(addressMdl.getAdrAddr2());
    paramMdl.setAdr020tel1(addressMdl.getAdrTel1());
    paramMdl.setAdr020tel1Nai(addressMdl.getAdrTelNai1());
    paramMdl.setAdr020tel1Comment(addressMdl.getAdrTelCmt1());
    paramMdl.setAdr020tel2(addressMdl.getAdrTel2());
    paramMdl.setAdr020tel2Nai(addressMdl.getAdrTelNai2());
    paramMdl.setAdr020tel2Comment(addressMdl.getAdrTelCmt2());
    paramMdl.setAdr020tel3(addressMdl.getAdrTel3());
    paramMdl.setAdr020tel3Nai(addressMdl.getAdrTelNai3());
    paramMdl.setAdr020tel3Comment(addressMdl.getAdrTelCmt3());
    paramMdl.setAdr020fax1(addressMdl.getAdrFax1());
    paramMdl.setAdr020fax1Comment(addressMdl.getAdrFaxCmt1());
    paramMdl.setAdr020fax2(addressMdl.getAdrFax2());
    paramMdl.setAdr020fax2Comment(addressMdl.getAdrFaxCmt2());
    paramMdl.setAdr020fax3(addressMdl.getAdrFax3());
    paramMdl.setAdr020fax3Comment(addressMdl.getAdrFaxCmt3());
    paramMdl.setAdr020biko(addressMdl.getAdrBiko());
    paramMdl.setAdr020permitView(addressMdl.getAdrPermitView());
    paramMdl.setAdr020permitEdit(addressMdl.getAdrPermitEdit());

    // 担当者の設定
    AdrPersonchargeDao tantoDao = new AdrPersonchargeDao(con);
    List<AdrPersonchargeModel> tantoDataList = tantoDao.getTantoListForAddress(adrSid);
    List<String> tantoList = new ArrayList<String>();
    for (AdrPersonchargeModel tantoData : tantoDataList) {
      tantoList.add(String.valueOf(tantoData.getUsrSid()));
    }
    paramMdl.setAdr020tantoList(tantoList.toArray(new String[tantoList.size()]));

    // ラベル情報の設定
    AdrBelongLabelDao belongLabelDao = new AdrBelongLabelDao(con);
    paramMdl.setAdr020label(belongLabelDao.getLabelSidList(adrSid));

    // 閲覧権限グループの設定
    AdrPermitViewDao permitViewDao = new AdrPermitViewDao(con);
    int permitView = paramMdl.getAdr020permitView();
    if (permitView == GSConst.ADR_VIEWPERMIT_GROUP || permitView == GSConst.ADR_VIEWPERMIT_USER) {
      List<AdrPermitViewModel> permitDataList = permitViewDao.getPermitListForAddress(adrSid);
      List<String> permitList = new ArrayList<String>();

      for (AdrPermitViewModel permitData : permitDataList) {
        if (permitView == GSConst.ADR_VIEWPERMIT_GROUP) {
          permitList.add(String.valueOf(permitData.getGrpSid()));
        } else if (permitView == GSConst.ADR_VIEWPERMIT_USER) {
          permitList.add(String.valueOf(permitData.getUsrSid()));
        }
      }

      String[] permitArray = permitList.toArray(new String[permitList.size()]);
      if (permitView == GSConst.ADR_VIEWPERMIT_GROUP) {
        paramMdl.setAdr020permitViewGroup(permitArray);
      } else if (permitView == GSConst.ADR_VIEWPERMIT_USER) {
        paramMdl.setAdr020permitViewUser(permitArray);
      }
    }

    // 編集権限グループの設定
    AdrPermitEditDao permitEditDao = new AdrPermitEditDao(con);
    int permitEdit = paramMdl.getAdr020permitEdit();
    if (permitEdit == GSConstAddress.EDITPERMIT_GROUP
        || permitEdit == GSConstAddress.EDITPERMIT_USER) {
      List<AdrPermitEditModel> permitDataList = permitEditDao.getPermitListForAddress(adrSid);
      List<String> permitList = new ArrayList<String>();

      for (AdrPermitEditModel permitData : permitDataList) {
        if (permitEdit == GSConstAddress.EDITPERMIT_GROUP) {
          permitList.add(String.valueOf(permitData.getGrpSid()));
        } else if (permitEdit == GSConstAddress.EDITPERMIT_USER) {
          permitList.add(String.valueOf(permitData.getUsrSid()));
        }
      }

      String[] permitArray = permitList.toArray(new String[permitList.size()]);
      if (permitEdit == GSConstAddress.EDITPERMIT_GROUP) {
        paramMdl.setAdr020permitEditGroup(permitArray);
      } else if (permitEdit == GSConstAddress.EDITPERMIT_USER) {
        paramMdl.setAdr020permitEditUser(permitArray);
      }
    }
  }