<?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.ReversePositionDao" >
  <resultMap id="BaseResultMap" type="com.unis.base.server.entity.DCxxsjDo" >
    <id column="DCDBM" property="dcdbm" jdbcType="VARCHAR" />
    <result column="DCJHWJBH" property="dcjhwjbh" jdbcType="VARCHAR" />
    <result column="TZDBM" property="tzdbm" jdbcType="VARCHAR" />
    <result column="DCDW" property="dcdw" jdbcType="VARCHAR" />
    <result column="PZBM" property="pzbm" jdbcType="VARCHAR" />
    <result column="DCHWBM" property="dchwbm" jdbcType="VARCHAR" />
    <result column="DRHWBM" property="drhwbm" jdbcType="VARCHAR" />
    <result column="DCRQ" property="dcrq" jdbcType="TIMESTAMP" />
    <result column="CYR" property="cyr" jdbcType="VARCHAR" />
    <result column="SFZH" property="sfzh" jdbcType="VARCHAR" />
    <result column="LXDH" property="lxdh" jdbcType="VARCHAR" />
    <result column="YSGJ" property="ysgj" jdbcType="VARCHAR" />
    <result column="CCH" property="cch" jdbcType="VARCHAR" />
    <result column="RMDJY" property="rmdjy" jdbcType="VARCHAR" />
    <result column="RMDJSJ" property="rmdjsj" jdbcType="TIMESTAMP" />
    <result column="CMDJY" property="cmdjy" jdbcType="VARCHAR" />
    <result column="CMDJSJ" property="cmdjsj" jdbcType="TIMESTAMP" />
    <result column="MZ" property="mz" jdbcType="DECIMAL" />
    <result column="PZ" property="pz" jdbcType="DECIMAL" />
    <result column="XCKL" property="xckl" jdbcType="DECIMAL" />
    <result column="SZKZL" property="szkzl" jdbcType="DECIMAL" />
    <result column="QTKL" property="qtkl" jdbcType="DECIMAL" />
    <result column="QTKLSM" property="qtklsm" jdbcType="VARCHAR" />
    <result column="MZJJY" property="mzjjy" jdbcType="VARCHAR" />
    <result column="MZJBY" property="mzjby" jdbcType="VARCHAR" />
    <result column="CMSJ" property="cmsj" jdbcType="VARCHAR" />
    <result column="PZJJY" property="pzjjy" jdbcType="VARCHAR" />
    <result column="PZJBY" property="pzjby" jdbcType="VARCHAR" />
    <result column="CPSJ" property="cpsj" jdbcType="TIMESTAMP" />
    <result column="BZ" property="bz" jdbcType="VARCHAR" />
    <result column="CZBZ" property="czbz" jdbcType="VARCHAR" />
    <result column="CREATOR" property="creator" jdbcType="VARCHAR" />
    <result column="CREATOR_CODE" property="creatorCode" jdbcType="VARCHAR" />
    <result column="CREATE_DATE" property="createDate" jdbcType="TIMESTAMP" />
    <result column="REFRESHER" property="refresher" jdbcType="VARCHAR" />
    <result column="REFRESHER_CODE" property="refresherCode" jdbcType="VARCHAR" />
    <result column="REFRESH_TIME" property="refreshTime" jdbcType="TIMESTAMP" />
    <result column="REMARK" property="remark" jdbcType="VARCHAR" />
    <result column="ORGID" property="orgid" jdbcType="VARCHAR" />
    <result column="STATUS" property="status" jdbcType="DECIMAL" />
  </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" >
    DCDBM, DCJHWJBH, TZDBM, DCDW, PZBM, DCHWBM, DRHWBM, DCRQ, CYR, SFZH, LXDH, YSGJ, 
    CCH, RMDJY, RMDJSJ, CMDJY, CMDJSJ, MZ, PZ, XCKL, SZKZL, QTKL, QTKLSM, MZJJY, MZJBY, 
    CMSJ, PZJJY, PZJBY, CPSJ, BZ, CZBZ, CREATOR, CREATOR_CODE, CREATE_DATE, REFRESHER, 
    REFRESHER_CODE, REFRESH_TIME, REMARK, ORGID, STATUS
  </sql>
  <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.unis.base.server.example.DCxxsjExample" >
    select
    <if test="distinct" >
      distinct
    </if>
    <include refid="Base_Column_List" />
    from D_CXXSJ
    <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 D_CXXSJ
    where DCDBM = #{dcdbm,jdbcType=VARCHAR}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.String" >
    delete from D_CXXSJ
    where DCDBM = #{dcdbm,jdbcType=VARCHAR}
  </delete>
  <!--<delete id="deleteByExample" parameterType="com.unis.base.server.entity.DCxxsjExample" >-->
    <!--delete from D_CXXSJ-->
    <!--<if test="_parameter != null" >-->
      <!--<include refid="Example_Where_Clause" />-->
    <!--</if>-->
  <!--</delete>-->
  <insert id="insert" parameterType="com.unis.base.server.entity.DCxxsjDo" >
    insert into D_CXXSJ (DCDBM, DCJHWJBH, TZDBM, 
      DCDW, PZBM, DCHWBM, 
      DRHWBM, DCRQ, CYR, 
      SFZH, LXDH, YSGJ, CCH, 
      RMDJY, RMDJSJ, CMDJY, 
      CMDJSJ, MZ, PZ, XCKL, 
      SZKZL, QTKL, QTKLSM, 
      MZJJY, MZJBY, CMSJ, 
      PZJJY, PZJBY, CPSJ, 
      BZ, CZBZ, CREATOR, 
      CREATOR_CODE, CREATE_DATE, REFRESHER, 
      REFRESHER_CODE, REFRESH_TIME, REMARK, 
      ORGID, STATUS)
    values (#{dcdbm,jdbcType=VARCHAR}, #{dcjhwjbh,jdbcType=VARCHAR}, #{tzdbm,jdbcType=VARCHAR}, 
      #{dcdw,jdbcType=VARCHAR}, #{pzbm,jdbcType=VARCHAR}, #{dchwbm,jdbcType=VARCHAR}, 
      #{drhwbm,jdbcType=VARCHAR}, #{dcrq,jdbcType=TIMESTAMP}, #{cyr,jdbcType=VARCHAR}, 
      #{sfzh,jdbcType=VARCHAR}, #{lxdh,jdbcType=VARCHAR}, #{ysgj,jdbcType=VARCHAR}, #{cch,jdbcType=VARCHAR}, 
      #{rmdjy,jdbcType=VARCHAR}, #{rmdjsj,jdbcType=TIMESTAMP}, #{cmdjy,jdbcType=VARCHAR}, 
      #{cmdjsj,jdbcType=TIMESTAMP}, #{mz,jdbcType=DECIMAL}, #{pz,jdbcType=DECIMAL}, #{xckl,jdbcType=DECIMAL}, 
      #{szkzl,jdbcType=DECIMAL}, #{qtkl,jdbcType=DECIMAL}, #{qtklsm,jdbcType=VARCHAR}, 
      #{mzjjy,jdbcType=VARCHAR}, #{mzjby,jdbcType=VARCHAR}, #{cmsj,jdbcType=VARCHAR}, 
      #{pzjjy,jdbcType=VARCHAR}, #{pzjby,jdbcType=VARCHAR}, #{cpsj,jdbcType=TIMESTAMP}, 
      #{bz,jdbcType=VARCHAR}, #{czbz,jdbcType=VARCHAR}, #{creator,jdbcType=VARCHAR}, 
      #{creatorCode,jdbcType=VARCHAR}, #{createDate,jdbcType=TIMESTAMP}, #{refresher,jdbcType=VARCHAR}, 
      #{refresherCode,jdbcType=VARCHAR}, #{refreshTime,jdbcType=TIMESTAMP}, #{remark,jdbcType=VARCHAR}, 
      #{orgid,jdbcType=VARCHAR}, #{status,jdbcType=DECIMAL})
  </insert>
  <insert id="insertSelective" parameterType="com.unis.base.server.entity.DCxxsjDo" >
    insert into D_CXXSJ
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="dcdbm != null" >
        DCDBM,
      </if>
      <if test="dcjhwjbh != null" >
        DCJHWJBH,
      </if>
      <if test="tzdbm != null" >
        TZDBM,
      </if>
      <if test="dcdw != null" >
        DCDW,
      </if>
      <if test="pzbm != null" >
        PZBM,
      </if>
      <if test="dchwbm != null" >
        DCHWBM,
      </if>
      <if test="drhwbm != null" >
        DRHWBM,
      </if>
      <if test="dcrq != null" >
        DCRQ,
      </if>
      <if test="cyr != null" >
        CYR,
      </if>
      <if test="sfzh != null" >
        SFZH,
      </if>
      <if test="lxdh != null" >
        LXDH,
      </if>
      <if test="ysgj != null" >
        YSGJ,
      </if>
      <if test="cch != null" >
        CCH,
      </if>
      <if test="rmdjy != null" >
        RMDJY,
      </if>
      <if test="rmdjsj != null" >
        RMDJSJ,
      </if>
      <if test="cmdjy != null" >
        CMDJY,
      </if>
      <if test="cmdjsj != null" >
        CMDJSJ,
      </if>
      <if test="mz != null" >
        MZ,
      </if>
      <if test="pz != null" >
        PZ,
      </if>
      <if test="xckl != null" >
        XCKL,
      </if>
      <if test="szkzl != null" >
        SZKZL,
      </if>
      <if test="qtkl != null" >
        QTKL,
      </if>
      <if test="qtklsm != null" >
        QTKLSM,
      </if>
      <if test="mzjjy != null" >
        MZJJY,
      </if>
      <if test="mzjby != null" >
        MZJBY,
      </if>
      <if test="cmsj != null" >
        CMSJ,
      </if>
      <if test="pzjjy != null" >
        PZJJY,
      </if>
      <if test="pzjby != null" >
        PZJBY,
      </if>
      <if test="cpsj != null" >
        CPSJ,
      </if>
      <if test="bz != null" >
        BZ,
      </if>
      <if test="czbz != null" >
        CZBZ,
      </if>
      <if test="creator != null" >
        CREATOR,
      </if>
      <if test="creatorCode != null" >
        CREATOR_CODE,
      </if>
      <if test="createDate != null" >
        CREATE_DATE,
      </if>
      <if test="refresher != null" >
        REFRESHER,
      </if>
      <if test="refresherCode != null" >
        REFRESHER_CODE,
      </if>
      <if test="refreshTime != null" >
        REFRESH_TIME,
      </if>
      <if test="remark != null" >
        REMARK,
      </if>
      <if test="orgid != null" >
        ORGID,
      </if>
      <if test="status != null" >
        STATUS,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="dcdbm != null" >
        #{dcdbm,jdbcType=VARCHAR},
      </if>
      <if test="dcjhwjbh != null" >
        #{dcjhwjbh,jdbcType=VARCHAR},
      </if>
      <if test="tzdbm != null" >
        #{tzdbm,jdbcType=VARCHAR},
      </if>
      <if test="dcdw != null" >
        #{dcdw,jdbcType=VARCHAR},
      </if>
      <if test="pzbm != null" >
        #{pzbm,jdbcType=VARCHAR},
      </if>
      <if test="dchwbm != null" >
        #{dchwbm,jdbcType=VARCHAR},
      </if>
      <if test="drhwbm != null" >
        #{drhwbm,jdbcType=VARCHAR},
      </if>
      <if test="dcrq != null" >
        #{dcrq,jdbcType=TIMESTAMP},
      </if>
      <if test="cyr != null" >
        #{cyr,jdbcType=VARCHAR},
      </if>
      <if test="sfzh != null" >
        #{sfzh,jdbcType=VARCHAR},
      </if>
      <if test="lxdh != null" >
        #{lxdh,jdbcType=VARCHAR},
      </if>
      <if test="ysgj != null" >
        #{ysgj,jdbcType=VARCHAR},
      </if>
      <if test="cch != null" >
        #{cch,jdbcType=VARCHAR},
      </if>
      <if test="rmdjy != null" >
        #{rmdjy,jdbcType=VARCHAR},
      </if>
      <if test="rmdjsj != null" >
        #{rmdjsj,jdbcType=TIMESTAMP},
      </if>
      <if test="cmdjy != null" >
        #{cmdjy,jdbcType=VARCHAR},
      </if>
      <if test="cmdjsj != null" >
        #{cmdjsj,jdbcType=TIMESTAMP},
      </if>
      <if test="mz != null" >
        #{mz,jdbcType=DECIMAL},
      </if>
      <if test="pz != null" >
        #{pz,jdbcType=DECIMAL},
      </if>
      <if test="xckl != null" >
        #{xckl,jdbcType=DECIMAL},
      </if>
      <if test="szkzl != null" >
        #{szkzl,jdbcType=DECIMAL},
      </if>
      <if test="qtkl != null" >
        #{qtkl,jdbcType=DECIMAL},
      </if>
      <if test="qtklsm != null" >
        #{qtklsm,jdbcType=VARCHAR},
      </if>
      <if test="mzjjy != null" >
        #{mzjjy,jdbcType=VARCHAR},
      </if>
      <if test="mzjby != null" >
        #{mzjby,jdbcType=VARCHAR},
      </if>
      <if test="cmsj != null" >
        #{cmsj,jdbcType=VARCHAR},
      </if>
      <if test="pzjjy != null" >
        #{pzjjy,jdbcType=VARCHAR},
      </if>
      <if test="pzjby != null" >
        #{pzjby,jdbcType=VARCHAR},
      </if>
      <if test="cpsj != null" >
        #{cpsj,jdbcType=TIMESTAMP},
      </if>
      <if test="bz != null" >
        #{bz,jdbcType=VARCHAR},
      </if>
      <if test="czbz != null" >
        #{czbz,jdbcType=VARCHAR},
      </if>
      <if test="creator != null" >
        #{creator,jdbcType=VARCHAR},
      </if>
      <if test="creatorCode != null" >
        #{creatorCode,jdbcType=VARCHAR},
      </if>
      <if test="createDate != null" >
        #{createDate,jdbcType=TIMESTAMP},
      </if>
      <if test="refresher != null" >
        #{refresher,jdbcType=VARCHAR},
      </if>
      <if test="refresherCode != null" >
        #{refresherCode,jdbcType=VARCHAR},
      </if>
      <if test="refreshTime != null" >
        #{refreshTime,jdbcType=TIMESTAMP},
      </if>
      <if test="remark != null" >
        #{remark,jdbcType=VARCHAR},
      </if>
      <if test="orgid != null" >
        #{orgid,jdbcType=VARCHAR},
      </if>
      <if test="status != null" >
        #{status,jdbcType=DECIMAL},
      </if>
    </trim>
  </insert>
  <!--<select id="countByExample" parameterType="com.unis.base.server.entity.DCxxsjExample" resultType="java.lang.Integer" >-->
    <!--select count(*) from D_CXXSJ-->
    <!--<if test="_parameter != null" >-->
      <!--<include refid="Example_Where_Clause" />-->
    <!--</if>-->
  <!--</select>-->
  <update id="updateByExampleSelective" parameterType="map" >
    update D_CXXSJ
    <set >
      <if test="record.dcdbm != null" >
        DCDBM = #{record.dcdbm,jdbcType=VARCHAR},
      </if>
      <if test="record.dcjhwjbh != null" >
        DCJHWJBH = #{record.dcjhwjbh,jdbcType=VARCHAR},
      </if>
      <if test="record.tzdbm != null" >
        TZDBM = #{record.tzdbm,jdbcType=VARCHAR},
      </if>
      <if test="record.dcdw != null" >
        DCDW = #{record.dcdw,jdbcType=VARCHAR},
      </if>
      <if test="record.pzbm != null" >
        PZBM = #{record.pzbm,jdbcType=VARCHAR},
      </if>
      <if test="record.dchwbm != null" >
        DCHWBM = #{record.dchwbm,jdbcType=VARCHAR},
      </if>
      <if test="record.drhwbm != null" >
        DRHWBM = #{record.drhwbm,jdbcType=VARCHAR},
      </if>
      <if test="record.dcrq != null" >
        DCRQ = #{record.dcrq,jdbcType=TIMESTAMP},
      </if>
      <if test="record.cyr != null" >
        CYR = #{record.cyr,jdbcType=VARCHAR},
      </if>
      <if test="record.sfzh != null" >
        SFZH = #{record.sfzh,jdbcType=VARCHAR},
      </if>
      <if test="record.lxdh != null" >
        LXDH = #{record.lxdh,jdbcType=VARCHAR},
      </if>
      <if test="record.ysgj != null" >
        YSGJ = #{record.ysgj,jdbcType=VARCHAR},
      </if>
      <if test="record.cch != null" >
        CCH = #{record.cch,jdbcType=VARCHAR},
      </if>
      <if test="record.rmdjy != null" >
        RMDJY = #{record.rmdjy,jdbcType=VARCHAR},
      </if>
      <if test="record.rmdjsj != null" >
        RMDJSJ = #{record.rmdjsj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.cmdjy != null" >
        CMDJY = #{record.cmdjy,jdbcType=VARCHAR},
      </if>
      <if test="record.cmdjsj != null" >
        CMDJSJ = #{record.cmdjsj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.mz != null" >
        MZ = #{record.mz,jdbcType=DECIMAL},
      </if>
      <if test="record.pz != null" >
        PZ = #{record.pz,jdbcType=DECIMAL},
      </if>
      <if test="record.xckl != null" >
        XCKL = #{record.xckl,jdbcType=DECIMAL},
      </if>
      <if test="record.szkzl != null" >
        SZKZL = #{record.szkzl,jdbcType=DECIMAL},
      </if>
      <if test="record.qtkl != null" >
        QTKL = #{record.qtkl,jdbcType=DECIMAL},
      </if>
      <if test="record.qtklsm != null" >
        QTKLSM = #{record.qtklsm,jdbcType=VARCHAR},
      </if>
      <if test="record.mzjjy != null" >
        MZJJY = #{record.mzjjy,jdbcType=VARCHAR},
      </if>
      <if test="record.mzjby != null" >
        MZJBY = #{record.mzjby,jdbcType=VARCHAR},
      </if>
      <if test="record.cmsj != null" >
        CMSJ = #{record.cmsj,jdbcType=VARCHAR},
      </if>
      <if test="record.pzjjy != null" >
        PZJJY = #{record.pzjjy,jdbcType=VARCHAR},
      </if>
      <if test="record.pzjby != null" >
        PZJBY = #{record.pzjby,jdbcType=VARCHAR},
      </if>
      <if test="record.cpsj != null" >
        CPSJ = #{record.cpsj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.bz != null" >
        BZ = #{record.bz,jdbcType=VARCHAR},
      </if>
      <if test="record.czbz != null" >
        CZBZ = #{record.czbz,jdbcType=VARCHAR},
      </if>
      <if test="record.creator != null" >
        CREATOR = #{record.creator,jdbcType=VARCHAR},
      </if>
      <if test="record.creatorCode != null" >
        CREATOR_CODE = #{record.creatorCode,jdbcType=VARCHAR},
      </if>
      <if test="record.createDate != null" >
        CREATE_DATE = #{record.createDate,jdbcType=TIMESTAMP},
      </if>
      <if test="record.refresher != null" >
        REFRESHER = #{record.refresher,jdbcType=VARCHAR},
      </if>
      <if test="record.refresherCode != null" >
        REFRESHER_CODE = #{record.refresherCode,jdbcType=VARCHAR},
      </if>
      <if test="record.refreshTime != null" >
        REFRESH_TIME = #{record.refreshTime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.remark != null" >
        REMARK = #{record.remark,jdbcType=VARCHAR},
      </if>
      <if test="record.orgid != null" >
        ORGID = #{record.orgid,jdbcType=VARCHAR},
      </if>
      <if test="record.status != null" >
        STATUS = #{record.status,jdbcType=DECIMAL},
      </if>
    </set>
    <if test="_parameter != null" >
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByExample" parameterType="map" >
    update D_CXXSJ
    set DCDBM = #{record.dcdbm,jdbcType=VARCHAR},
      DCJHWJBH = #{record.dcjhwjbh,jdbcType=VARCHAR},
      TZDBM = #{record.tzdbm,jdbcType=VARCHAR},
      DCDW = #{record.dcdw,jdbcType=VARCHAR},
      PZBM = #{record.pzbm,jdbcType=VARCHAR},
      DCHWBM = #{record.dchwbm,jdbcType=VARCHAR},
      DRHWBM = #{record.drhwbm,jdbcType=VARCHAR},
      DCRQ = #{record.dcrq,jdbcType=TIMESTAMP},
      CYR = #{record.cyr,jdbcType=VARCHAR},
      SFZH = #{record.sfzh,jdbcType=VARCHAR},
      LXDH = #{record.lxdh,jdbcType=VARCHAR},
      YSGJ = #{record.ysgj,jdbcType=VARCHAR},
      CCH = #{record.cch,jdbcType=VARCHAR},
      RMDJY = #{record.rmdjy,jdbcType=VARCHAR},
      RMDJSJ = #{record.rmdjsj,jdbcType=TIMESTAMP},
      CMDJY = #{record.cmdjy,jdbcType=VARCHAR},
      CMDJSJ = #{record.cmdjsj,jdbcType=TIMESTAMP},
      MZ = #{record.mz,jdbcType=DECIMAL},
      PZ = #{record.pz,jdbcType=DECIMAL},
      XCKL = #{record.xckl,jdbcType=DECIMAL},
      SZKZL = #{record.szkzl,jdbcType=DECIMAL},
      QTKL = #{record.qtkl,jdbcType=DECIMAL},
      QTKLSM = #{record.qtklsm,jdbcType=VARCHAR},
      MZJJY = #{record.mzjjy,jdbcType=VARCHAR},
      MZJBY = #{record.mzjby,jdbcType=VARCHAR},
      CMSJ = #{record.cmsj,jdbcType=VARCHAR},
      PZJJY = #{record.pzjjy,jdbcType=VARCHAR},
      PZJBY = #{record.pzjby,jdbcType=VARCHAR},
      CPSJ = #{record.cpsj,jdbcType=TIMESTAMP},
      BZ = #{record.bz,jdbcType=VARCHAR},
      CZBZ = #{record.czbz,jdbcType=VARCHAR},
      CREATOR = #{record.creator,jdbcType=VARCHAR},
      CREATOR_CODE = #{record.creatorCode,jdbcType=VARCHAR},
      CREATE_DATE = #{record.createDate,jdbcType=TIMESTAMP},
      REFRESHER = #{record.refresher,jdbcType=VARCHAR},
      REFRESHER_CODE = #{record.refresherCode,jdbcType=VARCHAR},
      REFRESH_TIME = #{record.refreshTime,jdbcType=TIMESTAMP},
      REMARK = #{record.remark,jdbcType=VARCHAR},
      ORGID = #{record.orgid,jdbcType=VARCHAR},
      STATUS = #{record.status,jdbcType=DECIMAL}
    <if test="_parameter != null" >
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByPrimaryKeySelective" parameterType="com.unis.base.server.entity.DCxxsjDo" >
    update D_CXXSJ
    <set >
      <if test="dcjhwjbh != null" >
        DCJHWJBH = #{dcjhwjbh,jdbcType=VARCHAR},
      </if>
      <if test="tzdbm != null" >
        TZDBM = #{tzdbm,jdbcType=VARCHAR},
      </if>
      <if test="dcdw != null" >
        DCDW = #{dcdw,jdbcType=VARCHAR},
      </if>
      <if test="pzbm != null" >
        PZBM = #{pzbm,jdbcType=VARCHAR},
      </if>
      <if test="dchwbm != null" >
        DCHWBM = #{dchwbm,jdbcType=VARCHAR},
      </if>
      <if test="drhwbm != null" >
        DRHWBM = #{drhwbm,jdbcType=VARCHAR},
      </if>
      <if test="dcrq != null" >
        DCRQ = #{dcrq,jdbcType=TIMESTAMP},
      </if>
      <if test="cyr != null" >
        CYR = #{cyr,jdbcType=VARCHAR},
      </if>
      <if test="sfzh != null" >
        SFZH = #{sfzh,jdbcType=VARCHAR},
      </if>
      <if test="lxdh != null" >
        LXDH = #{lxdh,jdbcType=VARCHAR},
      </if>
      <if test="ysgj != null" >
        YSGJ = #{ysgj,jdbcType=VARCHAR},
      </if>
      <if test="cch != null" >
        CCH = #{cch,jdbcType=VARCHAR},
      </if>
      <if test="rmdjy != null" >
        RMDJY = #{rmdjy,jdbcType=VARCHAR},
      </if>
      <if test="rmdjsj != null" >
        RMDJSJ = #{rmdjsj,jdbcType=TIMESTAMP},
      </if>
      <if test="cmdjy != null" >
        CMDJY = #{cmdjy,jdbcType=VARCHAR},
      </if>
      <if test="cmdjsj != null" >
        CMDJSJ = #{cmdjsj,jdbcType=TIMESTAMP},
      </if>
      <if test="mz != null" >
        MZ = #{mz,jdbcType=DECIMAL},
      </if>
      <if test="pz != null" >
        PZ = #{pz,jdbcType=DECIMAL},
      </if>
      <if test="xckl != null" >
        XCKL = #{xckl,jdbcType=DECIMAL},
      </if>
      <if test="szkzl != null" >
        SZKZL = #{szkzl,jdbcType=DECIMAL},
      </if>
      <if test="qtkl != null" >
        QTKL = #{qtkl,jdbcType=DECIMAL},
      </if>
      <if test="qtklsm != null" >
        QTKLSM = #{qtklsm,jdbcType=VARCHAR},
      </if>
      <if test="mzjjy != null" >
        MZJJY = #{mzjjy,jdbcType=VARCHAR},
      </if>
      <if test="mzjby != null" >
        MZJBY = #{mzjby,jdbcType=VARCHAR},
      </if>
      <if test="cmsj != null" >
        CMSJ = #{cmsj,jdbcType=VARCHAR},
      </if>
      <if test="pzjjy != null" >
        PZJJY = #{pzjjy,jdbcType=VARCHAR},
      </if>
      <if test="pzjby != null" >
        PZJBY = #{pzjby,jdbcType=VARCHAR},
      </if>
      <if test="cpsj != null" >
        CPSJ = #{cpsj,jdbcType=TIMESTAMP},
      </if>
      <if test="bz != null" >
        BZ = #{bz,jdbcType=VARCHAR},
      </if>
      <if test="czbz != null" >
        CZBZ = #{czbz,jdbcType=VARCHAR},
      </if>
      <if test="creator != null" >
        CREATOR = #{creator,jdbcType=VARCHAR},
      </if>
      <if test="creatorCode != null" >
        CREATOR_CODE = #{creatorCode,jdbcType=VARCHAR},
      </if>
      <if test="createDate != null" >
        CREATE_DATE = #{createDate,jdbcType=TIMESTAMP},
      </if>
      <if test="refresher != null" >
        REFRESHER = #{refresher,jdbcType=VARCHAR},
      </if>
      <if test="refresherCode != null" >
        REFRESHER_CODE = #{refresherCode,jdbcType=VARCHAR},
      </if>
      <if test="refreshTime != null" >
        REFRESH_TIME = #{refreshTime,jdbcType=TIMESTAMP},
      </if>
      <if test="remark != null" >
        REMARK = #{remark,jdbcType=VARCHAR},
      </if>
      <if test="orgid != null" >
        ORGID = #{orgid,jdbcType=VARCHAR},
      </if>
      <if test="status != null" >
        STATUS = #{status,jdbcType=DECIMAL},
      </if>
    </set>
    where DCDBM = #{dcdbm,jdbcType=VARCHAR}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.unis.base.server.entity.DCxxsjDo" >
    update D_CXXSJ
    set DCJHWJBH = #{dcjhwjbh,jdbcType=VARCHAR},
      TZDBM = #{tzdbm,jdbcType=VARCHAR},
      DCDW = #{dcdw,jdbcType=VARCHAR},
      PZBM = #{pzbm,jdbcType=VARCHAR},
      DCHWBM = #{dchwbm,jdbcType=VARCHAR},
      DRHWBM = #{drhwbm,jdbcType=VARCHAR},
      DCRQ = #{dcrq,jdbcType=TIMESTAMP},
      CYR = #{cyr,jdbcType=VARCHAR},
      SFZH = #{sfzh,jdbcType=VARCHAR},
      LXDH = #{lxdh,jdbcType=VARCHAR},
      YSGJ = #{ysgj,jdbcType=VARCHAR},
      CCH = #{cch,jdbcType=VARCHAR},
      RMDJY = #{rmdjy,jdbcType=VARCHAR},
      RMDJSJ = #{rmdjsj,jdbcType=TIMESTAMP},
      CMDJY = #{cmdjy,jdbcType=VARCHAR},
      CMDJSJ = #{cmdjsj,jdbcType=TIMESTAMP},
      MZ = #{mz,jdbcType=DECIMAL},
      PZ = #{pz,jdbcType=DECIMAL},
      XCKL = #{xckl,jdbcType=DECIMAL},
      SZKZL = #{szkzl,jdbcType=DECIMAL},
      QTKL = #{qtkl,jdbcType=DECIMAL},
      QTKLSM = #{qtklsm,jdbcType=VARCHAR},
      MZJJY = #{mzjjy,jdbcType=VARCHAR},
      MZJBY = #{mzjby,jdbcType=VARCHAR},
      CMSJ = #{cmsj,jdbcType=VARCHAR},
      PZJJY = #{pzjjy,jdbcType=VARCHAR},
      PZJBY = #{pzjby,jdbcType=VARCHAR},
      CPSJ = #{cpsj,jdbcType=TIMESTAMP},
      BZ = #{bz,jdbcType=VARCHAR},
      CZBZ = #{czbz,jdbcType=VARCHAR},
      CREATOR = #{creator,jdbcType=VARCHAR},
      CREATOR_CODE = #{creatorCode,jdbcType=VARCHAR},
      CREATE_DATE = #{createDate,jdbcType=TIMESTAMP},
      REFRESHER = #{refresher,jdbcType=VARCHAR},
      REFRESHER_CODE = #{refresherCode,jdbcType=VARCHAR},
      REFRESH_TIME = #{refreshTime,jdbcType=TIMESTAMP},
      REMARK = #{remark,jdbcType=VARCHAR},
      ORGID = #{orgid,jdbcType=VARCHAR},
      STATUS = #{status,jdbcType=DECIMAL}
    where DCDBM = #{dcdbm,jdbcType=VARCHAR}
  </update>

  <select id="findPageList" resultMap="BaseResultMap" parameterType="com.unis.base.common.vo.ReversePositionVo" >
    select
    <include refid="Base_Column_List" />
    from D_CXXSJ
    <where>
      STATUS=1
      <if test="dcdbm != null and dcdbm != ''">
        AND FABH = #{dcdbm,jdbcType=VARCHAR}
      </if>
    </where>
    ORDER BY CREATE_DATE DESC
  </select>
</mapper>