materialouttableservlet.java

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

		request.setAttribute("outNo", modb.getOutNo());
		flag = modd.save(modb) ? true : false;
		return flag;
	}

	// 修改出库单明细
	private void updateMaterialOutDetail(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException {
		//2008-4-5 修改
		boolean flag = false;
		boolean flag2 = false;
		String url = "../imis_mate/fail.jsp";
		MateOutDetailBean modb = new MateOutDetailBean();
		MateOutDetailBean mateOut = new MateOutDetailBean();
		MaterialBean mate = null;
		
		modb.setOutNoId(Integer.parseInt(request.getParameter("outId")));
		modb.setOutNo(request.getParameter("outNo"));
		modb.setMaterialName(request.getParameter("materialName"));
		modb.setMaModel(request.getParameter("maModel"));
		modb.setMaBrand(request.getParameter("maBrand"));
		modb.setMaMadeIn(request.getParameter("maMadeIn"));
		modb.setMaterialTypeNo(request.getParameter("materialTypeNo"));
		modb.setMaterialNo(Integer.parseInt(request.getParameter("materialNo")));
		modb.setPriceUnit(Double.parseDouble(request.getParameter("priceUnit")));
		modb.setOutCount(Integer.parseInt(request.getParameter("outCount")));
		MateOutDetailDAO modd = new MateOutDetailDAO();
		MaterialDAO mateDAO = new MaterialDAO();
		
		
		mateOut = modd.getMateOutDetailBeanOfOutNoId(modb.getOutNoId()); //返回旧的 出库明细
		
		try {
			mate = mateDAO.selectMaterial(mateOut.getMaterialNo());
			if(mate != null && (modb.getOutCount()>=0)) {
				int i = mate.getNowCount() + (mateOut.getOutCount() - modb.getOutCount()); 
				flag2 = i >= 0 ? true : false;
			}
		} catch (Exception e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		if(flag2){
			//如果库存数量 可以修改 那么修改 出库明细
			flag = modd.update(modb) ? true : false;
		}
		if(flag){
			try {
				//入库出库明细修改成功 那么修改库存信息
				flag = mateDAO.updateMaterialForMateOutDetail(mateOut.getMaterialNo(),mateOut.getOutCount(),modb.getOutCount());
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if (flag) {
			request.setAttribute("success", "数据修改成功");
			url = "../imis_mate/successful.jsp";
		} else {
			if(flag2) {
				request.setAttribute("fail", "数据修改失败");
			}else {
				request.setAttribute("fail", "数据修改失败,库存数量不足.");
			}
			url = "../imis_mate/fail.jsp";
		}
		request.getRequestDispatcher(url).forward(request, response);
	}

	// 删除出库单明细
	private boolean deleteMaterialOutDetail(HttpServletRequest request,
			HttpServletResponse response) {
		// TODO Auto-generated method stub
		boolean flag = false;
		int outNoId = Integer.parseInt(request.getParameter("outId").trim());
		MateOutDetailDAO modd = new MateOutDetailDAO();
		MateOutDetailBean modb = new MateOutDetailBean();
		modb=modd.getMateOutDetailBeanOfOutNoId(outNoId);
		ArrayList list = new ArrayList();
		list.add(modb);
		flag = modd.delete(list) ? true : false;
		return flag;
	}
	private void deleteOutDetail(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException{
		//删除出库明细 2008-04-09 增加回滚功能 增加判断是否是最后一个明晰 如果是 则删除总出库单
		
		int outNoId = Integer.parseInt(request.getParameter("outId").trim());
		boolean flag = false;
		String url = "../imis_mate/successful.jsp";
		MateOutDetailBean modb = new MateOutDetailBean();
		MateOutDetailDAO modd = new MateOutDetailDAO();
		MateOutBaseDAO mobd = new MateOutBaseDAO();
		
		modb = modd.getMateOutDetailBeanOfOutNoId(outNoId);
		ArrayList list = modd.getMateOutDetailBeanOfOutNo(modb.getOutNo());
		flag = modd.delete(outNoId); //删除明晰
		
		if(flag && list.size()<=1){
			//如果是最后一个明晰 则删除总出库单
			mobd.delete(modb.getOutNo());
		}

		if(flag){
			this.rollBackOutDetail(modb);
			request.setAttribute("success", "数据删除成功");
			url = "../imis_mate/successful.jsp";
		} else {
			request.setAttribute("fail", "数据删除失败");
			url = "../imis_mate/fail.jsp";
		}
		request.getRequestDispatcher(url).forward(request, response);
	}
	private boolean rollBackOutDetail(MateOutDetailBean modb) {
		//把出库的数量 返回给库存信息
		
		boolean flag = false;
		MaterialDAO mateDAO = new MaterialDAO();
		try {
			flag = mateDAO.rollBackOutDetail(modb);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return flag;
	}
	// 添加出库单
	public boolean insertMaterialOutTable(HttpServletRequest request,
			HttpServletResponse response) {
		boolean flag = true;
		MateOutBaseBean mobb = new MateOutBaseBean();
		mobb.setOutNo(request.getParameter("outNo").trim());
		mobb.setOutDate(request.getParameter("outDate"));
		mobb.setUserCode(request.getParameter("userCode").trim());
		mobb.setUseDep(Integer.parseInt(request.getParameter("useDep").trim()));
		mobb.setManagerBy(request.getParameter("managerBy").trim());
		mobb.setUseBy(request.getParameter("useBy").trim());
		mobb.setRoomNu(request.getParameter("roomNu").trim());
		mobb.setBuildingNu(request.getParameter("buildingNu").trim());
		mobb.setOutCause(Integer.parseInt(request.getParameter("outCause")
				.trim()));
		mobb.setReMark(request.getParameter("reMark").trim());
		MateOutBaseDAO mobd = new MateOutBaseDAO();
		request.setAttribute("outNo", mobb.getOutNo());
		flag = mobd.save(mobb) ? true : false;
		return flag;
	}

	// 修改出库单
	public boolean updateMaterialOutTable(HttpServletRequest request,
			HttpServletResponse response) {
		boolean flag = true;
		MateOutBaseBean mobb = new MateOutBaseBean();
		mobb.setOutNo(request.getParameter("outNo"));
		mobb.setOutDate(request.getParameter("outDate"));
		mobb.setUserCode(request.getParameter("userCode"));
		mobb.setUseDep(Integer.parseInt(request.getParameter("useDep")));
		mobb.setManagerBy(request.getParameter("managerBy"));
		mobb.setUseBy(request.getParameter("useBy"));
		mobb.setRoomNu(request.getParameter("roomNu"));
		mobb.setBuildingNu(request.getParameter("buildingNu"));
		mobb.setOutCause(Integer.parseInt(request.getParameter("outCause")));
		mobb.setReMark(request.getParameter("reMark"));
		MateOutBaseDAO mobd = new MateOutBaseDAO();
		request.setAttribute("outNo", mobb.getOutNo());
		flag = mobd.update(mobb) ? true : false;

		return flag;
	}

	// 删除出库单
	public boolean deleteMaterialOutTable(HttpServletRequest request,
			HttpServletResponse response) {
		boolean flag = true;
		String outNo = request.getParameter("outNo").trim();
		MateOutBaseDAO mobd = new MateOutBaseDAO();
		MateOutDetailDAO modd = new MateOutDetailDAO();
		ArrayList list = modd.getMateOutDetailBeanOfOutNo(outNo);
		flag = mobd.delete(outNo) ? true : false;
		if(modd.getMateOutDetailBeanOfOutNo(outNo).size()!=0){
		if (flag) {
			flag = modd.delete(list) ? true : false;
		}}
		return flag;
	}

	public void getMaterialOut(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		// 查询采购明细
		String url = null;

		if (request.getParameter("outId") != null) {

			MateOutDetailDAO mbdd = new MateOutDetailDAO();
			MateOutDetailBean mbdb = null;
			try {
				mbdb = mbdd.getMateOutDetailBeanOfOutNoId(Integer
						.parseInt((String) request.getParameter("outId")));

			} catch (Exception e) {
				e.printStackTrace();
			}

			
			request.setAttribute("MaterialOutDetail", mbdb);

			if (request.getParameter("page").equals("modify")) {
				url = "./MaterialOutDetail_modify.jsp";
			} else if (request.getParameter("page").equals("delete")) {
				url = "./MaterialOutDetail_delete.jsp";
			}
		}
		// 查询采购单

		else if (request.getParameter("outNo") != null) {
			MateOutBaseDAO dao = new MateOutBaseDAO();
			MateOutBaseBean mbb = null;
			try {

				mbb = dao.getMateOutBaseBeanByOutNu((String) request
						.getParameter("outNo"));

			} catch (Exception e) {
				e.printStackTrace();
			}
			HousBuildingAndRoom hbr = new HousBuildingAndRoom();
			if(mbb!=null){
				ArrayList list = hbr.getRoomListForBuildingNu(mbb.getBuildingNu());
				request.setAttribute("roomList", list);	
			}
			request.setAttribute("MaterialOutBean", mbb);

			if (request.getParameter("page").equals("modify")) {
				url = "./MaterialOutTable_modify.jsp";
			} else if (request.getParameter("page").equals("delete")) {
				url = "./MaterialOutTable_delete.jsp";
			}

		}
		request.getRequestDispatcher(url).forward(request, response);
	}

	// 可以插入出库信息
	public boolean OutNo(HttpServletRequest request,
			HttpServletResponse response) {
		boolean flag = false;
		MateOutBaseDAO dao = new MateOutBaseDAO();
		String buyNo = request.getParameter("outNo").trim();
		if (dao.getMateOutBaseBeanByOutNu(buyNo) != null) {
			flag = false;
		} else {
			flag = true;
		}
		return flag;

	}
}