Example usage for org.apache.poi.xssf.usermodel XSSFRow getCell

List of usage examples for org.apache.poi.xssf.usermodel XSSFRow getCell

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.xssf.usermodel.*
  5. XSSFRow
  6. getCell

Introduction

In this page you can find the example usage for org.apache.poi.xssf.usermodel XSSFRow getCell.

Prototype

@Override
public XSSFCell getCell(int cellnum)

Source Link

Document

Returns the cell at the given (0 based) index, with the org.apache.poi.ss.usermodel.Row.MissingCellPolicy from the parent Workbook.

Usage

From source file:Import.ImportDonation.java

private AcDonateMemberAccount AddDoanteMemberAccount(XSSFRow row, ShPerson person,
        AcDonateMember donateMember) {/* w w  w  .  j a v  a2  s .  c o  m*/
    AcDonateMemberAccount donateMemberAccount = new AcDonateMemberAccount();
    //        
    donateMemberAccount.setBusinessUnitId(person.getBusinessUnitId());
    donateMemberAccount.setDonateMemberId(donateMember.getDonateMemberId());
    XSSFCell cell81 = row.getCell(81);
    String accountFullCode = getStringCellValueSetError(cell81, 81);
    Integer accountId = null;
    if (!isBlankOrNull(accountFullCode)) {
        accountId = getAccountId(accountFullCode);
    }
    donateMemberAccount.setAccountId(accountId);

    XSSFCell cell82 = row.getCell(82);
    String departmentFullCode = getStringCellValueSetError(cell82, 82);
    Integer departmentId = null;
    if (!isBlankOrNull(departmentFullCode)) {
        departmentId = getDepartmentId(departmentFullCode);
    }
    donateMemberAccount.setDepartmentId(departmentId);

    XSSFCell cell83 = row.getCell(83);
    String planFullCode = getStringCellValueSetError(cell83, 83);
    Integer planId = null;
    if (!isBlankOrNull(planFullCode)) {
        planId = getPlanId(planFullCode);
    }
    donateMemberAccount.setPlanId(planId);

    XSSFCell cell84 = row.getCell(84);
    String sourceFullCode = getStringCellValueSetError(cell84, 84);
    Integer sourceId = null;
    if (!isBlankOrNull(sourceFullCode)) {
        sourceId = getSourceId(sourceFullCode);
    }
    donateMemberAccount.setSourceId(sourceId);

    XSSFCell cell85 = row.getCell(85);
    String subAccountFullCode = getStringCellValueNoSetError(cell85);
    Integer subAccountId = null;
    if (!isBlankOrNull(subAccountFullCode)) {
        subAccountId = getSubAccountId(subAccountFullCode, departmentId, sourceId);
    }
    donateMemberAccount.setSubAccountId(subAccountId);

    donateMemberAccount.setIsCancel(STRING_N);
    donateMemberAccount.setIsLockUpdate(STRING_N);
    donateMemberAccount.setCreateTime(NOW);
    donateMemberAccount.setCreateTime(NOW);
    donateMemberAccount.setCreateProg(CREATE_PROG);
    donateMemberAccount.setCreateUserId(CREATE_USER_ID);
    donateMemberAccount.setLastUpdTime(NOW);
    donateMemberAccount.setLastUpdUserId(CREATE_USER_ID);
    donateMemberAccount.setLastUpdProg(CREATE_PROG);
    donateMemberAccount.setLastUpdVersion(1);
    cacheDao.addEntity(donateMemberAccount);
    return donateMemberAccount;
}

From source file:Import.ImportDonation.java

