public IActionResult CreateExelDoc(int id)
{
OpenXmlExcel open = new OpenXmlExcel();
MemoryStream bais = new MemoryStream(open.CreateExcel().ToArray());
string file_type = "application/xlsx";
string file_name = "prikaz.xlsx";
return(File(bais, file_type, file_name));
}
/// <summary>
/// Excel导出方式
/// </summary>
/// <param name="paging">查询参数</param>
/// <param name="excelReportDto"></param>
/// <returns></returns>
public async Task <OperateStatus> ReportExcelUserQuery(SystemUserPagingInput paging,
ExcelReportDto excelReportDto)
{
var operateStatus = new OperateStatus();
try
{
//组装数据
IList <SystemUserOutput> dtos = (await _userInfoRepository.PagingUserQuery(paging)).Data.ToList();
var tables = new Dictionary <string, DataTable>(StringComparer.OrdinalIgnoreCase);
//组装需要导出数据
var dt = new DataTable("User");
dt.Columns.Add("Num");
dt.Columns.Add("Code");
dt.Columns.Add("Name");
dt.Columns.Add("OrganizationName");
dt.Columns.Add("Mobile");
dt.Columns.Add("IsFreeze");
dt.Columns.Add("CreatTime");
dt.Columns.Add("FirstVisitTime");
dt.Columns.Add("LastVisitTime");
dt.Columns.Add("Remark");
var num = 1;
if (dtos.Any())
{
foreach (var dto in dtos)
{
var row = dt.NewRow();
dt.Rows.Add(row);
row[0] = num;
row[1] = dto.Code;
row[2] = dto.Name;
row[3] = dto.OrganizationName;
row[4] = dto.Mobile;
row[5] = dto.IsFreeze ? "是" : "否";
row[7] = dto.FirstVisitTime;
row[8] = dto.LastVisitTime;
row[9] = dto.Remark;
num++;
}
}
tables.Add(dt.TableName, dt);
OpenXmlExcel.ExportExcel(excelReportDto.TemplatePath, excelReportDto.DownPath, tables);
operateStatus.ResultSign = ResultSign.Successful;
}
catch (Exception)
{
operateStatus.ResultSign = ResultSign.Error;
}
return(operateStatus);
}
public async Task <OperateStatus> ReportExcelExceptionLogQuery(QueryParam paging,
ExcelReportDto excelReportDto)
{
var operateStatus = new OperateStatus();
try
{
//获取总共条数
paging.Rows = await Count();
//组装数据
IList <SystemExceptionLog> dtos = (await _exceptionLogRepository.PagingQueryProcAsync(paging)).Data.ToList();
var tables = new Dictionary <string, DataTable>(StringComparer.OrdinalIgnoreCase);
//组装需要导出数据
var dt = new DataTable("ExceptionLog");
dt.Columns.Add("Num");
dt.Columns.Add("OperateTime");
dt.Columns.Add("Code");
dt.Columns.Add("Message");
dt.Columns.Add("RequestUrl");
dt.Columns.Add("ClientHost");
var num = 1;
if (dtos.Any())
{
foreach (var dto in dtos)
{
var row = dt.NewRow();
dt.Rows.Add(row);
row[0] = num;
row[1] = dto.CreateTime;
row[2] = dto.CreateUserCode;
row[3] = dto.Message;
row[4] = dto.RequestUrl;
row[5] = dto.ClientHost;
num++;
}
}
tables.Add(dt.TableName, dt);
OpenXmlExcel.ExportExcel(excelReportDto.TemplatePath, excelReportDto.DownPath, tables);
operateStatus.ResultSign = ResultSign.Successful;
}
catch (Exception)
{
operateStatus.ResultSign = ResultSign.Error;
}
return(operateStatus);
}
