From 79f33da4df32fc139c3855a8ecca6545723e0815 Mon Sep 17 00:00:00 2001 From: wu <731351411@qq.com> Date: 星期二, 19 九月 2023 08:08:17 +0800 Subject: [PATCH] 删除不需要的代码,玻璃信息放入其他数据库 方便测试显示数据库连接的信息 --- springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java | 147 ++++++++++++++++++++++++++++++++++-------------- 1 files changed, 103 insertions(+), 44 deletions(-) diff --git a/springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java b/springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java index 4216a59..cae88ae 100644 --- a/springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java +++ b/springboot-vue3/src/main/java/com/example/springboot/controller/HomeController.java @@ -8,7 +8,9 @@ import com.example.springboot.mapper.HomeMapper; import com.example.springboot.service.HomeService; +import com.example.springboot.service.SpianService; import com.example.springboot.common.Result; +import com.example.springboot.entity.CarPosition; import com.example.springboot.entity.StorageCage; import com.example.springboot.entity.alarmmg; @@ -23,83 +25,140 @@ @Autowired HomeService storageRackService; - @GetMapping("/load") - public Result selectAll(){ - List<StorageCage> storageCagelist=homeMapper.selectAll(); + @Autowired + SpianService spianService; + + @GetMapping("/load") + public Result selectAll() { + List<StorageCage> storageCagelist = homeMapper.selectAll(); Map<String, Object> map = new HashMap<>(); - map.put("list",storageCagelist); + map.put("list", storageCagelist); return Result.success(map); } - @GetMapping("/loads") - public Result selectRack(){ - List<StorageCage> storageCagelist1=homeMapper.selectRack1(); - List<StorageCage> storageCagelist2=homeMapper.selectRack2(); - List<StorageCage> storageCagelist3=homeMapper.selectRack3(); - List<StorageCage> storageCagelist4=homeMapper.selectRack4(); + @GetMapping("/loads") + public Result selectRack() { + List<StorageCage> storageCagelist1 = homeMapper.selectRack1(); + List<StorageCage> storageCagelist2 = homeMapper.selectRack2(); + List<StorageCage> storageCagelist3 = homeMapper.selectRack3(); + List<StorageCage> storageCagelist4 = homeMapper.selectRack4(); Map<String, Object> map = new HashMap<>(); - map.put("list1",storageCagelist1); - map.put("list2",storageCagelist2); - map.put("list3",storageCagelist3); - map.put("list4",storageCagelist4); + map.put("list1", storageCagelist1); + map.put("list2", storageCagelist2); + map.put("list3", storageCagelist3); + map.put("list4", storageCagelist4); return Result.success(map); } - - - @GetMapping("/loadinout") - public Result selectinout(Integer types){ - List<StorageCage> storageCageinout=homeMapper.selectinout(types); + + @GetMapping("/loadinout") + public Result selectinout(Integer types) { + List<StorageCage> storageCageinout = homeMapper.selectinout(types); Map<String, Object> map = new HashMap<>(); - map.put("list",storageCageinout); + map.put("list", storageCageinout); return Result.success(map); } @GetMapping("/InsertOrder") - public Result InsertOrder(String orderid){ - short result=homeMapper.SelectOrder(orderid); + public Result InsertOrder(String orderid) { + short result = homeMapper.SelectOrder(orderid); Map<String, Object> map = new HashMap<>(); - if(result>0){ + if (result > 0) { homeMapper.updateOrder(); homeMapper.InsertOrder(orderid); - map.put("message","200"); - }else{ - map.put("message","500"); + map.put("message", "200"); + } else { + map.put("message", "500"); } return Result.success(map); } @GetMapping("/Addglassid") - public Result Addglassid(Integer glassid){ + public Result Addglassid(short glassid) { Map<String, Object> map = new HashMap<>(); - short taskno=homeMapper.SelectOutTask(); - if(taskno>0){ - map.put("message2","500"); - }else{ - map.put("message2","200"); - //璋冪敤浼嶄笂鐗囧嚱鏁� + short taskno = homeMapper.SelectOutTask(); + if (taskno > 0) { + map.put("message2", "500"); + } else { + // 璋冪敤浼嶄笂鐗囧嚱鏁� + short results = spianService.selectAll(Short.toString(glassid)); + if (results == 200) { + map.put("message2", "200"); + } else if (results == 300) { + map.put("message2", "300"); + } else if (results == 400) { + map.put("message2", "400"); + } } return Result.success(map); } @GetMapping("/UpdateTask") - public Result UpdateTask(Integer types,Integer shelfrack){ + public Result UpdateTask(Integer types, Integer shelfrack, Integer glassid) { Map<String, Object> map = new HashMap<>(); - homeMapper.UpdateTask(types,shelfrack); - if(types==0){ - homeMapper.UpdateCageTask1(shelfrack); - }else{ - homeMapper.UpdateCageTask2(shelfrack); + homeMapper.UpdateTask(types, shelfrack); + if (types == 0) { + homeMapper.UpdateCageTask1(shelfrack, glassid); + } else { + homeMapper.UpdateCageTask2(shelfrack, glassid); } - map.put("message3","200"); + map.put("message3", "200"); return Result.success(map); } - @GetMapping("/SelectAlarmmgInfo") - public Result SelectAlarmmgInfo(){ - List<alarmmg> alarmmg=homeMapper.SelectAlarmmgInfo(); + @GetMapping("/SelectAlarmmgInfo") + public Result SelectAlarmmgInfo() { + List<alarmmg> alarmmg = homeMapper.SelectAlarmmgInfo(); Map<String, Object> map = new HashMap<>(); - map.put("alarmmg",alarmmg); + map.put("alarmmg", alarmmg); return Result.success(map); } + + @GetMapping("/SelectCageInfo") + public Result SelectCageInfo(short cage) { + List<StorageCage> cageinfo = homeMapper.SelectCageInfo(cage); + Map<String, Object> map = new HashMap<>(); + map.put("cageinfo", cageinfo); + return Result.success(map); + } + + @GetMapping("/DeleteByGlassID") + public Result DeleteByGlassID(short glassid) { + homeMapper.DeleteByGlassID(glassid); + Map<String, Object> map = new HashMap<>(); + map.put("message3", "200"); + return Result.success(map); + } + + @GetMapping("/OutByGlassID") + public Result OutByGlassID(String glassid) { + Map<String, Object> map = new HashMap<>(); + // 璋冪敤浼嶄笂鐗囧嚱鏁� + Short results = spianService.selectout2(glassid); + if (results == 200) { + map.put("message2", "200"); + } else if (results == 300) { + map.put("message2", "300"); + } else if (results == 400) { + map.put("message2", "400"); + } + return Result.success(map); + } + + @GetMapping("/Loadcarlist") + public Result Loadcarlist() { + List<CarPosition> carlist = homeMapper.Loadcarlist(); + Map<String, Object> map = new HashMap<>(); + map.put("carlist", carlist); + return Result.success(map); + } + + @GetMapping("/SelectPassword") + public Result SelectPassword() { + String pwdct = homeMapper.SelectPassword(); + Map<String, Object> map = new HashMap<>(); + map.put("password", pwdct); + return Result.success(map); + } + } -- Gitblit v1.8.0