@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);
   }
 }
예제 #2
0
 @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);
 }
예제 #3
0
 @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);
   }
 }
예제 #5
0
 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]);
 }
예제 #6
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);
 }
예제 #7
0
 /**
  * 覆写方法:初始化所有数据
  *
  * @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);
   }
 }
예제 #9
0
 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;
 }
예제 #11
0
 @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);
   }
 }
예제 #12
0
 @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);
   }
 }
예제 #13
0
  /**
   * 更新单据受理状态的方法
   *
   * @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>&nbsp;&nbsp;&nbsp;&nbsp;电子采购系统(需求受理)中有新的采购项目等待您处理。<br>&nbsp;&nbsp;&nbsp;&nbsp;项目名称【");
      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;
  }