项目水资源分析模拟综合平，长江经济带小水电基础信息管理系统，java_basic.java.io,_myproject.zip

package com.lyht.business.analysisCalculation.service; import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.math.BigDecimal; import java.util.ArrayList; import java.util.Arrays; import java.util.Collections; import java.util.Comparator; import java.util.HashMap; import java.util.Hashtable; import java.util.List; import java.util.Map; import javax.annotation.Resource; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.springframework.context.annotation.Scope; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Propagation; import org.springframework.transaction.annotation.Transactional; import com.lyht.base.hibernate.common.PageResults; import com.lyht.business.analysisCalculation.bean.Result; import com.lyht.business.analysisCalculation.bean.ResultFifth; import com.lyht.business.analysisCalculation.bean.ResultFourth; import com.lyht.business.analysisCalculation.bean.ResultJg; import com.lyht.business.analysisCalculation.bean.ResultSecond; import com.lyht.business.analysisCalculation.bean.ResultSixthResult; import com.lyht.business.analysisCalculation.dao.ResultDao; import com.lyht.business.analysisCalculation.dao.ResultFifthDao; import com.lyht.business.analysisCalculation.dao.ResultFourthDao; import com.lyht.business.analysisCalculation.dao.ResultJgDao; import com.lyht.business.analysisCalculation.dao.ResultSecondDao; import com.lyht.business.analysisCalculation.dao.ResultSecondQlDao; import com.lyht.business.analysisCalculation.dao.ResultSixthDao; import com.lyht.business.analysisCalculation.dao.ResultSixthResultDao; import com.lyht.business.analysisCalculation.dao.ResultThirdLessDao; import com.lyht.business.analysisCalculation.dao.ResultThridDao; import com.lyht.business.analysisCalculation.dao.StPptnDayRDao; import com.lyht.business.analysisCalculation.formbean.ResultFifthFormBean; import com.lyht.business.analysisCalculation.formbean.ResultFormBean; import com.lyht.business.analysisCalculation.formbean.ResultFourthFormBean; import com.lyht.business.analysisCalculation.formbean.ResultThridFormBean; import com.lyht.business.consumer.hydrologicalData.bean.River; import com.lyht.business.consumer.hydrologicalData.bean.Stbprp; import com.lyht.business.consumer.hydrologicalData.dao.RiverDao; import com.lyht.business.consumer.hydrologicalData.dao.StbprpDao; import com.lyht.business.consumer.hydrologicalData.formbean.RiverFormBean; import com.lyht.business.consumer.hydrologicalData.formbean.TsqxFormBean; import com.lyht.business.system.bean.SysStaff; import com.lyht.util.CommonUtil; import com.lyht.util.DateUtil; import com.lyht.util.ExcelUtils; import com.lyht.util.Line; import com.lyht.util.LineDifference; import com.lyht.util.Point; import com.lyht.util.Randomizer; import net.sf.json.JSONArray; import net.sf.json.JSONObject; /** *作者： 刘魁 *脚本日期:2018年6月4日 15:24:11 *说明: 产流计算结果service */ @Service @Scope("prototype") @Transactional public class ResultService { @Resource ResultDao resuldDao; @Resource RiverDao riverDao; @Resource ResultJgDao rjDao; @Resource ResultThridDao resultThridDao; @Resource ResultThirdLessDao resultThridLessDao; @Resource ResultFourthDao resultFourthDao; @Resource private ResultSixthDao rxDao; @Resource private ResultFifthDao rfDao; @Resource private ResultSecondDao rsDao; @Resource private ResultSecondQlDao resultSecondQlDao; @Resource private ResultSixthResultDao resultSixthResultDao; @Resource private StbprpDao stbprpDao; @Resource private StPptnDayRDao stpptndayrDao; /** * 删除整场洪水信息 * @param stcd * @param params */ @Transactional public void deleteAllDataResult(String stcd,String params){ JSONArray dataList = JSONArray.fromObject(params); String pchs=""; if(dataList!=null && dataList.size()>0){ for(int i=0;i<dataList.size();i++){ JSONObject json = dataList.getJSONObject(i); if(json.containsKey("PCH")){ if(pchs!=null && pchs.trim().length()>0){ pchs=pchs+",'"+json.getString("PCH")+"'"; }else{ pchs="'"+json.getString("PCH")+"'"; } } } } if(pchs!=null && pchs.trim().length()>0){ String[] tableList = new String[]{"C_RESULT","C_FIFTH_PA","C_RESULT_FIFTH", "C_RESULT_FOURTH","C_RESULT_JG","C_RESULT_SECOND", "C_RESULT_SECOND_QL", "C_RESULT_SIX_PPA","C_RESULT_SIXTH","C_RESULT_SIXTH_RESULT","C_RESULT_THRID", "C_RESULT_THRID_LESS","H_RESULT","H_RESULT_FOURTH", "H_RESULT_FOURTH_E", "H_RESULT_FOURTH_Q","H_RESULT_FOURTH_ZHCX","H_RESULT_SECOND", "H_RESULT_SECOND_ZHCX","H_RESULT_THIRD_ZHCX","H_RESULT_THRID","H_RESULT_ZHCX"}; for(int i=0;i<tableList.length;i++){ resultSixthResultDao.deleteTableData(tableList[i], stcd, pchs); } } } /** * 删除产流计算第三步计算结果 * @param stcd * @param pch */ @Transactional public void deleteStep3Result(String stcd,String pch){ resultThridDao.deleteResultByStcdAndPch(stcd, pch); resultThridLessDao.deleteByStcdAndPch(stcd, pch); ResultSecond rs = rsDao.queryResultSecondByStcdAndPch(stcd, pch); rs.setRs(null); rs.setSqt3(null); rsDao.saveOrUpdate(rs); } @SuppressWarnings({ "unchecked", "rawtypes" }) public List<Map> queryStep1Jyl(String stcd,String start,String end,String interval){ List<Map> resultList = new ArrayList<Map>(); start=start+":00"; end=end+":00"; String searchStart=CommonUtil.getAfterMinitsDateTime(start, -Integer.valueOf(interval)); searchStart=searchStart.substring(0, 16);//输入的查询开始时间的前一个间隔开始时间作为查询数据的开始时间 List<Map> jylList = this.resuldDao.queryStep1Jyl(stcd, searchStart, end); end=CommonUtil.getAfterMinitsDateTime(end, Integer.valueOf(interval));//扩大一个时间间隔 String endTime=start;// String startTime=searchStart+":00"; while(CommonUtil.compareLessDateTime(endTime, end)){ Map map = new HashMap(); double drp=getJylData(startTime,endTime,jylList); map.put("DT", endTime.subSequence(0, 16)); map.put("DRP", drp); resultList.add(map); startTime=endTime; endTime=CommonUtil.getAfterMinitsDateTime(endTime, Integer.valueOf(interval)); } return resultList; } @SuppressWarnings("rawtypes") private double getJylData(String start,String end,List<Map> jylList){ double result=0; if(jylList!=null && jylList.size()>0){ for(int i=0;i<jylList.size();i++){ Map map = jylList.get(i); if(map!=null && CommonUtil.trim(map.get("BTM")).length()>0 && CommonUtil.trim(map.get("STM")).length()>0){ String btm = CommonUtil.trim(map.get("BTM")); String stm = CommonUtil.trim(map.get("STM")); btm=btm+":00"; stm=stm+":00"; double drp=0; if(CommonUtil.trim(map.get("DRP")).length()>0){ drp=CommonUtil.getFloatValue(CommonUtil.trim(map.get("DRP"))); } if(CommonUtil.compareMoreDateTime(start, btm) && CommonUtil.compareLessDateTime(end, stm)){ //[3,7]在[0,8]之中的情况结果为[3,7] long interval=CommonUtil.getDifferenceTime(start, end); long sjc=CommonUtil.getDifferenceTime(btm, stm); result = drp*interval/sjc; double val=new BigDecimal(result).setScale(1, BigDecimal.ROUND_HALF_UP).doubleValue();//保留2位小数 return val; }else if(CommonUtil.compareMoreDateTime(start, btm) && !CommonUtil.compareLessDateTime(end, stm) && !CommonUtil.compareLessDateTime(stm, start)){ //[3,7]在[2,6]结果为[3,6] long interval=CommonUtil.getDifferenceTime(start, stm); long sjc=CommonUtil.getDifferenceTime(btm, stm); result = result+drp*interval/sjc; }else if(!CommonUtil.compareMoreDateTime(start, btm) && CommonUtil.compareMoreDateTime(end, stm)){ //[3,7]在[4,6]结果为[4,6] result=result+drp;