hibernatecolumndao.java

OBPM是一个开源

package cn.myapps.core.dynaform.view.dao;

import cn.myapps.base.action.ParamsTable;
import cn.myapps.base.dao.DataPackage;
import cn.myapps.base.dao.HibernateBaseDAO;
import cn.myapps.core.dynaform.view.ejb.Column;

public class HibernateColumnDAO extends HibernateBaseDAO implements ColumnDAO {
	public HibernateColumnDAO(String voClassName) {
		super(voClassName);
	}

	public DataPackage findByViewid(String id, String application)
			throws Exception {
		String hql = "from " + _voClazzName + " column where column.view.id='"
				+ id + "'" +" and vo.applicationid = '" + application + "' "+ "order by column.orderno";
		return super.getDatapackage(hql);
	}

	public Column getPreviousColumn(String viewid, int oderno, String application)
			throws Exception {
		String hql = "FROM " + _voClazzName + " vo where vo.view.id='" + viewid
				+ "'" + "and vo.orderno in (select max(column.orderno) "
				+ "from " + _voClazzName + " column where column.view.id='"
				+ viewid + "'" +" and vo.applicationid = '" + application + "' "+ " and column.orderno <" + oderno + ")";

		return (Column) getData(hql);

	}

	public Column getNextColumn(String viewid, int oderno, String application)
			throws Exception {
		String hql = "FROM " + _voClazzName + " vo where vo.view.id='" + viewid
				+ "'" + " and vo.orderno in (select min(column.orderno) "
				+ "from " + _voClazzName + " column where column.view.id='"
				+ viewid + "'" +" and vo.applicationid = '" + application + "' "+ " and column.orderno >" + oderno + ")";

		return (Column) getData(hql);

	}

	public Column getColumnByMaxOderNO(String viewid, String application)
			throws Exception {
		String hql = "FROM " + _voClazzName + " vo where vo.view.id='" + viewid
				+ "'" + " and vo.orderno in (select max(column.orderno) "
				+ "from " + _voClazzName + " column where column.view.id='"
				+ viewid + "'" + ") "+" and vo.applicationid = '" + application + "'";
		return (Column) getData(hql);
	}

}