//       2011.05.30 아래 항목에 대하여 (round,0)을 (round,9) 로 처리함
//       순보해약차기준일시상각금액, 당월한도반영최종미상각금액, 당월한도미반영최종미상각금액
//                            당월한도반영최종미상각금액, 당월한도미반영최종미상각금액

      /*------------------------------------------------------------------------------------------------------
      *  1.최종미상각액, 순보해약차기준일시상각액 재계산
      * -----------------------------------------------------------------------------------------------------
      * sum(당월한도미반영최종미상각금액 ) > sum(당월순보해약차 인 경우만 재계산 한다.
      *  증번별 당월한도반영최종미상각금액 = 당월한도반영최종미상각금액 + 당월한도미반영최종미상각금액 - (sum(당월한도미반영최종미상각금액 )-sum(당월순보해약차)) * 증번별 당월한도미반영최종미상각금액 /sum(당월한도미반영최종미상각금액 )
      *    순보해약차기준일시상각금액 = (sum(당월한도미반영최종미상각금액 )-sum(당월순보해약차)) * 증번별 당월한도미반영최종미상각금액 /sum(당월한도미반영최종미상각금액 )
      *    당월한도반영최종상각금액 += (sum(당월한도미반영최종미상각금액 )-sum(당월순보해약차)) * 증번별 당월한도미반영최종미상각금액 /sum(당월한도미반영최종미상각금액 )
      *  증번별 당월한도반영최종미상각금액 = 당월한도미반영최종미상각금액 - 당월한도반영최종상각금액
      */
       //순보해약차기준일시상각금액 = (총당월한도미반영최종미상각금액 - 총당월순보해약차) * 증번별 당월한도미반영최종미상각금액 / 총당월한도미반영최종미상각금액
      double nNprmCnclbDiamtStndDthmsDprAmt = (rs.getDouble("nTnCurmmLmitNrflFinalNrpymAmt1") - rs.getDouble("nTnEndtNprmCnclbDiamt"))
                         *   rs.getDouble("nCurmmLmitNrflFinalNrpymAmt")
                         /  rs.getDouble("nTnCurmmLmitNrflFinalNrpymAmt2");

      nNprmCnclbDiamtStndDthmsDprAmt = LtiUtils.round(nNprmCnclbDiamtStndDthmsDprAmt,9); //반올림 처리
      //당월한도반영최종상각금액 =  당월한도반영최종상각금액 + 순보해약차기준일시상각금액
      double nCurmmLmitRfltFinalDprAmt = rs.getDouble("nCurmmLmitRfltFinalDprAmt") + nNprmCnclbDiamtStndDthmsDprAmt;
      nCurmmLmitRfltFinalDprAmt = LtiUtils.round(nCurmmLmitRfltFinalDprAmt,9); //반올림 처리
       //당월한도반영최종미상각금액 = 당월한도미반영최종미상각금액 - 당월한도반영최종상각금액
      double nCurmmLmitRfltFinalNrpymAmt  = rs.getDouble("nCurmmLmitNrflFinalNrpymAmt1") - nCurmmLmitRfltFinalDprAmt;
      nCurmmLmitRfltFinalNrpymAmt = LtiUtils.round(nCurmmLmitRfltFinalNrpymAmt,9); //반올림 처리
      XMLUtil.setDouble(doc,    "nCurmmLmitRfltFinalNrpymAmt"     ,  nCurmmLmitRfltFinalNrpymAmt);  //당월한도반영최종미상각금액
      XMLUtil.setDouble(doc,    "nNprmCnclbDiamtStndDthmsDprAmt"     ,  nNprmCnclbDiamtStndDthmsDprAmt);  //순보해약차기준일시상각금액
      XMLUtil.setDouble(doc,    "nCurmmLmitRfltFinalDprAmt"     ,  nCurmmLmitRfltFinalDprAmt);  //당월한도반영최종상각금액

      if (XMLUtil.getString(doc, "sTestFlag").equals("T")) { //TEST일때만 LOG
//       Logger.info("KCL010Batch", "recalcuPaccNwcrCrfwDprReslt", "순보해약차기준일시상각금액==  " +  XMLUtil.getDouble(doc, "nNprmCnclbDiamtStndDthmsDprAmt"));
//       Logger.info("KCL010Batch", "recalcuPaccNwcrCrfwDprReslt", "       총당월한도미반영최종미상각금액==  " +  rs.getDouble("nTnCurmmLmitNrflFinalNrpymAmt"));
//       Logger.info("KCL010Batch", "recalcuPaccNwcrCrfwDprReslt", "       총당월순보해약차==  " +  rs.getDouble("nTnEndtNprmCnclbDiamt"));
//       Logger.info("KCL010Batch", "recalcuPaccNwcrCrfwDprReslt", "       증번별 당월한도미반영최종미상각금액==  " +  rs.getDouble("nCurmmLmitNrflFinalNrpymAmt"));
//       Logger.info("KCL010Batch", "recalcuPaccNwcrCrfwDprReslt", "당월한도반영최종상각금액==  " +  XMLUtil.getDouble(doc, "nCurmmLmitRfltFinalDprAmt"));
//       Logger.info("KCL010Batch", "recalcuPaccNwcrCrfwDprReslt", "       당월한도반영최종상각금액==  " +  rs.getDouble("nCurmmLmitRfltFinalDprAmt"));
//       Logger.info("KCL010Batch", "recalcuPaccNwcrCrfwDprReslt", "       순보해약차기준일시상각금액==  " +  nNprmCnclbDiamtStndDthmsDprAmt);
//       Logger.info("KCL010Batch", "recalcuPaccNwcrCrfwDprReslt", "당월한도반영최종미상각금액==  " +  XMLUtil.getDouble(doc, "nCurmmLmitRfltFinalNrpymAmt"));
//       Logger.info("KCL010Batch", "recalcuPaccNwcrCrfwDprReslt", "       당월한도미반영최종미상각금액==  " +  rs.getDouble("nCurmmLmitNrflFinalNrpymAmt"));
//       Logger.info("KCL010Batch", "recalcuPaccNwcrCrfwDprReslt", "       당월한도반영최종상각금액==  " +  nCurmmLmitRfltFinalDprAmt);
      } else {
       //계리평균책임준비금결과테이블 LIST MOVE
       update( doc, conn );
       nUpdateCt++;
                conn.commit();
      }
    }

    Logger.info("KCL010Batch", "recalcuPaccNwcrCrfwDprReslt", "===============================================");
     Logger.info("KCL010Batch", "recalcuPaccNwcrCrfwDprReslt", "=KCL010Batch (재처리 결과)              ");
     Logger.info("KCL010Batch", "recalcuPaccNwcrCrfwDprReslt", "===============================================");
    Logger.info("KCL010Batch", "recalcuPaccNwcrCrfwDprReslt", "=Input Count = " + nInputCt);
    Logger.info("KCL010Batch", "recalcuPaccNwcrCrfwDprReslt", "=Update Count = " + nUpdateCt);
    Logger.info("KCL010Batch", "recalcuPaccNwcrCrfwDprReslt", "===============================================");
    Logger.info("KCL010Batch", "recalcuPaccNwcrCrfwDprReslt", "[작업종료]");

         XMLUtil.setResultStatus(doc,TMSConstants.TMS_SUCCESSFUL);

    } catch(Exception e){
        XMLUtil.setResultStatus(doc,TMSConstants.TMS_FAIL);
        throw e;
    } finally {
         try{rs.close();}catch(Exception e){}
      try{pstmt1.close();}catch(Exception e){}
    }
    return doc;
 }

