<?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.cku.dao.CkuMatchSignMapper" >
  <resultMap id="BaseResultMap" type="com.cku.model.CkuMatchSign" >
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="entry_no" property="entryNo" jdbcType="VARCHAR" />
    <result column="flow_no" property="flowNo" jdbcType="VARCHAR" />
    <result column="dog_owner" property="dogOwner" jdbcType="VARCHAR" />
    <result column="dog_owner_e" property="dogOwnerE" jdbcType="VARCHAR" />
    <result column="user_no" property="userNo" jdbcType="VARCHAR" />
    <result column="show_num" property="showNum" jdbcType="VARCHAR" />
    <result column="identification" property="identification" jdbcType="VARCHAR" />
    <result column="entry_fee" property="entryFee" jdbcType="VARCHAR" />
    <result column="leave_cancel" property="leaveCancel" jdbcType="VARCHAR" />
    <result column="show_leave" property="showLeave" jdbcType="CHAR" />
    <result column="breed_name" property="breedName" jdbcType="VARCHAR" />
    <result column="breed_name_e" property="breedNameE" jdbcType="VARCHAR" />
    <result column="fci_code" property="fciCode" jdbcType="VARCHAR" />
    <result column="breed_group" property="breedGroup" jdbcType="VARCHAR" />
    <result column="dog_name" property="dogName" jdbcType="VARCHAR" />
    <result column="gender" property="gender" jdbcType="VARCHAR" />
    <result column="birth" property="birth" jdbcType="TIMESTAMP" />
    <result column="age_group" property="ageGroup" jdbcType="VARCHAR" />
    <result column="cku_studbook_num" property="ckuStudbookNum" jdbcType="VARCHAR" />
    <result column="foreign_studbook_num" property="foreignStudbookNum" jdbcType="VARCHAR" />
    <result column="microchip_no" property="microchipNo" jdbcType="VARCHAR" />
    <result column="fstudbook_num" property="fstudbookNum" jdbcType="VARCHAR" />
    <result column="fdog_name" property="fdogName" jdbcType="VARCHAR" />
    <result column="mstudbook_num" property="mstudbookNum" jdbcType="VARCHAR" />
    <result column="mdog_name" property="mdogName" jdbcType="VARCHAR" />
    <result column="breeder" property="breeder" jdbcType="VARCHAR" />
    <result column="add_time" property="addTime" jdbcType="TIMESTAMP" />
    <result column="modify_date" property="modifyDate" jdbcType="TIMESTAMP" />
    <result column="del_tag" property="delTag" jdbcType="CHAR" />
    <result column="info_Confirm" property="infoConfirm" jdbcType="CHAR" />
    <result column="info_Confirm_time" property="infoConfirmTime" jdbcType="TIMESTAMP" />
    <result column="payout" property="payout" jdbcType="CHAR" />
    <result column="payout_time" property="payoutTime" jdbcType="TIMESTAMP" />
    <result column="order_price" property="orderPrice" jdbcType="DECIMAL" />
    <result column="running_number" property="runningNumber" jdbcType="VARCHAR" />
    <result column="operate" property="operate" jdbcType="CHAR" />
    <result column="operate_time" property="operateTime" jdbcType="TIMESTAMP" />
    <result column="pay_ckuid" property="payCkuid" jdbcType="VARCHAR" />
    <result column="pay_Pid" property="payPid" jdbcType="INTEGER" />
    <result column="serviceFee" property="servicefee" jdbcType="CHAR" />
    <result column="serviceFeePrice" property="servicefeeprice" jdbcType="DECIMAL" />
    <result column="BBE" property="bbe" jdbcType="CHAR" />
    <result column="trainer_id" property="trainerId" jdbcType="INTEGER" />
    <result column="project_id" property="projectId" jdbcType="INTEGER" />
    <result column="match_id" property="matchId" jdbcType="INTEGER" />
    <result column="dog_id" property="dogId" jdbcType="INTEGER" />
    <result column="remark" property="remark" jdbcType="VARCHAR" />
    <result column="COLOR" property="Color" jdbcType="VARCHAR" />
    <result column="sponsor_detil" property="sponsorDetil" jdbcType="VARCHAR" />
  </resultMap>
  <resultMap id="ResultMapWithBLOBs" type="com.cku.model.CkuMatchSignWithBLOBs" extends="BaseResultMap" >
    <result column="remark" property="remark" jdbcType="LONGVARCHAR" />
    <result column="opt_user" property="optUser" jdbcType="LONGVARCHAR" />
    <result column="info_Confirm_why" property="infoConfirmWhy" jdbcType="LONGVARCHAR" />
  </resultMap>
  <!-- 查询主赛事犬只报名情况 zhuoHeng -->
  <select id="getTopDog" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
  SELECT
		CKU血统证书号
	FROM
		(
			SELECT
				*
			FROM
				cku_shows_baoming
			WHERE
				赛事编号 like '%${showNum}%'  
		)cku_baoming
	GROUP BY
		CKU血统证书号
  </select>
  <!-- 根据赛事编号和犬只CKU血统证书号查询犬只报名信息  zhuoHeng-->
  <select id="getSignByStudbookNum" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
  SELECT
		baoming.id id,
		baoming.报名序号 entry_no,
		baoming.流水账号 flow_no,
		baoming.犬主人 dog_owner,
		baoming.犬主英文名 dog_owner_e,
		baoming.会员号 user_no,
		baoming.赛事编号 show_num,
		baoming.鉴定 identification,
		baoming.备注 remark,
		baoming.报名费 entry_fee,
		baoming.请假及取消 leave_cancel,
		baoming.赛场请假 show_leave,
		baoming.犬种中文名 breed_name,
		baoming.犬种英文名 breed_name_e,
		baoming.FCI代码 fci_code,
		baoming.犬种组 breed_group,
		baoming.犬名 dog_name,
		baoming.性别 gender,
		baoming.出生日期 birth,
		baoming.年龄组别 age_group,
		baoming.CKU血统证书号 cku_studbook_num,
		baoming.国外血统证书号 foreign_studbook_num,
		baoming.芯片号 microchip_no,
		baoming.父犬血统证书号 fstudbook_num,
		baoming.父犬名 fdog_name,
		baoming.母犬血统证书号 mstudbook_num,
		baoming.母犬名 mdog_name,
		baoming.繁殖人 breeder,
		baoming.操作人员 opt_user,
		baoming.添加日期 add_time,
		baoming.修改日期 modify_date,
		baoming.del_tag del_tag,
		baoming.info_Confirm info_Confirm,
		baoming.info_Confirm_time info_Confirm_time,
		baoming.info_Confirm_why info_Confirm_why,
		baoming.payout payout,
		baoming.payout_time payout_time,
		baoming.order_price order_price,
		baoming.running_number running_number,
		baoming.operate operate,
		baoming.operate_time operate_time,
		baoming.pay_ckuid pay_ckuid,
		baoming.pay_Pid pay_Pid,
		baoming.serviceFee serviceFee,
		baoming.serviceFeePrice serviceFeePrice,
		baoming.BBE BBE,
		dog.颜色及标志 COLOR,
		baoming.sponsor_detil sponsorDetil
	FROM
		cku_shows_baoming baoming left join dog dog on baoming.CKU血统证书号 = dog.血统证书号
	WHERE
		赛事编号 LIKE '%${showNum}%'
	AND CKU血统证书号 = #{pedigreeNum}
  </select>
  <sql id="Base_Column_List" >
    id, entry_no, flow_no, dog_owner, dog_owner_e, user_no, show_num, identification, 
    entry_fee, leave_cancel, show_leave, breed_name, breed_name_e, fci_code, breed_group, 
    dog_name, gender, birth, age_group, cku_studbook_num, foreign_studbook_num, microchip_no, 
    fstudbook_num, fdog_name, mstudbook_num, mdog_name, breeder, add_time, modify_date, 
    del_tag, info_Confirm, info_Confirm_time, payout, payout_time, order_price, running_number, 
    operate, operate_time, pay_ckuid, pay_Pid, serviceFee, serviceFeePrice, BBE, trainer_id, 
    project_id, match_id, dog_id,sponsor_detil
  </sql>
  <sql id="Blob_Column_List" >
    remark, opt_user, info_Confirm_why
  </sql>
  <select id="selectByPrimaryKey" resultMap="ResultMapWithBLOBs" parameterType="java.lang.Integer" >
    select 
    <include refid="Base_Column_List" />
    ,
    <include refid="Blob_Column_List" />
    from cku_shows_baoming
    where id = #{id,jdbcType=INTEGER}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
    delete from cku_shows_baoming
    where id = #{id,jdbcType=INTEGER}
  </delete>
  <insert id="insert" parameterType="com.cku.model.CkuMatchSignWithBLOBs" >
    insert into cku_shows_baoming (id, entry_no, flow_no, 
      dog_owner, dog_owner_e, user_no, 
      show_num, identification, entry_fee, 
      leave_cancel, show_leave, breed_name, 
      breed_name_e, fci_code, breed_group, 
      dog_name, gender, birth, 
      age_group, cku_studbook_num, foreign_studbook_num, 
      microchip_no, fstudbook_num, fdog_name, 
      mstudbook_num, mdog_name, breeder, 
      add_time, modify_date, del_tag, 
      info_Confirm, info_Confirm_time, payout, 
      payout_time, order_price, running_number, 
      operate, operate_time, pay_ckuid, 
      pay_Pid, serviceFee, serviceFeePrice, 
      BBE, trainer_id, project_id, 
      match_id, dog_id, remark, 
      opt_user, info_Confirm_why,sponsor_detil)
    values (#{id,jdbcType=INTEGER}, #{entryNo,jdbcType=VARCHAR}, #{flowNo,jdbcType=VARCHAR}, 
      #{dogOwner,jdbcType=VARCHAR}, #{dogOwnerE,jdbcType=VARCHAR}, #{userNo,jdbcType=VARCHAR}, 
      #{showNum,jdbcType=VARCHAR}, #{identification,jdbcType=VARCHAR}, #{entryFee,jdbcType=VARCHAR}, 
      #{leaveCancel,jdbcType=VARCHAR}, #{showLeave,jdbcType=CHAR}, #{breedName,jdbcType=VARCHAR}, 
      #{breedNameE,jdbcType=VARCHAR}, #{fciCode,jdbcType=VARCHAR}, #{breedGroup,jdbcType=VARCHAR}, 
      #{dogName,jdbcType=VARCHAR}, #{gender,jdbcType=VARCHAR}, #{birth,jdbcType=TIMESTAMP}, 
      #{ageGroup,jdbcType=VARCHAR}, #{ckuStudbookNum,jdbcType=VARCHAR}, #{foreignStudbookNum,jdbcType=VARCHAR}, 
      #{microchipNo,jdbcType=VARCHAR}, #{fstudbookNum,jdbcType=VARCHAR}, #{fdogName,jdbcType=VARCHAR}, 
      #{mstudbookNum,jdbcType=VARCHAR}, #{mdogName,jdbcType=VARCHAR}, #{breeder,jdbcType=VARCHAR}, 
      #{addTime,jdbcType=TIMESTAMP}, #{modifyDate,jdbcType=TIMESTAMP}, #{delTag,jdbcType=CHAR}, 
      #{infoConfirm,jdbcType=CHAR}, #{infoConfirmTime,jdbcType=TIMESTAMP}, #{payout,jdbcType=CHAR}, 
      #{payoutTime,jdbcType=TIMESTAMP}, #{orderPrice,jdbcType=DECIMAL}, #{runningNumber,jdbcType=VARCHAR}, 
      #{operate,jdbcType=CHAR}, #{operateTime,jdbcType=TIMESTAMP}, #{payCkuid,jdbcType=VARCHAR}, 
      #{payPid,jdbcType=INTEGER}, #{servicefee,jdbcType=CHAR}, #{servicefeeprice,jdbcType=DECIMAL}, 
      #{bbe,jdbcType=CHAR}, #{trainerId,jdbcType=INTEGER}, #{projectId,jdbcType=INTEGER}, 
      #{matchId,jdbcType=INTEGER}, #{dogId,jdbcType=INTEGER}, #{remark,jdbcType=LONGVARCHAR}, 
      #{optUser,jdbcType=LONGVARCHAR}, #{infoConfirmWhy,jdbcType=LONGVARCHAR},#{sponsorDetil,jdbcType=VARCHAR})
  </insert>
  <insert id="insertSelective" parameterType="com.cku.model.CkuMatchSignWithBLOBs" >
    insert into cku_shows_baoming
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        id,
      </if>
      <if test="entryNo != null" >
        entry_no,
      </if>
      <if test="flowNo != null" >
        flow_no,
      </if>
      <if test="dogOwner != null" >
        dog_owner,
      </if>
      <if test="dogOwnerE != null" >
        dog_owner_e,
      </if>
      <if test="userNo != null" >
        user_no,
      </if>
      <if test="showNum != null" >
        show_num,
      </if>
      <if test="identification != null" >
        identification,
      </if>
      <if test="entryFee != null" >
        entry_fee,
      </if>
      <if test="leaveCancel != null" >
        leave_cancel,
      </if>
      <if test="showLeave != null" >
        show_leave,
      </if>
      <if test="breedName != null" >
        breed_name,
      </if>
      <if test="breedNameE != null" >
        breed_name_e,
      </if>
      <if test="fciCode != null" >
        fci_code,
      </if>
      <if test="breedGroup != null" >
        breed_group,
      </if>
      <if test="dogName != null" >
        dog_name,
      </if>
      <if test="gender != null" >
        gender,
      </if>
      <if test="birth != null" >
        birth,
      </if>
      <if test="ageGroup != null" >
        age_group,
      </if>
      <if test="ckuStudbookNum != null" >
        cku_studbook_num,
      </if>
      <if test="foreignStudbookNum != null" >
        foreign_studbook_num,
      </if>
      <if test="microchipNo != null" >
        microchip_no,
      </if>
      <if test="fstudbookNum != null" >
        fstudbook_num,
      </if>
      <if test="fdogName != null" >
        fdog_name,
      </if>
      <if test="mstudbookNum != null" >
        mstudbook_num,
      </if>
      <if test="mdogName != null" >
        mdog_name,
      </if>
      <if test="breeder != null" >
        breeder,
      </if>
      <if test="addTime != null" >
        add_time,
      </if>
      <if test="modifyDate != null" >
        modify_date,
      </if>
      <if test="delTag != null" >
        del_tag,
      </if>
      <if test="infoConfirm != null" >
        info_Confirm,
      </if>
      <if test="infoConfirmTime != null" >
        info_Confirm_time,
      </if>
      <if test="payout != null" >
        payout,
      </if>
      <if test="payoutTime != null" >
        payout_time,
      </if>
      <if test="orderPrice != null" >
        order_price,
      </if>
      <if test="runningNumber != null" >
        running_number,
      </if>
      <if test="operate != null" >
        operate,
      </if>
      <if test="operateTime != null" >
        operate_time,
      </if>
      <if test="payCkuid != null" >
        pay_ckuid,
      </if>
      <if test="payPid != null" >
        pay_Pid,
      </if>
      <if test="servicefee != null" >
        serviceFee,
      </if>
      <if test="servicefeeprice != null" >
        serviceFeePrice,
      </if>
      <if test="bbe != null" >
        BBE,
      </if>
      <if test="trainerId != null" >
        trainer_id,
      </if>
      <if test="projectId != null" >
        project_id,
      </if>
      <if test="matchId != null" >
        match_id,
      </if>
      <if test="dogId != null" >
        dog_id,
      </if>
      <if test="remark != null" >
        remark,
      </if>
      <if test="optUser != null" >
        opt_user,
      </if>
      <if test="infoConfirmWhy != null" >
        info_Confirm_why,
      </if>
       <if test="sponsorDetil !=null">
      	sponsor_detil
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        #{id,jdbcType=INTEGER},
      </if>
      <if test="entryNo != null" >
        #{entryNo,jdbcType=VARCHAR},
      </if>
      <if test="flowNo != null" >
        #{flowNo,jdbcType=VARCHAR},
      </if>
      <if test="dogOwner != null" >
        #{dogOwner,jdbcType=VARCHAR},
      </if>
      <if test="dogOwnerE != null" >
        #{dogOwnerE,jdbcType=VARCHAR},
      </if>
      <if test="userNo != null" >
        #{userNo,jdbcType=VARCHAR},
      </if>
      <if test="showNum != null" >
        #{showNum,jdbcType=VARCHAR},
      </if>
      <if test="identification != null" >
        #{identification,jdbcType=VARCHAR},
      </if>
      <if test="entryFee != null" >
        #{entryFee,jdbcType=VARCHAR},
      </if>
      <if test="leaveCancel != null" >
        #{leaveCancel,jdbcType=VARCHAR},
      </if>
      <if test="showLeave != null" >
        #{showLeave,jdbcType=CHAR},
      </if>
      <if test="breedName != null" >
        #{breedName,jdbcType=VARCHAR},
      </if>
      <if test="breedNameE != null" >
        #{breedNameE,jdbcType=VARCHAR},
      </if>
      <if test="fciCode != null" >
        #{fciCode,jdbcType=VARCHAR},
      </if>
      <if test="breedGroup != null" >
        #{breedGroup,jdbcType=VARCHAR},
      </if>
      <if test="dogName != null" >
        #{dogName,jdbcType=VARCHAR},
      </if>
      <if test="gender != null" >
        #{gender,jdbcType=VARCHAR},
      </if>
      <if test="birth != null" >
        #{birth,jdbcType=TIMESTAMP},
      </if>
      <if test="ageGroup != null" >
        #{ageGroup,jdbcType=VARCHAR},
      </if>
      <if test="ckuStudbookNum != null" >
        #{ckuStudbookNum,jdbcType=VARCHAR},
      </if>
      <if test="foreignStudbookNum != null" >
        #{foreignStudbookNum,jdbcType=VARCHAR},
      </if>
      <if test="microchipNo != null" >
        #{microchipNo,jdbcType=VARCHAR},
      </if>
      <if test="fstudbookNum != null" >
        #{fstudbookNum,jdbcType=VARCHAR},
      </if>
      <if test="fdogName != null" >
        #{fdogName,jdbcType=VARCHAR},
      </if>
      <if test="mstudbookNum != null" >
        #{mstudbookNum,jdbcType=VARCHAR},
      </if>
      <if test="mdogName != null" >
        #{mdogName,jdbcType=VARCHAR},
      </if>
      <if test="breeder != null" >
        #{breeder,jdbcType=VARCHAR},
      </if>
      <if test="addTime != null" >
        #{addTime,jdbcType=TIMESTAMP},
      </if>
      <if test="modifyDate != null" >
        #{modifyDate,jdbcType=TIMESTAMP},
      </if>
      <if test="delTag != null" >
        #{delTag,jdbcType=CHAR},
      </if>
      <if test="infoConfirm != null" >
        #{infoConfirm,jdbcType=CHAR},
      </if>
      <if test="infoConfirmTime != null" >
        #{infoConfirmTime,jdbcType=TIMESTAMP},
      </if>
      <if test="payout != null" >
        #{payout,jdbcType=CHAR},
      </if>
      <if test="payoutTime != null" >
        #{payoutTime,jdbcType=TIMESTAMP},
      </if>
      <if test="orderPrice != null" >
        #{orderPrice,jdbcType=DECIMAL},
      </if>
      <if test="runningNumber != null" >
        #{runningNumber,jdbcType=VARCHAR},
      </if>
      <if test="operate != null" >
        #{operate,jdbcType=CHAR},
      </if>
      <if test="operateTime != null" >
        #{operateTime,jdbcType=TIMESTAMP},
      </if>
      <if test="payCkuid != null" >
        #{payCkuid,jdbcType=VARCHAR},
      </if>
      <if test="payPid != null" >
        #{payPid,jdbcType=INTEGER},
      </if>
      <if test="servicefee != null" >
        #{servicefee,jdbcType=CHAR},
      </if>
      <if test="servicefeeprice != null" >
        #{servicefeeprice,jdbcType=DECIMAL},
      </if>
      <if test="bbe != null" >
        #{bbe,jdbcType=CHAR},
      </if>
      <if test="trainerId != null" >
        #{trainerId,jdbcType=INTEGER},
      </if>
      <if test="projectId != null" >
        #{projectId,jdbcType=INTEGER},
      </if>
      <if test="matchId != null" >
        #{matchId,jdbcType=INTEGER},
      </if>
      <if test="dogId != null" >
        #{dogId,jdbcType=INTEGER},
      </if>
      <if test="remark != null" >
        #{remark,jdbcType=LONGVARCHAR},
      </if>
      <if test="optUser != null" >
        #{optUser,jdbcType=LONGVARCHAR},
      </if>
      <if test="infoConfirmWhy != null" >
        #{infoConfirmWhy,jdbcType=LONGVARCHAR},
      </if>
      <if test="sponsorDetil !=null">
      	#{sponsorDetil,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.cku.model.CkuMatchSignWithBLOBs" >
    update cku_shows_baoming
    <set >
      <if test="entryNo != null" >
        entry_no = #{entryNo,jdbcType=VARCHAR},
      </if>
      <if test="flowNo != null" >
        flow_no = #{flowNo,jdbcType=VARCHAR},
      </if>
      <if test="dogOwner != null" >
        dog_owner = #{dogOwner,jdbcType=VARCHAR},
      </if>
      <if test="dogOwnerE != null" >
        dog_owner_e = #{dogOwnerE,jdbcType=VARCHAR},
      </if>
      <if test="userNo != null" >
        user_no = #{userNo,jdbcType=VARCHAR},
      </if>
      <if test="showNum != null" >
        show_num = #{showNum,jdbcType=VARCHAR},
      </if>
      <if test="identification != null" >
        identification = #{identification,jdbcType=VARCHAR},
      </if>
      <if test="entryFee != null" >
        entry_fee = #{entryFee,jdbcType=VARCHAR},
      </if>
      <if test="leaveCancel != null" >
        leave_cancel = #{leaveCancel,jdbcType=VARCHAR},
      </if>
      <if test="showLeave != null" >
        show_leave = #{showLeave,jdbcType=CHAR},
      </if>
      <if test="breedName != null" >
        breed_name = #{breedName,jdbcType=VARCHAR},
      </if>
      <if test="breedNameE != null" >
        breed_name_e = #{breedNameE,jdbcType=VARCHAR},
      </if>
      <if test="fciCode != null" >
        fci_code = #{fciCode,jdbcType=VARCHAR},
      </if>
      <if test="breedGroup != null" >
        breed_group = #{breedGroup,jdbcType=VARCHAR},
      </if>
      <if test="dogName != null" >
        dog_name = #{dogName,jdbcType=VARCHAR},
      </if>
      <if test="gender != null" >
        gender = #{gender,jdbcType=VARCHAR},
      </if>
      <if test="birth != null" >
        birth = #{birth,jdbcType=TIMESTAMP},
      </if>
      <if test="ageGroup != null" >
        age_group = #{ageGroup,jdbcType=VARCHAR},
      </if>
      <if test="ckuStudbookNum != null" >
        cku_studbook_num = #{ckuStudbookNum,jdbcType=VARCHAR},
      </if>
      <if test="foreignStudbookNum != null" >
        foreign_studbook_num = #{foreignStudbookNum,jdbcType=VARCHAR},
      </if>
      <if test="microchipNo != null" >
        microchip_no = #{microchipNo,jdbcType=VARCHAR},
      </if>
      <if test="fstudbookNum != null" >
        fstudbook_num = #{fstudbookNum,jdbcType=VARCHAR},
      </if>
      <if test="fdogName != null" >
        fdog_name = #{fdogName,jdbcType=VARCHAR},
      </if>
      <if test="mstudbookNum != null" >
        mstudbook_num = #{mstudbookNum,jdbcType=VARCHAR},
      </if>
      <if test="mdogName != null" >
        mdog_name = #{mdogName,jdbcType=VARCHAR},
      </if>
      <if test="breeder != null" >
        breeder = #{breeder,jdbcType=VARCHAR},
      </if>
      <if test="addTime != null" >
        add_time = #{addTime,jdbcType=TIMESTAMP},
      </if>
      <if test="modifyDate != null" >
        modify_date = #{modifyDate,jdbcType=TIMESTAMP},
      </if>
      <if test="delTag != null" >
        del_tag = #{delTag,jdbcType=CHAR},
      </if>
      <if test="infoConfirm != null" >
        info_Confirm = #{infoConfirm,jdbcType=CHAR},
      </if>
      <if test="infoConfirmTime != null" >
        info_Confirm_time = #{infoConfirmTime,jdbcType=TIMESTAMP},
      </if>
      <if test="payout != null" >
        payout = #{payout,jdbcType=CHAR},
      </if>
      <if test="payoutTime != null" >
        payout_time = #{payoutTime,jdbcType=TIMESTAMP},
      </if>
      <if test="orderPrice != null" >
        order_price = #{orderPrice,jdbcType=DECIMAL},
      </if>
      <if test="runningNumber != null" >
        running_number = #{runningNumber,jdbcType=VARCHAR},
      </if>
      <if test="operate != null" >
        operate = #{operate,jdbcType=CHAR},
      </if>
      <if test="operateTime != null" >
        operate_time = #{operateTime,jdbcType=TIMESTAMP},
      </if>
      <if test="payCkuid != null" >
        pay_ckuid = #{payCkuid,jdbcType=VARCHAR},
      </if>
      <if test="payPid != null" >
        pay_Pid = #{payPid,jdbcType=INTEGER},
      </if>
      <if test="servicefee != null" >
        serviceFee = #{servicefee,jdbcType=CHAR},
      </if>
      <if test="servicefeeprice != null" >
        serviceFeePrice = #{servicefeeprice,jdbcType=DECIMAL},
      </if>
      <if test="bbe != null" >
        BBE = #{bbe,jdbcType=CHAR},
      </if>
      <if test="trainerId != null" >
        trainer_id = #{trainerId,jdbcType=INTEGER},
      </if>
      <if test="projectId != null" >
        project_id = #{projectId,jdbcType=INTEGER},
      </if>
      <if test="matchId != null" >
        match_id = #{matchId,jdbcType=INTEGER},
      </if>
      <if test="dogId != null" >
        dog_id = #{dogId,jdbcType=INTEGER},
      </if>
      <if test="remark != null" >
        remark = #{remark,jdbcType=LONGVARCHAR},
      </if>
      <if test="optUser != null" >
        opt_user = #{optUser,jdbcType=LONGVARCHAR},
      </if>
      <if test="infoConfirmWhy != null" >
        info_Confirm_why = #{infoConfirmWhy,jdbcType=LONGVARCHAR},
      </if>
      <if test="sponsorDetil !=null">
      	sponsor_detil=#{sponsorDetil,jdbcType=VARCHAR},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKeyWithBLOBs" parameterType="com.cku.model.CkuMatchSignWithBLOBs" >
    update cku_shows_baoming
    set entry_no = #{entryNo,jdbcType=VARCHAR},
      flow_no = #{flowNo,jdbcType=VARCHAR},
      dog_owner = #{dogOwner,jdbcType=VARCHAR},
      dog_owner_e = #{dogOwnerE,jdbcType=VARCHAR},
      user_no = #{userNo,jdbcType=VARCHAR},
      show_num = #{showNum,jdbcType=VARCHAR},
      identification = #{identification,jdbcType=VARCHAR},
      entry_fee = #{entryFee,jdbcType=VARCHAR},
      leave_cancel = #{leaveCancel,jdbcType=VARCHAR},
      show_leave = #{showLeave,jdbcType=CHAR},
      breed_name = #{breedName,jdbcType=VARCHAR},
      breed_name_e = #{breedNameE,jdbcType=VARCHAR},
      fci_code = #{fciCode,jdbcType=VARCHAR},
      breed_group = #{breedGroup,jdbcType=VARCHAR},
      dog_name = #{dogName,jdbcType=VARCHAR},
      gender = #{gender,jdbcType=VARCHAR},
      birth = #{birth,jdbcType=TIMESTAMP},
      age_group = #{ageGroup,jdbcType=VARCHAR},
      cku_studbook_num = #{ckuStudbookNum,jdbcType=VARCHAR},
      foreign_studbook_num = #{foreignStudbookNum,jdbcType=VARCHAR},
      microchip_no = #{microchipNo,jdbcType=VARCHAR},
      fstudbook_num = #{fstudbookNum,jdbcType=VARCHAR},
      fdog_name = #{fdogName,jdbcType=VARCHAR},
      mstudbook_num = #{mstudbookNum,jdbcType=VARCHAR},
      mdog_name = #{mdogName,jdbcType=VARCHAR},
      breeder = #{breeder,jdbcType=VARCHAR},
      add_time = #{addTime,jdbcType=TIMESTAMP},
      modify_date = #{modifyDate,jdbcType=TIMESTAMP},
      del_tag = #{delTag,jdbcType=CHAR},
      info_Confirm = #{infoConfirm,jdbcType=CHAR},
      info_Confirm_time = #{infoConfirmTime,jdbcType=TIMESTAMP},
      payout = #{payout,jdbcType=CHAR},
      payout_time = #{payoutTime,jdbcType=TIMESTAMP},
      order_price = #{orderPrice,jdbcType=DECIMAL},
      running_number = #{runningNumber,jdbcType=VARCHAR},
      operate = #{operate,jdbcType=CHAR},
      operate_time = #{operateTime,jdbcType=TIMESTAMP},
      pay_ckuid = #{payCkuid,jdbcType=VARCHAR},
      pay_Pid = #{payPid,jdbcType=INTEGER},
      serviceFee = #{servicefee,jdbcType=CHAR},
      serviceFeePrice = #{servicefeeprice,jdbcType=DECIMAL},
      BBE = #{bbe,jdbcType=CHAR},
      trainer_id = #{trainerId,jdbcType=INTEGER},
      project_id = #{projectId,jdbcType=INTEGER},
      match_id = #{matchId,jdbcType=INTEGER},
      dog_id = #{dogId,jdbcType=INTEGER},
      remark = #{remark,jdbcType=LONGVARCHAR},
      opt_user = #{optUser,jdbcType=LONGVARCHAR},
      info_Confirm_why = #{infoConfirmWhy,jdbcType=LONGVARCHAR},
      sponsor_detil=#{sponsorDetil,jdbcType=VARCHAR
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.cku.model.CkuMatchSign" >
    update cku_shows_baoming
    set entry_no = #{entryNo,jdbcType=VARCHAR},
      flow_no = #{flowNo,jdbcType=VARCHAR},
      dog_owner = #{dogOwner,jdbcType=VARCHAR},
      dog_owner_e = #{dogOwnerE,jdbcType=VARCHAR},
      user_no = #{userNo,jdbcType=VARCHAR},
      show_num = #{showNum,jdbcType=VARCHAR},
      identification = #{identification,jdbcType=VARCHAR},
      entry_fee = #{entryFee,jdbcType=VARCHAR},
      leave_cancel = #{leaveCancel,jdbcType=VARCHAR},
      show_leave = #{showLeave,jdbcType=CHAR},
      breed_name = #{breedName,jdbcType=VARCHAR},
      breed_name_e = #{breedNameE,jdbcType=VARCHAR},
      fci_code = #{fciCode,jdbcType=VARCHAR},
      breed_group = #{breedGroup,jdbcType=VARCHAR},
      dog_name = #{dogName,jdbcType=VARCHAR},
      gender = #{gender,jdbcType=VARCHAR},
      birth = #{birth,jdbcType=TIMESTAMP},
      age_group = #{ageGroup,jdbcType=VARCHAR},
      cku_studbook_num = #{ckuStudbookNum,jdbcType=VARCHAR},
      foreign_studbook_num = #{foreignStudbookNum,jdbcType=VARCHAR},
      microchip_no = #{microchipNo,jdbcType=VARCHAR},
      fstudbook_num = #{fstudbookNum,jdbcType=VARCHAR},
      fdog_name = #{fdogName,jdbcType=VARCHAR},
      mstudbook_num = #{mstudbookNum,jdbcType=VARCHAR},
      mdog_name = #{mdogName,jdbcType=VARCHAR},
      breeder = #{breeder,jdbcType=VARCHAR},
      add_time = #{addTime,jdbcType=TIMESTAMP},
      modify_date = #{modifyDate,jdbcType=TIMESTAMP},
      del_tag = #{delTag,jdbcType=CHAR},
      info_Confirm = #{infoConfirm,jdbcType=CHAR},
      info_Confirm_time = #{infoConfirmTime,jdbcType=TIMESTAMP},
      payout = #{payout,jdbcType=CHAR},
      payout_time = #{payoutTime,jdbcType=TIMESTAMP},
      order_price = #{orderPrice,jdbcType=DECIMAL},
      running_number = #{runningNumber,jdbcType=VARCHAR},
      operate = #{operate,jdbcType=CHAR},
      operate_time = #{operateTime,jdbcType=TIMESTAMP},
      pay_ckuid = #{payCkuid,jdbcType=VARCHAR},
      pay_Pid = #{payPid,jdbcType=INTEGER},
      serviceFee = #{servicefee,jdbcType=CHAR},
      serviceFeePrice = #{servicefeeprice,jdbcType=DECIMAL},
      BBE = #{bbe,jdbcType=CHAR},
      trainer_id = #{trainerId,jdbcType=INTEGER},
      project_id = #{projectId,jdbcType=INTEGER},
      match_id = #{matchId,jdbcType=INTEGER},
      dog_id = #{dogId,jdbcType=INTEGER},
      sponsor_detil=#{sponsorDetil,jdbcType=VARCHAR}
    where id = #{id,jdbcType=INTEGER}
  </update>
      <!--********************************************************* 自定义*********************************************
    <select id="checkSignUnfinished" resultType="java.lang.Integer" parameterType="java.lang.Integer" >
	    select 
	    <include refid="Base_Column_List" />
	    from cku_shows_baoming
	    where user_no = #{ckuNo,jdbcType=INTEGER} and payout='0'
	  </select>
	   -->
</mapper>