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);
}
}
public void Execute(BasePage Context)
{
var FileList = new List <Playngo_ClientZone_DownloadFile>();
//将文件列表取出
String FileIds = WebHelper.GetStringParam(Context.Request, "FileIds", "");
if (!String.IsNullOrEmpty(FileIds))
{
FileIds = FileIds.Trim(',');
if (!String.IsNullOrEmpty(FileIds))
{
FileList = Playngo_ClientZone_DownloadFile.FindAllByIds(FileIds);
}
}
//待打包的文件路径
var FilePathList = new List <String>();
if (FileList != null && FileList.Count > 0)
{
//将文件的路径收集着
foreach (var FileItem in FileList)
{
if (FileItem != null && FileItem.ID > 0 && !String.IsNullOrEmpty(FileItem.Options))
{
if (Context.IsPreRoleView(FileItem.Per_AllUsers, FileItem.Per_Roles) && Context.IsPreJurisdictionView(FileItem.Per_AllJurisdictions, FileItem.Per_Jurisdictions))
{
var FileItemOptions = ConvertTo.Deserialize <List <KeyValueEntity> >(FileItem.Options);
if (FileItemOptions != null)
{
TemplateFormat xf = new TemplateFormat(Context);
String UploadFile = xf.GetFilePath(xf.ViewItemSettingT <String>(FileItem.Options, "UploadFile", ""), Context);
if (!String.IsNullOrEmpty(UploadFile))
{
UploadFile = Context.Server.MapPath(UploadFile);
if (File.Exists(UploadFile) && !FilePathList.Exists(r => r.ToLower() == UploadFile.ToLower()))
{
FilePathList.Add(UploadFile);
}
}
}
}
else
{
//没有权限下载
}
}
}
if (FilePathList != null && FilePathList.Count > 0)
{
//整理压缩包文件路径等信息
String ZipPath = Context.Server.MapPath(String.Format("{0}ClientZone/temporary/download-{1}files-{2}.zip", Context.PortalSettings.HomeDirectory, FilePathList.Count, DateTime.Now.ToString("yyyyMMdd-Hms")));
FileInfo ZipFile = new FileInfo(ZipPath);
if (!ZipFile.Directory.Exists)
{
ZipFile.Directory.Create();
}
else
{
//清楚很多天前的文件
FileSystemUtils.ClearFiles(ZipFile.Directory, 1);
}
//创建压缩包
FileSystemUtils.CreateZipFiles(FilePathList, ZipPath);
//将压缩好的文件列表下载
FileSystemUtils.DownloadFile(ZipPath, Path.GetFileName(ZipPath));
}
else
{
IsResponseWrite = true;
ResponseString = "No files found.";
}
}
}