public void performTask(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { String forwardURL = ""; Message message = SessionUtil.getMessage(req); Connection conn = null; try { SfUserDTO user = (SfUserDTO) getUserAccount(req); Request2DTO req2DTO = new Request2DTO(); req2DTO.setDTOClassName(AmsVendorInfoDTO.class.getName()); AmsVendorInfoDTO dto = (AmsVendorInfoDTO) req2DTO.getDTO(req); String action = dto.getAct(); conn = getDBConnection(req); SpareVendorDAO rptDAO = new SpareVendorDAO(user, dto, conn); if (action.equals("")) { req.setAttribute(QueryConstant.QUERY_DTO, dto); forwardURL = AssetsURLList.SPARE_VENDOR_QUERY; } else if (action.equals(AssetsActionConstant.QUERY_ACTION)) { BaseSQLProducer sqlProducer = new SpareVendorModel(user, dto); PageQueryDAO pageDAO = new PageQueryDAO(req, conn, sqlProducer); pageDAO.setCalPattern(LINE_PATTERN); pageDAO.produceWebData(); req.setAttribute(QueryConstant.QUERY_DTO, dto); forwardURL = AssetsURLList.SPARE_VENDOR_QUERY; } else if (action.equals(WebActionConstant.NEW_ACTION)) { String VendorId = rptDAO.getVendorId(); dto.setVendorId(VendorId); req.setAttribute(QueryConstant.QUERY_DTO, dto); forwardURL = AssetsURLList.SPARE_VENDOR_INFO; } else if (action.equals(WebActionConstant.CREATE_ACTION)) { rptDAO.setServletConfig(getServletConfig(req)); rptDAO.createData(); message = rptDAO.getMessage(); forwardURL = AssetsURLList.SPARE_VENDOR_SERVLET; } else if (action.equals(WebActionConstant.UPDATE_ACTION)) { rptDAO.setServletConfig(getServletConfig(req)); rptDAO.updateData(); message = rptDAO.getMessage(); forwardURL = AssetsURLList.SPARE_VENDOR_SERVLET; } else if (action.equals(AssetsActionConstant.DETAIL_ACTION)) { rptDAO.setDTOClassName(AmsVendorInfoDTO.class.getName()); AmsVendorInfoDTO ridDto = (AmsVendorInfoDTO) rptDAO.getDataByPrimaryKey(); if (ridDto == null) { dto = new AmsVendorInfoDTO(); message = getMessage(MsgKeyConstant.DATA_NOT_EXIST); message.setIsError(true); } req.setAttribute(QueryConstant.QUERY_DTO, ridDto); forwardURL = AssetsURLList.SPARE_VENDOR_INFO; } else if (action.equals(WebActionConstant.DELETE_ACTION)) { rptDAO.deleteData(); message = rptDAO.getMessage(); forwardURL = AssetsURLList.SPARE_VENDOR_SERVLET; } else if (action.equals("verifyworkNo")) { String vendorName = req.getParameter("vendorName"); boolean success = rptDAO.doVerify(vendorName); PrintWriter out = res.getWriter(); if (success) { out.print("Y"); } out.flush(); out.close(); } else { message = getMessage(MsgKeyConstant.INVALID_REQ); message.setIsError(true); forwardURL = MessageConstant.MSG_PRC_SERVLET; } } catch (PoolPassivateException ex) { ex.printLog(); message = getMessage(AssetsMessageKeys.POOL_PASSIVATE_ERROR); message.setIsError(true); forwardURL = MessageConstant.MSG_PRC_SERVLET; } catch (DTOException ex) { ex.printLog(); message = getMessage(AssetsMessageKeys.DTO_ERROR); message.setIsError(true); forwardURL = MessageConstant.MSG_PRC_SERVLET; } catch (QueryException ex) { ex.printLog(); message = getMessage(AssetsMessageKeys.QUERY_ERROR); message.setIsError(true); forwardURL = MessageConstant.MSG_PRC_SERVLET; } catch (DataHandleException ex) { ex.printLog(); message = getMessage(AssetsMessageKeys.COMMON_ERROR); message.setIsError(true); forwardURL = MessageConstant.MSG_PRC_SERVLET; } catch (SQLModelException ex) { ex.printLog(); message = getMessage(AssetsMessageKeys.COMMON_ERROR); message.setIsError(true); forwardURL = MessageConstant.MSG_PRC_SERVLET; } catch (ContainerException e) { e.printStackTrace(); } finally { closeDBConnection(conn); setHandleMessage(req, message); if (!StrUtil.isEmpty(forwardURL)) { ServletForwarder forwarder = new ServletForwarder(req, res); forwarder.forwardView(forwardURL); } } }
/** * @param req HttpServletRequest * @param res HttpServletResponse * @throws ServletException * @throws IOException */ public void performTask(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { String forwardURL = ""; Message message = SessionUtil.getMessage(req); Connection conn = null; try { SfUserDTO user = (SfUserDTO) SessionUtil.getUserAccount(req); Request2DTO req2DTO = new Request2DTO(); req2DTO.setDTOClassName(AmsYjItemDTO.class.getName()); AmsYjItemDTO dtoParameter = (AmsYjItemDTO) req2DTO.getDTO(req); String action = dtoParameter.getAct(); conn = getDBConnection(req); AmsYjItemDAO amsYjItemDAO = new AmsYjItemDAO(user, dtoParameter, conn); if (action.equals("")) { forwardURL = "/yj/yjItemSearch.jsp"; } else if (action.equals(WebActionConstant.QUERY_ACTION)) { BaseSQLProducer sqlProducer = new AmsYjItemModel(user, dtoParameter); PageQueryDAO pageDAO = new PageQueryDAO(req, conn, sqlProducer); pageDAO.produceWebData(); forwardURL = "/yj/yjItemSearch.jsp"; } else if (action.equals(WebActionConstant.NEW_ACTION)) { AmsYjItemDTO amsYjItem = new AmsYjItemDTO(); req.setAttribute("AMS_YJ_ITEM", amsYjItem); forwardURL = "/yj/yjItemDetail.jsp"; } else if (action.equals(WebActionConstant.DETAIL_ACTION)) { amsYjItemDAO.setDTOClassName(AmsYjItemDTO.class.getName()); AmsYjItemDTO amsYjItem = (AmsYjItemDTO) amsYjItemDAO.getDataByPrimaryKey(); if (amsYjItem == null) { amsYjItem = new AmsYjItemDTO(); message = getMessage(MsgKeyConstant.DATA_NOT_EXIST); message.setIsError(true); } req.setAttribute("AMS_YJ_ITEM", amsYjItem); forwardURL = "/yj/yjItemDetail.jsp"; } else if (action.equals(WebActionConstant.CREATE_ACTION)) { boolean isNew = StrUtil.isEmpty(dtoParameter.getItemCode()); YjManagerUtil yjUtil = new YjManagerUtil(user, conn); if (isNew) { dtoParameter.setItemCode(String.valueOf(yjUtil.getYjManagerMax("AMS_YJ_ITEM_SEQ"))); } amsYjItemDAO.createData(); forwardURL = "/servlet/com.sino.ams.yj.servlet.AmsYjItemServlet?act=" + WebActionConstant.QUERY_ACTION + "&itemCode=" + dtoParameter.getItemCode(); } else if (action.equals(WebActionConstant.UPDATE_ACTION)) { amsYjItemDAO.updateData(); forwardURL = "/servlet/com.sino.ams.yj.servlet.AmsYjItemServlet?act=" + WebActionConstant.QUERY_ACTION + "&itemCode=" + dtoParameter.getItemCode(); } else if (action.equals(WebActionConstant.DELETE_ACTION)) { // 失效 amsYjItemDAO.deleteData(); forwardURL = "/servlet/com.sino.ams.yj.servlet.AmsYjItemServlet?act=" + WebActionConstant.QUERY_ACTION; } else if (action.equals(AMSActionConstant.INURE_ACTION)) { // 生效 String amsYjItem = ""; amsYjItemDAO.enableItem(amsYjItem); forwardURL = "/servlet/com.sino.ams.yj.servlet.AmsYjItemServlet?act=" + WebActionConstant.QUERY_ACTION; } else if (action.equals(WebActionConstant.EXPORT_ACTION)) { // 导出到Excel File file = amsYjItemDAO.exportFile(); WebFileDownload fileDown = new WebFileDownload(req, res); fileDown.setFilePath(file.getAbsolutePath()); fileDown.download(); file.delete(); } else if (action.equals("verifyItemName")) { String itemName = req.getParameter("itemName"); boolean success = amsYjItemDAO.doVerify(itemName); PrintWriter out = res.getWriter(); if (success) { out.print("Y"); } out.flush(); out.close(); } else { message = getMessage(MsgKeyConstant.INVALID_REQ); message.setIsError(true); forwardURL = MessageConstant.MSG_PRC_SERVLET; } } catch (PoolPassivateException ex) { ex.printLog(); message = getMessage(MsgKeyConstant.POOL_PASSIVATE_ERROR); message.setIsError(true); forwardURL = MessageConstant.MSG_PRC_SERVLET; } catch (DTOException ex) { ex.printLog(); message = getMessage(MsgKeyConstant.DTO_ERROR); message.setIsError(true); forwardURL = MessageConstant.MSG_PRC_SERVLET; } catch (QueryException ex) { ex.printLog(); message = getMessage(MsgKeyConstant.QUERY_ERROR); message.setIsError(true); forwardURL = MessageConstant.MSG_PRC_SERVLET; } catch (DataHandleException ex) { ex.printLog(); // 请根据实际情况处理消息 forwardURL = "保持界面录入的数据,返回到原页面,并显示上面给出的消息"; } catch (WebFileDownException e) { e .printStackTrace(); // To change body of catch statement use File | Settings | File // Templates. } finally { DBManager.closeDBConnection(conn); setHandleMessage(req, message); ServletForwarder forwarder = new ServletForwarder(req, res); forwarder.forwardView(forwardURL); // 根据实际情况修改页面跳转代码。 } }
/** * @param req HttpServletRequest * @param res HttpServletResponse * @throws ServletException * @throws IOException */ public void performTask(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { // String MATCH_MODE_SPARE = "0"; 备件确认 // String MATCH_MODE_SPARE_RET = "1"; 撤销备件关系 // String MATCH_MODE_PRJMTL = "2"; 工程物资确认 // String MATCH_MODE_PRJMTL_RET = "3"; 撤销工程物资匹配关系 // String MATCH_MODE_OTHER = "4"; 设备屏蔽 // String MATCH_MODE_0THER_RET = "5"; 撤销设备屏蔽 String forwardURL = ""; Message message = SessionUtil.getMessage(req); String action = req.getParameter("act"); action = StrUtil.nullToString(action); Connection conn = null; try { SfUserDTO user = (SfUserDTO) SessionUtil.getUserAccount(req); TfEtsItemMatchRecDTO dtoParameter = null; Request2DTO req2DTO = new Request2DTO(); req2DTO.setDTOClassName(TfEtsItemMatchRecDTO.class.getName()); dtoParameter = (TfEtsItemMatchRecDTO) req2DTO.getDTO(req); conn = getDBConnection(req); TfEtsItemMatchRecDAO etsItemMatchRecDAO = new TfEtsItemMatchRecDAO(user, dtoParameter, conn); String matchType = dtoParameter.getMatchType(); ServletConfigDTO configDTO = getServletConfig(req); if (action.equals("")) { if (matchType.equals(WebAttrConstant.MATHC_MODE_CHANGED_ASSETS_RET)) { // 撤消资产匹配关系操作 forwardURL = URLDefineList.TF_UNYOKE_PAGE + "?matchType=" + matchType; } else { forwardURL = URLDefineList.TF_FINANCE_PROP_SET_PAGE + "?matchType=" + matchType; } } else if (action.equals(WebActionConstant.QUERY_ACTION)) { if (matchType.equals(WebAttrConstant.MATHC_MODE_CHANGED_ASSETS_RET)) { BaseSQLProducer sqlProducer = new TfEtsItemMatchRecModel(user, dtoParameter); PageQueryDAO pageDAO = new PageQueryDAO(req, conn, sqlProducer); pageDAO.setServletConfig(configDTO); CheckBoxProp checkProp = new CheckBoxProp("subCheck"); checkProp.addDbField("SYSTEM_ID"); checkProp.addDbField("ASSET_ID"); pageDAO.setWebCheckProp(checkProp); pageDAO.produceWebData(); forwardURL = URLDefineList.TF_UNYOKE_PAGE + "?matchType=" + matchType + "&unyokeFlag=" + dtoParameter.getUnyokeFlag(); } else { BaseSQLProducer sqlProducer = new TfEtsItemMatchRecModel(user, dtoParameter); PageQueryDAO pageDAO = new PageQueryDAO(req, conn, sqlProducer); pageDAO.produceWebData(); forwardURL = URLDefineList.TF_FINANCE_PROP_SET_PAGE + "?matchType=" + matchType; } } else if (action.equals(AMSActionConstant.MATCH_ACTION)) { DTOSet dtos = getDTOs(req, matchType); if (matchType.equals(WebAttrConstant.MATHC_MODE_CHANGED_ASSETS_RET)) { dtos = getCheckedAssets(req, matchType); etsItemMatchRecDAO.delDTOs(dtos); forwardURL = URLDefineList.TF_UNYOKE_PAGE + "?matchType=" + matchType; } // 2009.3.31修改su // else if(matchType.equals(WebAttrConstant.MATCH_MODE_RENT)) {//租赁资产确认 // String [] systemIds=req.getParameterValues("systemId"); // etsItemMatchRecDAO.confirmRentAssets(systemIds); // forwardURL = URLDefineList.FINANCE_PROP_SET_PAGE + "?matchType=" + // matchType; // } // else if(matchType.equals(WebAttrConstant.MATCH_MODE_DG)) {//代管资产确认 // String [] systemIds=req.getParameterValues("systemId"); // etsItemMatchRecDAO.confirmDGAssets(systemIds); // forwardURL = URLDefineList.FINANCE_PROP_SET_PAGE + "?matchType=" + // matchType; // } // else if(matchType.equals(WebAttrConstant.MATCH_MODE_LC)) {//低值易耗资产确认 // String [] systemIds=req.getParameterValues("systemId"); // etsItemMatchRecDAO.confirmLCAssets(systemIds); // forwardURL = URLDefineList.FINANCE_PROP_SET_PAGE + "?matchType=" + // matchType; // } // else if(matchType.equals(WebAttrConstant.MATCH_MODE_CT)) {//村通资产确认 // String [] systemIds=req.getParameterValues("systemId"); // etsItemMatchRecDAO.confirmCTAssets(systemIds); // forwardURL = URLDefineList.FINANCE_PROP_SET_PAGE + "?matchType=" + // matchType; // } else { etsItemMatchRecDAO.saveDTOs(dtos); if (matchType.equals(WebAttrConstant.MATCH_MODE_PRJMTL) || matchType.equals(WebAttrConstant.MATCH_MODE_PRJMTL_RET)) { DTOSet dtoes = this.getSystemIds(req); etsItemMatchRecDAO.getDistributePrj(dtoParameter.getPrjId(), dtoes); } forwardURL = URLDefineList.TF_FINANCE_PROP_SET_SERVLET + "?act=" + WebActionConstant.QUERY_ACTION + "&matchType=" + matchType; } } else { message = getMessage(MsgKeyConstant.INVALID_REQ); message.setIsError(true); forwardURL = MessageConstant.MSG_PRC_SERVLET; } } catch (PoolPassivateException ex) { ex.printLog(); message = getMessage(MsgKeyConstant.POOL_PASSIVATE_ERROR); message.setIsError(true); forwardURL = MessageConstant.MSG_PRC_SERVLET; } catch (DataHandleException ex) { ex.printLog(); message = getMessage(MsgKeyConstant.DTO_ERROR); message.setIsError(true); forwardURL = MessageConstant.MSG_PRC_SERVLET; } catch (DTOException ex) { ex.printLog(); message = getMessage(MsgKeyConstant.DTO_ERROR); message.setIsError(true); forwardURL = MessageConstant.MSG_PRC_SERVLET; } catch (QueryException ex) { ex.printLog(); message = getMessage(MsgKeyConstant.QUERY_ERROR); message.setIsError(true); forwardURL = MessageConstant.MSG_PRC_SERVLET; } catch (StrException ex) { ex.printLog(); message = getMessage(MsgKeyConstant.COMMON_ERROR); message.setIsError(true); forwardURL = MessageConstant.MSG_PRC_SERVLET; } catch (UploadException ex) { // 请根据实际情况处理消息 forwardURL = "保持界面录入的数据,返回到原页面,并显示上面给出的消息"; } catch (SQLException e) { e.printStackTrace(); } finally { DBManager.closeDBConnection(conn); setHandleMessage(req, message); ServletForwarder forwarder = new ServletForwarder(req, res); forwarder.forwardView(forwardURL); // 根据实际情况修改页面跳转代码。 } }