public FileContentResult ListExcel(IDbConnection connection, CustomerGrossSalesListRequest request)
{
var data = List(connection, request).Entities;
var report = new DynamicDataReport(data, request.IncludeColumns, typeof(Columns.CustomerGrossSalesColumns));
var bytes = new ReportRepository().Render(report);
return ExcelContentResult.Create(bytes, "CustomerGrossSales_" +
DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx");
}
public ListResponse <MyRow> List(IDbConnection connection,
CustomerGrossSalesListRequest request)
{
var data = connection.Query <MyRow>("CustomerGrossSales",
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, CustomerGrossSalesListRequest request)
{
return(new MyRepository().List(connection, request));
}
