<?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.CkuUserMapper" >
  <resultMap id="BaseResultMap" type="com.cku.model.CkuUser" >
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="pay_status" property="payStatus" jdbcType="VARCHAR" />
    <result column="member_num" property="memberNum" jdbcType="VARCHAR" />
    <result column="web_member" property="webMember" jdbcType="VARCHAR" />
    <result column="name" property="name" jdbcType="VARCHAR" />
    <result column="name_spelling" property="nameSpelling" jdbcType="VARCHAR" />
    <result column="gender" property="gender" jdbcType="VARCHAR" />
    <result column="birthday" property="birthday" jdbcType="TIMESTAMP" />
    <result column="id_num" property="idNum" jdbcType="VARCHAR" />
    <result column="contact_address" property="contactAddress" jdbcType="VARCHAR" />
    <result column="post_code" property="postCode" jdbcType="VARCHAR" />
    <result column="telephone" property="telephone" jdbcType="VARCHAR" />
    <result column="mobile_phone" property="mobilePhone" jdbcType="VARCHAR" />
    <result column="fax" property="fax" jdbcType="VARCHAR" />
    <result column="Email" property="email" jdbcType="VARCHAR" />
    <result column="reg_member_num" property="regMemberNum" jdbcType="VARCHAR" />
    <result column="reg_breeding_num" property="regBreedingNum" jdbcType="INTEGER" />
    <result column="reg_data" property="regData" jdbcType="TIMESTAMP" />
    <result column="member_type" property="memberType" jdbcType="VARCHAR" />
    <result column="pay_detail" property="payDetail" jdbcType="VARCHAR" />
    <result column="member_begin_time" property="memberBeginTime" jdbcType="TIMESTAMP" />
    <result column="member_deadline_time" property="memberDeadlineTime" jdbcType="TIMESTAMP" />
    <result column="reg_by" property="regBy" jdbcType="VARCHAR" />
    <result column="modifi_date" property="modifiDate" jdbcType="TIMESTAMP" />
    <result column="del_tag" property="delTag" jdbcType="CHAR" />
    <result column="qslz_tag" property="qslzTag" jdbcType="CHAR" />
    <result column="qslz_time" property="qslzTime" jdbcType="TIMESTAMP" />
    <result column="delivery_way" property="deliveryWay" jdbcType="VARCHAR" />
    <result column="certifi_delivery_way" property="certifiDeliveryWay" jdbcType="VARCHAR" />
    <result column="notice_delivery_way" property="noticeDeliveryWay" jdbcType="VARCHAR" />
    <result column="Province" property="province" jdbcType="VARCHAR" />
    <result column="City" property="city" jdbcType="VARCHAR" />
    <result column="Street" property="street" jdbcType="VARCHAR" />
    <result column="QQ" property="qq" jdbcType="VARCHAR" />
    <result column="mrUserType" property="mrusertype" jdbcType="CHAR" />
    <result column="mrUserTime" property="mrusertime" jdbcType="TIMESTAMP" />
    <result column="ckuUserPhoto" property="ckuuserphoto" jdbcType="VARCHAR" />
    <result column="recommender" property="recommender" jdbcType="VARCHAR" />
    <result column="tel_time" property="telTime" jdbcType="TIMESTAMP" />
    <result column="isNewUser" property="isnewuser" jdbcType="CHAR" />
    <result column="SS_jstime" property="ssJstime" jdbcType="TIMESTAMP" />
    <result column="qydUserType" property="qydusertype" jdbcType="CHAR" />
    <result column="qydUserTime" property="qydusertime" jdbcType="TIMESTAMP" />
    <result column="cku_club" property="ckuClub" jdbcType="VARCHAR" />
    <result column="cku_cardtype" property="ckuCardtype" jdbcType="VARCHAR" />
    <result column="payin" property="payin" jdbcType="DECIMAL" />
    <result column="payout" property="payout" jdbcType="DECIMAL" />
    <result column="yue1" property="yue1" jdbcType="DECIMAL" />
    <result column="yue2" property="yue2" jdbcType="DECIMAL" />
  </resultMap>
  <resultMap id="ResultMapWithBLOBs" type="com.cku.model.CkuUserWithBLOBs" extends="BaseResultMap" >
    <result column="remarks" property="remarks" jdbcType="LONGVARCHAR" />
    <result column="operator" property="operator" jdbcType="LONGVARCHAR" />
    <result column="mrBeiZhu" property="mrbeizhu" jdbcType="LONGVARCHAR" />
  </resultMap>
  <!--SQL SERVER 根据会员号获取会员信息 zhuoHeng -->
  <select id="getUserMessage" resultMap="BaseResultMap" parameterType="java.lang.Integer">
  	SELECT
		id id,
		缴费状态 pay_status,
		会员号 member_num,
		网站会员 web_member,
		姓名 NAME,
		姓名拼音 name_spelling,
		性别 gender,
		出生日期 birthday,
		身份证号 id_num,
		联系地址 contact_address,
		邮政编码 post_code,
		固定电话 telephone,
		移动电话 mobile_phone,
		传真电话 fax,
		Email Email,
		会员登记编号 reg_member_num,
		繁殖登记编号 reg_breeding_num,
		登记日期 reg_data,
		会员类别 member_type,
		交费详情 pay_detail,
		备注 remarks,
		会员开始时间 member_begin_time,
		会员截止时间 member_deadline_time,
		登记人员 reg_by,
		修改日期 modifi_date,
		del_tag del_tag,
		操作人员 operator,
		qslz_tag qslz_tag,
		qslz_time qslz_time,
		配送方式 delivery_way,
		证书配送方式 certifi_delivery_way,
		通知配送方式 notice_delivery_way,
		Province Province,
		City City,
		Street Street,
		QQ QQ,
		mrUserType mrUserType,
		mrUserTime mrUserTime,
		ckuUserPhoto ckuUserPhoto,
		推荐人 recommender,
		电话联络 tel_time,
		isNewUser isNewUser,
		SS_jstime SS_jstime,
		mrBeiZhu mrBeiZhu,
		qydUserType qydUserType,
		qydUserTime qydUserTime,
		cku_club cku_club,
		cku_cardtype cku_cardtype,
		payin payin,
		payout payout,
		yue1 yue1,
		yue2 yue2
	FROM
		cku_user
	WHERE 会员号 = #{idNum}
  </select>
  <sql id="Base_Column_List" >
    id, pay_status, member_num, web_member, name, name_spelling, gender, birthday, id_num, 
    contact_address, post_code, telephone, mobile_phone, fax, Email, reg_member_num, 
    reg_breeding_num, reg_data, member_type, pay_detail, member_begin_time, member_deadline_time, 
    reg_by, modifi_date, del_tag, qslz_tag, qslz_time, delivery_way, certifi_delivery_way, 
    notice_delivery_way, Province, City, Street, QQ, mrUserType, mrUserTime, ckuUserPhoto, 
    recommender, tel_time, isNewUser, SS_jstime, qydUserType, qydUserTime, cku_club, 
    cku_cardtype, payin, payout, yue1, yue2
  </sql>
  <sql id="Blob_Column_List" >
    remarks, operator, mrBeiZhu
  </sql>
  <select id="selectByPrimaryKey" resultMap="ResultMapWithBLOBs" parameterType="java.lang.Integer" >
    select 
    <include refid="Base_Column_List" />
    ,
    <include refid="Blob_Column_List" />
    from cku_user
    where id = #{id,jdbcType=INTEGER}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
    delete from cku_user
    where id = #{id,jdbcType=INTEGER}
  </delete>
  <insert id="insert" parameterType="com.cku.model.CkuUserWithBLOBs" >
    insert into cku_user (id, pay_status, member_num, 
      web_member, name, name_spelling, 
      gender, birthday, id_num, 
      contact_address, post_code, telephone, 
      mobile_phone, fax, Email, 
      reg_member_num, reg_breeding_num, reg_data, 
      member_type, pay_detail, member_begin_time, 
      member_deadline_time, reg_by, modifi_date, 
      del_tag, qslz_tag, qslz_time, 
      delivery_way, certifi_delivery_way, notice_delivery_way, 
      Province, City, Street, 
      QQ, mrUserType, mrUserTime, 
      ckuUserPhoto, recommender, tel_time, 
      isNewUser, SS_jstime, qydUserType, 
      qydUserTime, cku_club, cku_cardtype, 
      payin, payout, yue1, 
      yue2, remarks, operator,                                       
      mrBeiZhu)
    values (#{id,jdbcType=INTEGER}, #{payStatus,jdbcType=VARCHAR}, #{memberNum,jdbcType=VARCHAR}, 
      #{webMember,jdbcType=VARCHAR}, #{name,jdbcType=VARCHAR}, #{nameSpelling,jdbcType=VARCHAR}, 
      #{gender,jdbcType=VARCHAR}, #{birthday,jdbcType=TIMESTAMP}, #{idNum,jdbcType=VARCHAR}, 
      #{contactAddress,jdbcType=VARCHAR}, #{postCode,jdbcType=VARCHAR}, #{telephone,jdbcType=VARCHAR}, 
      #{mobilePhone,jdbcType=VARCHAR}, #{fax,jdbcType=VARCHAR}, #{email,jdbcType=VARCHAR}, 
      #{regMemberNum,jdbcType=VARCHAR}, #{regBreedingNum,jdbcType=VARCHAR}, #{regData,jdbcType=TIMESTAMP}, 
      #{memberType,jdbcType=VARCHAR}, #{payDetail,jdbcType=VARCHAR}, #{memberBeginTime,jdbcType=TIMESTAMP}, 
      #{memberDeadlineTime,jdbcType=TIMESTAMP}, #{regBy,jdbcType=VARCHAR}, #{modifiDate,jdbcType=TIMESTAMP}, 
      #{delTag,jdbcType=CHAR}, #{qslzTag,jdbcType=CHAR}, #{qslzTime,jdbcType=TIMESTAMP}, 
      #{deliveryWay,jdbcType=VARCHAR}, #{certifiDeliveryWay,jdbcType=VARCHAR}, #{noticeDeliveryWay,jdbcType=VARCHAR}, 
      #{province,jdbcType=VARCHAR}, #{city,jdbcType=VARCHAR}, #{street,jdbcType=VARCHAR}, 
      #{qq,jdbcType=VARCHAR}, #{mrusertype,jdbcType=CHAR}, #{mrusertime,jdbcType=TIMESTAMP}, 
      #{ckuuserphoto,jdbcType=VARCHAR}, #{recommender,jdbcType=VARCHAR}, #{telTime,jdbcType=TIMESTAMP}, 
      #{isnewuser,jdbcType=CHAR}, #{ssJstime,jdbcType=TIMESTAMP}, #{qydusertype,jdbcType=CHAR}, 
      #{qydusertime,jdbcType=TIMESTAMP}, #{ckuClub,jdbcType=VARCHAR}, #{ckuCardtype,jdbcType=VARCHAR}, 
      #{payin,jdbcType=DECIMAL}, #{payout,jdbcType=DECIMAL}, #{yue1,jdbcType=DECIMAL}, 
      #{yue2,jdbcType=DECIMAL}, #{remarks,jdbcType=LONGVARCHAR}, #{operator,jdbcType=LONGVARCHAR}, 
      #{mrbeizhu,jdbcType=LONGVARCHAR})
  </insert>
  <insert id="insertSelective" parameterType="com.cku.model.CkuUserWithBLOBs" >
    insert into cku_user
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        id,
      </if>
      <if test="payStatus != null" >
        pay_status,
      </if>
      <if test="memberNum != null" >
        member_num,
      </if>
      <if test="webMember != null" >
        web_member,
      </if>
      <if test="name != null" >
        name,
      </if>
      <if test="nameSpelling != null" >
        name_spelling,
      </if>
      <if test="gender != null" >
        gender,
      </if>
      <if test="birthday != null" >
        birthday,
      </if>
      <if test="idNum != null" >
        id_num,
      </if>
      <if test="contactAddress != null" >
        contact_address,
      </if>
      <if test="postCode != null" >
        post_code,
      </if>
      <if test="telephone != null" >
        telephone,
      </if>
      <if test="mobilePhone != null" >
        mobile_phone,
      </if>
      <if test="fax != null" >
        fax,
      </if>
      <if test="email != null" >
        Email,
      </if>
      <if test="regMemberNum != null" >
        reg_member_num,
      </if>
      <if test="regBreedingNum != null" >
        reg_breeding_num,
      </if>
      <if test="regData != null" >
        reg_data,
      </if>
      <if test="memberType != null" >
        member_type,
      </if>
      <if test="payDetail != null" >
        pay_detail,
      </if>
      <if test="memberBeginTime != null" >
        member_begin_time,
      </if>
      <if test="memberDeadlineTime != null" >
        member_deadline_time,
      </if>
      <if test="regBy != null" >
        reg_by,
      </if>
      <if test="modifiDate != null" >
        modifi_date,
      </if>
      <if test="delTag != null" >
        del_tag,
      </if>
      <if test="qslzTag != null" >
        qslz_tag,
      </if>
      <if test="qslzTime != null" >
        qslz_time,
      </if>
      <if test="deliveryWay != null" >
        delivery_way,
      </if>
      <if test="certifiDeliveryWay != null" >
        certifi_delivery_way,
      </if>
      <if test="noticeDeliveryWay != null" >
        notice_delivery_way,
      </if>
      <if test="province != null" >
        Province,
      </if>
      <if test="city != null" >
        City,
      </if>
      <if test="street != null" >
        Street,
      </if>
      <if test="qq != null" >
        QQ,
      </if>
      <if test="mrusertype != null" >
        mrUserType,
      </if>
      <if test="mrusertime != null" >
        mrUserTime,
      </if>
      <if test="ckuuserphoto != null" >
        ckuUserPhoto,
      </if>
      <if test="recommender != null" >
        recommender,
      </if>
      <if test="telTime != null" >
        tel_time,
      </if>
      <if test="isnewuser != null" >
        isNewUser,
      </if>
      <if test="ssJstime != null" >
        SS_jstime,
      </if>
      <if test="qydusertype != null" >
        qydUserType,
      </if>
      <if test="qydusertime != null" >
        qydUserTime,
      </if>
      <if test="ckuClub != null" >
        cku_club,
      </if>
      <if test="ckuCardtype != null" >
        cku_cardtype,
      </if>
      <if test="payin != null" >
        payin,
      </if>
      <if test="payout != null" >
        payout,
      </if>
      <if test="yue1 != null" >
        yue1,
      </if>
      <if test="yue2 != null" >
        yue2,
      </if>
      <if test="remarks != null" >
        remarks,
      </if>
      <if test="operator != null" >
        operator,
      </if>
      <if test="mrbeizhu != null" >
        mrBeiZhu,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        #{id,jdbcType=INTEGER},
      </if>
      <if test="payStatus != null" >
        #{payStatus,jdbcType=VARCHAR},
      </if>
      <if test="memberNum != null" >
        #{memberNum,jdbcType=VARCHAR},
      </if>
      <if test="webMember != null" >
        #{webMember,jdbcType=VARCHAR},
      </if>
      <if test="name != null" >
        #{name,jdbcType=VARCHAR},
      </if>
      <if test="nameSpelling != null" >
        #{nameSpelling,jdbcType=VARCHAR},
      </if>
      <if test="gender != null" >
        #{gender,jdbcType=VARCHAR},
      </if>
      <if test="birthday != null" >
        #{birthday,jdbcType=TIMESTAMP},
      </if>
      <if test="idNum != null" >
        #{idNum,jdbcType=VARCHAR},
      </if>
      <if test="contactAddress != null" >
        #{contactAddress,jdbcType=VARCHAR},
      </if>
      <if test="postCode != null" >
        #{postCode,jdbcType=VARCHAR},
      </if>
      <if test="telephone != null" >
        #{telephone,jdbcType=VARCHAR},
      </if>
      <if test="mobilePhone != null" >
        #{mobilePhone,jdbcType=VARCHAR},
      </if>
      <if test="fax != null" >
        #{fax,jdbcType=VARCHAR},
      </if>
      <if test="email != null" >
        #{email,jdbcType=VARCHAR},
      </if>
      <if test="regMemberNum != null" >
        #{regMemberNum,jdbcType=VARCHAR},
      </if>
      <if test="regBreedingNum != null" >
        #{regBreedingNum,jdbcType=VARCHAR},
      </if>
      <if test="regData != null" >
        #{regData,jdbcType=TIMESTAMP},
      </if>
      <if test="memberType != null" >
        #{memberType,jdbcType=VARCHAR},
      </if>
      <if test="payDetail != null" >
        #{payDetail,jdbcType=VARCHAR},
      </if>
      <if test="memberBeginTime != null" >
        #{memberBeginTime,jdbcType=TIMESTAMP},
      </if>
      <if test="memberDeadlineTime != null" >
        #{memberDeadlineTime,jdbcType=TIMESTAMP},
      </if>
      <if test="regBy != null" >
        #{regBy,jdbcType=VARCHAR},
      </if>
      <if test="modifiDate != null" >
        #{modifiDate,jdbcType=TIMESTAMP},
      </if>
      <if test="delTag != null" >
        #{delTag,jdbcType=CHAR},
      </if>
      <if test="qslzTag != null" >
        #{qslzTag,jdbcType=CHAR},
      </if>
      <if test="qslzTime != null" >
        #{qslzTime,jdbcType=TIMESTAMP},
      </if>
      <if test="deliveryWay != null" >
        #{deliveryWay,jdbcType=VARCHAR},
      </if>
      <if test="certifiDeliveryWay != null" >
        #{certifiDeliveryWay,jdbcType=VARCHAR},
      </if>
      <if test="noticeDeliveryWay != null" >
        #{noticeDeliveryWay,jdbcType=VARCHAR},
      </if>
      <if test="province != null" >
        #{province,jdbcType=VARCHAR},
      </if>
      <if test="city != null" >
        #{city,jdbcType=VARCHAR},
      </if>
      <if test="street != null" >
        #{street,jdbcType=VARCHAR},
      </if>
      <if test="qq != null" >
        #{qq,jdbcType=VARCHAR},
      </if>
      <if test="mrusertype != null" >
        #{mrusertype,jdbcType=CHAR},
      </if>
      <if test="mrusertime != null" >
        #{mrusertime,jdbcType=TIMESTAMP},
      </if>
      <if test="ckuuserphoto != null" >
        #{ckuuserphoto,jdbcType=VARCHAR},
      </if>
      <if test="recommender != null" >
        #{recommender,jdbcType=VARCHAR},
      </if>
      <if test="telTime != null" >
        #{telTime,jdbcType=TIMESTAMP},
      </if>
      <if test="isnewuser != null" >
        #{isnewuser,jdbcType=CHAR},
      </if>
      <if test="ssJstime != null" >
        #{ssJstime,jdbcType=TIMESTAMP},
      </if>
      <if test="qydusertype != null" >
        #{qydusertype,jdbcType=CHAR},
      </if>
      <if test="qydusertime != null" >
        #{qydusertime,jdbcType=TIMESTAMP},
      </if>
      <if test="ckuClub != null" >
        #{ckuClub,jdbcType=VARCHAR},
      </if>
      <if test="ckuCardtype != null" >
        #{ckuCardtype,jdbcType=VARCHAR},
      </if>
      <if test="payin != null" >
        #{payin,jdbcType=DECIMAL},
      </if>
      <if test="payout != null" >
        #{payout,jdbcType=DECIMAL},
      </if>
      <if test="yue1 != null" >
        #{yue1,jdbcType=DECIMAL},
      </if>
      <if test="yue2 != null" >
        #{yue2,jdbcType=DECIMAL},
      </if>
      <if test="remarks != null" >
        #{remarks,jdbcType=LONGVARCHAR},
      </if>
      <if test="operator != null" >
        #{operator,jdbcType=LONGVARCHAR},
      </if>
      <if test="mrbeizhu != null" >
        #{mrbeizhu,jdbcType=LONGVARCHAR},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.cku.model.CkuUserWithBLOBs" >
    update cku_user
    <set >
      <if test="payStatus != null" >
        pay_status = #{payStatus,jdbcType=VARCHAR},
      </if>
      <if test="memberNum != null" >
        member_num = #{memberNum,jdbcType=VARCHAR},
      </if>
      <if test="webMember != null" >
        web_member = #{webMember,jdbcType=VARCHAR},
      </if>
      <if test="name != null" >
        name = #{name,jdbcType=VARCHAR},
      </if>
      <if test="nameSpelling != null" >
        name_spelling = #{nameSpelling,jdbcType=VARCHAR},
      </if>
      <if test="gender != null" >
        gender = #{gender,jdbcType=VARCHAR},
      </if>
      <if test="birthday != null" >
        birthday = #{birthday,jdbcType=TIMESTAMP},
      </if>
      <if test="idNum != null" >
        id_num = #{idNum,jdbcType=VARCHAR},
      </if>
      <if test="contactAddress != null" >
        contact_address = #{contactAddress,jdbcType=VARCHAR},
      </if>
      <if test="postCode != null" >
        post_code = #{postCode,jdbcType=VARCHAR},
      </if>
      <if test="telephone != null" >
        telephone = #{telephone,jdbcType=VARCHAR},
      </if>
      <if test="mobilePhone != null" >
        mobile_phone = #{mobilePhone,jdbcType=VARCHAR},
      </if>
      <if test="fax != null" >
        fax = #{fax,jdbcType=VARCHAR},
      </if>
      <if test="email != null" >
        Email = #{email,jdbcType=VARCHAR},
      </if>
      <if test="regMemberNum != null" >
        reg_member_num = #{regMemberNum,jdbcType=VARCHAR},
      </if>
      <if test="regBreedingNum != null" >
        reg_breeding_num = #{regBreedingNum,jdbcType=VARCHAR},
      </if>
      <if test="regData != null" >
        reg_data = #{regData,jdbcType=TIMESTAMP},
      </if>
      <if test="memberType != null" >
        member_type = #{memberType,jdbcType=VARCHAR},
      </if>
      <if test="payDetail != null" >
        pay_detail = #{payDetail,jdbcType=VARCHAR},
      </if>
      <if test="memberBeginTime != null" >
        member_begin_time = #{memberBeginTime,jdbcType=TIMESTAMP},
      </if>
      <if test="memberDeadlineTime != null" >
        member_deadline_time = #{memberDeadlineTime,jdbcType=TIMESTAMP},
      </if>
      <if test="regBy != null" >
        reg_by = #{regBy,jdbcType=VARCHAR},
      </if>
      <if test="modifiDate != null" >
        modifi_date = #{modifiDate,jdbcType=TIMESTAMP},
      </if>
      <if test="delTag != null" >
        del_tag = #{delTag,jdbcType=CHAR},
      </if>
      <if test="qslzTag != null" >
        qslz_tag = #{qslzTag,jdbcType=CHAR},
      </if>
      <if test="qslzTime != null" >
        qslz_time = #{qslzTime,jdbcType=TIMESTAMP},
      </if>
      <if test="deliveryWay != null" >
        delivery_way = #{deliveryWay,jdbcType=VARCHAR},
      </if>
      <if test="certifiDeliveryWay != null" >
        certifi_delivery_way = #{certifiDeliveryWay,jdbcType=VARCHAR},
      </if>
      <if test="noticeDeliveryWay != null" >
        notice_delivery_way = #{noticeDeliveryWay,jdbcType=VARCHAR},
      </if>
      <if test="province != null" >
        Province = #{province,jdbcType=VARCHAR},
      </if>
      <if test="city != null" >
        City = #{city,jdbcType=VARCHAR},
      </if>
      <if test="street != null" >
        Street = #{street,jdbcType=VARCHAR},
      </if>
      <if test="qq != null" >
        QQ = #{qq,jdbcType=VARCHAR},
      </if>
      <if test="mrusertype != null" >
        mrUserType = #{mrusertype,jdbcType=CHAR},
      </if>
      <if test="mrusertime != null" >
        mrUserTime = #{mrusertime,jdbcType=TIMESTAMP},
      </if>
      <if test="ckuuserphoto != null" >
        ckuUserPhoto = #{ckuuserphoto,jdbcType=VARCHAR},
      </if>
      <if test="recommender != null" >
        recommender = #{recommender,jdbcType=VARCHAR},
      </if>
      <if test="telTime != null" >
        tel_time = #{telTime,jdbcType=TIMESTAMP},
      </if>
      <if test="isnewuser != null" >
        isNewUser = #{isnewuser,jdbcType=CHAR},
      </if>
      <if test="ssJstime != null" >
        SS_jstime = #{ssJstime,jdbcType=TIMESTAMP},
      </if>
      <if test="qydusertype != null" >
        qydUserType = #{qydusertype,jdbcType=CHAR},
      </if>
      <if test="qydusertime != null" >
        qydUserTime = #{qydusertime,jdbcType=TIMESTAMP},
      </if>
      <if test="ckuClub != null" >
        cku_club = #{ckuClub,jdbcType=VARCHAR},
      </if>
      <if test="ckuCardtype != null" >
        cku_cardtype = #{ckuCardtype,jdbcType=VARCHAR},
      </if>
      <if test="payin != null" >
        payin = #{payin,jdbcType=DECIMAL},
      </if>
      <if test="payout != null" >
        payout = #{payout,jdbcType=DECIMAL},
      </if>
      <if test="yue1 != null" >
        yue1 = #{yue1,jdbcType=DECIMAL},
      </if>
      <if test="yue2 != null" >
        yue2 = #{yue2,jdbcType=DECIMAL},
      </if>
      <if test="remarks != null" >
        remarks = #{remarks,jdbcType=LONGVARCHAR},
      </if>
      <if test="operator != null" >
        operator = #{operator,jdbcType=LONGVARCHAR},
      </if>
      <if test="mrbeizhu != null" >
        mrBeiZhu = #{mrbeizhu,jdbcType=LONGVARCHAR},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKeyWithBLOBs" parameterType="com.cku.model.CkuUserWithBLOBs" >
    update cku_user
    set pay_status = #{payStatus,jdbcType=VARCHAR},
      member_num = #{memberNum,jdbcType=VARCHAR},
      web_member = #{webMember,jdbcType=VARCHAR},
      name = #{name,jdbcType=VARCHAR},
      name_spelling = #{nameSpelling,jdbcType=VARCHAR},
      gender = #{gender,jdbcType=VARCHAR},
      birthday = #{birthday,jdbcType=TIMESTAMP},
      id_num = #{idNum,jdbcType=VARCHAR},
      contact_address = #{contactAddress,jdbcType=VARCHAR},
      post_code = #{postCode,jdbcType=VARCHAR},
      telephone = #{telephone,jdbcType=VARCHAR},
      mobile_phone = #{mobilePhone,jdbcType=VARCHAR},
      fax = #{fax,jdbcType=VARCHAR},
      Email = #{email,jdbcType=VARCHAR},
      reg_member_num = #{regMemberNum,jdbcType=VARCHAR},
      reg_breeding_num = #{regBreedingNum,jdbcType=VARCHAR},
      reg_data = #{regData,jdbcType=TIMESTAMP},
      member_type = #{memberType,jdbcType=VARCHAR},
      pay_detail = #{payDetail,jdbcType=VARCHAR},
      member_begin_time = #{memberBeginTime,jdbcType=TIMESTAMP},
      member_deadline_time = #{memberDeadlineTime,jdbcType=TIMESTAMP},
      reg_by = #{regBy,jdbcType=VARCHAR},
      modifi_date = #{modifiDate,jdbcType=TIMESTAMP},
      del_tag = #{delTag,jdbcType=CHAR},
      qslz_tag = #{qslzTag,jdbcType=CHAR},
      qslz_time = #{qslzTime,jdbcType=TIMESTAMP},
      delivery_way = #{deliveryWay,jdbcType=VARCHAR},
      certifi_delivery_way = #{certifiDeliveryWay,jdbcType=VARCHAR},
      notice_delivery_way = #{noticeDeliveryWay,jdbcType=VARCHAR},
      Province = #{province,jdbcType=VARCHAR},
      City = #{city,jdbcType=VARCHAR},
      Street = #{street,jdbcType=VARCHAR},
      QQ = #{qq,jdbcType=VARCHAR},
      mrUserType = #{mrusertype,jdbcType=CHAR},
      mrUserTime = #{mrusertime,jdbcType=TIMESTAMP},
      ckuUserPhoto = #{ckuuserphoto,jdbcType=VARCHAR},
      recommender = #{recommender,jdbcType=VARCHAR},
      tel_time = #{telTime,jdbcType=TIMESTAMP},
      isNewUser = #{isnewuser,jdbcType=CHAR},
      SS_jstime = #{ssJstime,jdbcType=TIMESTAMP},
      qydUserType = #{qydusertype,jdbcType=CHAR},
      qydUserTime = #{qydusertime,jdbcType=TIMESTAMP},
      cku_club = #{ckuClub,jdbcType=VARCHAR},
      cku_cardtype = #{ckuCardtype,jdbcType=VARCHAR},
      payin = #{payin,jdbcType=DECIMAL},
      payout = #{payout,jdbcType=DECIMAL},
      yue1 = #{yue1,jdbcType=DECIMAL},
      yue2 = #{yue2,jdbcType=DECIMAL},
      remarks = #{remarks,jdbcType=LONGVARCHAR},
      operator = #{operator,jdbcType=LONGVARCHAR},
      mrBeiZhu = #{mrbeizhu,jdbcType=LONGVARCHAR}
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.cku.model.CkuUser" >
    update cku_user
    set pay_status = #{payStatus,jdbcType=VARCHAR},
      member_num = #{memberNum,jdbcType=VARCHAR},
      web_member = #{webMember,jdbcType=VARCHAR},
      name = #{name,jdbcType=VARCHAR},
      name_spelling = #{nameSpelling,jdbcType=VARCHAR},
      gender = #{gender,jdbcType=VARCHAR},
      birthday = #{birthday,jdbcType=TIMESTAMP},
      id_num = #{idNum,jdbcType=VARCHAR},
      contact_address = #{contactAddress,jdbcType=VARCHAR},
      post_code = #{postCode,jdbcType=VARCHAR},
      telephone = #{telephone,jdbcType=VARCHAR},
      mobile_phone = #{mobilePhone,jdbcType=VARCHAR},
      fax = #{fax,jdbcType=VARCHAR},
      Email = #{email,jdbcType=VARCHAR},
      reg_member_num = #{regMemberNum,jdbcType=VARCHAR},
      reg_breeding_num = #{regBreedingNum,jdbcType=VARCHAR},
      reg_data = #{regData,jdbcType=TIMESTAMP},
      member_type = #{memberType,jdbcType=VARCHAR},
      pay_detail = #{payDetail,jdbcType=VARCHAR},
      member_begin_time = #{memberBeginTime,jdbcType=TIMESTAMP},
      member_deadline_time = #{memberDeadlineTime,jdbcType=TIMESTAMP},
      reg_by = #{regBy,jdbcType=VARCHAR},
      modifi_date = #{modifiDate,jdbcType=TIMESTAMP},
      del_tag = #{delTag,jdbcType=CHAR},
      qslz_tag = #{qslzTag,jdbcType=CHAR},
      qslz_time = #{qslzTime,jdbcType=TIMESTAMP},
      delivery_way = #{deliveryWay,jdbcType=VARCHAR},
      certifi_delivery_way = #{certifiDeliveryWay,jdbcType=VARCHAR},
      notice_delivery_way = #{noticeDeliveryWay,jdbcType=VARCHAR},
      Province = #{province,jdbcType=VARCHAR},
      City = #{city,jdbcType=VARCHAR},
      Street = #{street,jdbcType=VARCHAR},
      QQ = #{qq,jdbcType=VARCHAR},
      mrUserType = #{mrusertype,jdbcType=CHAR},
      mrUserTime = #{mrusertime,jdbcType=TIMESTAMP},
      ckuUserPhoto = #{ckuuserphoto,jdbcType=VARCHAR},
      recommender = #{recommender,jdbcType=VARCHAR},
      tel_time = #{telTime,jdbcType=TIMESTAMP},
      isNewUser = #{isnewuser,jdbcType=CHAR},
      SS_jstime = #{ssJstime,jdbcType=TIMESTAMP},
      qydUserType = #{qydusertype,jdbcType=CHAR},
      qydUserTime = #{qydusertime,jdbcType=TIMESTAMP},
      cku_club = #{ckuClub,jdbcType=VARCHAR},
      cku_cardtype = #{ckuCardtype,jdbcType=VARCHAR},
      payin = #{payin,jdbcType=DECIMAL},
      payout = #{payout,jdbcType=DECIMAL},
      yue1 = #{yue1,jdbcType=DECIMAL},
      yue2 = #{yue2,jdbcType=DECIMAL}
    where id = #{id,jdbcType=INTEGER}
  </update>
</mapper>