进销存管理系统源代码

package com.zking.purchase.action; import java.sql.Date; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import org.apache.struts.actions.DispatchAction; import com.zking.purchase.bean.GoodsBean; import com.zking.purchase.bean.OrderBean; import com.zking.purchase.bean.StoreRoomBean; import com.zking.purchase.bean.SupplierBean; import com.zking.purchase.formbean.OrderForm; import com.zking.purchase.service.BuyerServices; import com.zking.util.PageBean; import com.zking.Login.bean.UserBean; public class OrderAction extends DispatchAction { /** * 查询跳转到新增入库单页面上所需要的数据，再转发到新增入库单据页面 * * @param mapping * @param form * @param request * @param response * @return * @throws Exception */ public ActionForward addOrder(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { BuyerServices bs = new BuyerServices(); Map<String,Object> map = null; // 对数据进行处理 map = bs.getNewPageElement(0); List<StoreRoomBean> stores = (ArrayList<StoreRoomBean>)map.get("stores");//所有仓库 List<SupplierBean> supps = (ArrayList<SupplierBean>)map.get("supps");//所有供应商 List<GoodsBean> goods =(ArrayList<GoodsBean>)map.get("goods");//所有仓库List中第一个元素对应的所有商品 request.setAttribute("stores", stores); request.setAttribute("supps", supps); request.setAttribute("goods", goods); bs.conn.close(); //request.setAttribute(name, o) // 转发请求 return mapping.findForward("addorder"); } /** * 查询跳转到新增退货单据页面上所需要的数据，再转发到新增退货单据页面 * * @param mapping * @param form * @param request * @param response * @return * @throws Exception */ public ActionForward addOrdeReturn(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { BuyerServices bs = new BuyerServices(); Map<String,Object> map = null; // 对数据进行处理 map = bs.getNewPageElement(0); List<StoreRoomBean> stores = (ArrayList<StoreRoomBean>)map.get("stores");//所有仓库 List<SupplierBean> supps = (ArrayList<SupplierBean>)map.get("supps");//所有供应商 List<GoodsBean> goods =(ArrayList<GoodsBean>)map.get("goods");//所有仓库List中第一个元素对应的所有商品 request.setAttribute("stores", stores); request.setAttribute("supps", supps); request.setAttribute("goods", goods); bs.conn.close(); // 转发请求 return mapping.findForward("addordereturn"); } /** * 从库存盘点部分针对某一种商品进行采购，查询跳转到新增入库单页面上所需要的数据，再转发到新增入库单据页面 * * @param mapping * @param form * @param request * @param response * @return * @throws Exception */ public ActionForward addOrder_Goods(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { BuyerServices bs = new BuyerServices(); Map<String,Object> map = null; // 接收数据 String goodid = request.getParameter("gid"); int gid = 0; if(goodid!=null&&goodid.length()>0){ gid=Integer.parseInt(goodid); } // 对数据进行处理 map = bs.getNewPageElement(gid); List<StoreRoomBean> stores = (ArrayList<StoreRoomBean>)map.get("stores");//所有仓库 List<SupplierBean> supps = (ArrayList<SupplierBean>)map.get("supps");//所有供应商 List<GoodsBean> goods =(ArrayList<GoodsBean>)map.get("goods");//所有仓库List中第一个元素对应的所有商品 GoodsBean addedgood = (GoodsBean)map.get("addedgood"); StoreRoomBean select_store = (StoreRoomBean) map.get("select_store"); request.setAttribute("stores", stores); request.setAttribute("supps", supps); request.setAttribute("goods", goods); request.setAttribute("addedgood", addedgood); request.setAttribute("select_store", select_store); bs.conn.close(); // 转发请求 return mapping.findForward("addorder"); } /** * 修改入库单的请求，将要修改的入库单的详细信息储存在request中，转发到编辑入库单的页面 * * * @param mapping * @param form * ActionForm，转换为OrderForm * @param request * @param response * @return * @throws Exception */ public ActionForward editOrder(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { Map<String,Object> map = null; BuyerServices bs = new BuyerServices(); // 接收数据 OrderForm of = (OrderForm) form; int oid = of.getOid(); OrderBean order = bs.getOrderDetail(oid); // 对数据进行处理 request.setAttribute("order", order); map = bs.getNewPageElement(0); List<StoreRoomBean> stores = (ArrayList<StoreRoomBean>)map.get("stores");//所有仓库 List<SupplierBean> supps = (ArrayList<SupplierBean>)map.get("supps");//所有供应商 List<GoodsBean> goods =(ArrayList<GoodsBean>)map.get("goods");//所有仓库List中第一个元素对应的所有商品 request.setAttribute("stores", stores); request.setAttribute("supps", supps); request.setAttribute("goods", goods); bs.conn.close(); // 转发请求 return mapping.findForward("editorder"); } /** * 修改退货单的请求，将要修改的退货单的详细信息储存在request中，转发到编辑退货单的页面 * * @param mapping * @param form * ActionForm，转换为OrderForm * @param request * @param response * @return * @throws Exception */ public ActionForward editOrdeReturn(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { Map<String,Object> map = null; BuyerServices bs = new BuyerServices(); // 接收数据 OrderForm of = (OrderForm) form; int oid = of.getOid(); OrderBean order = bs.getOrderDetail(oid); // 对数据进行处理 request.setAttribute("order", order); map = bs.getNewPageElement(0); List<StoreRoomBean> stores = (ArrayList<StoreRoomBean>)map.get("stores");//所有仓库 List<SupplierBean> supps = (ArrayList<SupplierBean>)map.get("supps");//所有供应商 List<GoodsBean> goods =(ArrayList<GoodsBean>)map.get("goods");//所有仓库List中第一个元素对应的所有商品 request.setAttribute("stores", stores); request.setAttribute("supps", supps); request.setAttribute("goods", goods); bs.conn.close(); // 转发请求 return mapping.findForward("editordereturn"); } /** * 增加入库单的方法，返回值是一个ActionForward * * @param mapping * @param form * ActionForm，转换为OrderForm * @param request * @param response * @return * @throws Exception */ public ActionForward addOrderSave(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { OrderForm oform = (OrderForm) form; OrderBean order = new OrderBean(); // 表示订单的JavaBean BuyerServices bs = new BuyerServices(); ActionForward af = new ActionForward();// 转发 Map<String, Object> resultmap = new HashMap<String, Object>(); Map<String, Object> map = new HashMap<String, Object>(); List<OrderBean> orders = new ArrayList<OrderBean>(); HttpSession session = request.getSession(); UserBean user= (UserBean) session.getAttribute("user");//当前登录采购员的信息在session中。 if(user==null) { return mapping.findForward("timeout");//登陆超时，session已经失效。 } // 接收数据 order.setBuyer(user.getSname()); // 单据的经手人 order.setOidenty(oform.getOidenty()); // 单据的编号 order.setGid(oform.getGid()); // 商品的主键，在新增时为空，不填。商品下