<?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.EptWarehouseLocationDao">
    
	<sql id="EptWarehouseLocationEntityColumns">
		a1.ID AS "id"
		,a1.LOCATION_NO AS "locationNo"
		,a1.LOCATION_NAME AS "locationName"
		,a1.REMARK AS "remark"
		,a1.IS_DELETE AS "isDelete"
		,a1.CREATE_ID AS "createId"
		,a1.CREATE_DATE AS "createDate"
		,a1.UPDATE_ID AS "updateId"
		,a1.UPDATE_DATE AS "updateDate"
	</sql>
	
	<sql id="EptWarehouseLocationEntityListColumn">
		a1.ID AS "id"
		,a1.LOCATION_NO AS "locationNo"
		,a1.LOCATION_NAME AS "locationName"
		,a1.REMARK AS "remark"
	</sql>
	
	<!--查询表中所有资料(所有字段) -->
	<select id="listAll" parameterType="HashMap" resultType="com.eport.rest.entity.EptWarehouseLocationEntity">
		select  
			<include refid="EptWarehouseLocationEntityListColumn"/>
		FROM ept_warehouse_location a1
		WHERE 1=1
		and a1.BOOK_ID = ${bookId}
		and a1.IS_DELETE = 0
	</select>
	
	<!--分页查询资料(所有字段) -->
	<select id="pageAll" parameterType="HashMap" resultType="com.eport.rest.entity.EptWarehouseLocationEntity">
		select  
			<include refid="EptWarehouseLocationEntityListColumn"/>
		FROM ept_warehouse_location a1 
		WHERE 1=1
		<if test="locationNo != null">
		and a1.LOCATION_NO like CONCAT(CONCAT('%',#{locationNo}),'%')
		</if>
		<if test="locationName != null">
		and a1.LOCATION_NAME CONCAT(CONCAT('%',#{locationName}),'%')
		</if>
		and a1.IS_DELETE = 0
	</select>
	
	<!--查询表中所有资料(仅列表显示字段) -->
	<select id="list" parameterType="HashMap" resultType="com.eport.rest.entity.EptWarehouseLocationEntity">
		select  
			<include refid="EptWarehouseLocationEntityListColumn"/>
		FROM ept_warehouse_location a1
		WHERE 1=1
		<if test="locationNo != null">
		and a1.LOCATION_NO like CONCAT(CONCAT('%',#{locationNo}),'%')
		</if>
		<if test="locationName != null">
		and a1.LOCATION_NAME CONCAT(CONCAT('%',#{locationName}),'%')
		</if>
		and a1.IS_DELETE = 0
	</select>
		
	<!--分页查询资料(仅列表显示字段) -->
	<select id="page" parameterType="HashMap" resultType="com.eport.rest.entity.EptWarehouseLocationEntity">
		select  
			<include refid="EptWarehouseLocationEntityListColumn"/>
		FROM ept_warehouse_location a1
		WHERE 1=1
		<if test="locationNo != null">
		and a1.LOCATION_NO like CONCAT(CONCAT('%',#{locationNo}),'%')
		</if>
		<if test="locationName != null">
		and a1.LOCATION_NAME CONCAT(CONCAT('%',#{locationName}),'%')
		</if>
		and a1.IS_DELETE = 0
	</select>
	
	<!--根据主键查询数据 -->
	<select id="findByPK" parameterType="Integer" resultType="com.eport.rest.entity.EptWarehouseLocationEntity">
		select  
		<include refid="EptWarehouseLocationEntityColumns"/>
		FROM ept_warehouse_location  a1
		WHERE a1.ID=#{par}
		 and IS_DELETE = 0
	</select>
	
	<!--新增数据 -->
	<insert id="insert" parameterType="com.eport.rest.entity.EptWarehouseLocationEntity">
		<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_warehouse_location (
		LOCATION_NO
		,LOCATION_NAME
		,REMARK
		,IS_DELETE
		,CREATE_ID
		,CREATE_DATE
		,UPDATE_ID
		,UPDATE_DATE
		<if test="id != null ">
		,ID
		</if>
		  ) VALUES (
		#{locationNo,jdbcType=VARCHAR}
		,#{locationName,jdbcType=VARCHAR}
		,#{remark,jdbcType=VARCHAR}
		,#{isDelete,jdbcType=INTEGER}
		,#{createId,jdbcType=INTEGER}
		,#{createDate,jdbcType=DATE}
		,#{updateId,jdbcType=INTEGER}
		,#{updateDate,jdbcType=DATE}
		<if test="id != null ">
		,#{id,jdbcType=INTEGER}
		</if>
		  )
	</insert>
		
	<!--更新数据 -->
	<update id="update" parameterType="com.eport.rest.entity.EptWarehouseLocationEntity">
		update  
		ept_warehouse_location
		<set>
		<if test="locationNo != null ">
		LOCATION_NO = #{locationNo},
		</if>
		<if test="locationName != null ">
		LOCATION_NAME = #{locationName},
		</if>
		<if test="remark != null ">
		REMARK = #{remark},
		</if>
		<if test="isDelete != null ">
		IS_DELETE = #{isDelete},
		</if>
		<if test="createId != null ">
		CREATE_ID = #{createId},
		</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>
		</set>
		WHERE ID = #{id}
	</update>
	
	<!--根据主键删除数据 -->
	<update id="delete" parameterType="HashMap">
		update  
		ept_warehouse_location set IS_DELETE = 1
		where ID in (${par})
	</update>
		
</mapper>