<?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.suoutstore.SuOutStoreDetailDao"> <!--BaseResultMap --> <resultMap id="BaseResultMap" type="com.phxl.modules.goods.entity.suoutstore.SuOutStoreDetail"> <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_no" property="medPlanNo" jdbcType="VARCHAR" /> <result column="med_plan_row_no" property="medPlanRowNo" jdbcType="TINYINT" /> <result column="goods_guid" property="goodsGuid" 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="poqty" property="poqty" jdbcType="DECIMAL" /> <result column="arrivalqty" property="arrivalqty" 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_no,med_plan_row_no,goods_guid,goods_name,goods_spec,unit,manufacturer,purchaser_price,amount,lot,production_date,expire_date,poqty,arrivalqty,memo</sql> <!--批量插入MedPlanDetail --> <insert id="batchInsert" parameterType="list"> insert into med_supplier_out_store_detail (id,bill_no,row_no,med_plan_no,med_plan_row_no,goods_guid,goods_name,goods_spec,unit,manufacturer,purchaser_price,amount,lot,production_date,expire_date,poqty,arrivalqty,memo) values <foreach collection ="list" item="obj" separator =","> <trim prefix=" (" suffix=")" suffixOverrides=","> #{obj.id}, #{obj.billNo}, #{obj.rowNo}, #{obj.medPlanNo}, #{obj.medPlanRowNo}, #{obj.goodsGuid}, #{obj.goodsName}, #{obj.goodsSpec}, #{obj.unit}, #{obj.manufacturer}, #{obj.purchaserPrice}, #{obj.amount}, #{obj.lot}, #{obj.productionDate}, #{obj.expireDate}, #{obj.poqty}, #{obj.arrivalqty}, #{obj.memo} </trim> </foreach> </insert> </mapper>