package com.qxueyou.scc.exam.dao;

import com.qxueyou.scc.base.dao.BaseDAO;
import com.qxueyou.scc.base.model.Pager;
import com.qxueyou.scc.base.util.CollectionUtils;
import com.qxueyou.scc.exam.model.ExamResultV;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public class ExamResultVDao extends BaseDAO {

    public List<ExamResultV> getResultList(String classId) {
        String hql = "from ExamResultV where class_Id LIKE ? and score != null and score != 0";
        return this.find(hql,CollectionUtils.newList(classId),ExamResultV.class);
    }

    public int getExamCount(String classId) {
        //id.
        String hql = "select count(distinct examId) from ExamResultV where class_Id=?";

        return this.findCount(hql, CollectionUtils.newList(classId));
    }


}