private ShMember AddMember(XSSFRow row, ShPerson person) {
    ShMember member = new ShMember();
    member.setBusinessUnitId(person.getBusinessUnitId());
    member.setPersonId(person.getPersonId());
    XSSFCell cell63 = row.getCell(63);
    Date oldDonateDate = getDateCellValueIsNotEmptySetError(cell63, 63);
    String budgetYear = dateToBudgetYear(oldDonateDate);

    try {/*from www .java2s. co m*/
        subBudgetYear = budgetYear.substring(2);
    } catch (NullPointerException nullEx) {
        validationError.append("  ").append(" [")
                .append(budgetYear).append(" ] ");
    }

    try {
        String memberNo = getFormMemberNo(person.getBusinessUnitId(), subBudgetYear);
        member.setMemberNo(memberNo);
    } catch (NullPointerException e) {
        validationError.append(" [Gen MemberNo ] ");
    }
    XSSFCell cell1 = row.getCell(1);
    String memberTypeName = getStringCellValueSetError(cell1, 1);
    ShMemberType findShMemberTypeByName = cacheDao.findShMemberTypeByNameCache(memberTypeName);
    if (findShMemberTypeByName == null) {
        setError(1);
    }
    member.setMemberTypeId(findShMemberTypeByName);
    member.setMemberRequestId(null);

    member.setMemberSource(STRING_A);
    member.setDonatorId(null);
    member.setDonatorRelate(null);
    XSSFCell cell68 = row.getCell(68);
    Date actorData = getDateCellValueSetError(cell68, 68);
    member.setRegisterDate(actorData);
    member.setMemberRequestRelationId(null);
    member.setDepartmentId(person.getBusinessUnitId());
    member.setOldRegisterDate(actorData);
    member.setOldTotalAmount(BigDecimal.ZERO);
    member.setOldPaidAmount(BigDecimal.ZERO);
    member.setOldPaidDate(null);
    member.setOldPaidYear(null);
    member.setOldPaidTerm(null);
    XSSFCell cell67 = row.getCell(67);
    String pruPose = getStringCellValueNoSetError(cell67);
    member.setOldMemberNo(pruPose);
    XSSFCell cell62 = row.getCell(62);
    BigDecimal amount = getBigDecimalCellValueSetError(cell62, 62);
    member.setAmount(amount);
    member.setIsCancel(STRING_N);
    member.setIsLockUpdate(STRING_N);
    member.setCreateTime(NOW);
    member.setCreateProg(CREATE_PROG);
    member.setCreateUserId(CREATE_USER_ID);
    member.setLastUpdTime(NOW);
    member.setLastUpdUserId(CREATE_USER_ID);
    member.setLastUpdProg(CREATE_PROG);
    member.setLastUpdVersion(1);

    //--  Addition --//
    XSSFCell cell64 = row.getCell(64);
    String bookNo = getStringFormatNoSetError(cell64, "##");

    XSSFCell cell65 = row.getCell(65);
    String receipt = getStringFormatNoSetError(cell65, "##");

    XSSFCell cell66 = row.getCell(66);
    String purPose = getStringCellValueNoSetError(cell66);

    XSSFCell cell61 = row.getCell(61);
    String donateName = getStringCellValueNoSetError(cell61); // 

    String addition = getAddition(bookNo, receipt, dateToshortDate(oldDonateDate), purPose, donateName);
    member.setAddition(addition);

    cacheDao.addEntity(member);
    return member;
}

From source file:Import.ImportDonation.java

private boolean validatAddAddress(XSSFRow row) {
    int start = 48;
    int end = 59;
    for (int i = start; i < end; i++) {
        try {//  ww w .j av a2  s . c  om
            getCellValue(row.getCell(i));
        } catch (NullPointerException e) {
            return false;
        }
    }
    return true;
}

From source file:Import.ImportDonation.java

private ShMemberCard AddMemberCard(XSSFRow row, ShPerson person, ShMember member) {
    ShMemberCard memberCard = new ShMemberCard();
    memberCard.setBusinessUnitId(person.getBusinessUnitId());

    XSSFCell cell67 = row.getCell(67);
    String memberCardNo = getStringCellValueNoSetError(cell67);
    memberCard.setMemberCardNo(memberCardNo);

    memberCard.setMemberId(member);//w w w.  ja v  a  2  s .  c  o m
    memberCard.setIsCancel(STRING_N);
    memberCard.setIsLockUpdate(STRING_N);
    memberCard.setCreateTime(NOW);
    memberCard.setCreateProg(CREATE_PROG);
    memberCard.setCreateUserId(CREATE_USER_ID);
    memberCard.setLastUpdTime(NOW);
    memberCard.setLastUpdUserId(CREATE_USER_ID);
    memberCard.setLastUpdProg(CREATE_PROG);
    memberCard.setLastUpdVersion(1);
    cacheDao.addEntity(memberCard);
    return memberCard;
}

