default.aspx.cs

这是asp.net^和Visual C++Sharp编写的串并口通讯的书籍 源代码

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            FileDReportDocument();//调用方法加载报表
        }
    }

    public void FileDReportDocument()
    {
        exportTypesList.DataSource = System.Enum.GetValues(typeof(ExportFormatType));
        exportTypesList.DataBind();
        SqlConnection con = new SqlConnection("server=(local);uid=sa;pwd=;database=db_06");
        con.Open();
        SqlDataAdapter da = new SqlDataAdapter("select * from tb_employ", con);
        DataSet ds = new DataSet();
        da.Fill(ds, "tb_worke");
        con.Close();
        ReportDocument hierarchicalGroupingReport = new ReportDocument();
        hierarchicalGroupingReport.Load(Server.MapPath("CrystalReport2.rpt"));//加载报表路径
        hierarchicalGroupingReport.SetDataSource(ds);////加载报表数据源 this.CrystalReportViewer1.ReportSource = hierarchicalGroupingReport;

    }
    public string exportPath;//存储导出报表的文件路径
    public string exportInfo;//存储、提示信息
    public DiskFileDestinationOptions diskFileDestinationOptions;
    public ExportOptions exportOptions;
    public ReportDocument hierarchicalGroupingReport = new ReportDocument();
    public bool selectedNoFormat = false;//判断是否选择导出格式
    private void ExportSetup()
    {
        try
        {
            exportPath = "C:\\Exported\\";
            if (!System.IO.Directory.Exists(exportPath))
            {
                System.IO.Directory.CreateDirectory(exportPath);
            }
            hierarchicalGroupingReport.Load(Server.MapPath("CrystalReport2.rpt"));//加载报表路径
            diskFileDestinationOptions = new DiskFileDestinationOptions();
            exportOptions = hierarchicalGroupingReport.ExportOptions;
            exportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
            exportOptions.FormatOptions = null;
        }
        catch (Exception ee)
        {
            Response.Write(ee.Message.ToString());
        }
    }
    private void ExportSelection()
    {

    }
    //导出.rpt文件（.rpt）
    private void ConfigureExportToRpt()
    {
        exportOptions.ExportFormatType = ExportFormatType.CrystalReport;

        exportInfo = exportPath + "Report.rpt";
        diskFileDestinationOptions.DiskFileName = exportPath + "Report.rpt";
        exportOptions.DestinationOptions = diskFileDestinationOptions;

    }
    //导出.rtf文件（.rtf）
    private void ConfigureExportToRtf()
    {
        exportOptions.ExportFormatType = ExportFormatType.RichText;
        diskFileDestinationOptions.DiskFileName = exportPath + "RichTextFormat.rtf";
        exportOptions.DestinationOptions = diskFileDestinationOptions;
        exportInfo = exportPath + "RichTextFormat.rtf";
    }
    //导出.doc文件（.doc）
    private void ConfigureExportToDoc()
    {
        exportOptions.ExportFormatType = ExportFormatType.WordForWindows;
        diskFileDestinationOptions.DiskFileName = exportPath + "Word.doc";
        exportOptions.DestinationOptions = diskFileDestinationOptions;
        exportInfo = exportPath + "Word.doc";

    }
    //导出.xls文件（.xls）
    private void ConfigureExportToXls()
    {
        exportOptions.ExportFormatType = ExportFormatType.Excel;
        diskFileDestinationOptions.DiskFileName = exportPath + "Excel.xls";
        exportOptions.DestinationOptions = diskFileDestinationOptions;
        exportInfo = exportPath + "Excel.xls";
    }
    //导出.pdf文件（.pdf）
    private void ConfigureExportToPdf()
    {
        exportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
        diskFileDestinationOptions.DiskFileName = exportPath + "PortableDoc.pdf";
        exportOptions.DestinationOptions = diskFileDestinationOptions;
        exportInfo = exportPath + "PortableDoc.pdf";
    }
    //导出.html文件（.html）
    private void ConfigureExportToHtml32()
    {
        exportOptions.ExportFormatType = ExportFormatType.HTML32;
        HTMLFormatOptions html32FormatOptions = new HTMLFormatOptions();
        html32FormatOptions.HTMLBaseFolderName = exportPath + "Html32Folder";
        html32FormatOptions.HTMLFileName = "html32.html";
        html32FormatOptions.HTMLEnableSeparatedPages = false;
        html32FormatOptions.HTMLHasPageNavigator = false;
        exportOptions.FormatOptions = html32FormatOptions;
        exportInfo = exportPath + "Html32Folder";


    }
    //导出html40.html文件（.html）
    private void ConfigureExportToHtml40()
    {
        exportOptions.ExportFormatType = ExportFormatType.HTML40;
        HTMLFormatOptions html40FormatOptions = new HTMLFormatOptions();
        html40FormatOptions.HTMLBaseFolderName = exportPath + "Html40Folder";
        html40FormatOptions.HTMLFileName = "html40.html";
        html40FormatOptions.HTMLEnableSeparatedPages = true;
        html40FormatOptions.HTMLHasPageNavigator = true;
        html40FormatOptions.FirstPageNumber = 1;
        html40FormatOptions.LastPageNumber = 3;
        exportOptions.FormatOptions = html40FormatOptions;
        exportInfo = exportPath + "Html40Folder";


    }
    //    //导出.xls文件（.xls）
    private void ConfigureExportToXlsRec()
    {
        exportOptions.ExportFormatType = ExportFormatType.ExcelRecord;
        diskFileDestinationOptions.DiskFileName = exportPath + "ExcelRecord.xls";
        exportOptions.DestinationOptions = diskFileDestinationOptions;
        exportInfo = exportPath + "ExcelRecord.xls";
    }
    //导出报表
    protected void Button1_Click(object sender, EventArgs e)
    {
        if ((ExportFormatType)exportTypesList.SelectedIndex == ExportFormatType.NoFormat)
        {
            Response.Write("<script>alert('你选择了未指定导出格式选项');</script>");
            FileDReportDocument();//调用方法加载报表
        }
        else
        {
            if ((ExportFormatType)exportTypesList.SelectedIndex == ExportFormatType.HTML32 || (ExportFormatType)exportTypesList.SelectedIndex == ExportFormatType.HTML40)
            {
                Response.Write("<script>alert('ExportToHttpResponse方法不支持定HTML32和HTML40 格式');</script>");
                FileDReportDocument();//调用方法加载报表
            }
            else
            {
                ReportDocument hierarchicalGroupingReport = new ReportDocument();
                hierarchicalGroupingReport.Load(Server.MapPath("CrystalReport2.rpt"));//加载报表路径
                ExportOptions exportOptions = hierarchicalGroupingReport.ExportOptions;
                exportOptions.ExportFormatType = (ExportFormatType)exportTypesList.SelectedIndex;
                hierarchicalGroupingReport.ExportToHttpResponse(exportOptions, Response, false, "ExportedReport");
            }
        }


    }
    protected void CrystalReportViewer1_Init(object sender, EventArgs e)
    {

    }
}