/** * 受注伝票を更新します. * * @param dto 受注伝票DTO * @return ロック結果 * @throws UnabledLockException * @throws ServiceException */ @Override protected int updateRecord(ROrderSlipDto dto) throws UnabledLockException, ServiceException { RoSlipTrn entity = Beans.createAndCopy(RoSlipTrn.class, dto) .dateConverter(Constants.FORMAT.DATE, "roDate", "validDate") .dateConverter(Constants.FORMAT.DATE, "shipDate", "validDate") .dateConverter(Constants.FORMAT.DATE, "deliveryDate", "validDate") .dateConverter(Constants.FORMAT.TIMESTAMP, "updDatetm") .execute(); if (dto.cutoffGroupCategory != null && dto.cutoffGroupCategory.length() == 3) { entity.cutoffGroup = dto.cutoffGroupCategory.substring(0, 2); entity.paybackCycleCategory = dto.cutoffGroupCategory.substring(2, 3); } int lockResult = this.lockRecord( RoSlipService.Param.RO_SLIP_ID, entity.roSlipId.toString(), entity.updDatetm, "rorder/LockSlip.sql"); Map<String, Object> param = setEntityToParam(entity); this.updateBySqlFile("rorder/UpdateSlip.sql", param).execute(); return lockResult; }
/** * 受注伝票を登録します. * * @param dto 受注伝票DTO * @return 登録件数 * @throws ServiceException */ @Override protected int insertRecord(ROrderSlipDto dto) throws ServiceException { dto.roSlipId = Long.toString(seqMakerService.nextval(RoSlipService.Table.RO_SLIP_TRN)); NumberConverter convUP = createUnitPriceConverter(dto.priceFractCategory); NumberConverter convTax = createUnitPriceConverter(dto.taxFractCategory); RoSlipTrn entity = Beans.createAndCopy(RoSlipTrn.class, dto) .converter(convUP, "retailPriceTotal", "priceTotal", "costTotal") .converter(convTax, "ctaxPriceTotal") .dateConverter(Constants.FORMAT.DATE, "roDate", "validDate") .dateConverter(Constants.FORMAT.DATE, "shipDate", "validDate") .dateConverter(Constants.FORMAT.DATE, "deliveryDate", "validDate") .execute(); if (dto.cutoffGroupCategory != null && dto.cutoffGroupCategory.length() == 3) { entity.cutoffGroup = dto.cutoffGroupCategory.substring(0, 2); entity.paybackCycleCategory = dto.cutoffGroupCategory.substring(2, 3); } Map<String, Object> param = setEntityToParam(entity); return this.updateBySqlFile("rorder/InsertRoSlip.sql", param).execute(); }