public string TestExportList(string fileTemplate)
{
var data = DBHelper.GetDataTable(@"SELECT * FROM dbo.cb_Cost WHERE ProjectCode='C01BJ01' order by CostCode ");
var str = ExcelHelper.ExportExcel(fileTemplate, data);
return(str);
}
public HttpResult ExportExcel(TemplateExportlDTO dto)
{
object excelData = ReflectionHelper.Invoke(dto.ServiceMethod, dto.CustomerParam);
var url = ExcelHelper.ExportExcel(dto.TemplateFile, excelData);
return(HttpResult.Ok(url));
}
public string TestExportDatatable(string fileTemplate)
{
var data = DBHelper.GetDataTable(@"select top 300 RoomGUID,Room,RoomCode,HuXing,Total,Price,Status,SLControlDate
from p_Room where SLControlDate is not null order by Roomcode ");
var str = ExcelHelper.ExportExcel(fileTemplate, data);
return(str);
}
