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));
}
