devbox
羊村懒王
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Java项目:超市进销存管理系统(java+SpringBoot+Html+Layui+echarts+mysql)_java mysql超市库存数量用数据类型

作者：羊村懒王 | 2024-03-26 11:25:01

赞

踩

java mysql超市库存数量用数据类型

源码获取：博客首页 "资源" 里下载！

项目介绍

超市进销存管理系统,分为管理员与普通员工两种角色；

管理员主要功能包括：

员工管理：员工的添加、编辑、删除；

普通员工主要功能包括：

供应商管理：供应商的添加、删除、修改；

商品管理：商品种类管理、商品信息管理；

库存管理；

订单管理；

环境需要

1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。
2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可
4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS；
5.是否Maven项目: 是；查看源码目录中是否包含pom.xml；若包含，则为maven项目，否则为非maven项目
6.数据库：MySql 5.7版本；
7.lombok 注：一定要安装，否则会有问题；

技术栈

1. 后端：SpringBoot+Mybatis

2. 前端：Html+jQuery+Layui+echarts

使用说明

1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；

2.使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;若为maven项目，导入成功后请执行maven clean;maven install命令，配置tomcat，然后运行；

3. 将项目中application.yml配置文件中的数据库配置改为自己的配置;

4. 管理员访问地址：http://localhost:8085/admin

5. 员工访问地址：http://localhost:8085

 

 

 

 

 

 

