<?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.steerinfo.ems.tcm036.mapper.TCm036Mapper">
  <resultMap id="BaseResultMap" type="com.steerinfo.ems.tcm036.model.TCm036">
    <id column="BILLSNO" jdbcType="VARCHAR" property="billsno" />
    <result column="RECORDID" jdbcType="VARCHAR" property="recordid" />
    <result column="ADDRESS" jdbcType="VARCHAR" property="address" />
    <result column="APPLYCHARGEMAN" jdbcType="VARCHAR" property="applychargeman" />
    <result column="APPLYMAN" jdbcType="VARCHAR" property="applyman" />
    <result column="APPLYUNIT" jdbcType="VARCHAR" property="applyunit" />
    <result column="ATTENTION" jdbcType="VARCHAR" property="attention" />
    <result column="BILLSTATUS" jdbcType="VARCHAR" property="billstatus" />
    <result column="CHARGEMANTEL" jdbcType="VARCHAR" property="chargemantel" />
    <result column="CONTENTCHANGE" jdbcType="VARCHAR" property="contentchange" />
    <result column="CREATTIME" jdbcType="VARCHAR" property="creattime" />
    <result column="EQUIPMENTNAME" jdbcType="VARCHAR" property="equipmentname" />
    <result column="EXECUTIVECHARGEMAN" jdbcType="VARCHAR" property="executivechargeman" />
    <result column="EXECUTIVESITUATION" jdbcType="VARCHAR" property="executivesituation" />
    <result column="EXECUTIVETIME" jdbcType="VARCHAR" property="executivetime" />
    <result column="LINKMANTEL" jdbcType="VARCHAR" property="linkmantel" />
    <result column="MEDIUMSYSTEM" jdbcType="VARCHAR" property="mediumsystem" />
    <result column="NOTE" jdbcType="VARCHAR" property="note" />
    <result column="OPERATESTATUS" jdbcType="VARCHAR" property="operatestatus" />
    <result column="RESTARTTIME" jdbcType="VARCHAR" property="restarttime" />
    <result column="SAFETYPRECAUTIONS" jdbcType="VARCHAR" property="safetyprecautions" />
    <result column="SIGNMAN" jdbcType="VARCHAR" property="signman" />
    <result column="SIGNTIME" jdbcType="VARCHAR" property="signtime" />
    <result column="STOPTIME" jdbcType="VARCHAR" property="stoptime" />
    <result column="STRUCTDIAGRAM" jdbcType="VARCHAR" property="structdiagram" />
    <result column="STRUCTUREDIAGRAM" jdbcType="VARCHAR" property="structurediagram" />
    <result column="TASKSTATUS" jdbcType="VARCHAR" property="taskstatus" />
    <result column="TIMEOVER" jdbcType="VARCHAR" property="timeover" />
    <result column="TIMESTART" jdbcType="VARCHAR" property="timestart" />
    <result column="WORKCONTENT" jdbcType="VARCHAR" property="workcontent" />
  </resultMap>

  <select id="selectByPrimaryKey" parameterType="java.lang.String" resultMap="BaseResultMap">
    select BILLSNO, RECORDID, ADDRESS, APPLYCHARGEMAN, APPLYMAN, APPLYUNIT, ATTENTION,
    BILLSTATUS, CHARGEMANTEL, CONTENTCHANGE, CREATTIME, EQUIPMENTNAME, EXECUTIVECHARGEMAN,
    EXECUTIVESITUATION, EXECUTIVETIME, LINKMANTEL, MEDIUMSYSTEM, NOTE, OPERATESTATUS,
    RESTARTTIME, SAFETYPRECAUTIONS, SIGNMAN, SIGNTIME, STOPTIME, STRUCTDIAGRAM, STRUCTUREDIAGRAM, TASKSTATUS,
    TIMEOVER, TIMESTART, WORKCONTENT
    from T_CM_036
    where BILLSNO = #{billsno,jdbcType=VARCHAR}
  </select>

  <select id="selectByParameters" parameterType="java.util.HashMap" resultMap="BaseResultMap">
    select BILLSNO, RECORDID, ADDRESS, APPLYCHARGEMAN, APPLYMAN, APPLYUNIT, ATTENTION,
    BILLSTATUS, CHARGEMANTEL, CONTENTCHANGE, CREATTIME, EQUIPMENTNAME, EXECUTIVECHARGEMAN,
    EXECUTIVESITUATION, EXECUTIVETIME, LINKMANTEL, MEDIUMSYSTEM, NOTE, OPERATESTATUS,
    RESTARTTIME, SAFETYPRECAUTIONS, SIGNMAN, SIGNTIME, STOPTIME, STRUCTDIAGRAM, STRUCTUREDIAGRAM, TASKSTATUS,
    TIMEOVER, TIMESTART, WORKCONTENT
    from T_CM_036
    <where>
      <if test="mediumsystem != null and mediumsystem != ''">
        and MEDIUMSYSTEM = #{mediumsystem}
      </if>
      <if test="applyman != null and applyman != ''">
        and APPLYMAN like '%${applyman}%'
      </if>
      <if test="applyunit != null and applyunit != ''">
        and APPLYUNIT like '%${applyunit}%'
      </if>
      <if test="equipmentname != null and equipmentname != ''">
        and EQUIPMENTNAME like '%${equipmentname}%'
      </if>
      <if test="operatestatus != null and operatestatus != ''">
        and OPERATESTATUS = #{operatestatus}
      </if>
      <if test="billstatus != null and billstatus != ''">
        and BILLSTATUS = #{billstatus}
      </if>
      <if test="creattime != null and creattime != ''">
        and CREATTIME &gt;= #{creattime}
      </if>
      <if test="creattimee != null and creattimee != ''">
        and CREATTIME &lt;= #{creattimee}
      </if>
      <if test="signtime != null and signtime != ''">
        and SIGNTIME  &gt;= #{signtime}
      </if>
      <if test="signtimee != null and signtimee != ''">
        and SIGNTIME &lt;= #{signtimee}
      </if>
      <if test="executivetime != null and executivetime != ''">
        and EXECUTIVETIME &gt;= #{executivetime}
      </if>
      <if test="executivetimee != null and executivetimee != ''">
        and EXECUTIVETIME &lt;= #{executivetimee}
      </if>
    </where>
  </select>

  <insert id="insert" parameterType="com.steerinfo.ems.tcm036.model.TCm036">
    insert into T_CM_036 (BILLSNO, RECORDID, ADDRESS,
      APPLYCHARGEMAN, APPLYMAN, APPLYUNIT, ATTENTION, BILLSTATUS, CHARGEMANTEL,
      CONTENTCHANGE, CREATTIME, EQUIPMENTNAME, LINKMANTEL, MEDIUMSYSTEM, OPERATESTATUS, RESTARTTIME,
      SAFETYPRECAUTIONS, STOPTIME, STRUCTDIAGRAM, STRUCTUREDIAGRAM, TASKSTATUS, TIMEOVER, TIMESTART, WORKCONTENT
      )
    values (#{billsno,jdbcType=VARCHAR}, #{recordid,jdbcType=VARCHAR}, #{address,jdbcType=VARCHAR},
      #{applychargeman,jdbcType=VARCHAR}, #{applyman,jdbcType=VARCHAR}, #{applyunit,jdbcType=VARCHAR},
      #{attention,jdbcType=VARCHAR}, #{billstatus,jdbcType=VARCHAR}, #{chargemantel,jdbcType=VARCHAR},
      #{contentchange,jdbcType=VARCHAR}, #{creattime,jdbcType=VARCHAR}, #{equipmentname,jdbcType=VARCHAR},
      #{linkmantel,jdbcType=VARCHAR}, #{mediumsystem,jdbcType=VARCHAR}, #{operatestatus,jdbcType=VARCHAR},
      #{restarttime,jdbcType=VARCHAR}, #{safetyprecautions,jdbcType=VARCHAR}, #{stoptime,jdbcType=VARCHAR},
      #{structdiagram, jdbcType=VARCHAR}, #{structurediagram,jdbcType=VARCHAR}, #{taskstatus,jdbcType=VARCHAR},
      #{timeover,jdbcType=VARCHAR}, #{timestart,jdbcType=VARCHAR}, #{workcontent,jdbcType=VARCHAR}
      )
  </insert>

  <delete id="deleteByPrimaryKey" parameterType="java.lang.String">
    delete from T_CM_036
    where BILLSNO = #{billsno,jdbcType=VARCHAR}
  </delete>

  <delete id="batchDelete" parameterType="java.util.List">
    delete from T_CM_036
    where BILLSNO in
    <foreach close=")" collection="list" item="id" open="(" separator=",">
      #{id}
    </foreach>
  </delete>

  <update id="updateByPrimaryKeySelective" parameterType="com.steerinfo.ems.tcm036.model.TCm036">
    update T_CM_036
    <set>
      <if test="address != null">
        ADDRESS = #{address,jdbcType=VARCHAR},
      </if>
      <if test="applychargeman != null">
        APPLYCHARGEMAN = #{applychargeman,jdbcType=VARCHAR},
      </if>
      <if test="applyman != null">
        APPLYMAN = #{applyman,jdbcType=VARCHAR},
      </if>
      <if test="applyunit != null">
        APPLYUNIT = #{applyunit,jdbcType=VARCHAR},
      </if>
      <if test="attention != null">
        ATTENTION = #{attention,jdbcType=VARCHAR},
      </if>
      <if test="chargemantel != null">
        CHARGEMANTEL = #{chargemantel,jdbcType=VARCHAR},
      </if>
      <if test="contentchange != null">
        CONTENTCHANGE = #{contentchange,jdbcType=VARCHAR},
      </if>
      <if test="creattime != null">
        CREATTIME = #{creattime,jdbcType=VARCHAR},
      </if>
      <if test="equipmentname != null">
        EQUIPMENTNAME = #{equipmentname,jdbcType=VARCHAR},
      </if>
      <if test="linkmantel != null">
        LINKMANTEL = #{linkmantel,jdbcType=VARCHAR},
      </if>
      <if test="restarttime != null">
        RESTARTTIME = #{restarttime,jdbcType=VARCHAR},
      </if>
      <if test="safetyprecautions != null">
        SAFETYPRECAUTIONS = #{safetyprecautions,jdbcType=VARCHAR},
      </if>
      <if test="stoptime != null">
        STOPTIME = #{stoptime,jdbcType=VARCHAR},
      </if>
      <if test="structdiagram != null">
        STRUCTDIAGRAM = #{structdiagram,jdbcType=VARCHAR},
      </if>
      <if test="structurediagram != null">
        STRUCTUREDIAGRAM = #{structurediagram,jdbcType=VARCHAR},
      </if>
      <if test="taskstatus != null">
        TASKSTATUS = #{taskstatus,jdbcType=VARCHAR},
      </if>
      <if test="timeover != null">
        TIMEOVER = #{timeover,jdbcType=VARCHAR},
      </if>
      <if test="timestart != null">
        TIMESTART = #{timestart,jdbcType=VARCHAR},
      </if>
      <if test="workcontent != null">
        WORKCONTENT = #{workcontent,jdbcType=VARCHAR},
      </if>
      <if test="mediumsystem != null">
        MEDIUMSYSTEM = #{mediumsystem,jdbcType=VARCHAR},
      </if>
      <if test="signman != null">
        SIGNMAN = #{signman,jdbcType=VARCHAR},
      </if>
      <if test="signtime != null">
        SIGNTIME = #{signtime,jdbcType=VARCHAR},
      </if>
      <if test="executivechargeman != null">
        EXECUTIVECHARGEMAN = #{executivechargeman,jdbcType=VARCHAR},
      </if>
      <if test="executivesituation != null">
        EXECUTIVESITUATION = #{executivesituation,jdbcType=VARCHAR},
      </if>
      <if test="executivetime != null">
        EXECUTIVETIME = #{executivetime,jdbcType=VARCHAR},
      </if>
      <if test="note != null">
        NOTE = #{note,jdbcType=VARCHAR},
      </if>
      <if test="billstatus != null">
        BILLSTATUS = #{billstatus,jdbcType=VARCHAR},
      </if>
      <if test="operatestatus != null">
        OPERATESTATUS = #{operatestatus,jdbcType=VARCHAR},
      </if>
    </set>
    where BILLSNO = #{billsno,jdbcType=VARCHAR}
  </update>

  <select id="getMaxId" resultType="java.lang.String">
    SELECT MAX(SUBSTR(BILLSNO, LENGTH(BILLSNO) - 3)) FROM T_CM_036
  </select>
  <!--
  <delete id="deleteBySelectiveElement" parameterType="java.util.HashMap">
    delete from T_CM_036
    where 1!=1 
      <if test="recordid != null">
        and RECORDID = #{recordid}
      </if>
      <if test="address != null and address != ''">
        and ADDRESS = #{address}
      </if>
      <if test="applychargeman != null and applychargeman != ''">
        and APPLYCHARGEMAN = #{applychargeman}
      </if>
      <if test="applyman != null and applyman != ''">
        and APPLYMAN = #{applyman}
      </if>
      <if test="applyunit != null and applyunit != ''">
        and APPLYUNIT = #{applyunit}
      </if>
      <if test="attention != null and attention != ''">
        and ATTENTION = #{attention}
      </if>
      <if test="billstatus != null and billstatus != ''">
        and BILLSTATUS = #{billstatus}
      </if>
      <if test="chargemantel != null and chargemantel != ''">
        and CHARGEMANTEL = #{chargemantel}
      </if>
      <if test="contentchange != null and contentchange != ''">
        and CONTENTCHANGE = #{contentchange}
      </if>
      <if test="creattime != null and creattime != ''">
        and CREATTIME = #{creattime}
      </if>
      <if test="equipmentname != null and equipmentname != ''">
        and EQUIPMENTNAME = #{equipmentname}
      </if>
      <if test="executivechargeman != null and executivechargeman != ''">
        and EXECUTIVECHARGEMAN = #{executivechargeman}
      </if>
      <if test="executivesituation != null and executivesituation != ''">
        and EXECUTIVESITUATION = #{executivesituation}
      </if>
      <if test="executivetime != null and executivetime != ''">
        and EXECUTIVETIME = #{executivetime}
      </if>
      <if test="linkmantel != null and linkmantel != ''">
        and LINKMANTEL = #{linkmantel}
      </if>
      <if test="mediumsystem != null and mediumsystem != ''">
        and MEDIUMSYSTEM = #{mediumsystem}
      </if>
      <if test="note != null and note != ''">
        and NOTE = #{note}
      </if>
      <if test="operatestatus != null and operatestatus != ''">
        and OPERATESTATUS = #{operatestatus}
      </if>
      <if test="restarttime != null and restarttime != ''">
        and RESTARTTIME = #{restarttime}
      </if>
      <if test="safetyprecautions != null and safetyprecautions != ''">
        and SAFETYPRECAUTIONS = #{safetyprecautions}
      </if>
      <if test="signman != null and signman != ''">
        and SIGNMAN = #{signman}
      </if>
      <if test="signtime != null and signtime != ''">
        and SIGNTIME = #{signtime}
      </if>
      <if test="stoptime != null and stoptime != ''">
        and STOPTIME = #{stoptime}
      </if>
      <if test="structurediagram != null and structurediagram != ''">
        and STRUCTUREDIAGRAM = #{structurediagram}
      </if>
      <if test="taskstatus != null and taskstatus != ''">
        and TASKSTATUS = #{taskstatus}
      </if>
      <if test="timeover != null and timeover != ''">
        and TIMEOVER = #{timeover}
      </if>
      <if test="timestart != null and timestart != ''">
        and TIMESTART = #{timestart}
      </if>
      <if test="workcontent != null and workcontent != ''">
        and WORKCONTENT = #{workcontent}
      </if>
  </delete>
  <insert id="insertSelective" parameterType="com.steerinfo.ems.tcm036.model.TCm036">
    insert into T_CM_036
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="billsno != null">
        BILLSNO,
      </if>
      <if test="recordid != null">
        RECORDID,
      </if>
      <if test="address != null">
        ADDRESS,
      </if>
      <if test="applychargeman != null">
        APPLYCHARGEMAN,
      </if>
      <if test="applyman != null">
        APPLYMAN,
      </if>
      <if test="applyunit != null">
        APPLYUNIT,
      </if>
      <if test="attention != null">
        ATTENTION,
      </if>
      <if test="billstatus != null">
        BILLSTATUS,
      </if>
      <if test="chargemantel != null">
        CHARGEMANTEL,
      </if>
      <if test="contentchange != null">
        CONTENTCHANGE,
      </if>
      <if test="creattime != null">
        CREATTIME,
      </if>
      <if test="equipmentname != null">
        EQUIPMENTNAME,
      </if>
      <if test="executivechargeman != null">
        EXECUTIVECHARGEMAN,
      </if>
      <if test="executivesituation != null">
        EXECUTIVESITUATION,
      </if>
      <if test="executivetime != null">
        EXECUTIVETIME,
      </if>
      <if test="linkmantel != null">
        LINKMANTEL,
      </if>
      <if test="mediumsystem != null">
        MEDIUMSYSTEM,
      </if>
      <if test="note != null">
        NOTE,
      </if>
      <if test="operatestatus != null">
        OPERATESTATUS,
      </if>
      <if test="restarttime != null">
        RESTARTTIME,
      </if>
      <if test="safetyprecautions != null">
        SAFETYPRECAUTIONS,
      </if>
      <if test="signman != null">
        SIGNMAN,
      </if>
      <if test="signtime != null">
        SIGNTIME,
      </if>
      <if test="stoptime != null">
        STOPTIME,
      </if>
      <if test="structurediagram != null">
        STRUCTUREDIAGRAM,
      </if>
      <if test="taskstatus != null">
        TASKSTATUS,
      </if>
      <if test="timeover != null">
        TIMEOVER,
      </if>
      <if test="timestart != null">
        TIMESTART,
      </if>
      <if test="workcontent != null">
        WORKCONTENT,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="billsno != null">
        #{billsno,jdbcType=VARCHAR},
      </if>
      <if test="recordid != null">
        #{recordid,jdbcType=VARCHAR},
      </if>
      <if test="address != null">
        #{address,jdbcType=VARCHAR},
      </if>
      <if test="applychargeman != null">
        #{applychargeman,jdbcType=VARCHAR},
      </if>
      <if test="applyman != null">
        #{applyman,jdbcType=VARCHAR},
      </if>
      <if test="applyunit != null">
        #{applyunit,jdbcType=VARCHAR},
      </if>
      <if test="attention != null">
        #{attention,jdbcType=VARCHAR},
      </if>
      <if test="billstatus != null">
        #{billstatus,jdbcType=VARCHAR},
      </if>
      <if test="chargemantel != null">
        #{chargemantel,jdbcType=VARCHAR},
      </if>
      <if test="contentchange != null">
        #{contentchange,jdbcType=VARCHAR},
      </if>
      <if test="creattime != null">
        #{creattime,jdbcType=VARCHAR},
      </if>
      <if test="equipmentname != null">
        #{equipmentname,jdbcType=VARCHAR},
      </if>
      <if test="executivechargeman != null">
        #{executivechargeman,jdbcType=VARCHAR},
      </if>
      <if test="executivesituation != null">
        #{executivesituation,jdbcType=VARCHAR},
      </if>
      <if test="executivetime != null">
        #{executivetime,jdbcType=VARCHAR},
      </if>
      <if test="linkmantel != null">
        #{linkmantel,jdbcType=VARCHAR},
      </if>
      <if test="mediumsystem != null">
        #{mediumsystem,jdbcType=VARCHAR},
      </if>
      <if test="note != null">
        #{note,jdbcType=VARCHAR},
      </if>
      <if test="operatestatus != null">
        #{operatestatus,jdbcType=VARCHAR},
      </if>
      <if test="restarttime != null">
        #{restarttime,jdbcType=VARCHAR},
      </if>
      <if test="safetyprecautions != null">
        #{safetyprecautions,jdbcType=VARCHAR},
      </if>
      <if test="signman != null">
        #{signman,jdbcType=VARCHAR},
      </if>
      <if test="signtime != null">
        #{signtime,jdbcType=VARCHAR},
      </if>
      <if test="stoptime != null">
        #{stoptime,jdbcType=VARCHAR},
      </if>
      <if test="structurediagram != null">
        #{structurediagram,jdbcType=VARCHAR},
      </if>
      <if test="taskstatus != null">
        #{taskstatus,jdbcType=VARCHAR},
      </if>
      <if test="timeover != null">
        #{timeover,jdbcType=VARCHAR},
      </if>
      <if test="timestart != null">
        #{timestart,jdbcType=VARCHAR},
      </if>
      <if test="workcontent != null">
        #{workcontent,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKey" parameterType="com.steerinfo.ems.tcm036.model.TCm036">
    update T_CM_036
    set RECORDID = #{recordid,jdbcType=VARCHAR},
      ADDRESS = #{address,jdbcType=VARCHAR},
      APPLYCHARGEMAN = #{applychargeman,jdbcType=VARCHAR},
      APPLYMAN = #{applyman,jdbcType=VARCHAR},
      APPLYUNIT = #{applyunit,jdbcType=VARCHAR},
      ATTENTION = #{attention,jdbcType=VARCHAR},
      BILLSTATUS = #{billstatus,jdbcType=VARCHAR},
      CHARGEMANTEL = #{chargemantel,jdbcType=VARCHAR},
      CONTENTCHANGE = #{contentchange,jdbcType=VARCHAR},
      CREATTIME = #{creattime,jdbcType=VARCHAR},
      EQUIPMENTNAME = #{equipmentname,jdbcType=VARCHAR},
      EXECUTIVECHARGEMAN = #{executivechargeman,jdbcType=VARCHAR},
      EXECUTIVESITUATION = #{executivesituation,jdbcType=VARCHAR},
      EXECUTIVETIME = #{executivetime,jdbcType=VARCHAR},
      LINKMANTEL = #{linkmantel,jdbcType=VARCHAR},
      MEDIUMSYSTEM = #{mediumsystem,jdbcType=VARCHAR},
      NOTE = #{note,jdbcType=VARCHAR},
      OPERATESTATUS = #{operatestatus,jdbcType=VARCHAR},
      RESTARTTIME = #{restarttime,jdbcType=VARCHAR},
      SAFETYPRECAUTIONS = #{safetyprecautions,jdbcType=VARCHAR},
      SIGNMAN = #{signman,jdbcType=VARCHAR},
      SIGNTIME = #{signtime,jdbcType=VARCHAR},
      STOPTIME = #{stoptime,jdbcType=VARCHAR},
      STRUCTUREDIAGRAM = #{structurediagram,jdbcType=VARCHAR},
      TASKSTATUS = #{taskstatus,jdbcType=VARCHAR},
      TIMEOVER = #{timeover,jdbcType=VARCHAR},
      TIMESTART = #{timestart,jdbcType=VARCHAR},
      WORKCONTENT = #{workcontent,jdbcType=VARCHAR}
    where BILLSNO = #{billsno,jdbcType=VARCHAR}
  </update>
  <update id="updateByPrimaryKeySelective" parameterType="com.steerinfo.ems.tcm036.model.TCm036">
    update T_CM_036
    <set>
      <if test="recordid != null">
        RECORDID = #{recordid,jdbcType=VARCHAR},
      </if>
      <if test="address != null">
        ADDRESS = #{address,jdbcType=VARCHAR},
      </if>
      <if test="applychargeman != null">
        APPLYCHARGEMAN = #{applychargeman,jdbcType=VARCHAR},
      </if>
      <if test="applyman != null">
        APPLYMAN = #{applyman,jdbcType=VARCHAR},
      </if>
      <if test="applyunit != null">
        APPLYUNIT = #{applyunit,jdbcType=VARCHAR},
      </if>
      <if test="attention != null">
        ATTENTION = #{attention,jdbcType=VARCHAR},
      </if>
      <if test="billstatus != null">
        BILLSTATUS = #{billstatus,jdbcType=VARCHAR},
      </if>
      <if test="chargemantel != null">
        CHARGEMANTEL = #{chargemantel,jdbcType=VARCHAR},
      </if>
      <if test="contentchange != null">
        CONTENTCHANGE = #{contentchange,jdbcType=VARCHAR},
      </if>
      <if test="creattime != null">
        CREATTIME = #{creattime,jdbcType=VARCHAR},
      </if>
      <if test="equipmentname != null">
        EQUIPMENTNAME = #{equipmentname,jdbcType=VARCHAR},
      </if>
      <if test="executivechargeman != null">
        EXECUTIVECHARGEMAN = #{executivechargeman,jdbcType=VARCHAR},
      </if>
      <if test="executivesituation != null">
        EXECUTIVESITUATION = #{executivesituation,jdbcType=VARCHAR},
      </if>
      <if test="executivetime != null">
        EXECUTIVETIME = #{executivetime,jdbcType=VARCHAR},
      </if>
      <if test="linkmantel != null">
        LINKMANTEL = #{linkmantel,jdbcType=VARCHAR},
      </if>
      <if test="mediumsystem != null">
        MEDIUMSYSTEM = #{mediumsystem,jdbcType=VARCHAR},
      </if>
      <if test="note != null">
        NOTE = #{note,jdbcType=VARCHAR},
      </if>
      <if test="operatestatus != null">
        OPERATESTATUS = #{operatestatus,jdbcType=VARCHAR},
      </if>
      <if test="restarttime != null">
        RESTARTTIME = #{restarttime,jdbcType=VARCHAR},
      </if>
      <if test="safetyprecautions != null">
        SAFETYPRECAUTIONS = #{safetyprecautions,jdbcType=VARCHAR},
      </if>
      <if test="signman != null">
        SIGNMAN = #{signman,jdbcType=VARCHAR},
      </if>
      <if test="signtime != null">
        SIGNTIME = #{signtime,jdbcType=VARCHAR},
      </if>
      <if test="stoptime != null">
        STOPTIME = #{stoptime,jdbcType=VARCHAR},
      </if>
      <if test="structurediagram != null">
        STRUCTUREDIAGRAM = #{structurediagram,jdbcType=VARCHAR},
      </if>
      <if test="taskstatus != null">
        TASKSTATUS = #{taskstatus,jdbcType=VARCHAR},
      </if>
      <if test="timeover != null">
        TIMEOVER = #{timeover,jdbcType=VARCHAR},
      </if>
      <if test="timestart != null">
        TIMESTART = #{timestart,jdbcType=VARCHAR},
      </if>
      <if test="workcontent != null">
        WORKCONTENT = #{workcontent,jdbcType=VARCHAR},
      </if>
    </set>
    where BILLSNO = #{billsno,jdbcType=VARCHAR}
  </update>
  <select id="selectByPrimaryKey" parameterType="java.lang.String" resultMap="BaseResultMap">
    select BILLSNO, RECORDID, ADDRESS, APPLYCHARGEMAN, APPLYMAN, APPLYUNIT, ATTENTION, 
    BILLSTATUS, CHARGEMANTEL, CONTENTCHANGE, CREATTIME, EQUIPMENTNAME, EXECUTIVECHARGEMAN, 
    EXECUTIVESITUATION, EXECUTIVETIME, LINKMANTEL, MEDIUMSYSTEM, NOTE, OPERATESTATUS, 
    RESTARTTIME, SAFETYPRECAUTIONS, SIGNMAN, SIGNTIME, STOPTIME, STRUCTUREDIAGRAM, TASKSTATUS, 
    TIMEOVER, TIMESTART, WORKCONTENT
    from T_CM_036
    where BILLSNO = #{billsno,jdbcType=VARCHAR}
  </select>
  <select id="selectByParameters" parameterType="java.util.HashMap" resultMap="BaseResultMap">
    select BILLSNO, RECORDID, ADDRESS, APPLYCHARGEMAN, APPLYMAN, APPLYUNIT, ATTENTION, 
    BILLSTATUS, CHARGEMANTEL, CONTENTCHANGE, CREATTIME, EQUIPMENTNAME, EXECUTIVECHARGEMAN, 
    EXECUTIVESITUATION, EXECUTIVETIME, LINKMANTEL, MEDIUMSYSTEM, NOTE, OPERATESTATUS, 
    RESTARTTIME, SAFETYPRECAUTIONS, SIGNMAN, SIGNTIME, STOPTIME, STRUCTUREDIAGRAM, TASKSTATUS, 
    TIMEOVER, TIMESTART, WORKCONTENT
    from T_CM_036
    <where> 
      <if test="recordid != null">
        and RECORDID = #{recordid}
      </if>
      <if test="address != null and address != ''">
        and ADDRESS = #{address}
      </if>
      <if test="applychargeman != null and applychargeman != ''">
        and APPLYCHARGEMAN = #{applychargeman}
      </if>
      <if test="applyman != null and applyman != ''">
        and APPLYMAN = #{applyman}
      </if>
      <if test="applyunit != null and applyunit != ''">
        and APPLYUNIT = #{applyunit}
      </if>
      <if test="attention != null and attention != ''">
        and ATTENTION = #{attention}
      </if>
      <if test="billstatus != null and billstatus != ''">
        and BILLSTATUS = #{billstatus}
      </if>
      <if test="chargemantel != null and chargemantel != ''">
        and CHARGEMANTEL = #{chargemantel}
      </if>
      <if test="contentchange != null and contentchange != ''">
        and CONTENTCHANGE = #{contentchange}
      </if>
      <if test="creattime != null and creattime != ''">
        and CREATTIME = #{creattime}
      </if>
      <if test="equipmentname != null and equipmentname != ''">
        and EQUIPMENTNAME = #{equipmentname}
      </if>
      <if test="executivechargeman != null and executivechargeman != ''">
        and EXECUTIVECHARGEMAN = #{executivechargeman}
      </if>
      <if test="executivesituation != null and executivesituation != ''">
        and EXECUTIVESITUATION = #{executivesituation}
      </if>
      <if test="executivetime != null and executivetime != ''">
        and EXECUTIVETIME = #{executivetime}
      </if>
      <if test="linkmantel != null and linkmantel != ''">
        and LINKMANTEL = #{linkmantel}
      </if>
      <if test="mediumsystem != null and mediumsystem != ''">
        and MEDIUMSYSTEM = #{mediumsystem}
      </if>
      <if test="note != null and note != ''">
        and NOTE = #{note}
      </if>
      <if test="operatestatus != null and operatestatus != ''">
        and OPERATESTATUS = #{operatestatus}
      </if>
      <if test="restarttime != null and restarttime != ''">
        and RESTARTTIME = #{restarttime}
      </if>
      <if test="safetyprecautions != null and safetyprecautions != ''">
        and SAFETYPRECAUTIONS = #{safetyprecautions}
      </if>
      <if test="signman != null and signman != ''">
        and SIGNMAN = #{signman}
      </if>
      <if test="signtime != null and signtime != ''">
        and SIGNTIME = #{signtime}
      </if>
      <if test="stoptime != null and stoptime != ''">
        and STOPTIME = #{stoptime}
      </if>
      <if test="structurediagram != null and structurediagram != ''">
        and STRUCTUREDIAGRAM = #{structurediagram}
      </if>
      <if test="taskstatus != null and taskstatus != ''">
        and TASKSTATUS = #{taskstatus}
      </if>
      <if test="timeover != null and timeover != ''">
        and TIMEOVER = #{timeover}
      </if>
      <if test="timestart != null and timestart != ''">
        and TIMESTART = #{timestart}
      </if>
      <if test="workcontent != null and workcontent != ''">
        and WORKCONTENT = #{workcontent}
      </if>
    </where>
  </select>
  <select id="selectLikeByParameters" parameterType="java.util.HashMap" resultMap="BaseResultMap">
    select BILLSNO, RECORDID, ADDRESS, APPLYCHARGEMAN, APPLYMAN, APPLYUNIT, ATTENTION, 
    BILLSTATUS, CHARGEMANTEL, CONTENTCHANGE, CREATTIME, EQUIPMENTNAME, EXECUTIVECHARGEMAN, 
    EXECUTIVESITUATION, EXECUTIVETIME, LINKMANTEL, MEDIUMSYSTEM, NOTE, OPERATESTATUS, 
    RESTARTTIME, SAFETYPRECAUTIONS, SIGNMAN, SIGNTIME, STOPTIME, STRUCTUREDIAGRAM, TASKSTATUS, 
    TIMEOVER, TIMESTART, WORKCONTENT
    from T_CM_036
    <where> 
      <if test="recordid != null">
        and RECORDID = #{recordid}
      </if>
      <if test="address != null and address != ''">
        and ADDRESS LIKE '%${address}%'
      </if>
      <if test="applychargeman != null and applychargeman != ''">
        and APPLYCHARGEMAN LIKE '%${applychargeman}%'
      </if>
      <if test="applyman != null and applyman != ''">
        and APPLYMAN LIKE '%${applyman}%'
      </if>
      <if test="applyunit != null and applyunit != ''">
        and APPLYUNIT LIKE '%${applyunit}%'
      </if>
      <if test="attention != null and attention != ''">
        and ATTENTION LIKE '%${attention}%'
      </if>
      <if test="billstatus != null and billstatus != ''">
        and BILLSTATUS LIKE '%${billstatus}%'
      </if>
      <if test="chargemantel != null and chargemantel != ''">
        and CHARGEMANTEL LIKE '%${chargemantel}%'
      </if>
      <if test="contentchange != null and contentchange != ''">
        and CONTENTCHANGE LIKE '%${contentchange}%'
      </if>
      <if test="creattime != null and creattime != ''">
        and CREATTIME LIKE '%${creattime}%'
      </if>
      <if test="equipmentname != null and equipmentname != ''">
        and EQUIPMENTNAME LIKE '%${equipmentname}%'
      </if>
      <if test="executivechargeman != null and executivechargeman != ''">
        and EXECUTIVECHARGEMAN LIKE '%${executivechargeman}%'
      </if>
      <if test="executivesituation != null and executivesituation != ''">
        and EXECUTIVESITUATION LIKE '%${executivesituation}%'
      </if>
      <if test="executivetime != null and executivetime != ''">
        and EXECUTIVETIME LIKE '%${executivetime}%'
      </if>
      <if test="linkmantel != null and linkmantel != ''">
        and LINKMANTEL LIKE '%${linkmantel}%'
      </if>
      <if test="mediumsystem != null and mediumsystem != ''">
        and MEDIUMSYSTEM LIKE '%${mediumsystem}%'
      </if>
      <if test="note != null and note != ''">
        and NOTE LIKE '%${note}%'
      </if>
      <if test="operatestatus != null and operatestatus != ''">
        and OPERATESTATUS LIKE '%${operatestatus}%'
      </if>
      <if test="restarttime != null and restarttime != ''">
        and RESTARTTIME LIKE '%${restarttime}%'
      </if>
      <if test="safetyprecautions != null and safetyprecautions != ''">
        and SAFETYPRECAUTIONS LIKE '%${safetyprecautions}%'
      </if>
      <if test="signman != null and signman != ''">
        and SIGNMAN LIKE '%${signman}%'
      </if>
      <if test="signtime != null and signtime != ''">
        and SIGNTIME LIKE '%${signtime}%'
      </if>
      <if test="stoptime != null and stoptime != ''">
        and STOPTIME LIKE '%${stoptime}%'
      </if>
      <if test="structurediagram != null and structurediagram != ''">
        and STRUCTUREDIAGRAM LIKE '%${structurediagram}%'
      </if>
      <if test="taskstatus != null and taskstatus != ''">
        and TASKSTATUS LIKE '%${taskstatus}%'
      </if>
      <if test="timeover != null and timeover != ''">
        and TIMEOVER LIKE '%${timeover}%'
      </if>
      <if test="timestart != null and timestart != ''">
        and TIMESTART LIKE '%${timestart}%'
      </if>
      <if test="workcontent != null and workcontent != ''">
        and WORKCONTENT LIKE '%${workcontent}%'
      </if>
    </where>
  </select>
  <insert id="batchInsert" parameterType="java.util.List">
    insert into T_CM_036 
      (BILLSNO, 
      RECORDID, ADDRESS, APPLYCHARGEMAN, 
      APPLYMAN, APPLYUNIT, ATTENTION, 
      BILLSTATUS, CHARGEMANTEL, CONTENTCHANGE, 
      CREATTIME, EQUIPMENTNAME, EXECUTIVECHARGEMAN, 
      EXECUTIVESITUATION, EXECUTIVETIME, 
      LINKMANTEL, MEDIUMSYSTEM, NOTE, 
      OPERATESTATUS, RESTARTTIME, SAFETYPRECAUTIONS, 
      SIGNMAN, SIGNTIME, STOPTIME, 
      STRUCTUREDIAGRAM, TASKSTATUS, 
      TIMEOVER, TIMESTART, WORKCONTENT
      )
    ( <foreach collection="list" item="item" separator="union all"> 
   select  
      #{item.billsno,jdbcType=VARCHAR}, 
      #{item.recordid,jdbcType=VARCHAR}, #{item.address,jdbcType=VARCHAR}, #{item.applychargeman,jdbcType=VARCHAR},
      #{item.applyman,jdbcType=VARCHAR}, #{item.applyunit,jdbcType=VARCHAR}, #{item.attention,jdbcType=VARCHAR}, 
      #{item.billstatus,jdbcType=VARCHAR}, #{item.chargemantel,jdbcType=VARCHAR}, #{item.contentchange,jdbcType=VARCHAR}, 
      #{item.creattime,jdbcType=VARCHAR}, #{item.equipmentname,jdbcType=VARCHAR}, #{item.executivechargeman,jdbcType=VARCHAR}, 
      #{item.executivesituation,jdbcType=VARCHAR}, #{item.executivetime,jdbcType=VARCHAR}, 
      #{item.linkmantel,jdbcType=VARCHAR}, #{item.mediumsystem,jdbcType=VARCHAR}, #{item.note,jdbcType=VARCHAR}, 
      #{item.operatestatus,jdbcType=VARCHAR}, #{item.restarttime,jdbcType=VARCHAR}, #{item.safetyprecautions,jdbcType=VARCHAR}, 
      #{item.signman,jdbcType=VARCHAR}, #{item.signtime,jdbcType=VARCHAR}, #{item.stoptime,jdbcType=VARCHAR}, 
      #{item.structurediagram,jdbcType=VARCHAR}, #{item.taskstatus,jdbcType=VARCHAR}, 
      #{item.timeover,jdbcType=VARCHAR}, #{item.timestart,jdbcType=VARCHAR}, #{item.workcontent,jdbcType=VARCHAR}
       from dual  
   </foreach> )
  </insert>
  <update id="batchUpdate" parameterType="java.util.List">
     update T_CM_036
     set
       BILLSNO=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.billsno,jdbcType=VARCHAR}
       </foreach>
       ,RECORDID=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.recordid,jdbcType=VARCHAR}
       </foreach>
       ,ADDRESS=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.address,jdbcType=VARCHAR}
       </foreach>
       ,APPLYCHARGEMAN=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.applychargeman,jdbcType=VARCHAR}
       </foreach>
       ,APPLYMAN=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.applyman,jdbcType=VARCHAR}
       </foreach>
       ,APPLYUNIT=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.applyunit,jdbcType=VARCHAR}
       </foreach>
       ,ATTENTION=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.attention,jdbcType=VARCHAR}
       </foreach>
       ,BILLSTATUS=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.billstatus,jdbcType=VARCHAR}
       </foreach>
       ,CHARGEMANTEL=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.chargemantel,jdbcType=VARCHAR}
       </foreach>
       ,CONTENTCHANGE=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.contentchange,jdbcType=VARCHAR}
       </foreach>
       ,CREATTIME=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.creattime,jdbcType=VARCHAR}
       </foreach>
       ,EQUIPMENTNAME=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.equipmentname,jdbcType=VARCHAR}
       </foreach>
       ,EXECUTIVECHARGEMAN=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.executivechargeman,jdbcType=VARCHAR}
       </foreach>
       ,EXECUTIVESITUATION=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.executivesituation,jdbcType=VARCHAR}
       </foreach>
       ,EXECUTIVETIME=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.executivetime,jdbcType=VARCHAR}
       </foreach>
       ,LINKMANTEL=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.linkmantel,jdbcType=VARCHAR}
       </foreach>
       ,MEDIUMSYSTEM=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.mediumsystem,jdbcType=VARCHAR}
       </foreach>
       ,NOTE=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.note,jdbcType=VARCHAR}
       </foreach>
       ,OPERATESTATUS=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.operatestatus,jdbcType=VARCHAR}
       </foreach>
       ,RESTARTTIME=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.restarttime,jdbcType=VARCHAR}
       </foreach>
       ,SAFETYPRECAUTIONS=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.safetyprecautions,jdbcType=VARCHAR}
       </foreach>
       ,SIGNMAN=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.signman,jdbcType=VARCHAR}
       </foreach>
       ,SIGNTIME=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.signtime,jdbcType=VARCHAR}
       </foreach>
       ,STOPTIME=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.stoptime,jdbcType=VARCHAR}
       </foreach>
       ,STRUCTUREDIAGRAM=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.structurediagram,jdbcType=VARCHAR}
       </foreach>
       ,TASKSTATUS=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.taskstatus,jdbcType=VARCHAR}
       </foreach>
       ,TIMEOVER=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.timeover,jdbcType=VARCHAR}
       </foreach>
       ,TIMESTART=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.timestart,jdbcType=VARCHAR}
       </foreach>
       ,WORKCONTENT=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.workcontent,jdbcType=VARCHAR}
       </foreach>
     where BILLSNO in 
     <foreach close=")" collection="list" index="index" item="item" open="(" separator=",">
    #{item.billsno,jdbcType=VARCHAR}
     </foreach> 
  </update>
  <delete id="batchDelete" parameterType="java.util.List">
    delete from T_CM_036
    where BILLSNO in 
    <foreach close=")" collection="list" item="id" open="(" separator=",">
      #{id}
    </foreach>
  </delete>
  <resultMap id="BaseResultMap" type="com.steerinfo.ems.tcm036.model.TCm036">
    <id column="BILLSNO" jdbcType="VARCHAR" property="billsno" />
    <result column="RECORDID" jdbcType="VARCHAR" property="recordid" />
    <result column="ADDRESS" jdbcType="VARCHAR" property="address" />
    <result column="APPLYCHARGEMAN" jdbcType="VARCHAR" property="applychargeman" />
    <result column="APPLYMAN" jdbcType="VARCHAR" property="applyman" />
    <result column="APPLYUNIT" jdbcType="VARCHAR" property="applyunit" />
    <result column="ATTENTION" jdbcType="VARCHAR" property="attention" />
    <result column="BILLSTATUS" jdbcType="VARCHAR" property="billstatus" />
    <result column="CHARGEMANTEL" jdbcType="VARCHAR" property="chargemantel" />
    <result column="CONTENTCHANGE" jdbcType="VARCHAR" property="contentchange" />
    <result column="CREATTIME" jdbcType="VARCHAR" property="creattime" />
    <result column="EQUIPMENTNAME" jdbcType="VARCHAR" property="equipmentname" />
    <result column="EXECUTIVECHARGEMAN" jdbcType="VARCHAR" property="executivechargeman" />
    <result column="EXECUTIVESITUATION" jdbcType="VARCHAR" property="executivesituation" />
    <result column="EXECUTIVETIME" jdbcType="VARCHAR" property="executivetime" />
    <result column="LINKMANTEL" jdbcType="VARCHAR" property="linkmantel" />
    <result column="MEDIUMSYSTEM" jdbcType="VARCHAR" property="mediumsystem" />
    <result column="NOTE" jdbcType="VARCHAR" property="note" />
    <result column="OPERATESTATUS" jdbcType="VARCHAR" property="operatestatus" />
    <result column="RESTARTTIME" jdbcType="VARCHAR" property="restarttime" />
    <result column="SAFETYPRECAUTIONS" jdbcType="VARCHAR" property="safetyprecautions" />
    <result column="SIGNMAN" jdbcType="VARCHAR" property="signman" />
    <result column="SIGNTIME" jdbcType="VARCHAR" property="signtime" />
    <result column="STOPTIME" jdbcType="VARCHAR" property="stoptime" />
    <result column="STRUCTUREDIAGRAM" jdbcType="VARCHAR" property="structurediagram" />
    <result column="TASKSTATUS" jdbcType="VARCHAR" property="taskstatus" />
    <result column="TIMEOVER" jdbcType="VARCHAR" property="timeover" />
    <result column="TIMESTART" jdbcType="VARCHAR" property="timestart" />
    <result column="WORKCONTENT" jdbcType="VARCHAR" property="workcontent" />
  </resultMap>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.String">
    delete from T_CM_036
    where BILLSNO = #{billsno,jdbcType=VARCHAR}
  </delete>
  <delete id="deleteBySelectiveElement" parameterType="java.util.HashMap">
    delete from T_CM_036
    where 1!=1 
      <if test="recordid != null">
        and RECORDID = #{recordid}
      </if>
      <if test="address != null and address != ''">
        and ADDRESS = #{address}
      </if>
      <if test="applychargeman != null and applychargeman != ''">
        and APPLYCHARGEMAN = #{applychargeman}
      </if>
      <if test="applyman != null and applyman != ''">
        and APPLYMAN = #{applyman}
      </if>
      <if test="applyunit != null and applyunit != ''">
        and APPLYUNIT = #{applyunit}
      </if>
      <if test="attention != null and attention != ''">
        and ATTENTION = #{attention}
      </if>
      <if test="billstatus != null and billstatus != ''">
        and BILLSTATUS = #{billstatus}
      </if>
      <if test="chargemantel != null and chargemantel != ''">
        and CHARGEMANTEL = #{chargemantel}
      </if>
      <if test="contentchange != null and contentchange != ''">
        and CONTENTCHANGE = #{contentchange}
      </if>
      <if test="creattime != null and creattime != ''">
        and CREATTIME = #{creattime}
      </if>
      <if test="equipmentname != null and equipmentname != ''">
        and EQUIPMENTNAME = #{equipmentname}
      </if>
      <if test="executivechargeman != null and executivechargeman != ''">
        and EXECUTIVECHARGEMAN = #{executivechargeman}
      </if>
      <if test="executivesituation != null and executivesituation != ''">
        and EXECUTIVESITUATION = #{executivesituation}
      </if>
      <if test="executivetime != null and executivetime != ''">
        and EXECUTIVETIME = #{executivetime}
      </if>
      <if test="linkmantel != null and linkmantel != ''">
        and LINKMANTEL = #{linkmantel}
      </if>
      <if test="mediumsystem != null and mediumsystem != ''">
        and MEDIUMSYSTEM = #{mediumsystem}
      </if>
      <if test="note != null and note != ''">
        and NOTE = #{note}
      </if>
      <if test="operatestatus != null and operatestatus != ''">
        and OPERATESTATUS = #{operatestatus}
      </if>
      <if test="restarttime != null and restarttime != ''">
        and RESTARTTIME = #{restarttime}
      </if>
      <if test="safetyprecautions != null and safetyprecautions != ''">
        and SAFETYPRECAUTIONS = #{safetyprecautions}
      </if>
      <if test="signman != null and signman != ''">
        and SIGNMAN = #{signman}
      </if>
      <if test="signtime != null and signtime != ''">
        and SIGNTIME = #{signtime}
      </if>
      <if test="stoptime != null and stoptime != ''">
        and STOPTIME = #{stoptime}
      </if>
      <if test="structurediagram != null and structurediagram != ''">
        and STRUCTUREDIAGRAM = #{structurediagram}
      </if>
      <if test="taskstatus != null and taskstatus != ''">
        and TASKSTATUS = #{taskstatus}
      </if>
      <if test="timeover != null and timeover != ''">
        and TIMEOVER = #{timeover}
      </if>
      <if test="timestart != null and timestart != ''">
        and TIMESTART = #{timestart}
      </if>
      <if test="workcontent != null and workcontent != ''">
        and WORKCONTENT = #{workcontent}
      </if>
  </delete>
  <insert id="insert" parameterType="com.steerinfo.ems.tcm036.model.TCm036">
    insert into T_CM_036 (BILLSNO, RECORDID, ADDRESS, 
      APPLYCHARGEMAN, APPLYMAN, APPLYUNIT, 
      ATTENTION, BILLSTATUS, CHARGEMANTEL, 
      CONTENTCHANGE, CREATTIME, EQUIPMENTNAME, 
      EXECUTIVECHARGEMAN, EXECUTIVESITUATION, 
      EXECUTIVETIME, LINKMANTEL, MEDIUMSYSTEM, 
      NOTE, OPERATESTATUS, RESTARTTIME, 
      SAFETYPRECAUTIONS, SIGNMAN, SIGNTIME, 
      STOPTIME, STRUCTUREDIAGRAM, TASKSTATUS, 
      TIMEOVER, TIMESTART, WORKCONTENT
      )
    values (#{billsno,jdbcType=VARCHAR}, #{recordid,jdbcType=VARCHAR}, #{address,jdbcType=VARCHAR},
      #{applychargeman,jdbcType=VARCHAR}, #{applyman,jdbcType=VARCHAR}, #{applyunit,jdbcType=VARCHAR}, 
      #{attention,jdbcType=VARCHAR}, #{billstatus,jdbcType=VARCHAR}, #{chargemantel,jdbcType=VARCHAR}, 
      #{contentchange,jdbcType=VARCHAR}, #{creattime,jdbcType=VARCHAR}, #{equipmentname,jdbcType=VARCHAR}, 
      #{executivechargeman,jdbcType=VARCHAR}, #{executivesituation,jdbcType=VARCHAR}, 
      #{executivetime,jdbcType=VARCHAR}, #{linkmantel,jdbcType=VARCHAR}, #{mediumsystem,jdbcType=VARCHAR}, 
      #{note,jdbcType=VARCHAR}, #{operatestatus,jdbcType=VARCHAR}, #{restarttime,jdbcType=VARCHAR}, 
      #{safetyprecautions,jdbcType=VARCHAR}, #{signman,jdbcType=VARCHAR}, #{signtime,jdbcType=VARCHAR}, 
      #{stoptime,jdbcType=VARCHAR}, #{structurediagram,jdbcType=VARCHAR}, #{taskstatus,jdbcType=VARCHAR}, 
      #{timeover,jdbcType=VARCHAR}, #{timestart,jdbcType=VARCHAR}, #{workcontent,jdbcType=VARCHAR}
      )
  </insert>
  <insert id="insertSelective" parameterType="com.steerinfo.ems.tcm036.model.TCm036">
    insert into T_CM_036
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="billsno != null">
        BILLSNO,
      </if>
      <if test="recordid != null">
        RECORDID,
      </if>
      <if test="address != null">
        ADDRESS,
      </if>
      <if test="applychargeman != null">
        APPLYCHARGEMAN,
      </if>
      <if test="applyman != null">
        APPLYMAN,
      </if>
      <if test="applyunit != null">
        APPLYUNIT,
      </if>
      <if test="attention != null">
        ATTENTION,
      </if>
      <if test="billstatus != null">
        BILLSTATUS,
      </if>
      <if test="chargemantel != null">
        CHARGEMANTEL,
      </if>
      <if test="contentchange != null">
        CONTENTCHANGE,
      </if>
      <if test="creattime != null">
        CREATTIME,
      </if>
      <if test="equipmentname != null">
        EQUIPMENTNAME,
      </if>
      <if test="executivechargeman != null">
        EXECUTIVECHARGEMAN,
      </if>
      <if test="executivesituation != null">
        EXECUTIVESITUATION,
      </if>
      <if test="executivetime != null">
        EXECUTIVETIME,
      </if>
      <if test="linkmantel != null">
        LINKMANTEL,
      </if>
      <if test="mediumsystem != null">
        MEDIUMSYSTEM,
      </if>
      <if test="note != null">
        NOTE,
      </if>
      <if test="operatestatus != null">
        OPERATESTATUS,
      </if>
      <if test="restarttime != null">
        RESTARTTIME,
      </if>
      <if test="safetyprecautions != null">
        SAFETYPRECAUTIONS,
      </if>
      <if test="signman != null">
        SIGNMAN,
      </if>
      <if test="signtime != null">
        SIGNTIME,
      </if>
      <if test="stoptime != null">
        STOPTIME,
      </if>
      <if test="structurediagram != null">
        STRUCTUREDIAGRAM,
      </if>
      <if test="taskstatus != null">
        TASKSTATUS,
      </if>
      <if test="timeover != null">
        TIMEOVER,
      </if>
      <if test="timestart != null">
        TIMESTART,
      </if>
      <if test="workcontent != null">
        WORKCONTENT,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="billsno != null">
        #{billsno,jdbcType=VARCHAR},
      </if>
      <if test="recordid != null">
        #{recordid,jdbcType=VARCHAR},
      </if>
      <if test="address != null">
        #{address,jdbcType=VARCHAR},
      </if>
      <if test="applychargeman != null">
        #{applychargeman,jdbcType=VARCHAR},
      </if>
      <if test="applyman != null">
        #{applyman,jdbcType=VARCHAR},
      </if>
      <if test="applyunit != null">
        #{applyunit,jdbcType=VARCHAR},
      </if>
      <if test="attention != null">
        #{attention,jdbcType=VARCHAR},
      </if>
      <if test="billstatus != null">
        #{billstatus,jdbcType=VARCHAR},
      </if>
      <if test="chargemantel != null">
        #{chargemantel,jdbcType=VARCHAR},
      </if>
      <if test="contentchange != null">
        #{contentchange,jdbcType=VARCHAR},
      </if>
      <if test="creattime != null">
        #{creattime,jdbcType=VARCHAR},
      </if>
      <if test="equipmentname != null">
        #{equipmentname,jdbcType=VARCHAR},
      </if>
      <if test="executivechargeman != null">
        #{executivechargeman,jdbcType=VARCHAR},
      </if>
      <if test="executivesituation != null">
        #{executivesituation,jdbcType=VARCHAR},
      </if>
      <if test="executivetime != null">
        #{executivetime,jdbcType=VARCHAR},
      </if>
      <if test="linkmantel != null">
        #{linkmantel,jdbcType=VARCHAR},
      </if>
      <if test="mediumsystem != null">
        #{mediumsystem,jdbcType=VARCHAR},
      </if>
      <if test="note != null">
        #{note,jdbcType=VARCHAR},
      </if>
      <if test="operatestatus != null">
        #{operatestatus,jdbcType=VARCHAR},
      </if>
      <if test="restarttime != null">
        #{restarttime,jdbcType=VARCHAR},
      </if>
      <if test="safetyprecautions != null">
        #{safetyprecautions,jdbcType=VARCHAR},
      </if>
      <if test="signman != null">
        #{signman,jdbcType=VARCHAR},
      </if>
      <if test="signtime != null">
        #{signtime,jdbcType=VARCHAR},
      </if>
      <if test="stoptime != null">
        #{stoptime,jdbcType=VARCHAR},
      </if>
      <if test="structurediagram != null">
        #{structurediagram,jdbcType=VARCHAR},
      </if>
      <if test="taskstatus != null">
        #{taskstatus,jdbcType=VARCHAR},
      </if>
      <if test="timeover != null">
        #{timeover,jdbcType=VARCHAR},
      </if>
      <if test="timestart != null">
        #{timestart,jdbcType=VARCHAR},
      </if>
      <if test="workcontent != null">
        #{workcontent,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKey" parameterType="com.steerinfo.ems.tcm036.model.TCm036">
    update T_CM_036
    set RECORDID = #{recordid,jdbcType=VARCHAR},
      ADDRESS = #{address,jdbcType=VARCHAR},
      APPLYCHARGEMAN = #{applychargeman,jdbcType=VARCHAR},
      APPLYMAN = #{applyman,jdbcType=VARCHAR},
      APPLYUNIT = #{applyunit,jdbcType=VARCHAR},
      ATTENTION = #{attention,jdbcType=VARCHAR},
      BILLSTATUS = #{billstatus,jdbcType=VARCHAR},
      CHARGEMANTEL = #{chargemantel,jdbcType=VARCHAR},
      CONTENTCHANGE = #{contentchange,jdbcType=VARCHAR},
      CREATTIME = #{creattime,jdbcType=VARCHAR},
      EQUIPMENTNAME = #{equipmentname,jdbcType=VARCHAR},
      EXECUTIVECHARGEMAN = #{executivechargeman,jdbcType=VARCHAR},
      EXECUTIVESITUATION = #{executivesituation,jdbcType=VARCHAR},
      EXECUTIVETIME = #{executivetime,jdbcType=VARCHAR},
      LINKMANTEL = #{linkmantel,jdbcType=VARCHAR},
      MEDIUMSYSTEM = #{mediumsystem,jdbcType=VARCHAR},
      NOTE = #{note,jdbcType=VARCHAR},
      OPERATESTATUS = #{operatestatus,jdbcType=VARCHAR},
      RESTARTTIME = #{restarttime,jdbcType=VARCHAR},
      SAFETYPRECAUTIONS = #{safetyprecautions,jdbcType=VARCHAR},
      SIGNMAN = #{signman,jdbcType=VARCHAR},
      SIGNTIME = #{signtime,jdbcType=VARCHAR},
      STOPTIME = #{stoptime,jdbcType=VARCHAR},
      STRUCTUREDIAGRAM = #{structurediagram,jdbcType=VARCHAR},
      TASKSTATUS = #{taskstatus,jdbcType=VARCHAR},
      TIMEOVER = #{timeover,jdbcType=VARCHAR},
      TIMESTART = #{timestart,jdbcType=VARCHAR},
      WORKCONTENT = #{workcontent,jdbcType=VARCHAR}
    where BILLSNO = #{billsno,jdbcType=VARCHAR}
  </update>
  <select id="selectLikeByParameters" parameterType="java.util.HashMap" resultMap="BaseResultMap">
    select BILLSNO, RECORDID, ADDRESS, APPLYCHARGEMAN, APPLYMAN, APPLYUNIT, ATTENTION, 
    BILLSTATUS, CHARGEMANTEL, CONTENTCHANGE, CREATTIME, EQUIPMENTNAME, EXECUTIVECHARGEMAN, 
    EXECUTIVESITUATION, EXECUTIVETIME, LINKMANTEL, MEDIUMSYSTEM, NOTE, OPERATESTATUS, 
    RESTARTTIME, SAFETYPRECAUTIONS, SIGNMAN, SIGNTIME, STOPTIME, STRUCTUREDIAGRAM, TASKSTATUS, 
    TIMEOVER, TIMESTART, WORKCONTENT
    from T_CM_036
    <where> 
      <if test="recordid != null">
        and RECORDID = #{recordid}
      </if>
      <if test="address != null and address != ''">
        and ADDRESS LIKE '%${address}%'
      </if>
      <if test="applychargeman != null and applychargeman != ''">
        and APPLYCHARGEMAN LIKE '%${applychargeman}%'
      </if>
      <if test="applyman != null and applyman != ''">
        and APPLYMAN LIKE '%${applyman}%'
      </if>
      <if test="applyunit != null and applyunit != ''">
        and APPLYUNIT LIKE '%${applyunit}%'
      </if>
      <if test="attention != null and attention != ''">
        and ATTENTION LIKE '%${attention}%'
      </if>
      <if test="billstatus != null and billstatus != ''">
        and BILLSTATUS LIKE '%${billstatus}%'
      </if>
      <if test="chargemantel != null and chargemantel != ''">
        and CHARGEMANTEL LIKE '%${chargemantel}%'
      </if>
      <if test="contentchange != null and contentchange != ''">
        and CONTENTCHANGE LIKE '%${contentchange}%'
      </if>
      <if test="creattime != null and creattime != ''">
        and CREATTIME LIKE '%${creattime}%'
      </if>
      <if test="equipmentname != null and equipmentname != ''">
        and EQUIPMENTNAME LIKE '%${equipmentname}%'
      </if>
      <if test="executivechargeman != null and executivechargeman != ''">
        and EXECUTIVECHARGEMAN LIKE '%${executivechargeman}%'
      </if>
      <if test="executivesituation != null and executivesituation != ''">
        and EXECUTIVESITUATION LIKE '%${executivesituation}%'
      </if>
      <if test="executivetime != null and executivetime != ''">
        and EXECUTIVETIME LIKE '%${executivetime}%'
      </if>
      <if test="linkmantel != null and linkmantel != ''">
        and LINKMANTEL LIKE '%${linkmantel}%'
      </if>
      <if test="mediumsystem != null and mediumsystem != ''">
        and MEDIUMSYSTEM LIKE '%${mediumsystem}%'
      </if>
      <if test="note != null and note != ''">
        and NOTE LIKE '%${note}%'
      </if>
      <if test="operatestatus != null and operatestatus != ''">
        and OPERATESTATUS LIKE '%${operatestatus}%'
      </if>
      <if test="restarttime != null and restarttime != ''">
        and RESTARTTIME LIKE '%${restarttime}%'
      </if>
      <if test="safetyprecautions != null and safetyprecautions != ''">
        and SAFETYPRECAUTIONS LIKE '%${safetyprecautions}%'
      </if>
      <if test="signman != null and signman != ''">
        and SIGNMAN LIKE '%${signman}%'
      </if>
      <if test="signtime != null and signtime != ''">
        and SIGNTIME LIKE '%${signtime}%'
      </if>
      <if test="stoptime != null and stoptime != ''">
        and STOPTIME LIKE '%${stoptime}%'
      </if>
      <if test="structurediagram != null and structurediagram != ''">
        and STRUCTUREDIAGRAM LIKE '%${structurediagram}%'
      </if>
      <if test="taskstatus != null and taskstatus != ''">
        and TASKSTATUS LIKE '%${taskstatus}%'
      </if>
      <if test="timeover != null and timeover != ''">
        and TIMEOVER LIKE '%${timeover}%'
      </if>
      <if test="timestart != null and timestart != ''">
        and TIMESTART LIKE '%${timestart}%'
      </if>
      <if test="workcontent != null and workcontent != ''">
        and WORKCONTENT LIKE '%${workcontent}%'
      </if>
    </where>
  </select>
  <insert id="batchInsert" parameterType="java.util.List">
    insert into T_CM_036 
      (BILLSNO, 
      RECORDID, ADDRESS, APPLYCHARGEMAN, 
      APPLYMAN, APPLYUNIT, ATTENTION, 
      BILLSTATUS, CHARGEMANTEL, CONTENTCHANGE, 
      CREATTIME, EQUIPMENTNAME, EXECUTIVECHARGEMAN, 
      EXECUTIVESITUATION, EXECUTIVETIME, 
      LINKMANTEL, MEDIUMSYSTEM, NOTE, 
      OPERATESTATUS, RESTARTTIME, SAFETYPRECAUTIONS, 
      SIGNMAN, SIGNTIME, STOPTIME, 
      STRUCTUREDIAGRAM, TASKSTATUS, 
      TIMEOVER, TIMESTART, WORKCONTENT
      )
    ( <foreach collection="list" item="item" separator="union all"> 
   select  
      #{item.billsno,jdbcType=VARCHAR}, 
      #{item.recordid,jdbcType=VARCHAR}, #{item.address,jdbcType=VARCHAR}, #{item.applychargeman,jdbcType=VARCHAR},
      #{item.applyman,jdbcType=VARCHAR}, #{item.applyunit,jdbcType=VARCHAR}, #{item.attention,jdbcType=VARCHAR}, 
      #{item.billstatus,jdbcType=VARCHAR}, #{item.chargemantel,jdbcType=VARCHAR}, #{item.contentchange,jdbcType=VARCHAR}, 
      #{item.creattime,jdbcType=VARCHAR}, #{item.equipmentname,jdbcType=VARCHAR}, #{item.executivechargeman,jdbcType=VARCHAR}, 
      #{item.executivesituation,jdbcType=VARCHAR}, #{item.executivetime,jdbcType=VARCHAR}, 
      #{item.linkmantel,jdbcType=VARCHAR}, #{item.mediumsystem,jdbcType=VARCHAR}, #{item.note,jdbcType=VARCHAR}, 
      #{item.operatestatus,jdbcType=VARCHAR}, #{item.restarttime,jdbcType=VARCHAR}, #{item.safetyprecautions,jdbcType=VARCHAR}, 
      #{item.signman,jdbcType=VARCHAR}, #{item.signtime,jdbcType=VARCHAR}, #{item.stoptime,jdbcType=VARCHAR}, 
      #{item.structurediagram,jdbcType=VARCHAR}, #{item.taskstatus,jdbcType=VARCHAR}, 
      #{item.timeover,jdbcType=VARCHAR}, #{item.timestart,jdbcType=VARCHAR}, #{item.workcontent,jdbcType=VARCHAR}
       from dual  
   </foreach> )
  </insert>
  <update id="batchUpdate" parameterType="java.util.List">
     update T_CM_036
     set
       BILLSNO=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.billsno,jdbcType=VARCHAR}
       </foreach>
       ,RECORDID=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.recordid,jdbcType=VARCHAR}
       </foreach>
       ,ADDRESS=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.address,jdbcType=VARCHAR}
       </foreach>
       ,APPLYCHARGEMAN=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.applychargeman,jdbcType=VARCHAR}
       </foreach>
       ,APPLYMAN=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.applyman,jdbcType=VARCHAR}
       </foreach>
       ,APPLYUNIT=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.applyunit,jdbcType=VARCHAR}
       </foreach>
       ,ATTENTION=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.attention,jdbcType=VARCHAR}
       </foreach>
       ,BILLSTATUS=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.billstatus,jdbcType=VARCHAR}
       </foreach>
       ,CHARGEMANTEL=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.chargemantel,jdbcType=VARCHAR}
       </foreach>
       ,CONTENTCHANGE=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.contentchange,jdbcType=VARCHAR}
       </foreach>
       ,CREATTIME=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.creattime,jdbcType=VARCHAR}
       </foreach>
       ,EQUIPMENTNAME=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.equipmentname,jdbcType=VARCHAR}
       </foreach>
       ,EXECUTIVECHARGEMAN=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.executivechargeman,jdbcType=VARCHAR}
       </foreach>
       ,EXECUTIVESITUATION=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.executivesituation,jdbcType=VARCHAR}
       </foreach>
       ,EXECUTIVETIME=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.executivetime,jdbcType=VARCHAR}
       </foreach>
       ,LINKMANTEL=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.linkmantel,jdbcType=VARCHAR}
       </foreach>
       ,MEDIUMSYSTEM=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.mediumsystem,jdbcType=VARCHAR}
       </foreach>
       ,NOTE=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.note,jdbcType=VARCHAR}
       </foreach>
       ,OPERATESTATUS=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.operatestatus,jdbcType=VARCHAR}
       </foreach>
       ,RESTARTTIME=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.restarttime,jdbcType=VARCHAR}
       </foreach>
       ,SAFETYPRECAUTIONS=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.safetyprecautions,jdbcType=VARCHAR}
       </foreach>
       ,SIGNMAN=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.signman,jdbcType=VARCHAR}
       </foreach>
       ,SIGNTIME=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.signtime,jdbcType=VARCHAR}
       </foreach>
       ,STOPTIME=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.stoptime,jdbcType=VARCHAR}
       </foreach>
       ,STRUCTUREDIAGRAM=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.structurediagram,jdbcType=VARCHAR}
       </foreach>
       ,TASKSTATUS=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.taskstatus,jdbcType=VARCHAR}
       </foreach>
       ,TIMEOVER=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.timeover,jdbcType=VARCHAR}
       </foreach>
       ,TIMESTART=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.timestart,jdbcType=VARCHAR}
       </foreach>
       ,WORKCONTENT=
       <foreach close="end" collection="list" index="index" item="item" open="case BILLSNO" separator=" ">
          when #{item.billsno,jdbcType=VARCHAR} then #{item.workcontent,jdbcType=VARCHAR}
       </foreach>
     where BILLSNO in 
     <foreach close=")" collection="list" index="index" item="item" open="(" separator=",">
    #{item.billsno,jdbcType=VARCHAR}
     </foreach> 
  </update>
  -->
</mapper>