From source file:Import.ImportDonation.java

private void addPersonDoc(XSSFRow row, ShPerson person) {
    XSSFCell cell14 = row.getCell(14);
    String docNo;/*from  w  w  w  .j av a2 s  . c  o  m*/
    try {
        docNo = getStringCellValue(cell14);
    } catch (NullPointerException nullEx) {
        return;
    }
    ShPersonDoc personDoc = new ShPersonDoc();
    personDoc.setBusinessUnitId(person.getBusinessUnitId());
    personDoc.setPersonId(person);
    personDoc.setSeqOrder(1);
    XSSFCell cell12 = row.getCell(12);
    String docName = getStringCellValueNoSetError(cell12);
    try {
        DocType docType = DocType.valueOf(docName);
        personDoc.setDocType(docType.getType());
    } catch (NullPointerException e) {
        personDoc.setDocType(STRING_C);
    }
    XSSFCell cell13 = row.getCell(13);
    String issuer = getStringCellValueNoSetError(cell13);
    personDoc.setIssuer(issuer);
    personDoc.setDocNo(docNo);
    XSSFCell cell15 = row.getCell(15);
    Date expireDate = getDateCellValueIsNotEmptySetError(cell15, 15);
    personDoc.setExpireDate(expireDate);
    personDoc.setIsCancel(STRING_N);
    personDoc.setIsLockUpdate(STRING_N);
    personDoc.setCreateTime(NOW);
    personDoc.setCreateUserId(CREATE_USER_ID);
    personDoc.setCreateProg(CREATE_PROG);
    personDoc.setLastUpdTime(NOW);
    personDoc.setLastUpdUserId(CREATE_USER_ID);
    personDoc.setLastUpdProg(CREATE_PROG);
    personDoc.setLastUpdVersion(1);
    cacheDao.addEntity(personDoc);
}

From source file:Import.ImportDonationtt.java

