using System;
using System.Data;
using System.Web;
using System.Text;
using System.IO;namespace GZPI.Service.AgenciesChannel
{
    /// <summary>
    /// ExportData 的摘要说明。
    /// </summary>
    public class ExportData
    {
        public ExportData()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="dt"></param>
        /// <param name="strFileName">含.xls</param>
        public static void ExportDataToExcel(DataTable dt, string FileName)
        {
            try
            {
                StringWriter sw = new StringWriter();
                string colstr = "";
                foreach (DataColumn col in dt.Columns)
                {
                    colstr +=col.ColumnName + "\t";
                }
                sw.WriteLine(colstr);foreach (DataRow row in dt.Rows)
                {
                    colstr = "";
                    foreach (DataColumn col in dt.Columns)
                    {
                        colstr +=row[col.ColumnName].ToString() + "\t";
                    }
                    sw.WriteLine(colstr);
                }
                sw.Close();
                HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName+ ".xls", System.Text.Encoding.UTF8));
                HttpContext.Current.Response.ContentType = "application/ms-excel";    
                System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;
                System.Web.HttpContext.Current.Response.Write(sw);
                System.Web.HttpContext.Current.Response.End();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }public static void ExportDataToExcelByWeb(DataTable dt,System.Web.UI.WebControls.DataGrid DGOutPut,string FileName)
        {
            try
            {
                DGOutPut.Visible=true;
                DGOutPut.DataSource=dt;
                DGOutPut.DataBind();
                System.Web.HttpContext.Current.Response.Clear();
                System.Web.HttpContext.Current.Response.Buffer = true;
                System.Web.HttpContext.Current.Response.Charset = "GB2312";
                System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename="+FileName+".xls");
                System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文
                System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。 
                DGOutPut.EnableViewState = false;
                System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
                System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
                System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
                DGOutPut.RenderControl(oHtmlTextWriter);
                System.Web.HttpContext.Current.Response.Write(oStringWriter.ToString());
                System.Web.HttpContext.Current.Response.End();
                DGOutPut.Visible=false;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

    }
}

        private void DGOutPut_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
        {
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                e.Item.Cells[1].Attributes.Add("style", "vnd.ms-excel.numberformat:@");         
            }
        }private void BtnOutPut_Click(object sender, System.EventArgs e)
        {            
            DataTable dt=_da.ExecuteDataTable(sql);               
　　　　　　 GZPI.Service.AgenciesChannel.ExportData.ExportDataToExcelByWeb(dt,DGOutPut,"续办人事代理业务信息");    
        }