<?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.eport.rest.dao.EptBookDao">
    
	<sql id="EptBookEntityColumns">
		a1.ID AS "id"
		,a1.COP_EMS_NO AS "copEmsNo"
		,a1.BOOK_NO AS "bookNo"
		,a1.CONT_CUSTOM AS "contCustom"
		,a1.BOOK_TYPE AS "bookType"
		,a1.RECEIPT_ADDRESS AS "receiptAddress"
		,a1.BUSI_UNIT_CODE AS "busiUnitCode"
		,a1.BUSI_UNIT_NAME AS "busiUnitName"
		,a1.MACH_UNIT_CODE AS "machUnitCode"
		,a1.MACH_UNIT_NAME AS "machUnitName"
		,a1.COMPANY_NAME AS "companyName"
		,a1.COMPANY_MANAGER AS "companyManager"
		,a1.TRADE_MODE AS "tradeMode"
		,a1.MASTER_FTC AS "masterFtc"
		,a1.MASTER_CUSTOMS AS "masterCustoms"
		,a1.DUTY_MODE AS "dutyMode"
		,a1.LAND_PLACE AS "landPlace"
		,a1.DEAL_CODE AS "dealCode"
		,a1.IN_SALE_RATE AS "inSaleRate"
		,a1.PROTOCOL_NO AS "protocolNo"
		,a1.LICENSE_KEY AS "licenseKey"
		,a1.APPROVAL_NO AS "approvalNo"
		,a1.IN_CONTRACT_NO AS "inContractNo"
		,a1.BAK_IN_PRICE AS "bakInPrice"
		,a1.OBJ_IN_NO AS "objInNo"
		,a1.OUT_CONTRACT_NO AS "outContractNo"
		,a1.BAK_OUT_PRICE AS "bakOutPrice"
		,a1.OBJ_OUT_NO AS "objOutNo"
		,a1.PROCESS_TYPE AS "processType"
		,a1.BOND_TYPE AS "bondType"
		,a1.MANAGER_OBJ AS "managerObj"
		,a1.INPUT_TIME AS "inputTime"
		,a1.DECLA_TIME AS "declaTime"
		,a1.DECLARE_DATE AS "declareDate"
		,a1.EFFECT_TIME AS "effectTime"
		,a1.IN_OUT_PORT AS "inOutPort"
		,a1.CURRENT_IN_PRICE AS "currentInPrice"
		,a1.CURRENT_OUT_PRICE AS "currentOutPrice"
		,a1.DUE_FLAG AS "dueFlag"
		,a1.TRADES_CODE AS "tradesCode"
		,a1.DISTRICT_CODE AS "districtCode"
		,a1.CONTR_NO AS "contrNo"
		,a1.NOTE AS "note"
		,a1.INPUTER AS "inputer"
		,a1.IS_DELETE AS "isDelete"
		,a1.CREATE_ID AS "createId"
		,a1.CREATE_PERSON AS "createPerson"
		,a1.CREATE_DATE AS "createDate"
		,a1.UPDATE_ID AS "updateId"
		,a1.UPDATE_DATE AS "updateDate"
		,a1.SEQ_NO AS "seqNo"
		,a1.PLAT_NO2 AS "platNo2"
		,a1.PLAT_NO AS "platNo"
		,a1.CUSTOMS AS "customs"
		,a1.MOD_NUM AS "modNum"
		,a1.ECI_EMS_NO AS "eciEmsNo"
		,a1.OWNER_CODE AS "ownerCode"
		,a1.OWNER_NAME AS "ownerName"
		,a1.DECLARE_CODE AS "declareCode"
		,a1.DECLARE_NAME AS "declareName"
		,a1.INVEST_MODE AS "investMode"
		,a1.EMS_APPR_NO AS "emsApprNo"
		,a1.I_E_PORT AS "iEPort"
		,a1.PAY_MODE AS "payMode"
		,a1.MODIFY_MARK AS "modifyMark"
		,a1.ECI_EMS_PROPERTY AS "eciEmsProperty"
		,a1.ECI_EMS_LEVEL AS "eciEmsLevel"
		,a1.DECLARE_PERSON AS "declarePerson"
		,a1.APPROVE_PERSON AS "approvePerson"
		,a1.APPROVE_DATE AS "approveDate"
		,a1.OUTER_COMMENT AS "outerComment"
		,a1.INNER_COMMENT AS "innerComment"
		,a1.STEP_ID AS "stepId"
		,a1.STATUS AS "status"
		,a1.AREA_CODE AS "areaCode"
		,a1.CUSTOMS_CODE AS "customsCode"
		,a1.BATCH_NO AS "batchNo"
		,a1.BATCH_FLAG AS "batchFlag"
		,a1.EMS_NO AS "emsNo"
	</sql>
	
	<sql id="EptBookEntityListColumns">
		a1.ID AS "id"
		,a1.COP_EMS_NO AS "copEmsNo"
		,a1.BOOK_NO AS "bookNo"
		,a1.CONT_CUSTOM AS "contCustom"
		,a1.BUSI_UNIT_NAME AS "busiUnitName"
		,a1.EFFECT_TIME AS "effectTime"
	</sql>
	
	
	
		<!--查询表中所有资料(所有字段) -->
		<select id="listAll"  
		parameterType="HashMap" 
		resultType="com.eport.rest.entity.EptBookEntity"
		>
		select  
			<include refid="EptBookEntityColumns"/>
			,(select DISTRICT_NAME from district_rel  c1 where c1.DISTRICT_CODE = a1.DISTRICT_CODE) as districtName
			,(select CODE_NAME from ept_sup_code  c1 where c1.CODE = a1.TRADE_MODE) as tradeModeName
			,(select DUTY_SPEC from levymode  c1 where c1.DUTY_MODE = a1.DUTY_MODE) as dutyModeName
			,(select CODE_NAME from ept_deal_code  c1 where c1.CODE = a1.DEAL_CODE) as dealCodeName
			,(select CUSTOMS_NAME from customs_rel  c1 where c1.CUSTOMS_CODE = a1.IN_OUT_PORT) as inOutPortName
			,(select INVEST_MODE_NAME from invest_mode  c1 where c1.INVEST_MODE_CODE = a1.INVEST_MODE) as investModeName
			,(select PAY_MODE_NAME from pay_mode  c1 where c1.PAY_MODE_CODE = a1.PAY_MODE) as payModeName
			,(select EMS_NAME from ems_type c1 where c1.EMS_CODE = a1.BOOK_TYPE) as emsTypeName
			,(select CUSTOMS_NAME from customs_rel c1 where c1.CUSTOMS_CODE = a1.customs) as customsName
		FROM ept_book  a1
		WHERE 1=1
		<if test="copEmsNo != null">
		and COP_EMS_NO like CONCAT(CONCAT('%',#{copEmsNo}),'%')
		</if>
		<if test="bookNo != null">
		and BOOK_NO like CONCAT(CONCAT('%',#{bookNo}),'%')
		</if>
		<if test="effectTime_start != null and effectTime_start!=''">
		and EFFECT_TIME &gt;=#{effectTime_start}
		</if>
		<if test="effectTime_end != null and effectTime_end!=''">
		and EFFECT_TIME &lt;=#{effectTime_end}
		</if>
		<if test="contCustom != null">
		and CONT_CUSTOM like CONCAT(CONCAT('%',#{contCustom}),'%')
		</if>
		 and IS_DELETE = 0
		</select>
		
	
		<!--分页查询资料(所有字段) -->
		<select id="pageAll"  
		parameterType="HashMap" 
		resultType="com.eport.rest.entity.EptBookEntity"
		>
		select  
			<include refid="EptBookEntityColumns"/>
			,(select DISTRICT_NAME from district_rel  c1 where c1.DISTRICT_CODE = a1.DISTRICT_CODE) as districtName
			,(select CODE_NAME from ept_sup_code  c1 where c1.CODE = a1.TRADE_MODE) as tradeModeName
			,(select DUTY_SPEC from levymode  c1 where c1.DUTY_MODE = a1.DUTY_MODE) as dutyModeName
			,(select CODE_NAME from ept_deal_code  c1 where c1.CODE = a1.DEAL_CODE) as dealCodeName
			,(select CUSTOMS_NAME from customs_rel  c1 where c1.CUSTOMS_CODE = a1.IN_OUT_PORT) as inOutPortName
			,(select INVEST_MODE_NAME from invest_mode  c1 where c1.INVEST_MODE_CODE = a1.INVEST_MODE) as investModeName
			,(select PAY_MODE_NAME from pay_mode  c1 where c1.PAY_MODE_CODE = a1.PAY_MODE) as payModeName
			,(select EMS_NAME from ems_type c1 where c1.EMS_CODE = a1.BOOK_TYPE) as emsTypeName
			,(select CUSTOMS_NAME from customs_rel c1 where c1.CUSTOMS_CODE = a1.customs) as customsName
		FROM ept_book  a1
		WHERE 1=1
		<if test="copEmsNo != null">
		and COP_EMS_NO like CONCAT(CONCAT('%',#{copEmsNo}),'%')
		</if>
		<if test="bookNo != null">
		and BOOK_NO like CONCAT(CONCAT('%',#{bookNo}),'%')
		</if>
		<if test="effectTime_start != null and effectTime_start!=''">
		and EFFECT_TIME &gt;=#{effectTime_start}
		</if>
		<if test="effectTime_end != null and effectTime_end!=''">
		and EFFECT_TIME &lt;=#{effectTime_end}
		</if>
		<if test="contCustom != null">
		and CONT_CUSTOM like CONCAT(CONCAT('%',#{contCustom}),'%')
		</if>
		 and IS_DELETE = 0
		</select>
		
	
		<!--查询表中所有资料(仅列表显示字段) -->
		<select id="list"  
		parameterType="HashMap" 
		resultType="com.eport.rest.entity.EptBookEntity"
		>
		select  
			<include refid="EptBookEntityListColumns"/>
		FROM ept_book  a1
		WHERE 1=1
		<if test="copEmsNo != null">
		and COP_EMS_NO like CONCAT(CONCAT('%',#{copEmsNo}),'%')
		</if>
		<if test="bookNo != null">
		and BOOK_NO like CONCAT(CONCAT('%',#{bookNo}),'%')
		</if>
		<if test="effectTime_start != null and effectTime_start!=''">
		and EFFECT_TIME &gt;=#{effectTime_start}
		</if>
		<if test="effectTime_end != null and effectTime_end!=''">
		and EFFECT_TIME &lt;=#{effectTime_end}
		</if>
		<if test="contCustom != null">
		and CONT_CUSTOM like CONCAT(CONCAT('%',#{contCustom}),'%')
		</if>
		 and IS_DELETE = 0
		</select>
		
	
		<!--分页查询资料(仅列表显示字段) -->
		<select id="page"  
		parameterType="HashMap" 
		resultType="com.eport.rest.entity.EptBookEntity"
		>
		select  
			<include refid="EptBookEntityListColumns"/>
		FROM ept_book  a1
		WHERE 1=1
		<if test="copEmsNo != null">
		and COP_EMS_NO like CONCAT(CONCAT('%',#{copEmsNo}),'%')
		</if>
		<if test="eciEmsNo != null">
		and BOOK_NO like CONCAT(CONCAT('%',#{eciEmsNo}),'%')
		</if>
		<if test="effectTime_start != null and effectTime_start!=''">
		and EFFECT_TIME &gt;=#{effectTime_start}
		</if>
		<if test="effectTime_end != null and effectTime_end!=''">
		and EFFECT_TIME &lt;=#{effectTime_end}
		</if>
		<if test="contCustom != null">
		and CONT_CUSTOM like CONCAT(CONCAT('%',#{contCustom}),'%')
		</if>
		 and IS_DELETE = 0
		</select>
		
	
		<!--根据主键查询数据 -->
		<select id="findByPK"  
		parameterType="Integer" 
		resultType="com.eport.rest.entity.EptBookEntity"
		>
		select  
		<include refid="EptBookEntityColumns"/>
			
			,(select CODE_NAME from ept_sup_code  c1 where c1.CODE = a1.TRADE_MODE) as tradeModeName
			,(select DUTY_SPEC from levymode  c1 where c1.DUTY_MODE = a1.DUTY_MODE) as dutyModeName
			,(select CODE_NAME from ept_deal_code  c1 where c1.CODE = a1.DEAL_CODE) as dealCodeName
			,(select DISTRICT_NAME from district_rel  c1 where c1.DISTRICT_CODE = a1.DISTRICT_CODE) as districtName
			,(select CUSTOMS_NAME from customs_rel  c1 where c1.CUSTOMS_CODE = a1.I_E_PORT) as inOutPortName
			,(select CUSTOMS_NAME from customs_rel  c1 where c1.CUSTOMS_CODE = a1.I_E_PORT) as iEPortName
			,(select INVEST_MODE_NAME from invest_mode  c1 where c1.INVEST_MODE_CODE = a1.INVEST_MODE) as investModeName
			,(select PAY_MODE_NAME from pay_mode  c1 where c1.PAY_MODE_CODE = a1.PAY_MODE) as payModeName
			,(select EMS_NAME from ems_type c1 where c1.EMS_CODE = a1.BOOK_TYPE) as emsTypeName
			,(select CUSTOMS_NAME from customs_rel c1 where c1.CUSTOMS_CODE = a1.customs) as customsName
		FROM ept_book  a1
		WHERE a1.ID=#{par}
		 and IS_DELETE = 0
		</select>
		
		<!--根据主键查询数据 -->
		<select id="findBySeqNo"  
		parameterType="String" 
		resultType="com.eport.rest.entity.EptBookEntity"
		>
		select  
		<include refid="EptBookEntityColumns"/>
			,(select DISTRICT_NAME from district_rel  c1 where c1.DISTRICT_CODE = a1.DISTRICT_CODE) as districtName
			,(select CODE_NAME from ept_sup_code  c1 where c1.CODE = a1.TRADE_MODE) as tradeModeName
			,(select DUTY_SPEC from levymode  c1 where c1.DUTY_MODE = a1.DUTY_MODE) as dutyModeName
			,(select CODE_NAME from ept_deal_code  c1 where c1.CODE = a1.DEAL_CODE) as dealCodeName
			,(select CUSTOMS_NAME from customs_rel  c1 where c1.CUSTOMS_CODE = a1.IN_OUT_PORT) as inOutPortName
			,(select INVEST_MODE_NAME from invest_mode  c1 where c1.INVEST_MODE_CODE = a1.INVEST_MODE) as investModeName
			,(select PAY_MODE_NAME from pay_mode  c1 where c1.PAY_MODE_CODE = a1.PAY_MODE) as payModeName
			,(select EMS_NAME from ems_type c1 where c1.EMS_CODE = a1.BOOK_TYPE) as emsTypeName
			,(select CUSTOMS_NAME from customs_rel c1 where c1.CUSTOMS_CODE = a1.customs) as customsName
		FROM ept_book  a1
		WHERE a1.SEQ_NO=#{par}
		 and IS_DELETE = 0
		</select>
	
		<!--新增数据 -->
		<insert id="insert"  
		parameterType="com.eport.rest.entity.EptBookEntity" 
		>
		<selectKey resultType="Integer" order="AFTER" keyProperty="id">
		<if test="id != null ">
		select #{id} from dual
		</if>
		<if test="id == null ">
		SELECT LAST_INSERT_ID() AS id
		</if>
		 </selectKey>
		insert  
		  INTO ept_book (
		COP_EMS_NO
		,BOOK_NO
		,CONT_CUSTOM
		,BOOK_TYPE
		,RECEIPT_ADDRESS
		,BUSI_UNIT_CODE
		,BUSI_UNIT_NAME
		,MACH_UNIT_CODE
		,MACH_UNIT_NAME
		,COMPANY_NAME
		,COMPANY_MANAGER
		,TRADE_MODE
		,MASTER_FTC
		,MASTER_CUSTOMS
		,DUTY_MODE
		,LAND_PLACE
		,DEAL_CODE
		,IN_SALE_RATE
		,PROTOCOL_NO
		,LICENSE_KEY
		,APPROVAL_NO
		,IN_CONTRACT_NO
		,BAK_IN_PRICE
		,OBJ_IN_NO
		,OUT_CONTRACT_NO
		,BAK_OUT_PRICE
		,OBJ_OUT_NO
		,PROCESS_TYPE
		,BOND_TYPE
		,MANAGER_OBJ
		,INPUT_TIME
		,DECLA_TIME
		,DECLA_DATE
		,EFFECT_TIME
		,IN_OUT_PORT
		,CURRENT_IN_PRICE
		,CURRENT_OUT_PRICE
		,DUE_FLAG
		,NOTE
		,INPUTER
		,IS_DELETE
		,CREATE_ID
		,CREATE_DATE
		,UPDATE_ID
		,UPDATE_DATE
		,SEQ_NO
		,PLAT_NO2
		,CUSTOMS
		,MOD_NUM
		,ECI_EMS_NO
		,OWNER_CODE
		,OWNER_NAME
		,DECLARE_CODE
		,DECLARE_NAME
		,INVEST_MODE
		,EMS_APPR_NO
		,I_E_PORT
		,PAY_MODE
		,MODIFY_MARK
		,ECI_EMS_PROPERTY
		,ECI_EMS_LEVEL
		,DECLARE_PERSON
		,CREATE_PERSON
		,APPROVE_PERSON
		,APPROVE_DATE
		,OUTER_COMMENT
		,INNER_COMMENT
		,STEP_ID
		,STATUS
		,TRADES_CODE
		,DISTRICT_CODE
		,CONTR_NO
		,AREA_CODE
		,CUSTOMS_CODE
		,BATCH_NO 
		,BATCH_FLAG 
		,PLAT_NO  
		,EMS_NO 
		,DECLARE_DATE
		<if test="id != null ">
		,ID
		</if>
		  ) VALUES (
		#{copEmsNo,jdbcType=VARCHAR}
		,#{bookNo,jdbcType=VARCHAR}
		,#{contCustom,jdbcType=VARCHAR}
		,#{bookType,jdbcType=VARCHAR}
		,#{receiptAddress,jdbcType=VARCHAR}
		,#{busiUnitCode,jdbcType=VARCHAR}
		,#{busiUnitName,jdbcType=VARCHAR}
		,#{machUnitCode,jdbcType=VARCHAR}
		,#{machUnitName,jdbcType=VARCHAR}
		,#{companyName,jdbcType=VARCHAR}
		,#{companyManager,jdbcType=VARCHAR}
		,#{tradeMode,jdbcType=VARCHAR}
		,#{masterFtc,jdbcType=VARCHAR}
		,#{masterCustoms,jdbcType=VARCHAR}
		,#{dutyMode,jdbcType=VARCHAR}
		,#{landPlace,jdbcType=VARCHAR}
		,#{dealCode,jdbcType=VARCHAR}
		,#{inSaleRate,jdbcType=VARCHAR}
		,#{protocolNo,jdbcType=VARCHAR}
		,#{licenseKey,jdbcType=VARCHAR}
		,#{approvalNo,jdbcType=VARCHAR}
		,#{inContractNo,jdbcType=VARCHAR}
		,#{bakInPrice,jdbcType=FLOAT}
		,#{objInNo,jdbcType=INTEGER}
		,#{outContractNo,jdbcType=VARCHAR}
		,#{bakOutPrice,jdbcType=FLOAT}
		,#{objOutNo,jdbcType=INTEGER}
		,#{processType,jdbcType=VARCHAR}
		,#{bondType,jdbcType=VARCHAR}
		,#{managerObj,jdbcType=VARCHAR}
		,#{inputTime,jdbcType=DATE}
		,#{declaTime,jdbcType=DATE}
		,#{effectTime,jdbcType=DATE}
		,#{inOutPort,jdbcType=VARCHAR}
		,#{currentInPrice,jdbcType=FLOAT}
		,#{currentOutPrice,jdbcType=FLOAT}
		,#{dueFlag,jdbcType=VARCHAR}
		,#{note,jdbcType=VARCHAR}
		,#{inputer,jdbcType=VARCHAR}
		,#{isDelete,jdbcType=INTEGER}
		,#{createId,jdbcType=INTEGER}
		,#{createDate,jdbcType=DATE}
		,#{updateId,jdbcType=INTEGER}
		,#{updateDate,jdbcType=DATE}
		,#{seqNo,jdbcType=VARCHAR}
		,#{platNo2,jdbcType=VARCHAR}
		,#{customs,jdbcType=VARCHAR}
		,#{modNum,jdbcType=INTEGER}
		,#{eciEmsNo,jdbcType=VARCHAR}
		,#{ownerCode,jdbcType=VARCHAR}
		,#{ownerName,jdbcType=VARCHAR}
		,#{declareCode,jdbcType=VARCHAR}
		,#{declareName,jdbcType=VARCHAR}
		,#{investMode,jdbcType=VARCHAR}
		,#{emsApprNo,jdbcType=VARCHAR}
		,#{iEPort,jdbcType=VARCHAR}
		,#{payMode,jdbcType=VARCHAR}
		,#{modifyMark,jdbcType=VARCHAR}
		,#{eciEmsProperty,jdbcType=VARCHAR}
		,#{eciEmsLevel,jdbcType=VARCHAR}
		,#{declarePerson,jdbcType=VARCHAR}
		,#{approvePerson,jdbcType=VARCHAR}
		,#{createPerson,jdbcType=VARCHAR}
		,#{approveDate,jdbcType=DATE}
		,#{outerComment,jdbcType=VARCHAR}
		,#{innerComment,jdbcType=VARCHAR}
		,#{stepId,jdbcType=VARCHAR}
		,#{status,jdbcType=INTEGER}
		,#{tradesCode,jdbcType=VARCHAR}
		,#{districtCode,jdbcType=VARCHAR}
		,#{contrNo,jdbcType=VARCHAR}
		,#{areaCode,jdbcType=VARCHAR}
		,#{batchNo,jdbcType=VARCHAR}
		,#{batchFlag,jdbcType=VARCHAR}
		,#{platNo,jdbcType=VARCHAR}
		,#{emsNo,jdbcType=VARCHAR}
		,#{declareDate,jdbcType=DATE}
		<if test="id != null ">
		,#{id,jdbcType=INTEGER}
		</if>
		  )
		</insert>
		
	
		<!--更新数据 -->
		<update id="update"  
		parameterType="com.eport.rest.entity.EptBookEntity" 
		>
		update  
		ept_book
		<set>
		<if test="copEmsNo != null ">
		COP_EMS_NO = #{copEmsNo},
		</if>
		<if test="bookNo != null ">
		BOOK_NO = #{bookNo},
		</if>
		<if test="contCustom != null ">
		CONT_CUSTOM = #{contCustom},
		</if>
		<if test="bookType != null ">
		BOOK_TYPE = #{bookType},
		</if>
		<if test="receiptAddress != null ">
		RECEIPT_ADDRESS = #{receiptAddress},
		</if>
		<if test="busiUnitCode != null ">
		BUSI_UNIT_CODE = #{busiUnitCode},
		</if>
		<if test="busiUnitName != null ">
		BUSI_UNIT_NAME = #{busiUnitName},
		</if>
		<if test="machUnitCode != null ">
		MACH_UNIT_CODE = #{machUnitCode},
		</if>
		<if test="machUnitName != null ">
		MACH_UNIT_NAME = #{machUnitName},
		</if>
		<if test="companyName != null ">
		COMPANY_NAME = #{companyName},
		</if>
		<if test="companyManager != null ">
		COMPANY_MANAGER = #{companyManager},
		</if>
		<if test="tradeMode != null ">
		TRADE_MODE = #{tradeMode},
		</if>
		<if test="masterFtc != null ">
		MASTER_FTC = #{masterFtc},
		</if>
		<if test="masterCustoms != null ">
		MASTER_CUSTOMS = #{masterCustoms},
		</if>
		<if test="dutyMode != null ">
		DUTY_MODE = #{dutyMode},
		</if>
		<if test="landPlace != null ">
		LAND_PLACE = #{landPlace},
		</if>
		<if test="dealCode != null ">
		DEAL_CODE = #{dealCode},
		</if>
		<if test="inSaleRate != null ">
		IN_SALE_RATE = #{inSaleRate},
		</if>
		<if test="protocolNo != null ">
		PROTOCOL_NO = #{protocolNo},
		</if>
		<if test="licenseKey != null ">
		LICENSE_KEY = #{licenseKey},
		</if>
		<if test="approvalNo != null ">
		APPROVAL_NO = #{approvalNo},
		</if>
		<if test="inContractNo != null ">
		IN_CONTRACT_NO = #{inContractNo},
		</if>
		<if test="bakInPrice != null ">
		BAK_IN_PRICE = #{bakInPrice},
		</if>
		<if test="objInNo != null ">
		OBJ_IN_NO = #{objInNo},
		</if>
		<if test="outContractNo != null ">
		OUT_CONTRACT_NO = #{outContractNo},
		</if>
		<if test="bakOutPrice != null ">
		BAK_OUT_PRICE = #{bakOutPrice},
		</if>
		<if test="objOutNo != null ">
		OBJ_OUT_NO = #{objOutNo},
		</if>
		<if test="processType != null ">
		PROCESS_TYPE = #{processType},
		</if>
		<if test="bondType != null ">
		BOND_TYPE = #{bondType},
		</if>
		<if test="managerObj != null ">
		MANAGER_OBJ = #{managerObj},
		</if>
		<if test="inputTime != null ">
		INPUT_TIME = #{inputTime},
		</if>
		<if test="declaTime != null ">
		DECLA_TIME = #{declaTime},
		</if>
		<if test="declareDate != null ">
		DECLARE_DATE = #{declareDate},
		</if>
		<if test="effectTime != null ">
		EFFECT_TIME = #{effectTime},
		</if>
		<if test="inOutPort != null ">
		IN_OUT_PORT = #{inOutPort},
		</if>
		<if test="currentInPrice != null ">
		CURRENT_IN_PRICE = #{currentInPrice},
		</if>
		<if test="currentOutPrice != null ">
		CURRENT_OUT_PRICE = #{currentOutPrice},
		</if>
		<if test="dueFlag != null ">
		DUE_FLAG = #{dueFlag},
		</if>
		<if test="note != null ">
		NOTE = #{note},
		</if>
		<if test="inputer != null ">
		INPUTER = #{inputer},
		</if>
		<if test="isDelete != null ">
		IS_DELETE = #{isDelete},
		</if>
		<if test="createId != null ">
		CREATE_ID = #{createId},
		</if>
		<if test="createPerson != null ">
		CREATE_PERSON = #{createPerson},
		</if>
		<if test="createDate != null ">
		CREATE_DATE = #{createDate},
		</if>
		<if test="updateId != null ">
		UPDATE_ID = #{updateId},
		</if>
		<if test="updateDate != null ">
		UPDATE_DATE = #{updateDate},
		</if>
		<if test="seqNo != null ">
		SEQ_NO = #{seqNo},
		</if>
		<if test="platNo2 != null ">
		PLAT_NO2 = #{platNo2},
		</if>
		<if test="customs != null ">
		CUSTOMS = #{customs},
		</if>
		<if test="modNum != null ">
		MOD_NUM = #{modNum},
		</if>
		<if test="eciEmsNo != null ">
		ECI_EMS_NO = #{eciEmsNo},
		</if>
		<if test="ownerCode != null ">
		OWNER_CODE = #{ownerCode},
		</if>
		<if test="ownerName != null ">
		OWNER_NAME = #{ownerName},
		</if>
		<if test="declareCode != null ">
		DECLARE_CODE = #{declareCode},
		</if>
		<if test="declareName != null ">
		DECLARE_NAME = #{declareName},
		</if>
		<if test="investMode != null ">
		INVEST_MODE = #{investMode},
		</if>
		<if test="emsApprNo != null ">
		EMS_APPR_NO = #{emsApprNo},
		</if>
		<if test="iEPort != null ">
		I_E_PORT = #{iEPort},
		</if>
		<if test="payMode != null ">
		PAY_MODE = #{payMode},
		</if>
		<if test="modifyMark != null ">
		MODIFY_MARK = #{modifyMark},
		</if>
		<if test="eciEmsProperty != null ">
		ECI_EMS_PROPERTY = #{eciEmsProperty},
		</if>
		<if test="eciEmsLevel != null ">
		ECI_EMS_LEVEL = #{eciEmsLevel},
		</if>
		<if test="declarePerson != null ">
		DECLARE_PERSON = #{declarePerson},
		</if>
		<if test="approvePerson != null ">
		APPROVE_PERSON = #{approvePerson},
		</if>
		<if test="approveDate != null ">
		APPROVE_DATE = #{approveDate},
		</if>
		<if test="outerComment != null ">
		OUTER_COMMENT = #{outerComment},
		</if>
		<if test="innerComment != null ">
		INNER_COMMENT = #{innerComment},
		</if>
		<if test="stepId != null ">
		STEP_ID = #{stepId},
		</if>
		<if test="status != null ">
		status = #{status},
		</if>
		<if test="tradesCode != null ">
		TRADES_CODE = #{tradesCode},
		</if>
		<if test="districtCode != null ">
		DISTRICT_CODE = #{districtCode},
		</if>
		<if test="contrNo != null ">
		CONTR_NO = #{contrNo},
		</if>
		<if test="areaCode != null ">
		AREA_CODE = #{areaCode},
		</if>
		<if test="customsCode != null ">
		CUSTOMS_CODE = #{customsCode},
		</if>
		<if test="batchNo != null ">
		BATCH_NO = #{batchNo},
		</if>
		<if test="customsCode != null ">
		BATCH_FLAG = #{batchFlag},
		</if>
		<if test="platNo != null ">
		PLAT_NO = #{platNo},
		</if>
		<if test="emsNo != null ">
		EMS_NO = #{emsNo},
		</if>
		</set>
		WHERE ID = #{id}
		</update>
		
	
		<!--根据主键删除数据 -->
		<update id="delete"  
		parameterType="HashMap" 
		>
		update  
		ept_book set IS_DELETE = 1
		where ID in (${par})
		</update>
		
	
		<!--根据企业内部编号查询数据 -->
		<select id="findByCopEmsNo"  
		parameterType="HashMap" 
		resultType="HashMap"
		>
		select ID as "id",COP_EMS_NO as "copEmsNo",BOOK_NO as "bookNo",CONT_CUSTOM as "contCustom"
		from ept_book
		where COP_EMS_NO = #{value}
		</select>
		
	
		<!--根据签约客户查询资料 -->
		<select id="findByContCustom"  
		parameterType="HashMap" 
		resultType="HashMap"
		>
		select ID as "id",COP_EMS_NO as "copEmsNo",BOOK_NO as "bookNo",CONT_CUSTOM as "contCustom"
		from ept_book
		where CONT_CUSTOM= #{value}
		</select>
		
	
		<!--根据手册编号查询数据 -->
		<select id="findByBookNo"  
		parameterType="HashMap" 
		resultType="HashMap"
		>
		select ID as "id",COP_EMS_NO as "copEmsNo",BOOK_NO as "bookNo",CONT_CUSTOM as "contCustom"
		from ept_book
		where BOOK_NO= #{value}
		</select>
		
	
</mapper>