前端控制器用户控制层： 

  1. /**
  2.  * <p>
  3.  * 前端控制器
  4.  * </p>
  5.  *
  6.  */
  7. @RestController
  8. @RequestMapping("/user")
  9. public class UserController {
  10.  
  11.     @Autowired
  12.     private UserService userService;
  13.  
  14.     @Autowired
  15.     private RoleService roleService;
  16.  
  17.  
  18.     /**
  19.      * 登录
  20.      *
  21.      * @param username 用户名
  22.      * @param password 密码
  23.      * @param request
  24.      * @return
  25.      */
  27.     @SysLog("登陆操作")
  28.     @PostMapping("/login")
  29.     public Result login(String username, String password, HttpServletRequest request) {
  30.         try {
  31.             //获取当前登录主体对象
  32.             Subject subject = SecurityUtils.getSubject();
  33.             UsernamePasswordToken token = new UsernamePasswordToken(username, password);
  34.             subject.login(token);
  35.             LoginUserVO userDTO = (LoginUserVO) subject.getPrincipal();
  36.             request.getSession().setAttribute("username", userDTO.getUser());
  37.             return Result.success(true, "200", "登录成功");
  38.         } catch (UnknownAccountException e) {
  39.             e.printStackTrace();
  40.             return Result.error(false, "400", "登录失败,用户名不存在");
  41.         }catch (IncorrectCredentialsException e) {
  42.             e.printStackTrace();
  43.             return Result.error(false, "400", "登录失败,密码错误");
  44.         }catch (AuthenticationException e) {
  45.             e.printStackTrace();
  46.             return Result.error(false, "400", "登录失败,账户禁用");
  47.         }
  48.     }
  49.  
  50.     /**
  51.      * 得到登陆验证码
  52.      * @param response
  53.      * @param session
  54.      * @throws IOException
  55.      */
  56.     @RequestMapping("/getCode")
  57.     public void getCode(HttpServletResponse response, HttpSession session) throws IOException {
  58.         //定义图形验证码的长和宽
  59.         LineCaptcha lineCaptcha = CaptchaUtil.createLineCaptcha(116, 36,4,5);
  60.         session.setAttribute("code",lineCaptcha.getCode());
  61.         try {
  62.             ServletOutputStream outputStream = response.getOutputStream();
  63.             lineCaptcha.write(outputStream);
  64.             outputStream.close();
  65.         } catch (IOException e) {
  66.             e.printStackTrace();
  67.         }
  68.     }
  69.  
  70.     /**
  71.      * 查询所有用户信息
  72.      *
  73.      * @param userVO
  74.      * @return
  75.      */
  76.     @SysLog("用户查询操作")
  77.     @RequestMapping("/userList")
  78.     public DataGridViewResult userList(UserVO userVO) {
  79.         //分页构造函数
  80.         IPage<User> page = new Page<>(userVO.getPage(), userVO.getLimit());
  81.         QueryWrapper<User> queryWrapper = new QueryWrapper<>();
  82.         queryWrapper.like(!StringUtils.isEmpty(userVO.getUsername()), "username", userVO.getUsername());
  83.         queryWrapper.like(!StringUtils.isEmpty(userVO.getUname()), "uname", userVO.getUname());
  84.         /**
  85.          * 翻页查询
  86.          * @param page         翻页对象
  87.          * @param queryWrapper 实体对象封装操作类
  88.          */
  89.         IPage<User> userIPage = userService.page(page, queryWrapper);
  90.         return new DataGridViewResult(userIPage.getTotal(), userIPage.getRecords());
  91.     }
  92.  
  93.     /**
  94.      * 添加用户信息
  95.      *
  96.      * @param user
  97.      * @return
  98.      */
  99.     @SysLog("用户添加操作")
  100.     @PostMapping("/adduser")
  101.     public Result addRole(User user) {
  102.  
  103.  
  104.         user.setUcreatetime(new Date());
  105.         String salt = UUIDUtil.randomUUID();
  106.         user.setPassword(PasswordUtil.md5("000000", salt, 2));
  107.         user.setSalt(salt);
  108.         user.setType(1);
  109.         boolean bool = userService.save(user);
  110.  
  111.         try {
  112.             if (bool) {
  113.                 return Result.success(true, "200", "添加成功！");
  114.             }
  115.         } catch (Exception e) {
  116.             e.printStackTrace();
  117.         }
  118.         return Result.error(false, null, "添加失败！");
  119.     }
  120.  
  121.     /**
  122.      * 校验用户名是否存在
  123.      *
  124.      * @param username
  125.      * @return
  126.      */
  128.     @RequestMapping("/checkUserName")
  129.     public String checkUserName(String username) {
  130.         Map<String, Object> map = new HashMap<>();
  131.         try {
  132.             QueryWrapper<User> queryWrapper = new QueryWrapper<>();
  133.             queryWrapper.eq("username", username);
  134.             User user = userService.getOne(queryWrapper);
  135.             if (user != null) {
  136.                 map.put("exist", true);
  137.                 map.put("message", "用户名已存在");
  138.             } else {
  139.                 map.put("exist", false);
  140.                 map.put("message", "用户名可以使用");
  141.             }
  142.         } catch (Exception e) {
  143.             e.printStackTrace();
  144.         }
  145.         return JSON.toJSONString(map);
  146.     }
  147.  
  148.     /**
  149.      * 修改用户信息
  150.      *
  151.      * @param user
  152.      * @return
  153.      */
  154.     @SysLog("用户修改操作")
  155.     @PostMapping("/updateuser")
  156.     public Result updateUser(User user) {
  157.  
  158.         boolean bool = userService.updateById(user);
  159.         try {
  160.             if (bool) {
  161.                 return Result.success(true, "200", "修改成功！");
  162.             }
  163.         } catch (Exception e) {
  164.             e.printStackTrace();
  165.         }
  166.         return Result.error(false, null, "修改失败！");
  167.     }
  168.  
  169.     /**
  170.      * 删除单条数据
  171.      *
  172.      * @param id
  173.      * @return
  174.      */
  175.     @SysLog("用户删除操作")
  176.     @RequestMapping("/deleteOne")
  177.     public Result deleteOne(int id) {
  178.         boolean bool = userService.removeById(id);
  179.         try {
  180.             if (bool) {
  181.                 return Result.success(true, "200", "删除成功！");
  182.             }
  183.         } catch (Exception e) {
  184.             e.printStackTrace();
  185.         }
  186.         return Result.error(false, null, "删除失败！");
  187.     }
  188.  
  189.     /**
  190.      * 重置密码
  191.      *
  192.      * @param id
  193.      * @return
  194.      */
  195.     @SysLog("用户修改操作")
  196.     @PostMapping("/resetPwd")
  197.     public Result resetPwd(int id) {
  198.  
  199.         User user = new User();
  200.         String salt = UUIDUtil.randomUUID();
  201.         user.setUid(id);
  202.         user.setPassword(PasswordUtil.md5("000000", salt, 2));
  203.         user.setSalt(salt);
  204.         boolean bool = userService.updateById(user);
  205.  
  206.         try {
  207.             if (bool) {
  208.                 return Result.success(true, "200", "重置成功！");
  209.             }
  210.         } catch (Exception e) {
  211.             e.printStackTrace();
  212.         }
  213.         return Result.error(false, null, "重置失败！");
  214.     }
  215.  
  216.     /**
  217.      * 根据id查询当前用户拥有的角色
  218.      *
  219.      * @param id
  220.      * @return
  221.      */
  222.     @RequestMapping("/initRoleByUserId")
  223.     public DataGridViewResult initRoleByUserId(int id) {
  224.         List<Map<String, Object>> mapList = null;
  225.         try {
  226.             //查询所有角色列表
  227.             mapList = roleService.listMaps();
  228.             //根据用户id查询用户拥有的角色
  229.             Set<Integer> roleIdList = userService.findRoleByUserId(id);
  230.             for (Map<String, Object> map : mapList) {
  231.                 //定义标记 默认不选中
  232.                 boolean flag = false;
  233.                 int roleId = (int) map.get("roleid");
  234.                 for (Integer rid : roleIdList) {
  235.                     if (rid == roleId) {
  236.                         flag = true;
  237.                         break;
  238.                     }
  239.                 }
  240.                 map.put("LAY_CHECKED", flag);
  241.             }
  242.         } catch (Exception e) {
  243.             e.printStackTrace();
  244.         }
  245.         return new DataGridViewResult(Long.valueOf(mapList.size()), mapList);
  246.  
  247.     }
  248.  
  249.     /**
  250.      * 为用户分配角色
  251.      *
  252.      * @param roleids
  253.      * @param userid
  254.      * @return
  255.      */
  256.     @SysLog("用户添加操作")
  257.     @RequestMapping("/saveUserRole")
  258.     public Result saveUserRole(String roleids, int userid) {
  259.  
  260.         try {
  261.             if (userService.saveUserRole(userid, roleids)) {
  262.                 return Result.success(true, null, "分配成功");
  263.             }
  264.  
  265.         } catch (Exception e) {
  266.             e.printStackTrace();
  267.         }
  268.         return Result.error(false, null, "分配失败");
  269.  
  270.     }
  271.  
  272.     /**
  273.      * 修改密码
  274.      *
  275.      * @param newPassWord1
  276.      * @param newPassWord2
  277.      * @return
  278.      */
  279.     @RequestMapping("/updateUserPassWord")
  280.     public Result updateUserPassWord(String newPassWord1, String newPassWord2,HttpSession session) {
  281.         User sessionUser = (User) session.getAttribute("username");
  282.  
  283.         if (newPassWord1.equals(newPassWord2)){
  284.             User user = new User();
  285.             String salt = UUIDUtil.randomUUID();
  286.             user.setUid(sessionUser.getUid());
  287.             user.setPassword(PasswordUtil.md5(newPassWord1, salt, 2));
  288.             user.setSalt(salt);
  289.             boolean bool = userService.updateById(user);
  290.             if (bool){
  291.                 return Result.success(true,null,"修改成功");
  292.             }else {
  293.                 return Result.error(false,null,"修改失败!");
  294.             }
  295.         }else {
  296.             return Result.error(false,null,"修改失败，两次密码不一致!");
  297.         }
  298.  
  299.     }
  300.  
  301. }
  302.

