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));
	}

}