informationselectservlet.java

销售管理系统 随着我国国民经济的持续发展

package com.webtier;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import com.dao.GoodsOrderDao;
import com.domain.GoodsOrderVO;
import com.dao.GoodsCancelDao;
import com.domain.GoodsCancelVO;
import com.dao.AreaDao;
import com.tool.Chinese;

//信息查询
public class InformationSelectServlet
    extends HttpServlet {
  private int method;
  private GoodsCancelVO cancelVO = null;
  private GoodsOrderVO orderVO = null;
  private GoodsOrderDao orderDao = null;
  private GoodsCancelDao cancelDao = null;
  private AreaDao areaDao = null;
  public void doGet(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    request.setCharacterEncoding("gb2312");
    cancelVO = new GoodsCancelVO();
    orderVO = new GoodsOrderVO();
    orderDao = new GoodsOrderDao();
    cancelDao = new GoodsCancelDao();
    areaDao = new AreaDao();
    this.method = Integer.parseInt(request.getParameter("method"));
    switch (method) {
      case 0: {
        this.orderSelect(request, response);
        break;
      }
      case 1: {
        this.orderSelectContent(request, response);
        break;
      }
      case 2: {
        this.OutSelect(request, response);
        break;
      }
      case 3: {
        this.outSelectConnect(request, response);
        break;
      }
      case 4: {
        this.cancelSelect(request, response);
        break;
      }
      case 5: {
        this.cancelSelectContent(request, response);
        break;
      }
      case 6: {
        this.areaSelect(request, response);
        break;
      }
      case 7: {
        this.areaCitySelect(request, response);
        break;
      }
      case 8: {
        this.orderSelectTime(request, response);
        break;
      }

      case 9: {
        this.cancelSelecTime(request, response);
        break;
      }

    }
  }

//退货时间段查询
  public void cancelSelecTime(HttpServletRequest request,
                              HttpServletResponse response) throws
      ServletException, IOException {
    String startYear = request.getParameter("startYear");
    String startMonth = request.getParameter("startMonth");
    String startDate = request.getParameter("startDate");
    String start = startYear + "-" + startMonth + "-" + startDate;
    String overYear = request.getParameter("overYear");
    String overMonth = request.getParameter("overMonth");
    String overDate = request.getParameter("overDate");
    String over = overYear + "-" + overMonth + "-" + overDate;
    List list = cancelDao.goodsCancelSelectTime(start,over);
    request.setAttribute("list", list);
    RequestDispatcher requestDispatcher = request.getRequestDispatcher(
        "information/cancelSelecTime.jsp");
    requestDispatcher.forward(request, response);
  }

  //出货和定货时间段查询
  public void orderSelectTime(HttpServletRequest request,
                              HttpServletResponse response) throws
      ServletException, IOException {
    int title = Integer.parseInt(request.getParameter("title"));
    String startYear = request.getParameter("startYear");
    String startMonth = request.getParameter("startMonth");
    String startDate = request.getParameter("startDate");
    String start = startYear + "-" + startMonth + "-" + startDate;
    String overYear = request.getParameter("overYear");
    String overMonth = request.getParameter("overMonth");
    String overDate = request.getParameter("overDate");
    String over = overYear + "-" + overMonth + "-" + overDate;
    List list = orderDao.goodsOrderSelectTime(start, over, title);
    request.setAttribute("list", list);
    RequestDispatcher requestDispatcher = request.getRequestDispatcher(
        "information/orderSelectTime.jsp");
    requestDispatcher.forward(request, response);
  }

  //查看城市信息
  public void areaCitySelect(HttpServletRequest request,
                             HttpServletResponse response) throws
      ServletException, IOException {
    String provicne = Chinese.str(request.getParameter("provicne"));
    System.out.println("provicne=" + provicne);
    List list = areaDao.areaCity(provicne);
    int pageNumber = list.size(); //计算出有多少条记录
    int maxPage = pageNumber; //计算有多少页数
    String number = request.getParameter("i");
    if (maxPage % 5 == 0) {
      maxPage = maxPage / 5;
    }
    else {
      maxPage = maxPage / 5 + 1;
    }
    if (number == null) {
      number = "0";
    }
    request.setAttribute("account", String.valueOf(number));
    request.setAttribute("maxPage", String.valueOf(maxPage));
    request.setAttribute("pageNumber", String.valueOf(pageNumber));
    request.setAttribute("provicne", provicne);
    request.setAttribute("list", list);
    RequestDispatcher requestDispatcher = request.getRequestDispatcher(
        "information/areaCitySelect.jsp");
    requestDispatcher.forward(request, response);

  }

  //查看地区信息
  public void areaSelect(HttpServletRequest request,
                         HttpServletResponse response) throws
      ServletException, IOException {
    List list = areaDao.listProvicne();
    int pageNumber = list.size(); //计算出有多少条记录
    int maxPage = pageNumber; //计算有多少页数
    String number = request.getParameter("i");
    if (maxPage % 5 == 0) {
      maxPage = maxPage / 5;
    }
    else {
      maxPage = maxPage / 5 + 1;
    }
    if (number == null) {
      number = "0";
    }
    request.setAttribute("account", String.valueOf(number));
    request.setAttribute("maxPage", String.valueOf(maxPage));
    request.setAttribute("pageNumber", String.valueOf(pageNumber));
    request.setAttribute("list", list);

    RequestDispatcher requestDispatcher = request.getRequestDispatcher(
        "information/areaSelect.jsp");
    requestDispatcher.forward(request, response);

  }

  //查看退货详细内容
  public void cancelSelectContent(HttpServletRequest request,
                                  HttpServletResponse response) throws
      ServletException, IOException {
    request.setAttribute("cancel",
                         cancelDao.cancelSelectOne(request.
        getParameter("number")));
    RequestDispatcher requestDispatcher = request.getRequestDispatcher(
        "information/cancelContent.jsp");
    requestDispatcher.forward(request, response);

  }

  //退货信息查询
  public void cancelSelect(HttpServletRequest request,
                           HttpServletResponse response) throws
      ServletException, IOException {
    String back = "";
    List list = cancelDao.cancelSelect(back);
    int pageNumber = list.size(); //计算出有多少条记录
    int maxPage = pageNumber; //计算有多少页数
    String number = request.getParameter("i");
    if (maxPage % 5 == 0) {
      maxPage = maxPage / 5;
    }
    else {
      maxPage = maxPage / 5 + 1;
    }
    if (number == null) {
      number = "0";
    }
    request.setAttribute("account", String.valueOf(number));
    request.setAttribute("maxPage", String.valueOf(maxPage));
    request.setAttribute("pageNumber", String.valueOf(pageNumber));
    request.setAttribute("list", list);
    RequestDispatcher requestDispatcher = request.getRequestDispatcher(
        "information/cancelSelect.jsp");
    requestDispatcher.forward(request, response);

  }

  //出货查询内容
  public void outSelectConnect(HttpServletRequest request,
                               HttpServletResponse response) throws
      ServletException, IOException {
    request.setAttribute("out",
                         orderDao.goodsOrderSelect(request.getParameter(
        "number")));
    RequestDispatcher requestDispatcher = request.getRequestDispatcher(
        "information/outSelectConnect.jsp");
    requestDispatcher.forward(request, response);
  }

  //出货信息查询
  public void OutSelect(HttpServletRequest request,
                        HttpServletResponse response) throws
      ServletException, IOException {
    Integer title = Integer.valueOf("1");
    List list = orderDao.goodsOrderSelect(title);
    int pageNumber = list.size(); //计算出有多少条记录
    int maxPage = pageNumber; //计算有多少页数
    String number = request.getParameter("i");
    if (maxPage % 5 == 0) {
      maxPage = maxPage / 5;
    }
    else {
      maxPage = maxPage / 5 + 1;
    }
    if (number == null) {
      number = "0";
    }
    request.setAttribute("account", String.valueOf(number));
    request.setAttribute("maxPage", String.valueOf(maxPage));
    request.setAttribute("pageNumber", String.valueOf(pageNumber));
    request.setAttribute("list", list);
    RequestDispatcher requestDispatcher = request.getRequestDispatcher(
        "information/outSelect.jsp");
    requestDispatcher.forward(request, response);
  }

  //查看定货信息详细内容
  public void orderSelectContent(HttpServletRequest request,
                                 HttpServletResponse response) throws
      ServletException, IOException {
    request.setAttribute("order",
                         orderDao.goodsOrderSelect(request.getParameter(
                             "number")));
    RequestDispatcher requestDispatcher = request.getRequestDispatcher(
        "information/orderSelectContent.jsp");
    requestDispatcher.forward(request, response);
  }

//定货信息查询
  public void orderSelect(HttpServletRequest request,
                          HttpServletResponse response) throws
      ServletException, IOException {
    Integer title = Integer.valueOf("0");
    List list = orderDao.goodsOrderSelect(title);
    int pageNumber = list.size(); //计算出有多少条记录
    int maxPage = pageNumber; //计算有多少页数
    String number = request.getParameter("i");
    if (maxPage % 5 == 0) {
      maxPage = maxPage / 5;
    }
    else {
      maxPage = maxPage / 5 + 1;
    }
    if (number == null) {
      number = "0";
    }
    request.setAttribute("account", String.valueOf(number));
    request.setAttribute("maxPage", String.valueOf(maxPage));
    request.setAttribute("pageNumber", String.valueOf(pageNumber));
    request.setAttribute("list", list);
    RequestDispatcher requestDispatcher = request.getRequestDispatcher(
        "information/orderSelect.jsp");
    requestDispatcher.forward(request, response);
  }

  public void doPost(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    doGet(request, response);
  }

}