/**
* 资金计划保存到临时表中
*
* @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;
}
/**
* 删除原资金计划
*
* @param cb
* @return
* @throws Exception
*/
public boolean deleteFundFundCharge(String docId) throws Exception {
Conn conn = new Conn();
// 报价编号
String sql = " delete from FUND_FUND_PLAN_TEMP where doc_id='" + docId + "'";
conn.executeUpdate(sql);
return true;
}
/**
* 删除原资金计划
*
* @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;
}
/**
* 资金计划保存到临时表中
*
* @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;
}