资源管理修改

Administrator

2022-11-16 83c795e9d040110973df19a9a3d953518d27b35d

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
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));
    }
}