public FileResult NoOutExport(string classId, string startTime, string endTime) { IDictionary <string, string> parms = new Dictionary <string, string>(); var exportSql = new ReportHelper().CreateSql("Dorm_NoOutReport", classId, startTime, endTime, ref parms); var dbParameter = CreateParms(parms); var reports = LateReturnReportApp.GetDataTable(exportSql, dbParameter); var ms = new NPOIExcel().ToExcelStream(reports, "长时间未出报表"); ms.Seek(0, SeekOrigin.Begin); var filename = "长时间未出报表" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"; return(File(ms, "application/ms-excel", filename)); }
public FileResult OriginalExport(string studentNum) { var stuId = ""; if (!string.IsNullOrEmpty(studentNum)) { stuId = new StudentService().GetIdByStudentNumber(studentNum); if (stuId == null) { throw new Exception("未找到该学生"); } } IDictionary <string, string> parms = new Dictionary <string, string>(); var exportSql = OriginalReportApp.CreateSql(stuId, ref parms); var dbParameter = CreateParms(parms); var reports = OriginalReportApp.GetDataTable(exportSql, dbParameter); var ms = new NPOIExcel().ToExcelStream(reports, "原始流水数据报表"); ms.Seek(0, SeekOrigin.Begin); var filename = "原始流水数据报表" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"; return(File(ms, "application/ms-excel", filename)); }