nutz框架的添加和删除

//插入版本,查出数据库最新版本，创建新版本，在此基础上加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;

}


}