merchantgoodsstorageaction.java

基于struts的网上商店源码

/*
 * 作者:刘云云
 * 时间:2007年12月06日
 * 功能:库存销售管理-＞商品管理-＞库存商品查询。
 * 库存商品的分类浏览以及查询等功能
 */
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.MerchantGoodsStorageBean;
import com.mole.struts.bean.MerchantGoodsTypeBean;
import com.mole.struts.dao.MerchantGoodsStorageDAO;

/**
 * MyEclipse Struts Creation date: 11-11-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 */
public class MerchantGoodsStorageAction 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 = (String) request.getParameter("action");

		if (action == null || action.equals("record")) {// 获取浏览库存商品页面
			forward = storageRecord(mapping, form, request);
		} else if (action.equals("manage")) {// 获取商品入库操作页面
			forward = storageManage(mapping, form, request);
		} else if (action.equals("add")) {// 添加库存商品
			forward = storageManageAdd(mapping, form, request);
		}
		return forward;
	}

	// 添加库存商品
	public ActionForward storageManageAdd(ActionMapping mapping,
			ActionForm form, HttpServletRequest request) {
		String storeId = (String) request.getSession().getAttribute("store");
		String resultList = request.getParameter("resultList");
		String[] data = resultList.split(",");
		int len = (data.length - 1) / 3;

		String[] goodsNames = new String[len];
		String[] amounts = new String[len];
		String[] prices = new String[len];
		for (int i = 0; i < len; i++) {
			goodsNames[i] = data[3 * i + 1];
			amounts[i] = data[3 * i + 2];
			prices[i] = data[3 * i + 3];
		}
		try {
			String user = (String) request.getSession().getAttribute("user");
			new MerchantGoodsStorageDAO().executeStoredProcedure(storeId, user,
					goodsNames, amounts, prices);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return storageManage(mapping, form, request);
	}

	// 获取商品入库操作页面
	public ActionForward storageManage(ActionMapping mapping, ActionForm form,
			HttpServletRequest request) {
		String storeId = (String) request.getSession().getAttribute("store");
		if (storeId == null)
			return null;

		String sql = "SELECT Name,GoodsType,GoodsNumber FROM Goods WHERE StoreID="
				+ storeId;
		MerchantGoodsStorageDAO dao = new MerchantGoodsStorageDAO();
		MerchantGoodsStorageBean[] result = dao.getGoodsStorageName(sql);

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

		request.setAttribute("result", result);
		return mapping.findForward("goMerchantGoodsStorageManage");
	}

	// 获取浏览库存商品页面
	public ActionForward storageRecord(ActionMapping mapping, ActionForm form,
			HttpServletRequest request) {

		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;
		}

		MerchantGoodsStorageBean[] records = null;
		MerchantGoodsStorageDAO dao = null;
		Object daoObj = request.getSession().getAttribute("pageDataRecord");
		if (daoObj != null && daoObj instanceof MerchantGoodsStorageDAO) {
			dao = (MerchantGoodsStorageDAO) daoObj;
		} else {
			String column = " goodsNumber,name,typeName,amount,lastStockAmount,totalAmount,stockDate ";
			dao = new MerchantGoodsStorageDAO(column, null, " ID ", null,
					" ID ", 10);
			dao.setWhere(" v_goodsStorage ", storeId, request
					.getParameter("typeId"), request.getParameter("goodsName"));
			request.getSession().setAttribute("pageDataRecord", dao);
		}

		String pageIndex = (String) request.getParameter("pageIndex");
		if (pageIndex != null && !pageIndex.equals("")) {
			dao.setCurrentPage(Integer.parseInt(pageIndex));
			dao.setPageSize(Integer.parseInt(request
					.getParameter("pageSizeSelect")));
			dao.setWhere(" v_goodsStorage ", storeId, request
					.getParameter("typeId"), request.getParameter("goodsName"));
		}
		String sql = "SELECT ID,Name FROM GoodsType WHERE StoreID=" + storeId;
		MerchantGoodsTypeBean[] types = dao.getGoodsType(sql);
		request.setAttribute("types", types);

		sql = "SELECT Name,GoodsType,GoodsNumber FROM Goods WHERE StoreID="
				+ storeId;
		MerchantGoodsStorageBean[] names = dao.getGoodsStorageName(sql);
		request.setAttribute("names", names);

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