private ShPerson addPerson(XSSFRow row) {
    ShPerson person = new ShPerson();

    Integer departmentId = getDepartmentId(DEPARTMENT_CODE);
    if (departmentId == null || departmentId == 0) {
        //            setErrorValue(86, DEPARTMENT_CODE);
    }//  www.  jav  a 2  s . c om
    person.setBusinessUnitId(departmentId);

    XSSFCell cell2 = row.getCell(2);
    String titleName = getStringCellValueNoSetError(cell2);// 
    person.setTitleName(titleName);

    person.setPersonType(STRING_P);
    if (!isBlankOrNull(titleName)) {
        ShTitle title = dao.findTitleByTitleName(titleName);
        try {
            person.setTitleId(title.getTitleId());
        } catch (NullPointerException nullEx) {
        }
    }

    XSSFCell cell3 = row.getCell(3);
    String firstNameThai = getStringCellValueSetError(cell3, 3);//  ()
    person.setFirstName(firstNameThai);

    XSSFCell cell4 = row.getCell(4);
    String middleNameThai = getStringCellValueNoSetError(cell4); // ?
    person.setMiddleName(middleNameThai);

    XSSFCell cell5 = row.getCell(5);
    String lastNameThai = getStringCellValueNoSetError(cell5);// ?
    person.setLastName(lastNameThai);

    XSSFCell cell6 = row.getCell(6);
    String firstNameEng = getStringCellValueNoSetError(cell6); //  (?)
    person.setFirstNameEng(firstNameEng);

    XSSFCell cell7 = row.getCell(7);
    String middleNameEng = getStringCellValueNoSetError(cell7); // ? (?)
    person.setMiddleNameEng(middleNameEng);

    XSSFCell cell8 = row.getCell(8);
    String lastNameEng = getStringCellValueNoSetError(cell8); // ? (?)
    person.setLastNameEng(lastNameEng);

    XSSFCell cell9 = row.getCell(9);
    String nickName = getStringCellValueNoSetError(cell9); // 
    person.setNickName(nickName);

    XSSFCell cell10 = row.getCell(10);
    String Phone = getStringCellValueNoSetError(cell10); // 
    person.setPhone(Phone);

    XSSFCell cell11 = row.getCell(11);
    String fax = getStringCellValueNoSetError(cell11); // ??
    person.setFax(fax);

    XSSFCell cell16 = row.getCell(16);
    String sex = getStringCellValueNoSetError(cell16); // 
    try {
        SexType sexType = SexType.valueOf(sex);
        person.setSex(sexType.getDescription());
    } catch (NullPointerException e) {
        person.setSex(STRING_N);
    }

    XSSFCell cell17 = row.getCell(17);
    Date birthDate = getDateCellValueNoSetError(cell17); // ?
    person.setBirthDate(birthDate);

    person.setResidentAddressSource(STRING_N);

    person.setShipAddressSource(STRING_N);
    person.setIsShipRecipientAuto(STRING_N);
    String shipRecipient = getShipRecipient(titleName, firstNameThai, middleNameThai, lastNameThai);
    person.setShipRecipient(shipRecipient);

    XSSFCell cell48 = row.getCell(48);
    String addressName = getStringFormatNoSetError(cell48, "##"); // // @AW

    XSSFCell cell49 = row.getCell(49);
    String addressLocation = getStringFormatNoSetError(cell49, "##"); // / @AX

    XSSFCell cell50 = row.getCell(50);
    String addressNo = getStringFormatNoSetError(cell50, "##"); //  @AY

    XSSFCell cell51 = row.getCell(51);
    String addressMoo = getStringFormatNoSetError(cell51, "##"); //  @AZ

    XSSFCell cell53 = row.getCell(53);
    String addressStreet = getStringCellValueNoSetError(cell53); // 

    XSSFCell cell54 = row.getCell(54);
    String addressSoi = getStringFormatNoSetError(cell54, "##"); // ?/

    String address1 = getShipAddress(addressName, addressLocation, addressNo, addressMoo, addressStreet,
            addressSoi);

    person.setShipAddressLine1(address1);

    XSSFCell cell55 = row.getCell(55);
    String province = getStringCellValueNoSetError(cell55); // 

    XSSFCell cell56 = row.getCell(56);
    String amphoe = getStringCellValueNoSetError(cell56); // 

    XSSFCell cell57 = row.getCell(57);
    String tumbon = getStringCellValueNoSetError(cell57); // 

    String address2 = getShipAddress(tumbon, amphoe, province, null, null, null);
    person.setShipAddressLine2(address2);

    XSSFCell cell58 = row.getCell(58);
    String postCode = getStringFormatNoSetError(cell58, "##"); // 

    XSSFCell cell59 = row.getCell(59);
    String country = getStringCellValueNoSetError(cell59); // 

    String address3 = getShipAddress(postCode, country, null, null, null, null);
    person.setShipAddressLine3(address3);

    person.setIsCancel(STRING_N);
    person.setIsLockUpdate(STRING_N);
    person.setCreateTime(NOW);
    person.setCreateProg(CREATE_PROG);
    person.setCreateUserId(CREATE_USER_ID);

    person.setLastUpdTime(NOW);
    person.setLastUpdProg(CREATE_PROG);
    person.setLastUpdUserId(CREATE_USER_ID);

    person.setLastUpdVersion(1);
    dao.addEntity(person);
    return person;
}

From source file:Import.ImportDonationtt.java

