📄 department.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="../adovbs.inc" -->
<!--#include file ="../Connections/auto.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../css/MainBorder.css" rel="stylesheet" type="text/css">
<title>信息显示</title>
<style type="text/css">
<!--
.STYLE5 {color: #FFFFFF}
-->
</style>
<style type="text/css">
<!--
td { font-family: "宋体"; font-size: 9pt}
body { font-family: "宋体"; font-size: 9pt}
select { font-family: "宋体"; font-size: 9pt}
A {text-decoration: none; color: #336699; font-family: "宋体"; font-size: 9pt}
A:hover {text-decoration: underline; color: #FF0000; font-family: "宋体"; font-size: 9pt}
-->
</style>
</head>
<style type="text/css">
<!--
#f1 {
position: relative;
top: 10px;
left: 430px;
width: 80px;
}
#f2 {
position: relative;
top: -31px;
left: 510px;
width: 80px;
}
-->
</style>
<style type="text/css">
<!--
table {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
color: #000000;
font-style: normal;
text-align: center;
}
#title {
font-size: 24px;
}
#di{
text-align:right;
font-family:Arial, Helvetica, sans-serif;
font-size:12px
}
.tddown {
border-top-style: solid;
border-right-style: solid;
border-bottom-style: solid;
border-left-style: solid;
border-top-color: #666666;
border-right-color: #FFFFFF;
border-bottom-color: #FFFFFF;
border-left-color: #666666;
margin: 0px;
padding: 0px;
border-top-width: 1px;
border-right-width: 1px;
border-bottom-width: 1px;
border-left-width: 1px;
}
.style2 {font-family: "华文中宋", "宋体"; }
.STYLE7 {color: #0000FF}
-->
</style>
<script language="vbscript">
sub OK()
change.tfield.value=""
change.tfield.focus()
end sub
</script>
<script language="vbscript">
sub del_onclick()
yes =window.confirm("是否要删除该部门？")
if yes = true then
form2.submit()
end if
end sub
</script>
<body >
<table width="200" border="0">
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<%
set RS = server.CreateObject("ADODB.Recordset")
Sname="select * from part"
RS.open Sname , CN,1,3
if RS.eof then
response.write("还没有部门信息！")
else
%>
<table width="584" height="133" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#D4D0C8">
<tr>
<td height="27" colspan="3" ><div class="style2 STYLE3 STYLE1" id="title" >
<div align="center" class="STYLE7"> 部门管理 </div>
</div></td>
<td height="27" ><span class="STYLE7">
<input name="Submit222" type="button" class="s04" onClick="JavaScript:window.open('manage.htm','','width=450,height=230,top=150,left=350')" value="添加部门">
</span></td>
</tr>
<tr class="but">
<td width="149" height="35" align="right" class="but01" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but'">部门中文名称</td>
<td width="145" align="left " class="but01" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but'">部门英文名称</td>
<td width="147" align="left " class="but01" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but01'">执行操作</td>
<td width="143" align="left " class="but01" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but01'">执行操作</td>
</tr>
<%
RS.movefirst
RS.pagesize=5
page=CLng(Request("page"))
if page<1 then page=1
RS.absolutepage=page
for i=1 to RS.pagesize
if not RS.eof then
%>
<tr bgcolor="#FFFFF4">
<td height="31" align="right" class="but1" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but1'"><% response.write(RS("cpart"))%>
</td>
<td class="but1" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but1'">
<% response.write(RS("epart"))%></td>
<td class="but1" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but1'" ><input name="Submit22" type="button" class="s04" onClick="JavaScript:window.open('Partchange.asp?cpart=<%=RS("cpart") %>','','width=450,height=230,top=150,left=350')" value="修改信息"></td>
<td class="but1" onMouseDown="this.className='tddown'" onMouseUp="this.className='but'" onMouseOut="this.className='but1'"><input name="Submit2" type="button" class="s04" onClick="JavaScript:window.open('delpart.asp?cpart=<%=RS("cpart") %>','','width=200,height=180,top=150,left=350')" value="删除信息"> </td></tr>
<%
end if
if not RS.eof then
RS.movenext
else
exit for
end if
next
'RS.close
%>
<tr >
<th height="27" colspan="4">
<div id="di"> <span class="STYLE5">
<% if page<>1 then %>
当前<%=page%>页<a href=<%=path%>?page=1 >第一页</a>
<a href=<%=path%>?page=<%=(page-1)%>>上一页</a></span>
<span class="STYLE5">
<%end if
if page<>RS.pagecount then %>
当前<%=page1%>页</span> <span class="STYLE5"><a href=<%=path%>?page=<%=(page+1)%> >下一页</a>
<a href=<%=path%>?page=<%=RS.pagecount%> >最后一页</a></span>
<%end if %>
</div></th>
</tr>
</table>
<% end if %>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -