修改分值，解除绑定相关

zengh

2021-07-18 90c49a219f9abb8a85be0e07f190c33bac25d1ee

修改分值，解除绑定相关

 src/main/java/org/springblade/modules/exam/controller/ExamSubjectChoicesController.java

@@ -146,4 +146,12 @@
        return R.data(pages);
    }

    /**
     * 修改单项题目分值
     */
    @PostMapping("/updateChoicesValue")
    public R updateChoicesValue(String id,String value) {
        return R.status(examSubjectChoicesService.updateChoicesValue(id,value));
    }

}

 src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.java

@@ -39,4 +39,6 @@
     */
    ExamSubjectChoicesVO selectExamSubjectChoicesInfo(@Param("examSubjectChoices") ExamSubjectChoices examSubjectChoices);

    boolean updateChoicesValue(String id,String value);

}

 src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.xml

@@ -30,6 +30,12 @@
        <if test="examSubjectChoices.id!=null and  examSubjectChoices.id!=''">
            and exa.examination_id = #{examSubjectChoices.id}
        </if>
        <if test="examSubjectChoices.subjectName!=null and  examSubjectChoices.subjectName!=''">
            and esc.subject_name like concat('%', #{examSubjectChoices.subjectName},'%')
        </if>
        <if test="examSubjectChoices.choicesType!=null and  examSubjectChoices.choicesType!=''">
            and esc.choices_type = #{examSubjectChoices.choices_type}
        </if>
    </select>


@@ -74,4 +80,8 @@
            and esc.id = #{examSubjectChoices.id}
        </if>
    </select>

    <update id="updateChoicesValue">
        update exam_subject_choices set score = #{value} where id = #{id}
    </update>
</mapper>

 src/main/java/org/springblade/modules/exam/service/ExamSubjectChoicesService.java

@@ -32,4 +32,9 @@
     * @param examSubjectChoices 选择题信息对象
     */
    ExamSubjectChoicesVO selectExamSubjectChoicesInfo(ExamSubjectChoices examSubjectChoices);

    /**
     *    修改分值
     */
    boolean updateChoicesValue(String id , String value);
}

 src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java

@@ -34,4 +34,9 @@
    public ExamSubjectChoicesVO selectExamSubjectChoicesInfo(ExamSubjectChoices examSubjectChoices) {
        return baseMapper.selectExamSubjectChoicesInfo(examSubjectChoices);
    }

    @Override
    public boolean updateChoicesValue(String id, String value) {
        return baseMapper.updateChoicesValue(id,value);
    }
}