| | |
| | | <result property="categoryId" column="category_id"/> |
| | | <result property="hisPacBm" column="his_pac_bm"/> |
| | | <result property="pym" column="pym"/> |
| | | <result property="tjCategory" column="tj_category"/> |
| | | </resultMap> |
| | | |
| | | <sql id="selectTjPackageVo"> |
| | |
| | | sale_num, |
| | | category_id, |
| | | his_pac_bm, |
| | | pym |
| | | pym,tj_category |
| | | from tj_package |
| | | </sql> |
| | | |
| | |
| | | <if test="counterPrice != null">counter_price,</if> |
| | | <if test="saleNum != null">sale_num,</if> |
| | | <if test="pym != null">pym,</if> |
| | | <if test="tjCategory != null">tj_category,</if> |
| | | |
| | | </trim> |
| | | <trim prefix="values (" suffix=")" suffixOverrides=","> |
| | |
| | | <if test="counterPrice != null">#{counter_price},</if> |
| | | <if test="saleNum != null">#{sale_num},</if> |
| | | <if test="pym != null">#{pym},</if> |
| | | <if test="tjCategory != null">#{tjCategory},</if> |
| | | </trim> |
| | | </insert> |
| | | |
| | |
| | | <if test="counterPrice != null">counter_price=#{counterPrice},</if> |
| | | <if test="saleNum != null">sale_num=#{saleNum},</if> |
| | | <if test="pym != null">pym=#{pym},</if> |
| | | <if test="tjCategory != null">tj_category=#{tjCategory},</if> |
| | | </trim> |
| | | where pac_id = #{pacId} |
| | | </update> |