public static Boolean SaveAsToFile(List <DNNGo_PowerForms_Field> fieldList, List <DNNGo_PowerForms_Content> DataList, String FullName, Int32 EnumExportExtension, bool ExtraTracking)
{
bool flag = false;
try
{
ExportDotNet excel = new ExportDotNet();
excel.Title = "HistoryRecords";
excel.ExportFileName = FullName;
FileInfo Exportfile = new FileInfo(FullName);
if (!Exportfile.Directory.Exists)
{
Exportfile.Directory.Create();
}
DataTable dt = new DataTable(excel.Title);
dt = ConvertDataTable(dt, fieldList, DataList, ExtraTracking);
if (EnumExportExtension == (Int32)EnumExport.Excel)
{
flag = excel.ExportToExcel(dt);
}
else if (EnumExportExtension == (Int32)EnumExport.CSV)
{
flag = excel.ExportToCSV(dt);
}
else if (EnumExportExtension == (Int32)EnumExport.Doc)
{
flag = excel.ExportToDoc(dt);
}
else if (EnumExportExtension == (Int32)EnumExport.Html)
{
flag = excel.ExportToHtml(dt);
}
else if (EnumExportExtension == (Int32)EnumExport.TextFile)
{
flag = excel.ExportToTextFile(dt);
}
else if (EnumExportExtension == (Int32)EnumExport.Xml)
{
flag = excel.ExportToXml(dt);
}
else
{
flag = excel.ExportToExcel(dt);
}
}
catch (Exception ex)
{
throw ex;
}
return(flag);
}
public void Execute(BasePage Context)
{
Int32 EventId = WebHelper.GetIntParam(Context.Request, "EventId", 0);
if (EventId > 0)
{
var EventItem = Playngo_ClientZone_Event.FindByKeyForEdit(EventId);
if (EventItem != null && EventItem.ID > 0)
{
//拼凑文件名
String FileName = String.Format("Users_{0}_{1}.{2}", Context.ModuleId, DateTime.Now.ToString("yyyyMMddHHmmssffff"), "csv");
//文件路径
String FilePath = Context.Server.MapPath(String.Format("{0}ClientZone/Export/{1}", Context.PortalSettings.HomeDirectory, FileName));
//文件实体
var fileInfo = new FileInfo(FilePath);
//文件路径是否需要创建
if (!fileInfo.Directory.Exists)
{
fileInfo.Directory.Create();
}
//创建导出类实体
ExportDotNet excel = new ExportDotNet();
//导出标题(Excel之类的才有)
excel.Title = String.Format("User list of events {0}", EventItem.Title);
excel.ExportFileName = FilePath;
DataTable dt = new DataTable(excel.Title);
//获取表格数据
dt = GetDataTable(EventItem, dt, Context);
//导出表格数据到CSV
Boolean flag = excel.ExportToCSV(dt);
if (flag)
{
//下载文件
FileSystemUtils.DownloadFile(excel.ExportFileName, FileName);
}
}
else
{
ResponseString = "没找到数据怎么搞";
}
}
else
{
ResponseString = "传过来的文件编号都不对";
}
}
/// <summary>
/// 导出表格信息
/// </summary>
protected void btnExportExcel_Click(object sender, EventArgs e)
{
try
{
var UserList = GetUserList();
if (UserList != null && UserList.Count > 0)
{
DataTable UserTable = ConvertUserList(UserList);
//拼凑文件名
String FileName = String.Format("Users_{0}_{1}.{2}", ModuleId, DateTime.Now.ToString("yyyyMMddHHmmssffff"), "xls");
//文件路径
String FilePath = Context.Server.MapPath(String.Format("{0}ClientZone/Export/{1}", PortalSettings.HomeDirectory, FileName));
//文件实体
var fileInfo = new FileInfo(FilePath);
//文件路径是否需要创建
if (!fileInfo.Directory.Exists)
{
fileInfo.Directory.Create();
}
//创建导出类实体
ExportDotNet excel = new ExportDotNet();
//导出标题(Excel之类的才有)
excel.Title = "Users";
excel.ExportFileName = FilePath;
Boolean flag = excel.ExportToExcel(UserTable);
if (flag)
{
//下载文件
FileSystemUtils.DownloadFile(excel.ExportFileName, FileName);
}
}
else
{
//没有用户
}
}
catch (Exception ex)
{
ProcessModuleLoadException(ex);
}
}
