潘钊 / bsth_control · Files

package com.bsth.service.oil.impl;



import java.text.DecimalFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import javax.transaction.Transactional;

import org.apache.commons.lang3.StringEscapeUtils;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Sort;
import org.springframework.data.domain.Sort.Direction;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;

import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.bsth.common.ResponseCode;
import com.bsth.data.BasicData;
import com.bsth.entity.Cars;
import com.bsth.entity.Line;
import com.bsth.entity.oil.Cdl;
import com.bsth.entity.oil.Cyl;
import com.bsth.entity.oil.Dlb;
import com.bsth.entity.oil.Jdl;
import com.bsth.entity.oil.Ylb;
import com.bsth.entity.oil.Ylxxb;
import com.bsth.entity.search.CustomerSpecs;
import com.bsth.repository.CarsRepository;
import com.bsth.repository.oil.CdlRepository;
import com.bsth.repository.oil.CylRepository;
import com.bsth.repository.oil.DlbRepository;
import com.bsth.repository.oil.JdlRepository;
import com.bsth.repository.oil.YlbRepository;
import com.bsth.repository.oil.YlxxbRepository;
import com.bsth.service.impl.BaseServiceImpl;
import com.bsth.service.oil.DlbService;
import com.bsth.service.realcontrol.ScheduleRealInfoService;
import com.bsth.util.Arith;

@Service
public class DlbServiceImpl extends BaseServiceImpl<Dlb,Integer> implements DlbService{
	@Autowired
	DlbRepository repository;
	
	@Autowired
	YlxxbRepository ylxxbRepository;
	
	@Autowired
	CdlRepository cdlRepository;
	@Autowired
	JdlRepository jdlRepository;
	@Autowired
	CarsRepository carsRepository;
	
	@Autowired
	ScheduleRealInfoService scheduleRealInfoService;
	
	@Autowired
	JdbcTemplate jdbcTemplate;
	
	Logger logger = LoggerFactory.getLogger(this.getClass());
	