前端控制器角色控制层：

  1. /**
  2.  * <p>
  3.  * 前端控制器
  4.  * </p>
  5.  *
  6.  */
  7. @RestController
  8. @RequestMapping("/role")
  9. public class RoleController {
  10.  
  11.     @Autowired
  12.     private RoleService roleService;
  13.  
  14.     @Autowired
  15.     private PermissionService permissionService;
  16.  
  17.     /**
  18.      * 查询所有角色信息
  19.      * @param roleVO
  20.      * @return
  21.      */
  22.     @SysLog("角色查询操作")
  23.     @RequestMapping("/roleList")
  24.     public DataGridViewResult roleList(RoleVO roleVO) {
  25.         //分页构造函数
  26.         IPage<Role> page = new Page<>(roleVO.getPage(), roleVO.getLimit());
  27.         QueryWrapper<Role> queryWrapper = new QueryWrapper<>();
  28.         queryWrapper.like(!StringUtils.isEmpty(roleVO.getRolename()), "rolename", roleVO.getRolename());
  29.         /**
  30.          * 翻页查询
  31.          *
  32.          * @param page         翻页对象
  33.          * @param queryWrapper 实体对象封装操作类 {@link com.baomidou.mybatisplus.core.conditions.query.QueryWrapper}
  34.          */
  35.         IPage<Role> roleIPage = roleService.page(page, queryWrapper);
  36.         return new DataGridViewResult(roleIPage.getTotal(), roleIPage.getRecords());
  37.     }
  38.  
  39.     /**
  40.      * 添加角色信息
  41.      *
  42.      * @param role
  43.      * @return
  44.      */
  45.     @SysLog("角色添加操作")
  46.     @PostMapping("/addrole")
  47.     public Result addRole(Role role) {
  48.         boolean bool = roleService.save(role);
  49.         try {
  50.             if (bool) {
  51.                 return Result.success(true, "200", "添加成功！");
  52.             }
  53.         } catch (Exception e) {
  54.             e.printStackTrace();
  55.         }
  56.         return Result.error(false, null, "添加失败！");
  57.     }
  58.  
  59.  
  60.     /**
  61.      * 修改角色信息
  62.      *
  63.      * @param role
  64.      * @return
  65.      */
  66.     @SysLog("角色修改操作")
  67.     @PostMapping("/updaterole")
  68.     public Result updateRole(Role role) {
  69.         boolean bool = roleService.updateById(role);
  70.         try {
  71.             if (bool) {
  72.                 return Result.success(true, "200", "修改成功！");
  73.             }
  74.         } catch (Exception e) {
  75.             e.printStackTrace();
  76.         }
  77.         return Result.error(false, null, "修改失败！");
  78.     }
  79.  
  80.     /**
  81.      * 删除单条数据
  82.      *
  83.      * @param id
  84.      * @return
  85.      */
  86.     @SysLog("角色删除操作")
  87.     @RequestMapping("/deleteOne")
  88.     public Result deleteOne(int id) {
  89.         boolean bool = roleService.removeById(id);
  90.         try {
  91.             if (bool) {
  92.                 return Result.success(true, "200", "删除成功！");
  93.             }
  94.         } catch (Exception e) {
  95.             e.printStackTrace();
  96.         }
  97.         return Result.error(false, null, "删除失败！");
  98.     }
  99.  
  100.  
  101.     /**
  102.      * 初始化权限菜单树
  103.      *
  104.      * @param roleId
  105.      * @return
  106.      */
  107.     @RequestMapping("/initPermissionByRoleId")
  108.     public DataGridViewResult initPermissionByRoleId(int roleId) {
  109.         //创建条件构造器对象
  110.         QueryWrapper<Permission> queryWrapper = new QueryWrapper<>();
  111.         List<Permission> permissionList = permissionService.list();
  112.         List<Integer> currentPermissionIds = permissionService.findRolePermissionIdByRoleId(roleId);
  113.         //保存角色拥有的菜单
  114.         List<Permission> currentPermissions = new ArrayList<>();
  115.         if (currentPermissionIds != null && currentPermissionIds.size() > 0) {
  116.             queryWrapper.in("id", currentPermissionIds);
  117.             currentPermissions = permissionService.list(queryWrapper);
  118.         }
  119.         List<TreeNode> treeNodes = new ArrayList<>();
  120.         for (Permission p1 : permissionList) {
  121.             //定义变量标记是否选中
  122.             String checkArr = "0";
  123.             for (Permission p2 : currentPermissions) {
  124.                 if (p1.getId().equals(p2.getId())) {
  125.                     checkArr = "1";
  126.                     break;
  127.                 }
  128.             }
  129.             Boolean spread = p1.getSpread() == 1 ? true : false;
  130.             treeNodes.add(new TreeNode(p1.getId(), p1.getPid(), p1.getTitle(), spread, checkArr));
  131.         }
  132.         return new DataGridViewResult(treeNodes);
  133.     }
  134.  
  135.     /**
  136.      * 保存分配权限关系方法
  137.      *
  138.      * @param roleid
  139.      * @param ids
  140.      * @return
  141.      */
  142.     @SysLog("角色添加操作")
  143.     @RequestMapping("/saveRolePermission")
  144.     public Result saveRolePermission(int roleid, String ids) {
  145.  
  146.         try {
  147.             if (roleService.saveRolePermission(roleid, ids)) {
  148.                 return Result.success(true, null, "分配成功");
  149.             }
  150.  
  151.         } catch (Exception e) {
  152.             e.printStackTrace();
  153.         }
  154.         return Result.error(false, null, "分配失败");
  155.  
  156.     }
  157. }

