用水晶报表导出DOC等文档

 

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace WebApplication1
{
    /**//// <summary>
    /// WebForm2 的摘要说明。
    /// </summary>
    public class WebForm2 : System.Web.UI.Page
    {
        protected System.Data.SqlClient.SqlConnection sqlConn;
        protected System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
        protected System.Data.SqlClient.SqlCommand sqlSelectCommand1;
        protected System.Web.UI.WebControls.Button btnGo;
        protected CrystalDecisions.Web.CrystalReportViewer cryViewPubs;

        private CryAuthors oRpt = null;
        private CrystalDecisions.Shared.DiskFileDestinationOptions DiskOpts; 
    
        private void Page_Load(object sender, System.EventArgs e)
        {
            // 在此处放置用户代码以初始化页面
            //实例化架构
            DSYoyo ds = new DSYoyo();
            sqlDataAdapter1.Fill(ds);
            //实例化报表
            oRpt = new CryAuthors();
            oRpt.SetDataSource(ds);
            //设置报表viewer源
            cryViewPubs.ReportSource = oRpt;
            
        }

        Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
            //
            InitializeComponent();
            base.OnInit(e);
        }
        
        /**//// <summary>
        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
        /// 此方法的内容。
        /// </summary>
        private void InitializeComponent()
        {    
            this.sqlConn = new System.Data.SqlClient.SqlConnection();
            this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
            this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
            // 
            // sqlConn
            // 
            this.sqlConn.ConnectionString = "workstation id=YEKD;packet size=4096;integrated security=SSPI;data source=".";per" +
                "sist security info=False;initial catalog=pubs";
            // 
            // sqlDataAdapter1
            // 
            this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
            this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                      new System.Data.Common.DataTableMapping("Table", "authors", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                                 new System.Data.Common.DataColumnMapping("au_id", "au_id"),
                                                                                                                                                                                                                 new System.Data.Common.DataColumnMapping("au_lname", "au_lname"),
                                                                                                                                                                                                                 new System.Data.Common.DataColumnMapping("au_fname", "au_fname")})});
            // 
            // sqlSelectCommand1
            // 
            this.sqlSelectCommand1.CommandText = "SELECT au_id, au_lname, au_fname FROM authors";
            this.sqlSelectCommand1.Connection = this.sqlConn;
            this.btnGo.Click += new System.EventHandler(this.btnGo_Click);
            this.Load += new System.EventHandler(this.Page_Load);

        }
        #endregion

        private void btnGo_Click(object sender, System.EventArgs e)
        {
            fileCreat("doc");
        }
        public void fileCreat(string cFileType)
        {
            switch (cFileType)
            {
                case "pdf":
                    //pdf文件格式
                    DiskOpts = new CrystalDecisions.Shared.DiskFileDestinationOptions();
                    oRpt.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
                    oRpt.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
                    DiskOpts.DiskFileName = Server.MapPath("\WebApplication1\Output.pdf"); //将导出文件写入web目录，必须为WebApplication1文件夹设置asp.net的完全控制权限
                    oRpt.ExportOptions.DestinationOptions = DiskOpts;
                    oRpt.Export(); //文件导出
                    Session["fileTypeFlag"] = "1";
                    //LinkButton1_Click(this, new EventArgs()); //触发//LinkButton1_Click事件

                    break;
                case "doc":
                    //Word文件格式
                    DiskOpts = new CrystalDecisions.Shared.DiskFileDestinationOptions();
                    oRpt.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;

                    oRpt.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.WordForWindows;

                    DiskOpts.DiskFileName = Server.MapPath("\WebApplication1\Output.doc");

                    oRpt.ExportOptions.DestinationOptions = DiskOpts;

                    oRpt.Export();

                    Session["fileTypeFlag"] = "2";

                    //LinkButton1_Click(this, new EventArgs());

                    break;
                case "excel":
                    //Excel文件格式
                    DiskOpts = new CrystalDecisions.Shared.DiskFileDestinationOptions();
                    oRpt.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;

                    oRpt.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.Excel;

                    DiskOpts.DiskFileName = Server.MapPath("\WebApplication1\Output.xls");

                    oRpt.ExportOptions.DestinationOptions = DiskOpts;

                    oRpt.Export();

                    Session["fileTypeFlag"] = "3";

                    //LinkButton1_Click(this, new EventArgs());
                    break;
            }

        }
    }
}