ReportX实例（2）.NET

来源：互联网发布：excel查找多个数据编辑：程序博客网时间：2024/06/05 08:43

本例子下载地址：http://download.csdn.net/source/331785

使用步骤：
1、注册控件ReportX.ocx（本压缩包内不包含ReportX.ocx，如果需要请到http://download.csdn.net/source/275430下载）
2、创建虚拟目录ReportXWeb

代码：
1、main.html
<HTML>
<HEAD>
<SCRIPT language="javascript">

      var xmlhttp;
      function loadXMLDoc(url)
      {
        if (window.XMLHttpRequest)
        {
          xmlhttp=new XMLHttpRequest();
          xmlhttp.onreadystatechange = xmlhttpChange;
          xmlhttp.open("GET", url, true);
          xmlhttp.send(null);
        }
        else if (window.ActiveXObject)
        {
          xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
          if (xmlhttp)
          {
            xmlhttp.onreadystatechange = xmlhttpChange;
            xmlhttp.open("GET", url, true);
            xmlhttp.send();
          }
        }
      }

      function xmlhttpChange()
      {
        if (xmlhttp.readyState==4)
        {
          if (xmlhttp.status==200)
          {
            ReportX1.OpenString(xmlhttp.responseText, false);
          }
          else
          {
          }
        }
      }

      function reportOpen()
      {
        ReportX1.OpenReport(form1.filepath.value);
      }

      function reportSave()
      {
        form1.filevalue.value = ReportX1.SaveString(false);
        form1.submit();
      }

      function printSetup()
      {
        ReportX1.PrintSetup();
      }

      function preview()
      {
        ReportX1.Preview();
      }

      function print()
      {
        ReportX1.Print(true);
      }

    </SCRIPT>
