| | |
| | | </insert> |
| | | |
| | | <update id="updateOpeWarehouseReserve" parameterType="com.nanometer.smartlab.entity.OpeWarehouseReserve"> |
| | | update ope_warehouse_reserve set reagent_id=#{reagentId},warehouseId=#{warehouseId}, article_number=#{articleNumber}, reserve=#{reserve}, update_time=now() |
| | | update ope_warehouse_reserve |
| | | <set> |
| | | reagent_id=#{reagentId}, |
| | | reserve=#{reserve}, |
| | | update_time=now(), |
| | | <if test="articleNumber != null and articleNumber !=''"> |
| | | article_number=#{articleNumber}, |
| | | </if> |
| | | <if test="warehouseId != null and warehouseId !=''"> |
| | | warehouseId=#{warehouseId}, |
| | | </if> |
| | | </set> |
| | | where id=#{id} |
| | | </update> |
| | | |