ASP.NET导出,打印

最新推荐文章于 2020-12-29 15:06:46 发布

阿伦_01

最新推荐文章于 2020-12-29 15:06:46 发布

阅读量491

点赞数

分类专栏： ASP.ET

ASP.ET 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

************导出GridView数据************

1、页面中添加：

<asp:LinkButton ID="lbtn_Excel" runat="server" OnClick="lbtn_Excel_Click"><img src="../icon/excel.jpg" height="20" align="absmiddle" border="0" />导出</asp:LinkButton>

2、后置代码，lbtn_Excel_Click方法：

    protected void lbtn_Excel_Click(object sender, EventArgs e)
    {
        string FileName = "MateOutList(" + DateTime.Now.ToShortDateString()+"_"          +DateTime.Now.ToShortTimeString() + ").xls";
        //导出Excel
        Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=" + FileName);
        Response.Charset="GB2312";
        Response.ContentType="application/vnd.xls";
        Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");
        System.IO.StringWriter strW=new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlTW=new HtmlTextWriter(strW);
        //GridView去样式
        System.Drawing.Color oldbackcolor = gv_Excel.HeaderStyle.BackColor;
        System.Drawing.Color oldforecolor = gv_Excel.HeaderStyle.ForeColor;

        GridView1.RenderControl(htmlTW);
        Response.Write(strW.ToString());
        Response.End();
    }

3、切记重写 VerifyRenderingInServerForm方法

    public override void VerifyRenderingInServerForm(Control control)
    {
        // Confirms that an HtmlForm control is rendered for
    }

4、如果LinkButton是在UpdatePanel<ContentTemplate></ContentTemplate>之间，切记在触发器中写上去<asp:PostBackTrigger ControlID="lbtn_Excel" />，如：

*************OK，原来导出就是如此简单。

**********打印************

1、页面添加：

<asp:LinkButton ID="lbtn_Print" runat="server" OnClientClick="return PintPage();"><img src="../icon/print.jpg" height="20" align="absmiddle" border="0" />打印</asp:LinkButton>

function PintPage()
{

//指向打印页面
window.showModalDialog('PrintMateOut.aspx?MainID='+ document.getElementById('hid_billid').value+'&SubID='+document.getElementById('hid_sub_id').value,'','dialogHeight:375px;dialogWidth:740px;help:0;');

}

</script>

2、打印页面，后置代码并没什么东西,前台用JavaScript处理了：
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"></meta>

         /*打印函数
         *doType 页面页脚类型 0 设置为空，1 设置为默认
         */
        function PrintTable(doType)   //打印函数
        {
             if(doType == '0')
             {
                PageSetup_Null();
             }
            else
            {
                PageSetup_Default();
             }
             document.getElementById("btn_Print").style.display = "none";
             document.getElementById("btn_NoPrint").style.display = "none";
             window.print();
             document.getElementById("btn_Print").style.display = "";
             document.getElementById("btn_NoPrint").style.display = "";
             window.location.reload();
        }