public JsonResult GetOpenMarketSLF(int reportId, DateTime startDate, DateTime endDate, string unit) { var table = OpenMarketReportRepository.GetOpenMarketSLF(startDate, endDate, unit); var columns = OpenMarketReportRepository.GetOpenMarketColumnDefinitionByReportId(reportId, "SLF"); var jtable = BuidJsonTable(table, columns); return(Json(jtable, JsonRequestBehavior.AllowGet)); }
public ActionResult ExportExcelForSLF(int reportId, DateTime startDate, DateTime endDate, string unit) { var table = OpenMarketReportRepository.GetOpenMarketSLF(startDate, endDate, unit); var columns = OpenMarketReportRepository.GetOpenMarketColumnDefinitionByReportId(reportId, "SLF"); var jtable = BuidJsonTable(table, columns); var reportName = MenuService.GetMenuNodeByReportId(reportId).DisplayName; reportName = Resources.Global.OpenMarketSLF; var jP = new JsonExcelParameter { Table = jtable, TableName = reportName, Source = Resources.Global.Source }; return(new JsonTableExcelResult(jP)); }