protected void Button2_Click(object sender, EventArgs e)
{
string zhilingName = this.TxtCode.Text;
MakeFile();
//System.IO.StreamWriter sw = new StreamWriter(@"d:\"+DateTime.Now.Month.ToString()+@"\"+zhilingName+".xls");
//System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
//打印方法
DataTable dt = ZhiDAL.getFreeDetaliPrint(zhilingName, "5");
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
if (dt != null)
{
curContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//改成utf-8
curContext.Response.ContentType = "application/excel";
curContext.Response.ClearContent();
curContext.Response.AddHeader("content-disposition", "attachment; filename=" + zhilingName + "-" + DateTime.Now.ToShortDateString() + ".xls");
//导出excel文件
System.IO.StringWriter sws = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sws);
GridView dg = new GridView();
dg.DataSource = dt.DefaultView;
dg.DataBind();
dg.RenderControl(hw);
dg.Dispose();
curContext.Response.Write(sws.ToString());
try
{
//在指定文件夹下 保存
// DateTime.Now.Month.ToString()
System.IO.StreamWriter sw = new StreamWriter(@"d:\" +DateTime.Now.ToString("yyyy-MM") + @"\" + zhilingName + ".xls");
sw.Write(sws.ToString());
sw.Close();
}
catch (Exception ex)
{
}
//hw = new System.Web.UI.HtmlTextWriter(sws);
curContext.Response.End();
}
}