c7d32ddb3723c1c99d729d2a9859169bf67d3474.svn-base 1.94 KB
<?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.phxl.modules.goods.dao.supplygoods.MedSupplyGoodsDao">

	<!--BaseResultMap -->
	<resultMap id="BaseResultMap"
		type="com.phxl.modules.goods.entity.supplygoods.MedSupplyGoods">
		<id column="id" property="id" jdbcType="BIGINT" />
		<result column="med_suppliercode" property="medSuppliercode" jdbcType="VARCHAR" />
		<result column="med_suppliername" property="medSuppliername" jdbcType="VARCHAR" />
		<result column="goods_code" property="goodsCode" jdbcType="VARCHAR" />
		<result column="goods_name" property="goodsName" jdbcType="VARCHAR" />
		<result column="producer" property="producer" jdbcType="VARCHAR" />
		<result column="goods_spec" property="goodsSpec" jdbcType="VARCHAR" />
		<result column="unit_style" property="unitStyle" jdbcType="VARCHAR" />
		<result column="create_time" property="createTime" jdbcType="TIMESTAMP" />
		<result column="update_time" property="updateTime" jdbcType="TIMESTAMP" />
		<result column="price" property="price" jdbcType="DECIMAL" />
	</resultMap>

	<!--Base_Column_List -->
	<sql id="Base_Column_List">id,med_suppliercode,med_suppliername,goods_code,goods_name,producer,goods_spec,unit_style,create_time,update_time,price</sql>

	<!--批量插入 -->
	<insert id="batchInsert" parameterType="list">
		insert into med_supply_catalog (id,med_suppliercode,med_suppliername,goods_code,goods_name,producer,goods_spec,unit_style,create_time,update_time,price)
		values
		<foreach collection ="list" item="obj" separator =",">
		<trim prefix=" (" suffix=")" suffixOverrides=",">
				#{obj.id},
				#{obj.medSuppliercode},
				#{obj.medSuppliername},
				#{obj.goodsCode},
				#{obj.goodsName},
				#{obj.producer},
				#{obj.goodsSpec},
				#{obj.unitStyle},
				#{obj.createTime},
				#{obj.updateTime},
				#{obj.price}
			</trim>
          </foreach>
	</insert>

</mapper>