materialchangeservlet.java

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

		String url = null;
		boolean flag = false;
		MateOutDetailBean mateODB = null;
		MateOutDetailDAO modd = new MateOutDetailDAO();
		MaterialChangeDAO mateDAO = DAOFactory.getInstance().getMaterialChangeDAO();
		MaterialChangeBean mate = new MaterialChangeBean();
		MaterialBean mateBean = new MaterialBean();
		
		mate.setChangeID(request.getParameter("changeID"));
		mate.setChangeType(request.getParameter("changeType"));
		mate.setOutNoId(request.getParameter("outNoId"));
		mate.setOutCount(request.getParameter("outCount"));
		//mate.setOutDate(request.getParameter("outDate"));
		mate.setUserCode(request.getParameter("userCode"));
		mate.setOraDep(request.getParameter("oraDep"));
		mate.setUseDep(request.getParameter("useDep"));
		mate.setManagerBy(request.getParameter("managerBy"));
		mate.setUseBy(request.getParameter("useBy"));
		mate.setRoomNu(request.getParameter("roomNu"));
		mate.setBuildingNu(request.getParameter("buildingNu"));
		mate.setChangeCause(request.getParameter("changeCause"));
		mate.setReMark(request.getParameter("remark"));

		
		//MateOutDetailDAO mateOutDAO = new MateOutDetailDAO();
		
		
		try {
			flag = mateDAO.insertMaterialChange(mate);
			
			if (flag) {
				flag = modd.updateChaflag(mate.getOutNoId());
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		if(flag && mate.getChangeType()==1) {
			//变更信息添加成功 并且变更类型 为 入库
			mateODB = modd.getMateOutDetailBeanOfOutNoId(mate.getOutNoId());
			if(mateODB != null) {
				mateBean.setMaterialTypeName(mateODB.getMaterialName());
				mateBean.setMaModel(mateODB.getMaModel());
				mateBean.setMaBrand(mateODB.getMaBrand());
				mateBean.setMaMadeIn(mateODB.getMaMadeIn());
				mateBean.setMaterialTypeNo(mateODB.getMaterialTypeNo());
				mateBean.setPriceUnit(mateODB.getPriceUnit());
				mateBean.setInCount(mate.getOutCount());
				mateBean.setUserCode(mate.getUserCode()); //入库人取变更人
				mateBean.setNowCount(mate.getOutCount()); //库存数量取变更数量
				mateBean.setInFrom(3); //入库类型为变更
				mateBean.setReMark(mate.getReMark());
				request.setAttribute("mate", mateBean);
				MaterialDAO materialDAO = new MaterialDAO();
				try {
					flag = materialDAO.insertMaterialNotDate(mateBean); //直接插入库存信息
				} catch (Exception e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				if(flag){
					request.getSession().setAttribute("mateChange",mateBean);
					request.setAttribute("success", "变更信息添加成功");
					url = CHANGE_INSERT_URL;
				}else {
					request.setAttribute("fail", "变更信息添加失败");
					//request.getRequestDispatcher(FAIL_URL).forward(request, response);
					url = FAIL_URL;
				}

			}
		} else if (flag) {
			request.setAttribute("success", "变更信息添加成功");
			//request.getRequestDispatcher(SUCCESS_URL).forward(request, response);
			url = CHANGE_SUCCESS_URL;
		} else {
			request.setAttribute("fail", "变更信息添加失败");
			//request.getRequestDispatcher(FAIL_URL).forward(request, response);
			url = FAIL_URL;
		}
		request.getRequestDispatcher(url).forward(request, response);
	}

	private void update(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// 更新变更信息
		boolean flag = false;

		MaterialChangeBean mate = new MaterialChangeBean();
		mate.setChangeID(request.getParameter("changeID"));
		mate.setChangeType(request.getParameter("changeType"));
		mate.setOutNoId(request.getParameter("outNoId"));
		mate.setOutCount(request.getParameter("outCount"));
		mate.setOutDate(request.getParameter("outDate"));
		mate.setUserCode(request.getParameter("userCode"));
		mate.setOraDep(request.getParameter("oraDep"));
		mate.setUseDep(request.getParameter("useDep"));
		mate.setManagerBy(request.getParameter("managerBy"));
		mate.setUseBy(request.getParameter("useBy"));
		mate.setRoomNu(request.getParameter("roomNu"));
		mate.setBuildingNu(request.getParameter("buildingNu"));
		mate.setChangeCause(request.getParameter("changeCause"));
		mate.setReMark(request.getParameter("remark"));

		MaterialChangeDAO mateDAO = DAOFactory.getInstance().getMaterialChangeDAO();
		try {
			flag = mateDAO.updateMaterialChange(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 {
		// 查询变更信息
		MaterialChangeBean mate = null;
		String changeId = request.getParameter("ChangeID");
		MaterialChangeDAO mateDAO = DAOFactory.getInstance()
				.getMaterialChangeDAO();
		try {
			mate = mateDAO.selectMaterialChange(new Integer(changeId).intValue());
		} catch (Exception e) {
			e.printStackTrace();
		}
		if (mate != null) {
			HousBuildingAndRoom hbr = new HousBuildingAndRoom();
			ArrayList list = hbr.getRoomListForBuildingNu(mate.getBuildingNu());
			
			request.setAttribute("roomList", list);
			request.setAttribute("mate", mate);
		} else {
			request.setAttribute("changeIdNull", "编号不存在.");
		}
		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 = true;
		String changeId = request.getParameter("changeID");
		String changeType = request.getParameter("changeType");
		String url = SUCCESS_URL;
		if(changeType!=null && changeType.trim().equals("1")) {
			//变更类型为1 入库变更
			this.rollBackChange(Integer.parseInt(changeId)); //删除变更信息(变更类型为入库时) 删除入库信息
		}else {
			flag = true;
		}
		if(flag == true) {
			MaterialChangeDAO mateDAO = DAOFactory.getInstance().getMaterialChangeDAO();
			MateOutDetailDAO mateOutD = new MateOutDetailDAO();
			try {
				MaterialChangeBean mateChangeBean = mateDAO.selectMaterialChange(new Integer(changeId).intValue());
				mateOutD.updateChaflag(mateChangeBean.getOutNoId(), false);
				flag = mateDAO.deleteMaterialChange(new Integer(changeId).intValue());
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		
		if (flag == true) {
			request.setAttribute("success", "成功删除信息");
			url = SUCCESS_URL;
//			request.getRequestDispatcher(SUCCESS_URL).forward(request, response);
		} else {
			request.setAttribute("fail", "信息删除失败");
			url = FAIL_URL;
//			request.getRequestDispatcher(FAIL_URL).forward(request, response);
		}
		request.getRequestDispatcher(url).forward(request, response);
	}
	
	private boolean rollBackChange(int changeId) {
		//删除变更信息(变更类型为入库时) 删除入库信息
		boolean flag = false;
		MaterialChangeDAO mateChangeDAO = DAOFactory.getInstance().getMaterialChangeDAO();
		MateOutDetailDAO mateOutDAO = new MateOutDetailDAO();
		MaterialDAO mateDAO = DAOFactory.getInstance().getMaterialDAO();
		MaterialChangeBean mateChangeBean = null;
		MateOutDetailBean mateOutBean = null;
		try {
			mateChangeBean = mateChangeDAO.selectMaterialChange(changeId);
			if(mateChangeDAO!=null) {
				mateOutBean = mateOutDAO.getMateOutDetailBeanOfOutNoId(mateChangeBean.getOutNoId());
			}
			if(mateOutDAO!=null) {
				flag = mateDAO.rollBackMaterial(mateOutBean,mateChangeBean.getOutDate());
			}
			
		} 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_SEARCH_URL).forward(request,
				response);
	}

	private void search(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// 多条件查询
		MaterialChangeBean mate = new MaterialChangeBean();
		ArrayList list = null;
		mate.setChangeType(request.getParameter("changeType")); // 变更类型
		mate.setOraDep(request.getParameter("oraDep")); // 原部门
		mate.setUseDep(request.getParameter("useDep")); // 转入部门
		String materialName = request.getParameter("MaterialName"); // 物品名称
		String startDate = request.getParameter("startDate"); // 起始时间
		String endDate = request.getParameter("endDate"); // 结束时间

		MaterialChangeDAO mateDAO = DAOFactory.getInstance()
				.getMaterialChangeDAO();
		try {
			list = mateDAO.searchMaterialChange(mate, materialName, startDate,
					endDate);
		} catch (Exception e) {
			e.printStackTrace();
		}
		request.getSession().setAttribute("mateChangeList", list);
		// request.setAttribute("mateList", 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/MaterialChangeTable_update.jsp"; // 更新数据页面
	private static final String INSERT_URL = "../imis_mate/MaterialChangeTable_insert.jsp"; // 插入数据页面
	private static final String SEARCH_URL = "../imis_mate/MaterialChange_bysearch.jsp";// 多条件查询页面
	private static final String INSERT_BYSEARCH_URL = "../imis_mate/MaterialChangeTable_insert_bysearch.jsp";// 多条件查询页面
	private static final String INSERT_SEARCH_URL = "../imis_mate/MaterialChangeTable_insert_search.jsp";// 多条件查询页面
	private static final String CHANGE_INSERT_URL = "../imis_mate/MaterialChangeSuccess.jsp"; //调拨入库页面
	private static final String CHANGE_SUCCESS_URL = "../imis_mate/MaterialChangeSuccess2.jsp"; //调拨入库页面
	private static final String WINDOW_CLOSE_URL = "../imis_mate/MaterialWindowClose.jsp"; //自动关闭页面
}