inputhelper

<!-- 外派信息 -->

<select id="OutSourcing">

select t.groupname, m.deptname

from t_dept m ,t_group t

<dynamic prepend="WHERE">

<isNotEmpty prepend="AND" property="groupname">

t.groupname LIKE '%' || #groupname# || '%'

</isNotEmpty>

<isNotEmpty prepend="AND" property="deptname">

m.deptname LIKE '%' || #deptname # || '%'

</isNotEmpty>

</dynamic>

</select>

<select id="OutSourcingCount">

select count(*) 

from t_dept m ,t_group t

<dynamic prepend="WHERE">

<isNotEmpty prepend="AND" property="groupname">

t.groupname LIKE '%' || #groupname# || '%'

</isNotEmpty>

<isNotEmpty prepend="AND" property="deptname">

m.deptname LIKE '%' || #deptname # || '%'

</isNotEmpty>

</dynamic>

</select>