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;
}