materialouttableservlet.java

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

package imis_mate.servlet;

import imis_mate.DAO.HousBuildingAndRoom;
import imis_mate.DAO.MateOutBaseDAO;
import imis_mate.DAO.MateOutDetailDAO;
import imis_mate.DAO.MaterialDAO;

import imis_mate.bean.MateOutBaseBean;
import imis_mate.bean.MateOutDetailBean;
import imis_mate.bean.MaterialBean;

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

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

public class MaterialOutTableServlet extends HttpServlet {

	/**
	 * 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").trim();
		String success = "数据添加成功!";
		String fail = "数据添加失败!";

		if (pattern.equals("insert")) {
			if (OutNo(request, response)) {
				if (insertMaterialOutTable(request, response)) {
					request.setAttribute("success", success);
					request.getRequestDispatcher(
							"../imis_mate/MaterialOutTableSuccessful.jsp")
							.forward(request, response);
				} else {
					request.setAttribute("fail", fail);
					request.getRequestDispatcher(
							"../imis_mate/MaterialOutTableFail.jsp").forward(
							request, response);
				}
			} else {

				request.setAttribute("MaterialTypeNoExisted", "该出库编号已存在");
				request.getRequestDispatcher(
						"../imis_mate/MaterialOutTable_insert.jsp").forward(
						request, response);
			}
		} else if (pattern.equals("insertnew")) {
			if (OutNo(request, response)) {
				if (insertMaterialOutTable(request, response)) {
					request.setAttribute("success", success);
					request.getRequestDispatcher(
							"../imis_mate/MaterialOutDetail_insert.jsp")
							.forward(request, response);
				} else {
					request.setAttribute("fail", fail);
					request.getRequestDispatcher(
							"../imis_mate/MaterialOutDetailFail.jsp").forward(
							request, response);
				}
			} else {

				request.setAttribute("MaterialTypeNoExisted", "该出库编号已存在");
				request.getRequestDispatcher(
						"../imis_mate/MaterialOutTable_insert.jsp").forward(
						request, response);
			}

		} else if (pattern.equals("insertDetail")) {

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

			if (insertMaterialOutDetail(request, response)) {
				request.setAttribute("success", success);
				request.setAttribute("tishi", "详细信息已添加.");
				request.getRequestDispatcher(
						"../imis_mate/MaterialOutDetail_insert.jsp").forward(
						request, response);
			} else {
				request.setAttribute("fail", fail);
				request
						.getRequestDispatcher(
								"../imis_mate/MaterialOutFail.jsp").forward(
								request, response);
			}
		}

		else if (pattern.equals("mod")) {
			if (updateMaterialOutTable(request, response)) {
				request.setAttribute("success", "数据修改成功");
				request.getRequestDispatcher(
						"../imis_mate/successful.jsp").forward(
						request, response);
			} else {
				request.setAttribute("fail", "数据修改失败");
				request.getRequestDispatcher(
						"../imis_mate/fail.jsp").forward(
						request, response);
			}
		} else if (pattern.equals("modDetail")) {
			this.updateMaterialOutDetail(request, response);
//			if (updateMaterialOutDetail(request, response)) {
//				request.setAttribute("success", "数据修改成功");
//				request.getRequestDispatcher(
//						"../imis_mate/successful.jsp").forward(
//						request, response);
//			} else {
//				request.setAttribute("fail", "数据修改失败");
//				request.getRequestDispatcher(
//						"../imis_mate/fail.jsp").forward(
//						request, response);
//			}
		} else if (pattern.equals("delete")) {
			if (deleteMaterialOutTable(request, response)) {
				request.setAttribute("success", "数据删除成功");
				request.getRequestDispatcher(
						"../imis_mate/successful.jsp").forward(
						request, response);
			} else {
				request.setAttribute("fail", "数据删除失败");
				request.getRequestDispatcher(
						"../imis_mate/fail.jsp").forward(
						request, response);
			}
		} else if (pattern.equals("delDetail")) {
			if (deleteMaterialOutDetail(request, response)) {
				request.setAttribute("success", "数据删除成功");
				request.getRequestDispatcher(
						"../imis_mate/successful.jsp").forward(
						request, response);
			} else {
				request.setAttribute("fail", "数据删除失败");
				request.getRequestDispatcher(
						"../imis_mate/fail.jsp").forward(
						request, response);
			}
		} else if (pattern.equals("getMaterialOut")) {

			getMaterialOut(request, response);

		} else if (pattern.equals("addOutDetail")) {
			// 成功页面 跳转到详细信息页面

			this.addOutDetail(request, response);

		} else if (pattern.equals("search")) {
			// 多条件查询
			this.search(request, response);
		} else if (pattern.equals("deleteDetail")){
			//删除出库明细 2008-04-09 增加回滚功能 增加判断是否是最后一个明晰 如果是 则删除总出库单
			this.deleteOutDetail(request, response);
		}
	}

	private void search(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// 多条件查询
		MateOutBaseBean mate = new MateOutBaseBean();
		MateOutDetailBean mateD = new MateOutDetailBean();
		ArrayList list = null;
		mateD.setMaterialTypeNo(request.getParameter("materialTypeNo")); // 物品类型
		mate.setUseDep(request.getParameter("useDep")); // 领用部门
		String startDate = request.getParameter("startDate"); // 起始时间
		String endDate = request.getParameter("endDate"); // 结束时间

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

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

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

	}

	// 添加出库单明细
	private boolean insertMaterialOutDetail(HttpServletRequest request,
			HttpServletResponse response) {
		// TODO Auto-generated method stub
		boolean flag = false;
		MateOutDetailBean modb = new MateOutDetailBean();
		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((request.getParameter("materialNo")));
		modb.setPriceUnit(request.getParameter("priceUnit"));
		modb.setOutCount(request.getParameter("outCount"));
		MateOutDetailDAO modd = new MateOutDetailDAO();