merchantgoodssalerecordaction.java

基于struts的网上商店源码

/*
 * 作者:刘云云
 * 时间:2007年11月09日
 * 功能:库存销售管理-＞商品管理-＞商品销售查询
 * 商家操作人员需要就商品，时间等维度进行查询
 */
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.MerchantGoodsSaleRecordBean;
import com.mole.struts.bean.MerchantGoodsStorageBean;
import com.mole.struts.bean.MerchantGoodsTypeBean;
import com.mole.struts.dao.MerchantGoodsSaleRecordDAO;
import com.mole.struts.dao.MerchantGoodsStorageDAO;
import com.mole.struts.form.MerchantGoodsSaleRecordForm;

/**
 * MyEclipse Struts Creation date: 11-09-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 * @struts.action-forward name="goBusinessRecord" path="/businessRecord.jsp"
 */
public class MerchantGoodsSaleRecordAction 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 = request.getParameter("slaveStoreId");
		if (storeId != null && storeId != "") {
			request.setAttribute("slaveStoreId", storeId);
		} else {
			storeId = (String) request.getSession().getAttribute("store");
			if (storeId == null)
				return null;
		}

		MerchantGoodsSaleRecordBean[] records = null;
		MerchantGoodsSaleRecordForm mgsrForm = (MerchantGoodsSaleRecordForm) form;
		MerchantGoodsSaleRecordDAO dao = null;
		Object daoObj = request.getSession().getAttribute("pageDataRecord");
		if (daoObj != null && daoObj instanceof MerchantGoodsSaleRecordDAO) {
			dao = (MerchantGoodsSaleRecordDAO) daoObj;
		} else {
			String column = " name ,sum(amount) amount, sum(amount*price) price ,goodsNumber,typeName";
			dao = new MerchantGoodsSaleRecordDAO(column, null, " name ",
					"typeName, name,goodsNumber ", " goodsNumber ", 10);
			dao.setWhere(" v_GoodsSaleRecord ", storeId, mgsrForm.getTypeId(),
					mgsrForm.getGoodsName(), null, null);
			request.getSession().setAttribute("pageDataRecord", dao);
		}

		String pageIndex = mgsrForm.getPageIndex();
		if (pageIndex != null && !pageIndex.equals("")) {
			dao.setCurrentPage(Integer.parseInt(pageIndex));
			dao.setPageSize(Integer.parseInt(mgsrForm.getPageSizeSelect()));
			dao.setWhere(" v_GoodsSaleRecord ", storeId, mgsrForm.getTypeId(),
					mgsrForm.getGoodsName(), mgsrForm.getStartDate(), mgsrForm
							.getEndDate());
		}
		MerchantGoodsStorageDAO mbrd = new MerchantGoodsStorageDAO();
		String sql = "SELECT Name,GoodsType,GoodsNumber FROM Goods WHERE StoreID="
				+ storeId;
		MerchantGoodsStorageBean[] arrayList = mbrd.getGoodsStorageName(sql);
		request.setAttribute("names", arrayList);

		sql = "SELECT ID,Name FROM GoodsType WHERE StoreID=" + storeId;
		MerchantGoodsTypeBean[] types = mbrd.getGoodsType(sql);
		request.setAttribute("types", types);

		records = dao.getBusinessRecordPage();
		request.setAttribute("result", records);
		return mapping.findForward("goGoodsSaleRecord");
	}
}