private ShAddress addAddress(XSSFRow row, ShPerson person) {
    if (validatAddAddress(row))
        return null;
    ShAddress address = new ShAddress();

    XSSFCell cell48 = row.getCell(48);
    String addressName1 = getStringFormatNoSetError(cell48, "##"); // // 

    XSSFCell cell49 = row.getCell(49);//from   w  w w  .j a va  2s . c  om
    String addressLocation1 = getStringFormatNoSetError(cell49, "##"); // /

    XSSFCell cell50 = row.getCell(50);
    String addressNo1 = getStringFormatNoSetError(cell50, "##"); // 

    XSSFCell cell51 = row.getCell(51);
    String moo1 = getStringFormatNoSetError(cell51, "##"); // 

    XSSFCell cell53 = row.getCell(53);
    String street1 = getStringFormatNoSetError(cell53, "##"); // 

    XSSFCell cell54 = row.getCell(54);
    String soi1 = getStringFormatNoSetError(cell54, "##"); // /

    XSSFCell cell58 = row.getCell(58);
    String postCode1 = getStringFormatNoSetError(cell58, "##"); // 

    XSSFCell cell60 = row.getCell(60);
    String phone1 = getStringFormatNoSetError(cell60, "##"); // 

    //ADDRESS_ID   ID Running
    //BUSINESS_UNIT_ID   SH_PERSON.BUSINESS_UNIT_ID
    address.setBusinessUnitId(person.getBusinessUnitId());
    //PERSON_ID   SH_PERSON.PERSON_ID
    address.setPersonId(person.getPersonId());
    //ADDRESS_TYPE   R
    address.setAddressType(STRING_R);
    //ADDRESS_NAME   @AW
    address.setAddressName(addressName1);
    //ADDRESS_LOCATION   @AX
    address.setAddressLocation(addressLocation1);
    //ADDRESS_NO   @AY
    address.setAddressNo(addressNo1);
    //ADDRESS_MOO   @AZ
    address.setAddressMoo(moo1);
    //ADDRESS_AREA_ID   "? V_SH_REGION.REGION_ID
    //V_SH_REGION.FULL_NAME =@BF||' '||@BE||' '||@BD"

    XSSFCell cell55 = row.getCell(55);
    String province = getStringCellValueNoSetError(cell55); // 

    XSSFCell cell56 = row.getCell(56);
    String amphoe = getStringCellValueNoSetError(cell56); // 

    XSSFCell cell57 = row.getCell(57);
    String tumbon = getStringCellValueNoSetError(cell57); // 

    String regionFullName = getShipAddress(tumbon, amphoe, province, null, null, null);

    if (!isBlankOrNull(regionFullName)) {
        VShRegion region = dao.findRegionByFullName(regionFullName);
        try {
            address.setAddressAreaId(region.getRegionId());
        } catch (NullPointerException nullEx) {
            validationWarn.append(" [ ").append(mapStringValidation.get(575655))
                    .append(regionFullName).append(" ?").append(" ] ");
        }
    }
    //ADDRESS_AREA_NAME   @BF||' '||@BE||' '||@BD
    address.setAddressAreaName(regionFullName);
    //ADDRESS_STREET   @BB
    address.setAddressStreet(street1);
    //ADDRESS_SOI   @BC
    address.setAddressSoi(soi1);
    //ADDRESS_POSTAL   @BG
    address.setAddressPostal(postCode1);
    //ADDRESS_PHONE   @BI
    address.setAddressPhone(phone1);
    //IS_CANCEL   N
    address.setIsCancel(STRING_N);
    //IS_LOCK_UPDATE   N
    address.setIsLockUpdate(STRING_N);
    //CREATE_TIME    Convert
    address.setCreateTime(NOW);
    //CREATE_USER_ID   CONVERT
    address.setCreateUserId(CREATE_USER_ID);
    //CREATE_PROG    Excel 
    address.setCreateProg(CREATE_PROG);

    address.setLastUpdTime(NOW);
    address.setLastUpdUserId(CREATE_USER_ID);
    address.setLastUpdProg(CREATE_PROG);
    address.setLastUpdVersion(1);

    dao.addEntity(address);
    return address;
}

From source file:Import.ImportDonationtt.java

