/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.mole.struts.action;

import java.util.ArrayList;

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.dao.DBConnector;

/**
 * MyEclipse Struts Creation date: 11-23-2007
 * 
 * @author ruzhenchao XDoclet definition:
 * @struts.action validate="true"
 */
public class MerchantGetVouchersInfoAction 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");
		DBConnector db = new DBConnector();
		String sql = "select ID,StoreID,Name,Amount,Description,Discount,Transfer,State from MerchantVoucher "
				+ " where StoreID='" + storeId + "'";
		ArrayList<Object[]> list = null;
		try {
			list = db.executeQuery(sql.toString());
		} catch (Exception e) {
			e.printStackTrace();
		}
		request.setAttribute("VoucherInfo", list);
		return mapping.findForward("goMerchantGiveVouchers");
	}
}