materialcheckservlet.java

JSP移动商品管理平台源代码.........

package imis_mate.servlet;

import imis_mate.DAO.DAOFactory;
import imis_mate.DAO.MaterialCheckDAO;
import imis_mate.DAO.MaterialDAO;
import imis_mate.DAO.MaterialTypeDAO;
import imis_mate.bean.MaterialBean;
import imis_mate.bean.MaterialCheckBean;
import imis_mate.bean.MaterialTypeBean;
import imis_mate.DAO.*;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;

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

public class MaterialCheckServlet extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public MaterialCheckServlet() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		this.doPost(request, response);
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String pattern = request.getParameter("pattern");
		
		if(pattern.equals("insert")) {
			//添加盘点
			this.insert(request,response);
		} else if(pattern.equals("update")) {
			//修改盘点
			this.update(request,response); 
		} else if(pattern.equals("select")) {
			//查询信息
			this.select(request,response);
		} else if(pattern.equals("delete")) {
			//删除信息
			this.delete(request,response);
		} else if(pattern.equals("newPage")) {
			//跳转到新的页面(添加盘点)
			this.newPage(request,response);
		} else if(pattern.equals("search")) {
			//多条件查询
			this.search(request,response);
		} else if(pattern.equals("searchInsertBy")) {
			//查询库存信息 
			this.searchMate(request,response);
		} else if(pattern.equals("searchInsertByReload")) {
			//查询库存信息	刷新
			this.searchMateReload(request,response);
		}else if(pattern.equals("insertCheck")) {
			//添加盘点信息
			this.insertCheck(request,response);
		} else if(pattern.equals("insertSearchPag")) {
			//跳转到盘点搜索页面
			this.insertSearchPag(request,response);
		} 
	}




	private void searchMateReload(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		HttpSession session = request.getSession();
		ArrayList list = null;
		MaterialBean mate = new MaterialBean();
		
		
		mate.setMaterialTypeNo((String)session.getAttribute("materialTypeNo"));
		String startDate = (String)session.getAttribute("startDate");
		String endDate = (String)session.getAttribute("endDate");
		
		MaterialDAO mateDAO = DAOFactory.getInstance().getMaterialDAO();
		try {
			list = mateDAO.checkSearchMaterial(mate, startDate, endDate); //查询所有库存数量大于0的数据
		} catch (Exception e) {
			e.printStackTrace();
		}
			request.getSession().setAttribute("mateCheckSearchList", list);
			request.getRequestDispatcher(NEW_SEARCH_URL).forward(request, response);
		
		
	}

	private void insertSearchPag(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// 跳转到盘点搜索页面
		request.getRequestDispatcher(INSERT_SEARCH_URL).forward(request, response);
	}

	private void insertCheck(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//添加盘点信息
		int materialNo = Integer.parseInt(request.getParameter("materialNo"));
		MaterialBean mate = null;
		MaterialDAO mateDAO = DAOFactory.getInstance().getMaterialDAO();
		try {
			mate = mateDAO.selectMaterial(materialNo);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		request.setAttribute("mateCheck", mate);
		request.setAttribute("outCount", mate.getInCount()-mate.getNowCount());
		request.getRequestDispatcher(INSERT_URL).forward(request, response);
	}

	private void searchMate(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// 查询库存信息
		HttpSession session = request.getSession();
		if(session.getAttribute("materialTypeNo")!=null)
		{
			session.removeAttribute("materialTypeNo");
			session.removeAttribute("startDate");
			session.removeAttribute("endDate");
			
		}
		ArrayList list = null;
		MaterialBean mate = new MaterialBean();
		mate.setMaterialTypeNo(request.getParameter("materialTypeNo"));
		String startDate = request.getParameter("startDate");
		String endDate = request.getParameter("endDate");
		
		session.setAttribute("materialTypeNo", mate.getMaterialTypeNo());
		session.setAttribute("startDate", startDate);
		session.setAttribute("endDate", endDate);
		
		MaterialDAO mateDAO = DAOFactory.getInstance().getMaterialDAO();
		try {
			list = mateDAO.checkSearchMaterial(mate, startDate, endDate); //查询所有库存数量大于0的数据
		} catch (Exception e) {
			e.printStackTrace();
		}
			request.getSession().setAttribute("mateCheckSearchList", list);
			request.getRequestDispatcher(NEW_SEARCH_URL).forward(request, response);
		
	}

	private void insert(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// 添加盘点信息
		boolean flag = false;
		MaterialCheckBean mateCheck = new MaterialCheckBean();
		mateCheck.setMaterialNo(request.getParameter("materialNo"));
		mateCheck.setMaterialName(request.getParameter("materialName"));
		mateCheck.setMaModel(request.getParameter("maModel"));
		mateCheck.setMaBrand(request.getParameter("maBrand"));
		mateCheck.setMaMadeIn(request.getParameter("maMadeIn"));
		mateCheck.setMaterialTypeNo(request.getParameter("materialTypeNo"));
		mateCheck.setOutCount(request.getParameter("outCount"));
		mateCheck.setNowCount(request.getParameter("nowCount"));
		mateCheck.setCheckCount(request.getParameter("checkCount"));
		mateCheck.setCheckDate(request.getParameter("checkDate"));
		mateCheck.setCheckBy(request.getParameter("checkBy"));
		mateCheck.setRemark(request.getParameter("remark"));
		
		MaterialCheckDAO mateDAO = DAOFactory.getInstance().getMaterialCheckDAO();
		
		
		String url = SUCCESS_SUCCESS_URL;
		
		try {
			flag = mateDAO.insertMaterialCheck(mateCheck);
		} catch (Exception e) {
			e.printStackTrace();
		}
		if(flag == true) {
			if(mateCheck.getCheckCount()>mateCheck.getNowCount())
			{
				MaterialBean materialBean = new MaterialBean();
				MaterialDAO mateDAO2 = new MaterialDAO();
				try {
					materialBean = mateDAO2.selectMaterial(mateCheck.getMaterialNo());
					materialBean.setPriceUnit(materialBean.getPriceUnit());
					materialBean.setInCount(mateCheck.getCheckCount()-mateCheck.getNowCount());
					materialBean.setInFrom(4);
					materialBean.setMaBrand(mateCheck.getMaBrand());
					materialBean.setMaMadeIn(mateCheck.getMaMadeIn());
					materialBean.setMaModel(mateCheck.getMaModel());
					materialBean.setMaterialNo(mateCheck.getMaterialNo());
					materialBean.setMaterialTypeName(mateCheck.getMaterialName());
					materialBean.setInDate(mateCheck.getCheckDate());
					materialBean.setMaterialTypeNo(mateCheck.getMaterialTypeNo());
					materialBean.setNowCount(mateCheck.getCheckCount()-mateCheck.getNowCount());
					materialBean.setUserCode(mateCheck.getCheckBy());
					materialBean.setReMark(mateCheck.getRemark());
					mateDAO2.insertMaterial(materialBean);
					request.getSession().setAttribute("materialCheck", materialBean);
					url = SUCCESS_URL_MATE;
				} catch (Exception e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			
			else if(mateCheck.getCheckCount()<mateCheck.getNowCount())
			{