accountviewservice.java

来自「模拟简单的会计信息录入管理应用」· Java 代码 · 共 94 行

package org.operamasks.example.ejb.gl.service;

import java.util.ArrayList;
import java.util.List;

import javax.ejb.Stateless;
import javax.ejb.TransactionAttribute;
import javax.ejb.TransactionAttributeType;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;

import org.operamasks.example.ejb.gl.entity.AccountView;

/** 
 * @generated
 */
@Stateless
@SuppressWarnings("unchecked")
public class AccountViewService implements IAccountViewService {
	/** 
	 * @generated default persist manager
	 */
	@PersistenceContext
	private EntityManager _innerDao;

	/** 
	 * @generated default persist method
	 */
	@TransactionAttribute(value = TransactionAttributeType.REQUIRED)
	public void createAccountView(AccountView vo) {
		_innerDao.persist(vo);
	}

	/** 
	 * @generated default persist method
	 */
	@TransactionAttribute(value = TransactionAttributeType.REQUIRED)
	public void modifyAccountView(AccountView vo) {
		_innerDao.merge(vo);
	}

	/** 
	 * @generated default remove method
	 */
	@TransactionAttribute(value = TransactionAttributeType.REQUIRED)
	public void removeAccountView(AccountView vo) {
		AccountView managed = _innerDao.merge(vo);
		_innerDao.remove(managed);
	}

	/** 
	 * @generated default query method
	 */
	@TransactionAttribute(value = TransactionAttributeType.REQUIRED)
	public List<AccountView> listAccountView() {
		Query q = _innerDao.createQuery("SELECT o FROM AccountView o ");
		return q.getResultList();
	}

	/** 
	 * @generated default persist method
	 */
	@TransactionAttribute(value = TransactionAttributeType.REQUIRED)
	public AccountView getAccountView(String pk) {
		Query q = _innerDao
				.createQuery("SELECT o FROM AccountView o WHERE o.id = '" + pk
						+ "'");
		List<AccountView> result = q.getResultList();
		if (result.size() == 1)
			return result.get(0);
		return null;
	}

	public List<Object[]> getAccountBalanceEntries(int pageSize, int firstResultIndex) {
		Query q = _innerDao.createQuery("SELECT accountView.number, accountView.name, voucherEntry.isCheck, period.periodYear,voucher.localDebitAmout, voucher.localCreditAmount, period.periodYear from AccountView accountView, VoucherEntry voucherEntry, Voucher voucher, Period period WHERE accountView = voucherEntry.accountView AND voucherEntry.voucher = voucher AND voucher.period = period");
		q.setMaxResults(pageSize);
		q.setFirstResult(firstResultIndex);
		List queryResult = q.getResultList();
		List<Object[]> result = new ArrayList<Object[]>();
		for(Object o: queryResult){
			if(o instanceof Object[]){
				result.add((Object[])o);
			}
		}
		return result;
	}
	
	public int getAccountBalanceEntriesCount(){
		Query q = _innerDao.createQuery("select count(accountView.number) from AccountView accountView, VoucherEntry voucherEntry, Voucher voucher, Period period WHERE accountView = voucherEntry.accountView AND voucherEntry.voucher = voucher AND voucher.period = period");
		return ((Long)q.getSingleResult()).intValue();
	}
}