/**
* 查询划款帐号维护中要打印列表信息
*
* @param pagination
* @throws Exception
* @return List
* @author wsh
*/
public List findHouseAccPrintList(Pagination pagination, List loanBankList) throws Exception {
// TODO Auto-generated method stub
List list = new ArrayList();
try {
String contractId = "";
String borrowerName = "";
String cardNum = "";
String sellerName = "";
if (pagination.getQueryCriterions().get("contractId") != null) {
contractId = (String) pagination.getQueryCriterions().get("contractId");
}
if (pagination.getQueryCriterions().get("borrowerName") != null) {
borrowerName = (String) pagination.getQueryCriterions().get("borrowerName");
}
if (pagination.getQueryCriterions().get("cardNum") != null) {
cardNum = (String) pagination.getQueryCriterions().get("cardNum");
}
if (pagination.getQueryCriterions().get("sellerName") != null) {
cardNum = (String) pagination.getQueryCriterions().get("sellerName");
}
list =
housesDAO.queryHousePrintList_wsh(
contractId, borrowerName, cardNum, sellerName, loanBankList);
for (int i = 0; i < list.size(); i++) {
HouseListDTO houseListDTO = (HouseListDTO) list.get(i);
// 转换真实姓名
if (houseListDTO.getOperator() != null && !"".equals(houseListDTO.getOperator()))
houseListDTO.setOperator(getUserRealName(houseListDTO.getOperator()));
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return list;
}
/**
* 修改划款帐号
*
* @param contractId 合同编号
* @throws Exception
* @author wsh
*/
public String findHouseType(String contractId) throws Exception {
// TODO Auto-generated method stub
String houseType = "";
try {
houseType = housesDAO.findHouseType_wsh(contractId);
} catch (Exception e) {
// TODO: handle exception
}
return houseType;
}
/**
* 根据合同编号查询划款帐号修改信息
*
* @param contractId 合同编号
* @param houseType 住房类型
* @return GiveaccModifyDTO
* @throws Exception
* @author wsh
*/
public GiveaccModifyDTO findGiveaccInfo(String contractId, String houseType)
throws Exception, BusinessException {
// TODO Auto-generated method stub
GiveaccModifyDTO giveaccModifyDTO = new GiveaccModifyDTO();
try {
giveaccModifyDTO = housesDAO.queryHousesInfo_wsh(contractId.toString(), houseType);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return giveaccModifyDTO;
}
/**
* author wsh 根据合同编号,借款人姓名，卡号，售房人查询PL131中记录数量 2007-9-26
*
* @param contractId 合同编号
* @param borrowerName 借款人姓名
* @param cardNum 卡号
* @param sellerName 售房人
* @return int
*/
public int findHouseAccCount(
String contractId, String borrowerName, String cardNum, String sellerName, List loanBankList)
throws Exception {
// TODO Auto-generated method stub
int count = 0;
try {
count =
housesDAO
.queryHouseCount_wsh(contractId, borrowerName, cardNum, sellerName, loanBankList)
.intValue();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return count;
}
/**
* 修改划款帐号
*
* @param contractId 合同编号
* @param newLoanKouAcc 新扣款帐号
* @param oldBankAcc 旧扣款帐号
* @param securityInfo 权限
* @throws Exception
* @author wsh
*/
public void modifyGiveAccInfo(
String contractId,
String oldSellerPayBank,
String oldPayBankAcc,
String newSellerPayBank,
String newPayBankAcc,
String houseType,
SecurityInfo securityInfo)
throws Exception, BusinessException {
// TODO Auto-generated method stub
try {
Houses house = housesDAO.queryById(contractId);
if ("01".equals(houseType)) {
house.setDeveloperPaybank(newSellerPayBank);
house.setDeveloperPaybankAAcc(newPayBankAcc);
} else {
house.setBargainorPaybank(newSellerPayBank);
house.setBargainorPaybankAcc(newPayBankAcc);
}
GiveAcc giveAcc = new GiveAcc();
giveAcc.setContractId(contractId);
giveAcc.setModifyDate(securityInfo.getUserInfo().getPlbizDate());
giveAcc.setNewPokeBank(newSellerPayBank);
giveAcc.setNewPokeBankAcc(newPayBankAcc);
giveAcc.setOldPokeBank(oldSellerPayBank);
giveAcc.setOldPokeBankAcc(oldPayBankAcc);
giveAcc.setOprator(securityInfo.getUserName());
giveAcc.setOpTime(new Date());
giveAccDAO.insert(giveAcc);
PlOperateLog plOperateLog = new PlOperateLog();
// 插入日志PL021
plOperateLog.setContractId(contractId);
plOperateLog.setOpSys(new BigDecimal(BusiLogConst.OP_SYSTEM_TYPE_LOAN + ""));
plOperateLog.setOpModel(String.valueOf(BusiLogConst.PL_OP_LOANAPPL_GATHERINGACC_DO));
plOperateLog.setOpButton(String.valueOf(BusiLogConst.BIZLOG_ACTION_ADD));
plOperateLog.setOpBizId(new BigDecimal(giveAcc.getPokeBankModifyId().toString()));
plOperateLog.setOpIp(securityInfo.getUserIp());
plOperateLog.setOpTime(new Date());
plOperateLog.setOperator(securityInfo.getUserName());
plOperateLogDAO.insert(plOperateLog);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}