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 classIds) { List 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 getClassNameByclsId(List classIds) { List clsLst = findByComplexHql("from ClsClass where deleteFlag is false and classId in(:ids)", CollectionUtils.newObjectMap("ids", classIds), ClsClass.class); List nameLst = new ArrayList(clsLst.size()); for (ClsClass clsClass : clsLst) { nameLst.add(clsClass.getName()); } return nameLst; } }