📄 employee_manage.asp
字号:
<!--#include file="../INC/Conn.asp"-->
<!--#include file="inc/Check.asp"-->
<!--#include file="inc/public.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>亿博尔</title>
</head>
<link href="Images/Admin.css" rel="stylesheet" type="text/css">
<body>
<table width="98%" height="40" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#D8D8D8">
<tr>
<td height="30" align="left" bgcolor="ffffff"><table width="100%" height="100%" border="0" cellpadding="3" cellspacing="0">
<tr bgcolor="eeeeee">
<td width="5%" align="center"><img src="Images/1.gif" width="13" height="12"></td>
<td width="78%"><span class="style2">管理中心 >>> 用户管理 </span></td>
<td width="17%" align="right">
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table width="98%" height="90%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#D8D8D8">
<tr>
<td valign="top" bgcolor="ffffff"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" bgcolor="ffffff">
<table width=100% border=0 align='center' cellpadding=3 cellspacing=1 bordercolordark=#ffffff bgcolor="eaeaea">
<tr align="left" bgcolor="ffffff" background="Images/box_bg.gif">
<td width="20%" height="20" background="Images/box_bg.gif">用户编号</td>
<td width="20%" background="Images/box_bg.gif">部门/职位</td>
<td width="20%" background="Images/box_bg.gif">状态</td>
<td width="20%" height="20" background="Images/box_bg.gif">管理地区</td>
<td width="20%" height="20" background="Images/box_bg.gif">操作</td>
</tr>
<%
Page = Request.QueryString("page")
IF page = "" or Not isNumeric(Page) Then
Page = 1
End IF
sql="select * from Employee"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
if not(rs.bof and rs.eof) then
'==============================page
rs.PageSize =15
%>
<!--#include file="../inc/page.asp"-->
<tr align="left" bgcolor="ffffff" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor='#F5F5F5'">
<td height="24"><%=rs("Employee_ID")%></td>
<td height="24">
<%
Employee_Flag = Rs("Employee_Flag")
Flags = ""
Employee_Flag_Name = ""
Flag_1 = 0
Flag_Str = len(Employee_Flag)/2
if Flag_Str > 0 Then
for i = 1 to Flag_Str
Set Rs_F = Conn.Execute("Select * From Flag Where Flag = '"& left(Employee_Flag,Flag_1+2) &"'")
If Not(Rs_F.eof and Rs_F.BOF) Then
Employee_Flag_Name = Employee_Flag_Name & Rs_F("Title") &" "
End IF
Rs_F.Close
Set Rs_F = Nothing
Flag_1 = Flag_1 + 2
Flags = Employee_Flag_Name
next
End iF
Response.Write Flags
%>
</td>
<td height="24"><%=Rs("Employee_State")%></td>
<td>
<%
Employee_Purview = Rs("Employee_Purview")
IF Employee_Purview <> "" Then
Citys = ""
Employee_Purview_Name = ""
Employee_Purview_1=split(Employee_Purview, ",")
for i = 0 to ubound(Employee_Purview_1)
Employee_Purview_2=Employee_Purview_1(i)
Set Rs_C = Conn.Execute("Select * From City Where NumberID = '"& Employee_Purview_2 &"'")
If Not(Rs_C.eof and Rs_C.BOF) Then
Employee_Purview_Name = Employee_Purview_Name & Rs_C("City") &""
End IF
Rs_C.Close
Set Rs_C = Nothing
Citys = Employee_Purview_Name
next
Response.Write Citys
Else
Response.Write "全部"
End IF
%>
</td>
<td height="24"><a href="Employee_info.asp?ID=<%=rs("Employee_ID")%>">修改</a>|<a href="Employee_info.asp?Makking=Del&ID=<%=rs("Employee_ID")%>" onClick="return confirm('删除用户后将不可恢复，您确定要这样操作吗？')">删除</a></td>
</tr>
<%
rs.movenext
next
end if
%>
</table></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="50%" height="24" align="left" valign="bottom" background="Images/box_bg_1.gif"><a href="Employee_info.asp"><img src="Images/add.gif" alt="添加菜单" width="36" height="21" border="0"></a>
</td>
<td width="50%" height="24" align="right" valign="top" background="Images/box_bg_1.gif">
<%Page_links=""
call PageControl(iCount,maxpage,page)
rs.close
set rs=nothing
Conn.Close
Set Conn = Nothing
%></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="1" bgcolor="#E2E1E1"></td>
</tr>
</table>
</td>
</tr>
</table>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="6"></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -