2f97c17dd654c598b338a89b216196ce59ef20a3.svn-base 4.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185
  1. package org.jeecg.modules.demo.hzz.shjsgc.shxmxx.service.impl;
  2. import org.jeecg.modules.demo.hzz.shjsgc.shxmxx.entity.RmShxmxxb;
  3. import org.jeecg.modules.demo.hzz.shjsgc.shxmxx.entity.RmJgjlb;
  4. import org.jeecg.modules.demo.hzz.shjsgc.shxmxx.mapper.RmJgjlbMapper;
  5. import org.jeecg.modules.demo.hzz.shjsgc.shxmxx.mapper.RmShxmxxbMapper;
  6. import org.jeecg.modules.demo.hzz.shjsgc.shxmxx.service.IRmShxmxxbService;
  7. import org.springframework.stereotype.Service;
  8. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  9. import org.springframework.beans.factory.annotation.Autowired;
  10. import org.springframework.transaction.annotation.Transactional;
  11. import java.io.Serializable;
  12. import java.util.*;
  13. /**
  14. * @Description: 涉河项目信息表
  15. * @Author: jeecg-boot
  16. * @Date: 2022-02-19
  17. * @Version: V1.0
  18. */
  19. @Service
  20. public class RmShxmxxbServiceImpl extends ServiceImpl<RmShxmxxbMapper, RmShxmxxb> implements IRmShxmxxbService {
  21. @Autowired
  22. private RmShxmxxbMapper rmShxmxxbMapper;
  23. @Autowired
  24. private RmJgjlbMapper rmJgjlbMapper;
  25. @Override
  26. @Transactional
  27. public void saveMain(RmShxmxxb rmShxmxxb, List<RmJgjlb> rmJgjlbList) {
  28. rmShxmxxbMapper.insert(rmShxmxxb);
  29. if(rmJgjlbList!=null && rmJgjlbList.size()>0) {
  30. for(RmJgjlb entity:rmJgjlbList) {
  31. //外键设置
  32. entity.setMainId(rmShxmxxb.getId());
  33. rmJgjlbMapper.insert(entity);
  34. }
  35. }
  36. }
  37. @Override
  38. @Transactional
  39. public void updateMain(RmShxmxxb rmShxmxxb,List<RmJgjlb> rmJgjlbList) {
  40. rmShxmxxbMapper.updateById(rmShxmxxb);
  41. //1.先删除子表数据
  42. rmJgjlbMapper.deleteByMainId(rmShxmxxb.getId());
  43. //2.子表数据重新插入
  44. if(rmJgjlbList!=null && rmJgjlbList.size()>0) {
  45. for(RmJgjlb entity:rmJgjlbList) {
  46. //外键设置
  47. entity.setMainId(rmShxmxxb.getId());
  48. rmJgjlbMapper.insert(entity);
  49. }
  50. }
  51. }
  52. @Override
  53. @Transactional
  54. public void delMain(String id) {
  55. rmJgjlbMapper.deleteByMainId(id);
  56. rmShxmxxbMapper.deleteById(id);
  57. }
  58. @Override
  59. @Transactional
  60. public void delBatchMain(Collection<? extends Serializable> idList) {
  61. for(Serializable id:idList) {
  62. rmJgjlbMapper.deleteByMainId(id.toString());
  63. rmShxmxxbMapper.deleteById(id);
  64. }
  65. }
  66. @Override
  67. public String rmshxmcount() {
  68. String countter = rmShxmxxbMapper.countter();
  69. return countter;
  70. }
  71. @Override
  72. public List<Map<String,Double>> findAllhlcd() {
  73. List<Map<String, Double>> allhlcd = rmShxmxxbMapper.findAllhlcd();
  74. // List<Map<String,Double>> list = rmShxmxxbMapper.findAllhlcd();
  75. // Map<String,Double> res = new HashMap<>();
  76. // for (Map<String,Double> stringStringMap : list) {
  77. //// System.out.println(stringStringMap.toString());
  78. //
  79. // String hlmc = null;
  80. // String hlcd = null;
  81. //
  82. // for (Map.Entry<String,Double> entry:stringStringMap.entrySet()){
  83. // if ("hlmc".equals(entry.getKey())){
  84. // hlmc = String.valueOf(entry.getValue());
  85. // }else {
  86. // hlcd = String.valueOf(entry.getValue());
  87. // }
  88. // }
  89. //
  90. // res.put(hlmc, Double.valueOf(hlcd));
  91. // }
  92. return allhlcd;
  93. }
  94. @Override
  95. public String yjcount() {
  96. String yjcount = rmShxmxxbMapper.yjcount();
  97. return yjcount;
  98. }
  99. @Override
  100. public Integer zjcount() {
  101. Integer zjcount = rmShxmxxbMapper.zjcount();
  102. return zjcount;
  103. }
  104. @Override
  105. public Integer njcount() {
  106. Integer njcount = rmShxmxxbMapper.njcount();
  107. return njcount;
  108. }
  109. @Override
  110. public List<Integer> xmcount() {
  111. List <Integer> list=new ArrayList<>();
  112. Integer bzgccount = rmShxmxxbMapper.bzgccount();
  113. Integer zbgccount = rmShxmxxbMapper.zbgccount();
  114. Integer dfgccount = rmShxmxxbMapper.dfgccount();
  115. Integer xjbgcount = rmShxmxxbMapper.xjbgcount();
  116. Integer skcount = rmShxmxxbMapper.skcount();
  117. Integer lhbcount = rmShxmxxbMapper.lhbcount();
  118. Integer gxcount = rmShxmxxbMapper.gxcount();
  119. Integer qlcount = rmShxmxxbMapper.qlcount();
  120. Integer szcount = rmShxmxxbMapper.szcount();
  121. int lhgccount=xjbgcount+skcount+lhbcount+gxcount+qlcount+szcount;
  122. list.add(bzgccount);
  123. list.add(zbgccount);
  124. list.add(dfgccount);
  125. list.add(lhgccount);
  126. return list;
  127. }
  128. @Override
  129. public void addxcjg(String id, String jsxmmc) {
  130. rmShxmxxbMapper.addxcjg(id,jsxmmc);
  131. }
  132. @Override
  133. public void delxcjg(String id) {
  134. rmShxmxxbMapper.delxcjg(id);
  135. }
  136. @Override
  137. public void updataxcjg(String jsxmmc, String id) {
  138. rmShxmxxbMapper.updataxcjg(jsxmmc,id);
  139. }
  140. @Override
  141. public List<HashMap<String, String>> selectjsqk() {
  142. List<HashMap<String, String>> selectjsqk = rmShxmxxbMapper.selectjsqk();
  143. return selectjsqk;
  144. }
  145. @Override
  146. public List<HashMap<String, String>> countxmlx() {
  147. List<HashMap<String, String>> countxmlx = rmShxmxxbMapper.countxmlx();
  148. return countxmlx;
  149. }
  150. @Override
  151. public List<HashMap<String, String>> selectnjqk() {
  152. List<HashMap<String, String>> selectnjqk = rmShxmxxbMapper.selectnjqk();
  153. return selectnjqk;
  154. }
  155. @Override
  156. public List<HashMap<String, String>> countjg() {
  157. return rmShxmxxbMapper.countjg();
  158. }
  159. }