📄 branch.asp
字号:
<!--#include file="../config.asp"-->
<!--#include file="../inc/check_login.asp"-->
<!--#include file="../inc/functions.asp"-->
<%
Application_ID = 6000300 '本功能编号，含义请查看编码表
if not CheckAuth(Session("Employee_ID"),Application_ID) then '验证权限
Server.Transfer "../err/un_authorized.htm"
response.end
end if
%>
<!--**************身份验证部分****************-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK rel="stylesheet" type="text/css" href="../style.css">
</head>
<body>
◆<a href="branch_new.asp" target="foot">增加分公司</a>
<hr size=1>
<table bgcolor="#FFFFFF" border=0 cellpadding=1 cellspacing=1 width="100%">
<%
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
conn.open connstr
sql = "select * from Employee_Branch order by Branch_ID"
set rs = conn.execute(sql)
i = 0
while not rs.eof
Branch_ID = rs("Branch_ID")
Branch_Name = rs("Branch_Name")
if i mod 2 = 0 then
bgcolor = "#FFFFFF"
else
bgcolor = "#EFEFEF"
end if
%>
<tr bgcolor="#EFEFEF">
<td valign="top" colspan=2>●<%= Branch_Name %></td>
<td valign="top" align="right"><a href="department_new.asp?Branch_ID=<%= Branch_ID %>" target="foot">增加新部门</a> / <a href="branch_del.asp?Branch_ID=<%= Branch_ID %>" target="foot">删除该分公司</a></td>
</tr>
<%
sql = "select * from Employee_Department where Branch_ID = " & Branch_ID
set rs_department = conn.execute(sql)
while not rs_department.eof
Department_ID = rs_department("Department_ID")
Department_Name = rs_department("Department_Name")
if trim(Department_Name) <> "" then
%>
<tr>
<td width="10"> </td>
<td>◇ <%= Department_Name %></td>
<td align="right"><a href="department_del.asp?Department_ID=<%= Department_ID %>" target="foot">删除该部门</a></td>
</tr>
<%
end if
rs_department.movenext
wend
rs_department.close
i = i + 1
rs.movenext
wend
rs.close
set rs = nothing
set rs_department = nothing
conn.close
set conn = nothing
%>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -