| 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 */@Servicepublic 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();	}}
 |