merchantbizgroupowneraction.java

基于struts的网上商店源码

/*
 * 作者:刘云云
 * 时间:2007年11月28日
 * 功能:我的商业合作-＞我发起的商圈
 * 查看自已发起的商圈
 */
package com.mole.struts.action;

import java.text.SimpleDateFormat;
import java.util.Date;

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.MerchantBizGroupInfoBean;
import com.mole.struts.dao.DBConnector;
import com.mole.struts.dao.MerchantBizGroupOwnerDAO;
import com.mole.struts.form.MerchantBizGroupOwnerForm;

/**
 * MyEclipse Struts Creation date: 11-28-2007
 * 
 * XDoclet definition:
 */
public class MerchantBizGroupOwnerAction 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("new")) { // 获取显示自已发起的商圈页面
			forward = newOwnBizGroup(mapping, form, request);
		} else if (action.equals("modify")) {// 获取修改自已发起的商圈页面
			forward = modifyBizGroup(mapping, form, request);
		} else if (action.equals("detail")) {// 获取自已发起的商圈详情页面
			forward = detailBizGroup(mapping, form, request);
		} else if (action.equals("launch")) {// 显示发起一条新商圈页面
			forward = launchBizGroup(mapping, form, request);
		} else if (action.equals("start")) {// 运营自已发起的商圈
			forward = startBizGroup(mapping, form, request);
		} else if (action.equals("cancel")) {// 结束自已发起的商圈
			forward = cancelBizGroup(mapping, form, request);
		} else if (action.equals("delete")) {// 删除自已发起的商圈
			forward = deleteBizGroup(mapping, form, request);
		} else if (action.equals("save")) {// 修改一条自已发起的商圈
			MerchantBizGroupOwnerDAO dao = new MerchantBizGroupOwnerDAO();
			dao.updateBizGroupInfo((MerchantBizGroupOwnerForm) form);
			forward = new ActionForward("/merchantBizGroupOwner.do?action=new");
		} else if (action.equals("insert")) {// 发起一条新商圈
			String storeID = (String) request.getSession()
					.getAttribute("store");
			MerchantBizGroupOwnerForm bglForm = (MerchantBizGroupOwnerForm) form;
			try {
				new DBConnector().executeStoredProcedure(
						"sp_CreateBizGroupActivity(?,?,?,?,?,?,?)", storeID,
						bglForm.getName(), bglForm.getActivityId(), bglForm
								.getStartDate(), bglForm.getEndDate(), bglForm
								.getDescription(), bglForm.getActivityDes());
			} catch (Exception e) {
				e.printStackTrace();
			}
			return new ActionForward("/merchantBizGroupOwner.do?action=new");
		}
		return forward;
	}

	public ActionForward deleteBizGroup(ActionMapping mapping, ActionForm form,
			HttpServletRequest request) {
		String id = request.getParameter("id");
		String sql = "UPDATE BizGroup SET state=3 WHERE ID=" + id;
		MerchantBizGroupOwnerDAO dao = new MerchantBizGroupOwnerDAO();
		dao.executeUpdate(sql);
		return new ActionForward("/merchantBizGroupOwner.do?action=new");
	}

	public ActionForward startBizGroup(ActionMapping mapping, ActionForm form,
			HttpServletRequest request) {
		String id = request.getParameter("id");
		String sql = "UPDATE BizGroup SET state=1 WHERE ID=" + id;
		MerchantBizGroupOwnerDAO dao = new MerchantBizGroupOwnerDAO();
		dao.executeUpdate(sql);
		return new ActionForward("/merchantBizGroupOwner.do?action=new");
	}

	public ActionForward cancelBizGroup(ActionMapping mapping, ActionForm form,
			HttpServletRequest request) {
		String id = request.getParameter("id");
		try {
			new DBConnector().executeStoredProcedure(
					"sp_EndBizGroupActivity(?)", id);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return new ActionForward("/merchantBizGroupOwner.do?action=new");
	}

	public ActionForward detailBizGroup(ActionMapping mapping, ActionForm form,
			HttpServletRequest request) {
		request.setAttribute("page", "detail");
		MerchantBizGroupOwnerDAO dao = new MerchantBizGroupOwnerDAO();
		String sql = "select ID,Name,Description,StartDate,EndDate,State,activityId,activityDes,image from BizGroup where ID='"
				+ request.getParameter("id") + "'";
		request.setAttribute("bizGroupInfo", dao.getBizGroupInfo(sql));
		request.getSession().setAttribute("BizGroupID",
				request.getParameter("id"));
		return mapping.findForward("goMerchantBizGroupLaunch");
	}

	public ActionForward modifyBizGroup(ActionMapping mapping, ActionForm form,
			HttpServletRequest request) {
		request.setAttribute("page", "modify");
		MerchantBizGroupOwnerDAO dao = new MerchantBizGroupOwnerDAO();
		String sql = "select ID,Name,Description,StartDate,EndDate,State,activityId,activityDes,image from BizGroup where ID='"
				+ request.getParameter("id") + "'";
		request.setAttribute("bizGroupInfo", dao.getBizGroupInfo(sql));
		request.getSession().setAttribute("BizGroupID",
				request.getParameter("id"));
		return mapping.findForward("goMerchantBizGroupLaunch");
	}

	public ActionForward launchBizGroup(ActionMapping mapping, ActionForm form,
			HttpServletRequest request) {

		request.setAttribute("page", "launch");
		MerchantBizGroupInfoBean bizGroupInfo = new MerchantBizGroupInfoBean();
		bizGroupInfo.setName("");
		bizGroupInfo.setActivityDes("");
		bizGroupInfo.setDescription("");

		Date currentDate = new Date();
		SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
		String dateString = formatter.format(currentDate);
		bizGroupInfo.setStartDate(dateString);
		currentDate.setMonth(currentDate.getMonth() + 1);
		dateString = formatter.format(currentDate);
		bizGroupInfo.setEndDate(dateString);

		bizGroupInfo.setActivityId("1");
		request.setAttribute("bizGroupInfo", bizGroupInfo);
		return mapping.findForward("goMerchantBizGroupLaunch");
	}

	public ActionForward newOwnBizGroup(ActionMapping mapping, ActionForm form,
			HttpServletRequest request) {
		String storeId = (String) request.getSession().getAttribute("store");

		MerchantBizGroupInfoBean[] records = null;

		MerchantBizGroupOwnerDAO dao = null;
		Object daoObj = request.getSession().getAttribute("pageDataRecord");
		if (daoObj != null && daoObj instanceof MerchantBizGroupOwnerDAO) {
			dao = (MerchantBizGroupOwnerDAO) daoObj;
		} else {
			String column = " Name,ActivityDes,StartDate,EndDate,State,activityId,ID,ISNULL(attCount,'0'),ISNULL(appCount,'0') ";
			String where = " v_BizGroupOwner WHERE StoreID=" + storeId;
			dao = new MerchantBizGroupOwnerDAO(column, where, " ID ", null,
					" ID ", 10);
			request.getSession().setAttribute("pageDataRecord", dao);
		}

		MerchantBizGroupOwnerForm mForm = (MerchantBizGroupOwnerForm) form;
		String pageIndex = mForm.getPageIndex();
		if (pageIndex != null && !pageIndex.equals("")) {
			dao.setPageSize(Integer.parseInt(mForm.getPageSizeSelect()));
			dao.setCurrentPage(Integer.parseInt(pageIndex));
			dao.setWhere(storeId, mForm.getActivityType());
		}

		records = dao.getBizGroupInfoPage(storeId);
		request.setAttribute("result", records);
		return mapping.findForward("goMerchantBizGroupOwner");
	}
}