<?xml version="1.0" encoding="gbk" standalone="no"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="" >
<!-- 	<typeAlias alias="Xtbhlbean" type="cn.vp.XXX.model.XtbhlBean"/> -->	<typeAlias alias="Xtbhl" type="cn.bsystem.ptconst.XtbhlBean"/>
	
	<sql id="condition_Xtbhl">
		where 1=1
		<isNotEmpty prepend='AND' property='LIKExh'>
			(xh like '%$LIKExh$%')
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='xh'>
			(xh = #xh#  )
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='LIKEcsdl'>
			(csdl like '%$LIKEcsdl$%')
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='csdl'>
			(csdl = #csdl#  )
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='LIKEcsdm'>
			(csdm like '%$LIKEcsdm$%' )
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='csdm'>
			(csdm = #csdm# )
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='LIKEcsmc'>
			(csmc like '%$LIKEcsmc$%' )
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='csmc'>
			(csmc = #csmc# )
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='LIKEmrz'>
			(mrz like '%$LIKEmrz$%' )
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='mrz'>
			(mrz = #mrz# )
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='LIKEsxz'>
			(sxz like '%$LIKEsxz$%')
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='sxz'>
			(sxz = #sxz# )
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='LIKExxz'>
			(xxz like '%$LIKExxz$%')
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='xxz'>
			(xxz = #xxz# )
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='LIKEpx'>
			(px like '%$LIKEpx$%' )
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='px'>
			(px = #px# )
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='LIKEcjry'>
			(cjry like '%$LIKEcjry$%' )
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='cjry'>
			(cjry = #cjry# )
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='LIKEcjrq'>
			(cjrq like '%$LIKEcjrq$%')
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='cjrq'>
			(cjrq = #cjrq# )
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='LIKExgry'>
			(xgry like '%$LIKExgry$%')
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='xgry'>
			(xgry = #xgry# )
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='LIKExgrq'>
			(xgrq like '%$LIKExgrq$%')
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='xgrq'>
			(xgrq = #xgrq# )
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='LIKEbz'>
			(bz like '%$LIKEbz$%' )
		</isNotEmpty>
		<isNotEmpty prepend='AND' property='bz'>
			(bz = #bz# )
		</isNotEmpty>
		<isNotEmpty property='tableparam'>
			$tableparam$
		</isNotEmpty>
		<isNotEmpty property='order'>
			$order$
		</isNotEmpty>
	</sql>
	
	<!-- query objects by page-->
	<select id="query_Xtbhl" resultClass="java.util.HashMap" parameterClass="java.util.Map">
		select 
			csdl,xh,csdm,csmc,mrz,sxz,xxz,px,cjry,cjrq,xgry,xgrq,bz
		from xtbhl 
		<include refid="condition_Xtbhl"/>
		
	</select>
	
	<!-- query objects totalcount -->
	<select id="count_Xtbhl" resultClass="java.lang.Integer" parameterClass="java.util.Map">
		select count(*) from xtbhl 
		<include refid="condition_Xtbhl"/>			
	</select>
	
</sqlMap>











