public ApiResult <ExcelDownloadInfo> Export([FromBody] ExcelInfo info)
{
if (info == null)
{
throw new ArgumentNullException(nameof(info));
}
ApiResult <ExcelDownloadInfo> result = new ApiResult <ExcelDownloadInfo>();
result.Result = new ExcelDownloadInfo();
string fileExt = info.GetFileExt();
if (string.IsNullOrEmpty(info.FileName))
{
info.FileName = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + fileExt;
}
else
{
if (!info.FileName.EndsWith(fileExt))
{
info.FileName = info.FileName + fileExt;
}
}
//mimeType
string mineType = MimeHelper.GetMineType(info.FileName);
if (!info.IsExportSelectData)
{
//设置最大导出条数
info.Condition = info.Condition == null ? new QueryCondition() : info.Condition;
info.Condition.PageSize = SystemConfig.MaxExport;
if (string.IsNullOrEmpty(info.Api))
{
throw new ArgumentNullException(nameof(info.Api));
}
if (!info.Api.StartsWith(Request.Scheme))
{
info.Api = $"{Request.Scheme}://{Request.Host}{info.Api}";
}
}
string[] arrPath = GetTempFilePath(UrlScheme, info.FileName);
using (MemoryStream ms = info.ExportExeclStream(token))
{
using (FileStream fs = new FileStream(arrPath[0], FileMode.CreateNew))
{
ms.WriteTo(fs);
}
}
result.Result.Name = info.FileName;
result.Result.Url = arrPath[1];
return(result);
}
public ExcelModule() : base("Excel")
{
//任务列表
Post["/GridExport"] = r =>
{
string excelParam = Request.Form["excelParam"];
if (string.IsNullOrEmpty(excelParam))
{
return("");
}
ExcelInfo info = JsonConvert.DeserializeObject <ExcelInfo>(excelParam);
if (string.IsNullOrEmpty(info.FileName))
{
info.FileName = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + ".xls";
}
else
{
if (!info.FileName.EndsWith(".xls"))
{
info.FileName = info.FileName + ".xls";
}
}
MemoryStream ms = info.ExportExeclStream();
byte[] msbyte = ms.GetBuffer();
ms.Dispose();
ms = null;
return(new Response()
{
Contents = stream => { stream.Write(msbyte, 0, msbyte.Length); },
ContentType = "application/msexcel",
StatusCode = HttpStatusCode.OK,
Headers = new Dictionary <string, string> {
{ "Content-Disposition", string.Format("attachment;filename={0}", HttpUtility.UrlPathEncode(info.FileName)) },
{ "Content-Length", msbyte.Length.ToString() }
}
});
};
}
public ExcelModule() : base("Excel")
{
//任务列表
Post["/GridExport"] = r =>
{
string excelParam = Request.Form["excelParam"];
if (string.IsNullOrEmpty(excelParam))
{
return("");
}
ExcelInfo info = JsonConvert.DeserializeObject <ExcelInfo>(excelParam);
if (string.IsNullOrEmpty(info.FileName))
{
info.FileName = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + ".xls";
}
else
{
if (!info.FileName.EndsWith(".xls"))
{
info.FileName = info.FileName + ".xls";
}
}
MemoryStream ms = info.ExportExeclStream();
byte[] msbyte = ms.GetBuffer();
ms.Dispose();
ms = null;
return(new Response()
{
Contents = stream => { stream.Write(msbyte, 0, msbyte.Length); },
ContentType = "application/msexcel",
StatusCode = HttpStatusCode.OK,
Headers = new Dictionary <string, string> {
{ "Content-Disposition", string.Format("attachment;filename={0}", System.Web.HttpUtility.UrlPathEncode(info.FileName)) },
{ "Content-Length", msbyte.Length.ToString() }
}
});
};
/// <summary>
/// 导出Excel模版
/// </summary>
/// <param name="type">业务类型</param>
/// <param name="FunctionCode">对应功能模块Code</param>
/// <returns></returns>
Get["/DownLoadTemplate"] = r =>
{
if (AllImports == null)
{
AllImports = MefConfig.ResolveMany <ExcelImport>();
}
string strType = Request.Query["type"];
ExcelImportType type = EnumHelper.StringToEnum <ExcelImportType>(strType);
var handler = AllImports.FirstOrDefault(e => e.Type == type);
if (handler == null)
{
throw new Exception("未找到“" + type.ToString() + "”相应处理模块");
}
string path = ExcelImporMapper.GetTemplatePath(type);
if (File.Exists(path))
{
try
{
string FileName = Path.GetFileName(path);
return(new Response()
{
Contents = stream => { handler.GetExportTemplate(path, stream); },
ContentType = MimeHelper.GetMineType(path),
StatusCode = HttpStatusCode.OK,
Headers = new Dictionary <string, string> {
{ "Content-Disposition", string.Format("attachment;filename={0}", System.Web.HttpUtility.UrlPathEncode(FileName)) }
}
});
}
catch (Exception ex)
{
throw ex;
}
}
else
{
throw new Exception("未找到“" + type.ToString() + "”对应模版文件");
}
};
/// <summary>
/// 导出Excel模版
/// </summary>
/// <returns></returns>
Post["/ImportTemplate"] = r =>
{
ImportResult result = new ImportResult();
try
{
if (AllImports == null)
{
AllImports = MefConfig.ResolveMany <ExcelImport>();
}
string ywType = Request.Query["type"];
if (string.IsNullOrEmpty(ywType))
{
throw new ArgumentNullException("ywType");
}
//业务类型
ExcelImportType type = EnumHelper.StringToEnum <ExcelImportType>(ywType);
//文件
HttpFile file = Request.Files.First();
var handler = AllImports.FirstOrDefault(e => e.Type == type);
if (handler == null)
{
throw new Exception("未找到“" + type.ToString() + "”相应处理模块");
}
result = handler.ImportTemplate(file.Value, file.Name, null);
if (result.IsSuccess)
{
//是否获取详细数据，决定后台是否返回 result.ExtraInfo
string ReturnDetailData = Request.Query["ReturnDetailData"];
if (string.IsNullOrEmpty(ReturnDetailData) || ReturnDetailData != "1")
{
result.ExtraInfo = null;
}
}
else
{
//设置错误模版http路径
result.Message = Request.Url.SiteBase + result.Message;
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
LogHelper.WriteLog("Excel导入异常", ex);
}
return(Response.AsJson(result));
};
}