当前位置:   article > 正文

基于javaweb+mysql的springboot进销存管理系统(java+springboot+jpa+maven+jquery+mysql+jsp)_springblade 进销存

springblade 进销存

基于javaweb+mysql的springboot进销存管理系统(java+springboot+jpa+maven+jquery+mysql+jsp)

运行环境

Java≥8、MySQL≥5.7

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计,大作业,毕业设计,项目练习,学习演示等

功能说明

基于javaweb+mysql的SpringBoot进销存管理系统(java+springboot+jpa+maven+jquery+mysql+jsp)

项目介绍

本系统基本完成了一个基于spring boot + JPA的进销存管理系统,包括manager管理员与employee雇员两种角色。 主要实现采购管理、库存管理、销售管理、查询统计、资料管理和系统管理功能。 本系统的实现使用了很多计算机技术,包括Java语言、Spring boot框架、 JPA持久层框架和MySQL数据库。带文档

环境需要

1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 4.数据库:MySql 5.7版本; 5.是否Maven项目:是;

技术栈

springboot+jpa+mysql+maven+jquery

使用说明

  1. 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中application.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目,项目运行成功后在浏览器中访问: 管理员登录地址:http://localhost:8080/ manager管理员账号密码:admin/123456 employee雇员账号密码:test/123456
	 */
	@RequestMapping("/multipageUp")
	public String getPurchaseUp(HttpServletRequest request,Model model){
		Long pageNum =Long.parseLong(request.getParameter("curPage"));
		try {
			if(pageNum<=(totaPage-1)){
				goodsList = systemService.findGoodsByPage((int)(pageNum-0));
				curtPage = pageNum+1;
			}else if(pageNum == totaPage){
				goodsList = systemService.findGoodsByPage((int)(pageNum-1));
				curtPage = pageNum;
			}
		} catch (ServiceException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		model.addAttribute("curtPage", curtPage);
		model.addAttribute("goodsList", goodsList);
		return "allGoods";
		
	}
	
	/**
	 * suppliers分页功能中 首页 尾页
	 * @param request
	 * @param model
	 * @return
	 */
	@RequestMapping("/multipage1")
	public String getPurchase1(HttpServletRequest request,Model model){		
		Long pageNum =Long.parseLong(request.getParameter("curPage"));
		try {
			suppliersList = suppliersAndCustomerService.findSuppliersByPage((int)(pageNum-1));
		} catch (ServiceException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		curtPage = pageNum;
		model.addAttribute("curtPage", curtPage);
		model.addAttribute("goodsList", suppliersList);
		return "suppliers-list";
		
	}
	
	/**
	 * suppliers分页功能中上一页
	 * @param request
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
				} catch (ServiceException e) {
					
					e.printStackTrace();
				}
				app.setAttribute("messageCount", count);
				app.setAttribute("user",managers);
				app.setAttribute("role",Role.Manager.value());
				req.getRequestDispatcher("/WEB-INF/jsp/index.jsp").forward(req, resp);
			}else{
				logger.info("登录失败,用户名或者密码错误");
				HttpSession session = req.getSession();
				session.setAttribute("msg","用户名或者密码错误");
				req.getRequestDispatcher("/WEB-INF/jsp/login.jsp").forward(req, resp);
			}
		}else if("employee".equals(user)){
			Employee employee = null;
			try {
				employee = managerService.employeelogin(name, password);
			} catch (ServiceException e) {
				e.printStackTrace();
			}
			if(employee!=null){			
				logger.info(name+"登录成功!!!");
				ServletContext app = req.getSession().getServletContext();
				try {
					Long count = managerService.findMessageCount();
					app.setAttribute("messageCount", count);
					app.setAttribute("user",employee);
					app.setAttribute("role",Role.Employee.value());
					req.getRequestDispatcher("/WEB-INF/jsp/index.jsp").forward(req, resp);
				} catch (ServiceException e) {
					e.printStackTrace();
				}
			}else{
				logger.info("登录失败,用户名或者密码错误");
				HttpSession session = req.getSession();
				session.setAttribute("msg","用户名或者密码错误");
				req.getRequestDispatcher("/WEB-INF/jsp/login.jsp").forward(req, resp);
			}
		}else{
			logger.info("登录失败,没有选择用户类型");
			HttpSession session = req.getSession();
			session.setAttribute("msg","请选择用户类型");
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
	 * @param request
	 * @param model
	 * @return
	 */
	@RequestMapping("/multipage")
	public String getPurchase(HttpServletRequest request,Model model){		
		Long pageNum =Long.parseLong(request.getParameter("curPage"));
		try {
			returnList = returnPurchaseService.findReturnOrderByPage((int)(pageNum-1));
		} catch (ServiceException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		currPage = pageNum;
		model.addAttribute("currPage", currPage);
		model.addAttribute("returnList", returnList);
		return "returnPurchase-list";
		
	}
	
	/**
	 * 分页功能中上一页
	 * @param request
	 * @param model
	 * @return
	 */
	@RequestMapping("/multipageDown")
	public String getPurchaseDown(HttpServletRequest request,Model model){
		Long pageNum =Long.parseLong(request.getParameter("curPage"));
		try {
			if(pageNum>1){
				returnList = returnPurchaseService.findReturnOrderByPage((int)(pageNum-2));
				currPage = pageNum-1;
			}else if(pageNum == 1){
				returnList = returnPurchaseService.findReturnOrderByPage((int)(pageNum-1));
				currPage = pageNum;
			}
		} catch (ServiceException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}		
		model.addAttribute("currPage", currPage);
		model.addAttribute("returnList", returnList);
		return "returnPurchase-list";
		
	}
	
	/**
	 * 分页功能中下一页
	 * @param request
	 * @param model
	 * @return
	 */
	@RequestMapping("/multipageUp")
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
		try {
			Long count = queryService.findGoodsOrderByTimeAndName(min,max,orderName);
			model.addAttribute("name",orderName);
			model.addAttribute("count", count);
		} catch (ServiceException e) {
			e.printStackTrace();
		}
		return "querySaleOrder";
	}
	
	/**
	 * 查询商品
	 * @param request
	 * @param model
	 * @return
	 */
	@RequestMapping("/queryGoods")
	public String querygoods(HttpServletRequest request,Model model){
		String name = request.getParameter("goodName");
		try {
			Goods goods = queryService.findGoodsByName(name);
			if (goods != null) {
				model.addAttribute("goods",goods);

			}
		} catch (ServiceException e) {
			
			e.printStackTrace();
		}
		return "queryGoods";
	}
	
	/**
	 * 查询客户
	 * @param request
	 * @param model
	 * @return
	 */
	@RequestMapping("/queryEmployee")
	public String querycustomer(HttpServletRequest request,Model model){
		String name = request.getParameter("customerName");
		try {
			Customer customer = queryService.findCustomerByName(name);
			model.addAttribute("customer",customer);
		} catch (ServiceException e) {
			
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
			// TODO Auto-generated catch block
			e.printStackTrace();
		}		
		model.addAttribute("curPage", curPage);
		model.addAttribute("outList", outList);
		return "stock";
		
	}
	
	/**
	 * 分页功能中下一页
	 * @param request
	 * @param model
	 * @return
	 */
	@RequestMapping("/multipageUp1")
	public String getPurchaseUp1(HttpServletRequest request,Model model){
		Long pageNum =Long.parseLong(request.getParameter("curPage"));
		try {
			if(pageNum<=(totPage-1)){
				outList = stockService.findStockByPage((int)(pageNum-0));
				curPage = pageNum+1;
			}else if(pageNum == totPage){
				outList = stockService.findStockByPage((int)(pageNum-1));
				curPage = pageNum;
			}
		} catch (ServiceException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		model.addAttribute("curPage", curPage);
		model.addAttribute("outList", outList);
		return "stock";
		
	}
}

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
	@RequestMapping("/stockquery")
	public String forwordStockQuery(){
		
		
		return "queryStock";
		
	}
	/**
	 * 商品库存查询
	 * @param request
	 * @param model
	 * @return
	 */
	@RequestMapping("/query")
	public String stockQuery(HttpServletRequest request,Model model){
		logger.info("库存查询开始");
		Long goodsId = Long.parseLong(request.getParameter("goodsId"));
		try {
			Stock stock = stockService.findStockByGoodsId(goodsId);
			model.addAttribute("sock", stock);
			logger.info("库存查询完成");
		} catch (ServiceException e) {			
			e.printStackTrace();
		}
		return "queryStock";
		
	}
	
	/**
	 * 跳转到移库页面
	 * @param model
	 * @return
	 */
	@RequestMapping("/area")
	public String forwordStockArea(Model model){
		try {
			
			outList = stockService.findStockByPage(0);
			coun = stockService.findStockCount();
			curPage = 1L;
			totPage = stockService.getTotalPage();
			model.addAttribute("coun", coun);
			model.addAttribute("curPage", curPage);
			model.addAttribute("totPage", totPage);
			model.addAttribute("outList", outList);
		} catch (ServiceException e) {			
			e.printStackTrace();
		}
		return "updateArea";
	}
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50

@Controller
@RequestMapping("/sale")
@SessionAttributes(value={"cunt","crrentPage","ttalPage","saleorderList","itemList"})
public class SaleController {
	private Logger logger = LoggerFactory.getLogger(this.getClass());
	private List<SaleItem> itemList = new ArrayList<SaleItem>();
	private List<SaleOrder> saleorderList = new ArrayList<SaleOrder>();
	private Long cunt;
	private Long crrentPage;
	private Long ttalPage;
	@Resource
	private SaleService saleService;
	@Resource
	private StockService stockService;
	/**
	 * 此方法用于跳转到销售订单页面
	 * @return
	 */
	@RequestMapping(value="/gotosale")
	public String turn(Model model){
		try {
			saleorderList = saleService.findSaleOrderByPage(0);
			cunt = saleService.findSaleOrderCount();
			crrentPage = 1L;
			ttalPage = saleService.getTotalPage();
			model.addAttribute("crrentPage", crrentPage);
			model.addAttribute("ttalPage", ttalPage);
			model.addAttribute("saleorderList", saleorderList);
			model.addAttribute("cunt", cunt);
		} catch (ServiceException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return "sale";
	}
	
	
	/**
	 * 此方法用于跳转到发货页面
	 * @return
	 */
	@RequestMapping(value="/gotooutsale")
	public String turns(Model model){
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
	 * @return
	 */
	@RequestMapping("/multipageUp1")
	public String getPurchaseUp1(HttpServletRequest request,Model model){
		Long pageNum =Long.parseLong(request.getParameter("curPage"));
		try {
			if(pageNum<=(ttalPage-1)){
				saleorderList = saleService.findSaleOrderByPage((int)(pageNum-0));
				crrentPage = pageNum+1;
			}else if(pageNum == ttalPage){
				saleorderList = saleService.findSaleOrderByPage((int)(pageNum-1));
				crrentPage = pageNum;
			}
		} catch (ServiceException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		model.addAttribute("currentPage", crrentPage);
		model.addAttribute("saleorderList", saleorderList);
		return "out-salestock";
		
	}
}

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
					app.setAttribute("messageCount", count);
					app.setAttribute("user",employee);
					app.setAttribute("role",Role.Employee.value());
					req.getRequestDispatcher("/WEB-INF/jsp/index.jsp").forward(req, resp);
				} catch (ServiceException e) {
					e.printStackTrace();
				}
			}else{
				logger.info("登录失败,用户名或者密码错误");
				HttpSession session = req.getSession();
				session.setAttribute("msg","用户名或者密码错误");
				req.getRequestDispatcher("/WEB-INF/jsp/login.jsp").forward(req, resp);
			}
		}else{
			logger.info("登录失败,没有选择用户类型");
			HttpSession session = req.getSession();
			session.setAttribute("msg","请选择用户类型");
			req.getRequestDispatcher("/WEB-INF/jsp/login.jsp").forward(req, resp);
		}
	}

	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(req, resp);
	}
	
}

