package com.vci.server.portal.service;
|
|
import java.math.BigDecimal;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
import org.hibernate.SQLQuery;
|
import org.hibernate.Session;
|
|
import com.vci.server.base.persistence.dao.BaseService;
|
import com.vci.server.base.persistence.dao.HibernateSessionFactory;
|
import com.vci.server.portal.dao.impl.PLTabPageEntityDaoImpl;
|
import com.vci.server.portal.entity.PLTabPageEntity;
|
|
public class PLTabPageEntityService extends BaseService{
|
|
private static PLTabPageEntityService instance = null;
|
|
private PLTabPageEntityService(){
|
|
}
|
|
public static PLTabPageEntityService getInstance(){
|
if(instance == null){
|
instance = new PLTabPageEntityService();
|
}
|
return instance;
|
}
|
/**
|
* 新增对象
|
* @param obj
|
* @throws Throwable
|
*/
|
public boolean savePLTabPageEntity(PLTabPageEntity obj) throws Throwable {
|
try {
|
PLTabPageEntityDaoImpl daoImpl = new PLTabPageEntityDaoImpl();
|
daoImpl.saveOrUpdate(obj);
|
return true;
|
}catch(Throwable e){
|
throw e;
|
}
|
}
|
|
/**
|
* 批量保持页签
|
* @param plTabPages
|
* @return
|
* @throws Throwable
|
*/
|
public boolean batchSavePLTabPageEntity(PLTabPageEntity[] objs) throws Throwable {
|
try {
|
PLTabPageEntityDaoImpl daoImpl = new PLTabPageEntityDaoImpl();
|
List<PLTabPageEntity> list = new ArrayList<PLTabPageEntity>();
|
int batchNum = 200;
|
for (int i = 0; i < objs.length; i++) {
|
list.add(objs[i]);
|
if ((i + 1) % batchNum == 0) {
|
daoImpl.saveOrUpdateAll(list);
|
list = new ArrayList<PLTabPageEntity>();
|
}
|
}
|
daoImpl.saveOrUpdateAll(list);
|
return true;
|
}catch(Throwable e){
|
throw e;
|
}
|
}
|
|
/**
|
* 更新对象
|
* @param obj
|
* @return
|
* @throws Throwable
|
*/
|
public boolean updatePLTabPageEntity(PLTabPageEntity obj) throws Throwable{
|
try {
|
PLTabPageEntityDaoImpl daoImpl = new PLTabPageEntityDaoImpl();
|
PLTabPageEntity objGet = daoImpl.getById(obj.getId());
|
if (objGet == null) {
|
daoImpl.saveOrUpdate(obj);
|
} else {
|
// objGet.setId(obj.getId());
|
objGet.setPlCode(obj.getPlCode());
|
objGet.setPlName(obj.getPlName());
|
objGet.setPlIsOpen(obj.getPlIsOpen());
|
objGet.setPlLabel(obj.getPlLabel());
|
objGet.setPlDesc(obj.getPlDesc());
|
objGet.setPlSeq(obj.getPlSeq());
|
objGet.setPlContextOId(obj.getPlContextOId());
|
// objGet.setPlCreateTime(obj.getPlCreateTime());
|
objGet.setPlCreateUser(obj.getPlCreateUser());
|
objGet.setPlModifyTime(obj.getPlModifyTime());
|
objGet.setPlModifyUser(obj.getPlModifyUser());
|
objGet.setPlLicensOrs(obj.getPlLicensOrs());
|
objGet.setPlOpenExpression(obj.getPlOpenExpression());
|
objGet.setPlUIParser(obj.getPlUIParser());
|
objGet.setPlExtAttr(obj.getPlExtAttr());
|
daoImpl.saveOrUpdate(objGet);
|
}
|
return true;
|
}catch(Throwable e){
|
throw e;
|
}
|
|
}
|
|
/**
|
* 删除对象
|
* @param obj
|
* @return
|
* @throws Throwable
|
*/
|
public boolean deletePLTabPageEntity(PLTabPageEntity obj) throws Throwable{
|
try {
|
PLTabPageEntityDaoImpl daoImpl = new PLTabPageEntityDaoImpl();
|
daoImpl.delete(obj);
|
return true;
|
}catch(Throwable e){
|
throw e;
|
}
|
}
|
|
/**
|
* 根据Id删除指定的对象
|
* @param id
|
* @return
|
* @throws Throwable
|
*/
|
public boolean deletePLTabPageEntityById(String id) throws Throwable{
|
try {
|
PLTabPageEntityDaoImpl daoImpl = new PLTabPageEntityDaoImpl();
|
PLTabPageEntity obj = daoImpl.getById(id);
|
if (obj != null) {
|
daoImpl.delete(obj);
|
}
|
return true;
|
}catch(Throwable e){
|
throw e;
|
}
|
}
|
|
/**
|
* 根据ID获取指定的PLTabPage
|
* @param plOId
|
* @return
|
* @throws Throwable
|
*/
|
public PLTabPageEntity getPLTabPageEntityById(String plOId) throws Throwable {
|
try {
|
PLTabPageEntityDaoImpl daoImpl = new PLTabPageEntityDaoImpl();
|
return daoImpl.getById(plOId);
|
}catch(Throwable e){
|
throw e;
|
}
|
}
|
|
/**
|
* 根据plPageDefinationOId获取PLPageLayoutDefinationArray
|
* @param plPageDefinationOId
|
* @return
|
* @throws Throwable
|
*/
|
public List<PLTabPageEntity> getPLTabPageEntitysByPageDefinationOId(
|
String plPageDefinationOId) throws Throwable {
|
try {
|
PLTabPageEntityDaoImpl daoImpl = new PLTabPageEntityDaoImpl();
|
List<PLTabPageEntity> list = daoImpl.findEntities("from PLTabPageEntity where plPageDefinationOId = '" + plPageDefinationOId + "'");
|
return list;
|
}catch(Throwable e){
|
throw e;
|
}
|
|
}
|
|
/**
|
* 根据type,pageLayoutName获取指定的PLTabPage
|
* @param type
|
* @param code
|
* @return
|
* @throws Throwable
|
*/
|
public List<PLTabPageEntity> getPLTabPageEntitysByTypeANDCode(
|
String type, String code) throws Throwable {
|
try {
|
Session session = HibernateSessionFactory.getSession();
|
SQLQuery sql = session.createSQLQuery("select * from PLTABPAGE t join PLUILAYOUT p on t.plPageDefinationOId " +
|
"= p.plOId where p.plRelatedType = ? and p.plCode = ?");
|
sql.setString(0, type);
|
sql.setString(1, code);
|
List list = sql.list();
|
List<PLTabPageEntity> entityList = new ArrayList<PLTabPageEntity>();
|
for(int i = 0; i < list.size(); i++){
|
PLTabPageEntity entity = new PLTabPageEntity();
|
Object[] objs = (Object[]) list.get(i);
|
entity.setPlOId((String)objs[0]);
|
entity.setPlCode((String)objs[1]);
|
entity.setPlName((String)objs[2]);
|
entity.setPlIsOpen(((BigDecimal)objs[3]).shortValue());
|
entity.setPlLabel((String)objs[4]);
|
entity.setPlDesc((String)objs[5]);
|
entity.setPlSeq(((BigDecimal)objs[6]).shortValue());
|
entity.setPlContextOId((String)objs[7]);
|
entity.setPlCreateTime((Date)objs[8]);
|
entity.setPlCreateUser((String)objs[9]);
|
entity.setPlModifyTime((Date)objs[10]);
|
entity.setPlModifyUser((String)objs[11]);
|
entity.setPlLicensOrs((String)objs[12]);
|
entity.setPlOpenExpression((String)objs[13]);
|
|
entityList.add(entity);
|
}
|
return entityList;
|
}catch(Throwable e){
|
throw e;
|
}
|
|
}
|
|
/**
|
* 根据上下文ID和区域的类型，按顺序获取当前tab页
|
* @param contextId
|
* @param type
|
* @return
|
* @throws Throwable
|
*/
|
public List<PLTabPageEntity> getTabPageByContextIdAndType(String contextId, int type) throws Throwable {
|
try {
|
PLTabPageEntityDaoImpl daoImpl = new PLTabPageEntityDaoImpl();
|
List<PLTabPageEntity> list = daoImpl.findEntities("from PLTabPageEntity where plPageDefinationOId = '" + contextId + "' and areaType = " + type + " order by plSeq");
|
return list;
|
}catch(Throwable e){
|
throw e;
|
}
|
}
|
|
/**
|
* 获取全量结果集，缓存使用
|
* @auther liu,20150727
|
* @return
|
* @throws Throwable
|
*/
|
public List<PLTabPageEntity> getAllTabPages() throws Throwable {
|
try {
|
PLTabPageEntityDaoImpl daoImpl = new PLTabPageEntityDaoImpl();
|
List<PLTabPageEntity> list = daoImpl.findEntities("from PLTabPageEntity order by plSeq");
|
return list;
|
}catch(Throwable e){
|
throw e;
|
}
|
}
|
}
|
