thmz/src/main/java/cn/hnthyy/thmz/mapper/his/MzSerialNoMapper.java

package cn.hnthyy.thmz.mapper.his;

import cn.hnthyy.thmz.entity.his.MzSerialNo;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

public interface MzSerialNoMapper {
    /**
     * 查询序列号记录
     * @return
     */
    @Select("select serial_no,rtrim(outpatient_no) outpatient_no,inject_no,serial_out,prior_no,serial_new,hzyl_no from mz_serial_no")
    MzSerialNo selectMzSerialNo();

    /**
     * 更新序列号
     * @param mzSerialNo
     * @return
     */
    @Update({"<script>",
            "update mz_serial_no ",
            "<trim prefix='set' prefixOverrides=',' suffix=' where outpatient_no = #{outpatientNo} and serial_out=#{serialOut} and serial_new =#{serialNew}' >",
               "<when test='newOutpatientNo!=null'>",
                  "outpatient_no =#{newOutpatientNo,jdbcType=VARCHAR}",
               "</when>",
               "<when test='newSerialOut!=null'>",
                  ",serial_out =#{newSerialOut,jdbcType=INTEGER}",
               "</when>",
               "<when test='newSerialNew!=null'>",
                  ",serial_new =#{newSerialNew,jdbcType=INTEGER}",
               "</when>",
            "</trim>"
            ,"</script>"})
    int updateMzSerialNo(MzSerialNo mzSerialNo);
}