前端控制器客户管理： 

  1. /**
  2.  * <p>
  3.  *  前端控制器
  4.  * </p>
  5.  *
  6.  */
  7. @RestController
  8. @RequestMapping("/customer")
  9. public class CustomerController {
  10.  
  11.     @Autowired
  12.     private CustomerService customerService;
  13.  
  14.  
  15.     /**
  16.      * 客户模糊查询
  17.      * @param
  18.      * @return
  19.      */
  20.     @SysLog("客户查询操作")
  21.     @RequestMapping("/customerList")
  22.     public DataGridViewResult customerList(CustomerVO customerVO) {
  23.  
  24.         //创建分页信息    参数1 当前页  参数2 每页显示条数
  25.         IPage<Customer> page = new Page<>(customerVO.getPage(), customerVO.getLimit());
  26.         QueryWrapper<Customer> queryWrapper = new QueryWrapper<>();
  27.         queryWrapper.like(!StringUtils.isEmpty(customerVO.getCustvip()),"custvip", customerVO.getCustvip());
  28.         IPage<Customer> customerIPage = customerService.page(page, queryWrapper);
  29.         /**
  30.          * logsIPage.getTotal() 总条数
  31.          * logsIPage.getRecords() 分页记录列表
  32.          */
  33.         return new DataGridViewResult(customerIPage.getTotal(),customerIPage.getRecords());
  34.  
  35.     }
  36.  
  37.     /**
  38.      * 客户批量删除
  39.      * @param ids
  40.      * @return
  41.      */
  42.     @SysLog("客户删除操作")
  43.     @RequestMapping("/deleteList")
  44.     public Result deleteList(String ids) {
  45.         //将字符串拆分成数组
  46.         String[] idsStr = ids.split(",");
  47.         List<String> list = Arrays.asList(idsStr);
  48.         boolean bool = customerService.removeByIds(list);
  49.         if(bool){
  50.             return Result.success(true,"200","删除成功！");
  51.         }
  52.         return Result.error(false,null,"删除失败！");
  53.     }
  54.  
  55.     /**
  56.      * 添加客户信息
  57.      * @param customer
  58.      * @return
  59.      */
  60.     @SysLog("客户添加操作")
  61.     @PostMapping("/addcustomer")
  62.     public Result addCustomer(Customer customer){
  63.         String id = RandomStringUtils.randomAlphanumeric(10);
  64.  
  65.         customer.setCustvip(id);
  66.         boolean bool = customerService.save(customer);
  67.         if(bool){
  68.             return Result.success(true,"200","添加成功！");
  69.         }
  70.         return Result.error(false,null,"添加失败！");
  71.     }
  72.  
  73.     /**
  74.      * 修改客户信息
  75.      * @param customer
  76.      * @return
  77.      */
  78.     @SysLog("客户修改操作")
  79.     @PostMapping("/updatecustomer")
  80.     public Result updateCustomer(Customer customer){
  81.  
  82.         boolean bool = customerService.updateById(customer);
  83.         if(bool){
  84.             return Result.success(true,"200","修改成功！");
  85.         }
  86.         return Result.error(false,null,"修改失败！");
  87.     }
  88.  
  89.     /**
  90.      * 删除单条数据
  91.      * @param id
  92.      * @return
  93.      */
  94.     @SysLog("客户删除操作")
  95.     @RequestMapping("/deleteOne")
  96.     public Result deleteOne(int id) {
  97.  
  98.         boolean bool = customerService.removeById(id);
  99.         if(bool){
  100.             return Result.success(true,"200","删除成功！");
  101.         }
  102.         return Result.error(false,null,"删除失败！");
  103.     }
  104.  
  105.  
  106.  
  107.     /**
  108.      *
  109.      * 加载下拉框
  110.      * @return
  111.      */
  112.     @RequestMapping("/loadAllCustomer")
  113.     public DataGridViewResult loadAllCustomer(){
  114.         QueryWrapper<Customer> queryWrapper = new QueryWrapper<>();
  115.         List<Customer> list = customerService.list(queryWrapper);
  116.         return new DataGridViewResult(list);
  117.  
  118.     }
  119.  
  120. }

