public Paging <List <StatisticalReportModel> > GetEventReport(string filter, int start, int limit)
{
List <Filter> filters = JsonConvert.DeserializeObject <List <Filter> >(filter);
StatisticalReportBLL bll = new StatisticalReportBLL();
return(bll.GetEventReport(filters, start, limit));
}
public DataTable ClassificationStatistics(int year)
{
StatisticalReportBLL srb = new StatisticalReportBLL();
DataTable dt = srb.ClassificationStatistics(year);
return(dt);
}
public HttpResponseMessage ExportYearExcel(string excelname, string exceltitle, string exceldata, string year)
{
StatisticalReportBLL bll = new StatisticalReportBLL();
//获取导出的数据
DataTable dt = bll.ClassificationStatistics(Convert.ToInt32(year));
//获取导出的Excel表
CommonFunctionBLL <StatisticalReportModel> cfBll = new CommonFunctionBLL <StatisticalReportModel>(exceldata);
return(cfBll.CreateExcel(dt, excelname, exceltitle));
}
public HttpResponseMessage ExportMonthExcel(string excelname, string exceltitle, string exceldata, string year, string month, string sourceid)
{
StatisticalReportBLL bll = new StatisticalReportBLL();
//获取导出的数据
List <StatisticalReportModel> list = bll.GetEventReport(year, month, sourceid);
//获取导出的Excel表
CommonFunctionBLL <StatisticalReportModel> cfBll = new CommonFunctionBLL <StatisticalReportModel>(exceldata);
return(cfBll.saveExcel(list, excelname, exceltitle));
}
public Paging <List <StatisticalReportModel> > GetEventReport(int start, int limit)
{
StatisticalReportBLL bll = new StatisticalReportBLL();
return(bll.GetEventReport(null, start, limit));
}