private AcDonateMember AddDoanteMember(XSSFRow row, ShPerson person) {
    AcDonateMember donateMember = new AcDonateMember();

    donateMember.setBusinessUnitId(person.getBusinessUnitId());

    donateMember.setDepartmentId(person.getBusinessUnitId());

    XSSFCell cell63 = row.getCell(63);
    Date oldDonateDate = getDateCellValueNoSetError(cell63);
    String budgetYear = dateToBudgetYear(oldDonateDate);
    try {/*from  ww w  . j  a  v  a 2s  . c  om*/
        subBudgetYear = budgetYear.substring(2);
    } catch (NullPointerException nullEx) {
        validationError.append("  ").append(" [")
                .append(budgetYear).append(" ] ");
    }

    donateMember.setBudgetYear(budgetYear);

    //        XSSFCell cell68 = row.getCell(68);
    //        Date actorData = getDateCellValueNoSetError(cell68);
    donateMember.setActorDate(oldDonateDate);

    donateMember.setPersonId(person.getPersonId());

    XSSFCell cell66 = row.getCell(66);
    String purPose = getStringCellValueNoSetError(cell66);
    try {
        donateMember.setPurpose(purPose.substring(0, 999));
    } catch (Exception e) {
        donateMember.setPurpose(purPose);
    }
    donateMember.setReceiveType(mode);

    XSSFCell cell62 = row.getCell(62);
    BigDecimal oldAmount = getBigDecimalCellValueNoSetError(cell62);
    donateMember.setOldAmount(oldAmount);

    // 
    switch (mode) {
    case STRING_C: {
        XSSFCell cell69 = row.getCell(69);
        String bankName = getStringCellValueSetError(cell69, 69);
        if (!isBlankOrNull(bankName)) {
            ShBank bank = dao.findShBankByBankName(bankName);
            try {
                donateMember.setCreditCardOwner(bank.getBankId());
            } catch (NullPointerException nullEx) {
            }
        }

        XSSFCell cell70 = row.getCell(70);
        String creditCardType = getStringCellValueSetError(cell70, 70);
        if (!isBlankOrNull(creditCardType)) {
            AcCreditCardType CreditCardType = dao.findAcCreditCardTypeByName(creditCardType);
            try {
                donateMember.setCreditCardType(CreditCardType.getCreditCardTypeId());
            } catch (NullPointerException nullEx) {
            }
        }

        XSSFCell cell71 = row.getCell(71);
        String creditCardNo = getStringCellValueSetError(cell71, 71);
        donateMember.setCreditCardNo(creditCardNo);

        XSSFCell cell72 = row.getCell(72);
        String creditCardName = getStringCellValueNoSetError(cell72);
        donateMember.setCreditCardName(creditCardName);
        XSSFCell cell73 = row.getCell(73);
        String creditCardExpYear = getStringCellValueNoSetError(cell73);
        donateMember.setCreditCardExpYear(creditCardExpYear);
        XSSFCell cell74 = row.getCell(74);
        String creditCardExpMonth = getStringCellValueNoSetError(cell74);
        donateMember.setCreditCardExpMonth(creditCardExpMonth);
        XSSFCell cell79 = row.getCell(79);
        BigDecimal amount = getBigDecimalCellValueSetError(cell79, 79);
        donateMember.setAmount(amount);

        XSSFCell cell80 = row.getCell(80);
        Integer offDate = getIntegerCellValueSetError(cell80, 80);
        donateMember.setOffDate(offDate);
        break;
    }
    case STRING_B: {
        XSSFCell cell75 = row.getCell(75);
        String bankName = getStringCellValueSetError(cell75, 75);
        Integer bankId = null;
        if (!isBlankOrNull(bankName)) {
            ShBank bankDao = dao.findShBankByBankName(bankName);
            try {
                bankId = bankDao.getBankId();
                donateMember.setBankId(bankId);
            } catch (NullPointerException nullEx) {
                validationError.append(" [ ").append(mapStringValidation.get(75))
                        .append(bankName).append(" ?").append(" ] ");
            }
        }
        XSSFCell cell76 = row.getCell(76);
        String bankBranchName = getStringCellValueNoSetError(cell76);
        if (!isBlankOrNull(bankBranchName)) {
            ShBankBranch bankBranch = dao.findShBankBranchByBankBranchNameAndBankId(bankBranchName, bankId);
            try {
                donateMember.setBankBranchId(bankBranch.getBankBranchId());
            } catch (NullPointerException nullEx) {
            }
        }

        XSSFCell cell77 = row.getCell(77);
        String bankAccount = getStringCellValueSetError(cell77, 77);
        donateMember.setBankAccount(bankAccount);
        XSSFCell cell78 = row.getCell(78);
        String bankAccountName = getStringCellValueSetError(cell78, 78);
        donateMember.setBankAccountName(bankAccountName);
        XSSFCell cell79 = row.getCell(79);
        BigDecimal amount = getBigDecimalCellValueSetError(cell79, 79);
        donateMember.setAmount(amount);

        XSSFCell cell80 = row.getCell(80);
        Integer offDate = getIntegerCellValueSetError(cell80, 80);
        donateMember.setOffDate(offDate);
        break;
    }
    case STRING_D: {
        donateMember.setAmount(oldAmount);
        break;
    }
    }

    donateMember.setOldDonateDate(oldDonateDate);
    donateMember.setIsCancel(STRING_N);
    donateMember.setIsLockUpdate(STRING_N);
    XSSFCell cell64 = row.getCell(64);
    String bookNo = getStringFormatNoSetError(cell64, "##");

    XSSFCell cell65 = row.getCell(65);
    String receipt = getStringFormatNoSetError(cell65, "##");

    //        XSSFCell cell66 = row.getCell(66);
    //        String objective = getStringCellValueNoSetError(cell66); // 
    XSSFCell cell61 = row.getCell(61);
    String donateName = getStringCellValueNoSetError(cell61); // 

    String addition = getAddition(bookNo, receipt, dateToshortDate(oldDonateDate), purPose, donateName);
    donateMember.setAddition(addition);

    donateMember.setCreateTime(NOW);
    donateMember.setCreateUserId(CREATE_USER_ID);
    donateMember.setCreateProg(CREATE_PROG);

    donateMember.setLastUpdTime(NOW);
    donateMember.setLastUpdUserId(CREATE_USER_ID);
    donateMember.setLastUpdProg(CREATE_PROG);
    donateMember.setLastUpdVersion(1);

    //DONATE_MEMBER_NO   Gen ????
    try {
        String donateMemberNo = getFormDonatorNo(person.getBusinessUnitId(), budgetYear.substring(2));
        donateMember.setDonateMemberNo(donateMemberNo);
    } catch (NullPointerException e) {
        validationError.append(" [Gen DonateMemberNo ] ");
    }
    dao.addEntity(donateMember);
    return donateMember;
}

