<?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="Nhywjtssxcsbbean" type="cn.vp.XXX.model.NhywjtssxcsbBean"/> -->	<typeAlias alias="Nhywjtssxcsb" type="cn.im.ywlogmanagement.NhywjtssxcsbBean"/>
	
	<sql id="condition_Nhywjtssxcsb">
		where 1=1
		<isNotEmpty prepend='AND ' property='LIKExh'>
			(xh like '%$LIKExh$%'   )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xh'>
			(xh = #xh#  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKExcdh'>
			(xcdh like '%$LIKExcdh$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcdh'>
			(xcdh = #xcdh# )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKExcsblx'>
			(xcsblx like '%$LIKExcsblx$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcsblx'>
			(xcsblx = #xcsblx# )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKExcsbbh'>
			(xcsbbh like '%$LIKExcsbbh$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcsbbh'>
			(xcsbbh = #xcsbbh# )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKExcsbtdbh'>
			(xcsbtdbh like '%$LIKExcsbtdbh$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcsbtdbh'>
			(xcsbtdbh = #xcsbtdbh# )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKExcsbmc'>
			(xcsbmc like '%$LIKExcsbmc$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcsbmc'>
			(xcsbmc = #xcsbmc# )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKExcsbzt'>
			(xcsbzt like '%$LIKExcsbzt$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcsbzt'>
			(xcsbzt = #xcsbzt# )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKExfzt'>
			(xfzt like '%$LIKExfzt$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xfzt'>
			(xfzt = #xfzt# )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKExfsj'>
			(xfsj like '%$LIKExfsj$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xfsj'>
			(xfsj = #xfsj# )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKExfms'>
			(xfms like '%$LIKExfms$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xfms'>
			(xfms = #xfms# )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEsbtp'>
			(sbtp like '%$LIKEsbtp$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='sbtp'>
			(sbtp = #sbtp# )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEsbsp'>
			(sbsp like '%$LIKEsbsp$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='sbsp'>
			(sbsp = #sbsp# )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEgztp'>
			(gztp like '%$LIKEgztp$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='gztp'>
			(gztp = #gztp# )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEgzsp'>
			(gzsp like '%$LIKEgzsp$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='gzsp'>
			(gzsp = #gzsp# )
		</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 prepend='AND ' property='LIKEkz1'>
			(kz1 like '%$LIKEkz1$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='kz1'>
			(kz1 = #kz1# )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEkz2'>
			(kz2 like '%$LIKEkz2$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='kz2'>
			(kz2 = #kz2# )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEkz3'>
			(kz3 like '%$LIKEkz3$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='kz3'>
			(kz3 = #kz3# )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEkz4'>
			(kz4 like '%$LIKEkz4$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='kz4'>
			(kz4 = #kz4# )
		</isNotEmpty>
		<isNotEmpty property='tableparam'>
			$tableparam$
		</isNotEmpty>
		<isNotEmpty property='order'>
			$order$
		</isNotEmpty>
	</sql>
	
	<!-- add object -->
	<insert id="insert_Nhywjtssxcsb" parameterClass="java.util.Map">
		insert into 
		nhywjtssxcsb(
		<dynamic prepend=" ">  
			<isNotEmpty prepend=',' property='xh'>xh</isNotEmpty>
			<isNotEmpty prepend=',' property='xcdh'>xcdh</isNotEmpty>
			<isNotEmpty prepend=',' property='xcsblx'>xcsblx</isNotEmpty>
			<isNotEmpty prepend=',' property='xcsbbh'>xcsbbh</isNotEmpty>
			<isNotEmpty prepend=',' property='xcsbtdbh'>xcsbtdbh</isNotEmpty>
			<isNotEmpty prepend=',' property='xcsbmc'>xcsbmc</isNotEmpty>
			<isNotEmpty prepend=',' property='xcsbzt'>xcsbzt</isNotEmpty>
			<isNotEmpty prepend=',' property='xfzt'>xfzt</isNotEmpty>
			<isNotEmpty prepend=',' property='xfsj'>xfsj</isNotEmpty>
			<isNotEmpty prepend=',' property='xfms'>xfms</isNotEmpty>
			<isNotEmpty prepend=',' property='sbtp'>sbtp</isNotEmpty>
			<isNotEmpty prepend=',' property='sbsp'>sbsp</isNotEmpty>
			<isNotEmpty prepend=',' property='gztp'>gztp</isNotEmpty>
			<isNotEmpty prepend=',' property='gzsp'>gzsp</isNotEmpty>
			<isNotEmpty prepend=',' property='cjry'>cjry</isNotEmpty>
			<isNotEmpty prepend=',' property='cjrq'>cjrq</isNotEmpty>
			<isNotEmpty prepend=',' property='xgry'>xgry</isNotEmpty>
			<isNotEmpty prepend=',' property='xgrq'>xgrq</isNotEmpty>
			<isNotEmpty prepend=',' property='bz'>bz</isNotEmpty>
			<isNotEmpty prepend=',' property='kz1'>kz1</isNotEmpty>
			<isNotEmpty prepend=',' property='kz2'>kz2</isNotEmpty>
			<isNotEmpty prepend=',' property='kz3'>kz3</isNotEmpty>
			<isNotEmpty prepend=',' property='kz4'>kz4</isNotEmpty>

		</dynamic>  
	    <![CDATA[ 
	        ) values ( 
	    ]]>  
	     <dynamic prepend=" "> 
			<isNotEmpty prepend=',' property='xh'>#xh#</isNotEmpty>
			<isNotEmpty prepend=',' property='xcdh'>#xcdh#</isNotEmpty>
			<isNotEmpty prepend=',' property='xcsblx'>#xcsblx#</isNotEmpty>
			<isNotEmpty prepend=',' property='xcsbbh'>#xcsbbh#</isNotEmpty>
			<isNotEmpty prepend=',' property='xcsbtdbh'>#xcsbtdbh#</isNotEmpty>
			<isNotEmpty prepend=',' property='xcsbmc'>#xcsbmc#</isNotEmpty>
			<isNotEmpty prepend=',' property='xcsbzt'>#xcsbzt#</isNotEmpty>
			<isNotEmpty prepend=',' property='xfzt'>#xfzt#</isNotEmpty>
			<isNotEmpty prepend=',' property='xfsj'>#xfsj#</isNotEmpty>
			<isNotEmpty prepend=',' property='xfms'>#xfms#</isNotEmpty>
			<isNotEmpty prepend=',' property='sbtp'>#sbtp#</isNotEmpty>
			<isNotEmpty prepend=',' property='sbsp'>#sbsp#</isNotEmpty>
			<isNotEmpty prepend=',' property='gztp'>#gztp#</isNotEmpty>
			<isNotEmpty prepend=',' property='gzsp'>#gzsp#</isNotEmpty>
			<isNotEmpty prepend=',' property='cjry'>#cjry#</isNotEmpty>
			<isNotEmpty prepend=',' property='cjrq'>#cjrq#</isNotEmpty>
			<isNotEmpty prepend=',' property='xgry'>#xgry#</isNotEmpty>
			<isNotEmpty prepend=',' property='xgrq'>#xgrq#</isNotEmpty>
			<isNotEmpty prepend=',' property='bz'>#bz#</isNotEmpty>
			<isNotEmpty prepend=',' property='kz1'>#kz1#</isNotEmpty>
			<isNotEmpty prepend=',' property='kz2'>#kz2#</isNotEmpty>
			<isNotEmpty prepend=',' property='kz3'>#kz3#</isNotEmpty>
			<isNotEmpty prepend=',' property='kz4'>#kz4#</isNotEmpty>

		 </dynamic>  
	    <![CDATA[ 
	        ) 
	    ]]> 
	</insert>
	
	<!-- edit object  -->
	<update id="update_Nhywjtssxcsb" parameterClass="java.util.Map">
		update nhywjtssxcsb 
		<dynamic prepend="set ">   
			
			<isNotEmpty prepend=',' property='xcdh'>xcdh=#xcdh#</isNotEmpty>
			<isNotEmpty prepend=',' property='xcsblx'>xcsblx=#xcsblx#</isNotEmpty>
			<isNotEmpty prepend=',' property='xcsbbh'>xcsbbh=#xcsbbh#</isNotEmpty>
			<isNotEmpty prepend=',' property='xcsbtdbh'>xcsbtdbh=#xcsbtdbh#</isNotEmpty>
			<isNotEmpty prepend=',' property='xcsbmc'>xcsbmc=#xcsbmc#</isNotEmpty>
			<isNotEmpty prepend=',' property='xcsbzt'>xcsbzt=#xcsbzt#</isNotEmpty>
			<isNotEmpty prepend=',' property='xfzt'>xfzt=#xfzt#</isNotEmpty>
			<isNotEmpty prepend=',' property='xfsj'>xfsj=#xfsj#</isNotEmpty>
			<isNotEmpty prepend=',' property='xfms'>xfms=#xfms#</isNotEmpty>
			<isNotEmpty prepend=',' property='sbtp'>sbtp=#sbtp#</isNotEmpty>
			<isNotEmpty prepend=',' property='sbsp'>sbsp=#sbsp#</isNotEmpty>
			<isNotEmpty prepend=',' property='gztp'>gztp=#gztp#</isNotEmpty>
			<isNotEmpty prepend=',' property='gzsp'>gzsp=#gzsp#</isNotEmpty>
			<isNotEmpty prepend=',' property='cjry'>cjry=#cjry#</isNotEmpty>
			<isNotEmpty prepend=',' property='cjrq'>cjrq=#cjrq#</isNotEmpty>
			<isNotEmpty prepend=',' property='xgry'>xgry=#xgry#</isNotEmpty>
			<isNotEmpty prepend=',' property='xgrq'>xgrq=#xgrq#</isNotEmpty>
			<isNotEmpty prepend=',' property='bz'>bz=#bz#</isNotEmpty>
			<isNotEmpty prepend=',' property='kz1'>kz1=#kz1#</isNotEmpty>
			<isNotEmpty prepend=',' property='kz2'>kz2=#kz2#</isNotEmpty>
			<isNotEmpty prepend=',' property='kz3'>kz3=#kz3#</isNotEmpty>
			<isNotEmpty prepend=',' property='kz4'>kz4=#kz4#</isNotEmpty>

		</dynamic>
		where 1=1 
			<isNotEmpty prepend='AND ' property='XGTJxh'> xh = #XGTJxh#</isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJxcdh'> xcdh = #XGTJxcdh# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJxcsblx'> xcsblx = #XGTJxcsblx# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJxcsbbh'> xcsbbh = #XGTJxcsbbh# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJxcsbtdbh'> xcsbtdbh = #XGTJxcsbtdbh# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJxcsbmc'> xcsbmc = #XGTJxcsbmc# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJxcsbzt'> xcsbzt = #XGTJxcsbzt# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJxfzt'> xfzt = #XGTJxfzt# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJxfsj'> xfsj = #XGTJxfsj# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJxfms'> xfms = #XGTJxfms# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJsbtp'> sbtp = #XGTJsbtp# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJsbsp'> sbsp = #XGTJsbsp# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJgztp'> gztp = #XGTJgztp# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJgzsp'> gzsp = #XGTJgzsp# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJcjry'> cjry = #XGTJcjry# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJcjrq'> cjrq = #XGTJcjrq# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJxgry'> xgry = #XGTJxgry# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJxgrq'> xgrq = #XGTJxgrq# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJbz'> bz = #XGTJbz# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJkz1'> kz1 = #XGTJkz1# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJkz2'> kz2 = #XGTJkz2# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJkz3'> kz3 = #XGTJkz3# </isNotEmpty>
			<isNotEmpty prepend='AND ' property='XGTJkz4'> kz4 = #XGTJkz4# </isNotEmpty>

	</update>
	
	<!-- delete object -->
	<delete id="delete_Nhywjtssxcsb" parameterClass="java.util.Map">
		delete from nhywjtssxcsb 
		<include refid="condition_Nhywjtssxcsb"/>
	</delete>
	
	<!-- batch delete object -->
	<delete id="batch_delete_Nhywjtssxcsb" parameterClass="java.util.Map">
		delete from nhywjtssxcsb 
		where 1=1
			<isNotEmpty prepend=' ' property='keyword'>
				$keyword$
			</isNotEmpty>
	</delete>
	
	<!-- query objects by page-->
	<select id="query_Nhywjtssxcsb" resultClass="java.util.HashMap" parameterClass="java.util.Map">
		select 
			xh,xcdh,xcsblx,xcsbbh,xcsbtdbh,xcsbmc,xcsbzt,xfzt,xfsj,xfms,sbtp,sbsp,gztp,gzsp,cjry,cjrq,xgry,xgrq,bz,kz1,kz2,kz3,kz4
			,(select b.xcdmc from nhywjtssxcd b where b.xh=xcdh ) as xcdmc
		from nhywjtssxcsb 
		<include refid="condition_Nhywjtssxcsb"/>		
	</select>
	
	<!-- query objects totalcount -->
	<select id="count_Nhywjtssxcsb" resultClass="java.lang.Integer" parameterClass="java.util.Map">
		select count(*) from nhywjtssxcsb 
		<include refid="condition_Nhywjtssxcsb"/>			
	</select>
	<!-- 根据服务商编号查询关联集合设备信息 -->
	<select id="listJksbByFwsbh" resultClass="java.util.HashMap" parameterClass="java.util.Map">
		select 	a.videonum,a.channelnum,a.channelname
		from ywvideochannelsetlist a
		where 1=1
	<!--and a.channelsetid = (select kz1 from nhywgysxx where xh = #fwsbh#	)-->
    <isNotEmpty prepend='AND ' property='LIKEchannelname'>
        (a.channelname like '%$LIKEchannelname$%'  )
    </isNotEmpty>
    <isNotEmpty prepend='AND ' property='LIKEvideonum'>
        (a.videonum like '%$LIKEvideonum$%'  )
    </isNotEmpty>
    <isNotEmpty prepend='AND ' property='xcdh'>
        ((a.videonum,a.channelnum) not in (select xcsbbh,xcsbtdbh from nhywjtssxcsb where xcdh=#xcdh#) )
    </isNotEmpty>
</select>
<!-- 根据服务商编号查询关联集合设备数量 -->
	<select id="countJksbByFwsbh" resultClass="java.lang.Integer" parameterClass="java.util.Map">
		select 	count(*) from ywvideochannelsetlist a		where 1=1
	<!-- and a.channelsetid = (select kz1 from nhywgysxx 	where xh = #fwsbh#)-->
    <isNotEmpty prepend='AND ' property='LIKEchannelname'>
        (a.channelname like '%$LIKEchannelname$%'  )
    </isNotEmpty>
    <isNotEmpty prepend='AND ' property='LIKEvideonum'>
        (a.videonum like '%$LIKEvideonum$%'  )
    </isNotEmpty>
    <isNotEmpty prepend='AND ' property='xcdh'>
        ((a.videonum,a.channelnum) not in (select xcsbbh,xcsbtdbh from nhywjtssxcsb where xcdh=#xcdh#) )
    </isNotEmpty>
</select>

<!-- batch add objects -->
	<insert id="batch_insert_Nhywjtssxcsb" parameterClass="java.util.List">
	 	<![CDATA[
          INSERT
      	]]>
      	<iterate conjunction=" " > 
			into nhywjtssxcsb(
			 <![CDATA[ 
				xh,xcdh,xcsblx,xcsbbh,xcsbtdbh,xcsbmc,xcsbzt,xfzt,xfsj,xfms,sbtp,sbsp,gztp,gzsp,cjry,cjrq,xgry,xgrq,bz,kz1,kz2,kz3,kz4
			)values
			 ]]>  		 
			 <![CDATA[ 
				(
				#list[].xh#,#list[].xcdh#,#list[].xcsblx#,#list[].xcsbbh#,#list[].xcsbtdbh#,#list[].xcsbmc#,#list[].xcsbzt#,#list[].xfzt#,#list[].xfsj#,#list[].xfms#,#list[].sbtp#,#list[].sbsp#,#list[].gztp#,#list[].gzsp#,#list[].cjry#,#list[].cjrq#,#list[].xgry#,#list[].xgrq#,#list[].bz#,#list[].kz1#,#list[].kz2#,#list[].kz3#,#list[].kz4#
				)
			]]>    
    	</iterate> 
	</insert>
	
	
	
	<!-- 根据服务商编号查询关联交通设备信息  start-->
	<!-- 标线 -->
	<select id="listJtsbByFwsbh_bx" resultClass="java.util.HashMap" parameterClass="java.util.Map">
		select 
			a.bxbh as videonum,a.bxmc as channelname,a.bxpp as pp	
		from nhywjtbxgl a where 1=1
		<isNotEmpty prepend='AND ' property='LIKEchannelname'>
			(a.bxmc like '%$LIKEchannelname$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEvideonum'>
			(a.bxbh like '%$LIKEvideonum$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcdh'>
			(a.bxbh not in (select xcsbbh from nhywjtssxcsb where xcdh=#xcdh#) )
		</isNotEmpty>
	</select>
	<select id="countJtsbByFwsbh_bx" resultClass="java.lang.Integer" parameterClass="java.util.Map">
		select count(*) from nhywjtbxgl a where 1=1
		<isNotEmpty prepend='AND ' property='LIKEchannelname'>
			(a.bxmc like '%$LIKEchannelname$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEvideonum'>
			(a.bxbh like '%$LIKEvideonum$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcdh'>
			(a.bxbh not in (select xcsbbh from nhywjtssxcsb where xcdh=#xcdh#) )
		</isNotEmpty>
	</select>
	<!-- 标志 -->
	<select id="listJtsbByFwsbh_bz" resultClass="java.util.HashMap" parameterClass="java.util.Map">
		select 
			a.bzbh as videonum,a.bzmc as channelname,a.bzpp as pp	
		from nhywjtbzgl a where 1=1
		<isNotEmpty prepend='AND ' property='LIKEchannelname'>
			(a.bzmc like '%$LIKEchannelname$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEvideonum'>
			(a.bzbh like '%$LIKEvideonum$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcdh'>
			(a.bzbh not in (select xcsbbh from nhywjtssxcsb where xcdh=#xcdh#) )
		</isNotEmpty>
	</select>
	<select id="countJtsbByFwsbh_bz" resultClass="java.lang.Integer" parameterClass="java.util.Map">
		select count(*) from nhywjtbzgl a where 1=1
		<isNotEmpty prepend='AND ' property='LIKEchannelname'>
			(a.bzmc like '%$LIKEchannelname$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEvideonum'>
			(a.bzbh like '%$LIKEvideonum$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcdh'>
			(a.bzbh not in (select xcsbbh from nhywjtssxcsb where xcdh=#xcdh#) )
		</isNotEmpty>
	</select>
	<!-- 护栏 -->
	<select id="listJtsbByFwsbh_hl" resultClass="java.util.HashMap" parameterClass="java.util.Map">
		select 
			a.hlbh as videonum,a.hlmc as channelname,a.hlpp as pp	
		from nhywjthlgl a where 1=1
		<isNotEmpty prepend='AND ' property='LIKEchannelname'>
			(a.hlmc like '%$LIKEchannelname$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEvideonum'>
			(a.hlbh like '%$LIKEvideonum$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcdh'>
			(a.hlbh not in (select xcsbbh from nhywjtssxcsb where xcdh=#xcdh#) )
		</isNotEmpty>
	</select>
	<select id="countJtsbByFwsbh_hl" resultClass="java.lang.Integer" parameterClass="java.util.Map">
		select count(*) from nhywjthlgl a where 1=1
		<isNotEmpty prepend='AND ' property='LIKEchannelname'>
			(a.hlmc like '%$LIKEchannelname$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEvideonum'>
			(a.hlbh like '%$LIKEvideonum$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcdh'>
			(a.hlbh not in (select xcsbbh from nhywjtssxcsb where xcdh=#xcdh#) )
		</isNotEmpty>
	</select>
	<!-- 信号灯 -->
	<select id="listJtsbByFwsbh_xhd" resultClass="java.util.HashMap" parameterClass="java.util.Map">
		select 
			a.xhdbh as videonum,a.xhdmc as channelname,a.pp as pp	
		from nhywjtxhdgl a where 1=1
		<isNotEmpty prepend='AND ' property='LIKEchannelname'>
			(a.xhdmc like '%$LIKEchannelname$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEvideonum'>
			(a.xhdbh like '%$LIKEvideonum$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcdh'>
			(a.xhdbh not in (select xcsbbh from nhywjtssxcsb where xcdh=#xcdh#) )
		</isNotEmpty>
	</select>
	<select id="countJtsbByFwsbh_xhd" resultClass="java.lang.Integer" parameterClass="java.util.Map">
		select count(*) from nhywjtxhdgl a where 1=1
		<isNotEmpty prepend='AND ' property='LIKEchannelname'>
			(a.xhdmc like '%$LIKEchannelname$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEvideonum'>
			(a.xhdbh like '%$LIKEvideonum$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcdh'>
			(a.xhdbh not in (select xcsbbh from nhywjtssxcsb where xcdh=#xcdh#) )
		</isNotEmpty>
	</select>
	<!-- 诱导屏 -->
	<select id="listJtsbByFwsbh_ydp" resultClass="java.util.HashMap" parameterClass="java.util.Map">
		select 
			a.ledbh as videonum,a.ledmc as channelname,a.pp as pp	
		from nhywjtledydpgl a where 1=1
		<isNotEmpty prepend='AND ' property='LIKEchannelname'>
			(a.ledmc like '%$LIKEchannelname$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEvideonum'>
			(a.ledbh like '%$LIKEvideonum$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcdh'>
			(a.ledbh not in (select xcsbbh from nhywjtssxcsb where xcdh=#xcdh#) )
		</isNotEmpty>
	</select>
	<select id="countJtsbByFwsbh_ydp" resultClass="java.lang.Integer" parameterClass="java.util.Map">
		select count(*) from nhywjtledydpgl a where 1=1
		<isNotEmpty prepend='AND ' property='LIKEchannelname'>
			(a.ledmc like '%$LIKEchannelname$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEvideonum'>
			(a.ledbh like '%$LIKEvideonum$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcdh'>
			(a.ledbh not in (select xcsbbh from nhywjtssxcsb where xcdh=#xcdh#) )
		</isNotEmpty>
	</select>


	<!-- 地磁 -->
	<select id="listJtsbByFwsbh_dc" resultClass="java.util.HashMap" parameterClass="java.util.Map">
		select
		a.id as videonum,a.name as channelname,'' pp
		from its.ksh_detector a where detectortype='GVD'
		<isNotEmpty prepend='AND ' property='LIKEchannelname'>
			(a.name like '%$LIKEchannelname$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEvideonum'>
			(a.bianma like '%$LIKEvideonum$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcdh'>
			(a.id not in (select xcsbbh from nhywjtssxcsb where xcdh=#xcdh#) )
		</isNotEmpty>
	</select>
	<select id="countJtsbByFwsbh_dc" resultClass="java.lang.Integer" parameterClass="java.util.Map">
		select count(*) from its.ksh_detector a where detectortype='GVD'
		<isNotEmpty prepend='AND ' property='LIKEchannelname'>
			(a.name like '%$LIKEchannelname$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEvideonum'>
			(a.bianma like '%$LIKEvideonum$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcdh'>
			(a.id not in (select xcsbbh from nhywjtssxcsb where xcdh=#xcdh#) )
		</isNotEmpty>
	</select>

	<!-- 微波 -->
	<select id="listJtsbByFwsbh_wb" resultClass="java.util.HashMap" parameterClass="java.util.Map">
		select
		a.id as videonum,a.name as channelname,'' pp
		from its.ksh_detector a where detectortype='SMARTSENSOR'
		<isNotEmpty prepend='AND ' property='LIKEchannelname'>
			(a.name like '%$LIKEchannelname$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEvideonum'>
			(a.bianma like '%$LIKEvideonum$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcdh'>
			(a.id not in (select xcsbbh from nhywjtssxcsb where xcdh=#xcdh#) )
		</isNotEmpty>
	</select>
	<select id="countJtsbByFwsbh_wb" resultClass="java.lang.Integer" parameterClass="java.util.Map">
		select count(*) from its.ksh_detector a where detectortype='SMARTSENSOR'
		<isNotEmpty prepend='AND ' property='LIKEchannelname'>
			(a.name like '%$LIKEchannelname$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEvideonum'>
			(a.bianma like '%$LIKEvideonum$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcdh'>
			(a.id not in (select xcsbbh from nhywjtssxcsb where xcdh=#xcdh#) )
		</isNotEmpty>
	</select>

	<!-- 雷达 -->
	<select id="listJtsbByFwsbh_ld" resultClass="java.util.HashMap" parameterClass="java.util.Map">
		select
		a.xh as videonum,a.ldmc as channelname,'' pp
		from its.ksh_zxld a where 1=1
		<isNotEmpty prepend='AND ' property='LIKEchannelname'>
			(a.ldmc like '%$LIKEchannelname$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEvideonum'>
			(a.ldbh like '%$LIKEvideonum$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcdh'>
			(a.xh not in (select xcsbbh from nhywjtssxcsb where xcdh=#xcdh#) )
		</isNotEmpty>
	</select>
	<select id="countJtsbByFwsbh_ld" resultClass="java.lang.Integer" parameterClass="java.util.Map">
		select count(*) from its.ksh_zxld a where 1=1
		<isNotEmpty prepend='AND ' property='LIKEchannelname'>
			(a.ldmc like '%$LIKEchannelname$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='LIKEvideonum'>
			(a.ldbh like '%$LIKEvideonum$%'  )
		</isNotEmpty>
		<isNotEmpty prepend='AND ' property='xcdh'>
			(a.xh not in (select xcsbbh from nhywjtssxcsb where xcdh=#xcdh#) )
		</isNotEmpty>
	</select>
	<!-- 根据服务商编号查询关联交通设备信息  end-->
</sqlMap>











