| | |
| | | <if test="warehouseId != null and warehouseId != ''"> |
| | | and ss.id like #{warehouseId} |
| | | </if> |
| | | order by ss.name ASC |
| | | order by ss.name ASC,su.create_time DESC |
| | | <if test="first != null and pageSize != null"> |
| | | limit #{first}, #{pageSize} |
| | | </if> |
| | |
| | | </insert> |
| | | |
| | | <update id="updateSysWarehouseContainer" parameterType="com.nanometer.smartlab.entity.SysWarehouseContainer"> |
| | | update sys_warehouse_container set warehouse_id=#{warehouseId}, type=#{type}, container_code=#{containerCode}, |
| | | update sys_warehouse_container set warehouse_id=#{warehouseId}, type=#{type}, container_code=#{containerCode}, |
| | | info_code=#{infoCode}, structure=#{structure}, name=#{name}, character_left=#{characterLeft}, character_right=#{characterRight}, |
| | | update_time=now(), |
| | | controller_code=#{controllerCode} |
| | |
| | | } |
| | | |
| | | if(opeUseFlow.getCreateTime()==null){ |
| | | opeUseFlow.setCreateTime(new Timestamp(System.currentTimeMillis())); |
| | | opeUseFlow.setCreateTime(new Timestamp(System.currentTimeMillis()+1000)); |
| | | } |
| | | |
| | | this.opeUseFlowDao.insertOpeUseFlow(opeUseFlow); |
| | |
| | | ors.setContainerId(reagentReceiving.getLabContainerId()); |
| | | ors.setHouseId(reagentReceiving.getLabId()); |
| | | ors.setUserId(reagentReceiving.getApplyUserId()); |
| | | opeReagentStatusService.updateReagentStatus(ors); |
| | | |
| | | if (opeReagentStatusService.isAllowWarehouseUse(ors)) { |
| | | // 减少库存 |