<sqlMap><parameterMap id="gwParameters" class="map">
<parameter property="did" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="emp" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="org" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="file" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="ret" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/>
<parameter property="msg" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/>
<parameter property="retcount" jdbcType="BIGINT" javaType="java.lang.Long" mode="OUT"/>
</parameterMap><procedure id="YD_GW_SEND" parameterMap="gwParameters">
{call YD_GW.YD_GW_SEND(?,?,?,?,?,?,?)}
</procedure><!--查询是否阅读 -->
<select id="isread" parameterClass="java.util.HashMap" resultClass="com.yd.soa.comm.mydocument.mydocument.CountMyDoc">
<![CDATA[
select (select count(did)
from yd_gw_inceptdoc ygi, YD_GW_inceptRelation ygr
where ygi.incepter =#incepter#
and ygi.inceptid = ygr.inceptid
and toid = #incepter#
and ygr.isread = #isread#
and ygi.turningtype = 1) sp,
(select count(did)
from yd_gw_inceptdoc ygi, YD_GW_inceptRelation ygr
where ygi.incepter = #incepter#
and ygi.inceptid = ygr.inceptid
and toid =#incepter#
and ygr.isread = #isread#
and ygi.turningtype = 2) cb,
(select count(did)
from yd_gw_inceptdoc ygi, YD_GW_inceptRelation ygr
where ygi.incepter = #incepter#
and ygi.inceptid = ygr.inceptid
and toid = #incepter#
and ygr.isread = #isread#
and ygi.turningtype = 3) gz,
(select count(did)
from yd_gw_inceptdoc ygi, YD_GW_inceptRelation ygr
where ygi.incepter = #incepter#
and ygi.inceptid = ygr.inceptid
and toid = #incepter#
and ygr.isread = #isread#) hj
from dual
]]></select>
<parameter property="did" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="emp" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="org" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="file" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="ret" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/>
<parameter property="msg" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/>
<parameter property="retcount" jdbcType="BIGINT" javaType="java.lang.Long" mode="OUT"/>
</parameterMap><procedure id="YD_GW_SEND" parameterMap="gwParameters">
{call YD_GW.YD_GW_SEND(?,?,?,?,?,?,?)}
</procedure><!--查询是否阅读 -->
<select id="isread" parameterClass="java.util.HashMap" resultClass="com.yd.soa.comm.mydocument.mydocument.CountMyDoc">
<![CDATA[
select (select count(did)
from yd_gw_inceptdoc ygi, YD_GW_inceptRelation ygr
where ygi.incepter =#incepter#
and ygi.inceptid = ygr.inceptid
and toid = #incepter#
and ygr.isread = #isread#
and ygi.turningtype = 1) sp,
(select count(did)
from yd_gw_inceptdoc ygi, YD_GW_inceptRelation ygr
where ygi.incepter = #incepter#
and ygi.inceptid = ygr.inceptid
and toid =#incepter#
and ygr.isread = #isread#
and ygi.turningtype = 2) cb,
(select count(did)
from yd_gw_inceptdoc ygi, YD_GW_inceptRelation ygr
where ygi.incepter = #incepter#
and ygi.inceptid = ygr.inceptid
and toid = #incepter#
and ygr.isread = #isread#
and ygi.turningtype = 3) gz,
(select count(did)
from yd_gw_inceptdoc ygi, YD_GW_inceptRelation ygr
where ygi.incepter = #incepter#
and ygi.inceptid = ygr.inceptid
and toid = #incepter#
and ygr.isread = #isread#) hj
from dual
]]></select>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货