package com.qxueyou.scc.admin.classes.dao;
|
|
import com.qxueyou.scc.admin.classes.model.ClsClass;
|
import com.qxueyou.scc.base.dao.BaseDAO;
|
import com.qxueyou.scc.base.model.Result;
|
import com.qxueyou.scc.base.util.CollectionUtils;
|
import org.springframework.stereotype.Repository;
|
|
import java.util.ArrayList;
|
import java.util.List;
|
|
@Repository
|
public class ClassDAO extends BaseDAO {
|
|
public int addStudent(String classId, int count) {
|
ClsClass clsClass = read(ClsClass.class, classId);
|
|
int studentCount = clsClass.getStudentCount();
|
|
if (studentCount == 0 && count == -1) {
|
return 0;
|
}
|
String hql = "update ClsClass cls set studentCount = studentCount+? where classId=?";
|
|
Result r = bulkUpdate(hql, new Object[]{count, classId});
|
|
return r.getDataT("doCount");
|
}
|
|
|
/**
|
* 获取这个通知的总人数
|
*/
|
public int getStudentCount(List<String> classIds) {
|
|
List<ClsClass> classLst = findByComplexHql("from ClsClass where deleteFlag is false and classId in(:ids) ",
|
CollectionUtils.newObjectMap("ids", classIds), ClsClass.class);
|
int studentCount = 0;
|
for (ClsClass clsClass : classLst) {
|
studentCount += clsClass.getStudentCount();
|
}
|
return studentCount;
|
|
}
|
|
/**
|
* 获取通知的班级名称
|
*/
|
public List<String> getClassNameByclsId(List<String> classIds) {
|
List<ClsClass> clsLst = findByComplexHql("from ClsClass where deleteFlag is false and classId in(:ids)", CollectionUtils.newObjectMap("ids", classIds), ClsClass.class);
|
List<String> nameLst = new ArrayList<String>(clsLst.size());
|
for (ClsClass clsClass : clsLst) {
|
nameLst.add(clsClass.getName());
|
}
|
return nameLst;
|
}
|
}
|