/*
 * 作者:劉云云
 * 時間:2007年12月22日
 * 功能:平臺基礎信息維護-開通城市（所在城市）地區的添加和刪除修改。
 */
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.AdminAreaInfoBean;
import com.mole.struts.dao.AdminAreaInfoDAO;

/**
 * MyEclipse Struts Creation date: 12-22-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 * @struts.action-forward name="goAdminAreaAdd" path="/adminAreaAdd.jsp"
 * @struts.action-forward name="goAdminAreaInfo" path="/adminAreaInfo.jsp"
 */
public class AdminAreaInfoAction 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) {
		AdminAreaInfoDAO dao = new AdminAreaInfoDAO();

		String action = request.getParameter("action");
		if (action == null || action.equals("show")) {// 獲取瀏覽開通城市地區頁面

			String cityId = request.getParameter("cityId");
			String provinceId = request.getParameter("provinceId");
			String sql = "SELECT ID,name FROM area WHERE cityId=" + cityId;
			AdminAreaInfoBean[] areaInfo = dao.getAllAreaInfo(sql);

			request.setAttribute("provinceId", provinceId);
			request.setAttribute("cityId", cityId);
			request.setAttribute("areaInfo", areaInfo);
			return mapping.findForward("goAdminAreaInfo");

		} else if (action.equals("add")) {// 獲取添加開通城市地區頁面
			String cityId = request.getParameter("cityId");
			String provinceId = request.getParameter("provinceId");
			request.setAttribute("provinceId", provinceId);

			request.setAttribute("cityId", cityId);
			request.setAttribute("pageAction", "add");
			return mapping.findForward("goAdminAreaAdd");

		} else if (action.equals("modify")) {// 獲取修改開通城市地區頁面
			String cityId = request.getParameter("cityId");
			String provinceId = request.getParameter("provinceId");
			String areaId = request.getParameter("areaId");

			request.setAttribute("provinceId", provinceId);
			request.setAttribute("cityId", cityId);
			request.setAttribute("areaId", areaId);
			request.setAttribute("pageAction", "modify");

			return mapping.findForward("goAdminAreaAdd");
		} else if (action.equals("onModify")) {// 修改一條開通城市地區記錄
			String cityId = request.getParameter("cityId");
			String provinceId = request.getParameter("provinceId");
			String areaName = request.getParameter("areaName");
			String areaId = request.getParameter("areaId");

			String sql = "UPDATE Area SET Name='" + areaName + "' WHERE ID="
					+ areaId;
			dao.executeUpdate(sql);
			return new ActionForward("/adminAreaInfo.do?action=show&cityId="
					+ cityId + "&provinceId=" + provinceId);
		} else if (action.equals("onAdd")) {// 添加一條開通城市地區記錄
			String cityId = request.getParameter("cityId");
			String provinceId = request.getParameter("provinceId");
			String areaName = request.getParameter("areaName");
			String sql = "SELECT max(ID) FROM area where cityId=" + cityId;
			int id = Integer.parseInt(dao.getMaxAreaId(sql).substring(4, 6)) + 1;
			String areaId = cityId + (id < 10 ? "0" + id : id);
			sql = "INSERT Area(ID,provinceId,cityId,Name) VALUES('" + areaId
					+ "','" + provinceId + "','" + cityId + "','" + areaName
					+ "')";
			dao.executeUpdate(sql);
			return new ActionForward("/adminAreaInfo.do?action=show&cityId="
					+ cityId + "&provinceId=" + provinceId);

		} else if (action.equals("delete")) {// 刪除一條開通城市地區記錄
			String cityId = request.getParameter("cityId");
			String provinceId = request.getParameter("provinceId");

			String sql = "DELETE FROM Area WHERE ID="
					+ request.getParameter("id");
			dao.executeUpdate(sql);
			return new ActionForward("/adminAreaInfo.do?action=show&cityId="
					+ cityId + "&provinceId=" + provinceId);
		}
		return null;
	}
}