	@Transactional  
	@Override
	public String obtainDsq() throws Exception{
		String result = "failure";
		List<Cars> carsList=carsRepository.findCars();
		 Map<String, Boolean> carsMap=new HashMap<String, Boolean>();
		 for (int i = 0; i < carsList.size(); i++) {
			 Cars c=carsList.get(i);
			 carsMap.put(c.getInsideCode(), c.getSfdc());
		}
		 SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
			Date dNow = new Date();   //当前时间
			Date dBefore = new Date();
			Calendar calendar = Calendar.getInstance(); //得到日历
			calendar.setTime(dNow);//把当前时间赋给日历
			calendar.add(Calendar.DAY_OF_MONTH, -1);  //设置为前一天
			dBefore = calendar.getTime();   //得到前一天的时间
			String rq=sdf.format(dBefore);
		String line="";
		//保留两位小数
		DecimalFormat df = new DecimalFormat("#.00");
		// TODO Auto-generated method stub
		Map<String, Object> newMap=new HashMap<String,Object>();
		//当天DLB信息
		List<Dlb> dlList=repository.obtainDl(rq, "", "", line, "", "nbbm");
		//当天YLXXB信息
		List<Ylxxb> ylxxList=ylxxbRepository.obtainYlxx(rq,1,"");
		//当天加电信息表
		List<Jdl> jdlList=jdlRepository.JdlList(rq);
		//前一天所有车辆最后进场班次信息
		List<Dlb> dlListBe=repository.obtainYlbefore(rq, "", "", "", "");
		List<Cdl> cdyList=cdlRepository.obtainCdl();
		//从排班表中计算出行驶的总里程
		List<Map<String,Object>> listpb=scheduleRealInfoService.yesterdayDataList(line,rq,"","","","");
		for(int x=0;x<listpb.size();x++){
			String type="add";
			boolean sfdc=false;
			Map<String, Object> map=listpb.get(x);
			if (carsMap.get(map.get("clZbh").toString())!=null) {
				 sfdc= carsMap.get(map.get("clZbh").toString());
			}else{
				sfdc=false;
			}
			if(sfdc){
				//判断驾驶员驾驶的该车辆是否已经存入了（查出的结果集中日期是相同的，根据驾驶员、内部编号、线路编码判断）
				Dlb t=new Dlb();
				for(int k=0;k<dlList.size();k++){
					Dlb t1=dlList.get(k);
					if(t1.getNbbm().equals(map.get("clZbh").toString())
							&&t1.getJsy().equals(map.get("jGh").toString())
							&&t1.getXlbm().equals(map.get("xlBm").toString()))
					{
						t=t1;
						type="update";
					}
				}
				try {
					//当日的第一个班次，出场油量等于前一天的最后一个班次的进场油量
					Double jzl=0.0;
					if(map.get("seqNumber").toString().equals("1")){
						boolean fage=true;
						for (int i = 0; i < dlListBe.size(); i++) {
							Dlb dlb=dlListBe.get(i);
							if(map.get("clZbh").toString().equals(dlb.getNbbm())){
								t.setCzcd(dlb.getJzcd());
								fage=false;
								break;
							}
						}
						if(fage){
							for (int y = 0; y < cdyList.size(); y++) {
								Cdl cdl=cdyList.get(y);
								if(map.get("clZbh").toString().equals(cdl.getNbbm())){
									t.setCzcd(cdl.getClcd()==null?0:cdl.getClcd());
									fage=false;
									break;
								}
							}
						}
						if(fage){
							t.setCzcd(0.0);
						}
						
						//手动导入没有驾驶员工号
						for (int i = 0; i < jdlList.size(); i++) {
							Jdl jdl=jdlList.get(i);
							if(map.get("clZbh").toString().equals(jdl.getNbbm()) 
									&&map.get("jGh").toString().equals(jdl.getJsy())){
								jzl+=jdl.getJdl();
							}
						}
					}
					
					
					//把当天的YLXXB的加注量设置为当天YLB的加注量（根据车号，驾驶员判断）
					for(int j=0;j<ylxxList.size();j++){
						Ylxxb ylxxb= ylxxList.get(j);
						if(map.get("clZbh").toString().equals(ylxxb.getNbbm()) &&map.get("jGh").toString().equals(ylxxb.getJsy())){
							jzl+=ylxxb.getJzl();
						}
					}
					
					t.setCdl(jzl);
					if(type.equals("add")){
						t.setHd(jzl);
						t.setJzcd(t.getCzcd());
					}
					
					t.setNbbm(map.get("clZbh").toString());
					t.setJsy(map.get("jGh")==null?"":map.get("jGh").toString());
					t.setZlc(map.get("totalKilometers")==null?0.0:Double.parseDouble(df.format(Double.parseDouble(map.get("totalKilometers").toString()))));
					t.setXlbm(map.get("xlBm")==null?"":map.get("xlBm").toString());
					t.setJcsx(Integer.parseInt(map.get("seqNumber").toString()));
					t.setSsgsdm(map.get("company")==null?"":map.get("company").toString());
					t.setFgsdm(map.get("bCompany")==null?"":map.get("bCompany").toString());
					t.setJhsj(map.get("fcsj")==null?"":map.get("fcsj").toString());
					t.setRq(sdf.parse(rq));
					t.setCreatetime(new Date());
					/*if(type.equals("add")){
						addList.add(t);
					}else{
						updateList.add(t);
					}*/
					repository.save(t);
					newMap.put("status", ResponseCode.SUCCESS);
				} catch (ParseException e) {
					// TODO Auto-generated catch block
					newMap.put("status", ResponseCode.ERROR);
					e.printStackTrace();
				}
			}
		}
		return result;
	}
	/**
	 * 获取进存电信息
	 * @Transactional 回滚事物
	 */
	@Transactional  
	@Override
	public Map<String, Object> obtain(Map<String, Object> map2) {
		List<Cars> carsList=carsRepository.findCars();
		 Map<String, Boolean> carsMap=new HashMap<String, Boolean>();
		 for (int i = 0; i < carsList.size(); i++) {
			 Cars c=carsList.get(i);
			 carsMap.put(c.getInsideCode(), c.getSfdc());
		}
		 String gsbm="";
			if(map2.get("ssgsdm_like")!=null){
				gsbm=map2.get("ssgsdm_like").toString();
			}
		String rq=map2.get("rq").toString();
		String line="";
		if(map2.get("xlbm_eq")!=null){
			line=map2.get("xlbm_eq").toString();
		}
		
		SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
		//保留两位小数
		DecimalFormat df = new DecimalFormat("#.00");
		// TODO Auto-generated method stub
		Map<String, Object> newMap=new HashMap<String,Object>();
		//当天DLB信息
		List<Dlb> dlList=repository.obtainDl(rq, gsbm, "", line, "", "nbbm");
		//当天YLXXB信息
		List<Ylxxb> ylxxList=ylxxbRepository.obtainYlxx(rq,1,gsbm);
		//当天加电信息表
		List<Jdl> jdlList=jdlRepository.JdlList(rq);
		//前一天所有车辆最后进场班次信息
		List<Dlb> dlListBe=repository.obtainYlbefore(rq, "", "", "", "");
		List<Cdl> cdyList=cdlRepository.obtainCdl();
		//从排班表中计算出行驶的总里程
		List<Map<String,Object>> listpb=scheduleRealInfoService.yesterdayDataList(line,rq,"","","","");
		List<Ylb> addList=new ArrayList<Ylb>();
		List<Ylb> updateList=new ArrayList<Ylb>();
		for(int x=0;x<listpb.size();x++){
			String type="add";
			boolean sfdc=false;
			Map<String, Object> map=listpb.get(x);
			if (carsMap.get(map.get("clZbh").toString())!=null) {
				 sfdc= carsMap.get(map.get("clZbh").toString());
			}else{
				sfdc=false;
			}
			if(sfdc){
				//判断驾驶员驾驶的该车辆是否已经存入了（查出的结果集中日期是相同的，根据驾驶员、内部编号、线路编码判断）
				Dlb t=new Dlb();
				for(int k=0;k<dlList.size();k++){
					Dlb t1=dlList.get(k);
					if(t1.getNbbm().equals(map.get("clZbh").toString())
							&&t1.getJsy().equals(map.get("jGh").toString())
							&&t1.getXlbm().equals(map.get("xlBm").toString()))
					{
						t=t1;
						type="update";
					}
				}
				try {
					//当日的第一个班次，出场油量等于前一天的最后一个班次的进场油量
					Double jzl=0.0;
					if(map.get("seqNumber").toString().equals("1")){
						boolean fage=true;
						for (int i = 0; i < dlListBe.size(); i++) {
							Dlb dlb=dlListBe.get(i);
							if(map.get("clZbh").toString().equals(dlb.getNbbm())){
								t.setCzcd(dlb.getJzcd());
								fage=false;
								break;
							}
						}
						if(fage){
							for (int y = 0; y < cdyList.size(); y++) {
								Cdl cdl=cdyList.get(y);
								if(map.get("clZbh").toString().equals(cdl.getNbbm())){
									t.setCzcd(cdl.getClcd()==null?0:cdl.getClcd());
									fage=false;
									break;
								}
							}
						}
						if(fage){
							t.setCzcd(0.0);
						}
						
						//
						for (int i = 0; i < jdlList.size(); i++) {
							Jdl jdl=jdlList.get(i);
							if(map.get("clZbh").toString().equals(jdl.getNbbm()) 
									&&map.get("jGh").toString().equals(jdl.getJsy())){
								jzl+=jdl.getJdl();
							}
						}
					}
					
					
					//把当天的YLXXB的加注量设置为当天YLB的加注量（根据车号，驾驶员判断）
					for(int j=0;j<ylxxList.size();j++){
						Ylxxb ylxxb= ylxxList.get(j);
						if(map.get("clZbh").toString().equals(ylxxb.getNbbm()) &&map.get("jGh").toString().equals(ylxxb.getJsy())){
							jzl+=ylxxb.getJzl();
						}
					}
					
					t.setCdl(jzl);
//					if(type.equals("add")){
						t.setHd(jzl);
						t.setJzcd(t.getCzcd());
//					}
					
					t.setNbbm(map.get("clZbh").toString());
					t.setJsy(map.get("jGh")==null?"":map.get("jGh").toString());
					t.setZlc(map.get("totalKilometers")==null?0.0:Double.parseDouble(df.format(Double.parseDouble(map.get("totalKilometers").toString()))));
					t.setXlbm(map.get("xlBm")==null?"":map.get("xlBm").toString());
					t.setJcsx(Integer.parseInt(map.get("seqNumber").toString()));
					t.setSsgsdm(map.get("company")==null?"":map.get("company").toString());
					t.setFgsdm(map.get("bCompany")==null?"":map.get("bCompany").toString());
					t.setJhsj(map.get("fcsj")==null?"":map.get("fcsj").toString());
					t.setRq(sdf.parse(rq));
					t.setCreatetime(new Date());
					/*if(type.equals("add")){
						addList.add(t);
					}else{
						updateList.add(t);
					}*/
					repository.save(t);
					newMap.put("status", ResponseCode.SUCCESS);
				} catch (ParseException e) {
					// TODO Auto-generated catch block
					newMap.put("status", ResponseCode.ERROR);
					e.printStackTrace();
				}
			}
		}
	/*	try {
			if(addList.size()>0){
				new BatchSaveUtils<Ylb>().saveList(addList, Ylb.class);
			}
			
			if(updateList.size()>0){
				
			}
			newMap.put("status", ResponseCode.SUCCESS);
		}
		catch (Exception e) {
			// TODO: handle exception
			newMap.put("status", ResponseCode.ERROR);
		}*/
		return newMap;
	}
	
