Example #1
0
 /**
  * 资金计划保存到临时表中
  *
  * @param cb
  * @param fp
  * @return
  */
 public boolean addFundFundCharge(
     String docId, List<FundPlanBean> fp, String markId, String markValue) throws Exception {
   // 为了不改变整个测算的 代码,资金计划临时性的插入到一张中间表当中,方便拼现金流
   for (FundPlanBean fund : fp) {
     Conn conn = new Conn();
     StringBuffer sb = new StringBuffer();
     sb.append(" INSERT INTO FUND_FUND_PLAN_TEMP")
         .append("(ID,doc_id")
         .append(",FEE_TYPE,")
         .append("PLAN_DATE,PLAN_MONEY,PAY_OBJ,")
         .append("SETTLE_METHOD,PAY_TYPE ," + markId)
         .append(") VALUES(")
         . // sys_guid()  '" + UUIDUtil.getUUID() + "'
         append(" '" + UUIDUtil.getUUID() + "','" + docId)
         .append("','" + fund.getFeeType())
         .append("','" + fund.getPlanDate())
         .append("','" + fund.getPlanMoney())
         .append("','" + fund.getPayObj())
         .append("','" + fund.getSettleMethod())
         .append("','" + fund.getPayType())
         .append("','" + markValue)
         .append("')");
     String replaceStr = sb.toString().replace("'null'", "null");
     sb = sb.replace(0, sb.length(), replaceStr);
     logger.info(sb.toString());
     conn.executeUpdate(sb.toString());
   }
   return true;
 }
Example #2
0
 /**
  * 资金计划保存到临时表中
  *
  * @param cb
  * @param fp
  * @return
  */
 public boolean addFundFundCharge(ConditionBean cb, List<FundPlanBean> fp, TabCalBean tcb)
     throws Exception {
   // 为了不改变整个测算的 代码,资金计划临时性的插入到一张中间表当中,方便拼现金流
   FundPlanBean fundAbstract = null;
   for (FundPlanBean fund : fp) {
     Conn conn = new Conn();
     StringBuffer sb = new StringBuffer();
     sb.append(" INSERT INTO " + tcb.getFundFundPlan_tb())
         .append("(ID,doc_id,PAYMENT_ID")
         .append(",FEE_TYPE,")
         .append(tcb.getContOrProjCName() + ",")
         .append("PLAN_DATE,PLAN_MONEY,PAY_OBJ,PAY_CUST,PAY_CUST_NAME,")
         .append("SETTLE_METHOD,PAY_TYPE ")
         .append(") VALUES(")
         . // sys_guid()  '" + UUIDUtil.getUUID() + "'
         append("'" + UUIDUtil.getUUID() + "','" + cb.getDocId() + "','" + fund.getPaymentId())
         .append("','" + fund.getFeeType())
         .append("','" + tcb.getContOrProjCValue())
         .append("','" + fund.getPlanDate())
         .append("','" + fund.getPlanMoney())
         .append("','" + fund.getPayObj())
         .append("','" + fund.getPayCust())
         .append("','" + fund.getPayCustName())
         .append("','" + fund.getSettleMethod())
         .append("','" + fund.getPayType())
         .append("')");
     String replaceStr = sb.toString().replace("'null'", "null");
     sb = sb.replace(0, sb.length(), replaceStr);
     logger.info(sb.toString());
     conn.executeUpdate(sb.toString());
     if (fund.getFeeType() != null && fund.getFeeType().equals("feetype12")) { // 将期末余值移除掉
       // fp.remove(fund);
       fundAbstract = fund;
     }
   }
   fp.remove(fundAbstract);
   return true;
 }