<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="cn.fenghuait.yzsl.mapper.GcAllInfoMapper">
<!-- 河道 -->
<resultMap id="GCRVMap" type="cn.fenghuait.yzsl.model.GcRv">
<id column="ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="ADUNCD" property="aduncd" jdbcType="CHAR" />
<result column="ADUNNM" property="adunnm" jdbcType="CHAR" />
<result column="ADUNPL" property="adunpl" jdbcType="CHAR" />
<!-- association – 映射到JavaBean 的某个"复杂类型"属性,其他JavaBean类. collection –复杂类型集合,a collection of complex types -->
<association property="gcDrarbsin" javaType="cn.fenghuait.yzsl.model.GcDrarbsin">
<id column="gcDrarbsin_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcDrarbsin_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcDrarbsin_RVRK" property="rvrk" jdbcType="CHAR" />
<result column="gcDrarbsin_RVUS" property="rvus" jdbcType="CHAR" />
<result column="gcDrarbsin_RVPL" property="rvpl" jdbcType="CHAR" />
<result column="gcDrarbsin_MDJMPL" property="mdjmpl" jdbcType="CHAR" />
<result column="gcDrarbsin_DWJMPL" property="dwjmpl" jdbcType="CHAR" />
<result column="gcDrarbsin_MNSTLN" property="mnstln" jdbcType="DECIMAL" />
<result column="gcDrarbsin_UPLN" property="upln" jdbcType="DECIMAL" />
<result column="gcDrarbsin_MDLN" property="mdln" jdbcType="DECIMAL" />
<result column="gcDrarbsin_DWLN" property="dwln" jdbcType="DECIMAL" />
<result column="gcDrarbsin_TREBN" property="trebn" jdbcType="DECIMAL" />
<result column="gcDrarbsin_TTDRBSAR" property="ttdrbsar" jdbcType="DECIMAL" />
<result column="gcDrarbsin_UPDRBSAR" property="updrbsar" jdbcType="DECIMAL" />
<result column="gcDrarbsin_MDDRBSAR" property="mddrbsar" jdbcType="DECIMAL" />
<result column="gcDrarbsin_LWDRBSAR" property="lwdrbsar" jdbcType="DECIMAL" />
<result column="gcDrarbsin_DRBSCTAR" property="drbsctar" jdbcType="DECIMAL" />
<result column="gcDrarbsin_DRBSHLAR" property="drbshlar" jdbcType="DECIMAL" />
<result column="gcDrarbsin_DRBSPLAR" property="drbsplar" jdbcType="DECIMAL" />
<result column="gcDrarbsin_DRBSLKAR" property="drbslkar" jdbcType="DECIMAL" />
<result column="gcDrarbsin_DRBSINAR" property="drbsinar" jdbcType="DECIMAL" />
<result column="gcDrarbsin_DRBSPP" property="drbspp" jdbcType="DECIMAL" />
</association>
<association property="gcPrnmsr" javaType="cn.fenghuait.yzsl.model.GcPrnmsr">
<id column="gcPrnmsr_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<result column="gcPrnmsr_ENNM" property="ennm" jdbcType="CHAR" />
<result column="gcPrnmsr_BIMP" property="bimp" jdbcType="CHAR" />
<result column="gcPrnmsr_ENIMG" property="enimg" jdbcType="CHAR" />
</association>
<collection property="gcRcbsinsList" ofType="cn.fenghuait.yzsl.model.GcRcbsin" javaType="ArrayList">
<id column="gcRcbsinsList_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcRcbsinsList_RCCD" property="rccd" jdbcType="CHAR" />
<id column="gcRcbsinsList_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcRcbsinsList_RVTP" property="rvtp" jdbcType="CHAR" />
<result column="gcRcbsinsList_CNAR" property="cnar" jdbcType="DECIMAL" />
<result column="gcRcbsinsList_RCLN" property="rcln" jdbcType="DECIMAL" />
<result column="gcRcbsinsList_ENBRNM" property="enbrnm" jdbcType="DECIMAL" />
<result column="gcRcbsinsList_CHAVWD" property="chavwd" jdbcType="DECIMAL" />
<result column="gcRcbsinsList_BTAVWD" property="btavwd" jdbcType="DECIMAL" />
<result column="gcRcbsinsList_HCHAR" property="hchar" jdbcType="DECIMAL" />
<result column="gcRcbsinsList_BTAR" property="btar" jdbcType="DECIMAL" />
<result column="gcRcbsinsList_CHFLDS" property="chflds" jdbcType="DECIMAL" />
<result column="gcRcbsinsList_RVAVSL" property="rvavsl" jdbcType="DECIMAL" />
<result column="gcRcbsinsList_CV" property="cv" jdbcType="DECIMAL" />
<result column="gcRcbsinsList_MXRVWD" property="mxrvwd" jdbcType="DECIMAL" />
<result column="gcRcbsinsList_MNRVWD" property="mnrvwd" jdbcType="DECIMAL" />
<result column="gcRcbsinsList_RM" property="rm" jdbcType="VARCHAR" />
</collection>
<collection property="gcRctrbschsList" ofType="cn.fenghuait.yzsl.model.GcRctrbsch" javaType="ArrayList">
<id column="gcRctrbschsList_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcRctrbschsList_CHTRCD" property="chtrcd" jdbcType="CHAR" />
<id column="gcRctrbschsList_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcRctrbschsList_EXDT" property="exdt" jdbcType="TIMESTAMP" />
<result column="gcRctrbschsList_TRNM" property="trnm" jdbcType="CHAR" />
<result column="gcRctrbschsList_TRDR" property="trdr" jdbcType="CHAR" />
<result column="gcRctrbschsList_TRATPL" property="tratpl" jdbcType="CHAR" />
<result column="gcRctrbschsList_INTRCD" property="intrcd" jdbcType="CHAR" />
<result column="gcRctrbschsList_TOINTRDS" property="tointrds" jdbcType="DECIMAL" />
<result column="gcRctrbschsList_CNSTCD" property="cnstcd" jdbcType="CHAR" />
<result column="gcRctrbschsList_LFBNCH" property="lfbnch" jdbcType="CHAR" />
<result column="gcRctrbschsList_LFBNPL" property="lfbnpl" jdbcType="CHAR" />
<result column="gcRctrbschsList_RGBNCH" property="rgbnch" jdbcType="CHAR" />
<result column="gcRctrbschsList_RGBNPL" property="rgbnpl" jdbcType="CHAR" />
<result column="gcRctrbschsList_BTWD" property="btwd" jdbcType="DECIMAL" />
<result column="gcRctrbschsList_CHWD" property="chwd" jdbcType="DECIMAL" />
<result column="gcRctrbschsList_BCAVEL" property="bcavel" jdbcType="DECIMAL" />
<result column="gcRctrbschsList_BECLSLTH" property="beclslth" jdbcType="DECIMAL" />
<result column="gcRctrbschsList_CHAVEL" property="chavel" jdbcType="DECIMAL" />
<result column="gcRctrbschsList_CHCLSLTH" property="chclslth" jdbcType="DECIMAL" />
<result column="gcRctrbschsList_CLSLINT" property="clslint" jdbcType="DECIMAL" />
<result column="gcRctrbschsList_MNCHEL" property="mnchel" jdbcType="DECIMAL" />
<result column="gcRctrbschsList_DSFLLV" property="dsfllv" jdbcType="DECIMAL" />
<result column="gcRctrbschsList_GNWTLV" property="gnwtlv" jdbcType="DECIMAL" />
<result column="gcRctrbschsList_ALWTLV" property="alwtlv" jdbcType="DECIMAL" />
<result column="gcRctrbschsList_ASHWL" property="ashwl" jdbcType="DECIMAL" />
<result column="gcRctrbschsList_ASHWLTM" property="ashwltm" jdbcType="TIMESTAMP" />
<result column="gcRctrbschsList_INHGWTLV" property="inhgwtlv" jdbcType="DECIMAL" />
<result column="gcRctrbschsList_IHFWLT" property="ihfwlt" jdbcType="TIMESTAMP" />
<result column="gcRctrbschsList_ASHFL" property="ashfl" jdbcType="DECIMAL" />
<result column="gcRctrbschsList_ASHFLTM" property="ashfltm" jdbcType="TIMESTAMP" />
<result column="gcRctrbschsList_ASLFL" property="aslfl" jdbcType="DECIMAL" />
<result column="gcRctrbschsList_ASLFLTM" property="aslfltm" jdbcType="TIMESTAMP" />
<result column="gcRctrbschsList_BEDLOAD" property="bedload" jdbcType="VARCHAR" />
<result column="gcRctrbschsList_CHSFDS" property="chsfds" jdbcType="DECIMAL" />
<result column="gcRctrbschsList_CHDKEL" property="chdkel" jdbcType="DECIMAL" />
<result column="gcRctrbschsList_RM" property="rm" jdbcType="VARCHAR" />
</collection>
<collection property="gcCnstList" ofType="cn.fenghuait.yzsl.model.GcCnst" javaType="ArrayList">
<id column="gcCnstList_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcCnstList_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcCnstList_ADUNCD" property="aduncd" jdbcType="CHAR" />
<result column="gcCnstList_ADUNNM" property="adunnm" jdbcType="CHAR" />
<result column="gcCnstList_ADUNPL" property="adunpl" jdbcType="CHAR" />
<result column="gcCnstList_STAD" property="stad" jdbcType="CHAR" />
<result column="gcCnstList_LGTD" property="lgtd" jdbcType="DECIMAL" />
<result column="gcCnstList_LTTD" property="lttd" jdbcType="DECIMAL" />
<result column="gcCnstList_STSTDT" property="ststdt" jdbcType="TIMESTAMP" />
<result column="gcCnstList_CNSTCFST" property="cnstcfst" jdbcType="CHAR" />
<result column="gcCnstList_CNSTTP" property="cnsttp" jdbcType="CHAR" />
<result column="gcCnstList_SRIT" property="srit" jdbcType="CHAR" />
<result column="gcCnstList_SRMS" property="srms" jdbcType="CHAR" />
<result column="gcCnstList_LVBSLV" property="lvbslv" jdbcType="CHAR" />
<result column="gcCnstList_DLBLP" property="dlblp" jdbcType="CHAR" />
<result column="gcCnstList_RM" property="rm" jdbcType="VARCHAR" />
<result column="gcCnstList_ENNM" property="ennm" jdbcType="VARCHAR" />
</collection>
<collection property="monitorsList" ofType="cn.fenghuait.yzsl.bean.Monitor" javaType="ArrayList">
<id column="monitorsList_id" property="id" jdbcType="INTEGER" />
<result column="monitorsList_ip" property="ip" jdbcType="VARCHAR" />
<result column="monitorsList_port" property="port" jdbcType="INTEGER" />
<result column="monitorsList_username" property="username" jdbcType="VARCHAR" />
<result column="monitorsList_password" property="password" jdbcType="VARCHAR" />
<result column="monitorsList_rm" property="rm" jdbcType="VARCHAR" />
<result column="monitorsList_create_date" property="create_date" jdbcType="TIMESTAMP" />
</collection>
</resultMap>
<!-- 堤防 -->
<resultMap id="GCDKMap" type="cn.fenghuait.yzsl.model.GcDk">
<id column="ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="ADUNCD" property="aduncd" jdbcType="CHAR" />
<result column="ADUNNM" property="adunnm" jdbcType="CHAR" />
<result column="ADUNPL" property="adunpl" jdbcType="CHAR" />
<result column="ATRCCD" property="atrccd" jdbcType="CHAR" />
<result column="DKCL" property="dkcl" jdbcType="CHAR" />
<result column="LVBSLV" property="lvbslv" jdbcType="CHAR" />
<result column="DLBLP" property="dlblp" jdbcType="CHAR" />
<result column="ENCRZRPL" property="encrzrpl" jdbcType="CHAR" />
<result column="ININ" property="inin" jdbcType="VARCHAR" />
<association property="gcBnbsin" javaType="cn.fenghuait.yzsl.model.GcBnbsin">
<id column="gcBnbsin_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcBnbsin_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcBnbsin_BNSCBGPL" property="bnscbgpl" jdbcType="CHAR" />
<result column="gcBnbsin_BNSCBGCH" property="bnscbgch" jdbcType="CHAR" />
<result column="gcBnbsin_BNSCENPL" property="bnscenpl" jdbcType="CHAR" />
<result column="gcBnbsin_BNSCENCH" property="bnscench" jdbcType="CHAR" />
<result column="gcBnbsin_BNSCLN" property="bnscln" jdbcType="DECIMAL" />
<result column="gcBnbsin_JMBNTPEL" property="jmbntpel" jdbcType="DECIMAL" />
<result column="gcBnbsin_ENBNTPEL" property="enbntpel" jdbcType="DECIMAL" />
<result column="gcBnbsin_MXDMHG" property="mxdmhg" jdbcType="DECIMAL" />
<result column="gcBnbsin_MXDMHGCH" property="mxdmhgch" jdbcType="CHAR" />
<result column="gcBnbsin_MXBNTPWD" property="mxbntpwd" jdbcType="DECIMAL" />
<result column="gcBnbsin_MBTWCH" property="mbtwch" jdbcType="CHAR" />
<result column="gcBnbsin_BNTPRDTP" property="bntprdtp" jdbcType="CHAR" />
<result column="gcBnbsin_LRSMXBDS" property="lrsmxbds" jdbcType="DECIMAL" />
<result column="gcBnbsin_LRSMNBDS" property="lrsmnbds" jdbcType="DECIMAL" />
<result column="gcBnbsin_PRSLNM" property="prslnm" jdbcType="DECIMAL" />
<result column="gcBnbsin_PRSLLN" property="prslln" jdbcType="DECIMAL" />
<result column="gcBnbsin_CNCLGTNM" property="cnclgtnm" jdbcType="DECIMAL" />
<result column="gcBnbsin_EXQS" property="exqs" jdbcType="VARCHAR" />
</association>
<association property="gcPrnmsr" javaType="cn.fenghuait.yzsl.model.GcPrnmsr">
<id column="gcPrnmsr_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<result column="gcPrnmsr_ENNM" property="ennm" jdbcType="CHAR" />
<result column="gcPrnmsr_BIMP" property="bimp" jdbcType="CHAR" />
<result column="gcPrnmsr_ENIMG" property="enimg" jdbcType="CHAR" />
</association>
<association property="gcBspfhn" javaType="cn.fenghuait.yzsl.model.GcBspfhn">
<id column="gcBspfhn_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcBspfhn_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcBspfhn_HSHGWTLV" property="hshgwtlv" jdbcType="DECIMAL" />
<result column="gcBspfhn_HHWLT" property="hhwlt" jdbcType="TIMESTAMP" />
<result column="gcBspfhn_HSMXFLFL" property="hsmxflfl" jdbcType="DECIMAL" />
<result column="gcBspfhn_HMXFLTMT" property="hmxfltmt" jdbcType="TIMESTAMP" />
<result column="gcBspfhn_RM" property="rm" jdbcType="VARCHAR" />
</association>
<association property="gcDbiabt" javaType="cn.fenghuait.yzsl.model.GcDbiabt">
<id column="gcDbiabt_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcDbiabt_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcDbiabt_PRAR" property="prar" jdbcType="DECIMAL" />
<result column="gcDbiabt_PRINAR" property="prinar" jdbcType="DECIMAL" />
<result column="gcDbiabt_PRVLNM" property="prvlnm" jdbcType="DECIMAL" />
<result column="gcDbiabt_PRFXASNM" property="prfxasnm" jdbcType="DECIMAL" />
<result column="gcDbiabt_PTPP" property="ptpp" jdbcType="DECIMAL" />
<result column="gcDbiabt_PRHUNM" property="prhunm" jdbcType="DECIMAL" />
<result column="gcDbiabt_PRFCMN" property="prfcmn" jdbcType="CHAR" />
<result column="gcDbiabt_PRCT" property="prct" jdbcType="CHAR" />
<result column="gcDbiabt_PRRL" property="prrl" jdbcType="CHAR" />
<result column="gcDbiabt_PRHG" property="prhg" jdbcType="CHAR" />
<result column="gcDbiabt_PRSTES" property="prstes" jdbcType="CHAR" />
<result column="gcDbiabt_RM" property="rm" jdbcType="VARCHAR" />
</association>
<association property="gcDkbc" javaType="cn.fenghuait.yzsl.model.GcDkbc">
<id column="gcDkbc_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcDkbc_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcDkbc_DSUNCD" property="dsuncd" jdbcType="CHAR" />
<result column="gcDkbc_DSUNNM" property="dsunnm" jdbcType="CHAR" />
<result column="gcDkbc_CONUNCD" property="conuncd" jdbcType="CHAR" />
<result column="gcDkbc_CONUNNM" property="conunnm" jdbcType="CHAR" />
<result column="gcDkbc_CONAPCD" property="conapcd" jdbcType="CHAR" />
<result column="gcDkbc_BLDUNCD" property="blduncd" jdbcType="CHAR" />
<result column="gcDkbc_BLDUNNM" property="bldunnm" jdbcType="CHAR" />
<result column="gcDkbc_MONUNCD" property="monuncd" jdbcType="CHAR" />
<result column="gcDkbc_MONUNNM" property="monunnm" jdbcType="CHAR" />
<result column="gcDkbc_CBUNCD" property="cbuncd" jdbcType="CHAR" />
<result column="gcDkbc_CBUNNM" property="cbunnm" jdbcType="CHAR" />
<result column="gcDkbc_QAUNCD" property="qauncd" jdbcType="CHAR" />
<result column="gcDkbc_QAUNNM" property="qaunnm" jdbcType="CHAR" />
<result column="gcDkbc_SWDT" property="swdt" jdbcType="TIMESTAMP" />
<result column="gcDkbc_CPLDT" property="cpldt" jdbcType="TIMESTAMP" />
<result column="gcDkbc_PRJKD" property="prjkd" jdbcType="CHAR" />
<result column="gcDkbc_PRJQTY" property="prjqty" jdbcType="CHAR" />
<result column="gcDkbc_PRJCOST" property="prjcost" jdbcType="DECIMAL" />
<result column="gcDkbc_CAEVCOST" property="caevcost" jdbcType="DECIMAL" />
<result column="gcDkbc_FSDT" property="fsdt" jdbcType="TIMESTAMP" />
<result column="gcDkbc_PRJRK" property="prjrk" jdbcType="CHAR" />
</association>
<association property="gcBsfst" javaType="cn.fenghuait.yzsl.model.GcBsfst">
<id column="gcBsfst_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcBsfst_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcBsfst_ERBSIN" property="erbsin" jdbcType="CHAR" />
<result column="gcBsfst_ERDSIN" property="erdsin" jdbcType="CHAR" />
<result column="gcBsfst_CNSTCD" property="cnstcd" jdbcType="CHAR" />
<result column="gcBsfst_DSCNFLST" property="dscnflst" jdbcType="CHAR" />
<result column="gcBsfst_DSFLLV" property="dsfllv" jdbcType="DECIMAL" />
<result column="gcBsfst_GNWTLV" property="gnwtlv" jdbcType="DECIMAL" />
<result column="gcBsfst_ALWTLV" property="alwtlv" jdbcType="DECIMAL" />
<result column="gcBsfst_RM" property="rm" jdbcType="VARCHAR" />
</association>
<association property="gcDkr" javaType="cn.fenghuait.yzsl.model.GcDkr">
<id column="gcDkr_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcDkr_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcDkr_RICS" property="rics" jdbcType="VARCHAR" />
<result column="gcDkr_RIDT" property="ridt" jdbcType="TIMESTAMP" />
<result column="gcDkr_RIPRJ" property="riprj" jdbcType="CHAR" />
<result column="gcDkr_RIDSUNCD" property="ridsuncd" jdbcType="CHAR" />
<result column="gcDkr_RIDSUNNM" property="ridsunnm" jdbcType="CHAR" />
<result column="gcDkr_RICONUNCD" property="riconuncd" jdbcType="CHAR" />
<result column="gcDkr_RICONUNNM" property="riconunnm" jdbcType="CHAR" />
<result column="gcDkr_RIBLDUNCD" property="riblduncd" jdbcType="CHAR" />
<result column="gcDkr_RIBLDUNNM" property="ribldunnm" jdbcType="CHAR" />
<result column="gcDkr_RIMONUNCD" property="rimonuncd" jdbcType="CHAR" />
<result column="gcDkr_RIMONUNNM" property="rimonunnm" jdbcType="CHAR" />
<result column="gcDkr_QAUNCD" property="qauncd" jdbcType="CHAR" />
<result column="gcDkr_QAUNNM" property="qaunnm" jdbcType="CHAR" />
<result column="gcDkr_RIPRIN" property="riprin" jdbcType="CHAR" />
<result column="gcDkr_RICT" property="rict" jdbcType="VARCHAR" />
<result column="gcDkr_RIPRJQTY" property="riprjqty" jdbcType="VARCHAR" />
<result column="gcDkr_RIPRJFIN" property="riprjfin" jdbcType="DECIMAL" />
<result column="gcDkr_RIBF" property="ribf" jdbcType="VARCHAR" />
</association>
<association property="gcDkscc" javaType="cn.fenghuait.yzsl.model.GcDkscc">
<id column="gcDkscc_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcDkscc_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcDkscc_ACUNCD" property="acuncd" jdbcType="CHAR" />
<result column="gcDkscc_ACUNNM" property="acunnm" jdbcType="CHAR" />
<result column="gcDkscc_SECACCL" property="secaccl" jdbcType="CHAR" />
<result column="gcDkscc_SECACCON" property="secaccon" jdbcType="VARCHAR" />
<result column="gcDkscc_RIOS" property="rios" jdbcType="VARCHAR" />
<result column="gcDkscc_ADUNCSOS" property="aduncsos" jdbcType="VARCHAR" />
</association>
<association property="gcDkancvdg" javaType="cn.fenghuait.yzsl.model.GcDkancvdg">
<id column="gcDkancvdg_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcDkancvdg_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcDkancvdg_ANCVDG" property="ancvdg" jdbcType="VARCHAR" />
<result column="gcDkancvdg_TMDGLIMCB" property="tmdglimcb" jdbcType="VARCHAR" />
<result column="gcDkancvdg_TMDGRCCB" property="tmdgrccb" jdbcType="VARCHAR" />
</association>
<association property="gcDkmgc" javaType="cn.fenghuait.yzsl.model.GcDkmgc">
<id column="gcDkmgc_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcDkmgc_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcDkmgc_ADUNKD" property="adunkd" jdbcType="CHAR" />
<result column="gcDkmgc_ADUNCD" property="aduncd" jdbcType="TIMESTAMP" />
<result column="gcDkmgc_ADUNNM" property="adunnm" jdbcType="CHAR" />
<result column="gcDkmgc_MGST" property="mgst" jdbcType="CHAR" />
<result column="gcDkmgc_MGFINSRC" property="mgfinsrc" jdbcType="CHAR" />
<result column="gcDkmgc_WKNUM" property="wknum" jdbcType="DECIMAL" />
<result column="gcDkmgc_SRVMG" property="srvmg" jdbcType="DECIMAL" />
<result column="gcDkmgc_EGMG" property="egmg" jdbcType="DECIMAL" />
<result column="gcDkmgc_BUSMG" property="busmg" jdbcType="DECIMAL" />
<result column="gcDkmgc_TOTINC" property="totinc" jdbcType="DECIMAL" />
<result column="gcDkmgc_WRINC" property="wrinc" jdbcType="DECIMAL" />
<result column="gcDkmgc_ERINC" property="erinc" jdbcType="DECIMAL" />
<result column="gcDkmgc_MIINC" property="miinc" jdbcType="DECIMAL" />
<result column="gcDkmgc_OPROE" property="oproe" jdbcType="DECIMAL" />
<result column="gcDkmgc_REPE" property="repe" jdbcType="DECIMAL" />
</association>
<collection property="gcBnbdcrprsList" ofType="cn.fenghuait.yzsl.model.GcBnbdcrpr" javaType="ArrayList">
<id column="gcBnbdcrprsList_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcBnbdcrprsList_BNTRCD" property="bntrcd" jdbcType="CHAR" />
<id column="gcBnbdcrprsList_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<id column="gcBnbdcrprsList_JMDS" property="jmds" jdbcType="DECIMAL" />
<id column="gcBnbdcrprsList_EXDT" property="exdt" jdbcType="TIMESTAMP" />
<result column="gcBnbdcrprsList_SRPNEL" property="srpnel" jdbcType="DECIMAL" />
</collection>
<collection property="monitorsList" ofType="cn.fenghuait.yzsl.bean.Monitor" javaType="ArrayList">
<id column="monitorsList_id" property="id" jdbcType="INTEGER" />
<result column="monitorsList_ip" property="ip" jdbcType="VARCHAR" />
<result column="monitorsList_port" property="port" jdbcType="INTEGER" />
<result column="monitorsList_username" property="username" jdbcType="VARCHAR" />
<result column="monitorsList_password" property="password" jdbcType="VARCHAR" />
<result column="monitorsList_rm" property="rm" jdbcType="VARCHAR" />
<result column="monitorsList_create_date" property="create_date" jdbcType="TIMESTAMP" />
</collection>
<collection property="gcDkhosList" ofType="cn.fenghuait.yzsl.model.GcDkhos" javaType="ArrayList">
<id column="gcDkhosList_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcDkhosList_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<id column="gcDkhosList_BRSPAG" property="brspag" jdbcType="CHAR" />
<result column="gcDkhosList_BRSPPL" property="brsppl" jdbcType="VARCHAR" />
<result column="gcDkhosList_INRN" property="inrn" jdbcType="CHAR" />
<result column="gcDkhosList_BRSPLS" property="brspls" jdbcType="VARCHAR" />
<result column="gcDkhosList_RPTM" property="rptm" jdbcType="TIMESTAMP" />
<result column="gcDkhosList_BSHVB" property="bshvb" jdbcType="VARCHAR" />
<result column="gcDkhosList_RM" property="rm" jdbcType="VARCHAR" />
</collection>
<collection property="gcCnstsList" ofType="cn.fenghuait.yzsl.model.GcCnst" javaType="ArrayList">
<id column="gcCnstsList_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcCnstsList_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcCnstsList_ADUNCD" property="aduncd" jdbcType="CHAR" />
<result column="gcCnstsList_ADUNNM" property="adunnm" jdbcType="CHAR" />
<result column="gcCnstsList_ADUNPL" property="adunpl" jdbcType="CHAR" />
<result column="gcCnstsList_STAD" property="stad" jdbcType="CHAR" />
<result column="gcCnstsList_LGTD" property="lgtd" jdbcType="DECIMAL" />
<result column="gcCnstsList_LTTD" property="lttd" jdbcType="DECIMAL" />
<result column="gcCnstsList_STSTDT" property="ststdt" jdbcType="TIMESTAMP" />
<result column="gcCnstsList_CNSTCFST" property="cnstcfst" jdbcType="CHAR" />
<result column="gcCnstsList_CNSTTP" property="cnsttp" jdbcType="CHAR" />
<result column="gcCnstsList_SRIT" property="srit" jdbcType="CHAR" />
<result column="gcCnstsList_SRMS" property="srms" jdbcType="CHAR" />
<result column="gcCnstsList_LVBSLV" property="lvbslv" jdbcType="CHAR" />
<result column="gcCnstsList_DLBLP" property="dlblp" jdbcType="CHAR" />
<result column="gcCnstsList_RM" property="rm" jdbcType="VARCHAR" />
<result column="gcCnstsList_ENNM" property="ennm" jdbcType="VARCHAR" />
<association property="gcCshct" javaType="cn.fenghuait.yzsl.model.GcCshct">
<id column="gcCnstsList_gcCshct_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcCnstsList_gcCshct_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcCnstsList_gcCshct_DSFLST" property="dsflst" jdbcType="CHAR" />
<result column="gcCnstsList_gcCshct_DSFLLV" property="dsfllv" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_DSFLFL" property="dsflfl" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_GNWTLV" property="gnwtlv" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_ASWLFL" property="aswlfl" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_ALWTLV" property="alwtlv" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_CHMXSFDS" property="chmxsfds" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_SRPNMXVL" property="srpnmxvl" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_SPMVT" property="spmvt" jdbcType="TIMESTAMP" />
<result column="gcCnstsList_gcCshct_ASHWL" property="ashwl" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_ASHWLTM" property="ashwltm" jdbcType="TIMESTAMP" />
<result column="gcCnstsList_gcCshct_ATSRMXFL" property="atsrmxfl" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_ASMFTM" property="asmftm" jdbcType="TIMESTAMP" />
<result column="gcCnstsList_gcCshct_INHGWTLV" property="inhgwtlv" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_IHFWLT" property="ihfwlt" jdbcType="TIMESTAMP" />
<result column="gcCnstsList_gcCshct_INMXFL" property="inmxfl" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_INMXFLTM" property="inmxfltm" jdbcType="TIMESTAMP" />
<result column="gcCnstsList_gcCshct_ACMXSDQT" property="acmxsdqt" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_ATMXSNQN" property="atmxsnqn" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_SRPNMNVL" property="srpnmnvl" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_SPMNVT" property="spmnvt" jdbcType="TIMESTAMP" />
<result column="gcCnstsList_gcCshct_ASLWL" property="aslwl" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_ASLWLTM" property="aslwltm" jdbcType="TIMESTAMP" />
<result column="gcCnstsList_gcCshct_ATSRMNFL" property="atsrmnfl" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_ASMNFTM" property="asmnftm" jdbcType="TIMESTAMP" />
<result column="gcCnstsList_gcCshct_INLWWTLV" property="inlwwtlv" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_INLWWLVTM" property="inlwwlvtm" jdbcType="TIMESTAMP" />
<result column="gcCnstsList_gcCshct_INMNFL" property="inmnfl" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_INMNFLTM" property="inmnfltm" jdbcType="TIMESTAMP" />
<result column="gcCnstsList_gcCshct_MXSDQT" property="mxsdqt" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_MXSDQTTM" property="mxsdqttm" jdbcType="TIMESTAMP" />
<result column="gcCnstsList_gcCshct_MNSDQT" property="mnsdqt" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcCshct_MNSDQTTM" property="mnsdqttm" jdbcType="TIMESTAMP" />
<result column="gcCnstsList_gcCshct_RM" property="rm" jdbcType="DECIMAL" />
</association>
<collection property="gcWtflrlsList" ofType="cn.fenghuait.yzsl.model.GcWtflrl" javaType="ArrayList">
<id column="gcCnstsList_gcWtflrlsList_EN" property="ennmcd" jdbcType="CHAR" />
<id column="gcCnstsList_gcWtflrlsList_IN" property="infndt" jdbcType="TIMESTAMP" />
<id column="gcCnstsList_gcWtflrlsList_WTLV" property="wtlv" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcWtflrlsList_FL" property="fl" jdbcType="DECIMAL" />
<result column="gcCnstsList_gcWtflrlsList_SRDT" property="srdt" jdbcType="TIMESTAMP" />
</collection>
</collection>
</resultMap>
<!-- 泵站 -->
<resultMap id="GCPUMPMap" type="cn.fenghuait.yzsl.model.GcPump">
<id column="ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="PLRVCD" property="plrvcd" jdbcType="CHAR" />
<result column="WLNCD" property="wlncd" jdbcType="CHAR" />
<result column="ENPL" property="enpl" jdbcType="CHAR" />
<result column="OPRKD" property="oprkd" jdbcType="CHAR" />
<result column="ADUNCD" property="aduncd" jdbcType="CHAR" />
<result column="ADUNNM" property="adunnm" jdbcType="CHAR" />
<result column="ADUNPL" property="adunpl" jdbcType="CHAR" />
<result column="OPPR" property="oppr" jdbcType="VARCHAR" />
<result column="LVBSLV" property="lvbslv" jdbcType="CHAR" />
<result column="DLBLP" property="dlblp" jdbcType="CHAR" />
<result column="CMDT" property="cmdt" jdbcType="TIMESTAMP" />
<result column="BGOPDT" property="bgopdt" jdbcType="TIMESTAMP" />
<result column="BSININ" property="bsinin" jdbcType="CHAR" />
<result column="RM" property="rm" jdbcType="VARCHAR" />
<association property="gcPrnmsr" javaType="cn.fenghuait.yzsl.model.GcPrnmsr">
<id column="gcPrnmsr_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<result column="gcPrnmsr_ENNM" property="ennm" jdbcType="CHAR" />
<result column="gcPrnmsr_BIMP" property="bimp" jdbcType="CHAR" />
<result column="gcPrnmsr_ENIMG" property="enimg" jdbcType="CHAR" />
</association>
<association property="gcPumpbi" javaType="cn.fenghuait.yzsl.model.GcPumpbi">
<id column="gcPumpbi_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcPumpbi_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcPumpbi_PSSCL" property="psscl" jdbcType="CHAR" />
<result column="gcPumpbi_PSCL" property="pscl" jdbcType="CHAR" />
<result column="gcPumpbi_MBCL" property="mbcl" jdbcType="CHAR" />
<result column="gcPumpbi_DSBBFLDSTD" property="dsbbfldstd" jdbcType="CHAR" />
<result column="gcPumpbi_CHBBFLDSTD" property="chbbfldstd" jdbcType="CHAR" />
<result column="gcPumpbi_STTLN" property="sttln" jdbcType="DECIMAL" />
<result column="gcPumpbi_STTWD" property="sttwd" jdbcType="DECIMAL" />
<result column="gcPumpbi_INCP" property="incp" jdbcType="DECIMAL" />
<result column="gcPumpbi_INNUM" property="innum" jdbcType="DECIMAL" />
<result column="gcPumpbi_INFL" property="infl" jdbcType="DECIMAL" />
<result column="gcPumpbi_DSDIST" property="dsdist" jdbcType="DECIMAL" />
<result column="gcPumpbi_PUMPT" property="pumpt" jdbcType="CHAR" />
<result column="gcPumpbi_PUMPNUM" property="pumpnum" jdbcType="DECIMAL" />
<result column="gcPumpbi_PUMPRV" property="pumprv" jdbcType="DECIMAL" />
<result column="gcPumpbi_PUMPDRVMAN" property="pumpdrvman" jdbcType="CHAR" />
<result column="gcPumpbi_GENT" property="gent" jdbcType="CHAR" />
<result column="gcPumpbi_GENNUM" property="gennum" jdbcType="DECIMAL" />
<result column="gcPumpbi_GENPW" property="genpw" jdbcType="DECIMAL" />
<result column="gcPumpbi_GENVLT" property="genvlt" jdbcType="DECIMAL" />
<result column="gcPumpbi_GENRV" property="genrv" jdbcType="DECIMAL" />
<result column="gcPumpbi_TFT" property="tft" jdbcType="CHAR" />
<result column="gcPumpbi_TFCP" property="tfcp" jdbcType="DECIMAL" />
<result column="gcPumpbi_TFNUM" property="tfnum" jdbcType="DECIMAL" />
<result column="gcPumpbi_LNVLT" property="lnvlt" jdbcType="DECIMAL" />
<result column="gcPumpbi_TFSS" property="tfss" jdbcType="CHAR" />
<result column="gcPumpbi_LFTDEVT" property="lftdevt" jdbcType="CHAR" />
<result column="gcPumpbi_LFTDEVCP" property="lftdevcp" jdbcType="CHAR" />
<result column="gcPumpbi_CUTFLMAN" property="cutflman" jdbcType="CHAR" />
<result column="gcPumpbi_UPSLST" property="upslst" jdbcType="CHAR" />
<result column="gcPumpbi_LWSLST" property="lwslst" jdbcType="CHAR" />
<result column="gcPumpbi_UPSLMTT" property="upslmtt" jdbcType="CHAR" />
<result column="gcPumpbi_LWSLMTT" property="lwslmtt" jdbcType="CHAR" />
<result column="gcPumpbi_INWCHNLT" property="inwchnlt" jdbcType="CHAR" />
<result column="gcPumpbi_OWCHNLT" property="owchnlt" jdbcType="CHAR" />
<result column="gcPumpbi_SHBHL" property="shbhl" jdbcType="DECIMAL" />
<result column="gcPumpbi_PUMPHL" property="pumphl" jdbcType="DECIMAL" />
<result column="gcPumpbi_GENHL" property="genhl" jdbcType="DECIMAL" />
<result column="gcPumpbi_VSHHL" property="vshhl" jdbcType="DECIMAL" />
<result column="gcPumpbi_RTCENHL" property="rtcenhl" jdbcType="DECIMAL" />
<result column="gcPumpbi_UPHL" property="uphl" jdbcType="DECIMAL" />
<result column="gcPumpbi_LWHL" property="lwhl" jdbcType="DECIMAL" />
<result column="gcPumpbi_HMPBHL" property="hmpbhl" jdbcType="DECIMAL" />
<result column="gcPumpbi_BRGWD" property="brgwd" jdbcType="DECIMAL" />
<result column="gcPumpbi_BRGHL" property="brghl" jdbcType="DECIMAL" />
<result column="gcPumpbi_BRGLD" property="brgld" jdbcType="DECIMAL" />
<result column="gcPumpbi_BRGBLV" property="brgblv" jdbcType="DECIMAL" />
<result column="gcPumpbi_DSUPWL" property="dsupwl" jdbcType="DECIMAL" />
<result column="gcPumpbi_DSLWWL" property="dslwwl" jdbcType="DECIMAL" />
<result column="gcPumpbi_CHUPWL" property="chupwl" jdbcType="DECIMAL" />
<result column="gcPumpbi_CHLWWL" property="chlwwl" jdbcType="DECIMAL" />
<result column="gcPumpbi_GEOLIN" property="geolin" jdbcType="CHAR" />
<result column="gcPumpbi_WTSRIT" property="wtsrit" jdbcType="CHAR" />
<result column="gcPumpbi_RM" property="rm" jdbcType="VARCHAR" />
</association>
<association property="gcPumpmgc" javaType="cn.fenghuait.yzsl.model.GcPumpmgc">
<id column="gcPumpmgc_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcPumpmgc_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcPumpmgc_ADUNKD" property="adunkd" jdbcType="CHAR" />
<result column="gcPumpmgc_ADUNCD" property="aduncd" jdbcType="TIMESTAMP" />
<result column="gcPumpmgc_ADUNNM" property="adunnm" jdbcType="CHAR" />
<result column="gcPumpmgc_MGST" property="mgst" jdbcType="CHAR" />
<result column="gcPumpmgc_MGFINSRC" property="mgfinsrc" jdbcType="CHAR" />
<result column="gcPumpmgc_WKNUM" property="wknum" jdbcType="DECIMAL" />
<result column="gcPumpmgc_SRVMG" property="srvmg" jdbcType="DECIMAL" />
<result column="gcPumpmgc_EGMG" property="egmg" jdbcType="DECIMAL" />
<result column="gcPumpmgc_BUSMG" property="busmg" jdbcType="DECIMAL" />
<result column="gcPumpmgc_TOTINC" property="totinc" jdbcType="DECIMAL" />
<result column="gcPumpmgc_WRINC" property="wrinc" jdbcType="DECIMAL" />
<result column="gcPumpmgc_ERINC" property="erinc" jdbcType="DECIMAL" />
<result column="gcPumpmgc_MIINC" property="miinc" jdbcType="DECIMAL" />
<result column="gcPumpmgc_OPROE" property="oproe" jdbcType="DECIMAL" />
<result column="gcPumpmgc_REPEDE" property="repede" jdbcType="DECIMAL" />
</association>
<association property="gcPumpbc" javaType="cn.fenghuait.yzsl.model.GcPumpbc">
<id column="gcPumpbc_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcPumpbc_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcPumpbc_DSUNNM" property="dsunnm" jdbcType="CHAR" />
<result column="gcPumpbc_CONUNCD" property="conuncd" jdbcType="CHAR" />
<result column="gcPumpbc_CONUNNM" property="conunnm" jdbcType="CHAR" />
<result column="gcPumpbc_CONAPCD" property="conapcd" jdbcType="CHAR" />
<result column="gcPumpbc_BLDUNCD" property="blduncd" jdbcType="CHAR" />
<result column="gcPumpbc_BLDUNNM" property="bldunnm" jdbcType="CHAR" />
<result column="gcPumpbc_MONUNCD" property="monuncd" jdbcType="CHAR" />
<result column="gcPumpbc_MONUNNM" property="monunnm" jdbcType="CHAR" />
<result column="gcPumpbc_CBUNCD" property="cbuncd" jdbcType="CHAR" />
<result column="gcPumpbc_CBUNNM" property="cbunnm" jdbcType="CHAR" />
<result column="gcPumpbc_QAUNCD" property="qauncd" jdbcType="CHAR" />
<result column="gcPumpbc_QAUNNM" property="qaunnm" jdbcType="CHAR" />
<result column="gcPumpbc_SWDT" property="swdt" jdbcType="TIMESTAMP" />
<result column="gcPumpbc_CPLDT" property="cpldt" jdbcType="TIMESTAMP" />
<result column="gcPumpbc_PRJKD" property="prjkd" jdbcType="CHAR" />
<result column="gcPumpbc_PRJQTY" property="prjqty" jdbcType="CHAR" />
<result column="gcPumpbc_PRJCOST" property="prjcost" jdbcType="DECIMAL" />
<result column="gcPumpbc_CAEVCOST" property="caevcost" jdbcType="DECIMAL" />
<result column="gcPumpbc_FSDT" property="fsdt" jdbcType="TIMESTAMP" />
<result column="gcPumpbc_PRJRK" property="prjrk" jdbcType="CHAR" />
</association>
<association property="gcPumpr" javaType="cn.fenghuait.yzsl.model.GcPumpr">
<id column="gcPumpr_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcPumpr_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcPumpr_RICS" property="rics" jdbcType="VARCHAR" />
<result column="gcPumpr_RIDT" property="ridt" jdbcType="TIMESTAMP" />
<result column="gcPumpr_RIPRJ" property="riprj" jdbcType="CHAR" />
<result column="gcPumpr_RIDSUNCD" property="ridsuncd" jdbcType="CHAR" />
<result column="gcPumpr_RIDSUNNM" property="ridsunnm" jdbcType="CHAR" />
<result column="gcPumpr_RICONUNCD" property="riconuncd" jdbcType="CHAR" />
<result column="gcPumpr_RICONUNNM" property="riconunnm" jdbcType="CHAR" />
<result column="gcPumpr_RIBLDUNCD" property="riblduncd" jdbcType="CHAR" />
<result column="gcPumpr_RIBLDUNNM" property="ribldunnm" jdbcType="CHAR" />
<result column="gcPumpr_RIMONUNCD" property="rimonuncd" jdbcType="CHAR" />
<result column="gcPumpr_RIMONUNNM" property="rimonunnm" jdbcType="CHAR" />
<result column="gcPumpr_QAUNCD" property="qauncd" jdbcType="CHAR" />
<result column="gcPumpr_QAUNNM" property="qaunnm" jdbcType="CHAR" />
<result column="gcPumpr_RIPRIN" property="riprin" jdbcType="CHAR" />
<result column="gcPumpr_RICT" property="rict" jdbcType="VARCHAR" />
<result column="gcPumpr_RIPRJQTY" property="riprjqty" jdbcType="VARCHAR" />
<result column="gcPumpr_RIPRJFIN" property="riprjfin" jdbcType="DECIMAL" />
<result column="gcPumpr_RIBF" property="ribf" jdbcType="VARCHAR" />
</association>
<association property="gcPumpscc" javaType="cn.fenghuait.yzsl.model.GcPumpscc">
<id column="gcPumpscc_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcPumpscc_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcPumpscc_ACUNCD" property="acuncd" jdbcType="CHAR" />
<result column="gcPumpscc_ACUNNM" property="acunnm" jdbcType="CHAR" />
<result column="gcPumpscc_SECACCL" property="secaccl" jdbcType="CHAR" />
<result column="gcPumpscc_SECACCON" property="secaccon" jdbcType="VARCHAR" />
<result column="gcPumpscc_RIOS" property="rios" jdbcType="VARCHAR" />
<result column="gcPumpscc_ADUNCSOS" property="aduncsos" jdbcType="VARCHAR" />
</association>
<collection property="gcWaterlinesList" javaType="cn.fenghuait.yzsl.model.GcWaterline">
<id column="gcWaterlinesList_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcWaterlinesList_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcWaterlinesList_ENNM" property="ennm" jdbcType="CHAR" />
<result column="gcWaterlinesList_ENLEN" property="enlen" jdbcType="DECIMAL" />
<result column="gcWaterlinesList_RMWTAR" property="rmwtar" jdbcType="DECIMAL" />
<result column="gcWaterlinesList_IRAR" property="irar" jdbcType="DECIMAL" />
<result column="gcWaterlinesList_ADUNNM" property="adunnm" jdbcType="CHAR" />
<result column="gcWaterlinesList_ADUNPL" property="adunpl" jdbcType="CHAR" />
<result column="gcWaterlinesList_STPNUM" property="stpnum" jdbcType="DECIMAL" />
<result column="gcWaterlinesList_SPNPL" property="spnpl" jdbcType="VARCHAR" />
<result column="gcWaterlinesList_CMDT" property="cmdt" jdbcType="TIMESTAMP" />
<result column="gcWaterlinesList_BGOPDT" property="bgopdt" jdbcType="TIMESTAMP" />
<result column="gcWaterlinesList_BSININ" property="bsinin" jdbcType="VARCHAR" />
<result column="gcWaterlinesList_RM" property="rm" jdbcType="VARCHAR" />
</collection>
<collection property="monitorsList" ofType="cn.fenghuait.yzsl.bean.Monitor" javaType="ArrayList">
<id column="monitorsList_id" property="id" jdbcType="INTEGER" />
<result column="monitorsList_ip" property="ip" jdbcType="VARCHAR" />
<result column="monitorsList_port" property="port" jdbcType="INTEGER" />
<result column="monitorsList_username" property="username" jdbcType="VARCHAR" />
<result column="monitorsList_password" property="password" jdbcType="VARCHAR" />
<result column="monitorsList_rm" property="rm" jdbcType="VARCHAR" />
<result column="monitorsList_create_date" property="create_date" jdbcType="TIMESTAMP" />
</collection>
</resultMap>
<!-- 水闸 -->
<resultMap id="GCSLMap" type="cn.fenghuait.yzsl.model.GcSl">
<id column="ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="ADUNCD" property="aduncd" jdbcType="CHAR" />
<result column="ADUNNM" property="adunnm" jdbcType="CHAR" />
<result column="ADUNPL" property="adunpl" jdbcType="CHAR" />
<result column="CMDT" property="cmdt" jdbcType="TIMESTAMP" />
<result column="GTCL" property="gtcl" jdbcType="CHAR" />
<result column="LVBSLV" property="lvbslv" jdbcType="CHAR" />
<result column="DLBLP" property="dlblp" jdbcType="CHAR" />
<result column="ENCRZRPL" property="encrzrpl" jdbcType="CHAR" />
<result column="ENPL" property="enpl" jdbcType="CHAR" />
<result column="ATRVCD" property="atrvcd" jdbcType="CHAR" />
<result column="RM" property="rm" jdbcType="VARCHAR" />
<association property="gcPrnmsr" javaType="cn.fenghuait.yzsl.model.GcPrnmsr">
<id column="gcPrnmsr_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<result column="gcPrnmsr_ENNM" property="ennm" jdbcType="CHAR" />
<result column="gcPrnmsr_BIMP" property="bimp" jdbcType="CHAR" />
<result column="gcPrnmsr_ENIMG" property="enimg" jdbcType="CHAR" />
</association>
<association property="gcSlhypr" javaType="cn.fenghuait.yzsl.model.GcSlhypr">
<id column="gcSlhypr_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcSlhypr_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcSlhypr_DGUWLV" property="dguwlv" jdbcType="DECIMAL" />
<result column="gcSlhypr_DGDWLV" property="dgdwlv" jdbcType="DECIMAL" />
<result column="gcSlhypr_DSEXGTFL" property="dsexgtfl" jdbcType="DECIMAL" />
<result column="gcSlhypr_DSFLST" property="dsflst" jdbcType="CHAR" />
<result column="gcSlhypr_DCGUWLV" property="dcguwlv" jdbcType="DECIMAL" />
<result column="gcSlhypr_DCGDWLV" property="dcgdwlv" jdbcType="DECIMAL" />
<result column="gcSlhypr_DCEGFL" property="dcegfl" jdbcType="DECIMAL" />
<result column="gcSlhypr_CHCNST" property="chcnst" jdbcType="CHAR" />
<result column="gcSlhypr_CGUWLV" property="cguwlv" jdbcType="DECIMAL" />
<result column="gcSlhypr_CGDWLV" property="cgdwlv" jdbcType="DECIMAL" />
<result column="gcSlhypr_CHEXGTFL" property="chexgtfl" jdbcType="DECIMAL" />
<result column="gcSlhypr_RM" property="rm" jdbcType="VARCHAR" />
</association>
<association property="gcSlprch" javaType="cn.fenghuait.yzsl.model.GcSlprch">
<id column="gcSlprch_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcSlprch_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcSlprch_HNCM" property="hncm" jdbcType="VARCHAR" />
<result column="gcSlprch_OPPR" property="oppr" jdbcType="VARCHAR" />
<result column="gcSlprch_GTBSGL" property="gtbsgl" jdbcType="VARCHAR" />
<result column="gcSlprch_ERBSIN" property="erbsin" jdbcType="CHAR" />
<result column="gcSlprch_ERDSIN" property="erdsin" jdbcType="CHAR" />
<result column="gcSlprch_GLEPCRX" property="glepcrx" jdbcType="CHAR" />
<result column="gcSlprch_GLEPCRY" property="glepcry" jdbcType="CHAR" />
<result column="gcSlprch_GLEPLN" property="glepln" jdbcType="DECIMAL" />
<result column="gcSlprch_GLEPLT" property="gleplt" jdbcType="DECIMAL" />
<result column="gcSlprch_GUBTEL" property="gubtel" jdbcType="DECIMAL" />
<result column="gcSlprch_GDBTEL" property="gdbtel" jdbcType="DECIMAL" />
<result column="gcSlprch_GTBDSTTP" property="gtbdsttp" jdbcType="CHAR" />
<result column="gcSlprch_GTMTEL" property="gtmtel" jdbcType="DECIMAL" />
<result column="gcSlprch_ENDSTP" property="endstp" jdbcType="CHAR" />
<result column="gcSlprch_GTORNM" property="gtornm" jdbcType="DECIMAL" />
<result column="gcSlprch_GTORSZ" property="gtorsz" jdbcType="DECIMAL" />
<result column="gcSlprch_GTORHG" property="gtorhg" jdbcType="DECIMAL" />
<result column="gcSlprch_OFBTLN" property="ofbtln" jdbcType="DECIMAL" />
<result column="gcSlprch_STTPHG" property="sttphg" jdbcType="DECIMAL" />
<result column="gcSlprch_SRTP" property="srtp" jdbcType="CHAR" />
<result column="gcSlprch_HDGRTP" property="hdgrtp" jdbcType="CHAR" />
<result column="gcSlprch_HDGRNM" property="hdgrnm" jdbcType="CHAR" />
<result column="gcSlprch_OPSHFR" property="opshfr" jdbcType="CHAR" />
<result column="gcSlprch_HGSPSP" property="hgspsp" jdbcType="CHAR" />
<result column="gcSlprch_STFLOPTM" property="stfloptm" jdbcType="DECIMAL" />
<result column="gcSlprch_EXQS" property="exqs" jdbcType="VARCHAR" />
</association>
<association property="gcSlbsbn" javaType="cn.fenghuait.yzsl.model.GcSlbsbn">
<id column="gcSlbsbn_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcSlbsbn_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcSlbsbn_DCFTPRPP" property="dcftprpp" jdbcType="DECIMAL" />
<result column="gcSlbsbn_DCFTPRAR" property="dcftprar" jdbcType="DECIMAL" />
<result column="gcSlbsbn_DSIRAR" property="dsirar" jdbcType="DECIMAL" />
<result column="gcSlbsbn_ACIRAR" property="acirar" jdbcType="DECIMAL" />
<result column="gcSlbsbn_DSRMWTST" property="dsrmwtst" jdbcType="CHAR" />
<result column="gcSlbsbn_DSRMWTAR" property="dsrmwtar" jdbcType="DECIMAL" />
<result column="gcSlbsbn_ACRMWTAR" property="acrmwtar" jdbcType="DECIMAL" />
<result column="gcSlbsbn_RM" property="rm" jdbcType="VARCHAR" />
</association>
<association property="gcSlhsusnt" javaType="cn.fenghuait.yzsl.model.GcSlhsusnt">
<id column="gcSlhsusnt_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcSlhsusnt_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcSlhsusnt_OPBGTM" property="opbgtm" jdbcType="TIMESTAMP" />
<result column="gcSlhsusnt_HMXFPFL" property="hmxfpfl" jdbcType="DECIMAL" />
<result column="gcSlhsusnt_HMXFLTMT" property="hmxfltmt" jdbcType="TIMESTAMP" />
<result column="gcSlhsusnt_AOMEGFL" property="aomegfl" jdbcType="DECIMAL" />
<result column="gcSlhsusnt_AOMEGFDT" property="aomegfdt" jdbcType="TIMESTAMP" />
<result column="gcSlhsusnt_AOGUHWLV" property="aoguhwlv" jdbcType="DECIMAL" />
<result column="gcSlhsusnt_AOGUHWLD" property="aoguhwld" jdbcType="TIMESTAMP" />
<result column="gcSlhsusnt_AOGULWLV" property="aogulwlv" jdbcType="DECIMAL" />
<result column="gcSlhsusnt_AOGULWLD" property="aogulwld" jdbcType="TIMESTAMP" />
<result column="gcSlhsusnt_AOGDHWLV" property="aogdhwlv" jdbcType="DECIMAL" />
<result column="gcSlhsusnt_AOGDHWLD" property="aogdhwld" jdbcType="TIMESTAMP" />
<result column="gcSlhsusnt_AOGDLWLV" property="aogdlwlv" jdbcType="DECIMAL" />
<result column="gcSlhsusnt_AOGDLWLD" property="aogdlwld" jdbcType="TIMESTAMP" />
<result column="gcSlhsusnt_MNIN" property="mnin" jdbcType="CHAR" />
<result column="gcSlhsusnt_RPIN" property="rpin" jdbcType="CHAR" />
<result column="gcSlhsusnt_RM" property="rm" jdbcType="VARCHAR" />
</association>
<association property="gcSlbc" javaType="cn.fenghuait.yzsl.model.GcSlbc">
<id column="gcSlbc_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcSlbc_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcSlbc_DSUNCD" property="dsuncd" jdbcType="CHAR" />
<result column="gcSlbc_DSUNNM" property="dsunnm" jdbcType="CHAR" />
<result column="gcSlbc_CONUNCD" property="conuncd" jdbcType="CHAR" />
<result column="gcSlbc_CONUNNM" property="conunnm" jdbcType="CHAR" />
<result column="gcSlbc_CONAPCD" property="conapcd" jdbcType="CHAR" />
<result column="gcSlbc_BLDUNCD" property="blduncd" jdbcType="CHAR" />
<result column="gcSlbc_BLDUNNM" property="bldunnm" jdbcType="CHAR" />
<result column="gcSlbc_MONUNCD" property="monuncd" jdbcType="CHAR" />
<result column="gcSlbc_MONUNNM" property="monunnm" jdbcType="CHAR" />
<result column="gcSlbc_CBUNCD" property="cbuncd" jdbcType="CHAR" />
<result column="gcSlbc_CBUNNM" property="cbunnm" jdbcType="CHAR" />
<result column="gcSlbc_QAUNCD" property="qauncd" jdbcType="CHAR" />
<result column="gcSlbc_QAUNNM" property="qaunnm" jdbcType="CHAR" />
<result column="gcSlbc_SWDT" property="swdt" jdbcType="TIMESTAMP" />
<result column="gcSlbc_CPLDT" property="cpldt" jdbcType="TIMESTAMP" />
<result column="gcSlbc_PRJKD" property="prjkd" jdbcType="CHAR" />
<result column="gcSlbc_PRJQTY" property="prjqty" jdbcType="CHAR" />
<result column="gcSlbc_PRJCOST" property="prjcost" jdbcType="DECIMAL" />
<result column="gcSlbc_CAEVCOST" property="caevcost" jdbcType="DECIMAL" />
<result column="gcSlbc_FSDT" property="fsdt" jdbcType="TIMESTAMP" />
</association>
<association property="gcSlr" javaType="cn.fenghuait.yzsl.model.GcSlr">
<id column="gcSlr_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcSlr_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcSlr_RICS" property="rics" jdbcType="VARCHAR" />
<result column="gcSlr_RIDT" property="ridt" jdbcType="TIMESTAMP" />
<result column="gcSlr_RIPRJ" property="riprj" jdbcType="CHAR" />
<result column="gcSlr_RIDSUNCD" property="ridsuncd" jdbcType="CHAR" />
<result column="gcSlr_RIDSUNNM" property="ridsunnm" jdbcType="CHAR" />
<result column="gcSlr_RICONUNCD" property="riconuncd" jdbcType="CHAR" />
<result column="gcSlr_RICONUNNM" property="riconunnm" jdbcType="CHAR" />
<result column="gcSlr_RIBLDUNCD" property="riblduncd" jdbcType="CHAR" />
<result column="gcSlr_RIBLDUNNM" property="ribldunnm" jdbcType="CHAR" />
<result column="gcSlr_RIMONUNCD" property="rimonuncd" jdbcType="CHAR" />
<result column="gcSlr_RIMONUNNM" property="rimonunnm" jdbcType="CHAR" />
<result column="gcSlr_QAUNCD" property="qauncd" jdbcType="CHAR" />
<result column="gcSlr_QAUNNM" property="qaunnm" jdbcType="CHAR" />
<result column="gcSlr_RIPRIN" property="riprin" jdbcType="CHAR" />
<result column="gcSlr_RICT" property="rict" jdbcType="VARCHAR" />
<result column="gcSlr_RIPRJQTY" property="riprjqty" jdbcType="VARCHAR" />
<result column="gcSlr_RIPRJFIN" property="riprjfin" jdbcType="DECIMAL" />
<result column="gcSlr_RIBF" property="ribf" jdbcType="VARCHAR" />
</association>
<association property="gcSlscc" javaType="cn.fenghuait.yzsl.model.GcSlscc">
<id column="gcSlscc_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcSlscc_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcSlscc_ACUNCD" property="acuncd" jdbcType="CHAR" />
<result column="gcSlscc_ACUNNM" property="acunnm" jdbcType="CHAR" />
<result column="gcSlscc_SECACCL" property="secaccl" jdbcType="CHAR" />
<result column="gcSlscc_SECACCON" property="secaccon" jdbcType="VARCHAR" />
<result column="gcSlscc_RIOS" property="rios" jdbcType="VARCHAR" />
<result column="gcSlscc_ADUNCSOS" property="aduncsos" jdbcType="VARCHAR" />
</association>
<association property="gcSlmgc" javaType="cn.fenghuait.yzsl.model.GcSlmgc">
<id column="gcSlmgc_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcSlmgc_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcSlmgc_ADUNKD" property="adunkd" jdbcType="CHAR" />
<result column="gcSlmgc_ADUNCD" property="aduncd" jdbcType="TIMESTAMP" />
<result column="gcSlmgc_ADUNNM" property="adunnm" jdbcType="CHAR" />
<result column="gcSlmgc_MGST" property="mgst" jdbcType="CHAR" />
<result column="gcSlmgc_MGFINSRC" property="mgfinsrc" jdbcType="CHAR" />
<result column="gcSlmgc_WKNUM" property="wknum" jdbcType="DECIMAL" />
<result column="gcSlmgc_SRVMG" property="srvmg" jdbcType="DECIMAL" />
<result column="gcSlmgc_EGMG" property="egmg" jdbcType="DECIMAL" />
<result column="gcSlmgc_BUSMG" property="busmg" jdbcType="DECIMAL" />
<result column="gcSlmgc_TOTINC" property="totinc" jdbcType="DECIMAL" />
<result column="gcSlmgc_WRINC" property="wrinc" jdbcType="DECIMAL" />
<result column="gcSlmgc_ERINC" property="erinc" jdbcType="DECIMAL" />
<result column="gcSlmgc_MIINC" property="miinc" jdbcType="DECIMAL" />
<result column="gcSlmgc_OPROE" property="oproe" jdbcType="DECIMAL" />
<result column="gcSldswlcbn_EPEDE " property="repede" jdbcType="DECIMAL" />
</association>
<association property="gcSldswlcbn" javaType="cn.fenghuait.yzsl.model.GcSldswlcbn">
<id column="gcSldswlcbn_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcSldswlcbn_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcSldswlcbn_WLCBNACD" property="wlcbnacd" jdbcType="CHAR" />
<result column="gcSldswlcbn_DSSUPWL" property="dssupwl" jdbcType="DECIMAL" />
<result column="gcSldswlcbn_DSSLWWL" property="dsslwwl" jdbcType="DECIMAL" />
<result column="gcSldswlcbn_DSSFL" property="dssfl" jdbcType="DECIMAL" />
<result column="gcSldswlcbn_DSEEUPWL" property="dseeupwl" jdbcType="DECIMAL" />
<result column="gcSldswlcbn_DSEELWWL" property="dseelwwl" jdbcType="DECIMAL" />
<result column="gcSldswlcbn_DSEEFL" property="dseefl" jdbcType="DECIMAL" />
<result column="gcSldswlcbn_DSHLUPWL" property="dshlupwl" jdbcType="DECIMAL" />
<result column="gcSldswlcbn_DSHLLWWL" property="dshllwwl" jdbcType="DECIMAL" />
<result column="gcSldswlcbn_DSHLFL" property="dshlfl" jdbcType="DECIMAL" />
<result column="gcSldswlcbn_CHSUPWL" property="chsupwl" jdbcType="DECIMAL" />
<result column="gcSldswlcbn_CHSLWWL" property="chslwwl" jdbcType="DECIMAL" />
<result column="gcSldswlcbn_CHSFL" property="chsfl" jdbcType="DECIMAL" />
<result column="gcSldswlcbn_CHEEUPWL" property="cheeupwl" jdbcType="DECIMAL" />
<result column="gcSldswlcbn_CHEELWWL" property="cheelwwl" jdbcType="DECIMAL" />
<result column="gcSldswlcbn_CHEEFL" property="cheefl" jdbcType="DECIMAL" />
<result column="gcSldswlcbn_CHHLUPWL" property="chhlupwl" jdbcType="DECIMAL" />
<result column="gcSldswlcbn_CHHLLWWL" property="chhllwwl" jdbcType="DECIMAL" />
<result column="gcSldswlcbn_CHHLFL" property="chhlfl" jdbcType="DECIMAL" />
<result column="gcSldswlcbn_RM" property="rm" jdbcType="VARCHAR" />
</association>
<association property="gcSlprjqty" javaType="cn.fenghuait.yzsl.model.GcSlprjqty">
<id column="gcSlprjqty_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcSlprjqty_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcSlprjqty_EWQTY" property="ewqty" jdbcType="DECIMAL" />
<result column="gcSlprjqty_SWQTY" property="swqty" jdbcType="DECIMAL" />
<result column="gcSlprjqty_CONCQTY" property="concqty" jdbcType="DECIMAL" />
<result column="gcSlprjqty_RSBQTY" property="rsbqty" jdbcType="DECIMAL" />
</association>
<association property="gcSlwatrec" javaType="cn.fenghuait.yzsl.model.GcSlwatrec">
<id column="gcSlwatrec_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcSlwatrec_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcSlwatrec_VTSHT" property="vtsht" jdbcType="DECIMAL" />
<result column="gcSlwatrec_MEPREPIPE" property="meprepipe" jdbcType="CHAR" />
<result column="gcSlwatrec_RVBDDST" property="rvbddst" jdbcType="CHAR" />
<result column="gcSlwatrec_CONCBLDSPL" property="concbldspl" jdbcType="CHAR" />
<result column="gcSlwatrec_FLXSPL" property="flxspl" jdbcType="CHAR" />
<result column="gcSlwatrec_OTH" property="oth" jdbcType="CHAR" />
</association>
<collection property="monitorsList" ofType="cn.fenghuait.yzsl.bean.Monitor" javaType="ArrayList">
<id column="monitorsList_id" property="id" jdbcType="INTEGER" />
<result column="monitorsList_ip" property="ip" jdbcType="VARCHAR" />
<result column="monitorsList_port" property="port" jdbcType="INTEGER" />
<result column="monitorsList_username" property="username" jdbcType="VARCHAR" />
<result column="monitorsList_password" property="password" jdbcType="VARCHAR" />
<result column="monitorsList_rm" property="rm" jdbcType="VARCHAR" />
<result column="monitorsList_create_date" property="create_date" jdbcType="TIMESTAMP" />
</collection>
<collection property="gcSldnntsList" ofType="cn.fenghuait.yzsl.model.GcSldnnt" javaType="ArrayList">
<id column="gcSldnntsList_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcSldnntsList_DNTM" property="dntm" jdbcType="TIMESTAMP" />
<id column="gcSldnntsList_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcSldnntsList_DNINCD" property="dnincd" jdbcType="CHAR" />
<result column="gcSldnntsList_DNINCL" property="dnincl" jdbcType="CHAR" />
<result column="gcSldnntsList_DNINNM" property="dninnm" jdbcType="CHAR" />
<result column="gcSldnntsList_DNPR" property="dnpr" jdbcType="CHAR" />
<result column="gcSldnntsList_CMDS" property="cmds" jdbcType="VARCHAR" />
<result column="gcSldnntsList_RMDNMS" property="rmdnms" jdbcType="VARCHAR" />
<result column="gcSldnntsList_RM" property="rm" jdbcType="VARCHAR" />
</collection>
<collection property="gcCnstsList" ofType="cn.fenghuait.yzsl.model.GcCnst" javaType="ArrayList">
<id column="gcCnstsList_ENNMCD" property="ennmcd" jdbcType="CHAR" />
<id column="gcCnstsList_INFNDT" property="infndt" jdbcType="TIMESTAMP" />
<result column="gcCnstsList_ADUNCD" property="aduncd" jdbcType="CHAR" />
<result column="gcCnstsList_ADUNNM" property="adunnm" jdbcType="CHAR" />
<result column="gcCnstsList_ADUNPL" property="adunpl" jdbcType="CHAR" />
<result column="gcCnstsList_STAD" property="stad" jdbcType="CHAR" />
<result column="gcCnstsList_LGTD" property="lgtd" jdbcType="DECIMAL" />
<result column="gcCnstsList_LTTD" property="lttd" jdbcType="DECIMAL" />
<result column="gcCnstsList_STSTDT" property="ststdt" jdbcType="TIMESTAMP" />
<result column="gcCnstsList_CNSTCFST" property="cnstcfst" jdbcType="CHAR" />
<result column="gcCnstsList_CNSTTP" property="cnsttp" jdbcType="CHAR" />
<result column="gcCnstsList_SRIT" property="srit" jdbcType="CHAR" />
<result column="gcCnstsList_SRMS" property="srms" jdbcType="CHAR" />
<result column="gcCnstsList_LVBSLV" property="lvbslv" jdbcType="CHAR" />
<result column="gcCnstsList_DLBLP" property="dlblp" jdbcType="CHAR" />
<result column="gcCnstsList_RM" property="rm" jdbcType="VARCHAR" />
<result column="gcCnstsList_ENNM" property="ennm" jdbcType="VARCHAR" />
</collection>
</resultMap>
<!-- 水闸 -->
<select id="selectGcslAll" resultMap="GCSLMap">
select
<if test="distinct"> distinct </if>
A.ENNMCD as ENNMCD,A.INFNDT as INFNDT ,A.ADUNCD as ADUNCD,A.ADUNNM as ADUNNM, A.ADUNPL as ADUNPL,A.CMDT
as CMDT,A.GTCL as GTCL,A.LVBSLV as
LVBSLV,A.DLBLP as DLBLP,A.ENCRZRPL as ENCRZRPL, A.ENPL as ENPL,A.ATRVCD as ATRVCD,A.Rm as Rm, <!-- C.ENNMCD as
gcCnstsList_ENNMCD,C.infndt as
gcCnstsList_INFNDT, C.ADUNCD as gcCnstsList_ADUNCD,C.ADUNNM as gcCnstsList_ADUNNM,C.ADUNPL as
gcCnstsList_ADUNPL,
C.STAD as
gcCnstsList_STAD,C.LGTD as gcCnstsList_LGTD,C.LTTD as gcCnstsList_LTTD, C.STSTDT as gcCnstsList_STSTDT,C.CNSTCFST as
gcCnstsList_CNSTCFST,
C.CNSTTP as gcCnstsList_CNSTTP,C.SRIT as gcCnstsList_SRIT, C.SRMS as gcCnstsList_SRMS,C.LVBSLV as gcCnstsList_LVBSLV, C.DLBLP as
gcCnsstList_DLBLP,C.RM
as gcCnstsList_RM X.ENNMCD as gcCnstList_ENNMCD,X.infndt as gcCnstList_INFNDT, X.ADUNCD as
gcCnstList_ADUNCD,X.ADUNNM as
gcCnstList_ADUNNM,X.ADUNPL
as gcCnstList_ADUNPL, X.STAD as gcCnstList_STAD,X.LGTD as gcCnstList_LGTD,X.LTTD as
gcCnstList_LTTD, X.STSTDT as
gcCnstList_STSTDT,X.CNSTCFST
as gcCnstList_CNSTCFST, X.CNSTTP as gcCnstList_CNSTTP,X.SRIT as gcCnstList_SRIT,
X.SRMS as gcCnstList_SRMS,X.LVBSLV as gcCnstList_LVBSLV,
X.DLBLP
as gcCnstList_DLBLP,X.RM as gcCnstList_RM ,-->D.ENNMCD as
gcPrnmsr_ENNMCD,D.ENNM as gcPrnmsr_ENNM,D.BIMP as gcPrnmsr_BIMP,D.ENIMG as
gcPrnmsr_ENIMG,
E.ENNMCD as gcSlhypr_ENNMCD,E.infndt as
gcSlhypr_INFNDT,E.DGUWLV as gcSlhypr_DGUWLV,E.DGDWLV as gcSlhypr_DGDWLV,E.dsexgtfl as gcSlhypr_DSEXGTFL,
E.DSFLST as
gcSlhypr_DSFLST,E.DCGUWLV as gcSlhypr_DCGUWLV,E.DCGDWLV as gcSlhypr_DCGDWLV,E.DCEGFL as gcSlhypr_DCEGFL,E.CHCNST as
gcSlhypr_CHCNST,
E.CGUWLV as gcSlhypr_CGUWLV,E.CGDWLV as gcSlhypr_CGDWLV,E.CHEXGTFL as gcSlhypr_CHEXGTFL,E.RM as gcSlhypr_RM, F.ENNMCD as
gcSlprch_ENNMCD,F.INFNDT
as gcSlprch_INFNDT,F.HNCM as gcSlprch_HNCM,F.OPPR as gcSlprch_OPPR,F.GTBSGL as gcSlprch_GTBSGL,F.ERBSIN as
gcSlprch_ERBSIN, F.ERDSIN as
gcSlprch_ERDSIN,F.GLEPCRX
as gcSlprch_GLEPCRX,F.GLEPCRY as gcSlprch_GLEPCRY,F.GLEPLN as
gcSlprch_GLEPLN,F.GLEPLT as gcSlprch_GLEPLT,F.GUBTEL as gcSlprch_GUBTEL,
F.GDBTEL
as gcSlprch_GDBTEL,F.GTBDSTTP as
gcSlprch_GTBDSTTP,F.GTMTEL as gcSlprch_GTMTEL,F.ENDSTP as gcSlprch_ENDSTP,F.GTORNM as
gcSlprch_GTORNM,F.GTORSZ
as gcSlprch_GTORSZ, F.GTORHG
as gcSlprch_GTORHG,F.OFBTLN as gcSlprch_OFBTLN,F.STTPHG as gcSlprch_STTPHG,F.SRTP as gcSlprch_SRTP,F.HDGRTP as
gcSlprch_HDGRTP,F.HDGRNM
as
gcSlprch_HDGRNM, F.OPSHFR as gcSlprch_OPSHFR,F.HGSPSP as gcSlprch_HGSPSP,F.STFLOPTM as gcSlprch_STFLOPTM,F.EXQS as gcSlprch_EXQS,
G.ENNMCD
as gcSlmgc_ENNMCD,G.INFNDT as gcSlmgc_INFNDT,G.ADUNKD as gcSlmgc_ADUNKD,G.ADUNCD as gcSlmgc_ADUNCD,G.ADUNNM as gcSlmgc_ADUNNM,G.MGST as
gcSlmgc_MGST,
G.MGFINSRC as gcSlmgc_MGFINSRC,G.WKNUM as gcSlmgc_WKNUM,G.SRVMG as gcSlmgc_SRVMG,G.EGMG as gcSlmgc_EGMG,G.BUSMG as
gcSlmgc_BUSMG,G.TOTINC as
gcSlmgc_TOTINC, G.WRINC as gcSlmgc_WRINC,G.ERINC as gcSlmgc_ERINC,G.MIINC as gcSlmgc_MIINC,G.OPROE as
gcSlmgc_OPROE,G.rEPEDE as
gcSldswlcbn_rEPEDE,
H.ENNMCD as gcSlscc_ENNMCD,H.INFNDT as gcSlscc_INFNDT,H.ACUNCD as gcSlscc_ACUNCD,H.ACUNNM as
gcSlscc_ACUNNM,H.SECACCL as gcSlscc_SECACCL,
H.SECACCON
as gcSlscc_SECACCON,H.RIOS as gcSlscc_RIOS,H.ADUNCSOS as gcSlscc_ADUNCSOS, I.ENNMCD
as gcSlbc_ENNMCD,I.INFNDT as gcSlbc_INFNDT,I.DSUNCD as
gcSlbc_DSUNCD,I.DSUNNM
as gcSlbc_DSUNNM,I.CONUNCD as gcSlbc_CONUNCD,I.CONUNNM as
gcSlbc_CONUNNM, I.CONAPCD as gcSlbc_CONAPCD,I.BLDUNCD as gcSlbc_BLDUNCD,I.BLDUNNM
as
gcSlbc_BLDUNNM,I.MONUNCD as gcSlbc_MONUNCD,i.MONUNNM as
gcSlbc_MONUNNM,i.CBUNCD as gcSlbc_CBUNCD, i.CBUNNM as gcSlbc_CBUNNM,i.QAUNCD as gcSlbc_QAUNCD,i.QAUNNM
as gcSlbc_QAUNNM,i.SWDT as
gcSlbc_SWDT,i.CPLDT as gcSlbc_CPLDT,i.PRJKD as gcSlbc_PRJKD,i.PRJQTY as gcSlbc_PRJQTY, i.PRJCOST as
gcSlbc_PRJCOST,i.CAEVCOST
as
gcSlbc_CAEVCOST,i.FSDT as gcSlbc_FSDT, j.ENNMCD as gcSlr_ENNMCD,j.INFNDT as gcSlr_INFNDT,j.RICS as gcSlr_RICS,j.RIDT as
gcSlr_RIDT,j.RIPRJ
as gcSlr_RIPRJ,j.RIDSUNCD as gcSlr_RIDSUNCD,j.RIDSUNNM as gcSlr_RIDSUNNM, j.RICONUNCD as gcSlr_RICONUNCD,j.RICONUNNM as
gcSlr_RICONUNNM,j.RIBLDUNCD
as gcSlr_RIBLDUNCD,j.RIBLDUNNM as gcSlr_RIBLDUNNM,j.RIMONUNCD as gcSlr_RIMONUNCD, j.RIMONUNNM as
gcSlr_RIMONUNNM,j.QAUNCD as
gcSlr_QAUNCD,j.QAUNNM
as gcSlr_QAUNNM,j.RIPRIN as gcSlr_RIPRIN,j.RICT as gcSlr_RICT,j.RIPRJQTY as
gcSlr_RIPRJQTY, j.RIPRJFIN as gcSlr_RIPRJFIN,j.RIBf as
gcSlr_RIBf,
K.ENNMCD as gcSldswlcbn_ENNMCD,K.INFNDT as gcSldswlcbn_INFNDT,K.WLCBNACD
as gcSldswlcbn_WLCBNACD,K.DSSUPWL as gcSldswlcbn_DSSUPWL,K.DSSLWWL as
gcSldswlcbn_DSSLWWL, K.DSSFL as gcSldswlcbn_DSSFL,K.DSEEUPWL as
gcSldswlcbn_DSEEUPWL,K.DSEELWWL as gcSldswlcbn_DSEELWWL,K.DSEEFL as
gcSldswlcbn_DSEEFL,K.DSHLUPWL
as gcSldswlcbn_DSHLUPWL, K.DSHLLWWL as
gcSldswlcbn_DSHLLWWL,K.DSHLFL as gcSldswlcbn_DSHLFL,K.CHSUPWL as gcSldswlcbn_CHSUPWL,K.CHSLWWL as
gcSldswlcbn_CHSLWWL,K.CHSFL
as
gcSldswlcbn_CHSFL, K.CHEEUPWL as gcSldswlcbn_CHEEUPWL,K.CHEELWWL as gcSldswlcbn_CHEELWWL,K.CHEEFL as gcSldswlcbn_CHEEFL,K.CHHLUPWL as
gcSldswlcbn_CHHLUPWL,K.CHHLLWWL
as gcSldswlcbn_CHHLLWWL, K.CHHLFL as gcSldswlcbn_CHHLFL,K.RM as gcSldswlcbn_RM, L.ENNMCD as
gcSlbsbn_ENNMCD,L.INFNDT as
gcSlbsbn_INFNDT,L.DCFTPRPP
as gcSlbsbn_DCFTPRPP,L.DCFTPRAR as gcSlbsbn_DCFTPRAR,L.DSIRAR as gcSlbsbn_DSIRAR,
L.ACIRAR as gcSlbsbn_ACIRAR,L.DSRMWTST as
gcSlbsbn_DSRMWTST,L.DSRMWTAR
as gcSlbsbn_DSRMWTAR,L.ACRMWTAR as gcSlbsbn_ACRMWTAR,L.RM as
gcSlbsbn_RM, M.ENNMCD as gcSldnntsList_ENNMCD,M.DNTM as
gcSldnntsList_DNTM,M.INFNDT
as gcSldnntsList_INFNDT,M.DNINCD as
gcSldnntsList_DNINCD,M.DNINCL as gcSldnntsList_DNINCL, M.DNINNM as gcSldnntsList_DNINNM,M.DNPR as
gcSldnntsList_DNPR,M.CMDS
as
gcSldnntsList_CMDS,M.RMDNMS as gcSldnntsList_RMDNMS,M.RM as gcSldnntsList_RM, N.ENNMCD as gcSlhsusnt_ENNMCD,N.INFNDT as
gcSlhsusnt_INFNDT,N.OPBGTM
as gcSlhsusnt_OPBGTM,N.HMXFPFL as gcSlhsusnt_HMXFPFL,N.HMXFLTMT as gcSlhsusnt_HMXFLTMT, N.AOMEGFL as
gcSlhsusnt_AOMEGFL,N.AOMEGFDT as
gcSlhsusnt_AOMEGFDT,N.AOGUHWLV
as gcSlhsusnt_AOGUHWLV,N.AOGUHWLD as gcSlhsusnt_AOGUHWLD,N.AOGULWLV as
gcSlhsusnt_AOGULWLV, n.AOGULWLD as gcSlhsusnt_AOGULWLD ,n.AOGDHWLV as
gcSlhsusnt_AOGDHWLV,n.AOGDHWLD as gcSlhsusnt_AOGDHWLD,n.AOGDLWLV as
gcSlhsusnt_AOGDLWLV,n.AOGDLWLD as gcSlhsusnt_AOGDLWLD, n.MNIN as
gcSlhsusnt_MNIN,n.RPIN
as gcSlhsusnt_RPIN,n.RM as gcSlhsusnt_RM, O.ENNMCD
as gcSlprjqty_ENNMCD,O.INFNDT as gcSlprjqty_INFNDT,O.EWQTY as gcSlprjqty_EWQTY,O.SWQTY as
gcSlprjqty_SWQTY,O.CONCQTY as
gcSlprjqty_CONCQTY,O.RSBQTY as gcSlprjqty_RSBQTY, P.ENNMCD as gcSlwatrec_ENNMCD,P.INFNDT as
gcSlwatrec_INFNDT,P.VTSHT
as
gcSlwatrec_VTSHT,P.MEPREPIPE as gcSlwatrec_MEPREPIPE,P.RVBDDST as gcSlwatrec_RVBDDST, P.CONCBLDSPL as gcSlwatrec_CONCBLDSPL,P.FLXSPL as
gcSlwatrec_FLXSPL,p.OTH
as gcSlwatrec_OTH, ta.id as monitorsList_id, ta.ip as monitorsList_ip, ta.port as monitorsList_port, ta.username as
monitorsList_username,
ta.password
as monitorsList_password, ta.rm as monitorsList_rm, ta.create_date as monitorsList_create_date from GC_SL
A <!-- LEFT JOIN GC_SLCNSTRL B on
A.ENNMCD=B.ENNMCD
and A.INFNDT=B.INFNDT LEFT JOIN GC_CNST C on C.ennmcd=B.gdcscd or C.ennmcd=B.gtcnstcd LEFT
JOIN GC_CNST X on X.ennmcd=B.gtcnstcd --> LEFT JOIN
GC_PRNMSR
D on D.ennmcd=a.ennmcd LEFT JOIN GC_SLHYPR E on E.ennmcd=A.ennmcd and
E.infndt=A.infndt LEFT JOIN GC_SLPRCH F on F.ennmcd=A.ennmcd and
F.infndt=A.infndt
LEFT JOIN GC_SLMGC G on G.ennmcd=A.ennmcd and
A.infndt=G.infndt LEFT JOIN Gc_slscc H on H.ennmcd=A.ennmcd and A.infndt=H.infndt LEFT JOIN
GC_SLBC
I on I.ennmcd=A.ennmcd and
A.infndt=I.infndt LEFT JOIN GC_Slr J on J.ennmcd=A.ennmcd and A.infndt=J.infndt LEFT JOIN GC_SLDSWLCBN K on
K.ennmcd=A.ennmcd
and
A.infndt=K.infndt LEFT JOIN GC_SLBSBN L on L.ennmcd=A.ennmcd and A.infndt=L.infndt LEFT JOIN GC_SLDNNT M on M.ennmcd=A.ennmcd and
A.infndt=M.infndt
LEFT JOIN GC_SLHSUSNT N on N.ennmcd=A.ennmcd and A.infndt=N.infndt LEFT JOIN GC_SLPRJQTY O on O.ennmcd=A.ennmcd and
A.infndt=O.infndt LEFT
JOIN
GC_SLWATREC p on P.ennmcd=A.ennmcd and A.infndt=P.infndt LEFT JOIN t_monitor_project tb on tb.pcode=A.Ennmcd
LEFT JOIN t_monitor ta ON ta.id
= tb.mid
<if test="orderByClause != null"> order by ${orderByClause} </if>
</select>
<!-- 河道 -->
<select id="selectGcrvAll" resultMap="GCRVMap">
select
<if test="distinct">
distinct
</if>
D.*,
F.ENNMCD as gcDrarbsin_ENNMCD ,
F.INFNDT as gcDrarbsin_INFNDT,
F.RVRK as gcDrarbsin_RVRK ,
F.RVUS as gcDrarbsin_RVUS,
F.RVPL as
gcDrarbsin_RVPL,
F.MDJMPL as gcDrarbsin_MDJMPL,
F.DWJMPL As gcDrarbsin_DWJMPL,
F.MNSTLN as gcDrarbsin_MNSTLN,
F.UPLN as gcDrarbsin_UPLN,
F.MDLN as gcDrarbsin_MDLN,
F.DWLN as gcDrarbsin_DWLN,
F.TREBN as gcDrarbsin_TREBN,
F.TTDRBSAR as gcDrarbsin_TTDRBSAR,
F.UPDRBSAR as
gcDrarbsin_UPDRBSAR,
F.MDDRBSAR as gcDrarbsin_MDDRBSAR,
F.LWDRBSAR as gcDrarbsin_LWDRBSAR,
F.DRBSCTAR gcDrarbsin_DRBSCTAR,
F.DRBSHLAR as
gcDrarbsin_DRBSHLAR,
F.DRBSPLAR as gcDrarbsin_DRBSPLAR,
F.DRBSLKAR as gcDrarbsin_DRBSLKAR,
F.DRBSINAR as gcDrarbsin_DRBSINAR,
F.DRBSPP as
gcDrarbsin_DRBSPP,
G.ENNMCD as gcPrnmsr_ENNMCD,
G.ENNM as gcPrnmsr_ENNM ,
G.BIMP as gcPrnmsr_BIMP,
G.ENIMG as gcPrnmsr_ENIMG,
A.RCCD as
gcRcbsinsList_RCCD,
A.INFNDT as gcRcbsinsList_INFNDT,
A.RVTP as gcRcbsinsList_RVTP,
A.CNAR as gcRcbsinsList_CNAR,
A.RCLN as
gcRcbsinsList_RCLN,
A.ENBRNM AS gcRcbsinsList_ENBRNM ,
A.CHAVWD as gcRcbsinsList_CHAVWD,
A.BTAVWD asgcRcbsinsList_BTAVWD,
A.HCHAR as
gcRcbsinsList_HCHAR,
A.BTAR as gcRcbsinsList_BTAR,
A.CHFLDS as gcRcbsinsList_CHFLDS,
A.RVAVSL as gcRcbsinsList_RVAVSL,
A.CV as
gcRcbsinsList_CV,
A.MXRVWD as gcRcbsinsList_MXRVWD,
A.MNRVWD as gcRcbsinsList_MNRVWD,
A.RM as gcRcbsinsList_RM ,
N.ENNMCD as
gcCnstList_ENNMCD,
N.INFNDT AS gcCnstList_INFNDT,
N.ADUNCD as gcCnstList_ADUNCD,
N.ADUNNM as gcCnstList_ADUNNM,
N.ADUNPL as gcCnstList_ADUNPL,
N.STAD as gcCnstList_STAD,
N.LGTD as gcCnstList_LGTD,
N.LTTD as gcCnstList_LTTD,
N.STSTDT as gcCnstList_STSTDT,
N.CNSTCFST as
gcCnstList_CNSTCFST,
N.CNSTTP as gcCnstList_CNSTTP,
N.SRIT as gcCnstList_SRIT,
N.SRMS as gcCnstList_SRMS,
N.LVBSLV as gcCnstList_LVBSLV,
N.DLBLP as gcCnstList_DLBLP,
N.RM as gcCnstList_RM ,
ta.id as monitorsList_id,
ta.ip as monitorsList_ip,
ta.port as monitorsList_port,
ta.username as monitorsList_username,
ta.password as monitorsList_password,
ta.rm as monitorsList_rm,
ta.create_date as
monitorsList_create_date,
I.ENNMCD as gcRctrbschsList_ENNMCD,
I.CHTRCD as gcRctrbschsList_CHTRCD,
I.INFNDT as gcRctrbschsList_INFNDT,
I.EXDT
as gcRctrbschsList_EXDT,
I.TRNM as gcRctrbschsList_TRNM,
I.TRDR as gcRctrbschsList_TRDR,
I.TRATPL as gcRctrbschsList_TRATPL,
I.INTRCD as
gcRctrbschsList_INTRCD,
I.TOINTRDS as gcRctrbschsList_TOINTRDS,
I.CNSTCD as gcRctrbschsList_CNSTCD,
I.LFBNCH as gcRctrbschsList_LFBNCH,
I.LFBNPL as gcRctrbschsList_LFBNPL,
I.RGBNCH as gcRctrbschsList_RGBNCH,
I.RGBNPL as gcRctrbschsList_RGBNPL,
I.BTWD as gcRctrbschsList_BTWD,
I.CHWD as gcRctrbschsList_CHWD,
I.BCAVEL as gcRctrbschsList_BCAVEL,
I.BECLSLTH as gcRctrbschsList_BECLSLTH,
I.CHAVEL as
gcRctrbschsList_CHAVEL,
I.CHCLSLTH as gcRctrbschsList_CHCLSLTH,
I.CLSLINT as gcRctrbschsList_CLSLINT,
I.MNCHEL as gcRctrbschsList_MNCHEL,
I.DSFLLV as gcRctrbschsList_DSFLLV,
I.GNWTLV as gcRctrbschsList_GNWTLV ,
I.ALWTLV as gcRctrbschsList_ALWTLV,
I.ASHWL as
gcRctrbschsList_ASHWL,
I.ASHWLTM as gcRctrbschsList_ASHWLTM,
I.INHGWTLV as gcRctrbschsList_INHGWTLV,
I.IHFWLT as gcRctrbschsList_IHFWLT,
I.ASHFL as gcRctrbschsList_ASHFL,
I.ASHFLTM as gcRctrbschsList_ASHFLTM,
I.ASLFL as gcRctrbschsList_ASLFL,
I.ASLFLTM as
gcRctrbschsList_ASLFLTM,
I.BEDLOAD as gcRctrbschsList_BEDLOAD,
I.CHSFDS as gcRctrbschsList_CHSFDS,
I.CHDKEL as gcRctrbschsList_CHDKEL,
I.RM as
gcRctrbschsList_RM
from
GC_RV D
LEFT JOIN gc_rvrcds B ON B.Ennmcd=D.ENNMCD and B.INFNDT=D.INFNDT
LEFT JOIN gc_rcbsin A ON A.ENNMCD=B.ENNMCD
and A.INFNDT=B.INFNDT and
A.RCCD=B.RCCD
LEFT JOIN GC_DRARBSIN F on F.ENNMCD = F.ENNMCD and F.INFNDT=D.INFNDT
LEFT JOIN GC_PRNMSR G on
G.ENNMCD = D.ENNMCD
LEFT JOIN GC_RCTR H ON H.Ennmcd=D.ENNMCD and H.infndt=D.INFNDT
LEFT JOIN GC_RCTRBSCH I ON H.ENNMCD=I.ENNMCD and
H.INFNDT=I.INFNDT and
H.Chtrcd=I.Chtrcd
LEFT JOIN GC_RVSRRLTB M ON M.Ennmcd=D.ENNMCD and M.INFNDT=D.INFNDT
LEFT JOIN GC_CNST N ON
M.ENNMCD=N.ENNMCD
LEFT JOIN t_monitor_project tb on tb.pcode=D.Ennmcd
LEFT JOIN t_monitor ta
ON ta.id = tb.mid
<if test="orderByClause != null">
order by ${orderByClause}
</if>
</select>
<!-- 泵站 -->
<select id="selectGcpumpAll" resultMap="GCPUMPMap">
select
<if test="distinct">
distinct
</if>
A.ENNMCD as ENNMCD,A.INFNDT as INFNDT,A.ADUNCD as ADUNCD,
A.PLRVCD as PLRVCD,A.WLNCD as WLNCD,
A.ENPL as ENPL,A.OPRKD as OPRKD,A.DLBLP as
DLBLP,A.ADUNNM as ADUNNM,
A.ADUNPL as ADUNPL,a.OPPR as OPPR,a.LVBSLV as LVBSLV,a.CMDT as CMDT,
a.BGOPDT as BGOPDT,
a.BSININ as BSININ,
a.RM as
RM,
B.ENNMCD as gcPrnmsr_ENNMCD,B.ENNM as gcPrnmsr_ENNM,
B.BIMP as gcPrnmsr_BIMP,B.ENIMG as gcPrnmsr_ENIMG,
C.ENNMCD as
gcPumpbi_ENNMCD,c.INFNDT as gcPumpbi_INFNDT,c.PSSCL as gcPumpbi_PSSCL,
c.PSCL as gcPumpbi_PSCL,c.MBCL as gcPumpbi_MBCL,c.DSBBFLDSTD as
gcPumpbi_DSBBFLDSTD,
c.CHBBFLDSTD as gcPumpbi_CHBBFLDSTD,c.STTLN as gcPumpbi_STTLN,c.STTWD as gcPumpbi_STTWD,
c.INCP as
gcPumpbi_INCP,c.INNUM as gcPumpbi_INNUM,c.INFL as gcPumpbi_INFL,c.DSDIST as gcPumpbi_DSDIST,
c.PUMPT as gcPumpbi_PUMPT,c.PUMPNUM as
gcPumpbi_PUMPNUM,c.PUMPRV as gcPumpbi_PUMPRV,
c.PUMPDRVMAN as gcPumpbi_PUMPDRVMAN,c.GENT as gcPumpbi_GENT,c.GENNUM as gcPumpbi_GENNUM,
c.GENPW as gcPumpbi_GENPW,c.GENVLT as gcPumpbi_GENVLT,c.GENRV as gcPumpbi_GENRV,
c.TFT as gcPumpbi_TFT,c.TFCP as gcPumpbi_TFCP,c.TFNUM as
gcPumpbi_TFNUM,c.LNVLT as gcPumpbi_LNVLT,
c.TFSS as gcPumpbi_TFSS,c.LFTDEVT as gcPumpbi_LFTDEVT,c.LFTDEVCP as gcPumpbi_LFTDEVCP,c.CUTFLMAN
as gcPumpbi_CUTFLMAN,
c.UPSLST as gcPumpbi_UPSLST,c.LWSLST as gcPumpbi_LWSLST,c.UPSLMTT as gcPumpbi_UPSLMTT,
c.LWSLMTT as
gcPumpbi_LWSLMTT,c.INWCHNLT AS gcPumpbi_INWCHNLT,C.OWCHNLT AS gcPumpbi_OWCHNLT,
c.SHBHL as gcPumpbi_SHBHL,c.PUMPHL as
gcPumpbi_PUMPHL,c.GENHL as gcPumpbi_GENHL,
c.VSHHL as gcPumpbi_VSHHL,c.RTCENHL as gcPumpbi_RTCENHL,c.UPHL as gcPumpbi_UPHL,
c.LWHL as
gcPumpbi_LWHL,c.HMPBHL as gcPumpbi_HMPBHL,c.BRGWD as gcPumpbi_BRGWD,
c.BRGHL as gcPumpbi_BRGHL,c.BRGLD as gcPumpbi_BRGLD,c.BRGBLV as
gcPumpbi_BRGBLV,
c.DSUPWL as gcPumpbi_DSUPWL,c.DSLWWL as gcPumpbi_DSLWWL,c.CHUPWL as gcPumpbi_CHUPWL,
c.CHLWWL as gcPumpbi_CHLWWL,c.GEOLIN
as gcPumpbi_GEOLIN,c.WTSRIT as gcPumpbi_WTSRIT,
c.RM as gcPumpbi_RM,
ta.id as monitorsList_id,
ta.ip as monitorsList_ip,
ta.port as
monitorsList_port,
ta.username as monitorsList_username,
ta.password as
monitorsList_password,
ta.rm as monitorsList_rm,
ta.create_date as
monitorsList_create_date,
d.ENNMCD as gcPumpr_ennmcd,d.INFNDT as gcPumpr_INFNDT,d.RICS as gcPumpr_RICS,
d.RIDT as gcPumpr_RIDT,d.RIPRJ as
gcPumpr_RIPRJ,d.RIDSUNCD as gcPumpr_RIDSUNCD,
d.RIDSUNNM as gcPumpr_RIDSUNNM,d.RICONUNCD as gcPumpr_RICONUNCD,d.RICONUNNM as
gcPumpr_RICONUNNM,
d.RIBLDUNCD as gcPumpr_RIBLDUNCD,d.RIBLDUNNM as gcPumpr_RIBLDUNNM,
d.RIMONUNCD as gcPumpr_RIMONUNCD,d.RIMONUNNM as
gcPumpr_RIMONUNNM,
d.QAUNCD as gcPumpr_QAUNCD,d.QAUNNM as gcPumpr_QAUNNM,d.RIPRIN as gcPumpr_RIPRIN,
d.RICT as gcPumpr_RICT,d.RIPRJQTY as
gcPumpr_RIPRJQTY,d.RIPRJFIN as gcPumpr_RIPRJFIN,
d.RIBF as gcPumpr_RIBF,
e.ENNMCD as gcPumpscc_ENNMCD,e.INFNDT as gcPumpscc_INFNDT,e.ACUNCD
as gcPumpscc_ACUNCD,
e.ACUNNM as gcPumpscc_ACUNNM,e.SECACCL as gcPumpscc_SECACCL,e.SECACCON as gcPumpscc_SECACCON,
e.RIOS as
gcPumpscc_RIOS,e.ADUNCSOS as gcPumpscc_ADUNCSOS,
f.ENNMCD as gcPumpmgc_ENNMCD,f.INFNDT as gcPumpmgc_INFNDT,
f.ADUNKD as
gcPumpmgc_ADUNKD,f.ADUNCD as gcPumpmgc_ADUNCD,
f.ADUNNM as gcPumpmgc_ADUNNM,f.MGST as gcPumpmgc_MGST,
f.MGFINSRC as
gcPumpmgc_MGFINSRC,f.WKNUM as gcPumpmgc_WKNUM,
f.SRVMG as gcPumpmgc_SRVMG,f.EGMG as gcPumpmgc_EGMG,
f.BUSMG as gcPumpmgc_BUSMG,f.TOTINC as
gcPumpmgc_TOTINC,
f.WRINC as gcPumpmgc_WRINC,f.ERINC as gcPumpmgc_ERINC,
f.MIINC as gcPumpmgc_MIINC,f.OPROE as gcPumpmgc_OPROE,
f.REPEDE as
gcPumpmgc_REPEDE,
g.ENNMCD as gcPumpbc_ENNMCD,g.INFNDT as gcPumpbc_INFNDT,
g.DSUNNM as gcPumpbc_DSUNNM,g.CONUNCD as gcPumpbc_CONUNCD,
g.CONUNNM as gcPumpbc_CONUNNM,g.CONAPCD as gcPumpbc_CONAPCD,
g.BLDUNCD as gcPumpbc_BLDUNCD,g.BLDUNNM as gcPumpbc_BLDUNNM,
g.MONUNCD as
gcPumpbc_MONUNCD,g.MONUNNM as gcPumpbc_MONUNNM,
g.CBUNCD as gcPumpbc_CBUNCD,g.CBUNNM as gcPumpbc_CBUNNM,
g.QAUNCD as
gcPumpbc_QAUNCD,g.QAUNNM as gcPumpbc_QAUNNM,
g.SWDT as gcPumpbc_SWDT,g.CPLDT as gcPumpbc_CPLDT,
g.PRJKD as gcPumpbc_PRJKD,g.PRJQTY as
gcPumpbc_PRJQTY,
g.PRJCOST as gcPumpbc_PRJCOST,g.CAEVCOST as gcPumpbc_CAEVCOST,
g.FSDT as gcPumpbc_FSDT,g.PRJRK as gcPumpbc_PRJRK,
i.ENNMCD
as gcWaterlinesList_ENNMCD,i.INFNDT as gcWaterlinesList_INFNDT,
i.ENNM as gcWaterlinesList_ENNM,i.ENLEN as gcWaterlinesList_ENLEN,
i.RMWTAR
as gcWaterlinesList_RMWTAR,i.IRAR as gcWaterlinesList_IRAR,
i.ADUNNM as gcWaterlinesList_ADUNNM,i.ADUNPL as gcWaterlinesList_ADUNPL,
i.STPNUM as gcWaterlinesList_STPNUM,i.SPNPL as gcWaterlinesList_SPNPL,
i.CMDT as gcWaterlinesList_CMDT,i.BGOPDT as gcWaterlinesList_BGOPDT,
i.BSININ as gcWaterlinesList_BSININ,i.RM as gcWaterlinesList_RM
from GC_PUMP A
LEFT JOIN GC_PRNMSR B on b.ennmcd=a.ennmcd
LEFT JOIN GC_PUMPBI
C on c.ennmcd=a.ennmcd and c.infndt=a.infndt
LEFT JOIN t_monitor_project tb on tb.pcode=A.Ennmcd
LEFT JOIN t_monitor ta ON ta.id = tb.mid
LEFT JOIN GC_PUMPR d on d.ennmcd=a.ennmcd and d.infndt=a.infndt
LEFT JOIN GC_PUMPSCC e on e.ennmcd=a.ennmcd and e.infndt=a.infndt
LEFT JOIN
GC_PUMPMGC f on f.ennmcd=a.ennmcd and f.infndt=a.infndt
LEFT JOIN GC_PUMPBC g on g.ennmcd=a.ennmcd and g.infndt=a.infndt
LEFT JOIN
GC_PUMPWTLN h on h.ennmcd=a.ennmcd and h.infndt=a.infndt
LEFT JOIN GC_WATERLINE i on i.ennmcd=h.wlennmcd
<if test="orderByClause != null">
order by ${orderByClause}
</if>
</select>
<!-- 堤防 -->
<select id="selectGcDkAll" resultMap="GCDKMap">
select
<if test="distinct">
distinct
</if>
A.ENNMCD as ENNMCD,
A.INFNDT as INFNDT,
A.ADUNCD as ADUNCD,
A.ADUNNM as ADUNNM,
A.ADUNPL as ADUNPL,
A.ATRCCD as ATRCCD,
A.DKCL as DKCL,
A.LVBSLV
as LVBSLV,
A.DLBLP as DLBLP,
A.ENCRZRPL as ENCRZRPL,
A.ININ as ININ,
B.ENNMCD as gcPrnmsr_ENNMCD,
B.ENNM as gcPrnmsr_ENNM,
B.BIMP as
gcPrnmsr_BIMP,
B.ENIMG as gcPrnmsr_ENIMG,
C.ENNMCD as gcBnbsin_ENNMCD,
C.INFNDT as gcBnbsin_INFNDT,
C.BNSCBGPL as gcBnbsin_BNSCBGPL,
C.BNSCBGCH as gcBnbsin_BNSCBGCH,
C.BNSCENPL as gcBnbsin_BNSCENPL,
C.BNSCENCH as gcBnbsin_BNSCENCH,
C.BNSCLN as gcBnbsin_BNSCLN,
C.JMBNTPEL as
gcBnbsin_JMBNTPEL,
C.ENBNTPEL as gcBnbsin_ENBNTPEL,
C.MXDMHG as gcBnbsin_MXDMHG,
C.MXDMHGCH as gcBnbsin_MXDMHGCH,
C.MXBNTPWD as
gcBnbsin_MXBNTPWD,
C.MBTWCH as gcBnbsin_MBTWCH,
C.BNTPRDTP as gcBnbsin_BNTPRDTP,
C.LRSMXBDS as gcBnbsin_LRSMXBDS,
C.LRSMNBDS as
gcBnbsin_LRSMNBDS,
C.PRSLNM as gcBnbsin_PRSLNM,
C.PRSLLN as gcBnbsin_PRSLLN,
c.CNCLGTNM as gcBnbsin_CNCLGTNM,
c.EXQS as gcBnbsin_EXQS,
E.ENNMCD as gcCnstsList_ENNMCD,
e.infndt as gcCnstsList_INFNDT,
e.ADUNCD as gcCnstsList_ADUNCD,
e.ADUNNM as gcCnstsList_ADUNNM,
e.ADUNPL as
gcCnstsList_ADUNPL,
e.STAD as gcCnstsList_STAD,
e.LGTD as gcCnstsList_LGTD,
e.LTTD as gcCnstsList_LTTD,
e.STSTDT as gcCnstsList_STSTDT,
e.CNSTCFST as gcCnstsList_CNSTCFST,
e.CNSTTP as gcCnstsList_CNSTTP,
e.SRIT as gcCnstsList_SRIT,
e.SRMS as gcCnstsList_SRMS,
e.LVBSLV as
gcCnstsList_LVBSLV,
e.DLBLP as gcCnsstList_DLBLP,
e.RM as gcCnstsList_RM,
f.ENNMCD as gcDkhosList_ENNMCD,
f.INFNDT as gcDkhosList_INFNDT,
f.BRSPAG as gcDkhosList_BRSPAG,
f.BRSPPL as gcDkhosList_BRSPPL,
f.INRN as gcDkhosList_INRN,
f.BRSPLS as gcDkhosList_BRSPLS,
f.RPTM as
gcDkhosList_RPTM,
f.BSHVB as gcDkhosList_BSHVB,
f.RM as gcDkhosList_RM,
g.ENNMCD as gcBspfhn_ENNMCD,
g.INFNDT as gcBspfhn_INFNDT,
g.HSHGWTLV as
gcBspfhn_HSHGWTLV,
g.HHWLT as gcBspfhn_HHWLT,
g.HSMXFLFL as gcBspfhn_HSMXFLFL,
g.HMXFLTMT as gcBspfhn_HMXFLTMT,
g.RM as gcBspfhn_RM,
h.ENNMCD
as gcDbiabt_ENNMCD,
h.INFNDT as gcDbiabt_INFNDT,
h.PRAR as gcDbiabt_PRAR,
h.PRINAR as gcDbiabt_PRINAR,
h.PRVLNM as gcDbiabt_PRVLNM,
h.PRFXASNM
as gcDbiabt_PRFXASNM,
h.PTPP as gcDbiabt_PTPP,
h.PRHUNM as gcDbiabt_PRHUNM,
h.PRFCMN as gcDbiabt_PRFCMN,
h.PRCT as gcDbiabt_PRCT,
h.PRRL as
gcDbiabt_PRRL,
h.PRHG as gcDbiabt_PRHG,
h.PRSTES as gcDbiabt_PRSTES,
h.rm as gcDbiabt_RM,
i.ENNMCD as gcDkbc_ENNMCD,
i.INFNDT as gcDkbc_INFNDT,
i.DSUNCD as gcDkbc_DSUNCD,
i.DSUNNM as gcDkbc_DSUNNM,
i.CONUNCD as gcDkbc_CONUNCD,
i.CONUNNM as gcDkbc_CONUNNM,
i.CONAPCD as gcDkbc_CONAPCD,
i.BLDUNCD as gcDkbc_BLDUNCD,
i.BLDUNNM as gcDkbc_BLDUNNM,
i.MONUNCD as gcDkbc_MONUNCD,
i.MONUNNM as gcDkbc_MONUNNM,
i.CBUNCD as gcDkbc_CBUNCD,
i.CBUNNM as gcDkbc_CBUNNM,
i.QAUNCD as gcDkbc_QAUNCD,
i.QAUNNM as gcDkbc_QAUNNM,
i.SWDT as gcDkbc_SWDT,
i.CPLDT as gcDkbc_CPLDT,
i.PRJKD as
gcDkbc_PRJKD,
i.PRJQTY as gcDkbc_PRJQTY,
i.PRJCOST as gcDkbc_PRJCOST,
i.CAEVCOST as gcDkbc_CAEVCOST,
i.FSDT as gcDkbc_FSDT,
i.PRJRK as
gcDkbc_PRJRK,
j.ENNMCD as gcDkr_ENNMCD,
j.iNFNDT as gcDkr_INFNDT,
j.RICS as gcDkr_RICS,
j.RIDT as gcDkr_RIDT,
j.RIPRJ as gcDkr_RIPRJ,
j.RIDSUNCD as gcDkr_RIDSUNCD,
j.RIDSUNNM as gcDkr_RIDSUNNM,
j.RICONUNCD as gcDkr_RICONUNCD,
j.RICONUNNM as gcDkr_RICONUNNM,
j.RIBLDUNCD as
gcDkr_RIBLDUNCD,
j.RIBLDUNNM as gcDkr_RIBLDUNNM,
j.RIMONUNCD as gcDkr_RIMONUNCD,
j.RIMONUNNM as gcDkr_RIMONUNNM,
j.QAUNCD as gcDkr_QAUNCD,
j.QAUNNM as gcDkr_QAUNNM,
j.RIPRIN as gcDkr_RIPRIN,
j.RICT as gcDkr_RICT,
j.RIPRJQTY as gcDkr_RIPRJQTY,
j.RIPRJFIN as gcDkr_RIPRJFIN,
j.RIBF as
gcDkr_RIBF,
k.ENNMCD as gcDkscc_ENNMCD,
k.INFNDT as gcDkscc_INFNDT,
k.ACUNCD as gcDkscc_ACUNCD,
k.ACUNNM as gcDkscc_ACUNNM,
k.SECACCL as
gcDkscc_SECACCL,
k.SECACCON as gcDkscc_SECACCON,
k.RIOS as gcDkscc_RIOS,
k.ADUNCSOS as gcDkscc_ADUNCSOS,
l.ENNMCD as gcDkancvdg_ENNMCD,
l.INFNDT as gcDkancvdg_INFNDT,
l.ANCVDG as gcDkancvdg_ANCVDG,
l.tMDGLIMCB as gcDkancvdg_TMDGLIMCB,
l.TMDGRCCB as gcDkancvdg_TMDGRCCB,
m.ENNMCD as gcDkmgc_ENNMCD,
m.INFNDT as gcDkmgc_INFNDT,
m.ADUNKD as gcDkmgc_ADUNKD,
m.ADUNCD as gcDkmgc_ADUNCD,
m.ADUNNM as gcDkmgc_ADUNNM,
m.MGST as gcDkmgc_MGST,
m.MGFINSRC as gcDkmgc_MGFINSRC,
m.WKNUM as gcDkmgc_WKNUM,
m.SRVMG as gcDkmgc_SRVMG,
m.EGMG as gcDkmgc_EGMG,
m.BUSMG as
gcDkmgc_BUSMG,
m.TOTINC as gcDkmgc_TOTINC,
m.WRINC as gcDkmgc_WRINC,
m.ERINC as gcDkmgc_ERINC,
m.MIINC as gcDkmgc_MIINC,
m.OPROE as
gcDkmgc_OPROE,
m.REPE as gcDkmgc_REPE,
n.ENNMCD as gcBnbdcrprsList_ENNMCD,
n.BNTRCD as gcBnbdcrprsList_BNTRCD,
n.INFNDT as
gcBnbdcrprsList_INFNDT,
n.JMDS as gcBnbdcrprsList_JMDS,
n.EXDT as gcBnbdcrprsList_EXDT,
n.SRPNEL as gcBnbdcrprsList_SRPNEL,
ta.id as
monitorsList_id,
ta.ip as monitorsList_ip,
ta.port as monitorsList_port,
ta.username as monitorsList_username,
ta.password as
monitorsList_password,
ta.rm as monitorsList_rm,
ta.create_date as monitorsList_create_date,
o.ENNMCD as gcBsfst_ENNMCD,o.INFNDT as
gcBsfst_INFNDT,o.ERBSIN as gcBsfst_ERBSIN,
o.ERDSIN as gcBsfst_ERDSIN,o.CNSTCD as gcBsfst_CNSTCD,o.DSCNFLST as gcBsfst_DSCNFLST,
o.DSFLLV as
gcBsfst_DSFLLV,o.GNWTLV as gcBsfst_GNWTLV,o.ALWTLV as gcBsfst_ALWTLV,
o.rm as gcBsfst_RM,p.ENNMCD
as gcCnstsList_gcCshct_ENNMCD,p.INFNDT as
gcCnstsList_gcCshct_INFNDT,
p.DSFLST as gcCnstsList_gcCshct_DSFLST,p.DSFLLV as gcCnstsList_gcCshct_DSFLLV,
p.DSFLFL as
gcCnstsList_gcCshct_DSFLFL,p.GNWTLV as gcCnstsList_gcCshct_GNWTLV,
p.ASWLFL as gcCnstsList_gcCshct_ASWLFL,p.CHMXSFDS as
gcCnstsList_gcCshct_CHMXSFDS,
p.ALWTLV as gcCnstsList_gcCshct_ALWTLV,p.SRPNMXVL as gcCnstsList_gcCshct_SRPNMXVL,
p.SPMVT as
gcCnstsList_gcCshct_SPMVT,p.ASHWL as gcCnstsList_gcCshct_ASHWL,
p.ASHWLTM as gcCnstsList_gcCshct_ASHWLTM,p.ATSRMXFL as
gcCnstsList_gcCshct_ATSRMXFL,
p.ASMFTM as gcCnstsList_gcCshct_ASMFTM,p.INHGWTLV as gcCnstsList_gcCshct_INHGWTLV,
p.IHFWLT as
gcCnstsList_gcCshct_IHFWLT,p.INMXFL as gcCnstsList_gcCshct_INMXFL,
p.INMXFLTM as gcCnstsList_gcCshct_INMXFLTM,p.ACMXSDQT as
gcCnstsList_gcCshct_ACMXSDQT,
p.ATMXSNQN as gcCnstsList_gcCshct_ATMXSNQN,p.SRPNMNVL as gcCnstsList_gcCshct_SRPNMNVL,
p.SPMNVT as
gcCnstsList_gcCshct_SPMNVT,p.ASLWL as gcCnstsList_gcCshct_ASLWL,
p.ASLWLTM as gcCnstsList_gcCshct_ASLWLTM,p.ATSRMNFL as
gcCnstsList_gcCshct_ATSRMNFL,
p.ASMNFTM as gcCnstsList_gcCshct_ASMNFTM,p.INLWWTLV as gcCnstsList_gcCshct_INLWWTLV,
p.INLWWLVTM as
gcCnstsList_gcCshct_INLWWLVTM,p.INMNFL as gcCnstsList_gcCshct_INMNFL,
p.INMNFLTM as gcCnstsList_gcCshct_INMNFLTM,p.MXSDQT as
gcCnstsList_gcCshct_MXSDQT,
p.MXSDQTTM as gcCnstsList_gcCshct_MXSDQTTM,p.MNSDQT as gcCnstsList_gcCshct_MNSDQT,
p.MNSDQTTM as
gcCnstsList_gcCshct_MNSDQTTM,p.RM as gcCnstsList_gcCshct_RM,
q.ENNMCD as gcCnstsList_gcWtflrlsList_EN,q.INFNDT as
gcCnstsList_gcWtflrlsList_IN,
q.WTLV as gcCnstsList_gcWtflrlsList_WTLV,q.FL as gcCnstsList_gcWtflrlsList_FL,
q.SRDT as
gcCnstsList_gcWtflrlsList_SRDT
from
GC_DK A
LEFT JOIN
GC_PRNMSR B
on b.ennmcd=a.ennmcd
LEFT JOIN
GC_BNBSIN C
on c.ennmcd=a.ennmcd
and
c.infndt=a.infndt
LEFT JOIN
GC_DKSRRLTB D
on D.ennmcd=A.ennmcd
and D.infndt=a.infndt
LEFT JOIN
GC_CNST E
on E.ennmcd=D.cnstcd
LEFT JOIN GC_CSHCT p
on p.ennmcd=e.ennmcd
and p.infndt=e.infndt LEFT JOIN GC_WTFLRL q on q.ennmcd=e.ennmcd
and q.infndt=e.infndt
LEFT JOIN
GC_DKHOS F
on
F.ennmcd=A.ennmcd
and F.infndt=a.infndt
LEFT JOIN
GC_BSPFHN G
on G.ennmcd=A.ennmcd
and g.infndt=a.infndt
LEFT JOIN
GC_DBIABT H
on
h.ennmcd=A.ennmcd
and h.infndt=a.infndt
LEFT JOIN
GC_DKBC i
on i.ennmcd=A.ennmcd
and a.infndt=i.infndt
LEFT JOIN
GC_DKR j
on j.ennmcd=A.ennmcd
and
a.infndt=j.infndt
LEFT JOIN
GC_DKSCC k
on k.ennmcd=A.ennmcd
and a.infndt=k.infndt
LEFT JOIN
GC_DKANCVDG l
on l.ennmcd=A.ennmcd
and
a.infndt=l.infndt
LEFT JOIN
GC_DKMGC m
on m.ennmcd=A.ennmcd
and a.infndt=m.infndt
LEFT JOIN
GC_BNBDCRPR n
on n.ennmcd=A.ennmcd
and
a.infndt=n.infndt
LEFT JOIN
t_monitor_project tb
on tb.pcode=A.Ennmcd
LEFT JOIN
t_monitor ta
ON ta.id = tb.mid
LEFT JOIN GC_BSFST o on
o.ennmcd=A.ennmcd
and a.infndt=o.infndt
<if test="orderByClause != null">
order by ${orderByClause}
</if>
</select>
</mapper>
转载于:https://my.oschina.net/jjjjjjjjjjj11111/blog/482413