KDL080Batch

            query.append("b.sResvAmtKey         sResvAmtKey,  \n");  //준비금키
            query.append("b.sPremCalcFomlFlag   sPremCalcFomlFlag,  \n");  //보험료산출식구분
            query.append("b.nInsArea         nInsArea  \n");  //가입면적
            query.append("from longterm..LTIKD07 a, longterm..LTIKD01 b    \n");                                        
            query.append("where a.sCloseYm = ?     \n");          
            query.append("and  a.sCloseYm = b.sCloseYm       \n");          
            if (! XMLUtil.getString(doc, "sCrNo").equals("")) {
    query.append("and a.sCrNo = '" + XMLUtil.getString(doc, "sCrNo")+"'   \n"); //계약번호  (건별 테스트시 사용) 
   }
            query.append("and  a.sCrNo = b.sCrNo      \n");       
            query.append("and  a.sTrtyCd = b.sTrtyCd      \n");          
            query.append("and  a.nPsnPrprtGroupSeqno = b.nPsnPrprtGroupSeqno    \n");                              
            query.append("and  a.sPsnPrprtGroupFlgcd = b.sPsnPrprtGroupFlgcd    \n");                              
//   query.append("and  substring(a.sCrNo,1,1) ='L'       \n");  //임시
            query.append("order by b.sCloseYm, b.sCrNo, b.sTrtyCd      \n"); 
   
            //Logger.info("query=======LDH=======> " + query.toString());
           
      pstmt1 = dbconn.prepareStatement(query.toString()); 
   pstmt1.setString(1, sCloseYm);
   rs = pstmt1.executeQuery();

   if (! XMLUtil.getString(doc, "sCrNo").equals("")) {
    XMLUtil.setString(doc, "sTestFlag" ,     "T"); //테스트구분 SET (계약번호를 입력하면 테스트로 간주)
   }

        Document result = null;
   Document tmpDoc = null;
   Document stndRsfnDoc1 = null; // 기준준비금 화배책 계산 금액
   
   while ( rs.next() ) {
    tmpDoc = XMLUtil.getDocument("<KDL080/>");
    //재물에서 없는 경우가 있음(목적물만 있는 경우)
    if(rs.getString("sDrveFlagCd")==null || rs.getString("sDrveFlagCd").trim().equals("")){
     sDrveFlagCd = "1";
    }else{
     sDrveFlagCd = rs.getString("sDrveFlagCd");
    }

    XMLUtil.setInt   (tmpDoc,    "nAnntPymCt"     ,  rs.getInt   ("nAnntPymCt"));  //연금지급횟수
    XMLUtil.setString(tmpDoc,    "sCrtorRelnCd"     ,  rs.getString("sCrtorRelnCd"));  //계약자관계코드
    XMLUtil.setString(tmpDoc,    "sCrtorCd"     ,  rs.getString("sCrtorCd"));  //계약자코드
    XMLUtil.setInt   (tmpDoc,    "nCrtorAge"     ,  rs.getInt   ("nCrtorAge"));  //계약자연령
    XMLUtil.setString(tmpDoc,    "sCrtorSexFlag"     ,  rs.getString("sCrtorSexFlag"));  //계약자성별코드
    XMLUtil.setString(tmpDoc,    "sCrtorAddrKindCd"     ,  rs.getString("sCrtorAddrKindCd"));  //계약자주소구분코드
    XMLUtil.setString(tmpDoc,    "sInrpsFlagCd"     ,  rs.getString("sInrpsFlagCd"));  //피보험자구분코드
    XMLUtil.setString(tmpDoc,    "sInrpsCd"     ,  rs.getString("sInrpsCd"));  //피보험자코드
    XMLUtil.setInt   (tmpDoc,    "nInrpsAge"     ,  rs.getInt   ("nInrpsAge"));  //피보험자연령
    XMLUtil.setString(tmpDoc,    "sInrpsSexFlag"     ,  rs.getString("sInrpsSexFlag"));  //피보험자성별코드
    XMLUtil.setString(tmpDoc,    "sInrpsAddrKindCd"     ,  rs.getString("sInrpsAddrKindCd"));  //피보험자주소구분코드
    XMLUtil.setInt   (tmpDoc,    "nInrpsPsct"     ,  rs.getInt   ("nInrpsPsct"));  //피보험자인원수
    XMLUtil.setString(tmpDoc,    "sInrpsStatCd"     ,  rs.getString("sInrpsStatCd"));  //피보험자상태코드
    XMLUtil.setInt   (tmpDoc,    "nObjtNum"     ,  rs.getInt   ("nObjtNum"));  //물건수
    XMLUtil.setString(tmpDoc,    "sDgnsObjtYn"     ,  rs.getString("sDgnsObjtYn"));  //진단대상여부
    XMLUtil.setDouble(tmpDoc,    "nPrrmRato"     ,  rs.getDouble("nPrrmRato"));  //예정이율
    XMLUtil.setString(tmpDoc,    "sGdFlag"     ,  rs.getString("sGdFlag"));  //상품구분
    XMLUtil.setString(tmpDoc,    "sCvrgeFlag"     ,  rs.getString("sCvrgeFlag"));  //연령별담보
    XMLUtil.setString(tmpDoc,    "sPpayCalcCd"     ,  rs.getString("sPpayCalcCd"));  //선납산출코드
    XMLUtil.setInt   (tmpDoc,    "nElapsYct"     ,  rs.getInt   ("nElapsYct"));  //경과년수
    XMLUtil.setInt   (tmpDoc,    "nElapsMct"     ,  rs.getInt   ("nElapsMct"));  //경과월수
    XMLUtil.setInt   (tmpDoc,    "nElapsDays"     ,  rs.getInt   ("nElapsDays"));  //경과일수
    XMLUtil.setInt   (tmpDoc,    "nNelpMnth"     ,  rs.getInt   ("nNelpMnth"));  //미경과월수
    XMLUtil.setString(tmpDoc,    "sResvAmtKey"     ,  rs.getString   ("sResvAmtKey"));  //준비금키
    XMLUtil.setString(tmpDoc,    "sPremCalcFomlFlag"     ,  rs.getString   ("sPremCalcFomlFlag"));  //보험료산출식구분
    XMLUtil.setString(tmpDoc,    "nInsArea"     ,  rs.getString   ("nInsArea"));  //가입면적
            
    XMLUtil.setString(tmpDoc,    "sTestFlag"     ,  XMLUtil.getString(doc, "sTestFlag"));  //테스트여부

    nInputCnt++;

    if (XMLUtil.getString(tmpDoc, "sTestFlag").equals("T")) { //TEST일때만 LOG
        Logger.info("KDL080Batch", "calculateReserveFund       ", "@@@ :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::");
     Logger.info("KDL080Batch", "calculateReserveFund       ", "@@@  LTIKD07  계약번호 ==  " +  XMLUtil.getString(tmpDoc,  "sCrNo") + " 특약코드 = " + XMLUtil.getString(tmpDoc,  "sTrtyCd"));
     Logger.info("KDL080Batch", "calculateReserveFund       ", "param all ==" + XMLUtil.indent(tmpDoc));
    }

      /* ------------------------------------------------------------------------------------------------------
      *  4.준비금테이블정보 가져오기 aa
      * -----------------------------------------------------------------------------------------------------
      * 해당 계약건의 준비금테이블정보를 가져 온다.
      */
      //준비금테이블 읽기 서비스 호출(com.inswave.longterm.act.bat.KXL150Batch)
         KXL150Batch aa= new KXL150Batch();
         result = aa.doTask( tmpDoc );
         
         //YTD 계산
         int    nLeapYearDays = LtiDateUtil.getLeapYearDays(LtiDateUtil.getEndDate(rs.getString("sInsurStrtDate"), rs.getInt("nElapsYct"), 0, 0));
             
         //보장형적립금 계산
         double  nCalcNetpPremAcat = 0.0;  //산출식적립금액
         double  nStndNetpPremAcat = 0.0;  //표준식적립금액
      // 화배책에 해당하는 특약에 대해서 미경과보험료  재계산(sPremCalcFomlFlag = '01' 화배책, nInsArea 계산시 면적)
      if("01".equals(XMLUtil.getString(tmpDoc,"sPremCalcFomlFlag"))&& !"".equals(XMLUtil.getString(tmpDoc,"nInsArea")) ){
       stndRsfnDoc1 = aa.getRsfnCalcEtc(tmpDoc, dbconn);
       //Logger.info("stndRsfnDoc1--ldh " + XMLUtil.indent(stndRsfnDoc1));
       
       XMLUtil.setDouble(tmpDoc, "nYstrStndResv", XMLUtil.getDouble(stndRsfnDoc1, "nCalcYstrStndResv"));    // 산출연시기준준비금
       XMLUtil.setDouble(tmpDoc, "nYendStndResv", XMLUtil.getDouble(stndRsfnDoc1, "nCalcYendStndResv"));    // 산출연말기준준비금
       XMLUtil.setDouble(tmpDoc, "nStndNetPrem", XMLUtil.getDouble(stndRsfnDoc1, "nCalcStndNetPrem"));     // 산출준비금 년납순보험료
       XMLUtil.setDouble(tmpDoc, "nRsfnTotPrrmNwcr", XMLUtil.getDouble(stndRsfnDoc1, "nCalcRsfnTotPrrmNwcr"));    // 총신계약비
       XMLUtil.setDouble(tmpDoc, "nYstrStndResvCncl", XMLUtil.getDouble(stndRsfnDoc1, "nCalcYstrStndResvCncl"));      // 산출연시기준준비금_표준해약식
       XMLUtil.setDouble(tmpDoc, "nYendStndResvCncl", XMLUtil.getDouble(stndRsfnDoc1, "nCalcYendStndResvCncl"));     // 산출연말기준준비금_표준해약식
       XMLUtil.setDouble(tmpDoc, "nTotNwcrRateStnd", XMLUtil.getDouble(stndRsfnDoc1, "nCalcTotNwcrRateStnd"));    // 총신계약비_표준해약식
       XMLUtil.setDouble(tmpDoc, "nYstrStndResvStndFm", XMLUtil.getDouble(stndRsfnDoc1, "nCalcYstrStndResvStndFm"));     //산출연시기준준비금표준식
       XMLUtil.setDouble(tmpDoc, "nYendStndResvStndFm", XMLUtil.getDouble(stndRsfnDoc1, "nCalcYendStndResvStndFm"));     //산출연말기준준비금표준식
       XMLUtil.setDouble(tmpDoc, "nRsfnTotPrrmNwcrStndCncl", XMLUtil.getDouble(stndRsfnDoc1, "nCalcRsfnTotPrrmNwcrStndCncl"));  //산출준비금총예정신계약비표준해약식
       XMLUtil.setDouble(tmpDoc, "nNetPrem", XMLUtil.getDouble(stndRsfnDoc1, "nCalcNetPrem"));  //산출준비금총예정신계약비표준해약식
       
       /*nCalcYstrStndResv = XMLUtil.getDouble(stndRsfnDoc1, "nCalcYstrStndResv");     // 산출연시기준준비금
       nCalcYendStndResv = XMLUtil.getDouble(stndRsfnDoc1, "nCalcYendStndResv");   //  산출연말기준준비금
       nCalcStndNetPrem = XMLUtil.getDouble(stndRsfnDoc1, "nCalcStndNetPrem");     //  산출순보험료
       nCalcYstrStndResvCncl = XMLUtil.getDouble(stndRsfnDoc1, "nCalcYstrStndResvCncl");  //  산출연시기준준비금_표준해약식
       nCalcYendStndResvCncl = XMLUtil.getDouble(stndRsfnDoc1, "nCalcYendStndResvCncl"); //  산출연말기준준비금_표준해약식
       nCalcTotNwcrRateStnd = XMLUtil.getDouble(stndRsfnDoc1, "nCalcTotNwcrRateStnd");  //  산출총신계약비_표준해약식
       */      
      }