/// <summary>
/// 导出grid数据excel
/// </summary>
/// <param name="excelId"></param>
/// <param name="accountItemIds">科目id集合</param>
/// <param name="financialDataItemIds">项目id集合</param>
/// <param name="qiJianTypeId">会计期间类型</param>
/// <returns></returns>
public FileResult ExportExcel(int excelId, string accountItemIds, string financialDataItemIds, int xiangMuTreeTypeId, int qiJianTypeId = 1, int onlyStatisticChildren = 0, int statisticAccountChildren = 0)
{
try
{
var action = new ExportExcelAction(_financialDataBll, _financialDataExtendBll);
var result = action.Process(excelId, accountItemIds, financialDataItemIds, qiJianTypeId, onlyStatisticChildren, xiangMuTreeTypeId, statisticAccountChildren);
return(File(result, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", string.Format("统计数据_{0}.xlsx", DateTime.Now.ToString("yyyyMMddHHmmss"))));
}
catch (Exception ex)
{
Log.Write("导出grid数据excel出错", MessageType.Error, typeof(FinancialDataController), ex);
return(null);
}
}
/// <summary>
/// 导出excel
/// </summary>
/// <param name="ids"></param>
/// <returns></returns>
public FileResult ExportExcel(string ids)
{
try
{
var action = new ExportExcelAction(_companyBll);
var result = action.Process(ids);
return(File(result, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", string.Format("公司地推表_{0}.xlsx", DateTime.Now.ToString("yyyyMMddHHmmss"))));
}
catch (Exception ex)
{
Log.Write("导出grid数据excel出错", MessageType.Error, typeof(FinancialDataController), ex);
return(null);
}
}