车辆派遣管理系统第二周查询统计派车单统计

1、今日完成任务:
(1)完成查询统计-派车单统计模块的代码书写及测试工作

2、核心源码：

package com.dw.controller;

import java.net.URLDecoder;
import java.net.URLEncoder;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletResponse;

import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.util.StringUtils;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import com.dw.entity.Dispatch;
import com.dw.service.DispatchService;



@Controller
public class DispatchController {
   
	@Autowired
	private DispatchService ds;
	@RequestMapping("/queryAllDispatch")
	@ResponseBody
	public List<Dispatch> queryAllDispatch(Integer status,Integer carid,String year,String month,Integer companyid,Integer driverid,Integer clerkid,String startdate,String enddate){
   
		try {
   
			List<Dispatch> list = ds.queryAll(status,carid,year,month,companyid,driverid,clerkid,startdate,enddate);
			return list;
		} catch (Exception e) {
   
			e.printStackTrace();
			return null;
		}
	}
	@RequestMapping("/saveDispatch")
	@ResponseBody
	public void saveDispatch(Dispatch dispatch){
   
		try {
   
			ds.save(dispatch);
		} catch (Exception e) {
   
			e.printStackTrace();
		}
	}
	@RequestMapping("/exportDispatch")
	@ResponseBody
	public void exportDispatch(Integer status,Integer carid,Integer companyid,Integer driverid,Integer clerkid,String startdate,String enddate,HttpServletResponse resp){
   
		try {
   
			List<Dispatch> list = ds.queryAll(status,carid,null,null,companyid,driverid,clerkid,startdate,enddate);
			HSSFWorkbook workbook = createDispatchExcel(list,"派车单详细信息");
            //设置响应类型及头信息
            resp.setContentType("application/vnd.ms-excel");
            String filename = URLEncoder.encode("派车单统计.xls", "UTF-8");
            if(!StringUtils.isEmpty(driverid)){
   
            	filename = URLEncoder.encode("驾驶员"+list.get(0).getDriver().getName()+URLDecoder.decode(filename, "UTF-8"), "UTF-8");
            }
            if(!StringUtils.isEmpty(clerkid)){
   
            	filename = URLEncoder.encode("业务员"+list.get(0).getClerk().getName()+URLDecoder.decode(filename, "UTF-8"), "UTF-8");
            }
            if(!StringUtils.isEmpty(carid)){
   
            	filename = URLEncoder.encode(list.get(0).getCar().getCarnumber()+"车辆"+URLDecoder.decode(filename, "UTF-8"), "UTF-8");
            }
            if(!StringUtils.isEmpty(companyid)){
   
            	filename = URLEncoder.encode(list.get(0).getCustomer().getCompany()+URLDecoder.decode(filename, "UTF-8"), "UTF-8"