public HttpResponseMessage GetReportRateOutput(DateTime? begin_time = null, DateTime? end_time = null, string type = "大浮标")

         {

             var dataList = _adapter.DataReportRate(type, begin_time, end_time).ToList();

             NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();

             NPOI.SS.UserModel.ISheet sheet = book.CreateSheet("“" + type + "”到报率统计");

             // 第一列

             NPOI.SS.UserModel.IRow row = sheet.CreateRow();

             row.CreateCell().SetCellValue("站名");

             row.CreateCell().SetCellValue("应到报数");

             row.CreateCell().SetCellValue("叶绿素到报率");

             row.CreateCell().SetCellValue("气压到报率");

             row.CreateCell().SetCellValue("风速到报率");

             row.CreateCell().SetCellValue("气温到报率");

             row.CreateCell().SetCellValue("水温到报率");

             row.CreateCell().SetCellValue("波高到报率");

             row.CreateCell().SetCellValue("盐度到报率");

             NPOI.SS.UserModel.ICellStyle style = book.CreateCellStyle();

             style.Alignment = HorizontalAlignment.Center;

             style.FillBackgroundColor = NPOI.HSSF.Util.HSSFColor.DarkBlue.Index;

             style.FillForegroundColor = NPOI.HSSF.Util.HSSFColor.DarkBlue.Index;

             row.GetCell().CellStyle = style;

             row.GetCell().CellStyle = style;

             row.GetCell().CellStyle = style;

             row.GetCell().CellStyle = style;

             row.GetCell().CellStyle = style;

             row.GetCell().CellStyle = style;

             row.GetCell().CellStyle = style;

             row.GetCell().CellStyle = style;

             row.GetCell().CellStyle = style;

             sheet.SetColumnWidth(,  * );

             sheet.SetColumnWidth(,  * );

             sheet.SetColumnWidth(,  * );

             sheet.SetColumnWidth(,  * );

             sheet.SetColumnWidth(,  * );

             sheet.SetColumnWidth(,  * );

             sheet.SetColumnWidth(,  * );

             sheet.SetColumnWidth(,  * );

             sheet.SetColumnWidth(,  * );

             int index = ;

             foreach (DataTransferStatus dataInfo in dataList)

             {

                 // 第二列

                 NPOI.SS.UserModel.IRow row2 = sheet.CreateRow(index);

                 row2.CreateCell().SetCellValue(dataInfo.name);

                 row2.CreateCell().SetCellValue(dataInfo.report_number);

                 row2.CreateCell().SetCellValue(dataInfo.phyll_report_rate + "%");

                 row2.CreateCell().SetCellValue(dataInfo.pressure_report_rate + "%");

                 row2.CreateCell().SetCellValue(dataInfo.speed_report_rate + "%");

                 row2.CreateCell().SetCellValue(dataInfo.temp_report_rate + "%");

                 row2.CreateCell().SetCellValue(dataInfo.water_report_rate + "%");

                 row2.CreateCell().SetCellValue(dataInfo.wave_report_rate + "%");

                 row2.CreateCell().SetCellValue(dataInfo.salt_report_rate + "%");

                 index++;

             }

             System.IO.MemoryStream stream = new System.IO.MemoryStream();

             book.Write(stream);

             stream.Seek(, SeekOrigin.Begin);

             book = null;

             HttpResponseMessage mResult = new HttpResponseMessage(System.Net.HttpStatusCode.OK);

             mResult.Content = new StreamContent(stream);

             mResult.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment");

             mResult.Content.Headers.ContentDisposition.FileName = type + "_到报率统计" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";

             mResult.Content.Headers.ContentType = new MediaTypeHeaderValue("application/ms-excel");

             return mResult;

         }