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