| | |
|---|
| | | <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例子数据库中获取报表数据 |
|---|
| | | 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.GenOneRecordset(this, "select * from h_v_Kf_POStockInBillList_K3 where hmainid=1781"); |
|---|
| | | SqlXMLReportData.GenOneRecordset(this, "select * from h_v_SRM_BarCodeBillList where HItemID in(" + Request.Params["linterid"] + ") order by 物料代码"); |
|---|
| | | } |
|---|
| | | //OledbXMLReportData.GenOneRecordset(this, "select * from Customers order by CustomerID"); |
|---|
| | | //SqlXMLReportData.GenOneRecordset(this, "select * from h_v_Kf_POStockInBillList_K3 where hmainid=1781"); |
|---|
| | | //SqlXMLReportData.GenOneRecordset(this, "select * from h_v_SRM_BarCodeBillList where HItemID in(" + Request.Params["linterid"] + ") order by 物料代码"); |
|---|
| | | SqlXMLReportData.GenOneRecordset(this, "select *,'1' as 单价, 0 as 金额 ,0 as 含税单价 ,GETDATE() as 交货日期 ,'古龙' as 业务员,'' as 让步接收,'' as 表头备注 ,getdate() 预计到货日期,'' as 表体备注 from h_v_SRM_BarCodeBillList where HItemID in(" + Request.Params["linterid"] + ") order by 物料代码"); |
|---|
| | | } |
|---|
| | | </script> |
|---|
| | | </head> |
|---|
| | | <body> |
|---|