	/**
	 * 拆分
	 */
	@Transactional  
	@Override
	public Map<String, Object> sort(Map<String, Object> map) {
		// TODO Auto-generated method stub
		Map<String, Object> newMap = new HashMap<String, Object>();
		try{
			int id=Integer.parseInt(map.get("id").toString());
			//最后存油量
			Double jzdl=Double.parseDouble(map.get("jzdl").toString());
			Double hdl=Double.parseDouble(map.get("hdl").toString());
			Dlb dlb=repository.findOne(id); 
			dlb.setJzcd(jzdl);
			dlb.setHd(hdl);
			repository.save(dlb);
			newMap.put("status", ResponseCode.SUCCESS);
		}catch(Exception e){
			newMap.put("status", ResponseCode.ERROR);
			logger.error("save erro.", e);
		}
		return newMap;
	}

	
	/**
	 * 核对，有加注没里程
	 * @param map
	 * @return
	 */
	@Transactional
	@Override
	public Map<String, Object> checkDl(Map<String, Object> map) {
		Map<String, Object> newMap=new HashMap<String,Object>();
//		String xlbm="";
//		if(map.get("xlbm_like")!=null){
//			xlbm=map.get("xlbm_like").toString();
//		}
		// TODO Auto-generated method stub
		
		List<Cars> carsList = carsRepository.findCars();
		Map<String, String> carsMap = new HashMap<String, String>();
		for (int i = 0; i < carsList.size(); i++) {
			Cars c = carsList.get(i);
			carsMap.put(c.getInsideCode(), c.getBrancheCompanyCode()==null?"":c.getBrancheCompanyCode());
		}
		
		try{
			//获取车辆存油信息
			
			String rq=map.get("rq").toString();
			String xlbm="";
			if(map.get("xlbm_like")!=null){
				xlbm= map.get("xlbm_like").toString().trim();
			}
			String gsbm="";
			if(map.get("ssgsdm_like")!=null){
				gsbm=map.get("ssgsdm_like").toString();
			}
			String fgsbm="";
			if(map.get("fgsdm_like")!=null){
				fgsbm=map.get("fgsdm_like").toString();
			}
			String nbbm="";
			if(map.get("nbbm_eq")!=null){
				nbbm=map.get("nbbm_eq").toString();
			}
			List<Dlb> ylListBe=repository.obtainYlbefore(rq, gsbm, "", xlbm, nbbm);
//			List<Cdl> cylList=cdlRepository.obtainCdl(nbbm, gsbm);
			List<Dlb> ylbList=repository.obtainDl(rq,gsbm,fgsbm,xlbm,nbbm,"nbbm");
			List<Ylxxb> ylxxbList=ylxxbRepository.obtainYlxx(rq,0,gsbm);
			for (int i = 0; i < ylxxbList.size(); i++) {
				Boolean fage=true;
				Ylxxb y1=ylxxbList.get(i);
				for(int y=0;y<ylbList.size();y++){
					Dlb y2=ylbList.get(y);
					if(y1.getNbbm().equals(y2.getNbbm())){
						fage=false;
						break;
					}
				}
				
				if(fage){
					Dlb t=new Dlb();
					t.setNbbm(y1.getNbbm());
					t.setRq(y1.getYyrq());
					t.setJsy(y1.getJsy());
					t.setCdl(y1.getJzl());
					t.setSsgsdm(y1.getGsdm());
					String fgsdm="";
					if(null!=carsMap.get(y1.getNbbm())){
						fgsdm=carsMap.get(y1.getNbbm());
					}
					t.setFgsdm(fgsdm);
					t.setJcsx(1);
					Line line= BasicData.nbbm2LineMap.get(y1.getNbbm());
					if(null !=line){
						t.setXlbm(line.getLineCode());
					}else{
						t.setXlbm("");
					}
					boolean status=true;
					for (int j = 0; j < ylListBe.size(); j++) {
						Dlb b=ylListBe.get(j);
						if(b.getNbbm().equals(y1.getNbbm())){
							t.setCzcd(b.getJzcd());
							status=false;
							break;
						}
					}
					/*if(status){
						for (int j = 0; j < cylList.size(); j++) {
							Cyl c=cylList.get(j);
							if(c.getNbbm().equals(y1.getNbbm())){
								t.setCzyl(c.getCyl());
								cyl=c;
								status=false;
								break;
							}
						}
					}*/
					if(status){
						t.setCzcd(0.0);
					}
//					double jzyl=Arith.add(t.getJzl(), t.getCzyl());
					t.setJzcd(100.0);
					t.setHd(0.0);
					if(fgsdm.equals(fgsbm)){
						repository.save(t);
					}
				}
			}
			newMap.put("status", ResponseCode.SUCCESS);
		}catch(Exception e){
			newMap.put("status", ResponseCode.ERROR);
			logger.error("save erro.", e);
			throw e;
		}
		
		return newMap;
	}

