public FileContentResult ListExcel(IDbConnection connection, ProductionreportListRequest request)
{
var data = List(connection, request).Entities;
var report = new DynamicDataReport(data, request.IncludeColumns, typeof(Columns.ProductionreportColumns));
var bytes = new ReportRepository().Render(report);
return(ExcelContentResult.Create(bytes, "CustomerGrossSales_" +
DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx"));
}
public ListResponse <MyRow> List(IDbConnection connection,
ProductionreportListRequest request)
{
var data = connection.Query <MyRow>("CuttmToT",
param: new
{
startDate = request.StartDate,
endDate = request.EndDate
},
commandType: System.Data.CommandType.StoredProcedure);
var response = new ListResponse <MyRow>();
response.Entities = (List <MyRow>)data;
return(response);
}
public ListResponse <MyRow> List(IDbConnection connection, ProductionreportListRequest request)
{
return(new MyRepository().List(connection, request));
}
