/*
 * 作者:荊明君
 * 時間:2007年12月15日
 * 功能:平臺操作人員管理-添加刪除和瀏覽平臺操作人員(賬戶管理)。
 */
package com.mole.struts.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

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.AdminMemberBean;
import com.mole.struts.dao.AdminMemberDAO;
import com.mole.struts.form.AdminMemberForm;

/**
 * MyEclipse Struts Creation date: 12-15-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action path="/adminMemberInfo" name="adminMemberInfoForm"
 *                input="/adminMemberInfo.jsp" scope="request" validate="true"
 */
public class AdminMemberAction 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 loginId = (String) request.getSession().getAttribute("user");
		AdminMemberDAO dao = new AdminMemberDAO();
		if (!dao.checkRole(loginId)) {
			HttpSession session = request.getSession();
			session.setAttribute("title", "錯誤信息");
			session.setAttribute("message", "你無權限或訪問失敗！");
			session.setAttribute("returnUrl", "show.do?action=null");
			return mapping.findForward("goMessage");
		}

		ActionForward forward = null;

		String action = request.getParameter("action");
		if (action == null || action.equals("show")) {// 獲取瀏覽平臺操作人員賬戶頁面
			AdminMemberBean[] memberInfo = dao.getMemberInfo(loginId);
			request.setAttribute("memberInfo", memberInfo);
			forward = mapping.findForward("goAdminMember");
		} else if (action.equals("modify")) {// 獲取修改平臺操作人員賬戶頁面
			AdminMemberBean memberDetail = dao.getMemberDetail(request
					.getParameter("memberId"));
			request.setAttribute("memberDetail", memberDetail);
			forward = mapping.findForward("goAdminMemberDetail");
		} else if (action.equals("delete")) {// 刪除一條平臺操作人員賬戶記錄
			String sql = "DELETE FROM [administrator] WHERE ID="
					+ request.getParameter("memberId");
			dao.executeUpdate(sql);
			forward = new ActionForward("/adminMember.do?action=show");
		} else if (action.equals("add")) {// 獲取添加平臺操作人員賬戶頁面
			forward = mapping.findForward("goAdminMemberAdd");
		} else if (action.equals("onAdd")) {// 添加一條平臺操作人員賬戶記錄
			AdminMemberForm aForm = (AdminMemberForm) form;
			String sql = "INSERT INTO [Administrator] ([loginName],[password],[Role],[State],[Name],[Gender],[Email],[Telephone],[Cellphone],[Address])"
					+ "VALUES('"
					+ aForm.getLoginName()
					+ "','"
					+ aForm.getNewPassword()
					+ "','"
					+ aForm.getRole()
					+ "','"
					+ aForm.getState()
					+ "','"
					+ aForm.getName()
					+ "','"
					+ aForm.getGender()
					+ "','"
					+ aForm.getEmail()
					+ "','"
					+ aForm.getTelephone()
					+ "','"
					+ aForm.getCellphone()
					+ "','" + aForm.getAddress() + "')";
			dao.executeUpdate(sql);
			forward = new ActionForward("/adminMember.do?action=show");
		} else if (action.equals("onModify")) {// 修改一條平臺操作人員賬戶記錄
			AdminMemberForm aForm = (AdminMemberForm) form;
			String sql = "UPDATE [Administrator] SET role=" + aForm.getRole()
					+ ",state=" + aForm.getState() + " WHERE ID="
					+ request.getParameter("memberId");
			dao.executeUpdate(sql);
			forward = new ActionForward("/adminMember.do?action=show");
		}
		return forward;
	}
}