1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
| <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="xmlLBM_QC_TakeSampleCheckBillMainList.aspx.cs" Inherits="WebTM.views.基础资料.公用基础资料.xmlLBM_Sc_ProcessExchangeBillList" %>
|
| <!DOCTYPE html>
|
| <html xmlns="http://www.w3.org/1999/xhtml">
| <head runat="server">
| <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
| <title></title>
| <script runat="server">
| protected void Page_Load(object sender, EventArgs e)
| {
| //★特别提示★：
| //不同的数据库应该选用不同的报表XML数据生成类，SQL Server数据库用SqlXMLReportData，Oracle数据库用OracleXMLReportData
| //OledbXMLReportData适合于Access等本地数据库，为了演示方便，这里从Grid++Report的Access例子数据库中获取报表数据
|
| //OledbXMLReportData.GenOneRecordset(this, "select * from Customers order by CustomerID");
| SqlXMLReportData.GenEntireData(this, "select 单据号 as 流转卡编号,产品名称,生产资源,CONVERT(varchar(10),日期,23) as 检测时间,工序流转卡批次号 as 批号 from h_v_QC_TakeSampleCheckBillList where hmainid="+Request.Params["linterid"],"select 1");
| }
| </script>
| </head>
| <body>
| <form id="form1" runat="server">
| <div>
| </div>
| </form>
| </body>
| </html>
|
|
