<?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="com.sooka.system.gas.zenner_meter_reading_infor.mapper.TGuijiZennerMeterReadingMapper">

    <sql id="selectVo">
        select id, GUID, VC_WCB_USERGUID, VC_WCB_METERGUID, VC_WCB_PERSON, D_WCB_OPDATE, N_WCB_USED, N_WCB_HEJI, N_WCB_HEJIEX, N_WCB_LEAVE, N_WCB_BUY, N_WCB_TOTALBUY, N_WCB_PRICE, I_WCB_BUYCOUNT, I_WCB_WLBUYCOUNT, VC_WCB_REMOTECLOSEVALVE, VC_WCB_REVEAL, VC_WCB_COMMUNICATEBAD, VC_WCB_MAGNETICDISTURBANCE, VC_WCB_VALVESTATE, VC_WCB_BATTERY, VC_WCB_FLOW, VC_WCB_BATTERYPER, VC_WCB_BATTERYMILL, VC_WCB_SPAREBATTERYMILL, VC_WCB_ADDRESS, VC_WCB_CODE, VC_WCB_VALVEERR, VC_WCB_ARREARSCLOSEVALUE, VC_WCB_INNERBATERR, VC_WCB_DIE, VC_WCB_TILT, VC_WCB_MONTHVALUE, EXECE_DATE, EXECE_STATE, VC_WCB_USEDATE, VC_WCB_USERNAME, VC_WCB_ALARMVALUE, VC_WCB_SIGNALINTENSITY, I_WCB_REPORTCOUNT, N_WCB_JTNUM1, N_WCB_JTPRICE1, N_WCB_JTAMOUNT1, N_WCB_JTNUM2, N_WCB_JTPRICE2, N_WCB_JTAMOUNT2, N_WCB_JTNUM3, N_WCB_JTPRICE3, N_WCB_JTAMOUNT3, N_WCB_JTNUM4, N_WCB_JTPRICE4, N_WCB_JTAMOUNT4, N_WCB_JTNUM5, N_WCB_JTPRICE5, N_WCB_JTAMOUNT5, N_WCB_JTNUM6, N_WCB_JTPRICE6, N_WCB_JTAMOUNT6 from t_guiji_gas_zenner_meter_reading_infor
    </sql>

    <select id="selectList" parameterType="TGuijiZennerMeterReadingInfor" resultType="TGuijiZennerMeterReadingInfor">
        <include refid="selectVo"/>
        <where>
            <if test="GUID != null  and GUID != ''"> and GUID like concat('%', #{GUID}, '%')</if>
            <if test="VC_WCB_USERGUID != null  and VC_WCB_USERGUID != ''"> and VC_WCB_USERGUID like concat('%', #{VC_WCB_USERGUID}, '%')</if>
            <if test="VC_WCB_METERGUID != null  and VC_WCB_METERGUID != ''"> and VC_WCB_METERGUID like concat('%', #{VC_WCB_METERGUID}, '%')</if>
            <if test="VC_WCB_PERSON != null  and VC_WCB_PERSON != ''"> and VC_WCB_PERSON like concat('%', #{VC_WCB_PERSON}, '%')</if>
            <if test="D_WCB_OPDATE != null  and D_WCB_OPDATE != ''"> and D_WCB_OPDATE like concat('%', #{D_WCB_OPDATE}, '%')</if>
            <if test="N_WCB_USED != null  and N_WCB_USED != ''"> and N_WCB_USED like concat('%', #{N_WCB_USED}, '%')</if>
            <if test="N_WCB_HEJI != null  and N_WCB_HEJI != ''"> and N_WCB_HEJI like concat('%', #{N_WCB_HEJI}, '%')</if>
            <if test="N_WCB_HEJIEX != null  and N_WCB_HEJIEX != ''"> and N_WCB_HEJIEX like concat('%', #{N_WCB_HEJIEX}, '%')</if>
            <if test="N_WCB_LEAVE != null  and N_WCB_LEAVE != ''"> and N_WCB_LEAVE like concat('%', #{N_WCB_LEAVE}, '%')</if>
            <if test="N_WCB_BUY != null  and N_WCB_BUY != ''"> and N_WCB_BUY like concat('%', #{N_WCB_BUY}, '%')</if>
            <if test="N_WCB_TOTALBUY != null  and N_WCB_TOTALBUY != ''"> and N_WCB_TOTALBUY like concat('%', #{N_WCB_TOTALBUY}, '%')</if>
            <if test="N_WCB_PRICE != null  and N_WCB_PRICE != ''"> and N_WCB_PRICE like concat('%', #{N_WCB_PRICE}, '%')</if>
            <if test="I_WCB_BUYCOUNT != null  and I_WCB_BUYCOUNT != ''"> and I_WCB_BUYCOUNT like concat('%', #{I_WCB_BUYCOUNT}, '%')</if>
            <if test="I_WCB_WLBUYCOUNT != null  and I_WCB_WLBUYCOUNT != ''"> and I_WCB_WLBUYCOUNT like concat('%', #{I_WCB_WLBUYCOUNT}, '%')</if>
            <if test="VC_WCB_REMOTECLOSEVALVE != null  and VC_WCB_REMOTECLOSEVALVE != ''"> and VC_WCB_REMOTECLOSEVALVE like concat('%', #{VC_WCB_REMOTECLOSEVALVE}, '%')</if>
            <if test="VC_WCB_REVEAL != null  and VC_WCB_REVEAL != ''"> and VC_WCB_REVEAL like concat('%', #{VC_WCB_REVEAL}, '%')</if>
            <if test="VC_WCB_COMMUNICATEBAD != null  and VC_WCB_COMMUNICATEBAD != ''"> and VC_WCB_COMMUNICATEBAD like concat('%', #{VC_WCB_COMMUNICATEBAD}, '%')</if>
            <if test="VC_WCB_MAGNETICDISTURBANCE != null  and VC_WCB_MAGNETICDISTURBANCE != ''"> and VC_WCB_MAGNETICDISTURBANCE like concat('%', #{VC_WCB_MAGNETICDISTURBANCE}, '%')</if>
            <if test="VC_WCB_VALVESTATE != null  and VC_WCB_VALVESTATE != ''"> and VC_WCB_VALVESTATE like concat('%', #{VC_WCB_VALVESTATE}, '%')</if>
            <if test="VC_WCB_BATTERY != null  and VC_WCB_BATTERY != ''"> and VC_WCB_BATTERY like concat('%', #{VC_WCB_BATTERY}, '%')</if>
            <if test="VC_WCB_FLOW != null  and VC_WCB_FLOW != ''"> and VC_WCB_FLOW like concat('%', #{VC_WCB_FLOW}, '%')</if>
            <if test="VC_WCB_BATTERYPER != null  and VC_WCB_BATTERYPER != ''"> and VC_WCB_BATTERYPER like concat('%', #{VC_WCB_BATTERYPER}, '%')</if>
            <if test="VC_WCB_BATTERYMILL != null  and VC_WCB_BATTERYMILL != ''"> and VC_WCB_BATTERYMILL like concat('%', #{VC_WCB_BATTERYMILL}, '%')</if>
            <if test="VC_WCB_SPAREBATTERYMILL != null  and VC_WCB_SPAREBATTERYMILL != ''"> and VC_WCB_SPAREBATTERYMILL like concat('%', #{VC_WCB_SPAREBATTERYMILL}, '%')</if>
            <if test="VC_WCB_ADDRESS != null  and VC_WCB_ADDRESS != ''"> and VC_WCB_ADDRESS like concat('%', #{VC_WCB_ADDRESS}, '%')</if>
            <if test="VC_WCB_CODE != null  and VC_WCB_CODE != ''"> and VC_WCB_CODE like concat('%', #{VC_WCB_CODE}, '%')</if>
            <if test="VC_WCB_VALVEERR != null  and VC_WCB_VALVEERR != ''"> and VC_WCB_VALVEERR like concat('%', #{VC_WCB_VALVEERR}, '%')</if>
            <if test="VC_WCB_ARREARSCLOSEVALUE != null  and VC_WCB_ARREARSCLOSEVALUE != ''"> and VC_WCB_ARREARSCLOSEVALUE like concat('%', #{VC_WCB_ARREARSCLOSEVALUE}, '%')</if>
            <if test="VC_WCB_INNERBATERR != null  and VC_WCB_INNERBATERR != ''"> and VC_WCB_INNERBATERR like concat('%', #{VC_WCB_INNERBATERR}, '%')</if>
            <if test="VC_WCB_DIE != null  and VC_WCB_DIE != ''"> and VC_WCB_DIE like concat('%', #{VC_WCB_DIE}, '%')</if>
            <if test="VC_WCB_TILT != null  and VC_WCB_TILT != ''"> and VC_WCB_TILT like concat('%', #{VC_WCB_TILT}, '%')</if>
            <if test="VC_WCB_MONTHVALUE != null  and VC_WCB_MONTHVALUE != ''"> and VC_WCB_MONTHVALUE like concat('%', #{VC_WCB_MONTHVALUE}, '%')</if>
            <if test="EXECE_DATE != null  and EXECE_DATE != ''"> and EXECE_DATE like concat('%', #{EXECE_DATE}, '%')</if>
            <if test="EXECE_STATE != null  and EXECE_STATE != ''"> and EXECE_STATE like concat('%', #{EXECE_STATE}, '%')</if>
            <if test="VC_WCB_USEDATE != null  and VC_WCB_USEDATE != ''"> and VC_WCB_USEDATE like concat('%', #{VC_WCB_USEDATE}, '%')</if>
            <if test="VC_WCB_USERNAME != null  and VC_WCB_USERNAME != ''"> and VC_WCB_USERNAME like concat('%', #{VC_WCB_USERNAME}, '%')</if>
            <if test="VC_WCB_ALARMVALUE != null  and VC_WCB_ALARMVALUE != ''"> and VC_WCB_ALARMVALUE like concat('%', #{VC_WCB_ALARMVALUE}, '%')</if>
            <if test="VC_WCB_SIGNALINTENSITY != null  and VC_WCB_SIGNALINTENSITY != ''"> and VC_WCB_SIGNALINTENSITY like concat('%', #{VC_WCB_SIGNALINTENSITY}, '%')</if>
            <if test="I_WCB_REPORTCOUNT != null  and I_WCB_REPORTCOUNT != ''"> and I_WCB_REPORTCOUNT like concat('%', #{I_WCB_REPORTCOUNT}, '%')</if>
            <if test="N_WCB_JTNUM1 != null  and N_WCB_JTNUM1 != ''"> and N_WCB_JTNUM1 like concat('%', #{N_WCB_JTNUM1}, '%')</if>
            <if test="N_WCB_JTPRICE1 != null  and N_WCB_JTPRICE1 != ''"> and N_WCB_JTPRICE1 like concat('%', #{N_WCB_JTPRICE1}, '%')</if>
            <if test="N_WCB_JTAMOUNT1 != null  and N_WCB_JTAMOUNT1 != ''"> and N_WCB_JTAMOUNT1 like concat('%', #{N_WCB_JTAMOUNT1}, '%')</if>
            <if test="N_WCB_JTNUM2 != null  and N_WCB_JTNUM2 != ''"> and N_WCB_JTNUM2 like concat('%', #{N_WCB_JTNUM2}, '%')</if>
            <if test="N_WCB_JTPRICE2 != null  and N_WCB_JTPRICE2 != ''"> and N_WCB_JTPRICE2 like concat('%', #{N_WCB_JTPRICE2}, '%')</if>
            <if test="N_WCB_JTAMOUNT2 != null  and N_WCB_JTAMOUNT2 != ''"> and N_WCB_JTAMOUNT2 like concat('%', #{N_WCB_JTAMOUNT2}, '%')</if>
            <if test="N_WCB_JTNUM3 != null  and N_WCB_JTNUM3 != ''"> and N_WCB_JTNUM3 like concat('%', #{N_WCB_JTNUM3}, '%')</if>
            <if test="N_WCB_JTPRICE3 != null  and N_WCB_JTPRICE3 != ''"> and N_WCB_JTPRICE3 like concat('%', #{N_WCB_JTPRICE3}, '%')</if>
            <if test="N_WCB_JTAMOUNT3 != null  and N_WCB_JTAMOUNT3 != ''"> and N_WCB_JTAMOUNT3 like concat('%', #{N_WCB_JTAMOUNT3}, '%')</if>
            <if test="N_WCB_JTNUM4 != null  and N_WCB_JTNUM4 != ''"> and N_WCB_JTNUM4 like concat('%', #{N_WCB_JTNUM4}, '%')</if>
            <if test="N_WCB_JTPRICE4 != null  and N_WCB_JTPRICE4 != ''"> and N_WCB_JTPRICE4 like concat('%', #{N_WCB_JTPRICE4}, '%')</if>
            <if test="N_WCB_JTAMOUNT4 != null  and N_WCB_JTAMOUNT4 != ''"> and N_WCB_JTAMOUNT4 like concat('%', #{N_WCB_JTAMOUNT4}, '%')</if>
            <if test="N_WCB_JTNUM5 != null  and N_WCB_JTNUM5 != ''"> and N_WCB_JTNUM5 like concat('%', #{N_WCB_JTNUM5}, '%')</if>
            <if test="N_WCB_JTPRICE5 != null  and N_WCB_JTPRICE5 != ''"> and N_WCB_JTPRICE5 like concat('%', #{N_WCB_JTPRICE5}, '%')</if>
            <if test="N_WCB_JTAMOUNT5 != null  and N_WCB_JTAMOUNT5 != ''"> and N_WCB_JTAMOUNT5 like concat('%', #{N_WCB_JTAMOUNT5}, '%')</if>
            <if test="N_WCB_JTNUM6 != null  and N_WCB_JTNUM6 != ''"> and N_WCB_JTNUM6 like concat('%', #{N_WCB_JTNUM6}, '%')</if>
            <if test="N_WCB_JTPRICE6 != null  and N_WCB_JTPRICE6 != ''"> and N_WCB_JTPRICE6 like concat('%', #{N_WCB_JTPRICE6}, '%')</if>
            <if test="N_WCB_JTAMOUNT6 != null  and N_WCB_JTAMOUNT6 != ''"> and N_WCB_JTAMOUNT6 like concat('%', #{N_WCB_JTAMOUNT6}, '%')</if>
        </where>
    </select>

    <select id="selectListbyIds" parameterType="java.util.Map" resultType="TGuijiZennerMeterReadingInfor">
        <include refid="selectVo"/>
        where id in (${ids})
    </select>

    <select id="selectIds" parameterType="TGuijiZennerMeterReadingInfor" resultType="TGuijiZennerMeterReadingInfor">
        select id from t_guiji_gas_zenner_meter_reading_infor
        where 1 = 1
        <if test="GUID != null  and GUID != ''"> and GUID like concat('%', #{GUID}, '%')</if>
        <if test="VC_WCB_USERGUID != null  and VC_WCB_USERGUID != ''"> and VC_WCB_USERGUID like concat('%', #{VC_WCB_USERGUID}, '%')</if>
        <if test="VC_WCB_METERGUID != null  and VC_WCB_METERGUID != ''"> and VC_WCB_METERGUID like concat('%', #{VC_WCB_METERGUID}, '%')</if>
        <if test="VC_WCB_PERSON != null  and VC_WCB_PERSON != ''"> and VC_WCB_PERSON like concat('%', #{VC_WCB_PERSON}, '%')</if>
        <if test="D_WCB_OPDATE != null  and D_WCB_OPDATE != ''"> and D_WCB_OPDATE like concat('%', #{D_WCB_OPDATE}, '%')</if>
        <if test="N_WCB_USED != null  and N_WCB_USED != ''"> and N_WCB_USED like concat('%', #{N_WCB_USED}, '%')</if>
        <if test="N_WCB_HEJI != null  and N_WCB_HEJI != ''"> and N_WCB_HEJI like concat('%', #{N_WCB_HEJI}, '%')</if>
        <if test="N_WCB_HEJIEX != null  and N_WCB_HEJIEX != ''"> and N_WCB_HEJIEX like concat('%', #{N_WCB_HEJIEX}, '%')</if>
        <if test="N_WCB_LEAVE != null  and N_WCB_LEAVE != ''"> and N_WCB_LEAVE like concat('%', #{N_WCB_LEAVE}, '%')</if>
        <if test="N_WCB_BUY != null  and N_WCB_BUY != ''"> and N_WCB_BUY like concat('%', #{N_WCB_BUY}, '%')</if>
        <if test="N_WCB_TOTALBUY != null  and N_WCB_TOTALBUY != ''"> and N_WCB_TOTALBUY like concat('%', #{N_WCB_TOTALBUY}, '%')</if>
        <if test="N_WCB_PRICE != null  and N_WCB_PRICE != ''"> and N_WCB_PRICE like concat('%', #{N_WCB_PRICE}, '%')</if>
        <if test="I_WCB_BUYCOUNT != null  and I_WCB_BUYCOUNT != ''"> and I_WCB_BUYCOUNT like concat('%', #{I_WCB_BUYCOUNT}, '%')</if>
        <if test="I_WCB_WLBUYCOUNT != null  and I_WCB_WLBUYCOUNT != ''"> and I_WCB_WLBUYCOUNT like concat('%', #{I_WCB_WLBUYCOUNT}, '%')</if>
        <if test="VC_WCB_REMOTECLOSEVALVE != null  and VC_WCB_REMOTECLOSEVALVE != ''"> and VC_WCB_REMOTECLOSEVALVE like concat('%', #{VC_WCB_REMOTECLOSEVALVE}, '%')</if>
        <if test="VC_WCB_REVEAL != null  and VC_WCB_REVEAL != ''"> and VC_WCB_REVEAL like concat('%', #{VC_WCB_REVEAL}, '%')</if>
        <if test="VC_WCB_COMMUNICATEBAD != null  and VC_WCB_COMMUNICATEBAD != ''"> and VC_WCB_COMMUNICATEBAD like concat('%', #{VC_WCB_COMMUNICATEBAD}, '%')</if>
        <if test="VC_WCB_MAGNETICDISTURBANCE != null  and VC_WCB_MAGNETICDISTURBANCE != ''"> and VC_WCB_MAGNETICDISTURBANCE like concat('%', #{VC_WCB_MAGNETICDISTURBANCE}, '%')</if>
        <if test="VC_WCB_VALVESTATE != null  and VC_WCB_VALVESTATE != ''"> and VC_WCB_VALVESTATE like concat('%', #{VC_WCB_VALVESTATE}, '%')</if>
        <if test="VC_WCB_BATTERY != null  and VC_WCB_BATTERY != ''"> and VC_WCB_BATTERY like concat('%', #{VC_WCB_BATTERY}, '%')</if>
        <if test="VC_WCB_FLOW != null  and VC_WCB_FLOW != ''"> and VC_WCB_FLOW like concat('%', #{VC_WCB_FLOW}, '%')</if>
        <if test="VC_WCB_BATTERYPER != null  and VC_WCB_BATTERYPER != ''"> and VC_WCB_BATTERYPER like concat('%', #{VC_WCB_BATTERYPER}, '%')</if>
        <if test="VC_WCB_BATTERYMILL != null  and VC_WCB_BATTERYMILL != ''"> and VC_WCB_BATTERYMILL like concat('%', #{VC_WCB_BATTERYMILL}, '%')</if>
        <if test="VC_WCB_SPAREBATTERYMILL != null  and VC_WCB_SPAREBATTERYMILL != ''"> and VC_WCB_SPAREBATTERYMILL like concat('%', #{VC_WCB_SPAREBATTERYMILL}, '%')</if>
        <if test="VC_WCB_ADDRESS != null  and VC_WCB_ADDRESS != ''"> and VC_WCB_ADDRESS like concat('%', #{VC_WCB_ADDRESS}, '%')</if>
        <if test="VC_WCB_CODE != null  and VC_WCB_CODE != ''"> and VC_WCB_CODE like concat('%', #{VC_WCB_CODE}, '%')</if>
        <if test="VC_WCB_VALVEERR != null  and VC_WCB_VALVEERR != ''"> and VC_WCB_VALVEERR like concat('%', #{VC_WCB_VALVEERR}, '%')</if>
        <if test="VC_WCB_ARREARSCLOSEVALUE != null  and VC_WCB_ARREARSCLOSEVALUE != ''"> and VC_WCB_ARREARSCLOSEVALUE like concat('%', #{VC_WCB_ARREARSCLOSEVALUE}, '%')</if>
        <if test="VC_WCB_INNERBATERR != null  and VC_WCB_INNERBATERR != ''"> and VC_WCB_INNERBATERR like concat('%', #{VC_WCB_INNERBATERR}, '%')</if>
        <if test="VC_WCB_DIE != null  and VC_WCB_DIE != ''"> and VC_WCB_DIE like concat('%', #{VC_WCB_DIE}, '%')</if>
        <if test="VC_WCB_TILT != null  and VC_WCB_TILT != ''"> and VC_WCB_TILT like concat('%', #{VC_WCB_TILT}, '%')</if>
        <if test="VC_WCB_MONTHVALUE != null  and VC_WCB_MONTHVALUE != ''"> and VC_WCB_MONTHVALUE like concat('%', #{VC_WCB_MONTHVALUE}, '%')</if>
        <if test="EXECE_DATE != null  and EXECE_DATE != ''"> and EXECE_DATE like concat('%', #{EXECE_DATE}, '%')</if>
        <if test="EXECE_STATE != null  and EXECE_STATE != ''"> and EXECE_STATE like concat('%', #{EXECE_STATE}, '%')</if>
        <if test="VC_WCB_USEDATE != null  and VC_WCB_USEDATE != ''"> and VC_WCB_USEDATE like concat('%', #{VC_WCB_USEDATE}, '%')</if>
        <if test="VC_WCB_USERNAME != null  and VC_WCB_USERNAME != ''"> and VC_WCB_USERNAME like concat('%', #{VC_WCB_USERNAME}, '%')</if>
        <if test="VC_WCB_ALARMVALUE != null  and VC_WCB_ALARMVALUE != ''"> and VC_WCB_ALARMVALUE like concat('%', #{VC_WCB_ALARMVALUE}, '%')</if>
        <if test="VC_WCB_SIGNALINTENSITY != null  and VC_WCB_SIGNALINTENSITY != ''"> and VC_WCB_SIGNALINTENSITY like concat('%', #{VC_WCB_SIGNALINTENSITY}, '%')</if>
        <if test="I_WCB_REPORTCOUNT != null  and I_WCB_REPORTCOUNT != ''"> and I_WCB_REPORTCOUNT like concat('%', #{I_WCB_REPORTCOUNT}, '%')</if>
        <if test="N_WCB_JTNUM1 != null  and N_WCB_JTNUM1 != ''"> and N_WCB_JTNUM1 like concat('%', #{N_WCB_JTNUM1}, '%')</if>
        <if test="N_WCB_JTPRICE1 != null  and N_WCB_JTPRICE1 != ''"> and N_WCB_JTPRICE1 like concat('%', #{N_WCB_JTPRICE1}, '%')</if>
        <if test="N_WCB_JTAMOUNT1 != null  and N_WCB_JTAMOUNT1 != ''"> and N_WCB_JTAMOUNT1 like concat('%', #{N_WCB_JTAMOUNT1}, '%')</if>
        <if test="N_WCB_JTNUM2 != null  and N_WCB_JTNUM2 != ''"> and N_WCB_JTNUM2 like concat('%', #{N_WCB_JTNUM2}, '%')</if>
        <if test="N_WCB_JTPRICE2 != null  and N_WCB_JTPRICE2 != ''"> and N_WCB_JTPRICE2 like concat('%', #{N_WCB_JTPRICE2}, '%')</if>
        <if test="N_WCB_JTAMOUNT2 != null  and N_WCB_JTAMOUNT2 != ''"> and N_WCB_JTAMOUNT2 like concat('%', #{N_WCB_JTAMOUNT2}, '%')</if>
        <if test="N_WCB_JTNUM3 != null  and N_WCB_JTNUM3 != ''"> and N_WCB_JTNUM3 like concat('%', #{N_WCB_JTNUM3}, '%')</if>
        <if test="N_WCB_JTPRICE3 != null  and N_WCB_JTPRICE3 != ''"> and N_WCB_JTPRICE3 like concat('%', #{N_WCB_JTPRICE3}, '%')</if>
        <if test="N_WCB_JTAMOUNT3 != null  and N_WCB_JTAMOUNT3 != ''"> and N_WCB_JTAMOUNT3 like concat('%', #{N_WCB_JTAMOUNT3}, '%')</if>
        <if test="N_WCB_JTNUM4 != null  and N_WCB_JTNUM4 != ''"> and N_WCB_JTNUM4 like concat('%', #{N_WCB_JTNUM4}, '%')</if>
        <if test="N_WCB_JTPRICE4 != null  and N_WCB_JTPRICE4 != ''"> and N_WCB_JTPRICE4 like concat('%', #{N_WCB_JTPRICE4}, '%')</if>
        <if test="N_WCB_JTAMOUNT4 != null  and N_WCB_JTAMOUNT4 != ''"> and N_WCB_JTAMOUNT4 like concat('%', #{N_WCB_JTAMOUNT4}, '%')</if>
        <if test="N_WCB_JTNUM5 != null  and N_WCB_JTNUM5 != ''"> and N_WCB_JTNUM5 like concat('%', #{N_WCB_JTNUM5}, '%')</if>
        <if test="N_WCB_JTPRICE5 != null  and N_WCB_JTPRICE5 != ''"> and N_WCB_JTPRICE5 like concat('%', #{N_WCB_JTPRICE5}, '%')</if>
        <if test="N_WCB_JTAMOUNT5 != null  and N_WCB_JTAMOUNT5 != ''"> and N_WCB_JTAMOUNT5 like concat('%', #{N_WCB_JTAMOUNT5}, '%')</if>
        <if test="N_WCB_JTNUM6 != null  and N_WCB_JTNUM6 != ''"> and N_WCB_JTNUM6 like concat('%', #{N_WCB_JTNUM6}, '%')</if>
        <if test="N_WCB_JTPRICE6 != null  and N_WCB_JTPRICE6 != ''"> and N_WCB_JTPRICE6 like concat('%', #{N_WCB_JTPRICE6}, '%')</if>
        <if test="N_WCB_JTAMOUNT6 != null  and N_WCB_JTAMOUNT6 != ''"> and N_WCB_JTAMOUNT6 like concat('%', #{N_WCB_JTAMOUNT6}, '%')</if>
        <!-- 数据分页过滤 -->
        ${params.limit}
    </select>

    <select id="selectById" parameterType="String" resultType="TGuijiZennerMeterReadingInfor">
        <include refid="selectVo"/>
        where id = #{id}
    </select>

    <insert id="insert" parameterType="TGuijiZennerMeterReadingInfor">
        insert into t_guiji_gas_zenner_meter_reading_infor
        <trim prefix="(" suffix=")" suffixOverrides=",">
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
         </trim>
    </insert>

    <update id="update" parameterType="TGuijiZennerMeterReadingInfor">
        update t_guiji_gas_zenner_meter_reading_infor
        <trim prefix="SET" suffixOverrides=",">
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteById" parameterType="String">
        delete from t_guiji_gas_zenner_meter_reading_infor where id = #{id}
    </delete>

    <delete id="deleteByIds" parameterType="String">
        delete from t_guiji_gas_zenner_meter_reading_infor where id in
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>

</mapper>
