博主介绍：专注于Java（springboot ssm 等开发框架） vue .net php phython node.js uniapp 微信小程序 等诸多技术领域和毕业项目实战、概念设计阶段主要通过使用实体-联系图（E-R图）的方式，将现实世界中用户对系统的实际需求，转换成设计人员能够理解的抽象的数据库概念模型。本系统的总体功能设计如图4-1所示。图4-7、
图5-5物资管理界面
package com.controller;import java.io.File;import java.math.BigDecimal;import java.net.URL;import java.text.SimpleDateFormat;import com.alibaba.fastjson.JSONObject;import java.util.*;import org.springframework.beans.BeanUtils;import javax.servlet.http.HttpServletRequest;import org.springframework.web.context.ContextLoader;import javax.servlet.ServletContext;import com.service.TokenService;import com.utils.*;import java.lang.reflect.InvocationTargetException;import com.service.DictionaryService;import org.apache.commons.lang3.StringUtils;import com.annotation.IgnoreAuth;import org.slf4j.Logger;import org.slf4j.LoggerFactory;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.*;import com.baomidou.mybatisplus.mapper.EntityWrapper;import com.baomidou.mybatisplus.mapper.Wrapper;import com.entity.*;import com.entity.view.*;import com.service.*;import com.utils.PageUtils;import com.utils.R;import com.alibaba.fastjson.*;/** * 物资 * 后端接口 * @author * @email*/@RestController@Controller@RequestMapping("/wuzi")public class WuziController { private static final Logger logger = LoggerFactory.getLogger(WuziController.class); @Autowired private WuziService wuziService; @Autowired private TokenService tokenService; @Autowired private DictionaryService dictionaryService; //级联表service @Autowired private YuangongService yuangongService; /** * 后端列表 */ @RequestMapping("/page") public R page(@RequestParam Map<String, Object> params, HttpServletRequest request){ logger.debug("page方法:,,Controller:{},,params:{}",this.getClass().getName(),JSONObject.toJSONString(params)); String role = String.valueOf(request.getSession().getAttribute("role")); if(StringUtil.isEmpty(role)) return R.error(511,"权限为空"); else if("员工".equals(role)) params.put("yuangongId",request.getSession().getAttribute("userId")); params.put("wuziDeleteStart",1);params.put("wuziDeleteEnd",1); if(params.get("orderBy")==null || params.get("orderBy")==""){ params.put("orderBy","id"); } PageUtils page = wuziService.queryPage(params); //字典表数据转换 List<WuziView> list =(List<WuziView>)page.getList(); for(WuziView c:list){ //修改对应字典表字段 dictionaryService.dictionaryConvert(c, request); } return R.ok().put("data", page); } /** * 后端详情 */ @RequestMapping("/info/{id}") public R info(@PathVariable("id") Long id, HttpServletRequest request){ logger.debug("info方法:,,Controller:{},,id:{}",this.getClass().getName(),id); WuziEntity wuzi = wuziService.selectById(id); if(wuzi !=null){ //entity转view WuziView view = new WuziView(); BeanUtils.copyProperties( wuzi , view );//把实体数据重构到view中 //修改对应字典表字段 dictionaryService.dictionaryConvert(view, request); return R.ok().put("data", view); }else { return R.error(511,"查不到数据"); } } /** * 后端保存 */ @RequestMapping("/save") public R save(@RequestBody WuziEntity wuzi, HttpServletRequest request){ logger.debug("save方法:,,Controller:{},,wuzi:{}",this.getClass().getName(),wuzi.toString()); String role = String.valueOf(request.getSession().getAttribute("role")); if(StringUtil.isEmpty(role)) return R.error(511,"权限为空"); Wrapper<WuziEntity> queryWrapper = new EntityWrapper<WuziEntity>() .eq("wuzi_name", wuzi.getWuziName()) .eq("wuzi_types", wuzi.getWuziTypes()) .eq("wuzi_kucun_number", wuzi.getWuziKucunNumber()) .eq("yujing_number", wuzi.getYujingNumber()) .eq("wuzi_delete", wuzi.getWuziDelete()) ; logger.info("sql语句:"+queryWrapper.getSqlSegment()); WuziEntity wuziEntity = wuziService.selectOne(queryWrapper); if(wuziEntity==null){ wuzi.setWuziDelete(1); wuzi.setCreateTime(new Date()); wuziService.insert(wuzi); return R.ok(); }else { return R.error(511,"表中有相同数据"); } } /** * 后端修改 */ @RequestMapping("/update") public R update(@RequestBody WuziEntity wuzi, HttpServletRequest request){ logger.debug("update方法:,,Controller:{},,wuzi:{}",this.getClass().getName(),wuzi.toString()); String role = String.valueOf(request.getSession().getAttribute("role"));// if(StringUtil.isEmpty(role))// return R.error(511,"权限为空"); //根据字段查询是否有相同数据 Wrapper<WuziEntity> queryWrapper = new EntityWrapper<WuziEntity>() .notIn("id",wuzi.getId()) .andNew() .eq("wuzi_name", wuzi.getWuziName()) .eq("wuzi_types", wuzi.getWuziTypes()) .eq("wuzi_kucun_number", wuzi.getWuziKucunNumber()) .eq("yujing_number", wuzi.getYujingNumber()) .eq("wuzi_delete", wuzi.getWuziDelete()) ; logger.info("sql语句:"+queryWrapper.getSqlSegment()); WuziEntity wuziEntity = wuziService.selectOne(queryWrapper); if("".equals(wuzi.getWuziPhoto()) || "null".equals(wuzi.getWuziPhoto())){ wuzi.setWuziPhoto(null); } if(wuziEntity==null){ // String role = String.valueOf(request.getSession().getAttribute("role")); // if("".equals(role)){ // wuzi.set // } wuziService.updateById(wuzi);//根据id更新 return R.ok(); }else { return R.error(511,"表中有相同数据"); } } /** * 删除 */ @RequestMapping("/delete") public R delete(@RequestBody Integer[] ids){ logger.debug("delete:,,Controller:{},,ids:{}",this.getClass().getName(),ids.toString()); ArrayList<WuziEntity> list = new ArrayList<>(); for(Integer id:ids){ WuziEntity wuziEntity = new WuziEntity(); wuziEntity.setId(id); wuziEntity.setWuziDelete(2); list.add(wuziEntity); } if(list != null && list.size() >0){ wuziService.updateBatchById(list); } return R.ok(); } /** * 批量上传 */ @RequestMapping("/batchInsert") public R save( String fileName){ logger.debug("batchInsert方法:,,Controller:{},,fileName:{}",this.getClass().getName(),fileName); try { List<WuziEntity> wuziList = new ArrayList<>();//上传的东西 Map<String, List<String>> seachFields= new HashMap<>();//要查询的字段 Date date = new Date(); int lastIndexOf = fileName.lastIndexOf("."); if(lastIndexOf == -1){ return R.error(511,"该文件没有后缀"); }else{ String suffix = fileName.substring(lastIndexOf); if(!".xls".equals(suffix)){ return R.error(511,"只支持后缀为xls的excel文件"); }else{ URL resource = this.getClass().getClassLoader().getResource("static/upload/" + fileName);//获取文件路径 File file = new File(resource.getFile()); if(!file.exists()){ return R.error(511,"找不到上传文件，请联系管理员"); }else{ List<List<String>> dataList = PoiUtil.poiImport(file.getPath());//读取xls文件 dataList.remove(0);//删除第一行，因为第一行是提示 for(List<String> data:dataList){ //循环 WuziEntity wuziEntity = new WuziEntity();// wuziEntity.setWuziName(data.get(0)); //物资名称 要改的// wuziEntity.setWuziPhoto("");//照片// wuziEntity.setWuziTypes(Integer.valueOf(data.get(0))); //物资类型 要改的// wuziEntity.setWuziKucunNumber(Integer.valueOf(data.get(0))); //物资库存 要改的// wuziEntity.setYujingNumber(Integer.valueOf(data.get(0))); //预警值 要改的// wuziEntity.setWuziDelete(1);//逻辑删除字段// wuziEntity.setWuziContent("");//照片// wuziEntity.setCreateTime(date);//时间 wuziList.add(wuziEntity); //把要查询是否重复的字段放入map中 } //查询是否重复 wuziService.insertBatch(wuziList); return R.ok(); } } } }catch (Exception e){ return R.error(511,"批量插入数据异常，请联系管理员"); } }}
5.5物资订单管理
通过设计的物资订单管理功能模块，管理用户可以对相关的物资订单信息进行管理，比如管理用户可以查看详细的物资订单信息，删除失效的物资订单信息记录等，物资订单管理界面设计如图5-6所示。
