<?xml version="1.0"?>
|
<!DOCTYPE hibernate-mapping PUBLIC
|
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
|
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
|
|
<hibernate-mapping>
|
<sql-query name="ProductWarehouseEditQuery">
|
<![CDATA[
|
|
select bbpr_size,bbpr_id,bbpr_sn,bbpr_name,bbpr_brand from bb_product_item left join
|
bb_product on bbit_bbpr_id = bbpr_id
|
where 1=1
|
and ( bbit_is_exit is null or bbit_is_exit = 'N')
|
<<and bbit_locationid = :locationid>>
|
<<and bbpr_locationid = :locationid>>
|
<<and bbit_bbwh_id = :warehouseId>>
|
<<and if((:wareHouseIsNull='-2'),bbit_bbwh_id is null,1=1)>>
|
<<and (bbpr_sn like concat("%",:message,"%") or bbpr_name like concat("%",:message,"%") or bbpr_brand like concat("%",:message,"%"))>>
|
group by bbit_bbpr_id
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
