package com.wy.webtier;

import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForm;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForward;
import com.wy.domain.SmallTypeForm;
import org.apache.struts.action.Action;
import com.wy.dao.SmallTypeDao;
import java.util.List;

//商品小類別信息
public class SmallTypeAction
    extends Action {
  private int action;
  private SmallTypeDao dao = null;
  public ActionForward execute(ActionMapping mapping,
                               ActionForm form,
                               HttpServletRequest request,
                               HttpServletResponse response) {
    action = Integer.parseInt(request.getParameter("action"));
    dao = new SmallTypeDao();
    switch (action) {
      case 0: {
        return smallTypeSelect(mapping, form, request, response); //全部查詢小類別信息
      }
      case 2: {
        return smallTypeInsert(mapping, form, request, response); //添加小類別信息
      }
      case 3: {
        return smallTypeDelete(mapping, form, request, response); //刪除小類別信息
      }
      case 4: {
        return smallTypeSelectOne(mapping, form, request, response); //以數(shù)據(jù)庫流水號為條件查詢小類別信息
      }
      case 5: {
        return smallTypeUpdate(mapping, form, request, response); //以數(shù)據(jù)庫流水號為條件修改小類別信息
      }
      case 6: {
        return smallTypeSelectBigId(mapping, form, request, response); //以外鍵編號為條件修改小類別信息
      }
    }


    throw new java.lang.UnsupportedOperationException(
        "Method $execute() not yet implemented.");
  }

  //以外鍵編號為條件修改小類別信息
  public ActionForward smallTypeSelectBigId(ActionMapping mapping,
                                            ActionForm form,
                                            HttpServletRequest request,
                                            HttpServletResponse response) {
    List list = dao.selectOneBigId(Integer.valueOf(request.getParameter("bigId")));
    int pageNumber = list.size(); //計算出有多少條記錄
    int maxPage = pageNumber; //計算有多少頁數(shù)
    String number = request.getParameter("i");
    if (maxPage % 6 == 0) {
      maxPage = maxPage / 6;
    }
    else {
      maxPage = maxPage / 6 + 1;
    }
    if (number == null) {
      number = "0";
    }
    request.setAttribute("number", String.valueOf(number));
    request.setAttribute("maxPage", String.valueOf(maxPage));
    request.setAttribute("pageNumber", String.valueOf(pageNumber));
    request.setAttribute("list", list);
    return mapping.findForward("smallTypeSelect");
  }

  //以數(shù)據(jù)庫流水號為條件修改小類別信息
  public ActionForward smallTypeUpdate(ActionMapping mapping,
                                       ActionForm form,
                                       HttpServletRequest request,
                                       HttpServletResponse response) {
    SmallTypeForm smallTypeForm = (SmallTypeForm) form;
    smallTypeForm.setBigId(Integer.valueOf(request.getParameter("bigId")));
    smallTypeForm.setId(Integer.valueOf(request.getParameter("id")));
    smallTypeForm.setSmallName(request.getParameter("name"));
    dao.updateSmall(smallTypeForm);
    request.setAttribute("success", "修改小類別信息成功");
    return mapping.findForward("smallTypeOperation");
  }

  //以數(shù)據(jù)庫流水號為條件查詢小類別信息
  public ActionForward smallTypeSelectOne(ActionMapping mapping,
                                          ActionForm form,
                                          HttpServletRequest request,
                                          HttpServletResponse response) {
    request.setAttribute("small",
                         dao.selectOneBig(Integer.valueOf(request.
        getParameter("id"))));
    return mapping.findForward("smallTypeSelectOne");
  }

  //刪除小類別信息
  public ActionForward smallTypeDelete(ActionMapping mapping,
                                       ActionForm form,
                                       HttpServletRequest request,
                                       HttpServletResponse response) {

    if (dao.deleteSmall(Integer.valueOf(request.getParameter("id")))) {
      request.setAttribute("result", "刪除小類別信息成功！");
    }else {
      request.setAttribute("result", "商品信息還存在此類別，請先刪除商品信息！！！");
    }
    return mapping.findForward("smallTypeOperation");
  }

  //添加小類別信息
  public ActionForward smallTypeInsert(ActionMapping mapping,
                                       ActionForm form,
                                       HttpServletRequest request,
                                       HttpServletResponse response) {
    SmallTypeForm smallTypeForm = (SmallTypeForm) form;
    smallTypeForm.setBigId(Integer.valueOf(request.getParameter("bigId")));
    smallTypeForm.setSmallName(request.getParameter("name"));
    dao.insertSmall(smallTypeForm);
    request.setAttribute("result", "添加小類別信息成功");
    return mapping.findForward("smallTypeOperation");
  }


  //全部查詢小類別信息
  public ActionForward smallTypeSelect(ActionMapping mapping,
                                       ActionForm form,
                                       HttpServletRequest request,
                                       HttpServletResponse response) {
    List list = dao.selectSmall();
    int pageNumber = list.size(); //計算出有多少條記錄
    int maxPage = pageNumber; //計算有多少頁數(shù)
    String number = request.getParameter("i");
    if (maxPage % 6 == 0) {
      maxPage = maxPage / 6;
    }
    else {
      maxPage = maxPage / 6 + 1;
    }
    if (number == null) {
      number = "0";
    }
    request.setAttribute("number", String.valueOf(number));
    request.setAttribute("maxPage", String.valueOf(maxPage));
    request.setAttribute("pageNumber", String.valueOf(pageNumber));
    request.setAttribute("list", list);
    return mapping.findForward("smallTypeSelect");
  }
}