📄 orgmanagerimpl.java
字号:
package com.bjsxt.oa.manager.impl;
import java.util.List;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.bjsxt.oa.PagerModel;
import com.bjsxt.oa.manager.OrgManager;
import com.bjsxt.oa.manager.SystemException;
import com.bjsxt.oa.model.Orgnization;
public class OrgManagerImpl extends HibernateDaoSupport implements OrgManager {
public void addOrg(Orgnization org, int parentId) {
if(parentId != 0){
org.setParent(
(Orgnization)getHibernateTemplate()
.load(Orgnization.class, parentId)
);
}
getHibernateTemplate().save(org);
org.setSn(
org.getParent() == null ?
(""+org.getId()) :
(org.getParent().getSn()+"_"+org.getId())
);
getHibernateTemplate().update(org);
}
public void delOrg(int orgId) {
Orgnization org = (Orgnization)getHibernateTemplate().load(Orgnization.class, orgId);
//先判断是否存在子机构,如果存在子机构,则不允许删除
if(org.getChildren().size() > 0){
throw new SystemException("存在子机构,不允许删除","exception.org.del",org.getId());
}
getHibernateTemplate().delete(
org
);
}
public Orgnization findOrg(int orgId) {
return (Orgnization)getHibernateTemplate().load(Orgnization.class, orgId);
}
public PagerModel findOrgs(int parentId,int offset,int pagesize) {
String selectCountHql = "select count(*) from Orgnization o where o.parent is null";
if(parentId != 0){
selectCountHql = "select count(*) from Orgnization o where o.parent.id = "+parentId;
}
//获得总记录数
int total = ((Long)getSession().createQuery(selectCountHql).uniqueResult()).intValue();
String selectHql = "select o from Orgnization o where o.parent is null";
if(parentId != 0){
selectHql = "select o from Orgnization o where o.parent.id = "+parentId;
}
//取得当前页的数据
List datas = getSession().createQuery(selectHql)
.setFirstResult(offset)
.setMaxResults(pagesize)
.list();
PagerModel pm = new PagerModel();
pm.setTotal(total);
pm.setDatas(datas);
return pm;
// //如果parentId=0,则查找顶级机构列表
// if(parentId == 0){
// return getHibernateTemplate().find("from Orgnization o where o.parent is null");
// }
// return getHibernateTemplate().find("from Orgnization o where o.parent.id = ?", parentId);
}
public void updateOrg(Orgnization org, int parentId) {
if(parentId != 0){
org.setParent(
(Orgnization)getHibernateTemplate()
.load(Orgnization.class, parentId)
);
}
getHibernateTemplate().update(org);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -