materialbuytableservlet.java

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

package imis_mate.servlet;

import imis_mate.DAO.DAOFactory;
import imis_mate.DAO.MateBuyDAO;
import imis_mate.DAO.MaterialBuyDetailDAO;
import imis_mate.DAO.MaterialDAO;
import imis_mate.bean.MaterialBean;
import imis_mate.bean.MaterialBuyBean;
import imis_mate.bean.MaterialBuyDetailBean;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class MaterialBuyTableServlet extends HttpServlet {

	private String buyNo;

	/**
	 * The doGet method of the servlet. <br>
	 * 
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request
	 *            the request send by the client to the server
	 * @param response
	 *            the response send by the server to the client
	 * @throws ServletException
	 *             if an error occurred
	 * @throws IOException
	 *             if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doPost(request, response);
	}

	/**
	 * The doPost method of the servlet. <br>
	 * 
	 * This method is called when a form has its tag value method equals to
	 * post.
	 * 
	 * @param request
	 *            the request send by the client to the server
	 * @param response
	 *            the response send by the server to the client
	 * @throws ServletException
	 *             if an error occurred
	 * @throws IOException
	 *             if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		String pattern = request.getParameter("pattern");
		String success = "数据添加成功!";
		String fail = "数据添加失败!";
		if (pattern.equals("insert")) {
			if (BuyNo(request, response)) {
				if (insertMaterialBuyTable(request, response)) {
					request.setAttribute("success", success);
					request.getRequestDispatcher(
							"../imis_mate/MaterialBuySuccessful.jsp").forward(
							request, response);
				} else {
					request.setAttribute("fail", fail);
					request.getRequestDispatcher(
							"../imis_mate/MaterialBuyFail.jsp").forward(
							request, response);
				}
			} else {
				
						request.setAttribute("MaterialTypeNoExisted", "该采购编号已存在");
						request.getRequestDispatcher("../imis_mate/MaterialBuyTable_insert.jsp").forward(
						request, response);
			}

		} else if (pattern.equals("insertnew")) {
			if (BuyNo(request, response)) {

			if (insertMaterialBuyTable(request, response)) {
				request.setAttribute("success", success);
				request.getRequestDispatcher(
						"../imis_mate/MaterialBuyDetail_insert.jsp").forward(
						request, response);
			} else {
				request.setAttribute("fail", fail);
				request
						.getRequestDispatcher(
								"../imis_mate/MaterialBuyFail.jsp").forward(
								request, response);
			}
			} else {
				
				request.setAttribute("MaterialTypeNoExisted", "该采购编号已存在");
				request.getRequestDispatcher("../imis_mate/MaterialBuyTable_insert.jsp").forward(
				request, response);
	}
		} else if (pattern.equals("insertDetail")) {

			if (insertMaterialBuyDetail(request, response)) {
				request.setAttribute("success", success);
				request.setAttribute("tishi", "详细信息已添加。");
				request.getRequestDispatcher(
						"../imis_mate/MaterialBuySuccessful.jsp").forward(
						request, response);
			} else {
				request.setAttribute("fail", fail);
				request
						.getRequestDispatcher(
								"../imis_mate/MaterialBuyFail.jsp").forward(
								request, response);
			}
		} else if (pattern.equals("insertDetailnew")) {

			if (insertMaterialBuyDetail(request, response)) {
				request.setAttribute("success", success);
				request.setAttribute("tishi", "详细信息已添加.");
				request.getRequestDispatcher(
						"../imis_mate/MaterialBuyDetail_insertupdate.jsp").forward(
						request, response);
			} else {
				request.setAttribute("fail", fail);
				request
						.getRequestDispatcher(
								"../imis_mate/MaterialBuyFail.jsp").forward(
								request, response);
			}
		} else if (pattern.equals("mod")) {
			if (updateMaterialBuyTable(request, response)) {
				request.setAttribute("success", "采购单信息修改成功");
				request.getRequestDispatcher(
						"../imis_mate/MaterialBuyTable_modify.jsp").forward(
						request, response);
			} else {
				request.setAttribute("fail", "采购信息修改失败");
				request
						.getRequestDispatcher(
								"../imis_mate/MaterialBuyFail.jsp").forward(
								request, response);
			}
		} else if (pattern.equals("modDetail")) {
			if (updateMaterialBuyDetail(request, response)) {
				request.setAttribute("success", "采购单明细修改成功");
				request.getRequestDispatcher(
						"../imis_mate/MaterialBuyDetail_modify.jsp").forward(
						request, response);
			} else {
				request.setAttribute("fail", "采购单明细修改失败");
				request
						.getRequestDispatcher(
								"../imis_mate/MaterialBuyFail.jsp").forward(
								request, response);
			}
		} else if (pattern.equals("delete")) {
			if (deleteMaterialBuyTable(request, response)) {
				request.setAttribute("success", "采购单删除成功");
				request.getRequestDispatcher(
						"../imis_mate/MaterialBuyTable_delete.jsp").forward(
						request, response);
			} else {
				request.setAttribute("fail", "采购单删除失败");
				request
						.getRequestDispatcher(
								"../imis_mate/MaterialBuyFail.jsp").forward(
								request, response);
			}
		} else if (pattern.equals("delDetail")) {
			if (deleteMaterialBuyDetail(request, response)) {
				request.setAttribute("success", "采购单明细删除成功");
				request.getRequestDispatcher(
						"../imis_mate/MaterialBuyDetail_delete.jsp").forward(
						request, response);
			} else {
				request.setAttribute("fail", "采购单明细删除失败");
				request
						.getRequestDispatcher(
								"../imis_mate/MaterialBuyFail.jsp").forward(
								request, response);
			}
		} else if (pattern.equals("getMaterialBuy")) {

			getMaterialBuy(request, response);
		} else if (pattern.equals("search")) {
			// 多条件查询

			this.search(request, response);

			//getMaterialBuy(request, response);
		} else if (pattern.equals("addBuyDetail")) {
			// 成功页面 跳转到详细信息页面

			this.addBuyDetail(request, response);

		}//查询该采购信息的明细
		else if(pattern.equals("selectdetail")){
			this.selectDetail(request,response);
		}//明细结果返回查询采购信息
		else if(pattern.equals("getBuyBean")){
			
			this.getBuyBean(request, response);
		}else if(pattern.equals("deleteBuyDetail")) {
			//删除采购明细 2008-04-09  增加判断是否是最后一个明晰 如果是 则删除总采购单
			this.deleteBuyDetail(request, response);
		}
		 //退货操作
		else if(pattern.equals("reFlag")){
			
			if (setReFlag(request, response)) {
				request.setAttribute("success", "该采购物品已退货");
				request.getRequestDispatcher(
						"../imis_mate/MaterialBuyDetail_modify.jsp").forward(
						request, response);
			} else {
				request.setAttribute("fail", "该采购物品退货失败");
				request
						.getRequestDispatcher(
								"../imis_mate/MaterialBuyFail.jsp").forward(
								request, response);
		}
		}
		
	}



	

	private boolean setReFlag(HttpServletRequest request, HttpServletResponse response) {
		// 退货操作
		boolean flag = true;
		MaterialBuyDetailBean mbdb = new MaterialBuyDetailBean();
		mbdb.setBuyId(Integer.parseInt(request.getParameter("buyId")));
		MaterialBuyDetailDAO mbdd = new MaterialBuyDetailDAO();
		try {
			flag = mbdd.updateReFlag(mbdb);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return flag;
	}

	private void addBuyDetail(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		// 成功页面 跳转到详细信息页面
		// request.setAttribute("buyNo",request.getAttribute("buyNo"));

		request.setAttribute("buyNo", request.getParameter("buyNo"));
		request.getRequestDispatcher(
				"../imis_mate/MaterialBuyDetail_insert.jsp").forward(request,
				response);

	}

	private void search(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// 多条件查询
		MaterialBuyBean mate = new MaterialBuyBean();
		MaterialBuyDetailBean mateD = new MaterialBuyDetailBean();
		ArrayList list = null;
//		mateD.setMaterialTypeName(request.getParameter("materialTypeName"));
		mateD.setMaterialTypeNo(request.getParameter("materialTypeNo")); // 物品类型
		mateD.setFlag(request.getParameter("flag")); //退货标志
		mateD.setReFlag(request.getParameter("reFlag")); //入库标志
		
		mate.setApplyDep(request.getParameter("applyDep")); // 申请部门
		String startDate = request.getParameter("startDate"); // 起始时间
		String endDate = request.getParameter("endDate"); // 结束时间

		MateBuyDAO mateDAO = new MateBuyDAO();
		try {
			list = mateDAO.search(mate, mateD, startDate, endDate); // 调DAO
		} catch (Exception e) {
			e.printStackTrace();
		}
		request.getSession().setAttribute("mateBuyBySearchList", list);
		request.getRequestDispatcher(
				"../imis_mate/MaterialBuyTable_bysearch.jsp").forward(request,
				response);

	}

	// 插入采购单