医院耗材管理系统开发_15

本文阐述判断耗材是否二维码管理的操作

@ApiOperation("获取是否使用二维码")
@RequestMapping(value = "/getisQR", method = RequestMethod.POST)
@ResponseBody
public CommonResult<String> getisQR(@RequestBody JSONObject id) {
    String stocknum=id.getString("keyword");
    String bool=baseInfoService.searchbycode(stocknum);
    return CommonResult.success(bool);
}

首先用json格式接收前端发来的id，然后进行接收，

@Override
public String searchbycode(String stocknum){
    String reagentid=baseInfoMapper.getreagentid(stocknum);
    String isqr =baseInfoMapper.selectByPrimaryKey(Long.valueOf(reagentid)).getisQR();
    return isqr;
}

通过baseInfoMapper.getreagentid(stocknum)从后端获取耗材的基础编号

<select id="getreagentid" resultType="java.lang.String">
select reagent_id
from reagent_stock
where stock_no=#{stocknum,jdbcType=VARCHAR}

然后使用基础编号获取是否使用二维码
baseInfoService.searchbycode(stocknum);

<select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">
select 
<include refid="Base_Column_List" />
from reagent_base_info
where id = #{id,jdbcType=BIGINT}