<?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="CgProcureQuery">
|
<![CDATA[
|
|
select bbbp_name,bbst_type,bbst_style,cgpr_id,cgpr_sn,cgpr_bbbp_id,creator,create_time,modifier,modify_time,cgpr_require_date,cgpr_flag,cgpr_remark
|
from cg_procure cgpr,bb_business_partner bbbp,bb_stuff bbst,cg_procure_detail cgpd
|
where cgpr.cgpr_bbbp_id = bbbp.bbbp_id and cgpd.cgpd_cgpr_id=cgpr.cgpr_id and cgpd.cgpd_bbst_id=bbst.bbst_id
|
<<and bbbp_name= :bbbpName>>
|
<<and bbst_name= :bbstName>>
|
<<and bbst_type= :bbstType>>
|
<<and bbst_style= :bbstStyle>>
|
<<and cgpr_ate>=:beginRequireDate>>
|
<<and cgpr_ate<=:endRequireDate>>
|
<<and cgpr_flag= :cgprFlag>>
|
and ##CONDITIONS##
|
group by cgpr.cgpr_id
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
