<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="xmlLBM_Sc_ProcessExchangeArrangement.aspx.cs" Inherits="WebTM.views.基础资料.公用基础资料.xmlLBM_Sc_ProcessExchangeArrangement" %>
|
|
<!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例子数据库中获取报表数据
|
SqlXMLReportData.GenOneRecordset(this, @" select a.HICMOBillNo 生产订单号,a.HBillNo 指引卡,a.HMainSourceBillNo 流转卡号,a.HMakeDate 日期,m.HNumber 颜色,m.HName 色号,m.HModel 规格,cu.HName 客户,e.HName 业务员,b.sumCount 只数 ,isnull(HmaterOutqty,0) 重量 ,s.HName 生产资源
|
from Sc_ProcessExchangeBillMain a
|
left join
|
( select HICMOBillNo,count(*) sumCount
|
from Sc_ProcessExchangeBillMain
|
where HBillSubType<>'SUB'
|
group by HICMOBillNo
|
) b on b.HICMOBillNo=a.HICMOBillNo
|
left join(
|
select HInterID,HEntryID,HSourceID from Sc_ProcessExchangeBillSub
|
) sub on sub.HInterID=a.HMainSourceInterID and sub.HEntryID=a.HMainSourceEntryID
|
left join Gy_Source s on sub.HSourceID=s.HItemID
|
left join Gy_Material m on a.HMaterID=m.HItemID
|
left join Gy_Customer cu on a.HCusID=cu.HItemID
|
left join Gy_Employee e on a.HEmpID=e.HItemID
|
left join (
|
select sum(HmaterOutqty) HmaterOutqty,HProcExchBillNo,HProcNo from Sc_StationOutBillMain
|
group by HProcExchBillNo,HProcNo
|
) outc on outc.HProcExchBillNo=a.HMainSourceBillNo and outc.HProcNo='10'
|
where a.HInterID='" + Request.Params["linterid"] + "'");
|
}
|
</script>
|
</head>
|
<body>
|
<form id="form1" runat="server">
|
<div>
|
</div>
|
</form>
|
</body>
|
</html>
|
