//插入版本,查出数据库最新版本,创建新版本,在此基础上加1
public ProgrammeHead createVersion(ProgrammeHead obj) {
List<ProgrammeHead> programmeHead = dao().query(ProgrammeHead.class,Cnd.where("courseId","=",obj.getCourseId()));// 遍历获得最大版本数
Integer versionmax = programmeHead.get(0).getVersion();
for (int i = 0; i < programmeHead.size(); i++) {
if (versionmax < (Integer)programmeHead.get(i).getVersion()) versionmax = (Integer)programmeHead.get(i).getVersion();
} //设置版本创建日期
obj.setCreateTime(new Date());
//设置当前版本
obj.setVersion(versionmax+1);obj.setState(1);
//将之前版本状态清0,再插入新的数据
dao().update(ProgrammeHead.class, Chain.make("state", 0), Cnd.where("courseId","=",obj.getCourseId()));return dao().insert(obj);
}
//删除最新版本,遍历获得剩余版本数的最大值,设置其状态值为1
public int deleteVersion(ProgrammeHead obj) {
Cnd c = Cnd.where("courseId","=",obj.getCourseId()).and("version", "=", obj.getVersion());
ProgrammeHead programmeHead2 = dao().fetch(ProgrammeHead.class,c);
if (programmeHead2.getState() == 0) {
dao().clear(ProgrammeDetail.class, c);
dao().clear(ProgrammeHead.class, c);
return 1;
}else{
dao().clear(ProgrammeDetail.class, c);
dao().clear(ProgrammeHead.class, c);
List<ProgrammeHead> programmeHead = dao().query(ProgrammeHead.class,Cnd.where("courseId","=",obj.getCourseId()));
Integer versionmax = programmeHead.get(0).getVersion();
for (int i = 0; i < programmeHead.size(); i++) {
if (versionmax < (Integer)programmeHead.get(i).getVersion()) versionmax = (Integer)programmeHead.get(i).getVersion();
}
dao().update(ProgrammeHead.class, Chain.make("state", 1), Cnd.where("courseId","=",obj.getCourseId()).and("version","=",versionmax));
return versionmax;
}
}