17c0c35860d37f7d15344f7cccde6cfce00e9824.svn-base 2.83 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.medinstore.MedInStoreDetailDao">

	<!--BaseResultMap -->
	<resultMap id="BaseResultMap"
		type="com.phxl.modules.goods.entity.medinstore.MedInStoreDetail">
		<id column="id" property="id" jdbcType="BIGINT" />
		<result column="bill_no" property="billNo" jdbcType="VARCHAR" />
		<result column="row_no" property="rowNo" jdbcType="TINYINT" />
		<result column="med_plan_row_no" property="medPlanRowNo" jdbcType="TINYINT" />
		<result column="supplier_do_no" property="supplierDoNo" jdbcType="VARCHAR" />
		<result column="supplier_do_row_no" property="supplierDoRowNo" jdbcType="TINYINT" />
		<result column="goods_code" property="goodsCode" jdbcType="VARCHAR" />
		<result column="goods_name" property="goodsName" jdbcType="VARCHAR" />
		<result column="goods_spec" property="goodsSpec" jdbcType="VARCHAR" />
		<result column="unit" property="unit" jdbcType="VARCHAR" />
		<result column="manufacturer" property="manufacturer" jdbcType="VARCHAR" />
		<result column="purchaser_price" property="purchaserPrice" jdbcType="DECIMAL" />
		<result column="amount" property="amount" jdbcType="DECIMAL" />
		<result column="lot" property="lot" jdbcType="VARCHAR" />
		<result column="production_date" property="productionDate" jdbcType="TIMESTAMP" />
		<result column="expire_date" property="expireDate" jdbcType="TIMESTAMP" />
		<result column="arrivalqty" property="arrivalqty" jdbcType="DECIMAL" />		
		<result column="mvqty" property="mvqty" jdbcType="DECIMAL" />
		<result column="memo" property="memo" jdbcType="VARCHAR" />
	</resultMap>

	<!--Base_Column_List -->
	<sql id="Base_Column_List">id,bill_no,row_no,med_plan_row_no,supplier_do_no,supplier_do_row_no,goods_code,goods_name,goods_spec,unit,manufacturer,purchaser_price,amount,lot,production_date,expire_date,arrivalqty,mvqty,memo</sql>

	<!--批量插入MedInStoreDetail -->
	<insert id="batchInsert" parameterType="list">
		insert into med_hli_in_store_detail (id,bill_no,row_no,med_plan_row_no,supplier_do_no,supplier_do_row_no,goods_code,goods_name,goods_spec,unit,manufacturer,purchaser_price,amount,lot,production_date,expire_date,arrivalqty,mvqty,memo)
		values
		<foreach collection ="list" item="obj" separator =",">
		<trim prefix=" (" suffix=")" suffixOverrides=",">
				#{obj.id},
				#{obj.billNo},
				#{obj.rowNo},
				#{obj.medPlanRowNo},
				#{obj.supplierDoNo},
				#{obj.supplierDoRowNo},
				#{obj.goodsCode},
				#{obj.goodsName},
				#{obj.goodsSpec},
				#{obj.unit},
				#{obj.manufacturer},
				#{obj.purchaserPrice},
				#{obj.amount},
				#{obj.lot},
				#{obj.productionDate},
				#{obj.expireDate},
				#{obj.arrivalqty},				
				#{obj.mvqty},
				#{obj.memo}
			</trim>
          </foreach>
	</insert>
	

</mapper>