public String download() throws Exception {
    LogWriter.println(this.getClass().toString() + ":download下的方法被调用了");
    // 创建新的ExportExcel类以创建excel
    ExportExcel<YearCountTaxModel> ex = new ExportExcel<YearCountTaxModel>(new YearCountTaxModel());
    //
    SXSSFWorkbook workbook = new SXSSFWorkbook(300);
    if (getSessionUser() == null) {
      return "noSession";
    }
    // 获取记录总数,这里除以40000是为什么
    long count =
        yearCountTaxService.getAllMessageCount(
                    user.getUpperDistrict() + user.getDistrictName(), beginyear, endyear)
                / 40000
            + 1;
    LogWriter.println("获取的记录数位:" + count);

    for (int i = 0; i < count; ++i) {
      getAllList(i * 40000, 40000);
      // 获取需要下载的数据list
      // 获取需要下载的数据list
      workbook = ex.creatExcel(workbook, analyList);
    }
    // 创建输出流
    excelFile = ex.downLoadExcel(workbook);
    systemLogService.insertSystemLog("3", "下载按年度统计纳税征缴情况", true);
    return "excel";
  }
  public String getAllYearCountTaxByPage() {
    // 但是初始显示的时候 不应该是全部
    if (beginyear == null) {
      beginyear = "2011";
    } else {
      LogWriter.println("前台传给后台的数据beginyear为:" + beginyear);
    }
    if (endyear == null) {
      endyear = "2013";
    } else {
      LogWriter.println("前台传给后台的数据endyear为:" + endyear);
    }

    if (getSessionUser() == null) {
      return "noSession";
    }

    LogWriter.println("用户上级地区:" + user.getUpperDistrict() + "用户本级地区:" + user.getDistrictName());
    try {
      recordCount =
          yearCountTaxService.getAllMessageCount(
              user.getUpperDistrict() + user.getDistrictName(), beginyear, endyear);
    } catch (Exception e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
      json = "请检查是否存在相应的数据库模式";
      return "jsonData";
    }

    if (recordCount != 0) {
      int count = (int) (recordCount / pageSize);
      pageCount = ((recordCount % pageSize) == 0) ? count : count + 1; // 计算总页数
    }
    yearCountTaxList =
        yearCountTaxService.getAllMessageByPage(
            pageNum,
            pageSize,
            user.getUpperDistrict() + user.getDistrictName(),
            beginyear,
            endyear);

    return "showLessTaxMessage";
  }
  public String getDownloadFileName() {
    SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd ");

    String downloadFileName =
        "按年度统计纳税征缴情况"
            + user.getUpperDistrict()
            + user.getDistrictName()
            + sf.format(new Date()).toString()
            + ".xlsx";
    try {
      downloadFileName = new String(downloadFileName.getBytes("GBK"), "ISO8859-1");
    } catch (UnsupportedEncodingException e) {
      e.printStackTrace();
    }
    return downloadFileName;
  }
 /**
  * 得到数据
  *
  * @param startnum 数据开始的下标
  * @param totalnum 传过来的数据总数
  */
 public void getAllList(int startnum, int totalnum) {
   String dis = user.getUpperDistrict() + user.getDistrictName();
   //
   analyList = yearCountTaxService.getExcelList(dis, beginyear, endyear, startnum, totalnum);
 }