医院耗材管理系统开发_4

该文总结近期功能实现：
中心库出库：中心库出库要分别修改stock和stockdetail两个表。首先接收前端传入的数据，修改stock表中的数量，然后修改stockdetail中库存。

接受前端传入数据，.调用stockService.outFromCentre(stock)方法。

@OperationLogAnnotation(operaModule = "在库管理", operaDesc = "移库")
@ApiOperation("移出中心库")
@RequestMapping(value = "/outFromCentre", method = RequestMethod.POST)
@ResponseBody
public CommonResult outFromCentre(@RequestBody ReagentStock stock) {
    int count = stockService.outFromCentre(stock);
    return CommonResult.success(count);
}

.
修改stock和stockdetail。首先判断detail表中是否已经拥有该耗材。

public int outFromCentre(ReagentStock stock){
    String reagentid=stock.getReagentId();
    long Quantity=stock.getQuantity();
    long Number=stock.getoutNumber();
    String destination=stock.getdestination()+"";



    //判断科室库里是否已有
    ReagentStock stock1=stockMapper.selectByReagentId(reagentid,destination);

如果已经拥有耗材则调用updateByPrimaryKeySelective修改stock1

    //已有
    if(stock1.getId()/stock1.getId()==1){
        //修改中心库stock表
        stock.setQuantity(Quantity-Number);
        stockMapper.updateByPrimaryKeySelective(stock);

        //修改科室库stock表
        stock1.setQuantity(stock1.getQuantity()+Number);
        stockMapper.updateByPrimaryKeySelective(stock1);

调用mybatis的outFromCentre修改数据库。

        //修改stockdetail表
        return stockMapper.outFromCentre(stock.getStockNo(),stock1.getStockNo(),stock1.getBranchName(),stock.getoutNumber());
    }

    //没有
    else{

    }
    return 1;

};

}.

outFromCentre效果

<update id="outFromCentre" parameterType="jp.co.nss.hrm.backend.model.ReagentStock">
update reagent_stock_detail
set stock_no=#{n2,jdbcType=VARCHAR},
    branch =#{name,jdbcType=VARCHAR}
where stock_no=#{n1,jdbcType=VARCHAR}
limit ${number}