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 = "传过来的文件编号都不对"; } }