导出报表CSV,卸载迅雷,使用IE

#region 导出报表 /* private DataTable GetDataTable() { DataTable tblDatas = new DataTable("Datas"); tblDatas.Columns.Add("ID", Type.GetType("System.Int32")); tblDatas.Columns.Add("Product", Type.GetType("System.String")); tblDatas.Columns.Add("Version", Type.GetType("System.String")); tblDatas.Columns.Add("Description", Type.GetType("System.String")); tblDatas.Rows.Add(new object[] { null, "a", "b", "c" }); tblDatas.Rows.Add(new object[] { null, "a", "b", "c" }); tblDatas.Rows.Add(new object[] { null, "a", "b", "c" }); tblDatas.Rows.Add(new object[] { null, "a", "b", "c" }); tblDatas.Rows.Add(new object[] { null, "a", "b", "c" }); return tblDatas; } * */ private DataTable GetDataTable() { ZSql zsql = new ZSql(); string sql = "select Id, Name , (select name from Plant where JobShop.PlantId=Plant.Id) as PlantName,ResponsibleMan,ResponsibleTel from JobShop"; if (!string.IsNullOrEmpty(txtJobShopName.Text)) { sql += " where Name like '" + Common.FormatParameter(txtJobShopName.Text) + "%'"; } zsql.Open(sql); DataTable tblDatas = new DataTable("Datas"); tblDatas.Columns.Add("ID", Type.GetType("System.String")); tblDatas.Columns.Add("PlantName", Type.GetType("System.String")); tblDatas.Columns.Add("Name", Type.GetType("System.String")); tblDatas.Columns.Add("ResponsibleMan", Type.GetType("System.String")); tblDatas.Columns.Add("ResponsibleTel", Type.GetType("System.String")); for (int i = 0; i < zsql.m_table.Rows.Count; i++) { tblDatas.Rows.Add(new object[] {zsql.m_table.Rows[i]["Id"].ToString(), zsql.m_table.Rows[i]["PlantName"].ToString(), zsql.m_table.Rows[i]["Name"].ToString(), zsql.m_table.Rows[i]["ResponsibleMan"].ToString(), zsql.m_table.Rows[i]["ResponsibleTel"].ToString() }); } zsql.Close(); return tblDatas; } public static StringBuilder AppendCSVFields(StringBuilder argSource, string argFields) { return argSource.Append(argFields.Replace(",", " ").Trim()).Append(","); } //导出厂区报表 protected void btnExport_Click(object sender, EventArgs e) { DataTable dt = this.GetDataTable(); HttpContext.Current.Response.Clear(); System.IO.StringWriter swCSV = new System.IO.StringWriter(); //列名 swCSV.WriteLine("编号,厂区,车间(部室)名称,负责人,联系方式"); //遍历datatable导出数据 foreach (DataRow drTemp in dt.Rows) { StringBuilder sbText = new StringBuilder(); sbText = AppendCSVFields(sbText, drTemp["ID"].ToString()); sbText = AppendCSVFields(sbText, drTemp["PlantName"].ToString()); sbText = AppendCSVFields(sbText, drTemp["Name"].ToString()); sbText = AppendCSVFields(sbText, drTemp["ResponsibleMan"].ToString()); sbText = AppendCSVFields(sbText, drTemp["ResponsibleTel"].ToString()); //去掉尾部的逗号 sbText.Remove(sbText.Length - 1, 1); //写datatable的一行 swCSV.WriteLine(sbText.ToString()); } swCSV.Close(); HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + ".csv");//inline,attachment HttpContext.Current.Response.ContentType = "application/ms-excel"; HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); HttpContext.Current.Response.Write(swCSV.GetStringBuilder()); HttpContext.Current.Response.End(); } #endregion