protected void btnRoomsReportExport_Click(object sender, EventArgs e)
{
try
{
DropDownList ddlPropertyName = (DropDownList)Master.FindControl("ddlProperty");
string PropertyName = ddlPropertyName.SelectedItem.Text;
string PropertyVale = ddlPropertyName.SelectedItem.Value;
Response.Clear();
Response.Buffer = true;
Response.ClearContent();
Response.ClearHeaders();
Response.Charset = "";
string FileName = "Rooms_" + PropertyName + DateTime.Now + ".xls";
StringWriter strwritter = new StringWriter();
HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName);
GridView3.GridLines = GridLines.Both;
GridView3.HeaderStyle.Font.Bold = true;
GridView3.RenderControl(htmltextwrtter);
Response.Write(strwritter.ToString());
Response.End();
}
catch (Exception ex)
{
string text = ex.Message.ToString();
ScriptManager.RegisterStartupScript(this, typeof(Page), "Warning", "<script>showpoperror('" + text + "')</script>", false);
}
}
private void ExportDataGrid(string FileType, string FileName) //从DataGrid导出
{
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
Response.ContentType = FileType;
this.EnableViewState = false;
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
GridView11.RenderControl(hw);
GridView2.RenderControl(hw);
GridView3.RenderControl(hw);
GridView4.RenderControl(hw);
GridView5.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
}
protected void ibtnExportPDFAppTableDoc_Click(object sender, ImageClickEventArgs e)
{
GridView3.AllowPaging = false;
GridView3.DataSource = GetDataSource();
GridView3.DataBind();
if (GridView3.Rows.Count > 0)
{
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition",
"attachment;filename=ApprovedAdmitCardApplication.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView3.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
}
}
protected void lnkalready_Click(object sender, EventArgs e)
{
using (StringWriter sw = new StringWriter())
{
HtmlTextWriter hw = new HtmlTextWriter(sw);
//To Export all pages
GridView3.DataSource = already;
GridView3.DataBind();
GridView3.AllowPaging = false;
GridView3.AllowSorting = false;
GridView3.GridLines = GridLines.Both;
GridView3.HorizontalAlign = HorizontalAlign.Center;
Response.AddHeader("content-disposition", "attachment;filename=AlreadyAtm.xls");
Response.Charset = String.Empty;
Response.ContentType = "application/ms-excel";
GridView3.RenderControl(hw);
Response.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
protected void img_ExportToExcel3_Click(object sender, ImageClickEventArgs e)
{
Order = 1;
DataTable dt = FRB.GetEvalutionProfDividedODD(ddl_Term.SelectedValue, int.Parse(txt_CodeOstad.Text), int.Parse(ddl_CodeGroup.SelectedValue), int.Parse(ddl_CodeDras.SelectedValue), Order);
if (dt.Rows.Count == 0)
{
}
else
{
GridView3.DataSource = dt;
GridView3.DataBind();
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=ReportEvalutionProfDividedODD.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
using (StringWriter sw = new StringWriter())
{
HtmlTextWriter hw = new HtmlTextWriter(sw);
//To Export all pages
////gv_Show.AllowPaging = false;
////this.BindGrid();
//gv_Show.HeaderRow.BackColor = Color.White;
foreach (TableCell cell in GridView3.HeaderRow.Cells)
{
cell.BackColor = GridView3.HeaderStyle.BackColor;
}
foreach (GridViewRow row in GridView3.Rows)
{
//row.BackColor = Color.White;
foreach (TableCell cell in row.Cells)
{
if (row.RowIndex % 2 == 0)
{
cell.BackColor = GridView3.AlternatingRowStyle.BackColor;
}
else
{
cell.BackColor = GridView3.RowStyle.BackColor;
}
cell.CssClass = "textmode";
}
}
GridView3.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
}
public void ExcelExportReport()
{
try
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=Lab Invest Report (" + DateTime.Today.ToString("dd-MM-yyyy") + ").xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite =
new HtmlTextWriter(stringWrite);
GridView3.AllowPaging = false;
GridView4.AllowPaging = false;
ExcelReportMessage();
GridView3.CaptionAlign = TableCaptionAlign.Top;
GridView4.CaptionAlign = TableCaptionAlign.Top;
ReportOverAllSample();
ReportSelectedSample();
for (int i = 0; i < GridView3.HeaderRow.Cells.Count; i++)
{
GridView3.HeaderRow.Cells[i].Style.Add("font-size", "16px");
GridView3.HeaderRow.Cells[i].Style.Add("height", "80px");
GridView3.HeaderRow.Cells[i].Style.Add("background-color", "#00B894");
GridView3.HeaderRow.Cells[i].Style.Add("Color", "white");
}
// Footer Style:
GridView3.Rows[GridView3.Rows.Count - 1].Style.Add("font-size", "15px");
GridView3.Rows[GridView3.Rows.Count - 1].Font.Bold = true;
for (int i = 0; i < GridView4.HeaderRow.Cells.Count; i++)
{
GridView4.HeaderRow.Cells[i].Style.Add("font-size", "16px");
GridView4.HeaderRow.Cells[i].Style.Add("height", "80px");
GridView4.HeaderRow.Cells[i].Style.Add("background-color", "#00B894");
GridView4.HeaderRow.Cells[i].Style.Add("Color", "white");
}
// Footer Style:
GridView4.Rows[GridView4.Rows.Count - 1].Style.Add("font-size", "15px");
GridView4.Rows[GridView4.Rows.Count - 1].Font.Bold = true;
GridView3.RenderControl(htmlWrite);
GridView4.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
catch (Exception ex)
{
Response.Write("<script type=\"text/javascript\">alert(" + ex.Message + ")</script>");
}
}
protected void Export_Clicked(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.ClearContent();
Response.ClearHeaders();
Response.Charset = "";
string FileName = ddlCourseType.SelectedValue.Replace(" ", "_") + ddlCourseNo.SelectedValue.Replace("-", string.Empty) + "_" + lbEntryType.SelectedValue.Replace(" ", "_") + ".xls";
StringWriter strwritter = new StringWriter();
HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName);
//for (int i = 0; i < GridView3.Rows.Count; i++)
//{
// GridViewRow row = GridView1.Rows[i];
// row.Cells[3].Visible = false;
//}
if (lbEntryType.SelectedItem.Text.Equals("All"))
{
GridView1.GridLines = GridLines.Both;
GridView1.HeaderStyle.Font.Bold = true;
GridView1.RenderControl(htmltextwrtter);
}
else
{
if (string.IsNullOrEmpty(Session["User_ID"] as string))
{
GridView1.GridLines = GridLines.Both;
GridView1.HeaderStyle.Font.Bold = true;
GridView1.RenderControl(htmltextwrtter);
}
else if (Session["Access_Level"].ToString().Equals("4"))
{
GridView1.GridLines = GridLines.Both;
GridView1.HeaderStyle.Font.Bold = true;
GridView1.RenderControl(htmltextwrtter);
}
else
{
GridView3.Columns[4].Visible = false;
GridView3.GridLines = GridLines.Both;
GridView3.HeaderStyle.Font.Bold = true;
GridView3.RenderControl(htmltextwrtter);
}
}
Response.Write("<B>");
Response.Write(ddlCourseType.SelectedValue + " " + ddlCourseNo.SelectedValue + " " + lbEntryType.SelectedValue);
Response.Write("</B>");
Response.Write(strwritter.ToString());
Response.End();
}
protected void ExportToExcel(object sender, EventArgs e)
{
if (this.ButtonEdit.Text != "Edit")
{
this.Label1.Text = "Cancel Editing State Before Exporting!";
return;
}
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=Team_Table.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
using (StringWriter sw = new StringWriter())
{
HtmlTextWriter hw = new HtmlTextWriter(sw);
//To Export all pages
GridView3.AllowPaging = false;
//this.BindGrid();
GridView3.HeaderRow.BackColor = Color.White;
foreach (TableCell cell in GridView3.HeaderRow.Cells)
{
cell.BackColor = GridView3.HeaderStyle.BackColor;
}
foreach (GridViewRow row in GridView3.Rows)
{
row.BackColor = Color.White;
foreach (TableCell cell in row.Cells)
{
if (row.RowIndex % 2 == 0)
{
cell.BackColor = GridView3.AlternatingRowStyle.BackColor;
}
else
{
cell.BackColor = GridView3.RowStyle.BackColor;
}
cell.CssClass = "textmode";
}
}
GridView3.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
protected void btnDownloadExcelCorpCompReport_Click(object sender, EventArgs e)
{
hidTAB.Value = "#tab2";
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=CorpCompletenessReportExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
using (StringWriter sw = new StringWriter())
{
HtmlTextWriter hw = new HtmlTextWriter(sw);
//To Export all pages
GridView3.AllowPaging = false;
DQIAfterBVNCompletenessPageDataBind(ddlCat2.SelectedItem.Value, ddlbranch2.SelectedItem.Value);//.BindGrid();
GridView3.HeaderRow.BackColor = Color.White;
foreach (TableCell cell in GridView3.HeaderRow.Cells)
{
cell.BackColor = GridView3.HeaderStyle.BackColor;
}
foreach (GridViewRow row in GridView3.Rows)
{
row.BackColor = Color.White;
foreach (TableCell cell in row.Cells)
{
if (row.RowIndex % 2 == 0)
{
cell.BackColor = GridView3.AlternatingRowStyle.BackColor;
}
else
{
cell.BackColor = GridView3.RowStyle.BackColor;
}
cell.CssClass = "textmode";
}
}
GridView3.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
private void Export(string FileType, string FileName)
{
Response.Charset = "GB2312"; //避免文件名为乱码
Response.ContentEncoding = System.Text.Encoding.UTF8; //不知道干啥的，修改这行UTF8到7就出现乱码，最好别加了。
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
Response.ContentType = FileType;
this.EnableViewState = false;
StringWriter tw = new StringWriter(); //实例化StringWriter;
HtmlTextWriter hw = new HtmlTextWriter(tw); //实例化HtmlTextWriter;
//GridView1.Columns[7].Visible = false; //**!!!!**将第7列，也就是按钮列隐藏,否则无法导出来;
GridView3.RenderControl(hw);
GridView2.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
}
protected void Button2_Click(object sender, EventArgs e)
{
Response.ClearContent();
string fileName = Request.Url.ToString();
//int order = fileName.IndexOf("-", 0, 4);
//fileName = fileName.Substring(order,fileName.Length-order);
Response.AddHeader("content-disposition", "attachment; filename=" + fileName + ".xls");
Response.ContentType = "application/excel";
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
GridView3.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
protected void Button5_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=PaidMntRptOf" + DropDownList3.SelectedItem.ToString() + "OfCurrRpt.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
using (StringWriter sw = new StringWriter())
{
HtmlTextWriter hw = new HtmlTextWriter(sw);
//To Export all pages
GridView3.AllowPaging = false;
this.BindGrid();
GridView3.BorderColor = Color.Black;
GridView3.HeaderRow.BackColor = Color.Snow;
foreach (TableCell cell in GridView3.HeaderRow.Cells)
{
cell.BackColor = GridView3.HeaderStyle.BackColor;
}
foreach (GridViewRow row in GridView3.Rows)
{
row.BackColor = Color.White;
foreach (TableCell cell in row.Cells)
{
if (row.RowIndex % 2 == 0)
{
cell.BackColor = GridView3.AlternatingRowStyle.BackColor;
}
else
{
cell.BackColor = GridView3.RowStyle.BackColor;
}
cell.CssClass = "textmode";
}
}
GridView3.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { mso-number-format:\@; } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
private void ExportGridToPDF()
{
if (GridView3.Visible == false)
{
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=SIM_RequestForm.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView2.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
GridView2.AllowPaging = true;
GridView2.DataBind();
}
else
{
if (GridView2.Visible == false)
{
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=SIM_RequestForm.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView3.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
GridView3.AllowPaging = true;
GridView3.DataBind();
}
}
}
protected void btn2_Click(object sender, EventArgs e)
{
// Clear all content output from the buffer stream
Response.ClearContent();
// Specify the default file name using "content-disposition" RESPONSE header
Response.AppendHeader("content-disposition", "attachment; filename=class-teacher.xls");
// Set excel as the HTTP MIME type
Response.ContentType = "application/excel";
// Create an instance of stringWriter for writing information to a string
System.IO.StringWriter stringWriter2 = new System.IO.StringWriter();
// Create an instance of HtmlTextWriter class for writing markup
// characters and text to an ASP.NET server control output stream
HtmlTextWriter htw2 = new HtmlTextWriter(stringWriter2);
GridView3.RenderControl(htw2);
Response.Write(stringWriter2.ToString());
Response.End();
}
private void ExportGridToExcel()
{
Response.Clear();
Response.Buffer = true;
Response.ClearContent();
Response.ClearHeaders();
Response.Charset = "";
string FileName = "Agenda" + DateTime.Now + ".xls";
StringWriter strwritter = new StringWriter();
HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName);
GridView3.GridLines = GridLines.Both;
GridView3.HeaderStyle.Font.Bold = true;
GridView3.RenderControl(htmltextwrtter);
Response.Write(strwritter.ToString());
Response.End();
}
protected void ibtnExportExcelAppTableDoc_Click(object sender, ImageClickEventArgs e)
{
GridView3.AllowPaging = false;
GridView3.DataSource = GetDataSource();
GridView3.DataBind();
if (GridView3.Rows.Count > 0)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=ApprovedAdmitCardApplication.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView3.RenderControl(hw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
protected void Button3_Click(object sender, EventArgs e)
{
try
{
GridView3.Visible = true;
GETGRID1();
GridView3.Visible = true;
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename= '" + "AgnetLoan" + "'.xls");
Response.ContentType = "application/excel";
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
GridView3.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
catch (Exception ex)
{
WebMsgBox.Show(ex.ToString());
}
}
protected void Button3_Click(object sender, EventArgs e)
{
// Clear all content output from the buffer stream
Response.ClearContent();
// Specify the default file name using "content-disposition" RESPONSE header
Response.AppendHeader("content-disposition", "attachment; filename=Employees.xls");
// Set excel as the HTTP MIME type
Response.ContentType = "application/excel";
// Create an instance of stringWriter for writing information to a string
System.IO.StringWriter stringWriter = new System.IO.StringWriter();
// Create an instance of HtmlTextWriter class for writing markup
// characters and text to an ASP.NET server control output stream
HtmlTextWriter htw = new HtmlTextWriter(stringWriter);
// Set white color as the background color for gridview header row
GridView3.HeaderRow.Style.Add("background-color", "#FFFFFF");
// Set background color of each cell of GridView1 header row
foreach (TableCell tableCell in GridView3.HeaderRow.Cells)
{
tableCell.Style["background-color"] = "#A55129";
}
// Set background color of each cell of each data row of GridView1
foreach (GridViewRow gridViewRow in GridView3.Rows)
{
gridViewRow.BackColor = System.Drawing.Color.White;
foreach (TableCell gridViewRowTableCell in gridViewRow.Cells)
{
gridViewRowTableCell.Style["background-color"] = "#FFF7E7";
}
}
GridView3.RenderControl(htw);
Response.Write(stringWriter.ToString());
Response.End();
}
protected void btn_export_Click(object sender, EventArgs e)
{
//try
//{
// getdatefuntion();
// Response.ClearContent();
// Response.AddHeader("content-disposition", "attachment; filename= '" + ddl_Plantname.SelectedItem.Text + ":Bill Period" + FDATE + "To:" + TODATE + "'.xls");
// Response.ContentType = "application/excel";
// System.IO.StringWriter sw = new System.IO.StringWriter();
// HtmlTextWriter htw = new HtmlTextWriter(sw);
// GridView3.RenderControl(htw);
// Response.Write(sw.ToString());
// Response.End();
//}
//catch
//{
//}
try
{
Response.Clear();
Response.Buffer = true;
//string filename = "'" + ddl_Plantname.SelectedItem.Text + "' " + DateTime.Now.ToString() + ".xls";
getdatefuntion();
//Response.AddHeader("content-disposition", "attachment;filename=" + filename);
Response.AddHeader("content-disposition", "attachment; filename= '" + ddl_Plantname.SelectedItem.Text + ":Bill Period" + FDATE + "To:" + TODATE + "'.xls");
// Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
using (StringWriter sw = new StringWriter())
{
HtmlTextWriter hw = new HtmlTextWriter(sw);
//To Export all pages
GridView3.AllowPaging = false;
LoadUploadedFilesDetails();
GridView3.HeaderRow.BackColor = Color.White;
foreach (TableCell cell in GridView3.HeaderRow.Cells)
{
cell.BackColor = GridView3.HeaderStyle.BackColor;
}
foreach (GridViewRow row in GridView3.Rows)
{
row.BackColor = Color.White;
foreach (TableCell cell in row.Cells)
{
if (row.RowIndex % 2 == 0)
{
cell.BackColor = GridView3.AlternatingRowStyle.BackColor;
}
else
{
cell.BackColor = GridView3.RowStyle.BackColor;
}
cell.CssClass = "textmode";
}
}
GridView3.RenderControl(hw);
//style to format numbers to string
string style = @"<style> td { mso-number-format:""" + "\\@" + @"""; }</style>";
// string style = @"<style> .textmode { } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
catch (Exception ex)
{
WebMsgBox.Show(ex.ToString());
}
}
