public string OnlineExportData(ExportDataModel exp)
{
EasyMan.Dtos.ErrorInfo err = new EasyMan.Dtos.ErrorInfo();
err.IsError = false;
try
{
//非压缩导出
string strFileName = exp.FileName;
//lngDbServerId = (long)exp.DbServerId;
strMapPathAll = "";
strPathAll = "";
string strPath = exp.FilePath;
Easyman.Common.Fun.GetPath(ref strFileName, exp.FileFormat, ref strMapPathAll, ref strPath);//重新整理保存路径
#region 表结果dt
DataTable dt = new DataTable();
if (exp.DbServerId == null)
{
dt = DbHelper.ExecuteGetTable(exp.Sql);
}
else
{
dt = _dbServerAppService.ExecuteGetTable((int)exp.DbServerId, exp.Sql); //要导出的数据集
}
#endregion
string ColumnHeader = "";
switch (exp.FileFormat.ToLower())
{
case ".xlsx":
ColumnHeader = GetHeadStr(exp.TopFields); //将表头对像转成字符串
OutExcelHelper.ExportExcel(dt, strFileName, strMapPathAll, ColumnHeader, true);
break;
case ".csv":
OutExcelHelper.ExportCsv(dt, strFileName, strMapPathAll, ColumnHeader, true);
break;
case ".txt":
OutExcelHelper.ExportTxt(dt, strFileName, strMapPathAll, ColumnHeader, true);
break;
default:
ColumnHeader = GetHeadStr(exp.TopFields); //将表头对像转成字符串
OutExcelHelper.ExportExcel(dt, strFileName, strMapPathAll, ColumnHeader, true);
break;
}
exp.FileName += exp.FileFormat;
SavaDBSql(strPath, strMapPathAll, exp);
return(strPath);
}
catch (Exception ex)
{
err.IsError = true;
err.Message = ex.Message;
throw;
}
}
/// <summary>
/// 多线程执行体
/// </summary>
/// <param name="exp"></param>
private static void OutExportFile(object exp)
{
ExportDataModel ExportDataM = (ExportDataModel)exp;
DataTable dt = (DataTable)ExportDataM.ObjParam;
switch (ExportDataM.FileFormat.ToLower())
{
case ".xlsx":
OutExcelHelper.ExportExcel(dt, ExportDataM.FileName, ExportDataM.FilePath, ExportDataM.ColumnHeader, false);
break;
case ".csv":
OutExcelHelper.ExportCsv(dt, ExportDataM.FileName, ExportDataM.FilePath, ExportDataM.ColumnHeader, false);
break;
case ".txt":
OutExcelHelper.ExportTxt(dt, ExportDataM.FileName, ExportDataM.FilePath, ExportDataM.ColumnHeader, false);
break;
default:
OutExcelHelper.ExportExcel(dt, ExportDataM.FileName, ExportDataM.FilePath, ExportDataM.ColumnHeader, false);
break;
}
}
