📄 unit.jsp
字号:
<%@ page contentType="text/html;charset=GBK" language="java" %>
<%@ page import="java.sql.*,java.util.*,java.io.*,javax.xml.transform.*,org.dom4j.*,org.dom4j.io.*,javax.xml.transform.stream.StreamSource" %>
<%@ include file="conn.jsp"%>
<%
String departid=(String)request.getParameter("depart_id");
if(departid==null)
departid="";
String unitid=(String)request.getParameter("unit_id");
if(unitid==null)
unitid="";
String expand =(String)request.getParameter("expand");
if(expand==null)
expand="false";
Document document = DocumentHelper.createDocument();
document = document.addProcessingInstruction("xml-stylesheet","type=\"text/xsl\"");
document.setXMLEncoding("GBK");
Element root = document.addElement("root"); //填充部门
String unitSql = "select t.org_id,t.org_name from txl_org t where t.org_level = '1'";
ResultSet rs = null;
rs = st.executeQuery(unitSql);
int p=0; //计算在哪一页显示
int r=0; //计数变量
int s=0; //计数变量
while(rs.next()){
Element element = root.addElement("unit");
String unit = rs.getString("org_name");
String unit_id = rs.getString("org_id");
element.addAttribute("name", unit);
element.addAttribute("unit_id", unit_id);
if(!unitid.equals("") && expand.equals("true") && unitid.equals(unit_id)) {
p=p+r;
element.addAttribute("expand", "false");
}
else if (!unitid.equals("") && expand.equals("false") && unitid.equals(unit_id)){
p=p+r;
element.addAttribute("expand", "true");
}
else
element.addAttribute("expand", "false");
r++;
}
for(int i=0;i<15;i++){ //空白填充
Element element = root.addElement("unit");
element.addAttribute("name", "");
element.addAttribute("unit_id", "");
}
if(expand.equals("false") ||(!unitid.equals("") && expand.equals("true") && !departid.equals(""))){ //填充判断
List list = null; //填充处室
list = document.selectNodes("//unit");
for(int i=0;i<list.size();i++){
Element node = (Element) list.get(i);
String unit_id = node.attributeValue("unit_id");
if(unit_id.equals(unitid)){
String departSql = "select * from txl_org t where t.org_level = '2' and t.upper_org_id = '" + unit_id +"'";
//ResultSet
rs = st.executeQuery(departSql);
while(rs.next()){
Element element = node.addElement("depart");
String depart = rs.getString("org_name");
String depart_id = rs.getString("org_id");
element.addAttribute("name",depart );
element.addAttribute("depart_id",depart_id);
element.addAttribute("parent", element.getParent().attributeValue("unit_id"));
if(!unitid.equals("") && expand.equals("true") && departid.equals(depart_id)){
element.addAttribute("expand", "false");
p=p+s;
}
else if (!unitid.equals("") && expand.equals("false") && departid.equals(depart_id)){
element.addAttribute("expand", "true");
p=p+s;
}
else
element.addAttribute("expand", "false");
s++;
}
}
}
}
p=p/20; //计算显示在哪页
// System.out.println(p);
TransformerFactory factory = TransformerFactory.newInstance();
Transformer transformer = factory.newTransformer(new StreamSource(new File("unit.xsl")));
DocumentSource source = new DocumentSource(document);
DocumentResult result = new DocumentResult();
transformer.transform(source, result);
Document transformedDoc = result.getDocument();
//out.println(document.asXML());
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<LINK href="style.css" type="text/css" rel="stylesheet">
<script defer="defer" language="javascript" type="text/javascript">
<!--
var _offset = 0;
var page = 0;
function _$id(_obj) {
return document.getElementById(_obj);
}
function _$Pages(_i) {
_$id("Content").scrollTop = (_$id("Content").clientHeight*_i);
page = _i;
// alert(page);
}
function pgup(){ //上翻页
if(!page==0){
page--;
}
_$id("Content").scrollTop = (_$id("Content").clientHeight*page);
}
function pgdn(){ //下翻页
_offset = _$id("Content").clientHeight;
//alert(1==Math.floor(_$id("Content").scrollHeight/_offset));
if(!(page==Math.floor(_$id("Content").scrollHeight/_offset)-1)){
page++;
}
_$id("Content").scrollTop = (_$id("Content").clientHeight*page);
//alert(page);
}
function _$InitPages() {
/* var _s='';
_offset = _$id("Content").clientHeight;
var _top = _$id("Content").scrollTop;
for (var i=0;i<(_$id("Content").scrollHeight/_offset);i++) {
_s+=('<a href="javascript:void(0);" onclick="javascript:_$Pages('+i+');" onfocus="this.blur()" title="Page '+(i+1)+'">'+(i+1)+'</a> ');
}
_$id("Pages").innerHTML=_s;*/
_$Pages(<%=p%>); //定位页数
}
function del()
{
var i,n=0;
for(i=0;i<document.forms[0].unit.length;i++)
{
if(document.forms[0].unit[i].checked)
n++;
}
if(n==0){
alert("请选择您要删除的处室！");
return false;
}
if (confirm("此操作将删除您选中的处室及其所属全部人员，是否继续？"))
document.forms[0].submit();
else
return false;
}
//-->
</script>
</HEAD>
<BODY onload="_$InitPages();">
<!--BODY-->
<form action="delunit.jsp" method="post" target="_blank">
<table border="0" width = "100%">
<tr bgcolor = "#ffe3bb">
<td style="height=20;BORDER-bottom:#FF9900 1px solid" colspan="9">
<font id="User">集团公司人员通讯录>部门信息</font>
</td>
</tr>
<tr>
<td style="height=20;BORDER-bottom:#FF9900 1px solid" colspan="9">
<table>
<tr>
<td align="center"></td>
<td width="35" align="center"><a href="createunit.jsp" onClick="" target="_blank"><font size="2">新建</font></a>|</td>
<td width="47" align="center"><a href="#" onClick="pgup();"><font size="2">上一页</font></a>|</td>
<td width="47" align="center"><a href="#" onClick="pgdn();"><font size="2">下一页</font></a>|</td>
<td width="38" align="center"><a href="unit.jsp?unit_id=1&expand=false" target="_self"><font size="2">展开</font></a>|</td>
<td width="38" align="center"><a href="unit.jsp" target="_self"><font size="2">折叠</font></a>|</td>
<td width="70"> </td>
<td width="45" align="center"><a onClick="del();" href="#"><font size="2">|删除|</font></a></td>
<td width="60" align="center"><a onClick="" href="departexpand.jsp?unit_id=1&expand=false"><font size="2">处室信息</font></a></td>
<td width="70" align="center"><a onClick="" href="index.jsp"><font size="2">人员通讯录</font></a></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="9"><br/>
<!--填充-->
<div id="Content">
<%
out.println(transformedDoc.asXML());
%>
</div>
<!--div id="Pages"></div-->
<!--填充-->
</td>
</tr>
<tr>
<td style="height=20;BORDER-top:#FF9900 1px solid" colspan="9">
<table><tr>
<td align="center">⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -