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)); }
public JsonResult GetOpenMarketOperation(int reportId, string type, DateTime startDate, DateTime endDate, string unit, bool includeExpired, string categoryType) { var table = OpenMarketReportRepository.GetOpenMarketOperation(type, startDate, endDate, unit, includeExpired?1:0); if (categoryType == "OperationTerm") { var dv = table.DefaultView; dv.Sort = "TERM"; table = dv.ToTable(); } var columns = OpenMarketReportRepository.GetOpenMarketColumnDefinitionByReportId(reportId, "Operation"); var jtable = BuidJsonTable(table, columns); return(Json(jtable, JsonRequestBehavior.AllowGet)); }
public ActionResult ExportExcelForSLO(int reportId, DateTime startDate, DateTime endDate, string unit, string includeExpired) { var table = OpenMarketReportRepository.GetOpenMarketSLO(startDate, endDate, unit); var columns = OpenMarketReportRepository.GetOpenMarketColumnDefinitionByReportId(reportId, "SLO"); var jtable = BuidJsonTable(table, columns); var reportName = MenuService.GetMenuNodeByReportId(reportId).DisplayName; reportName = Resources.Global.OpenMarketSLO; var totalColumns = new List <string>(); totalColumns.Add("IssueAmount"); var jP = new JsonExcelParameter { Table = jtable, TableName = reportName, Source = Resources.Global.Source, totalColumns = totalColumns, sumGroupColumnName = "Direction", isTotal = true }; return(new JsonTableGroupExcelResult(jP)); }
public ActionResult ExportExcelForOperation(int reportId, string type, DateTime startDate, DateTime endDate, string unit, bool includeExpired, string category) { var table = OpenMarketReportRepository.GetOpenMarketOperation(type, startDate, endDate, unit, includeExpired?1:0); if (category == "OperationTerm") { var dv = table.DefaultView; dv.Sort = "TERM"; table = dv.ToTable(); } var columns = OpenMarketReportRepository.GetOpenMarketColumnDefinitionByReportId(reportId, "Operation"); var jtable = BuidJsonTable(table, columns); var reportName = MenuService.GetMenuNodeByReportId(reportId).DisplayName; var totalColumns = new List <string>(); totalColumns.Add("Amount"); totalColumns.Add("Volume"); var jP = new JsonExcelParameter { Table = jtable, TableName = reportName, Source = Resources.Global.Source, totalColumns = totalColumns, sumGroupColumnName = category, isTotal = true }; return(new JsonTableGroupExcelResult(jP)); }