protected void btnExport_OnClick(object sender, EventArgs e)
{
DataTable dtExport = ((DataTable)Session["dtExport"]);
List <string> ColumnList = new List <string>();
foreach (RepeaterItem item in rptExportColumn.Items)
{
var chkExportColumn = item.FindControl("chkExportColumn") as CheckBox;
if (chkExportColumn.Checked)
{
ColumnList.Add(chkExportColumn.Text);
}
}
if (ColumnList.Count == 0)
{
CU.ZMessage(eMsgType.Error, string.Empty, "Please Select Export Field.");
return;
}
dtExport = dtExport.DefaultView.ToTable(false, ColumnList.ToArray());
//string FileName = lblFileName.Text + "_" + CU.GetDateTimeName();
//Session[FileName] = dtExport;
//System.Web.UI.ScriptManager.RegisterStartupScript(Page, typeof(System.Web.UI.Page), "OpenWindow", "OpenNewWindow('ExcelExport.aspx?" + "FileName".Encrypt() + "=" + FileName.Encrypt() + "');", true);
string FileName = lblFileName.Text + "_" + CU.GetDateTimeName() + ".xls";
CU.ExportToExcel(Server.MapPath(CU.GettempDownloadPath()) + "/" + FileName, dtExport);
System.Web.UI.ScriptManager.RegisterStartupScript(Page, typeof(System.Web.UI.Page), "OpenWindow", "OpenNewWindow('" + CU.GettempDownloadPath() + "/" + FileName + "');", true);
}