merchantbizgroupmemberaction.java

基于struts的网上商店源码

/*
 * 作者:刘云云
 * 时间:2007年11月21日
 * 功能:显示商圈的商家成员
 */
package com.mole.struts.action;

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

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.MerchantBizGroupMemberBean;
import com.mole.struts.bean.MerchantVoucherBean;
import com.mole.struts.dao.MerchantBizGroupMemberDAO;
import com.mole.struts.dao.MerchantVoucherProvideDAO;
import com.mole.struts.form.MerchantBizGroupMemberForm;

/**
 * MyEclipse Struts Creation date: 11-21-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 */

public class MerchantBizGroupMemberAction 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) {
		ActionForward forward = null;
		String action = request.getParameter("action");
		if (action == null || action.equals("show")) {// 获取商圈成员的页面
			forward = showMemberInfo(mapping, form, request);
		} else if (action.equals("cancel")) {// 结束某个商圈成员
			String storeId = request.getParameter("storeId");
			String bizgroupId = request.getParameter("bizgroupId");
			String sql = "UPDATE bizGroupMember SET state=2 WHERE BizGroupId='"
					+ bizgroupId + "' AND StoreId='" + storeId + "'";
			MerchantBizGroupMemberDAO dao = (MerchantBizGroupMemberDAO) request
					.getSession().getAttribute("pageDataRecord");
			dao.executeUpdate(sql);
			forward = showMemberInfo(mapping, form, request);
		} else if (action.equals("provide")) {// 获取设置某个商圈成员的商圈活动的页面
			String activityId = request.getParameter("activityId");
			request.setAttribute("bizgroupId", request
					.getParameter("bizgroupId"));
			request.setAttribute("attStoreId", request.getParameter("storeId"));

			if (activityId.equals("1")) {// 积分互认活动
				return mapping.findForward("goMerchantBGScoreDiscountPro");
			} else if (activityId.equals("2")) {// 代发优惠券活动
				String storeId = (String) request.getSession().getAttribute(
						"store");
				String sql = "SELECT ID,name,amount,discount FROM merchantVoucher WHERE type=1 AND StoreId="
						+ storeId;
				MerchantVoucherBean[] result = new MerchantVoucherProvideDAO()
						.getVoucherInfo(sql);
				request.setAttribute("result", result);
				return mapping.findForward("goMerchantBGVoucherPro");
			} else if (activityId.equals("3")) {// 共同承诺折扣活动
				return mapping.findForward("goMerchantBGDiscountPro");
			}
		} else if (action.equals("onProvide")) {// 设置某个商圈成员的商圈活动
			MerchantBizGroupMemberForm aForm = (MerchantBizGroupMemberForm) form;
			MerchantBizGroupMemberDAO dao = (MerchantBizGroupMemberDAO) request
					.getSession().getAttribute("pageDataRecord");

			request.setAttribute("bizgroupId", aForm.getBizgroupId());
			request.setAttribute("attStoreId", aForm.getAttStoreId());
			request.setAttribute("activityId", aForm.getActivityId());

			if (aForm.getActivityId().equals("1")) {// 积分互认活动
				try {
					dao.executeScoreDiscountPro(aForm.getBizgroupId(), aForm
							.getStoreA(), aForm.getScoreA(), aForm
							.getDiscountA(), aForm.getStoreB(), aForm
							.getScoreB(), aForm.getDiscountB());
				} catch (Exception e) {
					e.printStackTrace();
				}
			} else if (aForm.getActivityId().equals("2")) {// 代发优惠券活动
				try {
					dao.executeVoucherPro(aForm.getBizgroupId(), aForm
							.getAttStoreId(), aForm.getVoucherId(), aForm
							.getAmount());
				} catch (Exception e) {
					e.printStackTrace();
				}
			} else if (aForm.getActivityId().equals("3")) {// 共同承诺折扣活动
				try {
					dao.executeDiscountPro(aForm.getBizgroupId(), aForm
							.getAttStoreId(), aForm.getDiscount());
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
			forward = showMemberInfo(mapping, form, request);
		}

		return forward;
	}

	// 获取商圈成员的信息
	public ActionForward showMemberInfo(ActionMapping mapping, ActionForm form,
			HttpServletRequest request) {
		MerchantBizGroupMemberDAO dao = null;
		MerchantBizGroupMemberBean[] records = null;

		String activityId = request.getParameter("activityId");
		request.setAttribute("activityId", activityId);

		String bizgroupId = request.getParameter("bizgroupId");
		request.setAttribute("bizgroupId", bizgroupId);

		String pageIndex = request.getParameter("pageIndex");
		String pageSizeSelect = request.getParameter("pageSizeSelect");

		if (activityId.equals("1")) {// 积分互认活动
			if (pageIndex == null || pageIndex.equals("")) {
				String column = " storeId, name, telephone,address,description,ISNULL(scoreA,''),ISNULL(discountA,''),ISNULL(scoreB,''),ISNULL(discountB,'') ";
				String where = " v_BGScoreDiscountPro WHERE state=1 AND bizgroupId="
						+ bizgroupId;
				dao = new MerchantBizGroupMemberDAO(column, where, " id ",
						null, " id ", 10);
				request.getSession().setAttribute("pageDataRecord", dao);
				records = dao.getBizGroupScoreDiscountPage();
			} else {
				dao = (MerchantBizGroupMemberDAO) request.getSession()
						.getAttribute("pageDataRecord");
				dao.setCurrentPage(Integer.parseInt(pageIndex));
				dao.setPageSize(Integer.parseInt(pageSizeSelect));
				records = dao.getBizGroupScoreDiscountPage();
			}
		} else if (activityId.equals("2")) {// 代发优惠券活动
			if (pageIndex == null || pageIndex.equals("")) {
				String column = " storeId, name, telephone,address,description,ISNULL(voucherName,''),ISNULL(amount,'') ";
				String where = " v_BGVoucherPro WHERE state=1 AND bizgroupId="
						+ bizgroupId;
				dao = new MerchantBizGroupMemberDAO(column, where, " id ",
						null, " id ", 10);
				request.getSession().setAttribute("pageDataRecord", dao);
				records = dao.getBizGroupVoucherPage();
			} else {
				dao = (MerchantBizGroupMemberDAO) request.getSession()
						.getAttribute("pageDataRecord");
				dao.setCurrentPage(Integer.parseInt(pageIndex));
				dao.setPageSize(Integer.parseInt(pageSizeSelect));
				records = dao.getBizGroupVoucherPage();
			}
		} else if (activityId.equals("3")) {// 共同承诺折扣活动
			if (pageIndex == null || pageIndex.equals("")) {
				String column = " storeId, name, telephone,address,description,ISNULL(discount,'') ";
				String where = " v_BGDiscountPro WHERE state=1 AND bizgroupId="
						+ bizgroupId;
				dao = new MerchantBizGroupMemberDAO(column, where, " id ",
						null, " id ", 10);
				request.getSession().setAttribute("pageDataRecord", dao);
				records = dao.getBizGroupDiscountPage();
			} else {
				dao = (MerchantBizGroupMemberDAO) request.getSession()
						.getAttribute("pageDataRecord");
				dao.setCurrentPage(Integer.parseInt(pageIndex));
				dao.setPageSize(Integer.parseInt(pageSizeSelect));
				records = dao.getBizGroupDiscountPage();
			}
		}
		request.setAttribute("result", records);
		return mapping.findForward("goMerchantBizGroupMember");
	}
}