<?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.unis.base.server.dao.TyChubeilyynbaoDao" >
  <resultMap id="BaseResultMap" type="com.unis.base.server.entity.TyChubeilyynbao" >
    <id column="id" property="id" jdbcType="VARCHAR" />
    <result column="pzzb" property="pzzb" jdbcType="VARCHAR" />
    <result column="qckc" property="qckc" jdbcType="VARCHAR" />
    <result column="srhjxj" property="srhjxj" jdbcType="VARCHAR" />
    <result column="srhjcsczgjxj" property="srhjcsczgjxj" jdbcType="VARCHAR" />
    <result column="srhjcsczgjsw" property="srhjcsczgjsw" jdbcType="VARCHAR" />
    <result column="srhjcqygjxj" property="srhjcqygjxj" jdbcType="VARCHAR" />
    <result column="srhjcqygjsw" property="srhjcqygjsw" jdbcType="VARCHAR" />
    <result column="srhjsplyzr" property="srhjsplyzr" jdbcType="VARCHAR" />
    <result column="srhjjk" property="srhjjk" jdbcType="VARCHAR" />
    <result column="srhjqtsr" property="srhjqtsr" jdbcType="VARCHAR" />
    <result column="zchjxj" property="zchjxj" jdbcType="VARCHAR" />
    <result column="zchjxsxj" property="zchjxsxj" jdbcType="VARCHAR" />
    <result column="zchjxssw" property="zchjxssw" jdbcType="VARCHAR" />
    <result column="zchjzzsply" property="zchjzzsply" jdbcType="VARCHAR" />
    <result column="zchjck" property="zchjck" jdbcType="VARCHAR" />
    <result column="zchjqtzc" property="zchjqtzc" jdbcType="VARCHAR" />
    <result column="qmkcxj" property="qmkcxj" jdbcType="VARCHAR" />
    <result column="qmkcascndhfxj" property="qmkcascndhfxj" jdbcType="VARCHAR" />
    <result column="qmkcerlingyiwuq" property="qmkcerlingyiwuq" jdbcType="VARCHAR" />
    <result column="qmkcerlingyiliu" property="qmkcerlingyiliu" jdbcType="VARCHAR" />
    <result column="qmkcerlingyiqi" property="qmkcerlingyiqi" jdbcType="VARCHAR" />
    <result column="qmkcerlingyiba" property="qmkcerlingyiba" jdbcType="VARCHAR" />
    <result column="qmkcerlingyijiu" property="qmkcerlingyijiu" jdbcType="VARCHAR" />
    <result column="qmkcerlingerling" property="qmkcerlingerling" jdbcType="VARCHAR" />
    <result column="qmkcerlingeryi" property="qmkcerlingeryi" jdbcType="VARCHAR" />
    <result column="qmkcerlingerer" property="qmkcerlingerer" jdbcType="VARCHAR" />
    <result column="qmkcerlingersan" property="qmkcerlingersan" jdbcType="VARCHAR" />
    <result column="qmkcerlingersi" property="qmkcerlingersi" jdbcType="VARCHAR" />
    <result column="qmkcerlingerwu" property="qmkcerlingerwu" jdbcType="VARCHAR" />
    <result column="qmkcxbz" property="qmkcxbz" jdbcType="VARCHAR" />
    <result column="qmkcswcc" property="qmkcswcc" jdbcType="VARCHAR" />
    <result column="dtcb" property="dtcb" jdbcType="VARCHAR" />
    <result column="type" property="type" jdbcType="INTEGER" />
    <result column="baobiaoshijian" property="baobiaoshijian" jdbcType="VARCHAR" />
    <result column="yuebaoornianbao" property="yuebaoornianbao" jdbcType="INTEGER" />
    <result column="cjdw" property="cjdw" jdbcType="VARCHAR" />
    <result column="cjsj" property="cjsj" jdbcType="TIMESTAMP" />
    <result column="insertnumber" property="insertnumber" jdbcType="INTEGER" />
  </resultMap>
  <sql id="Example_Where_Clause" >
    <where >
      <foreach collection="oredCriteria" item="criteria" separator="or" >
        <if test="criteria.valid" >
          <trim prefix="(" suffix=")" prefixOverrides="and" >
            <foreach collection="criteria.criteria" item="criterion" >
              <choose >
                <when test="criterion.noValue" >
                  and ${criterion.condition}
                </when>
                <when test="criterion.singleValue" >
                  and ${criterion.condition} #{criterion.value}
                </when>
                <when test="criterion.betweenValue" >
                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
                </when>
                <when test="criterion.listValue" >
                  and ${criterion.condition}
                  <foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," >
                    #{listItem}
                  </foreach>
                </when>
              </choose>
            </foreach>
          </trim>
        </if>
      </foreach>
    </where>
  </sql>
  <sql id="Update_By_Example_Where_Clause" >
    <where >
      <foreach collection="example.oredCriteria" item="criteria" separator="or" >
        <if test="criteria.valid" >
          <trim prefix="(" suffix=")" prefixOverrides="and" >
            <foreach collection="criteria.criteria" item="criterion" >
              <choose >
                <when test="criterion.noValue" >
                  and ${criterion.condition}
                </when>
                <when test="criterion.singleValue" >
                  and ${criterion.condition} #{criterion.value}
                </when>
                <when test="criterion.betweenValue" >
                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
                </when>
                <when test="criterion.listValue" >
                  and ${criterion.condition}
                  <foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," >
                    #{listItem}
                  </foreach>
                </when>
              </choose>
            </foreach>
          </trim>
        </if>
      </foreach>
    </where>
  </sql>
  <sql id="Base_Column_List" >
    id, pzzb, qckc, srhjxj, srhjcsczgjxj, srhjcsczgjsw, srhjcqygjxj, srhjcqygjsw, srhjsplyzr, 
    srhjjk, srhjqtsr, zchjxj, zchjxsxj, zchjxssw, zchjzzsply, zchjck, zchjqtzc, qmkcxj, 
    qmkcascndhfxj, qmkcerlingyiwuq, qmkcerlingyiliu, qmkcerlingyiqi, qmkcerlingyiba, 
    qmkcerlingyijiu, qmkcerlingerling, qmkcerlingeryi, qmkcerlingerer, qmkcerlingersan, 
    qmkcerlingersi, qmkcerlingerwu, qmkcxbz, qmkcswcc, dtcb, type, baobiaoshijian, yuebaoornianbao, 
    cjdw, cjsj,insertnumber
  </sql>
  <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.unis.base.server.example.TyChubeilyynbaoExample" >
    select
    <if test="distinct" >
      distinct
    </if>
    <include refid="Base_Column_List" />
    from ty_chubeilyynbao
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null" >
      order by ${orderByClause}
    </if>
  </select>
  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
    select 
    <include refid="Base_Column_List" />
    from ty_chubeilyynbao
    where id = #{id,jdbcType=VARCHAR}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.String" >
    delete from ty_chubeilyynbao
    where id = #{id,jdbcType=VARCHAR}
  </delete>
  <delete id="deleteByExample" parameterType="com.unis.base.server.example.TyChubeilyynbaoExample" >
    delete from ty_chubeilyynbao
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </delete>
  <insert id="insert" parameterType="com.unis.base.server.entity.TyChubeilyynbao" >
    insert into ty_chubeilyynbao (id, pzzb, qckc, 
      srhjxj, srhjcsczgjxj, srhjcsczgjsw, 
      srhjcqygjxj, srhjcqygjsw, srhjsplyzr, 
      srhjjk, srhjqtsr, zchjxj, 
      zchjxsxj, zchjxssw, zchjzzsply, 
      zchjck, zchjqtzc, qmkcxj, 
      qmkcascndhfxj, qmkcerlingyiwuq, qmkcerlingyiliu, 
      qmkcerlingyiqi, qmkcerlingyiba, qmkcerlingyijiu, 
      qmkcerlingerling, qmkcerlingeryi, qmkcerlingerer, 
      qmkcerlingersan, qmkcerlingersi, qmkcerlingerwu, 
      qmkcxbz, qmkcswcc, dtcb, 
      type, baobiaoshijian, yuebaoornianbao, 
      cjdw, cjsj,insertnumber)
    values (#{id,jdbcType=VARCHAR}, #{pzzb,jdbcType=VARCHAR}, #{qckc,jdbcType=VARCHAR}, 
      #{srhjxj,jdbcType=VARCHAR}, #{srhjcsczgjxj,jdbcType=VARCHAR}, #{srhjcsczgjsw,jdbcType=VARCHAR}, 
      #{srhjcqygjxj,jdbcType=VARCHAR}, #{srhjcqygjsw,jdbcType=VARCHAR}, #{srhjsplyzr,jdbcType=VARCHAR}, 
      #{srhjjk,jdbcType=VARCHAR}, #{srhjqtsr,jdbcType=VARCHAR}, #{zchjxj,jdbcType=VARCHAR}, 
      #{zchjxsxj,jdbcType=VARCHAR}, #{zchjxssw,jdbcType=VARCHAR}, #{zchjzzsply,jdbcType=VARCHAR}, 
      #{zchjck,jdbcType=VARCHAR}, #{zchjqtzc,jdbcType=VARCHAR}, #{qmkcxj,jdbcType=VARCHAR}, 
      #{qmkcascndhfxj,jdbcType=VARCHAR}, #{qmkcerlingyiwuq,jdbcType=VARCHAR}, #{qmkcerlingyiliu,jdbcType=VARCHAR}, 
      #{qmkcerlingyiqi,jdbcType=VARCHAR}, #{qmkcerlingyiba,jdbcType=VARCHAR}, #{qmkcerlingyijiu,jdbcType=VARCHAR}, 
      #{qmkcerlingerling,jdbcType=VARCHAR}, #{qmkcerlingeryi,jdbcType=VARCHAR}, #{qmkcerlingerer,jdbcType=VARCHAR}, 
      #{qmkcerlingersan,jdbcType=VARCHAR}, #{qmkcerlingersi,jdbcType=VARCHAR}, #{qmkcerlingerwu,jdbcType=VARCHAR}, 
      #{qmkcxbz,jdbcType=VARCHAR}, #{qmkcswcc,jdbcType=VARCHAR}, #{dtcb,jdbcType=VARCHAR}, 
      #{type,jdbcType=INTEGER}, #{baobiaoshijian,jdbcType=VARCHAR}, #{yuebaoornianbao,jdbcType=INTEGER}, 
      #{cjdw,jdbcType=VARCHAR}, #{cjsj,jdbcType=TIMESTAMP},#{insertnumber,jdbcType=INTEGER})
  </insert>
  <insert id="insertSelective" parameterType="com.unis.base.server.entity.TyChubeilyynbao" >
    insert into ty_chubeilyynbao
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        id,
      </if>
      <if test="pzzb != null" >
        pzzb,
      </if>
      <if test="qckc != null" >
        qckc,
      </if>
      <if test="srhjxj != null" >
        srhjxj,
      </if>
      <if test="srhjcsczgjxj != null" >
        srhjcsczgjxj,
      </if>
      <if test="srhjcsczgjsw != null" >
        srhjcsczgjsw,
      </if>
      <if test="srhjcqygjxj != null" >
        srhjcqygjxj,
      </if>
      <if test="srhjcqygjsw != null" >
        srhjcqygjsw,
      </if>
      <if test="srhjsplyzr != null" >
        srhjsplyzr,
      </if>
      <if test="srhjjk != null" >
        srhjjk,
      </if>
      <if test="srhjqtsr != null" >
        srhjqtsr,
      </if>
      <if test="zchjxj != null" >
        zchjxj,
      </if>
      <if test="zchjxsxj != null" >
        zchjxsxj,
      </if>
      <if test="zchjxssw != null" >
        zchjxssw,
      </if>
      <if test="zchjzzsply != null" >
        zchjzzsply,
      </if>
      <if test="zchjck != null" >
        zchjck,
      </if>
      <if test="zchjqtzc != null" >
        zchjqtzc,
      </if>
      <if test="qmkcxj != null" >
        qmkcxj,
      </if>
      <if test="qmkcascndhfxj != null" >
        qmkcascndhfxj,
      </if>
      <if test="qmkcerlingyiwuq != null" >
        qmkcerlingyiwuq,
      </if>
      <if test="qmkcerlingyiliu != null" >
        qmkcerlingyiliu,
      </if>
      <if test="qmkcerlingyiqi != null" >
        qmkcerlingyiqi,
      </if>
      <if test="qmkcerlingyiba != null" >
        qmkcerlingyiba,
      </if>
      <if test="qmkcerlingyijiu != null" >
        qmkcerlingyijiu,
      </if>
      <if test="qmkcerlingerling != null" >
        qmkcerlingerling,
      </if>
      <if test="qmkcerlingeryi != null" >
        qmkcerlingeryi,
      </if>
      <if test="qmkcerlingerer != null" >
        qmkcerlingerer,
      </if>
      <if test="qmkcerlingersan != null" >
        qmkcerlingersan,
      </if>
      <if test="qmkcerlingersi != null" >
        qmkcerlingersi,
      </if>
      <if test="qmkcerlingerwu != null" >
        qmkcerlingerwu,
      </if>
      <if test="qmkcxbz != null" >
        qmkcxbz,
      </if>
      <if test="qmkcswcc != null" >
        qmkcswcc,
      </if>
      <if test="dtcb != null" >
        dtcb,
      </if>
      <if test="type != null" >
        type,
      </if>
      <if test="baobiaoshijian != null" >
        baobiaoshijian,
      </if>
      <if test="yuebaoornianbao != null" >
        yuebaoornianbao,
      </if>
      <if test="cjdw != null" >
        cjdw,
      </if>
      <if test="cjsj != null" >
        cjsj,
      </if>
      <if test="insertnumber != null" >
        insertnumber,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        #{id,jdbcType=VARCHAR},
      </if>
      <if test="pzzb != null" >
        #{pzzb,jdbcType=VARCHAR},
      </if>
      <if test="qckc != null" >
        #{qckc,jdbcType=VARCHAR},
      </if>
      <if test="srhjxj != null" >
        #{srhjxj,jdbcType=VARCHAR},
      </if>
      <if test="srhjcsczgjxj != null" >
        #{srhjcsczgjxj,jdbcType=VARCHAR},
      </if>
      <if test="srhjcsczgjsw != null" >
        #{srhjcsczgjsw,jdbcType=VARCHAR},
      </if>
      <if test="srhjcqygjxj != null" >
        #{srhjcqygjxj,jdbcType=VARCHAR},
      </if>
      <if test="srhjcqygjsw != null" >
        #{srhjcqygjsw,jdbcType=VARCHAR},
      </if>
      <if test="srhjsplyzr != null" >
        #{srhjsplyzr,jdbcType=VARCHAR},
      </if>
      <if test="srhjjk != null" >
        #{srhjjk,jdbcType=VARCHAR},
      </if>
      <if test="srhjqtsr != null" >
        #{srhjqtsr,jdbcType=VARCHAR},
      </if>
      <if test="zchjxj != null" >
        #{zchjxj,jdbcType=VARCHAR},
      </if>
      <if test="zchjxsxj != null" >
        #{zchjxsxj,jdbcType=VARCHAR},
      </if>
      <if test="zchjxssw != null" >
        #{zchjxssw,jdbcType=VARCHAR},
      </if>
      <if test="zchjzzsply != null" >
        #{zchjzzsply,jdbcType=VARCHAR},
      </if>
      <if test="zchjck != null" >
        #{zchjck,jdbcType=VARCHAR},
      </if>
      <if test="zchjqtzc != null" >
        #{zchjqtzc,jdbcType=VARCHAR},
      </if>
      <if test="qmkcxj != null" >
        #{qmkcxj,jdbcType=VARCHAR},
      </if>
      <if test="qmkcascndhfxj != null" >
        #{qmkcascndhfxj,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingyiwuq != null" >
        #{qmkcerlingyiwuq,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingyiliu != null" >
        #{qmkcerlingyiliu,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingyiqi != null" >
        #{qmkcerlingyiqi,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingyiba != null" >
        #{qmkcerlingyiba,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingyijiu != null" >
        #{qmkcerlingyijiu,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingerling != null" >
        #{qmkcerlingerling,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingeryi != null" >
        #{qmkcerlingeryi,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingerer != null" >
        #{qmkcerlingerer,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingersan != null" >
        #{qmkcerlingersan,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingersi != null" >
        #{qmkcerlingersi,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingerwu != null" >
        #{qmkcerlingerwu,jdbcType=VARCHAR},
      </if>
      <if test="qmkcxbz != null" >
        #{qmkcxbz,jdbcType=VARCHAR},
      </if>
      <if test="qmkcswcc != null" >
        #{qmkcswcc,jdbcType=VARCHAR},
      </if>
      <if test="dtcb != null" >
        #{dtcb,jdbcType=VARCHAR},
      </if>
      <if test="type != null" >
        #{type,jdbcType=INTEGER},
      </if>
      <if test="baobiaoshijian != null" >
        #{baobiaoshijian,jdbcType=VARCHAR},
      </if>
      <if test="yuebaoornianbao != null" >
        #{yuebaoornianbao,jdbcType=INTEGER},
      </if>
      <if test="cjdw != null" >
        #{cjdw,jdbcType=VARCHAR},
      </if>
      <if test="cjsj != null" >
        #{cjsj,jdbcType=TIMESTAMP},
      </if>
      <if test="insertnumber != null" >
        #{insertnumber,jdbcType=INTEGER},
      </if>
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.unis.base.server.example.TyChubeilyynbaoExample" resultType="java.lang.Integer" >
    select count(1) from ty_chubeilyynbao
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </select>
  <update id="updateByExampleSelective" parameterType="map" >
    update ty_chubeilyynbao
    <set >
      <if test="record.id != null" >
        id = #{record.id,jdbcType=VARCHAR},
      </if>
      <if test="record.pzzb != null" >
        pzzb = #{record.pzzb,jdbcType=VARCHAR},
      </if>
      <if test="record.qckc != null" >
        qckc = #{record.qckc,jdbcType=VARCHAR},
      </if>
      <if test="record.srhjxj != null" >
        srhjxj = #{record.srhjxj,jdbcType=VARCHAR},
      </if>
      <if test="record.srhjcsczgjxj != null" >
        srhjcsczgjxj = #{record.srhjcsczgjxj,jdbcType=VARCHAR},
      </if>
      <if test="record.srhjcsczgjsw != null" >
        srhjcsczgjsw = #{record.srhjcsczgjsw,jdbcType=VARCHAR},
      </if>
      <if test="record.srhjcqygjxj != null" >
        srhjcqygjxj = #{record.srhjcqygjxj,jdbcType=VARCHAR},
      </if>
      <if test="record.srhjcqygjsw != null" >
        srhjcqygjsw = #{record.srhjcqygjsw,jdbcType=VARCHAR},
      </if>
      <if test="record.srhjsplyzr != null" >
        srhjsplyzr = #{record.srhjsplyzr,jdbcType=VARCHAR},
      </if>
      <if test="record.srhjjk != null" >
        srhjjk = #{record.srhjjk,jdbcType=VARCHAR},
      </if>
      <if test="record.srhjqtsr != null" >
        srhjqtsr = #{record.srhjqtsr,jdbcType=VARCHAR},
      </if>
      <if test="record.zchjxj != null" >
        zchjxj = #{record.zchjxj,jdbcType=VARCHAR},
      </if>
      <if test="record.zchjxsxj != null" >
        zchjxsxj = #{record.zchjxsxj,jdbcType=VARCHAR},
      </if>
      <if test="record.zchjxssw != null" >
        zchjxssw = #{record.zchjxssw,jdbcType=VARCHAR},
      </if>
      <if test="record.zchjzzsply != null" >
        zchjzzsply = #{record.zchjzzsply,jdbcType=VARCHAR},
      </if>
      <if test="record.zchjck != null" >
        zchjck = #{record.zchjck,jdbcType=VARCHAR},
      </if>
      <if test="record.zchjqtzc != null" >
        zchjqtzc = #{record.zchjqtzc,jdbcType=VARCHAR},
      </if>
      <if test="record.qmkcxj != null" >
        qmkcxj = #{record.qmkcxj,jdbcType=VARCHAR},
      </if>
      <if test="record.qmkcascndhfxj != null" >
        qmkcascndhfxj = #{record.qmkcascndhfxj,jdbcType=VARCHAR},
      </if>
      <if test="record.qmkcerlingyiwuq != null" >
        qmkcerlingyiwuq = #{record.qmkcerlingyiwuq,jdbcType=VARCHAR},
      </if>
      <if test="record.qmkcerlingyiliu != null" >
        qmkcerlingyiliu = #{record.qmkcerlingyiliu,jdbcType=VARCHAR},
      </if>
      <if test="record.qmkcerlingyiqi != null" >
        qmkcerlingyiqi = #{record.qmkcerlingyiqi,jdbcType=VARCHAR},
      </if>
      <if test="record.qmkcerlingyiba != null" >
        qmkcerlingyiba = #{record.qmkcerlingyiba,jdbcType=VARCHAR},
      </if>
      <if test="record.qmkcerlingyijiu != null" >
        qmkcerlingyijiu = #{record.qmkcerlingyijiu,jdbcType=VARCHAR},
      </if>
      <if test="record.qmkcerlingerling != null" >
        qmkcerlingerling = #{record.qmkcerlingerling,jdbcType=VARCHAR},
      </if>
      <if test="record.qmkcerlingeryi != null" >
        qmkcerlingeryi = #{record.qmkcerlingeryi,jdbcType=VARCHAR},
      </if>
      <if test="record.qmkcerlingerer != null" >
        qmkcerlingerer = #{record.qmkcerlingerer,jdbcType=VARCHAR},
      </if>
      <if test="record.qmkcerlingersan != null" >
        qmkcerlingersan = #{record.qmkcerlingersan,jdbcType=VARCHAR},
      </if>
      <if test="record.qmkcerlingersi != null" >
        qmkcerlingersi = #{record.qmkcerlingersi,jdbcType=VARCHAR},
      </if>
      <if test="record.qmkcerlingerwu != null" >
        qmkcerlingerwu = #{record.qmkcerlingerwu,jdbcType=VARCHAR},
      </if>
      <if test="record.qmkcxbz != null" >
        qmkcxbz = #{record.qmkcxbz,jdbcType=VARCHAR},
      </if>
      <if test="record.qmkcswcc != null" >
        qmkcswcc = #{record.qmkcswcc,jdbcType=VARCHAR},
      </if>
      <if test="record.dtcb != null" >
        dtcb = #{record.dtcb,jdbcType=VARCHAR},
      </if>
      <if test="record.type != null" >
        type = #{record.type,jdbcType=INTEGER},
      </if>
      <if test="record.baobiaoshijian != null" >
        baobiaoshijian = #{record.baobiaoshijian,jdbcType=VARCHAR},
      </if>
      <if test="record.yuebaoornianbao != null" >
        yuebaoornianbao = #{record.yuebaoornianbao,jdbcType=INTEGER},
      </if>
      <if test="record.cjdw != null" >
        cjdw = #{record.cjdw,jdbcType=VARCHAR},
      </if>
      <if test="record.cjsj != null" >
        cjsj = #{record.cjsj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.insertnumber != null" >
        insertnumber = #{record.insertnumber,jdbcType=INTEGER},
      </if>
    </set>
    <if test="_parameter != null" >
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByExample" parameterType="map" >
    update ty_chubeilyynbao
    set id = #{record.id,jdbcType=VARCHAR},
      pzzb = #{record.pzzb,jdbcType=VARCHAR},
      qckc = #{record.qckc,jdbcType=VARCHAR},
      srhjxj = #{record.srhjxj,jdbcType=VARCHAR},
      srhjcsczgjxj = #{record.srhjcsczgjxj,jdbcType=VARCHAR},
      srhjcsczgjsw = #{record.srhjcsczgjsw,jdbcType=VARCHAR},
      srhjcqygjxj = #{record.srhjcqygjxj,jdbcType=VARCHAR},
      srhjcqygjsw = #{record.srhjcqygjsw,jdbcType=VARCHAR},
      srhjsplyzr = #{record.srhjsplyzr,jdbcType=VARCHAR},
      srhjjk = #{record.srhjjk,jdbcType=VARCHAR},
      srhjqtsr = #{record.srhjqtsr,jdbcType=VARCHAR},
      zchjxj = #{record.zchjxj,jdbcType=VARCHAR},
      zchjxsxj = #{record.zchjxsxj,jdbcType=VARCHAR},
      zchjxssw = #{record.zchjxssw,jdbcType=VARCHAR},
      zchjzzsply = #{record.zchjzzsply,jdbcType=VARCHAR},
      zchjck = #{record.zchjck,jdbcType=VARCHAR},
      zchjqtzc = #{record.zchjqtzc,jdbcType=VARCHAR},
      qmkcxj = #{record.qmkcxj,jdbcType=VARCHAR},
      qmkcascndhfxj = #{record.qmkcascndhfxj,jdbcType=VARCHAR},
      qmkcerlingyiwuq = #{record.qmkcerlingyiwuq,jdbcType=VARCHAR},
      qmkcerlingyiliu = #{record.qmkcerlingyiliu,jdbcType=VARCHAR},
      qmkcerlingyiqi = #{record.qmkcerlingyiqi,jdbcType=VARCHAR},
      qmkcerlingyiba = #{record.qmkcerlingyiba,jdbcType=VARCHAR},
      qmkcerlingyijiu = #{record.qmkcerlingyijiu,jdbcType=VARCHAR},
      qmkcerlingerling = #{record.qmkcerlingerling,jdbcType=VARCHAR},
      qmkcerlingeryi = #{record.qmkcerlingeryi,jdbcType=VARCHAR},
      qmkcerlingerer = #{record.qmkcerlingerer,jdbcType=VARCHAR},
      qmkcerlingersan = #{record.qmkcerlingersan,jdbcType=VARCHAR},
      qmkcerlingersi = #{record.qmkcerlingersi,jdbcType=VARCHAR},
      qmkcerlingerwu = #{record.qmkcerlingerwu,jdbcType=VARCHAR},
      qmkcxbz = #{record.qmkcxbz,jdbcType=VARCHAR},
      qmkcswcc = #{record.qmkcswcc,jdbcType=VARCHAR},
      dtcb = #{record.dtcb,jdbcType=VARCHAR},
      type = #{record.type,jdbcType=INTEGER},
      baobiaoshijian = #{record.baobiaoshijian,jdbcType=VARCHAR},
      yuebaoornianbao = #{record.yuebaoornianbao,jdbcType=INTEGER},
      cjdw = #{record.cjdw,jdbcType=VARCHAR},
      cjsj = #{record.cjsj,jdbcType=TIMESTAMP},
      insertnumber = #{record.insertnumber,jdbcType=INTEGER}
    <if test="_parameter != null" >
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByPrimaryKeySelective" parameterType="com.unis.base.server.entity.TyChubeilyynbao" >
    update ty_chubeilyynbao
    <set >
      <if test="pzzb != null" >
        pzzb = #{pzzb,jdbcType=VARCHAR},
      </if>
      <if test="qckc != null" >
        qckc = #{qckc,jdbcType=VARCHAR},
      </if>
      <if test="srhjxj != null" >
        srhjxj = #{srhjxj,jdbcType=VARCHAR},
      </if>
      <if test="srhjcsczgjxj != null" >
        srhjcsczgjxj = #{srhjcsczgjxj,jdbcType=VARCHAR},
      </if>
      <if test="srhjcsczgjsw != null" >
        srhjcsczgjsw = #{srhjcsczgjsw,jdbcType=VARCHAR},
      </if>
      <if test="srhjcqygjxj != null" >
        srhjcqygjxj = #{srhjcqygjxj,jdbcType=VARCHAR},
      </if>
      <if test="srhjcqygjsw != null" >
        srhjcqygjsw = #{srhjcqygjsw,jdbcType=VARCHAR},
      </if>
      <if test="srhjsplyzr != null" >
        srhjsplyzr = #{srhjsplyzr,jdbcType=VARCHAR},
      </if>
      <if test="srhjjk != null" >
        srhjjk = #{srhjjk,jdbcType=VARCHAR},
      </if>
      <if test="srhjqtsr != null" >
        srhjqtsr = #{srhjqtsr,jdbcType=VARCHAR},
      </if>
      <if test="zchjxj != null" >
        zchjxj = #{zchjxj,jdbcType=VARCHAR},
      </if>
      <if test="zchjxsxj != null" >
        zchjxsxj = #{zchjxsxj,jdbcType=VARCHAR},
      </if>
      <if test="zchjxssw != null" >
        zchjxssw = #{zchjxssw,jdbcType=VARCHAR},
      </if>
      <if test="zchjzzsply != null" >
        zchjzzsply = #{zchjzzsply,jdbcType=VARCHAR},
      </if>
      <if test="zchjck != null" >
        zchjck = #{zchjck,jdbcType=VARCHAR},
      </if>
      <if test="zchjqtzc != null" >
        zchjqtzc = #{zchjqtzc,jdbcType=VARCHAR},
      </if>
      <if test="qmkcxj != null" >
        qmkcxj = #{qmkcxj,jdbcType=VARCHAR},
      </if>
      <if test="qmkcascndhfxj != null" >
        qmkcascndhfxj = #{qmkcascndhfxj,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingyiwuq != null" >
        qmkcerlingyiwuq = #{qmkcerlingyiwuq,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingyiliu != null" >
        qmkcerlingyiliu = #{qmkcerlingyiliu,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingyiqi != null" >
        qmkcerlingyiqi = #{qmkcerlingyiqi,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingyiba != null" >
        qmkcerlingyiba = #{qmkcerlingyiba,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingyijiu != null" >
        qmkcerlingyijiu = #{qmkcerlingyijiu,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingerling != null" >
        qmkcerlingerling = #{qmkcerlingerling,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingeryi != null" >
        qmkcerlingeryi = #{qmkcerlingeryi,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingerer != null" >
        qmkcerlingerer = #{qmkcerlingerer,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingersan != null" >
        qmkcerlingersan = #{qmkcerlingersan,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingersi != null" >
        qmkcerlingersi = #{qmkcerlingersi,jdbcType=VARCHAR},
      </if>
      <if test="qmkcerlingerwu != null" >
        qmkcerlingerwu = #{qmkcerlingerwu,jdbcType=VARCHAR},
      </if>
      <if test="qmkcxbz != null" >
        qmkcxbz = #{qmkcxbz,jdbcType=VARCHAR},
      </if>
      <if test="qmkcswcc != null" >
        qmkcswcc = #{qmkcswcc,jdbcType=VARCHAR},
      </if>
      <if test="dtcb != null" >
        dtcb = #{dtcb,jdbcType=VARCHAR},
      </if>
      <if test="type != null" >
        type = #{type,jdbcType=INTEGER},
      </if>
      <if test="baobiaoshijian != null" >
        baobiaoshijian = #{baobiaoshijian,jdbcType=VARCHAR},
      </if>
      <if test="yuebaoornianbao != null" >
        yuebaoornianbao = #{yuebaoornianbao,jdbcType=INTEGER},
      </if>
      <if test="cjdw != null" >
        cjdw = #{cjdw,jdbcType=VARCHAR},
      </if>
      <if test="cjsj != null" >
        cjsj = #{cjsj,jdbcType=TIMESTAMP},
      </if>
      <if test="insertnumber != null" >
        insertnumber = #{insertnumber,jdbcType=INTEGER},
      </if>
    </set>
    where id = #{id,jdbcType=VARCHAR}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.unis.base.server.entity.TyChubeilyynbao" >
    update ty_chubeilyynbao
    set pzzb = #{pzzb,jdbcType=VARCHAR},
      qckc = #{qckc,jdbcType=VARCHAR},
      srhjxj = #{srhjxj,jdbcType=VARCHAR},
      srhjcsczgjxj = #{srhjcsczgjxj,jdbcType=VARCHAR},
      srhjcsczgjsw = #{srhjcsczgjsw,jdbcType=VARCHAR},
      srhjcqygjxj = #{srhjcqygjxj,jdbcType=VARCHAR},
      srhjcqygjsw = #{srhjcqygjsw,jdbcType=VARCHAR},
      srhjsplyzr = #{srhjsplyzr,jdbcType=VARCHAR},
      srhjjk = #{srhjjk,jdbcType=VARCHAR},
      srhjqtsr = #{srhjqtsr,jdbcType=VARCHAR},
      zchjxj = #{zchjxj,jdbcType=VARCHAR},
      zchjxsxj = #{zchjxsxj,jdbcType=VARCHAR},
      zchjxssw = #{zchjxssw,jdbcType=VARCHAR},
      zchjzzsply = #{zchjzzsply,jdbcType=VARCHAR},
      zchjck = #{zchjck,jdbcType=VARCHAR},
      zchjqtzc = #{zchjqtzc,jdbcType=VARCHAR},
      qmkcxj = #{qmkcxj,jdbcType=VARCHAR},
      qmkcascndhfxj = #{qmkcascndhfxj,jdbcType=VARCHAR},
      qmkcerlingyiwuq = #{qmkcerlingyiwuq,jdbcType=VARCHAR},
      qmkcerlingyiliu = #{qmkcerlingyiliu,jdbcType=VARCHAR},
      qmkcerlingyiqi = #{qmkcerlingyiqi,jdbcType=VARCHAR},
      qmkcerlingyiba = #{qmkcerlingyiba,jdbcType=VARCHAR},
      qmkcerlingyijiu = #{qmkcerlingyijiu,jdbcType=VARCHAR},
      qmkcerlingerling = #{qmkcerlingerling,jdbcType=VARCHAR},
      qmkcerlingeryi = #{qmkcerlingeryi,jdbcType=VARCHAR},
      qmkcerlingerer = #{qmkcerlingerer,jdbcType=VARCHAR},
      qmkcerlingersan = #{qmkcerlingersan,jdbcType=VARCHAR},
      qmkcerlingersi = #{qmkcerlingersi,jdbcType=VARCHAR},
      qmkcerlingerwu = #{qmkcerlingerwu,jdbcType=VARCHAR},
      qmkcxbz = #{qmkcxbz,jdbcType=VARCHAR},
      qmkcswcc = #{qmkcswcc,jdbcType=VARCHAR},
      dtcb = #{dtcb,jdbcType=VARCHAR},
      type = #{type,jdbcType=INTEGER},
      baobiaoshijian = #{baobiaoshijian,jdbcType=VARCHAR},
      yuebaoornianbao = #{yuebaoornianbao,jdbcType=INTEGER},
      cjdw = #{cjdw,jdbcType=VARCHAR},
      insertnumber = #{insertnumber,jdbcType=INTEGER},
      cjsj = #{cjsj,jdbcType=TIMESTAMP}
    where id = #{id,jdbcType=VARCHAR}
  </update>
</mapper>