dde3a42b64d80f46daec1a377b5ca0bb4f9db314.svn-base
4.35 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
<?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.spills.HisSpillsDao">
<!--BaseResultMap -->
<resultMap id="BaseResultMap"
type="com.phxl.modules.goods.entity.spills.HisSpills">
<id column="id" property="id" jdbcType="BIGINT" />
<result column="med_code" property="medCode" jdbcType="VARCHAR" />
<result column="med_name" property="medName" jdbcType="VARCHAR" />
<result column="depot_code" property="depotCode" jdbcType="VARCHAR" />
<result column="depot_name" property="depotName" jdbcType="VARCHAR" />
<result column="tack_stockdate" property="tackStockDate" jdbcType="TIMESTAMP" />
<result column="operater_name" property="operaterName" jdbcType="VARCHAR" />
<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="manufacturer" property="manufacturer" jdbcType="VARCHAR" />
<result column="lot" property="lot" jdbcType="VARCHAR" />
<result column="unit" property="unit" jdbcType="VARCHAR" />
<result column="number" property="number" jdbcType="DECIMAL" />
<result column="storck_num" property="storckNum" jdbcType="DECIMAL" />
<result column="difference_num" property="differenceNum" jdbcType="DECIMAL" />
<result column="production_date" property="productionDate" jdbcType="TIMESTAMP" />
<result column="expire_date" property="expireDate" jdbcType="TIMESTAMP" />
<result column="supplier_code" property="supplierCode" jdbcType="VARCHAR" />
<result column="supplier_name" property="supplierName" jdbcType="VARCHAR" />
<result column="tackstock_billno" property="tackStockBillNo" jdbcType="VARCHAR" />
<result column="price" property="price" jdbcType="DECIMAL" />
</resultMap>
<!--Base_Column_List -->
<sql id="Base_Column_List">id,med_code,med_name,depot_code,depot_name,tack_stockdate,operater_name,goods_code,goods_name,goods_spec,manufacturer,lot,unit,number,storck_num,difference_num,production_date,expire_date,supplier_code,supplier_name,tackstock_billno,price</sql>
<!--批量插入 -->
<insert id="batchInsert" parameterType="list">
insert into med_hli_spills (id,med_code,med_name,depot_code,depot_name,tack_stockdate,operater_name,goods_code,goods_name,goods_spec,manufacturer,lot,unit,number,storck_num,difference_num,production_date,expire_date,supplier_code,supplier_name,tackstock_billno,price)
values
<foreach collection ="list" item="obj" separator =",">
<trim prefix=" (" suffix=")" suffixOverrides=",">
#{obj.id},
#{obj.medCode},
#{obj.medName},
#{obj.depotCode},
#{obj.depotName},
#{obj.tackStockDate},
#{obj.operaterName},
#{obj.goodsCode},
#{obj.goodsName},
#{obj.goodsSpec},
#{obj.manufacturer},
#{obj.lot},
#{obj.unit},
#{obj.number},
#{obj.storckNum},
#{obj.differenceNum},
#{obj.productionDate},
#{obj.expireDate},
#{obj.supplierCode},
#{obj.supplierName},
#{obj.tackStockBillNo},
#{obj.price}
</trim>
</foreach>
</insert>
<!-- 新增HisSpills-->
<insert id="insert" parameterType="com.phxl.modules.goods.entity.spills.HisSpills">
insert into med_hli_spills (id,med_code,med_name,depot_code,depot_name,tack_stockdate,operater_name,goods_code,goods_name,goods_spec,manufacturer,lot,unit,number,storck_num,difference_num,production_date,expire_date,supplier_code,supplier_name,tackstock_billno,price)
values (
#{id,jdbcType=VARCHAR}
,#{medCode,jdbcType=VARCHAR}
,#{medName,jdbcType=VARCHAR}
,#{depotCode,jdbcType=VARCHAR}
,#{depotName,jdbcType=VARCHAR}
,#{tackStockDate,jdbcType=TIMESTAMP}
,#{operaterName,jdbcType=VARCHAR}
,#{goodsCode,jdbcType=VARCHAR}
,#{goodsName,jdbcType=VARCHAR}
,#{goodsSpec,jdbcType=VARCHAR}
,#{manufacturer,jdbcType=VARCHAR}
,#{lot,jdbcType=VARCHAR}
,#{unit,jdbcType=VARCHAR}
,#{number,jdbcType=DECIMAL}
,#{storckNum,jdbcType=DECIMAL}
,#{differenceNum,jdbcType=DECIMAL}
,#{productionDate,jdbcType=TIMESTAMP}
,#{expireDate,jdbcType=TIMESTAMP}
,#{supplierCode,jdbcType=VARCHAR}
,#{supplierName,jdbcType=VARCHAR}
,#{tackStockBillNo,jdbcType=VARCHAR}
,#{price,jdbcType=DECIMAL}
)
</insert>
</mapper>