materialbuytableservlet.java

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

	public boolean insertMaterialBuyTable(HttpServletRequest request,
			HttpServletResponse response) {
		boolean flag = true;
		MaterialBuyBean mbb = new MaterialBuyBean();
		mbb.setBuyNo(request.getParameter("buyNo").trim());
		mbb.setPayType(request.getParameter("payType"));
		mbb.setRePay(request.getParameter("rePay"));
		mbb.setAcPay(request.getParameter("acPay"));
		mbb.setInDate(request.getParameter("inDate"));
		mbb.setBuyDep(Integer.parseInt(request.getParameter("buyDep").trim()));
		mbb.setBuyBy(request.getParameter("buyBy").trim());
		mbb.setApplyDep(Integer.parseInt(request.getParameter("applyDep")
				.trim()));
		mbb.setApplyBy(request.getParameter("applyBy").trim());
		mbb.setUseDep(Integer.parseInt(request.getParameter("useDep").trim()));
		mbb.setUseBy(request.getParameter("useBy").trim());
		mbb.setBuyFor(request.getParameter("buyFor").trim());
		mbb.setSupplyNo(Integer.parseInt(request.getParameter("supplyNo")
				.trim()));
		mbb.setPerBy(request.getParameter("perBy").trim());
		mbb.setReMark(request.getParameter("remark").trim());
		MateBuyDAO mbd = new MateBuyDAO();

		request.setAttribute("buyNo", mbb.getBuyNo());
		flag = mbd.save(mbb) ? true : false;
		// this.buyNo =
		return flag;
	}

	// 修改采购单
	public boolean updateMaterialBuyTable(HttpServletRequest request,
			HttpServletResponse response) {
		boolean flag = true;
		MaterialBuyBean mbb = new MaterialBuyBean();
		MaterialBuyDetailDAO dao2 = new MaterialBuyDetailDAO();
		String oldbuyNo = ((String) request.getParameter("oldbuyNo")).trim();
		mbb.setBuyNo(request.getParameter("buyNo").trim());
		mbb.setPayType(request.getParameter("payType").trim());
		mbb.setRePay(request.getParameter("rePay"));
		mbb.setAcPay(request.getParameter("acPay"));
		mbb.setInDate(request.getParameter("inDate").trim());
		mbb.setBuyDep(Integer.parseInt(request.getParameter("buyDep").trim()));
		mbb.setBuyBy(request.getParameter("buyBy").trim());
		mbb.setApplyDep(Integer.parseInt(request.getParameter("applyDep")
				.trim()));
		mbb.setApplyBy(request.getParameter("applyBy").trim());
		mbb.setUseDep(Integer.parseInt(request.getParameter("useDep").trim()));
		mbb.setUseBy(request.getParameter("useBy").trim());
		mbb.setBuyFor(request.getParameter("buyFor").trim());
		mbb.setSupplyNo(Integer.parseInt(request.getParameter("supplyNo")
				.trim()));
		mbb.setPerBy(request.getParameter("perBy").trim());
		mbb.setReMark(request.getParameter("remark").trim());
		MateBuyDAO mbd = new MateBuyDAO();

		request.setAttribute("buyNo", mbb.getBuyNo());
		if(mbd.update(oldbuyNo,mbb)){
			flag = dao2.update(oldbuyNo, mbb.getBuyNo());
		}
		
		return flag;
	}

	// 删除采购单
	public boolean deleteMaterialBuyTable(HttpServletRequest request,
			HttpServletResponse response) {
		boolean flag = true;
		String buyNo = request.getParameter("buyNo").trim();

		MateBuyDAO dao1 = new MateBuyDAO();
		MaterialBuyDetailDAO dao2 = new MaterialBuyDetailDAO();
		flag = dao1.delete(buyNo);

		if (flag) {
			flag = dao2.delete(buyNo);
		}
		return flag;
	}

	// 采购明晰
	public boolean insertMaterialBuyDetail(HttpServletRequest request,
			HttpServletResponse response) {
		boolean flag = true;
		MaterialBuyDetailBean mbdb = new MaterialBuyDetailBean();
		mbdb.setBuyNo(request.getParameter("buyNo"));
		mbdb.setMaterialTypeName(request.getParameter("materialTypeName"));
		mbdb.setMaModel(request.getParameter("maModel"));
		mbdb.setMaBrand(request.getParameter("maBrand"));
		mbdb.setMaMadeIn(request.getParameter("maMadeIn"));
		mbdb.setMaterialTypeNo(request.getParameter("materialTypeNo"));
		mbdb.setPriceUnit((request.getParameter("priceUnit")));
		mbdb.setInCount((request.getParameter("inCount")));
		
		MaterialBuyDetailDAO mbdd = new MaterialBuyDetailDAO();
		request.setAttribute("buyNo", mbdb.getBuyNo());
		flag = mbdd.save(mbdb) ? true : false;
		return flag;
	}

	// 修改采购单明细
	public boolean updateMaterialBuyDetail(HttpServletRequest request,
			HttpServletResponse response) {
		boolean flag = true;
		MaterialBuyDetailBean mbdb = new MaterialBuyDetailBean();
		mbdb.setBuyId(Integer.parseInt(request.getParameter("buyId")));
		mbdb.setBuyNo(request.getParameter("buyNo").trim());
		mbdb.setMaterialTypeName(request.getParameter("materialTypeName")
				.trim());
		mbdb.setMaModel(request.getParameter("maModel").trim());
		mbdb.setMaBrand(request.getParameter("maBrand").trim());
		mbdb.setMaMadeIn(request.getParameter("maMadeIn").trim());
		mbdb.setMaterialTypeNo(request.getParameter("materialTypeNo").trim());
		mbdb.setPriceUnit(Double.parseDouble(request.getParameter("priceUnit")
				.trim()));
		mbdb.setInCount(Integer
				.parseInt(request.getParameter("inCount").trim()));
		MaterialBuyDetailDAO mbdd = new MaterialBuyDetailDAO();
		request.setAttribute("buyNo", mbdb.getBuyNo());
		flag = mbdd.update(mbdb) ? true : false;

		return flag;
	}

	public boolean deleteMaterialBuyDetail(HttpServletRequest request,
			HttpServletResponse response) {
		boolean flag = true;
		int buyId = Integer.parseInt(request.getParameter("buyId").trim());
		MaterialBuyDetailDAO mbdd = new MaterialBuyDetailDAO();
		flag = mbdd.delete(buyId);
		return flag;
	}
	private void deleteBuyDetail(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException{
		//删除采购明细 2008-04-09  增加判断是否是最后一个明晰 如果是 则删除总采购单
		boolean flag = false;
		int buyId = Integer.parseInt(request.getParameter("buyId").trim());
		String url = "../imis_mate/fail.jsp";
		MaterialBuyDetailBean mbdb = new MaterialBuyDetailBean();
		MaterialBuyDetailDAO mbdd = new MaterialBuyDetailDAO();
		MateBuyDAO mbd = new MateBuyDAO();
		
		mbdb = mbdd.getMaterialBuyDetailOfBuyId(buyId);
		ArrayList list = mbdd.getMaterialBuyDetailOfBuyNo(mbdb.getBuyNo());
		flag = mbdd.delete(buyId);
		if(flag && list.size()<=1){
			//如果是最后一个明晰 则删除总单
			mbd.delete(mbdb.getBuyNo());
		}
		if(flag){
			request.setAttribute("success", "数据删除成功");
			url = "../imis_mate/successful.jsp";
		} else {
			request.setAttribute("fail", "数据删除失败");
			url = "../imis_mate/fail.jsp";
		}
		request.getRequestDispatcher(url).forward(request, response);
	}

	public void getMaterialBuy(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		// 查询采购明细
		String url = null;
		if (request.getParameter("buyId") != null) {

			MaterialBuyDetailDAO mbdd = new MaterialBuyDetailDAO();
			MaterialBuyDetailBean mbdb = new MaterialBuyDetailBean();
			try {
				mbdb = mbdd.getMaterialBuyDetailOfBuyId(Integer
						.parseInt((String) request.getParameter("buyId")));

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

			request.setAttribute("MaterialBuyDetail", mbdb);

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

		// 查询采购单

		else if (request.getParameter("buyNo") != null) {
			MateBuyDAO dao = new MateBuyDAO();
			MaterialBuyBean mbb = null;
			
			try {

				mbb = dao.getMateBuyByBuyNo((String) request
						.getParameter("buyNo"));

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

			request.setAttribute("MaterialBuyBean", mbb);

			if (request.getParameter("page").equals("modify")) {
				url = "./MaterialBuyTable_modify.jsp";

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

			}
			

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

	}

	// 可以插入采购信息
	public boolean BuyNo(HttpServletRequest request,
			HttpServletResponse response) {
		boolean flag = false;
		MateBuyDAO dao = new MateBuyDAO();
		String buyNo = request.getParameter("buyNo").trim();
		if (dao.getMateBuyByBuyNo(buyNo) != null) {
			flag = false;
		} else {
			flag = true;
		}
		return flag;

	}
	
	
	//查询该采购buyno明细信息
	private void selectDetail(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		MaterialBuyBean mbb = new MaterialBuyBean();
		ArrayList list = null;
		mbb.setBuyNo(request.getParameter("buyNo"));
		mbb.setPayType(request.getParameter("payType"));
		mbb.setRePay(request.getParameter("rePay"));
		mbb.setAcPay(request.getParameter("acPay"));
		mbb.setInDate(request.getParameter("inDate"));
		mbb.setBuyDep(request.getParameter("buyDep"));
		mbb.setBuyBy(request.getParameter("buyBy").trim());
		mbb.setApplyDep(request.getParameter("applyDep")
				);
		mbb.setApplyBy(request.getParameter("applyBy").trim());
		mbb.setUseDep(Integer.parseInt(request.getParameter("useDep").trim()));
		mbb.setUseBy(request.getParameter("useBy").trim());
		mbb.setBuyFor(request.getParameter("buyFor").trim());
		mbb.setSupplyNo(Integer.parseInt(request.getParameter("supplyNo")
				.trim()));
		mbb.setPerBy(request.getParameter("perBy").trim());
		mbb.setReMark(request.getParameter("remark").trim());
		MaterialBuyDetailDAO dao = new MaterialBuyDetailDAO();
		try {
			list = dao.getMaterialBuyDetailOfBuyNo(mbb.getBuyNo()); // 调DAO
		} catch (Exception e) {
			e.printStackTrace();
		}
		request.getSession().setAttribute("materialDetailList", list);
		request.setAttribute("MaterialBuyBean", mbb);
		request.getRequestDispatcher(
				"../imis_mate/MaterialBuyTableDetail_insert.jsp").forward(request,
				response);
	}
	//	明细结果返回查询采购信息
	private void getBuyBean(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		
		MateBuyDAO dao = new MateBuyDAO();
		MaterialBuyBean mbb = null;
		MaterialBuyDetailDAO dao1 = new MaterialBuyDetailDAO();
		String url = null;
		ArrayList list = null;
		try {

			mbb = dao.getMateBuyByBuyNo((String) request
					.getParameter("buyNo"));

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			list = dao1.getMaterialBuyDetailOfBuyNo(mbb.getBuyNo()); // 调DAO
		} catch (Exception e) {
			e.printStackTrace();
		}
		request.getSession().setAttribute("materialDetailList", list);

		request.setAttribute("MaterialBuyBean", mbb);
		request.getRequestDispatcher("./MaterialBuyTableDetail_insert.jsp").forward(request, response);
	}
	
}