<?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.platform.dao.OrderRegMapper" >
  <resultMap id="BaseResultMap" type="com.platform.pojo.OrderReg" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <id column="ID" property="id" jdbcType="VARCHAR" />
    <result column="ORDER_DATE" property="orderDate" jdbcType="VARCHAR" />
    <result column="ORDER_NAME" property="orderName" jdbcType="VARCHAR" />
    <result column="PHONE_NUMBER" property="phoneNumber" jdbcType="VARCHAR" />
    <result column="ORDER_SECTION_NO" property="orderSectionNo" jdbcType="VARCHAR" />
    <result column="ORDER_DOCTOR_NO" property="orderDoctorNo" jdbcType="VARCHAR" />
    <result column="ORDER_TYPE" property="orderType" jdbcType="VARCHAR" />
    <result column="REG_TYPE" property="regType" jdbcType="VARCHAR" />
    <result column="REG_CATEGORY_NO" property="regCategoryNo" jdbcType="VARCHAR" />
    <result column="LIMIT_NUMBER" property="limitNumber" jdbcType="DECIMAL" />
    <result column="ORDERED_NUMBER" property="orderedNumber" jdbcType="DECIMAL" />
    <result column="ORDER_SOURCE" property="orderSource" jdbcType="VARCHAR" />
    <result column="SORT_NO" property="sortNo" jdbcType="VARCHAR" />
    <result column="PATIENT_IDCARD_NO" property="patientIdcardNo" jdbcType="VARCHAR" />
    <result column="PATIENT_CARD_NO" property="patientCardNo" jdbcType="VARCHAR" />
    <result column="REG_STATUS" property="regStatus" jdbcType="VARCHAR" />
    <result column="ORDER_SECTION_NAME" property="orderSectionName" jdbcType="VARCHAR" />
    <result column="ORDER_DOCTOR_NAME" property="orderDoctorName" jdbcType="VARCHAR" />
    <result column="REG_CATEGORY_NAME" property="regCategoryName" jdbcType="VARCHAR" />
    <result column="ORDER_TIME" property="orderTime" jdbcType="VARCHAR" />
    <result column="VISIT_DATE" property="visitDate" jdbcType="VARCHAR" />
    <result column="VISIT_TIME" property="visitTime" jdbcType="VARCHAR" />
    <result column="PLAN_ID" property="planId" jdbcType="VARCHAR" />
  </resultMap>
  <sql id="Example_Where_Clause" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <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" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <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" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    ID, ORDER_DATE, ORDER_NAME, PHONE_NUMBER, ORDER_SECTION_NO, ORDER_DOCTOR_NO, ORDER_TYPE, 
    REG_TYPE, REG_CATEGORY_NO, LIMIT_NUMBER, ORDERED_NUMBER, ORDER_SOURCE, SORT_NO, PATIENT_IDCARD_NO, 
    PATIENT_CARD_NO, REG_STATUS, ORDER_SECTION_NAME, ORDER_DOCTOR_NAME, REG_CATEGORY_NAME, 
    ORDER_TIME, VISIT_DATE, VISIT_TIME, PLAN_ID
  </sql>
  <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.platform.pojo.OrderRegExample" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select
    <if test="distinct" >
      distinct
    </if>
    <include refid="Base_Column_List" />
    from ORDER_REG
    <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" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select 
    <include refid="Base_Column_List" />
    from ORDER_REG
    where ID = #{id,jdbcType=VARCHAR}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.String" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from ORDER_REG
    where ID = #{id,jdbcType=VARCHAR}
  </delete>
  <delete id="deleteByExample" parameterType="com.platform.pojo.OrderRegExample" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from ORDER_REG
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </delete>
  <insert id="insert" parameterType="com.platform.pojo.OrderReg" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into ORDER_REG (ID, ORDER_DATE, ORDER_NAME, 
      PHONE_NUMBER, ORDER_SECTION_NO, ORDER_DOCTOR_NO, 
      ORDER_TYPE, REG_TYPE, REG_CATEGORY_NO, 
      LIMIT_NUMBER, ORDERED_NUMBER, ORDER_SOURCE, 
      SORT_NO, PATIENT_IDCARD_NO, PATIENT_CARD_NO, 
      REG_STATUS, ORDER_SECTION_NAME, ORDER_DOCTOR_NAME, 
      REG_CATEGORY_NAME, ORDER_TIME, VISIT_DATE, 
      VISIT_TIME, PLAN_ID)
    values (#{id,jdbcType=VARCHAR}, #{orderDate,jdbcType=VARCHAR}, #{orderName,jdbcType=VARCHAR}, 
      #{phoneNumber,jdbcType=VARCHAR}, #{orderSectionNo,jdbcType=VARCHAR}, #{orderDoctorNo,jdbcType=VARCHAR}, 
      #{orderType,jdbcType=VARCHAR}, #{regType,jdbcType=VARCHAR}, #{regCategoryNo,jdbcType=VARCHAR}, 
      #{limitNumber,jdbcType=DECIMAL}, #{orderedNumber,jdbcType=DECIMAL}, #{orderSource,jdbcType=VARCHAR}, 
      #{sortNo,jdbcType=VARCHAR}, #{patientIdcardNo,jdbcType=VARCHAR}, #{patientCardNo,jdbcType=VARCHAR}, 
      #{regStatus,jdbcType=VARCHAR}, #{orderSectionName,jdbcType=VARCHAR}, #{orderDoctorName,jdbcType=VARCHAR}, 
      #{regCategoryName,jdbcType=VARCHAR}, #{orderTime,jdbcType=VARCHAR}, #{visitDate,jdbcType=VARCHAR}, 
      #{visitTime,jdbcType=VARCHAR}, #{planId,jdbcType=VARCHAR})
  </insert>
  <insert id="insertSelective" useGeneratedKeys="true" keyProperty="id" parameterType="com.platform.pojo.OrderReg" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into ORDER_REG
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        ID,
      </if>
      <if test="orderDate != null" >
        ORDER_DATE,
      </if>
      <if test="orderName != null" >
        ORDER_NAME,
      </if>
      <if test="phoneNumber != null" >
        PHONE_NUMBER,
      </if>
      <if test="orderSectionNo != null" >
        ORDER_SECTION_NO,
      </if>
      <if test="orderDoctorNo != null" >
        ORDER_DOCTOR_NO,
      </if>
      <if test="orderType != null" >
        ORDER_TYPE,
      </if>
      <if test="regType != null" >
        REG_TYPE,
      </if>
      <if test="regCategoryNo != null" >
        REG_CATEGORY_NO,
      </if>
      <if test="limitNumber != null" >
        LIMIT_NUMBER,
      </if>
      <if test="orderedNumber != null" >
        ORDERED_NUMBER,
      </if>
      <if test="orderSource != null" >
        ORDER_SOURCE,
      </if>
      <if test="sortNo != null" >
        SORT_NO,
      </if>
      <if test="patientIdcardNo != null" >
        PATIENT_IDCARD_NO,
      </if>
      <if test="patientCardNo != null" >
        PATIENT_CARD_NO,
      </if>
      <if test="regStatus != null" >
        REG_STATUS,
      </if>
      <if test="orderSectionName != null" >
        ORDER_SECTION_NAME,
      </if>
      <if test="orderDoctorName != null" >
        ORDER_DOCTOR_NAME,
      </if>
      <if test="regCategoryName != null" >
        REG_CATEGORY_NAME,
      </if>
      <if test="orderTime != null" >
        ORDER_TIME,
      </if>
      <if test="visitDate != null" >
        VISIT_DATE,
      </if>
      <if test="visitTime != null" >
        VISIT_TIME,
      </if>
      <if test="planId != null" >
        PLAN_ID,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        #{id,jdbcType=VARCHAR},
      </if>
      <if test="orderDate != null" >
        #{orderDate,jdbcType=VARCHAR},
      </if>
      <if test="orderName != null" >
        #{orderName,jdbcType=VARCHAR},
      </if>
      <if test="phoneNumber != null" >
        #{phoneNumber,jdbcType=VARCHAR},
      </if>
      <if test="orderSectionNo != null" >
        #{orderSectionNo,jdbcType=VARCHAR},
      </if>
      <if test="orderDoctorNo != null" >
        #{orderDoctorNo,jdbcType=VARCHAR},
      </if>
      <if test="orderType != null" >
        #{orderType,jdbcType=VARCHAR},
      </if>
      <if test="regType != null" >
        #{regType,jdbcType=VARCHAR},
      </if>
      <if test="regCategoryNo != null" >
        #{regCategoryNo,jdbcType=VARCHAR},
      </if>
      <if test="limitNumber != null" >
        #{limitNumber,jdbcType=DECIMAL},
      </if>
      <if test="orderedNumber != null" >
        #{orderedNumber,jdbcType=DECIMAL},
      </if>
      <if test="orderSource != null" >
        #{orderSource,jdbcType=VARCHAR},
      </if>
      <if test="sortNo != null" >
        #{sortNo,jdbcType=VARCHAR},
      </if>
      <if test="patientIdcardNo != null" >
        #{patientIdcardNo,jdbcType=VARCHAR},
      </if>
      <if test="patientCardNo != null" >
        #{patientCardNo,jdbcType=VARCHAR},
      </if>
      <if test="regStatus != null" >
        #{regStatus,jdbcType=VARCHAR},
      </if>
      <if test="orderSectionName != null" >
        #{orderSectionName,jdbcType=VARCHAR},
      </if>
      <if test="orderDoctorName != null" >
        #{orderDoctorName,jdbcType=VARCHAR},
      </if>
      <if test="regCategoryName != null" >
        #{regCategoryName,jdbcType=VARCHAR},
      </if>
      <if test="orderTime != null" >
        #{orderTime,jdbcType=VARCHAR},
      </if>
      <if test="visitDate != null" >
        #{visitDate,jdbcType=VARCHAR},
      </if>
      <if test="visitTime != null" >
        #{visitTime,jdbcType=VARCHAR},
      </if>
      <if test="planId != null" >
        #{planId,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.platform.pojo.OrderRegExample" resultType="java.lang.Integer" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select count(*) from ORDER_REG
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </select>
  <update id="updateByExampleSelective" parameterType="map" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update ORDER_REG
    <set >
      <if test="record.id != null" >
        ID = #{record.id,jdbcType=VARCHAR},
      </if>
      <if test="record.orderDate != null" >
        ORDER_DATE = #{record.orderDate,jdbcType=VARCHAR},
      </if>
      <if test="record.orderName != null" >
        ORDER_NAME = #{record.orderName,jdbcType=VARCHAR},
      </if>
      <if test="record.phoneNumber != null" >
        PHONE_NUMBER = #{record.phoneNumber,jdbcType=VARCHAR},
      </if>
      <if test="record.orderSectionNo != null" >
        ORDER_SECTION_NO = #{record.orderSectionNo,jdbcType=VARCHAR},
      </if>
      <if test="record.orderDoctorNo != null" >
        ORDER_DOCTOR_NO = #{record.orderDoctorNo,jdbcType=VARCHAR},
      </if>
      <if test="record.orderType != null" >
        ORDER_TYPE = #{record.orderType,jdbcType=VARCHAR},
      </if>
      <if test="record.regType != null" >
        REG_TYPE = #{record.regType,jdbcType=VARCHAR},
      </if>
      <if test="record.regCategoryNo != null" >
        REG_CATEGORY_NO = #{record.regCategoryNo,jdbcType=VARCHAR},
      </if>
      <if test="record.limitNumber != null" >
        LIMIT_NUMBER = #{record.limitNumber,jdbcType=DECIMAL},
      </if>
      <if test="record.orderedNumber != null" >
        ORDERED_NUMBER = #{record.orderedNumber,jdbcType=DECIMAL},
      </if>
      <if test="record.orderSource != null" >
        ORDER_SOURCE = #{record.orderSource,jdbcType=VARCHAR},
      </if>
      <if test="record.sortNo != null" >
        SORT_NO = #{record.sortNo,jdbcType=VARCHAR},
      </if>
      <if test="record.patientIdcardNo != null" >
        PATIENT_IDCARD_NO = #{record.patientIdcardNo,jdbcType=VARCHAR},
      </if>
      <if test="record.patientCardNo != null" >
        PATIENT_CARD_NO = #{record.patientCardNo,jdbcType=VARCHAR},
      </if>
      <if test="record.regStatus != null" >
        REG_STATUS = #{record.regStatus,jdbcType=VARCHAR},
      </if>
      <if test="record.orderSectionName != null" >
        ORDER_SECTION_NAME = #{record.orderSectionName,jdbcType=VARCHAR},
      </if>
      <if test="record.orderDoctorName != null" >
        ORDER_DOCTOR_NAME = #{record.orderDoctorName,jdbcType=VARCHAR},
      </if>
      <if test="record.regCategoryName != null" >
        REG_CATEGORY_NAME = #{record.regCategoryName,jdbcType=VARCHAR},
      </if>
      <if test="record.orderTime != null" >
        ORDER_TIME = #{record.orderTime,jdbcType=VARCHAR},
      </if>
      <if test="record.visitDate != null" >
        VISIT_DATE = #{record.visitDate,jdbcType=VARCHAR},
      </if>
      <if test="record.visitTime != null" >
        VISIT_TIME = #{record.visitTime,jdbcType=VARCHAR},
      </if>
      <if test="record.planId != null" >
        PLAN_ID = #{record.planId,jdbcType=VARCHAR},
      </if>
    </set>
    <if test="_parameter != null" >
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByExample" parameterType="map" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update ORDER_REG
    set ID = #{record.id,jdbcType=VARCHAR},
      ORDER_DATE = #{record.orderDate,jdbcType=VARCHAR},
      ORDER_NAME = #{record.orderName,jdbcType=VARCHAR},
      PHONE_NUMBER = #{record.phoneNumber,jdbcType=VARCHAR},
      ORDER_SECTION_NO = #{record.orderSectionNo,jdbcType=VARCHAR},
      ORDER_DOCTOR_NO = #{record.orderDoctorNo,jdbcType=VARCHAR},
      ORDER_TYPE = #{record.orderType,jdbcType=VARCHAR},
      REG_TYPE = #{record.regType,jdbcType=VARCHAR},
      REG_CATEGORY_NO = #{record.regCategoryNo,jdbcType=VARCHAR},
      LIMIT_NUMBER = #{record.limitNumber,jdbcType=DECIMAL},
      ORDERED_NUMBER = #{record.orderedNumber,jdbcType=DECIMAL},
      ORDER_SOURCE = #{record.orderSource,jdbcType=VARCHAR},
      SORT_NO = #{record.sortNo,jdbcType=VARCHAR},
      PATIENT_IDCARD_NO = #{record.patientIdcardNo,jdbcType=VARCHAR},
      PATIENT_CARD_NO = #{record.patientCardNo,jdbcType=VARCHAR},
      REG_STATUS = #{record.regStatus,jdbcType=VARCHAR},
      ORDER_SECTION_NAME = #{record.orderSectionName,jdbcType=VARCHAR},
      ORDER_DOCTOR_NAME = #{record.orderDoctorName,jdbcType=VARCHAR},
      REG_CATEGORY_NAME = #{record.regCategoryName,jdbcType=VARCHAR},
      ORDER_TIME = #{record.orderTime,jdbcType=VARCHAR},
      VISIT_DATE = #{record.visitDate,jdbcType=VARCHAR},
      VISIT_TIME = #{record.visitTime,jdbcType=VARCHAR},
      PLAN_ID = #{record.planId,jdbcType=VARCHAR}
    <if test="_parameter != null" >
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByPrimaryKeySelective" parameterType="com.platform.pojo.OrderReg" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update ORDER_REG
    <set >
      <if test="orderDate != null" >
        ORDER_DATE = #{orderDate,jdbcType=VARCHAR},
      </if>
      <if test="orderName != null" >
        ORDER_NAME = #{orderName,jdbcType=VARCHAR},
      </if>
      <if test="phoneNumber != null" >
        PHONE_NUMBER = #{phoneNumber,jdbcType=VARCHAR},
      </if>
      <if test="orderSectionNo != null" >
        ORDER_SECTION_NO = #{orderSectionNo,jdbcType=VARCHAR},
      </if>
      <if test="orderDoctorNo != null" >
        ORDER_DOCTOR_NO = #{orderDoctorNo,jdbcType=VARCHAR},
      </if>
      <if test="orderType != null" >
        ORDER_TYPE = #{orderType,jdbcType=VARCHAR},
      </if>
      <if test="regType != null" >
        REG_TYPE = #{regType,jdbcType=VARCHAR},
      </if>
      <if test="regCategoryNo != null" >
        REG_CATEGORY_NO = #{regCategoryNo,jdbcType=VARCHAR},
      </if>
      <if test="limitNumber != null" >
        LIMIT_NUMBER = #{limitNumber,jdbcType=DECIMAL},
      </if>
      <if test="orderedNumber != null" >
        ORDERED_NUMBER = #{orderedNumber,jdbcType=DECIMAL},
      </if>
      <if test="orderSource != null" >
        ORDER_SOURCE = #{orderSource,jdbcType=VARCHAR},
      </if>
      <if test="sortNo != null" >
        SORT_NO = #{sortNo,jdbcType=VARCHAR},
      </if>
      <if test="patientIdcardNo != null" >
        PATIENT_IDCARD_NO = #{patientIdcardNo,jdbcType=VARCHAR},
      </if>
      <if test="patientCardNo != null" >
        PATIENT_CARD_NO = #{patientCardNo,jdbcType=VARCHAR},
      </if>
      <if test="regStatus != null" >
        REG_STATUS = #{regStatus,jdbcType=VARCHAR},
      </if>
      <if test="orderSectionName != null" >
        ORDER_SECTION_NAME = #{orderSectionName,jdbcType=VARCHAR},
      </if>
      <if test="orderDoctorName != null" >
        ORDER_DOCTOR_NAME = #{orderDoctorName,jdbcType=VARCHAR},
      </if>
      <if test="regCategoryName != null" >
        REG_CATEGORY_NAME = #{regCategoryName,jdbcType=VARCHAR},
      </if>
      <if test="orderTime != null" >
        ORDER_TIME = #{orderTime,jdbcType=VARCHAR},
      </if>
      <if test="visitDate != null" >
        VISIT_DATE = #{visitDate,jdbcType=VARCHAR},
      </if>
      <if test="visitTime != null" >
        VISIT_TIME = #{visitTime,jdbcType=VARCHAR},
      </if>
      <if test="planId != null" >
        PLAN_ID = #{planId,jdbcType=VARCHAR},
      </if>
    </set>
    where ID = #{id,jdbcType=VARCHAR}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.platform.pojo.OrderReg" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update ORDER_REG
    set ORDER_DATE = #{orderDate,jdbcType=VARCHAR},
      ORDER_NAME = #{orderName,jdbcType=VARCHAR},
      PHONE_NUMBER = #{phoneNumber,jdbcType=VARCHAR},
      ORDER_SECTION_NO = #{orderSectionNo,jdbcType=VARCHAR},
      ORDER_DOCTOR_NO = #{orderDoctorNo,jdbcType=VARCHAR},
      ORDER_TYPE = #{orderType,jdbcType=VARCHAR},
      REG_TYPE = #{regType,jdbcType=VARCHAR},
      REG_CATEGORY_NO = #{regCategoryNo,jdbcType=VARCHAR},
      LIMIT_NUMBER = #{limitNumber,jdbcType=DECIMAL},
      ORDERED_NUMBER = #{orderedNumber,jdbcType=DECIMAL},
      ORDER_SOURCE = #{orderSource,jdbcType=VARCHAR},
      SORT_NO = #{sortNo,jdbcType=VARCHAR},
      PATIENT_IDCARD_NO = #{patientIdcardNo,jdbcType=VARCHAR},
      PATIENT_CARD_NO = #{patientCardNo,jdbcType=VARCHAR},
      REG_STATUS = #{regStatus,jdbcType=VARCHAR},
      ORDER_SECTION_NAME = #{orderSectionName,jdbcType=VARCHAR},
      ORDER_DOCTOR_NAME = #{orderDoctorName,jdbcType=VARCHAR},
      REG_CATEGORY_NAME = #{regCategoryName,jdbcType=VARCHAR},
      ORDER_TIME = #{orderTime,jdbcType=VARCHAR},
      VISIT_DATE = #{visitDate,jdbcType=VARCHAR},
      VISIT_TIME = #{visitTime,jdbcType=VARCHAR},
      PLAN_ID = #{planId,jdbcType=VARCHAR}
    where ID = #{id,jdbcType=VARCHAR}
  </update>
</mapper>