From source file:Import.ImportDonationtt.java

private AcDonateMemberAccount AddDoanteMemberAccount(XSSFRow row, ShPerson person,
        AcDonateMember donateMember) {/*from  ww w  .j  a v  a 2  s .  c o  m*/
    AcDonateMemberAccount donateMemberAccount = new AcDonateMemberAccount();
    //        
    donateMemberAccount.setBusinessUnitId(person.getBusinessUnitId());
    donateMemberAccount.setDonateMemberId(donateMember.getDonateMemberId());
    XSSFCell cell81 = row.getCell(81);
    String accountFullCode = getStringCellValueSetError(cell81, 81);
    Integer accountId = getAccountId(accountFullCode);
    donateMemberAccount.setAccountId(accountId);
    XSSFCell cell82 = row.getCell(82);
    String departmentFullCode = getStringCellValueSetError(cell82, 82);
    Integer departmentId = getDepartmentId(departmentFullCode);
    donateMemberAccount.setDepartmentId(departmentId);
    XSSFCell cell83 = row.getCell(83);
    String planFullCode = getStringCellValueSetError(cell83, 83);
    Integer planId = getPlanId(planFullCode);
    donateMemberAccount.setPlanId(planId);
    XSSFCell cell84 = row.getCell(84);
    String sourceFullCode = getStringCellValueSetError(cell84, 84);
    Integer sourceId = getSourceId(sourceFullCode);
    donateMemberAccount.setSourceId(sourceId);
    XSSFCell cell85 = row.getCell(85);
    String subAccountFullCode = getStringCellValueNoSetError(cell85);
    Integer subAccountId = getSubAccountId(subAccountFullCode, departmentId, sourceId);
    donateMemberAccount.setSubAccountId(subAccountId);
    donateMemberAccount.setIsCancel(STRING_N);
    donateMemberAccount.setIsLockUpdate(STRING_N);
    donateMemberAccount.setCreateTime(NOW);
    donateMemberAccount.setCreateTime(NOW);
    donateMemberAccount.setCreateProg(CREATE_PROG);
    donateMemberAccount.setCreateUserId(CREATE_USER_ID);
    donateMemberAccount.setLastUpdTime(NOW);
    donateMemberAccount.setLastUpdUserId(CREATE_USER_ID);
    donateMemberAccount.setLastUpdProg(CREATE_PROG);
    donateMemberAccount.setLastUpdVersion(1);
    dao.addEntity(donateMemberAccount);
    return donateMemberAccount;
}

