merchantbusinessrecordaction.java

基于struts的网上商店源码

/*
 * 作者:管磊
 * 时间:12-05-2007
 * 功能:商家交易记录查询
 */
package com.mole.struts.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.mole.struts.bean.MerchantBusinessRecordBean;
import com.mole.struts.bean.Page;
import com.mole.struts.bean.merchantBusinessRecordDetailBean;
import com.mole.struts.dao.MerchantBusinessRecordDAO;

/**
 * MyEclipse Struts Creation date: 12-05-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 */
public class MerchantBusinessRecordAction extends Action {
	/*
	 * Generated Methods
	 */
	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {

		String storeId = (String) request.getSession().getAttribute("store");

		String action = request.getParameter("action");
		if (action == null) {// 笼统的查询
			String startTime = request.getParameter("startTime");
			String endTime = request.getParameter("endTime");
			String customerId = request.getParameter("customerId");
			if (startTime == null || startTime.equals(""))
				startTime = null;
			if (endTime == null || endTime.equals(""))
				endTime = null;
			if (customerId == null || customerId.equals(""))
				customerId = null;

			String where = null;
			if (startTime == null && endTime == null && customerId == null)
				where = "where storeid='" + storeId + "'";// 只有商家条件查询
			else if (startTime == null && endTime == null && customerId != null)
				where = " where [CustomerId]=" + customerId
						+ " and [storeid]='" + storeId + "'";// 有会员条件
			else if (startTime != null && endTime != null && customerId == null)
				where = " where  [storeId]='" + storeId + "' and  dealtime>'"
						+ startTime + "' and " + "dealtime<'" + endTime + "' ";// 有时间限制没有会员条件
			else if (startTime != null && endTime != null && customerId != null)
				where = " where [storeid]='" + storeId
						+ "' and dealtime>'"// 所有条件具有的查询。
						+ startTime + "' and " + " dealtime<'" + endTime
						+ "' and CustomerId=" + customerId;

			MerchantBusinessRecordDAO dao = new MerchantBusinessRecordDAO();
			Page page = new Page();// 分页查询操作。
			int pageSize = (request.getParameter("pageSizeSelect") == null ? 10
					: Integer.parseInt(request.getParameter("pageSizeSelect")));
			int currentPage = (request.getParameter("page") == null ? 1
					: Integer.parseInt(request.getParameter("page")));

			int count = dao.getPageInfo(where);
			page.setPageSize(pageSize);
			page.setRecordCount(count);
			page.setPageCount((count + pageSize - 1) / pageSize);
			page.setCurrentPage(currentPage);
			MerchantBusinessRecordBean[] result = null;
			try {// 从数据库中查询数据
				result = dao.BusinessReocrdQuery(where, page.getPageSize(),
						page.getCurrentPage());
			} catch (Exception e) {
				e.printStackTrace();
			}
			request.setAttribute("businessRecord", result);
			request.setAttribute("Page", page);
			return mapping.findForward("goMerchantBusinessRecord");

		} else if (action.equals("detail")) {// 交易记录的详细信息。
			merchantBusinessRecordDetailBean[] result = null;
			MerchantBusinessRecordDAO dao = new MerchantBusinessRecordDAO();
			try {
				result = dao.getRecordDetail(request.getParameter("swiftId"));// 根据交易的流水号。
			} catch (Exception e) {
				e.printStackTrace();
				HttpSession session = request.getSession();
				session.setAttribute("title", "错误信息");
				session.setAttribute("message", "用户名或密码错误，请重新登陆！");
				session.setAttribute("returnUrl", "show.do?action=goLogin");
				return mapping.findForward("goMessage");
			}
			request.setAttribute("list", result);
			return mapping.findForward("goMerchantBusinessRecordDetail");
		}

		return null;
	}
}