	@Override
	public List<Dlb> listDlb(Map<String, Object> map) {
		// TODO Auto-generated method stub
		List<Dlb> listDlb=new ArrayList<Dlb>();
		List<String> stringList=new ArrayList<String>();
		String rq=map.get("rq").toString();
		String gsbm=map.get("ssgsdm_like").toString();
		String fgsbm=map.get("fgsdm_like").toString();
		String xlbm=map.get("xlbm_like").toString().trim();
		String nbbm=map.get("nbbm_eq").toString();
		String sxtj=map.get("sxtj").toString();
		
		if(nbbm.trim()!=""){
			stringList.add(nbbm);
			listDlb=repository.listDlb(rq, gsbm, fgsbm, xlbm, stringList);
		}else{
			//全部
			if(sxtj.equals("0")){
				List<Object[]> objectLists=repository.checkNbmmNum(rq, gsbm, fgsbm, xlbm,nbbm);
				for (int i = 0; i < objectLists.size(); i++) {
					String clbm=objectLists.get(i)[0].toString();
					stringList.add(clbm);
				}
				if(stringList.size()>0){
					listDlb=repository.listDlb(rq, gsbm, fgsbm, xlbm, stringList);
				}
			}else{
				List<Object[]> objectLists;
				if(sxtj.equals("3")){
					//有加油没里程
					objectLists=repository.checkNbmmDl(rq, gsbm, fgsbm, xlbm, nbbm);
					for (int i = 0; i < objectLists.size(); i++) {
						String clbm=objectLists.get(i)[0].toString();
						double jzl=Double.parseDouble(objectLists.get(i)[1].toString());
						double zlc=Double.parseDouble(objectLists.get(i)[2].toString());
						if(jzl>0 && zlc<=0){
							stringList.add(clbm);
						}
						
					}
					
				}else if(sxtj.equals("4")){
					//有里程没加油
					objectLists=repository.checkNbmmDl(rq, gsbm, fgsbm, xlbm, nbbm);
					for (int i = 0; i < objectLists.size(); i++) {
						String clbm=objectLists.get(i)[0].toString();
						double jzl=Double.parseDouble(objectLists.get(i)[1].toString());
						double zlc=Double.parseDouble(objectLists.get(i)[2].toString());
						if(zlc>0 && jzl<=0){
							stringList.add(clbm);
						}
						
					}
				}else{
					objectLists=repository.checkNbmmNum(rq, gsbm, fgsbm, xlbm,nbbm);
					for (int i = 0; i < objectLists.size(); i++) {
						String clbm=objectLists.get(i)[0].toString();
						int cs=Integer.parseInt(objectLists.get(i)[1].toString());
						//一车一单
						if(sxtj.equals("1")){
							if(cs==1){
								stringList.add(clbm);
							}
						}	
						//一车多单
						if(sxtj.equals("2")){
							if(cs>1){
								stringList.add(clbm);
							}
						}
					}
				}
				
				if(stringList.size()>0){
					listDlb=repository.listDlb(rq, gsbm, fgsbm, xlbm, stringList);
				}
			}
		}

		return listDlb;
	}

