/**
* @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);
// 根据实际情况修改页面跳转代码。
}
}
public void performTask(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
String forwardURL = "";
Message message = SessionUtil.getMessage(req);
Connection conn = null;
try {
conn = getDBConnection(req);
SfUserDTO user = (SfUserDTO) SessionUtil.getUserAccount(req);
Request2DTO req2DTO = new Request2DTO();
req2DTO.setDTOClassName(AmsAssetsCJYCDTO.class.getName());
AmsAssetsCJYCDTO dtoParameter = (AmsAssetsCJYCDTO) req2DTO.getDTO(req);
AmsAssetsQJCJYCDAO dao = new AmsAssetsQJCJYCDAO(user, dtoParameter, conn);
ServletConfigDTO sevletConfig = SessionUtil.getServletConfigDTO(req);
dtoParameter.setFaCategory1(SinoConfig.getFaCat1Mis());
dtoParameter.setFaCategory2(SinoConfig.getFaCat2Mis());
dtoParameter.setFaCategory3(SinoConfig.getFaCat3Mis());
String action = req.getParameter("act");
action = StrUtil.nullToString(action);
OptionProducer op = new OptionProducer(user, conn);
int organizationId = StrUtil.strToInt(dtoParameter.getBookTypeCode());
String companySelect = op.getAllOrganization(organizationId, true);
req.setAttribute("OU", companySelect);
String monthOption = op.getFromMonthOption(dtoParameter.getFromMonth());
String tomonthOption = op.getFromMonthOption(dtoParameter.getToMonth());
String bookTypeCode = dtoParameter.getBookTypeCode();
String bookSelect = op.getAllBookTypeName(bookTypeCode, true);
String catSegment1 = dtoParameter.getCatSegment1();
String catSegment1Servlet = op.getUseField(catSegment1, true);
req.setAttribute("CATSEGMENT1", catSegment1Servlet);
req.setAttribute("BOOK_TYPE_CODE", bookSelect);
req.setAttribute("FROM_MONTH_OPTION", monthOption);
req.setAttribute("TO_MONTH_OPTION", tomonthOption);
req.setAttribute("AMSBJTRANSNOHDTO", dtoParameter);
if (action.equals("")) {
forwardURL = "/newasset/assetsQJCJYC.jsp";
} else if (action.equals(AssetsActionConstant.QUERY_ACTION)) {
BaseSQLProducer sqlProducer = new AmsAssetsQJCJYCModel(user, dtoParameter);
PageQueryDAO pageDAO = new PageQueryDAO(req, conn, sqlProducer);
pageDAO.setCalPattern(LINE_PATTERN);
pageDAO.setCountPages(false);
pageDAO.produceWebData();
req.setAttribute("AMSBJTRANSNOHDTO", dtoParameter);
forwardURL = "/newasset/assetsQJCJYC.jsp";
} else if (action.equals(AssetsActionConstant.EXPORT_ACTION)) {
File file = dao.exportFile();
WebFileDownload fileDown = new WebFileDownload(req, res);
fileDown.setFilePath(file.getAbsolutePath());
fileDown.download();
file.delete();
}
} 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(MsgKeyConstant.QUERY_ERROR);
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 (WebFileDownException ex) {
ex.printLog();
message = getMessage(MsgKeyConstant.COMMON_ERROR);
message.setIsError(true);
forwardURL = MessageConstant.MSG_PRC_SERVLET;
} catch (DataTransException ex) {
ex.printLog();
message = getMessage(MsgKeyConstant.COMMON_ERROR);
message.setIsError(true);
forwardURL = MessageConstant.MSG_PRC_SERVLET;
} finally {
DBManager.closeDBConnection(conn);
setHandleMessage(req, message);
ServletForwarder forwarder = new ServletForwarder(req, res);
forwarder.forwardView(forwardURL);
}
}
/**
* 所有的Servlet都必须实现的方法。
*
* @param req HttpServletRequest
* @param res HttpServletResponse
* @throws ServletException
* @throws IOException
* @todo Implement this com.sino.base.PubServlet method
*/
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(AmsAssetsCheckBatchDTO.class.getName());
AmsAssetsCheckBatchDTO dto = (AmsAssetsCheckBatchDTO) req2DTO.getDTO(req);
String action = dto.getAct();
conn = getDBConnection(req);
AssetsOptProducer optProducer = new AssetsOptProducer(user, conn);
String opt = optProducer.getAllOu(dto.getOrganizationId());
dto.setOrgOpt(opt);
if (dto.getEndDate().getCalendarValue().equals("")) {
dto.setEndDate(CalendarUtil.getCurrDate());
}
if (action.equals(AssetsActionConstant.EXPORT_ACTION)) {
CheckReportDAO rptDAO = new CheckReportDAO(user, dto, conn);
File file = rptDAO.exportCostData();
WebFileDownload fileDown = new WebFileDownload(req, res);
fileDown.setFilePath(file.getAbsolutePath());
fileDown.download();
file.delete();
} 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 (WebFileDownException ex) {
ex.printLog();
message = getMessage(AssetsMessageKeys.COMMON_ERROR);
message.setIsError(true);
forwardURL = MessageConstant.MSG_PRC_SERVLET;
} catch (DataTransException ex) {
ex.printLog();
message = getMessage(AssetsMessageKeys.COMMON_ERROR);
message.setIsError(true);
forwardURL = MessageConstant.MSG_PRC_SERVLET;
} catch (CalendarException ex) {
ex.printLog();
message = getMessage(AssetsMessageKeys.COMMON_ERROR);
message.setIsError(true);
forwardURL = MessageConstant.MSG_PRC_SERVLET;
} finally {
closeDBConnection(conn);
setHandleMessage(req, message);
if (!StrUtil.isEmpty(forwardURL)) {
ServletForwarder forwarder = new ServletForwarder(req, res);
forwarder.forwardView(forwardURL);
}
}
}
public void performTask(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
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);
EamSyschronizeDTO dtoParameter = null; // 声明DTO
Request2DTO req2DTO = new Request2DTO();
req2DTO.setDTOClassName(EamSyschronizeDTO.class.getName());
dtoParameter = (EamSyschronizeDTO) req2DTO.getDTO(req);
conn = getDBConnection(req);
TransStatusDAO eamNewLocusDAO = new TransStatusDAO(user, dtoParameter, conn);
ServletConfigDTO servletConfig = getServletConfig(req);
if (action.equals("")) {
forwardURL = URLDefineList.TRANS_QUERY;
} else if (action.equals(WebActionConstant.QUERY_ACTION)) { // 查询操作
BaseSQLProducer sqlProducer = new TransStatusQueryModel(user, dtoParameter);
PageQueryDAO pageDAO = new PageQueryDAO(req, conn, sqlProducer);
pageDAO.setServletConfig(servletConfig);
pageDAO.setCalPattern(LINE_PATTERN);
pageDAO.produceWebData();
req.setAttribute(WebAttrConstant.SYSCHRONIZE_DTO, dtoParameter);
forwardURL = URLDefineList.TRANS_QUERY;
} else if (action.equals(WebActionConstant.EXPORT_ACTION)) { // 导出Excel
File file = eamNewLocusDAO.getExportFile();
WebFileDownload fileDown = new WebFileDownload(req, res);
fileDown.setFilePath(file.getAbsolutePath());
fileDown.download();
file.delete();
} else if (action.equals(WebActionConstant.DETAIL_ACTION)) {
eamNewLocusDAO.setDTOClassName(EamSyschronizeDTO.class.getName());
String batchId = req.getParameter("id");
dtoParameter.setBatchId(batchId);
eamNewLocusDAO.setCalPattern(CalendarConstant.LINE_PATTERN);
// EamSyschronizeDTO dto = (EamSyschronizeDTO)eamNewLocusDAO.getDataByForeignKey(
// batchId);
// if(dto == null){
// dto = new EamSyschronizeDTO();
// message = getMessage(MsgKeyConstant.DATA_NOT_EXIST);
// message.setIsError(true);
// } else{
// dto = new EamSyschronizeDTO();
// EamSyschronizeDTO orderDTO = new EamSyschronizeDTO();
// orderDTO.setBatchId(dtoParameter.getBatchId());
// TransStatusDAO orderDAO = new TransStatusDAO(user, orderDTO, conn);
// orderDAO.setDTOClassName(EamSyschronizeDTO.class.getName());
// orderDAO.setCalPattern(LINE_PATTERN);
DTOSet orders = (DTOSet) eamNewLocusDAO.getDataByForeignKey(batchId);
req.setAttribute("DTOSET", orders);
// }
// req.setAttribute(WebAttrConstant.SYSCHRONIZE_DTO, dto);
forwardURL = "/synchronize/StatusDetail.jsp";
} else if (action.equals("show")) {
eamNewLocusDAO.setCalPattern(CalendarConstant.LINE_PATTERN);
String logId = req.getParameter("logId");
RowSet rs = eamNewLocusDAO.getLog(logId);
req.setAttribute("DATA", rs);
forwardURL = "/synchronize/logInfo.jsp";
}
} 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 (WebFileDownException e) {
e.printLog();
} catch (DataTransException e) {
e.printLog();
} finally {
DBManager.closeDBConnection(conn);
setHandleMessage(req, message);
ServletForwarder forwarder = new ServletForwarder(req, res);
forwarder.forwardView(forwardURL);
// 根据实际情况修改页面跳转代码。
}
}
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(AmsAssetsCheckHeaderDTO.class.getName());
AmsAssetsCheckHeaderDTO dto = (AmsAssetsCheckHeaderDTO) req2DTO.getDTO(req);
String action = dto.getAct();
conn = getDBConnection(req);
NewAssetsReportDeptDAO rptDAO = new NewAssetsReportDeptDAO(user, dto, conn);
if (action.equals("")) {
req.setAttribute(QueryConstant.QUERY_DTO, dto);
forwardURL = AssetsURLList.NEW_FA_REPORT_DEPT;
} else if (action.equals(AssetsActionConstant.QUERY_ACTION)) {
BaseSQLProducer sqlProducer = new NewAssetsReportDeptModel(user, dto);
PageQueryDAO pageDAO = new PageQueryDAO(req, conn, sqlProducer);
pageDAO.setPageSize(23);
pageDAO.setCalPattern(LINE_PATTERN);
pageDAO.produceWebData();
req.setAttribute(QueryConstant.QUERY_DTO, dto);
forwardURL = AssetsURLList.NEW_FA_REPORT_DEPT;
} else if (action.equals(AssetsActionConstant.EXPORT_ACTION)) {
File file = rptDAO.getExportFile();
WebFileDownload fileDown = new WebFileDownload(req, res);
fileDown.setFilePath(file.getAbsolutePath());
fileDown.download();
file.delete();
} 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 (WebFileDownException ex) {
ex.printLog();
message = getMessage(AssetsMessageKeys.COMMON_ERROR);
message.setIsError(true);
forwardURL = MessageConstant.MSG_PRC_SERVLET;
} catch (DataTransException ex) {
ex.printLog();
message = getMessage(AssetsMessageKeys.COMMON_ERROR);
message.setIsError(true);
forwardURL = MessageConstant.MSG_PRC_SERVLET;
} finally {
closeDBConnection(conn);
setHandleMessage(req, message);
if (!StrUtil.isEmpty(forwardURL)) {
ServletForwarder forwarder = new ServletForwarder(req, res);
forwarder.forwardView(forwardURL);
}
}
}