该文总结近期功能实现:
科室库出库:接受前端传入数据后,根据数量完成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库操作,根据数量删除
|