materialservlet.java

来自「JSP移动商品管理平台源代码.........」· Java 代码 · 共 400 行 · 第 1/2 页

		mate.setMaterialTypeName(request.getParameter("materialTypeName"));
		mate.setMaterialTypeNo(request.getParameter("materialTypeNo"));
		mate.setMaModel(request.getParameter("maModel"));
		mate.setMaBrand(request.getParameter("maBrand"));
		mate.setMaMadeIn(request.getParameter("maMadeIn"));
		mate.setBuyId(request.getParameter("buyId"));
		mate.setPriceUnit(request.getParameter("priceUnit"));
		mate.setInCount(request.getParameter("inCount"));
		mate.setNowCount(request.getParameter("inCount")); //库存数量按照入库数量走
		mate.setInDate(request.getParameter("inDate"));
		mate.setUserCode(request.getParameter("userCode"));
		mate.setInFrom(request.getParameter("inFrom"));
		mate.setReMark(request.getParameter("reMark"));
		
		MaterialDAO mateDAO = DAOFactory.getInstance().getMaterialDAO();
		try {//添加刷新功能
			if((request.getSession().getAttribute("new"))!=null){
				flag = mateDAO.insertMaterial(mate);
				request.getSession().removeAttribute("new");
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		if(flag == true) {
			if(request.getSession().getAttribute("mateChange")!=null){
				request.getSession().removeAttribute("mateChange");
			}
			if(request.getSession().getAttribute("materialCheck")!=null){
				request.getSession().removeAttribute("materialCheck");
			}
			
			request.setAttribute("success", "信息添加成功");
			request.getRequestDispatcher(SUCCESS_URL).forward(request, response);
		} else {
			request.setAttribute("fail", "信息添加失败");
			request.getRequestDispatcher(FAIL_URL).forward(request, response);
		}
	}

	private void update(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// 修改库存信息
		boolean flag = false;

		
		MaterialBean mate = new MaterialBean();
		mate.setMaterialNo(request.getParameter("materialNo"));
		mate.setMaterialTypeName(request.getParameter("materialTypeName"));
		mate.setMaterialTypeNo(request.getParameter("materialTypeNo"));
		mate.setMaModel(request.getParameter("maModel"));
		mate.setMaBrand(request.getParameter("maBrand"));
		mate.setMaMadeIn(request.getParameter("maMadeIn"));
		mate.setBuyId(request.getParameter("buyId"));
		mate.setPriceUnit(request.getParameter("priceUnit"));
		mate.setInCount(request.getParameter("inCount"));
		mate.setNowCount(request.getParameter("nowCount"));
		mate.setInDate(request.getParameter("inDate"));
		mate.setUserCode(request.getParameter("userCode"));
		//mate.setInFrom(request.getParameter("inFrom"));
		mate.setInFromToString(request.getParameter("inFrom"));
		mate.setReMark(request.getParameter("reMark"));
		
		
		
		
		MaterialDAO mateDAO = DAOFactory.getInstance().getMaterialDAO();
		try {
			flag = mateDAO.updateMaterial(mate);
		} catch (Exception e) {
			e.printStackTrace();
		}
		if(flag == true) {
			request.setAttribute("success", "信息更新成功");
			request.getRequestDispatcher(SUCCESS_URL).forward(request, response);
		} else {
			request.setAttribute("fail", "信息更新失败");
			request.getRequestDispatcher(FAIL_URL).forward(request, response);
		}
	}

	private void select(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//查询库存信息
		MaterialBean mate = null;
		String materialNo = request.getParameter("MaterialNo");//获得库存编号
		MaterialDAO mateDAO = DAOFactory.getInstance().getMaterialDAO();
		try {
			mate = mateDAO.selectMaterial(new Integer(materialNo).intValue());
		} catch (Exception e) {
			e.printStackTrace();
		}
		if(mate != null) {
			request.setAttribute("mate", mate);
		} else {
			request.setAttribute("materialNoNULL", "库存编号不存在.");
		}
		if(request.getParameter("page").equals("update")) {
			request.getRequestDispatcher(UPDATE_URL).forward(request, response);
		} else if(request.getParameter("page").equals("delete")) {
			request.getRequestDispatcher(DELETE_URL).forward(request, response);
		}
	}

	private void delete(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// 删除库存信息
		boolean flag = false;
		
		String materialNo = request.getParameter("materialNo");
		MaterialDAO mateDAO = DAOFactory.getInstance().getMaterialDAO();
		MaterialBuyDetailDAO mateBuyDAO = new MaterialBuyDetailDAO();
		
		try {
			MaterialBean mate = mateDAO.selectMaterial(Integer.parseInt(materialNo));
			flag = mateDAO.deleteMaterial(materialNo);
			if(flag && mate.getInFrom()==1){
				//如果删除成功 并且对应的入库类型为采购入库 
				mateBuyDAO.updateFlag(mate.getBuyId(), false); //更改对应采购单id下的 入库标志为 未入库
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		if(flag == true) {
			request.setAttribute("success","成功删除信息");
			request.getRequestDispatcher(SUCCESS_URL).forward(request, response);
		} else {
			request.setAttribute("fail","信息删除失败");
			request.getRequestDispatcher(FAIL_URL).forward(request,response);
		}
	}
	private void search(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// 多条件查询入库信息
		MaterialBean mate = new MaterialBean();
		ArrayList list = null;
		String startDate = null;
		String endDate = null;
		mate.setMaterialTypeName(request.getParameter("materialTypeName")); //物品名称
		mate.setMaterialTypeNo(request.getParameter("materialTypeNo")); //物品类型
		mate.setMaModel(request.getParameter("maModel")); //品牌
		mate.setMaBrand(request.getParameter("maBrand")); //型号
		mate.setMaMadeIn(request.getParameter("maMadeIn")); //产地
		mate.setInFrom(request.getParameter("inFrom")); //入库来源
		startDate = request.getParameter("startDate"); //起始时间
		endDate = request.getParameter("endDate"); //结束时间

		MaterialDAO mateDAO = DAOFactory.getInstance().getMaterialDAO();
		try {
			list = mateDAO.searchMaterial(mate,startDate,endDate);
		} catch (Exception e) {
			e.printStackTrace();
		}
			request.getSession().setAttribute("mateList", list);
			request.getRequestDispatcher(SEARCH_URL).forward(request, response);
	}
	
	private void reseve_search(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//多条件查询库存信息
		MaterialBean mate = new MaterialBean();
		ArrayList list = null;
		String startDate = null;
		String endDate = null;
		mate.setMaterialTypeName(request.getParameter("materialTypeName")); //物品名称
		mate.setMaterialTypeNo(request.getParameter("materialTypeNo")); //物品类型
		mate.setMaModel(request.getParameter("maModel")); //品牌
		mate.setMaBrand(request.getParameter("maBrand")); //型号
		mate.setMaMadeIn(request.getParameter("maMadeIn")); //产地
		mate.setInFrom(request.getParameter("inFrom")); //入库来源
		startDate = request.getParameter("startDate"); //起始时间
		endDate = request.getParameter("endDate"); //结束时间

		MaterialDAO mateDAO = DAOFactory.getInstance().getMaterialDAO();
		try {
			list = mateDAO.reseveSearchMaterial(mate,startDate,endDate);
		} catch (Exception e) {
			e.printStackTrace();
		}
			request.getSession().setAttribute("mateList", list);
			request.getRequestDispatcher(RESEVE_SEARCH_URL).forward(request, response);
	}
	
	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}
	
	private static final String SUCCESS_URL = "../imis_mate/successful.jsp"; //提交成功页面 
	private static final String FAIL_URL = "../imis_mate/fail.jsp"; //提交失败页面
	private static final String INSERT_URL = "../imis_mate/Material_insert.jsp"; //插入数据库页面
	private static final String ALLOT_INSERT_URL = "../imis_mate/Material_insert.jsp"; //调拨入库页面
	private static final String BUY_INSERT_URL = "../imis_mate/Material_Buy_insert.jsp"; //采购入库页面
	
	private static final String UPDATE_URL = "../imis_mate/Material_update.jsp"; //修改数据页面
	private static final String DELETE_URL = "../imis_mate/Material_delete.jsp"; //删除数据页面
	private static final String SEARCH_URL = "../imis_mate/Material_bysearch.jsp"; //搜索数据页面
	private static final String RESEVE_SEARCH_URL = "../imis_mate/Material_reseve_bysearch.jsp"; //搜索数据页面
	
	
}