ibait的使用

<insert id='CopyHtxx' parameterClass='fastrise.zcyw.obj.Htxx'>
		 <selectKey keyProperty='new_sheet_no' resultClass='string'>
	        select SEQ_KG_T_ZLHTXX.Nextval as new_sheet_no from dual
	    </selectKey>
	   insert into kg_t_zlhtxx (sheet_no,htbh,approve_flag,babzt,czbdw,oper_date,
	     dwmjcd,zcczf,zcczfdb,czf,czfdb,czflxr,czflxfs,sfzh,yyzzhm,htnzj,zq,htqdrq,htqsrq,htjzrq,fkfs,dycfk,
          zlyt,bzj,qtbj,xxfb,zcztsm,hyjy,zlht,xmxycs,xjjbr,sbdw,oper_id,dwbm,czflxrdh,zczydw,bz,xspjs,type,mympf,myzj,jsfs,htzje,zllx) 
         (select #new_sheet_no#,#htbh#,'执行状态',null,null,sysdate,
          dwmjcd,zcczf,zcczfdb,czf,czfdb,czflxr,czflxfs,sfzh,yyzzhm,htnzj,zq,htqdrq,htqsrq,htjzrq,fkfs,dycfk,
          zlyt,bzj,qtbj,xxfb,zcztsm,hyjy,zlht,xmxycs,xjjbr,
          sbdw,oper_id,dwbm,czflxrdh,zczydw,bz,xspjs,type,mympf,myzj,jsfs,htzje,zllx from kg_t_zlhtxx where sheet_no=#sheet_no#)
    </insert> 

	<sql id="SelectAllHtxxSql">
		 from kg_t_zlhtxx a, kg_zzjg b
		  <isEqual  property="jy" compareValue = "true">
           ,kg_t_zlhtwd c

<select id="SelectAllHtxxPaging" resultClass="fastrise.zcyw.obj.Htxx" parameterClass="fastrise.zcyw.obj.Htcxtj">
	<![CDATA[ select * from ( select paging.*, rownum rn from ( ]]>
	    <include refid="SelectHtxxFieldsSql"/>
		<include refid="SelectAllHtxxSql"/>
	<![CDATA[ ) paging where rownum <= $end$ ) where rn >=$start$ ]]>
	</select> 
	
	<select id="SelectAllHtxxCount" resultClass="string" parameterClass="fastrise.zcyw.obj.Htcxtj">
		select count(a.sheet_no) count
		<include refid="SelectAllHtxxSql"/>
	</select> 




</isEqual> where a.dwbm = b.code <isEqual prepend="And" property="jy" compareValue = "true"> a.sheet_no =c.htid(+) and c.htid is null </isEqual><isNotEmpty prepend="And" property="htqdrq_begin"><![CDATA[a.htjzrq >= #htqdrq_begin#]]></isNotEmpty><isNotEmpty prepend="And" property="htqdrq_end"><![CDATA[a.htjzrq <= #htqdrq_end#]]></isNotEmpty><isNotEmpty prepend="And" property="czbdw">a.czbdw like '%$czbdw$%'</isNotEmpty>




<select id='SelectAllHtxx' resultClass='fastrise.zcyw.obj.Htxx' parameterClass='fastrise.zcyw.obj.Htcxtj'>
	    <include refid="SelectHtxxFieldsSql"/>
	    <include refid="SelectAllHtxxSql"/>
	</select>