<?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="HardwareEntryDetailListQuery">
|
<![CDATA[
|
|
select e.cgsd_id,e.cgsd_did,e.cgsd_cgse_id,e.cgsd_cgpd_id,e.cgsd_bbst_id,e.cgsd_amount_w,e.cgsd_reject_amount,
|
e.cgsd_now_amount_w,e.cgsd_now_reject_amount,e.cgsd_statue,e.cgsd_price,
|
e.cgsd_sub_totle,e.cgsd_remark,bbbr_name,se.cgse_entry_date,
|
s.bbst_name,s.bbst_style,s.bbst_first_unit,p.bbbp_name
|
from cg_stuff_entry_detail e
|
left join cg_stuff_entry se on se.cgse_id=e.cgsd_cgse_id
|
left join bb_stuff s on s.bbst_id=e.cgsd_bbst_id
|
left join bb_branch on s.bbst_bbbr_id=bbbr_id
|
left join bb_business_partner p on p.bbbp_id=se.cgse_bbbp_id
|
where 1=1
|
and ( se.cgse_flag_entry= '五金' or se.cgse_flag_entry='五金退货' )
|
<<and s.bbst_name=:bbstName>>
|
<<and s.bbst_type=:bbstType>>
|
<<and se.cgse_entry_date >= :beginDate>>
|
<<and se.cgse_entry_date <= :endDate>>
|
and ##CONDITIONS##
|
|
]]>
|
</sql-query>
|
</hibernate-mapping>
|
