package com.vci.server.portal.service;
|
|
import java.math.BigDecimal;
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
import org.hibernate.SQLQuery;
|
import org.hibernate.Session;
|
|
import com.vci.corba.portal.data.PLTabButton;
|
import com.vci.server.base.persistence.dao.BaseService;
|
import com.vci.server.base.persistence.dao.HibernateSessionFactory;
|
import com.vci.server.portal.dao.impl.PLTabButtonEntityDaoImpl;
|
import com.vci.server.portal.entity.PLTabButtonEntity;
|
import com.vci.server.portal.entity.PLTabPageEntity;
|
|
public class PLTabButtonEntityService extends BaseService{
|
private static PLTabButtonEntityService instance = null;
|
|
private PLTabButtonEntityService(){
|
|
}
|
|
public static PLTabButtonEntityService getInstance(){
|
if(instance == null){
|
instance = new PLTabButtonEntityService();
|
}
|
return instance;
|
}
|
|
/**
|
* 新增对象
|
* XXX 这可是单例模式加锁
|
* @param obj
|
* @throws Throwable
|
*/
|
public synchronized boolean savePLTabButtonEntity(PLTabButtonEntity obj) throws Throwable {
|
try {
|
PLTabButtonEntityDaoImpl daoImpl = new PLTabButtonEntityDaoImpl();
|
//校验页签下编号是否存在
|
String sqloid = "select * from pltabbutton t where t.pltableoid = '"
|
+ obj.getPlTableOId() + "' and t.plseq >= " + obj.getPlSeq();
|
|
List<PLTabButtonEntity> loadAll = daoImpl.findEntites(sqloid,
|
new Object[0], "", PLTabButtonEntity.class);
|
/*if(loadAll != null && !loadAll.isEmpty()) {
|
return false;
|
}*/
|
if(loadAll != null && !loadAll.isEmpty()){
|
for (PLTabButtonEntity plTabButtonEntity : loadAll) {
|
int oldSeq=plTabButtonEntity.getPlSeq();
|
plTabButtonEntity.setPlSeq((short)(plTabButtonEntity.getPlSeq()+1));
|
daoImpl.update(plTabButtonEntity);
|
updateButtonAccess(obj.getPlTableOId(),oldSeq,oldSeq+1);
|
}
|
}
|
//..
|
PLTabButtonEntity btn = daoImpl.getById(obj.getPlOId());
|
if (btn == null) {
|
daoImpl.saveOrUpdate(obj);
|
} else {
|
btn.setPlTableOId(obj.getPlTableOId());
|
btn.setPlPageOId(obj.getPlPageOId());
|
btn.setPlActionOId(obj.getPlActionOId());
|
btn.setPlLabel(obj.getPlLabel());
|
btn.setPlDesc(obj.getPlDesc());
|
btn.setPlSeq(obj.getPlSeq());
|
btn.setPlAreaType(obj.getPlAreaType());
|
btn.setPlCreateUser(obj.getPlCreateUser());
|
btn.setPlModifyTime(obj.getPlModifyTime());
|
btn.setPlModifyUser(obj.getPlModifyUser());
|
btn.setPlLicensOrs(obj.getPlLicensOrs());
|
btn.setPlParentOid(obj.getPlParentOid());
|
btn.setDisplayMode(obj.getDisplayMode());
|
btn.setIconPath(obj.getIconPath());
|
btn.setAuthorization(obj.getAuthorization());
|
|
daoImpl.saveOrUpdate(btn);
|
}
|
return true;
|
}catch(Throwable e){
|
throw e;
|
}
|
}
|
|
/**
|
* 序号改后,更改按钮权限值,按钮权限是按序号按位授权的
|
* @param pltableoid
|
* @param oldSeq
|
* @param newSeq
|
*/
|
private void updateButtonAccess(String pltableoid, int oldSeq, int newSeq){
|
Session session = HibernateSessionFactory.getSession();
|
PLTabButtonEntityDaoImpl daoImpl = new PLTabButtonEntityDaoImpl();
|
String sql="select ploid,plrightvalue from plroleright where plfuncoid='"+pltableoid+"'";
|
SQLQuery query = session.createSQLQuery(sql);
|
List<?> list= query.list();
|
if(list.size()>0){
|
for(int i=0;i<list.size();i++){
|
Object[] row = (Object[]) list.get(i);
|
String ploid=(String) row[0];
|
BigDecimal value=(BigDecimal) row[1];
|
long rightValue = value.longValue();
|
rightValue = rightValue - (long)Math.pow(2, oldSeq) + (long)Math.pow(2, newSeq);
|
|
String sql2 = "update plroleright set plrightvalue="+ rightValue +" where ploid = '" + ploid + "'";
|
daoImpl.createSQLQuery(sql2);
|
}
|
|
}
|
}
|
public synchronized boolean bacthSavePLTabButtonEntity(PLTabButtonEntity[] objs) throws Throwable {
|
try {
|
PLTabButtonEntityDaoImpl daoImpl = new PLTabButtonEntityDaoImpl();
|
List<PLTabButtonEntity> list = new ArrayList<PLTabButtonEntity>();
|
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<PLTabButtonEntity>();
|
}
|
}
|
daoImpl.saveOrUpdateAll(list);
|
return true;
|
}catch(Throwable e){
|
throw e;
|
}
|
}
|
|
/**
|
* 更新对象
|
* XXX 这可是单例模式加锁
|
* @param obj
|
* @return
|
* @throws Throwable
|
*/
|
public synchronized boolean updatePLTabButtonEntity(PLTabButtonEntity obj) throws Throwable{
|
try {
|
//System.out.println("=====updatePLTabButtonEntity:" + obj.getPlLabel() + ";SEQ=" + obj.getPlSeq());
|
|
PLTabButtonEntityDaoImpl daoImpl = new PLTabButtonEntityDaoImpl();
|
String sql = "select * from pltabbutton t where t.pltableoid = '"
|
+ obj.getPlTableOId() + "' and t.plseq = " + obj.getPlSeq()
|
+ " and t.ploid != '" + obj.getPlOId() + "'";
|
|
//System.out.println("sql = " + sql);
|
|
String sqloid = "select * from pltabbutton t where t.pltableoid = '"
|
+ obj.getPlTableOId() + "' and t.plseq >= " + obj.getPlSeq()
|
+ " and t.ploid != '" + obj.getPlOId() + "'";
|
//System.out.println("sqloid = " + sqloid);
|
|
/*Session session = HibernateSessionFactory.getSession();
|
SQLQuery query = session.createSQLQuery(sql);
|
query.executeUpdate();
|
@SuppressWarnings("rawtypes")
|
List queryList = query.list();
|
if (queryList != null && queryList.size() > 1) {
|
return false;
|
}*/
|
|
Session session = HibernateSessionFactory.getSession();
|
|
String oldsql="select plseq from pltabbutton where ploid='"+obj.getPlOId()+"'";
|
SQLQuery query = session.createSQLQuery(oldsql);
|
List<?> list= query.list();
|
if(list.size()>0){
|
BigDecimal value = (BigDecimal) list.get(0);
|
|
this.updateButtonAccess(obj.getPlTableOId(), value.intValue(), obj.getPlSeq());
|
}
|
|
List<PLTabButtonEntity> loadAll = daoImpl.findEntites(sqloid,
|
new Object[0], "", PLTabButtonEntity.class);
|
/*if(loadAll != null && !loadAll.isEmpty()) {
|
return false;
|
}*/
|
daoImpl.update(obj);
|
if(loadAll != null && !loadAll.isEmpty()){
|
for (PLTabButtonEntity plTabButtonEntity : loadAll) {
|
String sqlsec = "select * from pltabbutton t where t.pltableoid = '"
|
+ plTabButtonEntity.getPlTableOId() + "' and t.plseq = " + plTabButtonEntity.getPlSeq()
|
+ " and t.ploid != '" + plTabButtonEntity.getPlOId() + "'";
|
|
//System.out.println("sqlsec = " + sqlsec);
|
|
List<PLTabButtonEntity> loadAlls = daoImpl.findEntites(sqlsec,
|
new Object[0], "", PLTabButtonEntity.class);
|
if(loadAlls.size()!=0){
|
int oldSeq=plTabButtonEntity.getPlSeq();
|
plTabButtonEntity.setPlSeq((short)(plTabButtonEntity.getPlSeq()+1));
|
daoImpl.update(plTabButtonEntity);
|
this.updateButtonAccess(plTabButtonEntity.getPlTableOId(), oldSeq, oldSeq+1);
|
}
|
}
|
}
|
/*PLTabButtonEntity objGet = daoImpl.getById(obj.getId());
|
if (objGet == null) {
|
daoImpl.saveOrUpdate(obj);
|
} else {
|
objGet.setPlTableOId(obj.getPlTableOId());
|
objGet.setPlPageOId(obj.getPlPageOId());
|
objGet.setPlActionOId(obj.getPlActionOId());
|
objGet.setPlLabel(obj.getPlLabel());
|
objGet.setPlDesc(obj.getPlDesc());
|
objGet.setPlSeq(obj.getPlSeq());
|
objGet.setPlAreaType(obj.getPlAreaType());
|
objGet.setPlCreateUser(obj.getPlCreateUser());
|
objGet.setPlModifyTime(obj.getPlModifyTime());
|
objGet.setPlModifyUser(obj.getPlModifyUser());
|
objGet.setPlLicensOrs(obj.getPlLicensOrs());
|
objGet.setPlParentOid(obj.getPlParentOid());
|
objGet.setDisplayMode(obj.getDisplayMode());
|
objGet.setIconPath(obj.getIconPath());
|
objGet.setAuthorization(obj.getAuthorization());
|
daoImpl.saveOrUpdate(objGet);
|
}*/
|
|
return true;
|
}catch(Throwable e){
|
throw e;
|
}
|
|
}
|
|
/**
|
* 删除对象
|
* XXX 这可是单例模式加锁
|
* @param obj
|
* @return
|
* @throws Throwable
|
*/
|
public synchronized boolean deletePLTabButtonEntity(PLTabButtonEntity obj) throws Throwable{
|
try {
|
PLTabButtonEntityDaoImpl daoImpl = new PLTabButtonEntityDaoImpl();
|
|
//删除按钮参数
|
String sql = "select * from pltabbutton t where t.plparentoid = '" +obj.getPlOId()+"'";
|
List<PLTabButtonEntity> loadAll = daoImpl.findEntites(sql,
|
new Object[0], "", PLTabButtonEntity.class);
|
if(loadAll != null && !loadAll.isEmpty()) {
|
return false;
|
}
|
String sql2 = "delete from plcommandparameter t where t.plcommandoid = '" + obj.getPlOId() + "'";
|
daoImpl.createSQLQuery(sql2);
|
daoImpl.delete(obj);
|
return true;
|
}catch(Throwable e){
|
throw e;
|
}
|
|
}
|
|
/**
|
* 根据Id删除指定的对象
|
* @param id
|
* @return
|
* @throws Throwable
|
*/
|
public boolean deletePLTabButtonEntityById(String id) throws Throwable{
|
try {
|
PLTabButtonEntityDaoImpl daoImpl = new PLTabButtonEntityDaoImpl();
|
PLTabButtonEntity obj = daoImpl.getById(id);
|
if (obj != null) {
|
// 删除按钮参数
|
String sql = "delete from plcommandparameter t where t.plcommandoid = '" + obj.getPlOId() + "'";
|
daoImpl.createSQLQuery(sql);
|
daoImpl.flush();
|
// 删除按钮定义
|
daoImpl.delete(obj);
|
}
|
return true;
|
}catch(Throwable e){
|
throw e;
|
}
|
|
}
|
|
/**
|
* 根据ID获取指定的PLTabButton
|
* @param plOId
|
* @return
|
* @throws Throwable
|
*/
|
public PLTabButtonEntity getPLTabButtonEntityById(String plOId) throws Throwable {
|
try {
|
PLTabButtonEntityDaoImpl daoImpl = new PLTabButtonEntityDaoImpl();
|
return daoImpl.getById(plOId);
|
}catch(Throwable e){
|
throw e;
|
}
|
|
}
|
|
/**
|
* 根据plTableOId获取PLTabButtonArray
|
* @param plTableOId
|
* @return
|
* @throws Throwable
|
*/
|
public List<PLTabButtonEntity> getPLTabButtonEntitysByTableOId(
|
String plTableOId) throws Throwable {
|
try {
|
PLTabButtonEntityDaoImpl daoImpl = new PLTabButtonEntityDaoImpl();
|
List<PLTabButtonEntity> list = daoImpl.findEntities("from PLTabButtonEntity where plTableOId = '" + plTableOId + "' order by plSeq");
|
Map<String, PLTabButtonEntity> mapBtn = new HashMap<String, PLTabButtonEntity>();
|
for (PLTabButtonEntity btn : list) {
|
mapBtn.put(btn.getPlOId(), btn);
|
}
|
|
List<PLTabButtonEntity> listNew = new ArrayList<PLTabButtonEntity>();
|
for (PLTabButtonEntity btn : list) {
|
if (btn.getPlParentOid() == null|| btn.getPlParentOid().equals("")) {
|
listNew.add(btn);
|
} else if (mapBtn.containsKey(btn.getPlParentOid())) {
|
listNew.add(btn);
|
} else {
|
daoImpl.delete(btn);
|
//System.out.println("删除:" + btn);
|
}
|
}
|
return listNew;
|
}catch(Throwable e){
|
throw e;
|
}
|
}
|
|
/**
|
* 根据plTableOId获取PLTabButtonArray
|
* @param plTableOId
|
* @return
|
* @throws Throwable
|
*/
|
public List<PLTabButtonEntity> getPLTabButtonEntitysByActionOId(
|
String plActionOid) throws Throwable {
|
try {
|
PLTabButtonEntityDaoImpl daoImpl = new PLTabButtonEntityDaoImpl();
|
List<PLTabButtonEntity> list = daoImpl.findEntities("from PLTabButtonEntity where plActionOId = '" + plActionOid + "' order by plSeq");
|
return list;
|
}catch(Throwable e){
|
throw e;
|
}
|
|
}
|
|
|
/**
|
* 根据type和formName判断表单是否能被修改
|
* @param type
|
* @param name
|
* @return
|
*/
|
public boolean judgeUpdateButton(int type, String name, String typeName){
|
boolean flag = false;
|
Session session = HibernateSessionFactory.getSession();
|
String judgeType = "";
|
if(type==0){
|
judgeType = "showType";
|
}else if(type==1){
|
judgeType = "linkType";
|
}
|
StringBuffer sql = new StringBuffer("select t.ploid from plpagedefination t where")
|
.append(" dbms_lob.instr(t.pldefination,'<templateId>")
|
.append(name)
|
.append("</templateId>',1,1 )>0 ")
|
.append("and dbms_lob.instr(t.pldefination,'<").append(judgeType)
|
.append(">")
|
.append(typeName)
|
.append("</")
|
.append(judgeType)
|
.append(">',1,1 )>0 ");
|
|
SQLQuery query = session.createSQLQuery(sql.toString());
|
List<?> list= query.list();
|
if(list!=null&&list.size()>0){
|
flag=true;
|
}
|
return flag;
|
}
|
|
/**
|
* 根据id判断表格是否能被删除
|
* @param type
|
* @param name
|
* @return
|
*/
|
public boolean judgeDeleteButton(String id, String typeName){
|
boolean flag = false;
|
Session session = HibernateSessionFactory.getSession();
|
StringBuffer sql = new StringBuffer("select t.id from plportalvi t where 1=1 ")
|
.append("and dbms_lob.instr(t.prm,'<JD_inObj>")
|
.append(id)
|
.append("</JD_inObj>',1,1 )>0 ")
|
.append("and t.typename = '")
|
.append(typeName)
|
.append("' ");
|
|
SQLQuery query = session.createSQLQuery(sql.toString());
|
List<?> list= query.list();
|
if(list!=null&&list.size()>0){
|
flag=true;
|
}
|
return flag;
|
}
|
|
/**
|
* 获取全量结果集，缓存使用
|
* @auther lmh20150728
|
* @return
|
* @throws Throwable
|
*/
|
public List<PLTabButtonEntity> getAllPLTabButtonEntitys() throws Throwable {
|
try {
|
PLTabButtonEntityDaoImpl daoImpl = new PLTabButtonEntityDaoImpl();
|
List<PLTabButtonEntity> list = daoImpl.findEntities("from PLTabButtonEntity order by plSeq");
|
return list;
|
}catch(Throwable e){
|
throw e;
|
}
|
|
}
|
}
|