	@Override
	public Map<String, Object> sumYlb(Map<String, Object> map) {
		// TODO Auto-generated method stub
		List<String> stringList = new ArrayList<String>();
		String rq = map.get("rq").toString();
		String gsbm = map.get("ssgsdm_like").toString();
		String fgsbm = map.get("fgsdm_like").toString();
		String xlbm = map.get("xlbm_like").toString().trim();
		String nbbm = map.get("nbbm_eq").toString();
		String sxtj = map.get("sxtj").toString();
		if (nbbm.trim() != "") {
			stringList.add(nbbm);
		} else {
			if (!sxtj.equals("0")) {
				List<Object[]> objectLists;
				if (sxtj.equals("3")) {
					// 有加油没里程
					objectLists = repository.checkNbmmDl(rq, gsbm, fgsbm, xlbm, nbbm);
					for (int i = 0; i < objectLists.size(); i++) {
						String clbm = objectLists.get(i)[0].toString();
						double jzl = Double.parseDouble(objectLists.get(i)[1].toString());
						double zlc = Double.parseDouble(objectLists.get(i)[2].toString());
						if (jzl > 0 && zlc <= 0) {
							stringList.add(clbm);
						}

					}

				} else if (sxtj.equals("4")) {
					// 有里程没加油
					objectLists = repository.checkNbmmDl(rq, gsbm, fgsbm, xlbm, nbbm);
					for (int i = 0; i < objectLists.size(); i++) {
						String clbm = objectLists.get(i)[0].toString();
						double jzl = Double.parseDouble(objectLists.get(i)[1].toString());
						double zlc = Double.parseDouble(objectLists.get(i)[2].toString());
						if (zlc > 0 && jzl <= 0) {
							stringList.add(clbm);
						}

					}
				} else {
					objectLists = repository.checkNbmmNum(rq, gsbm, fgsbm, xlbm, nbbm);
					for (int i = 0; i < objectLists.size(); i++) {
						String clbm = objectLists.get(i)[0].toString();
						int cs = Integer.parseInt(objectLists.get(i)[1].toString());
						// 一车一单

						if (sxtj.equals("1")) {
							if (cs == 1) {
								stringList.add(clbm);
							}
						}
						// 一车多单
						if (sxtj.equals("2")) {
							if (cs > 1) {
								stringList.add(clbm);
							}
						}
					}
				}
			}
		}
			List<Object[]> sumYlbList = new ArrayList<Object[]>();
			if (sxtj.equals("0")) {
				sumYlbList = repository.sumDlb2(rq, gsbm, fgsbm, xlbm, nbbm);
			} else {
				if (stringList.size() > 0) {
	
					// String strings[]=new String[stringList.size()];
					// for(int i=0;i<stringList.size();i++){
					// strings[i]=stringList.get(i);
					// }
					sumYlbList = repository.sumDlb(rq, gsbm, fgsbm, xlbm, stringList);
				} 
//				else {
//					sumYlbList = repository.sumDlb2(rq, gsbm, fgsbm, xlbm, nbbm);
//				}
			}
			Double jzl = 0.0, yh = 0.0, sh = 0.0;
			for (int i = 0; i < sumYlbList.size(); i++) {
				jzl = Arith.add(jzl, Double.valueOf(sumYlbList.get(i)[0].toString()));
				yh = Arith.add(yh, Double.valueOf(sumYlbList.get(i)[1].toString()));
				sh = Arith.add(sh, Double.valueOf(sumYlbList.get(i)[2].toString()));
			}
		
			Map<String, Object> sumMap = new HashMap<String, Object>();
			sumMap.put("jzl", jzl);
			sumMap.put("yh", yh);
			sumMap.put("sh", sh);
			return sumMap;
	}
	
	
	@Transactional  
	@Override
	public Map<String, Object> saveDlbList(Map<String, Object> map) throws Exception {
		// TODO Auto-generated method stub
		Map<String, Object> newMap=new HashMap<String,Object>();
		try{
		SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
		String json =StringEscapeUtils.unescapeHtml4(map.get("dlbList").toString());
		JSONArray jsonArray=JSONArray.parseArray(json);
		JSONObject jsonObject;
		// 获取车辆存油信息
//		List<Cyl> cylList = cylRepository.obtainCyl("","");
		for (int i = 0; i < jsonArray.size(); i++) {
//			Ylb t=new Ylb();
			jsonObject=jsonArray.getJSONObject(i);
			double czcd = jsonObject.getDoubleValue("czcd");
			double cdl =jsonObject.getDoubleValue("cdl");
			double jzcd =jsonObject.getDoubleValue("jzcd");
			double sh  =jsonObject.getDoubleValue("sh");
			String shyy =jsonObject.getString("shyy");
			double hd = jsonObject.getDoubleValue("hd");
			int yhlx =jsonObject.getIntValue("yhlx");
			Integer id =jsonObject.getInteger("id");
//			String nbbm =jsonObject.getString("nbbm");
//			String rq=jsonObject.getString("rq");
			repository.dlbUpdate(id, czcd, jzcd, hd, sh, shyy, yhlx);
		
		}
		newMap.put("status", ResponseCode.SUCCESS);
		}catch(Exception e){
			newMap.put("status", ResponseCode.ERROR);
			logger.error("save erro.", e);
			throw e;
		}
		return newMap;
	}
}