@Controller
@RequestMapping("/manager")
public class ManagerRegisterController {
	private Logger logger = LoggerFactory.getLogger(this.getClass());
	@Resource
	private ManagerService managerRegisterService;
	
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
	 * @param model
	 * @return
	 */
	@RequestMapping("/multipage1")
	public String getPurchase1(HttpServletRequest request,Model model){		
		Long pageNum =Long.parseLong(request.getParameter("curPage"));
		try {
			outList = stockService.findStockByPage((int)(pageNum-1));
		} catch (ServiceException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		curPage = pageNum;
		model.addAttribute("curPage", curPage);
		model.addAttribute("outList", outList);
		return "stock";
		
	}
	
	/**
	 * 分页功能中上一页
	 * @param request
	 * @param model
	 * @return
	 */
	@RequestMapping("/multipageDown1")
	public String getPurchaseDown1(HttpServletRequest request,Model model){
		Long pageNum =Long.parseLong(request.getParameter("curPage"));
		try {
			if(pageNum>1){
				outList = stockService.findStockByPage((int)(pageNum-2));
				curPage = pageNum-1;
			}else if(pageNum == 1){
				outList = stockService.findStockByPage((int)(pageNum-1));
				curPage = pageNum;
			}
		} catch (ServiceException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}		
		model.addAttribute("curPage", curPage);
		model.addAttribute("outList", outList);
		return "stock";
		
	}
	
	/**
	 * 分页功能中下一页
	 * @param request
	 * @param model
	 * @return
	 */
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
		Long pageNum =Long.parseLong(request.getParameter("curPage"));
		try {
			if(pageNum>1){
				saleorderList = saleService.findSaleOrderByPage((int)(pageNum-2));
				crrentPage = pageNum-1;
			}else if(pageNum == 1){
				saleorderList = saleService.findSaleOrderByPage((int)(pageNum-1));
				crrentPage = pageNum;
			}
		} catch (ServiceException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}		
		model.addAttribute("currentPage", crrentPage);
		model.addAttribute("saleorderList", saleorderList);
		return "sale";
		
	}
	
