医院耗材管理系统开发_3

最新推荐文章于 2024-10-15 10:29:42 发布

博卓卡替斯

最新推荐文章于 2024-10-15 10:29:42 发布

阅读量261

点赞数

分类专栏：医院耗材管理系统开发文章标签： intellij-idea spring 后端

本文链接：https://blog.csdn.net/chenlong58998/article/details/124354772

版权

医院耗材管理系统开发专栏收录该内容

18 篇文章 2 订阅

订阅专栏

该文总结近期功能实现：

科室库出库：接受前端传入数据后，根据数量完成stock与stock_detail库的修改。

接收数据，调用outFromBranch方法

@ApiOperation("移出科室库")
@RequestMapping(value = "/outFromBranch", method = RequestMethod.POST)
@ResponseBody
public CommonResult outFromBranch(@RequestBody ReagentStock stock) {

    int count = stockService.outFromBranch(stock);

    return CommonResult.success(1);
}

改变quantuty，调用updateByPrimaryKeySelective并传入

public int outFromBranch(ReagentStock stock){
    long Quantity=stock.getQuantity();
    long Number=stock.getoutNumber();
    stock.setQuantity(Quantity-Number);
    stockMapper.updateByPrimaryKeySelective(stock);
    return stockMapper.outFromBranch(stock.getStockNo(),Number);

}

调用数据库并写入（需判断if，否则容易出问题）

<update id="updateByExampleSelective" parameterType="map">
update reagent_stock
<set>
  <if test="record.id != null">
    id = #{record.id,jdbcType=BIGINT},
  </if>
  <if test="record.stockNo != null">
    stock_no = #{record.stockNo,jdbcType=VARCHAR},
  </if>
  <if test="record.stockType != null">
    stock_type = #{record.stockType,jdbcType=VARCHAR},
  </if>
  <if test="record.reagentId != null">
    reagent_id = #{record.reagentId,jdbcType=VARCHAR},
  </if>
  <if test="record.reagentName != null">
    reagent_name = #{record.reagentName,jdbcType=VARCHAR},
  </if>
  <if test="record.reagentType != null">
    reagent_type = #{record.reagentType,jdbcType=VARCHAR},
  </if>
  <if test="record.reagentUnit != null">
    reagent_unit = #{record.reagentUnit,jdbcType=VARCHAR},
  </if>
  <if test="record.branchName != null">
    branch_name = #{record.branchName,jdbcType=VARCHAR},
  </if>
  <if test="record.factory != null">
    factory = #{record.factory,jdbcType=VARCHAR},
  </if>
  <if test="record.supplierName != null">
    supplier_name = #{record.supplierName,jdbcType=VARCHAR},
  </if>
  <if test="record.quantity != null">
    quantity = #{record.quantity,jdbcType=BIGINT},
  </if>
  <if test="record.reagentPrice != null">
    reagent_price = #{record.reagentPrice,jdbcType=DOUBLE},
  </if>
  <if test="record.reagentStatus != null">
    reagent_status = #{record.reagentStatus,jdbcType=VARCHAR},
  </if>
  <if test="record.reagentTemp != null">
    reagent_temp = #{record.reagentTemp,jdbcType=VARCHAR},
  </if>
  <if test="record.lowStock != null">
    low_stock = #{record.lowStock,jdbcType=VARCHAR},
  </if>
  <if test="record.overdueStock != null">
    overdue_stock = #{record.overdueStock,jdbcType=INTEGER},
  </if>
  <if test="record.overdue != null">
    overdue = #{record.overdue,jdbcType=INTEGER},
  </if>
  <if test="record.createTime != null">
    create_time = #{record.createTime,jdbcType=TIMESTAMP},
  </if>
  <if test="record.createBy != null">
    create_by = #{record.createBy,jdbcType=VARCHAR},
  </if>
  <if test="record.updateTime != null">
    update_time = #{record.updateTime,jdbcType=TIMESTAMP},
  </if>
  <if test="record.updateBy != null">
    update_by = #{record.updateBy,jdbcType=VARCHAR},
  </if>
  <if test="record.deleteFlag != null">
    delete_flag = #{record.deleteFlag,jdbcType=TINYINT},
  </if>
  <if test="record.deleteTime != null">
    delete_time = #{record.deleteTime,jdbcType=TIMESTAMP},
  </if>
  <if test="record.deleteBy != null">
    delete_by = #{record.deleteBy,jdbcType=VARCHAR},
  </if>
</set>
<if test="_parameter != null">
  <include refid="Update_By_Example_Where_Clause" />
</if>

以上完成stock库-1

调用outFromBranch

<delete id="outFromBranch" parameterType="jp.co.nss.hrm.backend.model.ReagentStock">
delete from reagent_stock_detail
where stock_no = ${stock_no}
limit ${Number}

完成detail库操作，根据数量删除