订单表

【订单表】该表使用页面报表,利用页面报表页面分组的功能,更加订单ID进行分组。

<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8" /> <meta http-equiv="X-UA-Compatible" content="IE=edge" /> <title>ActiveReportsJS sample</title> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <link href="https://fonts.googleapis.com/css2?family=Montserrat:ital,wght@0,300;0,400;0,500;0,600;0,700;1,400&display=swap" rel="stylesheet" /> <link rel="stylesheet" href="https://cdn.materialdesignicons.com/2.8.94/css/materialdesignicons.min.css" /> <script src="/activereportsjs/demos/arjs/dist/ie-polyfills.js"></script> <script src="/activereportsjs/demos/arjs/dist/ar-js-core.js"></script> <script src="/activereportsjs/demos/arjs/dist/ar-js-viewer.js"></script> <script src="/activereportsjs/demos/arjs/dist/ar-js-designer.js"></script> <script src="/activereportsjs/demos/arjs/dist/ar-js-pdf.js"></script> <script src="/activereportsjs/demos/arjs/dist/ar-js-html.js"></script> <script src="/activereportsjs/demos/arjs/dist/ar-js-xlsx.js"></script> <script src="/activereportsjs/demos/arjs-localization/dist/ar-js-locales.js"></script> <script src="/activereportsjs/demos/arjs-localization/dist/designer/zh-locale.js"></script> <script src="$DEMOROOT$/lib/purejs/license.js"></script> <link rel="stylesheet" type="text/css" href="/activereportsjs/demos/arjs/styles/ar-js-ui.css" /> <link rel="stylesheet" type="text/css" href="/activereportsjs/demos/arjs/styles/ar-js-viewer.css" /> <link rel="stylesheet" type="text/css" href="/activereportsjs/demos/arjs/styles/ar-js-designer.css" /> <style> #root { height: 100vh; } #viewer-host, #designer-host { height: 100%; } #designer-host { display: none; } </style> </head> <body onload="load()" style="margin: 0"> <div id="root"> <div id="viewer-host"></div> <div id="designer-host"></div> </div> <script> var currentReport = undefined; var viewerHost = document.getElementById("viewer-host"); var designerHost = document.getElementById("designer-host"); function load() { var viewer = new ActiveReports.Viewer("#viewer-host", { language: "zh" }); var designer = new GC.ActiveReports.ReportDesigner.Designer( "#designer-host", { language: "zh" } ); designer.setActionHandlers({ onRender(report) { currentReport = report.definition; viewer.open(currentReport); viewerHost.style.display = "block"; designerHost.style.display = "none"; // return Promise.resolve(); }, }); var designButton = { key: "$openDesigner", text: "编辑报表", iconCssClass: "mdi mdi-pencil", enabled: true, action: function (item) { designer.setReport({ definition: currentReport, displayName: "订单表", }); viewerHost.style.display = "none"; designerHost.style.display = "block"; }, }; viewer.toolbar.addItem(designButton); viewer.toolbar.updateLayout({ default: [ "$openDesigner", "$split", "$navigation", "$split", "$refresh", "$split", "$history", "$split", "$zoom", "$fullscreen", "$split", "$print", "$split", "$singlepagemode", "$continuousmode", "$galleymode", ], }); fetch("dingdanbiao.rdlx-json") .then(function (data) { return data.json(); }) .then(function (report) { currentReport = report; viewer.open(report); }); } </script> </body> </html>
{"Name":"Report","Width":"8.5in","Layers":[{"Name":"default"}],"CustomProperties":[{"Name":"DisplayType","Value":"Page"},{"Name":"SizeType","Value":"Default"},{"Name":"PaperOrientation","Value":"Portrait"}],"Page":{"PageWidth":"8.5in","PageHeight":"11in","RightMargin":"0.25cm","LeftMargin":"0.25cm","TopMargin":"0.25cm","BottomMargin":"0.25cm","Columns":1,"ColumnSpacing":"0in"},"DataSources":[{"Name":"本地测试数据","ConnectionProperties":{"DataProvider":"JSONEMBED","ConnectString":"jsondata={\\n \"code\": 200000,\\n \"message\": null,\\n \"data\": [\\n {\\n \"orderNo\": \"OM21042600000051\",\\n \"sapSubCusName\": \"省直幼儿园(北大)\",\\n \"sapCusName\": \"**省直属机关幼儿园\",\\n \"sapCusCode\": \"100360\",\\n \"merchantName\": \"*辉超市股份有限公司\",\\n \"orderTime\": \"2021-04-26 12:25:45\",\\n \"requireDeliveryTime\": \"2021-04-29 00:00-23:59\",\\n \"preferDcName\": \"福建企业购\",\\n \"receiveUsername\": \"13609533815\",\\n \"receivePhone\": \"13609533815\",\\n \"custCon\": \"**省直属机关幼儿园\",\\n \"conTel\": \"13609533815\",\\n \"contactPerson\": \"托亚135\",\\n \"phone\": \"13552090086\",\\n \"receiveAddr\": \"\",\\n \"pageNum\": \"1\",\\n \"totalNum\": \"1\",\\n \"sum\": \"139.6\",\\n \"sumTraditional\": \"壹佰叁拾玖元陆角\",\\n \"totalSum\": \"139.6\",\\n \"totalSumTraditional\": \"壹佰叁拾玖元陆角\",\\n \"buyerRemarks\": null,\\n \"realTotalPriceWithoutTax\": \"128.07\",\\n \"taxTotalPrice\": \"11.53\",\\n \"realTotalPrice\": \"139.6\",\\n \"orderItems\": [\\n {\\n \"sortNum\": 1,\\n \"productCode\": \"1\",\\n \"productBarcode\": \"2304348000004\",\\n \"productName\": \"花生\",\\n \"productNameWithBuyerRemark\": \"花生\",\\n \"unit\": \"KG\",\\n \"originPrice\": \"13.96\",\\n \"originAmount\": \"139.6\",\\n \"promotionPrice\": \"13.96\",\\n \"sendQty\": \"10\",\\n \"realTotalPrice\": \"139.6\",\\n \"promotionPriceWithoutTax\": \"12.8073\",\\n \"realTotalPriceWithoutTax\": \"128.07\",\\n \"taxRatePercent\": \"9%\",\\n \"buyerRemarks\": \"\",\\n \"taxPrice\": \"11.53\",\\n \"departConfirm\": null,\\n \"wasteRate\": null,\\n \"manufactureFactory\": null,\\n \"manufactureDate\": null,\\n \"expirationDate\": null,\\n \"other\": null,\\n \"specRemarks\": \"\",\\n \"brandName\": null,\\n \"purchaseQty\": \"10\",\\n \"purchaseUnit\": \"KG\",\\n \"discountRate\": \"100\",\\n \"customerProductName\": \"花生\"\\n }\\n ],\\n \"tms\": \"是\",\\n \"externalOrderCode\": \"OM21042600000051\",\\n \"deliverAreaCode\": \"1\",\\n \"originSum\": \"139.6\",\\n \"title\": \"**省直属机关幼儿园\"\\n },\\n {\\n \"orderNo\": \"OM21042600000104\",\\n \"sapSubCusName\": \"省直幼儿园(北大)\",\\n \"sapCusName\": \"**省直属机关幼儿园\",\\n \"sapCusCode\": \"100360\",\\n \"merchantName\": \"*辉超市股份有限公司\",\\n \"orderTime\": \"2021-04-26 17:22:47\",\\n \"requireDeliveryTime\": \"2021-04-29 00:00-23:59\",\\n \"preferDcName\": \"福建企业购\",\\n \"receiveUsername\": \"13609533815\",\\n \"receivePhone\": \"13609533815\",\\n \"custCon\": \"**省直属机关幼儿园\",\\n \"conTel\": \"13609533815\",\\n \"contactPerson\": \"托亚135\",\\n \"phone\": \"13552090086\",\\n \"receiveAddr\": \"\",\\n \"pageNum\": \"1\",\\n \"totalNum\": \"1\",\\n \"sum\": \"189.6\",\\n \"sumTraditional\": \"壹佰捌拾玖元陆角\",\\n \"totalSum\": \"189.6\",\\n \"totalSumTraditional\": \"壹佰捌拾玖元陆角\",\\n \"buyerRemarks\": null,\\n \"realTotalPriceWithoutTax\": \"172.32\",\\n \"taxTotalPrice\": \"17.28\",\\n \"realTotalPrice\": \"189.6\",\\n \"orderItems\": [\\n {\\n \"sortNum\": 1,\\n \"productCode\": \"1\",\\n \"productBarcode\": \"2304348000004\",\\n \"productName\": \"花生\",\\n \"productNameWithBuyerRemark\": \"花生\",\\n \"unit\": \"KG\",\\n \"originPrice\": \"13.96\",\\n \"originAmount\": \"139.6\",\\n \"promotionPrice\": \"13.96\",\\n \"sendQty\": \"10\",\\n \"realTotalPrice\": \"139.6\",\\n \"promotionPriceWithoutTax\": \"12.8073\",\\n \"realTotalPriceWithoutTax\": \"128.07\",\\n \"taxRatePercent\": \"9%\",\\n \"buyerRemarks\": \"\",\\n \"taxPrice\": \"11.53\",\\n \"departConfirm\": null,\\n \"wasteRate\": null,\\n \"manufactureFactory\": null,\\n \"manufactureDate\": null,\\n \"expirationDate\": null,\\n \"other\": null,\\n \"specRemarks\": \"\",\\n \"brandName\": null,\\n \"purchaseQty\": \"10\",\\n \"purchaseUnit\": \"KG\",\\n \"discountRate\": \"100\",\\n \"customerProductName\": \"花生\"\\n },\\n {\\n \"sortNum\": 2,\\n \"productCode\": \"6889\",\\n \"productBarcode\": \"6901028048125\",\\n \"productName\": \"红梅(15mg软黄)包\",\\n \"productNameWithBuyerRemark\": \"红梅(15mg软黄)包\",\\n \"unit\": \"包\",\\n \"originPrice\": \"5\",\\n \"originAmount\": \"50\",\\n \"promotionPrice\": \"5\",\\n \"sendQty\": \"10\",\\n \"realTotalPrice\": \"50\",\\n \"promotionPriceWithoutTax\": \"4.4248\",\\n \"realTotalPriceWithoutTax\": \"44.25\",\\n \"taxRatePercent\": \"13%\",\\n \"buyerRemarks\": \"\",\\n \"taxPrice\": \"5.75\",\\n \"departConfirm\": null,\\n \"wasteRate\": null,\\n \"manufactureFactory\": null,\\n \"manufactureDate\": null,\\n \"expirationDate\": null,\\n \"other\": null,\\n \"specRemarks\": \"\",\\n \"brandName\": null,\\n \"purchaseQty\": \"10\",\\n \"purchaseUnit\": \"包\",\\n \"discountRate\": \"100\",\\n \"customerProductName\": \"红梅(15mg软黄)包\"\\n }\\n ],\\n \"tms\": \"是\",\\n \"externalOrderCode\": \"OM21042600000104\",\\n \"deliverAreaCode\": \"1\",\\n \"originSum\": \"189.6\",\\n \"title\": \"**省直属机关幼儿园\"\\n },\\n {\\n \"orderNo\": \"OM21042600000079\",\\n \"sapSubCusName\": \"省直幼儿园(北大)\",\\n \"sapCusName\": \"**省直属机关幼儿园\",\\n \"sapCusCode\": \"100360\",\\n \"merchantName\": \"*辉超市股份有限公司\",\\n \"orderTime\": \"2021-04-26 15:06:46\",\\n \"requireDeliveryTime\": \"2021-04-27 00:00-23:59\",\\n \"preferDcName\": \"福建企业购\",\\n \"receiveUsername\": \"13609533815\",\\n \"receivePhone\": \"13609533815\",\\n \"custCon\": \"**省直属机关幼儿园\",\\n \"conTel\": \"13609533815\",\\n \"contactPerson\": \"托亚135\",\\n \"phone\": \"13552090086\",\\n \"receiveAddr\": \"\",\\n \"pageNum\": \"1\",\\n \"totalNum\": \"1\",\\n \"sum\": \"14335.67\",\\n \"sumTraditional\": \"壹万肆仟叁佰叁拾伍元陆角柒分\",\\n \"totalSum\": \"14335.67\",\\n \"totalSumTraditional\": \"壹万肆仟叁佰叁拾伍元陆角柒分\",\\n \"buyerRemarks\": null,\\n \"realTotalPriceWithoutTax\": \"12898.17\",\\n \"taxTotalPrice\": \"1437.5\",\\n \"realTotalPrice\": \"14335.67\",\\n \"orderItems\": [\\n {\\n \"sortNum\": 1,\\n \"productCode\": \"3\",\\n \"productBarcode\": \"2302770000005\",\\n \"productName\": \"东北绿豆\",\\n \"productNameWithBuyerRemark\": \"东北绿豆\",\\n \"unit\": \"KG\",\\n \"originPrice\": \"9.98\",\\n \"originAmount\": \"507.78\",\\n \"promotionPrice\": \"9.98\",\\n \"sendQty\": \"50.88\",\\n \"realTotalPrice\": \"507.78\",\\n \"promotionPriceWithoutTax\": \"9.156\",\\n \"realTotalPriceWithoutTax\": \"465.85\",\\n \"taxRatePercent\": \"9%\",\\n \"buyerRemarks\": \"\",\\n \"taxPrice\": \"6.93\",\\n \"departConfirm\": null,\\n \"wasteRate\": null,\\n \"manufactureFactory\": null,\\n \"manufactureDate\": null,\\n \"expirationDate\": null,\\n \"other\": null,\\n \"specRemarks\": \"\",\\n \"brandName\": null,\\n \"purchaseQty\": \"50.88\",\\n \"purchaseUnit\": \"KG\",\\n \"discountRate\": \"100\",\\n \"customerProductName\": \"测试东北绿豆\"\\n },\\n {\\n \"sortNum\": 2,\\n \"productCode\": \"8774\",\\n \"productBarcode\": \"2302972000001\",\\n \"productName\": \"鸭蛋\",\\n \"productNameWithBuyerRemark\": \"鸭蛋\",\\n \"unit\": \"KG\",\\n \"originPrice\": \"13.16\",\\n \"originAmount\": \"1434.31\",\\n \"promotionPrice\": \"13.16\",\\n \"sendQty\": \"108.99\",\\n \"realTotalPrice\": \"1434.31\",\\n \"promotionPriceWithoutTax\": \"13.16\",\\n \"realTotalPriceWithoutTax\": \"1434.31\",\\n \"taxRatePercent\": \"0%\",\\n \"buyerRemarks\": \"\",\\n \"taxPrice\": \"8.86\",\\n \"departConfirm\": null,\\n \"wasteRate\": null,\\n \"manufactureFactory\": null,\\n \"manufactureDate\": null,\\n \"expirationDate\": null,\\n \"other\": null,\\n \"specRemarks\": \"\",\\n \"brandName\": null,\\n \"purchaseQty\": \"108.99\",\\n \"purchaseUnit\": \"KG\",\\n \"discountRate\": \"100\",\\n \"customerProductName\": \"测试鸭蛋\"\\n },\\n {\\n \"sortNum\": 3,\\n \"productCode\": \"1042915\",\\n \"productBarcode\": \"6927690331969\",\\n \"productName\": \"田趣小町米5kg\",\\n \"productNameWithBuyerRemark\": \"田趣小町米5kg\",\\n \"unit\": \"包\",\\n \"originPrice\": \"46.8\",\\n \"originAmount\": \"889.2\",\\n \"promotionPrice\": \"46.8\",\\n \"sendQty\": \"19\",\\n \"realTotalPrice\": \"889.2\",\\n \"promotionPriceWithoutTax\": \"42.9358\",\\n \"realTotalPriceWithoutTax\": \"815.78\",\\n \"taxRatePercent\": \"9%\",\\n \"buyerRemarks\": \"\",\\n \"taxPrice\": \"33.42\",\\n \"departConfirm\": null,\\n \"wasteRate\": null,\\n \"manufactureFactory\": null,\\n \"manufactureDate\": null,\\n \"expirationDate\": null,\\n \"other\": null,\\n \"specRemarks\": \"\",\\n \"brandName\": null,\\n \"purchaseQty\": \"19\",\\n \"purchaseUnit\": \"包\",\\n \"discountRate\": \"100\",\\n \"customerProductName\": \"田趣小町米5kg\"\\n },\\n {\\n \"sortNum\": 4,\\n \"productCode\": \"1\",\\n \"productBarcode\": \"2304348000004\",\\n \"productName\": \"花生\",\\n \"productNameWithBuyerRemark\": \"花生\",\\n \"unit\": \"KG\",\\n \"originPrice\": \"13.96\",\\n \"originAmount\": \"41.88\",\\n \"promotionPrice\": \"13.96\",\\n \"sendQty\": \"3\",\\n \"realTotalPrice\": \"41.88\",\\n \"promotionPriceWithoutTax\": \"12.8073\",\\n \"realTotalPriceWithoutTax\": \"38.42\",\\n \"taxRatePercent\": \"9%\",\\n \"buyerRemarks\": \"\",\\n \"taxPrice\": \"3.46\",\\n \"departConfirm\": null,\\n \"wasteRate\": null,\\n \"manufactureFactory\": null,\\n \"manufactureDate\": null,\\n \"expirationDate\": null,\\n \"other\": null,\\n \"specRemarks\": \"\",\\n \"brandName\": null,\\n \"purchaseQty\": \"3\",\\n \"purchaseUnit\": \"KG\",\\n \"discountRate\": \"100\",\\n \"customerProductName\": \"花生\"\\n },\\n {\\n \"sortNum\": 5,\\n \"productCode\": \"6939\",\\n \"productBarcode\": \"6901434382882\",\\n \"productName\": \"剑南春52度白酒500ml\",\\n \"productNameWithBuyerRemark\": \"剑南春52度白酒500ml\",\\n \"unit\": \"瓶\",\\n \"originPrice\": \"489\",\\n \"originAmount\": \"9780\",\\n \"promotionPrice\": \"500\",\\n \"sendQty\": \"20\",\\n \"realTotalPrice\": \"10000\",\\n \"promotionPriceWithoutTax\": \"442.4779\",\\n \"realTotalPriceWithoutTax\": \"8849.56\",\\n \"taxRatePercent\": \"13%\",\\n \"buyerRemarks\": \"\",\\n \"taxPrice\": \"150.44\",\\n \"departConfirm\": null,\\n \"wasteRate\": null,\\n \"manufactureFactory\": null,\\n \"manufactureDate\": null,\\n \"expirationDate\": null,\\n \"other\": null,\\n \"specRemarks\": \"\",\\n \"brandName\": null,\\n \"purchaseQty\": \"20\",\\n \"purchaseUnit\": \"瓶\",\\n \"discountRate\": \"102\",\\n \"customerProductName\": \"剑南春52度白酒500ml\"\\n },\\n {\\n \"sortNum\": 6,\\n \"productCode\": \"6882\",\\n \"productBarcode\": \"6901028118170\",\\n \"productName\": \"利群(红新版)包\",\\n \"productNameWithBuyerRemark\": \"利群(红新版)包\",\\n \"unit\": \"包\",\\n \"originPrice\": \"15\",\\n \"originAmount\": \"825\",\\n \"promotionPrice\": \"15\",\\n \"sendQty\": \"55\",\\n \"realTotalPrice\": \"825\",\\n \"promotionPriceWithoutTax\": \"13.2743\",\\n \"realTotalPriceWithoutTax\": \"730.09\",\\n \"taxRatePercent\": \"13%\",\\n \"buyerRemarks\": \"\",\\n \"taxPrice\": \"11.91\",\\n \"departConfirm\": null,\\n \"wasteRate\": null,\\n \"manufactureFactory\": null,\\n \"manufactureDate\": null,\\n \"expirationDate\": null,\\n \"other\": null,\\n \"specRemarks\": \"\",\\n \"brandName\": null,\\n \"purchaseQty\": \"55\",\\n \"purchaseUnit\": \"包\",\\n \"discountRate\": \"100\",\\n \"customerProductName\": \"1111111\"\\n },\\n {\\n \"sortNum\": 7,\\n \"productCode\": \"233223\",\\n \"productBarcode\": \"6917878027883\",\\n \"productName\": \"雀巢怡运全脂高钙奶粉400g\",\\n \"productNameWithBuyerRemark\": \"雀巢怡运全脂高钙奶粉400g\",\\n \"unit\": \"400g/袋\",\\n \"originPrice\": \"42.5\",\\n \"originAmount\": \"637.5\",\\n \"promotionPrice\": \"42.5\",\\n \"sendQty\": \"15\",\\n \"realTotalPrice\": \"637.5\",\\n \"promotionPriceWithoutTax\": \"37.6106\",\\n \"realTotalPriceWithoutTax\": \"564.16\",\\n \"taxRatePercent\": \"13%\",\\n \"buyerRemarks\": \"\",\\n \"taxPrice\": \"33.34\",\\n \"departConfirm\": null,\\n \"wasteRate\": null,\\n \"manufactureFactory\": null,\\n \"manufactureDate\": null,\\n \"expirationDate\": null,\\n \"other\": null,\\n \"specRemarks\": \"\",\\n \"brandName\": null,\\n \"purchaseQty\": \"15\",\\n \"purchaseUnit\": \"400g/袋\",\\n \"discountRate\": \"100\",\\n \"customerProductName\": \"测试雀巢\"\\n }\\n ],\\n \"tms\": \"是\",\\n \"externalOrderCode\": \"OM21042600000079\",\\n \"deliverAreaCode\": \"2\",\\n \"originSum\": \"14115.67\",\\n \"title\": \"**省直属机关幼儿园\"\\n }\\n ]\\n}"}}],"FixedPage":{"Pages":[{"ReportItems":[{"Type":"barcode","Name":"条形码1","ZIndex":1,"Value":"=Fields!sapCusCode.Value","Symbology":"QRCode","QuietZone":{"Left":"0cm","Right":"0cm","Top":"0cm","Bottom":"0cm"},"SupplementOptions":{"Spacing":"0cm"},"Style":{"FontFamily":"微软雅黑","TextAlign":"Right"},"Left":"18.425cm","Top":"0.499cm","Width":"2cm","Height":"2.001cm"},{"Type":"barcode","Name":"条形码2","ZIndex":2,"Value":"=Fields!externalOrderCode.Value","Symbology":"Code_128auto","QuietZone":{"Left":"0cm","Right":"0cm","Top":"0cm","Bottom":"0cm"},"SupplementOptions":{"Spacing":"0cm"},"Style":{"FontFamily":"微软雅黑","TextAlign":"Left"},"Left":"0cm","Top":"0.998cm","Width":"4cm","Height":"1.001cm"},{"Type":"table","Name":"表格2","ZIndex":9,"DataSetName":"DataSet","Style":{"FontFamily":"微软雅黑"},"TableColumns":[{"Width":"5.301cm"},{"Width":"4.035cm"},{"Width":"4.465cm"},{"Width":"6.501cm"}],"TableGroups":[{"Group":{"Name":"表格2_表格分组1","GroupExpressions":[""]},"Footer":{"TableRows":[{"Height":"2.251cm","TableCells":[{"Item":{"Type":"rectangle","Name":"容器1","ConsumeWhiteSpace":true,"Style":{"Border":{"Color":"DimGray","Style":"Solid"}},"ReportItems":[{"Type":"table","Name":"表格3","DataSetName":"orderItems","Style":{"FontFamily":"微软雅黑"},"TableColumns":[{"Width":"2.5cm"},{"Width":"2.5cm"},{"Width":"2.802cm"},{"Width":"2.5cm"},{"Width":"2.5cm"},{"Width":"2.5cm"},{"Width":"2.5cm"},{"Width":"2.5cm"}],"Header":{"TableRows":[{"Height":"0.85cm","TableCells":[{"Item":{"Type":"textbox","Name":"文本框39","KeepTogether":true,"Value":"序号","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle","BackgroundColor":"#aaaaaa"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框48","KeepTogether":true,"Value":"商品编码","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle","BackgroundColor":"#aaaaaa"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框49","KeepTogether":true,"Value":" 商品名称","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle","BackgroundColor":"#aaaaaa"},"Left":"0cm","Top":"0cm","Width":"2.802cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框50","KeepTogether":true,"Value":"单位","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle","BackgroundColor":"#aaaaaa"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框57","KeepTogether":true,"Value":"售价","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle","BackgroundColor":"#aaaaaa"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框60","KeepTogether":true,"Value":"团购价","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle","BackgroundColor":"#aaaaaa"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框63","KeepTogether":true,"Value":"发货数量","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle","BackgroundColor":"#aaaaaa"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框66","KeepTogether":true,"Value":"总金额","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle","BackgroundColor":"#aaaaaa"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}}]}],"RepeatOnNewPage":true},"Details":{"TableRows":[{"Height":"0.85cm","TableCells":[{"Item":{"Type":"textbox","Name":"文本框40","KeepTogether":true,"Value":"=RowNumber()","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框51","DataElementName":"productCode","KeepTogether":true,"Value":"=Fields!productCode.Value","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框52","DataElementName":"productName","CanGrow":true,"KeepTogether":true,"Value":"=Fields!productName.Value","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle","ShrinkToFit":"=True"},"Left":"0cm","Top":"0cm","Width":"2.802cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框53","DataElementName":"unit","KeepTogether":true,"Value":"=Fields!unit.Value","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框58","DataElementName":"originPrice","KeepTogether":true,"Value":"=Fields!originPrice.Value","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框61","DataElementName":"taxPrice","KeepTogether":true,"Value":"=Fields!taxPrice.Value","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框64","DataElementName":"purchaseQty","KeepTogether":true,"Value":"=Fields!purchaseQty.Value","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}},{"Item":{"Type":"textbox","Name":"文本框67","KeepTogether":true,"Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.85cm"}}]}]},"Left":"0cm","Top":"0cm","Width":"20.302cm","Height":"1.7cm"}],"Left":"0cm","Top":"0cm","Width":"20.302cm","Height":"2.251cm"},"ColSpan":4},null,null,null]}]}}],"Footer":{"TableRows":[{"Height":"0.75cm","TableCells":[{"Item":{"Type":"textbox","Name":"文本框36","KeepTogether":true,"Value":"=\"合计金额(大写):\" + Fields!sumTraditional.Value","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"9.336cm","Height":"0.75cm"},"ColSpan":2},null,{"Item":{"Type":"textbox","Name":"文本框38","DataElementName":"sum","KeepTogether":true,"Value":"=Sum(Fields!sum.Value)","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"10.966cm","Height":"0.75cm"},"ColSpan":2},null]},{"Height":"0.75cm","TableCells":[{"Item":{"Type":"textbox","Name":"文本框33","KeepTogether":true,"Value":"=\"合计总金额(大写):\" + Fields!totalSumTraditional.Value","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"9.336cm","Height":"0.75cm"},"ColSpan":2},null,{"Item":{"Type":"textbox","Name":"文本框42","DataElementName":"totalSum","KeepTogether":true,"Value":"=Sum(Fields!totalSum.Value)","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"10.966cm","Height":"0.75cm"},"ColSpan":2},null]},{"Height":"0.75cm","TableCells":[{"Item":{"Type":"textbox","Name":"文本框37","KeepTogether":true,"Value":"出货仓管确认签字:","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"5.301cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框44","KeepTogether":true,"Value":"承运方确认签字:","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"8.5cm","Height":"0.75cm"},"ColSpan":2},null,{"Item":{"Type":"textbox","Name":"文本框47","KeepTogether":true,"Value":"客户确认签字:","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"6.501cm","Height":"0.75cm"}}]}]},"Left":"0.2cm","Top":"5.259cm","Width":"20.302cm","Height":"4.501cm","FixedWidth":"20.301cm","FixedHeight":"11.241cm"},{"Type":"textbox","Name":"文本框19","ZIndex":10,"KeepTogether":true,"Value":" =\"客户订货时间:\"+Fields!orderTime.Value","Style":{"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Left":"0.2cm","Top":"4.518cm","Width":"10.233cm","Height":"0.75cm"},{"Type":"textbox","Name":"文本框22","ZIndex":11,"KeepTogether":true,"Value":"=\"客户信息:\"+Fields!sapSubCusName.Value","Style":{"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Left":"0.2cm","Top":"3.759cm","Width":"10.232cm","Height":"0.75cm"},{"Type":"textbox","Name":"文本框23","ZIndex":12,"KeepTogether":true,"Value":" =\"客户提货时间:\"+Fields!requireDeliveryTime.Value","Style":{"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Left":"10.432cm","Top":"4.509cm","Width":"10cm","Height":"0.75cm"},{"Type":"textbox","Name":"文本框31","ZIndex":13,"KeepTogether":true,"Value":" =\"出货门店:\"+Fields!merchantName.Value","Style":{"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Left":"10.432cm","Top":"3.771cm","Width":"10cm","Height":"0.75cm"},{"Type":"textbox","Name":"文本框32","ZIndex":14,"KeepTogether":true,"Value":" =Fields!title.Value + \"团购订单\"","Style":{"FontFamily":"微软雅黑","FontWeight":"Bold","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center"},"Left":"0.2cm","Top":"3.01cm","Width":"20.232cm","Height":"0.75cm"}]}],"Group":{"Name":"固定页面_分组1","GroupExpressions":["=Fields!orderNo.Value"]},"DataSetName":"DataSet"},"DataSets":[{"Name":"DataSet","Fields":[{"Name":"orderNo","DataField":"orderNo"},{"Name":"sapSubCusName","DataField":"sapSubCusName"},{"Name":"sapCusName","DataField":"sapCusName"},{"Name":"sapCusCode","DataField":"sapCusCode"},{"Name":"merchantName","DataField":"merchantName"},{"Name":"orderTime","DataField":"orderTime"},{"Name":"requireDeliveryTime","DataField":"requireDeliveryTime"},{"Name":"preferDcName","DataField":"preferDcName"},{"Name":"receiveUsername","DataField":"receiveUsername"},{"Name":"receivePhone","DataField":"receivePhone"},{"Name":"custCon","DataField":"custCon"},{"Name":"conTel","DataField":"conTel"},{"Name":"contactPerson","DataField":"contactPerson"},{"Name":"phone","DataField":"phone"},{"Name":"receiveAddr","DataField":"receiveAddr"},{"Name":"pageNum","DataField":"pageNum"},{"Name":"totalNum","DataField":"totalNum"},{"Name":"sum","DataField":"sum"},{"Name":"sumTraditional","DataField":"sumTraditional"},{"Name":"totalSum","DataField":"totalSum"},{"Name":"totalSumTraditional","DataField":"totalSumTraditional"},{"Name":"buyerRemarks","DataField":"buyerRemarks"},{"Name":"realTotalPriceWithoutTax","DataField":"realTotalPriceWithoutTax"},{"Name":"taxTotalPrice","DataField":"taxTotalPrice"},{"Name":"realTotalPrice","DataField":"realTotalPrice"},{"Name":"orderItems","DataField":"orderItems"},{"Name":"tms","DataField":"tms"},{"Name":"externalOrderCode","DataField":"externalOrderCode"},{"Name":"deliverAreaCode","DataField":"deliverAreaCode"},{"Name":"originSum","DataField":"originSum"},{"Name":"title","DataField":"title"}],"Query":{"DataSourceName":"本地测试数据","CommandText":"jpath=$.data.*"},"CaseSensitivity":"Auto","KanatypeSensitivity":"Auto","AccentSensitivity":"Auto","WidthSensitivity":"Auto"},{"Name":"orderItems","Fields":[{"Name":"sortNum","DataField":"sortNum"},{"Name":"productCode","DataField":"productCode"},{"Name":"productBarcode","DataField":"productBarcode"},{"Name":"productName","DataField":"productName"},{"Name":"productNameWithBuyerRemark","DataField":"productNameWithBuyerRemark"},{"Name":"unit","DataField":"unit"},{"Name":"originPrice","DataField":"originPrice"},{"Name":"originAmount","DataField":"originAmount"},{"Name":"promotionPrice","DataField":"promotionPrice"},{"Name":"sendQty","DataField":"sendQty"},{"Name":"realTotalPrice","DataField":"realTotalPrice"},{"Name":"promotionPriceWithoutTax","DataField":"promotionPriceWithoutTax"},{"Name":"realTotalPriceWithoutTax","DataField":"realTotalPriceWithoutTax"},{"Name":"taxRatePercent","DataField":"taxRatePercent"},{"Name":"buyerRemarks","DataField":"buyerRemarks"},{"Name":"taxPrice","DataField":"taxPrice"},{"Name":"departConfirm","DataField":"departConfirm"},{"Name":"wasteRate","DataField":"wasteRate"},{"Name":"manufactureFactory","DataField":"manufactureFactory"},{"Name":"manufactureDate","DataField":"manufactureDate"},{"Name":"expirationDate","DataField":"expirationDate"},{"Name":"other","DataField":"other"},{"Name":"specRemarks","DataField":"specRemarks"},{"Name":"brandName","DataField":"brandName"},{"Name":"purchaseQty","DataField":"purchaseQty"},{"Name":"purchaseUnit","DataField":"purchaseUnit"},{"Name":"discountRate","DataField":"discountRate"},{"Name":"customerProductName","DataField":"customerProductName"}],"Query":{"DataSourceName":"$dataset:DataSet/orderItems"},"CaseSensitivity":"Auto","KanatypeSensitivity":"Auto","AccentSensitivity":"Auto","WidthSensitivity":"Auto"}]}