@Override public void updateTemplate(CpGzTemplateVO templateVo) throws TplBusinessException { BaseDAO dao = new BaseDAO(); try { dao.updateVO(templateVo); } catch (DAOException e) { LfwLogger.error(e); throw new TplBusinessException(e.getMessage(), e); } }
@Override public void delete(String systemCode) { PtBaseDAO dao = new PtBaseDAO(); try { dao.deleteByClause(PtSsopropVO.class, " systemcode = '" + systemCode + "'"); } catch (DAOException e) { LfwLogger.error(e.getMessage(), e); } PortalCacheManager.notify( CacheKeys.PORTAL_SSO_PROVIDER_CACHE, CacheKeys.PORTAL_SSO_PROVIDER_MAP_CACHE); }
@Override public void update(PtSsopropVO ssoProp) { PtBaseDAO dao = new PtBaseDAO(); try { dao.updateVO(ssoProp); } catch (DAOException e) { LfwLogger.error(e.getMessage(), e); } PortalCacheManager.notify( CacheKeys.PORTAL_SSO_PROVIDER_CACHE, CacheKeys.PORTAL_SSO_PROVIDER_MAP_CACHE); }
@Override public void deleteTemplate(String pk_template) throws TplBusinessException { try { BaseDAO dao = new BaseDAO(); dao.deleteByPK(CpGzTemplateVO.class, pk_template); dao.deleteByClause(CpGzConditionVO.class, "pk_gz_template='" + pk_template + "'"); } catch (DAOException e) { LfwLogger.error(e); throw new TplBusinessException(e.getMessage(), e); } }
public MenuAdapterVO[] getAllMenuCategorys() throws CpbBusinessException { PtBaseDAO dao = new PtBaseDAO(); String sql = "select a.pk_menucategory,a.id,a.title from cp_menucategory a"; List<MenuAdapterVO> list; try { list = (List<MenuAdapterVO>) dao.executeQuery(sql, new MenuCategoryAdapterVOProcessor()); } catch (DAOException e) { LfwLogger.error(e.getMessage(), e); throw new CpbBusinessException(e); } return list.toArray(new MenuAdapterVO[0]); }
@Override public void add(SSOProviderVO provider) { PtBaseDAO dao = new PtBaseDAO(); PtSsopropVO vo = SSOUtil.provider2prop(provider); try { dao.insertVO(vo); } catch (DAOException e) { LfwLogger.error(e.getMessage(), e); } PortalCacheManager.notify( CacheKeys.PORTAL_SSO_PROVIDER_CACHE, CacheKeys.PORTAL_SSO_PROVIDER_MAP_CACHE); }
/** * 覆写方法:初始化所有数据 * * @return * @throws LfwBusinessException * @see nc.vo.ebscg.xydowmload.service.IDownloadService#getDown() */ public List<XyDowmloadVO> getDown() throws LfwBusinessException { // TODO Auto-generated method stub String sql = "select * from ebs_xy_down_file_sign isnull(dr, 0)=0"; try { List<XyDowmloadVO> list = (List<XyDowmloadVO>) baseDao.executeQuery(sql, new BeanListProcessor(XyDowmloadVO.class)); System.out.println(list); return list; } catch (DAOException e) { // TODO Auto-generated catch block Logger.error(e.getMessage(), e); e.printStackTrace(); throw new LfwBusinessException("没有查询到数据", e); } }
@Override public void initConditons(String pk_template, CpGzConditionVO[] conditions) throws TplBusinessException { try { BaseDAO dao = new BaseDAO(); // List<CpQueryConditionVO> list = (List<CpQueryConditionVO>) // dao.retrieveByClause(CpQueryConditionVO.class, "pkTemplet='" + pk_template + "'"); // Iterator<CpQueryConditionVO> it = list.iterator(); dao.deleteByClause(CpGzConditionVO.class, "pk_gz_template='" + pk_template + "'"); if (null != conditions) dao.insertVOArray(conditions); } catch (DAOException e) { LfwLogger.error(e); throw new TplBusinessException(e.getMessage(), e); } }
public MenuAdapterVO[] getAllMenus() throws CpbBusinessException { PtBaseDAO dao = new PtBaseDAO(); String sql1 = "select a.pk_menucategory,a.id,a.title from cp_menucategory as a"; String sql2 = "select b.code,b.name,b.pk_menuitem,b.pk_parent,b.pk_menucategory from cp_menuitem as b"; List<MenuAdapterVO> list1; List<MenuAdapterVO> list2; try { list1 = (List<MenuAdapterVO>) dao.executeQuery(sql1, new MenuCategoryAdapterVOProcessor()); list2 = (List<MenuAdapterVO>) dao.executeQuery(sql2, new MenuItemAdapterVOProcessor()); } catch (DAOException e) { LfwLogger.error(e.getMessage(), e); throw new CpbBusinessException(e); } list1.addAll(list2); return list1.toArray(new MenuAdapterVO[0]); }
/** * 查询,是否已经在外网确认过送货数量和金额 * * @author:zhenglq <br> * @datetime:2009-12-24下午06:51:17 * @param mainVO * @return * @throws LfwRuntimeException */ @SuppressWarnings("unchecked") public boolean permitComplete(String orderPk) throws LfwRuntimeException { // 查询采购订单确认中是否存在订单发货数据 String sql = "select * from ebs_dd_order_item_cfm where pk_dd_order_main='" + orderPk + "'"; try { List<OrderItemCfmVO> predVOList = (List<OrderItemCfmVO>) getBaseDao().executeQuery(sql, new BeanListProcessor(OrderItemCfmVO.class)); if (null != predVOList && predVOList.size() > 0) { return true; } else { return false; } } catch (DAOException e) { e.printStackTrace(); } return false; }
@SuppressWarnings("unchecked") @Override public CpResourceVO[] getResoureces(String pk_user) throws CpbBusinessException { PtBaseDAO baseDAO = new PtBaseDAO(); String sql = "select * from pt_resource p1 join pt_permission p2 on p1.pk_resource = p2.pk_resource where p2.pk_role in (select pk_role from pt_roleuser p3 where p3.pk_user = ?) "; List<CpResourceVO> list = null; SQLParameter param = new SQLParameter(); param.addParam(pk_user); try { list = (List<CpResourceVO>) baseDAO.executeQuery(sql, param, new BeanListProcessor(CpResourceVO.class)); if (list == null || list.size() < 1) return new CpResourceVO[] {}; return list.toArray(new CpResourceVO[list.size()]); } catch (DAOException e) { LfwLogger.error(e.getMessage(), e); throw new CpbBusinessException(e); } }
@SuppressWarnings("unchecked") public CpResourceVO[] getResourcesByRoles(String pkroles[]) throws CpbBusinessException { String param = StringUtils.join(pkroles, "','"); StringBuffer wherePart = new StringBuffer( "select * from pt_resource p1 join pt_permission p2 on p1.pk_resource = p2.pk_resource where p2.pk_role in ('"); wherePart.append(param); wherePart.append("') "); List<CpResourceVO> list = null; try { list = (List<CpResourceVO>) new PtBaseDAO() .executeQuery(wherePart.toString(), new BeanListProcessor(CpResourceVO.class)); if (list == null || list.size() < 1) return new CpResourceVO[] {}; return list.toArray(new CpResourceVO[list.size()]); } catch (DAOException e) { LfwLogger.error(e.getMessage(), e); throw new CpbBusinessException(e); } }
/** * 更新单据受理状态的方法 * * @author liweiqiang * @param key 主表的PK值 * @param btnNo 出发事件的按钮编号 2009-11-12 */ public String setAcceptStatusValue(String key, String btnNo) throws LfwBusinessException { BaseDAO dao = new BaseDAO(); try { DzcgMainAuthority dma = new DzcgMainAuthority(); if (dma.existsCloseData(key, EbsOperaitonConst.CLOSEREQCODE)) { return "此单据已经被关闭,无法进行此操作!"; } } catch (Exception e) { Logger.error( (new StringBuilder("采购申请,点击收回按钮时没有申请单数据 Pk_xq_req_main == ")).append(key).toString()); return "操作失败,请重新操作!"; } String result = null; ReqMainVO reqMainVO = new ReqMainVO(); reqMainVO.setPk_xq_req_main(key); reqMainVO.setStatus(1); ReqMainVO reqMainDeptVO = null; String fieldNames[] = { "accept_status", "modifydate", "modifier", "pk_oper_person", "pk_dept_sug", "zdy1" }; try { reqMainDeptVO = (ReqMainVO) dao.retrieveByPK(ReqMainVO.class, key); } catch (Exception e) { Logger.error( (new StringBuilder("采购申请,点击收回按钮时没有申请单数据 Pk_xq_req_main == ")).append(key).toString()); return "无法进行收回,没有找到申请单数据,请刷新后在进行操作!"; } reqMainVO.setModifydate(new UFDate(System.currentTimeMillis())); reqMainVO.setModifier(LfwRuntimeEnvironment.getUserVO().getPrimaryKey()); IReqService service = (IReqService) NCLocator.getInstance().lookup(IReqService.class); if ("998".equals(btnNo)) { Integer acceptstatus = reqMainDeptVO.getAccept_status(); Integer billstatus = reqMainDeptVO.getBillstatus(); if (acceptstatus == null || billstatus == null) { Logger.error("采购申请,点击收回按钮时没有找到正确的单据状态 acceptstatus == null, billstatus == null"); return "请刷新界面数据,在重新操作!"; } Logger.warn( (new StringBuilder("采购申请,点击收回按钮时数据状态为 acceptstatus == ")) .append(acceptstatus) .append(", billstatus == ") .append(billstatus) .toString()); switch (acceptstatus.intValue()) { case 3: // '\003' reqMainVO.setAccept_status(Integer.valueOf(1)); reqMainVO.setBillstatus(Integer.valueOf(8)); reqMainVO.setPk_oper_person(reqMainDeptVO.getPk_oper_person()); reqMainVO.setPk_dept_sug(reqMainDeptVO.getPk_dept_sug()); reqMainVO.setZdy1(reqMainDeptVO.getZdy1()); service.setReqVOValue(reqMainVO, fieldNames); return "收回成功!"; } return "只有在提交受理状态下才能收回单据"; } if (btnNo.equals("1")) { reqMainVO.setAccept_status(Integer.valueOf(2)); } else if (btnNo.equals("2")) { boolean flagTmp = false; // yanlei start 将建议采购经办人进行处理,对照转授权表。。有被授权人时,改为被授权人 try { // 获取当前方案申请记录 ArrayList<ReqMainVO> reqMainVOTmp = (ArrayList<ReqMainVO>) dao.retrieveByClause( ReqMainVO.class, " pk_xq_req_main like '" + reqMainVO.getPk_xq_req_main() + "'"); // 获取原建议采购经办人主键 // String old_pk_oper_person = // (String)((AggReqVO)ncobjects[i].getContainmentObject()).getParentVO().getAttributeValue("pk_oper_person"); String old_pk_oper_person = reqMainVOTmp.get(0).getPk_oper_person(); if (null != old_pk_oper_person && !"".equals(old_pk_oper_person)) { // 查询出被授权人人员的编码 String sqlPsnTmp = " pk_psndoc like '" + old_pk_oper_person + "'"; ArrayList<PsndocVO> psnvoTmp = (ArrayList<PsndocVO>) (dao.retrieveByClause(PsndocVO.class, sqlPsnTmp)); List<SmUserVO> asqvoTmp = (List<SmUserVO>) dao.executeQuery( "SELECT * FROM sm_user bd , sm_userandclerk sm WHERE " + " sm.pk_psndoc='" + psnvoTmp.get(0).getPk_psnbasdoc() + "' AND sm.userid = bd.cuserid", new BeanListProcessor(SmUserVO.class)); // String sqlAsTmp = " cuserid = (select userid from sm_userandclerk tttt where // tttt.pk_psndoc='"+psnvoTmp.get(0).getPk_psnbasdoc()+"'"; // ArrayList<SmUserVO> asqvoTmp = // (ArrayList<SmUserVO>)(dao.retrieveByClause(SmUserVO.class, sqlAsTmp)); String old_cuserid = asqvoTmp.get(0).getPrimaryKey(); String sqlWhere = " isnull(dr,0) = 0 and operatorid like '" + old_cuserid.toString() + "'"; ArrayList<ZsqVO> zsqvo = (ArrayList<ZsqVO>) (dao.retrieveByClause(ZsqVO.class, sqlWhere)); if (null != zsqvo && 0 != zsqvo.size()) { if ((null != zsqvo.get(0).getAuthorid()) && !old_cuserid.equals(zsqvo.get(0).getAuthorid())) { // 被授权人的人员id String new_cuserid = zsqvo.get(0).getAuthorid(); Date date1 = new Date(System.currentTimeMillis()); SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd"); String currDateStr = df.format(date1); UFDate currDate = new UFDate(currDateStr); UFDateTime uft = new UFDateTime(System.currentTimeMillis()); UFDateTime end_date = null; if (null != zsqvo.get(0).getEnd_author()) { end_date = zsqvo.get(0).getEnd_author(); } boolean is_youxiao = false; if (null != end_date) { is_youxiao = uft.before(end_date); } boolean is_everl_author = false; if (null != zsqvo.get(0).getIs_everl_author()) { is_everl_author = zsqvo.get(0).getIs_everl_author().booleanValue(); } if (null == new_cuserid) { reqMainVO.setPk_oper_person(reqMainDeptVO.getPk_oper_person()); reqMainVO.setPk_dept_sug(reqMainDeptVO.getPk_dept_sug()); reqMainVO.setZdy1(reqMainDeptVO.getZdy1()); } else if (is_youxiao || is_everl_author) { // 查询出被授权人人员的编码 // 当被授权人为操作人员时 // List<PsndocVO> psnvo = (List<PsndocVO>)dao.executeQuery( "SELECT // bd.pk_psndoc FROM bd_psndoc bd , sm_userandclerk sm WHERE " + // " sm.userid='"+new_cuserid+"' AND sm.pk_psndoc = bd.pk_psnbasdoc", new // BeanListProcessor(PsndocVO.class)); String sqlPsn = " pk_psndoc like '" + new_cuserid + "'"; ArrayList<PsndocVO> psnvo = (ArrayList<PsndocVO>) (dao.retrieveByClause(PsndocVO.class, sqlPsn)); // String sqlUser = "******"+new_cuserid+"'"; // ArrayList<SmUserVO> asqvo = // (ArrayList<SmUserVO>)(dao.retrieveByClause(SmUserVO.class, sqlUser)); // String str_code = asqvo.get(0).getUser_code(); // String sqlPsn = " psncode like '"+str_code+"'"; // ArrayList<PsndocVO> psnvo = // (ArrayList<PsndocVO>)(dao.retrieveByClause(PsndocVO.class, sqlPsn)); // // ((AggReqVO)ncobjects[i].getContainmentObject()).getParentVO().setAttributeValue("pk_oper_person", psnvo.get(0).getPk_psndoc()); reqMainVO.setPk_oper_person(psnvo.get(0).getPk_psndoc()); reqMainVO.setPk_dept_sug(psnvo.get(0).getPk_deptdoc()); reqMainVO.setZdy1(psnvo.get(0).getPk_corp()); } else { reqMainVO.setPk_oper_person(reqMainDeptVO.getPk_oper_person()); reqMainVO.setPk_dept_sug(reqMainDeptVO.getPk_dept_sug()); reqMainVO.setZdy1(reqMainDeptVO.getZdy1()); } } else { reqMainVO.setPk_oper_person(reqMainDeptVO.getPk_oper_person()); reqMainVO.setPk_dept_sug(reqMainDeptVO.getPk_dept_sug()); reqMainVO.setZdy1(reqMainDeptVO.getZdy1()); } } else { reqMainVO.setPk_oper_person(reqMainDeptVO.getPk_oper_person()); reqMainVO.setPk_dept_sug(reqMainDeptVO.getPk_dept_sug()); reqMainVO.setZdy1(reqMainDeptVO.getZdy1()); } } else { reqMainVO.setPk_oper_person(reqMainDeptVO.getPk_oper_person()); reqMainVO.setPk_dept_sug(reqMainDeptVO.getPk_dept_sug()); reqMainVO.setZdy1(reqMainDeptVO.getZdy1()); } } catch (DAOException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } // yanlei end String sql = " select * from ebs_xq_req_item_prod where pk_xq_req_main ='" + key + "' and isnull(dr,0) = 0"; // 查找合同表体数据 try { List<ReqItemProdVO> list = (List<ReqItemProdVO>) dao.executeQuery(sql, new BeanListProcessor(ReqItemProdVO.class)); if (list == null || list.size() <= 0) { return "表体数据无数据!"; } } catch (Exception e) { } reqMainVO.setAccept_status(Integer.valueOf(3)); if (flagTmp) reqMainVO.setPk_oper_person(reqMainDeptVO.getPk_oper_person()); // 申请人 String pk_persom = reqMainDeptVO.getOperatorid(); // 申请处理人 // yanlei start 当未授权时,发件人为原处理人,有授权人时,发件人变为被授权人 String pk_oper_person = reqMainVO.getPk_oper_person(); String psnname = ""; String email = ""; String person = ""; String email_s = ""; String dianhua = ""; String deptName = ""; DzcgMainAuthority dma = new DzcgMainAuthority(); try { // 获取人员管理档案信息 PsndocVO pvo = dma.getPsndocByPk(pk_oper_person); PsndocVO pdvo = dma.getPsndocVO(pk_persom); DeptdocVO dept = dma.getDeptInfo(reqMainDeptVO.getPk_dept()); if (pvo != null) { // 处理人员 psnname = pvo.getPsnname(); PsnbasdocVO pbvo = null; pbvo = dma.getPsnbasdocVOByPk(pvo.getPk_psnbasdoc()); if (pbvo != null) { // 处理人邮箱 email = pbvo.getEmail(); } } if (dept != null) { deptName = dept.getDeptname(); } if (pdvo != null) { // 申请人名称 person = pdvo.getPsnname(); PsnbasdocVO pcvo = null; pcvo = dma.getPsnbasdocVOByPk(pdvo.getPk_psnbasdoc()); if (pcvo != null) { // 申请人电话邮箱 email_s = pcvo.getEmail(); dianhua = pcvo.getMobile(); } } } catch (Exception e) { Logger.error("采购申请提交受理,发送email时获取人员档案信息失败!"); Logger.error(e.getMessage()); } // ---zhoqui--修改邮件发送内容--- String title = "新的采购项目等待您处理"; StringBuffer mail = new StringBuffer( psnname + ":<br> 电子采购系统(需求受理)中有新的采购项目等待您处理。<br> 项目名称【"); mail.append(reqMainDeptVO.getBill_name()).append("】【"); mail.append(reqMainDeptVO.getBill_code()).append("】<br><br>"); mail.append(deptName).append("<br>联系人:"); mail.append(person).append("(申请人)<br>电话:"); mail.append(dianhua).append("<br>邮箱:"); mail.append(email_s).append("<br>注:此邮件为系统自动发出,请勿直接回复。谢谢!"); dma.sendEmail(title, mail.toString(), email); } else { reqMainVO.setAccept_status(Integer.valueOf(4)); } service.setReqVOValue(reqMainVO, fieldNames); // 现在都是email的通信机制所以不发送代办事项 /* try { IPredictQueryService queryService = (IPredictQueryService)NCLocator.getInstance().lookup(IPredictQueryService.class); MessageinfoVO messageinfoVO = new MessageinfoVO(); messageinfoVO.setBillid(null); messageinfoVO.setBillno("/manageui.jsp?ctrl=nc.ui.ebscg.xqreqaccept.ClientUIWebCtrl&model=nc.ui.ebscg.xqreqaccept.ReqAcceptPageModel&delegator=nc.ui.ebscg.xqreqaccept.ReqAcceptDelegator&pageId=E05405"); messageinfoVO.setContent((new StringBuilder("采购申请提交受理,请进入待处理查看!")).append(new UFDateTime(System.currentTimeMillis())).toString()); messageinfoVO.setPk_billtype("E04C"); messageinfoVO.setPk_corp(LfwRuntimeEnvironment.getPkCorp()); messageinfoVO.setPk_srcbilltype(messageinfoVO.getPk_billtype()); messageinfoVO.setSenddate(new UFDateTime(System.currentTimeMillis())); messageinfoVO.setSenderman(LfwRuntimeEnvironment.getUserVO().getPrimaryKey()); messageinfoVO.setSendermanName(LfwRuntimeEnvironment.getUserVO().getUserName()); messageinfoVO.setPriority(new Integer(0)); List uaVOs = queryService.queryUserInfoByRolecode(reqMainDeptVO.getPk_dept_sug(), LfwRuntimeEnvironment.getCorp().getUnitcode(), "E05405"); messageinfoVO.setState(new Integer(0)); messageinfoVO.setType(new Integer(3)); if (uaVOs != null) { for (Iterator iterator = uaVOs.iterator(); iterator.hasNext(); dao.insertVO(messageinfoVO)) { UserAndClerkVO uaVO = (UserAndClerkVO)iterator.next(); messageinfoVO.setCheckman(uaVO.getUserid()); } } } catch (DAOException e1) { throw new LfwRuntimeException("向建议采购部门采购申请处理人发送待办失败!"); } */ result = "success"; return result; }