/*
 * 作者:李斌
 * 時間:2007年12月11日
 * 功能:創(chuàng)建用戶群
 */
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: 12-11-2007 Creator: Li Bin XDoclet
 * definition:
 * 
 * @struts.action input="/customerGroupModify.jsp" validate="true"
 * @struts.action-forward name="goModify" path="/customerGroupModify.jsp"
 */
public class CustomerGroupModifyAction 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) {
		// TODO Auto-generated method stub
		DBConnector dbc = new DBConnector();
		String action = request.getParameter("action");
		String groupID = request.getParameter("groupID");
		String sql;
		// 獲取群信息
		if ("getGroupInfo".equals(action)) {
			ArrayList<Object[]> list = null;
			sql = "select [ID],[Name],[KeyWord],[Description],[GroupImage] from [CustomerGroup] where [ID]="
					+ groupID;
			try {
				list = dbc.executeQuery(sql);
			} catch (Exception e) {
				e.printStackTrace();
			}
			request.setAttribute("GroupInfo", list);
			return mapping.findForward("goModify");
		}
		// 修改群信息
		if ("modify".equals(action)) {
			String groupName = request.getParameter("groupName");
			String groupKey = request.getParameter("groupKeyWord");
			String groupDesc = request.getParameter("groupDesc");
			String groupImage = request.getParameter("image");
			if (groupDesc == null)
				groupDesc = "";
			if (groupImage == null) {
				sql = "update [CustomerGroup] set [Name]=?,[KeyWord]=?,[Description]=? where [ID]=?";
				try {
					dbc.executeUpdate(sql, groupName, groupKey, groupDesc,
							groupID);
				} catch (Exception e) {
					e.printStackTrace();
				}
			} else {
				sql = "update [CustomerGroup] set [Name]=?,[KeyWord]=?,[Description]=?,[GroupImage]=? where [ID]=?";
				try {
					dbc.executeUpdate(sql, groupName, groupKey, groupDesc,
							groupImage, groupID);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
			return new ActionForward(
					"/customerGroupModify.do?action=getGroupInfo&groupID="
							+ groupID);
		}
		return null;
	}
}