	/**
	 * 分页功能中下一页
	 * @param request
	 * @param model
	 * @return
	 */
	@RequestMapping("/multipageUp")
	public String getPurchaseUp(HttpServletRequest request,Model model){
		Long pageNum =Long.parseLong(request.getParameter("curPage"));
		try {
			if(pageNum<=(ttalPage-1)){
				saleorderList = saleService.findSaleOrderByPage((int)(pageNum-0));
				crrentPage = pageNum+1;
			}else if(pageNum == ttalPage){
				saleorderList = saleService.findSaleOrderByPage((int)(pageNum-1));
				crrentPage = pageNum;
			}
		} catch (ServiceException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		model.addAttribute("currentPage", crrentPage);
		model.addAttribute("saleorderList", saleorderList);
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
			if(pageNum<=(ttalPage-1)){
				saleorderList = saleService.findSaleOrderByPage((int)(pageNum-0));
				crrentPage = pageNum+1;
			}else if(pageNum == ttalPage){
				saleorderList = saleService.findSaleOrderByPage((int)(pageNum-1));
				crrentPage = pageNum;
			}
		} catch (ServiceException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		model.addAttribute("currentPage", crrentPage);
		model.addAttribute("saleorderList", saleorderList);
		return "sale";
		
	}
	
	
	/**
	 * 分页功能中 首页 尾页
	 * @param request
	 * @param model
	 * @return
	 */
	@RequestMapping("/multipage1")
	public String getPurchase1(HttpServletRequest request,Model model){		
		Long pageNum =Long.parseLong(request.getParameter("curPage"));
		try {
			saleorderList = saleService.findSaleOrderByPage((int)(pageNum-1));
		} catch (ServiceException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		crrentPage = pageNum;
		model.addAttribute("currentPage", crrentPage);
		model.addAttribute("saleorderList", saleorderList);
		return "out-salestock";
		
	}
	
	/**
	 * 分页功能中上一页
	 * @param request
	 * @param model
	 * @return
	 */
	@RequestMapping("/multipageDown1")
	public String getPurchaseDown1(HttpServletRequest request,Model model){
		Long pageNum =Long.parseLong(request.getParameter("curPage"));
		try {
			if(pageNum>1){
				saleorderList = saleService.findSaleOrderByPage((int)(pageNum-2));
				crrentPage = pageNum-1;
			}else if(pageNum == 1){
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
	 * @return
	 */
	@RequestMapping("/multipage")
	public String getPurchase(HttpServletRequest request,Model model){		
		Long pageNum =Long.parseLong(request.getParameter("curPage"));
		try {
			returnsList = saleReturnService.findReturnOrderByPage((int)(pageNum-1));
		} catch (ServiceException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		cutPage = pageNum;
		model.addAttribute("cutPage", cutPage);
		model.addAttribute("returnsList", returnsList);
		return "salereturn";
		
	}
	
	/**
	 * 分页功能中上一页
	 * @param request
	 * @param model
	 * @return
	 */
	@RequestMapping("/multipageDown")
	public String getPurchaseDown(HttpServletRequest request,Model model){
		Long pageNum =Long.parseLong(request.getParameter("curPage"));
		try {
			if(pageNum>1){
				returnsList = saleReturnService.findReturnOrderByPage((int)(pageNum-2));
				cutPage = pageNum-1;
			}else if(pageNum == 1){
				returnsList = saleReturnService.findReturnOrderByPage((int)(pageNum-1));
				cutPage = pageNum;
			}
		} catch (ServiceException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}		
		model.addAttribute("cutPage", cutPage);
		model.addAttribute("returnsList", returnsList);
		return "salereturn";
		
	}
	
	/**
	 * 分页功能中下一页
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
		return "queryStock";
		
	}
	/**
	 * 商品库存查询
	 * @param request
	 * @param model
	 * @return
	 */
	@RequestMapping("/query")
	public String stockQuery(HttpServletRequest request,Model model){
		logger.info("库存查询开始");
		Long goodsId = Long.parseLong(request.getParameter("goodsId"));
		try {
			Stock stock = stockService.findStockByGoodsId(goodsId);
			model.addAttribute("sock", stock);
			logger.info("库存查询完成");
		} catch (ServiceException e) {			
			e.printStackTrace();
		}
		return "queryStock";
		
	}
	
	/**
	 * 跳转到移库页面
	 * @param model
	 * @return
	 */
	@RequestMapping("/area")
	public String forwordStockArea(Model model){
		try {
			
			outList = stockService.findStockByPage(0);
			coun = stockService.findStockCount();
			curPage = 1L;
			totPage = stockService.getTotalPage();
			model.addAttribute("coun", coun);
			model.addAttribute("curPage", curPage);
			model.addAttribute("totPage", totPage);
			model.addAttribute("outList", outList);
		} catch (ServiceException e) {			
			e.printStackTrace();
		}
		return "updateArea";
	}
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
		Long orderId =Long.parseLong(request.getParameter("orderId"));
		try {
			List<SaleItem> saleItem = saleService.delPurchaseItemByPurchaseId(orderId);
			SaleOrder saleOrder = saleService.delOrderByPurchaseId(orderId);
			if("已发货".equals(saleOrder.getFlag())){
				saleService.updateStockBySaleReturnOrder(saleItem);
			}
			itemsList = saleReturnService.addSaleReturnOrder(saleOrder, saleItem);
			returnsList = saleReturnService.findReturnOrderByPage(0);
			cont = saleReturnService.findReturnOrderCount();
			cutPage = 1L;
			talPage = saleReturnService.getTotalPage();
			model.addAttribute("itemsList", itemsList);
			model.addAttribute("returnsList", returnsList);
			model.addAttribute("cont", cont);
			model.addAttribute("cutPage", cutPage);
			model.addAttribute("talPage", talPage);
			logger.info("销售退货订单添加成功");
			return "salereturn";
		} catch (Exception e) {
			e.printStackTrace();
			return "salereturn";
		}
		
	}
	
	/**
	 * 跳转到退货首页
	 * @param model
	 * @return
	 */
	@RequestMapping("/forwordSaleReturn")
	public String forwordSale(Model model){
		try {
			returnsList = saleReturnService.findReturnOrderByPage(0);
			cont = saleReturnService.findReturnOrderCount();
			cutPage = 1L;
			talPage = saleReturnService.getTotalPage();
			model.addAttribute("itemsList", itemsList);
			model.addAttribute("returnsList", returnsList);
			model.addAttribute("cont", cont);
			model.addAttribute("cutPage", cutPage);
			model.addAttribute("talPage", talPage);
		} catch (ServiceException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}	catch (EmptyResultDataAccessException e) {
			return null;
		}			
		return "salereturn";
	}
	
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
	@RequestMapping("/gotoIndex")
	public String index(){
		
		return "index";
	}
	/**
	 * 查看所有商品
	 * @param model
	 * @return
	 */
	@RequestMapping("/goods")
	public String goods(Model model){
		try {
			goodsList = systemService.findGoodsByPage(0);
			couns = systemService.findGoodsCount();
			curtPage = 1L;
			totaPage = systemService.getTotalPage();
			model.addAttribute("couns", couns);
			model.addAttribute("curtPage", curtPage);
			model.addAttribute("totaPage", totaPage);
			model.addAttribute("goodsList", goodsList);
		} catch (ServiceException e) {
			e.printStackTrace();
		}
		return "allGoods";
	}
	
	/**
	 * 跳转到供应商资料首页
	 * @param model
	 * @return
	 */
	@RequestMapping("/gotoSuppliers")
	public String forwordsuppliers(Model model){
		try {
			suppliersList = suppliersAndCustomerService.findSuppliersByPage(0);
			couns = suppliersAndCustomerService.findSuppliersCount();
			curtPage = 1L;
			totaPage = suppliersAndCustomerService.getTotalPage();
			model.addAttribute("couns", couns);
			model.addAttribute("curtPage", curtPage);
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
				model.addAttribute("totalPage", totalPage);
				model.addAttribute("orderList", orderList);
				model.addAttribute("count", count);
				logger.info("提交采购订单成功");
			}
		} catch (ServiceException e) {
			e.printStackTrace();
		}
		return "article-list";
	}
	
	/**
	 * 分页功能中 首页 尾页
	 * @param request
	 * @param model
	 * @return
	 */
	@RequestMapping("/multipage")
	public String getPurchase(HttpServletRequest request,Model model){		
		Long pageNum =Long.parseLong(request.getParameter("curPage"));
		try {
			orderList = managerService.findPurchaseOrderByPage((int)(pageNum-1));
		} catch (ServiceException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		currentPage = pageNum;
		model.addAttribute("currentPage", currentPage);
		model.addAttribute("orderList", orderList);
		return "article-list";
		
	}
	
	/**
	 * 分页功能中上一页
	 * @param request
	 * @param model
	 * @return
	 */
	@RequestMapping("/multipageDown")
	public String getPurchaseDown(HttpServletRequest request,Model model){
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
			e.printStackTrace();
		}
		
		return "message";
	}
	
	/**
	 * 修改个人信息
	 * @param req
	 * @return
	 */
	@RequestMapping("/updatInformation")
	public String updateInformation(HttpServletRequest req){
		String gender = req.getParameter("gender");
		Long age = Long.parseLong(req.getParameter("age"));
		String phonenumber = req.getParameter("phonenumber");
		ServletContext app = req.getSession().getServletContext();
		Object attribute = app.getAttribute("user");
		HttpSession session = req.getSession();
		if(attribute instanceof Employee){
			((Employee) attribute).setGender(gender);
			((Employee) attribute).setAge(age);
			((Employee) attribute).setPhonenumber(phonenumber);
			try {
				Employee employee = managerService.updateEmplyeeByName((Employee)attribute);
				app.setAttribute("user",employee);
				session.setAttribute("mess", "信息成功修改");
			} catch (ServiceException e) {
				e.printStackTrace();
			}
			return "information";
		}else if(attribute instanceof Managers){
			((Managers) attribute).setAge(age);
			((Managers) attribute).setGender(gender);
			((Managers) attribute).setPhonenumber(phonenumber);
			try {
				Managers managers = managerService.updateManagersByName((Managers) attribute);
				app.setAttribute("user",managers);
				session.setAttribute("mess", "信息成功修改");
			} catch (ServiceException e) {
				e.printStackTrace();
			}
			return "information";
		}else{
			session.setAttribute("mess", "信息成功失败,请重新输入");
			return "information";
		}
	}
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48

请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述

声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/你好赵伟/article/detail/464848
推荐阅读
相关标签
  

闽ICP备14008679号