/******************************************************************************
 * Copyright (C) 2015 Shenzhen Penguin Network Technology Co., Ltd
 * All Rights Reserved.
 * ±¾Èí¼þΪÉîÛÚÊÐÆó¶ìÍøÂç¿Æ¼¼ÓÐÏÞ¹«Ë¾¿ª·¢ÑÐÖÆ¡£Î´¾­±¾¹«Ë¾ÕýʽÊéÃæͬÒ⣬ÆäËûÈκθöÈË¡¢ÍÅÌå
 * ²»µÃʹÓᢸ´ÖÆ¡¢Ð޸Ļò·¢²¼±¾Èí¼þ.
 *****************************************************************************/

package com.qxueyou.scc.user.dao;

import java.text.ParseException;
import java.util.List;

import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.transform.Transformers;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.hibernate4.support.HibernateDaoSupport;
import org.springframework.stereotype.Repository;

import com.qxueyou.scc.user.model.ExportUserRegistration;
import com.qxueyou.scc.user.model.UserRegistration;


@Repository(value="registrationDAO")
/**
 * ×Ô¶¯×¢ÈësessionFactory ±¨ÃûÐÅÏ¢
 *
 * @author ody.yuan
 * @since JDK1.6
 * @history 2015-04-23
 */
public class RegistrationDAO extends HibernateDaoSupport {
	
	/**
     * ×¢ÈësessionFactory
     *
     * @param sessionFactory
     */
    @Autowired(required = false)
    public void setSessionfactory(SessionFactory sessionFactory) {
        this.setSessionFactory(sessionFactory);
    }
    
    /**
	 * ²éѯ±¨ÃûÐÅÏ¢
	 * @param sql
	 * @param args
	 * @return
     * @throws ParseException 
	 */
    @SuppressWarnings("unchecked")
	public List<UserRegistration> queryRegistrationList(String sql,List<Object> args) {
    	// ²éѯ½á¹û
    	Session session = this.getSessionFactory().getCurrentSession();
    	SQLQuery query = session.createSQLQuery(sql);
    	query.setResultTransformer(Transformers.aliasToBean(UserRegistration.class));
    	for(int i = 0;args !=null && i < args.size() ;  i++ ){
    		query.setParameter(i, args.get(i));
    	}
    	List<UserRegistration> lstItems = query.list();
    	
		return lstItems;
	}
    
    /**
	 * µ¼³ö±¨ÃûÐÅÏ¢
	 * @param sql
	 * @param args
	 * @return
     * @throws ParseException 
	 */
    @SuppressWarnings("unchecked")
	public List<ExportUserRegistration> queryExportRegList(String sql,List<Object> args) {
    	// ²éѯ½á¹û
    	Session session = this.getSessionFactory().getCurrentSession();
    	SQLQuery query = session.createSQLQuery(sql);
    	query.setResultTransformer(Transformers.aliasToBean(ExportUserRegistration.class));
    	for(int i = 0;args !=null && i < args.size() ;  i++ ){
    		query.setParameter(i, args.get(i));
    	}
    	List<ExportUserRegistration> lstItems = query.list();
    	
		return lstItems;
	}
    
}