modifyDetailPage-增加查询功能

最新推荐文章于 2021-09-18 10:59:11 发布

原创最新推荐文章于 2021-09-18 10:59:11 发布 · 429 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

vtradex 专栏收录该内容

42 篇文章

订阅专栏

1，modify下增加查询控件和按钮，一般按钮一个就够，控件可增减。

2，detail下查询sql末尾增加/~xx:AND yy.xx={xx}~/

3，方法不执行任何数据库操作，内容为空即可。目的是触发modifyDetailPage的刷新。

<?xml version="1.0" encoding="UTF-8"?>

<pages>
    <modifyDetailPage id="modifyDetailReceiveBookingPage" title="modifyDetailReceiveBookingPage" 
		entityClass="com.server.model.receiving.WmsBooking" onClose="refreshParent" width="880" height="500">
        <initListeners/>
        <modify>
            <inputUIs>
                <hidden id="booking.id" title="booking.id" reserve="false"/>
                <remote id="booking.dock.id" title="booking.dock.id" row="1" col="2" span="1" readOnly="false" 
				required="true" reserve="false" forceOverride="true" focusUI="false" inVisible="false" multiple="false" 
				manualEditable="true" displayColumn="3" percentSignPosition="both" displayedTableHead="序号,代码">
                    <visibleExpression/>
                    <hql><![CDATA[SELECT
dock.id,
dock.code
FROM WmsDock dock
WHERE 1=1
AND dock.code LIKE :param 
AND dock.status = 'ENABLED'
AND dock.beReceive = true
AND dock.warehouseArea.warehouse.id = #{SESSION_WAREHOUSE}]]></hql>
                    <eventListeners/>
                </remote>
            </inputUIs>
        </modify>
        <detail entityClass="com.server.model.receiving.WmsASNDetail">
            <datasource><![CDATA[SELECT asnDetail.id,
			booking.asnPlannedStartTime,
			booking.asnPlannedLastTime  
			FROM WmsASNDetail asnDetail
	LEFT JOIN asnDetail.booking booking
	WHERE 1=1
	/~booking.preId: AND asnDetail.booking.id = {booking.preId}~/]]></datasource>
	<columns>
		<column id="asnDetail.id" title="asnDetail.id" visible="false" sortable="true" 
			horizonAlign="center" verticalAlign="middle"/>
		<column id="booking.asnPlannedStartTime" title="asnDetail.reserveBeginTime" 
			visible="true" sortable="true" horizonAlign="center" verticalAlign="middle" dataType="datetime"/>
		<column id="booking.asnPlannedLastTime" title="asnDetail.reserveFinishTime" 
			visible="true" sortable="true" horizonAlign="center" verticalAlign="middle" dataType="datetime"/>
	</columns>
	</detail>
    </modifyDetailPage>
</pages>