/******************************************************************************
|
* Copyright (C) 2015 Shenzhen Penguin Network Technology Co., Ltd
|
* All Rights Reserved.
|
* ±¾Èí¼þΪÉîÛÚÊÐÆó¶ìÍøÂç¿Æ¼¼ÓÐÏÞ¹«Ë¾¿ª·¢ÑÐÖÆ¡£Î´¾±¾¹«Ë¾ÕýʽÊéÃæͬÒ⣬ÆäËûÈκθöÈË¡¢ÍÅÌå
|
* ²»µÃʹÓᢸ´ÖÆ¡¢Ð޸Ļò·¢²¼±¾Èí¼þ.
|
*****************************************************************************/
|
|
package com.qxueyou.scc.base.service.impl;
|
|
import java.io.Serializable;
|
import java.util.Collection;
|
import java.util.List;
|
import java.util.Map;
|
|
import javax.persistence.EntityManager;
|
import javax.persistence.PersistenceContext;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.beans.factory.annotation.Qualifier;
|
import org.springframework.stereotype.Service;
|
|
import com.querydsl.jpa.impl.JPAQueryFactory;
|
import com.qxueyou.scc.base.dao.CommonDAO;
|
import com.qxueyou.scc.base.model.ITrace;
|
import com.qxueyou.scc.base.model.Pager;
|
import com.qxueyou.scc.base.model.Result;
|
import com.qxueyou.scc.base.service.ICommonService;
|
import com.qxueyou.scc.base.util.TraceUtils;
|
import com.qxueyou.scc.sys.model.SysDictionary;
|
|
@Service(value = "commonAppService")
|
/**
|
* @author Ïĵ»¢
|
* @since JDK1.7
|
* @history 2014-11-18 Ïĵ»¢ н¨
|
*/
|
public class CommonAppService implements ICommonService {
|
/**
|
* »ñÈ¡ÊÂÎñ¹ÜÀíÆ÷
|
*/
|
@PersistenceContext
|
public EntityManager em;
|
|
/**
|
* »ñÈ¡querydsl ²éѯ¹¤³§
|
*/
|
public JPAQueryFactory queryFactory;
|
|
private CommonDAO commonDAO;
|
|
|
public CommonDAO getCommonDAO(){
|
return commonDAO;
|
}
|
|
public JPAQueryFactory getQueryFactory() {
|
return new JPAQueryFactory(em);
|
}
|
|
|
/**
|
* ɾ³ýʵÌå
|
* @param trace
|
*/
|
public void deleteTrace(ITrace trace) {
|
trace.setDeleteFlag(true);
|
TraceUtils.setUpdateTrace(trace);
|
save(trace);
|
}
|
|
/**
|
* ɾ³ýʵÌ弯ºÏ
|
* @param traces
|
*/
|
public <T extends ITrace> void deleteTraces(List<T> traces) {
|
for (ITrace trace : traces) {
|
deleteTrace(trace);
|
}
|
}
|
|
/**
|
* ÒÀÀµ×¢Èë
|
*
|
* @param commonDAO
|
*/
|
@Autowired(required = false)
|
public void setCommonDAO(@Qualifier("commonDao")
|
CommonDAO commonDAO) {
|
this.commonDAO = commonDAO;
|
}
|
|
/**
|
* ¶ÁÈ¡¶ÔÏó
|
* @param <T> ·ºÐÍ
|
* @param clz ʵÌåÀàÐÍ
|
* @param pk ʵÌåÖ÷¼ü
|
* @return ²éѯ½á¹û
|
*/
|
public <T> T read(Class<T> clz,Serializable pk){
|
return this.commonDAO.read(clz, pk);
|
}
|
|
|
/**
|
* ±£´æ¶ÔÏó
|
* @return ²éѯ½á¹û
|
*/
|
public Result save(Object obj){
|
this.commonDAO.saveOrUpdate(obj);
|
return new Result(true);
|
|
}
|
|
/**
|
* ˢжÔÏó ÊÖ¶¯Ìá½»
|
* @return ²éѯ½á¹û
|
*/
|
public void flush(){
|
getCommonDAO().getHibernateTemplate().flush();
|
}
|
|
/**
|
* Çå³ý»º´æ
|
*/
|
public void clearCache(){
|
getCommonDAO().getHibernateTemplate().clear();
|
}
|
|
/**
|
* Çå³ýµ¥¸ö»º´æ
|
*/
|
public void evict(Object obj){
|
getCommonDAO().getHibernateTemplate().evict(obj);
|
}
|
|
/**
|
* ±£´æ¶ÔÏó
|
* @return ²éѯ½á¹û
|
*/
|
public Result insert(Object obj){
|
this.commonDAO.save(obj);
|
return new Result(true);
|
|
}
|
|
/**
|
* ±£´æ¶ÔÏó
|
* @return ²éѯ½á¹û
|
*/
|
@SuppressWarnings("rawtypes")
|
public Result saveOrUpdateAll(Collection collection){
|
commonDAO.saveOrUpdateAll(collection);
|
return new Result(true);
|
|
}
|
|
/**
|
* ¸ù¾Ýhql²éѯ,²¢·µ»ØÖ´ÐÐÀàÐ͵ÄÁбí½á¹û
|
* @param hql ²éѯÓï¾ä
|
* @param args ²ÎÊý
|
* @param cls ·µ»ØÀàÐÍ
|
* @return
|
*/
|
public <T> List<T> find(String hql,List<Object> args,Class<T> cls){
|
return this.commonDAO.find(hql, args, cls);
|
}
|
|
/**
|
* ¸ù¾Ýhql²éѯ,²¢·µ»ØÖ´ÐÐÀàÐ͵ÄÁбí½á¹û
|
*
|
* @param hql ²éѯÓï¾ä
|
* @param cls ·µ»ØÀàÐÍ
|
* @return
|
*/
|
public int findCount(String hql, List<Object> args) {
|
return this.commonDAO.findCount(hql, args);
|
}
|
|
|
/**
|
* ±£´æ»ò¸üжÔÏó
|
*/
|
public void deleteAll(@SuppressWarnings("rawtypes") Collection col) {
|
this.commonDAO.deleteAll(col);
|
}
|
|
/**
|
* ¸ù¾Ýhql²éѯ,²¢·µ»ØÖ´ÐÐÀàÐ͵ÄΨһ½á¹û
|
* @param hql ²éѯÓï¾ä
|
* @param args ²ÎÊý
|
* @param cls ·µ»ØÀàÐÍ
|
* @return
|
*/
|
public <T> T findUnique(String hql,List<Object> args,Class<T> cls){
|
return this.commonDAO.findUnique(hql, args, cls);
|
}
|
|
/**
|
* ʹÓÃsql²éѯ½á¹û
|
* @param sql
|
* @param args
|
* @return
|
*/
|
@SuppressWarnings("rawtypes")
|
public List findBySql(final String sql,final List<Object> args){
|
return this.commonDAO.findBySql(sql, args);
|
}
|
|
/**
|
* ʹÓÃsql²éѯ½á¹û
|
* @param sql
|
* @param args
|
* @return
|
*/
|
@SuppressWarnings("rawtypes")
|
public List findByPageSql(final String sql,final List<Object> args, final Pager pager){
|
return this.commonDAO.findByPageSql(sql, args, pager);
|
}
|
|
/**
|
* ʹÓÃsql²éѯ½á¹û
|
* @param sql
|
* @param args
|
* @return
|
*/
|
public int findCountBySql(final String sql,final List<Object> args){
|
return this.commonDAO.findCountBySql(sql, args);
|
}
|
|
public Result bulkUpdate(String hql, Object args[]) {
|
return this.commonDAO.bulkUpdate(hql, args);
|
}
|
|
public Result executeProduce(String sql, Object args[]) {
|
return this.commonDAO.executeProduce(sql, args);
|
}
|
|
public int executeDelete(String sql, Object args[]) {
|
return this.commonDAO.executeSqlDelete(sql, args);
|
}
|
|
/**
|
* hqlÖ»º¬µ¥Ò»²ÎÊý
|
*
|
* @param hql ²éѯÓï¾ä
|
* @param args ²ÎÊýÊý×é
|
* @param cls ·µ»ØÀàÐÍ
|
* @return
|
*/
|
public Result bulkUpdateInLoop(String hql, Object args[]) {
|
return this.commonDAO.bulkUpdateInLoop(hql, args);
|
}
|
|
/**
|
* ¸´ÔÓhql
|
* @param sql
|
* @param map
|
* @param cls
|
* @return
|
*/
|
public <T> List<T> findByComplexHql(final String hql, final Map<String, Object> map, Class<T> cls){
|
return this.commonDAO.findByComplexHql(hql, map, cls);
|
}
|
|
/**
|
* ¸´ÔÓhql
|
* @param sql
|
* @param map
|
* @param cls
|
* @return
|
*/
|
public <T> T findUniqueByHql(final String hql, final Map<String, Object> map){
|
return commonDAO.findUniqueByHql(hql, map);
|
}
|
|
/**
|
* ¸´ÔÓhql
|
* @param sql
|
* @param map
|
* @param cls
|
* @return
|
*/
|
public <T> List<T> findByComplexHql(final String hql, final Pager page, final Map<String, Object> map, Class<T> cls){
|
return this.commonDAO.findByComplexHql(hql, page, map, cls);
|
}
|
|
/**
|
* ·µ»Ø¸öÊý ¸´ÔÓhql
|
*
|
* @param hql ²éѯÓï¾ä
|
* @param cls ·µ»ØÀàÐÍ
|
* @return
|
*/
|
public int findCountByComplexHql(final String hql, final Map<String, Object> map) {
|
return this.commonDAO.findCountByComplexHql(hql, map);
|
}
|
|
/**
|
* ·µ»Ø¸öÊý ¸´ÔÓsql
|
*
|
* @param hql ²éѯÓï¾ä
|
* @param cls ·µ»ØÀàÐÍ
|
* @return
|
*/
|
public int findCountByComplexSql(final String hql, final Map<String, Object> map) {
|
return this.commonDAO.findCountByComplexSql(hql, map);
|
}
|
|
/**
|
* ¸´ÔÓsql
|
* @param sql
|
* @param map
|
* @param cls
|
* @return
|
*/
|
public <T> List<T> findByComplexSql(final String sql, final Map<String, Object> map, Class<T> cls){
|
return this.commonDAO.findByComplexSql(sql, map, cls);
|
}
|
|
/**
|
* ¸´ÔÓhql
|
* @param sql
|
* @param map
|
* @param cls
|
* @return
|
*/
|
public <T> List<T> findByComplexSql(final String sql, final Pager page, final Map<String, Object> map, Class<T> cls){
|
return this.commonDAO.findByComplexSql(sql, page, map, cls);
|
}
|
|
/**
|
* ¸ù¾Ýhql²éѯ,²¢·µ»ØÖ´ÐÐÀàÐ͵ÄÁбí½á¹û£¬ÁбíÊý¾ÝΪMap
|
* @param hql
|
* @param map
|
* @return
|
*/
|
public List<Map<String,Object>> findListWithMapByHql(final String hql, final Map<String, Object> map){
|
return this.commonDAO.findListWithMapByHql(hql, map);
|
}
|
|
/**
|
* ¸ù¾Ýhql²éѯ,²¢·µ»ØÖ´ÐÐÀàÐ͵ÄÁбí½á¹û£¬ÁбíÊý¾ÝΪMap
|
* @param hql
|
* @param args
|
* @return
|
*/
|
public List<Map<String,Object>> findListWithMapByHql(final String hql, final Map<String, Object> args,final Pager page){
|
return this.commonDAO.findListWithMapByHql(hql, args,page);
|
}
|
|
/**
|
* ·ÖÒ³²éѯ
|
* @param hql
|
* @param page
|
* @param args
|
* @param cls
|
* @return
|
*/
|
public <T> List<T> findList(final String hql, final Pager page, final List<Object> args,Class<T> cls){
|
return this.commonDAO.findList(hql, page, args, cls);
|
}
|
|
/**
|
* ²éѯ
|
* @param hql
|
* @param args
|
* @return
|
*/
|
public List<Object[]> findwithRawResult(String hql, List<Object> args) {
|
return this.commonDAO.findwithRawResult(hql, args);
|
}
|
|
|
/**
|
* ¸ù¾ÝÅäÖÃkey²éѯvalueÖµ
|
* @param key
|
* @return
|
*/
|
public String queryConfigValue(String key){
|
return this.commonDAO.queryConfigValue(key);
|
}
|
|
/**
|
* ¸ù¾Ý×ÖµäÀàÐͲéѯ×ÖµäÄÚÈݵÄlist
|
* @param dicType
|
* @return
|
*/
|
public List<SysDictionary> queryDictConfigMap(String dicType){
|
return this.commonDAO.queryDictConfigMap(dicType);
|
}
|
}
|
