派生自 projectDept/qhighschool

EricsHu
2023-11-25 79ab2cbd31c022916a8e696903d5eb34b70aa403
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
package com.qxueyou.scc.admin.score.dao;
 
import org.springframework.stereotype.Repository;
 
import com.qxueyou.scc.base.dao.BaseDAO;
import com.qxueyou.scc.base.util.CollectionUtils;
 
@Repository
public class ExamScoreVDAO extends BaseDAO {
 
    public int getExamCount(String classId) {
 
        String hql = "select count(distinct id.examId) from ExamScoreV where classId=?";
 
        return this.findCount(hql, CollectionUtils.newList(classId));
    }
 
    public int getToSubmitExamCount(String classId) {
 
        String hql = "from ExamScoreV where classId=? and coalesce(score,-1) = -1";
 
        return this.findCount(hql, CollectionUtils.newList(classId));
    }
 
}