hibernate经常使用的一些方法

public void saveRequireFileInfo(Map<String, String> paramsMap, String userId)
throws Exception {
String querymode = paramsMap.get("querymode");
String requireFileid = paramsMap.get("requireFileid");
Date sysdate = commonDAO.getDatabaseSysDate();
RequireFileInfo requireFileInfo = null;
if("edit".equals(querymode) && StringUtil.isNotBlank(requireFileid)){
requireFileInfo = requireFileDAO.getRequireFileInfoById(requireFileid);
requireFileInfo.setLastupdatetime(sysdate);   //修改时间
requireFileInfo.setLastupdateuser(userId);                           //修改人
}else{
requireFileInfo = new RequireFileInfo();
requireFileInfo.setCreatedatetime(sysdate);//创建时间
requireFileInfo.setCreateuser(userId);//创建人
requireFileInfo.setLastupdatetime(sysdate);   //修改时间
requireFileInfo.setLastupdateuser(userId);  //修改人
}
requireFileInfo.setProjectname(paramsMap.get("view_projectcode"));//项目名称
requireFileInfo.setProjectcode(paramsMap.get("projectcode"));//项目编码
requireFileInfo.setSerialnumber(paramsMap.get("serialnumber"));//编号
requireFileInfo.setSymbolnumber(paramsMap.get("symbolnumber"));//文号
requireFileInfo.setRequirementtitle(paramsMap.get("requirementtitle"));//要件标题
if(StringUtil.isNotBlank(paramsMap.get("requirementdate"))){
requireFileInfo.setRequirementdate(DateUtil.strToDate(paramsMap.get("requirementdate"), "yyyy-MM-dd"));//要件日期
}

requireFileInfo.setRequirementnumber(paramsMap.get("requirementnumber"));//要件份数

//判断交接信息是否选择 是:1
requireFileInfo.setIshandover(ishandover);
if(StringUtil.equals("1", ishandover)){
if(StringUtil.isNotBlank(paramsMap.get("handoverdate"))){
requireFileInfo.setHandoverdate(DateUtil.strToDate(paramsMap.get("handoverdate"), "yyyy-MM-dd"));
}
}else{
requireFileInfo.setHandoverdate(DateUtil.strToDate(paramsMap.get(""), "yyyy-MM-dd"));//修改时,交接信息改成否,要去掉交接日期
}
//保存修改方法
requireFileDAO.saveOrUpdateRequireInfo(requireFileInfo);
//保存文档信息
projectTextManager.saveTextInfo(paramsMap.get("updowminfo"), 
PmConstants.TCMP_REQUIREFILE_INFO, requireFileInfo.getId().toString(), "");


}


/**
* 保存或修改方法
*/
@Override
public void saveOrUpdateRequireInfo(RequireFileInfo requireFileInfo)
throws Exception {
try {
hibernateDao.saveOrUpdate(requireFileInfo);
} catch (Exception e) {
log.error("要件信息保存失败!");
throw new TcmpException(TcmpException.ERROR_INSERT);
}
}

/**
* 获取单条要件信息
*/
@Override
public RequireFileInfo getRequireFileInfoById(String id) throws Exception {
try{
return hibernateDao.get(RequireFileInfo.class, Integer.valueOf(id));
}catch (Exception e) {
log.error("获取单条要件信息失败", e);
throw e;
}
}

/**
* 作废修改状态
*/
@Override
public void saveOrUpdateRequireFileInfo(List<RequireFileInfo> list)
throws Exception {
try {
hibernateDao.saveOrUpdate(list);
} catch (Exception e) {
log.error("要件信息作废失败!!!");
throw e;
}
}



public Page<?> getBanksAccLedgerForPage(Map<String, String> paramsMap)
throws Exception {
Page<?> pageList = accountBanksInfoDAO.getBanksAccLedgerForPage(paramsMap);
if(pageList != null){
paramsMap.put("totalRecord", String.valueOf(pageList.getTotalRows()));
List<Map> listMaps= (List<Map>) pageList.getRecords();
List<Map> newlistMaps = new ArrayList<Map>();
Page<Map> newPage = new Page();
for (int i=0;i<listMaps.size();i++){
Map map = (Map)listMaps.get(i);
String primarykey = (String) map.get("id");
if(StringUtil.isNotBlank(primarykey)){
            String accoid = (String) map.get("id");
            AccountBanksInfoDetail accountBanksInfoDetail = accountBanksInfoDAO.getAccountFactorValue(accoid,AccountBatchUpdateConstants.FUNDPAYUKEYNAME);
            if(accountBanksInfoDetail != null && accountBanksInfoDetail.getFactorvalue() != null){
            String factorValue = accountBanksInfoDetail.getFactorvalue();
            String fundPayUkeyName = (String) DynamicBeanMethodInvoke.invoke("netsilverUshieldDAO",
            "getNetsilverUshieldName",new Object[]{factorValue},new Class[]{String.class});
            if(StringUtil.isNotBlank(fundPayUkeyName)){
            map.put(AccountBatchUpdateConstants.FUNDPAYUKEYNAME, fundPayUkeyName);
            }
            }
           
            //查询银行账户联系人 最多显示3个
            String accountWorkPerson = "";
            List<Map>  banksWorkPerson = accountBanksInfoDAO.getAccoBankContactInfo(accoid);
            if(banksWorkPerson != null && banksWorkPerson.size()>0){
            int counts = 0;
            for (Map personMap : banksWorkPerson) {
            if(counts > 2){
            continue;
            }
            if(personMap.get("contactman")!=null){
            String contactman= (String) personMap.get("contactman");
            accountWorkPerson = accountWorkPerson+contactman+":";
            }
            if(personMap.get("contactphone")!=null){
            String contactphone = (String) personMap.get("contactphone");
            accountWorkPerson = accountWorkPerson+contactphone+";";
            }
            counts++;
}
            }
            if(StringUtil.isNotBlank(accountWorkPerson)){
            //去除最后一个“;”
            accountWorkPerson = accountWorkPerson.substring(0, accountWorkPerson.length()-1);
            map.put("banksWorkPerson", accountWorkPerson);
            }
            //查询网银开通状态
            AccountBanksInfoDetail bankDetail = accountBanksInfoDAO.getAccountFactorValue(accoid,AccountBatchUpdateConstants.CONNECTIONSTATE);
            if(bankDetail != null && bankDetail.getFactorvalue() != null){
            String connectionState_display = BizframeDictCache.getInstance().getPrompt("CONNECTION_STATE", bankDetail.getFactorvalue());
        if(StringUtil.isNotBlank(connectionState_display)){
        map.put("connectionState_display", connectionState_display);
        }
            }
            newlistMaps.add(map);
}else{
newlistMaps.add(map);
}
        }
newPage.setRecords(newlistMaps);
newPage.setTotalRows(pageList.getTotalRows());
return newPage;
}
return pageList;
}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值