123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185 |
- package org.jeecg.modules.demo.hzz.shjsgc.shxmxx.service.impl;
- import org.jeecg.modules.demo.hzz.shjsgc.shxmxx.entity.RmShxmxxb;
- import org.jeecg.modules.demo.hzz.shjsgc.shxmxx.entity.RmJgjlb;
- import org.jeecg.modules.demo.hzz.shjsgc.shxmxx.mapper.RmJgjlbMapper;
- import org.jeecg.modules.demo.hzz.shjsgc.shxmxx.mapper.RmShxmxxbMapper;
- import org.jeecg.modules.demo.hzz.shjsgc.shxmxx.service.IRmShxmxxbService;
- import org.springframework.stereotype.Service;
- import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.transaction.annotation.Transactional;
- import java.io.Serializable;
- import java.util.*;
- /**
- * @Description: 涉河项目信息表
- * @Author: jeecg-boot
- * @Date: 2022-02-19
- * @Version: V1.0
- */
- @Service
- public class RmShxmxxbServiceImpl extends ServiceImpl<RmShxmxxbMapper, RmShxmxxb> implements IRmShxmxxbService {
- @Autowired
- private RmShxmxxbMapper rmShxmxxbMapper;
- @Autowired
- private RmJgjlbMapper rmJgjlbMapper;
-
- @Override
- @Transactional
- public void saveMain(RmShxmxxb rmShxmxxb, List<RmJgjlb> rmJgjlbList) {
- rmShxmxxbMapper.insert(rmShxmxxb);
- if(rmJgjlbList!=null && rmJgjlbList.size()>0) {
- for(RmJgjlb entity:rmJgjlbList) {
- //外键设置
- entity.setMainId(rmShxmxxb.getId());
- rmJgjlbMapper.insert(entity);
- }
- }
- }
- @Override
- @Transactional
- public void updateMain(RmShxmxxb rmShxmxxb,List<RmJgjlb> rmJgjlbList) {
- rmShxmxxbMapper.updateById(rmShxmxxb);
-
- //1.先删除子表数据
- rmJgjlbMapper.deleteByMainId(rmShxmxxb.getId());
-
- //2.子表数据重新插入
- if(rmJgjlbList!=null && rmJgjlbList.size()>0) {
- for(RmJgjlb entity:rmJgjlbList) {
- //外键设置
- entity.setMainId(rmShxmxxb.getId());
- rmJgjlbMapper.insert(entity);
- }
- }
- }
- @Override
- @Transactional
- public void delMain(String id) {
- rmJgjlbMapper.deleteByMainId(id);
- rmShxmxxbMapper.deleteById(id);
- }
- @Override
- @Transactional
- public void delBatchMain(Collection<? extends Serializable> idList) {
- for(Serializable id:idList) {
- rmJgjlbMapper.deleteByMainId(id.toString());
- rmShxmxxbMapper.deleteById(id);
- }
- }
- @Override
- public String rmshxmcount() {
- String countter = rmShxmxxbMapper.countter();
- return countter;
- }
- @Override
- public List<Map<String,Double>> findAllhlcd() {
- List<Map<String, Double>> allhlcd = rmShxmxxbMapper.findAllhlcd();
- // List<Map<String,Double>> list = rmShxmxxbMapper.findAllhlcd();
- // Map<String,Double> res = new HashMap<>();
- // for (Map<String,Double> stringStringMap : list) {
- //// System.out.println(stringStringMap.toString());
- //
- // String hlmc = null;
- // String hlcd = null;
- //
- // for (Map.Entry<String,Double> entry:stringStringMap.entrySet()){
- // if ("hlmc".equals(entry.getKey())){
- // hlmc = String.valueOf(entry.getValue());
- // }else {
- // hlcd = String.valueOf(entry.getValue());
- // }
- // }
- //
- // res.put(hlmc, Double.valueOf(hlcd));
- // }
- return allhlcd;
- }
- @Override
- public String yjcount() {
- String yjcount = rmShxmxxbMapper.yjcount();
- return yjcount;
- }
- @Override
- public Integer zjcount() {
- Integer zjcount = rmShxmxxbMapper.zjcount();
- return zjcount;
- }
- @Override
- public Integer njcount() {
- Integer njcount = rmShxmxxbMapper.njcount();
- return njcount;
- }
- @Override
- public List<Integer> xmcount() {
- List <Integer> list=new ArrayList<>();
- Integer bzgccount = rmShxmxxbMapper.bzgccount();
- Integer zbgccount = rmShxmxxbMapper.zbgccount();
- Integer dfgccount = rmShxmxxbMapper.dfgccount();
- Integer xjbgcount = rmShxmxxbMapper.xjbgcount();
- Integer skcount = rmShxmxxbMapper.skcount();
- Integer lhbcount = rmShxmxxbMapper.lhbcount();
- Integer gxcount = rmShxmxxbMapper.gxcount();
- Integer qlcount = rmShxmxxbMapper.qlcount();
- Integer szcount = rmShxmxxbMapper.szcount();
- int lhgccount=xjbgcount+skcount+lhbcount+gxcount+qlcount+szcount;
- list.add(bzgccount);
- list.add(zbgccount);
- list.add(dfgccount);
- list.add(lhgccount);
- return list;
- }
- @Override
- public void addxcjg(String id, String jsxmmc) {
- rmShxmxxbMapper.addxcjg(id,jsxmmc);
- }
- @Override
- public void delxcjg(String id) {
- rmShxmxxbMapper.delxcjg(id);
- }
- @Override
- public void updataxcjg(String jsxmmc, String id) {
- rmShxmxxbMapper.updataxcjg(jsxmmc,id);
- }
- @Override
- public List<HashMap<String, String>> selectjsqk() {
- List<HashMap<String, String>> selectjsqk = rmShxmxxbMapper.selectjsqk();
- return selectjsqk;
- }
- @Override
- public List<HashMap<String, String>> countxmlx() {
- List<HashMap<String, String>> countxmlx = rmShxmxxbMapper.countxmlx();
- return countxmlx;
- }
- @Override
- public List<HashMap<String, String>> selectnjqk() {
- List<HashMap<String, String>> selectnjqk = rmShxmxxbMapper.selectnjqk();
- return selectnjqk;
- }
- @Override
- public List<HashMap<String, String>> countjg() {
- return rmShxmxxbMapper.countjg();
- }
- }
|