private JsonTable GetBottomTable(BondDetailParams param, int id)
{
var userColumnService = (UserColumnService)DependencyResolver.Current.GetService(typeof(UserColumnService));
var columns = userColumnService.GetUserColumns(UserSettingHelper.GetUserId(Request), id);
int total;
var bottomTable = BondReportRepository.GetBondDetailByTypeNew(param, out total);
var reportcolumndefinitions = columns as REPORTCOLUMNDEFINITION[] ?? columns.ToArray();
var jsonTable = BuidJsonTable(bottomTable, reportcolumndefinitions, total, param.StartPage, param.PageSize);
List <Dictionary <string, string> > rowData = jsonTable.RowData;
foreach (Dictionary <string, string> currentRow in rowData)
{
foreach (DataRow row in bottomTable.Rows)
{
if (row["AssetId"].ToString() == currentRow["AssetId"])
{
if (!reportcolumndefinitions.Any(x => x.COLUMN_NAME == "IssuerOrgId"))
{
currentRow.Add("IssuerOrgId", row["IssuerOrgId"].ToString());
}
break;
}
}
}
return(jsonTable);
}
public ActionResult ExportExcelForIssuanceMaturesDetail(DateTime start, DateTime end, string type, string typeValue, int useSubType, string subType, string subTypeValue, string unit, string term, string reportName, int id, string order, string itemList, int startPage, int pageSize)
{
var userColumnService = (UserColumnService)DependencyResolver.Current.GetService(typeof(UserColumnService));
var columns = userColumnService.GetUserColumns(UserSettingHelper.GetUserId(Request), id);
var param = new BondDetailParams
{
Type = type,
TypeValue = typeValue,
UseSubType = useSubType == 1,
SubType = subType,
SubTypeValue = subTypeValue,
StartDate = start,
EndDate = end,
Term = term,
OrderBy = order,
ItemList = itemList,
StartPage = startPage,
PageSize = pageSize
};
int total;
var bottomTable = BondReportRepository.GetBondDetailByTypeNew(param, out total);
ReportParameter reportParam = new ReportParameter
{
StartDate = start,
EndDate = end,
Unit = string.IsNullOrEmpty(unit) ? "100M" : unit,
};
var reportcolumndefinitions = columns as REPORTCOLUMNDEFINITION[] ?? columns.ToArray();
return(new ExcelResult(bottomTable.AsEnumerable().AsQueryable(), reportcolumndefinitions.Select(x => x.DisplayName).ToArray(), reportcolumndefinitions.Select(x => x.COLUMN_NAME).ToArray(), reportName, reportName, false, null, reportParam, false, specificDateFormat: "yyyy-MM-dd"));
}