商品管理控制层：

  1. /**
  2.  * <p>
  3.  * 前端控制器
  4.  * </p>
  5.  *
  6.  */
  7. @RestController
  8. @RequestMapping("/goods")
  9. public class GoodsController {
  10.  
  11.  
  12.     @Autowired
  13.     private GoodsService goodsService;
  14.  
  15.     @Autowired
  16.     private ProviderService providerService;
  17.  
  18.     @Autowired
  19.     private CategoryService categoryService;
  20.  
  21.     /**
  22.      * 商品模糊查询
  23.      *
  24.      * @param
  25.      * @return
  26.      */
  27.     @SysLog("商品查询操作")
  28.     @RequestMapping("/goodsList")
  29.     public DataGridViewResult goodsList(GoodsVO goodsVO) {
  30.         //创建分页信息    参数1 当前页  参数2 每页显示条数
  31.         IPage<Goods> page = new Page<>(goodsVO.getPage(), goodsVO.getLimit());
  32.         QueryWrapper<Goods> queryWrapper = new QueryWrapper<>();
  33.         queryWrapper.eq(goodsVO.getProviderid() != null && goodsVO.getProviderid() != 0, "providerid", goodsVO.getProviderid());
  34.         queryWrapper.like(!StringUtils.isEmpty(goodsVO.getGname()), "gname", goodsVO.getGname());
  35.         IPage<Goods> goodsIPage = goodsService.page(page, queryWrapper);
  36.         List<Goods> records = goodsIPage.getRecords();
  37.         for (Goods goods : records) {
  38.             Provider provider = providerService.getById(goods.getProviderid());
  39.             if (null != provider) {
  40.                 goods.setProvidername(provider.getProvidername());
  41.             }
  42.         }
  43.         return new DataGridViewResult(goodsIPage.getTotal(), records);
  44.     }
  45.  
  46.  
  47.     /**
  48.      * 添加商品信息
  49.      *
  50.      * @param goods
  51.      * @return
  52.      */
  53.     @SysLog("商品添加操作")
  54.     @PostMapping("/addgoods")
  55.     public Result addGoods(Goods goods) {
  56.         String id = RandomStringUtils.randomAlphanumeric(8);
  57.         if (goods.getGoodsimg()!=null&&goods.getGoodsimg().endsWith("_temp")){
  58.             String newName = AppFileUtils.renameFile(goods.getGoodsimg());
  59.             goods.setGoodsimg(newName);
  60.         }
  61.         goods.setGnumbering(id);
  62.         boolean bool = goodsService.save(goods);
  63.         if (bool) {
  64.             return Result.success(true, "200", "添加成功！");
  65.         }
  66.         return Result.error(false, null, "添加失败！");
  67.     }
  68.  
  69.     /**
  70.      * 修改商品信息
  71.      *
  72.      * @param goods
  73.      * @return
  74.      */
  75.     @SysLog("商品修改操作")
  76.     @PostMapping("/updategoods")
  77.     public Result updateGoods(Goods goods) {
  78.         //商品图片不是默认图片
  79.         if (!(goods.getGoodsimg()!=null&&goods.getGoodsimg().equals(Constast.DEFAULT_IMG))){
  80.             if (goods.getGoodsimg().endsWith("_temp")){
  81.                 String newName = AppFileUtils.renameFile(goods.getGoodsimg());
  82.                 goods.setGoodsimg(newName);
  83.                 //删除原先的图片
  84.                 String oldPath = goodsService.getById(goods.getGid()).getGoodsimg();
  85.                 AppFileUtils.removeFileByPath(oldPath);
  86.             }
  87.         }
  88.         boolean bool = goodsService.updateById(goods);
  89.         if (bool) {
  90.             return Result.success(true, "200", "修改成功！");
  91.         }
  92.         return Result.error(false, null, "修改失败！");
  93.     }
  94.  
  95.  
  96.     /**
  97.      * 删除单条数据
  98.      *
  99.      * @param id
  100.      * @return
  101.      */
  102.     @SysLog("商品删除操作")
  103.     @RequestMapping("/deleteOne")
  104.     public Result deleteOne(int id) {
  105.  
  106.         boolean bool = goodsService.removeById(id);
  107.         if (bool) {
  108.             return Result.success(true, "200", "删除成功！");
  109.         }
  110.         return Result.error(false, null, "删除失败！");
  111.     }
  112.  
  113.     /**
  114.      * 根据id查询当前商品拥有的类别
  115.      *
  116.      * @param id
  117.      * @return
  118.      */
  119.     @RequestMapping("/initGoodsByCategoryId")
  120.     public DataGridViewResult initGoodsByCategoryId(int id) {
  121.         List<Map<String, Object>> mapList = null;
  122.         try {
  123.             //查询所有类别列表
  124.             mapList = categoryService.listMaps();
  125.             //根据商品id查询商品拥有的类别
  126.             Set<Integer> cateIdList = categoryService.findGoodsByCategoryId(id);
  127.             for (Map<String, Object> map : mapList) {
  128.                 //定义标记 默认不选中
  129.                 boolean flag = false;
  130.                 int cateId = (int) map.get("cateid");
  131.                 for (Integer cid : cateIdList) {
  132.                     if (cid == cateId) {
  133.                         flag = true;
  134.                         break;
  135.                     }
  136.                 }
  137.                 map.put("LAY_CHECKED", flag);
  138.             }
  139.         } catch (Exception e) {
  140.             e.printStackTrace();
  141.         }
  142.         return new DataGridViewResult(Long.valueOf(mapList.size()), mapList);
  143.  
  144.     }
  145.  
  146.     /**
  147.      * 根据商品id加载商品信息
  148.      * @param goodsid
  149.      * @return
  150.      */
  151.     @GetMapping("/loadGoodsById")
  152.     public DataGridViewResult loadGoodsById(int goodsid) {
  153.  
  154.  
  155.         QueryWrapper<Goods> goodsQueryWrapper = new QueryWrapper<>();
  156.         goodsQueryWrapper.eq(goodsid != 0, "gid", goodsid);
  157.         Goods goods = goodsService.getById(goodsid);
  158.  
  159.         return new DataGridViewResult(goods);
  160.  
  161.     }
  162.  
  163.     /**
  164.      * 为商品分配类别
  165.      *
  166.      * @param categoryids
  167.      * @param goodsid
  168.      * @return
  169.      */
  170.     @SysLog("类别添加操作")
  171.     @RequestMapping("/saveGoodsCategory")
  172.     public Result saveGoodsCategory(String categoryids, int goodsid) {
  173.  
  174.         try {
  175.             if (goodsService.saveGoodsCategory(goodsid, categoryids)) {
  176.                 return Result.success(true, null, "分配成功");
  177.             }
  178.  
  179.         } catch (Exception e) {
  180.             e.printStackTrace();
  181.         }
  182.         return Result.error(false, null, "分配失败");
  183.  
  184.     }
  185.  
  186.     /**
  187.      * 加载下拉框
  188.      *
  189.      * @return
  190.      */
  191.     @RequestMapping("/loadAllGoods")
  192.     public DataGridViewResult loadAllGoods() {
  193.         QueryWrapper<Goods> queryWrapper = new QueryWrapper<>();
  194.         List<Goods> list = goodsService.list(queryWrapper);
  195.         return new DataGridViewResult(list);
  196.  
  197.     }
  198.  
  199.  
  200.     /**
  201.      * 根据供应商查商品下拉框
  202.      *
  203.      * @param providerid
  204.      * @return
  205.      */
  206.     @RequestMapping("/loadGoodsByProvidreId")
  207.     public DataGridViewResult loadGoodsByProvidreId(Integer providerid) {
  208.         QueryWrapper<Goods> goodsQueryWrapper = new QueryWrapper<>();
  209.         goodsQueryWrapper.eq(providerid != null, "providerid", providerid);
  210.         List<Goods> list = goodsService.list(goodsQueryWrapper);
  211.         for (Goods goods : list) {
  212.             Provider provider = providerService.getById(goods.getProviderid());
  213.             if (null != provider) {
  214.                 goods.setProvidername(provider.getProvidername());
  215.             }
  216.  
  217.         }
  218.         return new DataGridViewResult(list);
  219.  
  220.     }
  221. }

源码获取：博客首页 "资源" 里下载！ 

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

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号