</HEAD>
<BODY>
<OBJECT id=ReportX1 classid=clsid:A5DA6E97-1D4C-4708-B705-84A45716B4DD><PARAM NAME="Visible" VALUE="0"><PARAM NAME="AutoScroll" VALUE="0"><PARAM NAME="AutoSize" VALUE="0"><PARAM NAME="AxBorderStyle" VALUE="1"><PARAM NAME="Caption" VALUE="ReportX"><PARAM NAME="Color" VALUE="16777215"><PARAM NAME="Font" VALUE="宋体"><PARAM NAME="KeyPreview" VALUE="-1"><PARAM NAME="PixelsPerInch" VALUE="96"><PARAM NAME="PrintScale" VALUE="1"><PARAM NAME="Scaled" VALUE="0"><PARAM NAME="DropTarget" VALUE="0"><PARAM NAME="HelpFile" VALUE=""><PARAM NAME="DoubleBuffered" VALUE="0"><PARAM NAME="Enabled" VALUE="-1"><PARAM NAME="Cursor" VALUE="0"><PARAM NAME="HelpType" VALUE="1"><PARAM NAME="HelpKeyword" VALUE=""><PARAM NAME="Saved" VALUE="-1"><PARAM NAME="SeparatorLine" VALUE="0"><PARAM NAME="PoleWidth" VALUE="43"><PARAM NAME="PoleHeight" VALUE="17"><PARAM NAME="ColCount" VALUE="30"><PARAM NAME="RowCount" VALUE="100"><PARAM NAME="LeftCol" VALUE="1"><PARAM NAME="TopRow" VALUE="1"><PARAM NAME="Painted" VALUE="-1"><PARAM NAME="EnterTo" VALUE="1"><PARAM NAME="MoveChart" VALUE="-1"><PARAM NAME="UpdateChart" VALUE="-1"><PARAM NAME="PrinterIndex" VALUE="-1"><PARAM NAME="PaperSize" VALUE="9"><PARAM NAME="PageWidth" VALUE="2100"><PARAM NAME="PageHeight" VALUE="2970"><PARAM NAME="PrintOrientation" VALUE="-1"><PARAM NAME="PrintCopies" VALUE="1"><PARAM NAME="LeftMargin" VALUE="200"><PARAM NAME="TopMargin" VALUE="200"><PARAM NAME="RightMargin" VALUE="200"><PARAM NAME="BottomMargin" VALUE="200"><PARAM NAME="HeaderMargin" VALUE="80"><PARAM NAME="FooterMargin" VALUE="120"><PARAM NAME="PrintBorders" VALUE="-1"><PARAM NAME="PrintBackColor" VALUE="-1"><PARAM NAME="PageFontName" VALUE="宋体"><PARAM NAME="PageFontSize" VALUE="12"><PARAM NAME="PageHeaderText" VALUE=""><PARAM NAME="PageFooterText" VALUE=""><PARAM NAME="LeftColCount" VALUE="0"><PARAM NAME="TopRowCount" VALUE="0"><PARAM NAME="RightColCount" VALUE="0"><PARAM NAME="BottomRowCount" VALUE="0"><PARAM NAME="PrintZoom" VALUE="100"><PARAM NAME="PrintArea" VALUE=""><PARAM NAME="PrintOrder" VALUE="-1"><PARAM NAME="ExecuteScript" VALUE="-1"><PARAM NAME="GridLine" VALUE="-1"><PARAM NAME="PoleReadOnly" VALUE="0"><PARAM NAME="CellReadOnly" VALUE="0"><PARAM NAME="RightWidth" VALUE="16"><PARAM NAME="BottomHeight" VALUE="16"><PARAM NAME="PaperSource" VALUE="256"><PARAM NAME="CellWidth" VALUE="80"><PARAM NAME="CellHeight" VALUE="19"><PARAM NAME="FontName" VALUE="宋体"><PARAM NAME="FontSize" VALUE="12"><PARAM NAME="ConnectionString" VALUE=""><PARAM NAME="QueryFrom" VALUE=""><PARAM NAME="QueryWhere" VALUE=""><PARAM NAME="QueryHaving" VALUE=""><PARAM NAME="ReportType" VALUE="0"><PARAM NAME="GroupType" VALUE="0"><PARAM NAME="GroupPageBreak" VALUE="0"><PARAM NAME="ReportLeft" VALUE="1"><PARAM NAME="ReportTop" VALUE="2"><PARAM NAME="AlternatingColor" VALUE="16777215"><PARAM NAME="ColTotal" VALUE="0"><PARAM NAME="RowTotal" VALUE="0"><PARAM NAME="PoleSelectColor" VALUE="15717318"><PARAM NAME="PoleColor" VALUE="14610415"><PARAM NAME="PoleSeparatorColor" VALUE="10267309"><PARAM NAME="CellSeparatorColor" VALUE="13026246"></OBJECT>
    <FORM id=form1 method="post" Action="WebForm2.aspx">
      <TABLE>
        <TR>
          <TD>
            <input type="button" id="Button5" value="台帐" onclick="loadXMLDoc('WebForm1.aspx?id=1')">
            <input type="button" id="Button6" value="派送单" onclick="loadXMLDoc('WebForm1.aspx?id=2')">
            <input type="button" id="Button7" value="预算计划比较" onclick="loadXMLDoc('WebForm1.aspx?id=3')">
            <input type="button" id="Button8" value="修理费结算单" onclick="loadXMLDoc('WebForm1.aspx?id=4')">
            <input type="button" id="Button9" value="水质在线监测参数显示" onclick="loadXMLDoc('WebForm1.aspx?id=5')">
          </TD>
        </TR>
        <TR>
          <TD>
            <input type="button" id="Button1" value="保存" onclick="reportSave()">
            <input type=hidden name=filevalue id=filevalue>
            <input type="button" id="Button2" value="打印设置" onclick="printSetup()">
            <input type="button" id="Button3" value="打印预览" onclick="preview()">
            <input type="button" id="Button4" value="打印" onclick="print()">
          </TD>
        </TR>
        <TR>
          <TD>文件名称：<input name=filename id=filename >
          </TD>
        <TR>
        </TR>
<TR>
          <TD>文件路径：<input name=filepath id=filepath type=file size=45> <A href="javascript:reportOpen()">打开本地文件</A>
          </TD></TR>
      </TABLE>
    </FORM>
</BODY>
</HTML>

2、WebForm1.aspx只保留
<@ Page language="c#" Codebehind="WebForm1.aspx.cs" AutoEventWireup="false" Inherits="ReportXWeb.WebForm1" %>

3、WebForm1.aspx.cs
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 ReportXWeb
{
/// <summary>
/// WebForm1 的摘要说明。
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
  private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Request.MapPath("db1.mdb") + ";Persist Security Info=False");
   System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter("SELECT filevalue FROM table1 Where id=" + Request.QueryString["id"], conn);
   DataSet ds = new DataSet();
   adapter.Fill(ds);
   byte[] bytesUnicode = (byte[])ds.Tables[0].Rows[0][0];               //Access是Unicode需要转换为ASCII
   byte[] bytesASCII = System.Text.Encoding.Convert(System.Text.Encoding.Unicode, System.Text.Encoding.ASCII, bytesUnicode);
   Response.Write(System.Text.Encoding.Default.GetString(bytesASCII, 0, bytesASCII.Length));
  }

  #region Web 窗体设计器生成的代码
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }

  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {
   this.Load += new System.EventHandler(this.Page_Load);
  }
  #endregion
}
}