| | |
| | | <result property="effectDate" column="EFFECT_DATE" /> |
| | | <result property="bigclass" column="BIGCLASS" /> |
| | | <result property="shopId" column="shop_id" /> |
| | | <result property="companyId" column="company_id" /> |
| | | </resultMap> |
| | | <!-- 插入方法 --> |
| | | <insert id="insert" parameterType="SysVipLevel" |
| | |
| | | REMARK, |
| | | EFFECT_DATE, |
| | | BIGCLASS, |
| | | shop_id |
| | | shop_id, |
| | | company_id |
| | | ) |
| | | VALUES ( |
| | | #{id}, |
| | |
| | | #{remark}, |
| | | #{effectDate}, |
| | | #{bigclass}, |
| | | #{shopId} |
| | | #{shopId}, |
| | | #{companyId} |
| | | ) |
| | | </insert> |
| | | |
| | |
| | | <if test="record.shopId != null and record.shopId !='' "> |
| | | and shop_id = #{record.shopId} |
| | | </if> |
| | | <if test="record.companyId != null and record.companyId !='' "> |
| | | and company_id = #{record.companyId} |
| | | </if> |
| | | </if> |
| | | <if test="pageVo !=null"><!-- 判断pageVo对象是否为空 --> |
| | | <if test="pageVo.sort !=null and pageVo.order !=null"> |
| | |
| | | </if> |
| | | <if test="record.shopId != null and record.shopId !='' "> |
| | | and shop_id = #{record.shopId} |
| | | </if> |
| | | <if test="record.companyId != null and record.companyId !='' "> |
| | | and company_id = #{record.companyId} |
| | | </if> |
| | | </if> |
| | | </select> |
| | |
| | | <if test="record.shopId != null and record.shopId !='' "> |
| | | and shop_id = #{record.shopId} |
| | | </if> |
| | | <if test="record.companyId != null and record.companyId !='' "> |
| | | and company_id = #{record.companyId} |
| | | </if> |
| | | </if> |
| | | </select> |
| | | </mapper> |