cgorderservlet.java

企业进销存源码

package com.web.servlet;

import java.io.IOException;
import java.util.HashMap;

import javax.servlet.ServletException;

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

import com.business.vo.CgPlan;
import com.common.util.Chinese;
import com.dao.util.DaoImp;
import com.web.util.*;

/**
 * @version 	1.0
 * @author
 */
public class CgOrderServlet extends BaseServlet {

	/**
	* @see javax.servlet.http.HttpServlet#void (javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	*/
	public void work(HttpServletRequest req, HttpServletResponse resp)
		throws IOException, ServletException, Exception {
		try {
			DaoImp dao = new DaoImp();
			if (req.getParameter("actionType").equals("add")) {
				String str =
					"insert into cgorder(dates,supplierId) values('"
						+ Chinese.toChinese(
							WebTools.showEx(req.getParameter("dates")))
						+ "','"
						+ Chinese.toChinese(
							WebTools.showEx(req.getParameter("supplierId")))
						+ "')";
				dao.insert(str);
				str = "select top 1 id from cgorder order by id desc";
				HashMap map = dao.find(str);
				for (int i = 0;i < req.getParameterValues("goodsName").length;i++) {
					str =
						"insert into cgOrdergoods(goodsName,goodsNum,gg,xh,goodsPrice,memo,orderId) values('"
							+ Chinese.toChinese(
								WebTools.showEx(
									req.getParameterValues("goodsName")[i]))
							+ "','"
							+ req.getParameterValues("goodsNum")[i]
							+ "','"
							+ Chinese.toChinese(
								WebTools.showEx(
									req.getParameterValues("gg")[i]))
							+ "','"
							+ Chinese.toChinese(
								WebTools.showEx(
									req.getParameterValues("xh")[i]))
							+ "','"
							+ req.getParameterValues("goodsPrice")[i]
							+ "','"
							+ Chinese.toChinese(
								WebTools.showEx(
									req.getParameterValues("memos")[i]))
							+ "','"
							+ WebTools.showEx(map.get("ID"))
							+ "')";
					System.out.println(str);
					dao.insert(str);
				}

				pManage.setCurrentPageUrl("/cg/order_add.jsp");
				pManage.setMessagePageUrl(successUrl);
				pManage.addPageEntity("返回列表页面", "/cg/order_list.jsp", "", "");
				req.getSession().setAttribute("SYSTEM_SUCCESS", "采购定单添加成功");
			}

			if (req.getParameter("actionType").equals("del")) {
				for (int i = 0;
					i < req.getParameterValues("f_ID").length;
					i++) {
					String str =
						"delete from cgorder where id = "
							+ WebTools.showEx(req.getParameterValues("f_ID")[i]);
					dao.delete(str);
					str =
						"delete from cgorderGoods where orderid = "
							+ WebTools.showEx(req.getParameterValues("f_ID")[i]);
					dao.delete(str);
				}

				pManage.setCurrentPageUrl("/cg/order_list.jsp");
				pManage.setMessagePageUrl(successUrl);
				req.getSession().setAttribute("SYSTEM_SUCCESS", "采购定单删除成功");
			}
			
		} catch (Exception e) {
			if (req.getParameter("actionType").equals("add")) {
				pManage.setCurrentPageUrl("/cg/order_add.jsp");
				pManage.setMessagePageUrl(successUrl);
				pManage.addPageEntity("返回列表页面", "/cg/order_list.jsp", "", "");
				req.getSession().setAttribute("SYSTEM_FAILURE", "采购定单添加失败");
			}

			if (req.getParameter("actionType").equals("del")) {
				pManage.setCurrentPageUrl("/cg/order_list.jsp");;
				pManage.setMessagePageUrl(successUrl);
				req.getSession().setAttribute("SYSTEM_FAILURE", "采购定单删除失败");
			}
			throw e;
		}
	}

}