From source file:Import.ImportDonationtt.java

private ShMember AddMember(XSSFRow row, ShPerson person) {
    ShMember member = new ShMember();
    member.setBusinessUnitId(person.getBusinessUnitId());
    member.setPersonId(person.getPersonId());
    XSSFCell cell63 = row.getCell(63);
    Date oldDonateDate = getDateCellValueNoSetError(cell63);
    String budgetYear = dateToBudgetYear(oldDonateDate);

    try {/*from w  w w .  j  av  a2 s  .  c  om*/
        subBudgetYear = budgetYear.substring(2);
    } catch (NullPointerException nullEx) {
        validationError.append("  ").append(" [")
                .append(budgetYear).append(" ] ");
    }

    try {
        String memberNo = getFormMemberNo(person.getBusinessUnitId(), subBudgetYear);
        member.setMemberNo(memberNo);
    } catch (NullPointerException e) {
        validationError.append(" [Gen MemberNo ] ");
    }
    XSSFCell cell1 = row.getCell(1);
    String memberTypeName = getStringCellValueNoSetError(cell1);
    ShMemberType findShMemberTypeByName = dao.findShMemberTypeByName(memberTypeName);
    member.setMemberTypeId(findShMemberTypeByName);
    member.setMemberRequestId(null);

    member.setMemberSource(STRING_A);
    member.setDonatorId(null);
    member.setDonatorRelate(null);
    XSSFCell cell68 = row.getCell(68);
    Date actorData = getDateCellValueSetError(cell68, 68);
    member.setRegisterDate(actorData);
    member.setMemberRequestRelationId(null);
    member.setDepartmentId(person.getBusinessUnitId());
    member.setOldRegisterDate(actorData);
    member.setOldTotalAmount(BigDecimal.ZERO);
    member.setOldPaidAmount(BigDecimal.ZERO);
    member.setOldPaidDate(null);
    member.setOldPaidYear(null);
    member.setOldPaidTerm(null);
    XSSFCell cell67 = row.getCell(67);
    String pruPose = getStringCellValueNoSetError(cell67);
    member.setOldMemberNo(pruPose);
    XSSFCell cell62 = row.getCell(62);
    BigDecimal amount = getBigDecimalCellValueSetError(cell62, 62);
    member.setAmount(amount);
    member.setIsCancel(STRING_N);
    member.setIsLockUpdate(STRING_N);
    member.setCreateTime(NOW);
    member.setCreateProg(CREATE_PROG);
    member.setCreateUserId(CREATE_USER_ID);
    member.setLastUpdTime(NOW);
    member.setLastUpdUserId(CREATE_USER_ID);
    member.setLastUpdProg(CREATE_PROG);
    member.setLastUpdVersion(1);
    dao.addEntity(member);
    return member;
}