<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="xmlLBM_QK_PackingBillList.aspx.cs" Inherits="WebTM.views.基础资料.公用基础资料.xmlLBM_QK_PackingBillList" %>
|
|
<!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");
|
var ids = Request.Params["linterid"];
|
var type=Request.Params["typename"].ToString();
|
var idsArray = ids.Split(',');
|
var PrintIds = "";
|
for (int i = 0; i < idsArray.Length; i++)
|
{
|
PrintIds += "'" + idsArray[i] + "',";
|
}
|
PrintIds = PrintIds.Substring(0, PrintIds.Length - 1);
|
|
if (type.Trim()=="墙咔条码")
|
{
|
SqlXMLReportData.GenOneRecordset(this, "select HSourceBillNo 订单号,a.HMaterID,m.HName 物料,m.HModel 型号,a.HQty 数量,a.HBatchNo 批号,a.HRemark 箱号,a.HRemark 场景号 from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID in (" + PrintIds + ")");
|
}
|
else
|
{
|
string sql = string.Format(@"select fo.FBILLNO 销售订单号,fo.F_ZZZZ_TEXT7 联系人,fo.FRECEIVEADDRESS 收货方地址,
|
fmn.FNAME 销售物料名称,fo.F_ZZZZ_TEXT 包装方式,fu.FDATAVALUE 花型,fu1.FDATAVALUE 墙咔缝,a.HQty 数量,a.HRemark 箱号,fo.F_ZZZZ_WBBZ 外包备注
|
from Gy_BarCodeBill a
|
left join Sc_ICMOBillSub b on a.HSourceEntryID=b.HEntryID and a.HSourceInterID = b.HInterID
|
left join AIS20200908101915zs..T_PRD_MOENTRY f1 on b.HERPEntryID=f1.FENTRYID
|
left join AIS20200908101915zs..T_SAL_ORDERENTRY fo1 on f1.FSaleOrderEntryId=fo1.FENTRYID
|
left join AIS20200908101915zs..T_SAL_ORDER fo on fo1.FID=fo.FID
|
left join AIS20200908101915zs..T_BD_MATERIAL_L fmn on fo1.FSUBMATERIALNUMBER=fmn.FMATERIALID
|
LEFT JOIN AIS20200908101915zs..T_BAS_ASSISTANTDATAENTRY_L fu1 on fo1.F_ZZZZ_ASSISTANT1=fu1.FENTRYID
|
LEFT JOIN AIS20200908101915zs..T_BAS_ASSISTANTDATAENTRY_L fu on fo1.F_ZZZZ_ASSISTANT2=fu.FENTRYID
|
where a.HItemID in ("+PrintIds+") order by a.HRemark");
|
SqlXMLReportData.GenOneRecordset(this, sql);
|
}
|
}
|
</script>
|
</head>
|
<body>
|
<form id="form1" runat="server">
|
<div>
|
</div>
|
</form>
|
</body>
|
</html>
|
