public ActionResult Index()
{
StringWriter stringWriter = new StringWriter();
using (HtmlTextWriter writer = new HtmlTextWriter(stringWriter))
{
string classValue = "className";
writer.RenderBeginTag(HtmlTextWriterTag.Html);
writer.AddAttribute(HtmlTextWriterAttribute.Class, classValue);
writer.AddStyleAttribute(HtmlTextWriterStyle.Color, "#db4141");
writer.Write("Huy");
writer.RenderBeginTag(HtmlTextWriterTag.Div);
writer.RenderEndTag();
writer.RenderEndTag();
GridView grid = new GridView();
grid.AllowPaging = false;
grid.RenderControl(writer);
//Change the Header Row back to white color
DataTable[] dt = new DataTable[2];
for (int i = 0; i <= 1; i++)
{
dt[i] = new DataTable();
dt[i].Columns.Add("id");
dt[i].Columns.Add("name");
}
IHTMLBuilder htmlBuilder = new HTMLBuilder();
htmlBuilder.Build();
grid.DataSource = dt;
grid.DataBind();
//Apply style to Individual Cells
grid.HeaderRow.Cells[0].Text = "harrison";
grid.HeaderRow.Cells[0].Style.Add("background-color", "green");
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=GridViewExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
Dictionary<string, IdentityModels> test = new Dictionary<string, IdentityModels>();
test.Add("huy", new IdentityModels());
var testModel = test["huy"];
}
Response.Output.Write(stringWriter.ToString());
Response.Flush();
Response.End();
return View();
}
protected void btnExcel_Click(object sender, EventArgs e)
{
//Create a dummy GridView
GridView GridView1 = new GridView();
GridView1.AllowPaging = false;
GridView1.DataSource = BindGridView();
GridView1.DataBind();
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=" + DateTime.Now.Year + "-Newly_Hired" + ".xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
for (int i = 0; i < GridView1.Rows.Count; i++)
{
//Apply text style to each Row
GridView1.Rows[i].Attributes.Add("class", "textmode");
}
GridView1.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();
}
public ActionResult ExportProductData()
{
// string ss = "<table><td><td></table>";
var products = Session["Product"];
GridView gv = new GridView();
gv.DataSource = products;
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=Orderlist.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gv.RenderControl(htw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
//Response.ClearContent();
//Response.AddHeader("content-disposition", "attachment; filename=Orderlist.xls");
//Response.ContentType = "application/ms-excel";
//Response.Write(ss);
//Response.End();
return RedirectToAction("Reports");
}
/// <summary>
/// 导出Excel
/// </summary>
/// <param name="obj"></param>
public void ExportData(System.Web.UI.WebControls.GridView obj)
{
try
{
string style = "";
if (obj.Rows.Count > 0)
{
style = @"<style> .text { mso-number-format:\@; } </script> ";
}
else
{
style = "no data.";
}
Response.ClearContent();
DateTime dt = DateTime.Now;
string filename = dt.Year.ToString() + dt.Month.ToString() + dt.Day.ToString() + dt.Hour.ToString() + dt.Minute.ToString() + dt.Second.ToString();
Response.AddHeader("content-disposition", "attachment; filename=ExportData" + filename + ".xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
obj.RenderControl(htw);
Response.Write(style);
Response.Write(sw.ToString());
Response.End();
}
catch
{
}
}
public static void OutPutExcelByGridView(GridView grvExcel, string excelName, string encodingName, System.Globalization.CultureInfo ci)
{
//定义文档类型、字符编码
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Buffer = true;
HttpContext.Current.Response.Charset = encodingName;
//下面这行很重要， attachment 参数表示作为附件下载，您可以改成 online在线打开
//filename=FileFlow.xls 指定输出文件的名称，注意其扩展名和指定文件类型相符，可以为：.doc .xls .txt .htm
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpContext.Current.Server.UrlEncode(excelName));
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding(encodingName);
//Response.ContentType指定文件类型 可以为application/ms-excel、application/ms-word、application/ms-txt、application/ms-html 或其他浏览器可直接支持文档
HttpContext.Current.Response.ContentType = "application/ms-excel";
grvExcel.EnableViewState = false;
if (ci == null) ci = new System.Globalization.CultureInfo("zh-CN", true);
System.Globalization.CultureInfo myCultureInfo = ci;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCultureInfo);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
oHtmlTextWriter.Write("<html><head><meta http-equiv=\"content-type\" content=\"text/html;charset=gb2312\"></head>");
grvExcel.Visible = true;
grvExcel.RenderControl(oHtmlTextWriter);
//this 表示输出本页，你也可以绑定datagrid,或其他支持obj.RenderControl()属性的控件
HttpContext.Current.Response.Write(oStringWriter.ToString());
HttpContext.Current.Response.End();
}
private static void DisplayExcelDocument(System.Web.UI.WebControls.GridView grid, HttpResponse response)
{
var filename = string.Format("Отчет_{0}.xls", DateTime.Now.ToString());
response.Clear();
response.ContentType = "text/html";
response.AddHeader("content-disposition", "attachment;filename=" + filename);
response.ContentEncoding = Encoding.UTF8;
var s = new StringWriter();
var writer = new ExcelHtmlTextWriter(s);
var v = grid.AllowPaging;
grid.AllowPaging = false;
grid.RenderControl(writer);
var hypertext = string.Format(
@"<html><head><meta http-equiv=""Content-Type"" content=""text/html; charset=utf-8"" /></head><body>{0}</body></html>",
s.ToString());
response.Write(hypertext);
response.Flush();
response.End();
grid.AllowPaging = v;
}
public bool ToExcel(HttpResponseBase Response, DataTable listTable, string nomeArquivo = "ConsultaPedidos.xls", int columnsMerged = 0)
{
var grid = new System.Web.UI.WebControls.GridView();
grid.DataSource = listTable;
grid.DataBind();
if (columnsMerged > 0)
{
MergeRows(grid, columnsMerged);
}
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=" + nomeArquivo);
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
return(true);
}
protected void ExportToPDF(DataTable dt)
{
GridView gvExport = new GridView();
gvExport.AllowPaging = false;
gvExport.DataSource = dt;
gvExport.DataBind();
gvExport.HeaderRow.Style.Add("font-size", "10px");
gvExport.HeaderRow.Style.Add("font-weight", "bold");
gvExport.Style.Add("text-decoration", "none");
gvExport.Style.Add("font-family", "Arial, Helvetica, sans-serif;");
gvExport.Style.Add("font-size", "8px");
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=LinkSpace.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
gvExport.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();
}
public void ExportClientsListToExcel()
{
var grid = new System.Web.UI.WebControls.GridView();
string[] ClientsList={"mike","jonh","vladimit"};
grid.DataSource = /*from d in dbContext.diners
where d.user_diners.All(m => m.user_id == userID) && d.active == true */
from d in ClientsList
select new
{
FirstName = d
};
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Exported_Diners.xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
/// <summary>
/// dtData是要导出为Excel的DataTable,FileName是要导出的Excel文件名(不加.xls)
/// </summary>
/// <param name="dtData"></param>
/// <param name="FileName"></param>
private void DataTable2Excel(DataTable dtData, String FileName)
{
System.Web.UI.WebControls.GridView dgExport = null;
//当前对话
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
//IO用于导出并返回excel文件
System.IO.StringWriter strWriter = null;
System.Web.UI.HtmlTextWriter htmlWriter = null;
if (dtData != null)
{
//设置编码和附件格式
//System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8)作用是方式中文文件名乱码
curContext.Response.AddHeader("content-disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8) + ".xls");
curContext.Response.ContentType = "application nd.ms-excel";
curContext.Response.ContentEncoding = System.Text.Encoding.UTF8;
curContext.Response.Charset = "GB2312";
//导出Excel文件
strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
//为了解决dgData中可能进行了分页的情况,需要重新定义一个无分页的GridView
dgExport = new System.Web.UI.WebControls.GridView();
dgExport.DataSource = dtData.DefaultView;
dgExport.AllowPaging = false;
dgExport.DataBind();
//下载到客户端
dgExport.RenderControl(htmlWriter);
curContext.Response.Write(strWriter.ToString());
curContext.Response.End();
}
}
/// <summary>
/// 将DataTable数据导出到EXCEL，调用该方法后自动返回可下载的文件流
/// </summary>
/// <param name="dtData">要导出的数据源</param>
public static void DataTable1Excel(System.Data.DataTable dtData, string name)
{
System.Web.UI.WebControls.GridView gvExport = null;
// 当前对话
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
// IO用于导出并返回excel文件
System.IO.StringWriter strWriter = null;
System.Web.UI.HtmlTextWriter htmlWriter = null;
if (dtData != null)
{
// 设置编码和附件格式
curContext.Response.ContentType = "application/vnd.ms-excel";
curContext.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(name, Encoding.UTF8).ToString());
curContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
curContext.Response.Charset = "utf-8";
// 导出excel文件
strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
// 为了解决gvData中可能进行了分页的情况，需要重新定义一个无分页的GridView
gvExport = new System.Web.UI.WebControls.GridView();
gvExport.DataSource = dtData.DefaultView;
gvExport.AllowPaging = false;
gvExport.DataBind();
// 返回客户端
gvExport.RenderControl(htmlWriter);
curContext.Response.Write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\" />" + strWriter.ToString());
curContext.Response.End();
}
}
public ActionResult GetUserExcelList(string searchType, string searchText, int? page, int? rows)
{
var grid = new System.Web.UI.WebControls.GridView();
List<UserT> model = new UserBiz().GetUserList(searchType, searchText, page.Value, rows.Value);
grid.DataSource = from m in model
select new
{
LoginId = m.LoginId,
LastLoginDate = m.LastLoginDate,
IsDeleted = m.IsDeleted,
DeletedDate = m.DeletedDate,
InsertUser = m.InsertUser,
InsertDate = m.InsertDate,
};
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", string.Format("attachment; filename=Excel_{0}.xls", DateTime.Now.ToString("yyyyMMddhhmmss")));
Response.Write("<meta http-equiv='Content-Type' content='text/html; charset=" + Request.ContentEncoding.HeaderName + "'>");
Response.Buffer = true;
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
return View("Index");
}
public async Task<FileResult> CreateSendExcellFile()
{
List<Report> report = await db.FilesDownloadNotes.Include(f => f.ApplicationUser).Include(f => f.FilesUploadNote)
.Select(x => new Report
{
FileName = x.FilesUploadNote.Name,
FileFileSize = x.FilesUploadNote.Size,
FileType = x.FilesUploadNote.Type,
DataUploaded = x.FilesUploadNote.DataTimeUpload,
WhoUploaded = x.FilesUploadNote.UserName,
TypeOperations = x.FileOperations,
DataOperations = x.DateTimeDownload,
WhoOperations = x.ApplicationUser.UserName
}).ToListAsync();
GridView grid = new GridView();
grid.DataSource = report;
grid.DataBind();
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
string r_name = "Report_" + DateTime.Now.ToString() + "_.xls";
return File(Encoding.UTF8.GetBytes(sw.ToString()), "application/ms-excel", r_name);
}
/// <summary>
/// 将GridView数据导出到Excel（保存为2003格式）
/// </summary>
/// <param name="obj"></param>
public void GridViewExportToExcel(System.Web.UI.WebControls.GridView obj)
{
try
{
string style = "";
if (obj.Rows.Count > 0)
{
style = @"<style> .text { mso-number-format:\@; } </script> ";
}
else
{
style = "no data.";
}
HttpContext.Current.Response.ClearContent();
string fileName = DateTime.Now.ToString("yyyyMMddHHmmsslll");
HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename=ExportData" + fileName + ".xls");
HttpContext.Current.Response.ContentType = "application/ms-excel";
HttpContext.Current.Response.Charset = "GB2312";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
obj.RenderControl(htw);
HttpContext.Current.Response.Write(style);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
catch (Exception ex)
{
throw ex;
}
}
public void ExportToExcel(DataTable dataTable, HttpResponse response)
{
// Create a dummy GridView
GridView GridView1 = new GridView();
GridView1.AllowPaging = false;
GridView1.DataSource = dataTable;
GridView1.DataBind();
response.Clear();
response.Buffer = true;
response.AddHeader("content-disposition", "attachment;filename=DataTable.xls");
response.Charset = "";
response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
for (int i = 0; (i
<= (GridView1.Rows.Count - 1)); i++)
{
// Apply text style to each Row
GridView1.Rows[i].Attributes.Add("class", "textmode");
}
GridView1.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();
}
public void ExportClientsListToExcel()
{
var grid = new System.Web.UI.WebControls.GridView();
string[] ClientsList = { "mike", "jonh", "vladimit" };
grid.DataSource = /*from d in dbContext.diners
* where d.user_diners.All(m => m.user_id == userID) && d.active == true */
from d in ClientsList
select new
{
FirstName = d
};
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Exported_Diners.xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
public void ExportRiskTableToXLS()
{
var grid = new System.Web.UI.WebControls.GridView();
grid.DataSource = /*from d in dbContext.diners
* where d.user_diners.All(m => m.user_id == userID) && d.active == true */
from line in GlobalVariables.glob_risk_list
select new
{
RiskName = line.risk_name,
RiskCategory = line.risk_category,
RiskProbability = line.risk_probability,
RiskImpact = line.risk_impact,
RiskRMMM = line.risk_RMMM
};
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=RiskTable.xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
public ActionResult ExportToPdf()
{
var grid = new System.Web.UI.WebControls.GridView();
grid.DataSource = GetAirtelDetails();
grid.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=MyPdf.pdf");
Response.ContentType = "application/pdf";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
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.Output.Write(sw.ToString());
Response.Flush();
Response.End();
return(View("Index"));
}
protected void generaXLS(string reporte, string campos, string sql)
{
GridView GridView2 = new GridView();
GridView2.AllowPaging = false;
GridView2.DataSource = obtienDatosTabla(campos, sql);
GridView2.DataBind();
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=" + reporte + ".xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
for (int i = 0; (i
<= (GridView2.Rows.Count - 1)); i++)
{
// Apply text style to each Row
GridView2.Rows[i].Attributes.Add("class", "textmode");
}
GridView2.RenderControl(hw);
string style = "<style> .textmode{mso-number-format:\\@;}</style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
protected void btnDownload_Click(object sender, ImageClickEventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename=Baogia.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite =
new HtmlTextWriter(stringWrite);
DataSet dts = new DataSet();
SqlDataAdapter adt = new SqlDataAdapter();
SqlCommand comm = new SqlCommand("Export_to_Excel", objConn.SqlConn());
comm.CommandType = CommandType.StoredProcedure;
comm.Connection.Open();
adt.SelectCommand = comm;
adt.Fill(dts);
GridView g = new GridView();
g.DataSource = dts;
g.DataBind();
g.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
protected void generatePDFButton_Click(object sender, EventArgs e)
{
DataTable aDataTable = aPatientManager.GetData(Convert.ToInt64(voterIdTextBox.Text));
GridView GridView1 = new GridView();
GridView1.AllowPaging = false;
GridView1.ShowHeaderWhenEmpty = true;
GridView1.DataSource = aDataTable;
GridView1.DataBind();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=AllHistoryOfAPatient.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter aStringWriter = new StringWriter();
HtmlTextWriter aHtmlTextWriter = new HtmlTextWriter(aStringWriter);
GridView1.RenderControl(aHtmlTextWriter);
StringReader aStringReader = new StringReader(aStringWriter.ToString());
Document pdfDocument = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
HTMLWorker aHtmlWorker = new HTMLWorker(pdfDocument);
PdfWriter.GetInstance(pdfDocument, Response.OutputStream);
pdfDocument.Open();
aHtmlWorker.Parse(aStringReader);
pdfDocument.Close();
Response.Write(pdfDocument);
Response.End();
}
public ActionResult ExportToExcel()
{
try
{
list = (List<NhanVien>)TempData["list"];
if (list != null)
{
GridView gv = new GridView();
gv.DataSource = list;
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=DanhSachNhanVienVeHuu.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gv.RenderControl(htw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
else
{
return Content("<script language='javascript' type='text/javascript'>alert('Không thể xuất file excel');");
}
return RedirectToAction("VeHuu");
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// GridView导出到Excel
/// </summary>
/// <param name="gvBindData"></param>
/// <param name="strExcelName">文件名</param>
/// <param name="strCharset">编码类型</param>
/// <param name="page">默认当前页面</param>
public static void GridViewToExcel(GridView gvBindData, string strExcelName = "GridView", string strCharset = "GB2312", Page page = null)
{
gvBindData.AllowPaging = false;
gvBindData.DataBind();
for (int i = 0; i < gvBindData.Columns.Count; i++)
{
if (gvBindData.Columns[i].FooterText.IndexOf("Delete") >= 0)
{
gvBindData.Columns[i].Visible = false;
}
}
if (page == null)
{
page = ((Page)HttpContext.Current.Handler);
}
page.Response.Clear();
page.Response.Buffer = false;
page.Response.Charset = strCharset;
page.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(strExcelName, Encoding.UTF8) + ".xls");
page.Response.ContentEncoding = Encoding.GetEncoding(strCharset);
page.Response.ContentType = "application/ms-excel";
StringWriter oStringWriter = new StringWriter();
HtmlTextWriter writer = new HtmlTextWriter(oStringWriter);
gvBindData.RenderControl(writer);
page.Response.Write(oStringWriter.ToString());
page.Response.End();
gvBindData.AllowPaging = true;
}
/// <summary>
/// 将GridView数据导出Excel
/// </summary>
/// <param name="obj"></param>
public void ExportData(GridView obj)
{
try
{
string style = "";
if (obj.Rows.Count > 0)
{
style = @"<style> .text { mso-number-format:\@; } </script> ";
}
else
{
style = "no data.";
}
HttpContext.Current.Response.ClearContent();
DateTime dt = DateTime.Now;
string filename = dt.Year.ToString() + dt.Month.ToString() + dt.Day.ToString() + dt.Hour.ToString() + dt.Minute.ToString() + dt.Second.ToString();
HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename=ExportData" + filename + ".xls");
HttpContext.Current.Response.ContentType = "application/ms-excel";
HttpContext.Current.Response.Charset = "GB2312";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
obj.RenderControl(htw);
HttpContext.Current.Response.Write(style);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
catch
{
}
}
/// <summary>
/// 描述：把DataTable内容导出excel并返回客户端
/// 作者：李伟波
/// 时间：2012-10-18
/// </summary>
/// <param name="dtData"></param>
/// <param name="header"></param>
/// <param name="fileName"></param>
/// <param name="mergeCellNums">要合并的列索引字典 格式：列索引-合并模式(合并模式 1 合并相同项、2 合并空项、3 合并相同项及空项)</param>
/// <param name="mergeKey">作为合并项的标记列索引</param>
public static void DataTable2Excel(System.Data.DataTable dtData, TableCell[] header, string fileName, Dictionary <int, int> mergeCellNums, int?mergeKey)
{
System.Web.UI.WebControls.GridView gvExport = null;
// 当前对话
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
// IO用于导出并返回excel文件
System.IO.StringWriter strWriter = null;
System.Web.UI.HtmlTextWriter htmlWriter = null;
if (dtData != null)
{
// 设置编码和附件格式
curContext.Response.ContentType = "application/vnd.ms-excel";
curContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
curContext.Response.Charset = "gb2312";
if (!string.IsNullOrEmpty(fileName))
{
//处理中文名乱码问题
fileName = System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8);
curContext.Response.AppendHeader("Content-Disposition", ("attachment;filename=" + (fileName.ToLower().EndsWith(".xls") ? fileName : fileName + ".xls")));
}
// 导出excel文件
strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
// 重新定义一个无分页的GridView
gvExport = new System.Web.UI.WebControls.GridView();
gvExport.DataSource = dtData.DefaultView;
gvExport.AllowPaging = false;
//优化导出数据显示，如身份证、12-1等显示异常问题
gvExport.RowDataBound += new System.Web.UI.WebControls.GridViewRowEventHandler(dgExport_RowDataBound);
gvExport.DataBind();
//处理表头
if (header != null && header.Length > 0)
{
if (gvExport.HeaderRow == null)
{
return;
}
gvExport.HeaderRow.Cells.Clear();
gvExport.HeaderRow.Cells.AddRange(header);
}
//合并单元格
if (mergeCellNums != null && mergeCellNums.Count > 0)
{
foreach (int cellNum in mergeCellNums.Keys)
{
MergeRows(gvExport, cellNum, mergeCellNums[cellNum], mergeKey);
}
}
// 返回客户端
gvExport.RenderControl(htmlWriter);
curContext.Response.Clear();
curContext.Response.Write("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=gb2312\"/>" + strWriter.ToString());
curContext.Response.End();
}
}
public string GetGridViewData(GridView gv)
{
StringBuilder strbuild = new StringBuilder();
StringWriter strwrite = new StringWriter(strbuild);
HtmlTextWriter html = new HtmlTextWriter(strwrite);
gv.RenderControl(html);
return strbuild.ToString();
}
private string GridViewToHtml(GridView gv)
{
StringBuilder sb = new StringBuilder();
StringWriter sw = new StringWriter(sb);
HtmlTextWriter hw = new HtmlTextWriter(sw);
gv.RenderControl(hw);
return sb.ToString();
}
private StringWriter GetDataFormated()
{
var stringWriter = new StringWriter();
var htmlWrite = new HtmlTextWriter(stringWriter);
var dataGrid = new GridView { DataSource = GetDataTable() };
dataGrid.DataBind();
dataGrid.RenderControl(htmlWrite);
return stringWriter;
}
public ActionResult Export()
{
DataTable dt = ToDataTable(db.EmployeeMsts.ToList());
if (dt.Rows.Count > 0)
{
DataSet ds = new DataSet();
ds.Tables.Add(dt);
ds.Tables[0].Columns.Remove("EmployeeID");
ds.Tables[0].Columns.Remove("Image");
System.Web.UI.WebControls.GridView gv = new System.Web.UI.WebControls.GridView();
gv.DataSource = ds;
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=outage_manager.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gv.HeaderRow.Style.Add("background-color", "#92D050");
Table table = new Table();
TableRow title = new TableRow();
title.BackColor = Color.Gray;
TableCell titlecell = new TableCell();
titlecell.ColumnSpan = 9;//Should span across all columns
titlecell.HorizontalAlign = HorizontalAlign.Left;
titlecell.RowSpan = 2;
Label lbl = new Label();
lbl.Text = "Employee Details";
lbl.Style.Add("font-size", "medium");
lbl.Style.Add("font-family", "Arial");
lbl.Style.Add("font-weight", "bold");
titlecell.Controls.Add(lbl);
title.Cells.Add(titlecell);
table.Rows.Add(title);
table.RenderControl(htw);
gv.RenderControl(htw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
return(RedirectToAction("Index"));
}
public static void ExportGridView(GridView gridView, string fileName, ExportType exportType)
{
const string m_Http_Attachment = "attachment;filename=";
const string m_Http_Content = "content-disposition";
HttpResponse m_Response = HttpContext.Current.Response;
m_Response.Clear();
m_Response.ClearContent();
m_Response.ClearHeaders();
m_Response.Buffer = true;
m_Response.AddHeader(m_Http_Content, m_Http_Attachment + fileName);
m_Response.ContentEncoding = Encoding.UTF8;
m_Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter m_StringWriter = new StringWriter();
HtmlTextWriter m_HtmlWriter = new HtmlTextWriter(m_StringWriter);
gridView.AllowPaging = false;
gridView.HeaderStyle.Font.Bold = true;
gridView.DataBind();
ClearControls(gridView);
try
{
gridView.RenderControl(m_HtmlWriter);
}
catch (Exception ex) { ex.ToString(); }
string m_gridViewText = m_StringWriter.ToString();
switch (exportType)
{
case ExportType.Excel:
ExportHelper.ExportToExcelWord(m_gridViewText, "application/vnd.ms-excel", m_Response);
break;
case ExportType.CSV:
ExportHelper.ExportToCsv(m_gridViewText, "application/csv", m_Response);
break;
case ExportType.Word:
ExportHelper.ExportToExcelWord(m_gridViewText, "application/vnd.ms-word", m_Response);
break;
default:
ExportHelper.ExportToExcelWord(m_gridViewText, "application/vnd.ms-excel", m_Response);
break;
}
}
public void Excel() {
var grid = new GridView();
grid.DataSource = adminOrchestrator.AllAppData();
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;filename=SlpApplications.xls");
Response.ContentType = "text/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htmlTextWriter = new HtmlTextWriter(sw);
grid.RenderControl(htmlTextWriter);
Response.Write(sw.ToString());
Response.End();
}
/// <summary>
/// 把DataTable内容导出Excel并返回客户端
/// </summary>
/// <param name="dtData">DataTable</param>
/// <param name="strName">自定义DataTable列名数组(把数据库表字段名转换为用户实际需要的字段名)</param>
/// <param name="strCaption">导出XLS文件头部标题(根据需要自定义)</param>
/// <param name="strFileName">导出XLS文件名(不包含后缀名)</param>
public static void DataToExcel(DataTable dtData, string[] strName, string strCaption, string strFileName)
{
System.Web.UI.WebControls.GridView dgExport = null;
// 当前对话
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
// IO用于导出并返回excel文件
System.IO.StringWriter strWriter = null;
System.Web.UI.HtmlTextWriter htmlWriter = null;
if (dtData != null)
{
string attachment = "attachment; filename=" + System.Web.HttpUtility.UrlEncode(strFileName, System.Text.Encoding.UTF8) + ".xls";
// 设置编码和附件格式
HttpResponse Response = HttpContext.Current.Response;
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
//Response.ContentType = "application/ms-excel";
Response.ContentType = "application/vnd.ms-excel";
Response.ContentEncoding = System.Text.Encoding.UTF7;
Response.Charset = "";
// 导出excel文件
strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
// 为了解决dgData中可能进行了分页的情况，需要重新定义一个无分页的DataGrid
dgExport = new System.Web.UI.WebControls.GridView();
dgExport.Caption = strCaption;
dgExport.RowStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Left;
dgExport.HeaderStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Left;
dgExport.HeaderStyle.Font.Bold = false;
dgExport.DataSource = dtData.DefaultView;
if (strName.Length > 0)
{
int i;
for (i = 0; i < strName.Length; i++)
{
dtData.Columns[i].ColumnName = strName[i];
}
}
dgExport.AllowPaging = false;
dgExport.DataBind();
// 返回客户端
dgExport.RenderControl(htmlWriter);
curContext.Response.Write(strWriter.ToString());
curContext.Response.End();
}
}
public ActionResult ExportToExcel(DateTime? fromDate, DateTime? toDate)
{
var db = DAL.DbContext.Create();
GridView gv = new GridView();
ExportToExcelData exportToExcelData = new ExportToExcelData();
var confromDate = Convert.ToDateTime(fromDate);
var contoDate = Convert.ToDateTime(toDate);
var addToDate = contoDate.AddDays(1);
var taplogs = db.SelectStudentsDateTap(confromDate, addToDate);
List<ExportToExcel> list = new List<ExportToExcel>();
foreach (var taplog in taplogs)
{
taplog.Student = db.Students.Get(taplog.StudentID);
taplog.Student.Course = db.Courses.Get(taplog.Student.CourseID);
list.Add(new ExportToExcel
{
DateTimeTap = taplog.DateTimeTap,
StudentID = taplog.Student.StudentID,
LastName = taplog.Student.LastName,
FirstName = taplog.Student.FirstName,
CourseAbbv = taplog.Student.Course.CourseAbbv
});
}
gv.DataSource = list.ToList();
gv.DataBind();
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/ms-excel";
Response.AddHeader("content-disposition", "attachment;filename=StudentTapLogList.xls");
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gv.RenderControl(htw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
return RedirectToAction("Index");
//return View(list.ToList());
}
public static void ExportExcelFromGridView(System.Web.UI.WebControls.GridView gv)
{
string filename = HttpUtility.UrlEncode("IA" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls", System.Text.Encoding.GetEncoding("utf-8"));
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Write("<meta http-equiv=\"content-type\" content=\"text/html;charset=utf-8\">");
HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + filename);
HttpContext.Current.Response.Charset = "utf-8";
HttpContext.Current.Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite);
gv.RenderControl(htmlWrite);
HttpContext.Current.Response.Write(stringWrite.ToString());
HttpContext.Current.Response.End();
}
public void ToExcel(HttpResponseBase Response, object clientsList)
{
var grid = new System.Web.UI.WebControls.GridView();
grid.DataSource = clientsList;
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=FileName.xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
/// <summary>
/// 返回传入的excel是不是正确的时刻表格式
/// </summary>
/// <param name="absFileName">绝对路径文件名</param>
/// <param name="htmStr">返回的HTML字符串用于生成Excel</param>
/// <param name="excelDt">返回的DataTable 用于处理数据源</param>
public static bool IsExcelFormatRight(string absFileName, out string htmStr, out DataTable excelDt)
{
// 时刻表
DataTable timedataTable = new DataTable();
// 用于输出的控件
System.Web.UI.WebControls.GridView GridView1 = new System.Web.UI.WebControls.GridView();
bool returnvalue = true;
//把excel转成DataTable
timedataTable = ExcelOperate.Import(absFileName);
GridView1.DataSource = timedataTable;
GridView1.DataBind();
//开始创建用于输出的对像
System.IO.StringWriter sW = new System.IO.StringWriter();
Html32TextWriter hW = new Html32TextWriter(sW);
//看看是不是正确的格式
foreach (GridViewRow row in GridView1.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
for (int i = 0; i < row.Cells.Count; i++)
{
if (i != 3 && i != 0)//3为地点
{
try
{
row.Cells[i].Text = DateTime.Parse(row.Cells[i].Text).ToString("HH:mm");
}
catch
{
row.Cells[i].Attributes.Add("style", "background:#ff0000;");
row.Attributes["title"] = "输入时间格式不正确";
returnvalue = false;
}
}
}
}
}
GridView1.RenderControl(hW);
//输出参数
htmStr = sW.ToString();
excelDt = timedataTable;
return(returnvalue);
}
public ActionResult _ExporttoExcel()
{
var user = userDb.GetAllUser().ToList();
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("User Id"));
dt.Columns.Add(new DataColumn("User Name"));
dt.Columns.Add(new DataColumn("Email"));
dt.Columns.Add(new DataColumn("Role Description"));
dt.Columns.Add(new DataColumn("Is Active"));
//dt.Columns.Add(new DataColumn(""));
//dt.Columns.Add(new DataColumn(" "));
//dt.Columns.Add(new DataColumn(""));
//dt.Columns.Add(new DataColumn(""));
foreach (var e in user)
{
DataRow dr_final1 = dt.NewRow();
dr_final1["User Id"] = e.Id;
dr_final1["User Name"] = e.UserName;
dr_final1["Email"] = e.Email;
dr_final1["Role Description"] = e.Name;
//dr_final1[""] = e.;
//dr_final1[""] = e.;
//dr_final1[" "] = e.;
//dr_final1[""] = e.;
dr_final1["Is Active"] = e.IsActive;
dt.Rows.Add(dr_final1);
}
System.Web.UI.WebControls.GridView gridvw = new System.Web.UI.WebControls.GridView();
gridvw.DataSource = dt; //bind the datatable to the gridview
gridvw.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=UserList.xls"); //Microsoft Office Excel Worksheet (.xlsx)
Response.ContentType = "application/ms-excel"; //"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gridvw.RenderControl(htw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
return(RedirectToAction("Index", "User"));
}
public void ExportDataToCSV(System.Data.DataTable dt, string FileName, int[] indexs)
{
if (dt == null)
{
return;
}
if (dt.Rows.Count == 0)
{
return;
}
try
{
System.Web.UI.WebControls.GridView dgExport = new System.Web.UI.WebControls.GridView();
dgExport.AllowPaging = false;
//dgExport.CellPadding = 2;
//dgExport.RowDataBound += new GridViewRowEventHandler(dgExport_RowDataBound);
dgExport.DataSource = dt;
dgExport.DataMember = dt.TableName;
dgExport.DataBind();
System.Web.HttpContext.Current.Response.Clear();
System.Web.HttpContext.Current.Response.Buffer = true;
System.Web.HttpContext.Current.Response.ContentEncoding = Encoding.GetEncoding("gb2312");
System.Web.HttpContext.Current.Response.Charset = "";
//System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + strFileName);
System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName + ".csv"));
string strText = "";
string strRowDelim = System.Environment.NewLine;
string strColDelim = ",";
System.Web.HttpContext.Current.Response.ContentType = "text/txt";
// System.Web.HttpContext.Current.Response.ContentType = "application/unkown";
System.Web.HttpContext.Current.Response.ContentEncoding = Encoding.GetEncoding("gb2312");
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
//System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
dgExport.RenderControl(oHtmlTextWriter);
strText = oStringWriter.ToString();
strText = ParseToDelim(strText, strRowDelim, strColDelim);
System.Web.HttpContext.Current.Response.Write(strText);
System.Web.HttpContext.Current.Response.End();
}
catch (Exception ex)
{
throw ex;
}
}
// GET: ExportData
public void ExportData()
{
var data = new GridView();
data.DataSource = db.getListKhoHang();
data.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=Marklist.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
data.RenderControl(htw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
public void ExportGridViewToExcel(GridView grid, string fileName, HttpResponse Hresponse)
{
Hresponse.Clear();
Hresponse.Buffer = true;
Hresponse.AddHeader("content-disposition", "attachment;fileName=" + fileName + ".xls");
Hresponse.Charset = "";
Hresponse.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
grid.RenderControl(hw);
Hresponse.Output.Write(sw.ToString());
Hresponse.Flush();
Hresponse.Close();
//Hresponse.End();
Hresponse.OutputStream.Close();
}
/// <summary>
/// 导出到Excel文件
/// </summary>
/// <param name="gv"></param>
/// <param name="fileName"></param>
public static void ExportToExcel(System.Web.UI.WebControls.GridView gv, string fileName)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Buffer = true;
HttpContext.Current.Response.Charset = "GB2312";
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8) + ".xls");
// 如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码！！！
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;
HttpContext.Current.Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
gv.RenderControl(oHtmlTextWriter);
HttpContext.Current.Response.Output.Write(oStringWriter.ToString());
HttpContext.Current.Response.Flush();
HttpContext.Current.Response.End();
}
protected void ExportListFromGridView(object sender, EventArgs e)
{
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;filename=Info Proyectos Grupos.xls");
Response.AddHeader("Content-Type", "application/vnd.ms-excel");
using (System.IO.StringWriter sw = new System.IO.StringWriter())
{
using (System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw))
{
System.Web.UI.WebControls.GridView grid = new System.Web.UI.WebControls.GridView();
grid.DataSource = dt.consultarProyec();
grid.DataBind();
grid.RenderControl(htw);
Response.Write(sw.ToString());
}
}
Response.End();
}
public void ProcessRequest(HttpContext context)
{
string tabData = context.Request["excelData"];
DataTable dt = ConvertCsvData(tabData);
if (dt == null)
{
// Add some error-catching here...
return;
}
//MS Word Code
//Create a dummy GridView
GridView GridView1 = new GridView();
GridView1.AllowPaging = false;
GridView1.DataSource = dt;
GridView1.DataBind();
System.Web.HttpContext.Current.Response.Clear();
System.Web.HttpContext.Current.Response.Buffer = true;
System.Web.HttpContext.Current.Response.AddHeader("content-disposition",
"attachment;filename=DataTable.doc");
System.Web.HttpContext.Current.Response.Charset = "";
System.Web.HttpContext.Current.Response.ContentType = "application/vnd.ms-word ";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView1.RenderControl(hw);
System.Web.HttpContext.Current.Response.Output.Write(sw.ToString());
System.Web.HttpContext.Current.Response.Flush();
System.Web.HttpContext.Current.Response.End();
//End of Word Code
// ************************************************ //
/*
string excelFilename = context.Request["filename"];
if (File.Exists(excelFilename))
File.Delete(excelFilename);
CreateExcelFile.CreateExcelDocument(dt, excelFilename, context.Response);*/
}
public void ProcessRequest(HttpContext context)
{
string file = context.Request.QueryString["file"];
string[] filename = file.Split('.');
int len = filename.Length;
string name= string.Empty;
for (int i = 0; i < len-1; i++)
{
name += filename[i];
name += ".";
}
int id = Convert.ToInt32(context.Request.QueryString["id"]);
obj.FileId = id;
obj.UserId = Convert.ToInt32(context.Session["userId"]);
//Get the data from database into datatable
string strQuery = "select Name,City,Address,Designation from Excel where fileid= " + id + " ";
SqlCommand cmd = new SqlCommand(strQuery);
DataTable dt = GetData(cmd);
//Create a dummy GridView
GridView GridView1 = new GridView();
GridView1.AllowPaging = false;
GridView1.DataSource = dt;
GridView1.DataBind();
obj.Downlaod_File(obj);
context.Response.ContentType = "application/pdf";
context.Response.AddHeader("content-disposition", "attachment;filename=" + name + "pdf");
// context.Response.TransmitFile(filePath);
context.Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView1.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, context.Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
context.Response.Write(pdfDoc);
context.Response.End();
}
public ActionResult ExportData()
{
GridView gv = new GridView();
gv.DataSource = db.tbl_LoginAudit.OrderByDescending(l => l.LoginTime).ToList();
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=AdminLog-" + DateTime.Now.ToShortDateString() +".xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gv.RenderControl(htw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
return RedirectToAction("Index");
}
public void ExportContrat()
{
var grid = new GridView();
var inv = BissInventaireEntities.Instance.Contrat.ToList();
grid.DataSource = inv;
grid.DataBind();
Response.ClearContent();
String DateExp = DateTime.Now.ToString();
Response.AddHeader("content-disposition", "attachment;filename=InventaireListeContrat_" + DateExp + ".xls");
Response.ContentType = "text/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htmltexxt = new HtmlTextWriter(sw);
grid.RenderControl(htmltexxt);
Response.Write(sw.ToString());
Response.End();
}
protected void btn_word_Click(object sender, ImageClickEventArgs e)
{
IGTMAIN.cmdtext = IGTMAIN.cmdtextlp;
IGTMAIN.GetDataLP();
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=" + IGTMAIN.filename + ".doc");
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.word";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite);
System.Web.UI.WebControls.GridView dg = new System.Web.UI.WebControls.GridView();
dg.Caption = IGTMAIN.Title;
dg.DataSource = IGTMAIN.dtlp;
dg.DataBind();
dg.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
protected void Button1_Click(object sender, EventArgs e)
{
var stringWriter = new StringWriter();
var htmlWriter = new HtmlTextWriter(stringWriter);
var gv = new GridView();
gv.HeaderStyle.ForeColor = Color.Black;
gv.HeaderStyle.BackColor = Color.AntiqueWhite;
gv.AlternatingRowStyle.BackColor = Color.GhostWhite;
gv.RowStyle.BackColor = Color.White;
CriarDados(gv);
gv.RenderControl(htmlWriter);
Session["DADOS"] = stringWriter.ToString();
Response.Redirect("~/HandlerExcel.ashx");
}
public void DownloadClawBackExcel(int acid)
{
string exlFilename = string.Empty;
string sConnectionString = string.Empty;
string spName = string.Empty;
string workSheetName = string.Empty;
LoginUserDetails objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails);
sConnectionString = objLoginUserDetails.CompanyDBConnectionString;
SqlConnection con = new SqlConnection(sConnectionString);
SqlCommand cmd = new SqlCommand();
con.Open();
DataTable dt = new DataTable();
spName = "st_rpt_DownloadClawBackReportExcel";
exlFilename = "Claw Back Report.xls";
workSheetName = "Claw Back Report";
cmd = new SqlCommand(spName, con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(dt);
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.Charset = "";
Response.AddHeader("content-disposition", "attachment;filename=" + exlFilename + "");
StringWriter sWriter = new StringWriter();
System.Web.UI.HtmlTextWriter hWriter = new System.Web.UI.HtmlTextWriter(sWriter);
System.Web.UI.WebControls.GridView dtGrid = new System.Web.UI.WebControls.GridView();
dtGrid.DataSource = dt;
dtGrid.DataBind();
dtGrid.RenderControl(hWriter);
Response.Write(@"<style> TD { mso-number-format:\@; } </style>");
Response.Output.Write(sWriter.ToString());
Response.Flush();
Response.End();
}
public static void ExportToExcel(string Filename, GridView gv, HttpResponse response)
{
gv.AllowPaging = false;
gv.DataBind();
response.Clear();
response.AddHeader("content-disposition", "attachment;filename=" + Filename + ".xls");
response.Charset = "";
response.Cache.SetCacheability(HttpCacheability.NoCache);
response.ContentType = "application/vnd.ms-excel";
foreach (GridViewRow row in gv.Rows)
{
PrepareControlForExport(row);
}
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
gv.RenderControl(htmlWrite);
response.Write(stringWrite.ToString());
//response.End();
HttpContext.Current.ApplicationInstance.CompleteRequest();
}
public static void Export(GridView gv, string filename)
{
Prepare(gv);
string attachment = "attachment; filename=" + filename + ".xls";
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.AddHeader("content-disposition", attachment);
HttpContext.Current.Response.ContentType = "application/ms-excel";
HttpContext.Current.Response.Charset = "utf-8";
HttpContext.Current.Response.Write("<html><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/></head><body>");
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
//HtmlForm frm = new HtmlForm();
//gv.Parent.Controls.Add(frm);
//frm.Attributes["runat"] = "server";
//frm.Controls.Add(gv);
//frm.RenderControl(htw);
gv.RenderControl(htw);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.Write("</body></html>");
HttpContext.Current.Response.End();
}
protected void exportBtn_Click(object sender, EventArgs e)
{
try
{
int locationID = int.Parse(locationsList.SelectedValue);
string month = MonthsList.SelectedValue;
string year = yearList.SelectedValue;
if (locationsList.SelectedIndex != 0 && yearList.SelectedIndex != 0)
{
System.Web.UI.WebControls.GridView reportGrid = new System.Web.UI.WebControls.GridView();
reportGrid.DataSource = pdfReportData(locationID, month, year);
reportGrid.DataBind();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=DataTable.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
reportGrid.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();
}
else
{
msg.Text = "Please specify all the required report's details.";
}
}
catch (Exception ex)
{
msg.Text = "There was something wrong." + ex.Message;
}
}
public void ToExcel(HttpResponseBase Response, object clientsList, string fileName)
{
try
{
var grid = new System.Web.UI.WebControls.GridView();
grid.DataSource = clientsList;
grid.DataBind();
Response.ClearContent();
//var filename = "MatHang_" + DateTime.Now.ToString("yyyyMMdd")+".xls";
Response.AddHeader("content-disposition", "attachment; filename=" + fileName);
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
catch (Exception ex)
{
Helpers.Config.SaveToLog(ex.ToString());
}
}
/// <summary>
/// 匯出 Excel File
/// http://www.dotnet-tutorial.com/articles/mvc/export-data-in-excel-file-with-asp-net-mvc
/// </summary>
/// <returns></returns>
public ActionResult ExportToExcel()
{
var gv = new System.Web.UI.WebControls.GridView();
gv.DataSource = repo.Get列表所有客戶資料().ToList();
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=DemoExcel.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter objStringWriter = new StringWriter();
HtmlTextWriter objHtmlTextWriter = new HtmlTextWriter(objStringWriter);
gv.RenderControl(objHtmlTextWriter);
Response.Output.Write(objStringWriter.ToString());
Response.Flush();
Response.End();
return(View("Index"));
}
public ActionResult ExportToExcel()
{
var grid = new System.Web.UI.WebControls.GridView();
grid.DataSource = ViewDetails();
grid.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
return(View("Index"));
}
protected void btn_excel_Click(object sender, ImageClickEventArgs e)
{
IGTMAIN.cmdtext = IGTMAIN.cmdtextlp;
IGTMAIN.GetDataLP();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;filename=" + IGTMAIN.filename + ".xls");
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
HtmlForm frm = new HtmlForm();
System.Web.UI.WebControls.GridView dg = new System.Web.UI.WebControls.GridView();
dg.Caption = IGTMAIN.Title;
dg.DataSource = IGTMAIN.dtlp;
dg.DataBind();
dg.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
/// <summary>
/// 将GridView数据导出到Excel表格中。
/// </summary>
/// <param name="gvCtrl">要导出数据的GridView控件。</param>
/// <param name="needToHideColumnIndexes">需要隐藏的GridView的列索引数组</param>
/// <param name="exportTitle">导出标题</param>
/// <param name="fileName">导出文件名</param>
static public void ExportToExcel(System.Web.UI.WebControls.GridView gvCtrl,
int[] needToHideColumnIndexes, string exportTitle, string fileName)
{
if (string.IsNullOrEmpty(exportTitle))
{
exportTitle = Properties.Resources.ExportTitle;
}
if (string.IsNullOrEmpty(fileName))
{
fileName = Properties.Resources.ExportFile;
}
// 记录GridView原始信息。
bool isSorting = gvCtrl.AllowSorting;
int pageIndex = gvCtrl.PageIndex;
int pageSize = gvCtrl.PageSize;
// 设置GridView状态信息。
Dictionary <int, bool> visibleStates = new Dictionary <int, bool>();
for (int i = 0; i < gvCtrl.Columns.Count; i++)
{
DataControlField aCol = gvCtrl.Columns[i];
visibleStates[i] = aCol.Visible;
bool bContains = false;
foreach (int x in needToHideColumnIndexes)
{
if (x == i)
{
bContains = true;
break;
}
}
aCol.Visible = (needToHideColumnIndexes == null || !bContains);
}
//gvCtrl.AllowPaging = false;
gvCtrl.AllowSorting = false;
gvCtrl.PageSize = (gvCtrl.PageSize * gvCtrl.PageCount <= 0 ? 1 : gvCtrl.PageSize * gvCtrl.PageCount);
gvCtrl.PageIndex = 0;
// 绑定GridView。
gvCtrl.DataBind();
// 处理输出流。
System.Web.HttpContext context = System.Web.HttpContext.Current;
context.Response.Clear();
context.Response.AddHeader("content-disposition", "attachment; filename=" + fileName);
context.Response.ContentType = "application/vnd.ms-excel";
context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
context.Response.Charset = "GB2312";
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);
gvCtrl.RenderControl(htw);
context.Response.Write(exportTitle);
context.Response.Write(sw.ToString());
context.Response.End();
// 还原GridView状态信息。
for (int i = 0; i < gvCtrl.Columns.Count; i++)
{
DataControlField aCol = gvCtrl.Columns[i];
aCol.Visible = visibleStates[i];
}
gvCtrl.AllowSorting = isSorting;
gvCtrl.PageSize = pageSize;
gvCtrl.PageIndex = pageIndex;
}
public System.Web.Mvc.ActionResult ExportFullDumpReport(string ResponsibleEmail, string ChapterName, string Owner, string RoleName, string UserName, string TAT)
{
string constr = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
DataTable table = new DataTable();
using (SqlConnection con1 = new SqlConnection(constr))
{
using (SqlCommand cmd1 = new SqlCommand())
{
cmd1.CommandText = "spIssueDetails";
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@Division", ResponsibleEmail);
cmd1.Parameters.AddWithValue("@ResponsibleEmail", ResponsibleEmail);
cmd1.Parameters.AddWithValue("@ChapterName", ChapterName);
cmd1.Parameters.AddWithValue("@Owner", Owner);
cmd1.Parameters.AddWithValue("@RoleName", RoleName);
cmd1.Parameters.AddWithValue("@UserName", UserName);
cmd1.CommandType = CommandType.StoredProcedure;
con1.Open();
cmd1.Connection = con1;
// da.SelectCommand = cmd1;
//da.Fill(dt);
using (var da = new SqlDataAdapter(cmd1))
{
da.Fill(table);
}
// }
for (int c = 0; c < table.Rows.Count - 1; c++)
{
ListQuery <IssueManagementCommentLog> query = new ListQuery <IssueManagementCommentLog>();
query.Parameters = new List <QueryParameter>();
string RequestNo = table.Rows[c]["ID_Request"].ToString();
string ChapterNameNew = table.Rows[c]["ChapterNameFromSystem"].ToString();
string PendingWithEmail = table.Rows[c]["ID_Pending_with_Email"].ToString();
string ResponsibleWithEmail = table.Rows[c]["ID_Responsible_Email"].ToString();
if (ChapterNameNew == "MyPidilite" || ChapterNameNew == "WSS Service Cell")
{
query.Parameters.Add(new QueryParameter()
{
Name = "RequestNo", Value = RequestNo
});
query.Parameters.Add(new QueryParameter()
{
Name = "ChapterName", Value = ChapterNameNew
});
query.Parameters.Add(new QueryParameter()
{
Name = "ID_Responsible_Email", Value = ResponsibleWithEmail
});
}
else
{
query.Parameters.Add(new QueryParameter()
{
Name = "RequestNo", Value = RequestNo
});
query.Parameters.Add(new QueryParameter()
{
Name = "ChapterName", Value = ChapterNameNew
});
query.Parameters.Add(new QueryParameter()
{
Name = "PendingWithEmail", Value = PendingWithEmail
});
}
var data = commentLogService.GetByQuery(query);
if (data.Items.Count > 0)
{
table.Rows[c]["ID_Comments"] = data.Items[0].ID_Comments.ToString();
}
}
}
DataRow[] DR = null;
System.Web.UI.WebControls.GridView gd = new System.Web.UI.WebControls.GridView();
if (ChapterName == "Market_Sudhar" || ChapterName == "Pilworld_WSS_feedback")
{
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
//gd.Columns.Add(new BoundField() { HeaderText = "Location", DataField = "ID_Location" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Pending_with_Email"
});
//gd.Columns.Add(new BoundField() { HeaderText = "PendingSince", DataField = "pendingSince" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Comment", DataField = "ID_Comments"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Anchor Comment", DataField = "AnchorSentBackComments"
});
if (TAT == "Beyond")
{
DR = table.Select("PendingSince>45");
}
else if (TAT == "Within")
{
DR = table.Select("PendingSince<=45");
}
}
else if (ChapterName == "Dealer Feedback")
{
//gd.Columns.Add(new BoundField() { HeaderText = "Request No.", DataField = "ID_Request" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Pending_with_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Comment", DataField = "ID_Comments"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Anchor Comment", DataField = "AnchorSentBackComments"
});
//gd.Columns.Add(new BoundField() { HeaderText = "Action With Timeline", DataField = "ID_Comments" });
if (TAT == "Beyond")
{
DR = table.Select("PendingSince>7");
}
else if (TAT == "Within")
{
DR = table.Select("PendingSince<=7");
}
}
else if (ChapterName == "Customer Service Cell")
{
//gd.Columns.Add(new BoundField() { HeaderText = "Request No.", DataField = "ID_Request" });
//gd.Columns.Add(new BoundField() { HeaderText = "Issue Details", DataField = "ID_Issue_Detail1" });
//gd.Columns.Add(new BoundField() { HeaderText = "PendingWithEmail", DataField = "ID_Pending_with_Email" });
//gd.Columns.Add(new BoundField() { HeaderText = "Action With Timeline", DataField = "ID_Comments" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Pending_with_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Comment", DataField = "ID_Comments"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Anchor Comment", DataField = "AnchorSentBackComments"
});
if (TAT == "Beyond")
{
DR = table.Select("PendingSince>7");
}
else if (TAT == "Within")
{
DR = table.Select("PendingSince<=7");
}
}
else if (ChapterName == "MyPidilite")
{
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
//gd.Columns.Add(new BoundField() { HeaderText = "PendingWithEmail", DataField = "ID_Pending_with_Email" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Responsible_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Latest Comments", DataField = "ID_Comments"
});
if (TAT == "Beyond")
{
DR = table.Select("id_TAT_status='Beyond TAT'");
}
else if (TAT == "Within")
{
DR = table.Select("id_TAT_status='Within TAT'");
}
}
else if (ChapterName == "WSS Service Cell")
{
//gd.Columns.Add(new BoundField() { HeaderText = "Request No.", DataField = "ID_Request" });
//gd.Columns.Add(new BoundField() { HeaderText = "Issue Details", DataField = "ID_Issue_Detail1" });
//gd.Columns.Add(new BoundField() { HeaderText = "Reported By Name", DataField = "ID_Reported_by_name" });
//gd.Columns.Add(new BoundField() { HeaderText = "Location", DataField = "ID_Location" });
//gd.Columns.Add(new BoundField() { HeaderText = "PendingWithEmail", DataField = "ID_Pending_with_Email" });
//gd.Columns.Add(new BoundField() { HeaderText = "ResponsibleWithEmail", DataField = "ID_Responsible_Email" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Responsible_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Comment", DataField = "ID_Comments"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Anchor Comment", DataField = "AnchorSentBackComments"
});
if (TAT == "Beyond")
{
DR = table.Select("id_TAT_status='Beyond TAT'");
}
else if (TAT == "Within")
{
DR = table.Select("id_TAT_status='Within TAT'");
}
}
else if (ChapterName == "Risk_Management")
{
//gd.Columns.Add(new BoundField() { HeaderText = "Request No.", DataField = "ID_Request" });
//gd.Columns.Add(new BoundField() { HeaderText = "Category", DataField = "ID_Category" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Pending_with_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Comment", DataField = "ID_Comments"
});
//gd.Columns.Add(new BoundField() { HeaderText = "Target Date", DataField = "ID_Target_Date" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Anchor Comment", DataField = "AnchorSentBackComments"
});
DR = table.Select("PendingSince>0");
}
else if (ChapterName == "BirthdayLunch" || ChapterName == "Sampark" || ChapterName == "Suggestion_at_Facebook" || ChapterName == "SimplifiedSuggestion")
{
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
//gd.Columns.Add(new BoundField() { HeaderText = "Reported By Name", DataField = "ID_Reported_by_name" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Pending_with_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Comment", DataField = "ID_Comments"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Anchor Comment", DataField = "AnchorSentBackComments"
});
//gd.Columns.Add(new BoundField() { HeaderText = "PendingSince", DataField = "pendingSince" });
DR = table.Select("PendingSince>0");
}
DataTable dtFinal = table.Clone();
foreach (DataRow d in DR)
{
dtFinal.ImportRow(d);
}
gd.DataSource = dtFinal;//table;
gd.AutoGenerateColumns = false;
//gd.Columns.Add(new BoundField() { HeaderText = "Request No.", DataField = "ID_Request" });
//gd.Columns.Add(new BoundField() { HeaderText = "Issue Details", DataField = "ID_Issue_Detail1" });
//gd.Columns.Add(new BoundField() { HeaderText = "Comments", DataField = "ID_Comments" });
////gd.Columns.Add(new BoundField() { HeaderText = "Status", DataField = "ID_status" });
//gd.Columns.Add(new BoundField() { HeaderText = "Reported By Name", DataField = "ID_Reported_by_name" });
//gd.Columns.Add(new BoundField() { HeaderText = "Department", DataField = "ID_Dept" });
//gd.Columns.Add(new BoundField() { HeaderText = "Location", DataField = "ID_Location" });
//gd.Columns.Add(new BoundField() { HeaderText = "PendingWithEmail", DataField = "ID_Pending_with_Email" });
//gd.Columns.Add(new BoundField() { HeaderText = "PendingSince", DataField = "pendingSince" });
//gd.Columns.Add(new BoundField() { HeaderText = "LoggedDate", DataField = "ID_Logged_Date" });
gd.DataBind();
var sb = new System.Text.StringBuilder();
var tw = new System.IO.StringWriter(sb);
var htw = new System.Web.UI.HtmlTextWriter(tw);
gd.RenderControl(htw);
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=IssueDetails.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
Response.Output.Write(sb.ToString());
Response.Flush();
Response.End();
return(RedirectToAction("Full Dump Report"));
con1.Close();
}
}
public System.Web.Mvc.ActionResult ExportFullDumpReportClose(string ChapterName)
{
string constr = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
DataTable table = new DataTable();
using (SqlConnection con1 = new SqlConnection(constr))
{
using (SqlCommand cmd1 = new SqlCommand())
{
cmd1.CommandText = "SpissuedetailsClose";
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@ChapterName", ChapterName);
cmd1.CommandType = CommandType.StoredProcedure;
con1.Open();
cmd1.Connection = con1;
using (var da = new SqlDataAdapter(cmd1))
{
da.Fill(table);
}
//for (int c = 0; c < table.Rows.Count - 1; c++)
//{
// ListQuery<IssueManagementCommentLog> query = new ListQuery<IssueManagementCommentLog>();
// query.Parameters = new List<QueryParameter>();
// string RequestNo = table.Rows[c]["ID_Request"].ToString();
// string ChapterNameNew = table.Rows[c]["ChapterNameFromSystem"].ToString();
// string PendingWithEmail = table.Rows[c]["ID_Pending_with_Email"].ToString();
// query.Parameters.Add(new QueryParameter() { Name = "RequestNo", Value = RequestNo });
// query.Parameters.Add(new QueryParameter() { Name = "ChapterName", Value = ChapterNameNew });
// query.Parameters.Add(new QueryParameter() { Name = "PendingWithEmail", Value = PendingWithEmail });
// var data = commentLogService.GetByQuery(query);
// if (data.Items.Count > 0)
// {
// table.Rows[c]["ID_Comments"] = data.Items[0].ID_Comments.ToString();
// }
//}
}
DataRow[] DR = null;
System.Web.UI.WebControls.GridView gd = new System.Web.UI.WebControls.GridView();
if (ChapterName == "Market_Sudhar" || ChapterName == "Pilworld_WSS_feedback")
{
//gd.Columns.Add(new BoundField() { HeaderText = "Department", DataField = "ID_dept" });
//gd.Columns.Add(new BoundField() { HeaderText = "Location", DataField = "ID_Location" });
//gd.Columns.Add(new BoundField() { HeaderText = "PendingSince", DataField = "pendingSince" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Pending_with_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Last Comments", DataField = "ID_Comments"
});
}
else if (ChapterName == "Dealer Feedback")
{
//gd.Columns.Add(new BoundField() { HeaderText = "Request No.", DataField = "ID_Request" });
//gd.Columns.Add(new BoundField() { HeaderText = "Department", DataField = "ID_dept" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Pending_with_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Last Comments", DataField = "ID_Comments"
});
}
else if (ChapterName == "Customer Service Cell")
{
//gd.Columns.Add(new BoundField() { HeaderText = "Request No.", DataField = "ID_Request" });
//gd.Columns.Add(new BoundField() { HeaderText = "Department", DataField = "ID_dept" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Pending_with_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Last Comments", DataField = "ID_Comments"
});
}
else if (ChapterName == "MyPidilite")
{
//gd.Columns.Add(new BoundField() { HeaderText = "Department", DataField = "ID_dept" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Responsible_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Last Comments", DataField = "ID_Comments"
});
}
else if (ChapterName == "WSS Service Cell")
{
//gd.Columns.Add(new BoundField() { HeaderText = "Request No.", DataField = "ID_Request" });
//gd.Columns.Add(new BoundField() { HeaderText = "Department", DataField = "ID_dept" });
//gd.Columns.Add(new BoundField() { HeaderText = "Reported By Name", DataField = "ID_Reported_by_name" });
//gd.Columns.Add(new BoundField() { HeaderText = "Location", DataField = "ID_Location" });
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Responsible_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Last Comments", DataField = "ID_Comments"
});
}
else if (ChapterName == "Birthday Lunch")
{
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Responsible_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Last Comments", DataField = "ID_Comments"
});
}
else if (ChapterName == "Simplified Suggestion")
{
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Responsible_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Last Comments", DataField = "ID_Comments"
});
}
else if (ChapterName == "Sampark")
{
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Responsible_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Last Comments", DataField = "ID_Comments"
});
}
else if (ChapterName == "Pidilite Ideas Initiatives")
{
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Responsible_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Last Comments", DataField = "ID_Comments"
});
}
else if (ChapterName == "Risk Management")
{
gd.Columns.Add(new BoundField()
{
HeaderText = "Issue Details", DataField = "ID_Issue_Detail1"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Name", DataField = "ID_Responsible_Email"
});
gd.Columns.Add(new BoundField()
{
HeaderText = "Collaborator Last Comments", DataField = "ID_Comments"
});
}
//DataTable dtFinal = table.Clone();
//foreach (DataRow d in DR)
//{
// dtFinal.ImportRow(d);
//}
var col = gd.Columns.Count;
gd.DataSource = table;
gd.AutoGenerateColumns = false;
//gd.Columns.Add(new BoundField() { HeaderText = "Request No.", DataField = "ID_Request" });
//gd.Columns.Add(new BoundField() { HeaderText = "Issue Details", DataField = "ID_Issue_Detail1" });
//gd.Columns.Add(new BoundField() { HeaderText = "Comments", DataField = "ID_Comments" });
////gd.Columns.Add(new BoundField() { HeaderText = "Status", DataField = "ID_status" });
//gd.Columns.Add(new BoundField() { HeaderText = "Reported By Name", DataField = "ID_Reported_by_name" });
//gd.Columns.Add(new BoundField() { HeaderText = "Department", DataField = "ID_Dept" });
//gd.Columns.Add(new BoundField() { HeaderText = "Location", DataField = "ID_Location" });
//gd.Columns.Add(new BoundField() { HeaderText = "PendingWithEmail", DataField = "ID_Pending_with_Email" });
//gd.Columns.Add(new BoundField() { HeaderText = "PendingSince", DataField = "pendingSince" });
//gd.Columns.Add(new BoundField() { HeaderText = "LoggedDate", DataField = "ID_Logged_Date" });
gd.DataBind();
var sb = new System.Text.StringBuilder();
var tw = new System.IO.StringWriter(sb);
var htw = new System.Web.UI.HtmlTextWriter(tw);
gd.RenderControl(htw);
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=IssueDetailsClose.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
Response.Output.Write(sb.ToString());
Response.Flush();
Response.End();
return(RedirectToAction("Full Dump Report"));
con1.Close();
}
}
protected void btn_Export_Click(object sender, EventArgs e)
{
System.Web.UI.WebControls.GridView dg = new System.Web.UI.WebControls.GridView();
/*
* BoundField field1 = new BoundField();
* field1.DataField = "sale_id";
* field1.HeaderText = "销售单号";
* dg.Columns.Add(field1);
*
* BoundField field2 = new BoundField();
* field2.DataField = "good_id";
* field2.HeaderText = "商品编号";
* dg.Columns.Add(field2);
*
* BoundField field3 = new BoundField();
* field3.DataField = "sale_price";
* field3.HeaderText = "销售单价";
* dg.Columns.Add(field3);
*
* BoundField field4 = new BoundField();
* field4.DataField = "purchase_price";
* field4.HeaderText = "采购单价";
* dg.Columns.Add(field4);
*
* BoundField field5 = new BoundField();
* field5.DataField = "purchase_total";
* field5.HeaderText = "成本总价";
* dg.Columns.Add(field5);
*
* BoundField field6 = new BoundField();
* field6.DataField = "sale_num";
* field6.HeaderText = "销售数量";
* dg.Columns.Add(field6);
*
*
* BoundField field7 = new BoundField();
* field7.DataField = "sale_total";
* field7.HeaderText = "销售总价";
* dg.Columns.Add(field7);
*
* BoundField field8 = new BoundField();
* field8.DataField = "sale_profit";
* field8.HeaderText = "利润";
* dg.Columns.Add(field8);
*
* BoundField field9 = new BoundField();
* field9.DataField = "sale_datetime";
* field9.HeaderText = "销售时间";
* dg.Columns.Add(field9);
*
* BoundField field10 = new BoundField();
* field10.DataField = "buyer_bh";
* field10.HeaderText = "采购商编号";
* dg.Columns.Add(field10);
*/
Sale sale = new Sale();
sale.Good_Id = "";
sale.Year_Month = 0;
if (this.txt_Name.Text != "")
{
sale.Good_Id = this.txt_Name.Text;
}
if (this.txt_Yearmonth.Text != "")
{
sale.Year_Month = Convert.ToInt32(this.txt_Yearmonth.Text);
}
SaleProvider provider = new SaleProvider();
DataTable table = provider.Select1(sale, 0, 0);
dg.DataSource = table.DefaultView;
dg.DataBind();
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "attachment;filename=Record.xls");
Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);
dg.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
