<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="xmlSRM_Web_BarCodeBillList.aspx.cs" Inherits="WebSRM.layuiAdmin.std_v1._2._1.src.views.SRM.xmlSRM_Web_BarCodeBillList" %>
|
|
<!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.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>
|
<form id="form1" runat="server">
|
<div>
|
|
</div>
|
</form>
|
</body>
|
</html>
|
