materialcheckservlet.java

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

				MaterialDAO materialDAO = new MaterialDAO();
				try {
					materialDAO.updateMaterialForMateCheck(mateCheck.getMaterialNo(), mateCheck.getCheckCount());
				} catch (Exception e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				url = SUCCESS_SUCCESS_URL;
			}
			
			request.setAttribute("success", "信息添加成功");
		
		} else {
			url = FAIL_URL;
			request.setAttribute("fail", "信息添加失败");
			
		}
		request.getRequestDispatcher(url).forward(request, response);
	}

	private void update(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// 更新盘点信息
		boolean flag = false;
		String url = null;
		MaterialDAO materialDAO = new MaterialDAO();
		
		MaterialCheckBean mateCheck = new MaterialCheckBean();
		mateCheck.setCheckID(request.getParameter("checkID"));
		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"));
		try {
			mateCheck.setNowCount((materialDAO.selectMaterial(mateCheck.getMaterialNo()).getNowCount()));
		} catch (Exception e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		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();
		try {
			flag = mateDAO.updateMaterialCheck(mateCheck);
		} catch (Exception e) {
			e.printStackTrace();
		}if(flag == true) {
			if(mateCheck.getCheckCount()>mateCheck.getNowCount())
			{
				MaterialBean materialCheck = new MaterialBean();
				materialCheck.setInCount(mateCheck.getCheckCount()-mateCheck.getNowCount());
				materialCheck.setInFrom(4);
				materialCheck.setMaBrand(mateCheck.getMaBrand());
				materialCheck.setMaMadeIn(mateCheck.getMaMadeIn());
				materialCheck.setMaModel(mateCheck.getMaModel());
				materialCheck.setMaterialNo(mateCheck.getMaterialNo());
				materialCheck.setMaterialTypeName(mateCheck.getMaterialName());
				materialCheck.setMaterialTypeNo(mateCheck.getMaterialTypeNo());
				materialCheck.setNowCount(mateCheck.getCheckCount()-mateCheck.getNowCount());
			
				request.getSession().setAttribute("materialCheck", materialCheck);
				
				url = SUCCESS_URL_MATE;
				request.setAttribute("success", "盘点信息更新成功");
			}
			
			else if(mateCheck.getCheckCount()<mateCheck.getNowCount())
			{
			
				try {
					materialDAO.updateMaterialForMateCheck(mateCheck.getMaterialNo(), mateCheck.getCheckCount());
				} catch (Exception e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				url = SUCCESS_URL;
				request.setAttribute("success", "盘点信息更新成功");
			}
		
		
			
		} else {
			request.setAttribute("fail","盘点信息更新失败");
			url = FAIL_URL;
			
		}
		request.getRequestDispatcher(url).forward(request, response);
	}

	private void select(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// 查询盘点信息
		MaterialCheckBean mateCheck = null;
		String checkID = request.getParameter("CheckID");
		MaterialCheckDAO mateDAO = DAOFactory.getInstance().getMaterialCheckDAO();
		try {
			mateCheck = mateDAO.selectMaterialCheck(new Integer(checkID).intValue());
		} catch (Exception e) {
			e.printStackTrace();
		}
		if(mateCheck != null) {
			request.setAttribute("mateCheck",mateCheck);
			
		} else {
			request.setAttribute("CheckIDNull","物品类型编号不存在.");
		}
		if(request.getParameter("page").equals("update")) {
			request.getRequestDispatcher(UPDATE_URL).forward(request, response);
		}
		
	}

	private void delete(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// 删除盘点信息
		boolean flag = false;
		String checkID = request.getParameter("checkID");
		MaterialCheckDAO mateDAO = DAOFactory.getInstance().getMaterialCheckDAO();
		
		flag = this.rollBackMate(checkID); //删除盘点信息 还原库存信息
		
		if(flag == true){
			try {
				flag = mateDAO.deleteMaterialCheck(checkID);
			} 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 boolean rollBackMate(String checkID){
		//删除盘点信息 还原库存信息
		boolean flag = false;
		MaterialCheckBean mateCheckBean = new MaterialCheckBean();
		MaterialBean mateBean = null;
		MaterialCheckDAO mateCheckDAO = DAOFactory.getInstance().getMaterialCheckDAO();
		MaterialDAO mateDAO = DAOFactory.getInstance().getMaterialDAO();
		
		mateCheckBean.setCheckID(checkID);
		
		try {
			mateCheckBean = mateCheckDAO.selectMaterialCheck(mateCheckBean.getCheckID());
			if(mateCheckBean.getNowCount() == mateCheckBean.getCheckCount()) {
				//原库存数量 等于 盘点数量
				flag = true;
			}else if(mateCheckBean.getNowCount() > mateCheckBean.getCheckCount()) {
				//原库存数量 大于 盘点数量 原来的操作为减 现在加回去
				int nowCount = mateCheckBean.getNowCount() - mateCheckBean.getCheckCount();
				mateBean = mateDAO.selectMaterial(mateCheckBean.getMaterialNo());
				if(mateBean!=null){
					nowCount = mateBean.getNowCount() + nowCount;
					mateBean.setNowCount(nowCount);
					flag = mateDAO.updateMaterial(mateBean);
				}else {
					flag = false;
				}
			}else if(mateCheckBean.getNowCount() < mateCheckBean.getCheckCount()) {
				//原库存数量 小于 盘点数量 原来的操作为添加库存 现在删除
				int nowCount = mateCheckBean.getCheckCount() - mateCheckBean.getNowCount();
				mateCheckBean.setCheckCount(nowCount);
				flag = mateDAO.rollBackMaterial(mateCheckBean);
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return flag;
	}
	private void newPage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// 跳转到插入页面
		request.getRequestDispatcher(INSERT_URL).forward(request,response);
	}
	
	private void search(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// 多条件查询
		MaterialCheckBean mate = new MaterialCheckBean();
		ArrayList list = null;
		mate.setCheckID(request.getParameter("checkID"));
		mate.setMaterialNo(request.getParameter("materialNo"));
		mate.setMaterialName(request.getParameter("materialName"));
		mate.setMaterialTypeNo(request.getParameter("materialTypeNo"));
//		mate.setCheckDate(request.getParameter("checkDate"));
		String startDate = request.getParameter("startDate"); //开始时间
		String endDate = request.getParameter("endDate"); //截止时间
		
//		
		
		MaterialCheckDAO mateDAO = DAOFactory.getInstance().getMaterialCheckDAO();
		try {
			list = mateDAO.searchMaterialCheck(mate,startDate,endDate);
		} catch (Exception e) {
			e.printStackTrace();
		}
			request.getSession().setAttribute("mateCheckList", list);
			request.getRequestDispatcher(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 UPDATE_URL = "../imis_mate/MaterialCheck_update.jsp"; //更新数据页面
 	private static final String INSERT_URL = "../imis_mate/MaterialCheck_insert.jsp"; //插入数据页面
	private static final String SEARCH_URL = "../imis_mate/MaterialCheck_bysearch.jsp"; //先是查询数据页面
//	private static final String INSERT_URL = "../imis_mate/MaterialCheck_insert_bysearch.jsp"; //插入数据页面
	private static final String INSERT_SEARCH_URL = "../imis_mate/MaterialCheck_insert_search.jsp"; //插入盘点信息搜索页面
	private static final String SUCCESS_URL_MATE = "../imis_mate/MaterialCheck_insertsuccess.jsp"; //盘点入库
	private static final String SUCCESS_SUCCESS_URL = "../imis_mate/MaterialCheck_insertsuccess2.jsp"; //盘点入库
	private static final String NEW_SEARCH_URL = "../imis_mate/MaterialCheck_insert_bysearch.jsp"; //盘点管理
}