Exemplo n.º 1
0
  /**
   * 删除原资金计划
   *
   * @param cb
   * @return
   * @throws Exception
   */
  public boolean deleteFundFundCharge(ConditionBean cb, TabCalBean tcb) throws Exception {

    Conn conn = new Conn();
    // 报价编号
    String sql =
        " delete from "
            + tcb.getFundFundPlan_tb()
            + " where  doc_id='"
            + cb.getDocId()
            + "' and "
            + tcb.getContOrProjCName()
            + "='"
            + tcb.getContOrProjCValue()
            + "'";

    conn.executeUpdate(sql);
    return true;
  }
Exemplo n.º 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;
 }